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 52: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

48: ) Return Varchar2
49: Is
50: l_orig_sys_document_ref Varchar2(50) := Null;
51: --
52: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
53: --
54: Begin
55:
56: If p_header_id Is Not Null Then

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

69:
70: Exception
71: When Others Then
72: IF l_debug_level > 0 THEN
73: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS NOT DERIVED , OTHERS EXCEPTION' ) ;
74: END IF;
75: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
76: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_orig_sys_document_ref');
77: End if;

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

88: Is
89: l_header_id Number := 0;
90: l_customer_key_profile VARCHAR2(1) := 'N';
91: --
92: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
93: --
94: Begin
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( 'ENTERING OEXPACKB GET_HEADER_ID' ) ;

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

92: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
93: --
94: Begin
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( 'ENTERING OEXPACKB GET_HEADER_ID' ) ;
97: END IF;
98:
99: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
100: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

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

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

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

105: End If;
106:
107: If p_orig_sys_document_ref Is Not Null Then
108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add( 'P_ORIG_SYS_DOCUMENT_REF IS NOT NULL'||P_ORIG_SYS_DOCUMENT_REF ) ;
110: END IF;
111: Select header_id
112: Into l_header_id
113: From oe_order_headers

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

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

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

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

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

131: Where line_id = p_line_id
132: And order_source_id = G_XML_ORDER_SOURCE_ID
133: And rownum = 1;
134: IF l_debug_level > 0 THEN
135: oe_debug_pub.add( 'HEADER_ID FOR THE LINE_ID => ' || L_HEADER_ID ) ;
136: END IF;
137: End If;
138:
139: IF l_debug_level > 0 THEN

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

136: END IF;
137: End If;
138:
139: IF l_debug_level > 0 THEN
140: oe_debug_pub.add( 'EXITING OEXPACKB GET_HEADER_ID' ) ;
141: END IF;
142: return l_header_id;
143:
144: Exception

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

143:
144: Exception
145: When Others Then
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'L_HEADER_ID IS NOT DERIVED , OTHERS EXCEPTION' ) ;
148: END IF;
149: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
150: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_header_id');
151: End if;

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

180: l_is_delivery_reqd Varchar2(1);
181: l_return_status Varchar2(30);
182: l_user_key Varchar2(240);
183: --
184: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
185: --
186: Begin
187: IF l_debug_level > 0 THEN
188: oe_debug_pub.add( 'ENTERING RAISE_EVENT_FROM_OEOI' ) ;

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

184: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
185: --
186: Begin
187: IF l_debug_level > 0 THEN
188: oe_debug_pub.add( 'ENTERING RAISE_EVENT_FROM_OEOI' ) ;
189: END IF;
190:
191: l_event_name := 'oracle.apps.ont.oi.po_ack.create';
192:

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

194: l_start_from_flow := OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM;
195: End If;
196:
197: IF l_debug_level > 0 THEN
198: oe_debug_pub.add( 'L_START_FROM_FLOW = '||L_START_FROM_FLOW ) ;
199: END IF;
200:
201: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
202: IF p_check_for_delivery = 'Y' THEN

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

220: Select Oe_Xml_Message_Seq_S.nextval
221: Into l_itemkey
222: From dual;
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add( 'L_ITEMKEY = '||L_ITEMKEY || ' ORG ID passed in is ' || p_org_id ) ;
225: END IF;
226:
227:
228: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then

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

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

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

280:
281: -- Up to your own code to commit the transaction
282: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'BEFORE COMMIT' ) ;
285: END IF;
286: Commit;
287: End if;
288:

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

297:
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: IF l_debug_level > 0 THEN
301: oe_debug_pub.add( 'EXITING RAISE_EVENT_FROM_OEOI' ) ;
302: END IF;
303: Exception
304: when others then
305: IF l_debug_level > 0 THEN

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

302: END IF;
303: Exception
304: when others then
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_FROM_OEOI' ) ;
307: END IF;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
310: THEN

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

340: l_itemkey Number;
341: l_org_id Number;
342: l_transaction_type Varchar2(6) := p_transaction_type;
343: --
344: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
345: --
346: Begin
347:
348:

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

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

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

359:
360: if p_itemkey is null then
361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'passed-in itemkey was null...pulling value from sequence') ;
364: end if;
365:
366: select OE_XML_MESSAGE_SEQ_S.nextval
367: into l_itemkey

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

372:
373: end if;
374:
375: IF l_debug_level > 0 THEN
376: oe_debug_pub.add( 'ITEMKEY (request_id) => ' || l_itemkey) ;
377: end if;
378:
379: If p_orig_sys_document_ref Is Null Then
380: l_orig_sys_document_ref := Get_Orig_Sys_document_Ref

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

384: l_orig_sys_document_ref := p_orig_sys_document_ref;
385: End If;
386:
387: IF l_debug_level > 0 THEN
388: oe_debug_pub.add( 'AFTER GET_ORIG_SYS_DOCUMENT_REF => ' || L_ORIG_SYS_DOCUMENT_REF ) ;
389: END IF;
390:
391: wf_event.AddParameterToList(p_name=> 'ORG_ID',
392: p_value=> p_org_id,

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

392: p_value=> p_org_id,
393: p_parameterlist=> l_parameter_list);
394:
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'AFTER ADDING ORG_ID PARAMETER..ORG_ID IS => ' || L_ORG_ID ) ;
397: END IF;
398:
399: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
400: p_value=> p_header_id,

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

399: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
400: p_value=> p_header_id,
401: p_parameterlist=> l_parameter_list);
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add( 'AFTER ADDING HEADER_ID PARAMETER..HEADER_ID IS => ' || P_HEADER_ID ) ;
404: END IF;
405: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
406: p_value=> l_orig_sys_document_ref,
407: p_parameterlist=> l_parameter_list);

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

409: wf_event.AddParameterToList(p_name=> 'LINE_ID',
410: p_value=> p_line_id,
411: p_parameterlist=> l_parameter_list);
412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add( 'AFTER ADDING LINE_ID PARAMETER..LINE_ID IS => ' || P_LINE_ID ) ;
414: END IF;
415: wf_event.AddParameterToList(p_name=> 'CUSTOMER_ID',
416: p_value=> p_customer_id,
417: p_parameterlist=> l_parameter_list);

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

445: p_value=> l_transaction_type,
446: p_parameterlist=> l_parameter_list);
447:
448: IF l_debug_level > 0 THEN
449: oe_debug_pub.add( 'AFTER ADD PARAMETERS' ) ;
450: END IF;
451:
452: If p_itemtype Is Null Then
453: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;

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

458: p_value=> l_itemtype,
459: p_parameterlist=> l_parameter_list);
460:
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add( 'start_from_flow:' || l_itemtype) ;
463: END IF;
464:
465: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
466: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN

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

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

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

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

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

504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'EXITING RAISE_EVENT_SHOWSO' ) ;
509: END IF;
510: Exception
511: when others then
512: IF l_debug_level > 0 THEN

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

509: END IF;
510: Exception
511: when others then
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'ENCOUNTERED OTHERS EXCEPTION IN RAISE_EVENT_SHOWSO: ' || sqlerrm) ;
514: END IF;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN

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

598: l_return_status VARCHAR2(1);
599: l_msg_count NUMBER;
600: l_msg_data VARCHAR2(2000);
601: --
602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
603: --
604: BEGIN
605:
606: -- Standard call to check for call compatibility

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

605:
606: -- Standard call to check for call compatibility
607:
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add( 'Entering Process Acknowledgment');
610: END IF;
611: IF NOT FND_API.Compatible_API_Call
612: ( l_api_version_number
613: , p_api_version_number

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

615: , G_PKG_NAME
616: )
617: THEN
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( 'OEXPACKB COMPATIBLE_API_CALL' ) ;
620: END IF;
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:

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

621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:
624: IF l_debug_level > 0 THEN
625: oe_debug_pub.add( 'BEFORE CALLING PRIVATE ACKNOWLEDGMENT API' ) ;
626: END IF;
627:
628: OE_Acknowledgment_Pvt.Process_Acknowledgment
629: ( p_api_version_number => 1.0

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

666: , x_return_status => l_return_status
667: );
668:
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add( 'AFTER CALLING PRIVATE ACKNOWLEDGMENT API' ) ;
671: END IF;
672:
673: EXCEPTION
674:

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

673: EXCEPTION
674:
675: WHEN FND_API.G_EXC_ERROR THEN
676: IF l_debug_level > 0 THEN
677: oe_debug_pub.add( 'ENCOUNTERED ERROR EXCEPTION' ) ;
678: END IF;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686:
687: WHEN OTHERS THEN
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_ACKNOWLEDGMENT_PUB.PROCESS_ACKNOWLEDGMENT: '|| SQLERRM ) ;
690: END IF;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692:
693: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

709: RETURN NUMBER
710: IS
711: i pls_integer;
712: --
713: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
714: --
715: BEGIN
716: IF l_debug_level > 0 THEN
717: oe_debug_pub.add( 'ENTERNING: OEXPACK FUNCTION GET_LINE_INDEX' ) ;

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

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

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

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

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

730: end if;
731: i := p_line_tbl.Next(i);
732: end loop;
733: IF l_debug_level > 0 THEN
734: oe_debug_pub.add( 'EXITING: OEXPACK FUNCTION GET_LINE_INDEX - RETURNING 0' ) ;
735: END IF;
736: return 0;
737: EXCEPTION
738: WHEN OTHERS THEN

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

752: IS
753:
754: l_header_status varchar2(30);
755: --
756: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
757: --
758: BEGIN
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_HEADER' ) ;

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

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

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

777: p_header_rec.sold_to_org_id, p_header_rec.change_sequence);
778:
779: if sql%rowcount > 0 then
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'INSERTED HEADER_ID => ' || P_HEADER_REC.HEADER_ID ) ;
782: END IF;
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: else
785: IF l_debug_level > 0 THEN

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

782: END IF;
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: else
785: IF l_debug_level > 0 THEN
786: 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_ERROR;
789: end if;
790:

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

788: x_return_status := FND_API.G_RET_STS_ERROR;
789: end if;
790:
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_HEADER' ) ;
793: END IF;
794: EXCEPTION
795: WHEN OTHERS THEN
796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

808: x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
809: )
810: IS
811: --
812: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
813: --
814: BEGIN
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_LINE' ) ;

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

812: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
813: --
814: BEGIN
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add( 'ENTERNING: OEXPACK PROCEDURE INSERT_LINE' ) ;
817: END IF;
818:
819: Insert Into OE_LINE_ACKS (header_id, line_id,
820: acknowledgment_type, last_ack_code, request_id,

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

826: p_line_rec.change_sequence
827: );
828: if sql%rowcount > 0 then
829: IF l_debug_level > 0 THEN
830: oe_debug_pub.add( 'INSERTED LINE_ID => ' || P_LINE_REC.LINE_ID ) ;
831: END IF;
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833: else
834: IF l_debug_level > 0 THEN

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

831: END IF;
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833: else
834: IF l_debug_level > 0 THEN
835: 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_ERROR;
838: end if;
839:

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

837: x_return_status := FND_API.G_RET_STS_ERROR;
838: end if;
839:
840: IF l_debug_level > 0 THEN
841: oe_debug_pub.add( 'EXITING: OEXPACK PROCEDURE INSERT_LINE' ) ;
842: END IF;
843: EXCEPTION
844: WHEN OTHERS THEN
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

940: -- FOR UPDATE NOWAIT
941: ORDER BY orig_sys_line_ref, orig_sys_shipment_ref;
942:
943: --
944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
945: --
946: BEGIN
947: IF l_debug_level > 0 THEN
948: oe_debug_pub.add( 'START OF QUERY_INF_RECORDS' ) ;

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

944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
945: --
946: BEGIN
947: IF l_debug_level > 0 THEN
948: oe_debug_pub.add( 'START OF QUERY_INF_RECORDS' ) ;
949: END IF;
950:
951:
952:

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

953: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
954: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
955: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
958: END IF;
959: End If;
960:
961: IF l_debug_level > 0 THEN

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

958: END IF;
959: End If;
960:
961: IF l_debug_level > 0 THEN
962: oe_debug_pub.add('Key Information');
963: oe_debug_pub.add('Order Source Id:' || p_order_source_id);
964: oe_debug_pub.add( 'Orig Sys Document Ref:' || p_orig_sys_document_ref);
965: oe_debug_pub.add( 'Sold To Org Id:' || p_sold_to_org_id);
966: oe_debug_pub.add( 'Change Sequence:' || p_change_sequence);

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

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

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

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

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

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

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

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

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

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

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

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

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

998: l_orig_sys_document_ref := l_header_rec.orig_sys_document_ref;
999: l_change_sequence := l_header_rec.change_sequence;
1000:
1001: IF l_debug_level > 0 THEN
1002: oe_debug_pub.add( 'ORDER SOURCE ID: ' || L_ORDER_SOURCE_ID ) ;
1003: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
1004: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
1005: END IF;
1006:

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

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

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

1000:
1001: IF l_debug_level > 0 THEN
1002: oe_debug_pub.add( 'ORDER SOURCE ID: ' || L_ORDER_SOURCE_ID ) ;
1003: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
1004: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
1005: END IF;
1006:
1007: -- { Start of line fetch
1008: --LINE---------------------LINE-----------------LINE----------------LINE-----

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

1006:
1007: -- { Start of line fetch
1008: --LINE---------------------LINE-----------------LINE----------------LINE-----
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;
1011: END IF;
1012:
1013: l_line_count := 0;
1014:

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

1030: ---------------- --------------------------
1031: l_line_count := l_line_count + 1;
1032: ---------------- -------------------------
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add( 'ASSIGNING RECORD TO LINE TABLE....LINE COUNT = ' || L_LINE_COUNT ) ;
1035: END IF;
1036: ---------------- --------------------------
1037: l_line_tbl(l_line_count) := l_line_rec;
1038: ---------------- -------------------------

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

1053: x_line_tbl := l_line_tbl;
1054: ------------------ -------------------------
1055:
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add( 'END OF QUERY_INF_RECORDS' ) ;
1058: END IF;
1059: EXCEPTION
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN

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

1058: END IF;
1059: EXCEPTION
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add ('In others exception in query inf:' || SQLERRM);
1063: END IF;
1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1065: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'query_inf_records');
1066: END IF;

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

1151: = decode(l_customer_key_profile, 'Y',
1152: nvl(p_sold_to_org_id, -999), 1);
1153:
1154: --
1155: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1156: --
1157: BEGIN
1158:
1159: -- { Check what parameters are passed

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

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

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

1169: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1170: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1171: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
1172: IF l_debug_level > 0 THEN
1173: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1174: END IF;
1175: End If;
1176:
1177: IF l_debug_level > 0 THEN

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

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

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

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

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

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

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

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

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

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

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

1264: );
1265: -- end bug 4195533
1266:
1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add( 'OEXPACKB: GOT THE HEADER ID => ' || L_HEADER_ID ) ;
1269: END IF;
1270:
1271: Exception
1272: When OTHERS Then

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

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

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

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

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

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

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

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

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

1355: --{Call Query Row procedure to get the Line Data from Base
1356: -- OE_ORDER_LINES_ALL table
1357:
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1360: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;
1361: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1362: END IF;
1363:

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

1356: -- OE_ORDER_LINES_ALL table
1357:
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1360: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;
1361: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1362: END IF;
1363:
1364: Begin

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

1357:
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'ORDER_SOURCE_ID' || L_HEADER_REC.ORDER_SOURCE_ID ) ;
1360: oe_debug_pub.add( 'P_START_FROM_FLOW' || P_START_FROM_FLOW ) ;
1361: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;
1362: END IF;
1363:
1364: Begin
1365: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)

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

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

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

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

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

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

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

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

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

1410: Into l_cancelled_flag
1411: From oe_order_headers
1412: Where header_id = l_header_id;
1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'HEADER_ID: ' || L_HEADER_ID ) ;
1415: END IF;
1416:
1417: If nvl(l_cancelled_flag, 'N') = 'N' Then
1418: l_ind_cntr := 0;

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

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

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

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

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

1450: End If;
1451:
1452: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add( 'G_WFI_PROC FLOW' ) ;
1455: END IF;
1456: -- l_acknowledgment_type := G_TRANSACTION_SSO;
1457: l_ind_cntr := 0;
1458:

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

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

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

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

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

1482: Fetch line_ack_cur
1483: Into l_line_ack_id;
1484: If l_line_ack_id is Not Null Then
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'G_WFI_PROC FLOW , L_LINE_ACK_ID => ' || L_LINE_ACK_ID ) ;
1487: END IF;
1488: l_line_rec :=
1489: oe_line_util.query_row ( p_line_id => l_line_ack_id);
1490: End If;

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

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

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

1604: l_errmsg varchar2(2000);
1605: l_result boolean := FALSE;
1606: l_org_id Number := p_org_id;
1607: --
1608: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1609: --
1610: Begin
1611:
1612: IF l_debug_level > 0 THEN

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

1609: --
1610: Begin
1611:
1612: IF l_debug_level > 0 THEN
1613: oe_debug_pub.add( 'OEXPACKB: ENTERING IS_DELIVERY_REQUIRED' ) ;
1614: END IF;
1615:
1616: x_is_delivery_required := 'N';
1617: If p_org_id IS NULL Then

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

1635: And b.status = 'A'
1636: And a.status ='A'; --bug 2752321
1637:
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1640: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1641: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1642: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1643: END IF;

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

1636: And a.status ='A'; --bug 2752321
1637:
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1640: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1641: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1642: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1643: END IF;
1644: ecx_document.isDeliveryRequired

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

1637:
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1640: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1641: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1642: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1643: END IF;
1644: ecx_document.isDeliveryRequired
1645: (

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

1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'L_CUST_ACC ' || L_CUST_ACCT_SITE_ID ) ;
1640: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1641: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1642: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1643: END IF;
1644: ecx_document.isDeliveryRequired
1645: (
1646: transaction_type => p_transaction_type,

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

1651: retcode => l_retcode,
1652: errmsg => l_errmsg
1653: );
1654: IF l_debug_level > 0 THEN
1655: oe_debug_pub.add( 'AFTER CALL TO ISDELIVERY REQ ' || L_ERRMSG ) ;
1656: END IF;
1657:
1658: IF (l_result) THEN
1659: x_is_delivery_required := 'Y';

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

1659: x_is_delivery_required := 'Y';
1660: x_party_site_id := l_party_site_id;
1661: x_party_id := l_party_id;
1662: IF l_debug_level > 0 THEN
1663: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;
1664: END IF;
1665: ELSE
1666: x_is_delivery_required := 'N';
1667: x_party_site_id := l_party_site_id;

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

1666: x_is_delivery_required := 'N';
1667: x_party_site_id := l_party_site_id;
1668: x_party_id := l_party_id;
1669: IF l_debug_level > 0 THEN
1670: oe_debug_pub.add( 'IS DELIVERY REQUIRED' || X_IS_DELIVERY_REQUIRED ) ;
1671: END IF;
1672: END IF;
1673:
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1672: END IF;
1673:
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;
1675: IF l_debug_level > 0 THEN
1676: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED' ) ;
1677: END IF;
1678: EXCEPTION
1679: WHEN NO_DATA_FOUND THEN
1680: IF l_debug_level > 0 THEN

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

1677: END IF;
1678: EXCEPTION
1679: WHEN NO_DATA_FOUND THEN
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH NO_DATA_FOUND' ) ;
1682: END IF;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: -- start bug 3711152
1685: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');

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

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

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

1694: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1695: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_Delivery_Required');
1696: END IF;
1697: IF l_debug_level > 0 THEN
1698: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1699: END IF;
1700:
1701: End Is_Delivery_Required;
1702: -- End of the Is_Delivery_Required }

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

1783: l_cso_response_profile varchar2(1);
1784: l_apply_3a7_hold boolean := FALSE;
1785: l_3a7_buyer_line boolean := FALSE;
1786: --
1787: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1788: --
1789: Begin
1790:
1791: l_header_rec := p_header_rec;

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

1810: k := l_line_tbl.Next(k);
1811: end loop;*/
1812:
1813: IF l_debug_level > 0 THEN
1814: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO, itemkeys are ' || l_itemkey_sso || ' and ' || l_itemkey_cso ) ;
1815: END IF;
1816:
1817: IF NOT(OE_GENESIS_UTIL.source_aia_enabled(p_header_rec.order_source_id)) THEN -- GENESIS
1818: -- { Start step 1.

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

1843: -- supporting holds via 3a6 also
1844: l_cso_response_profile := nvl(FND_PROFILE.VALUE ('ONT_3A7_RESPONSE_REQUIRED'), 'N');
1845: END IF;
1846: IF l_debug_level > 0 THEN
1847: oe_debug_pub.add( 'OEXPACKB: is delivery required for 3a7 = ' || l_is_delivery_required_cso ) ;
1848: oe_debug_pub.add( 'OEXPACKB: fetched CSO Response Required profile ' || l_cso_response_profile) ;
1849: END IF;
1850:
1851: End If;

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

1844: l_cso_response_profile := nvl(FND_PROFILE.VALUE ('ONT_3A7_RESPONSE_REQUIRED'), 'N');
1845: END IF;
1846: IF l_debug_level > 0 THEN
1847: oe_debug_pub.add( 'OEXPACKB: is delivery required for 3a7 = ' || l_is_delivery_required_cso ) ;
1848: oe_debug_pub.add( 'OEXPACKB: fetched CSO Response Required profile ' || l_cso_response_profile) ;
1849: END IF;
1850:
1851: End If;
1852:

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

1854: l_is_delivery_required_cso = 'N' AND
1855: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1856: -- No delivery is required so return, no further processing is required
1857: IF l_debug_level > 0 THEN
1858: oe_debug_pub.add( 'OEXPACKB: NO DELIVERY IS REQUIRED SO RETURN' ) ;
1859: END IF;
1860: x_return_status := FND_API.G_RET_STS_SUCCESS;
1861: return;
1862: end if;

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

1863: END IF; -- Order source Id
1864:
1865:
1866: IF l_debug_level > 0 THEN
1867: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1868: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1869: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;

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

1864:
1865:
1866: IF l_debug_level > 0 THEN
1867: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1868: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1869: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;

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

1865:
1866: IF l_debug_level > 0 THEN
1867: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1868: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1869: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;

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

1866: IF l_debug_level > 0 THEN
1867: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1868: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1869: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;

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

1867: oe_debug_pub.add( 'PRINTING HEADER RECORD VALUES' ) ;
1868: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1869: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;

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

1868: oe_debug_pub.add( 'OLD HEADER RECORD:' ) ;
1869: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;

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

1869: oe_debug_pub.add( 'orig_sys_document_ref:' || p_old_header_rec.orig_sys_document_ref) ;
1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;

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

1870: oe_debug_pub.add( 'booked_flag:' || p_old_header_rec.booked_flag) ;
1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;

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

1871: oe_debug_pub.add( 'flow_status_code:' || p_old_header_rec.flow_status_code) ;
1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;

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

1872: oe_debug_pub.add( 'request_id:' || p_old_header_rec.request_id) ;
1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;

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

1873: oe_debug_pub.add( 'transaction type:' || p_old_header_rec.xml_transaction_type_code) ;
1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;

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

1874: oe_debug_pub.add( 'operation code' || p_old_header_rec.operation) ;
1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;

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

1875: oe_debug_pub.add( 'xml message id:' || p_old_header_rec.xml_message_id) ;
1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;

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

1876: oe_debug_pub.add( 'NEW HEADER RECORD:' ) ;
1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;

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

1877: oe_debug_pub.add( 'orig_sys_document_ref:' || p_header_rec.orig_sys_document_ref) ;
1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;

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

1878: oe_debug_pub.add( 'booked_flag:' || p_header_rec.booked_flag) ;
1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;

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

1879: oe_debug_pub.add( 'flow_status_code:' || p_header_rec.flow_status_code) ;
1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;

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

1880: oe_debug_pub.add( 'request_id:' || p_header_rec.request_id) ;
1881: oe_debug_pub.add( 'transaction type:' || p_header_rec.xml_transaction_type_code) ;
1882: oe_debug_pub.add( 'operation code:' || p_header_rec.operation) ;
1883: oe_debug_pub.add( 'xml message id:' || p_header_rec.xml_message_id) ;
1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;

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

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

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

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

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

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

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

1884: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC:' ) ;
1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;

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

1885: oe_debug_pub.add( 'orig_sys_document_ref:' || OE_ORDER_UTIL.g_header_rec.orig_sys_document_ref) ;
1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;
1893:

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

1886: oe_debug_pub.add( 'booked_flag:' || OE_ORDER_UTIL.g_header_rec.booked_flag) ;
1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;
1893:
1894: -- End step 1. }

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

1887: oe_debug_pub.add( 'flow_status_code:' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1888: oe_debug_pub.add( 'request_id:' || OE_ORDER_UTIL.g_header_rec.request_id) ;
1889: oe_debug_pub.add( 'transaction type:' || OE_ORDER_UTIL.g_header_rec.xml_transaction_type_code) ;
1890: oe_debug_pub.add( 'operation code:' || OE_ORDER_UTIL.g_header_rec.operation) ;
1891: oe_debug_pub.add( 'xml message id:' || OE_ORDER_UTIL.g_header_rec.xml_message_id) ;
1892: END IF;
1893:
1894: -- End step 1. }
1895:

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

1902: -- i.e., when order booked first time, we need to send the 3A6.
1903: -- let us check for that
1904:
1905: IF l_debug_level > 0 THEN
1906: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1907: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1908: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1909: END IF;
1910:

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

1903: -- let us check for that
1904:
1905: IF l_debug_level > 0 THEN
1906: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1907: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1908: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1909: END IF;
1910:
1911: l_header_req := 'N';

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

1904:
1905: IF l_debug_level > 0 THEN
1906: oe_debug_pub.add( 'P_OLD_HEADER_REC.FLOW_STATUS_CODE ' || p_old_header_rec.flow_status_code) ;
1907: oe_debug_pub.add( 'L_HEADER_REC.FLOW_STATUS_CODE ' || l_header_rec.flow_status_code) ;
1908: oe_debug_pub.add( 'OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE ' || OE_ORDER_UTIL.g_header_rec.flow_status_code) ;
1909: END IF;
1910:
1911: l_header_req := 'N';
1912: l_header_req_cso := 'N';

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

1912: l_header_req_cso := 'N';
1913: if l_header_rec.flow_status_code = 'BOOKED' AND
1914: NOT(OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN -- GENESIS
1915: IF l_debug_level > 0 THEN
1916: oe_debug_pub.add( 'OEXPACKB: L_HEADER_REC.FLOW_STATUS_CODE = BOOKED' ) ;
1917: END IF;
1918: if nvl(p_old_header_rec.flow_status_code, 'BOOKED') <> 'BOOKED' And
1919: nvl(OE_ORDER_UTIL.g_header_rec.flow_status_code, 'N') = 'BOOKED' Then
1920: IF l_debug_level > 0 THEN

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

1917: END IF;
1918: if nvl(p_old_header_rec.flow_status_code, 'BOOKED') <> 'BOOKED' And
1919: nvl(OE_ORDER_UTIL.g_header_rec.flow_status_code, 'N') = 'BOOKED' Then
1920: IF l_debug_level > 0 THEN
1921: oe_debug_pub.add( 'OEXPACKB: P_OLD_HEADER_REC.FLOW_STATUS_CODE <> BOOKED' ) ;
1922: END IF;
1923: -- This means that order is Booked right now, and this is the condidate
1924: -- for 3A6, set the flag to indicate that..
1925:

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

1944: END IF;
1945: END IF;
1946:
1947: IF l_debug_level > 0 THEN
1948: oe_debug_pub.add( 'OEXPACKB: L_HEADER_STATUS = BOOKED' ) ;
1949: oe_debug_pub.add( 'OEXPACKB: L_IS_DELIVERY_REQD_CSO = ' || l_is_delivery_required_cso ) ;
1950: END IF;
1951: l_header_status := 'BOOKED';
1952: l_header_status_cso := 'BOOKED';

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

1945: END IF;
1946:
1947: IF l_debug_level > 0 THEN
1948: oe_debug_pub.add( 'OEXPACKB: L_HEADER_STATUS = BOOKED' ) ;
1949: oe_debug_pub.add( 'OEXPACKB: L_IS_DELIVERY_REQD_CSO = ' || l_is_delivery_required_cso ) ;
1950: END IF;
1951: l_header_status := 'BOOKED';
1952: l_header_status_cso := 'BOOKED';
1953: end if;

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

1962: l_header_status := l_header_rec.flow_status_code;
1963: l_sync_header := 'Y';
1964:
1965: IF l_debug_level > 0 THEN
1966: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1967: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1968: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1969: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1970: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);

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

1963: l_sync_header := 'Y';
1964:
1965: IF l_debug_level > 0 THEN
1966: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1967: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1968: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1969: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1970: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1971: END IF;

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

1964:
1965: IF l_debug_level > 0 THEN
1966: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1967: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1968: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1969: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1970: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1971: END IF;
1972: -- GENESIS --

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

1965: IF l_debug_level > 0 THEN
1966: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1967: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1968: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1969: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1970: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1971: END IF;
1972: -- GENESIS --
1973: end if;

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

1966: oe_debug_pub.add( 'Genesis: Set header flag for flow status code change');
1967: oe_debug_pub.add( 'Genesis: Order Source Id = '||l_header_rec.order_source_id);
1968: oe_debug_pub.add( 'Genesis: l_header_req = '||l_header_req);
1969: oe_debug_pub.add( 'Genesis: l_header_status = '||l_header_status);
1970: oe_debug_pub.add( 'Genesis: l_sync_header = '||l_sync_header);
1971: END IF;
1972: -- GENESIS --
1973: end if;
1974: -- End step 2a. }

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

1980: -- we need to send the 3A6 for above cases
1981: -- let us check for that
1982:
1983: IF l_debug_level > 0 THEN
1984: oe_debug_pub.add( 'OEXPACKB: BEFORE THE WHILE LOOP' ) ;
1985: END IF;
1986: -- Following For loop is changed to while because of new Notify_OC change
1987: -- for i in 1..l_line_tbl.count
1988: -- loop

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

1988: -- loop
1989: i := l_line_tbl.First;
1990: while i is not null loop
1991: IF l_debug_level > 0 THEN
1992: oe_debug_pub.add( 'OEXPACKB: INSIDE THE FOR LOOP FOR I = ' || I ) ;
1993: END IF;
1994: -- resetting whether or not a particular line is required
1995: -- and whether attributes have changed. added 11/12/02 -jjmcfarl
1996: l_line_req := 'N';

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

2009: l_apply_3a7_hold := FALSE;
2010: l_3a7_buyer_line := FALSE;
2011:
2012: IF l_debug_level > 0 THEN
2013: oe_debug_pub.add( 'tested version line_id: ' || l_line_tbl(i).line_id);
2014: oe_debug_pub.add( 'passed in version line_id: ' || p_line_tbl(i).line_id);
2015: oe_debug_pub.add( 'old version line_id: ' || p_old_line_tbl(i).line_id);
2016: END IF;
2017:

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

2010: l_3a7_buyer_line := FALSE;
2011:
2012: IF l_debug_level > 0 THEN
2013: oe_debug_pub.add( 'tested version line_id: ' || l_line_tbl(i).line_id);
2014: oe_debug_pub.add( 'passed in version line_id: ' || p_line_tbl(i).line_id);
2015: oe_debug_pub.add( 'old version line_id: ' || p_old_line_tbl(i).line_id);
2016: END IF;
2017:
2018: -- moved the derivation of the j index outside of the UPDATE if-statement that

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

2011:
2012: IF l_debug_level > 0 THEN
2013: oe_debug_pub.add( 'tested version line_id: ' || l_line_tbl(i).line_id);
2014: oe_debug_pub.add( 'passed in version line_id: ' || p_line_tbl(i).line_id);
2015: oe_debug_pub.add( 'old version line_id: ' || p_old_line_tbl(i).line_id);
2016: END IF;
2017:
2018: -- moved the derivation of the j index outside of the UPDATE if-statement that
2019: -- follows. this is done so that j will be derived for both update and create

Line 2026: oe_debug_pub.add( 'got line index: ' || j);

2022: j := i;
2023: else
2024: j := get_line_index(p_old_line_tbl, l_line_tbl(i).line_id);
2025: IF l_debug_level > 0 THEN
2026: oe_debug_pub.add( 'got line index: ' || j);
2027: END IF;
2028: end if;
2029:
2030: -- { Start for the comparision when the operation on the Line table

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

2030: -- { Start for the comparision when the operation on the Line table
2031: -- is UPDATE
2032: if l_line_tbl(i).operation = Oe_Globals.G_OPR_UPDATE then
2033: IF l_debug_level > 0 THEN
2034: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS UPDATE' ) ;
2035: END IF;
2036:
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;

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

2034: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS UPDATE' ) ;
2035: END IF;
2036:
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2039: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2040: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;

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

2035: END IF;
2036:
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2039: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2040: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;

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

2036:
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2039: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2040: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;

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

2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2039: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2040: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;

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

2038: oe_debug_pub.add( 'PRINTING LINE RECORD VALUES' ) ;
2039: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2040: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;

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

2039: oe_debug_pub.add( 'OLD LINE RECORD:' ) ;
2040: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;

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

2040: oe_debug_pub.add( ' orig_sys_document_ref: ' || p_old_line_tbl(j).orig_sys_document_ref) ;
2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;

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

2041: oe_debug_pub.add( ' line_id : ' || p_old_line_tbl(j).line_id) ;
2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;

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

2042: oe_debug_pub.add( ' flow_status_code : ' || p_old_line_tbl(j).flow_status_code) ;
2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;

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

2043: oe_debug_pub.add( ' request_id : ' || p_old_line_tbl(j).request_id) ;
2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;

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

2044: oe_debug_pub.add( ' operation : ' || p_old_line_tbl(j).operation) ;
2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;

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

2045: oe_debug_pub.add( ' unit_selling_price : ' || p_old_line_tbl(j).unit_selling_price) ;
2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;

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

2046: oe_debug_pub.add( ' ordered_quantity : ' || p_old_line_tbl(j).ordered_quantity) ;
2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;

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

2047: oe_debug_pub.add( ' order_quantity_uom : ' || p_old_line_tbl(j).order_quantity_uom) ;
2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;

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

2048: oe_debug_pub.add( ' schedule_arrival_date: ' || p_old_line_tbl(j).schedule_arrival_date) ;
2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;

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

2049: oe_debug_pub.add( ' shipped_quantity : ' || p_old_line_tbl(j).shipped_quantity) ;
2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;

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

2050: oe_debug_pub.add( ' schedule_ship_date : ' || p_old_line_tbl(j).schedule_ship_date) ;
2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;

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

2051: oe_debug_pub.add( ' transaction type : ' || p_old_line_tbl(j).xml_transaction_type_code) ;
2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;

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

2052: oe_debug_pub.add( 'NEW LINE RECORD:' ) ;
2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;

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

2053: oe_debug_pub.add( ' orig_sys_document_ref: ' || l_line_tbl(i).orig_sys_document_ref) ;
2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;

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

2054: oe_debug_pub.add( ' line_id : ' || l_line_tbl(i).line_id) ;
2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2062: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;

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

2055: oe_debug_pub.add( ' flow_status_code : ' || l_line_tbl(i).flow_status_code) ;
2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2062: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2063: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;

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

2056: oe_debug_pub.add( ' request_id : ' || l_line_tbl(i).request_id) ;
2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2062: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2063: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2064: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;

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

2057: oe_debug_pub.add( ' operation : ' || l_line_tbl(i).operation) ;
2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2062: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2063: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2064: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2065: END IF;

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

2058: oe_debug_pub.add( ' unit_selling_price : ' || l_line_tbl(i).unit_selling_price) ;
2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2062: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2063: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2064: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2065: END IF;
2066:

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

2059: oe_debug_pub.add( ' ordered_quantity : ' || l_line_tbl(i).ordered_quantity) ;
2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2062: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2063: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2064: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2065: END IF;
2066:
2067: -- { start j <> 0

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

2060: oe_debug_pub.add( ' order_quantity_uom : ' || l_line_tbl(i).order_quantity_uom) ;
2061: oe_debug_pub.add( ' schedule_arrival_date: ' || l_line_tbl(i).schedule_arrival_date) ;
2062: oe_debug_pub.add( ' shipped_quantity : ' || l_line_tbl(i).shipped_quantity) ;
2063: oe_debug_pub.add( ' schedule_ship_date : ' || l_line_tbl(i).schedule_ship_date) ;
2064: oe_debug_pub.add( ' transaction type : ' || l_line_tbl(i).xml_transaction_type_code) ;
2065: END IF;
2066:
2067: -- { start j <> 0
2068: if j <> 0 then

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

2070: if nvl(l_line_tbl(i).unit_selling_price, 0) <>
2071: nvl(p_old_line_tbl(j).unit_selling_price, 0) then
2072: -- set flag to indicate that unit_selling_price has changed
2073: IF l_debug_level > 0 THEN
2074: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT UNIT_SELLING_PRICE' ) ;
2075: END IF;
2076: l_change_usp := 'Y';
2077: l_change_usp_cso := 'Y';
2078: end if; -- unit_selling_price

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

2080: if nvl(l_line_tbl(i).ordered_quantity, 0) <>
2081: nvl(p_old_line_tbl(j).ordered_quantity, 0) then
2082: -- set flag to indicate that ordered_quantity has changed
2083: IF l_debug_level > 0 THEN
2084: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDERED_QUANTITY' ) ;
2085: END IF;
2086: l_change_oqty := 'Y';
2087: l_change_oqty_cso := 'Y';
2088: -- GENESIS --

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

2089: l_sync_line := 'Y';
2090: l_insert_sync_line := 'Y';
2091: l_change_type := 'SPLIT';
2092: IF l_debug_level > 0 THEN
2093: oe_debug_pub.add( 'Genesis: Set line flag for ordered quantity change');
2094: END IF;
2095: -- GENESIS --
2096: end if; -- ordered_quantity
2097:

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

2098: if not oe_globals.equal (l_line_tbl(i).order_quantity_uom,
2099: p_old_line_tbl(j).order_quantity_uom) then
2100: -- set flag to indicate that uom has changed
2101: IF l_debug_level > 0 THEN
2102: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT ORDER_QUANTITY_UOM' ) ;
2103: END IF;
2104: l_change_uom := 'Y';
2105: l_change_uom_cso := 'Y';
2106: end if;

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

2108: if nvl(l_line_tbl(i).schedule_arrival_date, trunc(sysdate)) <>
2109: nvl(p_old_line_tbl(j).schedule_arrival_date, trunc(sysdate)) then
2110: -- set flag to indicate that schedule_arrival_date has changed
2111: IF l_debug_level > 0 THEN
2112: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SCHEDULE_ARRIVAL_DATE' ) ;
2113: END IF;
2114: l_change_sadt := 'Y';
2115: -- GENESIS --
2116: l_sync_line := 'Y';

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

2116: l_sync_line := 'Y';
2117: l_insert_sync_line := 'Y';
2118: l_change_type := 'ARVL_DT_CHG';
2119: IF l_debug_level > 0 THEN
2120: oe_debug_pub.add( 'Genesis: Set line flag for schedule arrival date change');
2121: END IF;
2122: -- GENESIS --
2123: end if; -- schedule_arrival_date
2124: if nvl(l_line_tbl(i).shipped_quantity, 0) <>

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

2124: if nvl(l_line_tbl(i).shipped_quantity, 0) <>
2125: nvl(p_old_line_tbl(j).shipped_quantity, 0) then
2126: -- set flag to indicate that shipped_quantity has changed
2127: IF l_debug_level > 0 THEN
2128: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SHIPPED_QUANTITY' ) ;
2129: END IF;
2130: l_change_sqty := 'Y';
2131: end if; -- shipped_quantity
2132: if nvl(l_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>

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

2132: if nvl(l_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>
2133: nvl(p_old_line_tbl(j).schedule_ship_date, trunc(sysdate)) then
2134: -- set flag to indicate that schedule_ship_date has changed
2135: IF l_debug_level > 0 THEN
2136: oe_debug_pub.add( 'SET FLAG TO INDICATE THAT SCHEDULE_SHIP_DATE' ) ;
2137: END IF;
2138: l_change_ssdt := 'Y';
2139: l_change_ssdt_cso := 'Y';
2140: -- GENESIS --

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

2141: l_sync_line := 'Y';
2142: l_insert_sync_line := 'Y';
2143: l_change_type := 'SHIP_DT_CHG';
2144: IF l_debug_level > 0 THEN
2145: oe_debug_pub.add( 'Genesis: Set line flag for schedule ship date change');
2146: END IF;
2147: -- GENESIS --
2148: end if; -- schedule_ship_date
2149:

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

2158: l_insert_sync_line := 'Y';
2159: l_change_type := 'LINE_STATUS';
2160:
2161: IF l_debug_level > 0 THEN
2162: oe_debug_pub.add( 'Genesis: Set line flag for line flow status code change');
2163: END IF;
2164: END IF;
2165:
2166: -- Call Sync Line to process multiple lines ZB

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

2164: END IF;
2165:
2166: -- Call Sync Line to process multiple lines ZB
2167: IF l_debug_level > 0 THEN
2168: oe_debug_pub.add( 'Genesis: l_sync_line '|| l_sync_line);
2169: oe_debug_pub.add( 'Genesis: l_insert_sync_line '|| l_insert_sync_line);
2170: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2171: END IF;
2172:

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

2165:
2166: -- Call Sync Line to process multiple lines ZB
2167: IF l_debug_level > 0 THEN
2168: oe_debug_pub.add( 'Genesis: l_sync_line '|| l_sync_line);
2169: oe_debug_pub.add( 'Genesis: l_insert_sync_line '|| l_insert_sync_line);
2170: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2171: END IF;
2172:
2173: IF l_insert_sync_line = 'Y' and

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

2166: -- Call Sync Line to process multiple lines ZB
2167: IF l_debug_level > 0 THEN
2168: oe_debug_pub.add( 'Genesis: l_sync_line '|| l_sync_line);
2169: oe_debug_pub.add( 'Genesis: l_insert_sync_line '|| l_insert_sync_line);
2170: oe_debug_pub.add( 'Genesis: order_source_id '|| l_header_rec.order_source_id);
2171: END IF;
2172:
2173: IF l_insert_sync_line = 'Y' and
2174: (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN

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

2178: X_RETURN_STATUS => L_RETURN_STATUS);
2179: END IF;
2180: l_insert_sync_line := 'N';
2181: IF l_debug_level > 0 THEN
2182: oe_debug_pub.add( 'Genesis: after insert :l_insert_sync_line '|| l_insert_sync_line);
2183: END IF;
2184: -- GENESIS --
2185:
2186: IF l_change_oqty_cso = 'Y' OR

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

2216: -- changed for bug 3424468 to check operation code on old line instead of new line
2217: if p_old_line_tbl(j).operation = Oe_Globals.G_OPR_INSERT or
2218: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE then
2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2221: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2222: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2223: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2224: END IF;

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

2217: if p_old_line_tbl(j).operation = Oe_Globals.G_OPR_INSERT or
2218: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE then
2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2221: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2222: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2223: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2224: END IF;
2225: ------------------------------

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

2218: p_old_line_tbl(j).operation = Oe_Globals.G_OPR_CREATE then
2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2221: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2222: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2223: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2224: END IF;
2225: ------------------------------
2226: -- GENESIS --

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

2219: IF l_debug_level > 0 THEN
2220: oe_debug_pub.add( 'OEXPACKB: LINE OPERATIONS IS INSERT' ) ;
2221: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(j)'||p_old_line_tbl(j).line_id) ;
2222: oe_debug_pub.add( 'OEXPACKB: - p_old_line_id(i)'||p_old_line_tbl(i).line_id) ;
2223: oe_debug_pub.add( 'OEXPACKB: - p_line_id'||p_line_tbl(i).line_id ) ;
2224: END IF;
2225: ------------------------------
2226: -- GENESIS --
2227: -- Added this code to handle split case

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

2226: -- GENESIS --
2227: -- Added this code to handle split case
2228: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2229: IF l_debug_level > 0 THEN
2230: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).item_type_code'||p_line_tbl(i).item_type_code) ;
2231: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).split_from_line_id'||p_line_tbl(i).split_from_line_id) ;
2232: END IF;
2233: l_sync_line := 'Y';
2234: IF (l_line_tbl(i).SPLIT_FROM_LINE_ID IS NOT NULL OR l_line_tbl(i).item_type_code <> 'CONFIG') THEN

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

2227: -- Added this code to handle split case
2228: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2229: IF l_debug_level > 0 THEN
2230: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).item_type_code'||p_line_tbl(i).item_type_code) ;
2231: oe_debug_pub.add( 'OEXPACKB: - p_line_id(i).split_from_line_id'||p_line_tbl(i).split_from_line_id) ;
2232: END IF;
2233: l_sync_line := 'Y';
2234: IF (l_line_tbl(i).SPLIT_FROM_LINE_ID IS NOT NULL OR l_line_tbl(i).item_type_code <> 'CONFIG') THEN
2235: OE_SYNC_ORDER_PVT.INSERT_SYNC_lINE(P_LINE_rec => l_line_tbl(i),

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

2364: (OE_ORDER_UTIL.G_HEADER_REC.xml_transaction_type_code = G_TRANSACTION_CPO
2365: AND nvl(l_header_rec.cancelled_flag,'N') = 'Y')
2366: THEN
2367: IF l_debug_level > 0 THEN
2368: oe_debug_pub.add('3A7 Buyer change detected, line will not be sent or put on hold');
2369: END IF;
2370: l_3a7_buyer_line := TRUE;
2371: l_line_req_cso := 'N'; -- don't insert the line
2372: END IF;

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

2393: AND nvl(l_line_tbl(i).xml_transaction_type_code, G_TRANSACTION_CSO) = G_TRANSACTION_CSO
2394: THEN
2395:
2396: IF l_debug_level > 0 THEN
2397: oe_debug_pub.add( 'Calling OE_Acknowlegment_PUB.Apply_3A7_Hold', 2 ) ;
2398: END IF;
2399: OE_Acknowledgment_PUB.Apply_3A7_Hold
2400: ( p_header_id => l_line_tbl(i).header_id
2401: , p_line_id => l_line_tbl(i).line_id

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

2402: , p_sold_to_org_id => l_line_tbl(i).sold_to_org_id
2403: , p_tp_check => FND_API.G_FALSE
2404: , x_return_status => l_return_status);
2405: IF l_debug_level > 0 THEN
2406: oe_debug_pub.add( 'Return status after call to apply_3a7_hold:' || l_return_status, 2 ) ;
2407: END IF;
2408: END IF;
2409: END IF;
2410: END IF;

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

2411: -- end of 3a7 hold application
2412:
2413: -- { Start of l_line_req
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2416: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2417: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2418: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2419: END IF;

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

2412:
2413: -- { Start of l_line_req
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2416: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2417: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2418: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2419: END IF;
2420: if (l_line_req = 'Y') OR (l_header_status = 'BOOKED') then

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

2413: -- { Start of l_line_req
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2416: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2417: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2418: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2419: END IF;
2420: if (l_line_req = 'Y') OR (l_header_status = 'BOOKED') then
2421: -- Call insert routine to insert header_id and status info

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

2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'START 3A6 PROCESSING ON HEADER/LINES' ) ;
2416: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2417: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2418: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2419: END IF;
2420: if (l_line_req = 'Y') OR (l_header_status = 'BOOKED') then
2421: -- Call insert routine to insert header_id and status info
2422: If l_header_req = 'Y' Then

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

2450: -- Call insert routine to insert line_id and status info
2451: -- which will later be used to populate data in line ack
2452: -- table
2453: IF l_debug_level > 0 THEN
2454: oe_debug_pub.add( 'INSERTING LINE RECORD WITH INDEX = ' || I ) ;
2455: END IF;
2456: l_line_rec := l_line_tbl(i);
2457:
2458: --ensure that a valid line has been pulled from the lines table

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

2457:
2458: --ensure that a valid line has been pulled from the lines table
2459: If l_line_rec.line_id is not null then
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2462: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2463: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2464: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2465: END IF;

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

2458: --ensure that a valid line has been pulled from the lines table
2459: If l_line_rec.line_id is not null then
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2462: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2463: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2464: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2465: END IF;
2466:

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

2459: If l_line_rec.line_id is not null then
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2462: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2463: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2464: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2465: END IF;
2466:
2467: -- GENESIS --

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

2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( ' L_HEADER_STATUS : ' || L_HEADER_STATUS ) ;
2462: oe_debug_pub.add( ' L_HEADER_REQ : ' || L_HEADER_REQ ) ;
2463: oe_debug_pub.add( ' L_LINE_REQ : ' || L_LINE_REQ ) ;
2464: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2465: END IF;
2466:
2467: -- GENESIS --
2468: oe_debug_pub.add( 'Genesis: 6.1');

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

2464: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS ) ;
2465: END IF;
2466:
2467: -- GENESIS --
2468: oe_debug_pub.add( 'Genesis: 6.1');
2469: IF (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) THEN
2470: l_ack_type := G_TRANSACTION_SEBL;
2471: ELSE
2472: l_ack_type := G_TRANSACTION_SSO;

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

2485: end if;
2486:
2487: -- { Start of l_line_req_cso
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2490: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2491: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2492: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2493: END IF;

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

2486:
2487: -- { Start of l_line_req_cso
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2490: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2491: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2492: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2493: END IF;
2494: if (l_line_req_cso = 'Y') OR (l_header_status_cso = 'BOOKED') then

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

2487: -- { Start of l_line_req_cso
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2490: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2491: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2492: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2493: END IF;
2494: if (l_line_req_cso = 'Y') OR (l_header_status_cso = 'BOOKED') then
2495: -- Call insert routine to insert header_id and status info

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

2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'START 3A7 PROCESSING ON HEADER/LINES' ) ;
2490: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2491: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2492: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2493: END IF;
2494: if (l_line_req_cso = 'Y') OR (l_header_status_cso = 'BOOKED') then
2495: -- Call insert routine to insert header_id and status info
2496: If l_header_req_cso = 'Y' Then

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

2517: -- Call insert routine to insert line_id and status info
2518: -- which will later be used to populate data in line ack
2519: -- table
2520: IF l_debug_level > 0 THEN
2521: oe_debug_pub.add( 'INSERTING LINE RECORD WITH INDEX = ' || I ) ;
2522: END IF;
2523: l_line_rec := l_line_tbl(i);
2524:
2525: --ensure that a valid line has been pulled from the lines table

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

2524:
2525: --ensure that a valid line has been pulled from the lines table
2526: If l_line_rec.line_id is not null then
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2529: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2530: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2531: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2532: END IF;

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

2525: --ensure that a valid line has been pulled from the lines table
2526: If l_line_rec.line_id is not null then
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2529: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2530: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2531: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2532: END IF;
2533: If l_is_delivery_required_cso = 'Y' Then

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

2526: If l_line_rec.line_id is not null then
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2529: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2530: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2531: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2532: END IF;
2533: If l_is_delivery_required_cso = 'Y' Then
2534: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510'

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

2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( ' L_HEADER_STATUS IS : ' || L_HEADER_STATUS_CSO ) ;
2529: oe_debug_pub.add( ' L_HEADER_REQ_CSO : ' || L_HEADER_REQ_CSO ) ;
2530: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2531: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2532: END IF;
2533: If l_is_delivery_required_cso = 'Y' Then
2534: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510'
2535: AND l_cso_response_profile = 'Y' THEN

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

2534: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510'
2535: AND l_cso_response_profile = 'Y' THEN
2536: -- Check if Hold already exists on this order line
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'Process SSO: Check If Hold Already Applied' ) ;
2539: END IF;
2540:
2541: OE_HOLDS_PUB.Check_Holds
2542: ( p_api_version => 1.0

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

2552: );
2553:
2554: IF l_hold_result = FND_API.G_TRUE THEN
2555: IF l_debug_level > 0 THEN
2556: oe_debug_pub.add( 'Process SSO: Hold Already Applied On Header Id:'
2557: ||l_header_rec.header_id ||': Line_Id:'||l_line_tbl(i).line_id) ;
2558: oe_debug_pub.add( 'Change line status for 3A7');
2559: END IF;
2560: l_line_status_cso := 'ON HOLD';

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

2554: IF l_hold_result = FND_API.G_TRUE THEN
2555: IF l_debug_level > 0 THEN
2556: oe_debug_pub.add( 'Process SSO: Hold Already Applied On Header Id:'
2557: ||l_header_rec.header_id ||': Line_Id:'||l_line_tbl(i).line_id) ;
2558: oe_debug_pub.add( 'Change line status for 3A7');
2559: END IF;
2560: l_line_status_cso := 'ON HOLD';
2561: END IF ;
2562: END IF;

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

2634: -- Raise ShowSo Event
2635: If l_is_delivery_required = 'Y' Then
2636:
2637: IF l_debug_level > 0 THEN
2638: oe_debug_pub.add( 'Raising 3a6 event with itemkey: ' || l_itemkey_sso) ;
2639: END IF;
2640:
2641: OE_Acknowledgment_Pub.Raise_Event_Showso
2642: (p_header_id => l_header_rec.header_id,

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

2657: if l_header_req_cso = 'D' then
2658: If l_is_delivery_required_cso = 'Y' Then
2659: -- If l_order_booked_cso = 'Y' Then
2660: IF l_debug_level > 0 THEN
2661: oe_debug_pub.add( 'Raising 3a7 event with itemkey: ' || l_itemkey_cso) ;
2662: END IF;
2663:
2664: OE_Acknowledgment_Pub.Raise_Event_Showso
2665: (p_header_id => l_header_rec.header_id,

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

2684: l_sync_line_id := NULL;
2685: l_lin_req_id := NULL;
2686:
2687: IF l_debug_level > 0 THEN
2688: oe_debug_pub.add('GENESIS PROCESS_SSO : l_sync_header:'|| l_sync_header || ', l_sync_line:'
2689: || l_sync_line || ', l_change_type:'
2690: || l_change_type);
2691: END IF;
2692:

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

2692:
2693: IF ( (OE_GENESIS_UTIL.source_aia_enabled(l_header_rec.order_source_id)) AND l_sync_header = 'Y') THEN
2694:
2695: IF l_debug_level > 0 THEN
2696: oe_debug_pub.add('TESTING GENESIS 15...'||l_header_rec.order_source_id);
2697: END IF;
2698:
2699: IF l_sync_header = 'Y' THEN
2700: l_sync_header_id := l_header_rec.header_id;

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

2706: l_lin_req_id := l_line_rec.request_id;
2707: END IF;
2708:
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2711: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2712: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2713: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2714: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );

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

2707: END IF;
2708:
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2711: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2712: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2713: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2714: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2715: END IF;

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

2708:
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2711: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2712: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2713: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2714: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2715: END IF;
2716:

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

2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2711: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2712: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2713: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2714: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2715: END IF;
2716:
2717: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec

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

2710: oe_debug_pub.add('TESTING GENESIS 16...l_header_rec.request_id'||l_header_rec.request_id);
2711: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.request_id'||l_line_rec.request_id);
2712: oe_debug_pub.add('TESTING GENESIS 16...l_hdr_req_id'||l_hdr_req_id);
2713: oe_debug_pub.add('TESTING GENESIS 16...l_lin_req_id'|| l_lin_req_id);
2714: oe_debug_pub.add('TESTING GENESIS 16...l_line_rec.flow_status_code'||l_line_rec.flow_status_code );
2715: END IF;
2716:
2717: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec
2718: ,p_line_rec => null

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

2729:
2730: -- End of 3. }
2731:
2732: IF l_debug_level > 0 THEN
2733: oe_debug_pub.add( 'OEXPACKB: EXITING PROCESS_SSO' ) ;
2734: END IF;
2735: Exception
2736: When Others Then
2737: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

2795: 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))
2796: AND org_id = nvl(p_operating_unit,org_id);
2797:
2798: --
2799: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2800: --
2801: BEGIN
2802:
2803: IF l_debug_level > 0 THEN

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

2800: --
2801: BEGIN
2802:
2803: IF l_debug_level > 0 THEN
2804: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_SSO_CONC_PGM' ) ;
2805: END IF;
2806:
2807: IF p_operating_unit IS NOT NULL THEN
2808: MO_GLOBAL.set_policy_context('S',p_operating_unit);

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

2843: -- Setting Debug Mode and File
2844: -----------------------------------------------------------
2845:
2846: If nvl(l_debug_level, 1) > 0 Then
2847: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2848: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2849: fnd_file.put_line(FND_FILE.OUTPUT, '');
2850: END IF;
2851: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

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

2847: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2848: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2849: fnd_file.put_line(FND_FILE.OUTPUT, '');
2850: END IF;
2851: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
2852:
2853: -----------------------------------------------------------
2854: -- Get Concurrent Request Id
2855: -----------------------------------------------------------

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

2854: -- Get Concurrent Request Id
2855: -----------------------------------------------------------
2856:
2857: IF l_debug_level > 0 THEN
2858: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
2859: END IF;
2860: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
2861: IF l_debug_level > 0 THEN
2862: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;

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

2858: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
2859: END IF;
2860: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
2861: IF l_debug_level > 0 THEN
2862: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
2863: END IF;
2864: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
2865:
2866: OPEN c_order_for_customer;

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

2875: CLOSE c_order_for_customer;
2876:
2877: l_order_count := l_order_rec.header_id.count;
2878: IF l_debug_level > 0 THEN
2879: oe_debug_pub.add( 'COUNT: '||L_ORDER_COUNT ) ;
2880: END IF;
2881: IF l_order_count > 0 THEN
2882:
2883: -----------------------------------------------------------

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

2884: -- Raise event for all orders fetched
2885: -----------------------------------------------------------
2886: FOR i IN 1..l_order_count LOOP
2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
2889: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;

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

2885: -----------------------------------------------------------
2886: FOR i IN 1..l_order_count LOOP
2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
2889: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
2893: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;

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

2886: FOR i IN 1..l_order_count LOOP
2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
2889: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
2893: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
2894: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;

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

2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
2889: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
2893: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
2894: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
2895: END IF;

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

2888: oe_debug_pub.add( 'BEFORE CALL TO OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: '||I , 2 ) ;
2889: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
2893: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
2894: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
2895: END IF;
2896:

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

2889: oe_debug_pub.add( 'HEADER ID: '||L_ORDER_REC.HEADER_ID ( I ) , 1 ) ;
2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
2893: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
2894: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
2895: END IF;
2896:
2897: Is_Delivery_Required( p_customer_id => p_customer_id,

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

2890: oe_debug_pub.add( 'SOLD TO ORGID: '||L_ORDER_REC.SOLD_TO_ORG_ID ( I ) , 1 ) ;
2891: oe_debug_pub.add( 'SALES ORDER NUMBER: '||L_ORDER_REC.ORDER_NUMBER ( I ) , 1 ) ;
2892: oe_debug_pub.add( 'ORIG SYS DOCUMENT REF: '||L_ORDER_REC.ORIG_SYS_DOCUMENT_REF ( I ) , 1 ) ;
2893: oe_debug_pub.add( 'ORDER SOURCE ID: '||L_ORDER_REC.ORDER_SOURCE_ID ( I ) , 1 ) ;
2894: oe_debug_pub.add( 'ORG ID: '||L_ORDER_REC.ORG_ID ( I ) , 1 ) ;
2895: END IF;
2896:
2897: Is_Delivery_Required( p_customer_id => p_customer_id,
2898: p_transaction_type => 'ONT',

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

2906: If l_return_status <> FND_API.G_RET_STS_SUCCESS
2907: Or l_is_delivery_required = 'N' Then
2908: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_id);
2909: If l_debug_level > 0 THEN
2910: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);
2911: End If;
2912: Else
2913:
2914: OE_ACKNOWLEDGMENT_PUB.Raise_Event_Showso (

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

2923: p_request_id => l_request_id,
2924: p_org_id => l_order_rec.org_id(i),
2925: x_return_status => l_return_status );
2926: IF l_debug_level > 0 THEN
2927: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;
2928: END IF;
2929:
2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: 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 2942: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;

2938: End If;
2939: END LOOP;
2940: END IF;
2941: IF l_debug_level > 0 THEN
2942: oe_debug_pub.add( 'EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
2943: END IF;
2944:
2945: -- Exception Handling
2946: EXCEPTION

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

2947:
2948: WHEN OTHERS THEN
2949: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
2952: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
2953: END IF;
2954: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2955: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');

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

2948: WHEN OTHERS THEN
2949: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'WHEN OTHERS - EXITING OE_ACKNOWLEDGMENT_PUB.PROCESS_SSO_CONC_PGM' , 2 ) ;
2952: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
2953: END IF;
2954: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2955: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'process_sso_conc_pgm');
2956: End if;

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

3004: l_xmlg_icn NUMBER := p_xmlg_icn;
3005: l_header_id NUMBER := p_header_id;
3006: l_subscriber_list VARCHAR2(15) := nvl(p_subscriber_list,'ONT');
3007: --
3008: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3009: --
3010: l_converted VARCHAR2(100);
3011: i NUMBER;
3012: l_org_id NUMBER := p_org_id;

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

3018: l_order_processed_flag VARCHAR2(1) := 'Y';
3019:
3020: Begin
3021: IF l_debug_level > 0 THEN
3022: oe_debug_pub.add( 'ENTERING RAISE_EVENT_XMLINT' ) ;
3023: END IF;
3024:
3025: -- new profile to control which order sources can raise this event
3026: IF l_integ_profile = 'XML' THEN

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

3025: -- new profile to control which order sources can raise this event
3026: IF l_integ_profile = 'XML' THEN
3027: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID THEN
3028: IF l_debug_level > 0 THEN
3029: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3030: END IF;
3031: x_return_status := FND_API.G_RET_STS_SUCCESS;
3032: return;
3033: END IF;

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

3033: END IF;
3034: ELSIF l_integ_profile = 'EDIXML' THEN
3035: IF p_order_source_id NOT IN (G_XML_ORDER_SOURCE_ID, OE_GLOBALS.G_ORDER_SOURCE_EDI) THEN
3036: IF l_debug_level > 0 THEN
3037: oe_debug_pub.add( 'LEAVING RAISE_EVENT_XMLINT FOR DISABLED ORDER SOURCE: '|| p_order_source_id ) ;
3038: END IF;
3039: x_return_status := FND_API.G_RET_STS_SUCCESS;
3040: return;
3041: END IF;

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

3041: END IF;
3042: END IF;
3043:
3044: IF l_debug_level > 0 THEN
3045: oe_debug_pub.add( 'ADDING PARAMETERS TO XML INTEGRATION EVENT' ) ;
3046: END IF;
3047:
3048: --generating a unique event key
3049: SELECT OE_XML_MESSAGE_SEQ_S.nextval

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

3063: l_parameter_list.DELETE;
3064: x_return_status := FND_API.G_RET_STS_SUCCESS;
3065:
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3068: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;
3069: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3070: END IF;
3071: Return;

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

3064: x_return_status := FND_API.G_RET_STS_SUCCESS;
3065:
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3068: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;
3069: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3070: END IF;
3071: Return;
3072: END IF;

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

3065:
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status without order source or sold to org id' ) ;
3068: oe_debug_pub.add( 'order source ' || p_order_source_id || ' or sold to org id' || p_sold_to_org_id ) ;
3069: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3070: END IF;
3071: Return;
3072: END IF;
3073:

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

3144:
3145: Exception
3146: When Others Then
3147: IF l_debug_level > 0 THEN
3148: oe_debug_pub.add( 'EXCEPTION WHEN FETCH ORDER NUM' ) ;
3149: END IF;
3150:
3151: -- could not derive info
3152: l_document_num := NULL;

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

3371: END IF;
3372:
3373:
3374: IF l_debug_level > 0 THEN
3375: oe_debug_pub.add( 'FINISHED ADDING PARAMETERS TO INTEGRATION EVENT' ) ;
3376: FOR i in 1..l_parameter_list.count LOOP
3377: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3378: END LOOP;
3379: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;

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

3373:
3374: IF l_debug_level > 0 THEN
3375: oe_debug_pub.add( 'FINISHED ADDING PARAMETERS TO INTEGRATION EVENT' ) ;
3376: FOR i in 1..l_parameter_list.count LOOP
3377: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3378: END LOOP;
3379: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3380: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3381: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;

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

3375: oe_debug_pub.add( 'FINISHED ADDING PARAMETERS TO INTEGRATION EVENT' ) ;
3376: FOR i in 1..l_parameter_list.count LOOP
3377: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3378: END LOOP;
3379: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3380: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3381: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3382: END IF;
3383:

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

3376: FOR i in 1..l_parameter_list.count LOOP
3377: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3378: END LOOP;
3379: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3380: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3381: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3382: END IF;
3383:
3384: IF OE_Code_Control.Code_Release_Level < '110510' THEN

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

3377: oe_debug_pub.add (' ' || l_parameter_list(i).name || ' : ' || l_parameter_list(i).value);
3378: END LOOP;
3379: oe_debug_pub.add( 'FINISHED PRINTING EVENT PARAMS' ) ;
3380: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3381: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3382: END IF;
3383:
3384: IF OE_Code_Control.Code_Release_Level < '110510' THEN
3385: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID OR

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

3388: l_parameter_list.DELETE;
3389: x_return_status := FND_API.G_RET_STS_SUCCESS;
3390:
3391: IF l_debug_level > 0 THEN
3392: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status for this pre-110510 case' ) ;
3393: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3394: END IF;
3395: Return; -- thus we guarantee that old behaviour is preserved
3396: END IF;

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

3389: x_return_status := FND_API.G_RET_STS_SUCCESS;
3390:
3391: IF l_debug_level > 0 THEN
3392: oe_debug_pub.add( 'NOT RAISING oracle.apps.ont.oi.xml_int.status for this pre-110510 case' ) ;
3393: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3394: END IF;
3395: Return; -- thus we guarantee that old behaviour is preserved
3396: END IF;
3397: END IF;

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

3401: p_parameters => l_parameter_list);
3402:
3403:
3404: IF l_debug_level > 0 THEN
3405: oe_debug_pub.add( 'AFTER RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3406: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3407: END IF;
3408:
3409:

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

3402:
3403:
3404: IF l_debug_level > 0 THEN
3405: oe_debug_pub.add( 'AFTER RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3406: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT' ) ;
3407: END IF;
3408:
3409:
3410: l_parameter_list.DELETE;

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

3416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3417: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint');
3418: END IF;
3419: IF l_debug_level > 0 THEN
3420: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF' ) ;
3421: END IF;
3422: End Raise_Event_Xmlint;
3423: --End of Procedure to raise XML Integration (CLN) Event
3424:

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

3445: l_hold_id NUMBER := 56;
3446: l_party_id NUMBER;
3447: l_party_site_id NUMBER;
3448: --
3449: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3450: --
3451: BEGIN
3452: IF l_debug_level > 0 THEN
3453: oe_debug_pub.add( 'Entering Apply_3A7_Hold' ) ;

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

3449: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3450: --
3451: BEGIN
3452: IF l_debug_level > 0 THEN
3453: oe_debug_pub.add( 'Entering Apply_3A7_Hold' ) ;
3454: END IF;
3455:
3456: IF l_tp_check = FND_API.G_TRUE THEN
3457: IF l_debug_level > 0 THEN

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

3454: END IF;
3455:
3456: IF l_tp_check = FND_API.G_TRUE THEN
3457: IF l_debug_level > 0 THEN
3458: oe_debug_pub.add( 'Before Calling OE_Acknowledgment_PUB.Is_Delivery_Required') ;
3459: END IF;
3460:
3461: Is_Delivery_Required
3462: ( p_customer_id => p_sold_to_org_id,

Line 3472: 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 ) ;

3468: x_return_status => l_return_status
3469: );
3470:
3471: IF l_debug_level > 0 THEN
3472: 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 ) ;
3473: END IF;
3474: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3475: IF l_is_delivery_required_cso = 'Y' THEN
3476: IF l_debug_level > 0 THEN

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

3473: END IF;
3474: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3475: IF l_is_delivery_required_cso = 'Y' THEN
3476: IF l_debug_level > 0 THEN
3477: oe_debug_pub.add('3A7 enabled transaction. Hold should be applied');
3478: END IF;
3479: ELSE
3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add('NOT 3A7 enabled transaction. Hold should NOT be applied');

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

3477: oe_debug_pub.add('3A7 enabled transaction. Hold should be applied');
3478: END IF;
3479: ELSE
3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add('NOT 3A7 enabled transaction. Hold should NOT be applied');
3482: END IF;
3483: RETURN;
3484: END IF;
3485: END IF;

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

3484: END IF;
3485: END IF;
3486: ELSE
3487: IF l_debug_level > 0 THEN
3488: oe_debug_pub.add( 'Not performing TP check for 3A7') ;
3489: END IF;
3490: END IF;
3491:
3492: -- Check if Hold already exists on this order line

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

3490: END IF;
3491:
3492: -- Check if Hold already exists on this order line
3493: IF l_debug_level > 0 THEN
3494: oe_debug_pub.add( 'Check If Hold Already Applied' ) ;
3495: END IF;
3496:
3497: OE_HOLDS_PUB.Check_Holds
3498: ( p_api_version => 1.0

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

3509:
3510: -- Return with Success if this Hold Already exists on the order line
3511: IF l_hold_result = FND_API.G_TRUE THEN
3512: IF l_debug_level > 0 THEN
3513: oe_debug_pub.add( ' Hold Already Applied On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3514: END IF;
3515: RETURN ;
3516: END IF ;
3517:

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

3516: END IF ;
3517:
3518: -- Apply 3A7 Change Notification Hold on Order line
3519: IF l_debug_level > 0 THEN
3520: oe_debug_pub.add( 'Applying 3A7 Change Notification Hold on LINE ID:' || P_LINE_ID) ;
3521: END IF;
3522:
3523: l_hold_source_rec.hold_id := l_hold_id ; -- 3A7 Hold
3524: l_hold_source_rec.hold_entity_code:= 'O'; -- Order Hold

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

3542:
3543: x_return_status := FND_API.G_RET_STS_SUCCESS;
3544:
3545: IF l_debug_level > 0 THEN
3546: oe_debug_pub.add( 'Applied 3a7 Hold On Header Id:' || P_HEADER_ID||':Line_Id:'||p_line_id , 3 ) ;
3547: END IF;
3548:
3549: EXCEPTION
3550:

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

3549: EXCEPTION
3550:
3551: WHEN FND_API.G_EXC_ERROR THEN
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add('In G_EXC_ERROR exception - Apply_3A7_hold');
3554: END IF;
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: OE_MSG_PUB.Count_And_Get
3557: ( p_count => l_msg_count,

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

3559: );
3560:
3561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3562: IF l_debug_level > 0 THEN
3563: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Apply_3A7_hold');
3564: END IF;
3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3566: OE_MSG_PUB.Count_And_Get
3567: ( p_count => l_msg_count,

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

3569: );
3570:
3571: WHEN OTHERS THEN
3572: IF l_debug_level > 0 THEN
3573: oe_debug_pub.add('In when others exception - Apply_3A7_hold');
3574: END IF;
3575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3577: THEN

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

3606: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3607: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
3608: l_hold_result VARCHAR2(30);
3609: --
3610: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3611: --
3612: BEGIN
3613:
3614: IF l_debug_level > 0 THEN

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

3611: --
3612: BEGIN
3613:
3614: IF l_debug_level > 0 THEN
3615: oe_debug_pub.add( 'In Release_3A7_Hold' , 3 ) ;
3616: END IF;
3617:
3618: -- Checking Existence Of 3A7 Hold
3619: OE_HOLDS_PUB.Check_Holds

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

3631:
3632: -- Return with Success if this Hold exists on the order line
3633: IF l_hold_result = FND_API.G_TRUE THEN
3634: IF l_debug_level > 0 THEN
3635: oe_debug_pub.add( ' Hold Exists On Header Id:' || P_HEADER_ID||': Line_Id:'||p_line_id) ;
3636: END IF;
3637: l_hold_exists := 'Y';
3638: END IF ;
3639:

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

3638: END IF ;
3639:
3640: IF l_hold_exists = 'Y' THEN
3641: IF l_debug_level > 0 THEN
3642: oe_debug_pub.add('Releasing 3a7 Hold On Order Header Id:' || p_header_ID ||':Line_Id:'||p_line_id, 3 ) ;
3643: END IF;
3644: l_hold_source_rec.hold_id := l_hold_id;
3645: l_hold_source_rec.HOLD_ENTITY_CODE := 'O';
3646: l_hold_source_rec.HOLD_ENTITY_ID := p_header_id; -- Order Header

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

3662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END IF;
3665: IF l_debug_level > 0 THEN
3666: oe_debug_pub.add( 'Released 3a7 Hold On Header Id:' || P_HEADER_ID ||':Line_Id:'||p_line_id, 3 ) ;
3667: END IF;
3668:
3669: END IF; -- hold exists
3670: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3668:
3669: END IF; -- hold exists
3670: x_return_status := FND_API.G_RET_STS_SUCCESS;
3671: IF l_debug_level > 0 THEN
3672: oe_debug_pub.add( 'Exiting Release_3A7 Hold', 3 ) ;
3673: END IF;
3674:
3675: EXCEPTION
3676:

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

3675: EXCEPTION
3676:
3677: WHEN FND_API.G_EXC_ERROR THEN
3678: IF l_debug_level > 0 THEN
3679: oe_debug_pub.add('In G_EXC_ ERROR exception - Release_3A7_hold');
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_ERROR;
3682: OE_MSG_PUB.Count_And_Get
3683: ( p_count => l_msg_count,

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

3685: );
3686:
3687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3688: IF l_debug_level > 0 THEN
3689: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Release_3A7_hold');
3690: END IF;
3691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692: OE_MSG_PUB.Count_And_Get
3693: ( p_count => l_msg_count,

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

3695: );
3696:
3697: WHEN OTHERS THEN
3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add('In when others exception - Release_3A7_hold');
3700: END IF;
3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN

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

3727: l_msg_data VARCHAR2(2000);
3728: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
3729: l_release_3a7_hold_flag VARCHAR2(1) := 'N';
3730: --
3731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3732: --
3733: BEGIN
3734:
3735: IF l_debug_level > 0 THEN

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

3732: --
3733: BEGIN
3734:
3735: IF l_debug_level > 0 THEN
3736: oe_debug_pub.add( 'In OE_Acknowledgment_Pub.Process_3A8' , 3 ) ;
3737: END IF;
3738:
3739: /* 1) If independent 3A8 then release the hold.
3740: 2) If response 3A8 then

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

3742: b) Otherwise, raise an error. */
3743:
3744: IF NVL(p_x_line_rec.cso_response_flag, 'N') = 'N' then -- independent 3A8
3745: IF l_debug_level > 0 THEN
3746: oe_debug_pub.add( 'Independent 3A8/3A9 received, releasing hold', 3 ) ;
3747: END IF;
3748: l_release_3a7_hold_flag :='Y';
3749: ELSE -- it is 3A8 response
3750: IF l_debug_level > 0 THEN

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

3747: END IF;
3748: l_release_3a7_hold_flag :='Y';
3749: ELSE -- it is 3A8 response
3750: IF l_debug_level > 0 THEN
3751: oe_debug_pub.add('3A8 response attrs');
3752: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3753: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3754: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3755: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);

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

3748: l_release_3a7_hold_flag :='Y';
3749: ELSE -- it is 3A8 response
3750: IF l_debug_level > 0 THEN
3751: oe_debug_pub.add('3A8 response attrs');
3752: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3753: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3754: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3755: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3756: END IF;

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

3749: ELSE -- it is 3A8 response
3750: IF l_debug_level > 0 THEN
3751: oe_debug_pub.add('3A8 response attrs');
3752: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3753: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3754: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3755: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3756: END IF;
3757: IF (p_x_line_rec.ordered_quantity = 0) OR

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

3750: IF l_debug_level > 0 THEN
3751: oe_debug_pub.add('3A8 response attrs');
3752: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3753: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3754: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3755: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3756: END IF;
3757: IF (p_x_line_rec.ordered_quantity = 0) OR
3758: (p_x_line_rec.ordered_quantity = p_old_line_rec.ordered_quantity AND

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

3751: oe_debug_pub.add('3A8 response attrs');
3752: oe_debug_pub.add('Old qty: ' || p_old_line_rec.ordered_quantity || ' New qty:' || p_x_line_rec.ordered_quantity);
3753: oe_debug_pub.add('Old UOM: ' || p_old_line_rec.order_quantity_uom || ' New UOM:' || p_x_line_rec.order_quantity_uom);
3754: oe_debug_pub.add('Old ssdt: ' || p_old_line_rec.schedule_ship_date || ' New ssdt:' || p_x_line_rec.schedule_ship_date);
3755: oe_debug_pub.add('Old usp: ' || p_old_line_rec.unit_selling_price || ' New cinp:' || p_x_line_rec.customer_item_net_price);
3756: END IF;
3757: IF (p_x_line_rec.ordered_quantity = 0) OR
3758: (p_x_line_rec.ordered_quantity = p_old_line_rec.ordered_quantity AND
3759: p_x_line_rec.order_quantity_uom= p_old_line_rec.order_quantity_uom AND

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

3760: p_x_line_rec.schedule_ship_date= p_old_line_rec.schedule_ship_date AND
3761: -- p_x_line_rec.unit_selling_price= p_old_line_rec.unit_selling_price) THEN
3762: nvl(p_x_line_rec.customer_item_net_price, p_x_line_rec.unit_selling_price) = p_old_line_rec.unit_selling_price) THEN
3763: IF l_debug_level > 0 THEN
3764: oe_debug_pub.add( '3A8 response received, columns matching or zero quantity- releasing hold. ordered_quantity:' || p_x_line_rec.ordered_quantity, 3 ) ;
3765:
3766: END IF;
3767: l_release_3a7_hold_flag :='Y';
3768: ELSE -- columns does not match and quantity <> 0

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

3766: END IF;
3767: l_release_3a7_hold_flag :='Y';
3768: ELSE -- columns does not match and quantity <> 0
3769: IF l_debug_level > 0 THEN
3770: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3771: END IF;
3772: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3773: OE_MSG_PUB.Add;
3774: RAISE FND_API.G_EXC_ERROR;

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

3776: END IF; -- check for independent/response 3A8
3777:
3778: IF l_release_3a7_hold_flag = 'Y' THEN
3779: IF l_debug_level > 0 THEN
3780: oe_debug_pub.add( 'Releasing hold');
3781: END IF;
3782: Release_3A7_Hold
3783: ( p_header_id => p_x_line_rec.header_id
3784: , p_line_id => p_x_line_rec.line_id

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

3793: END IF;
3794:
3795: x_return_status := FND_API.G_RET_STS_SUCCESS;
3796: IF l_debug_level > 0 THEN
3797: oe_debug_pub.add( 'Exiting Process_3A8', 3 ) ;
3798: END IF;
3799:
3800: EXCEPTION
3801:

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

3800: EXCEPTION
3801:
3802: WHEN FND_API.G_EXC_ERROR THEN
3803: IF l_debug_level > 0 THEN
3804: oe_debug_pub.add('In G_EXC_ ERROR exception - Process_3A8');
3805: END IF;
3806: x_return_status := FND_API.G_RET_STS_ERROR;
3807: OE_MSG_PUB.Count_And_Get
3808: ( p_count => l_msg_count,

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

3810: );
3811:
3812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3813: IF l_debug_level > 0 THEN
3814: oe_debug_pub.add('In G_EXC_UNEXPECTED_ERROR exception - Process_3A8');
3815: END IF;
3816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3817: OE_MSG_PUB.Count_And_Get
3818: ( p_count => l_msg_count,

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

3820: );
3821:
3822: WHEN OTHERS THEN
3823: IF l_debug_level > 0 THEN
3824: oe_debug_pub.add('In when others exception - Process_3A8');
3825: END IF;
3826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3827: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN

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

3848: ) RETURN VARCHAR2
3849: IS
3850: l_transaction_type VARCHAR2(80);
3851: --
3852: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3853: --
3854: BEGIN
3855:
3856: IF p_txn_code IS NULL