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.OEP_CMERGE_OEHLD dependencies on ARP_MESSAGE

Line 58: arp_message.set_line( 'OEP_CMERGE_OEHLD.OE_HS()+' );

54: for update nowait;
55:
56: BEGIN
57:
58: arp_message.set_line( 'OEP_CMERGE_OEHLD.OE_HS()+' );
59:
60: /*-----------------------------+
61: | SO_HOLD_SOURCES |
62: +-----------------------------*/

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

63: /* both customer and site level */
64:
65: IF( process_mode = 'LOCK' ) THEN
66:
67: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
68: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
69:
70: open c1;
71: close c1;

Line 68: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

64:
65: IF( process_mode = 'LOCK' ) THEN
66:
67: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
68: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
69:
70: open c1;
71: close c1;
72:

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

82: ELSE
83:
84:
85: /* site level update */
86: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
87: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
88:
89: UPDATE SO_HOLD_SOURCES a
90: set (hold_entity_id) = (select distinct m.customer_site_id

Line 87: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

83:
84:
85: /* site level update */
86: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
87: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
88:
89: UPDATE SO_HOLD_SOURCES a
90: set (hold_entity_id) = (select distinct m.customer_site_id
91: from ra_customer_merges m

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

105: and hold_entity_code = 'STS';
106:
107: g_count := sql%rowcount;
108:
109: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
110: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
111:
112:
113: /* site level update */

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

106:
107: g_count := sql%rowcount;
108:
109: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
110: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
111:
112:
113: /* site level update */
114: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

110: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
111:
112:
113: /* site level update */
114: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
115: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
116:
117: UPDATE SO_HOLD_SOURCES a
118: set (hold_entity_id) = (select distinct m.customer_site_id

Line 115: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

111:
112:
113: /* site level update */
114: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
115: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
116:
117: UPDATE SO_HOLD_SOURCES a
118: set (hold_entity_id) = (select distinct m.customer_site_id
119: from ra_customer_merges m

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

133: and hold_entity_code = 'ITS';
134:
135: g_count := sql%rowcount;
136:
137: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
138: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
139:
140:
141: /* site level update */

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

134:
135: g_count := sql%rowcount;
136:
137: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
138: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
139:
140:
141: /* site level update */
142: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

138: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
139:
140:
141: /* site level update */
142: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
143: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
144:
145: UPDATE SO_HOLD_SOURCES a
146: set (hold_entity_id) = (select distinct m.customer_site_id

Line 143: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

139:
140:
141: /* site level update */
142: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
143: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
144:
145: UPDATE SO_HOLD_SOURCES a
146: set (hold_entity_id) = (select distinct m.customer_site_id
147: from ra_customer_merges m

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

161: and hold_entity_code = 'S';
162:
163: g_count := sql%rowcount;
164:
165: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
166: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
167:
168:
169: /* customer level update */

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

162:
163: g_count := sql%rowcount;
164:
165: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
166: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
167:
168:
169: /* customer level update */
170: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

166: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
167:
168:
169: /* customer level update */
170: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
171: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
172:
173: UPDATE SO_HOLD_SOURCES a
174: set hold_entity_id = (select distinct m.customer_id

Line 171: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

167:
168:
169: /* customer level update */
170: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
171: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
172:
173: UPDATE SO_HOLD_SOURCES a
174: set hold_entity_id = (select distinct m.customer_id
175: from ra_customer_merges m

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

189: and hold_entity_code = 'C';
190:
191: g_count := sql%rowcount;
192:
193: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
194: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
195:
196: END IF;
197:

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

190:
191: g_count := sql%rowcount;
192:
193: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
194: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
195:
196: END IF;
197:
198: arp_message.set_line( 'OEP_CMERGE_OEHLD.OE_HS()-' );

Line 198: arp_message.set_line( 'OEP_CMERGE_OEHLD.OE_HS()-' );

194: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
195:
196: END IF;
197:
198: arp_message.set_line( 'OEP_CMERGE_OEHLD.OE_HS()-' );
199:
200:
201: EXCEPTION
202: when others then

Line 203: arp_message.set_error( 'OEP_CMERGE_OEHLD.OE_HS');

199:
200:
201: EXCEPTION
202: when others then
203: arp_message.set_error( 'OEP_CMERGE_OEHLD.OE_HS');
204: raise;
205:
206: END;
207:

Line 216: arp_message.set_line( 'OEP_CMERGE_OEHLD.MERGE()+' );

212:
213: PROCEDURE MERGE (REQ_ID NUMBER, SET_NUM NUMBER, PROCESS_MODE VARCHAR2) IS
214: BEGIN
215:
216: arp_message.set_line( 'OEP_CMERGE_OEHLD.MERGE()+' );
217:
218: oe_hs( req_id, set_num, process_mode );
219:
220: arp_message.set_line( 'OEP_CMERGE_OEHLD.MERGE()-' );

Line 220: arp_message.set_line( 'OEP_CMERGE_OEHLD.MERGE()-' );

216: arp_message.set_line( 'OEP_CMERGE_OEHLD.MERGE()+' );
217:
218: oe_hs( req_id, set_num, process_mode );
219:
220: arp_message.set_line( 'OEP_CMERGE_OEHLD.MERGE()-' );
221:
222: EXCEPTION
223: when others then
224: raise;