1002: ,p_trans_code => l_trans_code
1003: );
1004: /* check for BETFOR00 */
1005:
1006: fnd_file.put_line (fnd_file.LOG,'');
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
1009: fnd_file.put_line (fnd_file.LOG,'====================================================');
1010: fnd_file.put_line (fnd_file.LOG,'');
1003: );
1004: /* check for BETFOR00 */
1005:
1006: fnd_file.put_line (fnd_file.LOG,'');
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
1009: fnd_file.put_line (fnd_file.LOG,'====================================================');
1010: fnd_file.put_line (fnd_file.LOG,'');
1011:
1004: /* check for BETFOR00 */
1005:
1006: fnd_file.put_line (fnd_file.LOG,'');
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
1009: fnd_file.put_line (fnd_file.LOG,'====================================================');
1010: fnd_file.put_line (fnd_file.LOG,'');
1011:
1012: IF l_trans_code <> 'BETFOR00' THEN
1005:
1006: fnd_file.put_line (fnd_file.LOG,'');
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
1009: fnd_file.put_line (fnd_file.LOG,'====================================================');
1010: fnd_file.put_line (fnd_file.LOG,'');
1011:
1012: IF l_trans_code <> 'BETFOR00' THEN
1013:
1006: fnd_file.put_line (fnd_file.LOG,'');
1007: fnd_file.put_line (fnd_file.LOG,'');
1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));
1009: fnd_file.put_line (fnd_file.LOG,'====================================================');
1010: fnd_file.put_line (fnd_file.LOG,'');
1011:
1012: IF l_trans_code <> 'BETFOR00' THEN
1013:
1014: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV00'));
1010: fnd_file.put_line (fnd_file.LOG,'');
1011:
1012: IF l_trans_code <> 'BETFOR00' THEN
1013:
1014: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV00'));
1015: RAISE BETFOR00_NOT_FOUND;
1016: ELSE
1017: /* get batch details */
1018: l_ah_trans_date := SUBSTR(l_record_read,10,4);
1020: l_enterprise_no := SUBSTR(l_record_read,49,11);
1021: l_division := SUBSTR(l_record_read,60,11);
1022: l_production_date := SUBSTR(l_record_read,81,4);
1023:
1024: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1025: fnd_file.put_line (fnd_file.LOG,'');
1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1021: l_division := SUBSTR(l_record_read,60,11);
1022: l_production_date := SUBSTR(l_record_read,81,4);
1023:
1024: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1025: fnd_file.put_line (fnd_file.LOG,'');
1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1022: l_production_date := SUBSTR(l_record_read,81,4);
1023:
1024: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1025: fnd_file.put_line (fnd_file.LOG,'');
1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1023:
1024: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1025: fnd_file.put_line (fnd_file.LOG,'');
1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1024: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);
1025: fnd_file.put_line (fnd_file.LOG,'');
1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1025: fnd_file.put_line (fnd_file.LOG,'');
1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1033: fnd_file.put_line (fnd_file.LOG,'');
1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1033: fnd_file.put_line (fnd_file.LOG,'');
1034: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1027: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1033: fnd_file.put_line (fnd_file.LOG,'');
1034: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1035: fnd_file.put_line (fnd_file.LOG,'');
1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1033: fnd_file.put_line (fnd_file.LOG,'');
1034: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1035: fnd_file.put_line (fnd_file.LOG,'');
1036: END IF;
1029: fnd_file.put_line (fnd_file.LOG,'');
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1033: fnd_file.put_line (fnd_file.LOG,'');
1034: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1035: fnd_file.put_line (fnd_file.LOG,'');
1036: END IF;
1037: UTL_FILE.fclose (l_file_type);
1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1033: fnd_file.put_line (fnd_file.LOG,'');
1034: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1035: fnd_file.put_line (fnd_file.LOG,'');
1036: END IF;
1037: UTL_FILE.fclose (l_file_type);
1038: EXCEPTION
1031: fnd_file.put_line (fnd_file.LOG,'');
1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);
1033: fnd_file.put_line (fnd_file.LOG,'');
1034: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);
1035: fnd_file.put_line (fnd_file.LOG,'');
1036: END IF;
1037: UTL_FILE.fclose (l_file_type);
1038: EXCEPTION
1039: WHEN BETFOR00_NOT_FOUND
1037: UTL_FILE.fclose (l_file_type);
1038: EXCEPTION
1039: WHEN BETFOR00_NOT_FOUND
1040: THEN
1041: fnd_file.put_line (fnd_file.LOG,'');
1042: fnd_file.put_line (fnd_file.LOG,'');
1043: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1044: fnd_file.put_line (fnd_file.LOG,'=========================================');
1045: fnd_file.put_line (fnd_file.LOG,'');
1038: EXCEPTION
1039: WHEN BETFOR00_NOT_FOUND
1040: THEN
1041: fnd_file.put_line (fnd_file.LOG,'');
1042: fnd_file.put_line (fnd_file.LOG,'');
1043: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1044: fnd_file.put_line (fnd_file.LOG,'=========================================');
1045: fnd_file.put_line (fnd_file.LOG,'');
1046: fnd_file.put_line (fnd_file.LOG,'');
1039: WHEN BETFOR00_NOT_FOUND
1040: THEN
1041: fnd_file.put_line (fnd_file.LOG,'');
1042: fnd_file.put_line (fnd_file.LOG,'');
1043: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1044: fnd_file.put_line (fnd_file.LOG,'=========================================');
1045: fnd_file.put_line (fnd_file.LOG,'');
1046: fnd_file.put_line (fnd_file.LOG,'');
1047:
1040: THEN
1041: fnd_file.put_line (fnd_file.LOG,'');
1042: fnd_file.put_line (fnd_file.LOG,'');
1043: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1044: fnd_file.put_line (fnd_file.LOG,'=========================================');
1045: fnd_file.put_line (fnd_file.LOG,'');
1046: fnd_file.put_line (fnd_file.LOG,'');
1047:
1048:
1041: fnd_file.put_line (fnd_file.LOG,'');
1042: fnd_file.put_line (fnd_file.LOG,'');
1043: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1044: fnd_file.put_line (fnd_file.LOG,'=========================================');
1045: fnd_file.put_line (fnd_file.LOG,'');
1046: fnd_file.put_line (fnd_file.LOG,'');
1047:
1048:
1049: END;
1042: fnd_file.put_line (fnd_file.LOG,'');
1043: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1044: fnd_file.put_line (fnd_file.LOG,'=========================================');
1045: fnd_file.put_line (fnd_file.LOG,'');
1046: fnd_file.put_line (fnd_file.LOG,'');
1047:
1048:
1049: END;
1050:
1087: || lpad(' ',31 ,'=')
1088: || lpad(' ',17 ,'=')
1089: || lpad(' ',15 ,'=');
1090:
1091: fnd_file.put_line (fnd_file.LOG,'');
1092: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1093: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1094: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1095: fnd_file.put_line (fnd_file.LOG,'');
1088: || lpad(' ',17 ,'=')
1089: || lpad(' ',15 ,'=');
1090:
1091: fnd_file.put_line (fnd_file.LOG,'');
1092: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1093: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1094: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1095: fnd_file.put_line (fnd_file.LOG,'');
1096:
1089: || lpad(' ',15 ,'=');
1090:
1091: fnd_file.put_line (fnd_file.LOG,'');
1092: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1093: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1094: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1095: fnd_file.put_line (fnd_file.LOG,'');
1096:
1097: <
1090:
1091: fnd_file.put_line (fnd_file.LOG,'');
1092: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1093: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1094: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1095: fnd_file.put_line (fnd_file.LOG,'');
1096:
1097: <
1098: LOOP
1091: fnd_file.put_line (fnd_file.LOG,'');
1092: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );
1093: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );
1094: fnd_file.put_line (fnd_file.LOG,l_column_underline );
1095: fnd_file.put_line (fnd_file.LOG,'');
1096:
1097: <
1098: LOOP
1099: BEGIN
1126:
1127: WHEN NO_DATA_FOUND
1128: THEN
1129: IF l_trans_code <> 'BETFOR99' THEN
1130: fnd_file.put_line (fnd_file.LOG,'');
1131: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1132: ELSE
1133:
1134: fnd_file.put_line (fnd_file.LOG,'');
1127: WHEN NO_DATA_FOUND
1128: THEN
1129: IF l_trans_code <> 'BETFOR99' THEN
1130: fnd_file.put_line (fnd_file.LOG,'');
1131: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1132: ELSE
1133:
1134: fnd_file.put_line (fnd_file.LOG,'');
1135: fnd_file.put_line (fnd_file.LOG,'');
1130: fnd_file.put_line (fnd_file.LOG,'');
1131: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1132: ELSE
1133:
1134: fnd_file.put_line (fnd_file.LOG,'');
1135: fnd_file.put_line (fnd_file.LOG,'');
1136:
1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1131: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));
1132: ELSE
1133:
1134: fnd_file.put_line (fnd_file.LOG,'');
1135: fnd_file.put_line (fnd_file.LOG,'');
1136:
1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1139: fnd_file.put_line (fnd_file.LOG,'');
1133:
1134: fnd_file.put_line (fnd_file.LOG,'');
1135: fnd_file.put_line (fnd_file.LOG,'');
1136:
1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1139: fnd_file.put_line (fnd_file.LOG,'');
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1134: fnd_file.put_line (fnd_file.LOG,'');
1135: fnd_file.put_line (fnd_file.LOG,'');
1136:
1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1139: fnd_file.put_line (fnd_file.LOG,'');
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1135: fnd_file.put_line (fnd_file.LOG,'');
1136:
1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1139: fnd_file.put_line (fnd_file.LOG,'');
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1136:
1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1139: fnd_file.put_line (fnd_file.LOG,'');
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1139: fnd_file.put_line (fnd_file.LOG,'');
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_pay_amt);
1139: fnd_file.put_line (fnd_file.LOG,'');
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1146: fnd_file.put_line (fnd_file.LOG,'');
1139: fnd_file.put_line (fnd_file.LOG,'');
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1146: fnd_file.put_line (fnd_file.LOG,'');
1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1146: fnd_file.put_line (fnd_file.LOG,'');
1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1148: fnd_file.put_line (fnd_file.LOG,'');
1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1146: fnd_file.put_line (fnd_file.LOG,'');
1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1148: fnd_file.put_line (fnd_file.LOG,'');
1149:
1142: fnd_file.put_line (fnd_file.LOG,'');
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1146: fnd_file.put_line (fnd_file.LOG,'');
1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1148: fnd_file.put_line (fnd_file.LOG,'');
1149:
1150: END IF;
1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1146: fnd_file.put_line (fnd_file.LOG,'');
1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1148: fnd_file.put_line (fnd_file.LOG,'');
1149:
1150: END IF;
1151: fnd_file.put_line (fnd_file.LOG,'');
1144: fnd_file.put_line (fnd_file.LOG,'');
1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);
1146: fnd_file.put_line (fnd_file.LOG,'');
1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1148: fnd_file.put_line (fnd_file.LOG,'');
1149:
1150: END IF;
1151: fnd_file.put_line (fnd_file.LOG,'');
1152: fnd_file.put_line (fnd_file.LOG,'');
1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);
1148: fnd_file.put_line (fnd_file.LOG,'');
1149:
1150: END IF;
1151: fnd_file.put_line (fnd_file.LOG,'');
1152: fnd_file.put_line (fnd_file.LOG,'');
1153: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1154: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1155: fnd_file.put_line (fnd_file.LOG,'');
1148: fnd_file.put_line (fnd_file.LOG,'');
1149:
1150: END IF;
1151: fnd_file.put_line (fnd_file.LOG,'');
1152: fnd_file.put_line (fnd_file.LOG,'');
1153: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1154: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1155: fnd_file.put_line (fnd_file.LOG,'');
1156: fnd_file.put_line (fnd_file.LOG,'');
1149:
1150: END IF;
1151: fnd_file.put_line (fnd_file.LOG,'');
1152: fnd_file.put_line (fnd_file.LOG,'');
1153: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1154: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1155: fnd_file.put_line (fnd_file.LOG,'');
1156: fnd_file.put_line (fnd_file.LOG,'');
1157: EXIT;
1150: END IF;
1151: fnd_file.put_line (fnd_file.LOG,'');
1152: fnd_file.put_line (fnd_file.LOG,'');
1153: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1154: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1155: fnd_file.put_line (fnd_file.LOG,'');
1156: fnd_file.put_line (fnd_file.LOG,'');
1157: EXIT;
1158:
1151: fnd_file.put_line (fnd_file.LOG,'');
1152: fnd_file.put_line (fnd_file.LOG,'');
1153: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1154: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1155: fnd_file.put_line (fnd_file.LOG,'');
1156: fnd_file.put_line (fnd_file.LOG,'');
1157: EXIT;
1158:
1159: END;
1152: fnd_file.put_line (fnd_file.LOG,'');
1153: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));
1154: fnd_file.put_line (fnd_file.LOG,'=======================================================');
1155: fnd_file.put_line (fnd_file.LOG,'');
1156: fnd_file.put_line (fnd_file.LOG,'');
1157: EXIT;
1158:
1159: END;
1160:
1204: rpad(l_emp_name ,31,' ') ||
1205: rpad(l_amount ,17,' ') ||
1206: l_val_remark;
1207:
1208: fnd_file.put_line (fnd_file.LOG,l_record_write);
1209:
1210: EXCEPTION
1211: WHEN e_record_too_long --Record is too long
1212: THEN -- Set retcode to 1, indicating a WARNING to the ConcMgr