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

Line 11: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM

7: /*-----------------------------------------------------------------
8: forward declarations
9: ------------------------------------------------------------------*/
10: PROCEDURE Query_Config
11: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
13: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
14: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
15:

Line 12: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM

8: forward declarations
9: ------------------------------------------------------------------*/
10: PROCEDURE Query_Config
11: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
13: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
14: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
15:
16: Procedure get_transaction_id(p_caller IN VARCHAR2);

Line 13: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM

9: ------------------------------------------------------------------*/
10: PROCEDURE Query_Config
11: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
13: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
14: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
15:
16: Procedure get_transaction_id(p_caller IN VARCHAR2);
17:

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

122: l_line_rec OE_ORDER_PUB.Line_Rec_Type
123: := OE_ORDER_PUB.G_MISS_LINE_REC;
124: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
125: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
126: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
127: l_line_count NUMBER;
128: l_queried_quantity NUMBER;
129:
130: CURSOR children is

Line 173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

169: OE_Line_Util.Lock_Row( p_line_id => p_parent_line_id
170: ,p_x_line_rec => l_parent_line_rec
171: ,x_return_status => l_return_status);
172:
173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170: ,p_x_line_rec => l_parent_line_rec
171: ,x_return_status => l_return_status);
172:
173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178:

Line 175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

171: ,x_return_status => l_return_status);
172:
173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178:
179: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN

Line 176: RAISE FND_API.G_EXC_ERROR;

172:
173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178:
179: IF l_item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN
180: l_model_actual_ship_date := l_parent_line_rec.actual_shipment_date;

Line 189: IF l_new_quantity <> FND_API.G_MISS_NUM THEN

185: -- Query to get header_id and order_qty is removed
186: l_header_id := l_parent_line_rec.header_id;
187: l_queried_quantity := l_parent_line_rec.ordered_quantity;
188:
189: IF l_new_quantity <> FND_API.G_MISS_NUM THEN
190: IF l_debug_level > 0 THEN
191: OE_DEBUG_PUB.Add('New Quantity is not missing');
192: END IF;
193: l_new_quantity := l_queried_quantity;

Line 312: IF nvl(l_project_id, -1) <> FND_API.G_MISS_NUM THEN

308:
309:
310: -- 2. project and task.
311:
312: IF nvl(l_project_id, -1) <> FND_API.G_MISS_NUM THEN
313: l_line_tbl(I).project_id := l_project_id;
314: IF l_debug_level > 0 THEN
315: oe_debug_pub.add('PROJECT_ID CASCADED, L_LINE_TBL (I).LINE_ID: '
316: || L_PROJECT_ID , 2 );

Line 320: IF nvl(l_task_id, -1) <> FND_API.G_MISS_NUM THEN

316: || L_PROJECT_ID , 2 );
317: END IF;
318: END IF;
319:
320: IF nvl(l_task_id, -1) <> FND_API.G_MISS_NUM THEN
321: l_line_tbl(I).task_id := l_task_id;
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add('TASK_ID CASCADED FOR,L_LINE_TBL (I).LINE_ID: '
324: || L_TASK_ID , 2 );

Line 331: IF nvl(l_ship_tolerance_above, -1) <> FND_API.G_MISS_NUM THEN

327:
328:
329: -- 3. ship_tolerance_above and below
330:
331: IF nvl(l_ship_tolerance_above, -1) <> FND_API.G_MISS_NUM THEN
332: l_line_tbl(I).ship_tolerance_above := l_ship_tolerance_above;
333: END IF;
334:
335: IF nvl(l_ship_tolerance_below, -1) <> FND_API.G_MISS_NUM THEN

Line 335: IF nvl(l_ship_tolerance_below, -1) <> FND_API.G_MISS_NUM THEN

331: IF nvl(l_ship_tolerance_above, -1) <> FND_API.G_MISS_NUM THEN
332: l_line_tbl(I).ship_tolerance_above := l_ship_tolerance_above;
333: END IF;
334:
335: IF nvl(l_ship_tolerance_below, -1) <> FND_API.G_MISS_NUM THEN
336: l_line_tbl(I).ship_tolerance_below := l_ship_tolerance_below;
337: END IF;
338:
339:

Line 342: IF nvl(l_ship_quantity, -1) <> FND_API.G_MISS_NUM THEN

338:
339:
340: -- 4. shipped_quantity and actual_shipment_date
341:
342: IF nvl(l_ship_quantity, -1) <> FND_API.G_MISS_NUM THEN
343: IF l_line_tbl(I).shipped_quantity is null THEN
344: l_line_tbl(I).shipped_quantity :=
345: (l_line_tbl(I).ordered_quantity / l_model_qty) * l_ship_quantity;
346: l_line_tbl(I).actual_shipment_date := l_model_actual_ship_date;

Line 360: IF nvl(l_ship_to_org_id, -1)<> FND_API.G_MISS_NUM THEN

356:
357:
358: -- 5. ship_to_org_id and request_date
359:
360: IF nvl(l_ship_to_org_id, -1)<> FND_API.G_MISS_NUM THEN
361: l_line_tbl(I).ship_to_org_id := l_ship_to_org_id;
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add('SHIP TO CASCADED , LINE_ID: '
364: || L_SHIP_TO_ORG_ID , 2 );

Line 368: IF nvl(l_request_date, sysdate) <> FND_API.G_MISS_DATE THEN

364: || L_SHIP_TO_ORG_ID , 2 );
365: END IF;
366: END IF;
367:
368: IF nvl(l_request_date, sysdate) <> FND_API.G_MISS_DATE THEN
369: l_line_tbl(I).request_date := l_request_date;
370: IF l_debug_level > 0 THEN
371: oe_debug_pub.add('REQUEST_DATE CASCADED , REQUEST_DATE: '
372: || L_REQUEST_DATE , 2 );

Line 378: IF nvl(p_request_rec.param15, 'X')<> FND_API.G_MISS_CHAR THEN

374: END IF;
375:
376: -- 6. source_type_code for ato configurations.
377:
378: IF nvl(p_request_rec.param15, 'X')<> FND_API.G_MISS_CHAR THEN
379: l_line_tbl(I).source_type_code := p_request_rec.param15;
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add('SOURCE_TYPE CASCADED: '
382: || P_REQUEST_REC.PARAM15 , 2 );

Line 390: IF nvl(l_freight_terms_code, 'X')<> FND_API.G_MISS_CHAR THEN

386:
387: /* Added the following logic to fix the bug 2217336 */
388: -- 7. freight_terms_code for ato configurations.
389:
390: IF nvl(l_freight_terms_code, 'X')<> FND_API.G_MISS_CHAR THEN
391: l_line_tbl(I).freight_terms_code := l_freight_terms_code ;
392: IF l_debug_level > 0 THEN
393: oe_debug_pub.add('FREIGHT_TERMS_CODE CASCADED: '
394: || L_FREIGHT_TERMS_CODE , 2 );

Line 400: IF nvl(l_promise_date, sysdate) <> FND_API.G_MISS_DATE THEN

396: END IF;
397:
398: -- 8. Promise date
399:
400: IF nvl(l_promise_date, sysdate) <> FND_API.G_MISS_DATE THEN
401: l_line_tbl(I).promise_date := l_promise_date;
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add('PROMISE DATE OCASCADED , PROMISE_DATE: '
404: || L_PROMISE_DATE , 2 );

Line 464: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

460:
461: -- Call OE_Order_PVT.Process_order
462:
463: OE_ORDER_PVT.Lines
464: (p_validation_level => FND_API.G_VALID_LEVEL_NONE
465: ,p_control_rec => l_control_rec
466: ,p_x_line_tbl => l_line_tbl
467: ,p_x_old_line_tbl => l_old_line_tbl
468: ,x_return_status => l_return_status);

Line 487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

483: -- 4504362
484: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
485: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
486:
487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
485: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
486:
487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:

Line 489: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

485: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
486:
487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: -- process_order call successful, and this was decrement to 0.

Line 490: RAISE FND_API.G_EXC_ERROR;

486:
487: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: -- process_order call successful, and this was decrement to 0.
494: IF l_set_zero = 'Y' THEN

Line 508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

504: Unlock_Config(p_line_rec => l_parent_line_rec,
505: x_return_status => l_return_status);
506:
507: oe_debug_pub.add('After calling Unlock_Config for parent line ' || l_return_status , 3 );
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

505: x_return_status => l_return_status);
506:
507: oe_debug_pub.add('After calling Unlock_Config for parent line ' || l_return_status , 3 );
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513: END IF;

Line 510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

506:
507: oe_debug_pub.add('After calling Unlock_Config for parent line ' || l_return_status , 3 );
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513: END IF;
514: -- Instance Unlocking

Line 511: RAISE FND_API.G_EXC_ERROR;

507: oe_debug_pub.add('After calling Unlock_Config for parent line ' || l_return_status , 3 );
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513: END IF;
514: -- Instance Unlocking
515:

Line 548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

544: ,x_return_status => l_return_status
545: ,p_line_tbl => l_line_tbl
546: ,p_old_line_tbl => l_old_line_tbl);
547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;

Line 549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

545: ,p_line_tbl => l_line_tbl
546: ,p_old_line_tbl => l_old_line_tbl);
547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553: END IF;

Line 550: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

546: ,p_old_line_tbl => l_old_line_tbl);
547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553: END IF;
554:

Line 551: RAISE FND_API.G_EXC_ERROR;

547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553: END IF;
554:
555: x_return_status := l_return_status;

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

626: := OE_ORDER_PUB.G_MISS_LINE_REC;
627: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
628: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
629:
630: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
631:
632: CURSOR configuration_line(p_header_id IN NUMBER,
633: p_top_model_line_id IN NUMBER,
634: p_ato_line_id IN NUMBER,

Line 665: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

661: OE_LINE_UTIL.Lock_Row(p_line_id => p_request_rec.param1,
662: p_x_line_rec => l_changed_line_rec,
663: x_return_status => l_return_status);
664:
665: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;

Line 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662: p_x_line_rec => l_changed_line_rec,
663: x_return_status => l_return_status);
664:
665: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:

Line 667: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

663: x_return_status => l_return_status);
664:
665: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: l_line_id := l_changed_line_rec.line_id;

Line 668: RAISE FND_API.G_EXC_ERROR;

664:
665: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: l_line_id := l_changed_line_rec.line_id;
672: l_header_id := l_changed_line_rec.header_id;

Line 758: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

754: || L_LINE_TBL.COUNT , 2 );
755: END IF;
756:
757: OE_ORDER_PVT.Lines
758: (p_validation_level => FND_API.G_VALID_LEVEL_NONE
759: ,p_control_rec => l_control_rec
760: ,p_x_line_tbl => l_line_tbl
761: ,p_x_old_line_tbl => l_old_line_tbl
762: ,x_return_status => l_return_status);

Line 779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

775:
776: -- ReSet recursion mode.
777: --OE_GLOBALS.G_RECURSION_MODE := 'N';
778:
779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;

Line 780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

776: -- ReSet recursion mode.
777: --OE_GLOBALS.G_RECURSION_MODE := 'N';
778:
779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784:

Line 781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

777: --OE_GLOBALS.G_RECURSION_MODE := 'N';
778:
779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784:
785: -- added for 2653505

Line 782: RAISE FND_API.G_EXC_ERROR;

778:
779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784:
785: -- added for 2653505
786: IF OE_CODE_CONTROL.get_code_release_level < '110508' THEN

Line 794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

790: ,x_return_status => l_return_status
791: ,p_line_tbl => l_line_tbl
792: ,p_old_line_tbl => l_old_line_tbl);
793:
794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: END IF;

Line 795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

791: ,p_line_tbl => l_line_tbl
792: ,p_old_line_tbl => l_old_line_tbl);
793:
794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: END IF;
799: END IF;

Line 796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

792: ,p_old_line_tbl => l_old_line_tbl);
793:
794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: END IF;
799: END IF;
800:

Line 797: RAISE FND_API.G_EXC_ERROR;

793:
794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
797: RAISE FND_API.G_EXC_ERROR;
798: END IF;
799: END IF;
800:
801: -- Setting G_CASCADING_REQUEST_LOGGED to requery the lines in the form

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

826: := OE_ORDER_PUB.G_MISS_LINE_REC;
827: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
828: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
829:
830: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
831: l_msg_count NUMBER;
832: l_msg_data VARCHAR2(2000);
833:
834: l_line_num VARCHAR2(20);

Line 849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

845: OE_LINE_UTIL.Lock_Row(p_line_id => p_line_id
846: ,p_x_line_rec => l_line_rec
847: ,x_return_status => l_return_status);
848:
849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846: ,p_x_line_rec => l_line_rec
847: ,x_return_status => l_return_status);
848:
849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:

Line 851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

847: ,x_return_status => l_return_status);
848:
849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: IF l_debug_level > 0 THEN

Line 852: RAISE FND_API.G_EXC_ERROR;

848:
849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: IF l_debug_level > 0 THEN
856: oe_debug_pub.add('ENTERING OE_CONGIG_UTIL.DELINK_CONFIG' , 1);

Line 897: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

893: , p_mode => 'GET_STATUS'
894: , x_po_status_rec => l_po_status_rec
895: , x_return_status => l_return_status);
896:
897: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
898: l_autorization_status := l_po_status_rec.authorization_status(1);
899:
900: IF l_debug_level > 0 THEN
901: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);

Line 904: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

900: IF l_debug_level > 0 THEN
901: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
902: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
903: END IF;
904: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;

Line 905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

901: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
902: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
903: END IF;
904: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:

Line 906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

902: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
903: END IF;
904: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: END IF;

Line 907: RAISE FND_API.G_EXC_ERROR;

903: END IF;
904: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: END IF;
911:

Line 960: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

956: oe_debug_pub.add('L_RETURN_STATUS IS: ' || L_RETURN_STATUS , 2 );
957: END IF;
958:
959: OE_ORDER_PVT.Lines
960: (p_validation_level => FND_API.G_VALID_LEVEL_NONE
961: ,p_control_rec => l_control_rec
962: ,p_x_line_tbl => l_line_tbl
963: ,p_x_old_line_tbl => l_old_line_tbl
964: ,x_return_status => l_return_status);

Line 968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

964: ,x_return_status => l_return_status);
965:
966:
967: -- count and get
968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add('STATUS:' || L_RETURN_STATUS , 3 );
971: END IF;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add('STATUS:' || L_RETURN_STATUS , 3 );
971: END IF;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('STATUS:' || L_RETURN_STATUS , 3 );
976: END IF;

Line 973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add('STATUS:' || L_RETURN_STATUS , 3 );
971: END IF;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('STATUS:' || L_RETURN_STATUS , 3 );
976: END IF;
977: RAISE FND_API.G_EXC_ERROR;

Line 977: RAISE FND_API.G_EXC_ERROR;

973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('STATUS:' || L_RETURN_STATUS , 3 );
976: END IF;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979:
980: -- Call Notify OC, required ****************************
981:

Line 989: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

985: ,x_return_status => l_return_status
986: ,p_line_tbl => l_line_tbl
987: ,p_old_line_tbl => l_old_line_tbl);
988:
989: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;

Line 990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

986: ,p_line_tbl => l_line_tbl
987: ,p_old_line_tbl => l_old_line_tbl);
988:
989: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:

Line 991: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

987: ,p_old_line_tbl => l_old_line_tbl);
988:
989: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:
995: oe_msg_pub.count_and_get

Line 992: RAISE FND_API.G_EXC_ERROR;

988:
989: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:
995: oe_msg_pub.count_and_get
996: ( p_count => l_msg_count

Line 1000: x_return_status := FND_API.G_RET_STS_SUCCESS;

996: ( p_count => l_msg_count
997: ,p_data => l_msg_data );
998:
999: -- if everything is OK.
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001:
1002: IF l_debug_level > 0 THEN
1003: oe_debug_pub.add('IN OE_CONFIG_UTI.DELINK , X_RETURN_STATUS'
1004: ||X_RETURN_STATUS , 2 );

Line 1009: WHEN FND_API.G_EXC_ERROR THEN

1005: oe_debug_pub.add('EXITING OE_CONGIG_UTIL.DELINK_CONFIG' , 1);
1006: END IF;
1007:
1008: EXCEPTION
1009: WHEN FND_API.G_EXC_ERROR THEN
1010:
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: -- Get message count and data
1013: oe_msg_pub.count_and_get

Line 1011: x_return_status := FND_API.G_RET_STS_ERROR;

1007:
1008: EXCEPTION
1009: WHEN FND_API.G_EXC_ERROR THEN
1010:
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: -- Get message count and data
1013: oe_msg_pub.count_and_get
1014: ( p_count => l_msg_count
1015: , p_data => l_msg_data

Line 1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1014: ( p_count => l_msg_count
1015: , p_data => l_msg_data
1016: );
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019:
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: -- Get message count and data
1022: oe_msg_pub.count_and_get

Line 1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1016: );
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019:
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: -- Get message count and data
1022: oe_msg_pub.count_and_get
1023: ( p_count => l_msg_count
1024: , p_data => l_msg_data

Line 1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1041: oe_msg_pub.count_and_get
1042: ( p_count => l_msg_count
1043: , p_data => l_msg_data
1044: );
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046:
1047: END Delink_Config;
1048:
1049:

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

1056: FUNCTION Validate_Cfgs_In_Order(p_header_id IN NUMBER)
1057: RETURN VARCHAR2
1058: IS
1059: l_line_id number := null;
1060: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1061: l_valid_config VARCHAR2(10);
1062: l_complete_config VARCHAR2(10);
1063:
1064: -- Instance locking changes

Line 1117: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1113: x_return_status => l_return_status);
1114:
1115: -- if the valid or complete flag is false, we error out.
1116:
1117: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1118: --get_transaction_id(p_caller => 'after call to validate_cfgs');
1119: RETURN l_return_status ;
1120: ELSE
1121: IF LOWER(l_valid_config) = 'false' OR

Line 1126: RETURN FND_API.G_RET_STS_ERROR;

1122: LOWER(l_complete_config) = 'false' THEN
1123: IF l_debug_level > 0 THEN
1124: oe_debug_pub.add('RETURN_STATUS SUCCESS,BUT INVALID/INCOMPLETE',2);
1125: END IF;
1126: RETURN FND_API.G_RET_STS_ERROR;
1127: END IF;
1128: END IF;
1129:
1130: -- Instance locking

Line 1178: p_init_msg_list => FND_API.G_TRUE,

1174: p_source_line_ref1 => Null,
1175: p_source_line_ref2 => Null,
1176: p_source_line_ref3 => Null,
1177: p_commit => 'N',
1178: p_init_msg_list => FND_API.G_TRUE,
1179: p_validation_level => Null,
1180: x_locking_key => l_locking_key,
1181: x_return_status => l_return_status,
1182: x_msg_count => l_msg_count,

Line 1192: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1188: IF l_msg_count > 0 THEN
1189: OE_MSG_PUB.Transfer_Msg_stack;
1190:
1191: END IF;
1192: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1193: RETURN l_return_status;
1194: END IF;
1195:
1196: END IF; -- Container

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

1220: FUNCTION Freeze_Inc_Items_for_Order(p_header_id IN NUMBER)
1221: RETURN VARCHAR2
1222: IS
1223: l_line_id NUMBER;
1224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1225:
1226: CURSOR order_lines is
1227: SELECT line_id
1228: FROM oe_order_lines

Line 1255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1251: l_return_status := Oe_Config_Util.Process_included_items
1252: ( p_line_id => l_line_id
1253: ,p_freeze => TRUE);
1254:
1255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1256: RETURN l_return_status ;
1257: END IF;
1258: END LOOP;
1259:

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

1398: l_booked_flag VARCHAR2(1) := 'N';
1399: l_model_qty NUMBER;
1400: l_msg_count NUMBER;
1401: l_msg_data VARCHAR2(2000);
1402: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1403: l_result_out VARCHAR2(30);
1404: l_options_tbl
1405: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type;
1406: -- input xml message

Line 1420: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;

1416: l_return_status_del VARCHAR2(1);
1417:
1418: -- cz_verify output
1419: l_any_insert NUMBER := 0;
1420: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;
1421: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;
1422: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;
1423: --
1424: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1421: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;

1417:
1418: -- cz_verify output
1419: l_any_insert NUMBER := 0;
1420: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;
1421: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;
1422: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;
1423: --
1424: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1425: --

Line 1422: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;

1418: -- cz_verify output
1419: l_any_insert NUMBER := 0;
1420: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;
1421: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;
1422: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;
1423: --
1424: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1425: --
1426: BEGIN

Line 1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1439: FROM OE_ORDER_LINES
1440: WHERE line_id = p_model_line_id;
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END;
1445:
1446: l_booked_flag := nvl(l_booked_flag, 'N');
1447: l_upgraded_flag := nvl(l_upgraded_flag, 'N');

Line 1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1466: x_valid_config => l_valid_config,
1467: x_complete_config => l_complete_config,
1468: x_return_status => l_return_status);
1469:
1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1471: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1472: OE_Msg_Pub.Add;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1469:
1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1471: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1472: OE_Msg_Pub.Add;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1476: OE_Msg_Pub.Add;
1477: RAISE FND_API.G_EXC_ERROR;

Line 1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1471: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1472: OE_Msg_Pub.Add;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1476: OE_Msg_Pub.Add;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;

Line 1477: RAISE FND_API.G_EXC_ERROR;

1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_UPGARDE_ERROR');
1476: OE_Msg_Pub.Add;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480: IF l_debug_level > 0 THEN
1481: oe_debug_pub.add('CONFIGURAION GOT UPGRADED' , 2 );

Line 1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1570: oe_debug_pub.add (' Message Count :'|| l_msg_count,2);
1571: oe_debug_pub.add (' Message Data :'|| l_msg_data,2);
1572: END IF;
1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1571: oe_debug_pub.add (' Message Data :'|| l_msg_data,2);
1572: END IF;
1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:

Line 1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1572: END IF;
1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:
1580: IF l_exists_flag = FND_API.G_FALSE THEN

Line 1577: RAISE FND_API.G_EXC_ERROR;

1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:
1580: IF l_exists_flag = FND_API.G_FALSE THEN
1581: IF l_debug_level > 0 THEN

Line 1578: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:
1580: IF l_exists_flag = FND_API.G_FALSE THEN
1581: IF l_debug_level > 0 THEN
1582: oe_debug_pub.add('Configuration Does not Exist '|| l_msg_data,2);

Line 1580: IF l_exists_flag = FND_API.G_FALSE THEN

1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:
1580: IF l_exists_flag = FND_API.G_FALSE THEN
1581: IF l_debug_level > 0 THEN
1582: oe_debug_pub.add('Configuration Does not Exist '|| l_msg_data,2);
1583: END IF;
1584: RAISE FND_API.G_EXC_ERROR;

Line 1584: RAISE FND_API.G_EXC_ERROR;

1580: IF l_exists_flag = FND_API.G_FALSE THEN
1581: IF l_debug_level > 0 THEN
1582: oe_debug_pub.add('Configuration Does not Exist '|| l_msg_data,2);
1583: END IF;
1584: RAISE FND_API.G_EXC_ERROR;
1585:
1586: ELSE
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add (' Configuration Exists ',2);

Line 1591: IF l_valid_flag = FND_API.G_FALSE THEN

1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add (' Configuration Exists ',2);
1589: END IF;
1590:
1591: IF l_valid_flag = FND_API.G_FALSE THEN
1592: l_valid_config := 'FALSE';
1593: ELSE
1594: l_valid_config := 'TRUE';
1595: END IF;

Line 1597: IF l_complete_flag = FND_API.G_FALSE THEN

1593: ELSE
1594: l_valid_config := 'TRUE';
1595: END IF;
1596:
1597: IF l_complete_flag = FND_API.G_FALSE THEN
1598: l_complete_config := 'FALSE';
1599: ELSE
1600: IF l_debug_level > 0 THEN
1601: oe_debug_pub.add('Configuration Exists, valid and Complete ',2);

Line 1654: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1650: ('AFTER CALLING SEND_INPUT_XML: '||L_RETURN_STATUS , 2 );
1651: END IF;
1652: --get_transaction_id(p_caller => 'after send_xml');
1653:
1654: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656:
1657: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;

Line 1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1651: END IF;
1652: --get_transaction_id(p_caller => 'after send_xml');
1653:
1654: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656:
1657: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659:

Line 1657: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1653:
1654: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656:
1657: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659:
1660: END IF;
1661:

Line 1658: RAISE FND_API.G_EXC_ERROR;

1654: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656:
1657: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659:
1660: END IF;
1661:
1662:

Line 1687: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1683:
1684: x_valid_config := l_valid_config;
1685: x_complete_config := l_complete_config;
1686:
1687: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1690: RAISE FND_API.G_EXC_ERROR;
1691: END IF;

Line 1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1684: x_valid_config := l_valid_config;
1685: x_complete_config := l_complete_config;
1686:
1687: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1690: RAISE FND_API.G_EXC_ERROR;
1691: END IF;
1692:

Line 1689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1685: x_complete_config := l_complete_config;
1686:
1687: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1690: RAISE FND_API.G_EXC_ERROR;
1691: END IF;
1692:
1693: END IF; -- if skip batch val

Line 1690: RAISE FND_API.G_EXC_ERROR;

1686:
1687: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1690: RAISE FND_API.G_EXC_ERROR;
1691: END IF;
1692:
1693: END IF; -- if skip batch val
1694:

Line 1732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1728: x_msg_count => l_msg_count,
1729: x_msg_data => l_msg_data,
1730: x_return_status => l_return_status);
1731:
1732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1733: THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1736: THEN

Line 1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1730: x_return_status => l_return_status);
1731:
1732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1733: THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1736: THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF;

Line 1735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1731:
1732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1733: THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1736: THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF;
1739: END IF;

Line 1737: RAISE FND_API.G_EXC_ERROR;

1733: THEN
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1736: THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF;
1739: END IF;
1740:
1741:

Line 1764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1760: oe_debug_pub.add('AFTER CALL TO PROCESS_CONFIG: '
1761: ||L_RETURN_STATUS , 2 );
1762: END IF;
1763:
1764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1765: IF l_debug_level > 0 THEN
1766: oe_debug_pub.add('PROCESS CONFIG UNEXPECTED ERROR' , 2 );
1767: END IF;
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1765: IF l_debug_level > 0 THEN
1766: oe_debug_pub.add('PROCESS CONFIG UNEXPECTED ERROR' , 2 );
1767: END IF;
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769:
1770: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add('PROCESS CONFIG EXEC ERROR' , 2 );

Line 1770: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1766: oe_debug_pub.add('PROCESS CONFIG UNEXPECTED ERROR' , 2 );
1767: END IF;
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769:
1770: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add('PROCESS CONFIG EXEC ERROR' , 2 );
1773: END IF;
1774: RAISE FND_API.G_EXC_ERROR;

Line 1774: RAISE FND_API.G_EXC_ERROR;

1770: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add('PROCESS CONFIG EXEC ERROR' , 2 );
1773: END IF;
1774: RAISE FND_API.G_EXC_ERROR;
1775:
1776: END IF;
1777:
1778: -- If you are here, things went off OK ! So return success

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

1818: l_change_flag VARCHAR2(1);
1819: l_item_type_code VARCHAR2(30);
1820: l_model_component VARCHAR2(1000);
1821: l_req_rec OE_Order_Pub.Request_Rec_Type;
1822: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1823: l_msg_count NUMBER;
1824: l_msg_data VARCHAR2(2000);
1825:
1826: --

Line 1847: x_return_status := FND_API.G_RET_STS_ERROR;

1843: IF l_debug_level > 0 THEN
1844: OE_DEBUG_PUB.Add('Line is top container, hence not allowed',3);
1845: END IF;
1846:
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NOT_IN_OPTIONS_WINDOW');
1849: OE_MSG_PUB.Add;
1850: RETURN;
1851: END IF;

Line 1856: l_return_status := FND_API.G_RET_STS_SUCCESS;

1852:
1853: END IF;
1854:
1855:
1856: l_return_status := FND_API.G_RET_STS_SUCCESS;
1857:
1858: OE_Process_Options_Pvt.Get_Options_From_DB
1859: ( p_top_model_line_id => p_model_line_id
1860: ,p_get_model_line => TRUE

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

1980: l_ratio NUMBER;
1981: l_req_rec OE_Order_Pub.Request_Rec_Type;
1982: l_deleted_options_tbl OE_Order_PUB.request_tbl_type
1983: := p_deleted_options_tbl;
1984: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1985: l_qty NUMBER := 1;
1986: --
1987: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1988: --

Line 2033: WHEN FND_API.G_EXC_ERROR THEN

2029: END IF;
2030: p_x_options_tbl(l_index).operation := OE_GLOBALS.G_OPR_DELETE;
2031:
2032: EXCEPTION
2033: WHEN FND_API.G_EXC_ERROR THEN
2034: IF l_debug_level > 0 THEN
2035: oe_debug_pub.add('COMPONENT NOT PRESENT' , 1);
2036: END IF;
2037: RAISE;

Line 2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2121: IF p_model_component is NULL THEN
2122: IF l_debug_level > 0 THEN
2123: oe_debug_pub.add('MODEL COMPONENT IS NULL' , 1);
2124: END IF;
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;
2127:
2128: IF l_debug_level > 0 THEN
2129: oe_debug_pub.add('OPTION/CLASS/KIT IS DELETED' , 1);

Line 2276: RAISE FND_API.G_EXC_ERROR;

2272: oe_debug_pub.add('OPERATION IS INSERT IN PROCEDURE DELETE_CHILDREN');
2273: oe_debug_pub.add('parent class : ' || p_parent_item);
2274: oe_debug_pub.add('child item : ' || p_x_options_tbl(I).ordered_item);
2275: END IF;
2276: RAISE FND_API.G_EXC_ERROR;
2277: END IF;
2278: END IF;
2279: I := p_x_options_tbl.NEXT(I);
2280: END LOOP;

Line 2319: RAISE FND_API.G_EXC_ERROR;

2315: oe_debug_pub.add('ENTERING DELETE_PARENT' , 1);
2316: END IF;
2317:
2318: IF p_model_component is NULL THEN
2319: RAISE FND_API.G_EXC_ERROR;
2320: END IF;
2321:
2322:
2323: IF p_component_code = p_model_component THEN

Line 2428: RAISE FND_API.G_EXC_ERROR;

2424: oe_debug_pub.add('ENTERING PROPOGATE_CHANGE_TO_PARENT' , 1);
2425: END IF;
2426:
2427: IF p_model_component is NULL THEN
2428: RAISE FND_API.G_EXC_ERROR;
2429: END IF;
2430:
2431:
2432: IF p_component_code = p_model_component THEN

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

2653: l_use_configurator BOOLEAN;
2654: l_configurator_was_used NUMBER;
2655: l_msg_count NUMBER;
2656: l_msg_data VARCHAR2(2000);
2657: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
2658: l_order_source_id NUMBER;
2659: l_orig_sys_document_ref VARCHAR2(50);
2660: l_orig_sys_line_ref VARCHAR2(50);
2661: l_orig_sys_shipment_ref VARCHAR2(50);

Line 2677: x_return_status := FND_API.G_RET_STS_SUCCESS;

2673: END IF;
2674:
2675:
2676: -- No Copy Changes. Initialized return status to success
2677: x_return_status := FND_API.G_RET_STS_SUCCESS;
2678:
2679:
2680: --get_transaction_id(p_caller => 'inside validate_config');
2681:

Line 2695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2691: FROM OE_ORDER_LINES_ALL
2692: WHERE line_id = p_model_line_id;
2693: EXCEPTION
2694: WHEN OTHERS THEN
2695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2696: END;
2697:
2698: OE_Msg_Pub.Set_Msg_Context
2699: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

Line 2786: x_return_status:= FND_API.G_RET_STS_ERROR;

2782:
2783: IF l_configurator_was_used <> 0 AND l_use_configurator THEN
2784: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_USE_OPTIONS_WINDOW');
2785: OE_Msg_Pub.Add;
2786: x_return_status:= FND_API.G_RET_STS_ERROR;
2787: END IF;
2788:
2789: IF l_configurator_was_used <> 1 AND NOT (l_use_configurator) THEN
2790: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_USE_CONFIGURATOR');

Line 2792: x_return_status:= FND_API.G_RET_STS_ERROR;

2788:
2789: IF l_configurator_was_used <> 1 AND NOT (l_use_configurator) THEN
2790: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_USE_CONFIGURATOR');
2791: OE_Msg_Pub.Add;
2792: x_return_status:= FND_API.G_RET_STS_ERROR;
2793: END IF;
2794:
2795: --get_transaction_id(p_caller => ' leaving validate_config');
2796:

Line 2809: WHEN FND_API.G_EXC_ERROR THEN

2805: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.VALIDATE_CONFIGURATION' , 1);
2806: END IF;
2807: EXCEPTION
2808:
2809: WHEN FND_API.G_EXC_ERROR THEN
2810: x_return_status := FND_API.G_RET_STS_ERROR;
2811: --get_transaction_id(p_caller => 'exc error in validate_config');
2812:
2813:

Line 2810: x_return_status := FND_API.G_RET_STS_ERROR;

2806: END IF;
2807: EXCEPTION
2808:
2809: WHEN FND_API.G_EXC_ERROR THEN
2810: x_return_status := FND_API.G_RET_STS_ERROR;
2811: --get_transaction_id(p_caller => 'exc error in validate_config');
2812:
2813:
2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2810: x_return_status := FND_API.G_RET_STS_ERROR;
2811: --get_transaction_id(p_caller => 'exc error in validate_config');
2812:
2813:
2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2816: --get_transaction_id(p_caller => 'unxp error in validate_config');
2817:
2818:

Line 2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2811: --get_transaction_id(p_caller => 'exc error in validate_config');
2812:
2813:
2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2816: --get_transaction_id(p_caller => 'unxp error in validate_config');
2817:
2818:
2819: WHEN OTHERS THEN

Line 2824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2820: IF l_debug_level > 0 THEN
2821: oe_debug_pub.add('ERROR IN VALIDATE_CONFIGURATION : '
2822: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);
2823: END IF;
2824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2825:
2826: END Validate_Configuration;
2827:
2828:

Line 2891: FND_API.G_RET_STS_SUCCESS;

2887: l_rec_index BINARY_INTEGER;
2888: l_xml_hdr VARCHAR2(2000);
2889: l_long_xml LONG := NULL;
2890: l_return_status VARCHAR2(1) :=
2891: FND_API.G_RET_STS_SUCCESS;
2892: I NUMBER;
2893: --
2894: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2895: --

Line 2931: RAISE FND_API.G_EXC_ERROR;

2927: WHEN NO_DATA_FOUND THEN
2928: l_send_model_flag := 'N';
2929:
2930: WHEN OTHERS THEN
2931: RAISE FND_API.G_EXC_ERROR;
2932: END;
2933:
2934:
2935: IF l_send_model_flag = 'Y' THEN

Line 3158: RAISE FND_API.G_EXC_ERROR;

3154: IF l_validation_status <> 0 THEN
3155: IF l_debug_level > 0 THEN
3156: oe_debug_pub.add('DO NOT PROCESS RESULTS , ERROR ',1);
3157: END IF;
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160:
3161: IF (l_html_pieces.COUNT <= 0) THEN
3162: IF l_debug_level > 0 THEN

Line 3165: RAISE FND_API.G_EXC_ERROR;

3161: IF (l_html_pieces.COUNT <= 0) THEN
3162: IF l_debug_level > 0 THEN
3163: oe_debug_pub.add('HTML_PIECES COUNT IS <= 0' , 2 );
3164: END IF;
3165: RAISE FND_API.G_EXC_ERROR;
3166: END IF;
3167:
3168:
3169: l_rec_index := l_html_pieces.FIRST;

Line 3192: WHEN FND_API.G_EXC_ERROR THEN

3188: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.SEND_INPUT_XML' , 1);
3189: END IF;
3190:
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: --get_transaction_id
3194: --(p_caller => 'send_xml exc error, before call to SPC validate');
3195:
3196: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3196: x_return_status := FND_API.G_RET_STS_ERROR;

3192: WHEN FND_API.G_EXC_ERROR THEN
3193: --get_transaction_id
3194: --(p_caller => 'send_xml exc error, before call to SPC validate');
3195:
3196: x_return_status := FND_API.G_RET_STS_ERROR;
3197: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');
3198: OE_Msg_Pub.Add;
3199:
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3196: x_return_status := FND_API.G_RET_STS_ERROR;
3197: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');
3198: OE_Msg_Pub.Add;
3199:
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3201: --get_transaction_id
3202: --(p_caller => 'send_xml unxp, before call to SPC validate');
3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3204: IF l_debug_level > 0 THEN

Line 3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3199:
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3201: --get_transaction_id
3202: --(p_caller => 'send_xml unxp, before call to SPC validate');
3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3204: IF l_debug_level > 0 THEN
3205: oe_debug_pub.add('AN UNEXP ERROR RAISED' , 1);
3206: END IF;
3207:

Line 3218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3214: WHEN OTHERS THEN
3215: --get_transaction_id
3216: --(p_caller=> 'send_xml others error, before call to SPC validate');
3217:
3218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3219:
3220: IF l_debug_level > 0 THEN
3221: oe_debug_pub.add
3222: ('SEND_INPUT_XML ERROR: ' || SUBSTR ( SQLERRM , 1 , 100 ) , 1);

Line 3277: := FND_API.G_RET_STS_SUCCESS;

3273: l_xml_hdr VARCHAR2(2000):=
3274: '';
3275: l_dummy VARCHAR2(500) := NULL;
3276: l_return_status VARCHAR2(1)
3277: := FND_API.G_RET_STS_SUCCESS;
3278:
3279: l_config_effective_date DATE;
3280: l_old_behavior VARCHAR2(1);
3281: l_frozen_model_bill VARCHAR2(1);

Line 3542: FND_API.G_RET_STS_SUCCESS;

3538: l_valid_config VARCHAR2(10);
3539: l_complete_config VARCHAR2(10);
3540: l_header_id NUMBER;
3541: l_return_status VARCHAR2(1) :=
3542: FND_API.G_RET_STS_SUCCESS;
3543: l_return_status_del VARCHAR2(1);
3544: l_msg VARCHAR2(2000);
3545: l_constraint VARCHAR2(16);
3546: l_flag VARCHAR2(1) := 'N';

Line 3734: RAISE FND_API.G_EXC_ERROR;

3730: ( p_config_hdr_id => l_config_header_id
3731: ,p_config_rev_nbr => l_config_rev_nbr
3732: ,x_return_status => l_return_status_del);
3733:
3734: RAISE FND_API.G_EXC_ERROR;
3735: END IF;
3736:
3737:
3738: -- if everything ok, set return values

Line 3751: WHEN FND_API.G_EXC_ERROR THEN

3747: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.PARSE_OUTPUT_XML' , 1);
3748: END IF;
3749:
3750: EXCEPTION
3751: WHEN FND_API.G_EXC_ERROR THEN
3752: x_return_status := FND_API.G_RET_STS_ERROR;
3753: IF l_debug_level > 0 THEN
3754: oe_debug_pub.add('SPC EXIT TAG IS ERROR' , 1);
3755: END IF;

Line 3752: x_return_status := FND_API.G_RET_STS_ERROR;

3748: END IF;
3749:
3750: EXCEPTION
3751: WHEN FND_API.G_EXC_ERROR THEN
3752: x_return_status := FND_API.G_RET_STS_ERROR;
3753: IF l_debug_level > 0 THEN
3754: oe_debug_pub.add('SPC EXIT TAG IS ERROR' , 1);
3755: END IF;
3756:

Line 3758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3754: oe_debug_pub.add('SPC EXIT TAG IS ERROR' , 1);
3755: END IF;
3756:
3757: WHEN OTHERS THEN
3758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3759: IF l_debug_level > 0 THEN
3760: oe_debug_pub.add('PARSE_OUTPUT_XML ERROR: '
3761: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);
3762: END IF;

Line 3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3904: END IF;
3905:
3906: EXCEPTION
3907: WHEN OTHERS THEN
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3909: END;
3910:
3911:
3912: /*----------------------------------------------------------------------

Line 3980: RAISE FND_API.G_EXC_ERROR;

3976: oe_msg_pub.add_text(p_message_text => x_msg_data);
3977:
3978: END IF;
3979:
3980: RAISE FND_API.G_EXC_ERROR;
3981: END IF;
3982:
3983:
3984: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3984: x_return_status := FND_API.G_RET_STS_SUCCESS;

3980: RAISE FND_API.G_EXC_ERROR;
3981: END IF;
3982:
3983:
3984: x_return_status := FND_API.G_RET_STS_SUCCESS;
3985: IF l_debug_level > 0 THEN
3986: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.EXPLODE' , 1);
3987: END IF;
3988:

Line 3990: WHEN FND_API.G_EXC_ERROR THEN

3986: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.EXPLODE' , 1);
3987: END IF;
3988:
3989: EXCEPTION
3990: WHEN FND_API.G_EXC_ERROR THEN
3991: x_return_status := FND_API.G_RET_STS_ERROR;
3992: END Explode;
3993:
3994: /*----------------------------------------------------------------------

Line 3991: x_return_status := FND_API.G_RET_STS_ERROR;

3987: END IF;
3988:
3989: EXCEPTION
3990: WHEN FND_API.G_EXC_ERROR THEN
3991: x_return_status := FND_API.G_RET_STS_ERROR;
3992: END Explode;
3993:
3994: /*----------------------------------------------------------------------
3995: Procedure Name : Query_Included_Item

Line 4019: , p_header_id IN NUMBER := FND_API.G_MISS_NUM

4015: parent line.
4016: -----------------------------------------------------------------------*/
4017: PROCEDURE Query_Included_Items
4018: ( p_line_id IN NUMBER
4019: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
4020: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
4021: , p_send_cancel_lines IN VARCHAR2 := 'N'
4022: , p_source_type IN VARCHAR2 := ''
4023: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

Line 4020: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM

4016: -----------------------------------------------------------------------*/
4017: PROCEDURE Query_Included_Items
4018: ( p_line_id IN NUMBER
4019: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
4020: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
4021: , p_send_cancel_lines IN VARCHAR2 := 'N'
4022: , p_source_type IN VARCHAR2 := ''
4023: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
4024: IS

Line 4049: IF p_header_id = FND_API.G_MISS_NUM AND

4045: IF l_debug_level > 0 THEN
4046: oe_debug_pub.add('SEND_CANCEL_LINES: '|| P_SEND_CANCEL_LINES , 3 );
4047: END IF;
4048:
4049: IF p_header_id = FND_API.G_MISS_NUM AND
4050: p_top_model_line_id = FND_API.G_MISS_NUM THEN
4051:
4052: BEGIN
4053: SELECT top_model_line_id ,header_id

Line 4050: p_top_model_line_id = FND_API.G_MISS_NUM THEN

4046: oe_debug_pub.add('SEND_CANCEL_LINES: '|| P_SEND_CANCEL_LINES , 3 );
4047: END IF;
4048:
4049: IF p_header_id = FND_API.G_MISS_NUM AND
4050: p_top_model_line_id = FND_API.G_MISS_NUM THEN
4051:
4052: BEGIN
4053: SELECT top_model_line_id ,header_id
4054: INTO l_top_model_line_id,l_header_id

Line 4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4098: END IF;
4099:
4100: EXCEPTION
4101: WHEN OTHERS THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: END Query_Included_Items;
4104:
4105: -- forward declaration
4106:

Line 4164: p_line_id IN NUMBER := FND_API.G_MISS_NUM,

4160: -----------------------------------------------------------------------*/
4161: FUNCTION Process_Included_Items
4162: (p_line_rec IN OE_ORDER_PUB.line_rec_type
4163: := OE_ORDER_PUB.G_MISS_LINE_REC,
4164: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
4165: p_freeze IN BOOLEAN,
4166: p_process_requests IN BOOLEAN DEFAULT FALSE)
4167: RETURN VARCHAR2
4168: IS

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

4173: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4174: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
4175: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4176:
4177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4178: l_msg_count NUMBER;
4179: l_msg_data VARCHAR2(2000);
4180:
4181: -- procedure variables

Line 4291: IF p_line_rec.line_id <> FND_API.G_MISS_NUM AND

4287: Print_Time('Entering oe_config_util.process_included_items');
4288:
4289: l_parent_line_rec := p_line_rec;
4290:
4291: IF p_line_rec.line_id <> FND_API.G_MISS_NUM AND
4292: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4293: IF l_debug_level > 0 THEN
4294: oe_debug_pub.add('DO NOT LOCK' , 3 );
4295: END IF;

Line 4297: IF p_line_id = FND_API.G_MISS_NUM THEN

4293: IF l_debug_level > 0 THEN
4294: oe_debug_pub.add('DO NOT LOCK' , 3 );
4295: END IF;
4296: ELSE
4297: IF p_line_id = FND_API.G_MISS_NUM THEN
4298: OE_LINE_UTIL.Lock_Row
4299: (p_line_id => p_line_rec.line_id
4300: ,p_x_line_rec => l_parent_line_rec
4301: ,x_return_status => l_return_status);

Line 4395: l_return_status := FND_API.G_RET_STS_SUCCESS;

4391:
4392: IF l_freeze_macd_kit THEN
4393:
4394: l_explosion_date := sysdate;
4395: l_return_status := FND_API.G_RET_STS_SUCCESS;
4396: GOTO UPDATE_EXP_DATE;
4397:
4398: END IF;
4399: l_validation_org := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 4417: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4413: x_msg_data => l_msg_data,
4414: x_error_code => l_error_code,
4415: x_return_status => l_return_status);
4416:
4417: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4420: RAISE FND_API.G_EXC_ERROR;
4421: END IF;

Line 4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4414: x_error_code => l_error_code,
4415: x_return_status => l_return_status);
4416:
4417: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4420: RAISE FND_API.G_EXC_ERROR;
4421: END IF;
4422:

Line 4419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4415: x_return_status => l_return_status);
4416:
4417: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4420: RAISE FND_API.G_EXC_ERROR;
4421: END IF;
4422:
4423:

Line 4420: RAISE FND_API.G_EXC_ERROR;

4416:
4417: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4420: RAISE FND_API.G_EXC_ERROR;
4421: END IF;
4422:
4423:
4424: BEGIN

Line 4447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4443: IF l_debug_level > 0 THEN
4444: oe_debug_pub.add
4445: ('UNEXPECTED ERROR WHILE GETTING BILL SEQUENCE ID' , 3 );
4446: END IF;
4447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4448: END;
4449:
4450: BEGIN
4451: SELECT max(component_number)

Line 4458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4454: WHERE link_to_line_id = p_line_id
4455: AND top_model_line_id = l_parent_line_rec.top_model_line_id;
4456: EXCEPTION
4457: WHEN OTHERS THEN
4458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4459: END;
4460:
4461: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4462:

Line 4510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4506: (p_parent_line_rec => l_parent_line_rec,
4507: p_x_child_line_rec => l_line_rec,
4508: x_return_status => l_return_status);
4509:
4510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: END IF;

Line 4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4507: p_x_child_line_rec => l_line_rec,
4508: x_return_status => l_return_status);
4509:
4510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: END IF;
4515:

Line 4512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4508: x_return_status => l_return_status);
4509:
4510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: END IF;
4515:
4516: l_default_child_line := FALSE;

Line 4513: RAISE FND_API.G_EXC_ERROR;

4509:
4510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4513: RAISE FND_API.G_EXC_ERROR;
4514: END IF;
4515:
4516: l_default_child_line := FALSE;
4517:

Line 4534: RAISE FND_API.G_EXC_ERROR;

4530: WHEN NO_DATA_FOUND THEN
4531: IF l_debug_level > 0 THEN
4532: oe_debug_pub.add('CANCAT SEG FETCH ERROR' , 3 );
4533: END IF;
4534: RAISE FND_API.G_EXC_ERROR;
4535: END;
4536:
4537: IF l_debug_level > 0 THEN
4538: oe_debug_pub.add('ORD ITEM IS: ' || L_LINE_REC.ORDERED_ITEM , 5 );

Line 4702: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

4698: l_control_rec.check_security := FALSE;
4699: l_control_rec.change_attributes := FALSE;
4700:
4701: OE_ORDER_PVT.Lines
4702: (p_validation_level => FND_API.G_VALID_LEVEL_NONE
4703: ,p_control_rec => l_control_rec
4704: ,p_x_line_tbl => l_line_tbl
4705: ,p_x_old_line_tbl => l_old_line_tbl
4706: ,x_return_status => l_return_status);

Line 4708: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4704: ,p_x_line_tbl => l_line_tbl
4705: ,p_x_old_line_tbl => l_old_line_tbl
4706: ,x_return_status => l_return_status);
4707:
4708: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;

Line 4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4705: ,p_x_old_line_tbl => l_old_line_tbl
4706: ,x_return_status => l_return_status);
4707:
4708: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713:

Line 4710: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4706: ,x_return_status => l_return_status);
4707:
4708: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713:
4714:

Line 4711: RAISE FND_API.G_EXC_ERROR;

4707:
4708: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713:
4714:
4715: Log_Included_Item_Requests

Line 4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4724: ,p_line_tbl => l_line_tbl
4725: ,p_old_line_tbl => l_old_line_tbl);
4726:
4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;

Line 4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4725: ,p_old_line_tbl => l_old_line_tbl);
4726:
4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;
4733:

Line 4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4726:
4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;
4733:
4734:

Line 4731: RAISE FND_API.G_EXC_ERROR;

4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;
4733:
4734:
4735: IF l_adjust_comp_no_flag = 'Y' THEN

Line 4764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4760: lock_control = lock_control + 1
4761: WHERE line_id = l_parent_line_rec.line_id;
4762: EXCEPTION
4763: WHEN OTHERS THEN
4764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4765: END;
4766: END IF;
4767:
4768:

Line 4774: WHEN FND_API.G_EXC_ERROR THEN

4770:
4771: RETURN l_return_status;
4772:
4773: EXCEPTION
4774: WHEN FND_API.G_EXC_ERROR THEN
4775: -- bug 4683857
4776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4777: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');
4778: END IF;

Line 4779: RETURN FND_API.G_RET_STS_ERROR;

4775: -- bug 4683857
4776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4777: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');
4778: END IF;
4779: RETURN FND_API.G_RET_STS_ERROR;
4780:
4781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4783: THEN

Line 4781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4777: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Process_Included_Items');
4778: END IF;
4779: RETURN FND_API.G_RET_STS_ERROR;
4780:
4781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4783: THEN
4784: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4785: END IF;

Line 4786: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

4782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4783: THEN
4784: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4785: END IF;
4786: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4787: WHEN OTHERS THEN
4788: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4789: THEN
4790: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');

Line 4792: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

4788: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4789: THEN
4790: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Process_Included_Items');
4791: END IF;
4792: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
4793: END Process_Included_Items;
4794:
4795:
4796: /*----------------------------------------------------------------------

Line 4839: x_return_status := FND_API.G_RET_STS_SUCCESS;

4835: WHERE line_id = l_line_id;
4836:
4837: END LOOP;
4838:
4839: x_return_status := FND_API.G_RET_STS_SUCCESS;
4840:
4841: IF l_debug_level > 0 THEN
4842: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.UPDATE_COMPONENT_NUMBER' , 1);
4843: END IF;

Line 4847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4843: END IF;
4844:
4845: EXCEPTION
4846: WHEN OTHERS THEN
4847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4848: END update_component_number;
4849:
4850: /*----------------------------------------------------------------------
4851: Procedure Name : Supply_Reserved

Line 4896: := FND_API.G_MISS_NUM ,

4892: Description :
4893: -----------------------------------------------------------------------*/
4894: FUNCTION Is_ATO_Model
4895: (p_line_id IN NUMBER
4896: := FND_API.G_MISS_NUM ,
4897: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4898: := OE_ORDER_PUB.G_MISS_LINE_REC)
4899: RETURN BOOLEAN
4900: IS

Line 4912: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

4908: oe_debug_pub.add('ENTERING IS_ATO_MODEL FUNCTION ' , 1);
4909: END IF;
4910:
4911: -- if p_line_rec.line_id is missing, query row
4912: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
4913: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4914:
4915: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4916: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 4915: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

4911: -- if p_line_rec.line_id is missing, query row
4912: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
4913: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4914:
4915: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4916: IF p_line_id <> FND_API.G_MISS_NUM THEN
4917: OE_Line_Util.Query_Row(p_line_id => p_line_id
4918: ,x_line_rec => l_line_rec);
4919: ELSE

Line 4916: IF p_line_id <> FND_API.G_MISS_NUM THEN

4912: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
4913: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4914:
4915: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4916: IF p_line_id <> FND_API.G_MISS_NUM THEN
4917: OE_Line_Util.Query_Row(p_line_id => p_line_id
4918: ,x_line_rec => l_line_rec);
4919: ELSE
4920: RAISE FND_API.G_EXC_ERROR;

Line 4920: RAISE FND_API.G_EXC_ERROR;

4916: IF p_line_id <> FND_API.G_MISS_NUM THEN
4917: OE_Line_Util.Query_Row(p_line_id => p_line_id
4918: ,x_line_rec => l_line_rec);
4919: ELSE
4920: RAISE FND_API.G_EXC_ERROR;
4921: END IF;
4922: ELSE
4923: l_line_rec := p_line_rec;
4924: END IF;

Line 4961: := FND_API.G_MISS_NUM ,

4957: Description :
4958: -----------------------------------------------------------------------*/
4959: FUNCTION Is_PTO_Model
4960: (p_line_id IN NUMBER
4961: := FND_API.G_MISS_NUM ,
4962: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
4963: := OE_ORDER_PUB.G_MISS_LINE_REC)
4964: RETURN BOOLEAN
4965: IS

Line 4978: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

4974: oe_debug_pub.add('ENTERING IS_PTO_MODEL FUNCTION ' , 1);
4975: END IF;
4976:
4977: -- if p_line_rec.line_id is missing, query row
4978: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
4979: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4980:
4981: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4982: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 4981: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

4977: -- if p_line_rec.line_id is missing, query row
4978: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
4979: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4980:
4981: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4982: IF p_line_id <> FND_API.G_MISS_NUM THEN
4983: OE_Line_Util.Query_Row(p_line_id => p_line_id
4984: ,x_line_rec => l_line_rec);
4985: ELSE

Line 4982: IF p_line_id <> FND_API.G_MISS_NUM THEN

4978: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
4979: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4980:
4981: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4982: IF p_line_id <> FND_API.G_MISS_NUM THEN
4983: OE_Line_Util.Query_Row(p_line_id => p_line_id
4984: ,x_line_rec => l_line_rec);
4985: ELSE
4986: RAISE FND_API.G_EXC_ERROR;

Line 4986: RAISE FND_API.G_EXC_ERROR;

4982: IF p_line_id <> FND_API.G_MISS_NUM THEN
4983: OE_Line_Util.Query_Row(p_line_id => p_line_id
4984: ,x_line_rec => l_line_rec);
4985: ELSE
4986: RAISE FND_API.G_EXC_ERROR;
4987: END IF;
4988: ELSE
4989: l_line_rec := p_line_rec;
4990: END IF;

Line 5026: := FND_API.G_MISS_NUM ,

5022: -----------------------------------------------------------------------*/
5023:
5024: FUNCTION Is_Included_Option
5025: (p_line_id IN NUMBER
5026: := FND_API.G_MISS_NUM ,
5027: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5028: := OE_ORDER_PUB.G_MISS_LINE_REC)
5029: RETURN BOOLEAN
5030: IS

Line 5043: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5039: oe_debug_pub.add('ENTERING IS_INCLUDED_OPTION FUNCTION ' , 1);
5040: END IF;
5041:
5042: -- if p_line_rec.line_id is missing, query row
5043: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5044: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5045:
5046: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5047: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5046: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5042: -- if p_line_rec.line_id is missing, query row
5043: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5044: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5045:
5046: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5047: IF p_line_id <> FND_API.G_MISS_NUM THEN
5048: OE_Line_Util.Query_Row(p_line_id => p_line_id
5049: ,x_line_rec => l_line_rec);
5050: ELSE

Line 5047: IF p_line_id <> FND_API.G_MISS_NUM THEN

5043: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5044: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5045:
5046: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5047: IF p_line_id <> FND_API.G_MISS_NUM THEN
5048: OE_Line_Util.Query_Row(p_line_id => p_line_id
5049: ,x_line_rec => l_line_rec);
5050: ELSE
5051: RAISE FND_API.G_EXC_ERROR;

Line 5051: RAISE FND_API.G_EXC_ERROR;

5047: IF p_line_id <> FND_API.G_MISS_NUM THEN
5048: OE_Line_Util.Query_Row(p_line_id => p_line_id
5049: ,x_line_rec => l_line_rec);
5050: ELSE
5051: RAISE FND_API.G_EXC_ERROR;
5052: END IF;
5053: ELSE
5054: l_line_rec := p_line_rec;
5055: END IF;

Line 5089: := FND_API.G_MISS_NUM ,

5085: Description :
5086: -----------------------------------------------------------------------*/
5087: FUNCTION Is_Config_Item
5088: (p_line_id IN NUMBER
5089: := FND_API.G_MISS_NUM ,
5090: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5091: := OE_ORDER_PUB.G_MISS_LINE_REC)
5092: RETURN BOOLEAN
5093: IS

Line 5106: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5102: oe_debug_pub.add('ENTERING IS_CONFIG_ITEM FUNCTION ' , 1);
5103: END IF;
5104:
5105: -- if p_line_rec.line_id is missing, query row
5106: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5107: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5108:
5109: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5110: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5109: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5105: -- if p_line_rec.line_id is missing, query row
5106: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5107: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5108:
5109: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5110: IF p_line_id <> FND_API.G_MISS_NUM THEN
5111: OE_Line_Util.Query_Row(p_line_id => p_line_id
5112: ,x_line_rec => l_line_rec);
5113: ELSE

Line 5110: IF p_line_id <> FND_API.G_MISS_NUM THEN

5106: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5107: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5108:
5109: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5110: IF p_line_id <> FND_API.G_MISS_NUM THEN
5111: OE_Line_Util.Query_Row(p_line_id => p_line_id
5112: ,x_line_rec => l_line_rec);
5113: ELSE
5114: RAISE FND_API.G_EXC_ERROR;

Line 5114: RAISE FND_API.G_EXC_ERROR;

5110: IF p_line_id <> FND_API.G_MISS_NUM THEN
5111: OE_Line_Util.Query_Row(p_line_id => p_line_id
5112: ,x_line_rec => l_line_rec);
5113: ELSE
5114: RAISE FND_API.G_EXC_ERROR;
5115: END IF;
5116: ELSE
5117: l_line_rec := p_line_rec;
5118: END IF;

Line 5152: := FND_API.G_MISS_NUM ,

5148: Description :
5149: -----------------------------------------------------------------------*/
5150: FUNCTION Is_ATO_Option
5151: (p_line_id IN NUMBER
5152: := FND_API.G_MISS_NUM ,
5153: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5154: := OE_ORDER_PUB.G_MISS_LINE_REC)
5155: RETURN BOOLEAN
5156: IS

Line 5169: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5165: oe_debug_pub.add('ENTERING IS_ATO_OPTION FUNCTION ' , 1);
5166: END IF;
5167:
5168: -- if p_line_rec.line_id is missing, query row
5169: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5170: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5171:
5172: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5173: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5172: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5168: -- if p_line_rec.line_id is missing, query row
5169: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5170: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5171:
5172: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5173: IF p_line_id <> FND_API.G_MISS_NUM THEN
5174: OE_Line_Util.Query_Row(p_line_id => p_line_id
5175: ,x_line_rec => l_line_rec);
5176: ELSE

Line 5173: IF p_line_id <> FND_API.G_MISS_NUM THEN

5169: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5170: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5171:
5172: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5173: IF p_line_id <> FND_API.G_MISS_NUM THEN
5174: OE_Line_Util.Query_Row(p_line_id => p_line_id
5175: ,x_line_rec => l_line_rec);
5176: ELSE
5177: RAISE FND_API.G_EXC_ERROR;

Line 5177: RAISE FND_API.G_EXC_ERROR;

5173: IF p_line_id <> FND_API.G_MISS_NUM THEN
5174: OE_Line_Util.Query_Row(p_line_id => p_line_id
5175: ,x_line_rec => l_line_rec);
5176: ELSE
5177: RAISE FND_API.G_EXC_ERROR;
5178: END IF;
5179: ELSE
5180: l_line_rec := p_line_rec;
5181: END IF;

Line 5219: := FND_API.G_MISS_NUM ,

5215: Description :
5216: -----------------------------------------------------------------------*/
5217: FUNCTION Is_PTO_Option
5218: (p_line_id IN NUMBER
5219: := FND_API.G_MISS_NUM ,
5220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5221: := OE_ORDER_PUB.G_MISS_LINE_REC)
5222: RETURN BOOLEAN
5223: IS

Line 5236: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5232: oe_debug_pub.add('ENTERING IS_PTO_OPTION FUNCTION ' , 1);
5233: END IF;
5234:
5235: -- if p_line_rec.line_id is missing, query row
5236: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5237: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5238:
5239: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5240: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5239: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5235: -- if p_line_rec.line_id is missing, query row
5236: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5237: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5238:
5239: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5240: IF p_line_id <> FND_API.G_MISS_NUM THEN
5241: OE_Line_Util.Query_Row(p_line_id => p_line_id
5242: ,x_line_rec => l_line_rec);
5243: ELSE

Line 5240: IF p_line_id <> FND_API.G_MISS_NUM THEN

5236: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5237: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5238:
5239: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5240: IF p_line_id <> FND_API.G_MISS_NUM THEN
5241: OE_Line_Util.Query_Row(p_line_id => p_line_id
5242: ,x_line_rec => l_line_rec);
5243: ELSE
5244: RAISE FND_API.G_EXC_ERROR;

Line 5244: RAISE FND_API.G_EXC_ERROR;

5240: IF p_line_id <> FND_API.G_MISS_NUM THEN
5241: OE_Line_Util.Query_Row(p_line_id => p_line_id
5242: ,x_line_rec => l_line_rec);
5243: ELSE
5244: RAISE FND_API.G_EXC_ERROR;
5245: END IF;
5246: ELSE
5247: l_line_rec := p_line_rec;
5248: END IF;

Line 5282: := FND_API.G_MISS_NUM ,

5278: Description :
5279: -----------------------------------------------------------------------*/
5280: FUNCTION Is_ATO_Class
5281: (p_line_id IN NUMBER
5282: := FND_API.G_MISS_NUM ,
5283: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5284: := OE_ORDER_PUB.G_MISS_LINE_REC)
5285: RETURN BOOLEAN
5286: IS

Line 5299: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5295: oe_debug_pub.add('ENTERING IS_ATO_CLASS FUNCTION ' , 1);
5296: END IF;
5297:
5298: -- if p_line_rec.line_id is missing, query row
5299: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5300: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5301:
5302: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5303: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5302: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5298: -- if p_line_rec.line_id is missing, query row
5299: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5300: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5301:
5302: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5303: IF p_line_id <> FND_API.G_MISS_NUM THEN
5304: OE_Line_Util.Query_Row(p_line_id => p_line_id
5305: ,x_line_rec => l_line_rec);
5306: ELSE

Line 5303: IF p_line_id <> FND_API.G_MISS_NUM THEN

5299: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5300: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5301:
5302: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5303: IF p_line_id <> FND_API.G_MISS_NUM THEN
5304: OE_Line_Util.Query_Row(p_line_id => p_line_id
5305: ,x_line_rec => l_line_rec);
5306: ELSE
5307: RAISE FND_API.G_EXC_ERROR;

Line 5307: RAISE FND_API.G_EXC_ERROR;

5303: IF p_line_id <> FND_API.G_MISS_NUM THEN
5304: OE_Line_Util.Query_Row(p_line_id => p_line_id
5305: ,x_line_rec => l_line_rec);
5306: ELSE
5307: RAISE FND_API.G_EXC_ERROR;
5308: END IF;
5309: ELSE
5310: l_line_rec := p_line_rec;
5311: END IF;

Line 5348: := FND_API.G_MISS_NUM ,

5344: Description :
5345: -----------------------------------------------------------------------*/
5346: FUNCTION Is_PTO_Class
5347: (p_line_id IN NUMBER
5348: := FND_API.G_MISS_NUM ,
5349: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5350: := OE_ORDER_PUB.G_MISS_LINE_REC)
5351: RETURN BOOLEAN
5352: IS

Line 5365: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5361: oe_debug_pub.add('ENTERING IS_PTO_CLASS FUNCTION ' , 1);
5362: END IF;
5363:
5364: -- if p_line_rec.line_id is missing, query row
5365: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5366: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5367:
5368: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5369: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5368: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5364: -- if p_line_rec.line_id is missing, query row
5365: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5366: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5367:
5368: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5369: IF p_line_id <> FND_API.G_MISS_NUM THEN
5370: OE_Line_Util.Query_Row(p_line_id => p_line_id
5371: ,x_line_rec => l_line_rec);
5372: ELSE

Line 5369: IF p_line_id <> FND_API.G_MISS_NUM THEN

5365: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5366: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5367:
5368: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5369: IF p_line_id <> FND_API.G_MISS_NUM THEN
5370: OE_Line_Util.Query_Row(p_line_id => p_line_id
5371: ,x_line_rec => l_line_rec);
5372: ELSE
5373: RAISE FND_API.G_EXC_ERROR;

Line 5373: RAISE FND_API.G_EXC_ERROR;

5369: IF p_line_id <> FND_API.G_MISS_NUM THEN
5370: OE_Line_Util.Query_Row(p_line_id => p_line_id
5371: ,x_line_rec => l_line_rec);
5372: ELSE
5373: RAISE FND_API.G_EXC_ERROR;
5374: END IF;
5375: ELSE
5376: l_line_rec := p_line_rec;
5377: END IF;

Line 5412: := FND_API.G_MISS_NUM ,

5408: Description :
5409: -----------------------------------------------------------------------*/
5410: FUNCTION Is_ATO_Subconfig
5411: (p_line_id IN NUMBER
5412: := FND_API.G_MISS_NUM ,
5413: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5414: := OE_ORDER_PUB.G_MISS_LINE_REC)
5415: RETURN BOOLEAN
5416: IS

Line 5429: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5425: oe_debug_pub.add('ENTERING IS_ATO_SUBCONFIG FUNCTION ' , 1);
5426: END IF;
5427:
5428: -- if p_line_rec.line_id is missing, query row
5429: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5430: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5431:
5432: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5433: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5432: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5428: -- if p_line_rec.line_id is missing, query row
5429: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5430: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5431:
5432: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5433: IF p_line_id <> FND_API.G_MISS_NUM THEN
5434: OE_Line_Util.Query_Row(p_line_id => p_line_id
5435: ,x_line_rec => l_line_rec);
5436: ELSE

Line 5433: IF p_line_id <> FND_API.G_MISS_NUM THEN

5429: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5430: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5431:
5432: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5433: IF p_line_id <> FND_API.G_MISS_NUM THEN
5434: OE_Line_Util.Query_Row(p_line_id => p_line_id
5435: ,x_line_rec => l_line_rec);
5436: ELSE
5437: RAISE FND_API.G_EXC_ERROR;

Line 5437: RAISE FND_API.G_EXC_ERROR;

5433: IF p_line_id <> FND_API.G_MISS_NUM THEN
5434: OE_Line_Util.Query_Row(p_line_id => p_line_id
5435: ,x_line_rec => l_line_rec);
5436: ELSE
5437: RAISE FND_API.G_EXC_ERROR;
5438: END IF;
5439: ELSE
5440: l_line_rec := p_line_rec;
5441: END IF;

Line 5478: := FND_API.G_MISS_NUM ,

5474: Description :
5475: -----------------------------------------------------------------------*/
5476: FUNCTION Is_Kit
5477: (p_line_id IN NUMBER
5478: := FND_API.G_MISS_NUM ,
5479: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5480: := OE_ORDER_PUB.G_MISS_LINE_REC)
5481: RETURN BOOLEAN
5482: IS

Line 5495: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5491: oe_debug_pub.add('ENTERING IS_KIT FUNCTION ' , 1);
5492: END IF;
5493:
5494: -- if p_line_rec.line_id is missing, query row
5495: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5496: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5497:
5498: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5499: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5498: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5494: -- if p_line_rec.line_id is missing, query row
5495: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5496: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5497:
5498: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5499: IF p_line_id <> FND_API.G_MISS_NUM THEN
5500: OE_Line_Util.Query_Row(p_line_id => p_line_id
5501: ,x_line_rec => l_line_rec);
5502: ELSE

Line 5499: IF p_line_id <> FND_API.G_MISS_NUM THEN

5495: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5496: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5497:
5498: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5499: IF p_line_id <> FND_API.G_MISS_NUM THEN
5500: OE_Line_Util.Query_Row(p_line_id => p_line_id
5501: ,x_line_rec => l_line_rec);
5502: ELSE
5503: RAISE FND_API.G_EXC_ERROR;

Line 5503: RAISE FND_API.G_EXC_ERROR;

5499: IF p_line_id <> FND_API.G_MISS_NUM THEN
5500: OE_Line_Util.Query_Row(p_line_id => p_line_id
5501: ,x_line_rec => l_line_rec);
5502: ELSE
5503: RAISE FND_API.G_EXC_ERROR;
5504: END IF;
5505: ELSE
5506: l_line_rec := p_line_rec;
5507: END IF;

Line 5540: := FND_API.G_MISS_NUM ,

5536: Description :
5537: -----------------------------------------------------------------------*/
5538: FUNCTION Is_Ato_Item
5539: (p_line_id IN NUMBER
5540: := FND_API.G_MISS_NUM ,
5541: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
5542: := OE_ORDER_PUB.G_MISS_LINE_REC)
5543: RETURN BOOLEAN
5544: IS

Line 5557: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR

5553: oe_debug_pub.add('ENTERING IS_ATO_ITEM FUNCTION ' , 1);
5554: END IF;
5555:
5556: -- if p_line_rec.line_id is missing, query row
5557: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5558: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5559:
5560: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5561: IF p_line_id <> FND_API.G_MISS_NUM THEN

Line 5560: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN

5556: -- if p_line_rec.line_id is missing, query row
5557: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5558: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5559:
5560: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5561: IF p_line_id <> FND_API.G_MISS_NUM THEN
5562: OE_Line_Util.Query_Row(p_line_id => p_line_id
5563: ,x_line_rec => l_line_rec);
5564: ELSE

Line 5561: IF p_line_id <> FND_API.G_MISS_NUM THEN

5557: -- if p_line_id and and p_line_rec both missing, RAISE FND_API.G_EXC_ERROR
5558: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5559:
5560: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5561: IF p_line_id <> FND_API.G_MISS_NUM THEN
5562: OE_Line_Util.Query_Row(p_line_id => p_line_id
5563: ,x_line_rec => l_line_rec);
5564: ELSE
5565: RAISE FND_API.G_EXC_ERROR;

Line 5565: RAISE FND_API.G_EXC_ERROR;

5561: IF p_line_id <> FND_API.G_MISS_NUM THEN
5562: OE_Line_Util.Query_Row(p_line_id => p_line_id
5563: ,x_line_rec => l_line_rec);
5564: ELSE
5565: RAISE FND_API.G_EXC_ERROR;
5566: END IF;
5567: ELSE
5568: l_line_rec := p_line_rec;
5569: END IF;

Line 5608: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM

5604: in that configuration bu only ato options/included items of that line
5605: ---------------------------------------------------------------------*/
5606:
5607: PROCEDURE Query_Config
5608: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
5609: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
5610: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5611: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5612: IS

Line 5609: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM

5605: ---------------------------------------------------------------------*/
5606:
5607: PROCEDURE Query_Config
5608: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
5609: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
5610: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5611: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5612: IS
5613: l_line_rec OE_Order_PUB.Line_Rec_Type

Line 5610: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM

5606:
5607: PROCEDURE Query_Config
5608: ( p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM
5609: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
5610: , p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM
5611: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
5612: IS
5613: l_line_rec OE_Order_PUB.Line_Rec_Type
5614: := OE_Order_PUB.G_MISS_LINE_REC;

Line 5644: p_link_to_line_id <> FND_API.G_MISS_NUM) THEN

5640: l_top_model_line_id := p_top_model_line_id;
5641:
5642: BEGIN
5643: IF (p_link_to_line_id is not null and
5644: p_link_to_line_id <> FND_API.G_MISS_NUM) THEN
5645: ll_line_id := p_link_to_line_id;
5646: ELSIF (p_top_model_line_id is not null and
5647: p_top_model_line_id <> FND_API.G_MISS_NUM) THEN
5648: ll_line_id := p_top_model_line_id;

Line 5647: p_top_model_line_id <> FND_API.G_MISS_NUM) THEN

5643: IF (p_link_to_line_id is not null and
5644: p_link_to_line_id <> FND_API.G_MISS_NUM) THEN
5645: ll_line_id := p_link_to_line_id;
5646: ELSIF (p_top_model_line_id is not null and
5647: p_top_model_line_id <> FND_API.G_MISS_NUM) THEN
5648: ll_line_id := p_top_model_line_id;
5649: ELSIF (p_ato_line_id is not null and
5650: p_ato_line_id <> FND_API.G_MISS_NUM) THEN
5651: ll_line_id := p_ato_line_id;

Line 5650: p_ato_line_id <> FND_API.G_MISS_NUM) THEN

5646: ELSIF (p_top_model_line_id is not null and
5647: p_top_model_line_id <> FND_API.G_MISS_NUM) THEN
5648: ll_line_id := p_top_model_line_id;
5649: ELSIF (p_ato_line_id is not null and
5650: p_ato_line_id <> FND_API.G_MISS_NUM) THEN
5651: ll_line_id := p_ato_line_id;
5652: ELSE
5653: ll_line_id := 0;
5654: END IF;

Line 5666: IF p_ato_line_id <> FND_API.G_MISS_NUM OR

5662: WHEN OTHERS THEN
5663: l_header_id:=0;
5664: END;
5665:
5666: IF p_ato_line_id <> FND_API.G_MISS_NUM OR
5667: p_link_to_line_id <> FND_API.G_MISS_NUM THEN
5668: l_top_model_line_id := NULL;
5669: END IF;
5670:

Line 5667: p_link_to_line_id <> FND_API.G_MISS_NUM THEN

5663: l_header_id:=0;
5664: END;
5665:
5666: IF p_ato_line_id <> FND_API.G_MISS_NUM OR
5667: p_link_to_line_id <> FND_API.G_MISS_NUM THEN
5668: l_top_model_line_id := NULL;
5669: END IF;
5670:
5671: IF l_debug_level > 0 THEN

Line 5700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5696: oe_debug_pub.add('NO_DATA_FOUND IN QUERY_CONFIG' , 1);
5697: END IF;
5698: RAISE NO_DATA_FOUND;
5699:
5700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5701: IF l_debug_level > 0 THEN
5702: oe_debug_pub.add('EXC_UNXP IN QUERY_CONFIG' , 1);
5703: END IF;
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5701: IF l_debug_level > 0 THEN
5702: oe_debug_pub.add('EXC_UNXP IN QUERY_CONFIG' , 1);
5703: END IF;
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705:
5706: WHEN OTHERS THEN
5707:
5708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 5719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5715: , 'Query_Config'
5716: );
5717: END IF;
5718:
5719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5720: END Query_Config;
5721:
5722:
5723: /*------------------------------------------------------------

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

5760: PROCEDURE Complete_Configuration
5761: (p_top_model_line_id IN NUMBER,
5762: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5763: IS
5764: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5765: l_sort_order VARCHAR2(2000); -- 4336446
5766: l_uom_code VARCHAR2(3);
5767: l_model_seq_id NUMBER;
5768: l_model_comp_seq_id NUMBER;

Line 5821: RAISE FND_API.G_EXC_ERROR;

5817: WHEN OTHERS THEN
5818: IF l_debug_level > 0 THEN
5819: oe_debug_pub.add('EXCEPTION IN SELECT' , 1);
5820: END IF;
5821: RAISE FND_API.G_EXC_ERROR;
5822: END;
5823:
5824:
5825: -- Explode the options in Bom_Explosions

Line 5851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5847: IF l_debug_level > 0 THEN
5848: oe_debug_pub.add('AFTER CALL TO EXPLODE: '|| L_RETURN_STATUS , 2 );
5849: END IF;
5850:
5851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5854: RAISE FND_API.G_EXC_ERROR;
5855: END IF;

Line 5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5848: oe_debug_pub.add('AFTER CALL TO EXPLODE: '|| L_RETURN_STATUS , 2 );
5849: END IF;
5850:
5851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5854: RAISE FND_API.G_EXC_ERROR;
5855: END IF;
5856:

Line 5853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5849: END IF;
5850:
5851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5854: RAISE FND_API.G_EXC_ERROR;
5855: END IF;
5856:
5857: IF l_model_seq_id is null THEN

Line 5854: RAISE FND_API.G_EXC_ERROR;

5850:
5851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5854: RAISE FND_API.G_EXC_ERROR;
5855: END IF;
5856:
5857: IF l_model_seq_id is null THEN
5858:

Line 5875: RAISE FND_API.G_EXC_ERROR;

5871: WHEN NO_DATA_FOUND THEN
5872: IF l_debug_level > 0 THEN
5873: oe_debug_pub.add('COMPONENT_SEQUENCE_ID QUERY FAILED' , 1);
5874: END IF;
5875: RAISE FND_API.G_EXC_ERROR;
5876: END;
5877:
5878: END IF;
5879:

Line 5938: x_return_status := FND_API.G_RET_STS_ERROR;

5934: oe_debug_pub.add('SELECT COMP_CODE FAILED , NO DATA FOUND ' , 1);
5935: oe_debug_pub.add('ITEM: '|| LINE_REC.INVENTORY_ITEM_ID , 1);
5936: END IF;
5937:
5938: x_return_status := FND_API.G_RET_STS_ERROR;
5939:
5940: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_ITEM_NOT_IN_BILL');
5941: FND_MESSAGE.Set_Token('COMPONENT', nvl(line_rec.ordered_item,line_rec.inventory_item_id));
5942: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_top_item_id));

Line 5952: x_return_status := FND_API.G_RET_STS_ERROR;

5948: oe_debug_pub.add('SELECT COMP_CODE FAILED , TOO_MANY ROWS ' , 1);
5949: oe_debug_pub.add('ITEM: '|| LINE_REC.INVENTORY_ITEM_ID , 1);
5950: END IF;
5951:
5952: x_return_status := FND_API.G_RET_STS_ERROR;
5953:
5954: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_AMBIGUITY');
5955: FND_MESSAGE.Set_Token('COMPONENT', nvl(line_rec.ordered_item,line_rec.inventory_item_id));
5956: FND_MESSAGE.Set_Token('MODEL', nvl(l_model_ordered_item,l_top_item_id));

Line 5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5961: IF l_debug_level > 0 THEN
5962: oe_debug_pub.add('SELECT COMP_CODE FAILED , OTHERS ' , 1);
5963: oe_debug_pub.add('ITEM: '|| LINE_REC.INVENTORY_ITEM_ID , 1);
5964: END IF;
5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5966: END;
5967:
5968: -- now update the oe table
5969: UPDATE oe_order_lines

Line 5979: x_return_status := FND_API.G_RET_STS_SUCCESS;

5975: WHERE line_id = line_rec.line_id;
5976:
5977: END LOOP;
5978:
5979: x_return_status := FND_API.G_RET_STS_SUCCESS;
5980: IF l_debug_level > 0 THEN
5981: oe_debug_pub.add('LEAVING COMPLETE CONFIGURATION' , 1);
5982: END IF;
5983:

Line 5989: x_return_status := FND_API.G_RET_STS_ERROR;

5985: WHEN OTHERS THEN
5986: IF l_debug_level > 0 THEN
5987: oe_debug_pub.add('AMBIGUITY IN BILL'|| SUBSTR ( SQLERRM , 1 , 150 ) , 1);
5988: END IF;
5989: x_return_status := FND_API.G_RET_STS_ERROR;
5990: END Complete_Configuration;
5991:
5992:
5993: /*----------------------------------------------------------------------

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

6026: l_quantity_reserved NUMBER;
6027: l_message_name VARCHAR2(30);
6028: l_error_message VARCHAR2(2000);
6029: l_result BOOLEAN;
6030: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6031: --
6032: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6033: --
6034: BEGIN

Line 6048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6044: WHEN OTHERS THEN
6045: IF l_debug_level > 0 THEN
6046: oe_debug_pub.add('OTHERS IN MATCH AND RESERVE' , 1);
6047: END IF;
6048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6049: END;
6050:
6051:
6052: IF CTO_MATCH_AND_RESERVE.match_inquiry

Line 6107: x_return_status := FND_API.G_RET_STS_ERROR;

6103: WHEN NO_DATA_FOUND THEN
6104: IF l_debug_level > 0 THEN
6105: oe_debug_pub.add('NO DATA FOUND IN MATCH AND RESERVE' , 1);
6106: END IF;
6107: x_return_status := FND_API.G_RET_STS_ERROR;
6108:
6109: WHEN OTHERS THEN
6110: IF l_debug_level > 0 THEN
6111: oe_debug_pub.add('EXCEPTION IN MATCH AND RESERVE' , 1);

Line 6113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6109: WHEN OTHERS THEN
6110: IF l_debug_level > 0 THEN
6111: oe_debug_pub.add('EXCEPTION IN MATCH AND RESERVE' , 1);
6112: END IF;
6113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6114: END Match_and_Reserve;
6115:
6116:
6117: /*----------------------------------------------------------------------

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

6134: l_table_name VARCHAR2(30);
6135: l_cto_result NUMBER;
6136: l_result BOOLEAN;
6137: l_ordered_item VARCHAR2(2000);
6138: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6139:
6140: l_config_header_id NUMBER;
6141: l_config_line_id NUMBER;
6142: l_source_type VARCHAR2(10);

Line 6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6164: WHEN OTHERS THEN
6165: IF l_debug_level > 0 THEN
6166: oe_debug_pub.add('DELINK BATCH ERROR' , 1);
6167: END IF;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END;
6170:
6171: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6172: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND

Line 6223: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6219: , p_mode => 'GET_STATUS'
6220: , x_po_status_rec => l_po_status_rec
6221: , x_return_status => l_return_status);
6222:
6223: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6224: l_autorization_status := l_po_status_rec.authorization_status(1);
6225:
6226: IF l_debug_level > 0 THEN
6227: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);

Line 6230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6226: IF l_debug_level > 0 THEN
6227: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
6228: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
6229: END IF;
6230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE FND_API.G_EXC_ERROR;
6234: END IF;

Line 6231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6227: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
6228: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
6229: END IF;
6230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE FND_API.G_EXC_ERROR;
6234: END IF;
6235:

Line 6232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

6228: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
6229: END IF;
6230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE FND_API.G_EXC_ERROR;
6234: END IF;
6235:
6236: END IF;

Line 6233: RAISE FND_API.G_EXC_ERROR;

6229: END IF;
6230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6233: RAISE FND_API.G_EXC_ERROR;
6234: END IF;
6235:
6236: END IF;
6237:

Line 6304: x_return_status := FND_API.G_RET_STS_ERROR;

6300: WHEN NO_DATA_FOUND THEN
6301: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_NO_ITEM_TO_DELINK');
6302: FND_MESSAGE.Set_Token('MODEL', nvl(l_ordered_item,l_inv_item_id));
6303: oe_msg_pub.add;
6304: x_return_status := FND_API.G_RET_STS_ERROR;
6305:
6306: WHEN OTHERS THEN
6307: IF l_debug_level > 0 THEN
6308: oe_debug_pub.add('EXCEPTION IN DELINK_CONFIG' , 1);

Line 6310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6306: WHEN OTHERS THEN
6307: IF l_debug_level > 0 THEN
6308: oe_debug_pub.add('EXCEPTION IN DELINK_CONFIG' , 1);
6309: END IF;
6310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6311: END Delink_Config_batch;
6312:
6313:
6314: /*----------------------------------------------------------------------

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

6411: l_result BOOLEAN;
6412: l_cto_result NUMBER(38) := 0;
6413: l_ordered_item VARCHAR2(2000);
6414: l_valid NUMBER;
6415: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6416:
6417: --
6418: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6419: --

Line 6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6432: IF l_debug_level > 0 THEN
6433: oe_debug_pub.add('LINK CONFIG ERROR' , 2 );
6434: END IF;
6435: l_valid := 1;
6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6437: END;
6438:
6439: IF (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
6440: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS ) AND

Line 6490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6486: FND_MESSAGE.Set_Name('BOM', 'CTO_INVALID_LINK_ERROR');
6487: OE_Msg_Pub.add;
6488: END IF;
6489:
6490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6491: END Link_Config;
6492:
6493:
6494: /*----------------------------------------------------------------------

Line 6521: x_return_status := FND_API.G_RET_STS_SUCCESS;

6517: ,last_update_login = FND_Global.Login_Id
6518: ,lock_control = lock_control + 1
6519: where line_id = p_line_id;
6520:
6521: x_return_status := FND_API.G_RET_STS_SUCCESS;
6522:
6523: IF l_debug_level > 0 THEN
6524: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.UPDATE_COMP_SEQ_ID' , 1);
6525: END IF;

Line 6532: x_return_status := FND_API.G_RET_STS_ERROR;

6528: WHEN no_data_found THEN
6529: IF l_debug_level > 0 THEN
6530: oe_debug_pub.add('NO_DATA_FOUND IN UPDATE_COMP_SEQ_ID' , 1);
6531: END IF;
6532: x_return_status := FND_API.G_RET_STS_ERROR;
6533:
6534: WHEN others THEN
6535: IF l_debug_level > 0 THEN
6536: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_COMP_SEQ_ID' , 1);

Line 6538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6534: WHEN others THEN
6535: IF l_debug_level > 0 THEN
6536: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_COMP_SEQ_ID' , 1);
6537: END IF;
6538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6539: END Update_Comp_Seq_Id;
6540:
6541:
6542: /*----------------------------------------------------------------------

Line 6569: x_return_status := FND_API.G_RET_STS_SUCCESS;

6565: ,last_update_login = FND_Global.Login_Id
6566: ,lock_control = lock_control + 1
6567: where ato_line_id = p_ato_line_id;
6568:
6569: x_return_status := FND_API.G_RET_STS_SUCCESS;
6570:
6571: IF l_debug_level > 0 THEN
6572: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.UPDATE_VISIBLE_DEMAND_FLAG' , 1);
6573: END IF;

Line 6580: x_return_status := FND_API.G_RET_STS_ERROR;

6576: WHEN no_data_found THEN
6577: IF l_debug_level > 0 THEN
6578: oe_debug_pub.add('NO_DATA_FOUND IN UPDATE_VISIBLE_DEMAND_FLAG' , 1);
6579: END IF;
6580: x_return_status := FND_API.G_RET_STS_ERROR;
6581:
6582: WHEN others THEN
6583: IF l_debug_level > 0 THEN
6584: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_VISIBLE_DEMAND_FLAG' , 1);

Line 6586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6582: WHEN others THEN
6583: IF l_debug_level > 0 THEN
6584: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_VISIBLE_DEMAND_FLAG' , 1);
6585: END IF;
6586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6587: END Update_Visible_Demand_Flag;
6588:
6589:
6590: /*----------------------------------------------------------------------

Line 6617: x_return_status := FND_API.G_RET_STS_SUCCESS;

6613: ,last_update_login = FND_Global.Login_Id
6614: ,lock_control = lock_control + 1
6615: where ato_line_id = p_ato_line_id;
6616:
6617: x_return_status := FND_API.G_RET_STS_SUCCESS;
6618:
6619: IF l_debug_level > 0 THEN
6620: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.UPDATE_MFG_COMP_SEQ_ID' , 1);
6621: END IF;

Line 6628: x_return_status := FND_API.G_RET_STS_ERROR;

6624: WHEN no_data_found THEN
6625: IF l_debug_level > 0 THEN
6626: oe_debug_pub.add('NO_DATA_FOUND IN UPDATE_MFG_COMP_SEQ_ID' , 1);
6627: END IF;
6628: x_return_status := FND_API.G_RET_STS_ERROR;
6629:
6630: WHEN others THEN
6631: IF l_debug_level > 0 THEN
6632: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_MFG_COMP_SEQ_ID' , 1);

Line 6634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6630: WHEN others THEN
6631: IF l_debug_level > 0 THEN
6632: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_MFG_COMP_SEQ_ID' , 1);
6633: END IF;
6634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6635: END Update_Mfg_Comp_Seq_Id;
6636:
6637:
6638: /*----------------------------------------------------------------------

Line 6665: x_return_status := FND_API.G_RET_STS_SUCCESS;

6661: ,last_update_login = FND_Global.Login_Id
6662: ,lock_control = lock_control + 1
6663: where ato_line_id = p_ato_line_id;
6664:
6665: x_return_status := FND_API.G_RET_STS_SUCCESS;
6666:
6667: IF l_debug_level > 0 THEN
6668: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.UPDATE_MODEL_GROUP_NUMBER' , 1);
6669: END IF;

Line 6676: x_return_status := FND_API.G_RET_STS_ERROR;

6672: WHEN no_data_found THEN
6673: IF l_debug_level > 0 THEN
6674: oe_debug_pub.add('NO_DATA_FOUND IN UPDATE_MODEL_GROUP_NUMBER' , 1);
6675: END IF;
6676: x_return_status := FND_API.G_RET_STS_ERROR;
6677:
6678: WHEN others THEN
6679: IF l_debug_level > 0 THEN
6680: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_MODEL_GROUP_NUMBER' , 1);

Line 6682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6678: WHEN others THEN
6679: IF l_debug_level > 0 THEN
6680: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_MODEL_GROUP_NUMBER' , 1);
6681: END IF;
6682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6683: END Update_Model_Group_Number;
6684:
6685:
6686: /*----------------------------------------------------------------------

Line 6719: x_return_status := FND_API.G_RET_STS_SUCCESS;

6715: ,last_update_login = FND_Global.Login_Id
6716: ,lock_control = lock_control + 1
6717: where ato_line_id = p_ato_line_id;
6718:
6719: x_return_status := FND_API.G_RET_STS_SUCCESS;
6720:
6721: IF l_debug_level > 0 THEN
6722: oe_debug_pub.add('EXITING OE_CONFIG_UTIL.UPDATE_CTO_COLUMNS' , 1);
6723: END IF;

Line 6730: x_return_status := FND_API.G_RET_STS_ERROR;

6726: WHEN no_data_found THEN
6727: IF l_debug_level > 0 THEN
6728: oe_debug_pub.add('NO_DATA_FOUND IN UPDATE_CTO_COLUMNS' , 1);
6729: END IF;
6730: x_return_status := FND_API.G_RET_STS_ERROR;
6731:
6732: WHEN others THEN
6733: IF l_debug_level > 0 THEN
6734: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_CTO_COLUMNS' , 1);

Line 6736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6732: WHEN others THEN
6733: IF l_debug_level > 0 THEN
6734: oe_debug_pub.add('OTHERS EXCEPTION IN UPDATE_CTO_COLUMNS' , 1);
6735: END IF;
6736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6737: END Update_Cto_Columns;
6738:
6739:
6740: /*------------------------------------------------------------------

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

6755: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
6756: := OE_Order_Pub.G_MISS_REQUEST_TBL
6757: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6758: IS
6759: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6760: l_msg_count NUMBER;
6761: l_msg_data VARCHAR2(2000);
6762: l_cto_change_tbl CTO_CHANGE_ORDER_PK.CHANGE_TABLE_TYPE;
6763: l_ato_line_id NUMBER := p_ato_line_id;

Line 6943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6939: WHEN OTHERS THEN
6940: IF l_debug_level > 0 THEN
6941: oe_debug_pub.add('EXCEPTION NOTIFY_CTO'|| SQLERRM , 1);
6942: END IF;
6943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6944: END;
6945:
6946:
6947: /*------------------------------------------------------------------

Line 7111: x_return_status := FND_API.G_RET_STS_SUCCESS;

7107: BEGIN
7108: IF l_debug_level > 0 THEN
7109: oe_debug_pub.add('ENTERING DEFAULT_CHILD_LINE' , 1);
7110: END IF;
7111: x_return_status := FND_API.G_RET_STS_SUCCESS;
7112:
7113: IF p_parent_line_rec.header_id is NULL OR
7114: p_parent_line_rec.top_model_line_id is NULL THEN
7115:

Line 7123: x_return_status := FND_API.G_RET_STS_ERROR;

7119: FND_Message.Set_Name('ONT', 'OE_CONFIG_WRONG_MODEL_LINK');
7120: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_x_child_line_rec.ordered_item
7121: ,p_x_child_line_rec.inventory_item_id));
7122: OE_Msg_Pub.add();
7123: x_return_status := FND_API.G_RET_STS_ERROR;
7124: RAISE FND_API.G_EXC_ERROR;
7125: END IF;
7126:
7127: p_x_child_line_rec.shipment_number := p_parent_line_rec.shipment_number;

Line 7124: RAISE FND_API.G_EXC_ERROR;

7120: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_x_child_line_rec.ordered_item
7121: ,p_x_child_line_rec.inventory_item_id));
7122: OE_Msg_Pub.add();
7123: x_return_status := FND_API.G_RET_STS_ERROR;
7124: RAISE FND_API.G_EXC_ERROR;
7125: END IF;
7126:
7127: p_x_child_line_rec.shipment_number := p_parent_line_rec.shipment_number;
7128: p_x_child_line_rec.line_number := p_parent_line_rec.line_number;

Line 7186: p_x_child_line_rec.line_type_id <> FND_API.G_MISS_NUM THEN

7182: p_x_child_line_rec.model_remnant_flag := p_parent_line_rec.model_remnant_flag;
7183:
7184: -- MACD ---------------------------------------------------------------
7185: IF p_x_child_line_rec.line_type_id IS NOT NULL OR
7186: p_x_child_line_rec.line_type_id <> FND_API.G_MISS_NUM THEN
7187:
7188: IF l_debug_level > 0 THEN
7189: OE_DEBUG_PUB.Add('LineTypeID:'||p_x_child_line_rec.line_type_id,3);
7190: OE_DEBUG_PUB.Add('Inventory Item ID (from Parent Line):'

Line 7275: p_x_child_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN

7271: oe_debug_pub.add('COPYING DFF TO CHILD' , 1);
7272: END IF;
7273:
7274: IF p_x_child_line_rec.attribute1 is null OR
7275: p_x_child_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
7276: p_x_child_line_rec.attribute1 := p_parent_line_rec.attribute1;
7277: END IF;
7278:
7279: IF p_x_child_line_rec.attribute2 is null OR

Line 7280: p_x_child_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN

7276: p_x_child_line_rec.attribute1 := p_parent_line_rec.attribute1;
7277: END IF;
7278:
7279: IF p_x_child_line_rec.attribute2 is null OR
7280: p_x_child_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
7281: p_x_child_line_rec.attribute2 := p_parent_line_rec.attribute2;
7282: END IF;
7283:
7284: IF p_x_child_line_rec.attribute3 is null OR

Line 7285: p_x_child_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN

7281: p_x_child_line_rec.attribute2 := p_parent_line_rec.attribute2;
7282: END IF;
7283:
7284: IF p_x_child_line_rec.attribute3 is null OR
7285: p_x_child_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
7286: p_x_child_line_rec.attribute3 := p_parent_line_rec.attribute3;
7287: END IF;
7288:
7289: IF p_x_child_line_rec.attribute4 is null OR

Line 7290: p_x_child_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN

7286: p_x_child_line_rec.attribute3 := p_parent_line_rec.attribute3;
7287: END IF;
7288:
7289: IF p_x_child_line_rec.attribute4 is null OR
7290: p_x_child_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
7291: p_x_child_line_rec.attribute4 := p_parent_line_rec.attribute4;
7292: END IF;
7293:
7294: IF p_x_child_line_rec.attribute5 is null OR

Line 7295: p_x_child_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN

7291: p_x_child_line_rec.attribute4 := p_parent_line_rec.attribute4;
7292: END IF;
7293:
7294: IF p_x_child_line_rec.attribute5 is null OR
7295: p_x_child_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
7296: p_x_child_line_rec.attribute5 := p_parent_line_rec.attribute5;
7297: END IF;
7298:
7299: IF p_x_child_line_rec.attribute6 is null OR

Line 7300: p_x_child_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN

7296: p_x_child_line_rec.attribute5 := p_parent_line_rec.attribute5;
7297: END IF;
7298:
7299: IF p_x_child_line_rec.attribute6 is null OR
7300: p_x_child_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
7301: p_x_child_line_rec.attribute6 := p_parent_line_rec.attribute6;
7302: END IF;
7303:
7304: IF p_x_child_line_rec.attribute7 is null OR

Line 7305: p_x_child_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN

7301: p_x_child_line_rec.attribute6 := p_parent_line_rec.attribute6;
7302: END IF;
7303:
7304: IF p_x_child_line_rec.attribute7 is null OR
7305: p_x_child_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
7306: p_x_child_line_rec.attribute7 := p_parent_line_rec.attribute7;
7307: END IF;
7308:
7309: IF p_x_child_line_rec.attribute8 is null OR

Line 7310: p_x_child_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN

7306: p_x_child_line_rec.attribute7 := p_parent_line_rec.attribute7;
7307: END IF;
7308:
7309: IF p_x_child_line_rec.attribute8 is null OR
7310: p_x_child_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
7311: p_x_child_line_rec.attribute8 := p_parent_line_rec.attribute8;
7312: END IF;
7313:
7314: IF p_x_child_line_rec.attribute9 is null OR

Line 7315: p_x_child_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN

7311: p_x_child_line_rec.attribute8 := p_parent_line_rec.attribute8;
7312: END IF;
7313:
7314: IF p_x_child_line_rec.attribute9 is null OR
7315: p_x_child_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
7316: p_x_child_line_rec.attribute9 := p_parent_line_rec.attribute9;
7317: END IF;
7318:
7319: IF p_x_child_line_rec.attribute10 is null OR

Line 7320: p_x_child_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN

7316: p_x_child_line_rec.attribute9 := p_parent_line_rec.attribute9;
7317: END IF;
7318:
7319: IF p_x_child_line_rec.attribute10 is null OR
7320: p_x_child_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
7321: p_x_child_line_rec.attribute10 := p_parent_line_rec.attribute10;
7322: END IF;
7323:
7324: IF p_x_child_line_rec.attribute11 is null OR

Line 7325: p_x_child_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN

7321: p_x_child_line_rec.attribute10 := p_parent_line_rec.attribute10;
7322: END IF;
7323:
7324: IF p_x_child_line_rec.attribute11 is null OR
7325: p_x_child_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
7326: p_x_child_line_rec.attribute11 := p_parent_line_rec.attribute11;
7327: END IF;
7328:
7329: IF p_x_child_line_rec.attribute12 is null OR

Line 7330: p_x_child_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN

7326: p_x_child_line_rec.attribute11 := p_parent_line_rec.attribute11;
7327: END IF;
7328:
7329: IF p_x_child_line_rec.attribute12 is null OR
7330: p_x_child_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
7331: p_x_child_line_rec.attribute12 := p_parent_line_rec.attribute12;
7332: END IF;
7333:
7334: IF p_x_child_line_rec.attribute13 is null OR

Line 7335: p_x_child_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN

7331: p_x_child_line_rec.attribute12 := p_parent_line_rec.attribute12;
7332: END IF;
7333:
7334: IF p_x_child_line_rec.attribute13 is null OR
7335: p_x_child_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
7336: p_x_child_line_rec.attribute13 := p_parent_line_rec.attribute13;
7337: END IF;
7338:
7339: IF p_x_child_line_rec.attribute14 is null OR

Line 7340: p_x_child_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN

7336: p_x_child_line_rec.attribute13 := p_parent_line_rec.attribute13;
7337: END IF;
7338:
7339: IF p_x_child_line_rec.attribute14 is null OR
7340: p_x_child_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
7341: p_x_child_line_rec.attribute14 := p_parent_line_rec.attribute14;
7342: END IF;
7343:
7344: IF p_x_child_line_rec.attribute15 is null OR

Line 7345: p_x_child_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN

7341: p_x_child_line_rec.attribute14 := p_parent_line_rec.attribute14;
7342: END IF;
7343:
7344: IF p_x_child_line_rec.attribute15 is null OR
7345: p_x_child_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
7346: p_x_child_line_rec.attribute15 := p_parent_line_rec.attribute15;
7347: END IF;
7348:
7349: IF p_x_child_line_rec.attribute16 is null OR -- for bug 2184255

Line 7350: p_x_child_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN

7346: p_x_child_line_rec.attribute15 := p_parent_line_rec.attribute15;
7347: END IF;
7348:
7349: IF p_x_child_line_rec.attribute16 is null OR -- for bug 2184255
7350: p_x_child_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
7351: p_x_child_line_rec.attribute16 := p_parent_line_rec.attribute16;
7352: END IF;
7353:
7354: IF p_x_child_line_rec.attribute17 is null OR

Line 7355: p_x_child_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN

7351: p_x_child_line_rec.attribute16 := p_parent_line_rec.attribute16;
7352: END IF;
7353:
7354: IF p_x_child_line_rec.attribute17 is null OR
7355: p_x_child_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
7356: p_x_child_line_rec.attribute17 := p_parent_line_rec.attribute17;
7357: END IF;
7358:
7359: IF p_x_child_line_rec.attribute18 is null OR

Line 7360: p_x_child_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN

7356: p_x_child_line_rec.attribute17 := p_parent_line_rec.attribute17;
7357: END IF;
7358:
7359: IF p_x_child_line_rec.attribute18 is null OR
7360: p_x_child_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
7361: p_x_child_line_rec.attribute18 := p_parent_line_rec.attribute18;
7362: END IF;
7363:
7364: IF p_x_child_line_rec.attribute19 is null OR

Line 7365: p_x_child_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN

7361: p_x_child_line_rec.attribute18 := p_parent_line_rec.attribute18;
7362: END IF;
7363:
7364: IF p_x_child_line_rec.attribute19 is null OR
7365: p_x_child_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
7366: p_x_child_line_rec.attribute19 := p_parent_line_rec.attribute19;
7367: END IF;
7368:
7369: IF p_x_child_line_rec.attribute20 is null OR -- for bug 2184255

Line 7370: p_x_child_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN

7366: p_x_child_line_rec.attribute19 := p_parent_line_rec.attribute19;
7367: END IF;
7368:
7369: IF p_x_child_line_rec.attribute20 is null OR -- for bug 2184255
7370: p_x_child_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
7371: p_x_child_line_rec.attribute20 := p_parent_line_rec.attribute20;
7372: END IF;
7373:
7374: IF p_x_child_line_rec.context is null OR

Line 7375: p_x_child_line_rec.context = FND_API.G_MISS_CHAR THEN

7371: p_x_child_line_rec.attribute20 := p_parent_line_rec.attribute20;
7372: END IF;
7373:
7374: IF p_x_child_line_rec.context is null OR
7375: p_x_child_line_rec.context = FND_API.G_MISS_CHAR THEN
7376: p_x_child_line_rec.context := p_parent_line_rec.context;
7377: END IF;
7378:
7379: IF p_x_child_line_rec.industry_attribute1 is null OR

Line 7380: p_x_child_line_rec.industry_attribute1 = FND_API.G_MISS_CHAR THEN

7376: p_x_child_line_rec.context := p_parent_line_rec.context;
7377: END IF;
7378:
7379: IF p_x_child_line_rec.industry_attribute1 is null OR
7380: p_x_child_line_rec.industry_attribute1 = FND_API.G_MISS_CHAR THEN
7381: p_x_child_line_rec.industry_attribute1 := p_parent_line_rec.industry_attribute1;
7382: END IF;
7383:
7384: IF p_x_child_line_rec.industry_attribute2 is null OR

Line 7385: p_x_child_line_rec.industry_attribute2 = FND_API.G_MISS_CHAR THEN

7381: p_x_child_line_rec.industry_attribute1 := p_parent_line_rec.industry_attribute1;
7382: END IF;
7383:
7384: IF p_x_child_line_rec.industry_attribute2 is null OR
7385: p_x_child_line_rec.industry_attribute2 = FND_API.G_MISS_CHAR THEN
7386: p_x_child_line_rec.industry_attribute2 := p_parent_line_rec.industry_attribute2;
7387: END IF;
7388:
7389: IF p_x_child_line_rec.industry_attribute3 is null OR

Line 7390: p_x_child_line_rec.industry_attribute3 = FND_API.G_MISS_CHAR THEN

7386: p_x_child_line_rec.industry_attribute2 := p_parent_line_rec.industry_attribute2;
7387: END IF;
7388:
7389: IF p_x_child_line_rec.industry_attribute3 is null OR
7390: p_x_child_line_rec.industry_attribute3 = FND_API.G_MISS_CHAR THEN
7391: p_x_child_line_rec.industry_attribute3 := p_parent_line_rec.industry_attribute3;
7392: END IF;
7393:
7394: IF p_x_child_line_rec.industry_attribute4 is null OR

Line 7395: p_x_child_line_rec.industry_attribute4 = FND_API.G_MISS_CHAR THEN

7391: p_x_child_line_rec.industry_attribute3 := p_parent_line_rec.industry_attribute3;
7392: END IF;
7393:
7394: IF p_x_child_line_rec.industry_attribute4 is null OR
7395: p_x_child_line_rec.industry_attribute4 = FND_API.G_MISS_CHAR THEN
7396: p_x_child_line_rec.industry_attribute4 := p_parent_line_rec.industry_attribute4;
7397: END IF;
7398:
7399: IF p_x_child_line_rec.industry_attribute5 is null OR

Line 7400: p_x_child_line_rec.industry_attribute5 = FND_API.G_MISS_CHAR THEN

7396: p_x_child_line_rec.industry_attribute4 := p_parent_line_rec.industry_attribute4;
7397: END IF;
7398:
7399: IF p_x_child_line_rec.industry_attribute5 is null OR
7400: p_x_child_line_rec.industry_attribute5 = FND_API.G_MISS_CHAR THEN
7401: p_x_child_line_rec.industry_attribute5 := p_parent_line_rec.industry_attribute5;
7402: END IF;
7403:
7404: IF p_x_child_line_rec.industry_attribute6 is null OR

Line 7405: p_x_child_line_rec.industry_attribute6 = FND_API.G_MISS_CHAR THEN

7401: p_x_child_line_rec.industry_attribute5 := p_parent_line_rec.industry_attribute5;
7402: END IF;
7403:
7404: IF p_x_child_line_rec.industry_attribute6 is null OR
7405: p_x_child_line_rec.industry_attribute6 = FND_API.G_MISS_CHAR THEN
7406: p_x_child_line_rec.industry_attribute6 := p_parent_line_rec.industry_attribute6;
7407: END IF;
7408:
7409: IF p_x_child_line_rec.industry_attribute7 is null OR

Line 7410: p_x_child_line_rec.industry_attribute7 = FND_API.G_MISS_CHAR THEN

7406: p_x_child_line_rec.industry_attribute6 := p_parent_line_rec.industry_attribute6;
7407: END IF;
7408:
7409: IF p_x_child_line_rec.industry_attribute7 is null OR
7410: p_x_child_line_rec.industry_attribute7 = FND_API.G_MISS_CHAR THEN
7411: p_x_child_line_rec.industry_attribute7 := p_parent_line_rec.industry_attribute7;
7412: END IF;
7413:
7414: IF p_x_child_line_rec.industry_attribute8 is null OR

Line 7415: p_x_child_line_rec.industry_attribute8 = FND_API.G_MISS_CHAR THEN

7411: p_x_child_line_rec.industry_attribute7 := p_parent_line_rec.industry_attribute7;
7412: END IF;
7413:
7414: IF p_x_child_line_rec.industry_attribute8 is null OR
7415: p_x_child_line_rec.industry_attribute8 = FND_API.G_MISS_CHAR THEN
7416: p_x_child_line_rec.industry_attribute8 := p_parent_line_rec.industry_attribute8;
7417: END IF;
7418:
7419: IF p_x_child_line_rec.industry_attribute9 is null OR

Line 7420: p_x_child_line_rec.industry_attribute9 = FND_API.G_MISS_CHAR THEN

7416: p_x_child_line_rec.industry_attribute8 := p_parent_line_rec.industry_attribute8;
7417: END IF;
7418:
7419: IF p_x_child_line_rec.industry_attribute9 is null OR
7420: p_x_child_line_rec.industry_attribute9 = FND_API.G_MISS_CHAR THEN
7421: p_x_child_line_rec.industry_attribute9 := p_parent_line_rec.industry_attribute9;
7422: END IF;
7423:
7424: IF p_x_child_line_rec.industry_attribute10 is null OR

Line 7425: p_x_child_line_rec.industry_attribute10 = FND_API.G_MISS_CHAR THEN

7421: p_x_child_line_rec.industry_attribute9 := p_parent_line_rec.industry_attribute9;
7422: END IF;
7423:
7424: IF p_x_child_line_rec.industry_attribute10 is null OR
7425: p_x_child_line_rec.industry_attribute10 = FND_API.G_MISS_CHAR THEN
7426: p_x_child_line_rec.industry_attribute10 := p_parent_line_rec.industry_attribute10;
7427: END IF;
7428:
7429: IF p_x_child_line_rec.industry_attribute11 is null OR

Line 7430: p_x_child_line_rec.industry_attribute11 = FND_API.G_MISS_CHAR THEN

7426: p_x_child_line_rec.industry_attribute10 := p_parent_line_rec.industry_attribute10;
7427: END IF;
7428:
7429: IF p_x_child_line_rec.industry_attribute11 is null OR
7430: p_x_child_line_rec.industry_attribute11 = FND_API.G_MISS_CHAR THEN
7431: p_x_child_line_rec.industry_attribute11 := p_parent_line_rec.industry_attribute11;
7432: END IF;
7433:
7434: IF p_x_child_line_rec.industry_attribute12 is null OR

Line 7435: p_x_child_line_rec.industry_attribute12 = FND_API.G_MISS_CHAR THEN

7431: p_x_child_line_rec.industry_attribute11 := p_parent_line_rec.industry_attribute11;
7432: END IF;
7433:
7434: IF p_x_child_line_rec.industry_attribute12 is null OR
7435: p_x_child_line_rec.industry_attribute12 = FND_API.G_MISS_CHAR THEN
7436: p_x_child_line_rec.industry_attribute12 := p_parent_line_rec.industry_attribute12;
7437: END IF;
7438:
7439: IF p_x_child_line_rec.industry_attribute13 is null OR

Line 7440: p_x_child_line_rec.industry_attribute13 = FND_API.G_MISS_CHAR THEN

7436: p_x_child_line_rec.industry_attribute12 := p_parent_line_rec.industry_attribute12;
7437: END IF;
7438:
7439: IF p_x_child_line_rec.industry_attribute13 is null OR
7440: p_x_child_line_rec.industry_attribute13 = FND_API.G_MISS_CHAR THEN
7441: p_x_child_line_rec.industry_attribute13 := p_parent_line_rec.industry_attribute13;
7442: END IF;
7443:
7444: IF p_x_child_line_rec.industry_attribute14 is null OR

Line 7445: p_x_child_line_rec.industry_attribute14 = FND_API.G_MISS_CHAR THEN

7441: p_x_child_line_rec.industry_attribute13 := p_parent_line_rec.industry_attribute13;
7442: END IF;
7443:
7444: IF p_x_child_line_rec.industry_attribute14 is null OR
7445: p_x_child_line_rec.industry_attribute14 = FND_API.G_MISS_CHAR THEN
7446: p_x_child_line_rec.industry_attribute14 := p_parent_line_rec.industry_attribute14;
7447: END IF;
7448:
7449: IF p_x_child_line_rec.industry_attribute15 is null OR

Line 7450: p_x_child_line_rec.industry_attribute15 = FND_API.G_MISS_CHAR THEN

7446: p_x_child_line_rec.industry_attribute14 := p_parent_line_rec.industry_attribute14;
7447: END IF;
7448:
7449: IF p_x_child_line_rec.industry_attribute15 is null OR
7450: p_x_child_line_rec.industry_attribute15 = FND_API.G_MISS_CHAR THEN
7451: p_x_child_line_rec.industry_attribute15 := p_parent_line_rec.industry_attribute15;
7452: END IF;
7453:
7454: IF p_x_child_line_rec.industry_attribute16 is null OR

Line 7455: p_x_child_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN

7451: p_x_child_line_rec.industry_attribute15 := p_parent_line_rec.industry_attribute15;
7452: END IF;
7453:
7454: IF p_x_child_line_rec.industry_attribute16 is null OR
7455: p_x_child_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN
7456: p_x_child_line_rec.industry_attribute16 := p_parent_line_rec.industry_attribute16;
7457: END IF;
7458: IF p_x_child_line_rec.industry_attribute17 is null OR
7459: p_x_child_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN

Line 7459: p_x_child_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN

7455: p_x_child_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN
7456: p_x_child_line_rec.industry_attribute16 := p_parent_line_rec.industry_attribute16;
7457: END IF;
7458: IF p_x_child_line_rec.industry_attribute17 is null OR
7459: p_x_child_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN
7460: p_x_child_line_rec.industry_attribute17 := p_parent_line_rec.industry_attribute17;
7461: END IF;
7462:
7463: IF p_x_child_line_rec.industry_attribute18 is null OR

Line 7464: p_x_child_line_rec.industry_attribute18 = FND_API.G_MISS_CHAR THEN

7460: p_x_child_line_rec.industry_attribute17 := p_parent_line_rec.industry_attribute17;
7461: END IF;
7462:
7463: IF p_x_child_line_rec.industry_attribute18 is null OR
7464: p_x_child_line_rec.industry_attribute18 = FND_API.G_MISS_CHAR THEN
7465: p_x_child_line_rec.industry_attribute18 := p_parent_line_rec.industry_attribute18;
7466: END IF;
7467:
7468: IF p_x_child_line_rec.industry_attribute19 is null OR

Line 7469: p_x_child_line_rec.industry_attribute19 = FND_API.G_MISS_CHAR THEN

7465: p_x_child_line_rec.industry_attribute18 := p_parent_line_rec.industry_attribute18;
7466: END IF;
7467:
7468: IF p_x_child_line_rec.industry_attribute19 is null OR
7469: p_x_child_line_rec.industry_attribute19 = FND_API.G_MISS_CHAR THEN
7470: p_x_child_line_rec.industry_attribute19 := p_parent_line_rec.industry_attribute19;
7471: END IF;
7472:
7473: IF p_x_child_line_rec.industry_attribute20 is null OR

Line 7474: p_x_child_line_rec.industry_attribute20 = FND_API.G_MISS_CHAR THEN

7470: p_x_child_line_rec.industry_attribute19 := p_parent_line_rec.industry_attribute19;
7471: END IF;
7472:
7473: IF p_x_child_line_rec.industry_attribute20 is null OR
7474: p_x_child_line_rec.industry_attribute20 = FND_API.G_MISS_CHAR THEN
7475: p_x_child_line_rec.industry_attribute20 := p_parent_line_rec.industry_attribute20;
7476: END IF;
7477:
7478: IF p_x_child_line_rec.industry_attribute21 is null OR

Line 7479: p_x_child_line_rec.industry_attribute21 = FND_API.G_MISS_CHAR THEN

7475: p_x_child_line_rec.industry_attribute20 := p_parent_line_rec.industry_attribute20;
7476: END IF;
7477:
7478: IF p_x_child_line_rec.industry_attribute21 is null OR
7479: p_x_child_line_rec.industry_attribute21 = FND_API.G_MISS_CHAR THEN
7480: p_x_child_line_rec.industry_attribute21 := p_parent_line_rec.industry_attribute21;
7481: END IF;
7482:
7483: IF p_x_child_line_rec.industry_attribute22 is null OR

Line 7484: p_x_child_line_rec.industry_attribute22 = FND_API.G_MISS_CHAR THEN

7480: p_x_child_line_rec.industry_attribute21 := p_parent_line_rec.industry_attribute21;
7481: END IF;
7482:
7483: IF p_x_child_line_rec.industry_attribute22 is null OR
7484: p_x_child_line_rec.industry_attribute22 = FND_API.G_MISS_CHAR THEN
7485: p_x_child_line_rec.industry_attribute22 := p_parent_line_rec.industry_attribute22;
7486: END IF;
7487:
7488: IF p_x_child_line_rec.industry_attribute23 is null OR

Line 7489: p_x_child_line_rec.industry_attribute23 = FND_API.G_MISS_CHAR THEN

7485: p_x_child_line_rec.industry_attribute22 := p_parent_line_rec.industry_attribute22;
7486: END IF;
7487:
7488: IF p_x_child_line_rec.industry_attribute23 is null OR
7489: p_x_child_line_rec.industry_attribute23 = FND_API.G_MISS_CHAR THEN
7490: p_x_child_line_rec.industry_attribute23 := p_parent_line_rec.industry_attribute23;
7491: END IF;
7492:
7493: IF p_x_child_line_rec.industry_attribute24 is null OR

Line 7494: p_x_child_line_rec.industry_attribute24 = FND_API.G_MISS_CHAR THEN

7490: p_x_child_line_rec.industry_attribute23 := p_parent_line_rec.industry_attribute23;
7491: END IF;
7492:
7493: IF p_x_child_line_rec.industry_attribute24 is null OR
7494: p_x_child_line_rec.industry_attribute24 = FND_API.G_MISS_CHAR THEN
7495: p_x_child_line_rec.industry_attribute24 := p_parent_line_rec.industry_attribute24;
7496: END IF;
7497:
7498: IF p_x_child_line_rec.industry_attribute25 is null OR

Line 7499: p_x_child_line_rec.industry_attribute25 = FND_API.G_MISS_CHAR THEN

7495: p_x_child_line_rec.industry_attribute24 := p_parent_line_rec.industry_attribute24;
7496: END IF;
7497:
7498: IF p_x_child_line_rec.industry_attribute25 is null OR
7499: p_x_child_line_rec.industry_attribute25 = FND_API.G_MISS_CHAR THEN
7500: p_x_child_line_rec.industry_attribute25 := p_parent_line_rec.industry_attribute25;
7501: END IF;
7502:
7503: IF p_x_child_line_rec.industry_attribute26 is null OR

Line 7504: p_x_child_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN

7500: p_x_child_line_rec.industry_attribute25 := p_parent_line_rec.industry_attribute25;
7501: END IF;
7502:
7503: IF p_x_child_line_rec.industry_attribute26 is null OR
7504: p_x_child_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN
7505: p_x_child_line_rec.industry_attribute26 := p_parent_line_rec.industry_attribute26;
7506: END IF;
7507: IF p_x_child_line_rec.industry_attribute27 is null OR
7508: p_x_child_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN

Line 7508: p_x_child_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN

7504: p_x_child_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN
7505: p_x_child_line_rec.industry_attribute26 := p_parent_line_rec.industry_attribute26;
7506: END IF;
7507: IF p_x_child_line_rec.industry_attribute27 is null OR
7508: p_x_child_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN
7509: p_x_child_line_rec.industry_attribute27 := p_parent_line_rec.industry_attribute27;
7510: END IF;
7511:
7512: IF p_x_child_line_rec.industry_attribute28 is null OR

Line 7513: p_x_child_line_rec.industry_attribute28 = FND_API.G_MISS_CHAR THEN

7509: p_x_child_line_rec.industry_attribute27 := p_parent_line_rec.industry_attribute27;
7510: END IF;
7511:
7512: IF p_x_child_line_rec.industry_attribute28 is null OR
7513: p_x_child_line_rec.industry_attribute28 = FND_API.G_MISS_CHAR THEN
7514: p_x_child_line_rec.industry_attribute28 := p_parent_line_rec.industry_attribute28;
7515: END IF;
7516:
7517: IF p_x_child_line_rec.industry_attribute29 is null OR

Line 7518: p_x_child_line_rec.industry_attribute29 = FND_API.G_MISS_CHAR THEN

7514: p_x_child_line_rec.industry_attribute28 := p_parent_line_rec.industry_attribute28;
7515: END IF;
7516:
7517: IF p_x_child_line_rec.industry_attribute29 is null OR
7518: p_x_child_line_rec.industry_attribute29 = FND_API.G_MISS_CHAR THEN
7519: p_x_child_line_rec.industry_attribute29 := p_parent_line_rec.industry_attribute29;
7520: END IF;
7521:
7522: IF p_x_child_line_rec.industry_attribute30 is null OR

Line 7523: p_x_child_line_rec.industry_attribute30 = FND_API.G_MISS_CHAR THEN

7519: p_x_child_line_rec.industry_attribute29 := p_parent_line_rec.industry_attribute29;
7520: END IF;
7521:
7522: IF p_x_child_line_rec.industry_attribute30 is null OR
7523: p_x_child_line_rec.industry_attribute30 = FND_API.G_MISS_CHAR THEN
7524: p_x_child_line_rec.industry_attribute30 := p_parent_line_rec.industry_attribute30;
7525: END IF;
7526:
7527: IF p_x_child_line_rec.industry_context is null OR

Line 7528: p_x_child_line_rec.industry_context = FND_API.G_MISS_CHAR THEN

7524: p_x_child_line_rec.industry_attribute30 := p_parent_line_rec.industry_attribute30;
7525: END IF;
7526:
7527: IF p_x_child_line_rec.industry_context is null OR
7528: p_x_child_line_rec.industry_context = FND_API.G_MISS_CHAR THEN
7529: p_x_child_line_rec.industry_context := p_parent_line_rec.industry_context;
7530: END IF;
7531:
7532:

Line 7538: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

7534:
7535:
7536: OE_Validate_Line.Validate_Flex
7537: ( p_x_line_rec => p_x_child_line_rec
7538: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
7539: ,x_return_status => x_return_status);
7540:
7541: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- For bug 2869052
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7541: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- For bug 2869052

7537: ( p_x_line_rec => p_x_child_line_rec
7538: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
7539: ,x_return_status => x_return_status);
7540:
7541: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- For bug 2869052
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7544: RAISE FND_API.G_EXC_ERROR;
7545: END IF;

Line 7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7538: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
7539: ,x_return_status => x_return_status);
7540:
7541: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- For bug 2869052
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7544: RAISE FND_API.G_EXC_ERROR;
7545: END IF;
7546:

Line 7543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

7539: ,x_return_status => x_return_status);
7540:
7541: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- For bug 2869052
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7544: RAISE FND_API.G_EXC_ERROR;
7545: END IF;
7546:
7547: ---------------- for direct save only ------------------------

Line 7544: RAISE FND_API.G_EXC_ERROR;

7540:
7541: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- For bug 2869052
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7544: RAISE FND_API.G_EXC_ERROR;
7545: END IF;
7546:
7547: ---------------- for direct save only ------------------------
7548:

Line 7597: p_parent_line_rec.ship_set_id <> FND_API.G_MISS_NUM) OR

7593:
7594: IF p_parent_line_rec.ship_model_complete_flag = 'Y' OR
7595: p_parent_line_rec.ato_line_id = p_parent_line_rec.top_model_line_id OR
7596: (p_parent_line_rec.ship_set_id is NOT NULL AND
7597: p_parent_line_rec.ship_set_id <> FND_API.G_MISS_NUM) OR
7598: (p_parent_line_rec.arrival_set_id is NOT NULL AND
7599: p_parent_line_rec.arrival_set_id <> FND_API.G_MISS_NUM)
7600: THEN
7601: IF l_debug_level > 0 THEN

Line 7599: p_parent_line_rec.arrival_set_id <> FND_API.G_MISS_NUM)

7595: p_parent_line_rec.ato_line_id = p_parent_line_rec.top_model_line_id OR
7596: (p_parent_line_rec.ship_set_id is NOT NULL AND
7597: p_parent_line_rec.ship_set_id <> FND_API.G_MISS_NUM) OR
7598: (p_parent_line_rec.arrival_set_id is NOT NULL AND
7599: p_parent_line_rec.arrival_set_id <> FND_API.G_MISS_NUM)
7600: THEN
7601: IF l_debug_level > 0 THEN
7602: oe_debug_pub.add('**PARENT IS ATO OR SMC PTO OR IN SET' , 1);
7603: END IF;

Line 7661: IF p_x_child_line_rec.ship_to_org_id = FND_API.G_MISS_NUM OR

7657: IF l_debug_level > 0 THEN
7658: oe_debug_pub.add('**PARENT IS NON SMC PTO ' , 1);
7659: END IF;
7660:
7661: IF p_x_child_line_rec.ship_to_org_id = FND_API.G_MISS_NUM OR
7662: p_x_child_line_rec.ship_to_org_id IS NULL THEN
7663: p_x_child_line_rec.ship_to_org_id
7664: := p_parent_line_rec.ship_to_org_id;
7665: END IF;

Line 7667: IF p_x_child_line_rec.request_date = FND_API.G_MISS_DATE OR

7663: p_x_child_line_rec.ship_to_org_id
7664: := p_parent_line_rec.ship_to_org_id;
7665: END IF;
7666:
7667: IF p_x_child_line_rec.request_date = FND_API.G_MISS_DATE OR
7668: p_x_child_line_rec.request_date IS NULL THEN
7669: p_x_child_line_rec.request_date
7670: := p_parent_line_rec.request_date;
7671: END IF;

Line 7673: IF p_x_child_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM OR

7669: p_x_child_line_rec.request_date
7670: := p_parent_line_rec.request_date;
7671: END IF;
7672:
7673: IF p_x_child_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM OR
7674: p_x_child_line_rec.invoice_to_org_id IS NULL THEN
7675: p_x_child_line_rec.invoice_to_org_id
7676: := p_parent_line_rec.invoice_to_org_id;
7677: END IF;

Line 7680: IF p_x_child_line_rec.intermed_ship_to_org_id = FND_API.G_MISS_NUM OR

7676: := p_parent_line_rec.invoice_to_org_id;
7677: END IF;
7678:
7679: /*Start bug7041018,7175458*/
7680: IF p_x_child_line_rec.intermed_ship_to_org_id = FND_API.G_MISS_NUM OR
7681: p_x_child_line_rec.intermed_ship_to_org_id IS NULL THEN
7682: p_x_child_line_rec.intermed_ship_to_org_id
7683: := p_parent_line_rec.intermed_ship_to_org_id;
7684: END IF;

Line 7686: IF p_x_child_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM OR

7682: p_x_child_line_rec.intermed_ship_to_org_id
7683: := p_parent_line_rec.intermed_ship_to_org_id;
7684: END IF;
7685:
7686: IF p_x_child_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM OR
7687: p_x_child_line_rec.ship_to_contact_id IS NULL THEN
7688: p_x_child_line_rec.ship_to_contact_id
7689: := p_parent_line_rec.ship_to_contact_id;
7690: END IF;

Line 7775: x_return_status := FND_API.G_RET_STS_SUCCESS;

7771: -- put logic here
7772: --END IF;
7773:
7774:
7775: x_return_status := FND_API.G_RET_STS_SUCCESS;
7776: IF l_debug_level > 0 THEN
7777: oe_debug_pub.add('LEAVING DEFAULT_CHILD_LINE' , 1);
7778: END IF;
7779:

Line 7782: WHEN FND_API.G_EXC_ERROR THEN

7778: END IF;
7779:
7780: EXCEPTION
7781:
7782: WHEN FND_API.G_EXC_ERROR THEN
7783: IF l_debug_level > 0 THEN
7784: oe_debug_pub.add('DEFAULT_CHILD_LINE, exc error '|| SQLERRM , 1);
7785: END IF;
7786: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7786: x_return_status := FND_API.G_RET_STS_ERROR;

7782: WHEN FND_API.G_EXC_ERROR THEN
7783: IF l_debug_level > 0 THEN
7784: oe_debug_pub.add('DEFAULT_CHILD_LINE, exc error '|| SQLERRM , 1);
7785: END IF;
7786: x_return_status := FND_API.G_RET_STS_ERROR;
7787:
7788: WHEN OTHERS THEN
7789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7790: IF l_debug_level > 0 THEN

Line 7789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7785: END IF;
7786: x_return_status := FND_API.G_RET_STS_ERROR;
7787:
7788: WHEN OTHERS THEN
7789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7790: IF l_debug_level > 0 THEN
7791: oe_debug_pub.add('others in DEFAULT_CHILD_LINE '|| SQLERRM , 1);
7792: END IF;
7793:

Line 8211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8207: p_line_id is not NULL THEN
8208: IF l_debug_level > 0 THEN
8209: oe_debug_pub.add('WRONG PARAMTERS' , 1);
8210: END IF;
8211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8212: END IF;
8213:
8214: x_return_status := FND_API.G_RET_STS_SUCCESS;
8215: x_wb_item_type := null;

Line 8214: x_return_status := FND_API.G_RET_STS_SUCCESS;

8210: END IF;
8211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8212: END IF;
8213:
8214: x_return_status := FND_API.G_RET_STS_SUCCESS;
8215: x_wb_item_type := null;
8216:
8217: SELECT count(*)
8218: INTO l_count

Line 8247: x_return_status := FND_API.G_RET_STS_ERROR;

8243: ELSE
8244: IF l_debug_level > 0 THEN
8245: oe_debug_pub.add('NO ELIGIBLE LINES ' , 1);
8246: END IF;
8247: x_return_status := FND_API.G_RET_STS_ERROR;
8248: RETURN;
8249: END IF;
8250:
8251: IF p_header_id is not null AND

Line 8312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8308: WHEN OTHERS THEN
8309: IF l_debug_level > 0 THEN
8310: oe_debug_pub.add('ERROR IN LAUNCH_SUPPLY_WORKBENCH'|| SQLERRM , 1);
8311: END IF;
8312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8313: END Launch_Supply_Workbench;
8314:
8315: /* -----------------------------------------------------------
8316: PROCEDURE Message_From_Cz

Line 8499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8495: IF l_debug_level > 0 THEN
8496: OE_Debug_Pub.Add('something wrong in i/p'|| p_model_line_id, 3);
8497: END IF;
8498:
8499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8500:
8501: END IF; -- if model rec was sent in
8502:
8503:

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

8649: l_part_of_container VARCHAR2(1);
8650: l_locking_key NUMBER;
8651: l_msg_count NUMBER;
8652: l_msg_data VARCHAR2(4000);
8653: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8654: l_order_number NUMBER;
8655:
8656: --
8657: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 8695: p_init_msg_list => FND_API.G_TRUE,

8691: p_source_line_ref1 => Null,
8692: p_source_line_ref2 => Null,
8693: p_source_line_ref3 => Null,
8694: p_commit => 'N',
8695: p_init_msg_list => FND_API.G_TRUE,
8696: p_validation_level => Null,
8697: p_locking_key => Null,
8698: x_return_status => x_return_status,
8699: x_msg_count => l_msg_count,

Line 8726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8722: WHEN OTHERS THEN
8723: IF l_debug_level > 0 THEN
8724: oe_debug_pub.add('ERROR IN OE_CONFIG_UTIL.Unlock_Config'|| SQLERRM , 1);
8725: END IF;
8726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8727: END Unlock_Config;
8728:
8729:
8730: END OE_CONFIG_UTIL;