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_NEGOTIATE_WF dependencies on OE_NEGOTIATE_WF

Line 1: PACKAGE BODY OE_Negotiate_WF as

1: PACKAGE BODY OE_Negotiate_WF as
2: /* $Header: OEXWNEGB.pls 120.7.12020000.3 2013/01/30 08:04:45 spothula ship $ */
3:
4:
5: PROCEDURE Update_Status_Lost(

Line 19: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Status_Lost:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

15: --
16:
17: BEGIN
18: IF l_debug_level > 0 THEN
19: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Status_Lost:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
20: END IF;
21: OE_STANDARD_WF.Set_Msg_Context(actid);
22: IF (funcmode = 'RUN') then
23:

Line 46: wf_core.context('OE_Negotiate_WF', 'Update_Status_Lost', itemtype, itemkey, to_char(actid), funcmode);

42:
43: END IF;
44: EXCEPTION
45: when others then
46: wf_core.context('OE_Negotiate_WF', 'Update_Status_Lost', itemtype, itemkey, to_char(actid), funcmode);
47: -- start data fix project
48: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
49: p_itemtype => itemtype,
50: p_itemkey => itemkey);

Line 76: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Negotiation_Complete:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

72: --
73:
74: BEGIN
75: IF l_debug_level > 0 THEN
76: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Negotiation_Complete:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
77: END IF;
78: OE_STANDARD_WF.Set_Msg_Context(actid);
79: IF (funcmode = 'RUN') then
80:

Line 109: wf_core.context('OE_Negotiate_WF', 'Negotiation_Complete', itemtype, itemkey, to_char(actid), funcmode);

105: END IF;
106: END IF;
107: EXCEPTION
108: when others then
109: wf_core.context('OE_Negotiate_WF', 'Negotiation_Complete', itemtype, itemkey, to_char(actid), funcmode);
110: -- start data fix project
111: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
112: p_itemtype => itemtype,
113: p_itemkey => itemkey);

Line 149: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Submit_Draft_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

145: --
146:
147: BEGIN
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Submit_Draft_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
150: END IF;
151: OE_STANDARD_WF.Set_Msg_Context(actid);
152:
153: IF (funcmode = 'RUN') then

Line 264: oe_debug_pub.add('Exiting OE_NEGOTIATE_WF.Submit_Draft_Internal Normally', 1);

260:
261: resultout := 'COMPLETE:COMPLETE';
262:
263: IF l_debug_level > 0 THEN
264: oe_debug_pub.add('Exiting OE_NEGOTIATE_WF.Submit_Draft_Internal Normally', 1);
265: END IF;
266:
267:
268: END IF;

Line 271: wf_core.context('OE_Negotiate_WF', 'Submit_Draft_Internal', itemtype, itemkey, to_char(actid), funcmode);

267:
268: END IF;
269: EXCEPTION
270: when others then
271: wf_core.context('OE_Negotiate_WF', 'Submit_Draft_Internal', itemtype, itemkey, to_char(actid), funcmode);
272: -- start data fix project
273: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
274: p_itemtype => itemtype,
275: p_itemkey => itemkey);

Line 298: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Customer_Acceptance:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

294: --
295:
296: BEGIN
297: IF l_debug_level > 0 THEN
298: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Customer_Acceptance:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
299: END IF;
300: OE_STANDARD_WF.Set_Msg_Context(actid);
301: IF (funcmode = 'RUN') then
302: OE_MSG_PUB.set_msg_context(

Line 323: wf_core.context('OE_Negotiate_WF', 'Customer_Acceptance', itemtype, itemkey, to_char(actid), funcmode);

319:
320: END IF;
321: EXCEPTION
322: when others then
323: wf_core.context('OE_Negotiate_WF', 'Customer_Acceptance', itemtype, itemkey, to_char(actid), funcmode);
324: -- start data fix project
325: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
326: p_itemtype => itemtype,
327: p_itemkey => itemkey);

Line 350: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Accepted:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

346: --
347:
348: BEGIN
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Accepted:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
351: END IF;
352: OE_STANDARD_WF.Set_Msg_Context(actid);
353: IF (funcmode = 'RUN') then
354: OE_MSG_PUB.set_msg_context(

Line 376: wf_core.context('OE_Negotiate_WF', 'Update_Customer_Accepted', itemtype, itemkey, to_char(actid), funcmode);

372:
373: END IF;
374: EXCEPTION
375: when others then
376: wf_core.context('OE_Negotiate_WF', 'Update_Customer_Accepted', itemtype, itemkey, to_char(actid), funcmode);
377: -- start data fix project
378: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
379: p_itemtype => itemtype,
380: p_itemkey => itemkey);

Line 404: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Rejected:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

400:
401: BEGIN
402:
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Rejected:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
405: END IF;
406: OE_STANDARD_WF.Set_Msg_Context(actid);
407: IF (funcmode = 'RUN') then
408: OE_MSG_PUB.set_msg_context(

Line 430: wf_core.context('OE_Negotiate_WF', 'Update_Customer_Rejected', itemtype, itemkey, to_char(actid), funcmode);

426:
427: END IF;
428: EXCEPTION
429: when others then
430: wf_core.context('OE_Negotiate_WF', 'Update_Customer_Rejected', itemtype, itemkey, to_char(actid), funcmode);
431: -- start data fix project
432: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
433: p_itemtype => itemtype,
434: p_itemkey => itemkey);

Line 462: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Check_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

458:
459: BEGIN
460:
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Check_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
463: END IF;
464: OE_STANDARD_WF.Set_Msg_Context(actid);
465: IF (funcmode = 'RUN') then
466: OE_MSG_PUB.set_msg_context(

Line 501: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO TIMER TO SET', 1);

497: , avalue=>l_avalue
498: );
499: resultout := 'COMPLETE:COMPLETE';
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO TIMER TO SET', 1);
502: END IF;
503: return;
504: END IF;
505:

Line 510: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: EXPIRED', 1);

506: -- expiration date does exist but expired
507: IF l_expiration_date < sysdate THEN
508: resultout := 'COMPLETE:EXPIRED';
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: EXPIRED', 1);
511: END IF;
512: return;
513: END IF;
514:

Line 529: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO REMINDER', 1);

525: aname=>'OFFER_FINAL_EXPIRE_TIMER',
526: avalue=>l_final_timer);
527: resultout := 'COMPLETE:NO_REMINDER';
528: IF l_debug_level > 0 THEN
529: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO REMINDER', 1);
530: END IF;
531: ELSIF to_char(sysdate, 'DD-MON-RRRR') = to_char(l_expiration_date, 'DD-MON-RRRR') THEN
532: -- pre notification percentage is non-zero
533: -- expiration_date is today midnight, we should send the reminder

Line 542: oe_debug_pub.add('OE_Negotiate_WF.Check_Expiration_Date: EXPIRE TODAY', 1);

538: , avalue=>(l_expiration_date - sysdate) * 1440
539: );
540: resultout := 'COMPLETE:EXPIRE_TODAY';
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add('OE_Negotiate_WF.Check_Expiration_Date: EXPIRE TODAY', 1);
543: END IF;
544: ELSE --expiration is not today, i.e. it is in the future
545: --again expiration_date should already be in 23:59:59
546: l_aname(1) := 'OFFER_FINAL_EXPIRE_TIMER';

Line 560: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: TIMER(S) SET', 1);

556: resultout := 'COMPLETE:COMPLETE';
557: END IF; -- end if of expiration date is today or future
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: TIMER(S) SET', 1);
561: END IF;
562: END IF; --funcmode = run
563:
564: EXCEPTION

Line 566: wf_core.context('OE_Negotiate_WF', 'Check_Expiration_Date', itemtype, itemkey, to_char(actid), funcmode);

562: END IF; --funcmode = run
563:
564: EXCEPTION
565: when others then
566: wf_core.context('OE_Negotiate_WF', 'Check_Expiration_Date', itemtype, itemkey, to_char(actid), funcmode);
567: -- start data fix project
568: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
569: p_itemtype => itemtype,
570: p_itemkey => itemkey);

Line 602: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Offer_Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

598: --
599:
600: BEGIN
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Offer_Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
603: END IF;
604: OE_STANDARD_WF.Set_Msg_Context(actid);
605: IF (funcmode = 'RUN') then
606: OE_MSG_PUB.set_msg_context(

Line 659: wf_core.context('OE_Negotiate_WF', 'Offer_Expired', itemtype, itemkey, to_char(actid), funcmode);

655:
656: END IF;
657: EXCEPTION
658: when others then
659: wf_core.context('OE_Negotiate_WF', 'Offer_Expired', itemtype, itemkey, to_char(actid), funcmode);
660: -- start data fix project
661: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
662: p_itemtype => itemtype,
663: p_itemkey => itemkey);

Line 829: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Lost: '|| TO_CHAR (p_header_id) ,1) ;

825: BEGIN
826: OE_MSG_PUB.initialize;
827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Lost: '|| TO_CHAR (p_header_id) ,1) ;
830: END IF;
831: OE_MSG_PUB.set_msg_context(
832: p_entity_code => 'HEADER'
833: ,p_entity_id => p_header_id

Line 861: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);

857: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
858: oe_msg_pub.add;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: IF l_debug_level > 0 THEN
861: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
862: END IF;
863: return;
864: END;
865: -- ok to go Lost

Line 880: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);

876:
877: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'LOST');
878:
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);
881: END IF;
882: EXCEPTION
883: WHEN OTHERS THEN
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 886: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);

882: EXCEPTION
883: WHEN OTHERS THEN
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
885: IF l_debug_level > 0 THEN
886: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
887: END IF;
888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
889: THEN
890: OE_MSG_PUB.Add_Exc_Msg

Line 919: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Accepted: '|| TO_CHAR (p_header_id) ,1) ;

915: BEGIN
916: OE_MSG_PUB.initialize;
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Accepted: '|| TO_CHAR (p_header_id) ,1) ;
920: END IF;
921:
922: OE_MSG_PUB.set_msg_context(
923: p_entity_code => 'HEADER'

Line 983: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);

979: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
980: oe_msg_pub.add;
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: IF l_debug_level > 0 THEN
983: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
984: END IF;
985: return;
986: END;
987: -- ok to go Accept

Line 1013: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted normally', 1);

1009: itemkey => to_char(p_header_id),
1010: activity => l_activity_name,
1011: result => 'ACCEPT');
1012: IF l_debug_level > 0 THEN
1013: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted normally', 1);
1014: END IF;
1015: EXCEPTION
1016:
1017: WHEN OTHERS THEN

Line 1020: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);

1016:
1017: WHEN OTHERS THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
1021: END IF;
1022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1023: THEN
1024: OE_MSG_PUB.Add_Exc_Msg

Line 1057: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Rejected: '|| TO_CHAR (p_header_id) ,1) ;

1053: BEGIN
1054: OE_MSG_PUB.initialize;
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Rejected: '|| TO_CHAR (p_header_id) ,1) ;
1058: END IF;
1059: OE_MSG_PUB.set_msg_context(
1060: p_entity_code => 'HEADER'
1061: ,p_entity_id => p_header_id

Line 1089: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);

1085: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1086: oe_msg_pub.add;
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1090: END IF;
1091: return;
1092: END;
1093: -- ok to go Reject

Line 1107: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);

1103:
1104:
1105: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'REJECT');
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);
1108: END IF;
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1113: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);

1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1112: IF l_debug_level > 0 THEN
1113: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1114: END IF;
1115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1116: THEN
1117: OE_MSG_PUB.Add_Exc_Msg

Line 1140: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Offer_Date_Changed: '|| TO_CHAR (p_header_id) ,1) ;

1136: BEGIN
1137: OE_MSG_PUB.initialize;
1138: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139: IF l_debug_level > 0 THEN
1140: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Offer_Date_Changed: '|| TO_CHAR (p_header_id) ,1) ;
1141: END IF;
1142: OE_MSG_PUB.set_msg_context(
1143: p_entity_code => 'HEADER'
1144: ,p_entity_id => p_header_id

Line 1171: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);

1167: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1168: oe_msg_pub.add;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: IF l_debug_level > 0 THEN
1171: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1172: END IF;
1173: return;
1174: END;
1175: -- ok to go date changed

Line 1181: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);

1177: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);
1178: END IF;
1179: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);
1182: END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1187: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);

1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1188: END IF;
1189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: OE_MSG_PUB.Add_Exc_Msg

Line 1220: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1) ;

1216: BEGIN
1217: -- OE_MSG_PUB.initialize; commented out for 4671489
1218: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219: IF l_debug_level > 0 THEN
1220: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1) ;
1221: END IF;
1222:
1223: BEGIN
1224: --Bug3435165

Line 1299: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);

1295: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1296: oe_msg_pub.add;
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: IF l_debug_level > 0 THEN
1299: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1300: END IF;
1301: return;
1302: END;
1303: -- ok to go Submit Draft

Line 1309: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft normally', 1);

1305: itemkey => to_char(p_header_id),
1306: activity => l_activity_name,
1307: result => 'COMPLETE');
1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft normally', 1);
1310: END IF;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1315: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);

1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: IF l_debug_level > 0 THEN
1315: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1316: END IF;
1317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1318: THEN
1319: OE_MSG_PUB.Add_Exc_Msg

Line 1345: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id) ,1 ) ;

1341: l_avaluetext wf_engine.texttabtyp;
1342: --
1343: BEGIN
1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id) ,1 ) ;
1346: END IF;
1347:
1348: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, To_char(p_header_id), 'SALES_DOCUMENT_TYPE_CODE');
1349: IF l_sales_document_type_code = 'O' THEN

Line 1402: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

1398: --
1399: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1400: BEGIN
1401: IF l_debug_level > 0 THEN
1402: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1403: END IF;
1404: OE_STANDARD_WF.Set_Msg_Context(actid);
1405: IF (funcmode = 'RUN') THEN
1406: set_header_attributes_internal(To_number(itemkey));

Line 1411: wf_core.context('OE_Negotiate_WF', 'Set_Header_Attributes', itemtype, itemkey, to_char(actid), funcmode);

1407: resultout := 'COMPLETE';
1408: END IF;
1409: EXCEPTION
1410: when others then
1411: wf_core.context('OE_Negotiate_WF', 'Set_Header_Attributes', itemtype, itemkey, to_char(actid), funcmode);
1412: -- start data fix project
1413: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1414: p_itemtype => itemtype,
1415: p_itemkey => itemkey);

Line 1440: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Final_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

1436: --
1437:
1438: BEGIN
1439: IF l_debug_level > 0 THEN
1440: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Final_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1441: END IF;
1442: OE_STANDARD_WF.Set_Msg_Context(actid);
1443: IF (funcmode = 'RUN') then
1444: OE_MSG_PUB.set_msg_context(

Line 1496: oe_debug_pub.add('Leaving OE_Negotiate_WF.Set_Final_Expiration_Date', 1);

1492: resultout := 'COMPLETE:EXPIRED';
1493: END IF;
1494:
1495: IF l_debug_level > 0 THEN
1496: oe_debug_pub.add('Leaving OE_Negotiate_WF.Set_Final_Expiration_Date', 1);
1497: END IF;
1498: END IF;
1499: EXCEPTION
1500: when others then

Line 1501: wf_core.context('OE_Negotiate_WF', 'Set_Final_Expiration_Date', itemtype, itemkey, to_char(actid), funcmode);

1497: END IF;
1498: END IF;
1499: EXCEPTION
1500: when others then
1501: wf_core.context('OE_Negotiate_WF', 'Set_Final_Expiration_Date', itemtype, itemkey, to_char(actid), funcmode);
1502: -- start data fix project
1503: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1504: p_itemtype => itemtype,
1505: p_itemkey => itemkey);

Line 1527: oe_debug_pub.add( 'ENTER OE_Negotiate_WF.At_Customer_Acceptance');

1523: --
1524: BEGIN
1525:
1526: IF l_debug_level > 0 THEN
1527: oe_debug_pub.add( 'ENTER OE_Negotiate_WF.At_Customer_Acceptance');
1528: END IF;
1529:
1530: select wpa.activity_name
1531: into l_activity_name

Line 1549: END OE_Negotiate_WF;

1545:
1546: END At_Customer_Acceptance;
1547:
1548:
1549: END OE_Negotiate_WF;