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_INV_ITEM_CATALOG_PVT dependencies on FND_API

Line 112: x_return_status := FND_API.G_RET_STS_ERROR;

108:
109: --
110: -- return status as Error
111: --
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: EXCEPTION
114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

111: --
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: EXCEPTION
114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
117: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
118: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
119: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 213: IF (FND_API.TO_BOOLEAN(p_validate_changes) AND NOT p_new_cc_in_hier) THEN --Bug: 4060185

209: FOR Item_Rev_Record IN c_get_item_rev_details (cp_item_id => p_inventory_item_id
210: ,cp_org_id => p_organization_id)
211: LOOP
212: code_debug(l_api_name||' Checking pending change orders for revision '|| Item_Rev_Record.revision);
213: IF (FND_API.TO_BOOLEAN(p_validate_changes) AND NOT p_new_cc_in_hier) THEN --Bug: 4060185
214: Check_Pending_Change_Orders
215: (p_inventory_item_id => p_inventory_item_id
216: ,p_organization_id => Item_Rev_Record.organization_id
217: ,p_revision_id => Item_Rev_Record.revision_id

Line 218: ,p_lifecycle_changed => FND_API.G_FALSE

214: Check_Pending_Change_Orders
215: (p_inventory_item_id => p_inventory_item_id
216: ,p_organization_id => Item_Rev_Record.organization_id
217: ,p_revision_id => Item_Rev_Record.revision_id
218: ,p_lifecycle_changed => FND_API.G_FALSE
219: ,p_lifecycle_phase_changed => FND_API.G_TRUE
220: ,p_change_id => NULL
221: ,p_change_line_id => NULL
222: ,x_return_status => x_return_status

Line 219: ,p_lifecycle_phase_changed => FND_API.G_TRUE

215: (p_inventory_item_id => p_inventory_item_id
216: ,p_organization_id => Item_Rev_Record.organization_id
217: ,p_revision_id => Item_Rev_Record.revision_id
218: ,p_lifecycle_changed => FND_API.G_FALSE
219: ,p_lifecycle_phase_changed => FND_API.G_TRUE
220: ,p_change_id => NULL
221: ,p_change_line_id => NULL
222: ,x_return_status => x_return_status
223: ,x_msg_count => x_msg_count

Line 226: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

222: ,x_return_status => x_return_status
223: ,x_msg_count => x_msg_count
224: ,x_msg_data => x_msg_data
225: );
226: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
227: code_debug(l_api_name||' returning Check_Pending_Change_Orders with status '|| x_return_status);
228: RETURN;
229: END IF;
230: END IF;

Line 244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

240: ,x_msg_count => x_msg_count
241: ,x_msg_data => x_msg_data );
242:
243: code_debug(l_api_name||': check_floating_attachments' || x_return_status);
244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RETURN;
246: END IF;
247:
248:

Line 264: ,p_commit => FND_API.G_FALSE

260: --
261: code_debug(l_api_name||': Creating Phase History Record ');
262: Create_Phase_History_Record (
263: p_api_version => 1.0
264: ,p_commit => FND_API.G_FALSE
265: ,p_inventory_item_id => p_inventory_item_id
266: ,p_organization_id => Item_Rev_Record.organization_id
267: ,p_revision_id => Item_Rev_Record.Revision_id
268: ,p_lifecycle_id => l_item_rev_lifecycle_id

Line 275: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

271: ,x_return_status => x_return_status
272: ,x_msg_count => x_msg_count
273: ,x_msg_data => x_msg_data
274: );
275: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: RETURN;
277: END IF;
278: --
279: -- update item revision project

Line 290: x_return_status := FND_API.G_RET_STS_SUCCESS;

286: AND revision_id = Item_Rev_Record.revision_id
287: AND ASSOCIATION_TYPE = 'EGO_ITEM_PROJ_ASSOC_TYPE'
288: AND ASSOCIATION_CODE = 'LIFECYCLE_TRACKING';
289: END LOOP; -- item revision loop
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291: code_debug(l_api_name||': Bye Bye ');
292: EXCEPTION
293: WHEN OTHERS THEN
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291: code_debug(l_api_name||': Bye Bye ');
292: EXCEPTION
293: WHEN OTHERS THEN
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: IF c_get_default_phase_id%ISOPEN THEN
296: CLOSE c_get_default_phase_id;
297: END IF;
298: IF c_get_item_rev_details%ISOPEN THEN

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: END IF;
298: IF c_get_item_rev_details%ISOPEN THEN
299: CLOSE c_get_item_rev_details;
300: END IF;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
303: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
304: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
305: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 362: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'

358: WHERE inventory_item_id = cp_item_id
359: AND organization_id = cp_org_id;
360:
361: --Return Status Variables
362: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
363: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
364: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
365: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
366: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;

Line 363: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'

359: AND organization_id = cp_org_id;
360:
361: --Return Status Variables
362: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
363: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
364: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
365: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
366: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
367:

Line 364: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'

360:
361: --Return Status Variables
362: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
363: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
364: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
365: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
366: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
367:
368: l_status_rec BOOLEAN := FALSE;

Line 398: IF FND_API.To_Boolean( p_commit ) THEN

394: BEGIN
395: x_return_status := l_ret_error;
396: l_api_name := 'Change_Item_Lifecycle';
397: code_debug(l_api_name||': started with org id '||to_char(p_organization_id));
398: IF FND_API.To_Boolean( p_commit ) THEN
399: SAVEPOINT Change_Item_Lifecycle;
400: END IF;
401: code_debug(l_api_name||': Taking the null values ');
402: IF p_new_catalog_category_id = -1 THEN

Line 444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

440: ,x_msg_count => x_msg_count
441: ,x_msg_data => x_msg_data );
442:
443: code_debug(l_api_name||': check_floating_attachments' || x_return_status);
444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
445: IF FND_API.To_Boolean( p_commit ) THEN
446: ROLLBACK TO Change_Item_Lifecycle;
447: END IF;
448: RETURN;

Line 445: IF FND_API.To_Boolean( p_commit ) THEN

441: ,x_msg_data => x_msg_data );
442:
443: code_debug(l_api_name||': check_floating_attachments' || x_return_status);
444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
445: IF FND_API.To_Boolean( p_commit ) THEN
446: ROLLBACK TO Change_Item_Lifecycle;
447: END IF;
448: RETURN;
449: END IF;

Line 453: ,p_commit => FND_API.G_FALSE

449: END IF;
450:
451: Validate_And_Change_Item_LC(
452: p_api_version => 1.0
453: ,p_commit => FND_API.G_FALSE
454: ,p_inventory_item_id => p_inventory_item_id
455: ,p_item_revision_id => NULL
456: ,p_organization_id => p_organization_id
457: ,p_fetch_curr_values => FND_API.G_FALSE

Line 457: ,p_fetch_curr_values => FND_API.G_FALSE

453: ,p_commit => FND_API.G_FALSE
454: ,p_inventory_item_id => p_inventory_item_id
455: ,p_item_revision_id => NULL
456: ,p_organization_id => p_organization_id
457: ,p_fetch_curr_values => FND_API.G_FALSE
458: ,p_curr_cc_id => l_curr_cc_id
459: ,p_new_cc_id => l_new_cc_id
460: ,p_is_new_cc_in_hier => FND_API.G_TRUE
461: ,p_curr_lc_id => l_curr_lifecycle_id

Line 460: ,p_is_new_cc_in_hier => FND_API.G_TRUE

456: ,p_organization_id => p_organization_id
457: ,p_fetch_curr_values => FND_API.G_FALSE
458: ,p_curr_cc_id => l_curr_cc_id
459: ,p_new_cc_id => l_new_cc_id
460: ,p_is_new_cc_in_hier => FND_API.G_TRUE
461: ,p_curr_lc_id => l_curr_lifecycle_id
462: ,p_new_lc_id => l_new_lifecycle_id
463: ,p_curr_lcp_id => l_curr_phase_id
464: ,p_new_lcp_id => l_new_phase_id

Line 471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

467: ,x_return_status => x_return_status
468: ,x_msg_count => x_msg_count
469: ,x_msg_data => x_msg_data
470: );
471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
472: IF FND_API.To_Boolean( p_commit ) THEN
473: ROLLBACK TO Change_Item_Lifecycle;
474: END IF;
475: RETURN;

Line 472: IF FND_API.To_Boolean( p_commit ) THEN

468: ,x_msg_count => x_msg_count
469: ,x_msg_data => x_msg_data
470: );
471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
472: IF FND_API.To_Boolean( p_commit ) THEN
473: ROLLBACK TO Change_Item_Lifecycle;
474: END IF;
475: RETURN;
476: END IF;

Line 652: IF FND_API.To_Boolean( p_commit ) THEN

648: --R12: Business Event Enhancement
649:
650:
651:
652: IF FND_API.To_Boolean( p_commit ) THEN
653: COMMIT WORK;
654: END IF;
655: x_return_status := l_ret_success;
656: code_debug(l_api_name||': Bye Bye ');

Line 659: IF FND_API.To_Boolean( p_commit ) THEN

655: x_return_status := l_ret_success;
656: code_debug(l_api_name||': Bye Bye ');
657: EXCEPTION
658: WHEN OTHERS THEN
659: IF FND_API.To_Boolean( p_commit ) THEN
660: ROLLBACK TO Change_Item_Lifecycle;
661: END IF;
662: IF c_get_item_details%ISOPEN THEN
663: CLOSE c_get_item_details;

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

664: END IF;
665: IF c_get_item_curr_data%ISOPEN THEN
666: CLOSE c_get_item_curr_data;
667: END IF;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
670: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
671: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
672: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 748: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'

744: START WITH item_catalog_group_id = cp_new_id));
745:
746: */
747:
748: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
749: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
750: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
751:
752: l_change BOOLEAN := FALSE;

Line 749: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'

745:
746: */
747:
748: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
749: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
750: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
751:
752: l_change BOOLEAN := FALSE;
753: l_organization_id NUMBER;

Line 750: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'

746: */
747:
748: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
749: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
750: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
751:
752: l_change BOOLEAN := FALSE;
753: l_organization_id NUMBER;
754: l_api_name VARCHAR2(30);

Line 776: IF FND_API.To_Boolean( p_commit ) THEN

772: code_debug(l_api_name||': p_catalog_group_id: '||to_char(p_catalog_group_id) ||' p_new_catalog_group_id:'|| to_char(P_NEW_CATALOG_GROUP_ID));
773: code_debug(l_api_name||': p_new_lifecycle_id: '||to_char(p_new_lifecycle_id)||' p_new_phase_id: '||to_char(p_new_phase_id));
774: code_debug(l_api_name||': P_NEW_ITEM_STATUS_CODE: '||P_NEW_ITEM_STATUS_CODE);
775:
776: IF FND_API.To_Boolean( p_commit ) THEN
777: SAVEPOINT Change_Item_Catalog;
778: END IF;
779: x_return_status := l_ret_error;
780:

Line 799: p_commit => FND_API.G_FALSE,

795: p_new_catalog_category_id => p_new_catalog_group_id,
796: p_new_lifecycle_id => p_new_lifecycle_id,
797: p_new_phase_id => p_new_phase_id,
798: p_new_item_status_code => p_new_item_status_code,
799: p_commit => FND_API.G_FALSE,
800: x_return_status => x_return_status,
801: x_msg_data => x_msg_data,
802: x_msg_count => x_msg_count);
803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

799: p_commit => FND_API.G_FALSE,
800: x_return_status => x_return_status,
801: x_msg_data => x_msg_data,
802: x_msg_count => x_msg_count);
803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
804: RETURN;
805: END IF;
806: END LOOP;
807:

Line 1015: IF FND_API.To_Boolean( p_commit ) THEN

1011: ELSE
1012: RETURN;
1013: END IF;
1014: ***/
1015: IF FND_API.To_Boolean( p_commit ) THEN
1016: COMMIT WORK;
1017: INV_ITEM_PVT.SYNC_IM_INDEX; --3026311 Sync iM index
1018:
1019: -- Call IP Intermedia Sync

Line 1026: IF FND_API.To_Boolean( p_commit ) THEN

1022: END IF;
1023: code_debug(l_api_name||': Bye Bye ');
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: IF FND_API.To_Boolean( p_commit ) THEN
1027: ROLLBACK TO Change_Item_Catalog;
1028: END IF;
1029: IF c_get_item_details%ISOPEN THEN
1030: CLOSE c_get_item_details;

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034: END IF;
1035: IF c_get_master_org_details%ISOPEN THEN
1036: CLOSE c_get_master_org_details;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1040: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1041: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1042: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1136: l_lc_changed := FND_API.G_FALSE;

1132:
1133: BEGIN
1134: l_api_version := 1.0;
1135: l_api_name := 'Validate_And_Change_Item_LC';
1136: l_lc_changed := FND_API.G_FALSE;
1137: l_lcp_changed := FND_API.G_FALSE;
1138: l_perform_sync_only := FND_API.G_FALSE;
1139: l_null_id_value := FND_API.G_MISS_NUM;
1140:

Line 1137: l_lcp_changed := FND_API.G_FALSE;

1133: BEGIN
1134: l_api_version := 1.0;
1135: l_api_name := 'Validate_And_Change_Item_LC';
1136: l_lc_changed := FND_API.G_FALSE;
1137: l_lcp_changed := FND_API.G_FALSE;
1138: l_perform_sync_only := FND_API.G_FALSE;
1139: l_null_id_value := FND_API.G_MISS_NUM;
1140:
1141: code_debug(l_api_name||': Started with parameters ');

Line 1138: l_perform_sync_only := FND_API.G_FALSE;

1134: l_api_version := 1.0;
1135: l_api_name := 'Validate_And_Change_Item_LC';
1136: l_lc_changed := FND_API.G_FALSE;
1137: l_lcp_changed := FND_API.G_FALSE;
1138: l_perform_sync_only := FND_API.G_FALSE;
1139: l_null_id_value := FND_API.G_MISS_NUM;
1140:
1141: code_debug(l_api_name||': Started with parameters ');
1142: code_debug(' p_api_version : '||p_api_version||' p_commit : '|| p_commit);

Line 1139: l_null_id_value := FND_API.G_MISS_NUM;

1135: l_api_name := 'Validate_And_Change_Item_LC';
1136: l_lc_changed := FND_API.G_FALSE;
1137: l_lcp_changed := FND_API.G_FALSE;
1138: l_perform_sync_only := FND_API.G_FALSE;
1139: l_null_id_value := FND_API.G_MISS_NUM;
1140:
1141: code_debug(l_api_name||': Started with parameters ');
1142: code_debug(' p_api_version : '||p_api_version||' p_commit : '|| p_commit);
1143: code_debug(' p_inventory_item_id :'||p_inventory_item_id||' p_item_revision_id : '|| p_item_revision_id||' p_organization_id : '|| p_organization_id);

Line 1149: IF NOT FND_API.Compatible_API_Call (l_api_version

1145: code_debug(' p_is_new_cc_in_hier : '|| p_is_new_cc_in_hier ||' p_curr_lc_id: '|| p_curr_lc_id ||' p_new_lc_id : '|| p_new_lc_id);
1146: code_debug(' p_curr_lcp_id : '|| p_curr_lcp_id ||' p_new_lcp_id: '|| p_new_lcp_id ||' p_change_id : '|| p_change_id);
1147:
1148: --Standard checks
1149: IF NOT FND_API.Compatible_API_Call (l_api_version
1150: ,p_api_version
1151: ,l_api_name
1152: ,g_pkg_name)
1153: THEN

Line 1154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1150: ,p_api_version
1151: ,l_api_name
1152: ,g_pkg_name)
1153: THEN
1154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1155: END IF;
1156:
1157: IF FND_API.To_Boolean( p_commit ) THEN
1158: SAVEPOINT Validate_And_Change_Item_LC_SP;

Line 1157: IF FND_API.To_Boolean( p_commit ) THEN

1153: THEN
1154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1155: END IF;
1156:
1157: IF FND_API.To_Boolean( p_commit ) THEN
1158: SAVEPOINT Validate_And_Change_Item_LC_SP;
1159: END IF;
1160:
1161: IF FND_API.TO_BOOLEAN(p_fetch_curr_values) THEN

Line 1161: IF FND_API.TO_BOOLEAN(p_fetch_curr_values) THEN

1157: IF FND_API.To_Boolean( p_commit ) THEN
1158: SAVEPOINT Validate_And_Change_Item_LC_SP;
1159: END IF;
1160:
1161: IF FND_API.TO_BOOLEAN(p_fetch_curr_values) THEN
1162: IF p_item_revision_id IS NULL THEN
1163: -- fetch from item
1164: OPEN c_get_curr_item_val (cp_item_id => p_inventory_item_id
1165: ,cp_org_id => p_organization_id

Line 1218: l_lc_changed := FND_API.G_TRUE;

1214: -- perform validations if lc is chosen
1215: code_debug(l_api_name||' validate item as CC has changed from null to NOT Null ');
1216: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1217: l_validate := TRUE;
1218: l_lc_changed := FND_API.G_TRUE;
1219: l_lcp_changed := FND_API.G_TRUE;
1220: ELSE
1221: -- perform no validations.
1222: -- user

Line 1219: l_lcp_changed := FND_API.G_TRUE;

1215: code_debug(l_api_name||' validate item as CC has changed from null to NOT Null ');
1216: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1217: l_validate := TRUE;
1218: l_lc_changed := FND_API.G_TRUE;
1219: l_lcp_changed := FND_API.G_TRUE;
1220: ELSE
1221: -- perform no validations.
1222: -- user
1223: NULL;

Line 1232: l_lc_changed := FND_API.G_TRUE;

1228: IF p_new_lc_id IS NULL THEN
1229: IF l_new_cc_id IS NULL THEN
1230: code_debug(l_api_name||' validate item as CC has changed from ' ||l_curr_cc_id || ' TO '||l_new_cc_id||' and new LC id is null ');
1231: l_validate := TRUE;
1232: l_lc_changed := FND_API.G_TRUE;
1233: l_lcp_changed := FND_API.G_TRUE;
1234: ELSE
1235: -- catalog category is changed
1236: -- but no LC associated. check hierarchy

Line 1233: l_lcp_changed := FND_API.G_TRUE;

1229: IF l_new_cc_id IS NULL THEN
1230: code_debug(l_api_name||' validate item as CC has changed from ' ||l_curr_cc_id || ' TO '||l_new_cc_id||' and new LC id is null ');
1231: l_validate := TRUE;
1232: l_lc_changed := FND_API.G_TRUE;
1233: l_lcp_changed := FND_API.G_TRUE;
1234: ELSE
1235: -- catalog category is changed
1236: -- but no LC associated. check hierarchy
1237: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN

Line 1237: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN

1233: l_lcp_changed := FND_API.G_TRUE;
1234: ELSE
1235: -- catalog category is changed
1236: -- but no LC associated. check hierarchy
1237: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN
1238: l_new_cc_in_hier := TRUE;
1239: ELSIF p_is_new_cc_in_hier = FND_API.G_FALSE THEN
1240: l_new_cc_in_hier := FALSE;
1241: ELSE

Line 1239: ELSIF p_is_new_cc_in_hier = FND_API.G_FALSE THEN

1235: -- catalog category is changed
1236: -- but no LC associated. check hierarchy
1237: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN
1238: l_new_cc_in_hier := TRUE;
1239: ELSIF p_is_new_cc_in_hier = FND_API.G_FALSE THEN
1240: l_new_cc_in_hier := FALSE;
1241: ELSE
1242: OPEN c_check_cc_hier (cp_curr_cc_id => l_curr_cc_id
1243: ,cp_new_cc_id => l_new_cc_id

Line 1258: l_perform_sync_only := FND_API.G_TRUE;

1254: -- perform only sync
1255: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1256: code_debug(l_api_name||' perform only sync as the lifecycle is changed to null ');
1257: l_validate := TRUE;
1258: l_perform_sync_only := FND_API.G_TRUE;
1259: END IF;
1260: ELSE
1261: code_debug(l_api_name||' validate item as CC has changed from '|| l_curr_cc_id || ' TO '||l_new_cc_id||' and new LC id is null and CC not in hier');
1262: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN

Line 1264: l_lc_changed := FND_API.G_TRUE;

1260: ELSE
1261: code_debug(l_api_name||' validate item as CC has changed from '|| l_curr_cc_id || ' TO '||l_new_cc_id||' and new LC id is null and CC not in hier');
1262: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1263: l_validate := TRUE;
1264: l_lc_changed := FND_API.G_TRUE;
1265: l_lcp_changed := FND_API.G_TRUE;
1266: END IF;
1267: END IF;
1268: END IF; -- for l_new_cc_id IS NULL check

Line 1265: l_lcp_changed := FND_API.G_TRUE;

1261: code_debug(l_api_name||' validate item as CC has changed from '|| l_curr_cc_id || ' TO '||l_new_cc_id||' and new LC id is null and CC not in hier');
1262: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1263: l_validate := TRUE;
1264: l_lc_changed := FND_API.G_TRUE;
1265: l_lcp_changed := FND_API.G_TRUE;
1266: END IF;
1267: END IF;
1268: END IF; -- for l_new_cc_id IS NULL check
1269: ELSE -- new lifecycle is chosen.

Line 1278: l_lcp_changed := FND_API.G_TRUE;

1274: AND
1275: NVL(l_curr_lc_id,l_null_id_value) = NVL(p_new_lc_id,l_null_id_value)
1276: AND
1277: NVL(l_curr_lcp_id,l_null_id_value) <> NVL(p_new_lcp_id,l_null_id_value) THEN
1278: l_lcp_changed := FND_API.G_TRUE;
1279: ELSE
1280: l_lc_changed := FND_API.G_TRUE;
1281: l_lcp_changed := FND_API.G_TRUE;
1282: END IF;

Line 1280: l_lc_changed := FND_API.G_TRUE;

1276: AND
1277: NVL(l_curr_lcp_id,l_null_id_value) <> NVL(p_new_lcp_id,l_null_id_value) THEN
1278: l_lcp_changed := FND_API.G_TRUE;
1279: ELSE
1280: l_lc_changed := FND_API.G_TRUE;
1281: l_lcp_changed := FND_API.G_TRUE;
1282: END IF;
1283: END IF; -- for new lc_id IS NOT NULL
1284: END IF; -- for curr_cc_id check end

Line 1281: l_lcp_changed := FND_API.G_TRUE;

1277: NVL(l_curr_lcp_id,l_null_id_value) <> NVL(p_new_lcp_id,l_null_id_value) THEN
1278: l_lcp_changed := FND_API.G_TRUE;
1279: ELSE
1280: l_lc_changed := FND_API.G_TRUE;
1281: l_lcp_changed := FND_API.G_TRUE;
1282: END IF;
1283: END IF; -- for new lc_id IS NOT NULL
1284: END IF; -- for curr_cc_id check end
1285:

Line 1302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1298: ,x_return_status => x_return_status
1299: ,x_msg_count => x_msg_count
1300: ,x_msg_data => x_msg_data
1301: );
1302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1303: RETURN;
1304: END IF;
1305: END IF; -- end l_validate
1306:

Line 1307: IF FND_API.To_Boolean(p_commit) THEN

1303: RETURN;
1304: END IF;
1305: END IF; -- end l_validate
1306:
1307: IF FND_API.To_Boolean(p_commit) THEN
1308: COMMIT WORK;
1309: END IF;
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: code_debug(l_api_name||': Bye Bye ');

Line 1310: x_return_status := FND_API.G_RET_STS_SUCCESS;

1306:
1307: IF FND_API.To_Boolean(p_commit) THEN
1308: COMMIT WORK;
1309: END IF;
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: code_debug(l_api_name||': Bye Bye ');
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN

Line 1315: IF FND_API.To_Boolean( p_commit ) THEN

1311: code_debug(l_api_name||': Bye Bye ');
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: IF FND_API.To_Boolean( p_commit ) THEN
1316: ROLLBACK TO Validate_And_Change_Item_LC_SP;
1317: END IF;
1318: IF c_get_curr_item_val%ISOPEN THEN
1319: CLOSE c_get_curr_item_val;

Line 1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1323: END IF;
1324: IF c_check_cc_hier%ISOPEN THEN
1325: CLOSE c_check_cc_hier;
1326: END IF;
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1329: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1330: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1331: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1436: IF NOT FND_API.Compatible_API_Call (l_api_version

1432: code_debug(l_api_name||': p_lifecycle_id: '||to_char(p_lifecycle_id)||' p_lifecycle_phase_id: '||to_char(p_lifecycle_phase_id));
1433: code_debug(l_api_name||': p_lifecycle_changed: '||p_lifecycle_changed||' p_lifecycle_phase_changed: '||p_lifecycle_phase_changed);
1434:
1435: --Standard checks
1436: IF NOT FND_API.Compatible_API_Call (l_api_version
1437: ,p_api_version
1438: ,l_api_name
1439: ,g_pkg_name)
1440: THEN

Line 1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1437: ,p_api_version
1438: ,l_api_name
1439: ,g_pkg_name)
1440: THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443:
1444: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1445: OR

Line 1444: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)

1440: THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443:
1444: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1445: OR
1446: FND_API.To_Boolean(p_lifecycle_phase_changed)
1447: OR
1448: FND_API.To_Boolean(p_perform_sync_only)

Line 1446: FND_API.To_Boolean(p_lifecycle_phase_changed)

1442: END IF;
1443:
1444: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1445: OR
1446: FND_API.To_Boolean(p_lifecycle_phase_changed)
1447: OR
1448: FND_API.To_Boolean(p_perform_sync_only)
1449: ) THEN
1450: RETURN;

Line 1448: FND_API.To_Boolean(p_perform_sync_only)

1444: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1445: OR
1446: FND_API.To_Boolean(p_lifecycle_phase_changed)
1447: OR
1448: FND_API.To_Boolean(p_perform_sync_only)
1449: ) THEN
1450: RETURN;
1451: END IF;
1452: --

Line 1457: IF FND_API.To_Boolean(p_perform_sync_only) THEN

1453: -- inv team wish to call only Sync on certain conditions
1454: -- instead of calling another procedure, then wish to have SYNC
1455: -- exposed from here only
1456: --
1457: IF FND_API.To_Boolean(p_perform_sync_only) THEN
1458: code_debug(l_api_name||': calling Sync_Item_Revisions using perform sync only ');
1459: Sync_Item_Revisions(
1460: p_inventory_item_id => p_inventory_item_id
1461: ,p_organization_id => p_organization_id

Line 1474: IF ( NOT (FND_API.to_boolean(p_lifecycle_changed))

1470: code_debug(l_api_name||': returning Sync_Item_Revisions perform sync only '|| x_return_status);
1471: RETURN;
1472: END IF;
1473:
1474: IF ( NOT (FND_API.to_boolean(p_lifecycle_changed))
1475: AND
1476: FND_API.to_boolean(p_lifecycle_phase_changed)
1477: ) THEN
1478: --

Line 1476: FND_API.to_boolean(p_lifecycle_phase_changed)

1472: END IF;
1473:
1474: IF ( NOT (FND_API.to_boolean(p_lifecycle_changed))
1475: AND
1476: FND_API.to_boolean(p_lifecycle_phase_changed)
1477: ) THEN
1478: --
1479: -- check if there are any project associations
1480: --

Line 1510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1506: ,x_return_status => x_return_status
1507: ,x_msg_count => x_msg_count
1508: ,x_msg_data => x_msg_data
1509: );
1510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1511: RETURN;
1512: END IF;
1513: END IF; -- project association found
1514: END IF; -- lifecycle phase only has changed.

Line 1536: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1532: ,x_return_status => x_return_status
1533: ,x_msg_count => x_msg_count
1534: ,x_msg_data => x_msg_data
1535: );
1536: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1537: RETURN;
1538: END IF;
1539: ELSE
1540: CLOSE c_pending_phase_change;

Line 1559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1555: ,x_msg_data => x_msg_data
1556: );
1557: END IF; --Bug: 4060185
1558: code_debug(l_api_name||': returning Check_Pending_Change_Orders with status '|| x_return_status);
1559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1560: RETURN;
1561: END IF;
1562:
1563: IF (FND_API.To_Boolean(p_lifecycle_changed) AND p_item_revision_id IS NULL) THEN

Line 1563: IF (FND_API.To_Boolean(p_lifecycle_changed) AND p_item_revision_id IS NULL) THEN

1559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1560: RETURN;
1561: END IF;
1562:
1563: IF (FND_API.To_Boolean(p_lifecycle_changed) AND p_item_revision_id IS NULL) THEN
1564: -- check for pending changes and remove the associated projects
1565: code_debug(l_api_name||': calling Sync_Item_Revisions LC of item has changed ');
1566: Sync_Item_Revisions (
1567: p_inventory_item_id => p_inventory_item_id

Line 1578: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1574: ,x_msg_count => x_msg_count
1575: ,x_msg_data => x_msg_data
1576: );
1577: code_debug(l_api_name||': returning Sync_Item_Revisions with status '|| x_return_status);
1578: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1579: RETURN;
1580: ELSE
1581: -- everything is fine
1582: -- delete the projects associated with the item.

Line 1603: x_return_status := FND_API.G_RET_STS_SUCCESS;

1599:
1600: END IF;
1601:
1602:
1603: x_return_status := FND_API.G_RET_STS_SUCCESS;
1604: code_debug(l_api_name||': Bye Bye ');
1605:
1606: EXCEPTION
1607: WHEN OTHERS THEN

Line 1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1613: END IF;
1614: IF c_pending_phase_change%ISOPEN THEN
1615: CLOSE c_pending_phase_change;
1616: END IF;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1619: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1620: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1621: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1661: IF NOT FND_API.Compatible_API_Call (l_api_version

1657: l_api_version := 1.0;
1658: l_api_name := 'Create_Phase_History_Record';
1659: --Standard checks
1660: code_debug(l_api_name||': Started ');
1661: IF NOT FND_API.Compatible_API_Call (l_api_version
1662: ,p_api_version
1663: ,l_api_name
1664: ,g_pkg_name)
1665: THEN

Line 1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1662: ,p_api_version
1663: ,l_api_name
1664: ,g_pkg_name)
1665: THEN
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668:
1669: IF FND_API.To_Boolean( p_commit ) THEN
1670: SAVEPOINT Create_Phase_History_SP;

Line 1669: IF FND_API.To_Boolean( p_commit ) THEN

1665: THEN
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668:
1669: IF FND_API.To_Boolean( p_commit ) THEN
1670: SAVEPOINT Create_Phase_History_SP;
1671: END IF;
1672:
1673: l_user_id := FND_GLOBAL.User_Id;

Line 1703: IF FND_API.To_Boolean(p_commit) THEN

1699: l_sysdate,
1700: l_user_id,
1701: p_lifecycle_id,
1702: p_lifecycle_phase_id);
1703: IF FND_API.To_Boolean(p_commit) THEN
1704: COMMIT WORK;
1705: END IF;
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707: code_debug(l_api_name||': Bye Bye ');

Line 1706: x_return_status := FND_API.G_RET_STS_SUCCESS;

1702: p_lifecycle_phase_id);
1703: IF FND_API.To_Boolean(p_commit) THEN
1704: COMMIT WORK;
1705: END IF;
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707: code_debug(l_api_name||': Bye Bye ');
1708: EXCEPTION
1709: WHEN OTHERS THEN
1710: IF FND_API.To_Boolean( p_commit ) THEN

Line 1710: IF FND_API.To_Boolean( p_commit ) THEN

1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707: code_debug(l_api_name||': Bye Bye ');
1708: EXCEPTION
1709: WHEN OTHERS THEN
1710: IF FND_API.To_Boolean( p_commit ) THEN
1711: ROLLBACK TO Create_Phase_History_SP;
1712: END IF;
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

Line 1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1709: WHEN OTHERS THEN
1710: IF FND_API.To_Boolean( p_commit ) THEN
1711: ROLLBACK TO Create_Phase_History_SP;
1712: END IF;
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1715: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1716: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1717: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1789: x_return_status := FND_API.G_RET_STS_ERROR;

1785: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1786: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1787: x_msg_count := 1;
1788: x_msg_data := FND_MESSAGE.GET;
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: RETURN;
1791: END IF;
1792: l_change_notice := FND_API.G_MISS_CHAR;
1793: ELSE

Line 1792: l_change_notice := FND_API.G_MISS_CHAR;

1788: x_msg_data := FND_MESSAGE.GET;
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: RETURN;
1791: END IF;
1792: l_change_notice := FND_API.G_MISS_CHAR;
1793: ELSE
1794: -- 3878336 replacing the existing cursor with dynamic query
1795: l_dynamic_sql := 'SELECT change_notice FROM eng_engineering_changes WHERE change_id = :1' ;
1796: BEGIN

Line 1810: l_change_line_id := NVL(p_change_line_id,FND_API.G_MISS_NUM);

1806: END;
1807:
1808: END IF;
1809:
1810: l_change_line_id := NVL(p_change_line_id,FND_API.G_MISS_NUM);
1811: l_revision_id := p_revision_id;
1812: code_debug(l_api_name||': Change context passed -- change notice: '||l_change_notice ||' change line: '||l_change_line_id);
1813:
1814: -- 3878336 replacing the existing cursor with dynamic query

Line 1871: IF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN

1867: ' AND ENTITY_NAME=''ITEM'' ' ||
1868: ' AND FROM_ENTITY_NAME = ''EGO_ITEM_REVISION'' ) )';
1869:
1870: IF l_revision_id IS NOT NULL THEN
1871: IF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN
1872: code_debug(l_api_name||': Validating only revision changes ');
1873: BEGIN
1874: code_debug(l_api_name||': executing l_dyn_sql_pend_chg_rev ');
1875: code_debug(l_api_name||': executing p_inventory_item_id ' || p_inventory_item_id);

Line 1914: IF FND_API.TO_BOOLEAN(p_lifecycle_changed) THEN

1910: END IF;
1911: ELSE
1912:
1913: -- changes are at item level
1914: IF FND_API.TO_BOOLEAN(p_lifecycle_changed) THEN
1915: -- changing item lc
1916: code_debug(l_api_name||': Validating all item changes ');
1917: -- 3878336 replacing the existing cursor with dynamic query
1918: l_dynamic_sql := 'SELECT organization_id ' ||

Line 1990: ELSIF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN

1986: if (l_dynamic_cursor%ISOPEN) then
1987: CLOSE l_dynamic_cursor;
1988: end if;
1989: END;
1990: ELSIF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN
1991: -- check if there are any pending change
1992: -- associated with the item revision that is NULL
1993: code_debug(l_api_name||': Validating only item phase changes ');
1994: -- 3878336 replacing the existing cursor with dynamic query

Line 2143: x_return_status := FND_API.G_RET_STS_SUCCESS;

2139: ,x_msg_data => x_msg_data
2140: );
2141: ELSE
2142: code_debug(l_api_name||': No Pending Changes ');
2143: x_return_status := FND_API.G_RET_STS_SUCCESS;
2144: x_msg_count := 0;
2145: x_msg_data := NULL;
2146: END IF;
2147: code_debug(l_api_name||': Bye Bye ');

Line 2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2150: code_debug(l_api_name||': error6: ' || SQLERRM);
2151: IF l_dynamic_cursor%ISOPEN THEN
2152: CLOSE l_dynamic_cursor;
2153: END IF;
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2156: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2157: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2158: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);