DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on FND_FILE

Line 1006: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1007: 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:

Line 1008: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAL'));

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

Line 1009: fnd_file.put_line (fnd_file.LOG,'====================================================');

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:

Line 1010: fnd_file.put_line (fnd_file.LOG,'');

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'));

Line 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);

Line 1024: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','ARFN') || ' : ' || l_filename);

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);

Line 1025: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1026: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TD') ||' : ' || l_ah_trans_date);

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);

Line 1027: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1028: fnd_file.put_line (fnd_file.LOG,l_heading_ah || ' - ' || get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PI') ||' : ' || l_ah_proc_id);

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);

Line 1029: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1030: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EN') ||' : ' || l_enterprise_no);

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);

Line 1031: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1032: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','DIV') ||' : ' || l_division);

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;

Line 1033: fnd_file.put_line (fnd_file.LOG,'');

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);

Line 1034: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','PD') ||' : ' || l_production_date);

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

Line 1035: fnd_file.put_line (fnd_file.LOG,'');

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

Line 1041: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1042: 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,'');

Line 1043: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));

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:

Line 1044: fnd_file.put_line (fnd_file.LOG,'=========================================');

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:

Line 1045: fnd_file.put_line (fnd_file.LOG,'');

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;

Line 1046: 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;
1050:

Line 1091: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1092: fnd_file.put_line (fnd_file.LOG,l_column_heading1 );

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:

Line 1093: fnd_file.put_line (fnd_file.LOG,l_column_heading2 );

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: <>

Line 1094: fnd_file.put_line (fnd_file.LOG,l_column_underline );

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

Line 1095: fnd_file.put_line (fnd_file.LOG,'');

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

Line 1130: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1131: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','RNV99'));

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,'');

Line 1134: 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);

Line 1135: 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);
1139: fnd_file.put_line (fnd_file.LOG,'');

Line 1137: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NAP') ||' : ' || l_acc_pay_no);

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);

Line 1138: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAA') ||' : ' || l_acc_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,'');

Line 1139: 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);

Line 1140: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NRP') ||' : ' || l_rej_pay_no);

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,'');

Line 1141: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TRA') ||' : ' || l_rej_pay_amt);

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);

Line 1142: fnd_file.put_line (fnd_file.LOG,'');

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,'');

Line 1143: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NP') ||' : ' || l_no_of_payments);

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);

Line 1144: 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);
1148: fnd_file.put_line (fnd_file.LOG,'');

Line 1145: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','TAB') ||' : ' || l_tot_amt_batch);

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:

Line 1146: fnd_file.put_line (fnd_file.LOG,'');

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;

Line 1147: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','NR') ||' : ' || l_no_of_records);

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,'');

Line 1148: 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,'');

Line 1151: 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,'');

Line 1152: 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,'');

Line 1153: fnd_file.put_line (fnd_file.LOG,get_lookup_meaning ('NO_PAYMENT_PROCESS_LABELS','EAL'));

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;

Line 1154: fnd_file.put_line (fnd_file.LOG,'=======================================================');

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:

Line 1155: fnd_file.put_line (fnd_file.LOG,'');

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;

Line 1156: 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;
1160:

Line 1208: fnd_file.put_line (fnd_file.LOG,l_record_write);

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