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

Line 57: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DL()+' );

53: for update nowait;
54:
55: BEGIN
56:
57: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DL()+' );
58:
59: /*-----------------------------+
60: | SO_DISCOUNT_LINES |
61: +-----------------------------*/

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

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

Line 67: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

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

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

Line 86: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

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

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

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

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

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

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

Line 114: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

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

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

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

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

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

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

Line 142: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

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

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

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

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

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

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

Line 170: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

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

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

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

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

Line 197: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DL()-' );

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

Line 202: arp_message.set_error( 'OEP_CMERGE_OEDIS.OE_DL');

198:
199:
200: EXCEPTION
201: when others then
202: arp_message.set_error( 'OEP_CMERGE_OEDIS.OE_DL');
203: raise;
204:
205: END;
206:

Line 238: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DC()+' );

234: for update nowait;
235:
236: BEGIN
237:
238: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DC()+' );
239:
240: /*-----------------------------+
241: | SO_DISCOUNT_CUSTOMERS |
242: +-----------------------------*/

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

243: /* both customer and site level */
244:
245: IF( process_mode = 'LOCK' ) THEN
246:
247: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
248: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
249:
250: open c1;
251: close c1;

Line 248: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );

244:
245: IF( process_mode = 'LOCK' ) THEN
246:
247: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
248: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
249:
250: open c1;
251: close c1;
252:

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

256: ELSE
257:
258:
259: /* site level update */
260: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
261: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
262:
263: UPDATE SO_DISCOUNT_CUSTOMERS a
264: set (site_use_id) = (select distinct m.customer_site_id

Line 261: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );

257:
258:
259: /* site level update */
260: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
261: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
262:
263: UPDATE SO_DISCOUNT_CUSTOMERS a
264: set (site_use_id) = (select distinct m.customer_site_id
265: from ra_customer_merges m

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

278: and m.set_number = set_num);
279:
280: g_count := sql%rowcount;
281:
282: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
283: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
284:
285: /* customer level update */
286: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

279:
280: g_count := sql%rowcount;
281:
282: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
283: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
284:
285: /* customer level update */
286: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );

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

282: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
283: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
284:
285: /* customer level update */
286: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
288:
289: UPDATE SO_DISCOUNT_CUSTOMERS a
290: set customer_id = (select distinct m.customer_id

Line 287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );

283: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
284:
285: /* customer level update */
286: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
288:
289: UPDATE SO_DISCOUNT_CUSTOMERS a
290: set customer_id = (select distinct m.customer_id
291: from ra_customer_merges m

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

304: and m.set_number = set_num);
305:
306: g_count := sql%rowcount;
307:
308: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
309: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
310:
311: END IF;
312:

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

305:
306: g_count := sql%rowcount;
307:
308: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
309: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
310:
311: END IF;
312:
313: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DC()-' );

Line 313: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DC()-' );

309: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
310:
311: END IF;
312:
313: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DC()-' );
314:
315:
316: EXCEPTION
317: when others then

Line 318: arp_message.set_error( 'OEP_CMERGE_OEDIS.OE_DC');

314:
315:
316: EXCEPTION
317: when others then
318: arp_message.set_error( 'OEP_CMERGE_OEDIS.OE_DC');
319: raise;
320:
321: END;
322:

Line 331: arp_message.set_line( 'OEP_CMERGE_OEDIS.MERGE()+' );

327:
328: PROCEDURE MERGE (REQ_ID NUMBER, SET_NUM NUMBER, PROCESS_MODE VARCHAR2) IS
329: BEGIN
330:
331: arp_message.set_line( 'OEP_CMERGE_OEDIS.MERGE()+' );
332:
333: oe_dl( req_id, set_num, process_mode );
334: oe_dc( req_id, set_num, process_mode );
335:

Line 336: arp_message.set_line( 'OEP_CMERGE_OEDIS.MERGE()-' );

332:
333: oe_dl( req_id, set_num, process_mode );
334: oe_dc( req_id, set_num, process_mode );
335:
336: arp_message.set_line( 'OEP_CMERGE_OEDIS.MERGE()-' );
337:
338: EXCEPTION
339: when others then
340: raise;