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 1547: arp_standard.debug(' old_rec_app.receivable_application_id:'||old_rec_app.receivable_application_id);

1543: RAISE no_app_found;
1544: END IF;
1545: CLOSE cu_posted;
1546:
1547: arp_standard.debug(' old_rec_app.receivable_application_id:'||old_rec_app.receivable_application_id);
1548: arp_standard.debug(' old_rec_app.posting_control_id:'||old_rec_app.posting_control_id);
1549:
1550:
1551: BEGIN

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

1544: END IF;
1545: CLOSE cu_posted;
1546:
1547: arp_standard.debug(' old_rec_app.receivable_application_id:'||old_rec_app.receivable_application_id);
1548: arp_standard.debug(' old_rec_app.posting_control_id:'||old_rec_app.posting_control_id);
1549:
1550:
1551: BEGIN
1552:

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

1782: ----------------------------------------------------------------
1783: IF old_rec_app.posting_control_id = -3 THEN
1784:
1785:
1786: arp_standard.debug('Path Update CM RA and recreate distributions');
1787: arp_standard.debug('1 Delete current RA distributions');
1788:
1789: OPEN del_app(old_rec_app.receivable_application_id);
1790: LOOP

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

1783: IF old_rec_app.posting_control_id = -3 THEN
1784:
1785:
1786: arp_standard.debug('Path Update CM RA and recreate distributions');
1787: arp_standard.debug('1 Delete current RA distributions');
1788:
1789: OPEN del_app(old_rec_app.receivable_application_id);
1790: LOOP
1791: FETCH del_app INTO l_del_app_rec;

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

1792: EXIT WHEN del_app%NOTFOUND;
1793: --
1794: --Release 11.5 VAT changes, delete accounting for Applications
1795: --
1796: arp_standard.debug(' Current distributions exist delete distributions +');
1797: l_ae_doc_rec.document_type := 'CREDIT_MEMO';
1798: l_ae_doc_rec.document_id := l_del_app_rec.trx_id;
1799: l_ae_doc_rec.accounting_entity_level := 'ONE';
1800: l_ae_doc_rec.source_table := 'RA';

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

1805:
1806: l_ae_doc_rec.pay_sched_upd_yn := 'Y';
1807:
1808: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1809: arp_standard.debug(' delete distributions -');
1810:
1811: END LOOP;
1812: CLOSE del_app;
1813:

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

1814:
1815: ----------------------------------------------------------------
1816: -- Update the CM application record to the correct amount
1817: ----------------------------------------------------------------
1818: arp_standard.debug('Update the CM app ra_id '|| old_rec_app.receivable_application_id || '+');
1819:
1820: UPDATE ar_receivable_applications ra
1821: SET
1822: acctd_amount_applied_from =

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

1854:
1855: debug( SQL%ROWCOUNT||' row(s) updated', MSG_LEVEL_DEBUG );
1856:
1857:
1858: arp_standard.debug('MRC plugins ');
1859: OPEN get_app_id(old_rec_app.receivable_application_id);
1860: LOOP
1861: FETCH get_app_id INTO l_app_id, l_amount_applied;
1862: EXIT WHEN get_app_id%NOTFOUND;

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

1868: l_amount_applied);
1869: END LOOP;
1870: CLOSE get_app_id;
1871:
1872: arp_standard.debug('End update the CM app ra_id');
1873: ----------------------------------------------------------------
1874: -- Release 11.5, plug in changes recreate the accounting for the
1875: -- updated CM once parent records have been updated.Only one APP
1876: -- for the credit memo should get updated in previous statement.

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

1874: -- Release 11.5, plug in changes recreate the accounting for the
1875: -- updated CM once parent records have been updated.Only one APP
1876: -- for the credit memo should get updated in previous statement.
1877: ----------------------------------------------------------------
1878: arp_standard.debug('Creation of new distributions');
1879: OPEN cre_app(old_rec_app.receivable_application_id);
1880: LOOP
1881: FETCH cre_app INTO l_cre_app_rec;
1882: EXIT WHEN cre_app%NOTFOUND;

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

1882: EXIT WHEN cre_app%NOTFOUND;
1883: --
1884: --Release 11.5 VAT changes, recreate accounting for Applications
1885: --
1886: arp_standard.debug(' recreate distributions +:'||l_cre_app_rec.app_id);
1887: l_ae_doc_rec.document_type := 'CREDIT_MEMO';
1888: l_ae_doc_rec.document_id := l_cre_app_rec.trx_id;
1889: l_ae_doc_rec.accounting_entity_level := 'ONE';
1890: l_ae_doc_rec.source_table := 'RA';

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

1901: arp_balance_check.CHECK_APPLN_BALANCE(l_cre_app_rec.app_id,
1902: NULL,
1903: 'N');
1904:
1905: arp_standard.debug(' recreate distributions -');
1906: END LOOP;
1907: CLOSE cre_app;
1908: arp_standard.debug('End Path Update CM RA and recreate distributions');
1909:

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

1904:
1905: arp_standard.debug(' recreate distributions -');
1906: END LOOP;
1907: CLOSE cre_app;
1908: arp_standard.debug('End Path Update CM RA and recreate distributions');
1909:
1910: ELSE
1911:
1912: arp_standard.debug('Path Reverse CM RA and create new CM RA');

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

1908: arp_standard.debug('End Path Update CM RA and recreate distributions');
1909:
1910: ELSE
1911:
1912: arp_standard.debug('Path Reverse CM RA and create new CM RA');
1913: --BUG#5324129
1914: -- Insert RA to reverse the posted one
1915: ins_ra_rec := old_rec_app;
1916: ins_ra_rec.acctd_amount_applied_from := -1 * old_rec_app.acctd_amount_applied_from;

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

1975: ins_ra_rec.application_rule := 'CREDIT MEMO REVERSAL';
1976: ins_ra_rec.receivable_application_id := NULL;
1977:
1978: arp_app_pkg.insert_p( ins_ra_rec, l_ra_id );
1979: arp_standard.debug('Reverse application inserted ra_id :'||l_ra_id);
1980:
1981: --Update the reversal app record reversal_gl_date
1982: UPDATE ar_receivable_applications
1983: SET reversal_gl_date = TRUNC(SYSDATE),

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

1983: SET reversal_gl_date = TRUNC(SYSDATE),
1984: display = 'N'
1985: WHERE receivable_application_id = old_rec_app.receivable_application_id;
1986:
1987: arp_standard.debug('The old ra record '|| old_rec_app.receivable_application_id ||' reversal_gl_date updated ');
1988:
1989: -- MRC cm app record inserted
1990: -- need to call mrc engine to process rec apps row
1991: arp_standard.debug('Plugin MRC call for ra reversal ');

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

1987: arp_standard.debug('The old ra record '|| old_rec_app.receivable_application_id ||' reversal_gl_date updated ');
1988:
1989: -- MRC cm app record inserted
1990: -- need to call mrc engine to process rec apps row
1991: arp_standard.debug('Plugin MRC call for ra reversal ');
1992: ar_mrc_engine3.reversal_insert_oppos_ra_recs(
1993: ins_ra_rec,
1994: old_rec_app.receivable_application_id,
1995: l_ra_id);

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

1995: l_ra_id);
1996: -----------------
1997: -- Create reversal distributions
1998: -----------------
1999: arp_standard.debug('create the distribution for reversal app :'||l_ra_id);
2000: l_ae_doc_rec.source_table := 'RA';
2001: l_ae_doc_rec.accounting_entity_level := 'ONE';
2002: l_ae_doc_rec.other_flag := 'REVERSE';
2003: l_ae_doc_rec.source_id_old := old_rec_app.receivable_application_id;

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

2013:
2014: ----------------------------------------------------------------
2015: -- create the new CM application record to the correct amount
2016: ----------------------------------------------------------------
2017: arp_standard.debug('create the new CM APP record ');
2018:
2019: ins_ra_rec := old_rec_app;
2020: IF l_foreign_transaction = 'N' THEN
2021: ins_ra_rec.acctd_amount_applied_from := -( p_control.line_amount +

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

2050: ins_ra_rec.display := 'Y';
2051: ins_ra_rec.receivable_application_id := NULL;
2052:
2053: arp_app_pkg.insert_p( ins_ra_rec, l_ra_id );
2054: arp_standard.debug('CM APP record created :'||l_ra_id);
2055:
2056:
2057: arp_standard.debug('MRC plugin call for the app record '||l_ra_id);
2058: ar_mrc_engine3.cm_application(

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

2053: arp_app_pkg.insert_p( ins_ra_rec, l_ra_id );
2054: arp_standard.debug('CM APP record created :'||l_ra_id);
2055:
2056:
2057: arp_standard.debug('MRC plugin call for the app record '||l_ra_id);
2058: ar_mrc_engine3.cm_application(
2059: p_cm_ps_id => old_rec_app.payment_schedule_id,
2060: p_invoice_ps_id => old_rec_app.applied_payment_schedule_id,
2061: p_inv_ra_rec => ins_ra_rec,

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

2060: p_invoice_ps_id => old_rec_app.applied_payment_schedule_id,
2061: p_inv_ra_rec => ins_ra_rec,
2062: p_ra_id => l_ra_id);
2063:
2064: arp_standard.debug('Create the distributions for '||l_ra_id);
2065: -- Create the distributions
2066: l_ae_doc_rec.document_id := ins_ra_rec.customer_trx_id;
2067: l_ae_doc_rec.accounting_entity_level := 'ONE';
2068: l_ae_doc_rec.source_table := 'RA';

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

2080: END IF;
2081:
2082: EXCEPTION
2083: WHEN no_app_found THEN
2084: arp_standard.debug('No app found');
2085: WHEN OTHERS THEN
2086: debug( 'EXCEPTION: Error executing update stmt #2',
2087: MSG_LEVEL_BASIC );
2088: RAISE;

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

2409: 'Y', to_number(nvl(l_new_adj_acctd_amount, 0))),
2410: to_char(ar_adjustment_number_s.nextval),
2411: 'ARAPSI',
2412: -3
2413: ,arp_standard.sysparm.org_id /* SSA changes anuj */
2414: FROM
2415: ar_adjustments adj2,
2416: ar_receivable_applications ra,
2417: ra_customer_trx ct

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

3326:
3327: END IF;
3328:
3329: -- arabcm: update inv ps (reverse cm effect)
3330: arp_standard.debug(' reverse_cm_effect+');
3331: reverse_cm_effect(
3332: system_info,
3333: profile_info,
3334: l_control_rec.customer_trx_id );

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

3331: reverse_cm_effect(
3332: system_info,
3333: profile_info,
3334: l_control_rec.customer_trx_id );
3335: arp_standard.debug(' reverse_cm_effect-');
3336:
3337: -- aradra: delete cm app recs
3338: arp_standard.debug(' delete_applications+');
3339: delete_applications( l_control_rec.customer_trx_id );

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

3334: l_control_rec.customer_trx_id );
3335: arp_standard.debug(' reverse_cm_effect-');
3336:
3337: -- aradra: delete cm app recs
3338: arp_standard.debug(' delete_applications+');
3339: delete_applications( l_control_rec.customer_trx_id );
3340: arp_standard.debug(' delete_applications-');
3341: -- aradps: delete cm ps
3342: arp_standard.debug(' delete_payment_schedule+');

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

3336:
3337: -- aradra: delete cm app recs
3338: arp_standard.debug(' delete_applications+');
3339: delete_applications( l_control_rec.customer_trx_id );
3340: arp_standard.debug(' delete_applications-');
3341: -- aradps: delete cm ps
3342: arp_standard.debug(' delete_payment_schedule+');
3343: delete_payment_schedule( l_control_rec.customer_trx_id );
3344: arp_standard.debug(' delete_payment_schedule-');

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

3338: arp_standard.debug(' delete_applications+');
3339: delete_applications( l_control_rec.customer_trx_id );
3340: arp_standard.debug(' delete_applications-');
3341: -- aradps: delete cm ps
3342: arp_standard.debug(' delete_payment_schedule+');
3343: delete_payment_schedule( l_control_rec.customer_trx_id );
3344: arp_standard.debug(' delete_payment_schedule-');
3345: END IF;
3346:

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

3340: arp_standard.debug(' delete_applications-');
3341: -- aradps: delete cm ps
3342: arp_standard.debug(' delete_payment_schedule+');
3343: delete_payment_schedule( l_control_rec.customer_trx_id );
3344: arp_standard.debug(' delete_payment_schedule-');
3345: END IF;
3346:
3347: IF( l_control_rec.process_mode in ( I, U ) ) THEN
3348:

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

3352:
3353: ----------------------------------------------------------
3354: -- araiad: create adj, update ps
3355: ----------------------------------------------------------
3356: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');
3357: arp_maintain_ps2.insert_cm_child_adj_private(
3358: system_info,
3359: profile_info,
3360: l_control_rec.customer_trx_id );

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

3357: arp_maintain_ps2.insert_cm_child_adj_private(
3358: system_info,
3359: profile_info,
3360: l_control_rec.customer_trx_id );
3361: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');
3362:
3363:
3364: ----------------------------------------------------------
3365: -- Update adjustments with document number

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

3398:
3399: ----------------------------------------------------------
3400: -- Update adjustments with document number
3401: ----------------------------------------------------------
3402: arp_standard.debug(' update_adj_document_number+');
3403: update_adj_document_number(
3404: system_info,
3405: profile_info,
3406: l_control_rec.customer_trx_id,

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

3407: l_control_rec.initial_customer_trx_id,
3408: l_control_rec.customer_trx_id,
3409: null,
3410: l_doc_where_clause );
3411: arp_standard.debug(' update_adj_document_number-');
3412: END IF;
3413:
3414:
3415:

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

3416:
3417: END IF;
3418:
3419: -- araira: create cm ps, apps
3420: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');
3421: arp_maintain_ps2.insert_cm_ps_private(
3422: system_info,
3423: profile_info,
3424: l_control_rec.customer_trx_id );

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

3421: arp_maintain_ps2.insert_cm_ps_private(
3422: system_info,
3423: profile_info,
3424: l_control_rec.customer_trx_id );
3425: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');
3426:
3427:
3428: END IF;
3429:

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

3455: ELSE
3456: debug( ' non-DEP case', MSG_LEVEL_DEBUG );
3457:
3458: -- araups: correct round error, update inv ps, update cm app
3459: arp_standard.debug(' update_payment_schedule+');
3460: update_payment_schedule(
3461: system_info,
3462: profile_info,
3463: l_control_rec );

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

3460: update_payment_schedule(
3461: system_info,
3462: profile_info,
3463: l_control_rec );
3464: arp_standard.debug(' update_payment_schedule-');
3465:
3466: END IF;
3467:
3468: END IF;