978: ,p_trans_code => l_trans_code
979: );
980: /* check for BETFOR00 */
981:
982: fnd_file.put_line (fnd_file.LOG,'');
983: fnd_file.put_line (fnd_file.LOG,'');
984: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
985: fnd_file.put_line (fnd_file.LOG,'====================================================');
986: fnd_file.put_line (fnd_file.LOG,'');
979: );
980: /* check for BETFOR00 */
981:
982: fnd_file.put_line (fnd_file.LOG,'');
983: fnd_file.put_line (fnd_file.LOG,'');
984: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
985: fnd_file.put_line (fnd_file.LOG,'====================================================');
986: fnd_file.put_line (fnd_file.LOG,'');
987:
980: /* check for BETFOR00 */
981:
982: fnd_file.put_line (fnd_file.LOG,'');
983: fnd_file.put_line (fnd_file.LOG,'');
984: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
985: fnd_file.put_line (fnd_file.LOG,'====================================================');
986: fnd_file.put_line (fnd_file.LOG,'');
987:
988: IF l_trans_code <> 'BETFOR00' THEN
981:
982: fnd_file.put_line (fnd_file.LOG,'');
983: fnd_file.put_line (fnd_file.LOG,'');
984: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
985: fnd_file.put_line (fnd_file.LOG,'====================================================');
986: fnd_file.put_line (fnd_file.LOG,'');
987:
988: IF l_trans_code <> 'BETFOR00' THEN
989:
982: fnd_file.put_line (fnd_file.LOG,'');
983: fnd_file.put_line (fnd_file.LOG,'');
984: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
985: fnd_file.put_line (fnd_file.LOG,'====================================================');
986: fnd_file.put_line (fnd_file.LOG,'');
987:
988: IF l_trans_code <> 'BETFOR00' THEN
989:
990: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV00'));
986: fnd_file.put_line (fnd_file.LOG,'');
987:
988: IF l_trans_code <> 'BETFOR00' THEN
989:
990: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV00'));
991: RAISE BETFOR00_NOT_FOUND;
992: ELSE
993: /* get batch details */
994: l_ah_trans_date := SUBSTR(l_record_read,10,4);
996: l_enterprise_no := SUBSTR(l_record_read,49,11);
997: l_division := SUBSTR(l_record_read,60,11);
998: l_production_date := SUBSTR(l_record_read,81,4);
999:
1000: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1001: fnd_file.put_line (fnd_file.LOG,'');
1002: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
997: l_division := SUBSTR(l_record_read,60,11);
998: l_production_date := SUBSTR(l_record_read,81,4);
999:
1000: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1001: fnd_file.put_line (fnd_file.LOG,'');
1002: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
998: l_production_date := SUBSTR(l_record_read,81,4);
999:
1000: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1001: fnd_file.put_line (fnd_file.LOG,'');
1002: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
999:
1000: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1001: fnd_file.put_line (fnd_file.LOG,'');
1002: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1000: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1001: fnd_file.put_line (fnd_file.LOG,'');
1002: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1001: fnd_file.put_line (fnd_file.LOG,'');
1002: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1009: fnd_file.put_line (fnd_file.LOG,'');
1002: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1009: fnd_file.put_line (fnd_file.LOG,'');
1010: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1003: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1009: fnd_file.put_line (fnd_file.LOG,'');
1010: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1011: fnd_file.put_line (fnd_file.LOG,'');
1004: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1009: fnd_file.put_line (fnd_file.LOG,'');
1010: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1011: fnd_file.put_line (fnd_file.LOG,'');
1012: END IF;
1005: fnd_file.put_line (fnd_file.LOG,'');
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1009: fnd_file.put_line (fnd_file.LOG,'');
1010: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1011: fnd_file.put_line (fnd_file.LOG,'');
1012: END IF;
1013: UTL_FILE.fclose (l_file_type);
1006: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1009: fnd_file.put_line (fnd_file.LOG,'');
1010: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1011: fnd_file.put_line (fnd_file.LOG,'');
1012: END IF;
1013: UTL_FILE.fclose (l_file_type);
1014: EXCEPTION
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1009: fnd_file.put_line (fnd_file.LOG,'');
1010: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1011: fnd_file.put_line (fnd_file.LOG,'');
1012: END IF;
1013: UTL_FILE.fclose (l_file_type);
1014: EXCEPTION
1015: WHEN BETFOR00_NOT_FOUND
1013: UTL_FILE.fclose (l_file_type);
1014: EXCEPTION
1015: WHEN BETFOR00_NOT_FOUND
1016: THEN
1017: fnd_file.put_line (fnd_file.LOG,'');
1018: fnd_file.put_line (fnd_file.LOG,'');
1019: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1020: fnd_file.put_line (fnd_file.LOG,'=========================================');
1021: fnd_file.put_line (fnd_file.LOG,'');
1014: EXCEPTION
1015: WHEN BETFOR00_NOT_FOUND
1016: THEN
1017: fnd_file.put_line (fnd_file.LOG,'');
1018: fnd_file.put_line (fnd_file.LOG,'');
1019: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1020: fnd_file.put_line (fnd_file.LOG,'=========================================');
1021: fnd_file.put_line (fnd_file.LOG,'');
1022: fnd_file.put_line (fnd_file.LOG,'');
1015: WHEN BETFOR00_NOT_FOUND
1016: THEN
1017: fnd_file.put_line (fnd_file.LOG,'');
1018: fnd_file.put_line (fnd_file.LOG,'');
1019: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1020: fnd_file.put_line (fnd_file.LOG,'=========================================');
1021: fnd_file.put_line (fnd_file.LOG,'');
1022: fnd_file.put_line (fnd_file.LOG,'');
1023:
1016: THEN
1017: fnd_file.put_line (fnd_file.LOG,'');
1018: fnd_file.put_line (fnd_file.LOG,'');
1019: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1020: fnd_file.put_line (fnd_file.LOG,'=========================================');
1021: fnd_file.put_line (fnd_file.LOG,'');
1022: fnd_file.put_line (fnd_file.LOG,'');
1023:
1024:
1017: fnd_file.put_line (fnd_file.LOG,'');
1018: fnd_file.put_line (fnd_file.LOG,'');
1019: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1020: fnd_file.put_line (fnd_file.LOG,'=========================================');
1021: fnd_file.put_line (fnd_file.LOG,'');
1022: fnd_file.put_line (fnd_file.LOG,'');
1023:
1024:
1025: END;
1018: fnd_file.put_line (fnd_file.LOG,'');
1019: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1020: fnd_file.put_line (fnd_file.LOG,'=========================================');
1021: fnd_file.put_line (fnd_file.LOG,'');
1022: fnd_file.put_line (fnd_file.LOG,'');
1023:
1024:
1025: END;
1026:
1063: || lpad(' ',31 ,'=')
1064: || lpad(' ',17 ,'=')
1065: || lpad(' ',15 ,'=');
1066:
1067: fnd_file.put_line (fnd_file.LOG,'');
1068: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1069: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1070: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1071: fnd_file.put_line (fnd_file.LOG,'');
1064: || lpad(' ',17 ,'=')
1065: || lpad(' ',15 ,'=');
1066:
1067: fnd_file.put_line (fnd_file.LOG,'');
1068: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1069: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1070: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1071: fnd_file.put_line (fnd_file.LOG,'');
1072:
1065: || lpad(' ',15 ,'=');
1066:
1067: fnd_file.put_line (fnd_file.LOG,'');
1068: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1069: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1070: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1071: fnd_file.put_line (fnd_file.LOG,'');
1072:
1073: <
1066:
1067: fnd_file.put_line (fnd_file.LOG,'');
1068: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1069: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1070: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1071: fnd_file.put_line (fnd_file.LOG,'');
1072:
1073: <
1074: LOOP
1067: fnd_file.put_line (fnd_file.LOG,'');
1068: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1069: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1070: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1071: fnd_file.put_line (fnd_file.LOG,'');
1072:
1073: <
1074: LOOP
1075: BEGIN
1102:
1103: WHEN NO_DATA_FOUND
1104: THEN
1105: IF l_trans_code <> 'BETFOR99' THEN
1106: fnd_file.put_line (fnd_file.LOG,'');
1107: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1108: ELSE
1109:
1110: fnd_file.put_line (fnd_file.LOG,'');
1103: WHEN NO_DATA_FOUND
1104: THEN
1105: IF l_trans_code <> 'BETFOR99' THEN
1106: fnd_file.put_line (fnd_file.LOG,'');
1107: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1108: ELSE
1109:
1110: fnd_file.put_line (fnd_file.LOG,'');
1111: fnd_file.put_line (fnd_file.LOG,'');
1106: fnd_file.put_line (fnd_file.LOG,'');
1107: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1108: ELSE
1109:
1110: fnd_file.put_line (fnd_file.LOG,'');
1111: fnd_file.put_line (fnd_file.LOG,'');
1112:
1113: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1107: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1108: ELSE
1109:
1110: fnd_file.put_line (fnd_file.LOG,'');
1111: fnd_file.put_line (fnd_file.LOG,'');
1112:
1113: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1115: fnd_file.put_line (fnd_file.LOG,'');
1109:
1110: fnd_file.put_line (fnd_file.LOG,'');
1111: fnd_file.put_line (fnd_file.LOG,'');
1112:
1113: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1115: fnd_file.put_line (fnd_file.LOG,'');
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1110: fnd_file.put_line (fnd_file.LOG,'');
1111: fnd_file.put_line (fnd_file.LOG,'');
1112:
1113: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1115: fnd_file.put_line (fnd_file.LOG,'');
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1111: fnd_file.put_line (fnd_file.LOG,'');
1112:
1113: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1115: fnd_file.put_line (fnd_file.LOG,'');
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1112:
1113: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1115: fnd_file.put_line (fnd_file.LOG,'');
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1113: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1115: fnd_file.put_line (fnd_file.LOG,'');
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1114: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1115: fnd_file.put_line (fnd_file.LOG,'');
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1122: fnd_file.put_line (fnd_file.LOG,'');
1115: fnd_file.put_line (fnd_file.LOG,'');
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1122: fnd_file.put_line (fnd_file.LOG,'');
1123: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1116: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1122: fnd_file.put_line (fnd_file.LOG,'');
1123: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1124: fnd_file.put_line (fnd_file.LOG,'');
1117: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1122: fnd_file.put_line (fnd_file.LOG,'');
1123: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1124: fnd_file.put_line (fnd_file.LOG,'');
1125:
1118: fnd_file.put_line (fnd_file.LOG,'');
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1122: fnd_file.put_line (fnd_file.LOG,'');
1123: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1124: fnd_file.put_line (fnd_file.LOG,'');
1125:
1126: END IF;
1119: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1122: fnd_file.put_line (fnd_file.LOG,'');
1123: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1124: fnd_file.put_line (fnd_file.LOG,'');
1125:
1126: END IF;
1127: fnd_file.put_line (fnd_file.LOG,'');
1120: fnd_file.put_line (fnd_file.LOG,'');
1121: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1122: fnd_file.put_line (fnd_file.LOG,'');
1123: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1124: fnd_file.put_line (fnd_file.LOG,'');
1125:
1126: END IF;
1127: fnd_file.put_line (fnd_file.LOG,'');
1128: fnd_file.put_line (fnd_file.LOG,'');
1123: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1124: fnd_file.put_line (fnd_file.LOG,'');
1125:
1126: END IF;
1127: fnd_file.put_line (fnd_file.LOG,'');
1128: fnd_file.put_line (fnd_file.LOG,'');
1129: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1130: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1131: fnd_file.put_line (fnd_file.LOG,'');
1124: fnd_file.put_line (fnd_file.LOG,'');
1125:
1126: END IF;
1127: fnd_file.put_line (fnd_file.LOG,'');
1128: fnd_file.put_line (fnd_file.LOG,'');
1129: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1130: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1131: fnd_file.put_line (fnd_file.LOG,'');
1132: fnd_file.put_line (fnd_file.LOG,'');
1125:
1126: END IF;
1127: fnd_file.put_line (fnd_file.LOG,'');
1128: fnd_file.put_line (fnd_file.LOG,'');
1129: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1130: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1131: fnd_file.put_line (fnd_file.LOG,'');
1132: fnd_file.put_line (fnd_file.LOG,'');
1133: EXIT;
1126: END IF;
1127: fnd_file.put_line (fnd_file.LOG,'');
1128: fnd_file.put_line (fnd_file.LOG,'');
1129: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1130: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1131: fnd_file.put_line (fnd_file.LOG,'');
1132: fnd_file.put_line (fnd_file.LOG,'');
1133: EXIT;
1134:
1127: fnd_file.put_line (fnd_file.LOG,'');
1128: fnd_file.put_line (fnd_file.LOG,'');
1129: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1130: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1131: fnd_file.put_line (fnd_file.LOG,'');
1132: fnd_file.put_line (fnd_file.LOG,'');
1133: EXIT;
1134:
1135: END;
1128: fnd_file.put_line (fnd_file.LOG,'');
1129: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1130: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1131: fnd_file.put_line (fnd_file.LOG,'');
1132: fnd_file.put_line (fnd_file.LOG,'');
1133: EXIT;
1134:
1135: END;
1136:
1180: rpad(l_emp_name ,31,' ') ||
1181: rpad(l_amount ,17,' ') ||
1182: l_val_remark;
1183:
1184: fnd_file.put_line (fnd_file.LOG,l_record_write);
1185:
1186: EXCEPTION
1187: WHEN e_record_too_long --Record is too long
1188: THEN -- Set retcode to 1, indicating a WARNING to the ConcMgr