DBA Data[Home] [Help]

APPS.INV_CMERGE_ITEMS dependencies on INV_CMERGE_ITEMS

Line 1: PACKAGE BODY INV_CMERGE_ITEMS as

1: PACKAGE BODY INV_CMERGE_ITEMS as
2: /* $Header: invcmib.pls 120.1 2006/02/22 03:44:24 swshukla noship $ */
3:
4: /*---------------------------- PRIVATE VARIABLES ----------------------------*/
5: g_count NUMBER := 0;

Line 78: arp_message.set_line( 'INV_CMERGE_ITEMS.MERGE()+' );

74: l_last_fetch BOOLEAN := FALSE;
75: l_count NUMBER;
76: BEGIN
77:
78: arp_message.set_line( 'INV_CMERGE_ITEMS.MERGE()+' );
79: /*-----------------------+
80: | MTL_CUSTOMER_ITEMS |
81: +-----------------------*/
82: /* try to lock the table first */

Line 186: arp_message.set_line( 'INV_CMERGE_ITEMS.MERGE()-' );

182: EXIT;
183: END IF;
184: END LOOP;
185: /* Number of rows updates */
186: arp_message.set_line( 'INV_CMERGE_ITEMS.MERGE()-' );
187: arp_message.set_name('AR','AR_ROWS_UPDATED');
188: arp_message.set_token('NUM_ROWS',to_char(l_count));
189: END IF;
190: EXCEPTION

Line 192: arp_message.set_line( 'INV_CMERGE_ITEMS.MERGE');

188: arp_message.set_token('NUM_ROWS',to_char(l_count));
189: END IF;
190: EXCEPTION
191: WHEN OTHERS THEN
192: arp_message.set_line( 'INV_CMERGE_ITEMS.MERGE');
193: arp_message.set_line( substrb(SQLERRM,1,200) );
194: RAISE;
195: END MERGE;
196:

Line 197: end INV_CMERGE_ITEMS;

193: arp_message.set_line( substrb(SQLERRM,1,200) );
194: RAISE;
195: END MERGE;
196:
197: end INV_CMERGE_ITEMS;