eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on FND_API

Line 305: ,p_message_type => FND_API.G_RET_STS_ERROR

301: ERROR_HANDLER.Add_Error_Message(
302: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'
303: ,p_application_id => 'EGO'
304: ,p_token_tbl => l_token_table
305: ,p_message_type => FND_API.G_RET_STS_ERROR
306: ,p_entity_id => G_ENTITY_ID
307: ,p_entity_index => p_entity_index
308: ,p_entity_code => G_ENTITY_CODE
309: ,p_table_name => G_TABLE_NAME

Line 408: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE

404: ERRBUF OUT NOCOPY VARCHAR2
405: ,RETCODE OUT NOCOPY VARCHAR2
406: ,p_data_set_id IN NUMBER
407: ,p_debug_level IN NUMBER DEFAULT 0
408: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE
409: ,p_initialize_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
410: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
411: ,p_ignore_security_for_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
412: ) IS

Line 409: ,p_initialize_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

405: ,RETCODE OUT NOCOPY VARCHAR2
406: ,p_data_set_id IN NUMBER
407: ,p_debug_level IN NUMBER DEFAULT 0
408: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE
409: ,p_initialize_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
410: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
411: ,p_ignore_security_for_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
412: ) IS
413: l_api_name VARCHAR2(30);

Line 410: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

406: ,p_data_set_id IN NUMBER
407: ,p_debug_level IN NUMBER DEFAULT 0
408: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE
409: ,p_initialize_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
410: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
411: ,p_ignore_security_for_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
412: ) IS
413: l_api_name VARCHAR2(30);
414: l_error_message_name VARCHAR2(30);

Line 411: ,p_ignore_security_for_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE

407: ,p_debug_level IN NUMBER DEFAULT 0
408: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE
409: ,p_initialize_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
410: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
411: ,p_ignore_security_for_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
412: ) IS
413: l_api_name VARCHAR2(30);
414: l_error_message_name VARCHAR2(30);
415: l_entity_index_counter NUMBER := 0;

Line 648: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

644: --======================--
645: -- ERROR_HANDLER SET-UP --
646: --======================--
647:
648: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
649:
650: ERROR_HANDLER.Initialize();
651: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
652:

Line 819: IF p_validate_only = FND_API.G_FALSE THEN

815: -- First, verify that all passed-in Inventory Item IDs belong to existing --
816: -- Items; if any row has an invalid Item ID, error it out along with all --
817: -- other rows in its logical Attribute Group row --
818: ----------------------------------------------------------------------------
819: IF p_validate_only = FND_API.G_FALSE THEN
820: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
821: SET UAI.PROCESS_STATUS = G_PS_BAD_ITEM_ID
822: WHERE UAI.DATA_SET_ID = p_data_set_id
823: AND UAI.PROCESS_STATUS IN (G_PS_IN_PROCESS, G_PS_STYLE_VARIANT_IN_PROCESS)

Line 856: IF p_validate_only = FND_API.G_FALSE THEN

852: -- (Note that we only convert any Item Number/Org ID --
853: -- combination once and then set the Item ID we find --
854: -- to all rows with the same Item Number and Org ID) --
855: -------------------------------------------------------
856: IF p_validate_only = FND_API.G_FALSE THEN
857: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
858: SET INVENTORY_ITEM_ID =
859: (SELECT INVENTORY_ITEM_ID
860: FROM MTL_SYSTEM_ITEMS_B_KFV

Line 919: IF p_validate_only = FND_API.G_FALSE THEN

915: -- First, verify that all passed-in Revision IDs are valid; --
916: -- if any row has an invalid Revision ID, error it out along --
917: -- with all other rows in its logical Attribute Group row --
918: ---------------------------------------------------------------
919: IF p_validate_only = FND_API.G_FALSE THEN
920: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
921: SET UAI.PROCESS_STATUS = G_PS_BAD_REVISION_ID
922: WHERE UAI.DATA_SET_ID = p_data_set_id
923: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS

Line 957: IF p_validate_only = FND_API.G_FALSE THEN

953: -- Next, convert Revision to Revision ID for those rows where --
954: -- the user passed in the Revision (note that by "Revision", --
955: -- we mean the Revision *Code* and not the Revision Label) --
956: ----------------------------------------------------------------
957: IF p_validate_only = FND_API.G_FALSE THEN
958: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
959: SET UAI.REVISION_ID = (SELECT MIR.REVISION_ID
960: FROM MTL_ITEM_REVISIONS MIR
961: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID

Line 1038: IF p_validate_only = FND_API.G_FALSE THEN

1034: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Catalog Group ID conversion', 0);
1035: END IF;
1036:
1037: -- write_records(p_data_set_id => p_data_set_id, p_module => l_api_name, p_message => 'After init');
1038: IF p_validate_only = FND_API.G_FALSE THEN
1039: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1040: SET (UAI.ITEM_CATALOG_GROUP_ID, UAI.PROG_INT_CHAR1,
1041: UAI.PROG_INT_NUM2, UAI.PROG_INT_NUM3)
1042: = (SELECT NVL(MSI.ITEM_CATALOG_GROUP_ID,-1), NVL(MSI.APPROVAL_STATUS,'A'),

Line 1382: IF p_validate_only = FND_API.G_FALSE THEN

1378: ----------------------------------------------------------------
1379: -- Next, validate the Item Supplier attrs. Validate that the --
1380: -- pk1_value exists in ego_item_associations for this item --
1381: ----------------------------------------------------------------
1382: IF p_validate_only = FND_API.G_FALSE THEN
1383: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1384: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER
1385: WHERE uai.DATA_SET_ID = p_data_set_id
1386: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1455: IF p_validate_only = FND_API.G_FALSE THEN

1451: -----------------------------------------------------------------
1452: -- Next, validate the Item Supplier site attrs. Validate that --
1453: -- the pk2_value exists in ego_item_associations for this item --
1454: -----------------------------------------------------------------
1455: IF p_validate_only = FND_API.G_FALSE THEN
1456: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1457: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE
1458: WHERE uai.DATA_SET_ID = p_data_set_id
1459: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1529: IF p_validate_only = FND_API.G_FALSE THEN

1525: -- Next, validate the Item Supplier site Org attrs. Validate --
1526: -- that the pk1,pk2_value along with the organization_id exists --
1527: -- in ego_item_associations for this item --
1528: ------------------------------------------------------------------
1529: IF p_validate_only = FND_API.G_FALSE THEN
1530: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1531: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE_ORG
1532: WHERE uai.DATA_SET_ID = p_data_set_id
1533: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1602: IF p_validate_only = FND_API.G_TRUE THEN

1598: --------------------------------------------------------------------------------
1599: -- Mark as errors all rows that share the same logical Attribute Group --
1600: -- Variant attribute values for existing SKUs can not be updated --
1601: --------------------------------------------------------------------------------
1602: IF p_validate_only = FND_API.G_TRUE THEN
1603: UPDATE EGO_ITM_USR_ATTR_INTRFC
1604: SET PROCESS_STATUS = G_PS_SKU_VAR_VALUE_NOT_UPD
1605: WHERE DATA_SET_ID = p_data_set_id
1606: AND PROCESS_STATUS = G_PS_IN_PROCESS

Line 1667: IF p_validate_only = FND_API.G_FALSE THEN

1663:
1664: ---------------------------------------
1665: -- Set Lifecycle of the revision items.
1666: ---------------------------------------
1667: IF p_validate_only = FND_API.G_FALSE THEN
1668: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1669: SET (UAI.PROG_INT_NUM3)
1670: = NVL((SELECT MIR.CURRENT_PHASE_ID
1671: FROM MTL_ITEM_REVISIONS MIR

Line 1902: IF p_validate_only = FND_API.G_FALSE THEN

1898: --------------------------------------------------------------------------------
1899: -- Processing Style variant value sets. Using a merge statement so that bulk --
1900: -- feature can be used --
1901: --------------------------------------------------------------------------------
1902: IF p_validate_only = FND_API.G_FALSE THEN
1903: MERGE INTO EGO_STYLE_VARIANT_ATTR_VS ESVAV
1904: USING (SELECT
1905: INTF.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID,
1906: INTF.ATTR_VALUE_NUM AS VALUE_SET_ID,

Line 1965: END IF; --IF p_validate_only = FND_API.G_FALSE THEN

1961: WHERE DATA_SET_ID = p_data_set_id
1962: AND PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS;
1963:
1964: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all style records to success, count='||SQL%ROWCOUNT, 1);
1965: END IF; --IF p_validate_only = FND_API.G_FALSE THEN
1966:
1967:
1968:
1969: --========================================--

Line 2272: l_item_return_status := FND_API.G_RET_STS_ERROR;

2268: l_token_table(6).TOKEN_VALUE := error_rec.REVISION;
2269: END IF;
2270: END IF;
2271:
2272: l_item_return_status := FND_API.G_RET_STS_ERROR;
2273: ERROR_HANDLER.Add_Error_Message(
2274: p_message_name => l_error_message_name
2275: ,p_application_id => 'EGO'
2276: ,p_token_tbl => l_token_table

Line 2277: ,p_message_type => FND_API.G_RET_STS_ERROR

2273: ERROR_HANDLER.Add_Error_Message(
2274: p_message_name => l_error_message_name
2275: ,p_application_id => 'EGO'
2276: ,p_token_tbl => l_token_table
2277: ,p_message_type => FND_API.G_RET_STS_ERROR
2278: ,p_row_identifier => error_rec.TRANSACTION_ID
2279: ,p_entity_id => G_ENTITY_ID
2280: ,p_entity_code => G_ENTITY_CODE
2281: ,p_table_name => G_TABLE_NAME

Line 2354: IF p_validate_only = FND_API.G_TRUE AND p_ignore_security_for_validate = FND_API.G_FALSE THEN

2350: -- EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
2351:
2352: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting User Attributes Bulk Load', 1);
2353:
2354: IF p_validate_only = FND_API.G_TRUE AND p_ignore_security_for_validate = FND_API.G_FALSE THEN
2355: l_privilege_predicate_api_name := 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate';
2356: ELSE
2357: l_privilege_predicate_api_name := NULL;
2358: END IF;

Line 2390: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

2386: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2387: ,p_entity_index => l_entity_index_counter --IN NUMBER
2388: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2389: ,p_debug_level => p_debug_level --IN NUMBER
2390: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2391: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2392: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2393: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2394: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2391: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

2387: ,p_entity_index => l_entity_index_counter --IN NUMBER
2388: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2389: ,p_debug_level => p_debug_level --IN NUMBER
2390: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2391: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2392: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2393: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2394: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2395: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list

Line 2392: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

2388: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2389: ,p_debug_level => p_debug_level --IN NUMBER
2390: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2391: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2392: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2393: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2394: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2395: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
2396: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list

Line 2393: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

2389: ,p_debug_level => p_debug_level --IN NUMBER
2390: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2391: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2392: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2393: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2394: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2395: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
2396: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
2397: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2

Line 2394: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

2390: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2391: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2392: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2393: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2394: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2395: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
2396: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
2397: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2
2398: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

Line 2408: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2404: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
2405: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
2406: );
2407:
2408: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2409: ERRBUF := l_msg_data;
2410: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2411: RAISE G_UNHANDLED_EXCEPTION;
2412: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 2410: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2406: );
2407:
2408: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2409: ERRBUF := l_msg_data;
2410: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2411: RAISE G_UNHANDLED_EXCEPTION;
2412: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2413: RETCODE := L_CONC_RET_STS_WARNING;
2414: END IF;

Line 2502: ,p_message_type => FND_API.G_RET_STS_ERROR

2498: ERROR_HANDLER.Add_Error_Message(
2499: p_message_name => l_error_message_name
2500: ,p_application_id => 'EGO'
2501: ,p_token_tbl => l_token_table
2502: ,p_message_type => FND_API.G_RET_STS_ERROR
2503: ,p_row_identifier => i.TRANSACTION_ID
2504: ,p_entity_id => G_ENTITY_ID
2505: ,p_entity_code => G_ENTITY_CODE
2506: ,p_table_name => G_TABLE_NAME

Line 2538: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

2534: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2535: ,p_entity_index => l_entity_index_counter --IN NUMBER
2536: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2537: ,p_debug_level => p_debug_level --IN NUMBER
2538: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2539: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2540: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2541: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2542: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2539: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

2535: ,p_entity_index => l_entity_index_counter --IN NUMBER
2536: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2537: ,p_debug_level => p_debug_level --IN NUMBER
2538: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2539: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2540: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2541: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2542: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2543: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

Line 2540: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

2536: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2537: ,p_debug_level => p_debug_level --IN NUMBER
2538: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2539: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2540: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2541: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2542: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2543: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2544: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

Line 2541: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

2537: ,p_debug_level => p_debug_level --IN NUMBER
2538: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2539: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2540: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2541: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2542: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2543: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2544: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2545: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2

Line 2542: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

2538: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2539: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2540: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2541: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2542: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2543: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2544: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2545: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2
2546: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

Line 2556: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2552: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
2553: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
2554: );
2555:
2556: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2557: ERRBUF := l_msg_data;
2558: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2559: RAISE G_UNHANDLED_EXCEPTION;
2560: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 2558: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2554: );
2555:
2556: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2557: ERRBUF := l_msg_data;
2558: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2559: RAISE G_UNHANDLED_EXCEPTION;
2560: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2561: RETCODE := L_CONC_RET_STS_WARNING;
2562: END IF;

Line 2576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

2572: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2573: ,p_entity_index => l_entity_index_counter --IN NUMBER
2574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2575: ,p_debug_level => p_debug_level --IN NUMBER
2576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2580: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

2573: ,p_entity_index => l_entity_index_counter --IN NUMBER
2574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2575: ,p_debug_level => p_debug_level --IN NUMBER
2576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2580: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

Line 2578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

2574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2575: ,p_debug_level => p_debug_level --IN NUMBER
2576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2580: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2582: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

Line 2579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

2575: ,p_debug_level => p_debug_level --IN NUMBER
2576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2580: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2582: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2583: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2

Line 2580: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

2576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2580: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2582: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2583: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2
2584: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

Line 2594: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2590: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
2591: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
2592: );
2593:
2594: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2595: ERRBUF := l_msg_data;
2596: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2597: RAISE G_UNHANDLED_EXCEPTION;
2598: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 2596: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2592: );
2593:
2594: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2595: ERRBUF := l_msg_data;
2596: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2597: RAISE G_UNHANDLED_EXCEPTION;
2598: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2599: RETCODE := L_CONC_RET_STS_WARNING;
2600: END IF;

Line 2603: IF p_validate_only = FND_API.G_FALSE THEN

2599: RETCODE := L_CONC_RET_STS_WARNING;
2600: END IF;
2601:
2602:
2603: IF p_validate_only = FND_API.G_FALSE THEN
2604: ---------------------------------------------------------------------
2605: -- Calling the API to Mark all such rows which have the same data --
2606: -- as we have for the attribute in the production tables. --
2607: ---------------------------------------------------------------------

Line 2623: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2619: ,x_msg_data =>l_msg_data
2620: );
2621: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2622:
2623: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2624: ERRBUF := l_msg_data;
2625: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2626: ERROR_HANDLER.Add_Error_Message(
2627: p_message_text => l_msg_data

Line 2625: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2621: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2622:
2623: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2624: ERRBUF := l_msg_data;
2625: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2626: ERROR_HANDLER.Add_Error_Message(
2627: p_message_text => l_msg_data
2628: ,p_application_id => 'EGO'
2629: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2629: ,p_message_type => FND_API.G_RET_STS_ERROR

2625: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2626: ERROR_HANDLER.Add_Error_Message(
2627: p_message_text => l_msg_data
2628: ,p_application_id => 'EGO'
2629: ,p_message_type => FND_API.G_RET_STS_ERROR
2630: ,p_row_identifier => l_err_reporting_transaction_id
2631: ,p_entity_id => G_ENTITY_ID
2632: ,p_entity_code => G_ENTITY_CODE
2633: ,p_table_name => G_TABLE_NAME

Line 2657: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2653: ,x_msg_data =>l_msg_data
2654: );
2655: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2656:
2657: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2658: ERRBUF := l_msg_data;
2659: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2660: ERROR_HANDLER.Add_Error_Message(
2661: p_message_text => l_msg_data

Line 2659: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2655: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2656:
2657: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2658: ERRBUF := l_msg_data;
2659: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2660: ERROR_HANDLER.Add_Error_Message(
2661: p_message_text => l_msg_data
2662: ,p_application_id => 'EGO'
2663: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2663: ,p_message_type => FND_API.G_RET_STS_ERROR

2659: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2660: ERROR_HANDLER.Add_Error_Message(
2661: p_message_text => l_msg_data
2662: ,p_application_id => 'EGO'
2663: ,p_message_type => FND_API.G_RET_STS_ERROR
2664: ,p_row_identifier => l_err_reporting_transaction_id
2665: ,p_entity_id => G_ENTITY_ID
2666: ,p_entity_code => G_ENTITY_CODE
2667: ,p_table_name => G_TABLE_NAME

Line 2688: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2684: ,x_msg_data =>l_msg_data
2685: );
2686: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2687:
2688: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2689: ERRBUF := l_msg_data;
2690: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2691: ERROR_HANDLER.Add_Error_Message(
2692: p_message_text => l_msg_data

Line 2690: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2686: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
2687:
2688: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2689: ERRBUF := l_msg_data;
2690: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2691: ERROR_HANDLER.Add_Error_Message(
2692: p_message_text => l_msg_data
2693: ,p_application_id => 'EGO'
2694: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2694: ,p_message_type => FND_API.G_RET_STS_ERROR

2690: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2691: ERROR_HANDLER.Add_Error_Message(
2692: p_message_text => l_msg_data
2693: ,p_application_id => 'EGO'
2694: ,p_message_type => FND_API.G_RET_STS_ERROR
2695: ,p_row_identifier => l_err_reporting_transaction_id
2696: ,p_entity_id => G_ENTITY_ID
2697: ,p_entity_code => G_ENTITY_CODE
2698: ,p_table_name => G_TABLE_NAME

Line 2704: END IF; --IF p_validate_only = FND_API.G_FALSE THEN

2700: RAISE G_UNHANDLED_EXCEPTION;
2701: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN
2702: RETCODE := L_CONC_RET_STS_WARNING;
2703: END IF;
2704: END IF; --IF p_validate_only = FND_API.G_FALSE THEN
2705:
2706: ---------------------------------------------------------------------------------------
2707: -- Mark all rows to satus 5 that share the same logical Attribute Group row --
2708: -- with any rows for which the Change Policy is defined as CHANGE_ORDER_REQUIRED --

Line 2772: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

2768: EGO_GTIN_ATTRS_PVT.VALIDATE_INTF_ROWS(
2769: p_data_set_id => p_data_set_id
2770: ,p_entity_id => G_ENTITY_ID
2771: ,p_entity_code => G_ENTITY_CODE
2772: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
2773: ,x_return_status => l_gtinval_ret_code
2774: );
2775: IF (l_gtinval_ret_code = 'U') THEN
2776: RETCODE := L_CONC_RET_STS_ERROR;

Line 2787: IF p_validate_only = FND_API.G_FALSE THEN

2783: ------------------------------------------------
2784: -- Here we call the API in DML only mode for --
2785: -- all the attr group types --
2786: ------------------------------------------------
2787: IF p_validate_only = FND_API.G_FALSE THEN
2788: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
2789: p_api_version => G_API_VERSION --IN NUMBER
2790: ,p_application_id => 431 --IN NUMBER
2791: ,p_attr_group_type => 'EGO_ITEMMGMT_GROUP' --IN VARCHAR2

Line 2800: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

2796: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2797: ,p_entity_index => l_entity_index_counter --IN NUMBER
2798: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2799: ,p_debug_level => p_debug_level --IN NUMBER
2800: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2801: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2802: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2801: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

2797: ,p_entity_index => l_entity_index_counter --IN NUMBER
2798: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2799: ,p_debug_level => p_debug_level --IN NUMBER
2800: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2801: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2802: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2805: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list

Line 2802: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

2798: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2799: ,p_debug_level => p_debug_level --IN NUMBER
2800: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2801: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2802: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2805: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
2806: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list

Line 2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

2799: ,p_debug_level => p_debug_level --IN NUMBER
2800: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2801: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2802: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2805: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
2806: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
2807: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2

Line 2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

2800: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2801: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2802: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2805: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
2806: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
2807: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
2808: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

Line 2818: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2814: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
2815: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
2816: );
2817:
2818: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2819: ERRBUF := l_msg_data;
2820: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2821: RAISE G_UNHANDLED_EXCEPTION;
2822: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 2820: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2816: );
2817:
2818: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2819: ERRBUF := l_msg_data;
2820: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2821: RAISE G_UNHANDLED_EXCEPTION;
2822: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2823: RETCODE := L_CONC_RET_STS_WARNING;
2824: END IF;

Line 2838: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

2834: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2835: ,p_entity_index => l_entity_index_counter --IN NUMBER
2836: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2837: ,p_debug_level => p_debug_level --IN NUMBER
2838: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2839: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2840: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2839: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

2835: ,p_entity_index => l_entity_index_counter --IN NUMBER
2836: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2837: ,p_debug_level => p_debug_level --IN NUMBER
2838: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2839: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2840: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2843: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

Line 2840: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

2836: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2837: ,p_debug_level => p_debug_level --IN NUMBER
2838: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2839: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2840: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2843: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2844: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

Line 2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

2837: ,p_debug_level => p_debug_level --IN NUMBER
2838: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2839: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2840: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2843: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2844: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2845: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2

Line 2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

2838: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2839: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2840: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2843: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2844: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2845: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
2846: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

Line 2856: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2852: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
2853: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
2854: );
2855:
2856: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2857: ERRBUF := l_msg_data;
2858: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2859: RAISE G_UNHANDLED_EXCEPTION;
2860: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 2858: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2854: );
2855:
2856: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2857: ERRBUF := l_msg_data;
2858: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2859: RAISE G_UNHANDLED_EXCEPTION;
2860: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2861: RETCODE := L_CONC_RET_STS_WARNING;
2862: END IF;

Line 2876: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

2872: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2873: ,p_entity_index => l_entity_index_counter --IN NUMBER
2874: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2875: ,p_debug_level => p_debug_level --IN NUMBER
2876: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2877: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2878: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2877: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

2873: ,p_entity_index => l_entity_index_counter --IN NUMBER
2874: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2875: ,p_debug_level => p_debug_level --IN NUMBER
2876: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2877: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2878: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2881: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

Line 2878: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

2874: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2875: ,p_debug_level => p_debug_level --IN NUMBER
2876: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2877: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2878: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2881: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2882: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

Line 2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

2875: ,p_debug_level => p_debug_level --IN NUMBER
2876: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2877: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2878: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2881: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2882: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2883: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2

Line 2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

2876: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2877: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2878: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2881: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2882: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2883: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
2884: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

Line 2894: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2890: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
2891: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
2892: );
2893:
2894: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2895: ERRBUF := l_msg_data;
2896: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2897: RAISE G_UNHANDLED_EXCEPTION;
2898: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 2896: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2892: );
2893:
2894: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2895: ERRBUF := l_msg_data;
2896: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2897: RAISE G_UNHANDLED_EXCEPTION;
2898: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2899: RETCODE := L_CONC_RET_STS_WARNING;
2900: END IF;

Line 2914: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

2910:
2911: EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action ( p_data_set_id => p_data_set_id
2912: ,p_entity_id => G_ENTITY_ID
2913: ,p_entity_code => G_ENTITY_CODE
2914: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
2915: );
2916:
2917:
2918: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);

Line 2921: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN

2917:
2918: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);
2919:
2920:
2921: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
2922: -----------------------------------------------
2923: -- Delete all successful rows from the table --
2924: -- (they're the only rows still in process) --
2925: -----------------------------------------------

Line 2943: END IF; -- IF p_validate_only = FND_API.G...

2939:
2940: IF (p_debug_level > 0) THEN
2941: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Item/Item Revision Concurrent Program', 0);
2942: END IF;
2943: END IF; -- IF p_validate_only = FND_API.G...
2944:
2945: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
2946:
2947: -------------------------------------------------------------------

Line 2945: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

2941: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Item/Item Revision Concurrent Program', 0);
2942: END IF;
2943: END IF; -- IF p_validate_only = FND_API.G...
2944:
2945: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
2946:
2947: -------------------------------------------------------------------
2948: -- Finally, we log any errors that we've accumulated throughout --
2949: -- our conversions and looping (including all errors encountered --

Line 2992: ,p_message_type => FND_API.G_RET_STS_ERROR

2988:
2989: ERROR_HANDLER.Add_Error_Message(
2990: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
2991: ,p_application_id => 'EGO'
2992: ,p_message_type => FND_API.G_RET_STS_ERROR
2993: ,p_row_identifier => l_err_reporting_transaction_id
2994: ,p_entity_id => G_ENTITY_ID
2995: ,p_entity_code => G_ENTITY_CODE
2996: ,p_table_name => G_TABLE_NAME

Line 2999: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

2995: ,p_entity_code => G_ENTITY_CODE
2996: ,p_table_name => G_TABLE_NAME
2997: );
2998:
2999: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3000:
3001: ---------------------------------------------------------------
3002: -- No matter what the error, we want to make sure everything --
3003: -- we've logged gets to the appropriate error locations --

Line 3045: ,p_message_type => FND_API.G_RET_STS_ERROR

3041:
3042: ERROR_HANDLER.Add_Error_Message(
3043: p_message_text => 'Unexpected error in '||G_PKG_NAME||'.Process_Item_User_Attrs_Data: '||SQLERRM
3044: ,p_application_id => 'EGO'
3045: ,p_message_type => FND_API.G_RET_STS_ERROR
3046: ,p_row_identifier => l_err_reporting_transaction_id
3047: ,p_entity_id => G_ENTITY_ID
3048: ,p_entity_code => G_ENTITY_CODE
3049: ,p_table_name => G_TABLE_NAME

Line 3052: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

3048: ,p_entity_code => G_ENTITY_CODE
3049: ,p_table_name => G_TABLE_NAME
3050: );
3051:
3052: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3053:
3054: ---------------------------------------------------------------
3055: -- No matter what the error, we want to make sure everything --
3056: -- we've logged gets to the appropriate error locations --

Line 3095: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

3091: ,p_change_id IN NUMBER
3092: ,p_change_line_id IN NUMBER
3093: ,p_old_revision_id IN NUMBER DEFAULT NULL
3094: ,p_new_revision_id IN NUMBER DEFAULT NULL
3095: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
3096: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3097: ,x_return_status OUT NOCOPY VARCHAR2
3098: ,x_errorcode OUT NOCOPY NUMBER
3099: ,x_msg_count OUT NOCOPY NUMBER

Line 3096: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

3092: ,p_change_line_id IN NUMBER
3093: ,p_old_revision_id IN NUMBER DEFAULT NULL
3094: ,p_new_revision_id IN NUMBER DEFAULT NULL
3095: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
3096: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3097: ,x_return_status OUT NOCOPY VARCHAR2
3098: ,x_errorcode OUT NOCOPY NUMBER
3099: ,x_msg_count OUT NOCOPY NUMBER
3100: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3189: ,p_cleanup_row_identifiers IN VARCHAR2 DEFAULT FND_API.G_TRUE -- T/F

3185: ,p_source_attr_groups_sql IN VARCHAR2
3186: ,p_dest_process_status IN VARCHAR2
3187: ,p_dest_data_set_id IN VARCHAR2
3188: ,p_dest_transaction_type IN VARCHAR2
3189: ,p_cleanup_row_identifiers IN VARCHAR2 DEFAULT FND_API.G_TRUE -- T/F
3190: ,x_return_status OUT NOCOPY VARCHAR2
3191: ,x_msg_count OUT NOCOPY NUMBER
3192: ,x_msg_data OUT NOCOPY VARCHAR2
3193: )

Line 3247: IF FND_API.To_Boolean(p_commit) THEN

3243: BEGIN
3244: SetGlobals();
3245: Debug_Conc_Log('Starting Copy_data_to_Intf');
3246: -- Standard start of API savepoint
3247: IF FND_API.To_Boolean(p_commit) THEN
3248: SAVEPOINT Copy_data_to_Intf_SP;
3249: END IF;
3250:
3251: BEGIN

Line 3305: IF FND_API.to_boolean(p_copy_from_intf_table) THEN

3301: PROG_INT_NUM4,
3302: BUNDLE_ID ) #';
3303:
3304: Debug_Conc_Log('Copy_data_to_Intf: p_copy_from_intf_table='||p_copy_from_intf_table);
3305: IF FND_API.to_boolean(p_copy_from_intf_table) THEN
3306: l_prog_int_char1_value := q'#'FROM_INTF'#';
3307: l_prog_int_num4_value := 2;
3308: l_select_sql := q'#
3309: ( SELECT

Line 3452: ELSE -- FND_API.to_boolean(p_copy_from_intf_table)

3448:
3449: Debug_Conc_Log('Copy_data_to_Intf: l_dynamic_sql='||l_dynamic_sql);
3450: EXECUTE IMMEDIATE l_dynamic_sql;
3451: Debug_Conc_Log('Copy_data_to_Intf: Processed '||SQL%ROWCOUNT||' rows');
3452: ELSE -- FND_API.to_boolean(p_copy_from_intf_table)
3453: l_prog_int_char1_value := q'#'FROM_PROD'#';
3454: l_prog_int_num4_value := 1;
3455: l_attr_group_sql := 'SELECT DISTINCT ATTR_GROUP_ID FROM ( '|| p_source_attr_groups_sql ||' ) ';
3456: OPEN l_dynamic_cursor FOR l_attr_group_sql;

Line 3586: END IF; -- FND_API.to_boolean(p_copy_from_intf_table)

3582: EXECUTE IMMEDIATE l_dynamic_sql;
3583: Debug_Conc_Log('Copy_data_to_Intf: Inserted '||SQL%ROWCOUNT||' rows');
3584: END LOOP; -- attr_group_id LOOP
3585: CLOSE l_dynamic_cursor;
3586: END IF; -- FND_API.to_boolean(p_copy_from_intf_table)
3587:
3588: Debug_Conc_Log('Copy_data_to_Intf: Done inserting');
3589: IF p_dest_process_status = G_PS_IN_PROCESS THEN
3590: UPDATE ego_itm_usr_attr_intrfc

Line 3606: IF p_cleanup_row_identifiers = FND_API.G_TRUE THEN

3602: AND TRANSACTION_TYPE = p_dest_transaction_type
3603: AND PROG_INT_CHAR1 IN ('FROM_INTF', 'FROM_PROD');
3604: END IF;
3605:
3606: IF p_cleanup_row_identifiers = FND_API.G_TRUE THEN
3607: Debug_Conc_Log('Copy_data_to_Intf: Calling Clean_Up_UDA_Row_Idents with process_status='||p_dest_process_status);
3608: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
3609: p_batch_id => p_dest_data_set_id,
3610: p_process_status => p_dest_process_status,

Line 3611: p_ignore_item_num_upd => FND_API.G_TRUE,

3607: Debug_Conc_Log('Copy_data_to_Intf: Calling Clean_Up_UDA_Row_Idents with process_status='||p_dest_process_status);
3608: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
3609: p_batch_id => p_dest_data_set_id,
3610: p_process_status => p_dest_process_status,
3611: p_ignore_item_num_upd => FND_API.G_TRUE,
3612: p_commit => FND_API.G_FALSE );
3613: Debug_Conc_Log('Copy_data_to_Intf: Clean_Up_UDA_Row_Idents Done.');
3614: END IF;
3615: Debug_Conc_Log('Copy_data_to_Intf: Done');

Line 3612: p_commit => FND_API.G_FALSE );

3608: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
3609: p_batch_id => p_dest_data_set_id,
3610: p_process_status => p_dest_process_status,
3611: p_ignore_item_num_upd => FND_API.G_TRUE,
3612: p_commit => FND_API.G_FALSE );
3613: Debug_Conc_Log('Copy_data_to_Intf: Clean_Up_UDA_Row_Idents Done.');
3614: END IF;
3615: Debug_Conc_Log('Copy_data_to_Intf: Done');
3616: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3616: x_return_status := FND_API.G_RET_STS_SUCCESS;

3612: p_commit => FND_API.G_FALSE );
3613: Debug_Conc_Log('Copy_data_to_Intf: Clean_Up_UDA_Row_Idents Done.');
3614: END IF;
3615: Debug_Conc_Log('Copy_data_to_Intf: Done');
3616: x_return_status := FND_API.G_RET_STS_SUCCESS;
3617: EXCEPTION WHEN OTHERS THEN
3618: IF FND_API.To_Boolean(p_commit) THEN
3619: ROLLBACK TO Copy_data_to_Intf_SP;
3620: END IF;

Line 3618: IF FND_API.To_Boolean(p_commit) THEN

3614: END IF;
3615: Debug_Conc_Log('Copy_data_to_Intf: Done');
3616: x_return_status := FND_API.G_RET_STS_SUCCESS;
3617: EXCEPTION WHEN OTHERS THEN
3618: IF FND_API.To_Boolean(p_commit) THEN
3619: ROLLBACK TO Copy_data_to_Intf_SP;
3620: END IF;
3621: IF l_dynamic_cursor%ISOPEN THEN
3622: CLOSE l_dynamic_cursor;

Line 3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3621: IF l_dynamic_cursor%ISOPEN THEN
3622: CLOSE l_dynamic_cursor;
3623: END IF;
3624: Debug_Conc_Log('Copy_data_to_Intf: Error-'||SQLERRM);
3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3626: x_msg_data := SQLERRM;
3627: END Copy_data_to_Intf;
3628:
3629: ----------------------------------------------------------------------