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_ACKNOWLEDGMENT_PUB dependencies on OE_DEBUG_PUB

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

53: ) Return Varchar2
54: Is
55: l_orig_sys_document_ref Varchar2(50) := Null;
56: --
57: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
58: --
59: Begin
60:
61: If p_header_id Is Not Null Then

Line 78: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS NOT DERIVED , OTHERS EXCEPTION' ) ;

74:
75: Exception
76: When Others Then
77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS NOT DERIVED , OTHERS EXCEPTION' ) ;
79: END IF;
80: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
81: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_orig_sys_document_ref');
82: End if;

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

93: Is
94: l_header_id Number := 0;
95: l_customer_key_profile VARCHAR2(1) := 'N';
96: --
97: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
98: --
99: Begin
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'ENTERING OEXPACKB GET_HEADER_ID' ) ;

Line 101: oe_debug_pub.add( 'ENTERING OEXPACKB GET_HEADER_ID' ) ;

97: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
98: --
99: Begin
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'ENTERING OEXPACKB GET_HEADER_ID' ) ;
102: END IF;
103:
104: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
105: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

Line 108: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

104: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
105: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
106: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
109: END IF;
110: End If;
111:
112: If p_orig_sys_document_ref Is Not Null Then

Line 114: oe_debug_pub.add( 'P_ORIG_SYS_DOCUMENT_REF IS NOT NULL'||P_ORIG_SYS_DOCUMENT_REF ) ;

110: End If;
111:
112: If p_orig_sys_document_ref Is Not Null Then
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'P_ORIG_SYS_DOCUMENT_REF IS NOT NULL'||P_ORIG_SYS_DOCUMENT_REF ) ;
115: END IF;
116: Select header_id
117: Into l_header_id
118: From oe_order_headers

Line 127: oe_debug_pub.add( 'HEADER_ID FOR THE ORIG_SYS_DOCUMENT => ' || L_HEADER_ID ) ;

123: = decode(l_customer_key_profile, 'Y',
124: nvl(p_sold_to_org_id, -999), 1)
125: And rownum = 1;
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'HEADER_ID FOR THE ORIG_SYS_DOCUMENT => ' || L_HEADER_ID ) ;
128: END IF;
129: Elsif p_line_id Is Not Null Then
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'P_LINE_ID IS NOT NULL' ) ;

Line 131: oe_debug_pub.add( 'P_LINE_ID IS NOT NULL' ) ;

127: oe_debug_pub.add( 'HEADER_ID FOR THE ORIG_SYS_DOCUMENT => ' || L_HEADER_ID ) ;
128: END IF;
129: Elsif p_line_id Is Not Null Then
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'P_LINE_ID IS NOT NULL' ) ;
132: END IF;
133: Select header_id
134: Into l_header_id
135: From oe_order_lines

Line 140: oe_debug_pub.add( 'HEADER_ID FOR THE LINE_ID => ' || L_HEADER_ID ) ;

136: Where line_id = p_line_id
137: And order_source_id = G_XML_ORDER_SOURCE_ID
138: And rownum = 1;
139: IF l_debug_level > 0 THEN
140: oe_debug_pub.add( 'HEADER_ID FOR THE LINE_ID => ' || L_HEADER_ID ) ;
141: END IF;
142: End If;
143:
144: IF l_debug_level > 0 THEN

Line 145: oe_debug_pub.add( 'EXITING OEXPACKB GET_HEADER_ID' ) ;

141: END IF;
142: End If;
143:
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'EXITING OEXPACKB GET_HEADER_ID' ) ;
146: END IF;
147: return l_header_id;
148:
149: Exception

Line 152: oe_debug_pub.add( 'L_HEADER_ID IS NOT DERIVED , OTHERS EXCEPTION' ) ;

148:
149: Exception
150: When Others Then
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( 'L_HEADER_ID IS NOT DERIVED , OTHERS EXCEPTION' ) ;
153: END IF;
154: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
155: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_header_id');
156: End if;

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

185: l_is_delivery_reqd Varchar2(1);
186: l_return_status Varchar2(30);
187: l_user_key Varchar2(240);
188: --
189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
190: --
191: Begin
192: IF l_debug_level > 0 THEN
193: oe_debug_pub.add( 'ENTERING RAISE_EVENT_FROM_OEOI' ) ;

Line 193: oe_debug_pub.add( 'ENTERING RAISE_EVENT_FROM_OEOI' ) ;

189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
190: --
191: Begin
192: IF l_debug_level > 0 THEN
193: oe_debug_pub.add( 'ENTERING RAISE_EVENT_FROM_OEOI' ) ;
194: END IF;
195:
196: l_event_name := 'oracle.apps.ont.oi.po_ack.create';
197:

Line 203: oe_debug_pub.add( 'L_START_FROM_FLOW = '||L_START_FROM_FLOW ) ;

199: l_start_from_flow := OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM;
200: End If;
201:
202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add( 'L_START_FROM_FLOW = '||L_START_FROM_FLOW ) ;
204: END IF;
205:
206: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
207: IF p_check_for_delivery = 'Y' THEN

Line 229: oe_debug_pub.add( 'L_ITEMKEY = '||L_ITEMKEY || ' ORG ID passed in is ' || p_org_id ) ;

225: Select Oe_Xml_Message_Seq_S.nextval
226: Into l_itemkey
227: From dual;
228: IF l_debug_level > 0 THEN
229: oe_debug_pub.add( 'L_ITEMKEY = '||L_ITEMKEY || ' ORG ID passed in is ' || p_org_id ) ;
230: END IF;
231:
232:
233: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then

Line 277: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.PO_ACK.CREATE' ) ;

273: wf_event.AddParameterToList(p_name=> 'ECX_PARTY_SITE_ID',
274: p_value=> l_party_site_id,
275: p_parameterlist=> l_parameter_list);
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.PO_ACK.CREATE' ) ;
278: END IF;
279: wf_event.raise( p_event_name => l_event_name,
280: p_event_key => l_itemkey,
281: p_parameters => l_parameter_list);

Line 289: oe_debug_pub.add( 'BEFORE COMMIT' ) ;

285:
286: -- Up to your own code to commit the transaction
287: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then
288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add( 'BEFORE COMMIT' ) ;
290: END IF;
291: Commit;
292: End if;
293:

Line 306: oe_debug_pub.add( 'EXITING RAISE_EVENT_FROM_OEOI' ) ;

302:
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add( 'EXITING RAISE_EVENT_FROM_OEOI' ) ;
307: END IF;
308: Exception
309: when others then
310: IF l_debug_level > 0 THEN

Line 311: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_FROM_OEOI' ) ;

307: END IF;
308: Exception
309: when others then
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_FROM_OEOI' ) ;
312: END IF;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN

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

345: l_itemkey Number;
346: l_org_id Number;
347: l_transaction_type Varchar2(6) := p_transaction_type;
348: --
349: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
350: --
351: Begin
352:
353:

Line 362: oe_debug_pub.add( 'ENTERING RAISE_EVENT_SHOWSO' ) ;

358: -- Up to 100 name/value pairs. The fewer the parameters the
359: -- better performance will be.
360:
361: IF l_debug_level > 0 THEN
362: oe_debug_pub.add( 'ENTERING RAISE_EVENT_SHOWSO' ) ;
363: END IF;
364:
365: if p_itemkey is null then
366:

Line 368: oe_debug_pub.add( 'passed-in itemkey was null...pulling value from sequence') ;

364:
365: if p_itemkey is null then
366:
367: IF l_debug_level > 0 THEN
368: oe_debug_pub.add( 'passed-in itemkey was null...pulling value from sequence') ;
369: end if;
370:
371: select OE_XML_MESSAGE_SEQ_S.nextval
372: into l_itemkey

Line 381: oe_debug_pub.add( 'ITEMKEY (request_id) => ' || l_itemkey) ;

377:
378: end if;
379:
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add( 'ITEMKEY (request_id) => ' || l_itemkey) ;
382: end if;
383:
384: If p_orig_sys_document_ref Is Null Then
385: l_orig_sys_document_ref := Get_Orig_Sys_document_Ref

Line 393: oe_debug_pub.add( 'AFTER GET_ORIG_SYS_DOCUMENT_REF => ' || L_ORIG_SYS_DOCUMENT_REF ) ;

389: l_orig_sys_document_ref := p_orig_sys_document_ref;
390: End If;
391:
392: IF l_debug_level > 0 THEN
393: oe_debug_pub.add( 'AFTER GET_ORIG_SYS_DOCUMENT_REF => ' || L_ORIG_SYS_DOCUMENT_REF ) ;
394: END IF;
395:
396: wf_event.AddParameterToList(p_name=> 'ORG_ID',
397: p_value=> p_org_id,

Line 401: oe_debug_pub.add( 'AFTER ADDING ORG_ID PARAMETER..ORG_ID IS => ' || L_ORG_ID ) ;

397: p_value=> p_org_id,
398: p_parameterlist=> l_parameter_list);
399:
400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add( 'AFTER ADDING ORG_ID PARAMETER..ORG_ID IS => ' || L_ORG_ID ) ;
402: END IF;
403:
404: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
405: p_value=> p_header_id,

Line 408: oe_debug_pub.add( 'AFTER ADDING HEADER_ID PARAMETER..HEADER_ID IS => ' || P_HEADER_ID ) ;

404: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
405: p_value=> p_header_id,
406: p_parameterlist=> l_parameter_list);
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'AFTER ADDING HEADER_ID PARAMETER..HEADER_ID IS => ' || P_HEADER_ID ) ;
409: END IF;
410: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
411: p_value=> l_orig_sys_document_ref,
412: p_parameterlist=> l_parameter_list);

Line 418: oe_debug_pub.add( 'AFTER ADDING LINE_ID PARAMETER..LINE_ID IS => ' || P_LINE_ID ) ;

414: wf_event.AddParameterToList(p_name=> 'LINE_ID',
415: p_value=> p_line_id,
416: p_parameterlist=> l_parameter_list);
417: IF l_debug_level > 0 THEN
418: oe_debug_pub.add( 'AFTER ADDING LINE_ID PARAMETER..LINE_ID IS => ' || P_LINE_ID ) ;
419: END IF;
420: wf_event.AddParameterToList(p_name=> 'CUSTOMER_ID',
421: p_value=> p_customer_id,
422: p_parameterlist=> l_parameter_list);

Line 454: oe_debug_pub.add( 'AFTER ADD PARAMETERS' ) ;

450: p_value=> l_transaction_type,
451: p_parameterlist=> l_parameter_list);
452:
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add( 'AFTER ADD PARAMETERS' ) ;
455: END IF;
456:
457: If p_itemtype Is Null Then
458: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;

Line 467: oe_debug_pub.add( 'start_from_flow:' || l_itemtype) ;

463: p_value=> l_itemtype,
464: p_parameterlist=> l_parameter_list);
465:
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'start_from_flow:' || l_itemtype) ;
468: END IF;
469:
470: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
471: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN

Line 488: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.SHOW_SO.CREATE' ) ;

484: -- document is required to be generated, the Generate Function
485: -- will automatically be run
486:
487: IF l_debug_level > 0 THEN
488: oe_debug_pub.add( 'BEFORE RAISE EVENT ORACLE.APPS.ONT.OI.SHOW_SO.CREATE' ) ;
489: END IF;
490: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.show_so.create',
491: p_event_key => l_itemkey,
492: p_parameters => l_parameter_list);

Line 500: oe_debug_pub.add( 'BEFORE COMMIT' ) ;

496: -- Up to your own code to commit the transaction
497: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_PROC AND
498: p_commit_flag = 'Y' then
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add( 'BEFORE COMMIT' ) ;
501: END IF;
502: Commit;
503: End if;
504:

Line 513: oe_debug_pub.add( 'EXITING RAISE_EVENT_SHOWSO' ) ;

509:
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511:
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'EXITING RAISE_EVENT_SHOWSO' ) ;
514: END IF;
515: Exception
516: when others then
517: IF l_debug_level > 0 THEN

Line 518: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_SHOWSO: ' || sqlerrm) ;

514: END IF;
515: Exception
516: when others then
517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_SHOWSO: ' || sqlerrm) ;
519: END IF;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN

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

603: l_return_status VARCHAR2(1);
604: l_msg_count NUMBER;
605: l_msg_data VARCHAR2(2000);
606: --
607: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
608: --
609: BEGIN
610:
611: -- Standard call to check for call compatibility

Line 614: oe_debug_pub.add( 'Entering Process Acknowledgment');

610:
611: -- Standard call to check for call compatibility
612:
613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add( 'Entering Process Acknowledgment');
615: END IF;
616: IF NOT FND_API.Compatible_API_Call
617: ( l_api_version_number
618: , p_api_version_number

Line 624: oe_debug_pub.add( 'OEXPACKB COMPATIBLE_API_CALL' ) ;

620: , G_PKG_NAME
621: )
622: THEN
623: IF l_debug_level > 0 THEN
624: oe_debug_pub.add( 'OEXPACKB COMPATIBLE_API_CALL' ) ;
625: END IF;
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:

Line 630: oe_debug_pub.add( 'BEFORE CALLING PRIVATE ACKNOWLEDGMENT API' ) ;

626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:
629: IF l_debug_level > 0 THEN
630: oe_debug_pub.add( 'BEFORE CALLING PRIVATE ACKNOWLEDGMENT API' ) ;
631: END IF;
632:
633: OE_Acknowledgment_Pvt.Process_Acknowledgment
634: ( p_api_version_number => 1.0

Line 675: oe_debug_pub.add( 'AFTER CALLING PRIVATE ACKNOWLEDGMENT API' ) ;

671: , x_return_status => l_return_status
672: );
673:
674: IF l_debug_level > 0 THEN
675: oe_debug_pub.add( 'AFTER CALLING PRIVATE ACKNOWLEDGMENT API' ) ;
676: END IF;
677:
678: EXCEPTION
679:

Line 682: oe_debug_pub.add( 'ENCOUNTERED ERROR EXCEPTION' ) ;

678: EXCEPTION
679:
680: WHEN FND_API.G_EXC_ERROR THEN
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'ENCOUNTERED ERROR EXCEPTION' ) ;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 688: oe_debug_pub.add( 'ENCOUNTERED UNEXPECTED ERROR EXCEPTION' ) ;

684: x_return_status := FND_API.G_RET_STS_ERROR;
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'ENCOUNTERED UNEXPECTED ERROR EXCEPTION' ) ;
689: END IF;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
691:
692: WHEN OTHERS THEN

Line 694: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;

690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
691:
692: WHEN OTHERS THEN
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;
695: END IF;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
697:
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

714: RETURN NUMBER
715: IS
716: i pls_integer;
717: --
718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
719: --
720: BEGIN
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add( 'ENTERNING: OEXPACK FUNCTION GET_LINE_INDEX' ) ;

Line 722: oe_debug_pub.add( 'ENTERNING: OEXPACK FUNCTION GET_LINE_INDEX' ) ;

718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
719: --
720: BEGIN
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add( 'ENTERNING: OEXPACK FUNCTION GET_LINE_INDEX' ) ;
723: END IF;
724: -- Following For loop is changed to while because of new Notify_OC change
725: -- for i in 1..p_line_tbl.count
726: -- loop

Line 732: oe_debug_pub.add( 'EXITING: OEXPACK FUNCTION GET_LINE_INDEX - RETURNING ' || I ) ;

728: while i is not null loop
729: if p_line_tbl(i).line_id = p_line_id
730: then
731: IF l_debug_level > 0 THEN
732: oe_debug_pub.add( 'EXITING: OEXPACK FUNCTION GET_LINE_INDEX - RETURNING ' || I ) ;
733: END IF;
734: return i;
735: end if;
736: i := p_line_tbl.Next(i);

Line 739: oe_debug_pub.add( 'EXITING: OEXPACK FUNCTION GET_LINE_INDEX - RETURNING 0' ) ;

735: end if;
736: i := p_line_tbl.Next(i);
737: end loop;
738: IF l_debug_level > 0 THEN
739: oe_debug_pub.add( 'EXITING: OEXPACK FUNCTION GET_LINE_INDEX - RETURNING 0' ) ;
740: END IF;
741: return 0;
742: EXCEPTION
743: WHEN OTHERS THEN

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

757: IS
758:
759: l_header_status varchar2(30);
760: --
761: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
762: --
763: BEGIN
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_HEADER' ) ;

Line 765: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_HEADER' ) ;

761: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
762: --
763: BEGIN
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_HEADER' ) ;
766: END IF;
767:
768: l_header_status := p_header_status;
769:

Line 786: oe_debug_pub.add( 'INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;

782: p_header_rec.sold_to_org_id, p_header_rec.change_sequence);
783:
784: if sql%rowcount > 0 then
785: IF l_debug_level > 0 THEN
786: oe_debug_pub.add( 'INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
787: END IF;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: else
790: IF l_debug_level > 0 THEN

Line 791: oe_debug_pub.add( 'NOT INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;

787: END IF;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: else
790: IF l_debug_level > 0 THEN
791: oe_debug_pub.add( 'NOT INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
792: END IF;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: end if;
795:

Line 797: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_HEADER' ) ;

793: x_return_status := FND_API.G_RET_STS_ERROR;
794: end if;
795:
796: IF l_debug_level > 0 THEN
797: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_HEADER' ) ;
798: END IF;
799: EXCEPTION
800: WHEN OTHERS THEN
801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

813: x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
814: )
815: IS
816: --
817: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
818: --
819: BEGIN
820: IF l_debug_level > 0 THEN
821: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_LINE' ) ;

Line 821: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_LINE' ) ;

817: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
818: --
819: BEGIN
820: IF l_debug_level > 0 THEN
821: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_LINE' ) ;
822: END IF;
823:
824: Insert Into OE_LINE_ACKS (header_id, line_id,
825: acknowledgment_type, last_ack_code, request_id,

Line 835: oe_debug_pub.add( 'INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;

831: p_line_rec.change_sequence
832: );
833: if sql%rowcount > 0 then
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
836: END IF;
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: else
839: IF l_debug_level > 0 THEN

Line 840: oe_debug_pub.add( 'NOT INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;

836: END IF;
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: else
839: IF l_debug_level > 0 THEN
840: oe_debug_pub.add( 'NOT INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
841: END IF;
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: end if;
844:

Line 846: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_LINE' ) ;

842: x_return_status := FND_API.G_RET_STS_ERROR;
843: end if;
844:
845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_LINE' ) ;
847: END IF;
848: EXCEPTION
849: WHEN OTHERS THEN
850: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

945: -- FOR UPDATE NOWAIT
946: ORDER BY orig_sys_line_ref, orig_sys_shipment_ref;
947:
948: --
949: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
950: --
951: BEGIN
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'START OF QUERY_INF_RECORDS' ) ;

Line 953: oe_debug_pub.add( 'START OF QUERY_INF_RECORDS' ) ;

949: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
950: --
951: BEGIN
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'START OF QUERY_INF_RECORDS' ) ;
954: END IF;
955:
956:
957:

Line 962: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

958: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
959: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
960: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
961: IF l_debug_level > 0 THEN
962: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
963: END IF;
964: End If;
965:
966: IF l_debug_level > 0 THEN

Line 967: oe_debug_pub.add('Key Information');

963: END IF;
964: End If;
965:
966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add('Key Information');
968: oe_debug_pub.add('Order Source Id:' || p_order_source_id);
969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);

Line 968: oe_debug_pub.add('Order Source Id:' || p_order_source_id);

964: End If;
965:
966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add('Key Information');
968: oe_debug_pub.add('Order Source Id:' || p_order_source_id);
969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);
972: oe_debug_pub.add( 'Request Id:' || p_request_id);

Line 969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);

965:
966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add('Key Information');
968: oe_debug_pub.add('Order Source Id:' || p_order_source_id);
969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);
972: oe_debug_pub.add( 'Request Id:' || p_request_id);
973: oe_debug_pub.add( 'XML Transaction Type Code:' || p_xml_transaction_type_code);

Line 970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);

966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add('Key Information');
968: oe_debug_pub.add('Order Source Id:' || p_order_source_id);
969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);
972: oe_debug_pub.add( 'Request Id:' || p_request_id);
973: oe_debug_pub.add( 'XML Transaction Type Code:' || p_xml_transaction_type_code);
974: END IF;

Line 971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);

967: oe_debug_pub.add('Key Information');
968: oe_debug_pub.add('Order Source Id:' || p_order_source_id);
969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);
972: oe_debug_pub.add( 'Request Id:' || p_request_id);
973: oe_debug_pub.add( 'XML Transaction Type Code:' || p_xml_transaction_type_code);
974: END IF;
975: -- { Start of header fetch

Line 972: oe_debug_pub.add( 'Request Id:' || p_request_id);

968: oe_debug_pub.add('Order Source Id:' || p_order_source_id);
969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);
972: oe_debug_pub.add( 'Request Id:' || p_request_id);
973: oe_debug_pub.add( 'XML Transaction Type Code:' || p_xml_transaction_type_code);
974: END IF;
975: -- { Start of header fetch
976: --HEADER-----------HEADER---------------HEADER----------------HEADER---------

Line 973: oe_debug_pub.add( 'XML Transaction Type Code:' || p_xml_transaction_type_code);

969: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
970: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
971: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);
972: oe_debug_pub.add( 'Request Id:' || p_request_id);
973: oe_debug_pub.add( 'XML Transaction Type Code:' || p_xml_transaction_type_code);
974: END IF;
975: -- { Start of header fetch
976: --HEADER-----------HEADER---------------HEADER----------------HEADER---------
977:

Line 1007: oe_debug_pub.add( 'ORDER SOURCE ID: ' || L_ORDER_SOURCE_ID ) ;

1003: l_orig_sys_document_ref := l_header_rec.orig_sys_document_ref;
1004: l_change_sequence := l_header_rec.change_sequence;
1005:
1006: IF l_debug_level > 0 THEN
1007: oe_debug_pub.add( 'ORDER SOURCE ID: ' || L_ORDER_SOURCE_ID ) ;
1008: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
1009: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
1010: END IF;
1011:

Line 1008: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;

1004: l_change_sequence := l_header_rec.change_sequence;
1005:
1006: IF l_debug_level > 0 THEN
1007: oe_debug_pub.add( 'ORDER SOURCE ID: ' || L_ORDER_SOURCE_ID ) ;
1008: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
1009: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
1010: END IF;
1011:
1012: -- { Start of line fetch

Line 1009: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;

1005:
1006: IF l_debug_level > 0 THEN
1007: oe_debug_pub.add( 'ORDER SOURCE ID: ' || L_ORDER_SOURCE_ID ) ;
1008: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
1009: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
1010: END IF;
1011:
1012: -- { Start of line fetch
1013: --LINE---------------------LINE-----------------LINE----------------LINE-----

Line 1015: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;

1011:
1012: -- { Start of line fetch
1013: --LINE---------------------LINE-----------------LINE----------------LINE-----
1014: IF l_debug_level > 0 THEN
1015: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;
1016: END IF;
1017:
1018: l_line_count := 0;
1019:

Line 1039: oe_debug_pub.add( 'ASSIGNING RECORD TO LINE TABLE....LINE COUNT = ' || L_LINE_COUNT ) ;

1035: ---------------- --------------------------
1036: l_line_count := l_line_count + 1;
1037: ---------------- -------------------------
1038: IF l_debug_level > 0 THEN
1039: oe_debug_pub.add( 'ASSIGNING RECORD TO LINE TABLE....LINE COUNT = ' || L_LINE_COUNT ) ;
1040: END IF;
1041: ---------------- --------------------------
1042: l_line_tbl(l_line_count) := l_line_rec;
1043: ---------------- -------------------------

Line 1062: oe_debug_pub.add( 'END OF QUERY_INF_RECORDS' ) ;

1058: x_line_tbl := l_line_tbl;
1059: ------------------ -------------------------
1060:
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add( 'END OF QUERY_INF_RECORDS' ) ;
1063: END IF;
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF l_debug_level > 0 THEN

Line 1067: oe_debug_pub.add ('In others exception in query inf:' || SQLERRM);

1063: END IF;
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF l_debug_level > 0 THEN
1067: oe_debug_pub.add ('In others exception in query inf:' || SQLERRM);
1068: END IF;
1069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1070: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'query_inf_records');
1071: END IF;

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

1156: = decode(l_customer_key_profile, 'Y',
1157: nvl(p_sold_to_org_id, -999), 1);
1158:
1159: --
1160: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1161: --
1162: BEGIN
1163:
1164: -- { Check what parameters are passed

Line 1170: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_XML_ACKNOWLEDGMENT' ) ;

1166: -- should be null (as order never got created), otherwise use
1167: -- header_id to query the data from the base tables
1168:
1169: IF l_debug_level > 0 THEN
1170: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_XML_ACKNOWLEDGMENT' ) ;
1171: END IF;
1172: l_acknowledgment_type := p_transaction_type;
1173:
1174: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then

Line 1178: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

1174: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1175: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1176: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
1177: IF l_debug_level > 0 THEN
1178: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1179: END IF;
1180: End If;
1181:
1182: IF l_debug_level > 0 THEN

Line 1183: oe_debug_pub.add( 'request_id passed in:' || l_request_id ) ;

1179: END IF;
1180: End If;
1181:
1182: IF l_debug_level > 0 THEN
1183: oe_debug_pub.add( 'request_id passed in:' || l_request_id ) ;
1184: END IF;
1185:
1186: --If transaction is 3a6, the order has already been accepted.
1187: If p_transaction_type = G_TRANSACTION_SSO or p_transaction_type = G_TRANSACTION_CSO then

Line 1195: oe_debug_pub.add( 'OEXPACKB: HEADER ID IS NULL' ) ;

1191: -- { Start of p_header_id is null
1192: If p_header_id is NULL Then
1193:
1194: IF l_debug_level > 0 THEN
1195: oe_debug_pub.add( 'OEXPACKB: HEADER ID IS NULL' ) ;
1196: END IF;
1197: -- We need to check here to make sure if the order is created or rejected
1198: Begin
1199: Select orig_sys_document_ref

Line 1215: oe_debug_pub.add( 'OEXPACKB: GOT THE ORIG SYS DOCUMENT REF => ' || L_ORIG_SYS_DOCUMENT_REF ) ;

1211: And request_id = p_request_id;
1212: -- change sequence should go here, so should customer.
1213:
1214: IF l_debug_level > 0 THEN
1215: oe_debug_pub.add( 'OEXPACKB: GOT THE ORIG SYS DOCUMENT REF => ' || L_ORIG_SYS_DOCUMENT_REF ) ;
1216: END IF;
1217:
1218: Exception
1219: When NO_DATA_FOUND Then

Line 1222: oe_debug_pub.add( 'OEXPACKB: L_REJECT_ORDER IS SET TO N' ) ;

1218: Exception
1219: When NO_DATA_FOUND Then
1220: -- This means we are accepting the order let us set the flag
1221: IF l_debug_level > 0 THEN
1222: oe_debug_pub.add( 'OEXPACKB: L_REJECT_ORDER IS SET TO N' ) ;
1223: END IF;
1224: l_reject_order := 'N';
1225: When OTHERS Then
1226: -- Code here to raise error as not able to find the orig_sys_document_ref

Line 1228: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;

1224: l_reject_order := 'N';
1225: When OTHERS Then
1226: -- Code here to raise error as not able to find the orig_sys_document_ref
1227: IF l_debug_level > 0 THEN
1228: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1229: END IF;
1230: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1231: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1232: oe_msg_pub.add;

Line 1273: oe_debug_pub.add( 'OEXPACKB: GOT THE HEADER ID => ' || L_HEADER_ID ) ;

1269: );
1270: -- end bug 4195533
1271:
1272: IF l_debug_level > 0 THEN
1273: oe_debug_pub.add( 'OEXPACKB: GOT THE HEADER ID => ' || L_HEADER_ID ) ;
1274: END IF;
1275:
1276: Exception
1277: When OTHERS Then

Line 1280: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;

1276: Exception
1277: When OTHERS Then
1278: -- Code here to raise error as not able to find the header id
1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1281: END IF;
1282: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1283: fnd_message.set_token ('TABLE', 'oe_order_headers');
1284: oe_msg_pub.add;

Line 1315: oe_debug_pub.add ('Error in deriving value for Payment Term ' || SQLERRM);

1311: End If;
1312: Exception
1313: When Others Then
1314: If l_debug_level > 0 THEN
1315: oe_debug_pub.add ('Error in deriving value for Payment Term ' || SQLERRM);
1316: End If;
1317: End;
1318:
1319: --retrieving seeded header status in case of 3a6 generated from PROC

Line 1333: oe_debug_pub.add( 'RETRIEVED HEADER LAST_ACK_CODE: ' || L_HEADER_LAST_ACK_CODE ) ;

1329: and header_id = l_header_id
1330: and request_id = l_request_id;
1331:
1332: IF l_debug_level > 0 THEN
1333: oe_debug_pub.add( 'RETRIEVED HEADER LAST_ACK_CODE: ' || L_HEADER_LAST_ACK_CODE ) ;
1334: END IF;
1335: l_header_rec.last_ack_code := l_header_last_ack_code;
1336: Else
1337: -- 3a6 generated from concurrent program

Line 1350: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;

1346: Exception
1347: When Others Then
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1351: END IF;
1352: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1353: fnd_message.set_token ('TABLE', 'oe_order_headers');
1354: oe_msg_pub.add;

Line 1364: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;

1360: --{Call Query Row procedure to get the Line Data from Base
1361: -- OE_ORDER_LINES_ALL table
1362:
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1365: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;
1366: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1367: END IF;
1368:

Line 1365: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;

1361: -- OE_ORDER_LINES_ALL table
1362:
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1365: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;
1366: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1367: END IF;
1368:
1369: Begin

Line 1366: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;

1362:
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1365: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;
1366: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1367: END IF;
1368:
1369: Begin
1370: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)

Line 1376: oe_debug_pub.add( 'IN IF STATEMENT' ) ;

1372: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1373: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1374: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.add( 'IN IF STATEMENT' ) ;
1377: oe_debug_pub.add( P_START_FROM_FLOW || ' FLOW , WITH LINE_ID => ' || P_LINE_ID ) ;
1378: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1379: END IF;
1380: l_line_id := p_line_id;

Line 1377: oe_debug_pub.add( P_START_FROM_FLOW || ' FLOW , WITH LINE_ID => ' || P_LINE_ID ) ;

1373: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1374: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.add( 'IN IF STATEMENT' ) ;
1377: oe_debug_pub.add( P_START_FROM_FLOW || ' FLOW , WITH LINE_ID => ' || P_LINE_ID ) ;
1378: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1379: END IF;
1380: l_line_id := p_line_id;
1381: oe_line_util.query_rows ( p_header_id => l_header_id,

Line 1378: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;

1374: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.add( 'IN IF STATEMENT' ) ;
1377: oe_debug_pub.add( P_START_FROM_FLOW || ' FLOW , WITH LINE_ID => ' || P_LINE_ID ) ;
1378: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1379: END IF;
1380: l_line_id := p_line_id;
1381: oe_line_util.query_rows ( p_header_id => l_header_id,
1382: p_line_id => l_line_id,

Line 1411: oe_debug_pub.add( 'IN IF STATEMENT WITH TRANSACTION TYPE = '|| p_transaction_type ) ;

1407: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CPO)
1408: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CHO)
1409: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CHO) Then
1410: IF l_debug_level > 0 THEN
1411: oe_debug_pub.add( 'IN IF STATEMENT WITH TRANSACTION TYPE = '|| p_transaction_type ) ;
1412: END IF;
1413: Begin
1414: Select cancelled_flag
1415: Into l_cancelled_flag

Line 1419: oe_debug_pub.add( 'HEADER_ID: ' || L_HEADER_ID ) ;

1415: Into l_cancelled_flag
1416: From oe_order_headers
1417: Where header_id = l_header_id;
1418: IF l_debug_level > 0 THEN
1419: oe_debug_pub.add( 'HEADER_ID: ' || L_HEADER_ID ) ;
1420: END IF;
1421:
1422: If nvl(l_cancelled_flag, 'N') = 'N' Then
1423: l_ind_cntr := 0;

Line 1431: oe_debug_pub.add( 'FETCHED LINE ACK ID: ' || L_LINE_ACK_ID ) ;

1427: Into l_line_ack_id;
1428: Exit When Cancel_Line_Ack_Cur%NOTFOUND;
1429: IF l_line_ack_id IS NOT NULL THEN -- bug 3363327
1430: IF l_debug_level > 0 THEN
1431: oe_debug_pub.add( 'FETCHED LINE ACK ID: ' || L_LINE_ACK_ID ) ;
1432: END IF;
1433:
1434: l_line_rec := oe_line_util.query_row ( p_line_id => l_line_ack_id);
1435: END IF; -- end bug 3363327

Line 1446: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;

1442: Exception
1443: When Others Then
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --FND_API.G_RET_STS_SUCCESS;
1445: IF l_debug_level > 0 THEN
1446: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1447: END IF;
1448: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1449: fnd_message.set_token ('TABLE', 'oe_order_lines');
1450: oe_msg_pub.add;

Line 1459: oe_debug_pub.add( 'G_WFI_PROC FLOW' ) ;

1455: End If;
1456:
1457: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1458: IF l_debug_level > 0 THEN
1459: oe_debug_pub.add( 'G_WFI_PROC FLOW' ) ;
1460: END IF;
1461: -- l_acknowledgment_type := G_TRANSACTION_SSO;
1462: l_ind_cntr := 0;
1463:

Line 1472: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;

1468: Fetch sso_line_ack_cur
1469: Into l_line_ack_id, l_line_last_ack_code;
1470: If l_line_ack_id is Not Null Then
1471: IF l_debug_level > 0 THEN
1472: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;
1473: oe_debug_pub.add( 'RETRIEVED LINE LAST_ACK_CODE: ' || L_LINE_LAST_ACK_CODE ) ;
1474: END IF;
1475: l_line_rec :=
1476: oe_line_util.query_row ( p_line_id => l_line_ack_id);

Line 1473: oe_debug_pub.add( 'RETRIEVED LINE LAST_ACK_CODE: ' || L_LINE_LAST_ACK_CODE ) ;

1469: Into l_line_ack_id, l_line_last_ack_code;
1470: If l_line_ack_id is Not Null Then
1471: IF l_debug_level > 0 THEN
1472: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;
1473: oe_debug_pub.add( 'RETRIEVED LINE LAST_ACK_CODE: ' || L_LINE_LAST_ACK_CODE ) ;
1474: END IF;
1475: l_line_rec :=
1476: oe_line_util.query_row ( p_line_id => l_line_ack_id);
1477: l_line_rec.last_ack_code := l_line_last_ack_code;

Line 1491: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;

1487: Fetch line_ack_cur
1488: Into l_line_ack_id;
1489: If l_line_ack_id is Not Null Then
1490: IF l_debug_level > 0 THEN
1491: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;
1492: END IF;
1493: l_line_rec :=
1494: oe_line_util.query_row ( p_line_id => l_line_ack_id);
1495: End If;

Line 1508: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;

1504: Exception
1505: When Others Then
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1507: IF l_debug_level > 0 THEN
1508: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1509: END IF;
1510: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1511: fnd_message.set_token ('TABLE', 'oe_order_lines');
1512: oe_msg_pub.add;

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

1609: l_errmsg varchar2(2000);
1610: l_result boolean := FALSE;
1611: l_org_id Number := p_org_id;
1612: --
1613: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1614: --
1615: Begin
1616:
1617: IF l_debug_level > 0 THEN

Line 1618: oe_debug_pub.add( 'OEXPACKB: ENTERING IS_DELIVERY_REQUIRED' ) ;

1614: --
1615: Begin
1616:
1617: IF l_debug_level > 0 THEN
1618: oe_debug_pub.add( 'OEXPACKB: ENTERING IS_DELIVERY_REQUIRED' ) ;
1619: END IF;
1620:
1621: x_is_delivery_required := 'N';
1622: If p_org_id IS NULL Then

Line 1644: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;

1640: And b.status = 'A'
1641: And a.status ='A'; --bug 2752321
1642:
1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1645: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1646: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1647: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1648: END IF;

Line 1645: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;

1641: And a.status ='A'; --bug 2752321
1642:
1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1645: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1646: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1647: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1648: END IF;
1649: ecx_document.isDeliveryRequired

Line 1646: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;

1642:
1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1645: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1646: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1647: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1648: END IF;
1649: ecx_document.isDeliveryRequired
1650: (

Line 1647: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;

1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1645: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1646: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1647: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1648: END IF;
1649: ecx_document.isDeliveryRequired
1650: (
1651: transaction_type => p_transaction_type,

Line 1660: oe_debug_pub.add( 'AFTER CALL TO ISDELIVERY REQ ' || L_ERRMSG ) ;

1656: retcode => l_retcode,
1657: errmsg => l_errmsg
1658: );
1659: IF l_debug_level > 0 THEN
1660: oe_debug_pub.add( 'AFTER CALL TO ISDELIVERY REQ ' || L_ERRMSG ) ;
1661: END IF;
1662:
1663: IF (l_result) THEN
1664: x_is_delivery_required := 'Y';

Line 1668: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;

1664: x_is_delivery_required := 'Y';
1665: x_party_site_id := l_party_site_id;
1666: x_party_id := l_party_id;
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;
1669: END IF;
1670: ELSE
1671: x_is_delivery_required := 'N';
1672: x_party_site_id := l_party_site_id;

Line 1675: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;

1671: x_is_delivery_required := 'N';
1672: x_party_site_id := l_party_site_id;
1673: x_party_id := l_party_id;
1674: IF l_debug_level > 0 THEN
1675: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;
1676: END IF;
1677: END IF;
1678:
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1681: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED' ) ;

1677: END IF;
1678:
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED' ) ;
1682: END IF;
1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: IF l_debug_level > 0 THEN

Line 1686: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH NO_DATA_FOUND' ) ;

1682: END IF;
1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: IF l_debug_level > 0 THEN
1686: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH NO_DATA_FOUND' ) ;
1687: END IF;
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: -- start bug 3711152
1690: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');

Line 1696: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH OTHERS' ) ;

1692: -- oe_msg_pub.add;
1693: -- end bug 3711152
1694: WHEN OTHERS THEN
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH OTHERS' ) ;
1697: END IF;
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1700: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');

Line 1703: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1700: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');
1701: END IF;
1702: IF l_debug_level > 0 THEN
1703: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1704: END IF;
1705:
1706: End Is_Delivery_Required;
1707: -- End of the Is_Delivery_Required }

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

1795: -- Bug 13008311
1796:
1797: l_sync_line_inserted boolean := false; --Bug# 12879272
1798: --
1799: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1800: --
1801: Begin
1802:
1803: l_header_rec := p_header_rec;

Line 1826: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO, itemkeys are ' || l_itemkey_sso || ' and ' || l_itemkey_cso ) ;

1822: k := l_line_tbl.Next(k);
1823: end loop;*/
1824:
1825: IF l_debug_level > 0 THEN
1826: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO, itemkeys are ' || l_itemkey_sso || ' and ' || l_itemkey_cso ) ;
1827: END IF;
1828:
1829: IF NOT(OE_GENESIS_UTIL.source_aia_enabled(p_header_rec.order_source_id)) THEN -- GENESIS
1830: -- { Start step 1.

Line 1859: oe_debug_pub.add( 'OEXPACKB: is delivery required for 3a7 = ' || l_is_delivery_required_cso ) ;

1855: -- supporting holds via 3a6 also
1856: l_cso_response_profile := nvl(FND_PROFILE.VALUE ('ONT_3A7_RESPONSE_REQUIRED'), 'N');
1857: END IF;
1858: IF l_debug_level > 0 THEN
1859: oe_debug_pub.add( 'OEXPACKB: is delivery required for 3a7 = ' || l_is_delivery_required_cso ) ;
1860: oe_debug_pub.add( 'OEXPACKB: fetched CSO Response Required profile ' || l_cso_response_profile) ;
1861: END IF;
1862:
1863: End If;

Line 1860: oe_debug_pub.add( 'OEXPACKB: fetched CSO Response Required profile ' || l_cso_response_profile) ;

1856: l_cso_response_profile := nvl(FND_PROFILE.VALUE ('ONT_3A7_RESPONSE_REQUIRED'), 'N');
1857: END IF;
1858: IF l_debug_level > 0 THEN
1859: oe_debug_pub.add( 'OEXPACKB: is delivery required for 3a7 = ' || l_is_delivery_required_cso ) ;
1860: oe_debug_pub.add( 'OEXPACKB: fetched CSO Response Required profile ' || l_cso_response_profile) ;
1861: END IF;
1862:
1863: End If;
1864:

Line 1870: oe_debug_pub.add( 'OEXPACKB: NO DELIVERY IS REQUIRED SO RETURN' ) ;

1866: l_is_delivery_required_cso = 'N' AND
1867: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1868: -- No delivery is required so return, no further processing is required
1869: IF l_debug_level > 0 THEN
1870: oe_debug_pub.add( 'OEXPACKB: NO DELIVERY IS REQUIRED SO RETURN' ) ;
1871: END IF;
1872: x_return_status := FND_API.G_RET_STS_SUCCESS;
1873: return;
1874: end if;

Line 1879: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;

1875: END IF; -- Order source Id
1876:
1877:
1878: IF l_debug_level > 0 THEN
1879: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1880: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;

Line 1880: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;

1876:
1877:
1878: IF l_debug_level > 0 THEN
1879: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1880: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;

Line 1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;

1877:
1878: IF l_debug_level > 0 THEN
1879: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1880: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;

Line 1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;

1878: IF l_debug_level > 0 THEN
1879: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1880: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;

Line 1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;

1879: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1880: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;

Line 1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;

1880: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;

Line 1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;

1881: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;

Line 1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;

1882: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;

Line 1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;

1883: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;

Line 1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;

1884: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;

Line 1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;

1885: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;

Line 1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;

1886: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;

Line 1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;

1887: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;

Line 1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;

1888: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;

Line 1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;

1889: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;

Line 1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;

1890: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;

Line 1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;

1891: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;

Line 1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;

1892: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;

Line 1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;

1893: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;

Line 1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;

1894: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;

Line 1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;

1895: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;

Line 1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;

1896: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;

Line 1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;

1897: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;
1905:

Line 1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;

1898: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;
1905:
1906: -- End step 1. }

Line 1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;

1899: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1900: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1901: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1902: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1903: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1904: END IF;
1905:
1906: -- End step 1. }
1907:

Line 1918: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;

1914: -- i.e., when order booked first time, we need to send the 3A6.
1915: -- let us check for that
1916:
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1919: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1920: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1921: END IF;
1922:

Line 1919: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;

1915: -- let us check for that
1916:
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1919: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1920: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1921: END IF;
1922:
1923: l_header_req := 'N';

Line 1920: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;

1916:
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1919: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1920: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1921: END IF;
1922:
1923: l_header_req := 'N';
1924: l_header_req_cso := 'N';

Line 1928: oe_debug_pub.add( 'OEXPACKB: L_HEADER_REC.FLOW_STATUS_CODE = BOOKED' ) ;

1924: l_header_req_cso := 'N';
1925: if l_header_rec.flow_status_code = 'BOOKED' AND
1926: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1927: IF l_debug_level > 0 THEN
1928: oe_debug_pub.add( 'OEXPACKB: L_HEADER_REC.FLOW_STATUS_CODE = BOOKED' ) ;
1929: END IF;
1930: if nvl(p_old_header_rec.flow_status_code, 'BOOKED') <> 'BOOKED' And
1931: nvl(OE_ORDER_UTIL.g_header_rec.flow_status_code, 'N') = 'BOOKED' Then
1932: IF l_debug_level > 0 THEN

Line 1933: oe_debug_pub.add( 'OEXPACKB: P_OLD_HEADER_REC.FLOW_STATUS_CODE <> BOOKED' ) ;

1929: END IF;
1930: if nvl(p_old_header_rec.flow_status_code, 'BOOKED') <> 'BOOKED' And
1931: nvl(OE_ORDER_UTIL.g_header_rec.flow_status_code, 'N') = 'BOOKED' Then
1932: IF l_debug_level > 0 THEN
1933: oe_debug_pub.add( 'OEXPACKB: P_OLD_HEADER_REC.FLOW_STATUS_CODE <> BOOKED' ) ;
1934: END IF;
1935: -- This means that order is Booked right now, and this is the condidate
1936: -- for 3A6, set the flag to indicate that..
1937:

Line 1960: oe_debug_pub.add( 'OEXPACKB: L_HEADER_STATUS = BOOKED' ) ;

1956: END IF;
1957: END IF;
1958:
1959: IF l_debug_level > 0 THEN
1960: oe_debug_pub.add( 'OEXPACKB: L_HEADER_STATUS = BOOKED' ) ;
1961: oe_debug_pub.add( 'OEXPACKB: L_IS_DELIVERY_REQD_CSO = ' || l_is_delivery_required_cso ) ;
1962: END IF;
1963: l_header_status := 'BOOKED';
1964: l_header_status_cso := 'BOOKED';

Line 1961: oe_debug_pub.add( 'OEXPACKB: L_IS_DELIVERY_REQD_CSO = ' || l_is_delivery_required_cso ) ;

1957: END IF;
1958:
1959: IF l_debug_level > 0 THEN
1960: oe_debug_pub.add( 'OEXPACKB: L_HEADER_STATUS = BOOKED' ) ;
1961: oe_debug_pub.add( 'OEXPACKB: L_IS_DELIVERY_REQD_CSO = ' || l_is_delivery_required_cso ) ;
1962: END IF;
1963: l_header_status := 'BOOKED';
1964: l_header_status_cso := 'BOOKED';
1965: end if;

Line 1991: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');

1987: l_header_status := l_header_rec.flow_status_code;
1988: l_sync_header := 'Y';
1989:
1990: IF l_debug_level > 0 THEN
1991: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1992: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1993: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1994: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1995: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);

Line 1992: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);

1988: l_sync_header := 'Y';
1989:
1990: IF l_debug_level > 0 THEN
1991: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1992: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1993: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1994: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1995: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1996: END IF;

Line 1993: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);

1989:
1990: IF l_debug_level > 0 THEN
1991: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1992: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1993: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1994: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1995: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1996: END IF;
1997: -- GENESIS --

Line 1994: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);

1990: IF l_debug_level > 0 THEN
1991: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1992: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1993: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1994: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1995: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1996: END IF;
1997: -- GENESIS --
1998: end if;

Line 1995: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);

1991: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1992: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1993: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1994: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1995: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1996: END IF;
1997: -- GENESIS --
1998: end if;
1999: -- End step 2a. }

Line 2009: oe_debug_pub.add( 'OEXPACKB: BEFORE THE WHILE LOOP' ) ;

2005: -- we need to send the 3A6 for above cases
2006: -- let us check for that
2007:
2008: IF l_debug_level > 0 THEN
2009: oe_debug_pub.add( 'OEXPACKB: BEFORE THE WHILE LOOP' ) ;
2010: END IF;
2011: -- Following For loop is changed to while because of new Notify_OC change
2012: -- for i in 1..l_line_tbl.count
2013: -- loop

Line 2017: oe_debug_pub.add( 'OEXPACKB: INSIDE THE FOR LOOP FOR I = ' || I ) ;

2013: -- loop
2014: i := l_line_tbl.First;
2015: while i is not null loop
2016: IF l_debug_level > 0 THEN
2017: oe_debug_pub.add( 'OEXPACKB: INSIDE THE FOR LOOP FOR I = ' || I ) ;
2018: END IF;
2019: -- resetting whether or not a particular line is required
2020: -- and whether attributes have changed. added 11/12/02 -jjmcfarl
2021: l_line_req := 'N';

Line 2039: oe_debug_pub.add( 'tested version line_id: ' || l_line_tbl(i).line_id);

2035: l_3a7_buyer_line := FALSE;
2036: l_sync_line_inserted := FALSE; --Bug# 12879272
2037:
2038: IF l_debug_level > 0 THEN
2039: oe_debug_pub.add( 'tested version line_id: ' || l_line_tbl(i).line_id);
2040: oe_debug_pub.add( 'passed in version line_id: ' || p_line_tbl(i).line_id);
2041: oe_debug_pub.add( 'old version line_id: ' || p_old_line_tbl(i).line_id);
2042: END IF;
2043:

Line 2040: oe_debug_pub.add( 'passed in version line_id: ' || p_line_tbl(i).line_id);

2036: l_sync_line_inserted := FALSE; --Bug# 12879272
2037:
2038: IF l_debug_level > 0 THEN
2039: oe_debug_pub.add( 'tested version line_id: ' || l_line_tbl(i).line_id);
2040: oe_debug_pub.add( 'passed in version line_id: ' || p_line_tbl(i).line_id);
2041: oe_debug_pub.add( 'old version line_id: ' || p_old_line_tbl(i).line_id);
2042: END IF;
2043:
2044: -- moved the derivation of the j index outside of the UPDATE if-statement that

Line 2041: oe_debug_pub.add( 'old version line_id: ' || p_old_line_tbl(i).line_id);

2037:
2038: IF l_debug_level > 0 THEN
2039: oe_debug_pub.add( 'tested version line_id: ' || l_line_tbl(i).line_id);
2040: oe_debug_pub.add( 'passed in version line_id: ' || p_line_tbl(i).line_id);
2041: oe_debug_pub.add( 'old version line_id: ' || p_old_line_tbl(i).line_id);
2042: END IF;
2043:
2044: -- moved the derivation of the j index outside of the UPDATE if-statement that
2045: -- follows. this is done so that j will be derived for both update and create

Line 2052: oe_debug_pub.add( 'got line index - test1: ' || j);

2048: j := i;
2049: else
2050: j := get_line_index(p_old_line_tbl, l_line_tbl(i).line_id);
2051: IF l_debug_level > 0 THEN
2052: oe_debug_pub.add( 'got line index - test1: ' || j);
2053: END IF;
2054: end if;
2055:
2056: -- { Start for the comparision when the operation on the Line table

Line 2073: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS UPDATE' ) ;

2069: THEN
2070: -- Bug 13008311 : End
2071:
2072: IF l_debug_level > 0 THEN
2073: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS UPDATE' ) ;
2074: END IF;
2075:
2076: IF l_debug_level > 0 THEN
2077: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;

Line 2077: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;

2073: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS UPDATE' ) ;
2074: END IF;
2075:
2076: IF l_debug_level > 0 THEN
2077: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2078: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;

Line 2078: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;

2074: END IF;
2075:
2076: IF l_debug_level > 0 THEN
2077: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2078: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;

Line 2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;

2075:
2076: IF l_debug_level > 0 THEN
2077: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2078: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;

Line 2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;

2076: IF l_debug_level > 0 THEN
2077: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2078: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;

Line 2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;

2077: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2078: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;

Line 2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;

2078: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;

Line 2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;

2079: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;

Line 2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;

2080: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;

Line 2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;

2081: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;

Line 2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;

2082: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;

Line 2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;

2083: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;

Line 2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;

2084: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;

Line 2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;

2085: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;

Line 2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;

2086: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;

Line 2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;

2087: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;

Line 2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;

2088: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;

Line 2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;

2089: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;

Line 2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;

2090: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;

Line 2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;

2091: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;

Line 2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;

2092: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;

Line 2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;

2093: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;

Line 2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;

2094: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2102: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;

Line 2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;

2095: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2102: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2103: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;

Line 2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;

2096: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2102: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2103: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2104: END IF;

Line 2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;

2097: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2102: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2103: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2104: END IF;
2105:

Line 2102: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;

2098: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2102: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2103: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2104: END IF;
2105:
2106: -- { start j <> 0

Line 2103: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;

2099: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2100: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2101: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2102: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2103: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2104: END IF;
2105:
2106: -- { start j <> 0
2107: if j <> 0 then

Line 2113: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT UNIT_SELLING_PRICE' ) ;

2109: if nvl(l_line_tbl(i).unit_selling_price, 0) <>
2110: nvl(p_old_line_tbl(j).unit_selling_price, 0) then
2111: -- set flag to indicate that unit_selling_price has changed
2112: IF l_debug_level > 0 THEN
2113: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT UNIT_SELLING_PRICE' ) ;
2114: END IF;
2115: l_change_usp := 'Y';
2116: l_change_usp_cso := 'Y';
2117: end if; -- unit_selling_price

Line 2123: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDERED_QUANTITY' ) ;

2119: if nvl(l_line_tbl(i).ordered_quantity, 0) <>
2120: nvl(p_old_line_tbl(j).ordered_quantity, 0) then
2121: -- set flag to indicate that ordered_quantity has changed
2122: IF l_debug_level > 0 THEN
2123: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDERED_QUANTITY' ) ;
2124: END IF;
2125: l_change_oqty := 'Y';
2126: l_change_oqty_cso := 'Y';
2127: -- GENESIS --

Line 2132: oe_debug_pub.add( 'Genesis: Set line flag for ordered quantity change');

2128: l_sync_line := 'Y';
2129: l_insert_sync_line := 'Y';
2130: l_change_type := 'SPLIT';
2131: IF l_debug_level > 0 THEN
2132: oe_debug_pub.add( 'Genesis: Set line flag for ordered quantity change');
2133: END IF;
2134: -- GENESIS --
2135: end if; -- ordered_quantity
2136:

Line 2141: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDER_QUANTITY_UOM' ) ;

2137: if not oe_globals.equal (l_line_tbl(i).order_quantity_uom,
2138: p_old_line_tbl(j).order_quantity_uom) then
2139: -- set flag to indicate that uom has changed
2140: IF l_debug_level > 0 THEN
2141: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDER_QUANTITY_UOM' ) ;
2142: END IF;
2143: l_change_uom := 'Y';
2144: l_change_uom_cso := 'Y';
2145: end if;

Line 2151: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SCHEDULE_ARRIVAL_DATE' ) ;

2147: if nvl(l_line_tbl(i).schedule_arrival_date, trunc(sysdate)) <>
2148: nvl(p_old_line_tbl(j).schedule_arrival_date, trunc(sysdate)) then
2149: -- set flag to indicate that schedule_arrival_date has changed
2150: IF l_debug_level > 0 THEN
2151: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SCHEDULE_ARRIVAL_DATE' ) ;
2152: END IF;
2153: l_change_sadt := 'Y';
2154: -- GENESIS --
2155: l_sync_line := 'Y';

Line 2159: oe_debug_pub.add( 'Genesis: Set line flag for schedule arrival date change');

2155: l_sync_line := 'Y';
2156: l_insert_sync_line := 'Y';
2157: l_change_type := 'ARVL_DT_CHG';
2158: IF l_debug_level > 0 THEN
2159: oe_debug_pub.add( 'Genesis: Set line flag for schedule arrival date change');
2160: END IF;
2161: -- GENESIS --
2162: end if; -- schedule_arrival_date
2163: if nvl(l_line_tbl(i).shipped_quantity, 0) <>

Line 2167: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SHIPPED_QUANTITY' ) ;

2163: if nvl(l_line_tbl(i).shipped_quantity, 0) <>
2164: nvl(p_old_line_tbl(j).shipped_quantity, 0) then
2165: -- set flag to indicate that shipped_quantity has changed
2166: IF l_debug_level > 0 THEN
2167: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SHIPPED_QUANTITY' ) ;
2168: END IF;
2169: l_change_sqty := 'Y';
2170: end if; -- shipped_quantity
2171: if nvl(l_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>

Line 2175: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SCHEDULE_SHIP_DATE' ) ;

2171: if nvl(l_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>
2172: nvl(p_old_line_tbl(j).schedule_ship_date, trunc(sysdate)) then
2173: -- set flag to indicate that schedule_ship_date has changed
2174: IF l_debug_level > 0 THEN
2175: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SCHEDULE_SHIP_DATE' ) ;
2176: END IF;
2177: l_change_ssdt := 'Y';
2178: l_change_ssdt_cso := 'Y';
2179: -- GENESIS --

Line 2184: oe_debug_pub.add( 'Genesis: Set line flag for schedule ship date change');

2180: l_sync_line := 'Y';
2181: l_insert_sync_line := 'Y';
2182: l_change_type := 'SHIP_DT_CHG';
2183: IF l_debug_level > 0 THEN
2184: oe_debug_pub.add( 'Genesis: Set line flag for schedule ship date change');
2185: END IF;
2186: -- GENESIS --
2187: end if; -- schedule_ship_date
2188:

Line 2197: oe_debug_pub.ADD('Genesis: set line flag for ship from org id change');

2193: l_sync_line := 'Y';
2194: l_insert_sync_line := 'Y';
2195: l_change_type := 'SHP_FRM_CHG';
2196: IF l_debug_level > 0 THEN
2197: oe_debug_pub.ADD('Genesis: set line flag for ship from org id change');
2198: END IF;
2199: END IF;
2200: -- O2C 25:ship from org id
2201:

Line 2210: oe_debug_pub.ADD('Genesis: set line flag for shipping_method_code change');

2206: l_sync_line := 'Y';
2207: l_insert_sync_line := 'Y';
2208: l_change_type := 'SHP_MTH_CHG';
2209: IF l_debug_level > 0 THEN
2210: oe_debug_pub.ADD('Genesis: set line flag for shipping_method_code change');
2211: END IF;
2212: END IF;
2213: -- O2C 25:shipping_method_code (End changes for Bug 8936919 gabhatia)
2214:

Line 2232: oe_debug_pub.add( 'Genesis: Set line flag for line flow status code change');

2228: l_insert_sync_line := 'Y';
2229: l_change_type := 'LINE_STATUS';
2230:
2231: IF l_debug_level > 0 THEN
2232: oe_debug_pub.add( 'Genesis: Set line flag for line flow status code change');
2233: END IF;
2234: END IF;
2235:
2236: -- Call Sync Line to process multiple lines ZB

Line 2238: oe_debug_pub.add( 'Genesis: l_sync_line '|| l_sync_line);

2234: END IF;
2235:
2236: -- Call Sync Line to process multiple lines ZB
2237: IF l_debug_level > 0 THEN
2238: oe_debug_pub.add( 'Genesis: l_sync_line '|| l_sync_line);
2239: oe_debug_pub.add( 'Genesis: l_insert_sync_line '|| l_insert_sync_line);
2240: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2241: END IF;
2242:

Line 2239: oe_debug_pub.add( 'Genesis: l_insert_sync_line '|| l_insert_sync_line);

2235:
2236: -- Call Sync Line to process multiple lines ZB
2237: IF l_debug_level > 0 THEN
2238: oe_debug_pub.add( 'Genesis: l_sync_line '|| l_sync_line);
2239: oe_debug_pub.add( 'Genesis: l_insert_sync_line '|| l_insert_sync_line);
2240: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2241: END IF;
2242:
2243: IF l_insert_sync_line = 'Y' and

Line 2240: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);

2236: -- Call Sync Line to process multiple lines ZB
2237: IF l_debug_level > 0 THEN
2238: oe_debug_pub.add( 'Genesis: l_sync_line '|| l_sync_line);
2239: oe_debug_pub.add( 'Genesis: l_insert_sync_line '|| l_insert_sync_line);
2240: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2241: END IF;
2242:
2243: IF l_insert_sync_line = 'Y' and
2244: (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN

Line 2256: oe_debug_pub.add('l_sync_line_inserted: TRUE');

2252: p_change_type => l_change_type,
2253: p_req_id => l_itemkey_sso,
2254: X_RETURN_STATUS => L_RETURN_STATUS);
2255: l_sync_line_inserted := TRUE;
2256: oe_debug_pub.add('l_sync_line_inserted: TRUE');
2257: END IF;
2258: -- end of IF added for Bug# 12879272
2259: END IF;
2260: l_insert_sync_line := 'N';

Line 2262: oe_debug_pub.add( 'Genesis: after insert :l_insert_sync_line '|| l_insert_sync_line);

2258: -- end of IF added for Bug# 12879272
2259: END IF;
2260: l_insert_sync_line := 'N';
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'Genesis: after insert :l_insert_sync_line '|| l_insert_sync_line);
2263: END IF;
2264: -- GENESIS --
2265:
2266: IF l_change_oqty_cso = 'Y' OR

Line 2307: Oe_Debug_Pub.Add('OEXPACKB: - value of j: ' || j);

2303: -- So, we call this API if and only if 'j' is not equal to 0.
2304: ---
2305: IF j <> 0 THEN
2306: If l_debug_level > 0 Then
2307: Oe_Debug_Pub.Add('OEXPACKB: - value of j: ' || j);
2308: End If;
2309: is_line_exists(p_line_tbl(j).line_id,l_line_exists); -- Bug 9685021
2310: If l_debug_level > 0 Then
2311: Oe_Debug_Pub.Add('OEXPACKB: - Loc 1 Done with is_line_exists; return value: ' || l_line_exists);

Line 2311: Oe_Debug_Pub.Add('OEXPACKB: - Loc 1 Done with is_line_exists; return value: ' || l_line_exists);

2307: Oe_Debug_Pub.Add('OEXPACKB: - value of j: ' || j);
2308: End If;
2309: is_line_exists(p_line_tbl(j).line_id,l_line_exists); -- Bug 9685021
2310: If l_debug_level > 0 Then
2311: Oe_Debug_Pub.Add('OEXPACKB: - Loc 1 Done with is_line_exists; return value: ' || l_line_exists);
2312: End If;
2313: END IF;
2314:
2315:

Line 2324: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;

2320: and NOT OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id) ) -- bug 11078158
2321: ) then
2322:
2323: IF l_debug_level > 0 THEN
2324: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2325: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2326: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2327: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2328: END IF;

Line 2325: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;

2321: ) then
2322:
2323: IF l_debug_level > 0 THEN
2324: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2325: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2326: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2327: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2328: END IF;
2329: ------------------------------

Line 2326: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;

2322:
2323: IF l_debug_level > 0 THEN
2324: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2325: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2326: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2327: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2328: END IF;
2329: ------------------------------
2330: -- GENESIS --

Line 2327: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;

2323: IF l_debug_level > 0 THEN
2324: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2325: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2326: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2327: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2328: END IF;
2329: ------------------------------
2330: -- GENESIS --
2331: -- Added this code to handle split case

Line 2334: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).item_type_code'||p_line_tbl(i).item_type_code) ;

2330: -- GENESIS --
2331: -- Added this code to handle split case
2332: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2333: IF l_debug_level > 0 THEN
2334: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).item_type_code'||p_line_tbl(i).item_type_code) ;
2335: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).split_from_line_id'||p_line_tbl(i).split_from_line_id) ;
2336: END IF;
2337: l_sync_line := 'Y';
2338: IF (l_line_tbl(i).SPLIT_FROM_LINE_ID IS NOT NULL OR l_line_tbl(i).item_type_code <> 'CONFIG') THEN

Line 2335: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).split_from_line_id'||p_line_tbl(i).split_from_line_id) ;

2331: -- Added this code to handle split case
2332: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2333: IF l_debug_level > 0 THEN
2334: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).item_type_code'||p_line_tbl(i).item_type_code) ;
2335: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).split_from_line_id'||p_line_tbl(i).split_from_line_id) ;
2336: END IF;
2337: l_sync_line := 'Y';
2338: IF (l_line_tbl(i).SPLIT_FROM_LINE_ID IS NOT NULL OR l_line_tbl(i).item_type_code <> 'CONFIG') THEN
2339: -- Bug# 12879272

Line 2350: oe_debug_pub.add('l_sync_line_inserted: TRUE');

2346: p_change_type => l_change_type,
2347: p_req_id => l_itemkey_sso,
2348: X_RETURN_STATUS => L_RETURN_STATUS);
2349: l_sync_line_inserted := TRUE;
2350: oe_debug_pub.add('l_sync_line_inserted: TRUE');
2351: ELSE
2352: oe_debug_pub.add('No need to insert an acknowledgement, since one was already inserted');
2353: END IF;
2354: -- end of IF added for Bug# 12879272

Line 2352: oe_debug_pub.add('No need to insert an acknowledgement, since one was already inserted');

2348: X_RETURN_STATUS => L_RETURN_STATUS);
2349: l_sync_line_inserted := TRUE;
2350: oe_debug_pub.add('l_sync_line_inserted: TRUE');
2351: ELSE
2352: oe_debug_pub.add('No need to insert an acknowledgement, since one was already inserted');
2353: END IF;
2354: -- end of IF added for Bug# 12879272
2355: END IF;
2356: END IF;

Line 2484: oe_debug_pub.add('3A7 Buyer change detected, line will not be sent or put on hold');

2480: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2481: AND nvl(l_header_rec.cancelled_flag,'N') = 'Y')
2482: THEN
2483: IF l_debug_level > 0 THEN
2484: oe_debug_pub.add('3A7 Buyer change detected, line will not be sent or put on hold');
2485: END IF;
2486: l_3a7_buyer_line := TRUE;
2487: l_line_req_cso := 'N'; -- don't insert the line
2488: END IF;

Line 2513: oe_debug_pub.add( 'Calling OE_Acknowlegment_PUB.Apply_3A7_Hold', 2 ) ;

2509: AND nvl(l_line_tbl(i).xml_transaction_type_code, G_TRANSACTION_CSO) = G_TRANSACTION_CSO
2510: THEN
2511:
2512: IF l_debug_level > 0 THEN
2513: oe_debug_pub.add( 'Calling OE_Acknowlegment_PUB.Apply_3A7_Hold', 2 ) ;
2514: END IF;
2515: OE_Acknowledgment_PUB.Apply_3A7_Hold
2516: ( p_header_id => l_line_tbl(i).header_id
2517: , p_line_id => l_line_tbl(i).line_id

Line 2522: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;

2518: , p_sold_to_org_id => l_line_tbl(i).sold_to_org_id
2519: , p_tp_check => FND_API.G_FALSE
2520: , x_return_status => l_return_status);
2521: IF l_debug_level > 0 THEN
2522: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2523: END IF;
2524: END IF;
2525: END IF;
2526: END IF;

Line 2531: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;

2527: -- end of 3a7 hold application
2528:
2529: -- { Start of l_line_req
2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2532: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2533: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2534: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2535: END IF;

Line 2532: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;

2528:
2529: -- { Start of l_line_req
2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2532: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2533: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2534: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2535: END IF;
2536: if (l_line_req = 'Y') OR (l_header_status = 'BOOKED') then

Line 2533: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;

2529: -- { Start of l_line_req
2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2532: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2533: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2534: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2535: END IF;
2536: if (l_line_req = 'Y') OR (l_header_status = 'BOOKED') then
2537: -- Call insert routine to insert header_id and status info

Line 2534: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;

2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2532: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2533: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2534: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2535: END IF;
2536: if (l_line_req = 'Y') OR (l_header_status = 'BOOKED') then
2537: -- Call insert routine to insert header_id and status info
2538: If l_header_req = 'Y' Then

Line 2570: oe_debug_pub.add( 'INSERTING LINE RECORD WITH INDEX = ' || I ) ;

2566: -- Call insert routine to insert line_id and status info
2567: -- which will later be used to populate data in line ack
2568: -- table
2569: IF l_debug_level > 0 THEN
2570: oe_debug_pub.add( 'INSERTING LINE RECORD WITH INDEX = ' || I ) ;
2571: END IF;
2572: l_line_rec := l_line_tbl(i);
2573:
2574: --ensure that a valid line has been pulled from the lines table

Line 2577: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;

2573:
2574: --ensure that a valid line has been pulled from the lines table
2575: If l_line_rec.line_id is not null then
2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2578: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2579: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2580: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2581: END IF;

Line 2578: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;

2574: --ensure that a valid line has been pulled from the lines table
2575: If l_line_rec.line_id is not null then
2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2578: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2579: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2580: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2581: END IF;
2582:

Line 2579: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;

2575: If l_line_rec.line_id is not null then
2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2578: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2579: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2580: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2581: END IF;
2582:
2583: -- GENESIS --

Line 2580: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;

2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2578: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2579: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2580: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2581: END IF;
2582:
2583: -- GENESIS --
2584: oe_debug_pub.add( 'Genesis: 6.1');

Line 2584: oe_debug_pub.add( 'Genesis: 6.1');

2580: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2581: END IF;
2582:
2583: -- GENESIS --
2584: oe_debug_pub.add( 'Genesis: 6.1');
2585: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2586: l_ack_type := G_TRANSACTION_SEBL;
2587: ELSE
2588: l_ack_type := G_TRANSACTION_SSO;

Line 2605: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;

2601: end if;
2602:
2603: -- { Start of l_line_req_cso
2604: IF l_debug_level > 0 THEN
2605: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2606: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2607: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2608: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2609: END IF;

Line 2606: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;

2602:
2603: -- { Start of l_line_req_cso
2604: IF l_debug_level > 0 THEN
2605: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2606: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2607: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2608: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2609: END IF;
2610: if (l_line_req_cso = 'Y') OR (l_header_status_cso = 'BOOKED') then

Line 2607: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;

2603: -- { Start of l_line_req_cso
2604: IF l_debug_level > 0 THEN
2605: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2606: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2607: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2608: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2609: END IF;
2610: if (l_line_req_cso = 'Y') OR (l_header_status_cso = 'BOOKED') then
2611: -- Call insert routine to insert header_id and status info

Line 2608: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;

2604: IF l_debug_level > 0 THEN
2605: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2606: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2607: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2608: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2609: END IF;
2610: if (l_line_req_cso = 'Y') OR (l_header_status_cso = 'BOOKED') then
2611: -- Call insert routine to insert header_id and status info
2612: If l_header_req_cso = 'Y' Then

Line 2637: oe_debug_pub.add( 'INSERTING LINE RECORD WITH INDEX = ' || I ) ;

2633: -- Call insert routine to insert line_id and status info
2634: -- which will later be used to populate data in line ack
2635: -- table
2636: IF l_debug_level > 0 THEN
2637: oe_debug_pub.add( 'INSERTING LINE RECORD WITH INDEX = ' || I ) ;
2638: END IF;
2639: l_line_rec := l_line_tbl(i);
2640:
2641: --ensure that a valid line has been pulled from the lines table

Line 2644: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;

2640:
2641: --ensure that a valid line has been pulled from the lines table
2642: If l_line_rec.line_id is not null then
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2645: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2646: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2647: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2648: END IF;

Line 2645: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;

2641: --ensure that a valid line has been pulled from the lines table
2642: If l_line_rec.line_id is not null then
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2645: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2646: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2647: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2648: END IF;
2649: If l_is_delivery_required_cso = 'Y' Then

Line 2646: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;

2642: If l_line_rec.line_id is not null then
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2645: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2646: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2647: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2648: END IF;
2649: If l_is_delivery_required_cso = 'Y' Then
2650: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510'

Line 2647: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;

2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2645: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2646: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2647: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2648: END IF;
2649: If l_is_delivery_required_cso = 'Y' Then
2650: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510'
2651: AND l_cso_response_profile = 'Y' THEN

Line 2654: oe_debug_pub.add( 'Process SSO: Check If Hold Already Applied' ) ;

2650: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510'
2651: AND l_cso_response_profile = 'Y' THEN
2652: -- Check if Hold already exists on this order line
2653: IF l_debug_level > 0 THEN
2654: oe_debug_pub.add( 'Process SSO: Check If Hold Already Applied' ) ;
2655: END IF;
2656:
2657: OE_HOLDS_PUB.Check_Holds
2658: ( p_api_version => 1.0

Line 2672: oe_debug_pub.add( 'Process SSO: Hold Already Applied On Header Id:'

2668: );
2669:
2670: IF l_hold_result = FND_API.G_TRUE THEN
2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add( 'Process SSO: Hold Already Applied On Header Id:'
2673: ||l_header_rec.header_id ||': Line_Id:'||l_line_tbl(i).line_id) ;
2674: oe_debug_pub.add( 'Change line status for 3A7');
2675: END IF;
2676: l_line_status_cso := 'ON HOLD';

Line 2674: oe_debug_pub.add( 'Change line status for 3A7');

2670: IF l_hold_result = FND_API.G_TRUE THEN
2671: IF l_debug_level > 0 THEN
2672: oe_debug_pub.add( 'Process SSO: Hold Already Applied On Header Id:'
2673: ||l_header_rec.header_id ||': Line_Id:'||l_line_tbl(i).line_id) ;
2674: oe_debug_pub.add( 'Change line status for 3A7');
2675: END IF;
2676: l_line_status_cso := 'ON HOLD';
2677: END IF ;
2678: END IF;

Line 2754: oe_debug_pub.add( 'Raising 3a6 event with itemkey: ' || l_itemkey_sso) ;

2750: -- Raise ShowSo Event
2751: If l_is_delivery_required = 'Y' Then
2752:
2753: IF l_debug_level > 0 THEN
2754: oe_debug_pub.add( 'Raising 3a6 event with itemkey: ' || l_itemkey_sso) ;
2755: END IF;
2756:
2757: OE_Acknowledgment_Pub.Raise_Event_Showso
2758: (p_header_id => l_header_rec.header_id,

Line 2777: oe_debug_pub.add( 'Raising 3a7 event with itemkey: ' || l_itemkey_cso) ;

2773: if l_header_req_cso = 'D' then
2774: If l_is_delivery_required_cso = 'Y' Then
2775: -- If l_order_booked_cso = 'Y' Then
2776: IF l_debug_level > 0 THEN
2777: oe_debug_pub.add( 'Raising 3a7 event with itemkey: ' || l_itemkey_cso) ;
2778: END IF;
2779:
2780: OE_Acknowledgment_Pub.Raise_Event_Showso
2781: (p_header_id => l_header_rec.header_id,

Line 2804: oe_debug_pub.add('GENESIS PROCESS_SSO : l_sync_header:'|| l_sync_header || ', l_sync_line:'

2800: l_sync_line_id := NULL;
2801: l_lin_req_id := NULL;
2802:
2803: IF l_debug_level > 0 THEN
2804: oe_debug_pub.add('GENESIS PROCESS_SSO : l_sync_header:'|| l_sync_header || ', l_sync_line:'
2805: || l_sync_line || ', l_change_type:'
2806: || l_change_type);
2807: END IF;
2808:

Line 2812: oe_debug_pub.add('TESTING GENESIS 15...'||l_header_rec.order_source_id);

2808:
2809: IF ( (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND l_sync_header = 'Y') THEN
2810:
2811: IF l_debug_level > 0 THEN
2812: oe_debug_pub.add('TESTING GENESIS 15...'||l_header_rec.order_source_id);
2813: END IF;
2814:
2815: IF l_sync_header = 'Y' THEN
2816: l_sync_header_id := l_header_rec.header_id;

Line 2826: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);

2822: l_lin_req_id := l_line_rec.request_id;
2823: END IF;
2824:
2825: IF l_debug_level > 0 THEN
2826: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2827: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2828: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2829: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2830: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );

Line 2827: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);

2823: END IF;
2824:
2825: IF l_debug_level > 0 THEN
2826: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2827: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2828: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2829: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2830: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2831: END IF;

Line 2828: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);

2824:
2825: IF l_debug_level > 0 THEN
2826: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2827: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2828: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2829: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2830: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2831: END IF;
2832:

Line 2829: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);

2825: IF l_debug_level > 0 THEN
2826: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2827: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2828: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2829: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2830: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2831: END IF;
2832:
2833: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec

Line 2830: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );

2826: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2827: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2828: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2829: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2830: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2831: END IF;
2832:
2833: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec
2834: ,p_line_rec => null

Line 2849: oe_debug_pub.add( 'OEXPACKB: EXITING PROCESS_SSO' ) ;

2845:
2846: -- End of 3. }
2847:
2848: IF l_debug_level > 0 THEN
2849: oe_debug_pub.add( 'OEXPACKB: EXITING PROCESS_SSO' ) ;
2850: END IF;
2851: Exception
2852: When Others Then
2853: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

2911: AND nvl(cust_po_number, -99) BETWEEN nvl(p_customer_po_no_from,nvl(cust_po_number, -99)) AND nvl(p_customer_po_no_to,nvl(cust_po_number, -99))
2912: AND org_id = nvl(p_operating_unit,org_id);
2913:
2914: --
2915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2916: --
2917: BEGIN
2918:
2919: IF l_debug_level > 0 THEN

Line 2920: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO_CONC_PGM' ) ;

2916: --
2917: BEGIN
2918:
2919: IF l_debug_level > 0 THEN
2920: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO_CONC_PGM' ) ;
2921: END IF;
2922:
2923: IF p_operating_unit IS NOT NULL THEN
2924: MO_GLOBAL.set_policy_context('S',p_operating_unit);

Line 2963: l_filename := oe_debug_pub.set_debug_mode ('FILE');

2959: -- Setting Debug Mode and File
2960: -----------------------------------------------------------
2961:
2962: If nvl(l_debug_level, 1) > 0 Then
2963: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2964: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2965: fnd_file.put_line(FND_FILE.OUTPUT, '');
2966: END IF;
2967: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

Line 2967: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

2963: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2964: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2965: fnd_file.put_line(FND_FILE.OUTPUT, '');
2966: END IF;
2967: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
2968:
2969: -----------------------------------------------------------
2970: -- Get Concurrent Request Id
2971: -----------------------------------------------------------

Line 2974: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;

2970: -- Get Concurrent Request Id
2971: -----------------------------------------------------------
2972:
2973: IF l_debug_level > 0 THEN
2974: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
2975: END IF;
2976: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
2977: IF l_debug_level > 0 THEN
2978: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;

Line 2978: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;

2974: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
2975: END IF;
2976: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
2977: IF l_debug_level > 0 THEN
2978: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
2979: END IF;
2980: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
2981:
2982: OPEN c_order_for_customer;

Line 2995: oe_debug_pub.add( 'COUNT: '||L_ORDER_COUNT ) ;

2991: CLOSE c_order_for_customer;
2992:
2993: l_order_count := l_order_rec.header_id.count;
2994: IF l_debug_level > 0 THEN
2995: oe_debug_pub.add( 'COUNT: '||L_ORDER_COUNT ) ;
2996: END IF;
2997: IF l_order_count > 0 THEN
2998:
2999: -----------------------------------------------------------

Line 3004: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;

3000: -- Raise event for all orders fetched
3001: -----------------------------------------------------------
3002: FOR i IN 1..l_order_count LOOP
3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;

Line 3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;

3001: -----------------------------------------------------------
3002: FOR i IN 1..l_order_count LOOP
3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
3009: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;

Line 3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;

3002: FOR i IN 1..l_order_count LOOP
3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
3009: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
3010: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;

Line 3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;

3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
3009: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
3010: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
3011: END IF;

Line 3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;

3004: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
3009: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
3010: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
3011: END IF;
3012:

Line 3009: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;

3005: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
3009: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
3010: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
3011: END IF;
3012:
3013: Is_Delivery_Required( p_customer_id => p_customer_id,

Line 3010: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;

3006: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
3007: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
3008: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
3009: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
3010: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
3011: END IF;
3012:
3013: Is_Delivery_Required( p_customer_id => p_customer_id,
3014: p_transaction_type => 'ONT',

Line 3026: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);

3022: If l_return_status <> FND_API.G_RET_STS_SUCCESS
3023: Or l_is_delivery_required = 'N' Then
3024: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_id);
3025: If l_debug_level > 0 THEN
3026: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);
3027: End If;
3028: Else
3029:
3030: OE_ACKNOWLEDGMENT_PUB.Raise_Event_Showso (

Line 3043: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;

3039: p_request_id => l_request_id,
3040: p_org_id => l_order_rec.org_id(i),
3041: x_return_status => l_return_status );
3042: IF l_debug_level > 0 THEN
3043: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;
3044: END IF;
3045:
3046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));

Line 3058: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;

3054: End If;
3055: END LOOP;
3056: END IF;
3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
3059: END IF;
3060:
3061: -- Exception Handling
3062: EXCEPTION

Line 3067: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;

3063:
3064: WHEN OTHERS THEN
3065: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
3068: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3069: END IF;
3070: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3071: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');

Line 3068: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;

3064: WHEN OTHERS THEN
3065: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
3068: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3069: END IF;
3070: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3071: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');
3072: End if;

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

3120: l_xmlg_icn NUMBER := p_xmlg_icn;
3121: l_header_id NUMBER := p_header_id;
3122: l_subscriber_list VARCHAR2(15) := nvl(p_subscriber_list,'ONT');
3123: --
3124: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3125: --
3126: l_converted VARCHAR2(100);
3127: i NUMBER;
3128: l_org_id NUMBER := p_org_id;

Line 3138: oe_debug_pub.add( 'ENTERING RAISE_EVENT_XMLINT' ) ;

3134: l_order_processed_flag VARCHAR2(1) := 'Y';
3135:
3136: Begin
3137: IF l_debug_level > 0 THEN
3138: oe_debug_pub.add( 'ENTERING RAISE_EVENT_XMLINT' ) ;
3139: END IF;
3140:
3141: -- new profile to control which order sources can raise this event
3142: IF l_integ_profile = 'XML' THEN

Line 3145: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;

3141: -- new profile to control which order sources can raise this event
3142: IF l_integ_profile = 'XML' THEN
3143: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN
3144: IF l_debug_level > 0 THEN
3145: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3146: END IF;
3147: x_return_status := FND_API.G_RET_STS_SUCCESS;
3148: return;
3149: END IF;

Line 3153: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;

3149: END IF;
3150: ELSIF l_integ_profile = 'EDIXML' THEN
3151: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN
3152: IF l_debug_level > 0 THEN
3153: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3154: END IF;
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156: return;
3157: END IF;

Line 3161: oe_debug_pub.add( 'ADDING PARAMETERS TO XML INTEGRATION EVENT' ) ;

3157: END IF;
3158: END IF;
3159:
3160: IF l_debug_level > 0 THEN
3161: oe_debug_pub.add( 'ADDING PARAMETERS TO XML INTEGRATION EVENT' ) ;
3162: END IF;
3163:
3164: --generating a unique event key
3165: SELECT OE_XML_MESSAGE_SEQ_S.nextval

Line 3183: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;

3179: l_parameter_list.DELETE;
3180: x_return_status := FND_API.G_RET_STS_SUCCESS;
3181:
3182: IF l_debug_level > 0 THEN
3183: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3184: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;
3185: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3186: END IF;
3187: Return;

Line 3184: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;

3180: x_return_status := FND_API.G_RET_STS_SUCCESS;
3181:
3182: IF l_debug_level > 0 THEN
3183: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3184: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;
3185: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3186: END IF;
3187: Return;
3188: END IF;

Line 3185: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;

3181:
3182: IF l_debug_level > 0 THEN
3183: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3184: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;
3185: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3186: END IF;
3187: Return;
3188: END IF;
3189:

Line 3264: oe_debug_pub.add( 'EXCEPTION WHEN FETCH ORDER NUM' ) ;

3260:
3261: Exception
3262: When Others Then
3263: IF l_debug_level > 0 THEN
3264: oe_debug_pub.add( 'EXCEPTION WHEN FETCH ORDER NUM' ) ;
3265: END IF;
3266:
3267: -- could not derive info
3268: l_document_num := NULL;

Line 3491: oe_debug_pub.add( 'FINISHED ADDING PARAMETERS TO INTEGRATION EVENT' ) ;

3487: END IF;
3488:
3489:
3490: IF l_debug_level > 0 THEN
3491: oe_debug_pub.add( 'FINISHED ADDING PARAMETERS TO INTEGRATION EVENT' ) ;
3492: FOR i in 1..l_parameter_list.count LOOP
3493: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3494: END LOOP;
3495: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;

Line 3493: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);

3489:
3490: IF l_debug_level > 0 THEN
3491: oe_debug_pub.add( 'FINISHED ADDING PARAMETERS TO INTEGRATION EVENT' ) ;
3492: FOR i in 1..l_parameter_list.count LOOP
3493: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3494: END LOOP;
3495: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3496: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3497: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;

Line 3495: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;

3491: oe_debug_pub.add( 'FINISHED ADDING PARAMETERS TO INTEGRATION EVENT' ) ;
3492: FOR i in 1..l_parameter_list.count LOOP
3493: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3494: END LOOP;
3495: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3496: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3497: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3498: END IF;
3499:

Line 3496: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;

3492: FOR i in 1..l_parameter_list.count LOOP
3493: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3494: END LOOP;
3495: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3496: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3497: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3498: END IF;
3499:
3500: IF OE_Code_Control.Code_Release_Level < '110510' THEN

Line 3497: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;

3493: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3494: END LOOP;
3495: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3496: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3497: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3498: END IF;
3499:
3500: IF OE_Code_Control.Code_Release_Level < '110510' THEN
3501: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID OR

Line 3508: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status for this pre-110510 case' ) ;

3504: l_parameter_list.DELETE;
3505: x_return_status := FND_API.G_RET_STS_SUCCESS;
3506:
3507: IF l_debug_level > 0 THEN
3508: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status for this pre-110510 case' ) ;
3509: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3510: END IF;
3511: Return; -- thus we guarantee that old behaviour is preserved
3512: END IF;

Line 3509: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;

3505: x_return_status := FND_API.G_RET_STS_SUCCESS;
3506:
3507: IF l_debug_level > 0 THEN
3508: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status for this pre-110510 case' ) ;
3509: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3510: END IF;
3511: Return; -- thus we guarantee that old behaviour is preserved
3512: END IF;
3513: END IF;

Line 3521: oe_debug_pub.add( 'AFTER RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;

3517: p_parameters => l_parameter_list);
3518:
3519:
3520: IF l_debug_level > 0 THEN
3521: oe_debug_pub.add( 'AFTER RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3522: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3523: END IF;
3524:
3525:

Line 3522: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;

3518:
3519:
3520: IF l_debug_level > 0 THEN
3521: oe_debug_pub.add( 'AFTER RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3522: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3523: END IF;
3524:
3525:
3526: l_parameter_list.DELETE;

Line 3536: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF' ) ;

3532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3533: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3534: END IF;
3535: IF l_debug_level > 0 THEN
3536: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF' ) ;
3537: END IF;
3538: End Raise_Event_Xmlint;
3539: --End of Procedure to raise XML Integration (CLN) Event
3540:

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

3561: l_hold_id NUMBER := 56;
3562: l_party_id NUMBER;
3563: l_party_site_id NUMBER;
3564: --
3565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3566: --
3567: BEGIN
3568: IF l_debug_level > 0 THEN
3569: oe_debug_pub.add( 'Entering Apply_3A7_Hold' ) ;

Line 3569: oe_debug_pub.add( 'Entering Apply_3A7_Hold' ) ;

3565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3566: --
3567: BEGIN
3568: IF l_debug_level > 0 THEN
3569: oe_debug_pub.add( 'Entering Apply_3A7_Hold' ) ;
3570: END IF;
3571:
3572: IF l_tp_check = FND_API.G_TRUE THEN
3573: IF l_debug_level > 0 THEN

Line 3574: oe_debug_pub.add( 'Before Calling OE_Acknowledgment_PUB.Is_Delivery_Required') ;

3570: END IF;
3571:
3572: IF l_tp_check = FND_API.G_TRUE THEN
3573: IF l_debug_level > 0 THEN
3574: oe_debug_pub.add( 'Before Calling OE_Acknowledgment_PUB.Is_Delivery_Required') ;
3575: END IF;
3576:
3577: Is_Delivery_Required
3578: ( p_customer_id => p_sold_to_org_id,

Line 3588: oe_debug_pub.add( 'After Calling OE_Acknowledgment_PUB.Is_Delivery_Required: is delivery required for 3a7 = ' || l_is_delivery_required_cso||': Return Status:'||l_return_status ) ;

3584: x_return_status => l_return_status
3585: );
3586:
3587: IF l_debug_level > 0 THEN
3588: oe_debug_pub.add( 'After Calling OE_Acknowledgment_PUB.Is_Delivery_Required: is delivery required for 3a7 = ' || l_is_delivery_required_cso||': Return Status:'||l_return_status ) ;
3589: END IF;
3590: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3591: IF l_is_delivery_required_cso = 'Y' THEN
3592: IF l_debug_level > 0 THEN

Line 3593: oe_debug_pub.add('3A7 enabled transaction. Hold should be applied');

3589: END IF;
3590: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3591: IF l_is_delivery_required_cso = 'Y' THEN
3592: IF l_debug_level > 0 THEN
3593: oe_debug_pub.add('3A7 enabled transaction. Hold should be applied');
3594: END IF;
3595: ELSE
3596: IF l_debug_level > 0 THEN
3597: oe_debug_pub.add('NOT 3A7 enabled transaction. Hold should NOT be applied');

Line 3597: oe_debug_pub.add('NOT 3A7 enabled transaction. Hold should NOT be applied');

3593: oe_debug_pub.add('3A7 enabled transaction. Hold should be applied');
3594: END IF;
3595: ELSE
3596: IF l_debug_level > 0 THEN
3597: oe_debug_pub.add('NOT 3A7 enabled transaction. Hold should NOT be applied');
3598: END IF;
3599: RETURN;
3600: END IF;
3601: END IF;

Line 3604: oe_debug_pub.add( 'Not performing TP check for 3A7') ;

3600: END IF;
3601: END IF;
3602: ELSE
3603: IF l_debug_level > 0 THEN
3604: oe_debug_pub.add( 'Not performing TP check for 3A7') ;
3605: END IF;
3606: END IF;
3607:
3608: -- Check if Hold already exists on this order line

Line 3610: oe_debug_pub.add( 'Check If Hold Already Applied' ) ;

3606: END IF;
3607:
3608: -- Check if Hold already exists on this order line
3609: IF l_debug_level > 0 THEN
3610: oe_debug_pub.add( 'Check If Hold Already Applied' ) ;
3611: END IF;
3612:
3613: OE_HOLDS_PUB.Check_Holds
3614: ( p_api_version => 1.0

Line 3629: oe_debug_pub.add( ' Hold Already Applied On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;

3625:
3626: -- Return with Success if this Hold Already exists on the order line
3627: IF l_hold_result = FND_API.G_TRUE THEN
3628: IF l_debug_level > 0 THEN
3629: oe_debug_pub.add( ' Hold Already Applied On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3630: END IF;
3631: RETURN ;
3632: END IF ;
3633:

Line 3636: oe_debug_pub.add( 'Applying 3A7 Change Notification Hold on LINE ID:' || P_LINE_ID) ;

3632: END IF ;
3633:
3634: -- Apply 3A7 Change Notification Hold on Order line
3635: IF l_debug_level > 0 THEN
3636: oe_debug_pub.add( 'Applying 3A7 Change Notification Hold on LINE ID:' || P_LINE_ID) ;
3637: END IF;
3638:
3639: l_hold_source_rec.hold_id := l_hold_id ; -- 3A7 Hold
3640: l_hold_source_rec.hold_entity_code:= 'O'; -- Order Hold

Line 3662: oe_debug_pub.add( 'Applied 3a7 Hold On Header Id:' || P_HEADER_ID||':Line_Id:'||p_line_id , 3 ) ;

3658:
3659: x_return_status := FND_API.G_RET_STS_SUCCESS;
3660:
3661: IF l_debug_level > 0 THEN
3662: oe_debug_pub.add( 'Applied 3a7 Hold On Header Id:' || P_HEADER_ID||':Line_Id:'||p_line_id , 3 ) ;
3663: END IF;
3664:
3665: EXCEPTION
3666:

Line 3669: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');

3665: EXCEPTION
3666:
3667: WHEN FND_API.G_EXC_ERROR THEN
3668: IF l_debug_level > 0 THEN
3669: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3670: END IF;
3671: x_return_status := FND_API.G_RET_STS_ERROR;
3672: OE_MSG_PUB.Count_And_Get
3673: ( p_count => l_msg_count,

Line 3679: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');

3675: );
3676:
3677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3678: IF l_debug_level > 0 THEN
3679: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3682: OE_MSG_PUB.Count_And_Get
3683: ( p_count => l_msg_count,

Line 3689: oe_debug_pub.add('In when others exception - Apply_3A7_hold');

3685: );
3686:
3687: WHEN OTHERS THEN
3688: IF l_debug_level > 0 THEN
3689: oe_debug_pub.add('In when others exception - Apply_3A7_hold');
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3693: THEN

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

3722: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3723: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
3724: l_hold_result VARCHAR2(30);
3725: --
3726: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3727: --
3728: BEGIN
3729:
3730: IF l_debug_level > 0 THEN

Line 3731: oe_debug_pub.add( 'In Release_3A7_Hold' , 3 ) ;

3727: --
3728: BEGIN
3729:
3730: IF l_debug_level > 0 THEN
3731: oe_debug_pub.add( 'In Release_3A7_Hold' , 3 ) ;
3732: END IF;
3733:
3734: -- Checking Existence Of 3A7 Hold
3735: OE_HOLDS_PUB.Check_Holds

Line 3751: oe_debug_pub.add( ' Hold Exists On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;

3747:
3748: -- Return with Success if this Hold exists on the order line
3749: IF l_hold_result = FND_API.G_TRUE THEN
3750: IF l_debug_level > 0 THEN
3751: oe_debug_pub.add( ' Hold Exists On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3752: END IF;
3753: l_hold_exists := 'Y';
3754: END IF ;
3755:

Line 3758: oe_debug_pub.add('Releasing 3a7 Hold On Order Header Id:' || p_header_ID ||':Line_Id:'||p_line_id, 3 ) ;

3754: END IF ;
3755:
3756: IF l_hold_exists = 'Y' THEN
3757: IF l_debug_level > 0 THEN
3758: oe_debug_pub.add('Releasing 3a7 Hold On Order Header Id:' || p_header_ID ||':Line_Id:'||p_line_id, 3 ) ;
3759: END IF;
3760: l_hold_source_rec.hold_id := l_hold_id;
3761: l_hold_source_rec.HOLD_ENTITY_CODE := 'O';
3762: l_hold_source_rec.HOLD_ENTITY_ID := p_header_id; -- Order Header

Line 3782: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;

3778: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: END IF;
3781: IF l_debug_level > 0 THEN
3782: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;
3783: END IF;
3784:
3785: END IF; -- hold exists
3786: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3788: oe_debug_pub.add( 'Exiting Release_3A7 Hold', 3 ) ;

3784:
3785: END IF; -- hold exists
3786: x_return_status := FND_API.G_RET_STS_SUCCESS;
3787: IF l_debug_level > 0 THEN
3788: oe_debug_pub.add( 'Exiting Release_3A7 Hold', 3 ) ;
3789: END IF;
3790:
3791: EXCEPTION
3792:

Line 3795: oe_debug_pub.add('In G_EXC_ ERROR exception - Release_3A7_hold');

3791: EXCEPTION
3792:
3793: WHEN FND_API.G_EXC_ERROR THEN
3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add('In G_EXC_ ERROR exception - Release_3A7_hold');
3796: END IF;
3797: x_return_status := FND_API.G_RET_STS_ERROR;
3798: OE_MSG_PUB.Count_And_Get
3799: ( p_count => l_msg_count,

Line 3805: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');

3801: );
3802:
3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: IF l_debug_level > 0 THEN
3805: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3806: END IF;
3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3808: OE_MSG_PUB.Count_And_Get
3809: ( p_count => l_msg_count,

Line 3815: oe_debug_pub.add('In when others exception - Release_3A7_hold');

3811: );
3812:
3813: WHEN OTHERS THEN
3814: IF l_debug_level > 0 THEN
3815: oe_debug_pub.add('In when others exception - Release_3A7_hold');
3816: END IF;
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3819: THEN

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

3843: l_msg_data VARCHAR2(2000);
3844: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3845: l_release_3a7_hold_flag VARCHAR2(1) := 'N';
3846: --
3847: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3848: --
3849: BEGIN
3850:
3851: IF l_debug_level > 0 THEN

Line 3852: oe_debug_pub.add( 'In OE_Acknowledgment_Pub.Process_3A8' , 3 ) ;

3848: --
3849: BEGIN
3850:
3851: IF l_debug_level > 0 THEN
3852: oe_debug_pub.add( 'In OE_Acknowledgment_Pub.Process_3A8' , 3 ) ;
3853: END IF;
3854:
3855: /* 1) If independent 3A8 then release the hold.
3856: 2) If response 3A8 then

Line 3862: oe_debug_pub.add( 'Independent 3A8/3A9 received, releasing hold', 3 ) ;

3858: b) Otherwise, raise an error. */
3859:
3860: IF NVL(p_x_line_rec.cso_response_flag, 'N') = 'N' then -- independent 3A8
3861: IF l_debug_level > 0 THEN
3862: oe_debug_pub.add( 'Independent 3A8/3A9 received, releasing hold', 3 ) ;
3863: END IF;
3864: l_release_3a7_hold_flag :='Y';
3865: ELSE -- it is 3A8 response
3866: IF l_debug_level > 0 THEN

Line 3867: oe_debug_pub.add('3A8 response attrs');

3863: END IF;
3864: l_release_3a7_hold_flag :='Y';
3865: ELSE -- it is 3A8 response
3866: IF l_debug_level > 0 THEN
3867: oe_debug_pub.add('3A8 response attrs');
3868: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3869: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3870: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3871: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);

Line 3868: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);

3864: l_release_3a7_hold_flag :='Y';
3865: ELSE -- it is 3A8 response
3866: IF l_debug_level > 0 THEN
3867: oe_debug_pub.add('3A8 response attrs');
3868: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3869: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3870: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3871: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3872: END IF;

Line 3869: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);

3865: ELSE -- it is 3A8 response
3866: IF l_debug_level > 0 THEN
3867: oe_debug_pub.add('3A8 response attrs');
3868: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3869: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3870: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3871: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3872: END IF;
3873: IF (p_x_line_rec.ordered_quantity = 0) OR

Line 3870: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);

3866: IF l_debug_level > 0 THEN
3867: oe_debug_pub.add('3A8 response attrs');
3868: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3869: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3870: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3871: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3872: END IF;
3873: IF (p_x_line_rec.ordered_quantity = 0) OR
3874: (p_x_line_rec.ordered_quantity = p_old_line_rec.ordered_quantity AND

Line 3871: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);

3867: oe_debug_pub.add('3A8 response attrs');
3868: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3869: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3870: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3871: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3872: END IF;
3873: IF (p_x_line_rec.ordered_quantity = 0) OR
3874: (p_x_line_rec.ordered_quantity = p_old_line_rec.ordered_quantity AND
3875: p_x_line_rec.order_quantity_uom= p_old_line_rec.order_quantity_uom AND

Line 3880: oe_debug_pub.add( '3A8 response received, columns matching or zero quantity- releasing hold. ordered_quantity:' || p_x_line_rec.ordered_quantity, 3 ) ;

3876: p_x_line_rec.schedule_ship_date= p_old_line_rec.schedule_ship_date AND
3877: -- p_x_line_rec.unit_selling_price= p_old_line_rec.unit_selling_price) THEN
3878: nvl(p_x_line_rec.customer_item_net_price, p_x_line_rec.unit_selling_price) = p_old_line_rec.unit_selling_price) THEN
3879: IF l_debug_level > 0 THEN
3880: oe_debug_pub.add( '3A8 response received, columns matching or zero quantity- releasing hold. ordered_quantity:' || p_x_line_rec.ordered_quantity, 3 ) ;
3881:
3882: END IF;
3883: l_release_3a7_hold_flag :='Y';
3884: ELSE -- columns does not match and quantity <> 0

Line 3886: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;

3882: END IF;
3883: l_release_3a7_hold_flag :='Y';
3884: ELSE -- columns does not match and quantity <> 0
3885: IF l_debug_level > 0 THEN
3886: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3887: END IF;
3888: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3889: OE_MSG_PUB.Add;
3890: RAISE FND_API.G_EXC_ERROR;

Line 3896: oe_debug_pub.add( 'Releasing hold');

3892: END IF; -- check for independent/response 3A8
3893:
3894: IF l_release_3a7_hold_flag = 'Y' THEN
3895: IF l_debug_level > 0 THEN
3896: oe_debug_pub.add( 'Releasing hold');
3897: END IF;
3898: Release_3A7_Hold
3899: ( p_header_id => p_x_line_rec.header_id
3900: , p_line_id => p_x_line_rec.line_id

Line 3913: oe_debug_pub.add( 'Exiting Process_3A8', 3 ) ;

3909: END IF;
3910:
3911: x_return_status := FND_API.G_RET_STS_SUCCESS;
3912: IF l_debug_level > 0 THEN
3913: oe_debug_pub.add( 'Exiting Process_3A8', 3 ) ;
3914: END IF;
3915:
3916: EXCEPTION
3917:

Line 3920: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');

3916: EXCEPTION
3917:
3918: WHEN FND_API.G_EXC_ERROR THEN
3919: IF l_debug_level > 0 THEN
3920: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3921: END IF;
3922: x_return_status := FND_API.G_RET_STS_ERROR;
3923: OE_MSG_PUB.Count_And_Get
3924: ( p_count => l_msg_count,

Line 3930: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');

3926: );
3927:
3928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3929: IF l_debug_level > 0 THEN
3930: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3931: END IF;
3932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3933: OE_MSG_PUB.Count_And_Get
3934: ( p_count => l_msg_count,

Line 3940: oe_debug_pub.add('In when others exception - Process_3A8');

3936: );
3937:
3938: WHEN OTHERS THEN
3939: IF l_debug_level > 0 THEN
3940: oe_debug_pub.add('In when others exception - Process_3A8');
3941: END IF;
3942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN

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

3964: ) RETURN VARCHAR2
3965: IS
3966: l_transaction_type VARCHAR2(80);
3967: --
3968: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3969: --
3970: BEGIN
3971:
3972: IF p_txn_code IS NULL