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 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: oe_debug_pub.add( 'RETURNED FROM WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 2 ) ;
125: END IF;
126: END IF;
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
132: END IF;

Line 135: WHEN FND_API.G_EXC_ERROR THEN

131: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
132: END IF;
133: EXCEPTION
134:
135: WHEN FND_API.G_EXC_ERROR THEN
136:
137: x_return_status := FND_API.G_RET_STS_ERROR;
138:
139: -- Get message count and data

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133: EXCEPTION
134:
135: WHEN FND_API.G_EXC_ERROR THEN
136:
137: x_return_status := FND_API.G_RET_STS_ERROR;
138:
139: -- Get message count and data
140:
141: FND_MSG_PUB.Count_And_Get

Line 146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

142: ( p_count => x_msg_count
143: , p_data => x_msg_data
144: );
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
150: END IF;

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
150: END IF;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
152:
153: -- Get message count and data
154:
155: FND_MSG_PUB.Count_And_Get

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

167: IF l_errname IS NOT NULL THEN
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
170: END IF;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: ELSE
173: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
174: THEN
175: FND_MSG_PUB.Add_Exc_Msg

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count
185: , p_data => x_msg_data
186: );
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: END IF;
189:
190: END Complete_Ship_Line_Activity;
191:

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

189:
190: END Complete_Ship_Line_Activity;
191:
192:
193: /* Returns FND_API_G_TRUE if credit check passes,
194: FND_API.G_FALSE if credit check fails */
195: /** This function is not used ******/
196: FUNCTION Credit_Check
197: (

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

190: END Complete_Ship_Line_Activity;
191:
192:
193: /* Returns FND_API_G_TRUE if credit check passes,
194: FND_API.G_FALSE if credit check fails */
195: /** This function is not used ******/
196: FUNCTION Credit_Check
197: (
198: p_api_version_number IN NUMBER

Line 216: IF NOT FND_API.Compatible_API_Call

212: BEGIN
213:
214: -- Standard call to check for call compatibility
215:
216: IF NOT FND_API.Compatible_API_Call
217: ( l_api_version_number
218: , p_api_version_number
219: , l_api_name
220: , G_PKG_NAME

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: , l_api_name
220: , G_PKG_NAME
221: )
222: THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225: /*
226: OE_Credit_PUB.Check_Available_Credit
227: (

Line 234: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

230: p_msg_data => l_x_msg_data,
231: p_result_out => l_x_result_out,
232: p_return_status => l_x_return_status
233: );
234: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;

Line 235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

231: p_result_out => l_x_result_out,
232: p_return_status => l_x_return_status
233: );
234: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239: */

Line 236: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

232: p_return_status => l_x_return_status
233: );
234: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239: */
240: IF UPPER(l_x_result_out) = 'PASS' THEN

Line 237: RAISE FND_API.G_EXC_ERROR;

233: );
234: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239: */
240: IF UPPER(l_x_result_out) = 'PASS' THEN
241: return FND_API.G_TRUE;

Line 241: return FND_API.G_TRUE;

237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239: */
240: IF UPPER(l_x_result_out) = 'PASS' THEN
241: return FND_API.G_TRUE;
242: ELSE
243: return FND_API.G_FALSE;
244: END IF;
245:

Line 243: return FND_API.G_FALSE;

239: */
240: IF UPPER(l_x_result_out) = 'PASS' THEN
241: return FND_API.G_TRUE;
242: ELSE
243: return FND_API.G_FALSE;
244: END IF;
245:
246: EXCEPTION
247:

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244: END IF;
245:
246: EXCEPTION
247:
248: WHEN FND_API.G_EXC_ERROR THEN
249:
250: return FND_API.G_RET_STS_ERROR;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 250: return FND_API.G_RET_STS_ERROR;

246: EXCEPTION
247:
248: WHEN FND_API.G_EXC_ERROR THEN
249:
250: return FND_API.G_RET_STS_ERROR;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253:
254: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: WHEN FND_API.G_EXC_ERROR THEN
249:
250: return FND_API.G_RET_STS_ERROR;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253:
254: return FND_API.G_RET_STS_UNEXP_ERROR ;
255:
256: WHEN OTHERS THEN

Line 254: return FND_API.G_RET_STS_UNEXP_ERROR ;

250: return FND_API.G_RET_STS_ERROR;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253:
254: return FND_API.G_RET_STS_UNEXP_ERROR ;
255:
256: WHEN OTHERS THEN
257:
258: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 258: return FND_API.G_RET_STS_UNEXP_ERROR ;

254: return FND_API.G_RET_STS_UNEXP_ERROR ;
255:
256: WHEN OTHERS THEN
257:
258: return FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: END Credit_Check;
261:
262: /*

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

259:
260: END Credit_Check;
261:
262: /*
263: If this funtion returns FND_API.G_TRUE, a hold exists on this line.
264: If this funtion returns FND_API.G_FALSE, a hold does not exists
265: on this line.
266: */
267:

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

260: END Credit_Check;
261:
262: /*
263: If this funtion returns FND_API.G_TRUE, a hold exists on this line.
264: If this funtion returns FND_API.G_FALSE, a hold does not exists
265: on this line.
266: */
267:
268: FUNCTION Check_Holds_For_SC

Line 289: IF NOT FND_API.Compatible_API_Call

285: BEGIN
286:
287: -- Standard call to check for call compatibility
288:
289: IF NOT FND_API.Compatible_API_Call
290: ( l_api_version_number
291: , p_api_version_number
292: , l_api_name
293: , G_PKG_NAME

Line 296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

292: , l_api_name
293: , G_PKG_NAME
294: )
295: THEN
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: END IF;
298:
299: OE_Holds_PUB.Check_Holds
300: (

Line 308: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

304: x_return_status => l_x_return_status,
305: x_msg_count => l_x_msg_count,
306: x_msg_data => l_x_msg_data
307: );
308: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

305: x_msg_count => l_x_msg_count,
306: x_msg_data => l_x_msg_data
307: );
308: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: return l_x_result_out;

Line 310: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

306: x_msg_data => l_x_msg_data
307: );
308: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: return l_x_result_out;
314:

Line 311: RAISE FND_API.G_EXC_ERROR;

307: );
308: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: return l_x_result_out;
314:
315: EXCEPTION

Line 317: WHEN FND_API.G_EXC_ERROR THEN

313: return l_x_result_out;
314:
315: EXCEPTION
316:
317: WHEN FND_API.G_EXC_ERROR THEN
318:
319: return FND_API.G_RET_STS_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 319: return FND_API.G_RET_STS_ERROR;

315: EXCEPTION
316:
317: WHEN FND_API.G_EXC_ERROR THEN
318:
319: return FND_API.G_RET_STS_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322:
323: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

317: WHEN FND_API.G_EXC_ERROR THEN
318:
319: return FND_API.G_RET_STS_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322:
323: return FND_API.G_RET_STS_UNEXP_ERROR ;
324:
325: WHEN OTHERS THEN

Line 323: return FND_API.G_RET_STS_UNEXP_ERROR ;

319: return FND_API.G_RET_STS_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322:
323: return FND_API.G_RET_STS_UNEXP_ERROR ;
324:
325: WHEN OTHERS THEN
326:
327: return FND_API.G_RET_STS_UNEXP_ERROR ;

Line 327: return FND_API.G_RET_STS_UNEXP_ERROR ;

323: return FND_API.G_RET_STS_UNEXP_ERROR ;
324:
325: WHEN OTHERS THEN
326:
327: return FND_API.G_RET_STS_UNEXP_ERROR ;
328:
329: END Check_Holds_For_SC;
330:
331:

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

355: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
356: l_tbl_index NUMBER;
357: l_line_index NUMBER;
358: l_cal_tolerance_tbl Cal_Tolerance_Tbl_Type;
359: l_model_kit_line VARCHAR2(1) := FND_API.G_FALSE;
360: l_x_result_out VARCHAR2(30);
361: l_shipped_quantity NUMBER := 0;
362: l_ordered_quantity NUMBER := 0;
363: l_x_shipped_quantity NUMBER := 0;

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

369: l_x_return_status VARCHAR2(1);
370: l_top_model_line_id NUMBER;
371: -- l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
372: l_ratio_status VARCHAR2(1);
373: l_planned_quantity_passed VARCHAR2(1) := FND_API.G_FALSE;
374: l_top_model_index NUMBER := 0;
375:
376: l_count_unshipped NUMBER := 0;
377: l_del_shipping_quantity NUMBER := 0;

Line 388: x_update_tolerance_flag := FND_API.G_FALSE;

384: IF l_debug_level > 0 THEN
385: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
386: END IF;
387: -- Standard call to check for call compatibility
388: x_update_tolerance_flag := FND_API.G_FALSE;
389: x_ship_beyond_tolerance := FND_API.G_FALSE;
390: x_shipped_within_tolerance := FND_API.G_FALSE;
391: x_config_broken := FND_API.G_FALSE;
392:

Line 389: x_ship_beyond_tolerance := FND_API.G_FALSE;

385: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
386: END IF;
387: -- Standard call to check for call compatibility
388: x_update_tolerance_flag := FND_API.G_FALSE;
389: x_ship_beyond_tolerance := FND_API.G_FALSE;
390: x_shipped_within_tolerance := FND_API.G_FALSE;
391: x_config_broken := FND_API.G_FALSE;
392:
393: IF NOT FND_API.Compatible_API_Call

Line 390: x_shipped_within_tolerance := FND_API.G_FALSE;

386: END IF;
387: -- Standard call to check for call compatibility
388: x_update_tolerance_flag := FND_API.G_FALSE;
389: x_ship_beyond_tolerance := FND_API.G_FALSE;
390: x_shipped_within_tolerance := FND_API.G_FALSE;
391: x_config_broken := FND_API.G_FALSE;
392:
393: IF NOT FND_API.Compatible_API_Call
394: ( l_api_version_number

Line 391: x_config_broken := FND_API.G_FALSE;

387: -- Standard call to check for call compatibility
388: x_update_tolerance_flag := FND_API.G_FALSE;
389: x_ship_beyond_tolerance := FND_API.G_FALSE;
390: x_shipped_within_tolerance := FND_API.G_FALSE;
391: x_config_broken := FND_API.G_FALSE;
392:
393: IF NOT FND_API.Compatible_API_Call
394: ( l_api_version_number
395: , p_api_version_number

Line 393: IF NOT FND_API.Compatible_API_Call

389: x_ship_beyond_tolerance := FND_API.G_FALSE;
390: x_shipped_within_tolerance := FND_API.G_FALSE;
391: x_config_broken := FND_API.G_FALSE;
392:
393: IF NOT FND_API.Compatible_API_Call
394: ( l_api_version_number
395: , p_api_version_number
396: , l_api_name
397: , G_PKG_NAME

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: , l_api_name
397: , G_PKG_NAME
398: )
399: THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: -- Convert the passed table
404:

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

410: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).line_id := p_cal_tolerance_tbl(l_tbl_index).line_id;
411: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).quantity_to_be_shipped := p_cal_tolerance_tbl(l_tbl_index).quantity_to_be_shipped;
412:
413: /* to fix the bug 2127323 */
414: IF p_cal_tolerance_tbl(l_tbl_index).planned_quantity = FND_API.G_MISS_NUM THEN
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add( 'PLANNED QUANTITY IS MISSING SETTING IT TO ZERO ' , 3 ) ;
417: END IF;
418:

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

421: END IF;
422:
423: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).shipping_uom := p_cal_tolerance_tbl(l_tbl_index).shipping_uom;
424: IF nvl(p_cal_tolerance_tbl(l_tbl_index).planned_quantity,0) <> 0 AND
425: p_cal_tolerance_tbl(l_tbl_index).planned_quantity <> FND_API.G_MISS_NUM THEN
426: l_planned_quantity_passed := FND_API.G_TRUE;
427: END IF;
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;

Line 426: l_planned_quantity_passed := FND_API.G_TRUE;

422:
423: l_cal_tolerance_tbl(p_cal_tolerance_tbl(l_tbl_index).line_id).shipping_uom := p_cal_tolerance_tbl(l_tbl_index).shipping_uom;
424: IF nvl(p_cal_tolerance_tbl(l_tbl_index).planned_quantity,0) <> 0 AND
425: p_cal_tolerance_tbl(l_tbl_index).planned_quantity <> FND_API.G_MISS_NUM THEN
426: l_planned_quantity_passed := FND_API.G_TRUE;
427: END IF;
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add( 'SHIPPING UOM : '||P_CAL_TOLERANCE_TBL ( L_TBL_INDEX ) .SHIPPING_UOM , 3 ) ;
430: END IF;

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

449: -- l_line_rec := OE_Line_Util.Query_Row(p_cal_tolerance_tbl(l_tbl_index).line_id);
450: OE_Line_Util.Query_Row(p_line_id => p_cal_tolerance_tbl(l_tbl_index).line_id,
451: x_line_rec => l_line_rec);
452: IF l_line_rec.top_model_line_id IS NOT NULL AND
453: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
454:
455: l_model_kit_line := FND_API.G_TRUE;
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;

Line 455: l_model_kit_line := FND_API.G_TRUE;

451: x_line_rec => l_line_rec);
452: IF l_line_rec.top_model_line_id IS NOT NULL AND
453: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
454:
455: l_model_kit_line := FND_API.G_TRUE;
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
458: END IF;
459: l_top_model_line_id := l_line_rec.top_model_line_id;

Line 465: IF l_model_kit_line = FND_API.G_TRUE THEN

461: END IF;
462: NULL;
463: END LOOP;
464:
465: IF l_model_kit_line = FND_API.G_TRUE THEN
466:
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add( 'IT IS A MODEL/KIT LINE ' , 3 ) ;
469: END IF;

Line 553: IF l_ratio_status = FND_API.G_TRUE THEN

549: IF l_debug_level > 0 THEN
550: oe_debug_pub.add( 'RATIO STATUS/RETURN STATUS : '||L_RATIO_STATUS||L_X_RETURN_STATUS , 3 ) ;
551: END IF;
552:
553: IF l_ratio_status = FND_API.G_TRUE THEN
554:
555: l_shipped_quantity := l_temp_line_tbl(l_top_model_index).shipped_quantity;
556: l_line_rec := l_temp_line_tbl(l_top_model_index);
557:

Line 569: l_planned_quantity_passed = FND_API.G_TRUE THEN

565: x_result_out => l_x_result_out
566: );
567:
568: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
569: l_planned_quantity_passed = FND_API.G_TRUE THEN
570:
571: IF l_debug_level > 0 THEN
572: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 2 ) ;
573: END IF;

Line 625: IF l_ratio_status = FND_API.G_TRUE THEN

621: p_x_line_tbl => l_temp_line_tbl
622: , x_ratio_status => l_ratio_status
623: , x_return_status => l_x_return_status
624: );
625: IF l_ratio_status = FND_API.G_TRUE THEN
626:
627: l_shipped_quantity := l_temp_line_tbl(l_top_model_index).shipped_quantity;
628: l_ordered_quantity := l_temp_line_tbl(l_top_model_index).ordered_quantity;
629: l_line_rec := l_temp_line_tbl(l_top_model_index);

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

638: -- Get the total ordered and shipped quantities if it is a part of
639: -- a line set.
640:
641: IF l_line_rec.line_set_id IS NOT NULL AND
642: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN
643:
644: OE_Shipping_Integration_PUB.Get_Quantity
645: (
646: p_api_version_number => 1.0,

Line 683: x_update_tolerance_flag := FND_API.G_TRUE;

679: END IF;
680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
682: END IF;
683: x_update_tolerance_flag := FND_API.G_TRUE;
684: x_ship_tolerance := l_ship_tolerance;
685: ELSE
686: x_config_broken := FND_API.G_TRUE;
687: END IF;

Line 686: x_config_broken := FND_API.G_TRUE;

682: END IF;
683: x_update_tolerance_flag := FND_API.G_TRUE;
684: x_ship_tolerance := l_ship_tolerance;
685: ELSE
686: x_config_broken := FND_API.G_TRUE;
687: END IF;
688:
689: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
690: IF l_debug_level > 0 THEN

Line 693: x_ship_beyond_tolerance := FND_API.G_TRUE;

689: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'SHIPPED BEYOND TOLERANCE ' , 3 ) ;
692: END IF;
693: x_ship_beyond_tolerance := FND_API.G_TRUE;
694: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
695: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;

Line 699: x_shipped_within_tolerance := FND_API.G_TRUE;

695: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
698: END IF;
699: x_shipped_within_tolerance := FND_API.G_TRUE;
700: END IF;
701:
702: ELSE
703: x_config_broken := FND_API.G_TRUE;

Line 703: x_config_broken := FND_API.G_TRUE;

699: x_shipped_within_tolerance := FND_API.G_TRUE;
700: END IF;
701:
702: ELSE
703: x_config_broken := FND_API.G_TRUE;
704: END IF;
705:
706: ELSE
707: IF l_debug_level > 0 THEN

Line 789: l_planned_quantity_passed = FND_API.G_TRUE THEN

785: x_result_out => l_x_result_out
786: );
787:
788: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW AND
789: l_planned_quantity_passed = FND_API.G_TRUE THEN
790:
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW' , 3 ) ;
793: END IF;

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

826: -- Get the total ordered and shipped quantities if it is a part of
827: -- a line set.
828:
829: IF l_line_rec.line_set_id IS NOT NULL AND
830: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN
831:
832: OE_Shipping_Integration_PUB.Get_Quantity
833: (
834: p_api_version_number => 1.0,

Line 871: x_update_tolerance_flag := FND_API.G_TRUE;

867: END IF;
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( 'NEW TOLERANCE VALUE : '|| TO_CHAR ( L_SHIP_TOLERANCE ) , 3 ) ;
870: END IF;
871: x_update_tolerance_flag := FND_API.G_TRUE;
872: x_ship_tolerance := l_ship_tolerance;
873:
874: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
875: x_ship_beyond_tolerance := FND_API.G_TRUE;

Line 875: x_ship_beyond_tolerance := FND_API.G_TRUE;

871: x_update_tolerance_flag := FND_API.G_TRUE;
872: x_ship_tolerance := l_ship_tolerance;
873:
874: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
875: x_ship_beyond_tolerance := FND_API.G_TRUE;
876: ELSIF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
877: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
879: IF l_debug_level > 0 THEN

Line 882: x_shipped_within_tolerance := FND_API.G_TRUE;

878: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE ' , 3 ) ;
881: END IF;
882: x_shipped_within_tolerance := FND_API.G_TRUE;
883: END IF;
884:
885: END IF;
886:

Line 888: x_return_status := FND_API.G_RET_STS_SUCCESS;

884:
885: END IF;
886:
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
891: END IF;
892:

Line 898: x_return_status := FND_API.G_RET_STS_ERROR;

894:
895: WHEN NO_DATA_FOUND THEN
896:
897:
898: x_return_status := FND_API.G_RET_STS_ERROR;
899:
900: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
901: THEN
902: x_return_status := FND_API.G_RET_STS_ERROR;

Line 902: x_return_status := FND_API.G_RET_STS_ERROR;

898: x_return_status := FND_API.G_RET_STS_ERROR;
899:
900: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
901: THEN
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904:
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906:

Line 905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

901: THEN
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904:
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906:
907: IF l_debug_level > 0 THEN
908: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
909: END IF;

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

906:
907: IF l_debug_level > 0 THEN
908: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
909: END IF;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
911:
912: -- Get message count and data
913:
914: FND_MSG_PUB.Count_And_Get

Line 924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

920:
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
923: END IF;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925:
926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
927: THEN
928: FND_MSG_PUB.Add_Exc_Msg

Line 979: IF NOT FND_API.Compatible_API_Call

975: IF l_debug_level > 0 THEN
976: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY '||TO_CHAR ( P_LINE_ID ) ||'/'||TO_CHAR ( P_LINE_SET_ID ) , 1 ) ;
977: END IF;
978:
979: IF NOT FND_API.Compatible_API_Call
980: ( l_api_version_number
981: , p_api_version_number
982: , l_api_name
983: , G_PKG_NAME

Line 986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

982: , l_api_name
983: , G_PKG_NAME
984: )
985: THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988:
989: SELECT SUM(ordered_quantity)
990: , SUM(shipped_quantity)

Line 1001: x_return_status := FND_API.G_RET_STS_SUCCESS;

997:
998: x_ordered_quantity := l_x_ordered_quantity;
999: x_shipped_quantity := l_x_shipped_quantity;
1000: x_shipping_quantity := l_x_shipping_quantity;
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1002:
1003: IF l_debug_level > 0 THEN
1004: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY ' , 1 ) ;
1005: END IF;

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR;

1012: x_shipping_quantity := 0;
1013:
1014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1015: THEN
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: END IF;
1018:
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020:

Line 1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1015: THEN
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: END IF;
1018:
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020:
1021: IF l_debug_level > 0 THEN
1022: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1023: END IF;

Line 1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1020:
1021: IF l_debug_level > 0 THEN
1022: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1023: END IF;
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1025:
1026: -- Get message count and data
1027:
1028: FND_MSG_PUB.Count_And_Get

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1034:
1035: IF l_debug_level > 0 THEN
1036: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039:
1040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1041: THEN
1042: FND_MSG_PUB.Add_Exc_Msg

Line 1090: p_line_id = FND_API.G_MISS_NUM THEN

1086: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1087: END IF;
1088:
1089: IF p_line_id IS NULL OR
1090: p_line_id = FND_API.G_MISS_NUM THEN
1091:
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'LINE ID IS NULL ' , 1 ) ;
1094: END IF;

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: END IF;
1095:
1096: FND_MESSAGE.SET_NAME('ONT','OE_SHP_LINE_ID_MISSING');
1097: OE_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099:
1100: END IF;
1101:
1102: IF p_shipping_interfaced_flag IS NOT NULL AND

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1111: OE_Order_Util.Get_Attribute_Name('shipping_interfaced_flag'));
1112: OE_MSG_PUB.Add;
1113:
1114: RAISE FND_API.G_EXC_ERROR;
1115:
1116: END IF;
1117:
1118: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'

Line 1150: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1146: ,x_line_tbl => l_old_line_tbl
1147: ,x_return_status => x_return_status
1148: );
1149:
1150: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;

Line 1151: RAISE FND_API.G_EXC_ERROR;

1147: ,x_return_status => x_return_status
1148: );
1149:
1150: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;
1155:

Line 1152: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1148: );
1149:
1150: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;
1155:
1156: l_line_tbl := l_old_line_tbl;

Line 1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1149:
1150: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;
1155:
1156: l_line_tbl := l_old_line_tbl;
1157: l_line_tbl(1).shipping_interfaced_flag := p_shipping_interfaced_flag;

Line 1220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1218: END IF;
1219:
1220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;

Line 1221: RAISE FND_API.G_EXC_ERROR;

1217: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1218: END IF;
1219:
1220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225:

Line 1222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1218: END IF;
1219:
1220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225:
1226: IF l_index IS NOT NULL THEN

Line 1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1219:
1220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225:
1226: IF l_index IS NOT NULL THEN
1227: -- update the global picture directly

Line 1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1261: , p_line_tbl => l_line_tbl
1262: , p_old_line_tbl => l_old_line_tbl
1263: );
1264:
1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: END IF;

Line 1266: RAISE FND_API.G_EXC_ERROR;

1262: , p_old_line_tbl => l_old_line_tbl
1263: );
1264:
1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: END IF;
1270:

Line 1267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1263: );
1264:
1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: END IF;
1270:
1271: END IF; /* pack H */

Line 1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1264:
1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: END IF;
1270:
1271: END IF; /* pack H */
1272:

Line 1317: x_return_status := FND_API.G_RET_STS_SUCCESS;

1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1315: END IF;
1316:
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319: EXCEPTION
1320:
1321: WHEN FND_API.G_EXC_ERROR THEN

Line 1321: WHEN FND_API.G_EXC_ERROR THEN

1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319: EXCEPTION
1320:
1321: WHEN FND_API.G_EXC_ERROR THEN
1322:
1323: ROLLBACK TO Update_Shipping_Interface;
1324:
1325: OE_MSG_PUB.Count_And_Get

Line 1330: x_return_status := FND_API.G_RET_STS_ERROR;

1326: ( p_count => x_msg_count
1327: , p_data => x_msg_data
1328: );
1329:
1330: x_return_status := FND_API.G_RET_STS_ERROR;
1331:
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333:
1334: ROLLBACK TO Update_Shipping_Interface;

Line 1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1328: );
1329:
1330: x_return_status := FND_API.G_RET_STS_ERROR;
1331:
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333:
1334: ROLLBACK TO Update_Shipping_Interface;
1335:
1336: -- Get message count and data

Line 1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1342:
1343: IF l_debug_level > 0 THEN
1344: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1345: END IF;
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1347:
1348: WHEN OTHERS THEN
1349:
1350: ROLLBACK TO Update_Shipping_Interface;

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1366:
1367: IF l_debug_level > 0 THEN
1368: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1369: END IF;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371:
1372: END Update_Shipping_Interface;
1373:
1374: -- HW added qty2 for OPM in the procedure parameters

Line 1423: x_return_status := FND_API.G_RET_STS_SUCCESS;

1419: IF l_debug_level > 0 THEN
1420: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;
1421: END IF;
1422:
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424: /*
1425: IF NOT FND_API.Compatible_API_Call
1426: ( l_api_version_number
1427: , p_api_version_number

Line 1425: IF NOT FND_API.Compatible_API_Call

1421: END IF;
1422:
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424: /*
1425: IF NOT FND_API.Compatible_API_Call
1426: ( l_api_version_number
1427: , p_api_version_number
1428: , l_api_name
1429: , G_PKG_NAME

Line 1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1428: , l_api_name
1429: , G_PKG_NAME
1430: )
1431: THEN
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434: */
1435:
1436:

Line 1480: x_return_status := FND_API.G_RET_STS_ERROR;

1476: x_max_remaining_quantity2 := 0;
1477:
1478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1479: THEN
1480: x_return_status := FND_API.G_RET_STS_ERROR;
1481: END IF;
1482:
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484:

Line 1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1479: THEN
1480: x_return_status := FND_API.G_RET_STS_ERROR;
1481: END IF;
1482:
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484:
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1487: END IF;

Line 1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1484:
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1487: END IF;
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1489:
1490: -- Get message count and data
1491:
1492: FND_MSG_PUB.Count_And_Get

Line 1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1498:
1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1501: END IF;
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1503:
1504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1505: THEN
1506: FND_MSG_PUB.Add_Exc_Msg

Line 1532: x_return_status := FND_API.G_RET_STS_SUCCESS;

1528: RETURN BOOLEAN IS
1529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1530: l_line_id NUMBER;
1531: BEGIN
1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533:
1534: SELECT oel.line_id
1535: INTO l_line_id
1536: FROM oe_order_lines_all oel,

Line 1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1577: WHEN OTHERS THEN
1578: if l_debug_level > 0 then
1579: OE_DEBUG_PUB.Add('When Others in Check_Pick_pending_Lines'||SqlErrm, 1);
1580: End if;
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582: End Check_Import_Pending_Lines;
1583:
1584: PROCEDURE ATO_Config_Line_Ship_Notified( p_application_id IN NUMBER,
1585: p_entity_short_name in VARCHAR2,

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

1599:
1600:
1601:
1602: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1603: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1604: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1605: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1606: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1607: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)

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

1602: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1603: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1604: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1605: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1606: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1607: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)
1608: THEN
1609: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1610: p_result := 0;

Line 1679: x_return_status := FND_API.G_RET_STS_SUCCESS;

1675: l_header_id NUMBER := p_setsmc_input_rec.header_id;
1676: l_top_model_line_id NUMBER := p_setsmc_input_rec.top_model_line_id;
1677: l_ship_set_id NUMBER := p_setsmc_input_rec.ship_set_id;
1678: BEGIN
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680:
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Entering Get_SetSMC_Interface_Status ', 1);
1683: oe_debug_pub.add('headerID = '||l_header_id, 3);

Line 1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1730: IF l_debug_level > 0 THEN
1731: oe_debug_pub.add('OTHERS EXCEPTION ' || sqlerrm, 1);
1732: END IF;
1733:
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735: p_setsmc_output_rec.x_interface_status := 'N';
1736:
1737: END Get_SetSMC_Interface_Status;
1738: -- 3623149 changes ends