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

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: J NUMBER;
38: BEGIN
39:
40: oe_debug_pub.add('Entering oe_schedule_grp.update_scheduling_results' || p_x_sch_tbl.count ,1);
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
44: l_count := p_x_sch_tbl.count;
45:

Line 67: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_SUCCESS;

63:
64: END IF;
65:
66: g_sch_tbl(I) := p_x_sch_tbl(I);
67: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: IF I = l_count
70: OR p_x_sch_tbl(I).header_id <> p_x_sch_tbl(I + 1).header_id THEN
71:

Line 76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

72: SAVEPOINT Group_Schedule;
73: Process_order(x_return_status => l_return_status);
74: /*
75: -- Handling error as per bug 7679398
76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73: Process_order(x_return_status => l_return_status);
74: /*
75: -- Handling error as per bug 7679398
76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81: */

Line 78: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

74: /*
75: -- Handling error as per bug 7679398
76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81: */
82: -- Commented the above for bug 7679398/7675256, and added the SAVEPOINT -

Line 79: RAISE FND_API.G_EXC_ERROR;

75: -- Handling error as per bug 7679398
76: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81: */
82: -- Commented the above for bug 7679398/7675256, and added the SAVEPOINT -
83: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 83: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81: */
82: -- Commented the above for bug 7679398/7675256, and added the SAVEPOINT -
83: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
84: ROLLBACK TO Group_Schedule;
85: END IF;
86:
87:

Line 96: IF g_sch_tbl(J).x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

92: oe_debug_pub.add('J : ' || J);
93: oe_debug_pub.add('J Return Status :' || g_sch_tbl(J).x_return_status,1);
94: p_x_sch_tbl(J).x_return_status
95: := g_sch_tbl(J).x_return_status;
96: IF g_sch_tbl(J).x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
97:
98: oe_debug_pub.add('Setting the status to W to indicate partial processing',1);
99: x_return_status := 'W';
100:

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120: oe_debug_pub.add('Exiting oe_schedule_grp.update_scheduling_results' ||
121: x_return_status,1);
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121: x_return_status,1);
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129:

Line 127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

124: WHEN FND_API.G_EXC_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132:

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132:
133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
134: THEN
135: OE_MSG_PUB.Add_Exc_Msg

Line 147: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

143: IS
144: l_line_rec OE_Order_PUB.Line_Rec_type;
145: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
146: l_control_rec OE_GLOBALS.control_rec_type;
147: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
148: l_count Number;
149: l_ship_from_is_changed BOOLEAN := FALSE;
150: l_ship_method_is_changed BOOLEAN := FALSE;
151:

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: BEGIN
164:
165: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- This variable is to track that the Item is being Substituted by Planning Loop Back and not being changed manully by user.
169: -- Initializing to 'N' for current set of Lines. Will set it to Y if any item substitutions are happening.
170: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708

Line 186: IF g_sch_tbl(I).x_return_status = FND_API.G_RET_STS_SUCCESS THEN

182: WHILE I IS NOT NULL
183: LOOP
184: -- FOR I IN 1..g_sch_tbl.count LOOP
185:
186: IF g_sch_tbl(I).x_return_status = FND_API.G_RET_STS_SUCCESS THEN
187:
188: -- g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: BEGIN

Line 188: -- g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_SUCCESS;

184: -- FOR I IN 1..g_sch_tbl.count LOOP
185:
186: IF g_sch_tbl(I).x_return_status = FND_API.G_RET_STS_SUCCESS THEN
187:
188: -- g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: BEGIN
191: OE_Line_Util.Query_Row( p_line_id => g_sch_tbl(I).line_id
192: ,x_line_rec => l_line_rec);

Line 206: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

202:
203: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_LOOP_LINE');
204: FND_MESSAGE.SET_TOKEN('LINE_ID',g_sch_tbl(I).line_id);
205: OE_MSG_PUB.ADD;
206: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
207: goto end_main_loop;
208: END;
209: -- Special Validation is needed before taking the data
210:

Line 241: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

237: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
239: OE_Order_Util.Get_Attribute_Name('Schedule_Ship_Date'));
240: OE_MSG_PUB.ADD;
241: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
242:
243: END IF;
244:
245: IF g_sch_tbl(I).Orig_Schedule_arrival_date IS NOT NULL

Line 254: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

250: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
252: OE_Order_Util.Get_Attribute_Name('Schedule_Arrival_date'));
253: OE_MSG_PUB.ADD;
254: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
255:
256: END IF;
257:
258: IF g_sch_tbl(I).Orig_ship_from_org_id IS NOT NULL

Line 267: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

263: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
265: OE_Order_Util.Get_Attribute_Name('ship_from_org_id'));
266: OE_MSG_PUB.ADD;
267: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
268:
269: END IF;
270:
271: IF g_sch_tbl(I).Orig_Shipping_Method_Code IS NOT NULL

Line 280: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

276: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
278: OE_Order_Util.Get_Attribute_Name('Shipping_Method_Code'));
279: OE_MSG_PUB.ADD;
280: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
281:
282: END IF;
283:
284: IF g_sch_tbl(I).Orig_ordered_quantity IS NOT NULL

Line 293: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

289: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
291: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
292: OE_MSG_PUB.ADD;
293: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
294:
295: END IF;
296:
297: IF g_sch_tbl(I).Orig_Earliest_Ship_date IS NOT NULL

Line 308: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

304: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
306: OE_Order_Util.Get_Attribute_Name('Earliest_Ship_date'));
307: OE_MSG_PUB.ADD;
308: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
309:
310: END IF;
311:
312: IF l_line_rec.ato_line_id is not null

Line 317: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

313: AND l_line_rec.ato_line_id <> l_line_rec.line_id
314: AND NOT l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
315:
316: oe_debug_pub.add('E4',2);
317: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
318: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
319: OE_MSG_PUB.ADD;
320: END IF;
321:

Line 339: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

335: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
337: OE_Order_Util.Get_Attribute_Name('inventory_item_id'));
338: OE_MSG_PUB.ADD;
339: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
340: END IF;
341:
342: l_opm_enabled := INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_line_rec.ship_from_org_id);
343:

Line 376: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

372: -- Booked Line and OPM Item
373: ( nvl(l_line_rec.booked_flag, 'N') = 'Y' and nvl(l_line_rec.reserved_quantity, 0) <> 0 ) -- Booked Line with Reservations
374: )
375: THEN
376: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
378: OE_MSG_PUB.ADD;
379: END IF;
380:

Line 391: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

387: WHERE INVENTORY_ITEM_ID = g_sch_tbl(I).inventory_item_id
388: AND ORGANIZATION_ID = nvl(g_sch_tbl(I).ship_from_org_id, l_line_rec.ship_from_org_id);
389:
390: IF l_shippable_flag <> l_line_rec.shippable_flag THEN
391: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_SHP_NONSHP');
393: OE_MSG_PUB.ADD;
394: END IF;
395: END;

Line 406: IF g_sch_tbl(I).x_return_status = FND_API.G_RET_STS_SUCCESS THEN

402:
403: -- Special Validation.
404:
405: oe_debug_pub.add('After Special Validation ',2);
406: IF g_sch_tbl(I).x_return_status = FND_API.G_RET_STS_SUCCESS THEN
407:
408: IF nvl(l_line_rec.override_atp_date_code,'N') = 'Y' THEN
409: g_sch_tbl(I).x_override_atp_date_code := 'Y';
410: END IF;

Line 445: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

441: /*
442: IF trunc(g_sch_tbl(I).schedule_ship_date) < trunc(l_local_line_tbl(J).request_date) THEN
443:
444: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
445: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
446: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
447: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
448: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
449: OE_MSG_PUB.ADD;

Line 447: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;

443:
444: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
445: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
446: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
447: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
448: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
449: OE_MSG_PUB.ADD;
450: goto end_loop;
451: END IF;

Line 462: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

458:
459: /* IF trunc(g_sch_tbl(I).schedule_arrival_date) < trunc(l_local_line_tbl(J).request_date) THEN
460:
461: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
462: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
463: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
464: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
466: oe_msg_pub.add;

Line 464: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;

460:
461: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
462: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
463: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
464: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
466: oe_msg_pub.add;
467: goto end_loop;
468: END IF;

Line 559: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

555: IF g_sch_tbl(I).schedule_ship_date is NOT NULL THEN
556: /* IF trunc(g_sch_tbl(I).schedule_ship_date) < trunc(l_line_rec.request_date) THEN
557:
558: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
559: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
560: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
561: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
563: OE_MSG_PUB.ADD;

Line 561: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;

557:
558: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
559: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
560: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
561: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
563: OE_MSG_PUB.ADD;
564: goto end_loop1;
565: END IF;

Line 572: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

568: IF g_sch_tbl(I).schedule_arrival_date is NOT NULL THEN
569: /* IF trunc(g_sch_tbl(I).schedule_arrival_date) < trunc(l_line_rec.request_date) THEN
570:
571: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
572: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
573: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
574: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
575: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
576: oe_msg_pub.add;

Line 574: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;

570:
571: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
572: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
573: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
574: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
575: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
576: oe_msg_pub.add;
577: goto end_loop1;
578: END IF;

Line 640: IF g_line_tbl(J).return_status <> FND_API.G_RET_STS_SUCCESS THEN

636: FOR J IN 1..g_line_tbl.count LOOP
637:
638: oe_debug_pub.add('Operation ' || g_line_tbl(J).operation ,2);
639:
640: IF g_line_tbl(J).return_status <> FND_API.G_RET_STS_SUCCESS THEN
641:
642: oe_debug_pub.add('None ' || g_line_tbl(J).return_status,2);
643: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
644:

Line 770: x_return_status := FND_API.G_RET_STS_ERROR;

766: ,x_return_status => x_return_status);
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: END;
772:
773: END IF;
774: -- 4606248

Line 775: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

771: END;
772:
773: END IF;
774: -- 4606248
775: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
776:
777: OE_Order_PVT.Process_Requests_And_Notify
778: ( p_process_requests => TRUE
779: ,p_notify => TRUE

Line 789: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

785: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; -- Added for ER 6110708
786:
787: -- ELSE -- Updated for bug 7679398/7675256
788: END IF;
789: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
790:
791:
792:
793: FOR I IN 1..g_line_tbl.COUNT LOOP

Line 826: g_line_tbl(I).return_status = FND_API.G_RET_STS_SUCCESS) THEN

822: IF ( g_line_tbl(I).reserved_quantity > 0
823: OR g_line_tbl(I).inventory_item_id <> g_old_line_tbl(I).inventory_item_id -- Added for ER 6110708
824: )
825: AND (g_line_tbl(I).return_status is null OR
826: g_line_tbl(I).return_status = FND_API.G_RET_STS_SUCCESS) THEN
827:
828: Update_reservation(p_index => I,
829: x_return_status => x_return_status);
830:

Line 833: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

829: x_return_status => x_return_status);
830:
831: END IF;
832: END LOOP;
833: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;

Line 834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

830:
831: END IF;
832: END LOOP;
833: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:

Line 835: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

831: END IF;
832: END LOOP;
833: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:
839:

Line 836: RAISE FND_API.G_EXC_ERROR;

832: END LOOP;
833: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:
839:
840: g_line_tbl.delete;

Line 845: WHEN FND_API.G_EXC_ERROR THEN

841: g_old_line_tbl.delete;
842:
843: oe_debug_pub.add('Entering oe_schedule_grp.Process_order',1);
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846:
847: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
848: -- Added for IR ISO Tracking bug 7667702
849:

Line 850: x_return_status := FND_API.G_RET_STS_ERROR;

846:
847: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
848: -- Added for IR ISO Tracking bug 7667702
849:
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: g_line_tbl.delete;
852: g_old_line_tbl.delete;
853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

850: x_return_status := FND_API.G_RET_STS_ERROR;
851: g_line_tbl.delete;
852: g_old_line_tbl.delete;
853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855:
856: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
857: -- Added for IR ISO Tracking bug 7667702
858:

Line 859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

855:
856: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
857: -- Added for IR ISO Tracking bug 7667702
858:
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
860: g_line_tbl.delete;
861: g_old_line_tbl.delete;
862:
863: WHEN OTHERS THEN

Line 868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

864:
865: OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;
866: -- Added for IR ISO Tracking bug 7667702
867:
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: g_line_tbl.delete;
870: g_old_line_tbl.delete;
871:
872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 902: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

898: ,p_header_id => g_sch_tbl(I).header_id
899: ,p_line_id => g_sch_tbl(I).line_id);
900:
901: oe_debug_pub.add('ONT_SCH_LOOP_DATE_NULL',1);
902: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_DATE_NULL');
904: OE_MSG_PUB.ADD;
905:
906: END IF;

Line 911: WHEN FND_API.G_EXC_ERROR THEN

907:
908: I := g_sch_tbl.NEXT(I);
909: END LOOP;
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 912: x_return_status := FND_API.G_RET_STS_ERROR;

908: I := g_sch_tbl.NEXT(I);
909: END LOOP;
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916:

Line 914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916:
917: WHEN OTHERS THEN
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916:
917: WHEN OTHERS THEN
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919:

Line 918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916:
917: WHEN OTHERS THEN
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919:
920: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
921: THEN
922: OE_MSG_PUB.Add_Exc_Msg

Line 932: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

928:
929: PROCEDURE Validate_Lines(x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2)
930: IS
931: l_scheduling_level_code VARCHAR2(30);
932: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
933: l_msg_count NUMBER;
934: l_msg_data VARCHAR2(2000);
935: l_result Varchar2(30);
936: l_index NUMBER;

Line 946: x_return_status := FND_API.G_RET_STS_SUCCESS;

942: FOR I IN 1..G_LINE_TBL.COUNT LOOP
943:
944: oe_debug_pub.add('Validate_Lines' || g_line_tbl(I).line_id,1);
945:
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947: OE_MSG_PUB.set_msg_context
948: ( p_entity_code => 'LINE'
949: ,p_entity_id => g_line_tbl(I).line_id
950: ,p_header_id => g_line_tbl(I).header_id

Line 975: x_return_status := FND_API.G_RET_STS_ERROR;

971: oe_debug_pub.add('E1',2);
972: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
973: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_CANT_UPDATE');
974: OE_MSG_PUB.ADD;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: END IF;
977: */
978: IF g_line_tbl(I).cancelled_flag = 'Y' THEN
979:

Line 984: x_return_status := FND_API.G_RET_STS_ERROR;

980: oe_debug_pub.add('E1-1',2);
981: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
982: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_FULLY_CANCELLED');
983: OE_MSG_PUB.ADD;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: END IF;
986:
987: IF g_line_tbl(I).shipped_quantity is not null THEN
988:

Line 993: x_return_status := FND_API.G_RET_STS_ERROR;

989: oe_debug_pub.add('E1-2',2);
990: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
991: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_SHIPPED');
992: OE_MSG_PUB.ADD;
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: END IF;
995:
996: oe_debug_pub.add('Firm_demand_flag :' || g_line_tbl(I).firm_demand_flag,1);
997:

Line 1007: x_return_status := FND_API.G_RET_STS_ERROR;

1003: oe_debug_pub.add('E2',2);
1004: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1005: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_FRMD');
1006: OE_MSG_PUB.ADD;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: END IF; */
1009:
1010: IF g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
1011:

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR;

1012: oe_debug_pub.add('E3',2);
1013: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1014: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_SRV');
1015: OE_MSG_PUB.ADD;
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: END IF;
1018:
1019: IF g_line_tbl(I).ato_line_id IS NOT NULL THEN
1020: /* IF NOT (g_line_tbl(I).ato_line_id = g_line_tbl(I).line_id OR

Line 1027: x_return_status := FND_API.G_RET_STS_ERROR;

1023: oe_debug_pub.add('E4',2);
1024: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1025: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1026: OE_MSG_PUB.ADD;
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029: */
1030: IF nvl(g_line_tbl(I).model_remnant_flag,'N') = 'Y' THEN
1031: oe_debug_pub.add('E5',2);

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR;

1031: oe_debug_pub.add('E5',2);
1032: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1033: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1034: OE_MSG_PUB.ADD;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036:
1037: END IF;
1038: END IF;
1039:

Line 1046: x_return_status := FND_API.G_RET_STS_ERROR;

1042: oe_debug_pub.add('E6',2);
1043: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1044: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_RET');
1045: OE_MSG_PUB.ADD;
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: END IF;
1048:
1049: IF OE_OTA_UTIL.Is_OTA_Line(g_line_tbl(I).order_quantity_uom) THEN
1050:

Line 1055: x_return_status := FND_API.G_RET_STS_ERROR;

1051: oe_debug_pub.add('E7',2);
1052: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1053: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1054: OE_MSG_PUB.ADD;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: END IF;
1057:
1058: IF g_line_tbl(I).source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN
1059:

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060: oe_debug_pub.add('E8',2);
1061: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1062: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_EXT');
1063: OE_MSG_PUB.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: END IF;
1066:
1067: l_scheduling_level_code := OE_SCHEDULE_UTIL.Get_Scheduling_Level
1068: (g_line_tbl(I).header_id,

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

1075: oe_debug_pub.add('E9',2);
1076: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1077: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_LVL');
1078: OE_MSG_PUB.ADD;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081:
1082: END IF;
1083:

Line 1106: x_return_status := FND_API.G_RET_STS_ERROR;

1102: oe_debug_pub.add('E10',2);
1103: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1104: FND_MESSAGE.SET_NAMe('ONT', 'OE_SCH_LOOP_WSH_UPD');
1105: OE_MSG_PUB.ADD;
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107:
1108: END IF;
1109: */
1110: IF Oe_Sys_Parameters.Value('ONT_SCHEDULE_LINE_ON_HOLD') = 'N' THEN

Line 1114: , p_init_msg_list => FND_API.G_FALSE

1110: IF Oe_Sys_Parameters.Value('ONT_SCHEDULE_LINE_ON_HOLD') = 'N' THEN
1111:
1112: OE_Holds_PUB.Check_Holds
1113: ( p_api_version => 1.0
1114: , p_init_msg_list => FND_API.G_FALSE
1115: , p_commit => FND_API.G_FALSE
1116: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1117: , x_return_status => l_out_return_status
1118: , x_msg_count => l_msg_count

Line 1115: , p_commit => FND_API.G_FALSE

1111:
1112: OE_Holds_PUB.Check_Holds
1113: ( p_api_version => 1.0
1114: , p_init_msg_list => FND_API.G_FALSE
1115: , p_commit => FND_API.G_FALSE
1116: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1117: , x_return_status => l_out_return_status
1118: , x_msg_count => l_msg_count
1119: , x_msg_data => l_msg_data

Line 1116: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1112: OE_Holds_PUB.Check_Holds
1113: ( p_api_version => 1.0
1114: , p_init_msg_list => FND_API.G_FALSE
1115: , p_commit => FND_API.G_FALSE
1116: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1117: , x_return_status => l_out_return_status
1118: , x_msg_count => l_msg_count
1119: , x_msg_data => l_msg_data
1120: , p_line_id => g_line_tbl(I).line_id

Line 1127: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1123: , p_entity_id => NULL
1124: , x_result_out => l_result
1125: );
1126:
1127: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1128: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSE
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1128: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN

1124: , x_result_out => l_result
1125: );
1126:
1127: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1128: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSE
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125: );
1126:
1127: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1128: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSE
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133: END IF;

Line 1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1127: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1128: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSE
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133: END IF;
1134:
1135: IF (l_result = FND_API.G_TRUE) THEN

Line 1135: IF (l_result = FND_API.G_TRUE) THEN

1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133: END IF;
1134:
1135: IF (l_result = FND_API.G_TRUE) THEN
1136: oe_debug_pub.add('E11',2);
1137: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1138: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
1139: OE_MSG_PUB.Add;

Line 1140: x_return_status := FND_API.G_RET_STS_ERROR;

1136: oe_debug_pub.add('E11',2);
1137: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1138: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
1139: OE_MSG_PUB.Add;
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: END IF;
1142:
1143:
1144: END IF;

Line 1146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1142:
1143:
1144: END IF;
1145:
1146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1147:
1148: l_index := find_index(g_line_tbl(I).line_id);
1149: g_sch_tbl(l_index).x_return_status := x_return_status;
1150: END IF;

Line 1156: WHEN FND_API.G_EXC_ERROR THEN

1152:
1153: oe_debug_pub.add('Existing Validate_Lines',1);
1154:
1155: EXCEPTION
1156: WHEN FND_API.G_EXC_ERROR THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1157: x_return_status := FND_API.G_RET_STS_ERROR;

1153: oe_debug_pub.add('Existing Validate_Lines',1);
1154:
1155: EXCEPTION
1156: WHEN FND_API.G_EXC_ERROR THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161:

Line 1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1155: EXCEPTION
1156: WHEN FND_API.G_EXC_ERROR THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161:
1162: WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1156: WHEN FND_API.G_EXC_ERROR THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161:
1162: WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164:

Line 1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161:
1162: WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164:
1165: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1166: THEN
1167: OE_MSG_PUB.Add_Exc_Msg

Line 1253: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;

1249:
1250: IF g_line_tbl(J).ship_set_id = p_ship_set_id THEN
1251:
1252: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1253: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1254:
1255: l_index := find_index(g_line_tbl(J).line_id);
1256: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1257: END IF;

Line 1256: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;

1252: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1253: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1254:
1255: l_index := find_index(g_line_tbl(J).line_id);
1256: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1257: END IF;
1258:
1259: END LOOP;
1260:

Line 1268: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;

1264:
1265: IF g_line_tbl(J).arrival_set_id = p_arrival_set_id THEN
1266:
1267: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1268: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1269: l_index := find_index(g_line_tbl(J).line_id);
1270: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1271: END IF;
1272:

Line 1270: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;

1266:
1267: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1268: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1269: l_index := find_index(g_line_tbl(J).line_id);
1270: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1271: END IF;
1272:
1273: END LOOP;
1274:

Line 1283: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;

1279: IF g_line_tbl(J).top_model_line_id = p_top_model_line_id THEN
1280:
1281: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1282: l_index := find_index(g_line_tbl(J).line_id);
1283: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1284:
1285: END IF;
1286:
1287: END LOOP;

Line 1332: WHEN FND_API.G_EXC_ERROR THEN

1328:
1329:
1330: RETURN FALSE;
1331: EXCEPTION
1332: WHEN FND_API.G_EXC_ERROR THEN
1333: RETURN FALSE;
1334:
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: RETURN FALSE;

Line 1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1331: EXCEPTION
1332: WHEN FND_API.G_EXC_ERROR THEN
1333: RETURN FALSE;
1334:
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: RETURN FALSE;
1337:
1338: WHEN OTHERS THEN
1339:

Line 1382: WHEN FND_API.G_EXC_ERROR THEN

1378:
1379:
1380: RETURN null;
1381: EXCEPTION
1382: WHEN FND_API.G_EXC_ERROR THEN
1383: RETURN Null;
1384:
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1386: RETURN Null;

Line 1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1381: EXCEPTION
1382: WHEN FND_API.G_EXC_ERROR THEN
1383: RETURN Null;
1384:
1385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1386: RETURN Null;
1387:
1388: WHEN OTHERS THEN
1389:

Line 1432: WHEN FND_API.G_EXC_ERROR THEN

1428: ,x_return_status => x_return_status);
1429:
1430: END IF;
1431: EXCEPTION
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR;

1429:
1430: END IF;
1431: EXCEPTION
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437:

Line 1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1431: EXCEPTION
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437:
1438: WHEN OTHERS THEN
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1432: WHEN FND_API.G_EXC_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437:
1438: WHEN OTHERS THEN
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440:

Line 1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437:
1438: WHEN OTHERS THEN
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440:
1441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_MSG_PUB.Add_Exc_Msg