[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';
152: where organization_id = x_organization_id;
153: RETURN TRUE;
154: EXCEPTION
155: WHEN OTHERS THEN
156: IF FND_API.To_Boolean(p_set_message) THEN
157: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_ID');
158: l_dummy_char := fnd_message.get();
159: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
160: fnd_message.Set_Token('NAME', l_dummy_char);
171: where organization_code = p_organization_code;
172: RETURN TRUE;
173: EXCEPTION
174: WHEN OTHERS THEN
175: IF FND_API.To_Boolean(p_set_message) THEN
176: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION_CODE');
177: l_dummy_char := fnd_message.get();
178: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
179: fnd_message.Set_Token('NAME', l_dummy_char);
217: AND itm_num.organization_id = itm.organization_id;
218: RETURN TRUE;
219: EXCEPTION
220: WHEN OTHERS THEN
221: IF FND_API.To_Boolean(p_set_message) THEN
222: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_INV_ITEM_ID_ERR');
223: fnd_message.Set_Token('ITEM_ID', x_inventory_item_id);
224: fnd_msg_pub.Add;
225: END IF;
236: AND itm.organization_id = itm_num.organization_id;
237: RETURN TRUE;
238: EXCEPTION
239: WHEN OTHERS THEN
240: IF FND_API.To_Boolean(p_set_message) THEN
241: fnd_message.Set_Name(G_APP_NAME, 'EGO_EF_BL_ITEM_NUM_ERR');
242: fnd_message.Set_Token('ITEM_NUMBER', x_item_number);
243: fnd_msg_pub.Add;
244: END IF;
250: -- x_approval_status := NULL;
251: RETURN FALSE;
252: END IF;
253: ELSE
254: IF FND_API.To_Boolean(p_set_message) THEN
255: fnd_message.Set_Name(G_APP_NAME, 'EGO_ORGANIZATION');
256: l_dummy_char := fnd_message.get();
257: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');
258: fnd_message.Set_Token('NAME', l_dummy_char);
294: AND revision_id = x_revision_id;
295: RETURN TRUE;
296: EXCEPTION
297: WHEN OTHERS THEN
298: IF FND_API.To_Boolean(p_set_message) THEN
299: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISIONID_INVALID');
300: fnd_message.Set_Token('REVISION_ID', x_revision_id);
301: fnd_msg_pub.Add;
302: END IF;
312: AND revision = x_revision;
313: RETURN TRUE;
314: EXCEPTION
315: WHEN OTHERS THEN
316: IF FND_API.To_Boolean(p_set_message) THEN
317: fnd_message.Set_Name(G_APP_NAME, 'EGO_REVISION_INVALID');
318: fnd_message.Set_Token('REVISION', x_revision);
319: fnd_msg_pub.Add;
320: END IF;
547: RETURN TRUE;
548: IF fnd_function.test(p_function_name) THEN
549: RETURN TRUE;
550: ELSE
551: IF FND_API.To_Boolean(p_set_message) THEN
552: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
553: fnd_msg_pub.Add;
554: END IF;
555: RETURN FALSE;
767: ERROR_HANDLER.Add_Error_Message(
768: p_message_name => 'EGO_EF_BL_ITM_NOT_ALLOW_ERR'
769: ,p_application_id => 'EGO'
770: ,p_token_tbl => l_token_table
771: ,p_message_type => FND_API.G_RET_STS_ERROR
772: ,p_row_identifier => l_row_identifier
773: ,p_entity_id => p_entity_id
774: ,p_entity_index => p_entity_index
775: ,p_entity_code => p_entity_code
773: ,p_entity_id => p_entity_id
774: ,p_entity_index => p_entity_index
775: ,p_entity_code => p_entity_code
776: );
777: x_return_status:=FND_API.G_RET_STS_ERROR;
778: l_token_table.DELETE();
779: --Delete the row from the ROW_TABLE as it is an error case.
780: ELSIF (l_is_required='N') THEN
781: i:=i+1;
996: -- -----------------------------------------------------------------------------
997:
998: PROCEDURE Process_Items
999: (
1000: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
1001: , x_return_status OUT NOCOPY VARCHAR2
1002: , x_msg_count OUT NOCOPY NUMBER
1003: )
1004: IS
1103: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
1104: ----------------------------------------------------------------
1105: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1106: l_cat_tab_index NUMBER := G_MISS_NUM ;
1107: l_cat_match VARCHAR2(1) DEFAULT FND_API.G_FALSE ;
1108: --Bug: 4881908
1109: l_process_control VARCHAR2(2000) := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
1110: ---------------------------------------------------------------------------
1111: TYPE CATEGORY_ASSIGN_REC IS RECORD (
1639:
1640: IF l_Process_Control = 'EGO_INTERFACE_HANDLER' THEN
1641: INV_ITEM_GRP.Interface_Handler
1642: (
1643: p_commit => FND_API.G_TRUE
1644: ,p_transaction_type => G_Item_Rec.Transaction_Type
1645: ,p_Item_rec => l_Item_rec_in
1646: ,P_revision_rec => l_revision_rec
1647: ,p_Template_Id => l_template_id
1849: -------------------------------------------------------------------------
1850: l_cat_tab_index := 1 ;
1851: 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)
1852: LOOP
1853: l_cat_match := FND_API.G_FALSE;
1854: l_cat_assign_rec_table_aft(l_cat_tab_index).CATEGORY_SET_ID := DEFAULT_CAT_ASSIGN_REC.CATEGORY_SET_ID;
1855: l_cat_assign_rec_table_aft(l_cat_tab_index).CATEGORY_ID := DEFAULT_CAT_ASSIGN_REC.CATEGORY_ID;
1856: l_cat_assign_rec_table_aft(l_cat_tab_index).INVENTORY_ITEM_ID := l_Item_rec_out.INVENTORY_ITEM_ID;
1857: l_cat_assign_rec_table_aft(l_cat_tab_index).ORGANIZATION_ID := l_Item_rec_out.ORGANIZATION_ID;
1858: IF l_cat_assign_rec_table_bef IS NOT NULL AND l_cat_assign_rec_table_bef.FIRST IS NOT NULL THEN
1859: FOR CAT_REC_BEF IN l_cat_assign_rec_table_bef.FIRST .. l_cat_assign_rec_table_bef.LAST
1860: LOOP
1861: 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
1862: l_cat_match := FND_API.G_TRUE;
1863: ELSE
1864: NULL;
1865: END IF;
1866: END LOOP;
1864: NULL;
1865: END IF;
1866: END LOOP;
1867: END IF;
1868: IF l_cat_match = FND_API.G_FALSE THEN
1869: EGO_WF_WRAPPER_PVT.Raise_Item_Event(
1870: p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT
1871: ,p_inventory_item_id => l_cat_assign_rec_table_aft(l_cat_tab_index).INVENTORY_ITEM_ID
1872: ,p_organization_id => l_cat_assign_rec_table_aft(l_cat_tab_index).ORGANIZATION_ID
2012: -- -----------------------------------------------------------------------------
2013:
2014: PROCEDURE Process_Item_Org_Assignments
2015: (
2016: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
2017: , x_return_status OUT NOCOPY VARCHAR2
2018: , x_msg_count OUT NOCOPY NUMBER
2019: )
2020: IS
2285: );
2286:
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2290: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
2291:
2292: END Seed_Item_Long_Desc_Attr_Group;
2293:
2411: AND MESSAGE_NAME = 'EGO_ITEM_LONG_DESCRIPTION'
2412: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
2413: AND M.APPLICATION_ID = 431;
2414:
2415: x_return_status := FND_API.G_RET_STS_SUCCESS;
2416:
2417: EXCEPTION
2418: WHEN OTHERS THEN
2419:
2416:
2417: EXCEPTION
2418: WHEN OTHERS THEN
2419:
2420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2421: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
2422:
2423: END Seed_Item_Long_Desc_In_Bulk;
2424:
2494: ERROR_HANDLER.Add_Error_Message(
2495: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'
2496: ,p_application_id => 'EGO'
2497: ,p_token_tbl => l_token_table
2498: ,p_message_type => FND_API.G_RET_STS_ERROR
2499: ,p_entity_id => p_entity_id
2500: ,p_entity_index => p_entity_index
2501: ,p_entity_code => p_entity_code
2502: );
2588:
2589: ERROR_HANDLER.Add_Error_Message(
2590: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
2591: ,p_application_id => 'EGO'
2592: ,p_message_type => FND_API.G_RET_STS_ERROR
2593: ,p_entity_id => p_entity_id
2594: ,p_entity_index => p_entity_index
2595: ,p_entity_code => p_entity_code
2596: );
2594: ,p_entity_index => p_entity_index
2595: ,p_entity_code => p_entity_code
2596: );
2597:
2598: RAISE FND_API.G_EXC_ERROR;
2599:
2600: END;
2601:
2602: ------------------- BEGIN Bug 6531908 -----------------------------------
2690: ERROR_HANDLER.Add_Error_Message(
2691: p_message_name => l_error_message_name
2692: ,p_application_id => 'EGO'
2693: ,p_token_tbl => l_token_table
2694: ,p_message_type => FND_API.G_RET_STS_ERROR
2695: ,p_entity_id => p_entity_id
2696: ,p_entity_index => p_entity_index
2697: ,p_entity_code => p_entity_code
2698: );
2696: ,p_entity_index => p_entity_index
2697: ,p_entity_code => p_entity_code
2698: );
2699:
2700: RAISE FND_API.G_EXC_ERROR;
2701:
2702: END;
2703: END IF;
2704:
2723: ,p_entity_id IN NUMBER DEFAULT NULL
2724: ,p_entity_index IN NUMBER DEFAULT NULL
2725: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2726: ,p_debug_level IN NUMBER DEFAULT 0
2727: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2728: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2724: ,p_entity_index IN NUMBER DEFAULT NULL
2725: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2726: ,p_debug_level IN NUMBER DEFAULT 0
2727: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2728: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2732: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2725: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2726: ,p_debug_level IN NUMBER DEFAULT 0
2727: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2728: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2732: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2733: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2726: ,p_debug_level IN NUMBER DEFAULT 0
2727: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2728: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2732: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2733: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2734: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2727: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2728: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2732: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2733: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2734: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2735: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2728: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2732: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2733: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2734: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2735: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2736: ,x_return_status OUT NOCOPY VARCHAR2
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2732: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2733: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2734: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2735: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2736: ,x_return_status OUT NOCOPY VARCHAR2
2737: ,x_errorcode OUT NOCOPY NUMBER
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2732: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2733: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
2734: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
2735: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2736: ,x_return_status OUT NOCOPY VARCHAR2
2737: ,x_errorcode OUT NOCOPY NUMBER
2738: ,x_msg_count OUT NOCOPY NUMBER
2786: ----------------------------------------------------
2787: l_token_table(1).TOKEN_NAME := 'ITEM_ID';
2788: l_token_table(1).TOKEN_VALUE := p_inventory_item_id;
2789:
2790: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2791: ERROR_HANDLER.Add_Error_Message(
2792: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2793: ,p_application_id => 'EGO'
2794: ,p_token_tbl => l_token_table
2791: ERROR_HANDLER.Add_Error_Message(
2792: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2793: ,p_application_id => 'EGO'
2794: ,p_token_tbl => l_token_table
2795: ,p_message_type => FND_API.G_RET_STS_ERROR
2796: ,p_entity_id => p_entity_id
2797: ,p_entity_index => p_entity_index
2798: ,p_entity_code => p_entity_code
2799: ,p_addto_fnd_stack => 'Y'
2802: ERROR_HANDLER.Add_Error_Message(
2803: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2804: ,p_application_id => 'EGO'
2805: ,p_token_tbl => l_token_table
2806: ,p_message_type => FND_API.G_RET_STS_ERROR
2807: ,p_entity_id => p_entity_id
2808: ,p_entity_index => p_entity_index
2809: ,p_entity_code => p_entity_code
2810: );
2809: ,p_entity_code => p_entity_code
2810: );
2811: END IF;
2812:
2813: RAISE FND_API.G_EXC_ERROR;
2814:
2815: END;
2816:
2817: Get_Related_Class_Codes(
2844: ---------------------------------------------------------------
2845: -- we are calling the API to check and error out if an attribute
2846: --update needs to have a change order or update is not allowed.
2847: ---------------------------------------------------------------
2848: IF (p_do_policy_check = FND_API.G_TRUE ) THEN
2849: l_attributes_row_table:=
2850: Remove_Rows_After_Policy_Check(
2851: p_inventory_item_id => p_inventory_item_id
2852: ,p_organization_id => p_organization_id
2858: ELSE
2859: l_attributes_row_table:=p_attributes_row_table;
2860: END IF;
2861: --writing the errors to the log
2862: IF (l_return_status=FND_API.G_RET_STS_ERROR) THEN
2863: ERROR_HANDLER.Log_Error(
2864: p_write_err_to_inttable => 'Y'
2865: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2866: );
2899: ,x_msg_data => x_msg_data
2900: );
2901:
2902: EXCEPTION
2903: WHEN FND_API.G_EXC_ERROR THEN
2904:
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906:
2907: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2901:
2902: EXCEPTION
2903: WHEN FND_API.G_EXC_ERROR THEN
2904:
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906:
2907: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2908:
2909: IF (x_msg_count > 0) THEN
2906:
2907: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2908:
2909: IF (x_msg_count > 0) THEN
2910: IF (FND_API.To_Boolean(p_log_errors)) THEN
2911: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2912: ERROR_HANDLER.Log_Error(
2913: p_write_err_to_inttable => 'Y'
2914: ,p_write_err_to_conclog => 'Y'
2907: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2908:
2909: IF (x_msg_count > 0) THEN
2910: IF (FND_API.To_Boolean(p_log_errors)) THEN
2911: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2912: ERROR_HANDLER.Log_Error(
2913: p_write_err_to_inttable => 'Y'
2914: ,p_write_err_to_conclog => 'Y'
2915: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2935: END IF;
2936:
2937: WHEN OTHERS THEN
2938:
2939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2940:
2941: DECLARE
2942: l_dummy_entity_index NUMBER;
2943: l_dummy_entity_id VARCHAR2(60);
2949: l_token_table(2).TOKEN_VALUE := l_api_name;
2950: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
2951: l_token_table(3).TOKEN_VALUE := SQLERRM;
2952:
2953: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2954: ERROR_HANDLER.Add_Error_Message(
2955: p_message_name => 'EGO_PLSQL_ERR'
2956: ,p_application_id => 'EGO'
2957: ,p_token_tbl => l_token_table
2954: ERROR_HANDLER.Add_Error_Message(
2955: p_message_name => 'EGO_PLSQL_ERR'
2956: ,p_application_id => 'EGO'
2957: ,p_token_tbl => l_token_table
2958: ,p_message_type => FND_API.G_RET_STS_ERROR
2959: ,p_addto_fnd_stack => 'Y'
2960: );
2961: ELSE
2962: ERROR_HANDLER.Add_Error_Message(
2962: ERROR_HANDLER.Add_Error_Message(
2963: p_message_name => 'EGO_PLSQL_ERR'
2964: ,p_application_id => 'EGO'
2965: ,p_token_tbl => l_token_table
2966: ,p_message_type => FND_API.G_RET_STS_ERROR
2967: );
2968: END IF;
2969:
2970: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
2991: ,p_entity_id IN NUMBER DEFAULT NULL
2992: ,p_entity_index IN NUMBER DEFAULT NULL
2993: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2994: ,p_debug_level IN NUMBER DEFAULT 0
2995: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2996: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2997: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2998: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2999: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2992: ,p_entity_index IN NUMBER DEFAULT NULL
2993: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2994: ,p_debug_level IN NUMBER DEFAULT 0
2995: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2996: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2997: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2998: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2999: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
3000: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2993: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2994: ,p_debug_level IN NUMBER DEFAULT 0
2995: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2996: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2997: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2998: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2999: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
3000: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
3001: ,x_return_status OUT NOCOPY VARCHAR2
2994: ,p_debug_level IN NUMBER DEFAULT 0
2995: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2996: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2997: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2998: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2999: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
3000: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
3001: ,x_return_status OUT NOCOPY VARCHAR2
3002: ,x_errorcode OUT NOCOPY NUMBER
3059: );
3060:
3061:
3062: EXCEPTION
3063: WHEN FND_API.G_EXC_ERROR THEN
3064:
3065: x_return_status := FND_API.G_RET_STS_ERROR;
3066:
3067: x_msg_count := ERROR_HANDLER.Get_Message_Count();
3061:
3062: EXCEPTION
3063: WHEN FND_API.G_EXC_ERROR THEN
3064:
3065: x_return_status := FND_API.G_RET_STS_ERROR;
3066:
3067: x_msg_count := ERROR_HANDLER.Get_Message_Count();
3068:
3069: IF (x_msg_count > 0) THEN
3085: END IF;
3086:
3087: WHEN OTHERS THEN
3088:
3089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3090:
3091: DECLARE
3092: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3093: l_dummy_entity_index NUMBER;
3100: l_token_table(2).TOKEN_VALUE := l_api_name;
3101: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
3102: l_token_table(3).TOKEN_VALUE := SQLERRM;
3103:
3104: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
3105: ERROR_HANDLER.Add_Error_Message(
3106: p_message_name => 'EGO_PLSQL_ERR'
3107: ,p_application_id => 'EGO'
3108: ,p_token_tbl => l_token_table
3105: ERROR_HANDLER.Add_Error_Message(
3106: p_message_name => 'EGO_PLSQL_ERR'
3107: ,p_application_id => 'EGO'
3108: ,p_token_tbl => l_token_table
3109: ,p_message_type => FND_API.G_RET_STS_ERROR
3110: ,p_addto_fnd_stack => 'Y'
3111: );
3112: ELSE
3113: ERROR_HANDLER.Add_Error_Message(
3113: ERROR_HANDLER.Add_Error_Message(
3114: p_message_name => 'EGO_PLSQL_ERR'
3115: ,p_application_id => 'EGO'
3116: ,p_token_tbl => l_token_table
3117: ,p_message_type => FND_API.G_RET_STS_ERROR
3118: );
3119: END IF;
3120:
3121: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
3306: --
3307: -- user is not registered properly
3308: --
3309: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
3310: IF FND_API.To_Boolean(p_set_message) THEN
3311: fnd_msg_pub.Add;
3312: END IF;
3313: RETURN FALSE;
3314: ELSE
3343: OPEN c_priv_cursor FOR l_select_sql USING p_inventory_item_id,p_organization_id;
3344: FETCH c_priv_cursor INTO l_dummy_number;
3345: IF c_priv_cursor%NOTFOUND THEN
3346: CLOSE c_priv_cursor;
3347: IF FND_API.To_Boolean(p_set_message) THEN
3348: code_debug (' user does not have privilege '||p_function_name ||' on item '||p_inventory_item_id);
3349: IF p_function_name = G_FN_NAME_ADD_ROLE THEN
3350: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_CANNOT_GRANT');
3351: -- EGO_IPI_CANNOT_GRANT : User "USER" does not have privilege to give grants on Item "ITEM" in Organization "ORGANIZATION".
3464:
3465: -- user must not be able to delete his own grants
3466: l_api_name := 'Process_item_role';
3467: l_api_version := 1.0;
3468: x_return_status := FND_API.G_RET_STS_SUCCESS;
3469: l_user_id := FND_GLOBAL.User_Id;
3470: code_debug(l_api_name ||' started with params - grant guid '||RAWTOHEX(x_grant_guid));
3471: code_debug(' p_api_version '|| p_api_version||' p_commit '||p_commit||' p_init_msg_list '||p_init_msg_list );
3472: code_debug(' p_transaction_type '||p_transaction_type ||' p_inventory_item_id '||p_inventory_item_id||' p_item_number '||p_item_number );
3474: code_debug(' p_role_name '||p_role_name ||' p_instance_type '||p_instance_type||' p_instance_set_id '||p_instance_set_id );
3475: code_debug(' p_instance_set_name '||p_instance_set_name ||' p_party_type '||p_party_type||' p_party_id '||p_party_id );
3476: code_debug(' p_party_name'||p_party_name ||' p_start_date'||p_start_date||' p_end_date'||p_end_date );
3477:
3478: IF FND_API.To_Boolean( p_commit ) THEN
3479: SAVEPOINT PROCESS_ITEM_ROLE_SP;
3480: END IF;
3481: --
3482: -- Initialize message list
3480: END IF;
3481: --
3482: -- Initialize message list
3483: --
3484: IF FND_API.To_Boolean(p_init_msg_list) THEN
3485: FND_MSG_PUB.Initialize;
3486: END IF;
3487: code_debug(l_api_name||' msg pub initialized ' );
3488: --
3487: code_debug(l_api_name||' msg pub initialized ' );
3488: --
3489: --Standard checks
3490: --
3491: IF NOT FND_API.Compatible_API_Call (l_api_version
3492: ,p_api_version
3493: ,l_api_name
3494: ,g_pkg_name)THEN
3495: code_debug (l_api_version ||' invalid api version ');
3492: ,p_api_version
3493: ,l_api_name
3494: ,g_pkg_name)THEN
3495: code_debug (l_api_version ||' invalid api version ');
3496: RAISE FND_API.G_EXC_ERROR;
3497: END IF;
3498: code_debug(l_api_name||' valid api ' );
3499: --
3500: -- invalid params passed
3570: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
3571: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3572: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
3573: fnd_msg_pub.Add;
3574: RAISE FND_API.G_EXC_ERROR;
3575: END IF;
3576: code_debug(l_api_name||' valid params passed ' );
3577: l_sysdate := SYSDATE;
3578: l_start_date := NVL(p_start_date, l_sysdate);
3605: ELSE
3606: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3607: END IF;
3608: fnd_msg_pub.Add;
3609: RAISE FND_API.G_EXC_ERROR;
3610: END;
3611: --
3612: -- no security check done for the update of grants of type instance set.
3613: -- should this be done??
3628: ,p_party_id => l_party_id
3629: ,p_set_message => G_TRUE
3630: ) THEN
3631: code_debug(l_api_name ||' user does not have privilege to update the roles on item');
3632: RAISE FND_API.G_EXC_ERROR;
3633: END IF;
3634: code_debug(l_api_name ||' user has privilege to update the roles on item');
3635: ELSE
3636: IF NOT validate_function_security(p_function_name => G_FN_NAME_ADMIN
3635: ELSE
3636: IF NOT validate_function_security(p_function_name => G_FN_NAME_ADMIN
3637: ,p_set_message => G_TRUE) THEN
3638: code_debug(l_api_name ||' user does not have function privilege to update roles in instance set');
3639: RAISE FND_API.G_EXC_ERROR;
3640: END IF;
3641: code_debug(l_api_name ||' user has function privilege to update the roles in instance set');
3642: END IF;
3643:
3656: IF x_return_status <> G_TRUE THEN
3657: --
3658: -- should never occur as the grant is already valid
3659: --
3660: RAISE FND_API.G_EXC_ERROR;
3661: ELSE
3662: x_return_status := FND_API.G_RET_STS_SUCCESS;
3663: IF FND_API.To_Boolean( p_commit ) THEN
3664: COMMIT WORK;
3658: -- should never occur as the grant is already valid
3659: --
3660: RAISE FND_API.G_EXC_ERROR;
3661: ELSE
3662: x_return_status := FND_API.G_RET_STS_SUCCESS;
3663: IF FND_API.To_Boolean( p_commit ) THEN
3664: COMMIT WORK;
3665: END IF;
3666: RETURN;
3659: --
3660: RAISE FND_API.G_EXC_ERROR;
3661: ELSE
3662: x_return_status := FND_API.G_RET_STS_SUCCESS;
3663: IF FND_API.To_Boolean( p_commit ) THEN
3664: COMMIT WORK;
3665: END IF;
3666: RETURN;
3667: END IF;
3675: ) THEN
3676: code_debug (l_api_version ||' grant is already end dated ');
3677: fnd_message.Set_Name(G_APP_NAME, 'EGO_GRANT_END_DATED');
3678: fnd_msg_pub.Add;
3679: RAISE FND_API.G_EXC_ERROR;
3680: END IF;
3681: IF date_check (p_start_date => l_sysdate
3682: ,p_end_date => p_end_date
3683: ,p_validation_type => G_GT_VAL
3684: ) THEN
3685: code_debug (l_api_version ||' end date less than sysdate ');
3686: fnd_message.Set_Name(G_APP_NAME, 'EGO_ENDDATE_LT_CURRDATE');
3687: fnd_msg_pub.Add;
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690: IF (p_start_date > l_sysdate and l_start_date > l_sysdate) THEN
3691: l_start_date := NVL(p_start_date,l_start_date);
3692: END IF;
3704: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3705: fnd_message.Set_Token('START_DATE', l_start_date);
3706: fnd_message.Set_Token('END_DATE', p_end_date);
3707: fnd_msg_pub.Add;
3708: RAISE FND_API.G_EXC_ERROR;
3709: ELSE
3710: x_return_status := FND_API.G_RET_STS_SUCCESS;
3711: IF FND_API.To_Boolean( p_commit ) THEN
3712: COMMIT WORK;
3706: fnd_message.Set_Token('END_DATE', p_end_date);
3707: fnd_msg_pub.Add;
3708: RAISE FND_API.G_EXC_ERROR;
3709: ELSE
3710: x_return_status := FND_API.G_RET_STS_SUCCESS;
3711: IF FND_API.To_Boolean( p_commit ) THEN
3712: COMMIT WORK;
3713: END IF;
3714: RETURN;
3707: fnd_msg_pub.Add;
3708: RAISE FND_API.G_EXC_ERROR;
3709: ELSE
3710: x_return_status := FND_API.G_RET_STS_SUCCESS;
3711: IF FND_API.To_Boolean( p_commit ) THEN
3712: COMMIT WORK;
3713: END IF;
3714: RETURN;
3715: END IF;
3901: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_OVERLAP_GRANT');
3902: fnd_message.Set_Token('START_DATE', l_start_date);
3903: fnd_message.Set_Token('END_DATE', p_end_date);
3904: fnd_msg_pub.Add;
3905: RAISE FND_API.G_EXC_ERROR;
3906: ELSE
3907: -- changing return status to FND_API.G_RET_STS_SUCCESS
3908: -- as per standards
3909: x_return_status := FND_API.G_RET_STS_SUCCESS;
3903: fnd_message.Set_Token('END_DATE', p_end_date);
3904: fnd_msg_pub.Add;
3905: RAISE FND_API.G_EXC_ERROR;
3906: ELSE
3907: -- changing return status to FND_API.G_RET_STS_SUCCESS
3908: -- as per standards
3909: x_return_status := FND_API.G_RET_STS_SUCCESS;
3910: END IF;
3911: ELSE
3905: RAISE FND_API.G_EXC_ERROR;
3906: ELSE
3907: -- changing return status to FND_API.G_RET_STS_SUCCESS
3908: -- as per standards
3909: x_return_status := FND_API.G_RET_STS_SUCCESS;
3910: END IF;
3911: ELSE
3912: code_debug(l_api_name||' raising errors ');
3913: RAISE FND_API.G_EXC_ERROR;
3909: x_return_status := FND_API.G_RET_STS_SUCCESS;
3910: END IF;
3911: ELSE
3912: code_debug(l_api_name||' raising errors ');
3913: RAISE FND_API.G_EXC_ERROR;
3914: END IF;
3915: END IF;
3916:
3917: -- commit data
3914: END IF;
3915: END IF;
3916:
3917: -- commit data
3918: IF FND_API.To_Boolean( p_commit ) THEN
3919: COMMIT WORK;
3920: END IF;
3921:
3922: EXCEPTION
3919: COMMIT WORK;
3920: END IF;
3921:
3922: EXCEPTION
3923: WHEN FND_API.G_EXC_ERROR THEN
3924: code_debug(l_api_name||' returning expected error ');
3925: IF FND_API.To_Boolean( p_commit ) THEN
3926: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3927: END IF;
3921:
3922: EXCEPTION
3923: WHEN FND_API.G_EXC_ERROR THEN
3924: code_debug(l_api_name||' returning expected error ');
3925: IF FND_API.To_Boolean( p_commit ) THEN
3926: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3927: END IF;
3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3924: code_debug(l_api_name||' returning expected error ');
3925: IF FND_API.To_Boolean( p_commit ) THEN
3926: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3927: END IF;
3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3930: ,p_count => x_msg_count
3931: ,p_data => x_msg_data);
3932: WHEN OTHERS THEN
3925: IF FND_API.To_Boolean( p_commit ) THEN
3926: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3927: END IF;
3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3930: ,p_count => x_msg_count
3931: ,p_data => x_msg_data);
3932: WHEN OTHERS THEN
3933: IF FND_API.To_Boolean( p_commit ) THEN
3929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3930: ,p_count => x_msg_count
3931: ,p_data => x_msg_data);
3932: WHEN OTHERS THEN
3933: IF FND_API.To_Boolean( p_commit ) THEN
3934: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3935: END IF;
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3932: WHEN OTHERS THEN
3933: IF FND_API.To_Boolean( p_commit ) THEN
3934: ROLLBACK TO PROCESS_ITEM_ROLE_SP;
3935: END IF;
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
3938: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3939: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3940: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3938: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
3939: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
3940: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
3941: FND_MSG_PUB.Add;
3942: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3943: ,p_count => x_msg_count
3944: ,p_data => x_msg_data);
3945: code_debug(' EXCEPTION in '||l_api_name||' : ' ||x_msg_data );
3946: END Process_item_role;
4079:
4080: BEGIN
4081: l_api_name := 'Process_item_phase_and_status';
4082: l_api_version := 1.0;
4083: x_return_status := FND_API.G_RET_STS_SUCCESS;
4084: l_user_id := FND_GLOBAL.User_Id;
4085: l_policy_co_required := 'CHANGE_ORDER_REQUIRED';
4086: l_policy_not_allowed := 'NOT_ALLOWED';
4087: code_debug(l_api_name ||' started with params -- effective date '|| p_effective_date);
4089: code_debug(' p_transaction_type '||p_transaction_type ||' p_inventory_item_id '||p_inventory_item_id||' p_item_number '||p_item_number );
4090: code_debug(' p_organization_id '||p_organization_id ||' p_organization_code '||p_organization_code||' p_revision_id '||p_revision_id );
4091: code_debug(' p_revision '||p_revision ||' p_implement_changes '||p_implement_changes||' p_status '||p_status );
4092:
4093: IF FND_API.To_Boolean( p_commit ) THEN
4094: SAVEPOINT PROCESS_ITEM_PHASE_SP;
4095: END IF;
4096: --
4097: -- Initialize message list
4095: END IF;
4096: --
4097: -- Initialize message list
4098: --
4099: IF FND_API.To_Boolean(p_init_msg_list) THEN
4100: FND_MSG_PUB.Initialize;
4101: END IF;
4102: code_debug(l_api_name||' msg pub initialized ' );
4103: --
4102: code_debug(l_api_name||' msg pub initialized ' );
4103: --
4104: --Standard checks
4105: --
4106: IF NOT FND_API.Compatible_API_Call (l_api_version
4107: ,p_api_version
4108: ,l_api_name
4109: ,g_pkg_name) THEN
4110: code_debug (l_api_version ||' invalid api version ');
4107: ,p_api_version
4108: ,l_api_name
4109: ,g_pkg_name) THEN
4110: code_debug (l_api_version ||' invalid api version ');
4111: RAISE FND_API.G_EXC_ERROR;
4112: END IF;
4113: --
4114: -- check for invalid params
4115: --
4155: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4156: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4157: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4158: FND_MSG_PUB.Add;
4159: RAISE FND_API.G_EXC_ERROR;
4160: END IF;
4161: l_change_status_flag := TRUE;
4162: l_organization_id := p_organization_id;
4163: l_inventory_item_id := p_inventory_item_id;
4299: --
4300: -- logical set of errors completed
4301: -- further validations assume that there are no errors
4302: --
4303: RAISE FND_API.G_EXC_ERROR;
4304: END IF;
4305:
4306: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE
4307: /* , EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE */) THEN
4661: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change ');
4662: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN
4663: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4664: (p_api_version => p_api_version
4665: ,p_commit => FND_API.G_FALSE
4666: ,p_inventory_item_id => l_inventory_item_id
4667: ,p_item_number => l_item_number
4668: ,p_organization_id => l_organization_id
4669: ,p_effective_date => l_effective_date
4673: ,p_phase_id => l_future_phase_id
4674: ,p_status_code => p_status
4675: ,p_change_id => NULL
4676: ,p_change_line_id => NULL
4677: ,p_perform_security_check => FND_API.G_FALSE
4678: ,x_return_status => x_return_status
4679: ,x_errorcode => l_dummy_char
4680: ,x_msg_count => x_msg_count
4681: ,x_msg_data => x_msg_data
4686: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_PHASE THEN
4687:
4688: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4689: (p_api_version => p_api_version
4690: ,p_commit => FND_API.G_FALSE
4691: ,p_inventory_item_id => l_inventory_item_id
4692: ,p_item_number => l_item_number
4693: ,p_organization_id => l_organization_id
4694: ,p_effective_date => l_effective_date
4698: ,p_phase_id => l_future_phase_id
4699: ,p_status_code => NULL
4700: ,p_change_id => NULL
4701: ,p_change_line_id => NULL
4702: ,p_perform_security_check => FND_API.G_FALSE
4703: ,x_return_status => x_return_status
4704: ,x_errorcode => l_dummy_char
4705: ,x_msg_count => x_msg_count
4706: ,x_msg_data => x_msg_data
4708: */
4709: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
4710: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4711: (p_api_version => p_api_version
4712: ,p_commit => FND_API.G_FALSE
4713: ,p_inventory_item_id => l_inventory_item_id
4714: ,p_item_number => l_item_number
4715: ,p_organization_id => l_organization_id
4716: ,p_effective_date => l_effective_date
4720: ,p_phase_id => NULL
4721: ,p_status_code => p_status
4722: ,p_change_id => NULL
4723: ,p_change_line_id => NULL
4724: ,p_perform_security_check => FND_API.G_FALSE
4725: ,x_return_status => x_return_status
4726: ,x_errorcode => l_dummy_char
4727: ,x_msg_count => x_msg_count
4728: ,x_msg_data => x_msg_data
4730:
4731: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4732: EGO_ITEM_LC_IMP_PC_PUB.Modify_Pending_Phase_Change
4733: (p_api_version => p_api_version
4734: ,p_commit => FND_API.G_FALSE
4735: ,p_transaction_type => p_transaction_type
4736: ,p_inventory_item_id => l_inventory_item_id
4737: ,p_organization_id => l_organization_id
4738: ,p_revision_id => l_revision_id
4742: ,p_change_id => NULL
4743: ,p_change_line_id => NULL
4744: ,p_effective_date => p_effective_date
4745: ,p_new_effective_date => l_effective_date
4746: ,p_perform_security_check => FND_API.G_FALSE
4747: ,x_return_status => x_return_status
4748: ,x_errorcode => l_dummy_char
4749: ,x_msg_count => x_msg_count
4750: ,x_msg_data => x_msg_data
4751: );
4752: END IF;
4753:
4754: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.create_pending_phase_change '||x_return_status);
4755: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4756: code_debug (l_api_name ||' cannot create/modify/delete pending phase change '||x_msg_data);
4757: --
4758: -- this will occur only in case of exception
4759: -- all valid values are passed.
4762: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4763: fnd_message.set_token('MESSAGE', x_msg_data);
4764: fnd_msg_pub.Add;
4765: END IF;
4766: RAISE FND_API.G_EXC_ERROR;
4767: ELSIF FND_API.To_Boolean(p_implement_changes) THEN
4768: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4769: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4770: l_revision_master_controlled := FND_API.g_false;
4763: fnd_message.set_token('MESSAGE', x_msg_data);
4764: fnd_msg_pub.Add;
4765: END IF;
4766: RAISE FND_API.G_EXC_ERROR;
4767: ELSIF FND_API.To_Boolean(p_implement_changes) THEN
4768: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4769: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4770: l_revision_master_controlled := FND_API.g_false;
4771: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
4766: RAISE FND_API.G_EXC_ERROR;
4767: ELSIF FND_API.To_Boolean(p_implement_changes) THEN
4768: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4769: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4770: l_revision_master_controlled := FND_API.g_false;
4771: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
4772: EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes
4773: (p_api_version => p_api_version
4774: ,p_inventory_item_id => l_inventory_item_id
4776: ,p_revision_id => l_revision_id
4777: ,p_revision_master_controlled => l_revision_master_controlled
4778: ,p_status_master_controlled => l_status_master_controlled
4779: ,p_is_master_org => l_is_master_org
4780: ,p_perform_security_check => FND_API.G_FALSE
4781: ,x_return_status => x_return_status
4782: ,x_errorcode => l_dummy_char
4783: ,x_msg_count => x_msg_count
4784: ,x_msg_data => x_msg_data
4783: ,x_msg_count => x_msg_count
4784: ,x_msg_data => x_msg_data
4785: );
4786: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
4787: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4788: code_debug (l_api_name ||' cannot implement changes '||x_msg_data);
4789: IF x_msg_count = 1 THEN
4790: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4791: fnd_message.set_token('MESSAGE', x_msg_data);
4790: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
4791: fnd_message.set_token('MESSAGE', x_msg_data);
4792: fnd_msg_pub.Add;
4793: END IF;
4794: RAISE FND_API.G_EXC_ERROR;
4795: END IF;
4796: END IF;
4797: ELSE
4798: code_debug (l_api_name ||' flashing all errors ');
4795: END IF;
4796: END IF;
4797: ELSE
4798: code_debug (l_api_name ||' flashing all errors ');
4799: RAISE FND_API.G_EXC_ERROR;
4800: END IF;
4801: --
4802: -- commit data
4803: --
4800: END IF;
4801: --
4802: -- commit data
4803: --
4804: IF FND_API.To_Boolean( p_commit ) THEN
4805: COMMIT WORK;
4806: END IF;
4807: x_return_status := FND_API.G_RET_STS_SUCCESS;
4808: EXCEPTION
4803: --
4804: IF FND_API.To_Boolean( p_commit ) THEN
4805: COMMIT WORK;
4806: END IF;
4807: x_return_status := FND_API.G_RET_STS_SUCCESS;
4808: EXCEPTION
4809: WHEN FND_API.G_EXC_ERROR THEN
4810: IF FND_API.To_Boolean( p_commit ) THEN
4811: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4805: COMMIT WORK;
4806: END IF;
4807: x_return_status := FND_API.G_RET_STS_SUCCESS;
4808: EXCEPTION
4809: WHEN FND_API.G_EXC_ERROR THEN
4810: IF FND_API.To_Boolean( p_commit ) THEN
4811: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4812: END IF;
4813: x_return_status := FND_API.G_RET_STS_ERROR;
4806: END IF;
4807: x_return_status := FND_API.G_RET_STS_SUCCESS;
4808: EXCEPTION
4809: WHEN FND_API.G_EXC_ERROR THEN
4810: IF FND_API.To_Boolean( p_commit ) THEN
4811: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4812: END IF;
4813: x_return_status := FND_API.G_RET_STS_ERROR;
4814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4809: WHEN FND_API.G_EXC_ERROR THEN
4810: IF FND_API.To_Boolean( p_commit ) THEN
4811: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4812: END IF;
4813: x_return_status := FND_API.G_RET_STS_ERROR;
4814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4815: ,p_count => x_msg_count
4816: ,p_data => x_msg_data);
4817: WHEN OTHERS THEN
4810: IF FND_API.To_Boolean( p_commit ) THEN
4811: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4812: END IF;
4813: x_return_status := FND_API.G_RET_STS_ERROR;
4814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4815: ,p_count => x_msg_count
4816: ,p_data => x_msg_data);
4817: WHEN OTHERS THEN
4818: IF FND_API.To_Boolean( p_commit ) THEN
4814: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4815: ,p_count => x_msg_count
4816: ,p_data => x_msg_data);
4817: WHEN OTHERS THEN
4818: IF FND_API.To_Boolean( p_commit ) THEN
4819: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4820: END IF;
4821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4822: IF c_get_item_det%ISOPEN THEN
4817: WHEN OTHERS THEN
4818: IF FND_API.To_Boolean( p_commit ) THEN
4819: ROLLBACK TO PROCESS_ITEM_PHASE_SP;
4820: END IF;
4821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4822: IF c_get_item_det%ISOPEN THEN
4823: CLOSE c_get_item_det;
4824: END IF;
4825: IF c_get_item_rev_det%ISOPEN THEN
4841: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4842: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
4843: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
4844: FND_MSG_PUB.Add;
4845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4846: ,p_count => x_msg_count
4847: ,p_data => x_msg_data);
4848: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
4849: END Process_item_phase_and_status;
4891: code_debug(l_api_name ||' started with params ');
4892: code_debug(' p_api_version '|| p_api_version||' p_commit '||p_commit||' p_init_msg_list '||p_init_msg_list );
4893: code_debug(' p_inventory_item_id '||p_inventory_item_id||' p_item_number '||p_item_number||' p_revision '||p_revision );
4894: code_debug(' p_organization_id '||p_organization_id ||' p_organization_code '||p_organization_code||' p_revision_id '||p_revision_id );
4895: IF FND_API.To_Boolean( p_commit ) THEN
4896: SAVEPOINT IMPLEMENT_CHANGES_SP;
4897: END IF;
4898: --
4899: -- Initialize message list
4897: END IF;
4898: --
4899: -- Initialize message list
4900: --
4901: IF FND_API.To_Boolean(p_init_msg_list) THEN
4902: FND_MSG_PUB.Initialize;
4903: END IF;
4904: code_debug(l_api_name||' msg pub initialized ' );
4905: --
4904: code_debug(l_api_name||' msg pub initialized ' );
4905: --
4906: --Standard checks
4907: --
4908: IF NOT FND_API.Compatible_API_Call (l_api_version
4909: ,p_api_version
4910: ,l_api_name
4911: ,g_pkg_name) THEN
4912: code_debug (l_api_name ||' invalid api version ');
4909: ,p_api_version
4910: ,l_api_name
4911: ,g_pkg_name) THEN
4912: code_debug (l_api_name ||' invalid api version ');
4913: RAISE FND_API.G_EXC_ERROR;
4914: END IF;
4915: --
4916: -- check for mandatory params
4917: --
4926: fnd_message.Set_Name(G_APP_NAME, G_INVALID_PARAMS_MSG);
4927: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
4928: fnd_message.Set_Token(G_PROC_NAME_TOKEN, l_api_name);
4929: FND_MSG_PUB.Add;
4930: RAISE FND_API.G_EXC_ERROR;
4931: END IF;
4932:
4933: --
4934: -- validate organization details
4987:
4988: IF l_implement_flag THEN
4989: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes ');
4990: l_is_master_org := EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_organization_id);
4991: l_revision_master_controlled := FND_API.g_false;
4992: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
4993: EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes
4994: (p_api_version => p_api_version
4995: ,p_inventory_item_id => l_inventory_item_id
4997: ,p_revision_id => l_revision_id
4998: ,p_revision_master_controlled => l_revision_master_controlled
4999: ,p_status_master_controlled => l_status_master_controlled
5000: ,p_is_master_org => l_is_master_org
5001: ,p_perform_security_check => FND_API.G_TRUE
5002: ,x_return_status => x_return_status
5003: ,x_errorcode => l_dummy_char
5004: ,x_msg_count => x_msg_count
5005: ,x_msg_data => x_msg_data
5004: ,x_msg_count => x_msg_count
5005: ,x_msg_data => x_msg_data
5006: );
5007: code_debug (l_api_name ||' return status from ego_item_lc_imp_pc_pub.Implement_Pending_Changes '||x_return_status);
5008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5009: IF x_msg_count = 1 THEN
5010: code_debug (l_api_name ||' cannot implement changes for '||x_msg_data);
5011: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
5012: fnd_message.set_token('MESSAGE', x_msg_data);
5011: fnd_message.Set_Name(G_APP_NAME,'EGO_GENERIC_MSG_TEXT');
5012: fnd_message.set_token('MESSAGE', x_msg_data);
5013: fnd_msg_pub.Add;
5014: END IF;
5015: RAISE FND_API.G_EXC_ERROR;
5016: END IF;
5017: ELSE
5018: code_debug (l_api_name ||' flashing all errors ');
5019: RAISE FND_API.G_EXC_ERROR;
5015: RAISE FND_API.G_EXC_ERROR;
5016: END IF;
5017: ELSE
5018: code_debug (l_api_name ||' flashing all errors ');
5019: RAISE FND_API.G_EXC_ERROR;
5020: END IF;
5021: --
5022: -- commit data
5023: --
5020: END IF;
5021: --
5022: -- commit data
5023: --
5024: IF FND_API.To_Boolean( p_commit ) THEN
5025: COMMIT WORK;
5026: END IF;
5027:
5028: EXCEPTION
5025: COMMIT WORK;
5026: END IF;
5027:
5028: EXCEPTION
5029: WHEN FND_API.G_EXC_ERROR THEN
5030: IF FND_API.To_Boolean( p_commit ) THEN
5031: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5032: END IF;
5033: x_return_status := FND_API.G_RET_STS_ERROR;
5026: END IF;
5027:
5028: EXCEPTION
5029: WHEN FND_API.G_EXC_ERROR THEN
5030: IF FND_API.To_Boolean( p_commit ) THEN
5031: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5032: END IF;
5033: x_return_status := FND_API.G_RET_STS_ERROR;
5034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5029: WHEN FND_API.G_EXC_ERROR THEN
5030: IF FND_API.To_Boolean( p_commit ) THEN
5031: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5032: END IF;
5033: x_return_status := FND_API.G_RET_STS_ERROR;
5034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5035: ,p_count => x_msg_count
5036: ,p_data => x_msg_data);
5037: WHEN OTHERS THEN
5030: IF FND_API.To_Boolean( p_commit ) THEN
5031: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5032: END IF;
5033: x_return_status := FND_API.G_RET_STS_ERROR;
5034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5035: ,p_count => x_msg_count
5036: ,p_data => x_msg_data);
5037: WHEN OTHERS THEN
5038: IF FND_API.To_Boolean( p_commit ) THEN
5034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5035: ,p_count => x_msg_count
5036: ,p_data => x_msg_data);
5037: WHEN OTHERS THEN
5038: IF FND_API.To_Boolean( p_commit ) THEN
5039: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5040: END IF;
5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
5037: WHEN OTHERS THEN
5038: IF FND_API.To_Boolean( p_commit ) THEN
5039: ROLLBACK TO IMPLEMENT_CHANGES_SP;
5040: END IF;
5041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5042: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
5043: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
5044: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
5045: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
5043: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
5044: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
5045: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
5046: FND_MSG_PUB.Add;
5047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5048: ,p_count => x_msg_count
5049: ,p_data => x_msg_data);
5050: code_debug(' Exception in '||l_api_name||' : ' ||x_msg_data );
5051: END Implement_Item_Pending_Changes;
5402: ,x_msg_data => x_msg_data
5403: );
5404:
5405: EXCEPTION
5406: WHEN FND_API.G_EXC_ERROR THEN
5407:
5408: x_return_status := FND_API.G_RET_STS_ERROR;
5409:
5410: x_msg_count := ERROR_HANDLER.Get_Message_Count();
5404:
5405: EXCEPTION
5406: WHEN FND_API.G_EXC_ERROR THEN
5407:
5408: x_return_status := FND_API.G_RET_STS_ERROR;
5409:
5410: x_msg_count := ERROR_HANDLER.Get_Message_Count();
5411:
5412: IF (x_msg_count > 0) THEN
5428: END IF;
5429:
5430: WHEN OTHERS THEN
5431:
5432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5433:
5434: DECLARE
5435: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5436: l_dummy_entity_index NUMBER;
5447: ERROR_HANDLER.Add_Error_Message(
5448: p_message_name => 'EGO_PLSQL_ERR'
5449: ,p_application_id => 'EGO'
5450: ,p_token_tbl => l_token_table
5451: ,p_message_type => FND_API.G_RET_STS_ERROR
5452: );
5453:
5454: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
5455: ,x_entity_index => l_dummy_entity_index
5796: EGO_EXT_FWK_PUB.Compile_Attr_Group_Views(
5797: ERRBUF => l_msg_data
5798: ,RETCODE => l_return_status
5799: ,p_attr_group_id_list => l_ag_id
5800: ,p_init_msg_list => fnd_api.g_FALSE
5801: ,p_commit => fnd_api.g_TRUE
5802: );
5803:
5804: END IF;
5797: ERRBUF => l_msg_data
5798: ,RETCODE => l_return_status
5799: ,p_attr_group_id_list => l_ag_id
5800: ,p_init_msg_list => fnd_api.g_FALSE
5801: ,p_commit => fnd_api.g_TRUE
5802: );
5803:
5804: END IF;
5805:
5843: EGO_EXT_FWK_PUB.Compile_Attr_Group_Views(
5844: ERRBUF => l_msg_data
5845: ,RETCODE => l_return_status
5846: ,p_attr_group_id_list => TO_CHAR(l_temp_num)
5847: ,p_init_msg_list => fnd_api.g_FALSE
5848: ,p_commit => fnd_api.g_TRUE
5849: );
5850: END IF;
5851:
5844: ERRBUF => l_msg_data
5845: ,RETCODE => l_return_status
5846: ,p_attr_group_id_list => TO_CHAR(l_temp_num)
5847: ,p_init_msg_list => fnd_api.g_FALSE
5848: ,p_commit => fnd_api.g_TRUE
5849: );
5850: END IF;
5851:
5852: IF (l_return_status <> 'S') THEN
5894: RAISE ERR_OCCURED;
5895: END IF;
5896:
5897: ERRBUF := '';
5898: RETCODE := FND_API.G_RET_STS_SUCCESS;
5899:
5900:
5901: EXCEPTION
5902: WHEN ERR_OCCURED THEN
5905: l_views_exist := 'Could not create the following views as already an object exists by this name - '||l_views_exist;
5906: END IF;
5907:
5908: ERRBUF := l_views_exist||' '||l_view_compile_errs;
5909: RETCODE := FND_API.G_RET_STS_ERROR;
5910:
5911: RAISE_APPLICATION_ERROR(-20000, l_views_exist||' '||l_view_compile_errs);
5912:
5913: END Generate_GDSN_Ext_AG_TP_Views;
6115: --bug 12392423, hard code APPS as second parameter
6116: AD_DDL.DO_DDL(fnd_apps_schema, 'APPS',ad_ddl.create_view,l_final_view_sql, p_final_agv_name);
6117:
6118:
6119: x_return_status := FND_API.G_RET_STS_SUCCESS;
6120:
6121: EXCEPTION
6122: WHEN OTHERS THEN
6123:
6120:
6121: EXCEPTION
6122: WHEN OTHERS THEN
6123:
6124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6125: x_msg_data := SQLERRM;
6126:
6127: END GENERATE_GTIN_TP_ATTRS_VIEW;
6128:
6231: x_return_status := l_return_status ;
6232: END LOOP;
6233: EXCEPTION
6234: WHEN OTHERS THEN
6235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6236: x_msg_data := SQLERRM;
6237:
6238: END process_attribute_defaulting;
6239:
6277:
6278: --
6279: -- Initialize message list
6280: --
6281: IF FND_API.To_Boolean(p_init_msg_list) THEN
6282: FND_MSG_PUB.Initialize;
6283: END IF;
6284:
6285: x_return_status := FND_API.G_RET_STS_SUCCESS;
6281: IF FND_API.To_Boolean(p_init_msg_list) THEN
6282: FND_MSG_PUB.Initialize;
6283: END IF;
6284:
6285: x_return_status := FND_API.G_RET_STS_SUCCESS;
6286:
6287: --
6288: -- Validate id's
6289: --
6308: EXCEPTION
6309: WHEN NO_DATA_FOUND THEN
6310: fnd_message.set_name('INV','INV_TEMPLATE_ERROR');
6311: fnd_msg_pub.Add;
6312: RAISE FND_API.G_EXC_ERROR;
6313: WHEN OTHERS THEN
6314: null;
6315: END;
6316:
6325: EXCEPTION
6326: WHEN NO_DATA_FOUND THEN
6327: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
6328: fnd_msg_pub.Add;
6329: RAISE FND_API.G_EXC_ERROR;
6330: WHEN OTHERS THEN
6331: null;
6332: END;
6333:
6336: ELSE
6337:
6338: fnd_message.set_name('INV','INV_ST_INVALID_COMBINATION');
6339: fnd_msg_pub.Add;
6340: RAISE FND_API.G_EXC_ERROR;
6341:
6342: END IF;
6343:
6344: FOR j IN p_serial_tag_assignments.FIRST.. p_serial_tag_assignments.LAST
6381: IF l_exists = 'Y' THEN
6382: fnd_message.set_name('INV','INV_ALREADY_EXISTS');
6383: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);
6384: fnd_msg_pub.Add;
6385: RAISE FND_API.G_EXC_ERROR;
6386: END IF;
6387:
6388: EXCEPTION
6389: WHEN NO_DATA_FOUND THEN
6493: IF l_exists = 'Y' THEN
6494: FND_MESSAGE.SET_NAME('INV','INV_PENDING_TXNS_EXISTS');
6495: fnd_message.set_token('ENTITY',l_transaction_type_name,FALSE);
6496: fnd_msg_pub.Add;
6497: RAISE FND_API.G_EXC_ERROR;
6498: END IF;
6499:
6500: END IF;
6501:
6552:
6553: END IF;
6554:
6555: -- commit data
6556: IF FND_API.To_Boolean( p_commit ) THEN
6557: COMMIT;
6558: END IF;
6559:
6560: EXCEPTION
6557: COMMIT;
6558: END IF;
6559:
6560: EXCEPTION
6561: WHEN FND_API.G_EXC_ERROR THEN
6562: ROLLBACK TO Process_Serial_Tag_Assign;
6563: code_debug(l_api_name||' returning expected error ');
6564:
6565: x_return_status := FND_API.G_RET_STS_ERROR;
6561: WHEN FND_API.G_EXC_ERROR THEN
6562: ROLLBACK TO Process_Serial_Tag_Assign;
6563: code_debug(l_api_name||' returning expected error ');
6564:
6565: x_return_status := FND_API.G_RET_STS_ERROR;
6566: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6567: ,p_count => x_msg_count
6568: ,p_data => x_msg_data);
6569: WHEN OTHERS THEN
6562: ROLLBACK TO Process_Serial_Tag_Assign;
6563: code_debug(l_api_name||' returning expected error ');
6564:
6565: x_return_status := FND_API.G_RET_STS_ERROR;
6566: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6567: ,p_count => x_msg_count
6568: ,p_data => x_msg_data);
6569: WHEN OTHERS THEN
6570: ROLLBACK TO Process_Serial_Tag_Assign;
6567: ,p_count => x_msg_count
6568: ,p_data => x_msg_data);
6569: WHEN OTHERS THEN
6570: ROLLBACK TO Process_Serial_Tag_Assign;
6571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6572:
6573: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
6574: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
6575: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
6574: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
6575: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, l_api_name);
6576: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
6577: FND_MSG_PUB.Add;
6578: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6579: ,p_count => x_msg_count
6580: ,p_data => x_msg_data);
6581:
6582: code_debug(' EXCEPTION in '||l_api_name||' : ' ||x_msg_data );