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.ENG_REVISED_ITEM_UTIL dependencies on FND_API

Line 246: x_return_status := FND_API.G_RET_STS_SUCCESS;

242: , p_message_type => 'W');
243: END IF;
244: end if;
245: End loop;
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: l_err_text := G_PKG_NAME || ' :(Cancel_ECO)-Revised Item '

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

255: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
256: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
257: );
258: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260:
261: END Cancel_ECO;
262:
263: /*****************************************************************************

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345: -- End changes for bug 3668603
346:
347: BEGIN
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: FOR rev_comp IN c_getRevisedComps
352: LOOP
353: Bom_Bom_Component_Util.Cancel_Component

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
545: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
546: );
547: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:
550: END Cancel_Revised_Item;
551:
552:

Line 721: x_return_status := FND_API.G_RET_STS_SUCCESS;

717: SET new_item_revision_id = l_new_item_rev_id,
718: new_lifecycle_state_id = l_new_life_cycle_state_id
719: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_seq_id;
720:
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722:
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722:
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: WHEN OTHERS THEN
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729:

Line 728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

724: WHEN NO_DATA_FOUND THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: WHEN OTHERS THEN
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729:
730: end Update_New_Rev_Lifecycle;
731:
732:

Line 799: FND_API.G_MISS_DATE,

795: , LAST_UPDATED_BY = l_User_Id
796: , LAST_UPDATE_LOGIN = l_Login_Id
797: , IMPLEMENTATION_DATE =
798: DECODE( p_rev_item_unexp_rec.implementation_date,
799: FND_API.G_MISS_DATE,
800: to_date(NULL),
801: p_rev_item_unexp_rec.implementation_date
802: )
803: , CANCELLATION_DATE =

Line 805: FND_API.G_MISS_DATE,

801: p_rev_item_unexp_rec.implementation_date
802: )
803: , CANCELLATION_DATE =
804: DECODE(p_rev_item_unexp_rec.cancellation_date,
805: FND_API.G_MISS_DATE,
806: to_date(NULL),
807: p_rev_item_unexp_rec.cancellation_date
808: )
809: , CANCEL_COMMENTS = p_revised_item_rec.cancel_comments

Line 821: FND_API.G_MISS_DATE,

817: p_revised_item_rec.updated_revised_item_revision
818: )
819: , EARLY_SCHEDULE_DATE =
820: DECODE(p_revised_item_rec.earliest_effective_date,
821: FND_API.G_MISS_DATE,
822: to_date(NULL),
823: p_revised_item_rec.earliest_effective_date
824: )
825: , ATTRIBUTE_CATEGORY = p_revised_item_rec.attribute_category

Line 896: x_return_status := FND_API.G_RET_STS_SUCCESS;

892: , STATUS_code = nvl(p_rev_item_unexp_rec.status_code, p_revised_item_rec.status_type) -- Bug 3424007
893: WHERE REVISED_ITEM_SEQUENCE_ID = p_rev_item_unexp_rec.revised_item_sequence_id
894: ;
895:
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898:
899: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updating revised item is completed'); END IF;
900:

Line 912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

908: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
909: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
910: );
911: END IF;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913:
914: WHEN OTHERS THEN
915: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('un exp stmt_num '|| l_stmt_num); END IF;
916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

928: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
929: );
930: END IF;
931: END IF;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: END;
934: END IF; -- if call is from form, and side effects processing not requested.
935:
936: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Validation controller is '||p_control_rec.validation_controller); END IF;

Line 1075: , FND_API.G_MISS_CHAR

1071:
1072: UPDATE MTL_ITEM_REVISIONS_B
1073: SET revision =
1074: DECODE( p_revised_item_rec.updated_revised_item_revision
1075: , FND_API.G_MISS_CHAR
1076: , p_revised_item_rec.new_revised_item_revision
1077: , NULL
1078: , p_revised_item_rec.new_revised_item_revision
1079: , p_revised_item_rec.updated_revised_item_revision

Line 1084: , FND_API.G_MISS_CHAR

1080: )
1081: --Bug No:3612330 added by sseraphi to update the rev label also with rev code.
1082: , revision_label =
1083: DECODE( p_revised_item_rec.updated_revised_item_revision
1084: , FND_API.G_MISS_CHAR
1085: , p_revised_item_rec.new_revised_item_revision
1086: , NULL
1087: , p_revised_item_rec.new_revised_item_revision
1088: , p_revised_item_rec.updated_revised_item_revision

Line 1104: FND_API.G_MISS_CHAR,

1100: , p_revised_item_rec.new_effective_date
1101: )
1102: )
1103: , description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1104: FND_API.G_MISS_CHAR,
1105: description,
1106: p_revised_item_rec.new_revised_item_rev_desc)
1107: , last_update_date = SYSDATE
1108: , last_update_login = l_login_id

Line 1128: FND_API.G_MISS_CHAR,

1124: last_update_login = l_login_id, --who column
1125: last_updated_by = l_user_id, --who column
1126: /* Item revision description support Bug: 1667419*/
1127: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1128: FND_API.G_MISS_CHAR,
1129: description,
1130: p_revised_item_rec.new_revised_item_rev_desc),
1131: source_lang = l_language_code
1132: where revision_id = l_revision_id

Line 1190: FND_API.G_MISS_CHAR,

1186:
1187: UPDATE MTL_ITEM_REVISIONS_B
1188: SET
1189: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1190: FND_API.G_MISS_CHAR,
1191: description,
1192: p_revised_item_rec.new_revised_item_rev_desc)
1193: /* Bug no :2905537
1194: Revised item effectivity date updation doesnt update in item revisions table

Line 1229: FND_API.G_MISS_CHAR,

1225: last_update_date = SYSDATE, --who column
1226: last_update_login = l_login_id, --who column
1227: last_updated_by = l_user_id, --who column
1228: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1229: FND_API.G_MISS_CHAR,
1230: description,
1231: p_revised_item_rec.new_revised_item_rev_desc),
1232: source_lang = l_language_code
1233: where revision_id = l_revision_id

Line 1460: FND_API.G_MISS_CHAR,

1456: , p_revised_item_rec.new_effective_date
1457: )
1458: )
1459: , description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1460: FND_API.G_MISS_CHAR,
1461: description,
1462: p_revised_item_rec.new_revised_item_rev_desc)
1463: , last_update_date = SYSDATE
1464: , last_updated_by = l_user_id

Line 1482: FND_API.G_MISS_CHAR,

1478: last_update_date = SYSDATE, --who column
1479: last_update_login = l_login_id, --who column
1480: last_updated_by = l_user_id, --who column
1481: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1482: FND_API.G_MISS_CHAR,
1483: description,
1484: p_revised_item_rec.new_revised_item_rev_desc),
1485: source_lang = l_language_code
1486: where revision_id = l_revision_id

Line 1540: x_return_status := FND_API.G_RET_STS_SUCCESS;

1536: , p_change_notice => p_revised_item_rec.eco_name
1537: , x_Return_Status => x_return_status);
1538:
1539: end if;
1540: x_return_status := FND_API.G_RET_STS_SUCCESS;
1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: l_err_text := G_PKG_NAME ||
1544: ' : (Updating Record) ' ||

Line 1552: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1548: , p_Message_Text => l_Err_Text
1549: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1550: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1551: );
1552: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1554:
1555: END; /* Inser/Update/Delete revision and check reschedule block Ends */
1556: END IF;

Line 1601: x_return_status := FND_API.G_RET_STS_SUCCESS;

1597:
1598: l_current_lifecycle_phase_id NUMBER;
1599: BEGIN
1600:
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:
1603: l_user_id := Eng_Globals.Get_User_Id;
1604: l_login_id := Eng_Globals.Get_Login_Id;
1605: l_request_id := ENG_GLOBALS.Get_request_id;

Line 1732: FND_API.G_MISS_DATE,

1728: , SYSDATE
1729: , l_User_Id
1730: , l_Login_Id
1731: , DECODE(p_rev_item_unexp_rec.implementation_date,
1732: FND_API.G_MISS_DATE,
1733: to_date(NULL),
1734: p_rev_item_unexp_rec.implementation_date
1735: )
1736: , DECODE(p_rev_item_unexp_rec.cancellation_date,

Line 1737: FND_API.G_MISS_DATE,

1733: to_date(NULL),
1734: p_rev_item_unexp_rec.implementation_date
1735: )
1736: , DECODE(p_rev_item_unexp_rec.cancellation_date,
1737: FND_API.G_MISS_DATE,
1738: to_date(NULL),
1739: p_rev_item_unexp_rec.cancellation_date
1740: )
1741: , p_revised_item_rec.cancel_comments

Line 1760: , DECODE(p_rev_item_unexp_rec.bill_sequence_id, FND_API.G_MISS_NUM,

1756: , p_revised_item_rec.attribute14
1757: , p_revised_item_rec.attribute15
1758: , p_revised_item_rec.status_type
1759: , p_revised_item_rec.start_effective_date
1760: , DECODE(p_rev_item_unexp_rec.bill_sequence_id, FND_API.G_MISS_NUM,
1761: NULL, p_rev_item_unexp_rec.bill_sequence_id)
1762: , p_revised_item_rec.mrp_active
1763: , NULL /* Request ID */
1764: , l_prog_id

Line 1768: , DECODE(p_rev_item_unexp_rec.use_up_item_id, FND_API.G_MISS_NUM,

1764: , l_prog_id
1765: , SYSDATE
1766: , p_revised_item_rec.update_wip
1767: , p_rev_item_unexp_rec.use_up
1768: , DECODE(p_rev_item_unexp_rec.use_up_item_id, FND_API.G_MISS_NUM,
1769: NULL, p_rev_item_unexp_rec.use_up_item_id)
1770: , p_rev_item_unexp_rec.revised_item_sequence_id
1771: , p_revised_item_rec.use_up_plan_name
1772: , p_revised_item_rec.change_description

Line 1791: , DECODE(p_rev_item_unexp_rec.routing_sequence_id, FND_API.G_MISS_NUM,

1787: , p_rev_item_unexp_rec.completion_locator_id
1788: -- , p_rev_item_unexp_rec.mixed_model_map_flag
1789: , p_revised_item_rec.priority
1790: , p_revised_item_rec.ctp_flag
1791: , DECODE(p_rev_item_unexp_rec.routing_sequence_id, FND_API.G_MISS_NUM,
1792: NULL, p_rev_item_unexp_rec.routing_sequence_id )
1793: , p_revised_item_rec.new_routing_revision
1794: , p_revised_item_rec.routing_comment
1795: , p_revised_item_rec.eco_for_production

Line 1837: p_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR

1833: p_revised_item_rec.Transfer_Or_Copy is null )) --fix for bug 9556976
1834: THEN
1835: IF Eng_Default_Revised_Item.G_DEL_UPD_INS_ITEM_REV = 3 AND
1836: ( p_revised_item_rec.new_revised_item_revision IS NOT NULL OR
1837: p_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR
1838: )
1839: THEN
1840: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting item revisions . . . '); END IF;
1841: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

Line 1870: p_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR

1866: END IF;
1867:
1868: IF Eng_Default_Revised_Item.G_DEL_UPD_INS_RTG_REV = 3 AND
1869: ( p_revised_item_rec.new_routing_revision IS NOT NULL OR
1870: p_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR
1871: )
1872: THEN
1873:
1874: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting routing revisions . . .'); END IF;

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2062: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2063: );
2064: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066:
2067: END Insert_Row;
2068:
2069: /*****************************************************************************

Line 2111: x_return_status := FND_API.G_RET_STS_SUCCESS;

2107:
2108: DELETE FROM ENG_REVISED_ITEMS
2109: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;
2110:
2111: x_return_status := FND_API.G_RET_STS_SUCCESS;
2112:
2113: EXCEPTION
2114: WHEN OTHERS THEN
2115: l_err_text := G_PKG_NAME ||

Line 2125: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2121: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2122: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2123: );
2124: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2125: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2126: RETURN;
2127: END;
2128:
2129: BEGIN

Line 2170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2166: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2167: );
2168: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2169: END IF;
2170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2171: END;
2172: END Delete_Row;
2173:
2174: /*****************************************************************************

Line 2358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2354:
2355: WHEN OTHERS THEN
2356: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Revised Item: ' || SQLERRM); END IF;
2357:
2358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2359: x_revised_item_Rec := l_revised_item_rec;
2360: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2361:
2362: END Query_Row;

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

2384: , x_Return_Status OUT NOCOPY VARCHAR2
2385: )
2386: IS
2387: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2388: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2389: BEGIN
2390:
2391: IF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
2392: THEN

Line 2415: l_return_status := FND_API.G_RET_STS_SUCCESS;

2411: x_return_status := l_return_status;
2412:
2413: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_DELETE
2414: THEN
2415: l_return_status := FND_API.G_RET_STS_SUCCESS;
2416:
2417: IF p_control_rec.caller_type <> 'FORM'
2418: THEN
2419: -- ENG_Validate_Revised_Item.Check_Entity_Delete

Line 2428: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2424: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
2425: );
2426: END IF;
2427:
2428: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2429: -- Okay to Delete the item.
2430: Delete_Row
2431: ( p_revised_item_sequence_id =>
2432: p_rev_item_unexp_rec.revised_item_sequence_id

Line 2466: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

2462: * related replicated components.
2463: *********************************************************************/
2464: PROCEDURE Reschedule_Revised_Item
2465: ( p_api_version IN NUMBER := 1.0 --
2466: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
2467: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
2468: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --
2469: , p_debug IN VARCHAR2 := 'N' --
2470: , p_output_dir IN VARCHAR2 := NULL --

Line 2467: , p_commit IN VARCHAR2 := FND_API.G_FALSE --

2463: *********************************************************************/
2464: PROCEDURE Reschedule_Revised_Item
2465: ( p_api_version IN NUMBER := 1.0 --
2466: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
2467: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
2468: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --
2469: , p_debug IN VARCHAR2 := 'N' --
2470: , p_output_dir IN VARCHAR2 := NULL --
2471: , p_debug_filename IN VARCHAR2 := 'Resch_RevItem.log' --

Line 2468: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --

2464: PROCEDURE Reschedule_Revised_Item
2465: ( p_api_version IN NUMBER := 1.0 --
2466: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
2467: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
2468: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --
2469: , p_debug IN VARCHAR2 := 'N' --
2470: , p_output_dir IN VARCHAR2 := NULL --
2471: , p_debug_filename IN VARCHAR2 := 'Resch_RevItem.log' --
2472: , x_return_status OUT NOCOPY VARCHAR2 --

Line 2528: x_return_status := FND_API.G_RET_STS_SUCCESS;

2524: END IF;
2525:
2526: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('-***-Start API Reschedule_Revised_Item-***-'); END IF;
2527: SAVEPOINT Reschedule_Revised_Item_SP;
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529:
2530: -- Standard call to check for call compatibility
2531: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2532: THEN

Line 2531: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

2527: SAVEPOINT Reschedule_Revised_Item_SP;
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529:
2530: -- Standard call to check for call compatibility
2531: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2532: THEN
2533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2534: END IF;
2535:

Line 2533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2529:
2530: -- Standard call to check for call compatibility
2531: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2532: THEN
2533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2534: END IF;
2535:
2536: -- Initialize message list if p_init_msg_list is set to TRUE.
2537: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2537: IF FND_API.to_Boolean(p_init_msg_list) THEN

2533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2534: END IF;
2535:
2536: -- Initialize message list if p_init_msg_list is set to TRUE.
2537: IF FND_API.to_Boolean(p_init_msg_list) THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:
2541: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Fetch the revised Item Details'); END IF;

Line 2613: IF FND_API.To_Boolean (p_commit)

2609: AND revised_item_sequence_id = p_revised_item_sequence_id;
2610: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updated '|| SQL%ROWCOUNT ||'rows for routing revision effectivity'); END IF;
2611:
2612: CLOSE c_revised_item;
2613: IF FND_API.To_Boolean (p_commit)
2614: THEN
2615: COMMIT WORK;
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get

Line 2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2626: EXCEPTION
2627: WHEN OTHERS THEN
2628: ROLLBACK TO Reschedule_Revised_Item_SP;
2629: CLOSE c_revised_item;
2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2632: THEN
2633: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2634: END IF;

Line 2694: x_return_status := FND_API.G_RET_STS_SUCCESS;

2690: --
2691: -- Initialize OUT variables
2692: --
2693: x_new_revised_item_seq_id := NULL;
2694: x_return_status := FND_API.G_RET_STS_SUCCESS;
2695: --
2696: -- Processing Begins
2697: --
2698: OPEN c_revised_item(p_old_revised_item_seq_id);

Line 2752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2748: IF c_revised_item%ISOPEN THEN
2749: CLOSE c_revised_item;
2750: END IF;
2751: x_new_revised_item_seq_id := NULL;
2752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2753:
2754: END Copy_Revised_Item;
2755:
2756: END ENG_Revised_Item_Util;