40:
41: END IF;
42: -- END: code for BULK order import
43:
44: OE_STANDARD_WF.Set_Msg_Context(actid);
45:
46: IF l_debug_level > 0 THEN
47: oe_debug_pub.add( 'CALL CHECK_BOOKING_HOLDS' ) ;
48: END IF;
56: END IF;
57:
58: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
59: resultout := 'COMPLETE:ON_HOLD';
60: OE_STANDARD_WF.Save_Messages;
61: OE_STANDARD_WF.Clear_Msg_Context;
62: return;
63: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
64: -- start data fix project
57:
58: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
59: resultout := 'COMPLETE:ON_HOLD';
60: OE_STANDARD_WF.Save_Messages;
61: OE_STANDARD_WF.Clear_Msg_Context;
62: return;
63: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
64: -- start data fix project
65: -- OE_STANDARD_WF.Save_Messages;
61: OE_STANDARD_WF.Clear_Msg_Context;
62: return;
63: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
64: -- start data fix project
65: -- OE_STANDARD_WF.Save_Messages;
66: -- OE_STANDARD_WF.Clear_Msg_Context;
67: -- end data fix project
68: app_exception.raise_exception;
69: END IF;
62: return;
63: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
64: -- start data fix project
65: -- OE_STANDARD_WF.Save_Messages;
66: -- OE_STANDARD_WF.Clear_Msg_Context;
67: -- end data fix project
68: app_exception.raise_exception;
69: END IF;
70:
83: END IF;
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: resultout := 'COMPLETE:INCOMPLETE';
87: OE_STANDARD_WF.Save_Messages;
88: OE_STANDARD_WF.Clear_Msg_Context;
89: return;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: -- start data fix project
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: resultout := 'COMPLETE:INCOMPLETE';
87: OE_STANDARD_WF.Save_Messages;
88: OE_STANDARD_WF.Clear_Msg_Context;
89: return;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: -- start data fix project
92: -- OE_STANDARD_WF.Save_Messages;
88: OE_STANDARD_WF.Clear_Msg_Context;
89: return;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: -- start data fix project
92: -- OE_STANDARD_WF.Save_Messages;
93: -- OE_STANDARD_WF.Clear_Msg_Context;
94: -- end data fix project
95: app_exception.raise_exception;
96: END IF;
89: return;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: -- start data fix project
92: -- OE_STANDARD_WF.Save_Messages;
93: -- OE_STANDARD_WF.Clear_Msg_Context;
94: -- end data fix project
95: app_exception.raise_exception;
96: END IF;
97:
95: app_exception.raise_exception;
96: END IF;
97:
98: resultout := 'COMPLETE:COMPLETE';
99: OE_STANDARD_WF.Clear_Msg_Context;
100: return;
101:
102: end if; -- End for 'RUN' mode
103:
133: -- in the case of an exception.
134: wf_core.context('OE_Order_WF', 'Book_Order',
135: itemtype, itemkey, to_char(actid), funcmode);
136: -- start data fix project
137: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
138: p_itemtype => itemtype,
139: p_itemkey => itemkey);
140: OE_STANDARD_WF.Save_Messages;
141: OE_STANDARD_WF.Clear_Msg_Context;
136: -- start data fix project
137: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
138: p_itemtype => itemtype,
139: p_itemkey => itemkey);
140: OE_STANDARD_WF.Save_Messages;
141: OE_STANDARD_WF.Clear_Msg_Context;
142: -- end data fix project
143: raise;
144: END Book_Order;
137: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
138: p_itemtype => itemtype,
139: p_itemkey => itemkey);
140: OE_STANDARD_WF.Save_Messages;
141: OE_STANDARD_WF.Clear_Msg_Context;
142: -- end data fix project
143: raise;
144: END Book_Order;
145: