[Home] [Help]
27: G_GE_VAL CONSTANT VARCHAR2(2) := 'GE';
28: G_LT_VAL CONSTANT VARCHAR2(2) := 'LT';
29: G_LE_VAL CONSTANT VARCHAR2(2) := 'LE';
30:
31: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;
32: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;
33:
34: G_EGO_ITEM CONSTANT VARCHAR2(20) := 'EGO_ITEM';
35: G_HZ_USER_PARTY_TYPE CONSTANT VARCHAR2(20) := 'PERSON';
28: G_LT_VAL CONSTANT VARCHAR2(2) := 'LT';
29: G_LE_VAL CONSTANT VARCHAR2(2) := 'LE';
30:
31: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;
32: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;
33:
34: G_EGO_ITEM CONSTANT VARCHAR2(20) := 'EGO_ITEM';
35: G_HZ_USER_PARTY_TYPE CONSTANT VARCHAR2(20) := 'PERSON';
36: G_HZ_COMPANY_PARTY_TYPE CONSTANT VARCHAR2(20) := 'ORGANIZATION';
148: where organization_id = x_organization_id;
149: RETURN TRUE;
150: EXCEPTION
151: WHEN OTHERS THEN
152: IF FND_API.To_Boolean(p_set_message) THEN
153: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
154: l_dummy_char := fnd_message.get();
155: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
156: fnd_message.Set_Token('NAME', l_dummy_char);
167: where organization_code = p_organization_code;
168: RETURN TRUE;
169: EXCEPTION
170: WHEN OTHERS THEN
171: IF FND_API.To_Boolean(p_set_message) THEN
172: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
173: l_dummy_char := fnd_message.get();
174: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
175: fnd_message.Set_Token('NAME', l_dummy_char);
213: AND itm_num.organization_id = itm.organization_id;
214: RETURN TRUE;
215: EXCEPTION
216: WHEN OTHERS THEN
217: IF FND_API.To_Boolean(p_set_message) THEN
218: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_INV_ITEM_ID_ERR');
219: fnd_message.Set_Token('ITEM_ID', x_inventory_item_id);
220: fnd_msg_pub.Add;
221: END IF;
232: AND itm.organization_id = itm_num.organization_id;
233: RETURN TRUE;
234: EXCEPTION
235: WHEN OTHERS THEN
236: IF FND_API.To_Boolean(p_set_message) THEN
237: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_ITEM_NUM_ERR');
238: fnd_message.Set_Token('ITEM_NUMBER', x_item_number);
239: fnd_msg_pub.Add;
240: END IF;
246: -- x_approval_status := NULL;
247: RETURN FALSE;
248: END IF;
249: ELSE
250: IF FND_API.To_Boolean(p_set_message) THEN
251: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
252: l_dummy_char := fnd_message.get();
253: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
254: fnd_message.Set_Token('NAME', l_dummy_char);
290: AND revision_id = x_revision_id;
291: RETURN TRUE;
292: EXCEPTION
293: WHEN OTHERS THEN
294: IF FND_API.To_Boolean(p_set_message) THEN
295: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISIONID_INVALID');
296: fnd_message.Set_Token('REVISION_ID', x_revision_id);
297: fnd_msg_pub.Add;
298: END IF;
308: AND revision = x_revision;
309: RETURN TRUE;
310: EXCEPTION
311: WHEN OTHERS THEN
312: IF FND_API.To_Boolean(p_set_message) THEN
313: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISION_INVALID');
314: fnd_message.Set_Token('REVISION', x_revision);
315: fnd_msg_pub.Add;
316: END IF;
543: RETURN TRUE;
544: IF fnd_function.test(p_function_name) THEN
545: RETURN TRUE;
546: ELSE
547: IF FND_API.To_Boolean(p_set_message) THEN
548: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
549: fnd_msg_pub.Add;
550: END IF;
551: RETURN FALSE;
763: ERROR_HANDLER.Add_Error_Message(
764: p_message_name => 'EGO_EF_BL_ITM_NOT_ALLOW_ERR'
765: ,p_application_id => 'EGO'
766: ,p_token_tbl => l_token_table
767: ,p_message_type => FND_API.G_RET_STS_ERROR
768: ,p_row_identifier => l_row_identifier
769: ,p_entity_id => p_entity_id
770: ,p_entity_index => p_entity_index
771: ,p_entity_code => p_entity_code
769: ,p_entity_id => p_entity_id
770: ,p_entity_index => p_entity_index
771: ,p_entity_code => p_entity_code
772: );
773: x_return_status:=FND_API.G_RET_STS_ERROR;
774: l_token_table.DELETE();
775: --Delete the row from the ROW_TABLE as it is an error case.
776: ELSIF (l_is_required='N') THEN
777: i:=i+1;
798: -- -----------------------------------------------------------------------------
799:
800: PROCEDURE Process_Items
801: (
802: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
803: , x_return_status OUT NOCOPY VARCHAR2
804: , x_msg_count OUT NOCOPY NUMBER
805: )
806: IS
907: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
908: ----------------------------------------------------------------
909: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
910: l_cat_tab_index NUMBER := G_MISS_NUM ;
911: l_cat_match VARCHAR2(1) DEFAULT FND_API.G_FALSE ;
912: --Bug: 4881908
913: l_process_control VARCHAR2(2000) := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
914: ---------------------------------------------------------------------------
915: TYPE CATEGORY_ASSIGN_REC IS RECORD (
1412:
1413: IF l_Process_Control = 'EGO_INTERFACE_HANDLER' THEN
1414: INV_ITEM_GRP.Interface_Handler
1415: (
1416: p_commit => FND_API.G_TRUE
1417: ,p_transaction_type => G_Item_Rec.Transaction_Type
1418: ,p_Item_rec => l_Item_rec_in
1419: ,P_revision_rec => l_revision_rec
1420: ,p_Template_Id => l_template_id
1623: -------------------------------------------------------------------------
1624: l_cat_tab_index := 1 ;
1625: FOR DEFAULT_CAT_ASSIGN_REC IN DEFAULT_CAT_ASSIGN_UPDATE(CP_ITEM_ID => l_Item_rec_out.INVENTORY_ITEM_ID ,CP_ORG_ID => l_Item_rec_out.ORGANIZATION_ID)
1626: LOOP
1627: l_cat_match := FND_API.G_FALSE;
1628: l_cat_assign_rec_table_aft(l_cat_tab_index).CATEGORY_SET_ID := DEFAULT_CAT_ASSIGN_REC.CATEGORY_SET_ID;
1629: l_cat_assign_rec_table_aft(l_cat_tab_index).CATEGORY_ID := DEFAULT_CAT_ASSIGN_REC.CATEGORY_ID;
1630: l_cat_assign_rec_table_aft(l_cat_tab_index).INVENTORY_ITEM_ID := l_Item_rec_out.INVENTORY_ITEM_ID;
1631: l_cat_assign_rec_table_aft(l_cat_tab_index).ORGANIZATION_ID := l_Item_rec_in.ORGANIZATION_ID;
1632: IF l_cat_assign_rec_table_bef IS NOT NULL AND l_cat_assign_rec_table_bef.FIRST IS NOT NULL THEN
1633: FOR CAT_REC_BEF IN l_cat_assign_rec_table_bef.FIRST .. l_cat_assign_rec_table_bef.LAST
1634: LOOP
1635: IF l_cat_assign_rec_table_aft(l_cat_tab_index).CATEGORY_SET_ID = l_cat_assign_rec_table_bef(CAT_REC_BEF).CATEGORY_SET_ID THEN
1636: l_cat_match := FND_API.G_TRUE;
1637: ELSE
1638: NULL;
1639: END IF;
1640: END LOOP;
1638: NULL;
1639: END IF;
1640: END LOOP;
1641: END IF;
1642: IF l_cat_match = FND_API.G_FALSE THEN
1643: EGO_WF_WRAPPER_PVT.Raise_Item_Event(
1644: p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT
1645: ,p_inventory_item_id => l_cat_assign_rec_table_aft(l_cat_tab_index).INVENTORY_ITEM_ID
1646: ,p_organization_id => l_cat_assign_rec_table_aft(l_cat_tab_index).ORGANIZATION_ID
1786: -- -----------------------------------------------------------------------------
1787:
1788: PROCEDURE Process_Item_Org_Assignments
1789: (
1790: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
1791: , x_return_status OUT NOCOPY VARCHAR2
1792: , x_msg_count OUT NOCOPY NUMBER
1793: )
1794: IS
2059: );
2060:
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2064: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
2065:
2066: END Seed_Item_Long_Desc_Attr_Group;
2067:
2185: AND MESSAGE_NAME = 'EGO_ITEM_LONG_DESCRIPTION'
2186: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
2187: AND M.APPLICATION_ID = 431;
2188:
2189: x_return_status := FND_API.G_RET_STS_SUCCESS;
2190:
2191: EXCEPTION
2192: WHEN OTHERS THEN
2193:
2190:
2191: EXCEPTION
2192: WHEN OTHERS THEN
2193:
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2195: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
2196:
2197: END Seed_Item_Long_Desc_In_Bulk;
2198:
2268: ERROR_HANDLER.Add_Error_Message(
2269: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'
2270: ,p_application_id => 'EGO'
2271: ,p_token_tbl => l_token_table
2272: ,p_message_type => FND_API.G_RET_STS_ERROR
2273: ,p_entity_id => p_entity_id
2274: ,p_entity_index => p_entity_index
2275: ,p_entity_code => p_entity_code
2276: );
2362:
2363: ERROR_HANDLER.Add_Error_Message(
2364: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
2365: ,p_application_id => 'EGO'
2366: ,p_message_type => FND_API.G_RET_STS_ERROR
2367: ,p_entity_id => p_entity_id
2368: ,p_entity_index => p_entity_index
2369: ,p_entity_code => p_entity_code
2370: );
2368: ,p_entity_index => p_entity_index
2369: ,p_entity_code => p_entity_code
2370: );
2371:
2372: RAISE FND_API.G_EXC_ERROR;
2373:
2374: END;
2375:
2376: ------------------- BEGIN Bug 6531908 -----------------------------------
2464: ERROR_HANDLER.Add_Error_Message(
2465: p_message_name => l_error_message_name
2466: ,p_application_id => 'EGO'
2467: ,p_token_tbl => l_token_table
2468: ,p_message_type => FND_API.G_RET_STS_ERROR
2469: ,p_entity_id => p_entity_id
2470: ,p_entity_index => p_entity_index
2471: ,p_entity_code => p_entity_code
2472: );
2470: ,p_entity_index => p_entity_index
2471: ,p_entity_code => p_entity_code
2472: );
2473:
2474: RAISE FND_API.G_EXC_ERROR;
2475:
2476: END;
2477: END IF;
2478:
2497: ,p_entity_id IN NUMBER DEFAULT NULL
2498: ,p_entity_index IN NUMBER DEFAULT NULL
2499: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2500: ,p_debug_level IN NUMBER DEFAULT 0
2501: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2502: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2498: ,p_entity_index IN NUMBER DEFAULT NULL
2499: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2500: ,p_debug_level IN NUMBER DEFAULT 0
2501: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2502: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2506: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2499: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2500: ,p_debug_level IN NUMBER DEFAULT 0
2501: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2502: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2506: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2507: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2500: ,p_debug_level IN NUMBER DEFAULT 0
2501: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2502: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2506: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2507: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2508: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2501: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2502: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2506: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2507: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2508: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2509: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2502: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2506: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2507: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2508: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2509: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2510: ,x_return_status OUT NOCOPY VARCHAR2
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2506: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2507: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2508: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2509: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2510: ,x_return_status OUT NOCOPY VARCHAR2
2511: ,x_errorcode OUT NOCOPY NUMBER
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2506: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2507: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2508: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2509: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2510: ,x_return_status OUT NOCOPY VARCHAR2
2511: ,x_errorcode OUT NOCOPY NUMBER
2512: ,x_msg_count OUT NOCOPY NUMBER
2560: ----------------------------------------------------
2561: l_token_table(1).TOKEN_NAME := 'ITEM_ID';
2562: l_token_table(1).TOKEN_VALUE := p_inventory_item_id;
2563:
2564: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2565: ERROR_HANDLER.Add_Error_Message(
2566: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2567: ,p_application_id => 'EGO'
2568: ,p_token_tbl => l_token_table
2565: ERROR_HANDLER.Add_Error_Message(
2566: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2567: ,p_application_id => 'EGO'
2568: ,p_token_tbl => l_token_table
2569: ,p_message_type => FND_API.G_RET_STS_ERROR
2570: ,p_entity_id => p_entity_id
2571: ,p_entity_index => p_entity_index
2572: ,p_entity_code => p_entity_code
2573: ,p_addto_fnd_stack => 'Y'
2576: ERROR_HANDLER.Add_Error_Message(
2577: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2578: ,p_application_id => 'EGO'
2579: ,p_token_tbl => l_token_table
2580: ,p_message_type => FND_API.G_RET_STS_ERROR
2581: ,p_entity_id => p_entity_id
2582: ,p_entity_index => p_entity_index
2583: ,p_entity_code => p_entity_code
2584: );
2583: ,p_entity_code => p_entity_code
2584: );
2585: END IF;
2586:
2587: RAISE FND_API.G_EXC_ERROR;
2588:
2589: END;
2590:
2591: Get_Related_Class_Codes(
2618: ---------------------------------------------------------------
2619: -- we are calling the API to check and error out if an attribute
2620: --update needs to have a change order or update is not allowed.
2621: ---------------------------------------------------------------
2622: IF (p_do_policy_check = FND_API.G_TRUE ) THEN
2623: l_attributes_row_table:=
2624: Remove_Rows_After_Policy_Check(
2625: p_inventory_item_id => p_inventory_item_id
2626: ,p_organization_id => p_organization_id
2632: ELSE
2633: l_attributes_row_table:=p_attributes_row_table;
2634: END IF;
2635: --writing the errors to the log
2636: IF (l_return_status=FND_API.G_RET_STS_ERROR) THEN
2637: ERROR_HANDLER.Log_Error(
2638: p_write_err_to_inttable => 'Y'
2639: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2640: );
2673: ,x_msg_data => x_msg_data
2674: );
2675:
2676: EXCEPTION
2677: WHEN FND_API.G_EXC_ERROR THEN
2678:
2679: x_return_status := FND_API.G_RET_STS_ERROR;
2680:
2681: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2675:
2676: EXCEPTION
2677: WHEN FND_API.G_EXC_ERROR THEN
2678:
2679: x_return_status := FND_API.G_RET_STS_ERROR;
2680:
2681: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2682:
2683: IF (x_msg_count > 0) THEN
2680:
2681: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2682:
2683: IF (x_msg_count > 0) THEN
2684: IF (FND_API.To_Boolean(p_log_errors)) THEN
2685: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2686: ERROR_HANDLER.Log_Error(
2687: p_write_err_to_inttable => 'Y'
2688: ,p_write_err_to_conclog => 'Y'
2681: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2682:
2683: IF (x_msg_count > 0) THEN
2684: IF (FND_API.To_Boolean(p_log_errors)) THEN
2685: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2686: ERROR_HANDLER.Log_Error(
2687: p_write_err_to_inttable => 'Y'
2688: ,p_write_err_to_conclog => 'Y'
2689: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2709: END IF;
2710:
2711: WHEN OTHERS THEN
2712:
2713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2714:
2715: DECLARE
2716: l_dummy_entity_index NUMBER;
2717: l_dummy_entity_id VARCHAR2(60);
2723: l_token_table(2).TOKEN_VALUE := l_api_name;
2724: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
2725: l_token_table(3).TOKEN_VALUE := SQLERRM;
2726:
2727: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2728: ERROR_HANDLER.Add_Error_Message(
2729: p_message_name => 'EGO_PLSQL_ERR'
2730: ,p_application_id => 'EGO'
2731: ,p_token_tbl => l_token_table
2728: ERROR_HANDLER.Add_Error_Message(
2729: p_message_name => 'EGO_PLSQL_ERR'
2730: ,p_application_id => 'EGO'
2731: ,p_token_tbl => l_token_table
2732: ,p_message_type => FND_API.G_RET_STS_ERROR
2733: ,p_addto_fnd_stack => 'Y'
2734: );
2735: ELSE
2736: ERROR_HANDLER.Add_Error_Message(
2736: ERROR_HANDLER.Add_Error_Message(
2737: p_message_name => 'EGO_PLSQL_ERR'
2738: ,p_application_id => 'EGO'
2739: ,p_token_tbl => l_token_table
2740: ,p_message_type => FND_API.G_RET_STS_ERROR
2741: );
2742: END IF;
2743:
2744: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
2765: ,p_entity_id IN NUMBER DEFAULT NULL
2766: ,p_entity_index IN NUMBER DEFAULT NULL
2767: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2768: ,p_debug_level IN NUMBER DEFAULT 0
2769: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2770: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2771: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2772: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2773: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2766: ,p_entity_index IN NUMBER DEFAULT NULL
2767: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2768: ,p_debug_level IN NUMBER DEFAULT 0
2769: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2770: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2771: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2772: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2773: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2774: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2767: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2768: ,p_debug_level IN NUMBER DEFAULT 0
2769: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2770: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2771: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2772: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2773: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2774: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2775: ,x_return_status OUT NOCOPY VARCHAR2
2768: ,p_debug_level IN NUMBER DEFAULT 0
2769: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2770: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2771: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2772: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2773: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2774: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2775: ,x_return_status OUT NOCOPY VARCHAR2
2776: ,x_errorcode OUT NOCOPY NUMBER
2833: );
2834:
2835:
2836: EXCEPTION
2837: WHEN FND_API.G_EXC_ERROR THEN
2838:
2839: x_return_status := FND_API.G_RET_STS_ERROR;
2840:
2841: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2835:
2836: EXCEPTION
2837: WHEN FND_API.G_EXC_ERROR THEN
2838:
2839: x_return_status := FND_API.G_RET_STS_ERROR;
2840:
2841: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2842:
2843: IF (x_msg_count > 0) THEN
2859: END IF;
2860:
2861: WHEN OTHERS THEN
2862:
2863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2864:
2865: DECLARE
2866: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2867: l_dummy_entity_index NUMBER;
2874: l_token_table(2).TOKEN_VALUE := l_api_name;
2875: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
2876: l_token_table(3).TOKEN_VALUE := SQLERRM;
2877:
2878: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2879: ERROR_HANDLER.Add_Error_Message(
2880: p_message_name => 'EGO_PLSQL_ERR'
2881: ,p_application_id => 'EGO'
2882: ,p_token_tbl => l_token_table
2879: ERROR_HANDLER.Add_Error_Message(
2880: p_message_name => 'EGO_PLSQL_ERR'
2881: ,p_application_id => 'EGO'
2882: ,p_token_tbl => l_token_table
2883: ,p_message_type => FND_API.G_RET_STS_ERROR
2884: ,p_addto_fnd_stack => 'Y'
2885: );
2886: ELSE
2887: ERROR_HANDLER.Add_Error_Message(
2887: ERROR_HANDLER.Add_Error_Message(
2888: p_message_name => 'EGO_PLSQL_ERR'
2889: ,p_application_id => 'EGO'
2890: ,p_token_tbl => l_token_table
2891: ,p_message_type => FND_API.G_RET_STS_ERROR
2892: );
2893: END IF;
2894:
2895: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
3046: --
3047: -- user is not registered properly
3048: --
3049: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
3050: IF FND_API.To_Boolean(p_set_message) THEN
3051: fnd_msg_pub.Add;
3052: END IF;
3053: RETURN FALSE;
3054: ELSE
3083: OPEN c_priv_cursor FOR l_select_sql USING p_inventory_item_id,p_organization_id;
3084: FETCH c_priv_cursor INTO l_dummy_number;
3085: IF c_priv_cursor%NOTFOUND THEN
3086: CLOSE c_priv_cursor;
3087: IF FND_API.To_Boolean(p_set_message) THEN
3088: code_debug (' user does not have privilege '||p_function_name ||' on item '||p_inventory_item_id);
3089: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3090: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_CANNOT_GRANT');
3091: -- EGO_IPI_CANNOT_GRANT : User "USER" does not have privilege to give grants on Item "ITEM" in Organization "ORGANIZATION".
3204:
3205: -- user must not be able to delete his own grants
3206: l_api_name := 'Process_item_role';
3207: l_api_version := 1.0;
3208: x_return_status := FND_API.G_RET_STS_SUCCESS;
3209: l_user_id := FND_GLOBAL.User_Id;
3210: code_debug(l_api_name ||' started with params - grant guid '||RAWTOHEX(x_grant_guid));
3211: code_debug(' p_api_version '|| p_api_version||' p_commit '||p_commit||' p_init_msg_list '||p_init_msg_list );
3212: code_debug(' p_transaction_type '||p_transaction_type ||' p_inventory_item_id '||p_inventory_item_id||' p_item_number '||p_item_number );
3214: code_debug(' p_role_name '||p_role_name ||' p_instance_type '||p_instance_type||' p_instance_set_id '||p_instance_set_id );
3215: code_debug(' p_instance_set_name '||p_instance_set_name ||' p_party_type '||p_party_type||' p_party_id '||p_party_id );
3216: code_debug(' p_party_name'||p_party_name ||' p_start_date'||p_start_date||' p_end_date'||p_end_date );
3217:
3218: IF FND_API.To_Boolean( p_commit ) THEN
3219: SAVEPOINT PROCESS_ITEM_ROLE_SP;
3220: END IF;
3221: --
3222: -- Initialize message list
3220: END IF;
3221: --
3222: -- Initialize message list
3223: --
3224: IF FND_API.To_Boolean(p_init_msg_list) THEN
3225: FND_MSG_PUB.Initialize;
3226: END IF;
3227: code_debug(l_api_name||' msg pub initialized ' );
3228: --
3227: code_debug(l_api_name||' msg pub initialized ' );
3228: --
3229: --Standard checks
3230: --
3231: IF NOT FND_API.Compatible_API_Call (l_api_version
3232: ,p_api_version
3233: ,l_api_name
3234: ,g_pkg_name)THEN
3235: code_debug (l_api_version ||' invalid api version ');
3232: ,p_api_version
3233: ,l_api_name
3234: ,g_pkg_name)THEN
3235: code_debug (l_api_version ||' invalid api version ');
3236: RAISE FND_API.G_EXC_ERROR;
3237: END IF;
3238: code_debug(l_api_name||' valid api ' );
3239: --
3240: -- invalid params passed
3310: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3311: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3312: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3313: fnd_msg_pub.Add;
3314: RAISE FND_API.G_EXC_ERROR;
3315: END IF;
3316: code_debug(l_api_name||' valid params passed ' );
3317: l_sysdate := SYSDATE;
3318: l_start_date := NVL(p_start_date, l_sysdate);
3345: ELSE
3346: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3347: END IF;
3348: fnd_msg_pub.Add;
3349: RAISE FND_API.G_EXC_ERROR;
3350: END;
3351: --
3352: -- no security check done for the update of grants of type instance set.
3353: -- should this be done??
3368: ,p_party_id => l_party_id
3369: ,p_set_message => G_TRUE
3370: ) THEN
3371: code_debug(l_api_name ||' user does not have privilege to update the roles on item');
3372: RAISE FND_API.G_EXC_ERROR;
3373: END IF;
3374: code_debug(l_api_name ||' user has privilege to update the roles on item');
3375: ELSE
3376: IF NOT validate_function_security(p_function_name => G_FN_NAME_ADMIN
3375: ELSE
3376: IF NOT validate_function_security(p_function_name => G_FN_NAME_ADMIN
3377: ,p_set_message => G_TRUE) THEN
3378: code_debug(l_api_name ||' user does not have function privilege to update roles in instance set');
3379: RAISE FND_API.G_EXC_ERROR;
3380: END IF;
3381: code_debug(l_api_name ||' user has function privilege to update the roles in instance set');
3382: END IF;
3383:
3396: IF x_return_status <> G_TRUE THEN
3397: --
3398: -- should never occur as the grant is already valid
3399: --
3400: RAISE FND_API.G_EXC_ERROR;
3401: ELSE
3402: x_return_status := FND_API.G_RET_STS_SUCCESS;
3403: IF FND_API.To_Boolean( p_commit ) THEN
3404: COMMIT WORK;
3398: -- should never occur as the grant is already valid
3399: --
3400: RAISE FND_API.G_EXC_ERROR;
3401: ELSE
3402: x_return_status := FND_API.G_RET_STS_SUCCESS;
3403: IF FND_API.To_Boolean( p_commit ) THEN
3404: COMMIT WORK;
3405: END IF;
3406: RETURN;
3399: --
3400: RAISE FND_API.G_EXC_ERROR;
3401: ELSE
3402: x_return_status := FND_API.G_RET_STS_SUCCESS;
3403: IF FND_API.To_Boolean( p_commit ) THEN
3404: COMMIT WORK;
3405: END IF;
3406: RETURN;
3407: END IF;
3415: ) THEN
3416: code_debug (l_api_version ||' grant is already end dated ');
3417: fnd_message.Set_Name(G_APP_NAME, 'EGO_GRANT_END_DATED');
3418: fnd_msg_pub.Add;
3419: RAISE FND_API.G_EXC_ERROR;
3420: END IF;
3421: IF date_check (p_start_date => l_sysdate
3422: ,p_end_date => p_end_date
3423: ,p_validation_type => G_GT_VAL
3424: ) THEN
3425: code_debug (l_api_version ||' end date less than sysdate ');
3426: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');
3427: fnd_msg_pub.Add;
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430: IF (p_start_date > l_sysdate and l_start_date > l_sysdate) THEN
3431: l_start_date := NVL(p_start_date,l_start_date);
3432: END IF;
3444: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3445: fnd_message.Set_Token('START_DATE', l_start_date);
3446: fnd_message.Set_Token('END_DATE', p_end_date);
3447: fnd_msg_pub.Add;
3448: RAISE FND_API.G_EXC_ERROR;
3449: ELSE
3450: x_return_status := FND_API.G_RET_STS_SUCCESS;
3451: IF FND_API.To_Boolean( p_commit ) THEN
3452: COMMIT WORK;
3446: fnd_message.Set_Token('END_DATE', p_end_date);
3447: fnd_msg_pub.Add;
3448: RAISE FND_API.G_EXC_ERROR;
3449: ELSE
3450: x_return_status := FND_API.G_RET_STS_SUCCESS;
3451: IF FND_API.To_Boolean( p_commit ) THEN
3452: COMMIT WORK;
3453: END IF;
3454: RETURN;
3447: fnd_msg_pub.Add;
3448: RAISE FND_API.G_EXC_ERROR;
3449: ELSE
3450: x_return_status := FND_API.G_RET_STS_SUCCESS;
3451: IF FND_API.To_Boolean( p_commit ) THEN
3452: COMMIT WORK;
3453: END IF;
3454: RETURN;
3455: END IF;
3641: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3642: fnd_message.Set_Token('START_DATE', l_start_date);
3643: fnd_message.Set_Token('END_DATE', p_end_date);
3644: fnd_msg_pub.Add;
3645: RAISE FND_API.G_EXC_ERROR;
3646: ELSE
3647: -- changing return status to FND_API.G_RET_STS_SUCCESS
3648: -- as per standards
3649: x_return_status := FND_API.G_RET_STS_SUCCESS;
3643: fnd_message.Set_Token('END_DATE', p_end_date);
3644: fnd_msg_pub.Add;
3645: RAISE FND_API.G_EXC_ERROR;
3646: ELSE
3647: -- changing return status to FND_API.G_RET_STS_SUCCESS
3648: -- as per standards
3649: x_return_status := FND_API.G_RET_STS_SUCCESS;
3650: END IF;
3651: ELSE
3645: RAISE FND_API.G_EXC_ERROR;
3646: ELSE
3647: -- changing return status to FND_API.G_RET_STS_SUCCESS
3648: -- as per standards
3649: x_return_status := FND_API.G_RET_STS_SUCCESS;
3650: END IF;
3651: ELSE
3652: code_debug(l_api_name||' raising errors ');
3653: RAISE FND_API.G_EXC_ERROR;
3649: x_return_status := FND_API.G_RET_STS_SUCCESS;
3650: END IF;
3651: ELSE
3652: code_debug(l_api_name||' raising errors ');
3653: RAISE FND_API.G_EXC_ERROR;
3654: END IF;
3655: END IF;
3656:
3657: -- commit data
3654: END IF;
3655: END IF;
3656:
3657: -- commit data
3658: IF FND_API.To_Boolean( p_commit ) THEN
3659: COMMIT WORK;
3660: END IF;
3661:
3662: EXCEPTION
3659: COMMIT WORK;
3660: END IF;
3661:
3662: EXCEPTION
3663: WHEN FND_API.G_EXC_ERROR THEN
3664: code_debug(l_api_name||' returning expected error ');
3665: IF FND_API.To_Boolean( p_commit ) THEN
3666: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3667: END IF;
3661:
3662: EXCEPTION
3663: WHEN FND_API.G_EXC_ERROR THEN
3664: code_debug(l_api_name||' returning expected error ');
3665: IF FND_API.To_Boolean( p_commit ) THEN
3666: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3667: END IF;
3668: x_return_status := FND_API.G_RET_STS_ERROR;
3669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3664: code_debug(l_api_name||' returning expected error ');
3665: IF FND_API.To_Boolean( p_commit ) THEN
3666: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3667: END IF;
3668: x_return_status := FND_API.G_RET_STS_ERROR;
3669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3670: ,p_count => x_msg_count
3671: ,p_data => x_msg_data);
3672: WHEN OTHERS THEN
3665: IF FND_API.To_Boolean( p_commit ) THEN
3666: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3667: END IF;
3668: x_return_status := FND_API.G_RET_STS_ERROR;
3669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3670: ,p_count => x_msg_count
3671: ,p_data => x_msg_data);
3672: WHEN OTHERS THEN
3673: IF FND_API.To_Boolean( p_commit ) THEN
3669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3670: ,p_count => x_msg_count
3671: ,p_data => x_msg_data);
3672: WHEN OTHERS THEN
3673: IF FND_API.To_Boolean( p_commit ) THEN
3674: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3675: END IF;
3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3672: WHEN OTHERS THEN
3673: IF FND_API.To_Boolean( p_commit ) THEN
3674: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3675: END IF;
3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3678: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3679: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3680: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3678: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3679: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3680: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3681: FND_MSG_PUB.Add;
3682: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3683: ,p_count => x_msg_count
3684: ,p_data => x_msg_data);
3685: code_debug(' EXCEPTION in '||l_api_name||' : ' ||x_msg_data );
3686: END Process_item_role;
3802:
3803: BEGIN
3804: l_api_name := 'Process_item_phase_and_status';
3805: l_api_version := 1.0;
3806: x_return_status := FND_API.G_RET_STS_SUCCESS;
3807: l_user_id := FND_GLOBAL.User_Id;
3808: l_policy_co_required := 'CHANGE_ORDER_REQUIRED';
3809: l_policy_not_allowed := 'NOT_ALLOWED';
3810: code_debug(l_api_name ||' started with params -- effective date '|| p_effective_date);
3812: code_debug(' p_transaction_type '||p_transaction_type ||' p_inventory_item_id '||p_inventory_item_id||' p_item_number '||p_item_number );
3813: code_debug(' p_organization_id '||p_organization_id ||' p_organization_code '||p_organization_code||' p_revision_id '||p_revision_id );
3814: code_debug(' p_revision '||p_revision ||' p_implement_changes '||p_implement_changes||' p_status '||p_status );
3815:
3816: IF FND_API.To_Boolean( p_commit ) THEN
3817: SAVEPOINT PROCESS_ITEM_PHASE_SP;
3818: END IF;
3819: --
3820: -- Initialize message list
3818: END IF;
3819: --
3820: -- Initialize message list
3821: --
3822: IF FND_API.To_Boolean(p_init_msg_list) THEN
3823: FND_MSG_PUB.Initialize;
3824: END IF;
3825: code_debug(l_api_name||' msg pub initialized ' );
3826: --
3825: code_debug(l_api_name||' msg pub initialized ' );
3826: --
3827: --Standard checks
3828: --
3829: IF NOT FND_API.Compatible_API_Call (l_api_version
3830: ,p_api_version
3831: ,l_api_name
3832: ,g_pkg_name) THEN
3833: code_debug (l_api_version ||' invalid api version ');
3830: ,p_api_version
3831: ,l_api_name
3832: ,g_pkg_name) THEN
3833: code_debug (l_api_version ||' invalid api version ');
3834: RAISE FND_API.G_EXC_ERROR;
3835: END IF;
3836: --
3837: -- check for invalid params
3838: --
3864: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3865: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3866: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3867: FND_MSG_PUB.Add;
3868: RAISE FND_API.G_EXC_ERROR;
3869: END IF;
3870: l_change_status_flag := TRUE;
3871: l_organization_id := p_organization_id;
3872: l_inventory_item_id := p_inventory_item_id;
4008: --
4009: -- logical set of errors completed
4010: -- further validations assume that there are no errors
4011: --
4012: RAISE FND_API.G_EXC_ERROR;
4013: END IF;
4014:
4015: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN
4016: --
4200: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change ');
4201: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN
4202: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4203: (p_api_version => p_api_version
4204: ,p_commit => FND_API.G_FALSE
4205: ,p_inventory_item_id => l_inventory_item_id
4206: ,p_item_number => l_item_number
4207: ,p_organization_id => l_organization_id
4208: ,p_effective_date => l_effective_date
4212: ,p_phase_id => l_future_phase_id
4213: ,p_status_code => p_status
4214: ,p_change_id => NULL
4215: ,p_change_line_id => NULL
4216: ,p_perform_security_check => FND_API.G_FALSE
4217: ,x_return_status => x_return_status
4218: ,x_errorcode => l_dummy_char
4219: ,x_msg_count => x_msg_count
4220: ,x_msg_data => x_msg_data
4221: );
4222: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
4223: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4224: (p_api_version => p_api_version
4225: ,p_commit => FND_API.G_FALSE
4226: ,p_inventory_item_id => l_inventory_item_id
4227: ,p_item_number => l_item_number
4228: ,p_organization_id => l_organization_id
4229: ,p_effective_date => l_effective_date
4233: ,p_phase_id => NULL
4234: ,p_status_code => p_status
4235: ,p_change_id => NULL
4236: ,p_change_line_id => NULL
4237: ,p_perform_security_check => FND_API.G_FALSE
4238: ,x_return_status => x_return_status
4239: ,x_errorcode => l_dummy_char
4240: ,x_msg_count => x_msg_count
4241: ,x_msg_data => x_msg_data
4242: );
4243: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4244: EGO_ITEM_LC_IMP_PC_PUB.Modify_Pending_Phase_Change
4245: (p_api_version => p_api_version
4246: ,p_commit => FND_API.G_FALSE
4247: ,p_transaction_type => p_transaction_type
4248: ,p_inventory_item_id => l_inventory_item_id
4249: ,p_organization_id => l_organization_id
4250: ,p_revision_id => l_revision_id
4254: ,p_change_id => NULL
4255: ,p_change_line_id => NULL
4256: ,p_effective_date => p_effective_date
4257: ,p_new_effective_date => l_effective_date
4258: ,p_perform_security_check => FND_API.G_FALSE
4259: ,x_return_status => x_return_status
4260: ,x_errorcode => l_dummy_char
4261: ,x_msg_count => x_msg_count
4262: ,x_msg_data => x_msg_data
4263: );
4264: END IF;
4265:
4266: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.create_pending_phase_change '||x_return_status);
4267: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4268: code_debug (l_api_name ||' cannot create/modify/delete pending phase change '||x_msg_data);
4269: --
4270: -- this will occur only in case of exception
4271: -- all valid values are passed.
4274: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4275: fnd_message.set_token('MESSAGE', x_msg_data);
4276: fnd_msg_pub.Add;
4277: END IF;
4278: RAISE FND_API.G_EXC_ERROR;
4279: ELSIF FND_API.To_Boolean(p_implement_changes) THEN
4280: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4281: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4282: l_revision_master_controlled := FND_API.g_false;
4275: fnd_message.set_token('MESSAGE', x_msg_data);
4276: fnd_msg_pub.Add;
4277: END IF;
4278: RAISE FND_API.G_EXC_ERROR;
4279: ELSIF FND_API.To_Boolean(p_implement_changes) THEN
4280: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4281: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4282: l_revision_master_controlled := FND_API.g_false;
4283: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
4278: RAISE FND_API.G_EXC_ERROR;
4279: ELSIF FND_API.To_Boolean(p_implement_changes) THEN
4280: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4281: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4282: l_revision_master_controlled := FND_API.g_false;
4283: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
4284: EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes
4285: (p_api_version => p_api_version
4286: ,p_inventory_item_id => l_inventory_item_id
4288: ,p_revision_id => l_revision_id
4289: ,p_revision_master_controlled => l_revision_master_controlled
4290: ,p_status_master_controlled => l_status_master_controlled
4291: ,p_is_master_org => l_is_master_org
4292: ,p_perform_security_check => FND_API.G_FALSE
4293: ,x_return_status => x_return_status
4294: ,x_errorcode => l_dummy_char
4295: ,x_msg_count => x_msg_count
4296: ,x_msg_data => x_msg_data
4295: ,x_msg_count => x_msg_count
4296: ,x_msg_data => x_msg_data
4297: );
4298: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
4299: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4300: code_debug (l_api_name ||' cannot implement changes '||x_msg_data);
4301: IF x_msg_count = 1 THEN
4302: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4303: fnd_message.set_token('MESSAGE', x_msg_data);
4302: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4303: fnd_message.set_token('MESSAGE', x_msg_data);
4304: fnd_msg_pub.Add;
4305: END IF;
4306: RAISE FND_API.G_EXC_ERROR;
4307: END IF;
4308: END IF;
4309: ELSE
4310: code_debug (l_api_name ||' flashing all errors ');
4307: END IF;
4308: END IF;
4309: ELSE
4310: code_debug (l_api_name ||' flashing all errors ');
4311: RAISE FND_API.G_EXC_ERROR;
4312: END IF;
4313: --
4314: -- commit data
4315: --
4312: END IF;
4313: --
4314: -- commit data
4315: --
4316: IF FND_API.To_Boolean( p_commit ) THEN
4317: COMMIT WORK;
4318: END IF;
4319: x_return_status := FND_API.G_RET_STS_SUCCESS;
4320: EXCEPTION
4315: --
4316: IF FND_API.To_Boolean( p_commit ) THEN
4317: COMMIT WORK;
4318: END IF;
4319: x_return_status := FND_API.G_RET_STS_SUCCESS;
4320: EXCEPTION
4321: WHEN FND_API.G_EXC_ERROR THEN
4322: IF FND_API.To_Boolean( p_commit ) THEN
4323: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4317: COMMIT WORK;
4318: END IF;
4319: x_return_status := FND_API.G_RET_STS_SUCCESS;
4320: EXCEPTION
4321: WHEN FND_API.G_EXC_ERROR THEN
4322: IF FND_API.To_Boolean( p_commit ) THEN
4323: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4324: END IF;
4325: x_return_status := FND_API.G_RET_STS_ERROR;
4318: END IF;
4319: x_return_status := FND_API.G_RET_STS_SUCCESS;
4320: EXCEPTION
4321: WHEN FND_API.G_EXC_ERROR THEN
4322: IF FND_API.To_Boolean( p_commit ) THEN
4323: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4324: END IF;
4325: x_return_status := FND_API.G_RET_STS_ERROR;
4326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4321: WHEN FND_API.G_EXC_ERROR THEN
4322: IF FND_API.To_Boolean( p_commit ) THEN
4323: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4324: END IF;
4325: x_return_status := FND_API.G_RET_STS_ERROR;
4326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4327: ,p_count => x_msg_count
4328: ,p_data => x_msg_data);
4329: WHEN OTHERS THEN
4322: IF FND_API.To_Boolean( p_commit ) THEN
4323: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4324: END IF;
4325: x_return_status := FND_API.G_RET_STS_ERROR;
4326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4327: ,p_count => x_msg_count
4328: ,p_data => x_msg_data);
4329: WHEN OTHERS THEN
4330: IF FND_API.To_Boolean( p_commit ) THEN
4326: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4327: ,p_count => x_msg_count
4328: ,p_data => x_msg_data);
4329: WHEN OTHERS THEN
4330: IF FND_API.To_Boolean( p_commit ) THEN
4331: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4332: END IF;
4333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4334: IF c_get_item_det%ISOPEN THEN
4329: WHEN OTHERS THEN
4330: IF FND_API.To_Boolean( p_commit ) THEN
4331: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4332: END IF;
4333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4334: IF c_get_item_det%ISOPEN THEN
4335: CLOSE c_get_item_det;
4336: END IF;
4337: IF c_get_item_rev_det%ISOPEN THEN
4350: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4351: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4352: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4353: FND_MSG_PUB.Add;
4354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4355: ,p_count => x_msg_count
4356: ,p_data => x_msg_data);
4357: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
4358: END Process_item_phase_and_status;
4400: code_debug(l_api_name ||' started with params ');
4401: code_debug(' p_api_version '|| p_api_version||' p_commit '||p_commit||' p_init_msg_list '||p_init_msg_list );
4402: code_debug(' p_inventory_item_id '||p_inventory_item_id||' p_item_number '||p_item_number||' p_revision '||p_revision );
4403: code_debug(' p_organization_id '||p_organization_id ||' p_organization_code '||p_organization_code||' p_revision_id '||p_revision_id );
4404: IF FND_API.To_Boolean( p_commit ) THEN
4405: SAVEPOINT IMPLEMENT_CHANGES_SP;
4406: END IF;
4407: --
4408: -- Initialize message list
4406: END IF;
4407: --
4408: -- Initialize message list
4409: --
4410: IF FND_API.To_Boolean(p_init_msg_list) THEN
4411: FND_MSG_PUB.Initialize;
4412: END IF;
4413: code_debug(l_api_name||' msg pub initialized ' );
4414: --
4413: code_debug(l_api_name||' msg pub initialized ' );
4414: --
4415: --Standard checks
4416: --
4417: IF NOT FND_API.Compatible_API_Call (l_api_version
4418: ,p_api_version
4419: ,l_api_name
4420: ,g_pkg_name) THEN
4421: code_debug (l_api_name ||' invalid api version ');
4418: ,p_api_version
4419: ,l_api_name
4420: ,g_pkg_name) THEN
4421: code_debug (l_api_name ||' invalid api version ');
4422: RAISE FND_API.G_EXC_ERROR;
4423: END IF;
4424: --
4425: -- check for mandatory params
4426: --
4435: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4436: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4437: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4438: FND_MSG_PUB.Add;
4439: RAISE FND_API.G_EXC_ERROR;
4440: END IF;
4441:
4442: --
4443: -- validate organization details
4496:
4497: IF l_implement_flag THEN
4498: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4499: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4500: l_revision_master_controlled := FND_API.g_false;
4501: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
4502: EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes
4503: (p_api_version => p_api_version
4504: ,p_inventory_item_id => l_inventory_item_id
4506: ,p_revision_id => l_revision_id
4507: ,p_revision_master_controlled => l_revision_master_controlled
4508: ,p_status_master_controlled => l_status_master_controlled
4509: ,p_is_master_org => l_is_master_org
4510: ,p_perform_security_check => FND_API.G_TRUE
4511: ,x_return_status => x_return_status
4512: ,x_errorcode => l_dummy_char
4513: ,x_msg_count => x_msg_count
4514: ,x_msg_data => x_msg_data
4513: ,x_msg_count => x_msg_count
4514: ,x_msg_data => x_msg_data
4515: );
4516: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
4517: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4518: IF x_msg_count = 1 THEN
4519: code_debug (l_api_name ||' cannot implement changes for '||x_msg_data);
4520: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4521: fnd_message.set_token('MESSAGE', x_msg_data);
4520: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4521: fnd_message.set_token('MESSAGE', x_msg_data);
4522: fnd_msg_pub.Add;
4523: END IF;
4524: RAISE FND_API.G_EXC_ERROR;
4525: END IF;
4526: ELSE
4527: code_debug (l_api_name ||' flashing all errors ');
4528: RAISE FND_API.G_EXC_ERROR;
4524: RAISE FND_API.G_EXC_ERROR;
4525: END IF;
4526: ELSE
4527: code_debug (l_api_name ||' flashing all errors ');
4528: RAISE FND_API.G_EXC_ERROR;
4529: END IF;
4530: --
4531: -- commit data
4532: --
4529: END IF;
4530: --
4531: -- commit data
4532: --
4533: IF FND_API.To_Boolean( p_commit ) THEN
4534: COMMIT WORK;
4535: END IF;
4536:
4537: EXCEPTION
4534: COMMIT WORK;
4535: END IF;
4536:
4537: EXCEPTION
4538: WHEN FND_API.G_EXC_ERROR THEN
4539: IF FND_API.To_Boolean( p_commit ) THEN
4540: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4541: END IF;
4542: x_return_status := FND_API.G_RET_STS_ERROR;
4535: END IF;
4536:
4537: EXCEPTION
4538: WHEN FND_API.G_EXC_ERROR THEN
4539: IF FND_API.To_Boolean( p_commit ) THEN
4540: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4541: END IF;
4542: x_return_status := FND_API.G_RET_STS_ERROR;
4543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4538: WHEN FND_API.G_EXC_ERROR THEN
4539: IF FND_API.To_Boolean( p_commit ) THEN
4540: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4541: END IF;
4542: x_return_status := FND_API.G_RET_STS_ERROR;
4543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4544: ,p_count => x_msg_count
4545: ,p_data => x_msg_data);
4546: WHEN OTHERS THEN
4539: IF FND_API.To_Boolean( p_commit ) THEN
4540: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4541: END IF;
4542: x_return_status := FND_API.G_RET_STS_ERROR;
4543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4544: ,p_count => x_msg_count
4545: ,p_data => x_msg_data);
4546: WHEN OTHERS THEN
4547: IF FND_API.To_Boolean( p_commit ) THEN
4543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4544: ,p_count => x_msg_count
4545: ,p_data => x_msg_data);
4546: WHEN OTHERS THEN
4547: IF FND_API.To_Boolean( p_commit ) THEN
4548: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4549: END IF;
4550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4546: WHEN OTHERS THEN
4547: IF FND_API.To_Boolean( p_commit ) THEN
4548: ROLLBACK TO IMPLEMENT_CHANGES_SP;
4549: END IF;
4550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4551: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
4552: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4553: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4554: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4552: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4553: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4554: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4555: FND_MSG_PUB.Add;
4556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4557: ,p_count => x_msg_count
4558: ,p_data => x_msg_data);
4559: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
4560: END Implement_Item_Pending_Changes;
4906: ,x_msg_data => x_msg_data
4907: );
4908:
4909: EXCEPTION
4910: WHEN FND_API.G_EXC_ERROR THEN
4911:
4912: x_return_status := FND_API.G_RET_STS_ERROR;
4913:
4914: x_msg_count := ERROR_HANDLER.Get_Message_Count();
4908:
4909: EXCEPTION
4910: WHEN FND_API.G_EXC_ERROR THEN
4911:
4912: x_return_status := FND_API.G_RET_STS_ERROR;
4913:
4914: x_msg_count := ERROR_HANDLER.Get_Message_Count();
4915:
4916: IF (x_msg_count > 0) THEN
4932: END IF;
4933:
4934: WHEN OTHERS THEN
4935:
4936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4937:
4938: DECLARE
4939: l_token_table ERROR_HANDLER.Token_Tbl_Type;
4940: l_dummy_entity_index NUMBER;
4951: ERROR_HANDLER.Add_Error_Message(
4952: p_message_name => 'EGO_PLSQL_ERR'
4953: ,p_application_id => 'EGO'
4954: ,p_token_tbl => l_token_table
4955: ,p_message_type => FND_API.G_RET_STS_ERROR
4956: );
4957:
4958: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
4959: ,x_entity_index => l_dummy_entity_index
5300: EGO_EXT_FWK_PUB.Compile_Attr_Group_Views(
5301: ERRBUF => l_msg_data
5302: ,RETCODE => l_return_status
5303: ,p_attr_group_id_list => l_ag_id
5304: ,p_init_msg_list => fnd_api.g_FALSE
5305: ,p_commit => fnd_api.g_TRUE
5306: );
5307:
5308: END IF;
5301: ERRBUF => l_msg_data
5302: ,RETCODE => l_return_status
5303: ,p_attr_group_id_list => l_ag_id
5304: ,p_init_msg_list => fnd_api.g_FALSE
5305: ,p_commit => fnd_api.g_TRUE
5306: );
5307:
5308: END IF;
5309:
5347: EGO_EXT_FWK_PUB.Compile_Attr_Group_Views(
5348: ERRBUF => l_msg_data
5349: ,RETCODE => l_return_status
5350: ,p_attr_group_id_list => TO_CHAR(l_temp_num)
5351: ,p_init_msg_list => fnd_api.g_FALSE
5352: ,p_commit => fnd_api.g_TRUE
5353: );
5354: END IF;
5355:
5348: ERRBUF => l_msg_data
5349: ,RETCODE => l_return_status
5350: ,p_attr_group_id_list => TO_CHAR(l_temp_num)
5351: ,p_init_msg_list => fnd_api.g_FALSE
5352: ,p_commit => fnd_api.g_TRUE
5353: );
5354: END IF;
5355:
5356: IF (l_return_status <> 'S') THEN
5398: RAISE ERR_OCCURED;
5399: END IF;
5400:
5401: ERRBUF := '';
5402: RETCODE := FND_API.G_RET_STS_SUCCESS;
5403:
5404:
5405: EXCEPTION
5406: WHEN ERR_OCCURED THEN
5409: l_views_exist := 'Could not create the following views as already an object exists by this name - '||l_views_exist;
5410: END IF;
5411:
5412: ERRBUF := l_views_exist||' '||l_view_compile_errs;
5413: RETCODE := FND_API.G_RET_STS_ERROR;
5414:
5415: RAISE_APPLICATION_ERROR(-20000, l_views_exist||' '||l_view_compile_errs);
5416:
5417: END Generate_GDSN_Ext_AG_TP_Views;
5600:
5601:
5602: EXECUTE IMMEDIATE l_final_view_sql;
5603:
5604: x_return_status := FND_API.G_RET_STS_SUCCESS;
5605:
5606: EXCEPTION
5607: WHEN OTHERS THEN
5608:
5605:
5606: EXCEPTION
5607: WHEN OTHERS THEN
5608:
5609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5610: x_msg_data := SQLERRM;
5611:
5612: END GENERATE_GTIN_TP_ATTRS_VIEW;
5613:
5716: x_return_status := l_return_status ;
5717: END LOOP;
5718: EXCEPTION
5719: WHEN OTHERS THEN
5720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5721: x_msg_data := SQLERRM;
5722:
5723: END process_attribute_defaulting;
5724: