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 AR_PAYMENT_SCHEDULES_ALL

Line 136: PROCEDURE calc_term_apportion_ratio(p_invoice_type IN ar_payment_schedules_all.class%TYPE,

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,
137: p_term_id IN ar_payment_schedules_all.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules_all.terms_sequence_number%TYPE,
139: p_apportion_ratio OUT NOCOPY NUMBER,
140: p_first_installment_code OUT NOCOPY ra_terms.first_installment_code%TYPE,

Line 137: p_term_id IN ar_payment_schedules_all.term_id%TYPE,

133:
134: END display_error_summary;
135:
136: PROCEDURE calc_term_apportion_ratio(p_invoice_type IN ar_payment_schedules_all.class%TYPE,
137: p_term_id IN ar_payment_schedules_all.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules_all.terms_sequence_number%TYPE,
139: p_apportion_ratio OUT NOCOPY NUMBER,
140: p_first_installment_code OUT NOCOPY ra_terms.first_installment_code%TYPE,
141: p_process_status OUT NOCOPY VARCHAR2,

Line 138: p_terms_sequence_number IN ar_payment_schedules_all.terms_sequence_number%TYPE,

134: END display_error_summary;
135:
136: PROCEDURE calc_term_apportion_ratio(p_invoice_type IN ar_payment_schedules_all.class%TYPE,
137: p_term_id IN ar_payment_schedules_all.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules_all.terms_sequence_number%TYPE,
139: p_apportion_ratio OUT NOCOPY NUMBER,
140: p_first_installment_code OUT NOCOPY ra_terms.first_installment_code%TYPE,
141: p_process_status OUT NOCOPY VARCHAR2,
142: p_process_message OUT NOCOPY VARCHAR2

Line 184: p_customer_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,

180: p_process_message := SUBSTR(SQLERRM,1,300);
181: END calc_term_apportion_ratio;
182:
183: PROCEDURE rectify_ar_pay_sch(
184: p_customer_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
185: p_gl_rec_amount IN NUMBER DEFAULT NULL,
186: p_gl_tax_amount IN NUMBER DEFAULT NULL,
187: p_gl_freight_amount IN NUMBER DEFAULT NULL,
188: p_datafix_filename IN VARCHAR2,

Line 203: FROM ar_payment_schedules_all

199: p_process_status := jai_constants.successful;
200: p_process_message := NULL;
201:
202: FOR i IN( SELECT *
203: FROM ar_payment_schedules_all
204: WHERE customer_trx_id = p_customer_trx_id
205: ORDER BY payment_schedule_id)
206: LOOP
207:

Line 229: UPDATE ar_payment_schedules_all

225: END IF;
226:
227: IF p_gl_rec_amount IS NOT NULL THEN
228:
229: UPDATE ar_payment_schedules_all
230: SET amount_due_original = p_gl_rec_amount * ln_apportion_ratio,
231: last_update_date = sysdate,
232: last_updated_by = gn_bug_no
233: WHERE customer_trx_id = p_customer_trx_id

Line 237: 'UPDATE ar_payment_schedules_all

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||'
241: WHERE customer_trx_id = '||p_customer_trx_id||'

Line 250: UPDATE ar_payment_schedules_all

246: lv_sql_statement := NULL;
247:
248: ELSIF p_gl_tax_amount IS NOT NULL THEN
249:
250: UPDATE ar_payment_schedules_all
251: SET tax_original = p_gl_tax_amount * ln_apportion_ratio,
252: last_update_date = sysdate,
253: last_updated_by = gn_bug_no
254: WHERE customer_trx_id = p_customer_trx_id

Line 258: 'UPDATE ar_payment_schedules_all

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||'
262: WHERE customer_trx_id = '||p_customer_trx_id||'

Line 271: UPDATE ar_payment_schedules_all

267: lv_sql_statement := NULL;
268:
269: ELSIF p_gl_freight_amount IS NOT NULL THEN
270:
271: UPDATE ar_payment_schedules_all
272: SET freight_original = p_gl_freight_amount * ln_apportion_ratio,
273: last_update_date = sysdate,
274: last_updated_by = gn_bug_no
275: WHERE customer_trx_id = p_customer_trx_id

Line 279: 'UPDATE ar_payment_schedules_all

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||'
283: WHERE customer_trx_id = '||p_customer_trx_id||'

Line 305: p_customer_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,

301: p_process_message := SUBSTR(SQLERRM,1,300);
302: END rectify_ar_pay_sch;
303:
304: PROCEDURE rectify_ar_rec_appl(
305: p_customer_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
306: p_previous_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
307: p_arps_ado IN NUMBER DEFAULT NULL,
308: p_arps_to IN NUMBER DEFAULT NULL,
309: p_arps_fo IN NUMBER DEFAULT NULL,

Line 306: p_previous_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,

302: END rectify_ar_pay_sch;
303:
304: PROCEDURE rectify_ar_rec_appl(
305: p_customer_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
306: p_previous_trx_id IN ar_payment_schedules_all.customer_trx_id%TYPE,
307: p_arps_ado IN NUMBER DEFAULT NULL,
308: p_arps_to IN NUMBER DEFAULT NULL,
309: p_arps_fo IN NUMBER DEFAULT NULL,
310: p_datafix_filename IN VARCHAR2,

Line 325: FROM ar_payment_schedules_all

321: p_process_status := jai_constants.successful;
322: p_process_message := NULL;
323:
324: FOR i IN( SELECT *
325: FROM ar_payment_schedules_all
326: WHERE customer_trx_id = p_previous_trx_id
327: ORDER BY payment_schedule_id)
328: LOOP
329:

Line 624: FROM ar_payment_schedules_all

620: NVL(SUM(amount_line_items_original),0) amount_line_items_original,
621: NVL(SUM(amount_line_items_remaining),0) amount_line_items_remaining,
622: NVL(SUM(acctd_amount_due_remaining),0) acctd_amount_due_remaining,
623: NVL(SUM( NVL(amount_due_remaining,0) * NVL(exchange_rate,1) ),0) acctd_amount_due_remain_calc
624: FROM ar_payment_schedules_all
625: WHERE customer_trx_id = cp_customer_trx_id;
626:
627: CURSOR cur_payment_schedules(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
628: IS

Line 635: FROM ar_payment_schedules_all

631: NVL(amount_due_remaining,0) amount_due_remaining,
632: NVL(acctd_amount_due_remaining,0) acctd_amount_due_remaining,
633: payment_schedule_id,
634: exchange_rate
635: FROM ar_payment_schedules_all
636: WHERE customer_trx_id = cp_customer_trx_id;
637:
638: CURSOR cur_tot_cust_trx_gl_dist(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
639: cp_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE)

Line 1265: --To check if ADO in ar_payment_schedules_all is equal to amount of REC in ra_cust_trx_line_gl_dist_all

1261: END IF;
1262: END IF;
1263:
1264: ln_err_num := 3;
1265: --To check if ADO in ar_payment_schedules_all is equal to amount of REC in ra_cust_trx_line_gl_dist_all
1266: IF lt_error_table(ln_err_num).enable = 'Y' THEN
1267: IF rec_tot_payment_schedule.amount_due_original <> rec_tot_cust_trx_gl_dist_rec.amount THEN
1268: lv_process_status := jai_constants.expected_error;
1269: lv_process_message := lt_error_table(ln_err_num).error_description;

Line 1304: --To check if TO in ar_payment_schedules_all is equal to amount of TAX in ra_cust_trx_line_gl_dist_all

1300: END IF;
1301: END IF;
1302:
1303: ln_err_num := 4;
1304: --To check if TO in ar_payment_schedules_all is equal to amount of TAX in ra_cust_trx_line_gl_dist_all
1305: IF lt_error_table(ln_err_num).enable = 'Y' THEN
1306: IF rec_tot_payment_schedule.tax_original <> rec_tot_cust_trx_gl_dist_tax.amount THEN
1307: lv_process_status := jai_constants.expected_error;
1308: lv_process_message := lt_error_table(ln_err_num).error_description;

Line 1343: --To check if FO in ar_payment_schedules_all is equal to amount of FREIGHT in ra_cust_trx_line_gl_dist_all

1339: END IF;
1340: END IF;
1341:
1342: ln_err_num := 5;
1343: --To check if FO in ar_payment_schedules_all is equal to amount of FREIGHT in ra_cust_trx_line_gl_dist_all
1344: IF lt_error_table(ln_err_num).enable = 'Y' THEN
1345: IF rec_tot_payment_schedule.freight_original <> rec_tot_cust_trx_gl_dist_frt.amount THEN
1346: lv_process_status := jai_constants.expected_error;
1347: lv_process_message := lt_error_table(ln_err_num).error_description;

Line 1382: --To Check if ADO = ALIO + TO + FO in ar_payment_schedules_all

1378: END IF;
1379: END IF;
1380:
1381: ln_err_num := 6;
1382: --To Check if ADO = ALIO + TO + FO in ar_payment_schedules_all
1383: IF lt_error_table(ln_err_num).enable = 'Y' THEN
1384: IF rec_tot_payment_schedule.amount_due_original <> ( rec_tot_payment_schedule.amount_line_items_original
1385: + rec_tot_payment_schedule.tax_original
1386: + rec_tot_payment_schedule.freight_original)

Line 1408: --To Check if ADR = ALIR + TR + FR in ar_payment_schedules_all

1404: END IF;
1405: END IF;
1406:
1407: ln_err_num := 7;
1408: --To Check if ADR = ALIR + TR + FR in ar_payment_schedules_all
1409: IF lt_error_table(ln_err_num).enable = 'Y' THEN
1410: IF rec_tot_payment_schedule.amount_due_remaining <> ( rec_tot_payment_schedule.amount_line_items_remaining
1411: + rec_tot_payment_schedule.tax_remaining
1412: + rec_tot_payment_schedule.freight_remaining)

Line 1474: UPDATE ar_payment_schedules_all

1470: END IF;
1471:
1472: ln_error_cnt := 1;
1473:
1474: UPDATE ar_payment_schedules_all
1475: SET amount_due_remaining = 0,
1476: acctd_amount_due_remaining = 0,
1477: tax_remaining = 0,
1478: freight_remaining = 0,

Line 1484: 'UPDATE ar_payment_schedules_all

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,
1488: freight_remaining = 0,

Line 1533: UPDATE ar_payment_schedules_all

1529: END IF;
1530:
1531: ln_error_cnt := 1;
1532:
1533: UPDATE ar_payment_schedules_all
1534: SET amount_applied = amount_due_original,
1535: last_update_date = sysdate,
1536: last_updated_by = gn_bug_no
1537: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id;

Line 1540: 'UPDATE ar_payment_schedules_all

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||
1544: ' WHERE customer_trx_id = '|| rec_get_cust_trx.customer_trx_id||';';

Line 1842: UPDATE ar_payment_schedules_all inv_arps

1838: END IF;
1839:
1840: ln_error_cnt := 1;
1841:
1842: UPDATE ar_payment_schedules_all inv_arps
1843: SET tax_remaining = nvl(tax_original,0) - ( SELECT
1844: nvl(sum(tax_applied),0) tot_tax_applied
1845: FROM
1846: ar_receivable_applications_all reca

Line 1880: 'UPDATE ar_payment_schedules_all inv_arps

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
1884: ar_receivable_applications_all reca

Line 1962: UPDATE ar_payment_schedules_all inv_arps

1958: END IF;
1959:
1960: ln_error_cnt := 1;
1961:
1962: UPDATE ar_payment_schedules_all inv_arps
1963: SET amount_credited = (SELECT
1964: (nvl(sum(amount_applied),0) * (-1) )tot_amt_applied
1965: FROM
1966: ar_receivable_applications_all reca

Line 1981: 'UPDATE ar_payment_schedules_all inv_arps

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
1985: ar_receivable_applications_all reca

Line 2023: --To check if AADR = ADR * exchange_rate in ar_payment_schedules_all

2019: CLOSE jai_ar_validate_data_pkg.cur_curr_precision;
2020:
2021: ln_local_cnt := 0;
2022: ln_err_num := 8;
2023: --To check if AADR = ADR * exchange_rate in ar_payment_schedules_all
2024: IF lt_error_table(ln_err_num).enable = 'Y' THEN
2025: FOR rec_payment_schedules IN cur_payment_schedules(rec_get_cust_trx.customer_trx_id)
2026: LOOP
2027: IF ROUND(rec_payment_schedules.acctd_amount_due_remaining)

Line 2056: UPDATE ar_payment_schedules_all

2052: END IF;
2053:
2054: ln_error_cnt := 1;
2055:
2056: UPDATE ar_payment_schedules_all
2057: SET acctd_amount_due_remaining = ROUND(rec_payment_schedules.amount_due_remaining * rec_payment_schedules.exchange_rate, ln_precision),
2058: last_update_date = sysdate,
2059: last_updated_by = gn_bug_no
2060: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id

Line 2064: 'UPDATE ar_payment_schedules_all

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||'
2068: WHERE customer_trx_id = '||rec_get_cust_trx.customer_trx_id||'

Line 2123: UPDATE ar_payment_schedules_all

2119:
2120: ln_error_cnt := 1;
2121:
2122:
2123: UPDATE ar_payment_schedules_all
2124: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),
2125: gl_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/YYYY')) ,
2126: actual_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/YYYY')),
2127: last_update_date = sysdate,

Line 2133: 'UPDATE ar_payment_schedules_all

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'||''''||')) ,
2137: last_update_date = sysdate,

Line 2195: UPDATE ar_payment_schedules_all

2191: END IF;
2192:
2193: ln_error_cnt := 1;
2194:
2195: UPDATE ar_payment_schedules_all
2196: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),
2197: gl_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/YYYY')) ,
2198: actual_date_closed = DECODE (amount_due_remaining, 0, SYSDATE, TO_DATE('31/12/4712','DD/MM/YYYY')),
2199: last_update_date = sysdate,

Line 2206: 'UPDATE ar_payment_schedules_all

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'||''''||')) ,
2210: last_update_date = sysdate,