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: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/

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: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/
413: ,p_is_id_validations_reqd IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Fix for bug#9660659 */

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: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/
413: ,p_is_id_validations_reqd IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Fix for bug#9660659 */
414: ) IS

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: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/
413: ,p_is_id_validations_reqd IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Fix for bug#9660659 */
414: ) IS
415: l_api_name VARCHAR2(30);

Line 412: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/

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: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/
413: ,p_is_id_validations_reqd IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Fix for bug#9660659 */
414: ) IS
415: l_api_name VARCHAR2(30);
416: l_error_message_name VARCHAR2(30);

Line 413: ,p_is_id_validations_reqd IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Fix for bug#9660659 */

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: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/
413: ,p_is_id_validations_reqd IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Fix for bug#9660659 */
414: ) IS
415: l_api_name VARCHAR2(30);
416: l_error_message_name VARCHAR2(30);
417: l_entity_index_counter NUMBER := 0;

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

772: --======================--
773: -- ERROR_HANDLER SET-UP --
774: --======================--
775:
776: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
777:
778: ERROR_HANDLER.Initialize();
779: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
780:

Line 911: IF(p_is_id_validations_reqd = FND_API.G_TRUE) THEN /* Fix for bug#9660659 */

907: IF (p_debug_level > 0) THEN
908: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversions', 0);
909: END IF;
910:
911: IF(p_is_id_validations_reqd = FND_API.G_TRUE) THEN /* Fix for bug#9660659 */
912: ----------------------------------------------
913: -- 1). Validate passed-in Organization IDs --
914: -- and convert passed-in Organization Codes --
915: ----------------------------------------------

Line 961: END IF; /* end of IF(p_is_id_validations_reqd = FND_API.G_TRUE) - Bug 9696621

957: WHERE UAI2.DATA_SET_ID = p_data_set_id
958: AND UAI2.PROCESS_STATUS = G_PS_IN_PROCESS
959: AND UAI2.ORGANIZATION_ID IS NULL);
960:
961: END IF; /* end of IF(p_is_id_validations_reqd = FND_API.G_TRUE) - Bug 9696621
962: ending the IF, so that the item_number/item_id are validated always */
963:
964: --------------------------------------------
965: -- 2). Validate passed-in Inventory Item --

Line 977: IF p_validate_only = FND_API.G_FALSE THEN

973: -- First, verify that all passed-in Inventory Item IDs belong to existing --
974: -- Items; if any row has an invalid Item ID, error it out along with all --
975: -- other rows in its logical Attribute Group row --
976: ----------------------------------------------------------------------------
977: IF p_validate_only = FND_API.G_FALSE THEN
978: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
979: SET UAI.PROCESS_STATUS = G_PS_BAD_ITEM_ID
980: WHERE UAI.DATA_SET_ID = p_data_set_id
981: AND UAI.PROCESS_STATUS IN (G_PS_IN_PROCESS, G_PS_STYLE_VARIANT_IN_PROCESS)

Line 1014: IF p_validate_only = FND_API.G_FALSE THEN

1010: -- (Note that we only convert any Item Number/Org ID --
1011: -- combination once and then set the Item ID we find --
1012: -- to all rows with the same Item Number and Org ID) --
1013: -------------------------------------------------------
1014: IF p_validate_only = FND_API.G_FALSE THEN
1015: UPDATE EGO_ITM_USR_ATTR_INTRFC intrfc
1016: SET INVENTORY_ITEM_ID =
1017: (SELECT INVENTORY_ITEM_ID
1018: FROM MTL_SYSTEM_ITEMS_B_KFV

Line 1094: IF(p_is_id_validations_reqd = FND_API.G_TRUE) THEN /* Fix for bug#9660659 */

1090: WHERE UAI2.DATA_SET_ID = p_data_set_id
1091: AND UAI2.PROCESS_STATUS = G_PS_IN_PROCESS
1092: AND UAI2.INVENTORY_ITEM_ID IS NULL);
1093:
1094: IF(p_is_id_validations_reqd = FND_API.G_TRUE) THEN /* Fix for bug#9660659 */
1095: -----------------------------------------
1096: -- 3). Validate passed-in Revision IDs --
1097: -- and convert passed-in Revisions --
1098: -----------------------------------------

Line 1108: IF p_validate_only = FND_API.G_FALSE THEN

1104: -- First, verify that all passed-in Revision IDs are valid; --
1105: -- if any row has an invalid Revision ID, error it out along --
1106: -- with all other rows in its logical Attribute Group row --
1107: ---------------------------------------------------------------
1108: IF p_validate_only = FND_API.G_FALSE THEN
1109: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1110: SET UAI.PROCESS_STATUS = G_PS_BAD_REVISION_ID
1111: WHERE UAI.DATA_SET_ID = p_data_set_id
1112: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1146: IF p_validate_only = FND_API.G_FALSE THEN

1142: -- Next, convert Revision to Revision ID for those rows where --
1143: -- the user passed in the Revision (note that by "Revision", --
1144: -- we mean the Revision *Code* and not the Revision Label) --
1145: ----------------------------------------------------------------
1146: IF p_validate_only = FND_API.G_FALSE THEN
1147: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1148: SET UAI.REVISION_ID = (SELECT MIR.REVISION_ID
1149: FROM MTL_ITEM_REVISIONS MIR
1150: WHERE MIR.INVENTORY_ITEM_ID = UAI.INVENTORY_ITEM_ID

Line 1219: END IF; -- end of IF(p_is_id_validations_reqd = FND_API.G_TRUE) /* Fix for bug#9660659 */

1215: AND UAI2.PROCESS_STATUS = G_PS_IN_PROCESS
1216: AND UAI2.REVISION IS NOT NULL
1217: AND UAI2.REVISION_ID IS NULL);
1218:
1219: END IF; -- end of IF(p_is_id_validations_reqd = FND_API.G_TRUE) /* Fix for bug#9660659 */
1220:
1221: ---------------------------------------------------------
1222: -- 4). Find the Item Catalog Group ID for each Item --
1223: ---------------------------------------------------------

Line 1230: IF p_validate_only = FND_API.G_FALSE THEN

1226: END IF;
1227:
1228: -- write_records(p_data_set_id => p_data_set_id, p_module => l_api_name, p_message => 'After init');
1229: -- Fix for bug#9660659
1230: IF p_validate_only = FND_API.G_FALSE THEN
1231: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1232: SET (UAI.ITEM_CATALOG_GROUP_ID, UAI.PROG_INT_CHAR1,
1233: UAI.PROG_INT_NUM2, UAI.PROG_INT_NUM3)
1234: = (SELECT NVL(MSI.ITEM_CATALOG_GROUP_ID,-1), NVL(MSI.APPROVAL_STATUS,'A'),

Line 1402: IF (p_is_id_validations_reqd = FND_API.G_TRUE) THEN /* Fix for bug#9660659 */

1398: WHERE UAI2.DATA_SET_ID = p_data_set_id
1399: AND UAI2.PROCESS_STATUS = G_PS_IN_PROCESS
1400: AND UAI2.ITEM_CATALOG_GROUP_ID IS NULL);
1401:
1402: IF (p_is_id_validations_reqd = FND_API.G_TRUE) THEN /* Fix for bug#9660659 */
1403: ---------------------------------------------------------
1404: -- Find the Attr Group Type for Attribute Name --
1405: ---------------------------------------------------------
1406: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI

Line 1484: END IF; -- end of IF(p_is_id_validations_reqd = FND_API.G_TRUE) /* Fix for bug#9660659 */

1480: WHERE UAI.DATA_SET_ID = p_data_set_id
1481: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1482: AND UAI.ATTR_GROUP_ID IS NULL;
1483:
1484: END IF; -- end of IF(p_is_id_validations_reqd = FND_API.G_TRUE) /* Fix for bug#9660659 */
1485: -------------------------------------------------------------------------
1486: -- Erase Revision information for Attr Groups associated at ITEM_LEVEL --
1487: -------------------------------------------------------------------------
1488: /*

Line 1703: IF p_validate_only = FND_API.G_FALSE THEN

1699: ----------------------------------------------------------------
1700: -- Next, validate the Item Supplier attrs. Validate that the --
1701: -- pk1_value exists in ego_item_associations for this item --
1702: ----------------------------------------------------------------
1703: IF p_validate_only = FND_API.G_FALSE THEN
1704: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1705: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER
1706: WHERE uai.DATA_SET_ID = p_data_set_id
1707: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1810: IF p_validate_only = FND_API.G_FALSE THEN

1806: -----------------------------------------------------------------
1807: -- Next, validate the Item Supplier site attrs. Validate that --
1808: -- the pk2_value exists in ego_item_associations for this item --
1809: -----------------------------------------------------------------
1810: IF p_validate_only = FND_API.G_FALSE THEN
1811: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1812: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE
1813: WHERE uai.DATA_SET_ID = p_data_set_id
1814: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1922: IF p_validate_only = FND_API.G_FALSE THEN

1918: -- Next, validate the Item Supplier site Org attrs. Validate --
1919: -- that the pk1,pk2_value along with the organization_id exists --
1920: -- in ego_item_associations for this item --
1921: ------------------------------------------------------------------
1922: IF p_validate_only = FND_API.G_FALSE THEN
1923: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1924: SET uai.PROCESS_STATUS = G_PS_BAD_SUPPLIER_SITE_ORG
1925: WHERE uai.DATA_SET_ID = p_data_set_id
1926: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 2032: IF p_validate_only = FND_API.G_TRUE THEN

2028: --------------------------------------------------------------------------------
2029: -- Mark as errors all rows that share the same logical Attribute Group --
2030: -- Variant attribute values for existing SKUs can not be updated --
2031: --------------------------------------------------------------------------------
2032: IF p_validate_only = FND_API.G_TRUE THEN
2033: UPDATE EGO_ITM_USR_ATTR_INTRFC
2034: SET PROCESS_STATUS = G_PS_SKU_VAR_VALUE_NOT_UPD
2035: WHERE DATA_SET_ID = p_data_set_id
2036: AND PROCESS_STATUS = G_PS_IN_PROCESS

Line 2097: IF p_validate_only = FND_API.G_FALSE THEN

2093:
2094: ---------------------------------------
2095: -- Set Lifecycle of the revision items.
2096: ---------------------------------------
2097: IF p_validate_only = FND_API.G_FALSE THEN
2098: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
2099: SET (UAI.PROG_INT_NUM3)
2100: = NVL((SELECT MIR.CURRENT_PHASE_ID
2101: FROM MTL_ITEM_REVISIONS MIR

Line 2336: IF p_validate_only = FND_API.G_FALSE THEN

2332: --------------------------------------------------------------------------------
2333: -- Processing Style variant value sets. Using a merge statement so that bulk --
2334: -- feature can be used --
2335: --------------------------------------------------------------------------------
2336: IF p_validate_only = FND_API.G_FALSE THEN
2337: MERGE INTO EGO_STYLE_VARIANT_ATTR_VS ESVAV
2338: USING (SELECT
2339: INTF.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID,
2340: INTF.ATTR_VALUE_NUM AS VALUE_SET_ID,

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

2395: WHERE DATA_SET_ID = p_data_set_id
2396: AND PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS;
2397:
2398: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all style records to success, count='||SQL%ROWCOUNT, 1);
2399: END IF; --IF p_validate_only = FND_API.G_FALSE THEN
2400:
2401:
2402:
2403: --========================================--

Line 2501: l_item_return_status := FND_API.G_RET_STS_ERROR;

2497:
2498: l_token_table(1).TOKEN_NAME := 'ATTR_GROUP_NAME';
2499: l_token_table(1).TOKEN_VALUE := l_error_attr_group_name;
2500: l_error_message_name := l_error_message;
2501: l_item_return_status := FND_API.G_RET_STS_ERROR;
2502: ERROR_HANDLER.Add_Error_Message(
2503: p_message_name => l_error_message_name
2504: ,p_application_id => 'EGO'
2505: ,p_token_tbl => l_token_table

Line 2506: ,p_message_type => FND_API.G_RET_STS_ERROR

2502: ERROR_HANDLER.Add_Error_Message(
2503: p_message_name => l_error_message_name
2504: ,p_application_id => 'EGO'
2505: ,p_token_tbl => l_token_table
2506: ,p_message_type => FND_API.G_RET_STS_ERROR
2507: ,p_row_identifier => l_error_row_identifier
2508: ,p_entity_id => G_ENTITY_ID
2509: ,p_entity_code => G_ENTITY_CODE
2510: ,p_table_name => G_TABLE_NAME

Line 2818: l_item_return_status := FND_API.G_RET_STS_ERROR;

2814: l_token_table(6).TOKEN_VALUE := error_rec.REVISION;
2815: END IF;
2816: END IF;
2817:
2818: l_item_return_status := FND_API.G_RET_STS_ERROR;
2819: ERROR_HANDLER.Add_Error_Message(
2820: p_message_name => l_error_message_name
2821: ,p_application_id => 'EGO'
2822: ,p_token_tbl => l_token_table

Line 2823: ,p_message_type => FND_API.G_RET_STS_ERROR

2819: ERROR_HANDLER.Add_Error_Message(
2820: p_message_name => l_error_message_name
2821: ,p_application_id => 'EGO'
2822: ,p_token_tbl => l_token_table
2823: ,p_message_type => FND_API.G_RET_STS_ERROR
2824: ,p_row_identifier => error_rec.TRANSACTION_ID
2825: ,p_entity_id => G_ENTITY_ID
2826: ,p_entity_code => G_ENTITY_CODE
2827: ,p_table_name => G_TABLE_NAME

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

2964: -- EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
2965:
2966: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting User Attributes Bulk Load', 1);
2967:
2968: IF p_validate_only = FND_API.G_TRUE AND p_ignore_security_for_validate = FND_API.G_FALSE THEN
2969: l_privilege_predicate_api_name := 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate';
2970: ELSE
2971: l_privilege_predicate_api_name := NULL;
2972: END IF;

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

3036: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3037: ,p_entity_index => l_entity_index_counter --IN NUMBER
3038: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3039: ,p_debug_level => p_debug_level --IN NUMBER
3040: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3041: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3042: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3043: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3044: ,p_commit => p_commit -- FND_API.G_TRUE --IN VARCHAR2/* Added to fix Bug#7422423*/

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

3037: ,p_entity_index => l_entity_index_counter --IN NUMBER
3038: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3039: ,p_debug_level => p_debug_level --IN NUMBER
3040: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3041: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3042: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3043: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3044: ,p_commit => p_commit -- FND_API.G_TRUE --IN VARCHAR2/* Added to fix Bug#7422423*/
3045: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list

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

3038: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3039: ,p_debug_level => p_debug_level --IN NUMBER
3040: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3041: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3042: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3043: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3044: ,p_commit => p_commit -- FND_API.G_TRUE --IN VARCHAR2/* Added to fix Bug#7422423*/
3045: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
3046: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list

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

3039: ,p_debug_level => p_debug_level --IN NUMBER
3040: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3041: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3042: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3043: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3044: ,p_commit => p_commit -- FND_API.G_TRUE --IN VARCHAR2/* Added to fix Bug#7422423*/
3045: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
3046: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
3047: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2

Line 3044: ,p_commit => p_commit -- FND_API.G_TRUE --IN VARCHAR2/* Added to fix Bug#7422423*/

3040: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3041: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3042: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3043: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3044: ,p_commit => p_commit -- FND_API.G_TRUE --IN VARCHAR2/* Added to fix Bug#7422423*/
3045: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
3046: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
3047: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2
3048: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

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

3054: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
3055: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
3056: );
3057:
3058: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3059: ERRBUF := l_msg_data;
3060: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3061: RAISE G_UNHANDLED_EXCEPTION;
3062: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 3060: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3056: );
3057:
3058: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3059: ERRBUF := l_msg_data;
3060: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3061: RAISE G_UNHANDLED_EXCEPTION;
3062: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
3063: RETCODE := L_CONC_RET_STS_WARNING;
3064: END IF;

Line 3155: ,p_message_type => FND_API.G_RET_STS_ERROR

3151: ERROR_HANDLER.Add_Error_Message(
3152: p_message_name => l_error_message_name
3153: ,p_application_id => 'EGO'
3154: ,p_token_tbl => l_token_table
3155: ,p_message_type => FND_API.G_RET_STS_ERROR
3156: ,p_row_identifier => i.TRANSACTION_ID
3157: ,p_entity_id => G_ENTITY_ID
3158: ,p_entity_code => G_ENTITY_CODE
3159: ,p_table_name => G_TABLE_NAME

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

3203: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3204: ,p_entity_index => l_entity_index_counter --IN NUMBER
3205: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3206: ,p_debug_level => p_debug_level --IN NUMBER
3207: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3208: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3209: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3210: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3211: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

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

3204: ,p_entity_index => l_entity_index_counter --IN NUMBER
3205: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3206: ,p_debug_level => p_debug_level --IN NUMBER
3207: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3208: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3209: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3210: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3211: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3212: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

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

3205: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3206: ,p_debug_level => p_debug_level --IN NUMBER
3207: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3208: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3209: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3210: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3211: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3212: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3213: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

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

3206: ,p_debug_level => p_debug_level --IN NUMBER
3207: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3208: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3209: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3210: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3211: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3212: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3213: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3214: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2

Line 3211: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

3207: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3208: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3209: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3210: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3211: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3212: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3213: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3214: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2
3215: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

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

3221: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
3222: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
3223: );
3224:
3225: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3226: ERRBUF := l_msg_data;
3227: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3228: RAISE G_UNHANDLED_EXCEPTION;
3229: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 3227: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3223: );
3224:
3225: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3226: ERRBUF := l_msg_data;
3227: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3228: RAISE G_UNHANDLED_EXCEPTION;
3229: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
3230: RETCODE := L_CONC_RET_STS_WARNING;
3231: END IF;

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

3259: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3260: ,p_entity_index => l_entity_index_counter --IN NUMBER
3261: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3262: ,p_debug_level => p_debug_level --IN NUMBER
3263: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3264: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3265: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3266: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3267: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

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

3260: ,p_entity_index => l_entity_index_counter --IN NUMBER
3261: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3262: ,p_debug_level => p_debug_level --IN NUMBER
3263: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3264: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3265: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3266: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3267: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3268: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

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

3261: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3262: ,p_debug_level => p_debug_level --IN NUMBER
3263: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3264: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3265: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3266: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3267: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3268: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3269: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

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

3262: ,p_debug_level => p_debug_level --IN NUMBER
3263: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3264: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3265: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3266: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3267: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3268: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3269: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3270: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2

Line 3267: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

3263: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3264: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3265: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3266: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3267: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3268: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3269: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3270: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name --IN VARCHAR2
3271: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

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

3277: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
3278: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
3279: );
3280:
3281: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3282: ERRBUF := l_msg_data;
3283: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3284: RAISE G_UNHANDLED_EXCEPTION;
3285: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 3283: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3279: );
3280:
3281: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3282: ERRBUF := l_msg_data;
3283: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3284: RAISE G_UNHANDLED_EXCEPTION;
3285: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
3286: RETCODE := L_CONC_RET_STS_WARNING;
3287: END IF;

Line 3291: IF p_validate_only = FND_API.G_FALSE THEN

3287: END IF;
3288: END IF; -- end of IF (l_item_gtin_multi_count > 0) /* Fix for bug#9660659 */
3289:
3290:
3291: IF p_validate_only = FND_API.G_FALSE THEN
3292: ---------------------------------------------------------------------
3293: -- Calling the API to Mark all such rows which have the same data --
3294: -- as we have for the attribute in the production tables. --
3295: ---------------------------------------------------------------------

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

3309: ,x_msg_data =>l_msg_data
3310: );
3311: 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);
3312:
3313: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3314: ERRBUF := l_msg_data;
3315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3316: ERROR_HANDLER.Add_Error_Message(
3317: p_message_text => l_msg_data

Line 3315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3311: 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);
3312:
3313: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3314: ERRBUF := l_msg_data;
3315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3316: ERROR_HANDLER.Add_Error_Message(
3317: p_message_text => l_msg_data
3318: ,p_application_id => 'EGO'
3319: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 3319: ,p_message_type => FND_API.G_RET_STS_ERROR

3315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3316: ERROR_HANDLER.Add_Error_Message(
3317: p_message_text => l_msg_data
3318: ,p_application_id => 'EGO'
3319: ,p_message_type => FND_API.G_RET_STS_ERROR
3320: ,p_row_identifier => l_err_reporting_transaction_id
3321: ,p_entity_id => G_ENTITY_ID
3322: ,p_entity_code => G_ENTITY_CODE
3323: ,p_table_name => G_TABLE_NAME

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

3345: ,x_msg_data =>l_msg_data
3346: );
3347: 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);
3348:
3349: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3350: ERRBUF := l_msg_data;
3351: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3352: ERROR_HANDLER.Add_Error_Message(
3353: p_message_text => l_msg_data

Line 3351: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3347: 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);
3348:
3349: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3350: ERRBUF := l_msg_data;
3351: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3352: ERROR_HANDLER.Add_Error_Message(
3353: p_message_text => l_msg_data
3354: ,p_application_id => 'EGO'
3355: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 3355: ,p_message_type => FND_API.G_RET_STS_ERROR

3351: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3352: ERROR_HANDLER.Add_Error_Message(
3353: p_message_text => l_msg_data
3354: ,p_application_id => 'EGO'
3355: ,p_message_type => FND_API.G_RET_STS_ERROR
3356: ,p_row_identifier => l_err_reporting_transaction_id
3357: ,p_entity_id => G_ENTITY_ID
3358: ,p_entity_code => G_ENTITY_CODE
3359: ,p_table_name => G_TABLE_NAME

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

3378: ,x_msg_data =>l_msg_data
3379: );
3380: 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);
3381:
3382: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3383: ERRBUF := l_msg_data;
3384: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3385: ERROR_HANDLER.Add_Error_Message(
3386: p_message_text => l_msg_data

Line 3384: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3380: 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);
3381:
3382: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3383: ERRBUF := l_msg_data;
3384: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3385: ERROR_HANDLER.Add_Error_Message(
3386: p_message_text => l_msg_data
3387: ,p_application_id => 'EGO'
3388: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 3388: ,p_message_type => FND_API.G_RET_STS_ERROR

3384: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3385: ERROR_HANDLER.Add_Error_Message(
3386: p_message_text => l_msg_data
3387: ,p_application_id => 'EGO'
3388: ,p_message_type => FND_API.G_RET_STS_ERROR
3389: ,p_row_identifier => l_err_reporting_transaction_id
3390: ,p_entity_id => G_ENTITY_ID
3391: ,p_entity_code => G_ENTITY_CODE
3392: ,p_table_name => G_TABLE_NAME

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

3394: RAISE G_UNHANDLED_EXCEPTION;
3395: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN
3396: RETCODE := L_CONC_RET_STS_WARNING;
3397: END IF;
3398: END IF; --IF p_validate_only = FND_API.G_FALSE THEN
3399:
3400: ---------------------------------------------------------------------------------------
3401: -- Mark all rows to satus 5 that share the same logical Attribute Group row --
3402: -- with any rows for which the Change Policy is defined as CHANGE_ORDER_REQUIRED --

Line 3508: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

3504: EGO_GTIN_ATTRS_PVT.VALIDATE_INTF_ROWS(
3505: p_data_set_id => p_data_set_id
3506: ,p_entity_id => G_ENTITY_ID
3507: ,p_entity_code => G_ENTITY_CODE
3508: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
3509: ,x_return_status => l_gtinval_ret_code
3510: );
3511: IF (l_gtinval_ret_code = 'U') THEN
3512: RETCODE := L_CONC_RET_STS_ERROR;

Line 3523: IF p_validate_only = FND_API.G_FALSE THEN

3519: ------------------------------------------------
3520: -- Here we call the API in DML only mode for --
3521: -- all the attr group types --
3522: ------------------------------------------------
3523: IF p_validate_only = FND_API.G_FALSE THEN
3524: IF(l_item_mgmt_count > 0) THEN -- Bug 13434831 /* Fix for bug#9660659 */
3525: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
3526: p_api_version => G_API_VERSION --IN NUMBER
3527: ,p_application_id => 431 --IN NUMBER

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

3533: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3534: ,p_entity_index => l_entity_index_counter --IN NUMBER
3535: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3536: ,p_debug_level => p_debug_level --IN NUMBER
3537: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3538: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3539: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3540: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

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

3534: ,p_entity_index => l_entity_index_counter --IN NUMBER
3535: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3536: ,p_debug_level => p_debug_level --IN NUMBER
3537: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3538: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3539: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3540: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3542: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list

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

3535: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3536: ,p_debug_level => p_debug_level --IN NUMBER
3537: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3538: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3539: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3540: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3542: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
3543: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list

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

3536: ,p_debug_level => p_debug_level --IN NUMBER
3537: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3538: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3539: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3540: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3542: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
3543: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
3544: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2

Line 3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

3537: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3538: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3539: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3540: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3542: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
3543: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
3544: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
3545: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

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

3550: ,x_errorcode => l_errorcode --OUT NOCOPY NUMBER
3551: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
3552: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
3553: );
3554: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3555: ERRBUF := l_msg_data;
3556: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3557: RAISE G_UNHANDLED_EXCEPTION;
3558: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 3556: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3552: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
3553: );
3554: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3555: ERRBUF := l_msg_data;
3556: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3557: RAISE G_UNHANDLED_EXCEPTION;
3558: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
3559: RETCODE := L_CONC_RET_STS_WARNING;
3560: END IF;

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

3572: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3573: ,p_entity_index => l_entity_index_counter --IN NUMBER
3574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3575: ,p_debug_level => p_debug_level --IN NUMBER
3576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

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

3573: ,p_entity_index => l_entity_index_counter --IN NUMBER
3574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3575: ,p_debug_level => p_debug_level --IN NUMBER
3576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

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

3574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3575: ,p_debug_level => p_debug_level --IN NUMBER
3576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3582: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

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

3575: ,p_debug_level => p_debug_level --IN NUMBER
3576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3582: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3583: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2

Line 3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

3576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3582: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3583: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
3584: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

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

3590: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
3591: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
3592: );
3593:
3594: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3595: ERRBUF := l_msg_data;
3596: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3597: RAISE G_UNHANDLED_EXCEPTION;
3598: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 3596: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3592: );
3593:
3594: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3595: ERRBUF := l_msg_data;
3596: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3597: RAISE G_UNHANDLED_EXCEPTION;
3598: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
3599: RETCODE := L_CONC_RET_STS_WARNING;
3600: END IF;

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

3612: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3613: ,p_entity_index => l_entity_index_counter --IN NUMBER
3614: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3615: ,p_debug_level => p_debug_level --IN NUMBER
3616: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3617: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3618: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3619: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

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

3613: ,p_entity_index => l_entity_index_counter --IN NUMBER
3614: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3615: ,p_debug_level => p_debug_level --IN NUMBER
3616: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3617: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3618: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3619: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3621: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2

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

3614: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3615: ,p_debug_level => p_debug_level --IN NUMBER
3616: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3617: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3618: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3619: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3621: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3622: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2

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

3615: ,p_debug_level => p_debug_level --IN NUMBER
3616: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3617: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3618: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3619: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3621: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3622: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3623: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2

Line 3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

3616: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3617: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3618: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3619: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3621: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3622: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3623: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
3624: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2

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

3630: ,x_msg_count => l_msg_count --OUT NOCOPY NUMBER
3631: ,x_msg_data => l_msg_data --OUT NOCOPY VARCHAR2
3632: );
3633:
3634: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3635: ERRBUF := l_msg_data;
3636: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3637: RAISE G_UNHANDLED_EXCEPTION;
3638: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN

Line 3636: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

3632: );
3633:
3634: IF (l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3635: ERRBUF := l_msg_data;
3636: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3637: RAISE G_UNHANDLED_EXCEPTION;
3638: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
3639: RETCODE := L_CONC_RET_STS_WARNING;
3640: END IF;

Line 3655: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

3651:
3652: EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action ( p_data_set_id => p_data_set_id
3653: ,p_entity_id => G_ENTITY_ID
3654: ,p_entity_code => G_ENTITY_CODE
3655: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
3656: );
3657:
3658:
3659: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);

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

3658:
3659: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);
3660:
3661:
3662: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
3663: -----------------------------------------------
3664: -- Delete all successful rows from the table --
3665: -- (they're the only rows still in process) --
3666: -----------------------------------------------

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

3680:
3681: IF (p_debug_level > 0) THEN
3682: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Item/Item Revision Concurrent Program', 0);
3683: END IF;
3684: END IF; -- IF p_validate_only = FND_API.G...
3685:
3686: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3687:
3688: -------------------------------------------------------------------

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

3682: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Item/Item Revision Concurrent Program', 0);
3683: END IF;
3684: END IF; -- IF p_validate_only = FND_API.G...
3685:
3686: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3687:
3688: -------------------------------------------------------------------
3689: -- Finally, we log any errors that we've accumulated throughout --
3690: -- our conversions and looping (including all errors encountered --

Line 3703: IF FND_API.To_Boolean( p_commit ) THEN /* Added to fix Bug#7422423*/

3699: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3700: ERROR_HANDLER.Close_Debug_Session();
3701: END IF;
3702: END IF;
3703: IF FND_API.To_Boolean( p_commit ) THEN /* Added to fix Bug#7422423*/
3704: COMMIT WORK;
3705: END IF;
3706: EXCEPTION
3707: WHEN G_NO_USER_NAME_TO_VALIDATE THEN

Line 3734: ,p_message_type => FND_API.G_RET_STS_ERROR

3730:
3731: ERROR_HANDLER.Add_Error_Message(
3732: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
3733: ,p_application_id => 'EGO'
3734: ,p_message_type => FND_API.G_RET_STS_ERROR
3735: ,p_row_identifier => l_err_reporting_transaction_id
3736: ,p_entity_id => G_ENTITY_ID
3737: ,p_entity_code => G_ENTITY_CODE
3738: ,p_table_name => G_TABLE_NAME

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

3737: ,p_entity_code => G_ENTITY_CODE
3738: ,p_table_name => G_TABLE_NAME
3739: );
3740:
3741: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3742:
3743: ---------------------------------------------------------------
3744: -- No matter what the error, we want to make sure everything --
3745: -- we've logged gets to the appropriate error locations --

Line 3787: ,p_message_type => FND_API.G_RET_STS_ERROR

3783:
3784: ERROR_HANDLER.Add_Error_Message(
3785: p_message_text => 'Unexpected error in '||G_PKG_NAME||'.Process_Item_User_Attrs_Data: '||SQLERRM
3786: ,p_application_id => 'EGO'
3787: ,p_message_type => FND_API.G_RET_STS_ERROR
3788: ,p_row_identifier => l_err_reporting_transaction_id
3789: ,p_entity_id => G_ENTITY_ID
3790: ,p_entity_code => G_ENTITY_CODE
3791: ,p_table_name => G_TABLE_NAME

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

3790: ,p_entity_code => G_ENTITY_CODE
3791: ,p_table_name => G_TABLE_NAME
3792: );
3793:
3794: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3795:
3796: ---------------------------------------------------------------
3797: -- No matter what the error, we want to make sure everything --
3798: -- we've logged gets to the appropriate error locations --

Line 3837: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

3833: ,p_change_id IN NUMBER
3834: ,p_change_line_id IN NUMBER
3835: ,p_old_revision_id IN NUMBER DEFAULT NULL
3836: ,p_new_revision_id IN NUMBER DEFAULT NULL
3837: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
3838: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3839: ,x_return_status OUT NOCOPY VARCHAR2
3840: ,x_errorcode OUT NOCOPY NUMBER
3841: ,x_msg_count OUT NOCOPY NUMBER

Line 3838: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

3834: ,p_change_line_id IN NUMBER
3835: ,p_old_revision_id IN NUMBER DEFAULT NULL
3836: ,p_new_revision_id IN NUMBER DEFAULT NULL
3837: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
3838: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3839: ,x_return_status OUT NOCOPY VARCHAR2
3840: ,x_errorcode OUT NOCOPY NUMBER
3841: ,x_msg_count OUT NOCOPY NUMBER
3842: ,x_msg_data OUT NOCOPY VARCHAR2

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

3927: ,p_source_attr_groups_sql IN VARCHAR2
3928: ,p_dest_process_status IN VARCHAR2
3929: ,p_dest_data_set_id IN VARCHAR2
3930: ,p_dest_transaction_type IN VARCHAR2
3931: ,p_cleanup_row_identifiers IN VARCHAR2 DEFAULT FND_API.G_TRUE -- T/F
3932: ,x_return_status OUT NOCOPY VARCHAR2
3933: ,x_msg_count OUT NOCOPY NUMBER
3934: ,x_msg_data OUT NOCOPY VARCHAR2
3935: )

Line 3995: IF FND_API.To_Boolean(p_commit) THEN

3991: BEGIN
3992: SetGlobals();
3993: Debug_Conc_Log('Starting Copy_data_to_Intf');
3994: -- Standard start of API savepoint
3995: IF FND_API.To_Boolean(p_commit) THEN
3996: SAVEPOINT Copy_data_to_Intf_SP;
3997: END IF;
3998:
3999: BEGIN

Line 4053: IF FND_API.to_boolean(p_copy_from_intf_table) THEN

4049: PROG_INT_NUM4,
4050: BUNDLE_ID ) #';
4051:
4052: Debug_Conc_Log('Copy_data_to_Intf: p_copy_from_intf_table='||p_copy_from_intf_table);
4053: IF FND_API.to_boolean(p_copy_from_intf_table) THEN
4054: l_prog_int_char1_value := q'#'FROM_INTF'#';
4055: l_prog_int_num4_value := 2;
4056: l_select_sql := q'#
4057: ( SELECT

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

4196:
4197: Debug_Conc_Log('Copy_data_to_Intf: l_dynamic_sql='||l_dynamic_sql);
4198: EXECUTE IMMEDIATE l_dynamic_sql;
4199: Debug_Conc_Log('Copy_data_to_Intf: Processed '||SQL%ROWCOUNT||' rows');
4200: ELSE -- FND_API.to_boolean(p_copy_from_intf_table)
4201: l_prog_int_char1_value := q'#'FROM_PROD'#';
4202: l_prog_int_num4_value := 1;
4203: l_attr_group_sql := 'SELECT DISTINCT ATTR_GROUP_ID FROM ( '|| p_source_attr_groups_sql ||' ) ';
4204: OPEN l_dynamic_cursor FOR l_attr_group_sql;

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

4346: EXECUTE IMMEDIATE l_dynamic_sql;
4347: Debug_Conc_Log('Copy_data_to_Intf: Inserted '||SQL%ROWCOUNT||' rows');
4348: END LOOP; -- attr_group_id LOOP
4349: CLOSE l_dynamic_cursor;
4350: END IF; -- FND_API.to_boolean(p_copy_from_intf_table)
4351:
4352: Debug_Conc_Log('Copy_data_to_Intf: Done inserting');
4353:
4354: /* Fix for bug#9678667 - Start: Commenting the below code - the below code should be done after this api call */

Line 4374: IF p_cleanup_row_identifiers = FND_API.G_TRUE THEN

4370: AND PROG_INT_CHAR1 IN ('FROM_INTF', 'FROM_PROD');
4371: END IF;
4372: */ /* Fix for bug#9678667 : End */
4373:
4374: IF p_cleanup_row_identifiers = FND_API.G_TRUE THEN
4375: Debug_Conc_Log('Copy_data_to_Intf: Calling Clean_Up_UDA_Row_Idents with process_status='||p_dest_process_status);
4376: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
4377: p_batch_id => p_dest_data_set_id,
4378: p_process_status => p_dest_process_status,

Line 4379: p_ignore_item_num_upd => FND_API.G_TRUE,

4375: Debug_Conc_Log('Copy_data_to_Intf: Calling Clean_Up_UDA_Row_Idents with process_status='||p_dest_process_status);
4376: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
4377: p_batch_id => p_dest_data_set_id,
4378: p_process_status => p_dest_process_status,
4379: p_ignore_item_num_upd => FND_API.G_TRUE,
4380: p_commit => FND_API.G_FALSE );
4381: Debug_Conc_Log('Copy_data_to_Intf: Clean_Up_UDA_Row_Idents Done.');
4382: END IF;
4383: Debug_Conc_Log('Copy_data_to_Intf: Done');

Line 4380: p_commit => FND_API.G_FALSE );

4376: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
4377: p_batch_id => p_dest_data_set_id,
4378: p_process_status => p_dest_process_status,
4379: p_ignore_item_num_upd => FND_API.G_TRUE,
4380: p_commit => FND_API.G_FALSE );
4381: Debug_Conc_Log('Copy_data_to_Intf: Clean_Up_UDA_Row_Idents Done.');
4382: END IF;
4383: Debug_Conc_Log('Copy_data_to_Intf: Done');
4384: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4384: x_return_status := FND_API.G_RET_STS_SUCCESS;

4380: p_commit => FND_API.G_FALSE );
4381: Debug_Conc_Log('Copy_data_to_Intf: Clean_Up_UDA_Row_Idents Done.');
4382: END IF;
4383: Debug_Conc_Log('Copy_data_to_Intf: Done');
4384: x_return_status := FND_API.G_RET_STS_SUCCESS;
4385: EXCEPTION WHEN OTHERS THEN
4386: IF FND_API.To_Boolean(p_commit) THEN
4387: ROLLBACK TO Copy_data_to_Intf_SP;
4388: END IF;

Line 4386: IF FND_API.To_Boolean(p_commit) THEN

4382: END IF;
4383: Debug_Conc_Log('Copy_data_to_Intf: Done');
4384: x_return_status := FND_API.G_RET_STS_SUCCESS;
4385: EXCEPTION WHEN OTHERS THEN
4386: IF FND_API.To_Boolean(p_commit) THEN
4387: ROLLBACK TO Copy_data_to_Intf_SP;
4388: END IF;
4389: IF l_dynamic_cursor%ISOPEN THEN
4390: CLOSE l_dynamic_cursor;

Line 4393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4389: IF l_dynamic_cursor%ISOPEN THEN
4390: CLOSE l_dynamic_cursor;
4391: END IF;
4392: Debug_Conc_Log('Copy_data_to_Intf: Error-'||SQLERRM);
4393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4394: x_msg_data := SQLERRM;
4395: END Copy_data_to_Intf;
4396:
4397: ----------------------------------------------------------------------