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 338: oe_debug_pub.add('RAISING OIP STATUS CHANGE BUSINESS EVENT FOR ORDER HEADER CLOSURE');

334: -- jolin end
335:
336: -- Added following code to raise OIP status update event for Order Header during closure.
337: -- Call to the following procedure added for the bug 13930149
338: oe_debug_pub.add('RAISING OIP STATUS CHANGE BUSINESS EVENT FOR ORDER HEADER CLOSURE');
339: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(p_header_id => l_header_rec.header_id,
340: p_status => l_header_rec.flow_status_code);
341:
342: /********************GENESIS********************************

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

344: * the update_flow_status is getting called directly. So *
345: * we need to call synch_header_line for 28 *
346: ***********************************************************/
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( ' GENESIS : -CLOSE ORDER- header rec order source'||l_header_rec.order_source_id);
349: END IF;
350: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
351: -- 8516700: Start (O2C25)
352: IF Oe_Genesis_Util.Status_Needs_Sync(l_header_rec.flow_status_code) THEN

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

355: select OE_XML_MESSAGE_SEQ_S.nextval
356: into l_itemkey_sso
357: from dual;
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( ' GENESIS CLOSE : CLOSE ORDER - l_itemkey_sso'||l_itemkey_sso);
360: END IF;
361: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec
362: ,p_line_rec => null
363: ,p_hdr_req_id => l_itemkey_sso

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

433: /* Customer Acceptance */
434: l_pending_acceptance VARCHAR2(1) := 'N';
435: l_line_rec OE_ORDER_PUB.Line_rec_type;
436: --
437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
438: --
439: BEGIN
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'ENTER OE_ORDER_CLOSE_UTIL.CLOSE_LINE' , 1 ) ;

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

437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
438: --
439: BEGIN
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'ENTER OE_ORDER_CLOSE_UTIL.CLOSE_LINE' , 1 ) ;
442: END IF;
443:
444: SAVEPOINT CLOSE_LINE;
445:

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

593: AND l_line_rec.service_reference_type_code='ORDER'
594: AND l_line_rec.service_reference_line_id IS NOT NULL
595: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec.service_reference_line_id) = 'ACCEPTED')) THEN
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add('acceptance not required. item_type:'||l_line_rec.item_type_code);
598: END IF;
599: ELSE
600: l_pending_acceptance:= 'Y';
601: END IF;

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

700: -- Added for bug 5988559
701: IF SQL%NOTFOUND THEN
702:
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
705: END IF;
706: RAISE FND_API.G_EXC_ERROR;
707:
708: END IF;

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

749: -- Added for bug 5988559
750: IF SQL%NOTFOUND THEN
751:
752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
754: END IF;
755: RAISE FND_API.G_EXC_ERROR;
756:
757: END IF;

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

769: , x_index => l_notify_index
770: , x_return_status => x_return_status);
771:
772: IF l_debug_level > 0 THEN
773: oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || X_RETURN_STATUS , 1 ) ;
774: END IF;
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
777: END IF;

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

772: IF l_debug_level > 0 THEN
773: oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || X_RETURN_STATUS , 1 ) ;
774: END IF;
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
777: END IF;
778:
779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;

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

792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
794:
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
797: END IF;
798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
800: END IF;

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

795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
797: END IF;
798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
800: END IF;
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
803: END IF;

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

798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
800: END IF;
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
803: END IF;
804:
805:
806: -- Process requests is TRUE, but don't need to notify

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

804:
805:
806: -- Process requests is TRUE, but don't need to notify
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
809: END IF;
810: OE_Order_PVT.Process_Requests_And_Notify
811: ( p_process_requests => TRUE
812: , p_notify => FALSE

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

825: ELSE /* in pre-pack H code */
826:
827: -- Need to both notify and process requests in old framework
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add( 'OEXPVPMB: BEFORE CALLING PROCESS_REQUESTS_AND_NOTIFY' ) ;
830: END IF;
831: OE_Order_PVT.Process_Requests_And_Notify
832: ( p_process_requests => TRUE
833: , p_notify => TRUE

Line 861: oe_debug_pub.add('RAISING OIP STATUS CHANGE BUSINESS EVENT FOR ORDER LINE CLOSURE');

857: END IF;
858:
859: --- Adding the following code to raise OIP status change event during order line closure
860: -- change done for bug 13930149
861: oe_debug_pub.add('RAISING OIP STATUS CHANGE BUSINESS EVENT FOR ORDER LINE CLOSURE');
862: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(p_header_id => l_old_line_tbl(1).header_id,
863: p_line_id => p_line_id,
864: p_status => l_line_tbl(1).flow_status_code);
865: -- done with changes for bug 13930149

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

872: /* 10065583 Moved the If condition up */
873:
874: IF (OE_GENESIS_UTIL.source_aia_enabled(l_old_line_tbl(1).order_source_id)) THEN
875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
877: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
878: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
879: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
880: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);

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

873:
874: IF (OE_GENESIS_UTIL.source_aia_enabled(l_old_line_tbl(1).order_source_id)) THEN
875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
877: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
878: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
879: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
880: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
881: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);

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

874: IF (OE_GENESIS_UTIL.source_aia_enabled(l_old_line_tbl(1).order_source_id)) THEN
875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
877: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
878: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
879: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
880: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
881: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
882: END IF;

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

875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
877: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
878: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
879: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
880: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
881: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
882: END IF;
883: -- 8516700 (O2C2.5): Start

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

876: oe_debug_pub.add( ' GENESIS : CLOSE LINE - header rec order source'||p_line_id);
877: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
878: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
879: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
880: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
881: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
882: END IF;
883: -- 8516700 (O2C2.5): Start
884: IF Oe_Genesis_Util.Status_Needs_Sync(l_line_tbl(1).flow_status_code) THEN

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

877: oe_debug_pub.add( ' GENESIS : CLOSE LINE - line rec order source'||l_line_tbl(1).order_source_id);
878: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_old_line_tbl(1).order_source_id);
879: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec order source'||l_line_tbl(1).order_source_id);
880: oe_debug_pub.add( ' GENESIS : CLOSE LINE - new line rec flow status'||l_line_tbl(1).flow_status_code);
881: oe_debug_pub.add( ' GENESIS : CLOSE LINE - old line rec flow status'||l_old_line_tbl(1).flow_status_code);
882: END IF;
883: -- 8516700 (O2C2.5): Start
884: IF Oe_Genesis_Util.Status_Needs_Sync(l_line_tbl(1).flow_status_code) THEN
885: -- 8516700 (O2C2.5): End

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

891: select OE_XML_MESSAGE_SEQ_S.nextval
892: into l_itemkey_sso
893: from dual;
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add( ' GENESIS : CLOSE LINE - l_itemkey_sso'||l_itemkey_sso);
896: END IF;
897:
898: OE_SYNC_ORDER_PVT.INSERT_SYNC_lINE(P_LINE_rec => l_line_tbl(1),
899: p_change_type => 'LINE_STATUS',

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

900: p_req_id => l_itemkey_sso,
901: X_RETURN_STATUS => L_RETURN_STATUS_GEN);
902:
903: IF l_debug_level > 0 THEN
904: oe_debug_pub.add( ' GENESIS :CLOSE LINE: RETURN STATUS'||l_return_status_gen);
905: END IF;
906:
907: IF l_return_status_gen = FND_API.G_RET_STS_SUCCESS THEN
908: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec