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.OE_ORDER_CLOSE_UTIL dependencies on OE_DEBUG_PUB

Line 46: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

42: AND not exists( select 1 from oe_price_adj_assocs
43: where rltd_price_adj_id = adj.price_adjustment_id);
44:
45: --
46: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
47: --
48: BEGIN
49:
50: IF l_debug_level > 0 THEN

Line 51: oe_debug_pub.add('ENTERING DELETE_ADJUSTMENTS');

47: --
48: BEGIN
49:
50: IF l_debug_level > 0 THEN
51: oe_debug_pub.add('ENTERING DELETE_ADJUSTMENTS');
52: END IF;
53:
54: IF p_header_id IS NOT NULL THEN
55: OPEN c_adjustment_header;

Line 72: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

68: WHERE price_adjustment_id = l_adjustment_id;
69: EXCEPTION
70: WHEN OTHERS THEN
71: IF l_debug_level > 0 THEN
72: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
73: END IF;
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END;
76: END LOOP;

Line 98: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

94: WHERE price_adjustment_id = l_adjustment_id;
95: EXCEPTION
96: WHEN OTHERS THEN
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
99: END IF;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END;
102: --

Line 108: oe_debug_pub.add( 'ERROR: BOTH PARAMETERS ARE NULL IN DELETE_ADJUSTMENTS ' , 1 ) ;

104: CLOSE c_adjustment_line;
105: --
106: ELSE
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'ERROR: BOTH PARAMETERS ARE NULL IN DELETE_ADJUSTMENTS ' , 1 ) ;
109: END IF;
110: RETURN;
111: END IF;
112: END IF;

Line 115: oe_debug_pub.add('EXITING DELETE_ADJUSTMENTS');

111: END IF;
112: END IF;
113:
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add('EXITING DELETE_ADJUSTMENTS');
116: END IF;
117:
118: EXCEPTION
119: WHEN OTHERS THEN

Line 121: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

117:
118: EXCEPTION
119: WHEN OTHERS THEN
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
122: END IF;
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END DELETE_ADJUSTMENTS;
125:

Line 148: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

144: l_notify_index NUMBER; -- jolin
145: l_itemkey_sso NUMBER; -- GENESIS
146:
147: --
148: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
149: --
150: BEGIN
151:
152: SAVEPOINT CLOSE_ORDER;

Line 245: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_header_id , 1) ;

241: -- Added for bug 5988559
242: IF SQL%NOTFOUND THEN
243:
244: IF l_debug_level > 0 THEN
245: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_header_id , 1) ;
246: END IF;
247: RAISE FND_API.G_EXC_ERROR;
248:
249: END IF;

Line 266: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || X_RETURN_STATUS ) ;

262: , x_index => l_notify_index
263: , x_return_status => x_return_status);
264:
265: IF l_debug_level > 0 THEN
266: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || X_RETURN_STATUS ) ;
267: END IF;
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
270: END IF;

Line 269: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;

265: IF l_debug_level > 0 THEN
266: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || X_RETURN_STATUS ) ;
267: END IF;
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
270: END IF;
271:
272: IF l_notify_index is not null then
273: -- modify Global Picture

Line 283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;

279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;

Line 286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;

282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;
288:
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;

Line 297: oe_debug_pub.add( 'OEXUCLOB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;

293: END IF;
294:
295: -- Process requests is TRUE so still need to call it, but don't need to notify
296: IF l_debug_level > 0 THEN
297: oe_debug_pub.add( 'OEXUCLOB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
298: END IF;
299: OE_Order_PVT.Process_Requests_And_Notify
300: ( p_process_requests => TRUE
301: , p_notify => FALSE

Line 318: oe_debug_pub.add( 'OEXUCLOB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;

314: ELSE /* in pre-pack H code */
315:
316: -- Need to both notify and process requests in old framework
317: IF l_debug_level > 0 THEN
318: oe_debug_pub.add( 'OEXUCLOB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
319: END IF;
320: OE_Order_PVT.Process_Requests_And_Notify
321: ( p_process_requests => TRUE
322: , p_notify => TRUE

Line 342: oe_debug_pub.add( ' GENESIS : -CLOSE ORDER- header rec order source'||l_header_rec.order_source_id);

338: * the update_flow_status is getting called directly. So *
339: * we need to call synch_header_line for 28 *
340: ***********************************************************/
341: IF l_debug_level > 0 THEN
342: oe_debug_pub.add( ' GENESIS : -CLOSE ORDER- header rec order source'||l_header_rec.order_source_id);
343: END IF;
344: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
345:
346: select OE_XML_MESSAGE_SEQ_S.nextval

Line 350: oe_debug_pub.add( ' GENESIS CLOSE : CLOSE ORDER - l_itemkey_sso'||l_itemkey_sso);

346: select OE_XML_MESSAGE_SEQ_S.nextval
347: into l_itemkey_sso
348: from dual;
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( ' GENESIS CLOSE : CLOSE ORDER - l_itemkey_sso'||l_itemkey_sso);
351: END IF;
352: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec
353: ,p_line_rec => null
354: ,p_hdr_req_id => l_itemkey_sso

Line 427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

423: /* Customer Acceptance */
424: l_pending_acceptance VARCHAR2(1) := 'N';
425: l_line_rec OE_ORDER_PUB.Line_rec_type;
426: --
427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
428: --
429: BEGIN
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'ENTER OE_ORDER_CLOSE_UTIL.CLOSE_LINE' , 1 ) ;

Line 431: oe_debug_pub.add( 'ENTER OE_ORDER_CLOSE_UTIL.CLOSE_LINE' , 1 ) ;

427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
428: --
429: BEGIN
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'ENTER OE_ORDER_CLOSE_UTIL.CLOSE_LINE' , 1 ) ;
432: END IF;
433:
434: SAVEPOINT CLOSE_LINE;
435:

Line 587: oe_debug_pub.add('acceptance not required. item_type:'||l_line_rec.item_type_code);

583: AND l_line_rec.service_reference_type_code='ORDER'
584: AND l_line_rec.service_reference_line_id IS NOT NULL
585: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec.service_reference_line_id) = 'ACCEPTED')) THEN
586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add('acceptance not required. item_type:'||l_line_rec.item_type_code);
588: END IF;
589: ELSE
590: l_pending_acceptance:= 'Y';
591: END IF;

Line 665: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;

661: -- Added for bug 5988559
662: IF SQL%NOTFOUND THEN
663:
664: IF l_debug_level > 0 THEN
665: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
666: END IF;
667: RAISE FND_API.G_EXC_ERROR;
668:
669: END IF;

Line 687: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;

683: -- Added for bug 5988559
684: IF SQL%NOTFOUND THEN
685:
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
688: END IF;
689: RAISE FND_API.G_EXC_ERROR;
690:
691: END IF;

Line 736: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;

732: -- Added for bug 5988559
733: IF SQL%NOTFOUND THEN
734:
735: IF l_debug_level > 0 THEN
736: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
737: END IF;
738: RAISE FND_API.G_EXC_ERROR;
739:
740: END IF;

Line 756: oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || X_RETURN_STATUS , 1 ) ;

752: , x_index => l_notify_index
753: , x_return_status => x_return_status);
754:
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || X_RETURN_STATUS , 1 ) ;
757: END IF;
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
760: END IF;

Line 759: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;

755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || X_RETURN_STATUS , 1 ) ;
757: END IF;
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
760: END IF;
761:
762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
763: RAISE FND_API.G_EXC_ERROR;

Line 779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;

775: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
776: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
777:
778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
780: END IF;
781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
783: END IF;

Line 782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;

778: IF l_debug_level > 0 THEN
779: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
780: END IF;
781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
783: END IF;
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
786: END IF;

Line 785: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;

781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
783: END IF;
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
786: END IF;
787:
788:
789: -- Process requests is TRUE, but don't need to notify

Line 791: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;

787:
788:
789: -- Process requests is TRUE, but don't need to notify
790: IF l_debug_level > 0 THEN
791: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
792: END IF;
793: OE_Order_PVT.Process_Requests_And_Notify
794: ( p_process_requests => TRUE
795: , p_notify => FALSE

Line 812: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;

808: ELSE /* in pre-pack H code */
809:
810: -- Need to both notify and process requests in old framework
811: IF l_debug_level > 0 THEN
812: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
813: END IF;
814: OE_Order_PVT.Process_Requests_And_Notify
815: ( p_process_requests => TRUE
816: , p_notify => TRUE

Line 848: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);

844: * the update_flow_status is getting called directly. So *
845: * we need to call synch_header_line for 28 *
846: ***********************************************************/
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
849: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
850: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
851: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
852: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);

Line 849: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);

845: * we need to call synch_header_line for 28 *
846: ***********************************************************/
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
849: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
850: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
851: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
852: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
853: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);

Line 850: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);

846: ***********************************************************/
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
849: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
850: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
851: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
852: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
853: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
854: END IF;

Line 851: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);

847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
849: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
850: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
851: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
852: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
853: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
854: END IF;
855: IF (OE_GENESIS_UTIL.source_aia_enabled(l_old_line_tbl(1).order_source_id)) THEN

Line 852: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);

848: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
849: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
850: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
851: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
852: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
853: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
854: END IF;
855: IF (OE_GENESIS_UTIL.source_aia_enabled(l_old_line_tbl(1).order_source_id)) THEN
856: /*

Line 853: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);

849: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
850: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
851: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
852: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
853: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
854: END IF;
855: IF (OE_GENESIS_UTIL.source_aia_enabled(l_old_line_tbl(1).order_source_id)) THEN
856: /*
857: oe_line_util.query_row(

Line 871: oe_debug_pub.add( ' GENESIS : CLOSE LINE - l_itemkey_sso'||l_itemkey_sso);

867: select OE_XML_MESSAGE_SEQ_S.nextval
868: into l_itemkey_sso
869: from dual;
870: IF l_debug_level > 0 THEN
871: oe_debug_pub.add( ' GENESIS : CLOSE LINE - l_itemkey_sso'||l_itemkey_sso);
872: END IF;
873:
874: OE_SYNC_ORDER_PVT.INSERT_SYNC_lINE(P_LINE_rec => l_line_tbl(1),
875: p_change_type => 'LINE_STATUS',

Line 880: oe_debug_pub.add( ' GENESIS :CLOSE LINE: RETURN STATUS'||l_return_status_gen);

876: p_req_id => l_itemkey_sso,
877: X_RETURN_STATUS => L_RETURN_STATUS_GEN);
878:
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( ' GENESIS :CLOSE LINE: RETURN STATUS'||l_return_status_gen);
881: END IF;
882: IF l_return_status_gen = FND_API.G_RET_STS_SUCCESS THEN
883: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec
884: ,p_line_rec => null