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_OEPIC dependencies on ARP_MESSAGE

Line 35: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PR()+' );

31: for update nowait;
32:
33: BEGIN
34:
35: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PR()+' );
36:
37: /*-----------------------------+
38: | SO_PICKING_RULES |
39: +-----------------------------*/

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

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

Line 45: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );

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

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

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

Line 58: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );

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

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

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

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

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

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

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

Line 84: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );

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

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

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

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

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

Line 110: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PR()-' );

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

Line 115: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PR');

111:
112:
113: EXCEPTION
114: when others then
115: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PR');
116: raise;
117:
118: END;
119:

Line 145: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PB()+' );

141: for update nowait;
142:
143: BEGIN
144:
145: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PB()+' );
146:
147: /*-----------------------------+
148: | SO_PICKING_BATCHES |
149: +-----------------------------*/

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

150: /* both customer and site level */
151:
152: IF( process_mode = 'LOCK' ) THEN
153:
154: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
155: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
156:
157: open c1;
158: close c1;

Line 155: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );

151:
152: IF( process_mode = 'LOCK' ) THEN
153:
154: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
155: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
156:
157: open c1;
158: close c1;
159:

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

163: ELSE
164:
165:
166: /* site level update */
167: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
168: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
169:
170: UPDATE SO_PICKING_BATCHES a
171: set (site_use_id) = (select distinct m.customer_site_id

Line 168: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );

164:
165:
166: /* site level update */
167: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
168: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
169:
170: UPDATE SO_PICKING_BATCHES a
171: set (site_use_id) = (select distinct m.customer_site_id
172: from ra_customer_merges m

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

185: and m.set_number = set_num);
186:
187: g_count := sql%rowcount;
188:
189: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
190: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
191:
192: /* customer level update */
193: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

186:
187: g_count := sql%rowcount;
188:
189: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
190: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
191:
192: /* customer level update */
193: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
194: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );

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

189: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
190: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
191:
192: /* customer level update */
193: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
194: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
195:
196: UPDATE SO_PICKING_BATCHES a
197: set customer_id = (select distinct m.customer_id

Line 194: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );

190: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
191:
192: /* customer level update */
193: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
194: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
195:
196: UPDATE SO_PICKING_BATCHES a
197: set customer_id = (select distinct m.customer_id
198: from ra_customer_merges m

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

211: and m.set_number = set_num);
212:
213: g_count := sql%rowcount;
214:
215: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
216: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
217:
218: END IF;
219:

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

212:
213: g_count := sql%rowcount;
214:
215: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
216: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
217:
218: END IF;
219:
220: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PB()-' );

Line 220: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PB()-' );

216: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
217:
218: END IF;
219:
220: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PB()-' );
221:
222:
223: EXCEPTION
224: when others then

Line 225: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PB');

221:
222:
223: EXCEPTION
224: when others then
225: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PB');
226: raise;
227:
228: END;
229:

Line 246: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PH()+' );

242: for update nowait;
243:
244: BEGIN
245:
246: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PH()+' );
247:
248: /*-----------------------------+
249: | SO_PICKING_HEADERS |
250: +-----------------------------*/

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

251: /* both customer and site level */
252:
253: IF( process_mode = 'LOCK' ) THEN
254:
255: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
256: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
257:
258: open c1;
259: close c1;

Line 256: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );

252:
253: IF( process_mode = 'LOCK' ) THEN
254:
255: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
256: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
257:
258: open c1;
259: close c1;
260:

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

261: ELSE
262:
263:
264: /* site level update */
265: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
266: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
267:
268: UPDATE SO_PICKING_HEADERS a
269: set (ship_to_site_use_id) = (select distinct m.customer_site_id

Line 266: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );

262:
263:
264: /* site level update */
265: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
266: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
267:
268: UPDATE SO_PICKING_HEADERS a
269: set (ship_to_site_use_id) = (select distinct m.customer_site_id
270: from ra_customer_merges m

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

283: and m.set_number = set_num);
284:
285: g_count := sql%rowcount;
286:
287: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
288: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
289:
290: END IF;
291:

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

284:
285: g_count := sql%rowcount;
286:
287: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
288: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
289:
290: END IF;
291:
292: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PH()-' );

Line 292: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PH()-' );

288: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
289:
290: END IF;
291:
292: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PH()-' );
293:
294:
295: EXCEPTION
296: when others then

Line 297: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PH');

293:
294:
295: EXCEPTION
296: when others then
297: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PH');
298: raise;
299:
300: END;
301:

Line 317: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PL()+' );

313: for update nowait;
314:
315: BEGIN
316:
317: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PL()+' );
318:
319: /*-----------------------------+
320: | SO_PICKING_LINES |
321: +-----------------------------*/

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

322: /* both customer and site level */
323:
324: IF( process_mode = 'LOCK' ) THEN
325:
326: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
327: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );
328:
329: open c1;
330: close c1;

Line 327: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );

323:
324: IF( process_mode = 'LOCK' ) THEN
325:
326: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
327: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );
328:
329: open c1;
330: close c1;
331:

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

332: ELSE
333:
334:
335: /* site level update */
336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
337: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );
338:
339: UPDATE SO_PICKING_LINES a
340: set (ship_to_site_use_id) = (select distinct m.customer_site_id

Line 337: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );

333:
334:
335: /* site level update */
336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
337: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );
338:
339: UPDATE SO_PICKING_LINES a
340: set (ship_to_site_use_id) = (select distinct m.customer_site_id
341: from ra_customer_merges m

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

354: and m.set_number = set_num);
355:
356: g_count := sql%rowcount;
357:
358: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
359: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
360:
361: END IF;
362:

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

355:
356: g_count := sql%rowcount;
357:
358: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
359: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
360:
361: END IF;
362:
363: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PL()-' );

Line 363: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PL()-' );

359: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
360:
361: END IF;
362:
363: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PL()-' );
364:
365:
366: EXCEPTION
367: when others then

Line 368: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PL');

364:
365:
366: EXCEPTION
367: when others then
368: arp_message.set_error( 'OEP_CMERGE_OEPIC.OE_PL');
369: raise;
370:
371: END;
372:

Line 380: arp_message.set_line( 'OEP_CMERGE_OEPIC.MERGE()+' );

376:
377: PROCEDURE MERGE (REQ_ID NUMBER, SET_NUM NUMBER, PROCESS_MODE VARCHAR2) IS
378: BEGIN
379:
380: arp_message.set_line( 'OEP_CMERGE_OEPIC.MERGE()+' );
381:
382: oe_pr( req_id, set_num, process_mode );
383: oe_pb( req_id, set_num, process_mode );
384: oe_ph( req_id, set_num, process_mode );

Line 387: arp_message.set_line( 'OEP_CMERGE_OEPIC.MERGE()-' );

383: oe_pb( req_id, set_num, process_mode );
384: oe_ph( req_id, set_num, process_mode );
385: oe_pl( req_id, set_num, process_mode );
386:
387: arp_message.set_line( 'OEP_CMERGE_OEPIC.MERGE()-' );
388:
389: EXCEPTION
390: when others then
391: raise;