eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_IMPORT_WF dependencies on OE_DEBUG_PUB

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

17: l_client_org_id NUMBER;
18: l_parameter1 NUMBER;
19:
20: --
21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
22: --
23: BEGIN
24:
25: IF l_debug_level > 0 THEN

Line 26: oe_debug_pub.add( 'ENTERING OEOI_SELECTOR PROCEDURE' ) ;

22: --
23: BEGIN
24:
25: IF l_debug_level > 0 THEN
26: oe_debug_pub.add( 'ENTERING OEOI_SELECTOR PROCEDURE' ) ;
27:
28: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
29: END IF;
30:

Line 28: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;

24:
25: IF l_debug_level > 0 THEN
26: oe_debug_pub.add( 'ENTERING OEOI_SELECTOR PROCEDURE' ) ;
27:
28: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
29: END IF;
30:
31: -- {
32: IF (p_funcmode = 'RUN') THEN

Line 35: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;

31: -- {
32: IF (p_funcmode = 'RUN') THEN
33:
34: IF l_debug_level > 0 THEN
35: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;
36: END IF;
37: p_x_result := G_WFR_COMPLETE;
38:
39: -- Engine calls SET_CTX just before activity execution

Line 44: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;

40:
41: ELSIF(p_funcmode = 'SET_CTX') THEN
42:
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
45: END IF;
46:
47: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_IMPORT
48: , p_itemkey

Line 53: oe_debug_pub.add(' l_org_id =>' || l_org_id);

49: , 'ORG_ID'
50: );
51:
52: IF l_debug_level > 0 THEN
53: oe_debug_pub.add(' l_org_id =>' || l_org_id);
54: END IF;
55:
56: mo_global.set_policy_context(p_access_mode => 'S', p_org_id=>l_Org_Id);
57: p_x_result := G_WFR_COMPLETE;

Line 91: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;

87: aname => 'PARAMETER1');
88: End If;
89:
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;
92: END IF;
93: wf_engine.SetItemAttrText (itemtype => p_itemtype,
94: itemkey => p_itemkey,
95: aname => 'ORG_ID',

Line 101: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;

97:
98: l_org_id := l_parameter1;
99:
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;
102: END IF;
103:
104: IF (NVL(mo_global.get_current_org_id,-99) <> l_Org_Id)
105: THEN

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

136: l_client_org_id NUMBER;
137: l_parameter1 NUMBER;
138:
139: --
140: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
141: --
142: BEGIN
143:
144: IF l_debug_level > 0 THEN

Line 145: oe_debug_pub.add( 'ENTERING OESO_SELECTOR PROCEDURE' ) ;

141: --
142: BEGIN
143:
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'ENTERING OESO_SELECTOR PROCEDURE' ) ;
146:
147: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
148: END IF;
149:

Line 147: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;

143:
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'ENTERING OESO_SELECTOR PROCEDURE' ) ;
146:
147: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
148: END IF;
149:
150: -- {
151: IF (p_funcmode = 'RUN') THEN

Line 154: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;

150: -- {
151: IF (p_funcmode = 'RUN') THEN
152:
153: IF l_debug_level > 0 THEN
154: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;
155: END IF;
156: p_x_result := G_WFR_COMPLETE;
157:
158: -- Engine calls SET_CTX just before activity execution

Line 163: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;

159:
160: ELSIF(p_funcmode = 'SET_CTX') THEN
161:
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
164: END IF;
165: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO
166: , p_itemkey
167: , 'ORG_ID'

Line 171: oe_debug_pub.add(' l_org_id =>' || l_org_id);

167: , 'ORG_ID'
168: );
169:
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add(' l_org_id =>' || l_org_id);
172: END IF;
173:
174: mo_global.set_policy_context(p_access_mode => 'S', p_org_id=>l_Org_Id);
175: p_x_result := G_WFR_COMPLETE;

Line 180: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;

176:
177: ELSIF (p_funcmode = 'TEST_CTX') THEN
178:
179: IF l_debug_level > 0 THEN
180: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;
181: END IF;
182:
183: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO
184: , p_itemkey

Line 188: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;

184: , p_itemkey
185: , 'ORG_ID'
186: );
187: IF l_debug_level > 0 THEN
188: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;
189: END IF;
190:
191: IF (NVL(mo_global.get_current_org_id,-99) <> l_Org_Id) THEN
192: p_x_result := 'FALSE';

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

222: l_client_org_id NUMBER;
223: l_parameter1 NUMBER;
224:
225: --
226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
227: --
228: BEGIN
229:
230: IF l_debug_level > 0 THEN

Line 231: oe_debug_pub.add( 'ENTERING OEOA_SELECTOR PROCEDURE' ) ;

227: --
228: BEGIN
229:
230: IF l_debug_level > 0 THEN
231: oe_debug_pub.add( 'ENTERING OEOA_SELECTOR PROCEDURE' ) ;
232:
233: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
234: END IF;
235:

Line 233: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;

229:
230: IF l_debug_level > 0 THEN
231: oe_debug_pub.add( 'ENTERING OEOA_SELECTOR PROCEDURE' ) ;
232:
233: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
234: END IF;
235:
236: -- {
237: IF (p_funcmode = 'RUN') THEN

Line 240: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;

236: -- {
237: IF (p_funcmode = 'RUN') THEN
238:
239: IF l_debug_level > 0 THEN
240: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;
241: END IF;
242: p_x_result := G_WFR_COMPLETE;
243:
244: -- Engine calls SET_CTX just before activity execution

Line 249: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;

245:
246: ELSIF(p_funcmode = 'SET_CTX') THEN
247:
248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
250: END IF;
251:
252: l_org_id := wf_engine.GetItemAttrNumber( G_WFI_ORDER_ACK
253: , p_itemkey

Line 258: oe_debug_pub.add(' l_org_id =>' || l_org_id);

254: , 'ORG_ID'
255: );
256:
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add(' l_org_id =>' || l_org_id);
259: END IF;
260:
261: mo_global.set_policy_context(p_access_mode => 'S', p_org_id=>l_Org_Id);
262:

Line 276: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;

272: aname => 'ORG_ID');
273: End If;
274:
275: IF l_debug_level > 0 THEN
276: oe_debug_pub.add( 'WF_PARA1 = '||L_PARAMETER1 ) ;
277: END IF;
278: wf_engine.SetItemAttrText (itemtype => p_itemtype,
279: itemkey => p_itemkey,
280: aname => 'ORG_ID',

Line 288: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;

284: , p_itemkey
285: , 'ORG_ID'
286: );
287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;
289: END IF;
290:
291: IF (NVL(mo_global.get_current_org_id,-99) <> l_Org_Id)
292: THEN

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

312: p_itemkey in varchar2
313: )
314: IS
315: --
316: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
317: --
318: BEGIN
319:
320: Update WF_ITEMS

Line 335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'CALL_WF_PURGE');
333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
336: END IF;
337: END CALL_WF_PURGE;
338:
339: PROCEDURE START_ORDER_IMPORT

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

367: l_message VARCHAR2(240);
368: l_exists VARCHAR2(30);
369:
370: --
371: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
372: --
373: BEGIN
374:
375: IF p_funcmode = 'RUN' THEN

Line 377: oe_debug_pub.add( 'ENTERING START_ORDER_IMPORT' ) ;

373: BEGIN
374:
375: IF p_funcmode = 'RUN' THEN
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add( 'ENTERING START_ORDER_IMPORT' ) ;
378:
379: oe_debug_pub.add( 'START_ORDER_IMPORT ACTIVITY ID = '||P_ACTID ) ;
380: END IF;
381:

Line 379: oe_debug_pub.add( 'START_ORDER_IMPORT ACTIVITY ID = '||P_ACTID ) ;

375: IF p_funcmode = 'RUN' THEN
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add( 'ENTERING START_ORDER_IMPORT' ) ;
378:
379: oe_debug_pub.add( 'START_ORDER_IMPORT ACTIVITY ID = '||P_ACTID ) ;
380: END IF;
381:
382: -- { If the Profile option ONT_TRANSACTION_PROCESSING is not set or not
383: -- SYNCHRONOUS then no need to start the concurrent process as this will

Line 389: oe_debug_pub.add( 'NO NEED TO START THE CONC. PROGRAM AS PROFILE IS NOT SET' ) ;

385:
386: OE_STANDARD_WF.Set_Msg_Context(p_actid);
387: If nvl(l_sync, 'SYNCHRONOUS') = 'ASYNCHRONOUS' Then
388: IF l_debug_level > 0 THEN
389: oe_debug_pub.add( 'NO NEED TO START THE CONC. PROGRAM AS PROFILE IS NOT SET' ) ;
390: END IF;
391: p_x_result := G_WFR_NOT_ELIGIBLE;
392: return;
393: End If;

Line 405: oe_debug_pub.add( 'EXITING START_ORDER_IMPORT' ) ;

401: -- }
402: OE_STANDARD_WF.Save_Messages;
403: OE_STANDARD_WF.Clear_Msg_Context;
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add( 'EXITING START_ORDER_IMPORT' ) ;
406: END IF;
407:
408: END IF;
409: --

Line 439: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;

435: p_itemkey => p_itemkey);
436: OE_STANDARD_WF.Save_Messages;
437: OE_STANDARD_WF.Clear_Msg_Context;
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
440: END IF;
441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'EXITING START_ORDER_IMPORT WITH OTHERS EXCEPTION' ) ;
443: END IF;

Line 442: oe_debug_pub.add( 'EXITING START_ORDER_IMPORT WITH OTHERS EXCEPTION' ) ;

438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
440: END IF;
441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'EXITING START_ORDER_IMPORT WITH OTHERS EXCEPTION' ) ;
443: END IF;
444: RAISE;
445: END;
446:

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

467: l_change_sequence VARCHAR2(50);
468: l_customer_key_profile VARCHAR2(1) := 'N';
469:
470: --
471: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
472: --
473: BEGIN
474:
475: IF p_funcmode = 'RUN' THEN

Line 477: oe_debug_pub.add( 'ENTERING IS_OI_COMPLETE' ) ;

473: BEGIN
474:
475: IF p_funcmode = 'RUN' THEN
476: IF l_debug_level > 0 THEN
477: oe_debug_pub.add( 'ENTERING IS_OI_COMPLETE' ) ;
478: END IF;
479: OE_STANDARD_WF.Set_Msg_Context(p_actid);
480:
481: get_activity_result( p_itemtype => p_itemtype

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

491: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
492: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
493: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
496: END IF;
497: End If;
498:
499:

Line 501: oe_debug_pub.add( 'L_ACTIVITY_ID IS ' || L_ACTIVITY_ID ) ;

497: End If;
498:
499:
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add( 'L_ACTIVITY_ID IS ' || L_ACTIVITY_ID ) ;
502:
503: oe_debug_pub.add( 'L_REQUEST_ID IS ' || L_REQUEST_ID ) ;
504: END IF;
505: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype

Line 503: oe_debug_pub.add( 'L_REQUEST_ID IS ' || L_REQUEST_ID ) ;

499:
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add( 'L_ACTIVITY_ID IS ' || L_ACTIVITY_ID ) ;
502:
503: oe_debug_pub.add( 'L_REQUEST_ID IS ' || L_REQUEST_ID ) ;
504: END IF;
505: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype
506: , itemkey => p_itemkey
507: , aname => 'REQ_ID'

Line 510: oe_debug_pub.add( 'L_REQUEST_ID IS ' || L_REQUEST_ID ) ;

506: , itemkey => p_itemkey
507: , aname => 'REQ_ID'
508: );
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'L_REQUEST_ID IS ' || L_REQUEST_ID ) ;
511: END IF;
512: Begin
513: Select request_id
514: Into l_request_id

Line 525: oe_debug_pub.add( 'OTHERS EXCEPTION: SETTING L_REQUEST_ID TO NULL' ) ;

521: avalue => l_request_id);
522: Exception
523: When Others Then
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add( 'OTHERS EXCEPTION: SETTING L_REQUEST_ID TO NULL' ) ;
526: END IF;
527: l_request_id := Null;
528: End;
529:

Line 552: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS ' || L_ORIG_SYS_DOCUMENT_REF ) ;

548: );
549: End If;
550:
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS ' || L_ORIG_SYS_DOCUMENT_REF ) ;
553: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
554: oe_debug_pub.add( 'L_CHANGE_SEQUENCE IS ' || L_CHANGE_SEQUENCE ) ;
555: END IF;
556:

Line 553: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;

549: End If;
550:
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS ' || L_ORIG_SYS_DOCUMENT_REF ) ;
553: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
554: oe_debug_pub.add( 'L_CHANGE_SEQUENCE IS ' || L_CHANGE_SEQUENCE ) ;
555: END IF;
556:
557: -- start exception management

Line 554: oe_debug_pub.add( 'L_CHANGE_SEQUENCE IS ' || L_CHANGE_SEQUENCE ) ;

550:
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF IS ' || L_ORIG_SYS_DOCUMENT_REF ) ;
553: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
554: oe_debug_pub.add( 'L_CHANGE_SEQUENCE IS ' || L_CHANGE_SEQUENCE ) ;
555: END IF;
556:
557: -- start exception management
558: OE_MSG_PUB.set_msg_context(

Line 592: oe_debug_pub.add( 'G_WFR_COMPLETE , L_REQUEST_ID = '|| L_REQUEST_ID ) ;

588: p_x_result := G_WFR_INCOMPLETE;
589: Exception
590: When NO_DATA_FOUND Then
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add( 'G_WFR_COMPLETE , L_REQUEST_ID = '|| L_REQUEST_ID ) ;
593: END IF;
594: p_x_result := G_WFR_COMPLETE;
595: When OTHERS Then
596: p_x_result := G_WFR_NOT_ELIGIBLE;

Line 614: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE' ) ;

610:
611: OE_STANDARD_WF.Save_Messages;
612: OE_STANDARD_WF.Clear_Msg_Context;
613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE' ) ;
615: END IF;
616: END IF;
617:
618: --

Line 655: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;

651: p_itemkey => p_itemkey);
652: OE_STANDARD_WF.Save_Messages;
653: OE_STANDARD_WF.Clear_Msg_Context;
654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
656:
657: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE WITH OTHERS EXCEPTION' ) ;
658: END IF;
659: RAISE;

Line 657: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE WITH OTHERS EXCEPTION' ) ;

653: OE_STANDARD_WF.Clear_Msg_Context;
654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
656:
657: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE WITH OTHERS EXCEPTION' ) ;
658: END IF;
659: RAISE;
660: END IS_OI_COMPLETE;
661:

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

685: l_sold_to_org_id NUMBER;
686: l_change_sequence VARCHAR2(50);
687: l_org_id NUMBER;
688: --
689: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
690: --
691: BEGIN
692:
693: IF p_funcmode = 'RUN' THEN

Line 695: oe_debug_pub.add( 'ENTERING SET_DELIVERY_DATA' ) ;

691: BEGIN
692:
693: IF p_funcmode = 'RUN' THEN
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'ENTERING SET_DELIVERY_DATA' ) ;
696:
697: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;
698: END IF;
699: IF l_debug_level > 0 THEN

Line 697: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;

693: IF p_funcmode = 'RUN' THEN
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'ENTERING SET_DELIVERY_DATA' ) ;
696:
697: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;
698: END IF;
699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
701: END IF;

Line 700: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;

696:
697: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;
698: END IF;
699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
701: END IF;
702: --ecx_debug.g_debug_level := 3;
703: OE_STANDARD_WF.Set_Msg_Context(p_actid);
704: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype

Line 777: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF = ' || L_ORIG_SYS_DOCUMENT_REF ) ;

773: -- reassign to a meaningful variable name for clarity in SQL statements
774: l_xml_transaction_type_code := l_original_transaction_type;
775:
776: IF l_debug_level > 0 THEN
777: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF = ' || L_ORIG_SYS_DOCUMENT_REF ) ;
778: oe_debug_pub.add( 'L_ORIGINAL_TRANSACTION_TYPE = ' || L_ORIGINAL_TRANSACTION_TYPE ) ;
779: oe_debug_pub.add ( 'L_XML_TRANSACTION_TYPE_CODE = ' || L_XML_TRANSACTION_TYPE_CODE);
780: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
781: oe_debug_pub.add( 'L_DOCUMENT_ID IS ' || L_DOCUMENT_ID ) ;

Line 778: oe_debug_pub.add( 'L_ORIGINAL_TRANSACTION_TYPE = ' || L_ORIGINAL_TRANSACTION_TYPE ) ;

774: l_xml_transaction_type_code := l_original_transaction_type;
775:
776: IF l_debug_level > 0 THEN
777: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF = ' || L_ORIG_SYS_DOCUMENT_REF ) ;
778: oe_debug_pub.add( 'L_ORIGINAL_TRANSACTION_TYPE = ' || L_ORIGINAL_TRANSACTION_TYPE ) ;
779: oe_debug_pub.add ( 'L_XML_TRANSACTION_TYPE_CODE = ' || L_XML_TRANSACTION_TYPE_CODE);
780: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
781: oe_debug_pub.add( 'L_DOCUMENT_ID IS ' || L_DOCUMENT_ID ) ;
782: oe_debug_pub.add( 'L_REQUEST_ID = ' || L_REQUEST_ID ) ;

Line 779: oe_debug_pub.add ( 'L_XML_TRANSACTION_TYPE_CODE = ' || L_XML_TRANSACTION_TYPE_CODE);

775:
776: IF l_debug_level > 0 THEN
777: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF = ' || L_ORIG_SYS_DOCUMENT_REF ) ;
778: oe_debug_pub.add( 'L_ORIGINAL_TRANSACTION_TYPE = ' || L_ORIGINAL_TRANSACTION_TYPE ) ;
779: oe_debug_pub.add ( 'L_XML_TRANSACTION_TYPE_CODE = ' || L_XML_TRANSACTION_TYPE_CODE);
780: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
781: oe_debug_pub.add( 'L_DOCUMENT_ID IS ' || L_DOCUMENT_ID ) ;
782: oe_debug_pub.add( 'L_REQUEST_ID = ' || L_REQUEST_ID ) ;
783: END IF;

Line 780: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;

776: IF l_debug_level > 0 THEN
777: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF = ' || L_ORIG_SYS_DOCUMENT_REF ) ;
778: oe_debug_pub.add( 'L_ORIGINAL_TRANSACTION_TYPE = ' || L_ORIGINAL_TRANSACTION_TYPE ) ;
779: oe_debug_pub.add ( 'L_XML_TRANSACTION_TYPE_CODE = ' || L_XML_TRANSACTION_TYPE_CODE);
780: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
781: oe_debug_pub.add( 'L_DOCUMENT_ID IS ' || L_DOCUMENT_ID ) ;
782: oe_debug_pub.add( 'L_REQUEST_ID = ' || L_REQUEST_ID ) ;
783: END IF;
784:

Line 781: oe_debug_pub.add( 'L_DOCUMENT_ID IS ' || L_DOCUMENT_ID ) ;

777: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF = ' || L_ORIG_SYS_DOCUMENT_REF ) ;
778: oe_debug_pub.add( 'L_ORIGINAL_TRANSACTION_TYPE = ' || L_ORIGINAL_TRANSACTION_TYPE ) ;
779: oe_debug_pub.add ( 'L_XML_TRANSACTION_TYPE_CODE = ' || L_XML_TRANSACTION_TYPE_CODE);
780: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
781: oe_debug_pub.add( 'L_DOCUMENT_ID IS ' || L_DOCUMENT_ID ) ;
782: oe_debug_pub.add( 'L_REQUEST_ID = ' || L_REQUEST_ID ) ;
783: END IF;
784:
785: If p_itemtype = G_WFI_ORDER_ACK and

Line 782: oe_debug_pub.add( 'L_REQUEST_ID = ' || L_REQUEST_ID ) ;

778: oe_debug_pub.add( 'L_ORIGINAL_TRANSACTION_TYPE = ' || L_ORIGINAL_TRANSACTION_TYPE ) ;
779: oe_debug_pub.add ( 'L_XML_TRANSACTION_TYPE_CODE = ' || L_XML_TRANSACTION_TYPE_CODE);
780: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID IS ' || L_SOLD_TO_ORG_ID ) ;
781: oe_debug_pub.add( 'L_DOCUMENT_ID IS ' || L_DOCUMENT_ID ) ;
782: oe_debug_pub.add( 'L_REQUEST_ID = ' || L_REQUEST_ID ) ;
783: END IF;
784:
785: If p_itemtype = G_WFI_ORDER_ACK and
786: l_start_from_flow = Oe_Globals.G_WFI_LIN Then

Line 792: oe_debug_pub.add( 'START FROM FLOW = '||L_START_FROM_FLOW ) ;

788: Return;
789: End If;
790:
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'START FROM FLOW = '||L_START_FROM_FLOW ) ;
793: END IF;
794: If l_start_from_flow = G_WFI_ORDER_IMPORT Then
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'START FROM FLOW = '|| L_START_FROM_FLOW ) ;

Line 796: oe_debug_pub.add( 'START FROM FLOW = '|| L_START_FROM_FLOW ) ;

792: oe_debug_pub.add( 'START FROM FLOW = '||L_START_FROM_FLOW ) ;
793: END IF;
794: If l_start_from_flow = G_WFI_ORDER_IMPORT Then
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'START FROM FLOW = '|| L_START_FROM_FLOW ) ;
797: END IF;
798: l_order_imported := wf_engine.GetItemAttrText( G_WFI_ORDER_IMPORT
799: , p_itemkey
800: , 'ORDER_IMPORTED'

Line 805: oe_debug_pub.add( 'START FROM FLOW IS OEOI AND IMPORT COMPLETE' ) ;

801: );
802: If l_start_from_flow = G_WFI_ORDER_IMPORT And
803: l_order_imported = G_WFR_COMPLETE Then
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'START FROM FLOW IS OEOI AND IMPORT COMPLETE' ) ;
806: END IF;
807: l_header_id := Oe_Acknowledgment_Pub.get_header_id
808: ( p_orig_sys_document_ref => l_orig_sys_document_ref,
809: p_line_id => Null,

Line 815: oe_debug_pub.add( 'ELSIF P_ITEMTYPE = '|| P_ITEMTYPE ) ;

811: End If;
812:
813: Elsif p_itemtype = G_WFI_SHOW_SO Then
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add( 'ELSIF P_ITEMTYPE = '|| P_ITEMTYPE ) ;
816: END IF;
817: If l_start_from_flow = Oe_Globals.G_WFI_LIN Then
818: IF l_debug_level > 0 THEN
819: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;

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

815: oe_debug_pub.add( 'ELSIF P_ITEMTYPE = '|| P_ITEMTYPE ) ;
816: END IF;
817: If l_start_from_flow = Oe_Globals.G_WFI_LIN Then
818: IF l_debug_level > 0 THEN
819: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;
820: END IF;
821: l_header_id := Oe_Acknowledgment_Pub.get_header_id
822: ( p_orig_sys_document_ref => Null,
823: p_line_id => p_itemkey,

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

823: p_line_id => p_itemkey,
824: p_sold_to_org_id => l_sold_to_org_id);
825: Elsif l_start_from_flow IN (G_WFI_PROC, G_WFI_CONC_PGM) Then
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;
828: END IF;
829: l_header_id := wf_engine.GetItemAttrNumber( G_WFI_SHOW_SO
830: , p_itemkey
831: , 'HEADER_ID'

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

831: , 'HEADER_ID'
832: );
833: Elsif l_start_from_flow = Oe_Globals.G_WFI_HDR Then
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;
836: END IF;
837: l_header_id := p_itemkey; -- Item Key is the header id when started from header flow
838: End If;
839: l_order_imported := G_WFR_COMPLETE;

Line 843: oe_debug_pub.add( 'ELSIF P_ITEMTYPE = '|| P_ITEMTYPE ) ;

839: l_order_imported := G_WFR_COMPLETE;
840:
841: Elsif p_itemtype = G_WFI_ORDER_ACK Then
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add( 'ELSIF P_ITEMTYPE = '|| P_ITEMTYPE ) ;
844: END IF;
845: If l_start_from_flow = Oe_Globals.G_WFI_HDR Then
846: IF l_debug_level > 0 THEN
847: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;

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

843: oe_debug_pub.add( 'ELSIF P_ITEMTYPE = '|| P_ITEMTYPE ) ;
844: END IF;
845: If l_start_from_flow = Oe_Globals.G_WFI_HDR Then
846: IF l_debug_level > 0 THEN
847: oe_debug_pub.add( 'ELSIF L_START_FROM_FLOW = '|| L_START_FROM_FLOW ) ;
848: END IF;
849: l_header_id := p_itemkey;
850: Elsif l_start_from_flow in (G_WFI_IMPORT_PGM, G_WFI_PROC) Then
851: --check if the order is imported.

Line 860: oe_debug_pub.add( 'START FROM FLOW IS OEXVIMPB.PLS' ) ;

856: If l_order_imported = 'Y' Then
857: l_order_imported := G_WFR_COMPLETE;
858:
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'START FROM FLOW IS OEXVIMPB.PLS' ) ;
861: END IF;
862: l_header_id := Oe_Acknowledgment_Pub.get_header_id
863: ( p_orig_sys_document_ref => l_orig_sys_document_ref,
864: p_line_id => Null,

Line 877: oe_debug_pub.add( 'L_ORDER_IMPORTED = '||L_ORDER_IMPORTED ) ;

873: --l_order_imported := G_WFR_COMPLETE;
874: End If;
875:
876: IF l_debug_level > 0 THEN
877: oe_debug_pub.add( 'L_ORDER_IMPORTED = '||L_ORDER_IMPORTED ) ;
878: END IF;
879:
880: -- bug 3688227
881: IF l_header_id IS NOT NULL AND l_header_id <> FND_API.G_MISS_NUM THEN

Line 891: oe_debug_pub.add( 'IN IF L_ORDER_IMPORT => ' || L_ORDER_IMPORTED ) ;

887:
888: Begin
889: If l_order_imported = G_WFR_INCOMPLETE Then
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add( 'IN IF L_ORDER_IMPORT => ' || L_ORDER_IMPORTED ) ;
892: END IF;
893: -- check the usage of the ship_to_org_id
894: Select sold_to_org_id, ship_to_org_id
895: into l_party_id, l_party_site_id

Line 902: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN IF => ' || L_PARTY_ID ) ;

898: And xml_transaction_type_code = l_xml_transaction_type_code
899: And request_id = l_request_id
900: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN IF => ' || L_PARTY_ID ) ;
903: END IF;
904: Else
905: IF l_debug_level > 0 THEN
906: oe_debug_pub.add( 'IN ELSIF L_ORDER_IMPORT => ' || L_ORDER_IMPORTED ) ;

Line 906: oe_debug_pub.add( 'IN ELSIF L_ORDER_IMPORT => ' || L_ORDER_IMPORTED ) ;

902: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN IF => ' || L_PARTY_ID ) ;
903: END IF;
904: Else
905: IF l_debug_level > 0 THEN
906: oe_debug_pub.add( 'IN ELSIF L_ORDER_IMPORT => ' || L_ORDER_IMPORTED ) ;
907: END IF;
908: Select header_id, sold_to_org_id
909: Into l_header_id, l_party_id
910: From oe_order_headers

Line 914: oe_debug_pub.add( 'HEADER_ID IN ELSIF =>' || L_HEADER_ID ) ;

910: From oe_order_headers
911: Where header_id = l_header_id
912: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
913: IF l_debug_level > 0 THEN
914: oe_debug_pub.add( 'HEADER_ID IN ELSIF =>' || L_HEADER_ID ) ;
915:
916: oe_debug_pub.add( 'XML_MESSAGE_ID IN ELSIF =>' || L_DOCUMENT_ID ) ;
917:
918: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN ELSIF => ' || L_PARTY_ID ) ;

Line 916: oe_debug_pub.add( 'XML_MESSAGE_ID IN ELSIF =>' || L_DOCUMENT_ID ) ;

912: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
913: IF l_debug_level > 0 THEN
914: oe_debug_pub.add( 'HEADER_ID IN ELSIF =>' || L_HEADER_ID ) ;
915:
916: oe_debug_pub.add( 'XML_MESSAGE_ID IN ELSIF =>' || L_DOCUMENT_ID ) ;
917:
918: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN ELSIF => ' || L_PARTY_ID ) ;
919: END IF;
920:

Line 918: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN ELSIF => ' || L_PARTY_ID ) ;

914: oe_debug_pub.add( 'HEADER_ID IN ELSIF =>' || L_HEADER_ID ) ;
915:
916: oe_debug_pub.add( 'XML_MESSAGE_ID IN ELSIF =>' || L_DOCUMENT_ID ) ;
917:
918: oe_debug_pub.add( 'SOLD_TO_ORG_ID IN ELSIF => ' || L_PARTY_ID ) ;
919: END IF;
920:
921: End If;
922: Exception

Line 925: oe_debug_pub.add( 'IN WHEN NO DATA FOUND!!!!!') ;

921: End If;
922: Exception
923: /* When no_data_found then
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add( 'IN WHEN NO DATA FOUND!!!!!') ;
926: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
927: END IF;*/
928: When Others Then
929: IF l_debug_level > 0 THEN

Line 926: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;

922: Exception
923: /* When no_data_found then
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add( 'IN WHEN NO DATA FOUND!!!!!') ;
926: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
927: END IF;*/
928: When Others Then
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add( 'SELECT OF THE DATA FAILED FOR THE DOCUMENT' ) ;

Line 930: oe_debug_pub.add( 'SELECT OF THE DATA FAILED FOR THE DOCUMENT' ) ;

926: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
927: END IF;*/
928: When Others Then
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add( 'SELECT OF THE DATA FAILED FOR THE DOCUMENT' ) ;
931: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
932: END IF;
933: if l_order_imported = G_WFR_INCOMPLETE Then
934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');

Line 931: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;

927: END IF;*/
928: When Others Then
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add( 'SELECT OF THE DATA FAILED FOR THE DOCUMENT' ) ;
931: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
932: END IF;
933: if l_order_imported = G_WFR_INCOMPLETE Then
934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');

Line 949: oe_debug_pub.add( 'BEFORE SELECT FOR THE ACCOUNT SITE AND PARTY ID' ) ;

945: End;
946:
947:
948: IF l_debug_level > 0 THEN
949: oe_debug_pub.add( 'BEFORE SELECT FOR THE ACCOUNT SITE AND PARTY ID' ) ;
950: END IF;
951: l_org_id := MO_GLOBAL.Get_Current_Org_Id;
952: SELECT /* MOAC_SQL_CHANGE */ a.cust_acct_site_id, a.party_site_id, c.party_id
953: Into l_cust_acct_site_id, l_party_site_id, l_party_id

Line 969: oe_debug_pub.add( 'AFTER SELECT FOR THE ACCOUNT SITE AND PARTY ID AND PARTY_SITE_ID' || L_CUST_ACCT_SITE_ID || ' & ' || L_PARTY_ID || ' & ' || L_PARTY_SITE_ID ) ;

965: And b.status = 'A'
966: And a.status ='A'; --bug 2752321
967:
968: IF l_debug_level > 0 THEN
969: oe_debug_pub.add( 'AFTER SELECT FOR THE ACCOUNT SITE AND PARTY ID AND PARTY_SITE_ID' || L_CUST_ACCT_SITE_ID || ' & ' || L_PARTY_ID || ' & ' || L_PARTY_SITE_ID ) ;
970: END IF;
971: l_transaction_type := Oe_Acknowledgment_Pub.G_TRANSACTION_TYPE;
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'L_TRANSACTION_TYPE = '||L_TRANSACTION_TYPE ) ;

Line 973: oe_debug_pub.add( 'L_TRANSACTION_TYPE = '||L_TRANSACTION_TYPE ) ;

969: oe_debug_pub.add( 'AFTER SELECT FOR THE ACCOUNT SITE AND PARTY ID AND PARTY_SITE_ID' || L_CUST_ACCT_SITE_ID || ' & ' || L_PARTY_ID || ' & ' || L_PARTY_SITE_ID ) ;
970: END IF;
971: l_transaction_type := Oe_Acknowledgment_Pub.G_TRANSACTION_TYPE;
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'L_TRANSACTION_TYPE = '||L_TRANSACTION_TYPE ) ;
974: END IF;
975:
976: If p_itemtype = G_WFI_SHOW_SO Then
977: l_transaction_subtype := l_original_transaction_type; --Oe_Acknowledgment_Pub.G_TRANSACTION_SSO;

Line 982: oe_debug_pub.add( 'L_TRANSACTION_SUBTYPE = '||L_TRANSACTION_SUBTYPE ) ;

978: Elsif p_itemtype = G_WFI_ORDER_ACK Then
979: l_transaction_subtype := Oe_Acknowledgment_Pub.G_TRANSACTION_POA;
980: End If;
981: IF l_debug_level > 0 THEN
982: oe_debug_pub.add( 'L_TRANSACTION_SUBTYPE = '||L_TRANSACTION_SUBTYPE ) ;
983: END IF;
984:
985: wf_engine.SetItemAttrText (itemtype => p_itemtype,
986: itemkey => p_itemkey,

Line 1070: oe_debug_pub.add( 'EXITING SET_DELIVERY_DATA' ) ;

1066: p_x_result := 'COMPLETE:COMPLETE';
1067: OE_STANDARD_WF.Save_Messages;
1068: OE_STANDARD_WF.Clear_Msg_Context;
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add( 'EXITING SET_DELIVERY_DATA' ) ;
1071: END IF;
1072:
1073: END IF;
1074: --

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

1110: p_itemkey => p_itemkey);
1111: OE_STANDARD_WF.Save_Messages;
1112: OE_STANDARD_WF.Clear_Msg_Context;
1113: IF l_debug_level > 0 THEN
1114: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1115: END IF;
1116: RAISE;
1117: END set_delivery_data;
1118:

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

1141: l_sold_to_org_id NUMBER;
1142: l_change_sequence VARCHAR2(50);
1143: l_customer_key_profile VARCHAR2(1) := 'N';
1144: --
1145: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1146: --
1147: BEGIN
1148:
1149: IF p_funcmode = 'RUN' THEN

Line 1153: oe_debug_pub.G_DEBUG_MODE := 'FILE';

1149: IF p_funcmode = 'RUN' THEN
1150: /*
1151: insert into alok values('222');
1152: insert into alok values(fnd_profile.value('CONC_REQUEST_ID'));
1153: oe_debug_pub.G_DEBUG_MODE := 'FILE';
1154: oe_debug_pub.Debug_ON;
1155: */
1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'ENTERING IS_PARTNER_SETUP PROCEDURE' ) ;

Line 1154: oe_debug_pub.Debug_ON;

1150: /*
1151: insert into alok values('222');
1152: insert into alok values(fnd_profile.value('CONC_REQUEST_ID'));
1153: oe_debug_pub.G_DEBUG_MODE := 'FILE';
1154: oe_debug_pub.Debug_ON;
1155: */
1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'ENTERING IS_PARTNER_SETUP PROCEDURE' ) ;
1158: END IF;

Line 1157: oe_debug_pub.add( 'ENTERING IS_PARTNER_SETUP PROCEDURE' ) ;

1153: oe_debug_pub.G_DEBUG_MODE := 'FILE';
1154: oe_debug_pub.Debug_ON;
1155: */
1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'ENTERING IS_PARTNER_SETUP PROCEDURE' ) ;
1158: END IF;
1159:
1160: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1161: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

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

1160: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1161: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1162: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
1163: IF l_debug_level > 0 THEN
1164: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1165: END IF;
1166: End If;
1167:
1168: OE_STANDARD_WF.Set_Msg_Context(p_actid);

Line 1176: oe_debug_pub.add( 'L_ORDER_IMPORTED ' || L_ORDER_IMPORTED ) ;

1172: itemkey => p_itemkey,
1173: aname => 'ORDER_IMPORTED');
1174:
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add( 'L_ORDER_IMPORTED ' || L_ORDER_IMPORTED ) ;
1177: END IF;
1178:
1179: l_orig_sys_document_ref := wf_engine.GetItemAttrText
1180: (itemtype => p_itemtype,

Line 1222: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF ' || L_ORIG_SYS_DOCUMENT_REF ) ;

1218: );
1219: -- end bug 3688227
1220:
1221: IF l_debug_level > 0 THEN
1222: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF ' || L_ORIG_SYS_DOCUMENT_REF ) ;
1223: oe_debug_pub.add( 'L_XML_TRANSACTION_TYPE_CODE ' || L_XML_TRANSACTION_TYPE_CODE ) ;
1224: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ' || L_SOLD_TO_ORG_ID ) ;
1225: oe_debug_pub.add( 'L_CHANGE_SEQUENCE ' || L_CHANGE_SEQUENCE ) ;
1226: END IF;

Line 1223: oe_debug_pub.add( 'L_XML_TRANSACTION_TYPE_CODE ' || L_XML_TRANSACTION_TYPE_CODE ) ;

1219: -- end bug 3688227
1220:
1221: IF l_debug_level > 0 THEN
1222: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF ' || L_ORIG_SYS_DOCUMENT_REF ) ;
1223: oe_debug_pub.add( 'L_XML_TRANSACTION_TYPE_CODE ' || L_XML_TRANSACTION_TYPE_CODE ) ;
1224: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ' || L_SOLD_TO_ORG_ID ) ;
1225: oe_debug_pub.add( 'L_CHANGE_SEQUENCE ' || L_CHANGE_SEQUENCE ) ;
1226: END IF;
1227: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype

Line 1224: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ' || L_SOLD_TO_ORG_ID ) ;

1220:
1221: IF l_debug_level > 0 THEN
1222: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF ' || L_ORIG_SYS_DOCUMENT_REF ) ;
1223: oe_debug_pub.add( 'L_XML_TRANSACTION_TYPE_CODE ' || L_XML_TRANSACTION_TYPE_CODE ) ;
1224: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ' || L_SOLD_TO_ORG_ID ) ;
1225: oe_debug_pub.add( 'L_CHANGE_SEQUENCE ' || L_CHANGE_SEQUENCE ) ;
1226: END IF;
1227: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype
1228: , itemkey => p_itemkey

Line 1225: oe_debug_pub.add( 'L_CHANGE_SEQUENCE ' || L_CHANGE_SEQUENCE ) ;

1221: IF l_debug_level > 0 THEN
1222: oe_debug_pub.add( 'L_ORIG_SYS_DOCUMENT_REF ' || L_ORIG_SYS_DOCUMENT_REF ) ;
1223: oe_debug_pub.add( 'L_XML_TRANSACTION_TYPE_CODE ' || L_XML_TRANSACTION_TYPE_CODE ) ;
1224: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ' || L_SOLD_TO_ORG_ID ) ;
1225: oe_debug_pub.add( 'L_CHANGE_SEQUENCE ' || L_CHANGE_SEQUENCE ) ;
1226: END IF;
1227: l_request_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype
1228: , itemkey => p_itemkey
1229: , aname => 'REQ_ID'

Line 1232: oe_debug_pub.add( 'L_REQUEST_ID ' || L_REQUEST_ID ) ;

1228: , itemkey => p_itemkey
1229: , aname => 'REQ_ID'
1230: );
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'L_REQUEST_ID ' || L_REQUEST_ID ) ;
1233: END IF;
1234: If l_order_imported = G_WFR_COMPLETE Then
1235:
1236: Select header_id, xml_message_id, sold_to_org_id, ship_to_org_id

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

1277: End If;
1278: -- end exception management
1279:
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1282: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1283: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1284: END IF;
1285: OE_Acknowledgment_Pub.Is_Delivery_Required

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

1278: -- end exception management
1279:
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1282: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1283: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1284: END IF;
1285: OE_Acknowledgment_Pub.Is_Delivery_Required
1286: (

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

1279:
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( 'L_PARTY_ID ' || L_PARTY_ID ) ;
1282: oe_debug_pub.add( 'L_PARTY_SITE_ID ' || L_PARTY_SITE_ID ) ;
1283: oe_debug_pub.add( 'BEFORE CALL TO ISDELIVERY REQ' ) ;
1284: END IF;
1285: OE_Acknowledgment_Pub.Is_Delivery_Required
1286: (
1287: p_customer_id => l_party_id,

Line 1296: oe_debug_pub.add( 'AFTER CALL TO ISDELIVERY REQ' ) ;

1292: x_is_delivery_required => l_is_delivery_reqd,
1293: x_return_status => l_return_status
1294: );
1295: IF l_debug_level > 0 THEN
1296: oe_debug_pub.add( 'AFTER CALL TO ISDELIVERY REQ' ) ;
1297: END IF;
1298: IF OE_Code_Control.Get_Code_Release_Level >= '110510' THEN
1299: wf_engine.SetItemAttrText (p_itemtype,
1300: p_itemkey,

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

1355: p_itemkey => p_itemkey);
1356: OE_STANDARD_WF.Save_Messages;
1357: OE_STANDARD_WF.Clear_Msg_Context;
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1360: END IF;
1361: RAISE;
1362:
1363: END is_partner_setup;

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

1381: l_sold_to_org_id Number;
1382: l_change_sequence Varchar2(50);
1383:
1384: --
1385: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1386: --
1387: Begin
1388:
1389: IF p_funcmode = 'RUN' THEN

Line 1391: oe_debug_pub.add( 'ENTERING OEXWFOI.PROCESS_XML_ACKNOWLEDGMENT_WF' ) ;

1387: Begin
1388:
1389: IF p_funcmode = 'RUN' THEN
1390: IF l_debug_level > 0 THEN
1391: oe_debug_pub.add( 'ENTERING OEXWFOI.PROCESS_XML_ACKNOWLEDGMENT_WF' ) ;
1392: END IF;
1393: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1394:
1395: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype

Line 1400: oe_debug_pub.add( 'BEFORE PARAMETER3' ) ;

1396: , p_itemkey
1397: , 'START_FROM_FLOW'
1398: );
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add( 'BEFORE PARAMETER3' ) ;
1401: END IF;
1402: l_transaction_type := wf_engine.GetItemAttrText( p_itemtype
1403: , p_itemkey
1404: , 'PARAMETER3'

Line 1407: oe_debug_pub.add( 'PARAMETER3 ='||L_TRANSACTION_TYPE ) ;

1403: , p_itemkey
1404: , 'PARAMETER3'
1405: );
1406: IF l_debug_level > 0 THEN
1407: oe_debug_pub.add( 'PARAMETER3 ='||L_TRANSACTION_TYPE ) ;
1408: END IF;
1409:
1410:
1411: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then

Line 1419: oe_debug_pub.add( 'SOLD_TO_ORG_ID ='|| L_SOLD_TO_ORG_ID ) ;

1415: );
1416:
1417:
1418: IF l_debug_level > 0 THEN
1419: oe_debug_pub.add( 'SOLD_TO_ORG_ID ='|| L_SOLD_TO_ORG_ID ) ;
1420: END IF;
1421:
1422:
1423: l_change_sequence := wf_engine.GetItemAttrText( p_itemtype

Line 1430: oe_debug_pub.add( 'CHANGE_SEQUENCE ='|| L_CHANGE_SEQUENCE ) ;

1426: );
1427:
1428:
1429: IF l_debug_level > 0 THEN
1430: oe_debug_pub.add( 'CHANGE_SEQUENCE ='|| L_CHANGE_SEQUENCE ) ;
1431: END IF;
1432: End If;
1433:
1434:

Line 1437: oe_debug_pub.add( 'OEXWFOI: P_ITEMTYPE IS '||P_ITEMTYPE ) ;

1433:
1434:
1435: If p_itemtype = G_WFI_SHOW_SO Then
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add( 'OEXWFOI: P_ITEMTYPE IS '||P_ITEMTYPE ) ;
1438:
1439: oe_debug_pub.add( 'OEXWFOI: P_ITEMKEY IS '||P_ITEMKEY ) ;
1440: END IF;
1441:

Line 1439: oe_debug_pub.add( 'OEXWFOI: P_ITEMKEY IS '||P_ITEMKEY ) ;

1435: If p_itemtype = G_WFI_SHOW_SO Then
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add( 'OEXWFOI: P_ITEMTYPE IS '||P_ITEMTYPE ) ;
1438:
1439: oe_debug_pub.add( 'OEXWFOI: P_ITEMKEY IS '||P_ITEMKEY ) ;
1440: END IF;
1441:
1442: l_line_id := wf_engine.GetItemAttrNumber( p_itemtype
1443: , p_itemkey

Line 1479: oe_debug_pub.add( 'OEXWFOIB: RETRIEVING HEADER_ID....HEADER_ID IS '||L_HEADER_ID ) ;

1475: -- end bug 3688227
1476:
1477:
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'OEXWFOIB: RETRIEVING HEADER_ID....HEADER_ID IS '||L_HEADER_ID ) ;
1480: END IF;
1481:
1482:
1483: OE_Acknowledgment_Pub.Process_Xml_Acknowledgment(

Line 1509: oe_debug_pub.add( 'REQUEST_ID IN ELSE ='||L_REQUEST_ID ) ;

1505: aname => 'REQ_ID');
1506: End if;
1507:
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( 'REQUEST_ID IN ELSE ='||L_REQUEST_ID ) ;
1510:
1511: oe_debug_pub.add( 'OEXWFOI: P_ITEMTYPE IS '||P_ITEMTYPE ) ;
1512: END IF;
1513: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype

Line 1511: oe_debug_pub.add( 'OEXWFOI: P_ITEMTYPE IS '||P_ITEMTYPE ) ;

1507:
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( 'REQUEST_ID IN ELSE ='||L_REQUEST_ID ) ;
1510:
1511: oe_debug_pub.add( 'OEXWFOI: P_ITEMTYPE IS '||P_ITEMTYPE ) ;
1512: END IF;
1513: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
1514: , p_itemkey
1515: , 'ORIG_SYS_DOCUMENT_REF'

Line 1518: oe_debug_pub.add( 'OEXWFOI: REF ='||L_ORIG_SYS_DOCUMENT_REF ) ;

1514: , p_itemkey
1515: , 'ORIG_SYS_DOCUMENT_REF'
1516: );
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add( 'OEXWFOI: REF ='||L_ORIG_SYS_DOCUMENT_REF ) ;
1519: END IF;
1520:
1521: -- start bug 3688227
1522: OE_MSG_PUB.set_msg_context(

Line 1554: oe_debug_pub.add( 'EXITING OEXWFOI.PROCESS_XML_ACKNOWLEDGMENT_WF' ) ;

1550: x_return_status => l_return_status);
1551: End If;
1552:
1553: IF l_debug_level > 0 THEN
1554: oe_debug_pub.add( 'EXITING OEXWFOI.PROCESS_XML_ACKNOWLEDGMENT_WF' ) ;
1555: END IF;
1556:
1557: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
1558: p_x_result := 'COMPLETE:COMPLETE';

Line 1600: oe_debug_pub.add( 'EXITING WITH WHEN OTHERS EXCEPTION' ) ;

1596: p_itemkey => p_itemkey);
1597: OE_STANDARD_WF.Save_Messages;
1598: OE_STANDARD_WF.Clear_Msg_Context;
1599: IF l_debug_level > 0 THEN
1600: oe_debug_pub.add( 'EXITING WITH WHEN OTHERS EXCEPTION' ) ;
1601: END IF;
1602: RAISE;
1603: End Process_Xml_Acknowledgment_Wf;
1604:

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

1617: )
1618: IS
1619:
1620: --
1621: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1622: --
1623: BEGIN
1624:
1625: IF l_debug_level > 0 THEN

Line 1626: oe_debug_pub.add( 'ENTERING OE_OI_WF.GET_ACTIVITY_RESULT '|| P_ITEMTYPE||'/'||P_ITEMKEY||'/'||P_ACTIVITY_NAME , 1 ) ;

1622: --
1623: BEGIN
1624:
1625: IF l_debug_level > 0 THEN
1626: oe_debug_pub.add( 'ENTERING OE_OI_WF.GET_ACTIVITY_RESULT '|| P_ITEMTYPE||'/'||P_ITEMKEY||'/'||P_ACTIVITY_NAME , 1 ) ;
1627: END IF;
1628:
1629: SELECT wias.ACTIVITY_STATUS, wias.ACTIVITY_RESULT_CODE, wias.PROCESS_ACTIVITY
1630: INTO x_activity_status_code, x_activity_result, x_activity_id

Line 1640: oe_debug_pub.add( 'EXITING OE_OI_WF.GET_ACTIVITY_RESULT '||X_ACTIVITY_RESULT||'/'||X_RETURN_STATUS , 1 ) ;

1636:
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638:
1639: IF l_debug_level > 0 THEN
1640: oe_debug_pub.add( 'EXITING OE_OI_WF.GET_ACTIVITY_RESULT '||X_ACTIVITY_RESULT||'/'||X_RETURN_STATUS , 1 ) ;
1641: END IF;
1642:
1643: EXCEPTION
1644: WHEN NO_DATA_FOUND THEN

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

1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1649: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Get_Activity_Result');
1650: END IF;
1651: IF l_debug_level > 0 THEN
1652: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1653: END IF;
1654:
1655: END Get_Activity_Result;
1656:

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

1674: l_order_number Number;
1675: l_order_type_id Number;
1676: l_org_id Number;
1677: --
1678: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1679: --
1680: Begin
1681:
1682: IF p_funcmode = 'RUN' THEN

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

1773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1774: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Showso_Wf');
1775: END IF;
1776: IF l_debug_level > 0 THEN
1777: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1778: END IF;
1779: end if;
1780: OE_STANDARD_WF.Save_Messages;
1781: OE_STANDARD_WF.Clear_Msg_Context;

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

1810: p_itemkey => p_itemkey);
1811: OE_STANDARD_WF.Save_Messages;
1812: OE_STANDARD_WF.Clear_Msg_Context;
1813: IF l_debug_level > 0 THEN
1814: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1815: END IF;
1816: RAISE;
1817: End Raise_Event_Showso_Wf;
1818:

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

1831: l_customer_number Number;
1832: l_header_id Number;
1833: l_change_sequence Varchar2(50);
1834: --
1835: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1836: --
1837: Begin
1838:
1839: IF p_funcmode = 'RUN' THEN

Line 1842: oe_debug_pub.add( 'ENTERING SET_USER_KEY' ) ;

1838:
1839: IF p_funcmode = 'RUN' THEN
1840: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1841: IF l_debug_level > 0 THEN
1842: oe_debug_pub.add( 'ENTERING SET_USER_KEY' ) ;
1843: END IF;
1844:
1845: if (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_SHOW_SO) then
1846: l_header_id := wf_engine.GetItemAttrNumber(p_itemtype,

Line 1889: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;

1885: Else
1886: l_user_key := l_orig_sys_document_ref || ',' || to_char(l_customer_number) || ',' || l_transaction_type; --OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO;
1887: End If;
1888: IF l_debug_level > 0 THEN
1889: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1890: END IF;
1891: elsif (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT) then
1892: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype,
1893: p_itemkey,

Line 1938: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;

1934: aname => 'USER_KEY',
1935: avalue => l_user_key);
1936:
1937: IF l_debug_level > 0 THEN
1938: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1939: END IF;
1940: else -- now we will just assume that it is always passed in at this point
1941: -- TODO: we may need another else if to handle the ack being called from the conc_pgm or other workflow.
1942: l_user_key := wf_engine.GetItemAttrText(p_itemtype,

Line 1947: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;

1943: p_itemkey,
1944: 'USER_KEY'
1945: );
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1948: END IF;
1949:
1950: end if;
1951: wf_engine.SetItemUserKey(itemtype => p_itemtype,

Line 1958: oe_debug_pub.add( 'EXITING SET_USER_KEY' ) ;

1954:
1955:
1956: p_x_result := 'COMPLETE:COMPLETE';
1957: IF l_debug_level > 0 THEN
1958: oe_debug_pub.add( 'EXITING SET_USER_KEY' ) ;
1959: END IF;
1960:
1961: OE_STANDARD_WF.Save_Messages;
1962: OE_STANDARD_WF.Clear_Msg_Context;

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

2004:
2005: l_confirmation VARCHAR2(2000);
2006: l_message_id NUMBER;
2007: --
2008: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2009: --
2010: Begin
2011:
2012: IF p_funcmode = 'RUN' THEN

Line 2014: oe_debug_pub.add( 'ENTERING IS_CBOD_OUT_REQD' ) ;

2010: Begin
2011:
2012: IF p_funcmode = 'RUN' THEN
2013: IF l_debug_level > 0 THEN
2014: oe_debug_pub.add( 'ENTERING IS_CBOD_OUT_REQD' ) ;
2015: END IF;
2016: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2017: l_message_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2018: itemkey => p_itemkey,

Line 2021: oe_debug_pub.add( 'L_MESSAGE_ID : '|| L_MESSAGE_ID ) ;

2017: l_message_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2018: itemkey => p_itemkey,
2019: aname => 'PARAMETER5');
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add( 'L_MESSAGE_ID : '|| L_MESSAGE_ID ) ;
2022: END IF;
2023: Begin
2024: select confirmation
2025: into l_confirmation

Line 2031: oe_debug_pub.add( 'NO DATA FOUND IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;

2027: where document_id = l_message_id;
2028: Exception
2029: When NO_DATA_FOUND then
2030: IF l_debug_level > 0 THEN
2031: oe_debug_pub.add( 'NO DATA FOUND IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;
2032: END IF;
2033: p_x_result := 'F';
2034: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2035: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');

Line 2039: oe_debug_pub.add( 'OTHERS IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;

2035: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');
2036: END IF;
2037: When OTHERS then
2038: IF l_debug_level > 0 THEN
2039: oe_debug_pub.add( 'OTHERS IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;
2040: END IF;
2041: p_x_result := 'F';
2042: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2043: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');

Line 2047: oe_debug_pub.add( 'L_CONFIRMATION : '|| L_CONFIRMATION ) ;

2043: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');
2044: END IF;
2045: End;
2046: IF l_debug_level > 0 THEN
2047: oe_debug_pub.add( 'L_CONFIRMATION : '|| L_CONFIRMATION ) ;
2048: END IF;
2049: -- since we are only dealing with successes in our implementation,
2050: -- we only issue the cbod when l_confirmation is set to 2
2051: If l_confirmation = '2' then

Line 2058: oe_debug_pub.add( 'RETURN VALUE FOR IS_CBOD_OUT_REQD: ' || P_X_RESULT ) ;

2054: End If;
2055:
2056: --p_x_result := 'F';
2057: IF l_debug_level > 0 THEN
2058: oe_debug_pub.add( 'RETURN VALUE FOR IS_CBOD_OUT_REQD: ' || P_X_RESULT ) ;
2059: END IF;
2060: OE_STANDARD_WF.Save_Messages;
2061: OE_STANDARD_WF.Clear_Msg_Context;
2062:

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

2098: p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
2099: ) Is
2100:
2101: --
2102: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2103: --
2104: Begin
2105: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2106:

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

2117: p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
2118: ) Is
2119: l_event_key_num number;
2120: --
2121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2122: --
2123: Begin
2124:
2125: IF p_funcmode = 'RUN' THEN

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

2213: l_response_flag VARCHAR2(1);
2214: l_standard_desc VARCHAR2(80);
2215: l_failure_ack_flag VARCHAR2(10) := 'N';
2216: --
2217: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2218: --
2219: Begin
2220:
2221: IF p_funcmode = 'RUN' THEN

Line 2223: oe_debug_pub.add( 'ENTERING RAISE_EVENT_XMLINT_WF' ) ;

2219: Begin
2220:
2221: IF p_funcmode = 'RUN' THEN
2222: IF l_debug_level > 0 THEN
2223: oe_debug_pub.add( 'ENTERING RAISE_EVENT_XMLINT_WF' ) ;
2224: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
2225: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;
2226: END IF;
2227:

Line 2224: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;

2220:
2221: IF p_funcmode = 'RUN' THEN
2222: IF l_debug_level > 0 THEN
2223: oe_debug_pub.add( 'ENTERING RAISE_EVENT_XMLINT_WF' ) ;
2224: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
2225: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;
2226: END IF;
2227:
2228: OE_STANDARD_WF.Set_Msg_Context(p_actid);

Line 2225: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;

2221: IF p_funcmode = 'RUN' THEN
2222: IF l_debug_level > 0 THEN
2223: oe_debug_pub.add( 'ENTERING RAISE_EVENT_XMLINT_WF' ) ;
2224: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
2225: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;
2226: END IF;
2227:
2228: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2229:

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

2240: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
2241: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
2242: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
2243: IF l_debug_level > 0 THEN
2244: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
2245: END IF;
2246: End If;
2247:
2248:

Line 2269: oe_debug_pub.add( 'L_TRANSACTION_TYPE => ' || L_TRANSACTION_TYPE ) ;

2265: l_transaction_type := l_transaction_type_test2;
2266: End If;
2267:
2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add( 'L_TRANSACTION_TYPE => ' || L_TRANSACTION_TYPE ) ;
2270: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST1 => ' || L_TRANSACTION_TYPE_TEST1 ) ;
2271: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST2 => ' || L_TRANSACTION_TYPE_TEST2 ) ;
2272: END IF;
2273:

Line 2270: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST1 => ' || L_TRANSACTION_TYPE_TEST1 ) ;

2266: End If;
2267:
2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add( 'L_TRANSACTION_TYPE => ' || L_TRANSACTION_TYPE ) ;
2270: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST1 => ' || L_TRANSACTION_TYPE_TEST1 ) ;
2271: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST2 => ' || L_TRANSACTION_TYPE_TEST2 ) ;
2272: END IF;
2273:
2274: l_processing_stage := wf_engine.GetActivityAttrText (p_itemtype,

Line 2271: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST2 => ' || L_TRANSACTION_TYPE_TEST2 ) ;

2267:
2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add( 'L_TRANSACTION_TYPE => ' || L_TRANSACTION_TYPE ) ;
2270: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST1 => ' || L_TRANSACTION_TYPE_TEST1 ) ;
2271: oe_debug_pub.add( 'L_TRANSACTION_TYPE_TEST2 => ' || L_TRANSACTION_TYPE_TEST2 ) ;
2272: END IF;
2273:
2274: l_processing_stage := wf_engine.GetActivityAttrText (p_itemtype,
2275: p_itemkey,

Line 2295: oe_debug_pub.add( 'L_HEADER_ID => ' || L_HEADER_ID ) ;

2291: );
2292: -- end bug 3688227
2293:
2294: IF l_debug_level > 0 THEN
2295: oe_debug_pub.add( 'L_HEADER_ID => ' || L_HEADER_ID ) ;
2296: END IF;
2297:
2298: Begin
2299: Select orig_sys_document_ref

Line 2469: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER FOR ' || P_ITEMTYPE ) ;

2465: -- OE_STANDARD_WF.Save_Messages;
2466: -- OE_STANDARD_WF.Clear_Msg_Context;
2467: -- end data fix project
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER FOR ' || P_ITEMTYPE ) ;
2470: END IF;
2471: End;
2472:
2473: Elsif l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO THEN --do nothing, just trap

Line 2531: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER' ) ;

2527: END IF;
2528: OE_STANDARD_WF.Save_Messages;
2529: OE_STANDARD_WF.Clear_Msg_Context;
2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER' ) ;
2532: END IF;
2533: Return;
2534: End;
2535:

Line 2681: oe_debug_pub.add('L_ORIG_SYS_DOCUMENT_REF:' || l_orig_sys_document_ref) ;

2677: --Done Setting Message Text
2678:
2679:
2680: IF l_debug_level > 0 THEN
2681: oe_debug_pub.add('L_ORIG_SYS_DOCUMENT_REF:' || l_orig_sys_document_ref) ;
2682: oe_debug_pub.add('L_DOCUMENT_NUM:' || l_document_num) ;
2683: oe_debug_pub.add('L_MESSAGE_TEXT:' || l_message_text) ;
2684: oe_debug_pub.add('L_TRANSACTION_TYPE:' || l_transaction_type);
2685: oe_debug_pub.add('L_ORG_ID:' || l_org_id);

Line 2682: oe_debug_pub.add('L_DOCUMENT_NUM:' || l_document_num) ;

2678:
2679:
2680: IF l_debug_level > 0 THEN
2681: oe_debug_pub.add('L_ORIG_SYS_DOCUMENT_REF:' || l_orig_sys_document_ref) ;
2682: oe_debug_pub.add('L_DOCUMENT_NUM:' || l_document_num) ;
2683: oe_debug_pub.add('L_MESSAGE_TEXT:' || l_message_text) ;
2684: oe_debug_pub.add('L_TRANSACTION_TYPE:' || l_transaction_type);
2685: oe_debug_pub.add('L_ORG_ID:' || l_org_id);
2686: oe_debug_pub.add('L_CHANGE_SEQUENCE:' || l_change_sequence);

Line 2683: oe_debug_pub.add('L_MESSAGE_TEXT:' || l_message_text) ;

2679:
2680: IF l_debug_level > 0 THEN
2681: oe_debug_pub.add('L_ORIG_SYS_DOCUMENT_REF:' || l_orig_sys_document_ref) ;
2682: oe_debug_pub.add('L_DOCUMENT_NUM:' || l_document_num) ;
2683: oe_debug_pub.add('L_MESSAGE_TEXT:' || l_message_text) ;
2684: oe_debug_pub.add('L_TRANSACTION_TYPE:' || l_transaction_type);
2685: oe_debug_pub.add('L_ORG_ID:' || l_org_id);
2686: oe_debug_pub.add('L_CHANGE_SEQUENCE:' || l_change_sequence);
2687: END IF;

Line 2684: oe_debug_pub.add('L_TRANSACTION_TYPE:' || l_transaction_type);

2680: IF l_debug_level > 0 THEN
2681: oe_debug_pub.add('L_ORIG_SYS_DOCUMENT_REF:' || l_orig_sys_document_ref) ;
2682: oe_debug_pub.add('L_DOCUMENT_NUM:' || l_document_num) ;
2683: oe_debug_pub.add('L_MESSAGE_TEXT:' || l_message_text) ;
2684: oe_debug_pub.add('L_TRANSACTION_TYPE:' || l_transaction_type);
2685: oe_debug_pub.add('L_ORG_ID:' || l_org_id);
2686: oe_debug_pub.add('L_CHANGE_SEQUENCE:' || l_change_sequence);
2687: END IF;
2688:

Line 2685: oe_debug_pub.add('L_ORG_ID:' || l_org_id);

2681: oe_debug_pub.add('L_ORIG_SYS_DOCUMENT_REF:' || l_orig_sys_document_ref) ;
2682: oe_debug_pub.add('L_DOCUMENT_NUM:' || l_document_num) ;
2683: oe_debug_pub.add('L_MESSAGE_TEXT:' || l_message_text) ;
2684: oe_debug_pub.add('L_TRANSACTION_TYPE:' || l_transaction_type);
2685: oe_debug_pub.add('L_ORG_ID:' || l_org_id);
2686: oe_debug_pub.add('L_CHANGE_SEQUENCE:' || l_change_sequence);
2687: END IF;
2688:
2689:

Line 2686: oe_debug_pub.add('L_CHANGE_SEQUENCE:' || l_change_sequence);

2682: oe_debug_pub.add('L_DOCUMENT_NUM:' || l_document_num) ;
2683: oe_debug_pub.add('L_MESSAGE_TEXT:' || l_message_text) ;
2684: oe_debug_pub.add('L_TRANSACTION_TYPE:' || l_transaction_type);
2685: oe_debug_pub.add('L_ORG_ID:' || l_org_id);
2686: oe_debug_pub.add('L_CHANGE_SEQUENCE:' || l_change_sequence);
2687: END IF;
2688:
2689:
2690: -- Orig Sys Document Ref is passed in for Partner Document Number

Line 2722: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT_WF' ) ;

2718: p_failure_ack_flag => l_failure_ack_flag,
2719: x_return_status => l_return_status);
2720:
2721: IF l_debug_level > 0 THEN
2722: oe_debug_pub.add( 'EXITING RAISE_EVENT_XMLINT_WF' ) ;
2723: END IF;
2724: p_x_result := 'COMPLETE:COMPLETE';
2725:
2726:

Line 2763: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF'||SQLERRM ) ;

2759: p_itemkey => p_itemkey);
2760: OE_STANDARD_WF.Save_Messages;
2761: OE_STANDARD_WF.Clear_Msg_Context;
2762: IF l_debug_level > 0 THEN
2763: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF'||SQLERRM ) ;
2764: END IF;
2765: RAISE;
2766: End Raise_Event_Xmlint_Wf;
2767:

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

2778: l_party_id Number;
2779: l_party_site_id Number;
2780: l_error_code Number;
2781: l_error_msg Varchar2(1000);
2782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2783: l_debug_level_cln CONSTANT NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
2784:
2785: Begin
2786:

Line 2788: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');

2784:
2785: Begin
2786:
2787: IF (l_debug_level > 0) THEN
2788: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');
2789: oe_debug_pub.Add('With the following parameters:');
2790: oe_debug_pub.Add('itemtype:' || p_itemtype);
2791: oe_debug_pub.Add('itemkey:' || p_itemkey);
2792: oe_debug_pub.Add('actid:' || p_actid);

Line 2789: oe_debug_pub.Add('With the following parameters:');

2785: Begin
2786:
2787: IF (l_debug_level > 0) THEN
2788: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');
2789: oe_debug_pub.Add('With the following parameters:');
2790: oe_debug_pub.Add('itemtype:' || p_itemtype);
2791: oe_debug_pub.Add('itemkey:' || p_itemkey);
2792: oe_debug_pub.Add('actid:' || p_actid);
2793: oe_debug_pub.Add('funcmode:' || p_funcmode);

Line 2790: oe_debug_pub.Add('itemtype:' || p_itemtype);

2786:
2787: IF (l_debug_level > 0) THEN
2788: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');
2789: oe_debug_pub.Add('With the following parameters:');
2790: oe_debug_pub.Add('itemtype:' || p_itemtype);
2791: oe_debug_pub.Add('itemkey:' || p_itemkey);
2792: oe_debug_pub.Add('actid:' || p_actid);
2793: oe_debug_pub.Add('funcmode:' || p_funcmode);
2794: END IF;

Line 2791: oe_debug_pub.Add('itemkey:' || p_itemkey);

2787: IF (l_debug_level > 0) THEN
2788: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');
2789: oe_debug_pub.Add('With the following parameters:');
2790: oe_debug_pub.Add('itemtype:' || p_itemtype);
2791: oe_debug_pub.Add('itemkey:' || p_itemkey);
2792: oe_debug_pub.Add('actid:' || p_actid);
2793: oe_debug_pub.Add('funcmode:' || p_funcmode);
2794: END IF;
2795: -- Start of CLN debugs

Line 2792: oe_debug_pub.Add('actid:' || p_actid);

2788: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');
2789: oe_debug_pub.Add('With the following parameters:');
2790: oe_debug_pub.Add('itemtype:' || p_itemtype);
2791: oe_debug_pub.Add('itemkey:' || p_itemkey);
2792: oe_debug_pub.Add('actid:' || p_actid);
2793: oe_debug_pub.Add('funcmode:' || p_funcmode);
2794: END IF;
2795: -- Start of CLN debugs
2796: IF (l_debug_level_cln <= 1) THEN

Line 2793: oe_debug_pub.Add('funcmode:' || p_funcmode);

2789: oe_debug_pub.Add('With the following parameters:');
2790: oe_debug_pub.Add('itemtype:' || p_itemtype);
2791: oe_debug_pub.Add('itemkey:' || p_itemkey);
2792: oe_debug_pub.Add('actid:' || p_actid);
2793: oe_debug_pub.Add('funcmode:' || p_funcmode);
2794: END IF;
2795: -- Start of CLN debugs
2796: IF (l_debug_level_cln <= 1) THEN
2797: cln_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET',1);

Line 2834: oe_debug_pub.Add('EXITING IS_OAG_OR_ROSETTANET Successfully');

2830: p_x_result := 'OAG';
2831: end if;
2832:
2833: IF (l_debug_level > 0) THEN
2834: oe_debug_pub.Add('EXITING IS_OAG_OR_ROSETTANET Successfully');
2835: END IF;
2836: -- Start of CLN debugs
2837: IF (l_debug_level_cln <= 2) THEN
2838: cln_debug_pub.Add('EXITING IS_OAG_OR_ROSETTANET Successfully', 2);

Line 2858: oe_debug_pub.add( 'ERROR CODE : ' || l_error_code || ', ERROR MESSAGE : '||SUBSTR ( l_error_msg , 1 , 200 ) , 1 ) ;

2854: p_itemkey => p_itemkey);
2855: OE_STANDARD_WF.Save_Messages;
2856: OE_STANDARD_WF.Clear_Msg_Context;
2857: IF l_debug_level > 0 THEN
2858: oe_debug_pub.add( 'ERROR CODE : ' || l_error_code || ', ERROR MESSAGE : '||SUBSTR ( l_error_msg , 1 , 200 ) , 1 ) ;
2859: END IF;
2860: -- Start of CLN debugs
2861: IF (l_debug_level_cln <= 1) THEN
2862: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);