APPS.OEP_CMERGE_OESET dependencies on ARP_MESSAGE

Line 34: arp_message.set_line( 'OEP_CMERGE_OESET.OE_AG()+' );

30: for update nowait;
31:
32: BEGIN
33:
34: arp_message.set_line( 'OEP_CMERGE_OESET.OE_AG()+' );
35:
36: /*-----------------------------+
37: | SO_AGREEMENTS |
38: +-----------------------------*/

Line 43: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

39: /* both customer and site level */
40:
41: IF( process_mode = 'LOCK' ) THEN
42:
43: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
44: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
45:
46: open c1;
47: close c1;

Line 44: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );

40:
41: IF( process_mode = 'LOCK' ) THEN
42:
43: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
44: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
45:
46: open c1;
47: close c1;
48:

Line 56: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

52: ELSE
53:
54:
55: /* site level update */
56: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
57: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
58:
59: UPDATE SO_AGREEMENTS a
60: set (invoice_to_site_use_id) = (select distinct m.customer_site_id

Line 57: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );

53:
54:
55: /* site level update */
56: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
57: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
58:
59: UPDATE SO_AGREEMENTS a
60: set (invoice_to_site_use_id) = (select distinct m.customer_site_id
61: from ra_customer_merges m

Line 78: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

74: and m.set_number = set_num);
75:
76: g_count := sql%rowcount;
77:
78: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
79: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
80:
81: /* customer level update */
82: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line 79: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

75:
76: g_count := sql%rowcount;
77:
78: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
79: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
80:
81: /* customer level update */
82: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );

Line 82: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

78: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
79: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
80:
81: /* customer level update */
82: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
84:
85: UPDATE SO_AGREEMENTS a
86: set customer_id = (select distinct m.customer_id

Line 83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );

79: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
80:
81: /* customer level update */
82: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
84:
85: UPDATE SO_AGREEMENTS a
86: set customer_id = (select distinct m.customer_id
87: from ra_customer_merges m

Line 104: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

100: and m.set_number = set_num);
101:
102: g_count := sql%rowcount;
103:
104: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
105: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
106:
107: END IF;
108:

Line 105: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

101:
102: g_count := sql%rowcount;
103:
104: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
105: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
106:
107: END IF;
108:
109: arp_message.set_line( 'OEP_CMERGE_OESET.OE_AG()-' );

Line 109: arp_message.set_line( 'OEP_CMERGE_OESET.OE_AG()-' );

105: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
106:
107: END IF;
108:
109: arp_message.set_line( 'OEP_CMERGE_OESET.OE_AG()-' );
110:
111:
112: EXCEPTION
113: when others then

Line 114: arp_message.set_error( 'OEP_CMERGE_OESET.OE_AG');

110:
111:
112: EXCEPTION
113: when others then
114: arp_message.set_error( 'OEP_CMERGE_OESET.OE_AG');
115: raise;
116:
117: END;
118:

Line 125: arp_message.set_line( 'OEP_CMERGE_OESET.MERGE()+' );

121:
122: PROCEDURE MERGE (REQ_ID NUMBER, SET_NUM NUMBER, PROCESS_MODE VARCHAR2) IS
123: BEGIN
124:
125: arp_message.set_line( 'OEP_CMERGE_OESET.MERGE()+' );
126:
127: oe_ag( req_id, set_num, process_mode );
128:
129: arp_message.set_line( 'OEP_CMERGE_OESET.MERGE()-' );

Line 129: arp_message.set_line( 'OEP_CMERGE_OESET.MERGE()-' );

125: arp_message.set_line( 'OEP_CMERGE_OESET.MERGE()+' );
126:
127: oe_ag( req_id, set_num, process_mode );
128:
129: arp_message.set_line( 'OEP_CMERGE_OESET.MERGE()-' );
130:
131: EXCEPTION
132: when others then
133: raise;