DBA Data[Home] [Help]

APPS.ARP_CTLGD_PKG dependencies on ARP_STANDARD

Line 1479: arp_standard.debug('before loop for MRC processing...');

1475: IF (l_count = 0)
1476: THEN RAISE NO_DATA_FOUND;
1477: END IF;
1478:
1479: arp_standard.debug('before loop for MRC processing...');
1480: FOR I in gl_dist_array.FIRST .. gl_dist_array.LAST LOOP
1481: /*-----------------------------------------------------+
1482: | call mrc engine to update RA_CUST_TRX_LINES_GL_DIST |
1483: +-----------------------------------------------------*/

Line 1484: arp_standard.debug('before calling maintain_mrc ');

1480: FOR I in gl_dist_array.FIRST .. gl_dist_array.LAST LOOP
1481: /*-----------------------------------------------------+
1482: | call mrc engine to update RA_CUST_TRX_LINES_GL_DIST |
1483: +-----------------------------------------------------*/
1484: arp_standard.debug('before calling maintain_mrc ');
1485: arp_standard.debug('gl dist array('||to_char(I) || ') = ' || to_char(gl_dist_array(I)));
1486:
1487: ar_mrc_engine.maintain_mrc_data(
1488: p_event_mode => 'UPDATE',

Line 1485: arp_standard.debug('gl dist array('||to_char(I) || ') = ' || to_char(gl_dist_array(I)));

1481: /*-----------------------------------------------------+
1482: | call mrc engine to update RA_CUST_TRX_LINES_GL_DIST |
1483: +-----------------------------------------------------*/
1484: arp_standard.debug('before calling maintain_mrc ');
1485: arp_standard.debug('gl dist array('||to_char(I) || ') = ' || to_char(gl_dist_array(I)));
1486:
1487: ar_mrc_engine.maintain_mrc_data(
1488: p_event_mode => 'UPDATE',
1489: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',

Line 2803: arp_standard.debug('calling mrc engine for insertion of gl dist data');

2799: RAISE NO_DATA_FOUND;
2800: END IF;
2801:
2802: /* call mrc api to delete */
2803: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2804: ar_mrc_engine.maintain_mrc_data(
2805: p_event_mode => 'DELETE',
2806: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2807: p_mode => 'SINGLE',

Line 2874: arp_standard.debug('calling mrc engine for insertion of gl dist data');

2870: AND account_class = nvl(p_account_class, account_class)
2871: RETURNING cust_trx_line_gl_dist_id
2872: BULK COLLECT INTO l_gl_dist_key_value_list;
2873:
2874: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2875: ar_mrc_engine.maintain_mrc_data(
2876: p_event_mode => 'DELETE',
2877: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2878: p_mode => 'BATCH',

Line 2946: arp_standard.debug('calling mrc engine for insertion of gl dist data');

2942: AND account_class = nvl(p_account_class, account_class)
2943: RETURNING cust_trx_line_gl_dist_id
2944: BULK COLLECT INTO l_gl_dist_key_value_list;
2945:
2946: arp_standard.debug('calling mrc engine for insertion of gl dist data');
2947: ar_mrc_engine.maintain_mrc_data(
2948: p_event_mode => 'DELETE',
2949: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2950: p_mode => 'BATCH',

Line 3016: arp_standard.debug('calling mrc engine for insertion of gl dist data');

3012: AND account_class = nvl(p_account_class, account_class)
3013: RETURNING cust_trx_line_gl_dist_id
3014: BULK COLLECT INTO l_gl_dist_key_value_list;
3015:
3016: arp_standard.debug('calling mrc engine for insertion of gl dist data');
3017: ar_mrc_engine.maintain_mrc_data(
3018: p_event_mode => 'DELETE',
3019: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3020: p_mode => 'BATCH',

Line 3105: arp_standard.debug('calling mrc engine for insertion of gl dist data');

3101: AND account_class = nvl(p_account_class, account_class)
3102: RETURNING cust_trx_line_gl_dist_id
3103: BULK COLLECT INTO l_gl_dist_key_value_list;
3104:
3105: arp_standard.debug('calling mrc engine for insertion of gl dist data');
3106: ar_mrc_engine.maintain_mrc_data(
3107: p_event_mode => 'DELETE',
3108: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3109: p_mode => 'BATCH',

Line 3544: arp_standard.debug('calling mrc engine for update of gl dist data');

3540: /* Bug 3858542 - Added IF condition to prevent failures in
3541: MRC code when no rows will be updated */
3542: IF (SQL%ROWCOUNT > 0 )
3543: THEN
3544: arp_standard.debug('calling mrc engine for update of gl dist data');
3545: ar_mrc_engine.maintain_mrc_data(
3546: p_event_mode => 'UPDATE',
3547: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3548: p_mode => 'BATCH',

Line 3648: arp_standard.debug('calling mrc engine for update of gl dist data');

3644: BULK COLLECT INTO l_gl_dist_key_value_list;
3645: IF (SQL%ROWCOUNT > 0 ) then
3646: /* Used arp_global.request_id for bug3620556 */
3647: IF arp_global.request_id is NULL then
3648: arp_standard.debug('calling mrc engine for update of gl dist data');
3649: ar_mrc_engine.maintain_mrc_data(
3650: p_event_mode => 'UPDATE',
3651: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3652: p_mode => 'BATCH',

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

3858: pg_login_id), /* last_update_login */
3859: pg_prog_appl_id, /* program_application_id */
3860: pg_conc_program_id, /* program_id */
3861: sysdate, /* program_update_date */
3862: arp_standard.sysparm.org_id, /* SSA changes anuj */
3863: p_dist_rec.rounding_correction_flag
3864: );
3865:
3866: p_cust_trx_line_gl_dist_id := l_cust_trx_line_gl_dist_id;

Line 3868: arp_standard.debug('calling mrc engine for INSERT of gl dist data');

3864: );
3865:
3866: p_cust_trx_line_gl_dist_id := l_cust_trx_line_gl_dist_id;
3867:
3868: arp_standard.debug('calling mrc engine for INSERT of gl dist data');
3869: ar_mrc_engine.maintain_mrc_data(
3870: p_event_mode => 'INSERT',
3871: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3872: p_mode => 'SINGLE',