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.OE_CUST_MERGE dependencies on OE_DEBUG_PUB

Line 5699: oe_debug_pub.add('ER 3095805 Updating Bill To Site 1');

5695:
5696: /* site level update */
5697: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5698: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5699: oe_debug_pub.add('ER 3095805 Updating Bill To Site 1');
5700:
5701: UPDATE OE_HOLD_SOURCES a
5702: set (hold_entity_id) = (select distinct to_char(m.customer_site_id) --Bug 8866783
5703: from ra_customer_merges m

Line 5722: oe_debug_pub.add('ER 3095805 After Updating Bill To Site '||g_count);

5718: and hold_entity_code = 'B'
5719: RETURNING hold_id,hold_entity_id,hold_release_id, released_flag --ER 3095805
5720: BULK COLLECT INTO l_hold_id,l_hold_entity_id, l_hold_release_id, l_released_flag; --ER 3095805
5721: g_count := sql%rowcount;
5722: oe_debug_pub.add('ER 3095805 After Updating Bill To Site '||g_count);
5723: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
5724: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5725:
5726:

Line 5770: oe_debug_pub.add('ER 3095805 Updating Acc');

5766:
5767: /* customer level update */
5768: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5769: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5770: oe_debug_pub.add('ER 3095805 Updating Acc');
5771:
5772: UPDATE OE_HOLD_SOURCES a
5773: set hold_entity_id = (select distinct to_char(m.customer_id) --Bug 8866783
5774: from ra_customer_merges m

Line 5793: oe_debug_pub.add('ER 3095805 After Updating Acc '||g_count);

5789: RETURNING hold_id,hold_entity_id,hold_release_id, released_flag --ER 3095805
5790: BULK COLLECT INTO l_hold_id1,l_hold_entity_id1, l_hold_release_id1, l_released_flag1; --ER 3095805
5791:
5792: g_count := sql%rowcount;
5793: oe_debug_pub.add('ER 3095805 After Updating Acc '||g_count);
5794: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
5795: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5796:
5797: END IF;

Line 8522: oe_debug_pub.add('when others oe_cust_merge.update_dbi_log'||SQLERRM||

8518: arp_message.set_line(' End Update DBI');
8519:
8520: EXCEPTION
8521: WHEN OTHERS THEN
8522: oe_debug_pub.add('when others oe_cust_merge.update_dbi_log'||SQLERRM||
8523: SQLCODE);
8524:
8525: END oe_update_dbi_log;
8526:

Line 8531: oe_debug_pub.add('IN Procedure OE_Update_Credit_Hold_Flag');

8527: --ER 3095805 Start
8528: Procedure OE_Update_Credit_Hold_Flag IS
8529: BEGIN
8530:
8531: oe_debug_pub.add('IN Procedure OE_Update_Credit_Hold_Flag');
8532: oe_debug_pub.add(' Count of Bill To Site '||l_hold_entity_id.Count);
8533: oe_debug_pub.add(' Count of Cust Account '||l_hold_entity_id1.count);
8534:
8535: --For Bill To Site

Line 8532: oe_debug_pub.add(' Count of Bill To Site '||l_hold_entity_id.Count);

8528: Procedure OE_Update_Credit_Hold_Flag IS
8529: BEGIN
8530:
8531: oe_debug_pub.add('IN Procedure OE_Update_Credit_Hold_Flag');
8532: oe_debug_pub.add(' Count of Bill To Site '||l_hold_entity_id.Count);
8533: oe_debug_pub.add(' Count of Cust Account '||l_hold_entity_id1.count);
8534:
8535: --For Bill To Site
8536:

Line 8533: oe_debug_pub.add(' Count of Cust Account '||l_hold_entity_id1.count);

8529: BEGIN
8530:
8531: oe_debug_pub.add('IN Procedure OE_Update_Credit_Hold_Flag');
8532: oe_debug_pub.add(' Count of Bill To Site '||l_hold_entity_id.Count);
8533: oe_debug_pub.add(' Count of Cust Account '||l_hold_entity_id1.count);
8534:
8535: --For Bill To Site
8536:
8537: IF l_hold_entity_id.count > 0 THEN