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 1342: , p_error_status => FND_API.G_RET_STS_ERROR

1338: ( p_rev_operation_tbl => l_rev_operation_tbl
1339: , p_rev_op_resource_tbl => l_rev_op_resource_tbl
1340: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl
1341: , p_mesg_token_tbl => l_mesg_token_tbl
1342: , p_error_status => FND_API.G_RET_STS_ERROR
1343: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1344: , p_error_level => Error_Handler.G_OP_LEVEL
1345: , p_entity_index => I
1346: , x_eco_rec => l_eco_rec

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

1461: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1462: l_other_message VARCHAR2(50);
1463: l_err_text VARCHAR2(2000);
1464: l_valid BOOLEAN := TRUE;
1465: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1466: l_bo_return_status VARCHAR2(1) := 'S';
1467: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;
1468: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1469: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;

Line 1500: l_return_status := FND_API.G_RET_STS_SUCCESS;

1496:
1497: l_sub_component_rec.transaction_type :=
1498: UPPER(l_sub_component_rec.transaction_type);
1499:
1500: l_return_status := FND_API.G_RET_STS_SUCCESS;
1501: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1502:
1503: -- Process Flow step 3: Verify Substitute Component's existence
1504: --

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

1497: l_sub_component_rec.transaction_type :=
1498: UPPER(l_sub_component_rec.transaction_type);
1499:
1500: l_return_status := FND_API.G_RET_STS_SUCCESS;
1501: l_sub_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1502:
1503: -- Process Flow step 3: Verify Substitute Component's existence
1504: --
1505:

Line 1646: , p_error_status => FND_API.G_RET_STS_ERROR

1642: Eco_Error_Handler.Log_Error
1643: ( p_ref_designator_tbl => l_ref_designator_tbl
1644: , p_sub_component_tbl => l_sub_component_tbl
1645: , p_mesg_token_tbl => l_mesg_token_tbl
1646: , p_error_status => FND_API.G_RET_STS_ERROR
1647: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1648: , p_error_level => 6
1649: , p_entity_index => I
1650: , x_eco_rec => l_eco_rec

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

1761: l_other_token_tbl Error_Handler.Token_Tbl_Type;
1762: l_other_message VARCHAR2(50);
1763: l_err_text VARCHAR2(2000);
1764: l_valid BOOLEAN := TRUE;
1765: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1766: l_bo_return_status VARCHAR2(1) := 'S';
1767: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;
1768: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1769: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;

Line 1800: l_return_status := FND_API.G_RET_STS_SUCCESS;

1796:
1797: l_ref_designator_rec.transaction_type :=
1798: UPPER(l_ref_designator_rec.transaction_type);
1799:
1800: l_return_status := FND_API.G_RET_STS_SUCCESS;
1801: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1802:
1803: -- Process Flow step 3: Verify Reference Designator's existence
1804: --

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

1797: l_ref_designator_rec.transaction_type :=
1798: UPPER(l_ref_designator_rec.transaction_type);
1799:
1800: l_return_status := FND_API.G_RET_STS_SUCCESS;
1801: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1802:
1803: -- Process Flow step 3: Verify Reference Designator's existence
1804: --
1805:

Line 1893: , p_error_status => FND_API.G_RET_STS_ERROR

1889: Eco_Error_Handler.Log_Error
1890: ( p_ref_designator_tbl => l_ref_designator_tbl
1891: , p_sub_component_tbl => l_sub_component_tbl
1892: , p_mesg_token_tbl => l_mesg_token_tbl
1893: , p_error_status => FND_API.G_RET_STS_ERROR
1894: , p_error_scope => Error_Handler.G_SCOPE_RECORD
1895: , p_error_level => 5
1896: , p_entity_index => I
1897: , x_eco_rec => l_eco_rec

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

2015: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2016: l_other_message VARCHAR2(50);
2017: l_err_text VARCHAR2(2000);
2018: l_valid BOOLEAN := TRUE;
2019: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2020: l_bo_return_status VARCHAR2(1) := 'S';
2021: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;
2022: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2023: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;

Line 2057: l_return_status := FND_API.G_RET_STS_SUCCESS;

2053:
2054: l_rev_component_rec.transaction_type :=
2055: UPPER(l_rev_component_rec.transaction_type);
2056:
2057: l_return_status := FND_API.G_RET_STS_SUCCESS;
2058: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2059:
2060: -- Process Flow step 3: Verify Revised Component's existence
2061: --

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

2054: l_rev_component_rec.transaction_type :=
2055: UPPER(l_rev_component_rec.transaction_type);
2056:
2057: l_return_status := FND_API.G_RET_STS_SUCCESS;
2058: l_rev_component_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2059:
2060: -- Process Flow step 3: Verify Revised Component's existence
2061: --
2062:

Line 2394: , p_error_status => FND_API.G_RET_STS_ERROR

2390: ( p_rev_component_tbl => l_rev_component_tbl
2391: , p_ref_designator_tbl => l_ref_designator_tbl
2392: , p_sub_component_tbl => l_sub_component_tbl
2393: , p_mesg_token_tbl => l_mesg_token_tbl
2394: , p_error_status => FND_API.G_RET_STS_ERROR
2395: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2396: , p_error_level => 4
2397: , p_entity_index => I
2398: , x_eco_rec => l_eco_rec

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

2519: l_other_token_tbl Error_Handler.Token_Tbl_Type;
2520: l_other_message VARCHAR2(50);
2521: l_err_text VARCHAR2(2000);
2522: l_valid BOOLEAN := TRUE;
2523: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2524: l_bo_return_status VARCHAR2(1) := 'S';
2525: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2526: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2527: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;

Line 2566: l_return_status := FND_API.G_RET_STS_SUCCESS;

2562:
2563: l_revised_item_rec.transaction_type :=
2564: UPPER(l_revised_item_rec.transaction_type);
2565:
2566: l_return_status := FND_API.G_RET_STS_SUCCESS;
2567: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2568:
2569: -- Process Flow step 3: Verify ECO's existence
2570: --

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

2563: l_revised_item_rec.transaction_type :=
2564: UPPER(l_revised_item_rec.transaction_type);
2565:
2566: l_return_status := FND_API.G_RET_STS_SUCCESS;
2567: l_revised_item_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2568:
2569: -- Process Flow step 3: Verify ECO's existence
2570: --
2571:

Line 2894: , p_error_status => FND_API.G_RET_STS_ERROR

2890: , p_rev_operation_tbl => l_rev_operation_tbl --add
2891: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
2892: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
2893: , p_mesg_token_tbl => l_mesg_token_tbl
2894: , p_error_status => FND_API.G_RET_STS_ERROR
2895: , p_error_scope => Error_Handler.G_SCOPE_RECORD
2896: , p_error_level => 3
2897: , p_entity_index => I
2898: , x_ECO_rec => l_ECO_rec

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

3024: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3025: l_other_message VARCHAR2(50);
3026: l_err_text VARCHAR2(2000);
3027: l_valid BOOLEAN := TRUE;
3028: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3029: l_bo_return_status VARCHAR2(1) := 'S';
3030: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;
3031: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3032: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;

Line 3063: l_return_status := FND_API.G_RET_STS_SUCCESS;

3059:
3060: l_eco_revision_rec.transaction_type :=
3061: UPPER(l_eco_revision_rec.transaction_type);
3062:
3063: l_return_status := FND_API.G_RET_STS_SUCCESS;
3064: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3065:
3066: IF g_control_rec.attribute_defaulting
3067: THEN

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

3060: l_eco_revision_rec.transaction_type :=
3061: UPPER(l_eco_revision_rec.transaction_type);
3062:
3063: l_return_status := FND_API.G_RET_STS_SUCCESS;
3064: l_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3065:
3066: IF g_control_rec.attribute_defaulting
3067: THEN
3068:

Line 3184: , p_error_status => FND_API.G_RET_STS_ERROR

3180: , p_rev_operation_tbl => l_rev_operation_tbl --add
3181: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3182: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3183: , p_mesg_token_tbl => l_mesg_token_tbl
3184: , p_error_status => FND_API.G_RET_STS_ERROR
3185: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3186: , p_error_level => 2
3187: , p_entity_index => I
3188: , x_eco_rec => l_eco_rec

Line 3227: , p_error_status => FND_API.G_RET_STS_ERROR

3223: , p_rev_operation_tbl => l_rev_operation_tbl --add
3224: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3225: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3226: , p_mesg_token_tbl => l_mesg_token_tbl
3227: , p_error_status => FND_API.G_RET_STS_ERROR
3228: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3229: , p_error_level => 2
3230: , p_entity_index => I
3231: , x_eco_rec => l_eco_rec

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

3314: l_other_token_tbl Error_Handler.Token_Tbl_Type;
3315: l_other_message VARCHAR2(50);
3316: l_err_text VARCHAR2(2000);
3317: l_valid BOOLEAN := TRUE;
3318: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3319: l_bo_return_status VARCHAR2(1) := 'S';
3320: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
3321: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3322: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;

Line 3360: l_return_status := FND_API.G_RET_STS_SUCCESS;

3356:
3357: l_ECO_rec := p_ECO_rec;
3358: l_ECO_rec.transaction_type := UPPER(l_eco_rec.transaction_type);
3359:
3360: l_return_status := FND_API.G_RET_STS_SUCCESS;
3361: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3362:
3363: -- Process Flow step 3: Verify ECO's existence
3364: --

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

3357: l_ECO_rec := p_ECO_rec;
3358: l_ECO_rec.transaction_type := UPPER(l_eco_rec.transaction_type);
3359:
3360: l_return_status := FND_API.G_RET_STS_SUCCESS;
3361: l_eco_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3362:
3363: -- Process Flow step 3: Verify ECO's existence
3364: --
3365:

Line 3706: , p_error_status => FND_API.G_RET_STS_ERROR

3702: , p_rev_operation_tbl => l_rev_operation_tbl --add
3703: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
3704: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
3705: , p_mesg_token_tbl => l_mesg_token_tbl
3706: , p_error_status => FND_API.G_RET_STS_ERROR
3707: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3708: , p_error_level => 1
3709: , x_ECO_rec => l_ECO_rec
3710: , x_eco_revision_tbl => l_eco_revision_tbl

Line 4485: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR

4481: , p_rev_operation_tbl => l_rev_operation_tbl --add
4482: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4483: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4484: , p_mesg_token_tbl => l_mesg_token_tbl
4485: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4486: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4487: , p_other_message => l_other_message
4488: , p_other_token_tbl => l_other_token_tbl
4489: , p_error_level => 0

Line 4584: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR

4580: , p_rev_operation_tbl => l_rev_operation_tbl --add
4581: , p_rev_op_resource_tbl => l_rev_op_resource_tbl --add
4582: , p_rev_sub_resource_tbl => l_rev_sub_resource_tbl --add
4583: , p_mesg_token_tbl => l_mesg_token_tbl
4584: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
4585: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
4586: , p_other_message => l_other_message
4587: , p_other_token_tbl => l_other_token_tbl
4588: , p_error_level => 0

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

4638: -- End of Comments
4639:
4640: PROCEDURE Lock_Eco
4641: ( p_api_version_number IN NUMBER
4642: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4643: , x_return_status IN OUT NOCOPY VARCHAR2
4644: , x_msg_count IN OUT NOCOPY NUMBER
4645: , x_msg_data IN OUT NOCOPY VARCHAR2
4646: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=

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

4665: )
4666: IS
4667: l_api_version_number CONSTANT NUMBER := 1.0;
4668: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
4669: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4670: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
4671: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
4672: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
4673: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;

Line 4683: IF NOT FND_API.Compatible_API_Call

4679: NULL;
4680:
4681: /*********************** Temporarily commented *****************************
4682:
4683: IF NOT FND_API.Compatible_API_Call
4684: ( l_api_version_number
4685: , p_api_version_number
4686: , l_api_name
4687: , G_PKG_NAME

Line 4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4686: , l_api_name
4687: , G_PKG_NAME
4688: )
4689: THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: END IF;
4692:
4693: -- Initialize message list.
4694:

Line 4695: IF FND_API.to_Boolean(p_init_msg_list) THEN

4691: END IF;
4692:
4693: -- Initialize message list.
4694:
4695: IF FND_API.to_Boolean(p_init_msg_list) THEN
4696: FND_MSG_PUB.initialize;
4697: END IF;
4698:
4699: -- Set Savepoint

Line 4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4710: , x_return_status => l_return_status
4711: , x_err_text => x_err_text
4712: );
4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;

Line 4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4711: , x_err_text => x_err_text
4712: );
4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719:

Line 4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4712: );
4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719:
4720:

Line 4717: RAISE FND_API.G_EXC_ERROR;

4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719:
4720:
4721: END IF;

Line 4736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4732: , x_return_status => l_return_status
4733: , x_err_text => x_err_text
4734: );
4735:
4736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4739: RAISE FND_API.G_EXC_ERROR;
4740: END IF;

Line 4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4733: , x_err_text => x_err_text
4734: );
4735:
4736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4739: RAISE FND_API.G_EXC_ERROR;
4740: END IF;
4741:

Line 4738: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4734: );
4735:
4736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4739: RAISE FND_API.G_EXC_ERROR;
4740: END IF;
4741:
4742: x_eco_revision_tbl(I) := l_eco_revision_rec;

Line 4739: RAISE FND_API.G_EXC_ERROR;

4735:
4736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4739: RAISE FND_API.G_EXC_ERROR;
4740: END IF;
4741:
4742: x_eco_revision_tbl(I) := l_eco_revision_rec;
4743:

Line 4761: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4757: , x_return_status => l_return_status
4758: , x_err_text => x_err_text
4759: );
4760:
4761: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4763: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4764: RAISE FND_API.G_EXC_ERROR;
4765: END IF;

Line 4762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4758: , x_err_text => x_err_text
4759: );
4760:
4761: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4763: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4764: RAISE FND_API.G_EXC_ERROR;
4765: END IF;
4766:

Line 4763: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4759: );
4760:
4761: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4763: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4764: RAISE FND_API.G_EXC_ERROR;
4765: END IF;
4766:
4767: x_revised_item_tbl(I) := l_revised_item_rec;

Line 4764: RAISE FND_API.G_EXC_ERROR;

4760:
4761: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4763: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4764: RAISE FND_API.G_EXC_ERROR;
4765: END IF;
4766:
4767: x_revised_item_tbl(I) := l_revised_item_rec;
4768:

Line 4786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4782: , x_return_status => l_return_status
4783: , x_err_text => x_err_text
4784: );
4785:
4786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4789: RAISE FND_API.G_EXC_ERROR;
4790: END IF;

Line 4787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4783: , x_err_text => x_err_text
4784: );
4785:
4786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4789: RAISE FND_API.G_EXC_ERROR;
4790: END IF;
4791:

Line 4788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4784: );
4785:
4786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4789: RAISE FND_API.G_EXC_ERROR;
4790: END IF;
4791:
4792: x_rev_component_tbl(I) := l_rev_component_rec;

Line 4789: RAISE FND_API.G_EXC_ERROR;

4785:
4786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4789: RAISE FND_API.G_EXC_ERROR;
4790: END IF;
4791:
4792: x_rev_component_tbl(I) := l_rev_component_rec;
4793:

Line 4811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4807: , x_return_status => l_return_status
4808: , x_err_text => x_err_text
4809: );
4810:
4811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: END IF;

Line 4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4808: , x_err_text => x_err_text
4809: );
4810:
4811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: END IF;
4816:

Line 4813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4809: );
4810:
4811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: END IF;
4816:
4817: x_ref_designator_tbl(I) := l_ref_designator_rec;

Line 4814: RAISE FND_API.G_EXC_ERROR;

4810:
4811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4814: RAISE FND_API.G_EXC_ERROR;
4815: END IF;
4816:
4817: x_ref_designator_tbl(I) := l_ref_designator_rec;
4818:

Line 4836: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4832: , x_return_status => l_return_status
4833: , x_err_text => x_err_text
4834: );
4835:
4836: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4838: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4839: RAISE FND_API.G_EXC_ERROR;
4840: END IF;

Line 4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4833: , x_err_text => x_err_text
4834: );
4835:
4836: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4838: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4839: RAISE FND_API.G_EXC_ERROR;
4840: END IF;
4841:

Line 4838: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4834: );
4835:
4836: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4838: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4839: RAISE FND_API.G_EXC_ERROR;
4840: END IF;
4841:
4842: x_sub_component_tbl(I) := l_sub_component_rec;

Line 4839: RAISE FND_API.G_EXC_ERROR;

4835:
4836: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4838: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4839: RAISE FND_API.G_EXC_ERROR;
4840: END IF;
4841:
4842: x_sub_component_tbl(I) := l_sub_component_rec;
4843:

Line 4850: x_return_status := FND_API.G_RET_STS_SUCCESS;

4846: END LOOP;
4847:
4848: -- Set return status
4849:
4850: x_return_status := FND_API.G_RET_STS_SUCCESS;
4851:
4852: -- Get message count and data
4853:
4854: FND_MSG_PUB.Count_And_Get

Line 4862: WHEN FND_API.G_EXC_ERROR THEN

4858:
4859:
4860: EXCEPTION
4861:
4862: WHEN FND_API.G_EXC_ERROR THEN
4863:
4864: x_return_status := FND_API.G_RET_STS_ERROR;
4865:
4866: -- Get message count and data

Line 4864: x_return_status := FND_API.G_RET_STS_ERROR;

4860: EXCEPTION
4861:
4862: WHEN FND_API.G_EXC_ERROR THEN
4863:
4864: x_return_status := FND_API.G_RET_STS_ERROR;
4865:
4866: -- Get message count and data
4867:
4868: FND_MSG_PUB.Count_And_Get

Line 4877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4873: -- Rollback
4874:
4875: ROLLBACK TO Lock_Eco_PVT;
4876:
4877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4878:
4879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4880:
4881: -- Get message count and data

Line 4879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4875: ROLLBACK TO Lock_Eco_PVT;
4876:
4877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4878:
4879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4880:
4881: -- Get message count and data
4882:
4883: FND_MSG_PUB.Count_And_Get

Line 4893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4889: ROLLBACK TO Lock_Eco_PVT;
4890:
4891: WHEN OTHERS THEN
4892:
4893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4894:
4895: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4896: THEN
4897: FND_MSG_PUB.Add_Exc_Msg