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 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

225: , p_message_type => 'W');
226: END IF;
227: end if;
228: End loop;
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: l_err_text := G_PKG_NAME || ' :(Cancel_ECO)-Revised Item '

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

238: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
239: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
240: );
241: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243:
244: END Cancel_ECO;
245:
246: /*****************************************************************************

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328: -- End changes for bug 3668603
329:
330: BEGIN
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: FOR rev_comp IN c_getRevisedComps
335: LOOP
336: Bom_Bom_Component_Util.Cancel_Component

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
528: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
529: );
530: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532:
533: END Cancel_Revised_Item;
534:
535:

Line 704: x_return_status := FND_API.G_RET_STS_SUCCESS;

700: SET new_item_revision_id = l_new_item_rev_id,
701: new_lifecycle_state_id = l_new_life_cycle_state_id
702: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_seq_id;
703:
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705:
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705:
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709:
710: WHEN OTHERS THEN
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712:

Line 711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

707: WHEN NO_DATA_FOUND THEN
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709:
710: WHEN OTHERS THEN
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712:
713: end Update_New_Rev_Lifecycle;
714:
715:

Line 782: FND_API.G_MISS_DATE,

778: , LAST_UPDATED_BY = l_User_Id
779: , LAST_UPDATE_LOGIN = l_Login_Id
780: , IMPLEMENTATION_DATE =
781: DECODE( p_rev_item_unexp_rec.implementation_date,
782: FND_API.G_MISS_DATE,
783: to_date(NULL),
784: p_rev_item_unexp_rec.implementation_date
785: )
786: , CANCELLATION_DATE =

Line 788: FND_API.G_MISS_DATE,

784: p_rev_item_unexp_rec.implementation_date
785: )
786: , CANCELLATION_DATE =
787: DECODE(p_rev_item_unexp_rec.cancellation_date,
788: FND_API.G_MISS_DATE,
789: to_date(NULL),
790: p_rev_item_unexp_rec.cancellation_date
791: )
792: , CANCEL_COMMENTS = p_revised_item_rec.cancel_comments

Line 804: FND_API.G_MISS_DATE,

800: p_revised_item_rec.updated_revised_item_revision
801: )
802: , EARLY_SCHEDULE_DATE =
803: DECODE(p_revised_item_rec.earliest_effective_date,
804: FND_API.G_MISS_DATE,
805: to_date(NULL),
806: p_revised_item_rec.earliest_effective_date
807: )
808: , ATTRIBUTE_CATEGORY = p_revised_item_rec.attribute_category

Line 879: x_return_status := FND_API.G_RET_STS_SUCCESS;

875: , STATUS_code = nvl(p_rev_item_unexp_rec.status_code, p_revised_item_rec.status_type) -- Bug 3424007
876: WHERE REVISED_ITEM_SEQUENCE_ID = p_rev_item_unexp_rec.revised_item_sequence_id
877: ;
878:
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880:
881:
882: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updating revised item is completed'); END IF;
883:

Line 895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

891: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
892: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
893: );
894: END IF;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896:
897: WHEN OTHERS THEN
898: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('un exp stmt_num '|| l_stmt_num); END IF;
899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

911: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
912: );
913: END IF;
914: END IF;
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: END;
917: END IF; -- if call is from form, and side effects processing not requested.
918:
919: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Validation controller is '||p_control_rec.validation_controller); END IF;

Line 1058: , FND_API.G_MISS_CHAR

1054:
1055: UPDATE MTL_ITEM_REVISIONS_B
1056: SET revision =
1057: DECODE( p_revised_item_rec.updated_revised_item_revision
1058: , FND_API.G_MISS_CHAR
1059: , p_revised_item_rec.new_revised_item_revision
1060: , NULL
1061: , p_revised_item_rec.new_revised_item_revision
1062: , p_revised_item_rec.updated_revised_item_revision

Line 1067: , FND_API.G_MISS_CHAR

1063: )
1064: --Bug No:3612330 added by sseraphi to update the rev label also with rev code.
1065: , revision_label =
1066: DECODE( p_revised_item_rec.updated_revised_item_revision
1067: , FND_API.G_MISS_CHAR
1068: , p_revised_item_rec.new_revised_item_revision
1069: , NULL
1070: , p_revised_item_rec.new_revised_item_revision
1071: , p_revised_item_rec.updated_revised_item_revision

Line 1087: FND_API.G_MISS_CHAR,

1083: , p_revised_item_rec.new_effective_date
1084: )
1085: )
1086: , description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1087: FND_API.G_MISS_CHAR,
1088: description,
1089: p_revised_item_rec.new_revised_item_rev_desc)
1090: , last_update_date = SYSDATE
1091: , last_update_login = l_login_id

Line 1111: FND_API.G_MISS_CHAR,

1107: last_update_login = l_login_id, --who column
1108: last_updated_by = l_user_id, --who column
1109: /* Item revision description support Bug: 1667419*/
1110: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1111: FND_API.G_MISS_CHAR,
1112: description,
1113: p_revised_item_rec.new_revised_item_rev_desc),
1114: source_lang = l_language_code
1115: where revision_id = l_revision_id

Line 1173: FND_API.G_MISS_CHAR,

1169:
1170: UPDATE MTL_ITEM_REVISIONS_B
1171: SET
1172: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1173: FND_API.G_MISS_CHAR,
1174: description,
1175: p_revised_item_rec.new_revised_item_rev_desc)
1176: /* Bug no :2905537
1177: Revised item effectivity date updation doesnt update in item revisions table

Line 1212: FND_API.G_MISS_CHAR,

1208: last_update_date = SYSDATE, --who column
1209: last_update_login = l_login_id, --who column
1210: last_updated_by = l_user_id, --who column
1211: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1212: FND_API.G_MISS_CHAR,
1213: description,
1214: p_revised_item_rec.new_revised_item_rev_desc),
1215: source_lang = l_language_code
1216: where revision_id = l_revision_id

Line 1442: FND_API.G_MISS_CHAR,

1438: , p_revised_item_rec.new_effective_date
1439: )
1440: )
1441: , description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1442: FND_API.G_MISS_CHAR,
1443: description,
1444: p_revised_item_rec.new_revised_item_rev_desc)
1445: , last_update_date = SYSDATE
1446: , last_updated_by = l_user_id

Line 1464: FND_API.G_MISS_CHAR,

1460: last_update_date = SYSDATE, --who column
1461: last_update_login = l_login_id, --who column
1462: last_updated_by = l_user_id, --who column
1463: description = Decode(p_revised_item_rec.new_revised_item_rev_desc,
1464: FND_API.G_MISS_CHAR,
1465: description,
1466: p_revised_item_rec.new_revised_item_rev_desc),
1467: source_lang = l_language_code
1468: where revision_id = l_revision_id

Line 1522: x_return_status := FND_API.G_RET_STS_SUCCESS;

1518: , p_change_notice => p_revised_item_rec.eco_name
1519: , x_Return_Status => x_return_status);
1520:
1521: end if;
1522: x_return_status := FND_API.G_RET_STS_SUCCESS;
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: l_err_text := G_PKG_NAME ||
1526: ' : (Updating Record) ' ||

Line 1534: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1530: , p_Message_Text => l_Err_Text
1531: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1532: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1533: );
1534: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1536:
1537: END; /* Inser/Update/Delete revision and check reschedule block Ends */
1538: END IF;

Line 1583: x_return_status := FND_API.G_RET_STS_SUCCESS;

1579:
1580: l_current_lifecycle_phase_id NUMBER;
1581: BEGIN
1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: l_user_id := Eng_Globals.Get_User_Id;
1586: l_login_id := Eng_Globals.Get_Login_Id;
1587: l_request_id := ENG_GLOBALS.Get_request_id;

Line 1714: FND_API.G_MISS_DATE,

1710: , SYSDATE
1711: , l_User_Id
1712: , l_Login_Id
1713: , DECODE(p_rev_item_unexp_rec.implementation_date,
1714: FND_API.G_MISS_DATE,
1715: to_date(NULL),
1716: p_rev_item_unexp_rec.implementation_date
1717: )
1718: , DECODE(p_rev_item_unexp_rec.cancellation_date,

Line 1719: FND_API.G_MISS_DATE,

1715: to_date(NULL),
1716: p_rev_item_unexp_rec.implementation_date
1717: )
1718: , DECODE(p_rev_item_unexp_rec.cancellation_date,
1719: FND_API.G_MISS_DATE,
1720: to_date(NULL),
1721: p_rev_item_unexp_rec.cancellation_date
1722: )
1723: , p_revised_item_rec.cancel_comments

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

1738: , p_revised_item_rec.attribute14
1739: , p_revised_item_rec.attribute15
1740: , p_revised_item_rec.status_type
1741: , p_revised_item_rec.start_effective_date
1742: , DECODE(p_rev_item_unexp_rec.bill_sequence_id, FND_API.G_MISS_NUM,
1743: NULL, p_rev_item_unexp_rec.bill_sequence_id)
1744: , p_revised_item_rec.mrp_active
1745: , NULL /* Request ID */
1746: , l_prog_id

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

1746: , l_prog_id
1747: , SYSDATE
1748: , p_revised_item_rec.update_wip
1749: , p_rev_item_unexp_rec.use_up
1750: , DECODE(p_rev_item_unexp_rec.use_up_item_id, FND_API.G_MISS_NUM,
1751: NULL, p_rev_item_unexp_rec.use_up_item_id)
1752: , p_rev_item_unexp_rec.revised_item_sequence_id
1753: , p_revised_item_rec.use_up_plan_name
1754: , p_revised_item_rec.change_description

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

1769: , p_rev_item_unexp_rec.completion_locator_id
1770: -- , p_rev_item_unexp_rec.mixed_model_map_flag
1771: , p_revised_item_rec.priority
1772: , p_revised_item_rec.ctp_flag
1773: , DECODE(p_rev_item_unexp_rec.routing_sequence_id, FND_API.G_MISS_NUM,
1774: NULL, p_rev_item_unexp_rec.routing_sequence_id )
1775: , p_revised_item_rec.new_routing_revision
1776: , p_revised_item_rec.routing_comment
1777: , p_revised_item_rec.eco_for_production

Line 1813: p_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR

1809: p_control_rec.caller_type <> 'FORM'
1810: THEN
1811: IF Eng_Default_Revised_Item.G_DEL_UPD_INS_ITEM_REV = 3 AND
1812: ( p_revised_item_rec.new_revised_item_revision IS NOT NULL OR
1813: p_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR
1814: )
1815: THEN
1816: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting item revisions . . . '); END IF;
1817: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

Line 1846: p_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR

1842: END IF;
1843:
1844: IF Eng_Default_Revised_Item.G_DEL_UPD_INS_RTG_REV = 3 AND
1845: ( p_revised_item_rec.new_routing_revision IS NOT NULL OR
1846: p_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR
1847: )
1848: THEN
1849:
1850: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting routing revisions . . .'); END IF;

Line 2041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2037: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2038: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2039: );
2040: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2042:
2043: END Insert_Row;
2044:
2045: /*****************************************************************************

Line 2087: x_return_status := FND_API.G_RET_STS_SUCCESS;

2083:
2084: DELETE FROM ENG_REVISED_ITEMS
2085: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;
2086:
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088:
2089: EXCEPTION
2090: WHEN OTHERS THEN
2091: l_err_text := G_PKG_NAME ||

Line 2101: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2097: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2098: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2099: );
2100: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2101: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2102: RETURN;
2103: END;
2104:
2105: BEGIN

Line 2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2142: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2143: );
2144: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2145: END IF;
2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2147: END;
2148: END Delete_Row;
2149:
2150: /*****************************************************************************

Line 2334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2330:
2331: WHEN OTHERS THEN
2332: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Revised Item: ' || SQLERRM); END IF;
2333:
2334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2335: x_revised_item_Rec := l_revised_item_rec;
2336: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2337:
2338: END Query_Row;

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

2360: , x_Return_Status OUT NOCOPY VARCHAR2
2361: )
2362: IS
2363: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2364: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2365: BEGIN
2366:
2367: IF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
2368: THEN

Line 2391: l_return_status := FND_API.G_RET_STS_SUCCESS;

2387: x_return_status := l_return_status;
2388:
2389: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_DELETE
2390: THEN
2391: l_return_status := FND_API.G_RET_STS_SUCCESS;
2392:
2393: IF p_control_rec.caller_type <> 'FORM'
2394: THEN
2395: -- ENG_Validate_Revised_Item.Check_Entity_Delete

Line 2404: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2400: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
2401: );
2402: END IF;
2403:
2404: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2405: -- Okay to Delete the item.
2406: Delete_Row
2407: ( p_revised_item_sequence_id =>
2408: p_rev_item_unexp_rec.revised_item_sequence_id

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

2438: * related replicated components.
2439: *********************************************************************/
2440: PROCEDURE Reschedule_Revised_Item
2441: ( p_api_version IN NUMBER := 1.0 --
2442: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
2443: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
2444: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --
2445: , p_debug IN VARCHAR2 := 'N' --
2446: , p_output_dir IN VARCHAR2 := NULL --

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

2439: *********************************************************************/
2440: PROCEDURE Reschedule_Revised_Item
2441: ( p_api_version IN NUMBER := 1.0 --
2442: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
2443: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
2444: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --
2445: , p_debug IN VARCHAR2 := 'N' --
2446: , p_output_dir IN VARCHAR2 := NULL --
2447: , p_debug_filename IN VARCHAR2 := 'Resch_RevItem.log' --

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

2440: PROCEDURE Reschedule_Revised_Item
2441: ( p_api_version IN NUMBER := 1.0 --
2442: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
2443: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
2444: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL --
2445: , p_debug IN VARCHAR2 := 'N' --
2446: , p_output_dir IN VARCHAR2 := NULL --
2447: , p_debug_filename IN VARCHAR2 := 'Resch_RevItem.log' --
2448: , x_return_status OUT NOCOPY VARCHAR2 --

Line 2504: x_return_status := FND_API.G_RET_STS_SUCCESS;

2500: END IF;
2501:
2502: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('-***-Start API Reschedule_Revised_Item-***-'); END IF;
2503: SAVEPOINT Reschedule_Revised_Item_SP;
2504: x_return_status := FND_API.G_RET_STS_SUCCESS;
2505:
2506: -- Standard call to check for call compatibility
2507: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2508: THEN

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

2503: SAVEPOINT Reschedule_Revised_Item_SP;
2504: x_return_status := FND_API.G_RET_STS_SUCCESS;
2505:
2506: -- Standard call to check for call compatibility
2507: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2508: THEN
2509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2510: END IF;
2511:

Line 2509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2505:
2506: -- Standard call to check for call compatibility
2507: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2508: THEN
2509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2510: END IF;
2511:
2512: -- Initialize message list if p_init_msg_list is set to TRUE.
2513: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2513: IF FND_API.to_Boolean(p_init_msg_list) THEN

2509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2510: END IF;
2511:
2512: -- Initialize message list if p_init_msg_list is set to TRUE.
2513: IF FND_API.to_Boolean(p_init_msg_list) THEN
2514: FND_MSG_PUB.initialize;
2515: END IF;
2516:
2517: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Fetch the revised Item Details'); END IF;

Line 2589: IF FND_API.To_Boolean (p_commit)

2585: AND revised_item_sequence_id = p_revised_item_sequence_id;
2586: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updated '|| SQL%ROWCOUNT ||'rows for routing revision effectivity'); END IF;
2587:
2588: CLOSE c_revised_item;
2589: IF FND_API.To_Boolean (p_commit)
2590: THEN
2591: COMMIT WORK;
2592: END IF;
2593: FND_MSG_PUB.Count_And_Get

Line 2606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2602: EXCEPTION
2603: WHEN OTHERS THEN
2604: ROLLBACK TO Reschedule_Revised_Item_SP;
2605: CLOSE c_revised_item;
2606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2607: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2608: THEN
2609: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2610: END IF;

Line 2670: x_return_status := FND_API.G_RET_STS_SUCCESS;

2666: --
2667: -- Initialize OUT variables
2668: --
2669: x_new_revised_item_seq_id := NULL;
2670: x_return_status := FND_API.G_RET_STS_SUCCESS;
2671: --
2672: -- Processing Begins
2673: --
2674: OPEN c_revised_item(p_old_revised_item_seq_id);

Line 2728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2724: IF c_revised_item%ISOPEN THEN
2725: CLOSE c_revised_item;
2726: END IF;
2727: x_new_revised_item_seq_id := NULL;
2728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2729:
2730: END Copy_Revised_Item;
2731:
2732: END ENG_Revised_Item_Util;