APPS.OEP_CMERGE_OEORD dependencies on OEP_CMERGE_OEORD

Line 1: PACKAGE BODY OEP_CMERGE_OEORD AS

1: PACKAGE BODY OEP_CMERGE_OEORD AS
2: /* $Header: oeordpb.pls 115.1 99/07/26 11:08:35 porting shi $ */
3:
4:
5: /*---------------------------- PRIVATE VARIABLES ----------------------------*/

Line 46: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SH()+' );

42: for update nowait;
43:
44: BEGIN
45:
46: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SH()+' );
47:
48: /*-----------------------------+
49: | SO_HEADERS |
50: +-----------------------------*/

Line 161: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SH()-' );

157: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
158:
159: END IF;
160:
161: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SH()-' );
162:
163:
164: EXCEPTION
165: when others then

Line 166: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_SH');

162:
163:
164: EXCEPTION
165: when others then
166: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_SH');
167: raise;
168:
169: END;
170:

Line 187: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SL()+' );

183: for update nowait;
184:
185: BEGIN
186:
187: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SL()+' );
188:
189: /*-----------------------------+
190: | SO_LINES |
191: +-----------------------------*/

Line 237: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SL()-' );

233: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
234:
235: END IF;
236:
237: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SL()-' );
238:
239:
240: EXCEPTION
241: when others then

Line 242: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_SL');

238:
239:
240: EXCEPTION
241: when others then
242: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_SL');
243: raise;
244:
245: END;
246:

Line 261: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SD()+' );

257: for update nowait;
258:
259: BEGIN
260:
261: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SD()+' );
262:
263: /*-----------------------------+
264: | SO_LINE_SERVICE_DETAILS |
265: +-----------------------------*/

Line 307: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SD()-' );

303: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
304:
305: END IF;
306:
307: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SD()-' );
308:
309:
310: EXCEPTION
311: when others then

Line 312: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_SD');

308:
309:
310: EXCEPTION
311: when others then
312: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_SD');
313: raise;
314:
315: END;
316:

Line 332: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_OA()+' );

328: for update nowait;
329:
330: BEGIN
331:
332: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_OA()+' );
333:
334: /*-----------------------------+
335: | SO_ORDER_APPROVALS |
336: +-----------------------------*/

Line 377: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_OA()-' );

373: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
374:
375: END IF;
376:
377: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_OA()-' );
378:
379:
380: EXCEPTION
381: when others then

Line 382: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_OA');

378:
379:
380: EXCEPTION
381: when others then
382: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_OA');
383: raise;
384:
385: END;
386:

Line 417: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_VR()+' );

413:
414:
415: BEGIN
416:
417: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_VR()+' );
418:
419:
420:
421: /*-----------------------------+

Line 505: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_VR()-' );

501:
502:
503: END IF;
504:
505: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_VR()-' );
506:
507:
508: EXCEPTION
509: when others then

Line 510: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_VR');

506:
507:
508: EXCEPTION
509: when others then
510: arp_message.set_error( 'OEP_CMERGE_OEORD.OE_VR');
511: raise;
512:
513: END;
514:

Line 523: arp_message.set_line( 'OEP_CMERGE_OEORD.MERGE()+' );

519:
520: PROCEDURE MERGE (REQ_ID NUMBER, SET_NUM NUMBER, PROCESS_MODE VARCHAR2) IS
521: BEGIN
522:
523: arp_message.set_line( 'OEP_CMERGE_OEORD.MERGE()+' );
524:
525: oe_sh( req_id, set_num, process_mode );
526: oe_sl( req_id, set_num, process_mode );
527: oe_oa( req_id, set_num, process_mode );

Line 531: arp_message.set_line( 'OEP_CMERGE_OEORD.MERGE()-' );

527: oe_oa( req_id, set_num, process_mode );
528: oe_sd( req_id, set_num, process_mode );
529: oe_vr( req_id, set_num, process_mode );
530:
531: arp_message.set_line( 'OEP_CMERGE_OEORD.MERGE()-' );
532:
533: EXCEPTION
534: when others then
535: raise;

Line 538: END OEP_CMERGE_OEORD;

534: when others then
535: raise;
536:
537: END MERGE;
538: END OEP_CMERGE_OEORD;