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 98: x_return_status := FND_API.G_RET_STS_ERROR;

94: x_msg_data := fnd_message.get();
95: --
96: -- return status as Error
97: --
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: EXCEPTION
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

97: --
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: EXCEPTION
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
103: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
104: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'GET_ERROR_MSG');
105: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

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

195: FOR Item_Rev_Record IN c_get_item_rev_details (cp_item_id => p_inventory_item_id
196: ,cp_org_id => p_organization_id)
197: LOOP
198: code_debug(l_api_name||' Checking pending change orders for revision '|| Item_Rev_Record.revision);
199: IF (FND_API.TO_BOOLEAN(p_validate_changes) AND NOT p_new_cc_in_hier) THEN --Bug: 4060185
200: Check_Pending_Change_Orders
201: (p_inventory_item_id => p_inventory_item_id
202: ,p_organization_id => Item_Rev_Record.organization_id
203: ,p_revision_id => Item_Rev_Record.revision_id

Line 204: ,p_lifecycle_changed => FND_API.G_FALSE

200: Check_Pending_Change_Orders
201: (p_inventory_item_id => p_inventory_item_id
202: ,p_organization_id => Item_Rev_Record.organization_id
203: ,p_revision_id => Item_Rev_Record.revision_id
204: ,p_lifecycle_changed => FND_API.G_FALSE
205: ,p_lifecycle_phase_changed => FND_API.G_TRUE
206: ,p_change_id => NULL
207: ,p_change_line_id => NULL
208: ,x_return_status => x_return_status

Line 205: ,p_lifecycle_phase_changed => FND_API.G_TRUE

201: (p_inventory_item_id => p_inventory_item_id
202: ,p_organization_id => Item_Rev_Record.organization_id
203: ,p_revision_id => Item_Rev_Record.revision_id
204: ,p_lifecycle_changed => FND_API.G_FALSE
205: ,p_lifecycle_phase_changed => FND_API.G_TRUE
206: ,p_change_id => NULL
207: ,p_change_line_id => NULL
208: ,x_return_status => x_return_status
209: ,x_msg_count => x_msg_count

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

208: ,x_return_status => x_return_status
209: ,x_msg_count => x_msg_count
210: ,x_msg_data => x_msg_data
211: );
212: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
213: code_debug(l_api_name||' returning Check_Pending_Change_Orders with status '|| x_return_status);
214: RETURN;
215: END IF;
216: END IF;

Line 230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

226: ,x_msg_count => x_msg_count
227: ,x_msg_data => x_msg_data );
228:
229: code_debug(l_api_name||': check_floating_attachments' || x_return_status);
230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
231: RETURN;
232: END IF;
233:
234:

Line 250: ,p_commit => FND_API.G_FALSE

246: --
247: code_debug(l_api_name||': Creating Phase History Record ');
248: Create_Phase_History_Record (
249: p_api_version => 1.0
250: ,p_commit => FND_API.G_FALSE
251: ,p_inventory_item_id => p_inventory_item_id
252: ,p_organization_id => Item_Rev_Record.organization_id
253: ,p_revision_id => Item_Rev_Record.Revision_id
254: ,p_lifecycle_id => l_item_rev_lifecycle_id

Line 261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

257: ,x_return_status => x_return_status
258: ,x_msg_count => x_msg_count
259: ,x_msg_data => x_msg_data
260: );
261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
262: RETURN;
263: END IF;
264: --
265: -- update item revision project

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

272: AND revision_id = Item_Rev_Record.revision_id
273: AND ASSOCIATION_TYPE = 'EGO_ITEM_PROJ_ASSOC_TYPE'
274: AND ASSOCIATION_CODE = 'LIFECYCLE_TRACKING';
275: END LOOP; -- item revision loop
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277: code_debug(l_api_name||': Bye Bye ');
278: EXCEPTION
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277: code_debug(l_api_name||': Bye Bye ');
278: EXCEPTION
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: IF c_get_default_phase_id%ISOPEN THEN
282: CLOSE c_get_default_phase_id;
283: END IF;
284: IF c_get_item_rev_details%ISOPEN THEN

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: END IF;
284: IF c_get_item_rev_details%ISOPEN THEN
285: CLOSE c_get_item_rev_details;
286: END IF;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
289: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
290: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'SYNC_ITEM_REVISIONS');
291: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

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

344: WHERE inventory_item_id = cp_item_id
345: AND organization_id = cp_org_id;
346:
347: --Return Status Variables
348: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
349: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
350: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
351: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
352: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;

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

345: AND organization_id = cp_org_id;
346:
347: --Return Status Variables
348: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
349: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
350: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
351: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
352: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
353:

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

346:
347: --Return Status Variables
348: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
349: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
350: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
351: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
352: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
353:
354: l_status_rec BOOLEAN := FALSE;

Line 384: IF FND_API.To_Boolean( p_commit ) THEN

380: BEGIN
381: x_return_status := l_ret_error;
382: l_api_name := 'Change_Item_Lifecycle';
383: code_debug(l_api_name||': started with org id '||to_char(p_organization_id));
384: IF FND_API.To_Boolean( p_commit ) THEN
385: SAVEPOINT Change_Item_Lifecycle;
386: END IF;
387: code_debug(l_api_name||': Taking the null values ');
388: IF p_new_catalog_category_id = -1 THEN

Line 430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

426: ,x_msg_count => x_msg_count
427: ,x_msg_data => x_msg_data );
428:
429: code_debug(l_api_name||': check_floating_attachments' || x_return_status);
430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
431: IF FND_API.To_Boolean( p_commit ) THEN
432: ROLLBACK TO Change_Item_Lifecycle;
433: END IF;
434: RETURN;

Line 431: IF FND_API.To_Boolean( p_commit ) THEN

427: ,x_msg_data => x_msg_data );
428:
429: code_debug(l_api_name||': check_floating_attachments' || x_return_status);
430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
431: IF FND_API.To_Boolean( p_commit ) THEN
432: ROLLBACK TO Change_Item_Lifecycle;
433: END IF;
434: RETURN;
435: END IF;

Line 439: ,p_commit => FND_API.G_FALSE

435: END IF;
436:
437: Validate_And_Change_Item_LC(
438: p_api_version => 1.0
439: ,p_commit => FND_API.G_FALSE
440: ,p_inventory_item_id => p_inventory_item_id
441: ,p_item_revision_id => NULL
442: ,p_organization_id => p_organization_id
443: ,p_fetch_curr_values => FND_API.G_FALSE

Line 443: ,p_fetch_curr_values => FND_API.G_FALSE

439: ,p_commit => FND_API.G_FALSE
440: ,p_inventory_item_id => p_inventory_item_id
441: ,p_item_revision_id => NULL
442: ,p_organization_id => p_organization_id
443: ,p_fetch_curr_values => FND_API.G_FALSE
444: ,p_curr_cc_id => l_curr_cc_id
445: ,p_new_cc_id => l_new_cc_id
446: ,p_is_new_cc_in_hier => FND_API.G_TRUE
447: ,p_curr_lc_id => l_curr_lifecycle_id

Line 446: ,p_is_new_cc_in_hier => FND_API.G_TRUE

442: ,p_organization_id => p_organization_id
443: ,p_fetch_curr_values => FND_API.G_FALSE
444: ,p_curr_cc_id => l_curr_cc_id
445: ,p_new_cc_id => l_new_cc_id
446: ,p_is_new_cc_in_hier => FND_API.G_TRUE
447: ,p_curr_lc_id => l_curr_lifecycle_id
448: ,p_new_lc_id => l_new_lifecycle_id
449: ,p_curr_lcp_id => l_curr_phase_id
450: ,p_new_lcp_id => l_new_phase_id

Line 457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

453: ,x_return_status => x_return_status
454: ,x_msg_count => x_msg_count
455: ,x_msg_data => x_msg_data
456: );
457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
458: IF FND_API.To_Boolean( p_commit ) THEN
459: ROLLBACK TO Change_Item_Lifecycle;
460: END IF;
461: RETURN;

Line 458: IF FND_API.To_Boolean( p_commit ) THEN

454: ,x_msg_count => x_msg_count
455: ,x_msg_data => x_msg_data
456: );
457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
458: IF FND_API.To_Boolean( p_commit ) THEN
459: ROLLBACK TO Change_Item_Lifecycle;
460: END IF;
461: RETURN;
462: END IF;

Line 626: IF FND_API.To_Boolean( p_commit ) THEN

622: --R12: Business Event Enhancement
623:
624:
625:
626: IF FND_API.To_Boolean( p_commit ) THEN
627: COMMIT WORK;
628: END IF;
629: x_return_status := l_ret_success;
630: code_debug(l_api_name||': Bye Bye ');

Line 633: IF FND_API.To_Boolean( p_commit ) THEN

629: x_return_status := l_ret_success;
630: code_debug(l_api_name||': Bye Bye ');
631: EXCEPTION
632: WHEN OTHERS THEN
633: IF FND_API.To_Boolean( p_commit ) THEN
634: ROLLBACK TO Change_Item_Lifecycle;
635: END IF;
636: IF c_get_item_details%ISOPEN THEN
637: CLOSE c_get_item_details;

Line 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

638: END IF;
639: IF c_get_item_curr_data%ISOPEN THEN
640: CLOSE c_get_item_curr_data;
641: END IF;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
644: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
645: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
646: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

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

718: START WITH item_catalog_group_id = cp_new_id));
719:
720: */
721:
722: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
723: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
724: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
725:
726: l_change BOOLEAN := FALSE;

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

719:
720: */
721:
722: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
723: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
724: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
725:
726: l_change BOOLEAN := FALSE;
727: l_organization_id NUMBER;

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

720: */
721:
722: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
723: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
724: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
725:
726: l_change BOOLEAN := FALSE;
727: l_organization_id NUMBER;
728: l_api_name VARCHAR2(30);

Line 744: IF FND_API.To_Boolean( p_commit ) THEN

740: 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));
741: 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));
742: code_debug(l_api_name||': P_NEW_ITEM_STATUS_CODE: '||P_NEW_ITEM_STATUS_CODE);
743:
744: IF FND_API.To_Boolean( p_commit ) THEN
745: SAVEPOINT Change_Item_Catalog;
746: END IF;
747: x_return_status := l_ret_error;
748:

Line 766: p_commit => FND_API.G_FALSE,

762: p_new_catalog_category_id => p_new_catalog_group_id,
763: p_new_lifecycle_id => p_new_lifecycle_id,
764: p_new_phase_id => p_new_phase_id,
765: p_new_item_status_code => p_new_item_status_code,
766: p_commit => FND_API.G_FALSE,
767: x_return_status => x_return_status,
768: x_msg_data => x_msg_data,
769: x_msg_count => x_msg_count);
770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

766: p_commit => FND_API.G_FALSE,
767: x_return_status => x_return_status,
768: x_msg_data => x_msg_data,
769: x_msg_count => x_msg_count);
770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
771: RETURN;
772: END IF;
773: END LOOP;
774:

Line 948: IF FND_API.To_Boolean( p_commit ) THEN

944: ELSE
945: RETURN;
946: END IF;
947: ***/
948: IF FND_API.To_Boolean( p_commit ) THEN
949: COMMIT WORK;
950: INV_ITEM_PVT.SYNC_IM_INDEX; --3026311 Sync iM index
951:
952: -- Call IP Intermedia Sync

Line 959: IF FND_API.To_Boolean( p_commit ) THEN

955: END IF;
956: code_debug(l_api_name||': Bye Bye ');
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF FND_API.To_Boolean( p_commit ) THEN
960: ROLLBACK TO Change_Item_Catalog;
961: END IF;
962: IF c_get_item_details%ISOPEN THEN
963: CLOSE c_get_item_details;

Line 971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

967: END IF;
968: IF c_get_master_org_details%ISOPEN THEN
969: CLOSE c_get_master_org_details;
970: END IF;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
973: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
974: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
975: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1066: l_lc_changed := FND_API.G_FALSE;

1062:
1063: BEGIN
1064: l_api_version := 1.0;
1065: l_api_name := 'Validate_And_Change_Item_LC';
1066: l_lc_changed := FND_API.G_FALSE;
1067: l_lcp_changed := FND_API.G_FALSE;
1068: l_perform_sync_only := FND_API.G_FALSE;
1069: l_null_id_value := FND_API.G_MISS_NUM;
1070:

Line 1067: l_lcp_changed := FND_API.G_FALSE;

1063: BEGIN
1064: l_api_version := 1.0;
1065: l_api_name := 'Validate_And_Change_Item_LC';
1066: l_lc_changed := FND_API.G_FALSE;
1067: l_lcp_changed := FND_API.G_FALSE;
1068: l_perform_sync_only := FND_API.G_FALSE;
1069: l_null_id_value := FND_API.G_MISS_NUM;
1070:
1071: code_debug(l_api_name||': Started with parameters ');

Line 1068: l_perform_sync_only := FND_API.G_FALSE;

1064: l_api_version := 1.0;
1065: l_api_name := 'Validate_And_Change_Item_LC';
1066: l_lc_changed := FND_API.G_FALSE;
1067: l_lcp_changed := FND_API.G_FALSE;
1068: l_perform_sync_only := FND_API.G_FALSE;
1069: l_null_id_value := FND_API.G_MISS_NUM;
1070:
1071: code_debug(l_api_name||': Started with parameters ');
1072: code_debug(' p_api_version : '||p_api_version||' p_commit : '|| p_commit);

Line 1069: l_null_id_value := FND_API.G_MISS_NUM;

1065: l_api_name := 'Validate_And_Change_Item_LC';
1066: l_lc_changed := FND_API.G_FALSE;
1067: l_lcp_changed := FND_API.G_FALSE;
1068: l_perform_sync_only := FND_API.G_FALSE;
1069: l_null_id_value := FND_API.G_MISS_NUM;
1070:
1071: code_debug(l_api_name||': Started with parameters ');
1072: code_debug(' p_api_version : '||p_api_version||' p_commit : '|| p_commit);
1073: 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 1079: IF NOT FND_API.Compatible_API_Call (l_api_version

1075: 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);
1076: code_debug(' p_curr_lcp_id : '|| p_curr_lcp_id ||' p_new_lcp_id: '|| p_new_lcp_id ||' p_change_id : '|| p_change_id);
1077:
1078: --Standard checks
1079: IF NOT FND_API.Compatible_API_Call (l_api_version
1080: ,p_api_version
1081: ,l_api_name
1082: ,g_pkg_name)
1083: THEN

Line 1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1080: ,p_api_version
1081: ,l_api_name
1082: ,g_pkg_name)
1083: THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087: IF FND_API.To_Boolean( p_commit ) THEN
1088: SAVEPOINT Validate_And_Change_Item_LC_SP;

Line 1087: IF FND_API.To_Boolean( p_commit ) THEN

1083: THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087: IF FND_API.To_Boolean( p_commit ) THEN
1088: SAVEPOINT Validate_And_Change_Item_LC_SP;
1089: END IF;
1090:
1091: IF FND_API.TO_BOOLEAN(p_fetch_curr_values) THEN

Line 1091: IF FND_API.TO_BOOLEAN(p_fetch_curr_values) THEN

1087: IF FND_API.To_Boolean( p_commit ) THEN
1088: SAVEPOINT Validate_And_Change_Item_LC_SP;
1089: END IF;
1090:
1091: IF FND_API.TO_BOOLEAN(p_fetch_curr_values) THEN
1092: IF p_item_revision_id IS NULL THEN
1093: -- fetch from item
1094: OPEN c_get_curr_item_val (cp_item_id => p_inventory_item_id
1095: ,cp_org_id => p_organization_id

Line 1148: l_lc_changed := FND_API.G_TRUE;

1144: -- perform validations if lc is chosen
1145: code_debug(l_api_name||' validate item as CC has changed from null to NOT Null ');
1146: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1147: l_validate := TRUE;
1148: l_lc_changed := FND_API.G_TRUE;
1149: l_lcp_changed := FND_API.G_TRUE;
1150: ELSE
1151: -- perform no validations.
1152: -- user

Line 1149: l_lcp_changed := FND_API.G_TRUE;

1145: code_debug(l_api_name||' validate item as CC has changed from null to NOT Null ');
1146: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1147: l_validate := TRUE;
1148: l_lc_changed := FND_API.G_TRUE;
1149: l_lcp_changed := FND_API.G_TRUE;
1150: ELSE
1151: -- perform no validations.
1152: -- user
1153: NULL;

Line 1162: l_lc_changed := FND_API.G_TRUE;

1158: IF p_new_lc_id IS NULL THEN
1159: IF l_new_cc_id IS NULL THEN
1160: 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 ');
1161: l_validate := TRUE;
1162: l_lc_changed := FND_API.G_TRUE;
1163: l_lcp_changed := FND_API.G_TRUE;
1164: ELSE
1165: -- catalog category is changed
1166: -- but no LC associated. check hierarchy

Line 1163: l_lcp_changed := FND_API.G_TRUE;

1159: IF l_new_cc_id IS NULL THEN
1160: 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 ');
1161: l_validate := TRUE;
1162: l_lc_changed := FND_API.G_TRUE;
1163: l_lcp_changed := FND_API.G_TRUE;
1164: ELSE
1165: -- catalog category is changed
1166: -- but no LC associated. check hierarchy
1167: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN

Line 1167: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN

1163: l_lcp_changed := FND_API.G_TRUE;
1164: ELSE
1165: -- catalog category is changed
1166: -- but no LC associated. check hierarchy
1167: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN
1168: l_new_cc_in_hier := TRUE;
1169: ELSIF p_is_new_cc_in_hier = FND_API.G_FALSE THEN
1170: l_new_cc_in_hier := FALSE;
1171: ELSE

Line 1169: ELSIF p_is_new_cc_in_hier = FND_API.G_FALSE THEN

1165: -- catalog category is changed
1166: -- but no LC associated. check hierarchy
1167: IF p_is_new_cc_in_hier = FND_API.G_TRUE THEN
1168: l_new_cc_in_hier := TRUE;
1169: ELSIF p_is_new_cc_in_hier = FND_API.G_FALSE THEN
1170: l_new_cc_in_hier := FALSE;
1171: ELSE
1172: OPEN c_check_cc_hier (cp_curr_cc_id => l_curr_cc_id
1173: ,cp_new_cc_id => l_new_cc_id

Line 1188: l_perform_sync_only := FND_API.G_TRUE;

1184: -- perform only sync
1185: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1186: code_debug(l_api_name||' perform only sync as the lifecycle is changed to null ');
1187: l_validate := TRUE;
1188: l_perform_sync_only := FND_API.G_TRUE;
1189: END IF;
1190: ELSE
1191: 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');
1192: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN

Line 1194: l_lc_changed := FND_API.G_TRUE;

1190: ELSE
1191: 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');
1192: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1193: l_validate := TRUE;
1194: l_lc_changed := FND_API.G_TRUE;
1195: l_lcp_changed := FND_API.G_TRUE;
1196: END IF;
1197: END IF;
1198: END IF; -- for l_new_cc_id IS NULL check

Line 1195: l_lcp_changed := FND_API.G_TRUE;

1191: 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');
1192: IF NVL(l_curr_lc_id,l_null_id_value) <> NVL(p_new_lc_id,l_null_id_value) THEN
1193: l_validate := TRUE;
1194: l_lc_changed := FND_API.G_TRUE;
1195: l_lcp_changed := FND_API.G_TRUE;
1196: END IF;
1197: END IF;
1198: END IF; -- for l_new_cc_id IS NULL check
1199: ELSE -- new lifecycle is chosen.

Line 1208: l_lcp_changed := FND_API.G_TRUE;

1204: AND
1205: NVL(l_curr_lc_id,l_null_id_value) = NVL(p_new_lc_id,l_null_id_value)
1206: AND
1207: NVL(l_curr_lcp_id,l_null_id_value) <> NVL(p_new_lcp_id,l_null_id_value) THEN
1208: l_lcp_changed := FND_API.G_TRUE;
1209: ELSE
1210: l_lc_changed := FND_API.G_TRUE;
1211: l_lcp_changed := FND_API.G_TRUE;
1212: END IF;

Line 1210: l_lc_changed := FND_API.G_TRUE;

1206: AND
1207: NVL(l_curr_lcp_id,l_null_id_value) <> NVL(p_new_lcp_id,l_null_id_value) THEN
1208: l_lcp_changed := FND_API.G_TRUE;
1209: ELSE
1210: l_lc_changed := FND_API.G_TRUE;
1211: l_lcp_changed := FND_API.G_TRUE;
1212: END IF;
1213: END IF; -- for new lc_id IS NOT NULL
1214: END IF; -- for curr_cc_id check end

Line 1211: l_lcp_changed := FND_API.G_TRUE;

1207: NVL(l_curr_lcp_id,l_null_id_value) <> NVL(p_new_lcp_id,l_null_id_value) THEN
1208: l_lcp_changed := FND_API.G_TRUE;
1209: ELSE
1210: l_lc_changed := FND_API.G_TRUE;
1211: l_lcp_changed := FND_API.G_TRUE;
1212: END IF;
1213: END IF; -- for new lc_id IS NOT NULL
1214: END IF; -- for curr_cc_id check end
1215:

Line 1232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1228: ,x_return_status => x_return_status
1229: ,x_msg_count => x_msg_count
1230: ,x_msg_data => x_msg_data
1231: );
1232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: RETURN;
1234: END IF;
1235: END IF; -- end l_validate
1236:

Line 1237: IF FND_API.To_Boolean(p_commit) THEN

1233: RETURN;
1234: END IF;
1235: END IF; -- end l_validate
1236:
1237: IF FND_API.To_Boolean(p_commit) THEN
1238: COMMIT WORK;
1239: END IF;
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241: code_debug(l_api_name||': Bye Bye ');

Line 1240: x_return_status := FND_API.G_RET_STS_SUCCESS;

1236:
1237: IF FND_API.To_Boolean(p_commit) THEN
1238: COMMIT WORK;
1239: END IF;
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241: code_debug(l_api_name||': Bye Bye ');
1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN

Line 1245: IF FND_API.To_Boolean( p_commit ) THEN

1241: code_debug(l_api_name||': Bye Bye ');
1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: IF FND_API.To_Boolean( p_commit ) THEN
1246: ROLLBACK TO Validate_And_Change_Item_LC_SP;
1247: END IF;
1248: IF c_get_curr_item_val%ISOPEN THEN
1249: CLOSE c_get_curr_item_val;

Line 1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1253: END IF;
1254: IF c_check_cc_hier%ISOPEN THEN
1255: CLOSE c_check_cc_hier;
1256: END IF;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1259: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1260: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
1261: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1367: IF NOT FND_API.Compatible_API_Call (l_api_version

1363: code_debug(l_api_name||': p_lifecycle_id: '||to_char(p_lifecycle_id)||' p_lifecycle_phase_id: '||to_char(p_lifecycle_phase_id));
1364: code_debug(l_api_name||': p_lifecycle_changed: '||p_lifecycle_changed||' p_lifecycle_phase_changed: '||p_lifecycle_phase_changed);
1365:
1366: --Standard checks
1367: IF NOT FND_API.Compatible_API_Call (l_api_version
1368: ,p_api_version
1369: ,l_api_name
1370: ,g_pkg_name)
1371: THEN

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: ,p_api_version
1369: ,l_api_name
1370: ,g_pkg_name)
1371: THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374:
1375: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1376: OR

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

1371: THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374:
1375: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1376: OR
1377: FND_API.To_Boolean(p_lifecycle_phase_changed)
1378: OR
1379: FND_API.To_Boolean(p_perform_sync_only)

Line 1377: FND_API.To_Boolean(p_lifecycle_phase_changed)

1373: END IF;
1374:
1375: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1376: OR
1377: FND_API.To_Boolean(p_lifecycle_phase_changed)
1378: OR
1379: FND_API.To_Boolean(p_perform_sync_only)
1380: ) THEN
1381: RETURN;

Line 1379: FND_API.To_Boolean(p_perform_sync_only)

1375: IF NOT( FND_API.To_Boolean(p_lifecycle_changed)
1376: OR
1377: FND_API.To_Boolean(p_lifecycle_phase_changed)
1378: OR
1379: FND_API.To_Boolean(p_perform_sync_only)
1380: ) THEN
1381: RETURN;
1382: END IF;
1383: --

Line 1388: IF FND_API.To_Boolean(p_perform_sync_only) THEN

1384: -- inv team wish to call only Sync on certain conditions
1385: -- instead of calling another procedure, then wish to have SYNC
1386: -- exposed from here only
1387: --
1388: IF FND_API.To_Boolean(p_perform_sync_only) THEN
1389: code_debug(l_api_name||': calling Sync_Item_Revisions using perform sync only ');
1390: Sync_Item_Revisions(
1391: p_inventory_item_id => p_inventory_item_id
1392: ,p_organization_id => p_organization_id

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

1401: code_debug(l_api_name||': returning Sync_Item_Revisions perform sync only '|| x_return_status);
1402: RETURN;
1403: END IF;
1404:
1405: IF ( NOT (FND_API.to_boolean(p_lifecycle_changed))
1406: AND
1407: FND_API.to_boolean(p_lifecycle_phase_changed)
1408: ) THEN
1409: --

Line 1407: FND_API.to_boolean(p_lifecycle_phase_changed)

1403: END IF;
1404:
1405: IF ( NOT (FND_API.to_boolean(p_lifecycle_changed))
1406: AND
1407: FND_API.to_boolean(p_lifecycle_phase_changed)
1408: ) THEN
1409: --
1410: -- check if there are any project associations
1411: --

Line 1441: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1437: ,x_return_status => x_return_status
1438: ,x_msg_count => x_msg_count
1439: ,x_msg_data => x_msg_data
1440: );
1441: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1442: RETURN;
1443: END IF;
1444: END IF; -- project association found
1445: END IF; -- lifecycle phase only has changed.

Line 1467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1463: ,x_return_status => x_return_status
1464: ,x_msg_count => x_msg_count
1465: ,x_msg_data => x_msg_data
1466: );
1467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1468: RETURN;
1469: END IF;
1470: ELSE
1471: CLOSE c_pending_phase_change;

Line 1490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1486: ,x_msg_data => x_msg_data
1487: );
1488: END IF; --Bug: 4060185
1489: code_debug(l_api_name||': returning Check_Pending_Change_Orders with status '|| x_return_status);
1490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: RETURN;
1492: END IF;
1493:
1494: IF (FND_API.To_Boolean(p_lifecycle_changed) AND p_item_revision_id IS NULL) THEN

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

1490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: RETURN;
1492: END IF;
1493:
1494: IF (FND_API.To_Boolean(p_lifecycle_changed) AND p_item_revision_id IS NULL) THEN
1495: -- check for pending changes and remove the associated projects
1496: code_debug(l_api_name||': calling Sync_Item_Revisions LC of item has changed ');
1497: Sync_Item_Revisions (
1498: p_inventory_item_id => p_inventory_item_id

Line 1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1505: ,x_msg_count => x_msg_count
1506: ,x_msg_data => x_msg_data
1507: );
1508: code_debug(l_api_name||': returning Sync_Item_Revisions with status '|| x_return_status);
1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1510: RETURN;
1511: ELSE
1512: -- everything is fine
1513: -- delete the projects associated with the item.

Line 1530: x_return_status := FND_API.G_RET_STS_SUCCESS;

1526: AND association_code = 'LIFECYCLE_TRACKING' ;
1527: END IF;
1528: END IF; -- lifecycle has changed
1529:
1530: x_return_status := FND_API.G_RET_STS_SUCCESS;
1531: code_debug(l_api_name||': Bye Bye ');
1532:
1533: EXCEPTION
1534: WHEN OTHERS THEN

Line 1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1540: END IF;
1541: IF c_pending_phase_change%ISOPEN THEN
1542: CLOSE c_pending_phase_change;
1543: END IF;
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1545: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1546: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1547: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHANGE_ITEM_LC_DEPENDENCIES');
1548: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1588: IF NOT FND_API.Compatible_API_Call (l_api_version

1584: l_api_version := 1.0;
1585: l_api_name := 'Create_Phase_History_Record';
1586: --Standard checks
1587: code_debug(l_api_name||': Started ');
1588: IF NOT FND_API.Compatible_API_Call (l_api_version
1589: ,p_api_version
1590: ,l_api_name
1591: ,g_pkg_name)
1592: THEN

Line 1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1589: ,p_api_version
1590: ,l_api_name
1591: ,g_pkg_name)
1592: THEN
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: END IF;
1595:
1596: IF FND_API.To_Boolean( p_commit ) THEN
1597: SAVEPOINT Create_Phase_History_SP;

Line 1596: IF FND_API.To_Boolean( p_commit ) THEN

1592: THEN
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: END IF;
1595:
1596: IF FND_API.To_Boolean( p_commit ) THEN
1597: SAVEPOINT Create_Phase_History_SP;
1598: END IF;
1599:
1600: l_user_id := FND_GLOBAL.User_Id;

Line 1630: IF FND_API.To_Boolean(p_commit) THEN

1626: l_sysdate,
1627: l_user_id,
1628: p_lifecycle_id,
1629: p_lifecycle_phase_id);
1630: IF FND_API.To_Boolean(p_commit) THEN
1631: COMMIT WORK;
1632: END IF;
1633: x_return_status := FND_API.G_RET_STS_SUCCESS;
1634: code_debug(l_api_name||': Bye Bye ');

Line 1633: x_return_status := FND_API.G_RET_STS_SUCCESS;

1629: p_lifecycle_phase_id);
1630: IF FND_API.To_Boolean(p_commit) THEN
1631: COMMIT WORK;
1632: END IF;
1633: x_return_status := FND_API.G_RET_STS_SUCCESS;
1634: code_debug(l_api_name||': Bye Bye ');
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: IF FND_API.To_Boolean( p_commit ) THEN

Line 1637: IF FND_API.To_Boolean( p_commit ) THEN

1633: x_return_status := FND_API.G_RET_STS_SUCCESS;
1634: code_debug(l_api_name||': Bye Bye ');
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: IF FND_API.To_Boolean( p_commit ) THEN
1638: ROLLBACK TO Create_Phase_History_SP;
1639: END IF;
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);

Line 1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1636: WHEN OTHERS THEN
1637: IF FND_API.To_Boolean( p_commit ) THEN
1638: ROLLBACK TO Create_Phase_History_SP;
1639: END IF;
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
1642: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1643: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CREATE_PHASE_HISTORY_RECORD');
1644: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 1716: x_return_status := FND_API.G_RET_STS_ERROR;

1712: FND_MESSAGE.Set_Token('VALUE1', 'CHECK_ID');
1713: FND_MESSAGE.Set_Token('VALUE2', 'CHANGE_LINE_ID');
1714: x_msg_count := 1;
1715: x_msg_data := FND_MESSAGE.GET;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: RETURN;
1718: END IF;
1719: l_change_notice := FND_API.G_MISS_CHAR;
1720: ELSE

Line 1719: l_change_notice := FND_API.G_MISS_CHAR;

1715: x_msg_data := FND_MESSAGE.GET;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: RETURN;
1718: END IF;
1719: l_change_notice := FND_API.G_MISS_CHAR;
1720: ELSE
1721: -- 3878336 replacing the existing cursor with dynamic query
1722: l_dynamic_sql := 'SELECT change_notice FROM eng_engineering_changes WHERE change_id = :1' ;
1723: BEGIN

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

1733: END;
1734:
1735: END IF;
1736:
1737: l_change_line_id := NVL(p_change_line_id,FND_API.G_MISS_NUM);
1738: l_revision_id := p_revision_id;
1739: code_debug(l_api_name||': Change context passed -- change notice: '||l_change_notice ||' change line: '||l_change_line_id);
1740:
1741: -- 3878336 replacing the existing cursor with dynamic query

Line 1793: IF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN

1789: ' AND ENTITY_NAME=''ITEM'' ' ||
1790: ' AND FROM_ENTITY_NAME = ''EGO_ITEM_REVISION'' ) )';
1791:
1792: IF l_revision_id IS NOT NULL THEN
1793: IF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN
1794: code_debug(l_api_name||': Validating only revision changes ');
1795: BEGIN
1796: code_debug(l_api_name||': executing l_dyn_sql_pend_chg_rev ');
1797: code_debug(l_api_name||': executing p_inventory_item_id ' || p_inventory_item_id);

Line 1836: IF FND_API.TO_BOOLEAN(p_lifecycle_changed) THEN

1832: END IF;
1833: ELSE
1834:
1835: -- changes are at item level
1836: IF FND_API.TO_BOOLEAN(p_lifecycle_changed) THEN
1837: -- changing item lc
1838: code_debug(l_api_name||': Validating all item changes ');
1839: -- 3878336 replacing the existing cursor with dynamic query
1840: l_dynamic_sql := 'SELECT organization_id ' ||

Line 1912: ELSIF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN

1908: if (l_dynamic_cursor%ISOPEN) then
1909: CLOSE l_dynamic_cursor;
1910: end if;
1911: END;
1912: ELSIF FND_API.TO_BOOLEAN(p_lifecycle_phase_changed) THEN
1913: -- check if there are any pending change
1914: -- associated with the item revision that is NULL
1915: code_debug(l_api_name||': Validating only item phase changes ');
1916: -- 3878336 replacing the existing cursor with dynamic query

Line 2061: x_return_status := FND_API.G_RET_STS_SUCCESS;

2057: ,x_msg_data => x_msg_data
2058: );
2059: ELSE
2060: code_debug(l_api_name||': No Pending Changes ');
2061: x_return_status := FND_API.G_RET_STS_SUCCESS;
2062: x_msg_count := 0;
2063: x_msg_data := NULL;
2064: END IF;
2065: code_debug(l_api_name||': Bye Bye ');

Line 2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2068: code_debug(l_api_name||': error6: ' || SQLERRM);
2069: IF l_dynamic_cursor%ISOPEN THEN
2070: CLOSE l_dynamic_cursor;
2071: END IF;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
2074: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
2075: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'CHECK_PENDING_CHANGE_ORDERS');
2076: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);