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 FND_GLOBAL

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 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 236: lv_sql_statement := fnd_global.local_chr(10)||

232: last_updated_by = gn_bug_no
233: WHERE customer_trx_id = p_customer_trx_id
234: AND payment_schedule_id = i.payment_schedule_id;
235:
236: lv_sql_statement := fnd_global.local_chr(10)||
237: 'UPDATE ar_payment_schedules_all
238: SET amount_due_original = '||p_gl_rec_amount||' * '||ln_apportion_ratio||',
239: last_update_date = sysdate,
240: last_updated_by = '||gn_bug_no||'

Line 257: lv_sql_statement := fnd_global.local_chr(10)||

253: last_updated_by = gn_bug_no
254: WHERE customer_trx_id = p_customer_trx_id
255: AND payment_schedule_id = i.payment_schedule_id;
256:
257: lv_sql_statement := fnd_global.local_chr(10)||
258: 'UPDATE ar_payment_schedules_all
259: SET tax_original = '||p_gl_tax_amount||' * '||ln_apportion_ratio||',
260: last_update_date = sysdate,
261: last_updated_by = '||gn_bug_no||'

Line 278: lv_sql_statement := fnd_global.local_chr(10)||

274: last_updated_by = gn_bug_no
275: WHERE customer_trx_id = p_customer_trx_id
276: AND payment_schedule_id = i.payment_schedule_id;
277:
278: lv_sql_statement := fnd_global.local_chr(10)||
279: 'UPDATE ar_payment_schedules_all
280: SET freight_original = '||p_gl_freight_amount||' * '||ln_apportion_ratio||',
281: last_update_date = sysdate,
282: last_updated_by = '||gn_bug_no||'

Line 358: lv_sql_statement := fnd_global.local_chr(10)||

354: AND display = 'Y'
355: AND status = 'APP'
356: AND application_type = 'CM';
357:
358: lv_sql_statement := fnd_global.local_chr(10)||
359: 'UPDATE ar_receivable_applications_all
360: SET amount_applied = '||p_arps_ado||' * '||ln_apportion_ratio||',
361: last_update_date = sysdate,
362: last_updated_by = '||gn_bug_no||'

Line 387: lv_sql_statement := fnd_global.local_chr(10)||

383: AND display = 'Y'
384: AND status = 'APP'
385: AND application_type = 'CM';
386:
387: lv_sql_statement := fnd_global.local_chr(10)||
388: 'UPDATE ar_receivable_applications_all
389: SET tax_applied = '||p_arps_to||' * '||ln_apportion_ratio||',
390: last_update_date = sysdate,
391: last_updated_by = '||gn_bug_no||'

Line 416: lv_sql_statement := fnd_global.local_chr(10)||

412: AND display = 'Y'
413: AND status = 'APP'
414: AND application_type = 'CM';
415:
416: lv_sql_statement := fnd_global.local_chr(10)||
417: 'UPDATE ar_receivable_applications_all
418: SET freight_applied = '||p_arps_fo||' * '||ln_apportion_ratio||',
419: last_update_date = sysdate,
420: last_updated_by = '||gn_bug_no||'

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 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 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 1077: lv_sql_statement := fnd_global.local_chr(10)||

1073: last_updated_by = gn_bug_no
1074: WHERE customer_trx_line_id = i.customer_trx_line_id
1075: AND customer_trx_id = i.customer_trx_id;
1076:
1077: lv_sql_statement := fnd_global.local_chr(10)||
1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||
1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
1081: ' last_updated_by = '||gn_bug_no||fnd_global.local_chr(10)||

Line 1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||

1074: WHERE customer_trx_line_id = i.customer_trx_line_id
1075: AND customer_trx_id = i.customer_trx_id;
1076:
1077: lv_sql_statement := fnd_global.local_chr(10)||
1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||
1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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)||

Line 1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||

1075: AND customer_trx_id = i.customer_trx_id;
1076:
1077: lv_sql_statement := fnd_global.local_chr(10)||
1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||
1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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||';';

Line 1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||

1076:
1077: lv_sql_statement := fnd_global.local_chr(10)||
1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||
1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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:

Line 1081: ' last_updated_by = '||gn_bug_no||fnd_global.local_chr(10)||

1077: lv_sql_statement := fnd_global.local_chr(10)||
1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||
1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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);

Line 1082: 'WHERE customer_trx_line_id = '||i.customer_trx_line_id||fnd_global.local_chr(10)||

1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||
1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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:

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 1142: lv_sql_statement := fnd_global.local_chr(10)||

1138: last_updated_by = gn_bug_no
1139: WHERE customer_trx_line_id = i.customer_trx_line_id
1140: AND customer_trx_id = i.customer_trx_id;
1141:
1142: lv_sql_statement := fnd_global.local_chr(10)||
1143: 'UPDATE ra_cust_trx_line_gl_dist_all'||fnd_global.local_chr(10)||
1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||
1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||

Line 1143: 'UPDATE ra_cust_trx_line_gl_dist_all'||fnd_global.local_chr(10)||

1139: WHERE customer_trx_line_id = i.customer_trx_line_id
1140: AND customer_trx_id = i.customer_trx_id;
1141:
1142: lv_sql_statement := fnd_global.local_chr(10)||
1143: 'UPDATE ra_cust_trx_line_gl_dist_all'||fnd_global.local_chr(10)||
1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||
1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
1147: ' last_updated_by = '||gn_bug_no||fnd_global.local_chr(10)||

Line 1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||

1140: AND customer_trx_id = i.customer_trx_id;
1141:
1142: lv_sql_statement := fnd_global.local_chr(10)||
1143: 'UPDATE ra_cust_trx_line_gl_dist_all'||fnd_global.local_chr(10)||
1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||
1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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)||

Line 1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||

1141:
1142: lv_sql_statement := fnd_global.local_chr(10)||
1143: 'UPDATE ra_cust_trx_line_gl_dist_all'||fnd_global.local_chr(10)||
1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||
1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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||';';

Line 1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||

1142: lv_sql_statement := fnd_global.local_chr(10)||
1143: 'UPDATE ra_cust_trx_line_gl_dist_all'||fnd_global.local_chr(10)||
1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||
1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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:

Line 1147: ' last_updated_by = '||gn_bug_no||fnd_global.local_chr(10)||

1143: 'UPDATE ra_cust_trx_line_gl_dist_all'||fnd_global.local_chr(10)||
1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||
1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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);

Line 1148: 'WHERE customer_trx_line_id = '||i.customer_trx_line_id||fnd_global.local_chr(10)||

1144: 'SET amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1145: ' acctd_amount = round('||i.func_tax_amount||','||ln_precision||'),'||fnd_global.local_chr(10)||
1146: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
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:

Line 1177: lv_sql_statement := fnd_global.local_chr(10)||

1173: WHERE rec.account_class = 'REC'
1174: AND rec.latest_rec_flag = 'Y'
1175: AND customer_trx_id = rec_get_cust_trx.customer_trx_id;
1176:
1177: lv_sql_statement := fnd_global.local_chr(10)||
1178: 'UPDATE ra_cust_trx_line_gl_dist_all rec
1179: SET amount = (SELECT nvl(sum(amount),0)
1180: FROM ra_cust_trx_line_gl_dist_all rev_tax_frt
1181: WHERE rec.customer_trx_id = rev_tax_frt.customer_trx_id

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 1247: lv_sql_statement := fnd_global.local_chr(10)||

1243: last_updated_by = gn_bug_no
1244: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id
1245: AND customer_trx_line_id = rec_gl_dist_rctl.customer_trx_line_id;
1246:
1247: lv_sql_statement := fnd_global.local_chr(10)||
1248: 'UPDATE ra_customer_trx_lines_all
1249: SET extended_amount = '||rec_gl_dist_rctl.amount||',
1250: last_update_date = sysdate,
1251: last_updated_by = '||gn_bug_no||'

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 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 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 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 1483: lv_sql_statement := fnd_global.local_chr(10)||

1479: last_update_date = sysdate,
1480: last_updated_by = gn_bug_no
1481: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id;
1482:
1483: lv_sql_statement := fnd_global.local_chr(10)||
1484: 'UPDATE ar_payment_schedules_all
1485: SET amount_due_remaining = 0,
1486: acctd_amount_due_remaining = 0,
1487: tax_remaining = 0,

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 1539: lv_sql_statement := fnd_global.local_chr(10)||

1535: last_update_date = sysdate,
1536: last_updated_by = gn_bug_no
1537: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id;
1538:
1539: lv_sql_statement := fnd_global.local_chr(10)||
1540: 'UPDATE ar_payment_schedules_all
1541: SET amount_applied = amount_due_original,
1542: last_update_date = sysdate,
1543: last_updated_by = '||gn_bug_no||

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 1640: lv_sql_statement := fnd_global.local_chr(10)||

1636: AND application_type = 'CM'
1637: AND display = 'Y'
1638: AND status = 'APP';
1639:
1640: lv_sql_statement := fnd_global.local_chr(10)||
1641: 'UPDATE ar_receivable_applications_all
1642: SET amount_applied = NVL(line_applied,0) + NVL(tax_applied,0) + NVL(freight_applied,0),
1643: last_update_date = sysdate,
1644: last_updated_by = '||gn_bug_no||'

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 1709: lv_sql_statement := fnd_global.local_chr(10)||

1705: AND application_type = 'CM'
1706: AND display = 'Y'
1707: AND status = 'APP';
1708:
1709: lv_sql_statement := fnd_global.local_chr(10)||
1710: 'UPDATE ar_receivable_applications_all
1711: SET acctd_amount_applied_from = ROUND(amount_applied * '||rec_ra_customer_trx.exchange_rate||','|| ln_precision||'),
1712: last_update_date = sysdate,
1713: last_updated_by = '||gn_bug_no||'

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 1769: lv_sql_statement := fnd_global.local_chr(10)||

1765: AND application_type = 'CM'
1766: AND display = 'Y'
1767: AND status = 'APP';
1768:
1769: lv_sql_statement := fnd_global.local_chr(10)||
1770: 'UPDATE ar_receivable_applications_all
1771: SET acctd_amount_applied_to = ROUND(amount_applied * '||rec_ra_customer_trx_prev.exchange_rate||','|| ln_precision||'),
1772: last_update_date = sysdate,
1773: last_updated_by = '||gn_bug_no||'

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 1879: lv_sql_statement := fnd_global.local_chr(10)||

1875: WHERE
1876: customer_trx_id = rec_get_cust_trx.customer_trx_id;
1877:
1878:
1879: lv_sql_statement := fnd_global.local_chr(10)||
1880: 'UPDATE ar_payment_schedules_all inv_arps
1881: SET tax_remaining = nvl(tax_original,0) - ( SELECT
1882: nvl(sum(tax_applied),0) tot_tax_applied
1883: FROM

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 1980: lv_sql_statement := fnd_global.local_chr(10)||

1976: WHERE
1977: customer_trx_id = rec_get_cust_trx.customer_trx_id;
1978:
1979:
1980: lv_sql_statement := fnd_global.local_chr(10)||
1981: 'UPDATE ar_payment_schedules_all inv_arps
1982: SET amount_credited = (SELECT
1983: (nvl(sum(amount_applied),0) * (-1) )tot_amt_applied
1984: FROM

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 2063: lv_sql_statement := fnd_global.local_chr(10)||

2059: last_updated_by = gn_bug_no
2060: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id
2061: AND payment_schedule_id = rec_payment_schedules.payment_schedule_id;
2062:
2063: lv_sql_statement := fnd_global.local_chr(10)||
2064: 'UPDATE ar_payment_schedules_all
2065: SET acctd_amount_due_remaining = ROUND('||rec_payment_schedules.amount_due_remaining||' * '||rec_payment_schedules.exchange_rate||', '||ln_precision||'),
2066: last_update_date = sysdate,
2067: last_updated_by = '||gn_bug_no||'

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 2132: lv_sql_statement := fnd_global.local_chr(10)||

2128: last_updated_by = gn_bug_no
2129: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id
2130: AND payment_schedule_id = rec_payment_schedules.payment_schedule_id;
2131:
2132: lv_sql_statement := fnd_global.local_chr(10)||
2133: 'UPDATE ar_payment_schedules_all
2134: SET status = DECODE (amount_due_remaining, 0, '||''''||'CL'||''''||', '||''''||'OP'||''''||'),
2135: gl_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('||''''||'31/12/4712'||''''||','||''''||'DD/MM/YYYY'||''''||')) ,
2136: actual_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('||''''||'31/12/4712'||''''||','||''''||'DD/MM/YYYY'||''''||')) ,

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 2205: lv_sql_statement := fnd_global.local_chr(10)||

2201: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id
2202: AND payment_schedule_id = rec_payment_schedules.payment_schedule_id;
2203:
2204:
2205: lv_sql_statement := fnd_global.local_chr(10)||
2206: 'UPDATE ar_payment_schedules_all
2207: SET status = DECODE (amount_due_remaining, 0, '||''''||'CL'||''''||', '||''''||'OP'||''''||'),
2208: gl_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('||''''||'31/12/4712'||''''||','||''''||'DD/MM/YYYY'||''''||')) ,
2209: actual_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('||''''||'31/12/4712'||''''||','||''''||'DD/MM/YYYY'||''''||')) ,

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 2269: lv_sql_statement := fnd_global.local_chr(10)||

2265: last_update_date = sysdate,
2266: last_updated_by = gn_bug_no
2267: WHERE customer_trx_line_id = rec_cur_sync_il_line_tax.customer_trx_line_id;
2268:
2269: lv_sql_statement := fnd_global.local_chr(10)||
2270: 'UPDATE JAI_AR_TRX_LINES
2271: SET tax_amount = '||rec_cur_sync_il_line_tax.tax_amount||' ,
2272: total_amount = line_amount + '||rec_cur_sync_il_line_tax.tax_amount||',
2273: last_update_date = sysdate,

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 2326: lv_sql_statement := fnd_global.local_chr(10)||

2322: last_update_date = sysdate,
2323: last_updated_by = gn_bug_no
2324: WHERE CUSTOMER_TRX_ID = rec_sync_il_hdr_tax.customer_trx_id;
2325:
2326: lv_sql_statement := fnd_global.local_chr(10)||
2327: 'UPDATE JAI_AR_TRXS
2328: SET tax_amount = '||rec_sync_il_hdr_tax.tax_amount||' ,
2329: total_amount = line_amount + '||rec_sync_il_hdr_tax.tax_amount||',
2330: last_update_date = sysdate,

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: