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

Line 23: --g_MISS_CHAR VARCHAR2(1) := FND_API.g_MISS_CHAR;

19: g_in_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
20: g_out_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
21: -- end of global variables for copy_item_functionality
22:
23: --g_MISS_CHAR VARCHAR2(1) := FND_API.g_MISS_CHAR;
24: --g_MISS_NUM NUMBER := FND_API.g_MISS_NUM;
25: --g_MISS_DATE DATE := FND_API.g_MISS_DATE;
26:
27: -- =============================================================================

Line 24: --g_MISS_NUM NUMBER := FND_API.g_MISS_NUM;

20: g_out_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
21: -- end of global variables for copy_item_functionality
22:
23: --g_MISS_CHAR VARCHAR2(1) := FND_API.g_MISS_CHAR;
24: --g_MISS_NUM NUMBER := FND_API.g_MISS_NUM;
25: --g_MISS_DATE DATE := FND_API.g_MISS_DATE;
26:
27: -- =============================================================================
28: -- Procedures

Line 25: --g_MISS_DATE DATE := FND_API.g_MISS_DATE;

21: -- end of global variables for copy_item_functionality
22:
23: --g_MISS_CHAR VARCHAR2(1) := FND_API.g_MISS_CHAR;
24: --g_MISS_NUM NUMBER := FND_API.g_MISS_NUM;
25: --g_MISS_DATE DATE := FND_API.g_MISS_DATE;
26:
27: -- =============================================================================
28: -- Procedures
29: -- =============================================================================

Line 210: -- already commented out --, CONFIG_MODEL_TYPE VARCHAR2(30) := FND_API.g_MISS_CHAR

206: g_in_item_tbl(0).ENGINEERING_ITEM_ID := l_orig_item_rec.ENGINEERING_ITEM_ID;
207: g_in_item_tbl(0).ENGINEERING_ECN_CODE := l_orig_item_rec.ENGINEERING_ECN_CODE;
208: g_in_item_tbl(0).ENGINEERING_DATE := l_orig_item_rec.ENGINEERING_DATE;
209: g_in_item_tbl(0).EFFECTIVITY_CONTROL := l_orig_item_rec.EFFECTIVITY_CONTROL;
210: -- already commented out --, CONFIG_MODEL_TYPE VARCHAR2(30) := FND_API.g_MISS_CHAR
211: g_in_item_tbl(0).Product_Family_Item_Id := l_orig_item_rec.Product_Family_Item_Id;
212: -- Costing
213: g_in_item_tbl(0).COSTING_ENABLED_FLAG := l_orig_item_rec.COSTING_ENABLED_FLAG;
214: g_in_item_tbl(0).INVENTORY_ASSET_FLAG := l_orig_item_rec.INVENTORY_ASSET_FLAG;

Line 289: g_in_item_tbl(0).CARRYING_COST := FND_API.G_MISS_NUM;

285: g_in_item_tbl(0).PLANNING_MAKE_BUY_CODE := l_orig_item_rec.PLANNING_MAKE_BUY_CODE;
286: g_in_item_tbl(0).MIN_MINMAX_QUANTITY := l_orig_item_rec.MIN_MINMAX_QUANTITY;
287: g_in_item_tbl(0).MAX_MINMAX_QUANTITY := l_orig_item_rec.MAX_MINMAX_QUANTITY;
288: g_in_item_tbl(0).SAFETY_STOCK_BUCKET_DAYS := l_orig_item_rec.SAFETY_STOCK_BUCKET_DAYS;
289: g_in_item_tbl(0).CARRYING_COST := FND_API.G_MISS_NUM;
290: g_in_item_tbl(0).ORDER_COST := FND_API.G_MISS_NUM;
291: g_in_item_tbl(0).MRP_SAFETY_STOCK_PERCENT := l_orig_item_rec.MRP_SAFETY_STOCK_PERCENT;
292: g_in_item_tbl(0).MRP_SAFETY_STOCK_CODE := l_orig_item_rec.MRP_SAFETY_STOCK_CODE;
293: g_in_item_tbl(0).FIXED_ORDER_QUANTITY := l_orig_item_rec.FIXED_ORDER_QUANTITY;

Line 290: g_in_item_tbl(0).ORDER_COST := FND_API.G_MISS_NUM;

286: g_in_item_tbl(0).MIN_MINMAX_QUANTITY := l_orig_item_rec.MIN_MINMAX_QUANTITY;
287: g_in_item_tbl(0).MAX_MINMAX_QUANTITY := l_orig_item_rec.MAX_MINMAX_QUANTITY;
288: g_in_item_tbl(0).SAFETY_STOCK_BUCKET_DAYS := l_orig_item_rec.SAFETY_STOCK_BUCKET_DAYS;
289: g_in_item_tbl(0).CARRYING_COST := FND_API.G_MISS_NUM;
290: g_in_item_tbl(0).ORDER_COST := FND_API.G_MISS_NUM;
291: g_in_item_tbl(0).MRP_SAFETY_STOCK_PERCENT := l_orig_item_rec.MRP_SAFETY_STOCK_PERCENT;
292: g_in_item_tbl(0).MRP_SAFETY_STOCK_CODE := l_orig_item_rec.MRP_SAFETY_STOCK_CODE;
293: g_in_item_tbl(0).FIXED_ORDER_QUANTITY := l_orig_item_rec.FIXED_ORDER_QUANTITY;
294: g_in_item_tbl(0).FIXED_DAYS_SUPPLY := l_orig_item_rec.FIXED_DAYS_SUPPLY;

Line 390: -- already commented out --, IB_ITEM_INSTANCE_CLASS VARCHAR2(30) := FND_API.g_MISS_CHAR

386: g_in_item_tbl(0).DEFECT_TRACKING_ON_FLAG := l_orig_item_rec.DEFECT_TRACKING_ON_FLAG;
387: g_in_item_tbl(0).RECOVERED_PART_DISP_CODE := l_orig_item_rec.RECOVERED_PART_DISP_CODE;
388: g_in_item_tbl(0).COMMS_NL_TRACKABLE_FLAG := l_orig_item_rec.COMMS_NL_TRACKABLE_FLAG;
389: g_in_item_tbl(0).ASSET_CREATION_CODE := l_orig_item_rec.ASSET_CREATION_CODE;
390: -- already commented out --, IB_ITEM_INSTANCE_CLASS VARCHAR2(30) := FND_API.g_MISS_CHAR
391: g_in_item_tbl(0).IB_ITEM_INSTANCE_CLASS := l_orig_item_rec.IB_ITEM_INSTANCE_CLASS;
392: g_in_item_tbl(0).SERVICE_STARTING_DELAY := l_orig_item_rec.SERVICE_STARTING_DELAY;
393: -- Web Option
394: g_in_item_tbl(0).WEB_STATUS := l_orig_item_rec.WEB_STATUS;

Line 1123: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

1119: IS
1120: BEGIN
1121: SAVEPOINT Process_Item_Lifecycle;
1122: developer_debug ('::2960442::Process_Item_Lifecycle::start');
1123: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
1124: X_MSG_COUNT := 0;
1125:
1126: IF (P_TRANSACTION_TYPE = G_CREATE_TRANSACTION_TYPE) THEN
1127: Create_Item_Lifecycle(

Line 1156: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1152: );
1153: END IF;
1154: developer_debug ('::2960442::Process_Item_Lifecycle::end');
1155: EXCEPTION
1156: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1157: ROLLBACK TO Process_Item_Lifecycle;
1158: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1159:
1160: WHEN others THEN

Line 1158: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1154: developer_debug ('::2960442::Process_Item_Lifecycle::end');
1155: EXCEPTION
1156: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1157: ROLLBACK TO Process_Item_Lifecycle;
1158: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1159:
1160: WHEN others THEN
1161: ROLLBACK TO Process_Item_Lifecycle;
1162: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1162: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1158: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1159:
1160: WHEN others THEN
1161: ROLLBACK TO Process_Item_Lifecycle;
1162: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1163:
1164: END Process_Item_Lifecycle;
1165:
1166: Procedure Create_Item_Lifecycle(

Line 1182: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

1178: IS
1179: BEGIN
1180: SAVEPOINT Create_Item_Lifecycle;
1181: developer_debug ('::2960442::Create_Item_Lifecycle::start');
1182: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
1183: X_MSG_COUNT := 0;
1184:
1185: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
1186: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

Line 1213: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1209: COMMIT;
1210:
1211:
1212: EXCEPTION
1213: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1214: ROLLBACK TO Create_Item_Lifecycle;
1215: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1216:
1217: WHEN others THEN

Line 1215: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1211:
1212: EXCEPTION
1213: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1214: ROLLBACK TO Create_Item_Lifecycle;
1215: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1216:
1217: WHEN others THEN
1218: ROLLBACK TO Create_Item_Lifecycle;
1219: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1219: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1215: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1216:
1217: WHEN others THEN
1218: ROLLBACK TO Create_Item_Lifecycle;
1219: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1220: END Create_Item_Lifecycle;
1221:
1222: Procedure Update_Item_Lifecycle(
1223: P_API_VERSION IN NUMBER,

Line 1257: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

1253:
1254: BEGIN
1255: SAVEPOINT Update_Item_Lifecycle;
1256: developer_debug ('::2960442::Update_Item_Lifecycle::start');
1257: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
1258: X_MSG_COUNT := 0;
1259:
1260: L_MASTER_ORGANIZATION_ID := EGO_UI_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
1261:

Line 1416: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1412: developer_debug ('::2960442::Update_Item_Lifecycle::end');
1413: COMMIT;
1414:
1415: EXCEPTION
1416: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1417: ROLLBACK TO Update_Item_Lifecycle;
1418: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1419:
1420: WHEN others THEN

Line 1418: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1414:
1415: EXCEPTION
1416: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1417: ROLLBACK TO Update_Item_Lifecycle;
1418: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1419:
1420: WHEN others THEN
1421: ROLLBACK TO Update_Item_Lifecycle;
1422: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1422: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1418: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1419:
1420: WHEN others THEN
1421: ROLLBACK TO Update_Item_Lifecycle;
1422: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1423:
1424: END Update_Item_Lifecycle;
1425:
1426: -- -----------------------------------------------------------------------------

Line 1443: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

1439: IS
1440: BEGIN
1441: SAVEPOINT Update_Item_Attr_Ext;
1442: developer_debug ('::2960442::Update_Item_Attr_Ext::start');
1443: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
1444: X_MSG_COUNT := 0;
1445:
1446: IF (P_ITEM_CATALOG_GROUP_ID IS NULL) THEN
1447: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;

Line 1460: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1456: developer_debug ('::2960442::Update_Item_Attr_Ext::end');
1457: COMMIT;
1458:
1459: EXCEPTION
1460: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1461: ROLLBACK TO Update_Item_Attr_Ext;
1462: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1463:
1464: WHEN others THEN

Line 1462: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1458:
1459: EXCEPTION
1460: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1461: ROLLBACK TO Update_Item_Attr_Ext;
1462: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1463:
1464: WHEN others THEN
1465: ROLLBACK TO Update_Item_Attr_Ext;
1466: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1466: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1462: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1463:
1464: WHEN others THEN
1465: ROLLBACK TO Update_Item_Attr_Ext;
1466: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1467:
1468: END Update_Item_Attr_Ext;
1469:
1470:

Line 1592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1588: , x_return_status => l_return_status
1589: , p_mesg_token_tbl => l_mesg_token_tbl
1590: , x_mesg_token_tbl => l_mesg_token_tbl
1591: );
1592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1593: Error_Handler.Set_Debug('N');
1594: END IF;
1595: END IF;
1596: END IF;

Line 1953: ,p_init_msg_list => FND_API.g_FALSE

1949:
1950: developer_debug (' Before calling ego_item_pub.process_items');
1951: EGO_ITEM_PUB.Process_Items
1952: (p_api_version => 1.0
1953: ,p_init_msg_list => FND_API.g_FALSE
1954: ,p_commit => FND_API.g_FALSE
1955: ,p_Item_Tbl => g_in_item_tbl
1956: ,p_Role_Grant_Tbl => EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL
1957: ,x_Item_Tbl => g_out_item_tbl

Line 1954: ,p_commit => FND_API.g_FALSE

1950: developer_debug (' Before calling ego_item_pub.process_items');
1951: EGO_ITEM_PUB.Process_Items
1952: (p_api_version => 1.0
1953: ,p_init_msg_list => FND_API.g_FALSE
1954: ,p_commit => FND_API.g_FALSE
1955: ,p_Item_Tbl => g_in_item_tbl
1956: ,p_Role_Grant_Tbl => EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL
1957: ,x_Item_Tbl => g_out_item_tbl
1958: ,x_return_status => x_return_status

Line 1961: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1957: ,x_Item_Tbl => g_out_item_tbl
1958: ,x_return_status => x_return_status
1959: ,x_msg_count => x_msg_count
1960: );
1961: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1962: -- item created successfully
1963: x_inventory_item_id := g_out_item_tbl(0).inventory_item_id;
1964: x_organization_id := g_out_item_tbl(0).organization_id;
1965: ELSE

Line 1968: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS

1964: x_organization_id := g_out_item_tbl(0).organization_id;
1965: ELSE
1966: -- messages already logged by EGO_ITEM_PUB
1967: RETURN;
1968: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS
1969: OPEN c_fnd_object_id (cp_object_name => G_OBJECT_NAME);
1970: FETCH c_fnd_object_id INTO l_object_id;
1971: IF c_fnd_object_id%NOTFOUND THEN
1972: l_object_id := -1;

Line 2015: ,p_commit => FND_API.G_FALSE

2011: ,p_old_dtlevel_col_value_pairs => l_orig_item_rev_pk_value_pairs
2012: ,p_new_pk_col_value_pairs => l_new_item_pk_value_pairs
2013: ,p_new_dtlevel_col_value_pairs => l_new_item_rev_pk_value_pairs
2014: ,p_new_cc_col_value_pairs => l_new_cc_col_value_pairs
2015: ,p_commit => FND_API.G_FALSE
2016: ,x_return_status => x_return_status
2017: ,x_errorcode => l_error_code
2018: ,x_msg_count => x_msg_count
2019: ,x_msg_data => l_msg_data

Line 2022: IF x_return_status = fnd_api.g_miss_char THEN

2018: ,x_msg_count => x_msg_count
2019: ,x_msg_data => l_msg_data
2020: );
2021: developer_debug(' 20 Returning from EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data ' );
2022: IF x_return_status = fnd_api.g_miss_char THEN
2023: developer_debug(' 21 ');
2024: ELSIF x_return_status IS NULL THEN
2025: developer_debug(' 22 ');
2026: ELSE

Line 2030: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2026: ELSE
2027: developer_debug(' 23 '||x_return_status);
2028: END IF;
2029:
2030: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2031: -- error handled in Ego_user_attrs_data_pub
2032: RETURN;
2033: END IF;
2034: -- call the user attributes code for revision level

Line 2073: ,p_commit => FND_API.G_FALSE

2069: ,p_old_dtlevel_col_value_pairs => l_orig_item_rev_pk_value_pairs
2070: ,p_new_pk_col_value_pairs => l_new_item_pk_value_pairs
2071: ,p_new_dtlevel_col_value_pairs => l_new_item_rev_pk_value_pairs
2072: ,p_new_cc_col_value_pairs => l_new_cc_col_value_pairs
2073: ,p_commit => FND_API.G_FALSE
2074: ,x_return_status => x_return_status
2075: ,x_errorcode => l_error_code
2076: ,x_msg_count => x_msg_count
2077: ,x_msg_data => l_msg_data

Line 2092: IF x_return_status = fnd_api.g_miss_char THEN

2088: -----------------------------------------------------------------------
2089: Delete_Extra_Item_Long_Desc_AG(x_inventory_item_id, x_organization_id);
2090:
2091: developer_debug(' 90 Returning from EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data -- Revision Part ' );
2092: IF x_return_status = fnd_api.g_miss_char THEN
2093: developer_debug(' 91 ');
2094: ELSIF x_return_status IS NULL THEN
2095: developer_debug(' 92 ');
2096: ELSE

Line 2099: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2095: developer_debug(' 92 ');
2096: ELSE
2097: developer_debug(' 93 '||x_return_status);
2098: END IF;
2099: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2100: -- problem with Copy Revision Attrs Data for item
2101: RETURN;
2102: END IF;
2103: ELSE

Line 2112: ,p_commit => FND_API.G_FALSE

2108: -- create the lifecycle details now
2109: process_item_lifecycle
2110: (p_api_version => 1.0
2111: ,p_init_msg_list => p_init_msg_list
2112: ,p_commit => FND_API.G_FALSE
2113: ,p_inventory_item_id => x_inventory_item_id
2114: ,p_organization_id => x_organization_id
2115: ,p_catalog_group_id => p_item_catalog_group_id
2116: ,p_lifecycle_id => p_lifecycle_id

Line 2125: IF x_return_status = fnd_api.g_miss_char THEN

2121: ,x_msg_count => x_msg_count
2122: );
2123:
2124: developer_debug(' 110 Returning from Process Item Lifecycle ' );
2125: IF x_return_status = fnd_api.g_miss_char THEN
2126: developer_debug(' 111 ');
2127: ELSIF x_return_status IS NULL THEN
2128: developer_debug(' 112 ');
2129: ELSE

Line 2132: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2128: developer_debug(' 112 ');
2129: ELSE
2130: developer_debug(' 113 '||x_return_status);
2131: END IF;
2132: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2133: -- problem with item lifecycle processing for item
2134: RETURN;
2135: END IF;
2136: developer_debug(' 120 ');

Line 2144: IF FND_API.To_Boolean( p_commit ) THEN

2140: RETURN;
2141: END IF; -- p_transaction_type = G_COPY_TRANSACTION_TYPE
2142: developer_debug(' 140 ');
2143:
2144: IF FND_API.To_Boolean( p_commit ) THEN
2145: COMMIT WORK;
2146: END IF;
2147: x_return_status := G_RET_STS_SUCCESS;
2148: developer_debug ('::2960442::Process_Item::end');

Line 2749: IF NOT FND_API.Compatible_API_Call (l_api_version,

2745: BEGIN
2746: developer_debug (' ISS: Started Item Scalar Signature ');
2747:
2748: -- standard check for API validation
2749: IF NOT FND_API.Compatible_API_Call (l_api_version,
2750: p_api_version,
2751: l_api_name,
2752: G_PKG_NAME) THEN
2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2749: IF NOT FND_API.Compatible_API_Call (l_api_version,
2750: p_api_version,
2751: l_api_name,
2752: G_PKG_NAME) THEN
2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2754: END IF;
2755:
2756: developer_debug (' ISS: API version valid ');
2757: -- create save point

Line 2758: IF FND_API.To_Boolean(p_commit) THEN

2754: END IF;
2755:
2756: developer_debug (' ISS: API version valid ');
2757: -- create save point
2758: IF FND_API.To_Boolean(p_commit) THEN
2759: developer_debug (' ISS: Save Point Created ');
2760: SAVEPOINT Process_Item_Scalar;
2761: END IF;
2762:

Line 2764: IF FND_API.To_Boolean(p_init_msg_list) THEN

2760: SAVEPOINT Process_Item_Scalar;
2761: END IF;
2762:
2763: -- Initialize message list
2764: IF FND_API.To_Boolean(p_init_msg_list) THEN
2765: developer_debug (' ISS: Message list initialized ');
2766: FND_MSG_PUB.Initialize;
2767: END IF;
2768:

Line 3132: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3128: -----------------------------------------------------------------------------
3129: l_item_created_tbl := EGO_Item_PVT.G_Item_Tbl;
3130: developer_debug (' ISS: copied the item to created table ');
3131:
3132: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3133: -- item created successfully
3134: x_inventory_item_id := l_item_created_tbl(indx).inventory_item_id;
3135: x_organization_id := l_item_created_tbl(indx).organization_id;
3136: developer_debug (' ISS: copied the item created values ');

Line 3199: RAISE FND_API.G_EXC_ERROR;

3195: ,x_return_status => x_return_status
3196: );
3197: developer_debug (' ISS: returned from Update_Item_Number -> ' || x_return_status);
3198: IF x_return_status = G_RET_STS_ERROR THEN
3199: RAISE FND_API.G_EXC_ERROR;
3200: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END IF;
3203: END IF;

Line 3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3197: developer_debug (' ISS: returned from Update_Item_Number -> ' || x_return_status);
3198: IF x_return_status = G_RET_STS_ERROR THEN
3199: RAISE FND_API.G_EXC_ERROR;
3200: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END IF;
3203: END IF;
3204: -- common processing after update
3205: -- call the update approval status routine now

Line 3218: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS from IOI

3214: );
3215: ELSE
3216: -- messages already logged by EGO_ITEM_PVT
3217: RETURN;
3218: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS from IOI
3219:
3220: ELSIF p_transaction_type = G_COPY_TRANSACTION_TYPE THEN
3221: -- transaction type = 'COPY'
3222: -- to be implemented

Line 3225: RAISE FND_API.G_EXC_ERROR;

3221: -- transaction type = 'COPY'
3222: -- to be implemented
3223: FND_MESSAGE.Set_Name ('EGO', 'EGO_PROGRAM_NOT_IMPLEMENTED');
3224: FND_MSG_PUB.Add;
3225: RAISE FND_API.G_EXC_ERROR;
3226: END IF;
3227:
3228: IF FND_API.To_Boolean(p_commit) THEN
3229: COMMIT WORK;

Line 3228: IF FND_API.To_Boolean(p_commit) THEN

3224: FND_MSG_PUB.Add;
3225: RAISE FND_API.G_EXC_ERROR;
3226: END IF;
3227:
3228: IF FND_API.To_Boolean(p_commit) THEN
3229: COMMIT WORK;
3230: END IF;
3231: x_return_status := G_RET_STS_SUCCESS;
3232: developer_debug (' ISS: DONE with status -> '||x_return_status);

Line 3235: WHEN FND_API.G_EXC_ERROR THEN

3231: x_return_status := G_RET_STS_SUCCESS;
3232: developer_debug (' ISS: DONE with status -> '||x_return_status);
3233:
3234: EXCEPTION
3235: WHEN FND_API.G_EXC_ERROR THEN
3236: IF FND_API.To_Boolean(p_commit) THEN
3237: ROLLBACK TO Process_Item_Scalar;
3238: END IF;
3239: x_return_status := G_RET_STS_ERROR;

Line 3236: IF FND_API.To_Boolean(p_commit) THEN

3232: developer_debug (' ISS: DONE with status -> '||x_return_status);
3233:
3234: EXCEPTION
3235: WHEN FND_API.G_EXC_ERROR THEN
3236: IF FND_API.To_Boolean(p_commit) THEN
3237: ROLLBACK TO Process_Item_Scalar;
3238: END IF;
3239: x_return_status := G_RET_STS_ERROR;
3240: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 3240: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3236: IF FND_API.To_Boolean(p_commit) THEN
3237: ROLLBACK TO Process_Item_Scalar;
3238: END IF;
3239: x_return_status := G_RET_STS_ERROR;
3240: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3241: ,p_count => x_msg_count
3242: ,p_data => x_msg_data);
3243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3244: IF FND_API.To_Boolean(p_commit) THEN

Line 3243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3239: x_return_status := G_RET_STS_ERROR;
3240: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3241: ,p_count => x_msg_count
3242: ,p_data => x_msg_data);
3243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3244: IF FND_API.To_Boolean(p_commit) THEN
3245: ROLLBACK TO Process_Item_Scalar;
3246: END IF;
3247: x_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;

Line 3244: IF FND_API.To_Boolean(p_commit) THEN

3240: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3241: ,p_count => x_msg_count
3242: ,p_data => x_msg_data);
3243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3244: IF FND_API.To_Boolean(p_commit) THEN
3245: ROLLBACK TO Process_Item_Scalar;
3246: END IF;
3247: x_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;
3248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 3248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3244: IF FND_API.To_Boolean(p_commit) THEN
3245: ROLLBACK TO Process_Item_Scalar;
3246: END IF;
3247: x_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;
3248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3249: ,p_count => x_msg_count
3250: ,p_data => x_msg_data);
3251: WHEN OTHERS THEN
3252: IF FND_API.To_Boolean(p_commit) THEN

Line 3252: IF FND_API.To_Boolean(p_commit) THEN

3248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3249: ,p_count => x_msg_count
3250: ,p_data => x_msg_data);
3251: WHEN OTHERS THEN
3252: IF FND_API.To_Boolean(p_commit) THEN
3253: ROLLBACK TO Process_Item_Scalar;
3254: END IF;
3255: x_return_status := G_RET_STS_UNEXP_ERROR;
3256: -- for PL/SQL errors

Line 3262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3258: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3259: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3260: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3261: FND_MSG_PUB.Add;
3262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3263: ,p_count => x_msg_count
3264: ,p_data => x_msg_data);
3265: END Process_Item;
3266: