DBA Data[Home] [Help]

APPS.OE_INVOICE_WF dependencies on OE_GLOBALS

Line 58: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN

54: IF (funcmode = 'RUN') THEN
55:
56: OE_STANDARD_WF.Set_Msg_Context(actid);
57:
58: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN
59: l_line_id := to_number(itemkey);
60: ELSIF itemtype = OE_GLOBALS.G_WFI_HDR THEN
61: l_header_id := to_number(itemkey);
62: END IF;

Line 60: ELSIF itemtype = OE_GLOBALS.G_WFI_HDR THEN

56: OE_STANDARD_WF.Set_Msg_Context(actid);
57:
58: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN
59: l_line_id := to_number(itemkey);
60: ELSIF itemtype = OE_GLOBALS.G_WFI_HDR THEN
61: l_header_id := to_number(itemkey);
62: END IF;
63:
64: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN

Line 64: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN

60: ELSIF itemtype = OE_GLOBALS.G_WFI_HDR THEN
61: l_header_id := to_number(itemkey);
62: END IF;
63:
64: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN
65:
66: -- Added below code for bug 6704643
67: select t1.order_number
68: into l_order_number

Line 100: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;

96:
97: END IF;
98:
99: IF( l_count <> 0) THEN
100: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add( 'Line is Invoiced, NOT invoicing any more ' ) ;
103: END IF;
104: OE_STANDARD_WF.Clear_Msg_Context;

Line 112: ELSIF itemtype = OE_GLOBALS.G_WFI_HDR THEN

108: OE_Invoice_PUB.Interface_Line( l_line_id
109: , itemtype
110: , l_result_out
111: , l_return_status);
112: ELSIF itemtype = OE_GLOBALS.G_WFI_HDR THEN
113:
114: -- Added below code for bug 6704643
115: select t1.order_number
116: into l_order_number

Line 146: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;

142: and sales_order_line IS NOT NULL; -- Added for bug 6704643 ;
143: END IF;
144:
145: IF( l_count <> 0) THEN
146: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;
147: IF l_debug_level > 0 THEN
148: oe_debug_pub.add( 'Lines in Header Invoiced, NOT invoicing any more ' ) ;
149: END IF;
150: OE_STANDARD_WF.Clear_Msg_Context;

Line 164: IF l_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN

160: oe_debug_pub.add( 'INFO-L_RETURN_STATUS: '||L_RETURN_STATUS ) ;
161: oe_debug_pub.add( 'INFO-L_RESULT_OUT: '||L_RESULT_OUT ) ;
162: END IF;
163: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
164: IF l_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
165: resultout := OE_GLOBALS.G_WFR_COMPLETE ||':' || OE_GLOBALS.G_WFR_NOT_ELIGIBLE ;
166: OE_STANDARD_WF.Clear_Msg_Context;
167: RETURN;
168: ELSIF l_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

Line 165: resultout := OE_GLOBALS.G_WFR_COMPLETE ||':' || OE_GLOBALS.G_WFR_NOT_ELIGIBLE ;

161: oe_debug_pub.add( 'INFO-L_RESULT_OUT: '||L_RESULT_OUT ) ;
162: END IF;
163: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
164: IF l_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
165: resultout := OE_GLOBALS.G_WFR_COMPLETE ||':' || OE_GLOBALS.G_WFR_NOT_ELIGIBLE ;
166: OE_STANDARD_WF.Clear_Msg_Context;
167: RETURN;
168: ELSIF l_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
169: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;

Line 168: ELSIF l_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

164: IF l_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
165: resultout := OE_GLOBALS.G_WFR_COMPLETE ||':' || OE_GLOBALS.G_WFR_NOT_ELIGIBLE ;
166: OE_STANDARD_WF.Clear_Msg_Context;
167: RETURN;
168: ELSIF l_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
169: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;
170: OE_STANDARD_WF.Clear_Msg_Context;
171: RETURN;
172: ELSIF l_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

Line 169: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;

165: resultout := OE_GLOBALS.G_WFR_COMPLETE ||':' || OE_GLOBALS.G_WFR_NOT_ELIGIBLE ;
166: OE_STANDARD_WF.Clear_Msg_Context;
167: RETURN;
168: ELSIF l_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
169: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;
170: OE_STANDARD_WF.Clear_Msg_Context;
171: RETURN;
172: ELSIF l_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
173: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PRTL_COMPLETE;

Line 172: ELSIF l_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

168: ELSIF l_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
169: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;
170: OE_STANDARD_WF.Clear_Msg_Context;
171: RETURN;
172: ELSIF l_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
173: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PRTL_COMPLETE;
174: OE_STANDARD_WF.Clear_Msg_Context;
175: RETURN;
176: ELSIF l_result_out = OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE THEN

Line 173: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PRTL_COMPLETE;

169: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_COMPLETE ;
170: OE_STANDARD_WF.Clear_Msg_Context;
171: RETURN;
172: ELSIF l_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
173: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PRTL_COMPLETE;
174: OE_STANDARD_WF.Clear_Msg_Context;
175: RETURN;
176: ELSIF l_result_out = OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE THEN
177: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE;

Line 176: ELSIF l_result_out = OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE THEN

172: ELSIF l_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
173: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PRTL_COMPLETE;
174: OE_STANDARD_WF.Clear_Msg_Context;
175: RETURN;
176: ELSIF l_result_out = OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE THEN
177: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE;
178: OE_STANDARD_WF.Clear_Msg_Context;
179: RETURN;
180: --sol_ord_er #16014165

Line 177: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE;

173: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PRTL_COMPLETE;
174: OE_STANDARD_WF.Clear_Msg_Context;
175: RETURN;
176: ELSIF l_result_out = OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE THEN
177: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE;
178: OE_STANDARD_WF.Clear_Msg_Context;
179: RETURN;
180: --sol_ord_er #16014165
181: ELSIF l_result_out = OE_GLOBALS.G_CONTRACTS_BILLED THEN

Line 181: ELSIF l_result_out = OE_GLOBALS.G_CONTRACTS_BILLED THEN

177: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE;
178: OE_STANDARD_WF.Clear_Msg_Context;
179: RETURN;
180: --sol_ord_er #16014165
181: ELSIF l_result_out = OE_GLOBALS.G_CONTRACTS_BILLED THEN
182: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_CONTRACTS_BILLED;
183: OE_STANDARD_WF.Clear_Msg_Context;
184: RETURN;
185: --sol_ord_er #16014165 end

Line 182: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_CONTRACTS_BILLED;

178: OE_STANDARD_WF.Clear_Msg_Context;
179: RETURN;
180: --sol_ord_er #16014165
181: ELSIF l_result_out = OE_GLOBALS.G_CONTRACTS_BILLED THEN
182: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_CONTRACTS_BILLED;
183: OE_STANDARD_WF.Clear_Msg_Context;
184: RETURN;
185: --sol_ord_er #16014165 end
186: END IF;

Line 227: --resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_INCOMPLETE;

223: -- end data fix project
224: IF l_debug_level > 0 THEN
225: oe_debug_pub.add('OEXWINVB.pls - in unexpected error raise exception');
226: END IF;
227: --resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_INCOMPLETE;
228: --return;
229: app_exception.raise_exception;
230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: -- For HOLDs and Validation errors

Line 232: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN

228: --return;
229: app_exception.raise_exception;
230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: -- For HOLDs and Validation errors
232: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
233: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_ON_HOLD;
234: OE_STANDARD_WF.Save_Messages(p_instance_id => actid);
235: OE_STANDARD_WF.Clear_Msg_Context;
236: RETURN;

Line 233: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_ON_HOLD;

229: app_exception.raise_exception;
230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: -- For HOLDs and Validation errors
232: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
233: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_ON_HOLD;
234: OE_STANDARD_WF.Save_Messages(p_instance_id => actid);
235: OE_STANDARD_WF.Clear_Msg_Context;
236: RETURN;
237: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

Line 237: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

233: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_ON_HOLD;
234: OE_STANDARD_WF.Save_Messages(p_instance_id => actid);
235: OE_STANDARD_WF.Clear_Msg_Context;
236: RETURN;
237: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
238: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_INCOMPLETE;
239: OE_STANDARD_WF.Save_Messages(p_instance_id => actid);
240: OE_STANDARD_WF.Clear_Msg_Context;
241: RETURN;

Line 238: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_INCOMPLETE;

234: OE_STANDARD_WF.Save_Messages(p_instance_id => actid);
235: OE_STANDARD_WF.Clear_Msg_Context;
236: RETURN;
237: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
238: resultout := OE_GLOBALS.G_WFR_COMPLETE || ':' || OE_GLOBALS.G_WFR_INCOMPLETE;
239: OE_STANDARD_WF.Save_Messages(p_instance_id => actid);
240: OE_STANDARD_WF.Clear_Msg_Context;
241: RETURN;
242: END IF;