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_SHIPPING_INTEGRATION_PUB dependencies on FND_API

Line 15: This function returns FND_API.G_TRUE, if the line's next eligible WF

11: -- Version Current version = 1.0
12: -- Initial version = 1.0
13:
14: /*
15: This function returns FND_API.G_TRUE, if the line's next eligible WF
16: activity is "SHIP_LINE", otherwise returns FND_API.G_FALSE
17: */
18:
19: FUNCTION Is_Activity_Shipping

Line 16: activity is "SHIP_LINE", otherwise returns FND_API.G_FALSE

12: -- Initial version = 1.0
13:
14: /*
15: This function returns FND_API.G_TRUE, if the line's next eligible WF
16: activity is "SHIP_LINE", otherwise returns FND_API.G_FALSE
17: */
18:
19: FUNCTION Is_Activity_Shipping
20: (

Line 35: IF NOT FND_API.Compatible_API_Call

31: BEGIN
32:
33: -- Standard call to check for call compatibility
34:
35: IF NOT FND_API.Compatible_API_Call
36: ( l_api_version_number
37: , p_api_version_number
38: , l_api_name
39: , G_PKG_NAME

Line 42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

38: , l_api_name
39: , G_PKG_NAME
40: )
41: THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45:
46: select count(*)

Line 57: return FND_API.G_TRUE;

53: and wias.process_activity = wpa.instance_id
54: and wpa.activity_name = 'SHIP_LINE';
55:
56: IF l_count > 0 THEN
57: return FND_API.G_TRUE;
58: ELSE
59: return FND_API.G_FALSE;
60: END IF;
61:

Line 59: return FND_API.G_FALSE;

55:
56: IF l_count > 0 THEN
57: return FND_API.G_TRUE;
58: ELSE
59: return FND_API.G_FALSE;
60: END IF;
61:
62: EXCEPTION
63:

Line 64: WHEN FND_API.G_EXC_ERROR THEN

60: END IF;
61:
62: EXCEPTION
63:
64: WHEN FND_API.G_EXC_ERROR THEN
65:
66: return FND_API.G_RET_STS_ERROR;
67:
68: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 66: return FND_API.G_RET_STS_ERROR;

62: EXCEPTION
63:
64: WHEN FND_API.G_EXC_ERROR THEN
65:
66: return FND_API.G_RET_STS_ERROR;
67:
68: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
69:
70: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 68: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

64: WHEN FND_API.G_EXC_ERROR THEN
65:
66: return FND_API.G_RET_STS_ERROR;
67:
68: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
69:
70: return FND_API.G_RET_STS_UNEXP_ERROR ;
71:
72: WHEN OTHERS THEN

Line 70: return FND_API.G_RET_STS_UNEXP_ERROR ;

66: return FND_API.G_RET_STS_ERROR;
67:
68: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
69:
70: return FND_API.G_RET_STS_UNEXP_ERROR ;
71:
72: WHEN OTHERS THEN
73:
74: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 74: return FND_API.G_RET_STS_UNEXP_ERROR ;

70: return FND_API.G_RET_STS_UNEXP_ERROR ;
71:
72: WHEN OTHERS THEN
73:
74: return FND_API.G_RET_STS_UNEXP_ERROR ;
75:
76: END Is_Activity_Shipping;
77:
78: /*

Line 107: IF NOT FND_API.Compatible_API_Call

103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) ||' '||P_RESULT_CODE , 1 ) ;
105: END IF;
106:
107: IF NOT FND_API.Compatible_API_Call
108: ( l_api_version_number
109: , p_api_version_number
110: , l_api_name
111: , G_PKG_NAME

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: , l_api_name
111: , G_PKG_NAME
112: )
113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: IF OE_Validate.Line(p_line_id)
118: THEN

Line 134: x_return_status := FND_API.G_RET_STS_SUCCESS;

130: oe_debug_pub.add( 'RETURNED FROM WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;
131: END IF;
132: END IF;
133:
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
138: END IF;

Line 141: WHEN FND_API.G_EXC_ERROR THEN

137: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
138: END IF;
139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN
142:
143: x_return_status := FND_API.G_RET_STS_ERROR;
144:
145: -- Get message count and data

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN
142:
143: x_return_status := FND_API.G_RET_STS_ERROR;
144:
145: -- Get message count and data
146:
147: FND_MSG_PUB.Count_And_Get

Line 152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

148: ( p_count => x_msg_count
149: , p_data => x_msg_data
150: );
151:
152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
153:
154: IF l_debug_level > 0 THEN
155: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
156: END IF;

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

153:
154: IF l_debug_level > 0 THEN
155: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
156: END IF;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158:
159: -- Get message count and data
160:
161: FND_MSG_PUB.Count_And_Get

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

173: IF l_errname IS NOT NULL THEN
174: IF l_debug_level > 0 THEN
175: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
176: END IF;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
178: ELSE
179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

189: FND_MSG_PUB.Count_And_Get
190: ( p_count => x_msg_count
191: , p_data => x_msg_data
192: );
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: END IF;
195:
196: END Complete_Ship_Line_Activity;
197:

Line 199: /* Returns FND_API_G_TRUE if credit check passes,

195:
196: END Complete_Ship_Line_Activity;
197:
198:
199: /* Returns FND_API_G_TRUE if credit check passes,
200: FND_API.G_FALSE if credit check fails */
201: /** This function is not used ******/
202: FUNCTION Credit_Check
203: (

Line 200: FND_API.G_FALSE if credit check fails */

196: END Complete_Ship_Line_Activity;
197:
198:
199: /* Returns FND_API_G_TRUE if credit check passes,
200: FND_API.G_FALSE if credit check fails */
201: /** This function is not used ******/
202: FUNCTION Credit_Check
203: (
204: p_api_version_number IN NUMBER

Line 222: IF NOT FND_API.Compatible_API_Call

218: BEGIN
219:
220: -- Standard call to check for call compatibility
221:
222: IF NOT FND_API.Compatible_API_Call
223: ( l_api_version_number
224: , p_api_version_number
225: , l_api_name
226: , G_PKG_NAME

Line 229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

225: , l_api_name
226: , G_PKG_NAME
227: )
228: THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231: /*
232: OE_Credit_PUB.Check_Available_Credit
233: (

Line 240: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

236: p_msg_data => l_x_msg_data,
237: p_result_out => l_x_result_out,
238: p_return_status => l_x_return_status
239: );
240: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: p_result_out => l_x_result_out,
238: p_return_status => l_x_return_status
239: );
240: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: */

Line 242: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

238: p_return_status => l_x_return_status
239: );
240: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: */
246: IF UPPER(l_x_result_out) = 'PASS' THEN

Line 243: RAISE FND_API.G_EXC_ERROR;

239: );
240: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: */
246: IF UPPER(l_x_result_out) = 'PASS' THEN
247: return FND_API.G_TRUE;

Line 247: return FND_API.G_TRUE;

243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: */
246: IF UPPER(l_x_result_out) = 'PASS' THEN
247: return FND_API.G_TRUE;
248: ELSE
249: return FND_API.G_FALSE;
250: END IF;
251:

Line 249: return FND_API.G_FALSE;

245: */
246: IF UPPER(l_x_result_out) = 'PASS' THEN
247: return FND_API.G_TRUE;
248: ELSE
249: return FND_API.G_FALSE;
250: END IF;
251:
252: EXCEPTION
253:

Line 254: WHEN FND_API.G_EXC_ERROR THEN

250: END IF;
251:
252: EXCEPTION
253:
254: WHEN FND_API.G_EXC_ERROR THEN
255:
256: return FND_API.G_RET_STS_ERROR;
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 256: return FND_API.G_RET_STS_ERROR;

252: EXCEPTION
253:
254: WHEN FND_API.G_EXC_ERROR THEN
255:
256: return FND_API.G_RET_STS_ERROR;
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259:
260: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

254: WHEN FND_API.G_EXC_ERROR THEN
255:
256: return FND_API.G_RET_STS_ERROR;
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259:
260: return FND_API.G_RET_STS_UNEXP_ERROR ;
261:
262: WHEN OTHERS THEN

Line 260: return FND_API.G_RET_STS_UNEXP_ERROR ;

256: return FND_API.G_RET_STS_ERROR;
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259:
260: return FND_API.G_RET_STS_UNEXP_ERROR ;
261:
262: WHEN OTHERS THEN
263:
264: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 264: return FND_API.G_RET_STS_UNEXP_ERROR ;

260: return FND_API.G_RET_STS_UNEXP_ERROR ;
261:
262: WHEN OTHERS THEN
263:
264: return FND_API.G_RET_STS_UNEXP_ERROR ;
265:
266: END Credit_Check;
267:
268: /*

Line 269: If this funtion returns FND_API.G_TRUE, a hold exists on this line.

265:
266: END Credit_Check;
267:
268: /*
269: If this funtion returns FND_API.G_TRUE, a hold exists on this line.
270: If this funtion returns FND_API.G_FALSE, a hold does not exists
271: on this line.
272: */
273:

Line 270: If this funtion returns FND_API.G_FALSE, a hold does not exists

266: END Credit_Check;
267:
268: /*
269: If this funtion returns FND_API.G_TRUE, a hold exists on this line.
270: If this funtion returns FND_API.G_FALSE, a hold does not exists
271: on this line.
272: */
273:
274: FUNCTION Check_Holds_For_SC

Line 295: IF NOT FND_API.Compatible_API_Call

291: BEGIN
292:
293: -- Standard call to check for call compatibility
294:
295: IF NOT FND_API.Compatible_API_Call
296: ( l_api_version_number
297: , p_api_version_number
298: , l_api_name
299: , G_PKG_NAME

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

298: , l_api_name
299: , G_PKG_NAME
300: )
301: THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304:
305: OE_Holds_PUB.Check_Holds
306: (

Line 314: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

310: x_return_status => l_x_return_status,
311: x_msg_count => l_x_msg_count,
312: x_msg_data => l_x_msg_data
313: );
314: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311: x_msg_count => l_x_msg_count,
312: x_msg_data => l_x_msg_data
313: );
314: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: return l_x_result_out;

Line 316: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

312: x_msg_data => l_x_msg_data
313: );
314: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: return l_x_result_out;
320:

Line 317: RAISE FND_API.G_EXC_ERROR;

313: );
314: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: return l_x_result_out;
320:
321: EXCEPTION

Line 323: WHEN FND_API.G_EXC_ERROR THEN

319: return l_x_result_out;
320:
321: EXCEPTION
322:
323: WHEN FND_API.G_EXC_ERROR THEN
324:
325: return FND_API.G_RET_STS_ERROR;
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 325: return FND_API.G_RET_STS_ERROR;

321: EXCEPTION
322:
323: WHEN FND_API.G_EXC_ERROR THEN
324:
325: return FND_API.G_RET_STS_ERROR;
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328:
329: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

323: WHEN FND_API.G_EXC_ERROR THEN
324:
325: return FND_API.G_RET_STS_ERROR;
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328:
329: return FND_API.G_RET_STS_UNEXP_ERROR ;
330:
331: WHEN OTHERS THEN

Line 329: return FND_API.G_RET_STS_UNEXP_ERROR ;

325: return FND_API.G_RET_STS_ERROR;
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328:
329: return FND_API.G_RET_STS_UNEXP_ERROR ;
330:
331: WHEN OTHERS THEN
332:
333: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 333: return FND_API.G_RET_STS_UNEXP_ERROR ;

329: return FND_API.G_RET_STS_UNEXP_ERROR ;
330:
331: WHEN OTHERS THEN
332:
333: return FND_API.G_RET_STS_UNEXP_ERROR ;
334:
335: END Check_Holds_For_SC;
336:
337:

Line 365: l_model_kit_line VARCHAR2(1) := FND_API.G_FALSE;

361: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
362: l_tbl_index NUMBER;
363: l_line_index NUMBER;
364: l_cal_tolerance_tbl Cal_Tolerance_Tbl_Type;
365: l_model_kit_line VARCHAR2(1) := FND_API.G_FALSE;
366: l_x_result_out VARCHAR2(30);
367: l_shipped_quantity NUMBER := 0;
368: l_ordered_quantity NUMBER := 0;
369: l_x_shipped_quantity NUMBER := 0;

Line 379: l_planned_quantity_passed VARCHAR2(1) := FND_API.G_FALSE;

375: l_x_return_status VARCHAR2(1);
376: l_top_model_line_id NUMBER;
377: -- l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
378: l_ratio_status VARCHAR2(1);
379: l_planned_quantity_passed VARCHAR2(1) := FND_API.G_FALSE;
380: l_top_model_index NUMBER := 0;
381:
382: l_count_unshipped NUMBER := 0;
383: l_del_shipping_quantity NUMBER := 0;

Line 395: x_update_tolerance_flag := FND_API.G_FALSE;

391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
393: END IF;
394: -- Standard call to check for call compatibility
395: x_update_tolerance_flag := FND_API.G_FALSE;
396: x_ship_beyond_tolerance := FND_API.G_FALSE;
397: x_shipped_within_tolerance := FND_API.G_FALSE;
398: x_config_broken := FND_API.G_FALSE;
399:

Line 396: x_ship_beyond_tolerance := FND_API.G_FALSE;

392: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
393: END IF;
394: -- Standard call to check for call compatibility
395: x_update_tolerance_flag := FND_API.G_FALSE;
396: x_ship_beyond_tolerance := FND_API.G_FALSE;
397: x_shipped_within_tolerance := FND_API.G_FALSE;
398: x_config_broken := FND_API.G_FALSE;
399:
400: IF NOT FND_API.Compatible_API_Call

Line 397: x_shipped_within_tolerance := FND_API.G_FALSE;

393: END IF;
394: -- Standard call to check for call compatibility
395: x_update_tolerance_flag := FND_API.G_FALSE;
396: x_ship_beyond_tolerance := FND_API.G_FALSE;
397: x_shipped_within_tolerance := FND_API.G_FALSE;
398: x_config_broken := FND_API.G_FALSE;
399:
400: IF NOT FND_API.Compatible_API_Call
401: ( l_api_version_number

Line 398: x_config_broken := FND_API.G_FALSE;

394: -- Standard call to check for call compatibility
395: x_update_tolerance_flag := FND_API.G_FALSE;
396: x_ship_beyond_tolerance := FND_API.G_FALSE;
397: x_shipped_within_tolerance := FND_API.G_FALSE;
398: x_config_broken := FND_API.G_FALSE;
399:
400: IF NOT FND_API.Compatible_API_Call
401: ( l_api_version_number
402: , p_api_version_number

Line 400: IF NOT FND_API.Compatible_API_Call

396: x_ship_beyond_tolerance := FND_API.G_FALSE;
397: x_shipped_within_tolerance := FND_API.G_FALSE;
398: x_config_broken := FND_API.G_FALSE;
399:
400: IF NOT FND_API.Compatible_API_Call
401: ( l_api_version_number
402: , p_api_version_number
403: , l_api_name
404: , G_PKG_NAME

Line 407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

403: , l_api_name
404: , G_PKG_NAME
405: )
406: THEN
407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408: END IF;
409:
410: -- Convert the passed table
411:

Line 425: IF p_cal_tolerance_tbl(l_tbl_index).planned_quantity = FND_API.G_MISS_NUM THEN

421: l_cal_tolerance_tbl(l_line_id_mod).line_id := p_cal_tolerance_tbl(l_tbl_index).line_id;
422: l_cal_tolerance_tbl(l_line_id_mod).quantity_to_be_shipped := p_cal_tolerance_tbl(l_tbl_index).quantity_to_be_shipped;
423:
424: /* to fix the bug 2127323 */
425: IF p_cal_tolerance_tbl(l_tbl_index).planned_quantity = FND_API.G_MISS_NUM THEN
426: IF l_debug_level > 0 THEN
427: oe_debug_pub.add( 'PLANNED QUANTITY IS MISSING SETTING IT TO ZERO ' , 3 ) ;
428: END IF;
429:

Line 438: p_cal_tolerance_tbl(l_tbl_index).planned_quantity <> FND_API.G_MISS_NUM THEN

434:
435: -- l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).shipping_uom := p_cal_tolerance_tbl(l_tbl_index).shipping_uom; -- Bug 8795918
436: l_cal_tolerance_tbl(l_line_id_mod).shipping_uom := p_cal_tolerance_tbl(l_tbl_index).shipping_uom;
437: IF nvl(p_cal_tolerance_tbl(l_tbl_index).planned_quantity,0) <> 0 AND
438: p_cal_tolerance_tbl(l_tbl_index).planned_quantity <> FND_API.G_MISS_NUM THEN
439: l_planned_quantity_passed := FND_API.G_TRUE;
440: END IF;
441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;

Line 439: l_planned_quantity_passed := FND_API.G_TRUE;

435: -- l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).shipping_uom := p_cal_tolerance_tbl(l_tbl_index).shipping_uom; -- Bug 8795918
436: l_cal_tolerance_tbl(l_line_id_mod).shipping_uom := p_cal_tolerance_tbl(l_tbl_index).shipping_uom;
437: IF nvl(p_cal_tolerance_tbl(l_tbl_index).planned_quantity,0) <> 0 AND
438: p_cal_tolerance_tbl(l_tbl_index).planned_quantity <> FND_API.G_MISS_NUM THEN
439: l_planned_quantity_passed := FND_API.G_TRUE;
440: END IF;
441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;
443: END IF;

Line 466: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN

462: -- l_line_rec := OE_Line_Util.Query_Row(p_cal_tolerance_tbl(l_tbl_index).line_id);
463: OE_Line_Util.Query_Row(p_line_id => p_cal_tolerance_tbl(l_tbl_index).line_id,
464: x_line_rec => l_line_rec);
465: IF l_line_rec.top_model_line_id IS NOT NULL AND
466: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
467:
468: l_model_kit_line := FND_API.G_TRUE;
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;

Line 468: l_model_kit_line := FND_API.G_TRUE;

464: x_line_rec => l_line_rec);
465: IF l_line_rec.top_model_line_id IS NOT NULL AND
466: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
467:
468: l_model_kit_line := FND_API.G_TRUE;
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
471: END IF;
472: l_top_model_line_id := l_line_rec.top_model_line_id;

Line 478: IF l_model_kit_line = FND_API.G_TRUE THEN

474: END IF;
475: NULL;
476: END LOOP;
477:
478: IF l_model_kit_line = FND_API.G_TRUE THEN
479:
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
482: END IF;

Line 572: IF l_ratio_status = FND_API.G_TRUE THEN

568: IF l_debug_level > 0 THEN
569: oe_debug_pub.add( 'RATIO STATUS/RETURN STATUS : '||L_RATIO_STATUS||L_X_RETURN_STATUS , 3 ) ;
570: END IF;
571:
572: IF l_ratio_status = FND_API.G_TRUE THEN
573:
574: l_shipped_quantity := l_temp_line_tbl(l_top_model_index).shipped_quantity;
575: l_line_rec := l_temp_line_tbl(l_top_model_index);
576:

Line 588: l_planned_quantity_passed = FND_API.G_TRUE THEN

584: x_result_out => l_x_result_out
585: );
586:
587: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
588: l_planned_quantity_passed = FND_API.G_TRUE THEN
589:
590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 2 ) ;
592: END IF;

Line 648: IF l_ratio_status = FND_API.G_TRUE THEN

644: p_x_line_tbl => l_temp_line_tbl
645: , x_ratio_status => l_ratio_status
646: , x_return_status => l_x_return_status
647: );
648: IF l_ratio_status = FND_API.G_TRUE THEN
649:
650: l_shipped_quantity := l_temp_line_tbl(l_top_model_index).shipped_quantity;
651: l_ordered_quantity := l_temp_line_tbl(l_top_model_index).ordered_quantity;
652: l_line_rec := l_temp_line_tbl(l_top_model_index);

Line 665: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN

661: -- Get the total ordered and shipped quantities if it is a part of
662: -- a line set.
663:
664: IF l_line_rec.line_set_id IS NOT NULL AND
665: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN
666:
667: OE_Shipping_Integration_PUB.Get_Quantity
668: (
669: p_api_version_number => 1.0,

Line 706: x_update_tolerance_flag := FND_API.G_TRUE;

702: END IF;
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
705: END IF;
706: x_update_tolerance_flag := FND_API.G_TRUE;
707: x_ship_tolerance := l_ship_tolerance;
708: ELSE
709: x_config_broken := FND_API.G_TRUE;
710: END IF;

Line 709: x_config_broken := FND_API.G_TRUE;

705: END IF;
706: x_update_tolerance_flag := FND_API.G_TRUE;
707: x_ship_tolerance := l_ship_tolerance;
708: ELSE
709: x_config_broken := FND_API.G_TRUE;
710: END IF;
711:
712: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
713: IF l_debug_level > 0 THEN

Line 716: x_ship_beyond_tolerance := FND_API.G_TRUE;

712: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
715: END IF;
716: x_ship_beyond_tolerance := FND_API.G_TRUE;
717: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
718: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;

Line 722: x_shipped_within_tolerance := FND_API.G_TRUE;

718: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
721: END IF;
722: x_shipped_within_tolerance := FND_API.G_TRUE;
723: END IF;
724:
725: ELSE
726: x_config_broken := FND_API.G_TRUE;

Line 726: x_config_broken := FND_API.G_TRUE;

722: x_shipped_within_tolerance := FND_API.G_TRUE;
723: END IF;
724:
725: ELSE
726: x_config_broken := FND_API.G_TRUE;
727: END IF;
728:
729: ELSE
730: IF l_debug_level > 0 THEN

Line 812: l_planned_quantity_passed = FND_API.G_TRUE THEN

808: x_result_out => l_x_result_out
809: );
810:
811: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
812: l_planned_quantity_passed = FND_API.G_TRUE THEN
813:
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 3 ) ;
816: END IF;

Line 853: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN

849: -- Get the total ordered and shipped quantities if it is a part of
850: -- a line set.
851:
852: IF l_line_rec.line_set_id IS NOT NULL AND
853: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN
854:
855: OE_Shipping_Integration_PUB.Get_Quantity
856: (
857: p_api_version_number => 1.0,

Line 894: x_update_tolerance_flag := FND_API.G_TRUE;

890: END IF;
891: IF l_debug_level > 0 THEN
892: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
893: END IF;
894: x_update_tolerance_flag := FND_API.G_TRUE;
895: x_ship_tolerance := l_ship_tolerance;
896:
897: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
898: x_ship_beyond_tolerance := FND_API.G_TRUE;

Line 898: x_ship_beyond_tolerance := FND_API.G_TRUE;

894: x_update_tolerance_flag := FND_API.G_TRUE;
895: x_ship_tolerance := l_ship_tolerance;
896:
897: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
898: x_ship_beyond_tolerance := FND_API.G_TRUE;
899: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
900: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
902: IF l_debug_level > 0 THEN

Line 905: x_shipped_within_tolerance := FND_API.G_TRUE;

901: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
902: IF l_debug_level > 0 THEN
903: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
904: END IF;
905: x_shipped_within_tolerance := FND_API.G_TRUE;
906: END IF;
907:
908: END IF;
909:

Line 911: x_return_status := FND_API.G_RET_STS_SUCCESS;

907:
908: END IF;
909:
910:
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912: IF l_debug_level > 0 THEN
913: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
914: END IF;
915:

Line 921: x_return_status := FND_API.G_RET_STS_ERROR;

917:
918: WHEN NO_DATA_FOUND THEN
919:
920:
921: x_return_status := FND_API.G_RET_STS_ERROR;
922:
923: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
924: THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;

Line 925: x_return_status := FND_API.G_RET_STS_ERROR;

921: x_return_status := FND_API.G_RET_STS_ERROR;
922:
923: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
924: THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: END IF;
927:
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929:

Line 928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

924: THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: END IF;
927:
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929:
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
932: END IF;

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

929:
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
932: END IF;
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934:
935: -- Get message count and data
936:
937: FND_MSG_PUB.Count_And_Get

Line 947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

943:
944: IF l_debug_level > 0 THEN
945: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
946: END IF;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: FND_MSG_PUB.Add_Exc_Msg

Line 1002: IF NOT FND_API.Compatible_API_Call

998: IF l_debug_level > 0 THEN
999: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY '||TO_CHAR ( P_LINE_ID ) ||'/'||TO_CHAR ( P_LINE_SET_ID ) , 1 ) ;
1000: END IF;
1001:
1002: IF NOT FND_API.Compatible_API_Call
1003: ( l_api_version_number
1004: , p_api_version_number
1005: , l_api_name
1006: , G_PKG_NAME

Line 1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1005: , l_api_name
1006: , G_PKG_NAME
1007: )
1008: THEN
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: END IF;
1011:
1012: SELECT SUM(ordered_quantity)
1013: , SUM(shipped_quantity)

Line 1024: x_return_status := FND_API.G_RET_STS_SUCCESS;

1020:
1021: x_ordered_quantity := l_x_ordered_quantity;
1022: x_shipped_quantity := l_x_shipped_quantity;
1023: x_shipping_quantity := l_x_shipping_quantity;
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: IF l_debug_level > 0 THEN
1027: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY ' , 1 ) ;
1028: END IF;

Line 1039: x_return_status := FND_API.G_RET_STS_ERROR;

1035: x_shipping_quantity := 0;
1036:
1037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1038: THEN
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040: END IF;
1041:
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043:

Line 1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1038: THEN
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040: END IF;
1041:
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043:
1044: IF l_debug_level > 0 THEN
1045: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1046: END IF;

Line 1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1043:
1044: IF l_debug_level > 0 THEN
1045: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1046: END IF;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048:
1049: -- Get message count and data
1050:
1051: FND_MSG_PUB.Count_And_Get

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1057:
1058: IF l_debug_level > 0 THEN
1059: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1060: END IF;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062:
1063: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1064: THEN
1065: FND_MSG_PUB.Add_Exc_Msg

Line 1113: p_line_id = FND_API.G_MISS_NUM THEN

1109: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1110: END IF;
1111:
1112: IF p_line_id IS NULL OR
1113: p_line_id = FND_API.G_MISS_NUM THEN
1114:
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add( 'LINE ID IS NULL ' , 1 ) ;
1117: END IF;

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117: END IF;
1118:
1119: FND_MESSAGE.SET_NAME('ONT','OE_SHP_LINE_ID_MISSING');
1120: OE_MSG_PUB.ADD;
1121: RAISE FND_API.G_EXC_ERROR;
1122:
1123: END IF;
1124:
1125: IF p_shipping_interfaced_flag IS NOT NULL AND

Line 1137: RAISE FND_API.G_EXC_ERROR;

1133: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1134: OE_Order_Util.Get_Attribute_Name('shipping_interfaced_flag'));
1135: OE_MSG_PUB.Add;
1136:
1137: RAISE FND_API.G_EXC_ERROR;
1138:
1139: END IF;
1140:
1141: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'

Line 1173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1169: ,x_line_tbl => l_old_line_tbl
1170: ,x_return_status => x_return_status
1171: );
1172:
1173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: ,x_return_status => x_return_status
1171: );
1172:
1173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:

Line 1175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1171: );
1172:
1173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: l_line_tbl := l_old_line_tbl;

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172:
1173: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: l_line_tbl := l_old_line_tbl;
1180: l_line_tbl(1).shipping_interfaced_flag := p_shipping_interfaced_flag;

Line 1244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1242: END IF;
1243:
1244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1242: END IF;
1243:
1244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:

Line 1246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1242: END IF;
1243:
1244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: IF l_index IS NOT NULL THEN

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1243:
1244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: IF l_index IS NOT NULL THEN
1251: -- update the global picture directly

Line 1289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1285: , p_line_tbl => l_line_tbl
1286: , p_old_line_tbl => l_old_line_tbl
1287: );
1288:
1289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;

Line 1290: RAISE FND_API.G_EXC_ERROR;

1286: , p_old_line_tbl => l_old_line_tbl
1287: );
1288:
1289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:

Line 1291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1287: );
1288:
1289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:
1295: END IF; /* pack H */

Line 1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1288:
1289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:
1295: END IF; /* pack H */
1296:

Line 1342: x_return_status := FND_API.G_RET_STS_SUCCESS;

1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1340: END IF;
1341:
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:
1344: EXCEPTION
1345:
1346: WHEN FND_API.G_EXC_ERROR THEN

Line 1346: WHEN FND_API.G_EXC_ERROR THEN

1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:
1344: EXCEPTION
1345:
1346: WHEN FND_API.G_EXC_ERROR THEN
1347:
1348: ROLLBACK TO Update_Shipping_Interface;
1349:
1350: OE_MSG_PUB.Count_And_Get

Line 1355: x_return_status := FND_API.G_RET_STS_ERROR;

1351: ( p_count => x_msg_count
1352: , p_data => x_msg_data
1353: );
1354:
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356:
1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1358:
1359: ROLLBACK TO Update_Shipping_Interface;

Line 1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1353: );
1354:
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356:
1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1358:
1359: ROLLBACK TO Update_Shipping_Interface;
1360:
1361: -- Get message count and data

Line 1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1367:
1368: IF l_debug_level > 0 THEN
1369: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1370: END IF;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1372:
1373: WHEN OTHERS THEN
1374:
1375: ROLLBACK TO Update_Shipping_Interface;

Line 1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1391:
1392: IF l_debug_level > 0 THEN
1393: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1394: END IF;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396:
1397: END Update_Shipping_Interface;
1398:
1399: -- HW added qty2 for OPM in the procedure parameters

Line 1448: x_return_status := FND_API.G_RET_STS_SUCCESS;

1444: IF l_debug_level > 0 THEN
1445: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;
1446: END IF;
1447:
1448: x_return_status := FND_API.G_RET_STS_SUCCESS;
1449: /*
1450: IF NOT FND_API.Compatible_API_Call
1451: ( l_api_version_number
1452: , p_api_version_number

Line 1450: IF NOT FND_API.Compatible_API_Call

1446: END IF;
1447:
1448: x_return_status := FND_API.G_RET_STS_SUCCESS;
1449: /*
1450: IF NOT FND_API.Compatible_API_Call
1451: ( l_api_version_number
1452: , p_api_version_number
1453: , l_api_name
1454: , G_PKG_NAME

Line 1457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1453: , l_api_name
1454: , G_PKG_NAME
1455: )
1456: THEN
1457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1458: END IF;
1459: */
1460:
1461:

Line 1505: x_return_status := FND_API.G_RET_STS_ERROR;

1501: x_max_remaining_quantity2 := 0;
1502:
1503: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1504: THEN
1505: x_return_status := FND_API.G_RET_STS_ERROR;
1506: END IF;
1507:
1508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1509:

Line 1508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1504: THEN
1505: x_return_status := FND_API.G_RET_STS_ERROR;
1506: END IF;
1507:
1508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1509:
1510: IF l_debug_level > 0 THEN
1511: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1512: END IF;

Line 1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1509:
1510: IF l_debug_level > 0 THEN
1511: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1512: END IF;
1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1514:
1515: -- Get message count and data
1516:
1517: FND_MSG_PUB.Count_And_Get

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1523:
1524: IF l_debug_level > 0 THEN
1525: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1526: END IF;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528:
1529: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1530: THEN
1531: FND_MSG_PUB.Add_Exc_Msg

Line 1557: x_return_status := FND_API.G_RET_STS_SUCCESS;

1553: RETURN BOOLEAN IS
1554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1555: l_line_id NUMBER;
1556: BEGIN
1557: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558:
1559: SELECT oel.line_id
1560: INTO l_line_id
1561: FROM oe_order_lines_all oel,

Line 1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1602: WHEN OTHERS THEN
1603: if l_debug_level > 0 then
1604: OE_DEBUG_PUB.Add('When Others in Check_Pick_pending_Lines'||SqlErrm, 1);
1605: End if;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: End Check_Import_Pending_Lines;
1608:
1609: PROCEDURE ATO_Config_Line_Ship_Notified( p_application_id IN NUMBER,
1610: p_entity_short_name in VARCHAR2,

Line 1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR

1624:
1625:
1626:
1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)

Line 1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR

1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)
1633: THEN
1634: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1635: p_result := 0;

Line 1704: x_return_status := FND_API.G_RET_STS_SUCCESS;

1700: l_header_id NUMBER := p_setsmc_input_rec.header_id;
1701: l_top_model_line_id NUMBER := p_setsmc_input_rec.top_model_line_id;
1702: l_ship_set_id NUMBER := p_setsmc_input_rec.ship_set_id;
1703: BEGIN
1704: x_return_status := FND_API.G_RET_STS_SUCCESS;
1705:
1706: IF l_debug_level > 0 THEN
1707: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1708: oe_debug_pub.add('headerID = '||l_header_id, 3);

Line 1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1755: IF l_debug_level > 0 THEN
1756: oe_debug_pub.add('OTHERS EXCEPTION ' || sqlerrm, 1);
1757: END IF;
1758:
1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1760: p_setsmc_output_rec.x_interface_status := 'N';
1761:
1762: END Get_SetSMC_Interface_Status;
1763: -- 3623149 changes ends