DBA Data[Home] [Help]

APPS.OE_BLANKET_WF dependencies on STANDARD

Line 24: OE_STANDARD_WF.Set_Msg_Context(actid);

20: BEGIN
21: IF l_debug_level > 0 THEN
22: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Submit_Draft_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
23: END IF;
24: OE_STANDARD_WF.Set_Msg_Context(actid);
25: IF (funcmode = 'RUN') then
26:
27: select count(1)
28: into l_count

Line 53: OE_STANDARD_WF.Save_Messages;

49: IF l_return_status = FND_API.G_RET_STS_SUCCESS
50: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS
51: AND l_qa_return_status <> 'W' THEN
52: resultout := 'COMPLETE:INCOMPLETE';
53: OE_STANDARD_WF.Save_Messages;
54: OE_STANDARD_WF.Clear_Msg_Context;
55: return;
56: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
57: -- API call failed completely, fail the activity

Line 54: OE_STANDARD_WF.Clear_Msg_Context;

50: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS
51: AND l_qa_return_status <> 'W' THEN
52: resultout := 'COMPLETE:INCOMPLETE';
53: OE_STANDARD_WF.Save_Messages;
54: OE_STANDARD_WF.Clear_Msg_Context;
55: return;
56: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
57: -- API call failed completely, fail the activity
58: app_exception.raise_exception;

Line 74: OE_STANDARD_WF.Save_Messages;

70: x_return_status => l_return_status);
71:
72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
73: resultout := 'COMPLETE:INCOMPLETE';
74: OE_STANDARD_WF.Save_Messages;
75: OE_STANDARD_WF.Clear_Msg_Context;
76: return;
77: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
78: app_exception.raise_exception;

Line 75: OE_STANDARD_WF.Clear_Msg_Context;

71:
72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
73: resultout := 'COMPLETE:INCOMPLETE';
74: OE_STANDARD_WF.Save_Messages;
75: OE_STANDARD_WF.Clear_Msg_Context;
76: return;
77: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
78: app_exception.raise_exception;
79: END IF;

Line 89: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

85: EXCEPTION
86: when others then
87: wf_core.context('OE_Blanket_WF', 'Submit_Draft_Internal', itemtype, itemkey, to_char(actid), funcmode);
88: -- start data fix project
89: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
90: p_itemtype => itemtype,
91: p_itemkey => itemkey);
92: -- end data fix project
93: OE_STANDARD_WF.Save_Messages;

Line 93: OE_STANDARD_WF.Save_Messages;

89: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
90: p_itemtype => itemtype,
91: p_itemkey => itemkey);
92: -- end data fix project
93: OE_STANDARD_WF.Save_Messages;
94: OE_STANDARD_WF.Clear_Msg_Context;
95: raise;
96:
97: END Submit_Draft_Internal;

Line 94: OE_STANDARD_WF.Clear_Msg_Context;

90: p_itemtype => itemtype,
91: p_itemkey => itemkey);
92: -- end data fix project
93: OE_STANDARD_WF.Save_Messages;
94: OE_STANDARD_WF.Clear_Msg_Context;
95: raise;
96:
97: END Submit_Draft_Internal;
98:

Line 115: OE_STANDARD_WF.Set_Msg_Context(actid);

111: BEGIN
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Check_Negotiation_Exists:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
114: END IF;
115: OE_STANDARD_WF.Set_Msg_Context(actid);
116: IF (funcmode = 'RUN') THEN
117: select count(1)
118: into l_count
119: from wf_items

Line 139: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

135: EXCEPTION
136: when others then
137: wf_core.context('OE_Blanket_WF', 'Check_Negotiation_Exists', itemtype, itemkey, to_char(actid), funcmode);
138: -- start data fix project
139: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
140: p_itemtype => itemtype,
141: p_itemkey => itemkey);
142: -- end data fix project
143: OE_STANDARD_WF.Save_Messages;

Line 143: OE_STANDARD_WF.Save_Messages;

139: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
140: p_itemtype => itemtype,
141: p_itemkey => itemkey);
142: -- end data fix project
143: OE_STANDARD_WF.Save_Messages;
144: OE_STANDARD_WF.Clear_Msg_Context;
145: raise;
146:
147: END Check_Negotiation_Exists;

Line 144: OE_STANDARD_WF.Clear_Msg_Context;

140: p_itemtype => itemtype,
141: p_itemkey => itemkey);
142: -- end data fix project
143: OE_STANDARD_WF.Save_Messages;
144: OE_STANDARD_WF.Clear_Msg_Context;
145: raise;
146:
147: END Check_Negotiation_Exists;
148:

Line 174: OE_STANDARD_WF.Set_Msg_Context(actid);

170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Calculate_Effective_Dates:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
173: END IF;
174: OE_STANDARD_WF.Set_Msg_Context(actid);
175: IF (funcmode = 'RUN') then
176: SELECT obhe.Start_Date_Active, obhe.End_Date_Active
177: INTO l_start_date, l_end_date
178: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

Line 285: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

281: EXCEPTION
282: when others then
283: wf_core.context('OE_Blanket_WF', 'Calculate_Effective_Dates', itemtype, itemkey, to_char(actid), funcmode);
284: -- start data fix project
285: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
286: p_itemtype => itemtype,
287: p_itemkey => itemkey);
288: -- end data fix project
289: OE_STANDARD_WF.Save_Messages;

Line 289: OE_STANDARD_WF.Save_Messages;

285: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
286: p_itemtype => itemtype,
287: p_itemkey => itemkey);
288: -- end data fix project
289: OE_STANDARD_WF.Save_Messages;
290: OE_STANDARD_WF.Clear_Msg_Context;
291: raise;
292:
293: END Calculate_Effective_Dates;

Line 290: OE_STANDARD_WF.Clear_Msg_Context;

286: p_itemtype => itemtype,
287: p_itemkey => itemkey);
288: -- end data fix project
289: OE_STANDARD_WF.Save_Messages;
290: OE_STANDARD_WF.Clear_Msg_Context;
291: raise;
292:
293: END Calculate_Effective_Dates;
294:

Line 416: OE_STANDARD_WF.Set_Msg_Context(actid);

412: BEGIN
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
415: END IF;
416: OE_STANDARD_WF.Set_Msg_Context(actid);
417: IF (funcmode = 'RUN') then
418: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
419: p_item_key => itemkey,
420: p_flow_status_code => 'EXPIRED',

Line 459: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

455: EXCEPTION
456: when others then
457: wf_core.context('OE_Blanket_WF', 'Expired', itemtype, itemkey, to_char(actid), funcmode);
458: -- start data fix project
459: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
460: p_itemtype => itemtype,
461: p_itemkey => itemkey);
462: -- end data fix project
463: OE_STANDARD_WF.Save_Messages;

Line 463: OE_STANDARD_WF.Save_Messages;

459: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
460: p_itemtype => itemtype,
461: p_itemkey => itemkey);
462: -- end data fix project
463: OE_STANDARD_WF.Save_Messages;
464: OE_STANDARD_WF.Clear_Msg_Context;
465: raise;
466: END Expired;
467:

Line 464: OE_STANDARD_WF.Clear_Msg_Context;

460: p_itemtype => itemtype,
461: p_itemkey => itemkey);
462: -- end data fix project
463: OE_STANDARD_WF.Save_Messages;
464: OE_STANDARD_WF.Clear_Msg_Context;
465: raise;
466: END Expired;
467:
468:

Line 486: OE_STANDARD_WF.Set_Msg_Context(actid);

482: BEGIN
483: IF l_debug_level > 0 THEN
484: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Terminate_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
485: END IF;
486: OE_STANDARD_WF.Set_Msg_Context(actid);
487: IF (funcmode = 'RUN') then
488: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
489: p_item_key => itemkey,
490: p_flow_status_code => 'TERMINATED',

Line 506: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

502: EXCEPTION
503: when others then
504: wf_core.context('OE_Blanket_WF', 'Terminate_Internal', itemtype, itemkey, to_char(actid), funcmode);
505: -- start data fix project
506: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
507: p_itemtype => itemtype,
508: p_itemkey => itemkey);
509: -- end data fix project
510: OE_STANDARD_WF.Save_Messages;

Line 510: OE_STANDARD_WF.Save_Messages;

506: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
507: p_itemtype => itemtype,
508: p_itemkey => itemkey);
509: -- end data fix project
510: OE_STANDARD_WF.Save_Messages;
511: OE_STANDARD_WF.Clear_Msg_Context;
512: raise;
513:
514: END Terminate_Internal;

Line 511: OE_STANDARD_WF.Clear_Msg_Context;

507: p_itemtype => itemtype,
508: p_itemkey => itemkey);
509: -- end data fix project
510: OE_STANDARD_WF.Save_Messages;
511: OE_STANDARD_WF.Clear_Msg_Context;
512: raise;
513:
514: END Terminate_Internal;
515:

Line 534: OE_STANDARD_WF.Set_Msg_Context(actid);

530: BEGIN
531: IF l_debug_level > 0 THEN
532: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Close_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
533: END IF;
534: OE_STANDARD_WF.Set_Msg_Context(actid);
535: IF (funcmode = 'RUN') then
536: -- check for releases of blanket
537: l_blanket_number := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'TRANSACTION_NUMBER');
538: OE_BLANKET_WF_UTIL.Check_Release(p_blanket_number => l_blanket_number, x_return_status => l_return_status);

Line 543: OE_STANDARD_WF.Save_Messages;

539: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
540: --Blanket release check failed, return incomplete
541: --UI will display the message
542: resultout := 'COMPLETE:INCOMPLETE';
543: OE_STANDARD_WF.Save_Messages;
544: OE_STANDARD_WF.Clear_Msg_Context;
545: return;
546: END IF;
547: -- update open_flag to N

Line 544: OE_STANDARD_WF.Clear_Msg_Context;

540: --Blanket release check failed, return incomplete
541: --UI will display the message
542: resultout := 'COMPLETE:INCOMPLETE';
543: OE_STANDARD_WF.Save_Messages;
544: OE_STANDARD_WF.Clear_Msg_Context;
545: return;
546: END IF;
547: -- update open_flag to N
548: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,

Line 565: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

561: EXCEPTION
562: when others then
563: wf_core.context('OE_Blanket_WF', 'Close_Internal', itemtype, itemkey, to_char(actid), funcmode);
564: -- start data fix project
565: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
566: p_itemtype => itemtype,
567: p_itemkey => itemkey);
568: -- end data fix project
569: OE_STANDARD_WF.Save_Messages;

Line 569: OE_STANDARD_WF.Save_Messages;

565: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
566: p_itemtype => itemtype,
567: p_itemkey => itemkey);
568: -- end data fix project
569: OE_STANDARD_WF.Save_Messages;
570: OE_STANDARD_WF.Clear_Msg_Context;
571: raise;
572:
573: END Close_Internal;

Line 570: OE_STANDARD_WF.Clear_Msg_Context;

566: p_itemtype => itemtype,
567: p_itemkey => itemkey);
568: -- end data fix project
569: OE_STANDARD_WF.Save_Messages;
570: OE_STANDARD_WF.Clear_Msg_Context;
571: raise;
572:
573: END Close_Internal;
574:

Line 1023: OE_STANDARD_WF.Set_Msg_Context(actid);

1019: BEGIN
1020: IF l_debug_level > 0 THEN
1021: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1022: END IF;
1023: OE_STANDARD_WF.Set_Msg_Context(actid);
1024: IF (funcmode = 'RUN') THEN
1025: set_header_attributes_internal(To_number(itemkey));
1026: resultout := 'COMPLETE';
1027: END IF;

Line 1032: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1028: EXCEPTION
1029: when others then
1030: wf_core.context('OE_Blanket_WF', 'Set_Header_Attributes', itemtype, itemkey, to_char(actid), funcmode);
1031: -- start data fix project
1032: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1033: p_itemtype => itemtype,
1034: p_itemkey => itemkey);
1035: -- end data fix project
1036: OE_STANDARD_WF.Save_Messages;

Line 1036: OE_STANDARD_WF.Save_Messages;

1032: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1033: p_itemtype => itemtype,
1034: p_itemkey => itemkey);
1035: -- end data fix project
1036: OE_STANDARD_WF.Save_Messages;
1037: OE_STANDARD_WF.Clear_Msg_Context;
1038: raise;
1039: END Set_Header_Attributes;
1040:

Line 1037: OE_STANDARD_WF.Clear_Msg_Context;

1033: p_itemtype => itemtype,
1034: p_itemkey => itemkey);
1035: -- end data fix project
1036: OE_STANDARD_WF.Save_Messages;
1037: OE_STANDARD_WF.Clear_Msg_Context;
1038: raise;
1039: END Set_Header_Attributes;
1040:
1041:

Line 1061: OE_STANDARD_WF.Set_Msg_Context(actid);

1057: BEGIN
1058: IF l_debug_level > 0 THEN
1059: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Final_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1060: END IF;
1061: OE_STANDARD_WF.Set_Msg_Context(actid);
1062: IF (funcmode = 'RUN') THEN
1063: set_header_attributes_internal(To_number(itemkey));
1064: IF l_debug_level > 0 THEN
1065: oe_debug_pub.add( 'Done setting header attributes',1);

Line 1106: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1102: EXCEPTION
1103: when others then
1104: wf_core.context('OE_Blanket_WF', 'Set_Final_Expiration_Date', itemtype, itemkey, to_char(actid), funcmode);
1105: -- start data fix project
1106: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1107: p_itemtype => itemtype,
1108: p_itemkey => itemkey);
1109: -- end data fix project
1110: OE_STANDARD_WF.Save_Messages;

Line 1110: OE_STANDARD_WF.Save_Messages;

1106: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1107: p_itemtype => itemtype,
1108: p_itemkey => itemkey);
1109: -- end data fix project
1110: OE_STANDARD_WF.Save_Messages;
1111: OE_STANDARD_WF.Clear_Msg_Context;
1112: raise;
1113: END set_final_expiration_date;
1114:

Line 1111: OE_STANDARD_WF.Clear_Msg_Context;

1107: p_itemtype => itemtype,
1108: p_itemkey => itemkey);
1109: -- end data fix project
1110: OE_STANDARD_WF.Save_Messages;
1111: OE_STANDARD_WF.Clear_Msg_Context;
1112: raise;
1113: END set_final_expiration_date;
1114:
1115: END OE_Blanket_WF;