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.ARP_MAINTAIN_PS dependencies on STANDARD

Line 1111: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id;

1107:
1108: l_event_source_info.entity_type_code:= 'ADJUSTMENTS';
1109: l_security.security_id_int_1 := arp_global.sysparam.org_id;
1110: l_event_source_info.application_id := 222;
1111: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id;
1112:
1113: OPEN get_adj_event_id(p_customer_trx_id,p_subsequent_trx_id);
1114: loop
1115: FETCH get_adj_event_id INTO l_event_id,l_source_id_int_1;

Line 1124: print_fcn_label(' arp_standard.sysparm.set_of_books_id='|| arp_standard.sysparm.set_of_books_id );

1120: IF PG_DEBUG in ('Y', 'C') THEN
1121: print_fcn_label(' l_event_id='|| l_event_id );
1122: print_fcn_label(' l_source_id_int_1='|| l_source_id_int_1 );
1123: print_fcn_label(' arp_global.sysparam.org_id='|| arp_global.sysparam.org_id );
1124: print_fcn_label(' arp_standard.sysparm.set_of_books_id='|| arp_standard.sysparm.set_of_books_id );
1125: END IF;
1126: l_event_source_info.source_id_int_1 := l_source_id_int_1;
1127: /* first delete xla record and then delete from adjustment*/
1128: if( l_event_id IS NOT null) then

Line 1595: arp_standard.debug(' old_rec_app.receivable_application_id:'||old_rec_app.receivable_application_id);

1591: RAISE no_app_found;
1592: END IF;
1593: CLOSE cu_posted;
1594:
1595: arp_standard.debug(' old_rec_app.receivable_application_id:'||old_rec_app.receivable_application_id);
1596: arp_standard.debug(' old_rec_app.posting_control_id:'||old_rec_app.posting_control_id);
1597:
1598:
1599: BEGIN

Line 1596: arp_standard.debug(' old_rec_app.posting_control_id:'||old_rec_app.posting_control_id);

1592: END IF;
1593: CLOSE cu_posted;
1594:
1595: arp_standard.debug(' old_rec_app.receivable_application_id:'||old_rec_app.receivable_application_id);
1596: arp_standard.debug(' old_rec_app.posting_control_id:'||old_rec_app.posting_control_id);
1597:
1598:
1599: BEGIN
1600:

Line 1834: arp_standard.debug('Path Update CM RA and recreate distributions');

1830: ----------------------------------------------------------------
1831: IF old_rec_app.posting_control_id = -3 THEN
1832:
1833:
1834: arp_standard.debug('Path Update CM RA and recreate distributions');
1835: arp_standard.debug('1 Delete current RA distributions');
1836:
1837: OPEN del_app(old_rec_app.receivable_application_id);
1838: LOOP

Line 1835: arp_standard.debug('1 Delete current RA distributions');

1831: IF old_rec_app.posting_control_id = -3 THEN
1832:
1833:
1834: arp_standard.debug('Path Update CM RA and recreate distributions');
1835: arp_standard.debug('1 Delete current RA distributions');
1836:
1837: OPEN del_app(old_rec_app.receivable_application_id);
1838: LOOP
1839: FETCH del_app INTO l_del_app_rec;

Line 1844: arp_standard.debug(' Current distributions exist delete distributions +');

1840: EXIT WHEN del_app%NOTFOUND;
1841: --
1842: --Release 11.5 VAT changes, delete accounting for Applications
1843: --
1844: arp_standard.debug(' Current distributions exist delete distributions +');
1845: l_ae_doc_rec.document_type := 'CREDIT_MEMO';
1846: l_ae_doc_rec.document_id := l_del_app_rec.trx_id;
1847: l_ae_doc_rec.accounting_entity_level := 'ONE';
1848: l_ae_doc_rec.source_table := 'RA';

Line 1857: arp_standard.debug(' delete distributions -');

1853:
1854: l_ae_doc_rec.pay_sched_upd_yn := 'Y';
1855:
1856: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1857: arp_standard.debug(' delete distributions -');
1858:
1859: END LOOP;
1860: CLOSE del_app;
1861:

Line 1866: arp_standard.debug('Update the CM app ra_id '|| old_rec_app.receivable_application_id || '+');

1862:
1863: ----------------------------------------------------------------
1864: -- Update the CM application record to the correct amount
1865: ----------------------------------------------------------------
1866: arp_standard.debug('Update the CM app ra_id '|| old_rec_app.receivable_application_id || '+');
1867:
1868: UPDATE ar_receivable_applications ra
1869: SET
1870: acctd_amount_applied_from =

Line 1906: arp_standard.debug('MRC plugins ');

1902:
1903: debug( SQL%ROWCOUNT||' row(s) updated', MSG_LEVEL_DEBUG );
1904:
1905:
1906: arp_standard.debug('MRC plugins ');
1907: OPEN get_app_id(old_rec_app.receivable_application_id);
1908: LOOP
1909: FETCH get_app_id INTO l_app_id, l_amount_applied;
1910: EXIT WHEN get_app_id%NOTFOUND;

Line 1920: arp_standard.debug('End update the CM app ra_id');

1916: l_amount_applied);
1917: END LOOP;
1918: CLOSE get_app_id;
1919:
1920: arp_standard.debug('End update the CM app ra_id');
1921: ----------------------------------------------------------------
1922: -- Release 11.5, plug in changes recreate the accounting for the
1923: -- updated CM once parent records have been updated.Only one APP
1924: -- for the credit memo should get updated in previous statement.

Line 1926: arp_standard.debug('Creation of new distributions');

1922: -- Release 11.5, plug in changes recreate the accounting for the
1923: -- updated CM once parent records have been updated.Only one APP
1924: -- for the credit memo should get updated in previous statement.
1925: ----------------------------------------------------------------
1926: arp_standard.debug('Creation of new distributions');
1927: OPEN cre_app(old_rec_app.receivable_application_id);
1928: LOOP
1929: FETCH cre_app INTO l_cre_app_rec;
1930: EXIT WHEN cre_app%NOTFOUND;

Line 1934: arp_standard.debug(' recreate distributions +:'||l_cre_app_rec.app_id);

1930: EXIT WHEN cre_app%NOTFOUND;
1931: --
1932: --Release 11.5 VAT changes, recreate accounting for Applications
1933: --
1934: arp_standard.debug(' recreate distributions +:'||l_cre_app_rec.app_id);
1935: l_ae_doc_rec.document_type := 'CREDIT_MEMO';
1936: l_ae_doc_rec.document_id := l_cre_app_rec.trx_id;
1937: l_ae_doc_rec.accounting_entity_level := 'ONE';
1938: l_ae_doc_rec.source_table := 'RA';

Line 1953: arp_standard.debug(' recreate distributions -');

1949: arp_balance_check.CHECK_APPLN_BALANCE(l_cre_app_rec.app_id,
1950: NULL,
1951: 'N');
1952:
1953: arp_standard.debug(' recreate distributions -');
1954: END LOOP;
1955: CLOSE cre_app;
1956: arp_standard.debug('End Path Update CM RA and recreate distributions');
1957:

Line 1956: arp_standard.debug('End Path Update CM RA and recreate distributions');

1952:
1953: arp_standard.debug(' recreate distributions -');
1954: END LOOP;
1955: CLOSE cre_app;
1956: arp_standard.debug('End Path Update CM RA and recreate distributions');
1957:
1958: ELSE
1959:
1960: arp_standard.debug('Path Reverse CM RA and create new CM RA');

Line 1960: arp_standard.debug('Path Reverse CM RA and create new CM RA');

1956: arp_standard.debug('End Path Update CM RA and recreate distributions');
1957:
1958: ELSE
1959:
1960: arp_standard.debug('Path Reverse CM RA and create new CM RA');
1961: --BUG#5324129
1962: -- Insert RA to reverse the posted one
1963: ins_ra_rec := old_rec_app;
1964: ins_ra_rec.acctd_amount_applied_from := -1 * old_rec_app.acctd_amount_applied_from;

Line 2027: arp_standard.debug('Reverse application inserted ra_id :'||l_ra_id);

2023: ins_ra_rec.application_rule := 'CREDIT MEMO REVERSAL';
2024: ins_ra_rec.receivable_application_id := NULL;
2025:
2026: arp_app_pkg.insert_p( ins_ra_rec, l_ra_id );
2027: arp_standard.debug('Reverse application inserted ra_id :'||l_ra_id);
2028:
2029: --Update the reversal app record reversal_gl_date
2030: UPDATE ar_receivable_applications
2031: SET reversal_gl_date = TRUNC(SYSDATE),

Line 2035: arp_standard.debug('The old ra record '|| old_rec_app.receivable_application_id ||' reversal_gl_date updated ');

2031: SET reversal_gl_date = TRUNC(SYSDATE),
2032: display = 'N'
2033: WHERE receivable_application_id = old_rec_app.receivable_application_id;
2034:
2035: arp_standard.debug('The old ra record '|| old_rec_app.receivable_application_id ||' reversal_gl_date updated ');
2036:
2037: -- MRC cm app record inserted
2038: -- need to call mrc engine to process rec apps row
2039: arp_standard.debug('Plugin MRC call for ra reversal ');

Line 2039: arp_standard.debug('Plugin MRC call for ra reversal ');

2035: arp_standard.debug('The old ra record '|| old_rec_app.receivable_application_id ||' reversal_gl_date updated ');
2036:
2037: -- MRC cm app record inserted
2038: -- need to call mrc engine to process rec apps row
2039: arp_standard.debug('Plugin MRC call for ra reversal ');
2040: ar_mrc_engine3.reversal_insert_oppos_ra_recs(
2041: ins_ra_rec,
2042: old_rec_app.receivable_application_id,
2043: l_ra_id);

Line 2047: arp_standard.debug('create the distribution for reversal app :'||l_ra_id);

2043: l_ra_id);
2044: -----------------
2045: -- Create reversal distributions
2046: -----------------
2047: arp_standard.debug('create the distribution for reversal app :'||l_ra_id);
2048: l_ae_doc_rec.source_table := 'RA';
2049: l_ae_doc_rec.accounting_entity_level := 'ONE';
2050: l_ae_doc_rec.other_flag := 'REVERSE';
2051: l_ae_doc_rec.source_id_old := old_rec_app.receivable_application_id;

Line 2065: arp_standard.debug('create the new CM APP record ');

2061:
2062: ----------------------------------------------------------------
2063: -- create the new CM application record to the correct amount
2064: ----------------------------------------------------------------
2065: arp_standard.debug('create the new CM APP record ');
2066:
2067: ins_ra_rec := old_rec_app;
2068: IF l_foreign_transaction = 'N' THEN
2069: ins_ra_rec.acctd_amount_applied_from := -( p_control.line_amount +

Line 2102: arp_standard.debug('CM APP record created :'||l_ra_id);

2098: ins_ra_rec.display := 'Y';
2099: ins_ra_rec.receivable_application_id := NULL;
2100:
2101: arp_app_pkg.insert_p( ins_ra_rec, l_ra_id );
2102: arp_standard.debug('CM APP record created :'||l_ra_id);
2103:
2104:
2105: arp_standard.debug('MRC plugin call for the app record '||l_ra_id);
2106: ar_mrc_engine3.cm_application(

Line 2105: arp_standard.debug('MRC plugin call for the app record '||l_ra_id);

2101: arp_app_pkg.insert_p( ins_ra_rec, l_ra_id );
2102: arp_standard.debug('CM APP record created :'||l_ra_id);
2103:
2104:
2105: arp_standard.debug('MRC plugin call for the app record '||l_ra_id);
2106: ar_mrc_engine3.cm_application(
2107: p_cm_ps_id => old_rec_app.payment_schedule_id,
2108: p_invoice_ps_id => old_rec_app.applied_payment_schedule_id,
2109: p_inv_ra_rec => ins_ra_rec,

Line 2112: arp_standard.debug('Create the distributions for '||l_ra_id);

2108: p_invoice_ps_id => old_rec_app.applied_payment_schedule_id,
2109: p_inv_ra_rec => ins_ra_rec,
2110: p_ra_id => l_ra_id);
2111:
2112: arp_standard.debug('Create the distributions for '||l_ra_id);
2113: -- Create the distributions
2114: l_ae_doc_rec.document_id := ins_ra_rec.customer_trx_id;
2115: l_ae_doc_rec.accounting_entity_level := 'ONE';
2116: l_ae_doc_rec.source_table := 'RA';

Line 2132: arp_standard.debug('No app found');

2128: END IF;
2129:
2130: EXCEPTION
2131: WHEN no_app_found THEN
2132: arp_standard.debug('No app found');
2133: WHEN OTHERS THEN
2134: debug( 'EXCEPTION: Error executing update stmt #2',
2135: MSG_LEVEL_BASIC );
2136: RAISE;

Line 2461: ,arp_standard.sysparm.org_id /* SSA changes anuj */

2457: 'Y', to_number(nvl(l_new_adj_acctd_amount, 0))),
2458: to_char(ar_adjustment_number_s.nextval),
2459: 'ARAPSI',
2460: -3
2461: ,arp_standard.sysparm.org_id /* SSA changes anuj */
2462: FROM
2463: ar_adjustments adj2,
2464: ar_receivable_applications ra,
2465: ra_customer_trx ct

Line 3379: arp_standard.debug(' reverse_cm_effect+');

3375:
3376: END IF;
3377:
3378: -- arabcm: update inv ps (reverse cm effect)
3379: arp_standard.debug(' reverse_cm_effect+');
3380: reverse_cm_effect(
3381: system_info,
3382: profile_info,
3383: l_control_rec.customer_trx_id );

Line 3384: arp_standard.debug(' reverse_cm_effect-');

3380: reverse_cm_effect(
3381: system_info,
3382: profile_info,
3383: l_control_rec.customer_trx_id );
3384: arp_standard.debug(' reverse_cm_effect-');
3385:
3386: -- aradra: delete cm app recs
3387: arp_standard.debug(' delete_applications+');
3388: delete_applications( l_control_rec.customer_trx_id );

Line 3387: arp_standard.debug(' delete_applications+');

3383: l_control_rec.customer_trx_id );
3384: arp_standard.debug(' reverse_cm_effect-');
3385:
3386: -- aradra: delete cm app recs
3387: arp_standard.debug(' delete_applications+');
3388: delete_applications( l_control_rec.customer_trx_id );
3389: arp_standard.debug(' delete_applications-');
3390: -- aradps: delete cm ps
3391: arp_standard.debug(' delete_payment_schedule+');

Line 3389: arp_standard.debug(' delete_applications-');

3385:
3386: -- aradra: delete cm app recs
3387: arp_standard.debug(' delete_applications+');
3388: delete_applications( l_control_rec.customer_trx_id );
3389: arp_standard.debug(' delete_applications-');
3390: -- aradps: delete cm ps
3391: arp_standard.debug(' delete_payment_schedule+');
3392: delete_payment_schedule( l_control_rec.customer_trx_id );
3393: arp_standard.debug(' delete_payment_schedule-');

Line 3391: arp_standard.debug(' delete_payment_schedule+');

3387: arp_standard.debug(' delete_applications+');
3388: delete_applications( l_control_rec.customer_trx_id );
3389: arp_standard.debug(' delete_applications-');
3390: -- aradps: delete cm ps
3391: arp_standard.debug(' delete_payment_schedule+');
3392: delete_payment_schedule( l_control_rec.customer_trx_id );
3393: arp_standard.debug(' delete_payment_schedule-');
3394:
3395: /* 11825040 - Clean up line level balances if required */

Line 3393: arp_standard.debug(' delete_payment_schedule-');

3389: arp_standard.debug(' delete_applications-');
3390: -- aradps: delete cm ps
3391: arp_standard.debug(' delete_payment_schedule+');
3392: delete_payment_schedule( l_control_rec.customer_trx_id );
3393: arp_standard.debug(' delete_payment_schedule-');
3394:
3395: /* 11825040 - Clean up line level balances if required */
3396: arp_standard.debug(' clean up line level balances');
3397: select count(*)

Line 3396: arp_standard.debug(' clean up line level balances');

3392: delete_payment_schedule( l_control_rec.customer_trx_id );
3393: arp_standard.debug(' delete_payment_schedule-');
3394:
3395: /* 11825040 - Clean up line level balances if required */
3396: arp_standard.debug(' clean up line level balances');
3397: select count(*)
3398: into l_llca_count
3399: from ra_customer_trx_lines
3400: where customer_trx_id = l_control_rec.previous_customer_trx_id

Line 3422: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');

3418:
3419: ----------------------------------------------------------
3420: -- araiad: create adj, update ps
3421: ----------------------------------------------------------
3422: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');
3423: arp_maintain_ps2.insert_cm_child_adj_private(
3424: system_info,
3425: profile_info,
3426: l_control_rec.customer_trx_id );

Line 3427: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');

3423: arp_maintain_ps2.insert_cm_child_adj_private(
3424: system_info,
3425: profile_info,
3426: l_control_rec.customer_trx_id );
3427: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');
3428:
3429:
3430: ----------------------------------------------------------
3431: -- Update adjustments with document number

Line 3468: arp_standard.debug(' update_adj_document_number+');

3464:
3465: ----------------------------------------------------------
3466: -- Update adjustments with document number
3467: ----------------------------------------------------------
3468: arp_standard.debug(' update_adj_document_number+');
3469: update_adj_document_number(
3470: system_info,
3471: profile_info,
3472: l_control_rec.customer_trx_id,

Line 3477: arp_standard.debug(' update_adj_document_number-');

3473: l_control_rec.initial_customer_trx_id,
3474: l_control_rec.customer_trx_id,
3475: null,
3476: l_doc_where_clause );
3477: arp_standard.debug(' update_adj_document_number-');
3478: END IF;
3479:
3480:
3481:

Line 3486: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');

3482:
3483: END IF;
3484:
3485: -- araira: create cm ps, apps
3486: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');
3487: arp_maintain_ps2.insert_cm_ps_private(
3488: system_info,
3489: profile_info,
3490: l_control_rec.customer_trx_id );

Line 3491: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');

3487: arp_maintain_ps2.insert_cm_ps_private(
3488: system_info,
3489: profile_info,
3490: l_control_rec.customer_trx_id );
3491: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');
3492:
3493:
3494: END IF;
3495:

Line 3525: arp_standard.debug(' update_payment_schedule+');

3521: ELSE
3522: debug( ' non-DEP case', MSG_LEVEL_DEBUG );
3523:
3524: -- araups: correct round error, update inv ps, update cm app
3525: arp_standard.debug(' update_payment_schedule+');
3526: update_payment_schedule(
3527: system_info,
3528: profile_info,
3529: l_control_rec );

Line 3530: arp_standard.debug(' update_payment_schedule-');

3526: update_payment_schedule(
3527: system_info,
3528: profile_info,
3529: l_control_rec );
3530: arp_standard.debug(' update_payment_schedule-');
3531:
3532: END IF;
3533:
3534: END IF;