eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_VALIDATE_DATA_PKG dependencies on JAI_CMN_UTILS_PKG

Line 112: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));

108: p_process_message OUT NOCOPY VARCHAR2)
109: IS
110: ln_slno NUMBER := 0;
111: BEGIN
112: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
113: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',62,'=')||'Summary'||LPAD('=',62,'='));
114: jai_cmn_utils_pkg.print_log(p_filename, 'Total number of Records processed : '||p_total_count);
115: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
116: jai_cmn_utils_pkg.print_log(p_filename, LPAD('No.',3)||' '||RPAD('Error Description',120)||' '||LPAD('Count',6));

Line 113: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',62,'=')||'Summary'||LPAD('=',62,'='));

109: IS
110: ln_slno NUMBER := 0;
111: BEGIN
112: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
113: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',62,'=')||'Summary'||LPAD('=',62,'='));
114: jai_cmn_utils_pkg.print_log(p_filename, 'Total number of Records processed : '||p_total_count);
115: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
116: jai_cmn_utils_pkg.print_log(p_filename, LPAD('No.',3)||' '||RPAD('Error Description',120)||' '||LPAD('Count',6));
117: jai_cmn_utils_pkg.print_log(p_filename, LPAD('-',3,'-')||' '||RPAD('-',120,'-')||' '||LPAD('-',6,'-'));

Line 114: jai_cmn_utils_pkg.print_log(p_filename, 'Total number of Records processed : '||p_total_count);

110: ln_slno NUMBER := 0;
111: BEGIN
112: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
113: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',62,'=')||'Summary'||LPAD('=',62,'='));
114: jai_cmn_utils_pkg.print_log(p_filename, 'Total number of Records processed : '||p_total_count);
115: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
116: jai_cmn_utils_pkg.print_log(p_filename, LPAD('No.',3)||' '||RPAD('Error Description',120)||' '||LPAD('Count',6));
117: jai_cmn_utils_pkg.print_log(p_filename, LPAD('-',3,'-')||' '||RPAD('-',120,'-')||' '||LPAD('-',6,'-'));
118:

Line 115: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));

111: BEGIN
112: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
113: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',62,'=')||'Summary'||LPAD('=',62,'='));
114: jai_cmn_utils_pkg.print_log(p_filename, 'Total number of Records processed : '||p_total_count);
115: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
116: jai_cmn_utils_pkg.print_log(p_filename, LPAD('No.',3)||' '||RPAD('Error Description',120)||' '||LPAD('Count',6));
117: jai_cmn_utils_pkg.print_log(p_filename, LPAD('-',3,'-')||' '||RPAD('-',120,'-')||' '||LPAD('-',6,'-'));
118:
119: For i IN p_error_table.first..p_error_table.last

Line 116: jai_cmn_utils_pkg.print_log(p_filename, LPAD('No.',3)||' '||RPAD('Error Description',120)||' '||LPAD('Count',6));

112: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
113: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',62,'=')||'Summary'||LPAD('=',62,'='));
114: jai_cmn_utils_pkg.print_log(p_filename, 'Total number of Records processed : '||p_total_count);
115: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
116: jai_cmn_utils_pkg.print_log(p_filename, LPAD('No.',3)||' '||RPAD('Error Description',120)||' '||LPAD('Count',6));
117: jai_cmn_utils_pkg.print_log(p_filename, LPAD('-',3,'-')||' '||RPAD('-',120,'-')||' '||LPAD('-',6,'-'));
118:
119: For i IN p_error_table.first..p_error_table.last
120: LOOP

Line 117: jai_cmn_utils_pkg.print_log(p_filename, LPAD('-',3,'-')||' '||RPAD('-',120,'-')||' '||LPAD('-',6,'-'));

113: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',62,'=')||'Summary'||LPAD('=',62,'='));
114: jai_cmn_utils_pkg.print_log(p_filename, 'Total number of Records processed : '||p_total_count);
115: jai_cmn_utils_pkg.print_log(p_filename, fnd_global.local_chr(10));
116: jai_cmn_utils_pkg.print_log(p_filename, LPAD('No.',3)||' '||RPAD('Error Description',120)||' '||LPAD('Count',6));
117: jai_cmn_utils_pkg.print_log(p_filename, LPAD('-',3,'-')||' '||RPAD('-',120,'-')||' '||LPAD('-',6,'-'));
118:
119: For i IN p_error_table.first..p_error_table.last
120: LOOP
121: IF p_error_table.EXISTS(i) THEN

Line 125: jai_cmn_utils_pkg.print_log(p_filename, LPAD(ln_slno,2)||') '||RPAD(p_error_table(i).error_description,120)||' '||LPAD(p_error_table(i).error_record_count,6));

121: IF p_error_table.EXISTS(i) THEN
122:
123: IF p_error_table(i).error_record_count > 0 THEN
124: ln_slno := ln_slno + 1;
125: jai_cmn_utils_pkg.print_log(p_filename, LPAD(ln_slno,2)||') '||RPAD(p_error_table(i).error_description,120)||' '||LPAD(p_error_table(i).error_record_count,6));
126: END IF;
127:
128: END IF;
129:

Line 132: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',131,'='));

128: END IF;
129:
130: END LOOP;
131:
132: jai_cmn_utils_pkg.print_log(p_filename, LPAD('=',131,'='));
133:
134: END display_error_summary;
135:
136: PROCEDURE calc_term_apportion_ratio(p_invoice_type IN ar_payment_schedules_all.class%TYPE,

Line 244: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);

240: last_updated_by = '||gn_bug_no||'
241: WHERE customer_trx_id = '||p_customer_trx_id||'
242: AND payment_schedule_id = '||i.payment_schedule_id||';';
243:
244: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);
245:
246: lv_sql_statement := NULL;
247:
248: ELSIF p_gl_tax_amount IS NOT NULL THEN

Line 265: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);

261: last_updated_by = '||gn_bug_no||'
262: WHERE customer_trx_id = '||p_customer_trx_id||'
263: AND payment_schedule_id = '||i.payment_schedule_id||';';
264:
265: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);
266:
267: lv_sql_statement := NULL;
268:
269: ELSIF p_gl_freight_amount IS NOT NULL THEN

Line 286: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);

282: last_updated_by = '||gn_bug_no||'
283: WHERE customer_trx_id = '||p_customer_trx_id||'
284: AND payment_schedule_id = '||i.payment_schedule_id||';';
285:
286: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);
287:
288: lv_sql_statement := NULL;
289:
290: END IF;

Line 370: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);

366: AND display = '||''''||'Y'||''''||'
367: AND status = '||''''||'APP'||''''||'
368: AND application_type = '||''''||'CM'||''''||';';
369:
370: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);
371:
372: lv_sql_statement := NULL;
373:
374: ELSIF p_arps_to IS NOT NULL THEN

Line 399: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);

395: AND display = '||''''||'Y'||''''||'
396: AND status = '||''''||'APP'||''''||'
397: AND application_type = '||''''||'CM'||''''||';';
398:
399: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);
400:
401: lv_sql_statement := NULL;
402:
403: ELSIF p_arps_fo IS NOT NULL THEN

Line 428: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);

424: AND display = '||''''||'Y'||''''||'
425: AND status = '||''''||'APP'||''''||'
426: AND application_type = '||''''||'CM'||''''||';';
427:
428: jai_cmn_utils_pkg.print_log(p_datafix_filename, lv_sql_statement);
429:
430: lv_sql_statement := NULL;
431: END IF;
432:

Line 933: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Start of JAI AR Reconcilation program at '||TO_CHAR(sysdate,'DD-MON-YYYY HH24:MI:SS'));

929:
930: SAVEPOINT start_program;
931:
932: IF lv_generate_log = 'Y' THEN
933: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Start of JAI AR Reconcilation program at '||TO_CHAR(sysdate,'DD-MON-YYYY HH24:MI:SS'));
934: END IF;
935:
936: ln_total_count := 0;
937:

Line 960: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

956:
957: ln_error_cnt := 0;
958:
959: IF lv_generate_detail_log = 'Y' THEN
960: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
961: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Started processing customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
962: END IF;
963:
964: ln_total_count := ln_total_count + 1;

Line 961: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Started processing customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

957: ln_error_cnt := 0;
958:
959: IF lv_generate_detail_log = 'Y' THEN
960: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
961: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Started processing customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
962: END IF;
963:
964: ln_total_count := ln_total_count + 1;
965:

Line 975: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

971: IF cur_revrec_run%found THEN
972:
973: --As revenue recognition program has already been run on this customer_trx_id hence skip this and go to next record.
974: IF lv_generate_detail_log = 'Y' THEN
975: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
976: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Revenue recognition program has already been run on the customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
977: END IF;
978:
979: CLOSE cur_revrec_run;

Line 976: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Revenue recognition program has already been run on the customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

972:
973: --As revenue recognition program has already been run on this customer_trx_id hence skip this and go to next record.
974: IF lv_generate_detail_log = 'Y' THEN
975: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
976: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Revenue recognition program has already been run on the customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
977: END IF;
978:
979: CLOSE cur_revrec_run;
980: goto exit_point;

Line 1057: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1053:
1054: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1055:
1056: If lv_generate_detail_log = 'Y' THEN
1057: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1058: END IF;
1059:
1060: IF lv_generate_log = 'Y' THEN
1061: IF ln_error_cnt = 0 THEN

Line 1062: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1058: END IF;
1059:
1060: IF lv_generate_log = 'Y' THEN
1061: IF ln_error_cnt = 0 THEN
1062: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1063: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1064: END IF;
1065:
1066: ln_error_cnt := 1;

Line 1063: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1059:
1060: IF lv_generate_log = 'Y' THEN
1061: IF ln_error_cnt = 0 THEN
1062: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1063: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1064: END IF;
1065:
1066: ln_error_cnt := 1;
1067:

Line 1085: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1081: ' last_updated_by = '||gn_bug_no||fnd_global.local_chr(10)||
1082: 'WHERE customer_trx_line_id = '||i.customer_trx_line_id||fnd_global.local_chr(10)||
1083: 'AND customer_trx_id = '||i.customer_trx_id||';';
1084:
1085: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1086:
1087: lv_sql_statement := NULL;
1088:
1089: END LOOP;

Line 1111: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1107:
1108: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1109:
1110: If lv_generate_detail_log = 'Y' THEN
1111: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1112: END IF;
1113:
1114: IF lv_generate_log = 'Y' THEN
1115:

Line 1117: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1113:
1114: IF lv_generate_log = 'Y' THEN
1115:
1116: IF ln_error_cnt = 0 THEN
1117: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1118: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1119: END IF;
1120:
1121: ln_error_cnt := 1;

Line 1118: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1114: IF lv_generate_log = 'Y' THEN
1115:
1116: IF ln_error_cnt = 0 THEN
1117: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1118: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1119: END IF;
1120:
1121: ln_error_cnt := 1;
1122:

Line 1151: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1147: ' last_updated_by = '||gn_bug_no||fnd_global.local_chr(10)||
1148: 'WHERE customer_trx_line_id = '||i.customer_trx_line_id||fnd_global.local_chr(10)||
1149: 'AND customer_trx_id = '||i.customer_trx_id||';';
1150:
1151: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1152:
1153: lv_sql_statement := NULL;
1154:
1155: END LOOP;

Line 1195: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1191: WHERE rec.account_class = '||''''||'REC'||''''||'
1192: AND rec.latest_rec_flag = '||''''||'Y'||''''||'
1193: AND customer_trx_id = '||rec_get_cust_trx.customer_trx_id||';';
1194:
1195: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1196:
1197: lv_sql_statement := NULL;
1198:
1199:

Line 1226: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1222:
1223: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1224:
1225: If lv_generate_detail_log = 'Y' THEN
1226: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1227: END IF;
1228:
1229: IF lv_generate_log = 'Y' THEN
1230:

Line 1232: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1228:
1229: IF lv_generate_log = 'Y' THEN
1230:
1231: IF ln_error_cnt = 0 THEN
1232: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1233: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1234: END IF;
1235:
1236: ln_error_cnt := 1;

Line 1233: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1229: IF lv_generate_log = 'Y' THEN
1230:
1231: IF ln_error_cnt = 0 THEN
1232: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1233: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1234: END IF;
1235:
1236: ln_error_cnt := 1;
1237:

Line 1255: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1251: last_updated_by = '||gn_bug_no||'
1252: WHERE customer_trx_id = '||rec_get_cust_trx.customer_trx_id||'
1253: AND customer_trx_line_id = '||rec_gl_dist_rctl.customer_trx_line_id||';';
1254:
1255: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1256:
1257: lv_sql_statement := NULL;
1258:
1259: END LOOP;

Line 1278: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1274:
1275: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1276:
1277: If lv_generate_detail_log = 'Y' THEN
1278: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1279: END IF;
1280:
1281: /*
1282: ||arps.ado = gl_dist.rec

Line 1288: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1284:
1285: IF lv_generate_log = 'Y' THEN
1286:
1287: IF ln_error_cnt = 0 THEN
1288: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1289: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1290: END IF;
1291:
1292: ln_error_cnt := 1;

Line 1289: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1285: IF lv_generate_log = 'Y' THEN
1286:
1287: IF ln_error_cnt = 0 THEN
1288: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1289: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1290: END IF;
1291:
1292: ln_error_cnt := 1;
1293:

Line 1317: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1313:
1314: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1315:
1316: If lv_generate_detail_log = 'Y' THEN
1317: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1318: END IF;
1319:
1320: /*
1321: ||arps.to = gl_dist.tax

Line 1327: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1323:
1324: IF lv_generate_log = 'Y' THEN
1325:
1326: IF ln_error_cnt = 0 THEN
1327: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1328: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1329: END IF;
1330:
1331: ln_error_cnt := 1;

Line 1328: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1324: IF lv_generate_log = 'Y' THEN
1325:
1326: IF ln_error_cnt = 0 THEN
1327: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1328: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1329: END IF;
1330:
1331: ln_error_cnt := 1;
1332:

Line 1356: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1352:
1353: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1354:
1355: If lv_generate_detail_log = 'Y' THEN
1356: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1357: END IF;
1358:
1359: /*
1360: ||arps.FO = gl_dist.FRT

Line 1366: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1362:
1363: IF lv_generate_log = 'Y' THEN
1364:
1365: IF ln_error_cnt = 0 THEN
1366: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1367: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1368: END IF;
1369:
1370: ln_error_cnt := 1;

Line 1367: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1363: IF lv_generate_log = 'Y' THEN
1364:
1365: IF ln_error_cnt = 0 THEN
1366: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1367: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1368: END IF;
1369:
1370: ln_error_cnt := 1;
1371:

Line 1398: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1394:
1395: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1396:
1397: If lv_generate_detail_log = 'Y' THEN
1398: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1399: END IF;
1400:
1401: /*
1402: || rectified as a part of common (3,4,5). No seperate update required

Line 1424: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1420:
1421: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1422:
1423: If lv_generate_detail_log = 'Y' THEN
1424: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1425: END IF;
1426:
1427: /*
1428: || rectified as a part of INVOICE (1).

Line 1458: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1454:
1455: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1456:
1457: If lv_generate_detail_log = 'Y' THEN
1458: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1459: END IF;
1460:
1461: /*
1462: ||set all these values to 0

Line 1468: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1464:
1465: IF lv_generate_log = 'Y' THEN
1466:
1467: IF ln_error_cnt = 0 THEN
1468: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1469: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1470: END IF;
1471:
1472: ln_error_cnt := 1;

Line 1469: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1465: IF lv_generate_log = 'Y' THEN
1466:
1467: IF ln_error_cnt = 0 THEN
1468: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1469: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1470: END IF;
1471:
1472: ln_error_cnt := 1;
1473:

Line 1493: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1489: last_update_date = sysdate,
1490: last_updated_by = '||gn_bug_no||'
1491: WHERE customer_trx_id = '||rec_get_cust_trx.customer_trx_id||';';
1492:
1493: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1494:
1495: lv_sql_statement := NULL;
1496:
1497:

Line 1517: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1513:
1514: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1515:
1516: If lv_generate_detail_log = 'Y' THEN
1517: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1518: END IF;
1519:
1520: /*
1521: ||set amt_applied = ADO as has been corrected earlier

Line 1527: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1523:
1524: IF lv_generate_log = 'Y' THEN
1525:
1526: IF ln_error_cnt = 0 THEN
1527: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1528: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1529: END IF;
1530:
1531: ln_error_cnt := 1;

Line 1528: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1524: IF lv_generate_log = 'Y' THEN
1525:
1526: IF ln_error_cnt = 0 THEN
1527: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1528: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1529: END IF;
1530:
1531: ln_error_cnt := 1;
1532:

Line 1546: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1542: last_update_date = sysdate,
1543: last_updated_by = '||gn_bug_no||
1544: ' WHERE customer_trx_id = '|| rec_get_cust_trx.customer_trx_id||';';
1545:
1546: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1547:
1548: lv_sql_statement := NULL;
1549:
1550: END IF;

Line 1578: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1574:
1575: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1576:
1577: If lv_generate_detail_log = 'Y' THEN
1578: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1579: END IF;
1580:
1581: /*
1582: ||IF CM has more than one applications then manual steps needs to be carried out else update and generate log

Line 1589: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1585:
1586: IF lv_generate_log = 'Y' THEN
1587:
1588: IF ln_error_cnt = 0 THEN
1589: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1590: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1591: END IF;
1592:
1593: ln_error_cnt := 1;

Line 1590: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1586: IF lv_generate_log = 'Y' THEN
1587:
1588: IF ln_error_cnt = 0 THEN
1589: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1590: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1591: END IF;
1592:
1593: ln_error_cnt := 1;
1594:

Line 1627: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1623:
1624: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1625:
1626: If lv_generate_detail_log = 'Y' THEN
1627: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1628: END IF;
1629:
1630: IF lv_generate_log = 'Y' THEN
1631: UPDATE ar_receivable_applications_all

Line 1650: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1646: AND application_type = '||''''||'CM'||''''||'
1647: AND display = '||''''||'Y'||''''||'
1648: AND status = '||''''||'APP'||''''||';';
1649:
1650: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1651:
1652: lv_sql_statement := NULL;
1653:
1654: END IF;

Line 1683: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1679:
1680: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1681:
1682: If lv_generate_detail_log = 'Y' THEN
1683: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1684: END IF;
1685:
1686: /*
1687: ||set AAAF = AA * exchange_rate(CM)

Line 1693: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1689:
1690: IF lv_generate_log = 'Y' THEN
1691:
1692: IF ln_error_cnt = 0 THEN
1693: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1694: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1695: END IF;
1696:
1697: ln_error_cnt := 1;

Line 1694: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1690: IF lv_generate_log = 'Y' THEN
1691:
1692: IF ln_error_cnt = 0 THEN
1693: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1694: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1695: END IF;
1696:
1697: ln_error_cnt := 1;
1698:

Line 1719: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1715: AND application_type = '||''''||'CM'||''''||'
1716: AND display = '||''''||'Y'||''''||'
1717: AND status = '||''''||'APP'||''''||';';
1718:
1719: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1720:
1721: lv_sql_statement := NULL;
1722:
1723: END IF;

Line 1743: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1739:
1740: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1741:
1742: If lv_generate_detail_log = 'Y' THEN
1743: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1744: END IF;
1745:
1746:
1747: /*

Line 1754: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1750:
1751: IF lv_generate_log = 'Y' THEN
1752:
1753: IF ln_error_cnt = 0 THEN
1754: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1755: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1756: END IF;
1757:
1758: ln_error_cnt := 1;

Line 1755: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1751: IF lv_generate_log = 'Y' THEN
1752:
1753: IF ln_error_cnt = 0 THEN
1754: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1755: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1756: END IF;
1757:
1758: ln_error_cnt := 1;
1759:

Line 1779: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1775: AND application_type = '||''''||'CM'||''''||'
1776: AND display = '||''''||'Y'||''''||'
1777: AND status = '||''''||'APP'||''''||';';
1778:
1779: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1780:
1781: lv_sql_statement := NULL;
1782:
1783: END IF;

Line 1824: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1820:
1821: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1822:
1823: If lv_generate_detail_log = 'Y' THEN
1824: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1825: END IF;
1826:
1827: /*
1828: ||set TR = TO - SUM(TA) for the arps.payment_schedule_id = RECA.applied_payment_schedule_id AND ARPS.customer_trx_id = RECA.applied_customer_trx_id

Line 1836: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1832:
1833: IF lv_generate_log = 'Y' THEN
1834:
1835: IF ln_error_cnt = 0 THEN
1836: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1837: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1838: END IF;
1839:
1840: ln_error_cnt := 1;

Line 1837: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1833: IF lv_generate_log = 'Y' THEN
1834:
1835: IF ln_error_cnt = 0 THEN
1836: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1837: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1838: END IF;
1839:
1840: ln_error_cnt := 1;
1841:

Line 1917: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1913: WHERE
1914: customer_trx_id = '||rec_get_cust_trx.customer_trx_id||';';
1915:
1916:
1917: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1918:
1919: lv_sql_statement := NULL;
1920:
1921:

Line 1946: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

1942:
1943: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
1944:
1945: If lv_generate_detail_log = 'Y' THEN
1946: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
1947: END IF;
1948:
1949:
1950: /*

Line 1956: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

1952: */
1953: IF lv_generate_log = 'Y' THEN
1954:
1955: IF ln_error_cnt = 0 THEN
1956: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1957: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1958: END IF;
1959:
1960: ln_error_cnt := 1;

Line 1957: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

1953: IF lv_generate_log = 'Y' THEN
1954:
1955: IF ln_error_cnt = 0 THEN
1956: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
1957: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
1958: END IF;
1959:
1960: ln_error_cnt := 1;
1961:

Line 1998: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

1994: last_updated_by = '||gn_bug_no||'
1995: WHERE
1996: customer_trx_id = '||rec_get_cust_trx.customer_trx_id||';';
1997:
1998: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
1999:
2000: lv_sql_statement := NULL;
2001:
2002:

Line 2043: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

2039: IF ln_local_cnt = 1 THEN
2040: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
2041:
2042: If lv_generate_detail_log = 'Y' THEN
2043: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
2044: END IF;
2045: END IF;
2046:
2047: IF lv_generate_log = 'Y' THEN

Line 2050: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

2046:
2047: IF lv_generate_log = 'Y' THEN
2048:
2049: IF ln_error_cnt = 0 THEN
2050: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2051: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2052: END IF;
2053:
2054: ln_error_cnt := 1;

Line 2051: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

2047: IF lv_generate_log = 'Y' THEN
2048:
2049: IF ln_error_cnt = 0 THEN
2050: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2051: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2052: END IF;
2053:
2054: ln_error_cnt := 1;
2055:

Line 2072: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

2068: WHERE customer_trx_id = '||rec_get_cust_trx.customer_trx_id||'
2069: AND payment_schedule_id = '||rec_payment_schedules.payment_schedule_id||';';
2070:
2071:
2072: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
2073:
2074: lv_sql_statement := NULL;
2075:
2076: END IF;

Line 2105: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

2101: IF ln_local_cnt = 1 THEN
2102: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
2103:
2104: If lv_generate_detail_log = 'Y' THEN
2105: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
2106: END IF;
2107: END IF;
2108: /*
2109: ||set the staus = 'OP and gl_date_closed ='31-DEC-4712' and actual_date_closed '31-DEC-4712' as ADR and AADR

Line 2116: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

2112:
2113: IF lv_generate_log = 'Y' THEN
2114:
2115: IF ln_error_cnt = 0 THEN
2116: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2117: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2118: END IF;
2119:
2120: ln_error_cnt := 1;

Line 2117: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

2113: IF lv_generate_log = 'Y' THEN
2114:
2115: IF ln_error_cnt = 0 THEN
2116: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2117: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2118: END IF;
2119:
2120: ln_error_cnt := 1;
2121:

Line 2142: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

2138: last_updated_by = '||gn_bug_no||'
2139: WHERE customer_trx_id = '||rec_get_cust_trx.customer_trx_id||'
2140: AND payment_schedule_id = '||rec_payment_schedules.payment_schedule_id||';';
2141:
2142: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
2143:
2144: lv_sql_statement := NULL;
2145:
2146:

Line 2178: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

2174: IF ln_local_cnt = 1 THEN
2175: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
2176:
2177: If lv_generate_detail_log = 'Y' THEN
2178: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
2179: END IF;
2180: END IF;
2181:
2182: /*

Line 2189: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

2185:
2186: IF lv_generate_log = 'Y' THEN
2187:
2188: IF ln_error_cnt = 0 THEN
2189: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2190: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2191: END IF;
2192:
2193: ln_error_cnt := 1;

Line 2190: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

2186: IF lv_generate_log = 'Y' THEN
2187:
2188: IF ln_error_cnt = 0 THEN
2189: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2190: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2191: END IF;
2192:
2193: ln_error_cnt := 1;
2194:

Line 2215: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

2211: last_updated_by = '||gn_bug_no||'
2212: WHERE customer_trx_id = '||rec_get_cust_trx.customer_trx_id||'
2213: AND payment_schedule_id = '||rec_payment_schedules.payment_schedule_id||';';
2214:
2215: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
2216:
2217: lv_sql_statement := NULL;
2218:
2219: END IF;

Line 2248: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

2244: IF ln_local_cnt = 1 THEN
2245: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
2246:
2247: If lv_generate_detail_log = 'Y' THEN
2248: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
2249: END IF;
2250: END IF;
2251:
2252: IF lv_generate_log = 'Y' THEN

Line 2255: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

2251:
2252: IF lv_generate_log = 'Y' THEN
2253:
2254: IF ln_error_cnt = 0 THEN
2255: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2256: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2257: END IF;
2258:
2259: ln_error_cnt := 1;

Line 2256: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

2252: IF lv_generate_log = 'Y' THEN
2253:
2254: IF ln_error_cnt = 0 THEN
2255: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2256: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2257: END IF;
2258:
2259: ln_error_cnt := 1;
2260:

Line 2277: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

2273: last_update_date = sysdate,
2274: last_updated_by = '||gn_bug_no||'
2275: WHERE customer_trx_line_id = '||rec_cur_sync_il_line_tax.customer_trx_line_id||';';
2276:
2277: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
2278:
2279: lv_sql_statement := NULL;
2280:
2281: END IF;

Line 2306: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);

2302: IF ln_local_cnt = 1 THEN
2303: lt_error_table(ln_err_num).error_record_count := lt_error_table(ln_err_num).error_record_count + 1;
2304:
2305: If lv_generate_detail_log = 'Y' THEN
2306: jai_cmn_utils_pkg.print_log(lv_log_filename, ' Encountered the error - '||lt_error_table(ln_err_num).error_description);
2307: END IF;
2308: END IF;
2309:
2310: IF lv_generate_log = 'Y' THEN

Line 2313: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

2309:
2310: IF lv_generate_log = 'Y' THEN
2311:
2312: IF ln_error_cnt = 0 THEN
2313: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2314: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2315: END IF;
2316:
2317: ln_error_cnt := 1;

Line 2314: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);

2310: IF lv_generate_log = 'Y' THEN
2311:
2312: IF ln_error_cnt = 0 THEN
2313: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2314: jai_cmn_utils_pkg.print_log(lv_datafix_filename, '--Datafix for customer_trx_id : '||rec_get_cust_trx.customer_trx_id);
2315: END IF;
2316:
2317: ln_error_cnt := 1;
2318:

Line 2334: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);

2330: last_update_date = sysdate,
2331: last_updated_by = '||gn_bug_no||'
2332: WHERE CUSTOMER_TRX_ID = '||rec_sync_il_hdr_tax.customer_trx_id||';';
2333:
2334: jai_cmn_utils_pkg.print_log(lv_datafix_filename, lv_sql_statement);
2335:
2336: lv_sql_statement := NULL;
2337:
2338: END IF;

Line 2378: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));

2374: p_process_message := SUBSTR(sqlerrm,1,300);
2375:
2376: ROLLBACK to start_program;
2377:
2378: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2379: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Encountered an Oracle error : '||lv_process_message);
2380:
2381: END post_validation;
2382:

Line 2379: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Encountered an Oracle error : '||lv_process_message);

2375:
2376: ROLLBACK to start_program;
2377:
2378: jai_cmn_utils_pkg.print_log(lv_log_filename, fnd_global.local_chr(10));
2379: jai_cmn_utils_pkg.print_log(lv_log_filename, 'Encountered an Oracle error : '||lv_process_message);
2380:
2381: END post_validation;
2382:
2383: END jai_ar_validate_data_pkg;