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.

[Home] [Help]

APPS.ENG_FORM_ECO_PVT dependencies on FND_API

Line 51: l_return_status := FND_API.G_RET_STS_SUCCESS;

47: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
48: l_return_status VARCHAR2(1);
49: BEGIN
50:
51: l_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: BEGIN
54: SELECT routing_sequence_id
55: , lot_number

Line 129: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

125: l_other_token_tbl Error_Handler.Token_Tbl_Type;
126: l_other_message VARCHAR2(50);
127: l_err_text VARCHAR2(2000);
128: l_valid BOOLEAN := TRUE;
129: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
130: l_bo_return_status VARCHAR2(1) := 'S';
131: l_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type;
132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;
133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;

Line 164: l_return_status := FND_API.G_RET_STS_SUCCESS;

160:
161: l_rev_sub_resource_rec.transaction_type :=
162: UPPER(l_rev_sub_resource_rec.transaction_type);
163:
164: l_return_status := FND_API.G_RET_STS_SUCCESS;
165: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: -- Process Flow step 3: Verify Sub Operation Resource's existence
168: --

Line 165: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;

161: l_rev_sub_resource_rec.transaction_type :=
162: UPPER(l_rev_sub_resource_rec.transaction_type);
163:
164: l_return_status := FND_API.G_RET_STS_SUCCESS;
165: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: -- Process Flow step 3: Verify Sub Operation Resource's existence
168: --
169:

Line 319: , p_error_status => FND_API.G_RET_STS_ERROR

315: Eco_Error_Handler.Log_Error
316: ( p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
317: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
318: , p_mesg_token_tbl => l_mesg_token_tbl
319: , p_error_status => FND_API.G_RET_STS_ERROR
320: , p_error_scope => Error_Handler.G_SCOPE_RECORD
321: , p_error_level => Error_Handler.G_SR_LEVEL
322: , p_entity_index => I
323: , x_eco_rec => l_eco_rec

Line 439: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

435: l_other_token_tbl Error_Handler.Token_Tbl_Type;
436: l_other_message VARCHAR2(50);
437: l_err_text VARCHAR2(2000);
438: l_valid BOOLEAN := TRUE;
439: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
440: l_bo_return_status VARCHAR2(1) := 'S';
441: l_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type;
442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;
443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;

Line 474: l_return_status := FND_API.G_RET_STS_SUCCESS;

470:
471: l_rev_op_resource_rec.transaction_type :=
472: UPPER(l_rev_op_resource_rec.transaction_type);
473:
474: l_return_status := FND_API.G_RET_STS_SUCCESS;
475: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
476:
477: -- Process Flow step 3: Verify Operation Resource's existence
478: --

Line 475: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;

471: l_rev_op_resource_rec.transaction_type :=
472: UPPER(l_rev_op_resource_rec.transaction_type);
473:
474: l_return_status := FND_API.G_RET_STS_SUCCESS;
475: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
476:
477: -- Process Flow step 3: Verify Operation Resource's existence
478: --
479:

Line 627: , p_error_status => FND_API.G_RET_STS_ERROR

623: Eco_Error_Handler.Log_Error
624: ( p_rev_op_resource_tbl => l_rev_op_resource_tbl
625: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
626: , p_mesg_token_tbl => l_mesg_token_tbl
627: , p_error_status => FND_API.G_RET_STS_ERROR
628: , p_error_scope => Error_Handler.G_SCOPE_RECORD
629: , p_error_level => Error_Handler.G_RES_LEVEL
630: , p_entity_index => I
631: , x_eco_rec => l_eco_rec

Line 748: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

744: l_other_token_tbl Error_Handler.Token_Tbl_Type;
745: l_other_message VARCHAR2(50);
746: l_err_text VARCHAR2(2000);
747: l_valid BOOLEAN := TRUE;
748: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
749: l_bo_return_status VARCHAR2(1) := 'S';
750: l_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type;
751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;
752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;

Line 792: l_return_status := FND_API.G_RET_STS_SUCCESS;

788:
789: l_rev_operation_rec.transaction_type :=
790: UPPER(l_rev_operation_rec.transaction_type);
791:
792: l_return_status := FND_API.G_RET_STS_SUCCESS;
793: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: -- Process Flow step 3: Verify Revised Operation's existence
796: --

Line 793: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;

789: l_rev_operation_rec.transaction_type :=
790: UPPER(l_rev_operation_rec.transaction_type);
791:
792: l_return_status := FND_API.G_RET_STS_SUCCESS;
793: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: -- Process Flow step 3: Verify Revised Operation's existence
796: --
797: IF BOM_Globals.get_debug = 'Y'

Line 1352: , p_error_status => FND_API.G_RET_STS_ERROR

1348: ( p_rev_operation_tbl => l_rev_operation_tbl
1349: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1350: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1351: , p_mesg_token_tbl => l_mesg_token_tbl
1352: , p_error_status => FND_API.G_RET_STS_ERROR
1353: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1354: , p_error_level => Error_Handler.G_OP_LEVEL
1355: , p_entity_index => I
1356: , x_eco_rec => l_eco_rec

Line 1475: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1471: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1472: l_other_message VARCHAR2(50);
1473: l_err_text VARCHAR2(2000);
1474: l_valid BOOLEAN := TRUE;
1475: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1476: l_bo_return_status VARCHAR2(1) := 'S';
1477: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;
1478: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1479: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;

Line 1510: l_return_status := FND_API.G_RET_STS_SUCCESS;

1506:
1507: l_sub_component_rec.transaction_type :=
1508: UPPER(l_sub_component_rec.transaction_type);
1509:
1510: l_return_status := FND_API.G_RET_STS_SUCCESS;
1511: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: -- Process Flow step 3: Verify Substitute Component's existence
1514: --

Line 1511: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1507: l_sub_component_rec.transaction_type :=
1508: UPPER(l_sub_component_rec.transaction_type);
1509:
1510: l_return_status := FND_API.G_RET_STS_SUCCESS;
1511: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: -- Process Flow step 3: Verify Substitute Component's existence
1514: --
1515:

Line 1656: , p_error_status => FND_API.G_RET_STS_ERROR

1652: Eco_Error_Handler.Log_Error
1653: ( p_ref_designator_tbl => l_ref_designator_tbl
1654: , p_sub_component_tbl => l_sub_component_tbl
1655: , p_mesg_token_tbl => l_mesg_token_tbl
1656: , p_error_status => FND_API.G_RET_STS_ERROR
1657: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1658: , p_error_level => 6
1659: , p_entity_index => I
1660: , x_eco_rec => l_eco_rec

Line 1775: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1771: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1772: l_other_message VARCHAR2(50);
1773: l_err_text VARCHAR2(2000);
1774: l_valid BOOLEAN := TRUE;
1775: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1776: l_bo_return_status VARCHAR2(1) := 'S';
1777: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;
1778: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1779: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;

Line 1810: l_return_status := FND_API.G_RET_STS_SUCCESS;

1806:
1807: l_ref_designator_rec.transaction_type :=
1808: UPPER(l_ref_designator_rec.transaction_type);
1809:
1810: l_return_status := FND_API.G_RET_STS_SUCCESS;
1811: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1812:
1813: -- Process Flow step 3: Verify Reference Designator's existence
1814: --

Line 1811: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1807: l_ref_designator_rec.transaction_type :=
1808: UPPER(l_ref_designator_rec.transaction_type);
1809:
1810: l_return_status := FND_API.G_RET_STS_SUCCESS;
1811: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1812:
1813: -- Process Flow step 3: Verify Reference Designator's existence
1814: --
1815:

Line 1903: , p_error_status => FND_API.G_RET_STS_ERROR

1899: Eco_Error_Handler.Log_Error
1900: ( p_ref_designator_tbl => l_ref_designator_tbl
1901: , p_sub_component_tbl => l_sub_component_tbl
1902: , p_mesg_token_tbl => l_mesg_token_tbl
1903: , p_error_status => FND_API.G_RET_STS_ERROR
1904: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1905: , p_error_level => 5
1906: , p_entity_index => I
1907: , x_eco_rec => l_eco_rec

Line 2029: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2025: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2026: l_other_message VARCHAR2(50);
2027: l_err_text VARCHAR2(2000);
2028: l_valid BOOLEAN := TRUE;
2029: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2030: l_bo_return_status VARCHAR2(1) := 'S';
2031: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;
2032: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2033: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;

Line 2067: l_return_status := FND_API.G_RET_STS_SUCCESS;

2063:
2064: l_rev_component_rec.transaction_type :=
2065: UPPER(l_rev_component_rec.transaction_type);
2066:
2067: l_return_status := FND_API.G_RET_STS_SUCCESS;
2068: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2069:
2070: -- Process Flow step 3: Verify Revised Component's existence
2071: --

Line 2068: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2064: l_rev_component_rec.transaction_type :=
2065: UPPER(l_rev_component_rec.transaction_type);
2066:
2067: l_return_status := FND_API.G_RET_STS_SUCCESS;
2068: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2069:
2070: -- Process Flow step 3: Verify Revised Component's existence
2071: --
2072:

Line 2404: , p_error_status => FND_API.G_RET_STS_ERROR

2400: ( p_rev_component_tbl => l_rev_component_tbl
2401: , p_ref_designator_tbl => l_ref_designator_tbl
2402: , p_sub_component_tbl => l_sub_component_tbl
2403: , p_mesg_token_tbl => l_mesg_token_tbl
2404: , p_error_status => FND_API.G_RET_STS_ERROR
2405: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2406: , p_error_level => 4
2407: , p_entity_index => I
2408: , x_eco_rec => l_eco_rec

Line 2533: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2529: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2530: l_other_message VARCHAR2(50);
2531: l_err_text VARCHAR2(2000);
2532: l_valid BOOLEAN := TRUE;
2533: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2534: l_bo_return_status VARCHAR2(1) := 'S';
2535: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;

Line 2576: l_return_status := FND_API.G_RET_STS_SUCCESS;

2572:
2573: l_revised_item_rec.transaction_type :=
2574: UPPER(l_revised_item_rec.transaction_type);
2575:
2576: l_return_status := FND_API.G_RET_STS_SUCCESS;
2577: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2578:
2579: -- Process Flow step 3: Verify ECO's existence
2580: --

Line 2577: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2573: l_revised_item_rec.transaction_type :=
2574: UPPER(l_revised_item_rec.transaction_type);
2575:
2576: l_return_status := FND_API.G_RET_STS_SUCCESS;
2577: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2578:
2579: -- Process Flow step 3: Verify ECO's existence
2580: --
2581:

Line 2904: , p_error_status => FND_API.G_RET_STS_ERROR

2900: , p_rev_operation_tbl => l_rev_operation_tbl --add
2901: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2902: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2903: , p_mesg_token_tbl => l_mesg_token_tbl
2904: , p_error_status => FND_API.G_RET_STS_ERROR
2905: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2906: , p_error_level => 3
2907: , p_entity_index => I
2908: , x_ECO_rec => l_ECO_rec

Line 3038: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3034: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3035: l_other_message VARCHAR2(50);
3036: l_err_text VARCHAR2(2000);
3037: l_valid BOOLEAN := TRUE;
3038: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3039: l_bo_return_status VARCHAR2(1) := 'S';
3040: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;
3041: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3042: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;

Line 3073: l_return_status := FND_API.G_RET_STS_SUCCESS;

3069:
3070: l_eco_revision_rec.transaction_type :=
3071: UPPER(l_eco_revision_rec.transaction_type);
3072:
3073: l_return_status := FND_API.G_RET_STS_SUCCESS;
3074: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3075:
3076: IF g_control_rec.attribute_defaulting
3077: THEN

Line 3074: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3070: l_eco_revision_rec.transaction_type :=
3071: UPPER(l_eco_revision_rec.transaction_type);
3072:
3073: l_return_status := FND_API.G_RET_STS_SUCCESS;
3074: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3075:
3076: IF g_control_rec.attribute_defaulting
3077: THEN
3078:

Line 3194: , p_error_status => FND_API.G_RET_STS_ERROR

3190: , p_rev_operation_tbl => l_rev_operation_tbl --add
3191: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3192: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3193: , p_mesg_token_tbl => l_mesg_token_tbl
3194: , p_error_status => FND_API.G_RET_STS_ERROR
3195: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3196: , p_error_level => 2
3197: , p_entity_index => I
3198: , x_eco_rec => l_eco_rec

Line 3237: , p_error_status => FND_API.G_RET_STS_ERROR

3233: , p_rev_operation_tbl => l_rev_operation_tbl --add
3234: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3235: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3236: , p_mesg_token_tbl => l_mesg_token_tbl
3237: , p_error_status => FND_API.G_RET_STS_ERROR
3238: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3239: , p_error_level => 2
3240: , p_entity_index => I
3241: , x_eco_rec => l_eco_rec

Line 3328: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3324: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3325: l_other_message VARCHAR2(50);
3326: l_err_text VARCHAR2(2000);
3327: l_valid BOOLEAN := TRUE;
3328: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3329: l_bo_return_status VARCHAR2(1) := 'S';
3330: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;

Line 3370: l_return_status := FND_API.G_RET_STS_SUCCESS;

3366:
3367: l_ECO_rec := p_ECO_rec;
3368: l_ECO_rec.transaction_type := UPPER(l_eco_rec.transaction_type);
3369:
3370: l_return_status := FND_API.G_RET_STS_SUCCESS;
3371: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3372:
3373: -- Process Flow step 3: Verify ECO's existence
3374: --

Line 3371: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3367: l_ECO_rec := p_ECO_rec;
3368: l_ECO_rec.transaction_type := UPPER(l_eco_rec.transaction_type);
3369:
3370: l_return_status := FND_API.G_RET_STS_SUCCESS;
3371: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3372:
3373: -- Process Flow step 3: Verify ECO's existence
3374: --
3375:

Line 3716: , p_error_status => FND_API.G_RET_STS_ERROR

3712: , p_rev_operation_tbl => l_rev_operation_tbl --add
3713: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3714: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3715: , p_mesg_token_tbl => l_mesg_token_tbl
3716: , p_error_status => FND_API.G_RET_STS_ERROR
3717: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3718: , p_error_level => 1
3719: , x_ECO_rec => l_ECO_rec
3720: , x_eco_revision_tbl => l_eco_revision_tbl

Line 4495: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR

4491: , p_rev_operation_tbl => l_rev_operation_tbl --add
4492: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4493: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4494: , p_mesg_token_tbl => l_mesg_token_tbl
4495: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4496: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4497: , p_other_message => l_other_message
4498: , p_other_token_tbl => l_other_token_tbl
4499: , p_error_level => 0

Line 4594: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR

4590: , p_rev_operation_tbl => l_rev_operation_tbl --add
4591: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4592: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4593: , p_mesg_token_tbl => l_mesg_token_tbl
4594: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4595: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4596: , p_other_message => l_other_message
4597: , p_other_token_tbl => l_other_token_tbl
4598: , p_error_level => 0

Line 4652: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

4648: -- End of Comments
4649:
4650: PROCEDURE Lock_Eco
4651: ( p_api_version_number IN NUMBER
4652: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4653: , x_return_status IN OUT NOCOPY VARCHAR2
4654: , x_msg_count IN OUT NOCOPY NUMBER
4655: , x_msg_data IN OUT NOCOPY VARCHAR2
4656: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=

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

4675: )
4676: IS
4677: l_api_version_number CONSTANT NUMBER := 1.0;
4678: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
4679: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4680: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
4681: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
4682: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
4683: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;

Line 4693: IF NOT FND_API.Compatible_API_Call

4689: NULL;
4690:
4691: /*********************** Temporarily commented *****************************
4692:
4693: IF NOT FND_API.Compatible_API_Call
4694: ( l_api_version_number
4695: , p_api_version_number
4696: , l_api_name
4697: , G_PKG_NAME

Line 4700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4696: , l_api_name
4697: , G_PKG_NAME
4698: )
4699: THEN
4700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4701: END IF;
4702:
4703: -- Initialize message list.
4704:

Line 4705: IF FND_API.to_Boolean(p_init_msg_list) THEN

4701: END IF;
4702:
4703: -- Initialize message list.
4704:
4705: IF FND_API.to_Boolean(p_init_msg_list) THEN
4706: FND_MSG_PUB.initialize;
4707: END IF;
4708:
4709: -- Set Savepoint

Line 4724: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4720: , x_return_status => l_return_status
4721: , x_err_text => x_err_text
4722: );
4723:
4724: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4726: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;

Line 4725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4721: , x_err_text => x_err_text
4722: );
4723:
4724: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4726: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;
4729:

Line 4726: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4722: );
4723:
4724: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4726: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;
4729:
4730:

Line 4727: RAISE FND_API.G_EXC_ERROR;

4723:
4724: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4726: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;
4729:
4730:
4731: END IF;

Line 4746: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4742: , x_return_status => l_return_status
4743: , x_err_text => x_err_text
4744: );
4745:
4746: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4749: RAISE FND_API.G_EXC_ERROR;
4750: END IF;

Line 4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4743: , x_err_text => x_err_text
4744: );
4745:
4746: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4749: RAISE FND_API.G_EXC_ERROR;
4750: END IF;
4751:

Line 4748: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4744: );
4745:
4746: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4749: RAISE FND_API.G_EXC_ERROR;
4750: END IF;
4751:
4752: x_eco_revision_tbl(I) := l_eco_revision_rec;

Line 4749: RAISE FND_API.G_EXC_ERROR;

4745:
4746: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4749: RAISE FND_API.G_EXC_ERROR;
4750: END IF;
4751:
4752: x_eco_revision_tbl(I) := l_eco_revision_rec;
4753:

Line 4771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4767: , x_return_status => l_return_status
4768: , x_err_text => x_err_text
4769: );
4770:
4771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4774: RAISE FND_API.G_EXC_ERROR;
4775: END IF;

Line 4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4768: , x_err_text => x_err_text
4769: );
4770:
4771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4774: RAISE FND_API.G_EXC_ERROR;
4775: END IF;
4776:

Line 4773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4769: );
4770:
4771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4774: RAISE FND_API.G_EXC_ERROR;
4775: END IF;
4776:
4777: x_revised_item_tbl(I) := l_revised_item_rec;

Line 4774: RAISE FND_API.G_EXC_ERROR;

4770:
4771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4774: RAISE FND_API.G_EXC_ERROR;
4775: END IF;
4776:
4777: x_revised_item_tbl(I) := l_revised_item_rec;
4778:

Line 4796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4792: , x_return_status => l_return_status
4793: , x_err_text => x_err_text
4794: );
4795:
4796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4799: RAISE FND_API.G_EXC_ERROR;
4800: END IF;

Line 4797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4793: , x_err_text => x_err_text
4794: );
4795:
4796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4799: RAISE FND_API.G_EXC_ERROR;
4800: END IF;
4801:

Line 4798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4794: );
4795:
4796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4799: RAISE FND_API.G_EXC_ERROR;
4800: END IF;
4801:
4802: x_rev_component_tbl(I) := l_rev_component_rec;

Line 4799: RAISE FND_API.G_EXC_ERROR;

4795:
4796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4799: RAISE FND_API.G_EXC_ERROR;
4800: END IF;
4801:
4802: x_rev_component_tbl(I) := l_rev_component_rec;
4803:

Line 4821: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4817: , x_return_status => l_return_status
4818: , x_err_text => x_err_text
4819: );
4820:
4821: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4824: RAISE FND_API.G_EXC_ERROR;
4825: END IF;

Line 4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4818: , x_err_text => x_err_text
4819: );
4820:
4821: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4824: RAISE FND_API.G_EXC_ERROR;
4825: END IF;
4826:

Line 4823: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4819: );
4820:
4821: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4824: RAISE FND_API.G_EXC_ERROR;
4825: END IF;
4826:
4827: x_ref_designator_tbl(I) := l_ref_designator_rec;

Line 4824: RAISE FND_API.G_EXC_ERROR;

4820:
4821: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4824: RAISE FND_API.G_EXC_ERROR;
4825: END IF;
4826:
4827: x_ref_designator_tbl(I) := l_ref_designator_rec;
4828:

Line 4846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4842: , x_return_status => l_return_status
4843: , x_err_text => x_err_text
4844: );
4845:
4846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4848: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4849: RAISE FND_API.G_EXC_ERROR;
4850: END IF;

Line 4847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4843: , x_err_text => x_err_text
4844: );
4845:
4846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4848: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4849: RAISE FND_API.G_EXC_ERROR;
4850: END IF;
4851:

Line 4848: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4844: );
4845:
4846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4848: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4849: RAISE FND_API.G_EXC_ERROR;
4850: END IF;
4851:
4852: x_sub_component_tbl(I) := l_sub_component_rec;

Line 4849: RAISE FND_API.G_EXC_ERROR;

4845:
4846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4848: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4849: RAISE FND_API.G_EXC_ERROR;
4850: END IF;
4851:
4852: x_sub_component_tbl(I) := l_sub_component_rec;
4853:

Line 4860: x_return_status := FND_API.G_RET_STS_SUCCESS;

4856: END LOOP;
4857:
4858: -- Set return status
4859:
4860: x_return_status := FND_API.G_RET_STS_SUCCESS;
4861:
4862: -- Get message count and data
4863:
4864: FND_MSG_PUB.Count_And_Get

Line 4872: WHEN FND_API.G_EXC_ERROR THEN

4868:
4869:
4870: EXCEPTION
4871:
4872: WHEN FND_API.G_EXC_ERROR THEN
4873:
4874: x_return_status := FND_API.G_RET_STS_ERROR;
4875:
4876: -- Get message count and data

Line 4874: x_return_status := FND_API.G_RET_STS_ERROR;

4870: EXCEPTION
4871:
4872: WHEN FND_API.G_EXC_ERROR THEN
4873:
4874: x_return_status := FND_API.G_RET_STS_ERROR;
4875:
4876: -- Get message count and data
4877:
4878: FND_MSG_PUB.Count_And_Get

Line 4887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4883: -- Rollback
4884:
4885: ROLLBACK TO Lock_Eco_PVT;
4886:
4887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4888:
4889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4890:
4891: -- Get message count and data

Line 4889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4885: ROLLBACK TO Lock_Eco_PVT;
4886:
4887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4888:
4889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4890:
4891: -- Get message count and data
4892:
4893: FND_MSG_PUB.Count_And_Get

Line 4903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4899: ROLLBACK TO Lock_Eco_PVT;
4900:
4901: WHEN OTHERS THEN
4902:
4903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4904:
4905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4906: THEN
4907: FND_MSG_PUB.Add_Exc_Msg