#!/bin/ksh
#  ************************************************************************
#  *
#  *   Module      : MKSSUPP
#  *   Date        : 11 Mar 2011 
#  *   Author      : Monika Bhakuni
#  *
#  *   Description : Executes the package  Mks_Cust_Supplier_Data_Pkg and then FTPs the resulting file.
#  *
#  *   CCD         : 2010-01-2087 
#  *
#  *   Change History
#  *   --------------
#  *   Date         Author                 Ver  Description
#  *   -----------  ---------------------  ---  -------------------------
#  *   11 Mar 2011   Monika Bhakuni           1.0  Initial Creation
#  *
#  ************************************************************************
#
#
echo " "
echo " "
echo " "
echo "***** Start of Program  - MKS On Time Delivery Data Process *****"
echo " "
APPS_USERID_PASSWD=$1;export APPS_USERID_PASSWD
APPS_USER_ID="$2";export APPS_USER_ID
APPS_USER_NAME="$3";export APPS_USER_NAME
APPS_REQUEST_ID="$4";export APPS_REQUEST_ID

Pathnameout="$5";export Pathnameout
Filenameout="$6";export Filenameout
EmailRecepient="$7";export EmailRecepient
   
Remoteserver="${15}";export Remoteserver
Remoteuser="${16}";export Remoteuser
Remotepassword="${17}";export Remotepassword
echo " "
echo "  "
echo "*** Parameters ***  "
echo "Pathnameout: "$Pathnameout
echo "Filenameout: "$Filenameout
echo "EmailRecepient: "$EmailRecepient


echo "Remoteserver: "$Remoteserver
echo "Remoteuser: "$Remoteuser
echo "Remotepassword: "$Remotepassword
# -------------------------------------------------------------------------
# Define Variables
# -------------------------------------------------------------------------
HistPath=$MKS_CUSTOM/interfaces/history; export HistPath;
LogPath=$MKS_CUSTOM/interfaces/log; export LogPath;
SQLPath=$MKS_CUSTOM/sql
FileandPathout=$Pathnameout'/'$filename; export FileandPath
Filename=$filenameout''.txt'; export Filename

#####################################################################################################################
log_file=/tmp/${FCP_REQID}_ftp_log

DateNow=`date +%m/%d/%Y`; export DateNow
echo " "
echo " Todays Date is: " $DateNow
echo " "
echo 'Creating File ' $FileandPathout
sqlplus -s $FCP_LOGIN <<EOF1
execute Mks_Cust_Supplier_Data_Pkg.GET_Cust_Supplier_DATA ('$Pathnameout', '$Filename', '$EmailRecepient');
EOF1

   if test $? -eq 0
   then
      echo " "
      echo  "Successfully Processed MKS Supplier Data: " $FileandPathout
      echo " "
   else
      echo " "
      echo "*** ERROR MKS Supplier Data Not Created ***"
      echo " "
   fi

echo " "
echo "*** Begin FTP OUT Process ***"
echo " "
echo "Sending File: "$FileandPathout
cd  $Pathnameout
ftp -vn <<END1
prompt off
open $Remoteserver
user $Remoteuser $Remotepassword
put $Filename
END1
if test $? -eq 0
then
    echo " "
    echo "*** MKS Supplier Data Sent Successfully ***"
    echo " "
else
    echo " "
    echo "*** ERROR MKS On Time Delivery Data Not Received ***"
    echo " "
    exit1
fi
echo " "  
echo "***** Remove Output File from Output Directory *****"
sleep 15
rm -f $Filename

echo " "
echo "***** End of Program *****"
echo " "
echo " "
echo " "
exit 0