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 EGO_USER_ATTRS_DATA_PVT

Line 749: -- EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Returning because no data exists in interface table to process', 0);

745: AND (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (G_PS_TO_BE_PROCESSED, G_PS_IN_PROCESS, G_PS_STYLE_VARIANT_IN_PROCESS) );
746:
747: IF (l_rec_count = 0) THEN
748: l_return := TRUE; -- Bug 10263673, Set the falg to true, to identify that user didn't provide any values for UDAs.
749: -- EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Returning because no data exists in interface table to process', 0);
750: -- RETURN; -- Bug 10263673, Do not return now only.
751: ELSE
752: l_return := FALSE; -- Bug 10263673, Set the falg to false, to identify that the user has given some UDA values.
753: END IF;

Line 779: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);

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:
781: ---------------------------------------------------
782: -- If we're debugging, we have to set up a Debug --
783: -- session (unless our caller already did so) --

Line 787: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);

783: -- session (unless our caller already did so) --
784: ---------------------------------------------------
785:
786: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
787: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
788: END IF;
789: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item/Item Revision Concurrent Program for data set ID: '||p_data_set_id, 0);
790: END IF;
791: --------------------------------------------------------

Line 789: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item/Item Revision Concurrent Program for data set ID: '||p_data_set_id, 0);

785:
786: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
787: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
788: END IF;
789: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item/Item Revision Concurrent Program for data set ID: '||p_data_set_id, 0);
790: END IF;
791: --------------------------------------------------------
792: -- Related classification query is required for
793: -- User Attributes Bulk Load API

Line 811: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Preparing interface table', 0);

807: -- GETTING THE INTERFACE TABLE READY --
808: --===================================--
809:
810: IF (p_debug_level > 0) THEN
811: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Preparing interface table', 0);
812: END IF;
813:
814: -------------------------------------------------------------------
815: -- Gather statistics: since the data in interface tables changes --

Line 845: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Cannot find object EGO_ITEM in fnd_objects ', 0);

841: WHERE OBJ_NAME = G_ITEM_NAME;
842: EXCEPTION
843: WHEN OTHERS THEN
844: IF (p_debug_level > 0) THEN
845: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Cannot find object EGO_ITEM in fnd_objects ', 0);
846: END IF;
847: G_ITEM_OBJECT_ID := NULL;
848: END;
849:

Line 875: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))

871: ,CREATION_DATE = NVL(CREATION_DATE, SYSDATE)
872: ,LAST_UPDATED_BY = G_USER_ID
873: ,LAST_UPDATE_DATE = SYSDATE
874: ,LAST_UPDATE_LOGIN = G_LOGIN_ID
875: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))
876: WHERE DATA_SET_ID = p_data_set_id
877: AND (PROCESS_STATUS IS NULL OR PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
878:
879: --Fix for Bug:13716796

Line 908: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversions', 0);

904: -- THE FIVE PRELIMINARY CONVERSIONS --
905: --==================================--
906:
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: ----------------------------------------------

Line 917: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Org validation/conversion', 0);

913: -- 1). Validate passed-in Organization IDs --
914: -- and convert passed-in Organization Codes --
915: ----------------------------------------------
916: IF (p_debug_level > 0) THEN
917: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Org validation/conversion', 0);
918: END IF;
919:
920:
921: -----------------------------------------------------------------

Line 969: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item Number validation/conversion', 0);

965: -- 2). Validate passed-in Inventory Item --
966: -- IDs and convert passed-in Item Numbers --
967: --------------------------------------------
968: IF (p_debug_level > 0) THEN
969: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item Number validation/conversion', 0);
970: END IF;
971:
972: ----------------------------------------------------------------------------
973: -- First, verify that all passed-in Inventory Item IDs belong to existing --

Line 1100: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Revision conversion', 0);

1096: -- 3). Validate passed-in Revision IDs --
1097: -- and convert passed-in Revisions --
1098: -----------------------------------------
1099: IF (p_debug_level > 0) THEN
1100: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Revision conversion', 0);
1101: END IF;
1102:
1103: ---------------------------------------------------------------
1104: -- First, verify that all passed-in Revision IDs are valid; --

Line 1225: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Catalog Group ID conversion', 0);

1221: ---------------------------------------------------------
1222: -- 4). Find the Item Catalog Group ID for each Item --
1223: ---------------------------------------------------------
1224: IF (p_debug_level > 0) THEN
1225: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Catalog Group ID conversion', 0);
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

Line 1427: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID validation', 0);

1423: ---------------------------------------------------------
1424: -- Find the Bad Attr Group Id for Attribute Name --
1425: ---------------------------------------------------------
1426: IF (p_debug_level > 0) THEN
1427: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID validation', 0);
1428: END IF;
1429: ----------------------------------------------------------------------------
1430: -- Note: Attribute Internal Name take precidence over Attribute Group Id --
1431: ----------------------------------------------------------------------------

Line 1462: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID conversion', 0);

1458: ---------------------------------------------------------
1459: -- Find the Attr Group Id for Attribute Name --
1460: ---------------------------------------------------------
1461: IF (p_debug_level > 0) THEN
1462: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID conversion', 0);
1463: END IF;
1464: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1465: SET ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1466: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

Line 2057: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all SKU records to error, if trying to update variant value, count='||SQL%ROWCOUNT, 1);

2053: AND ext_prod.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
2054: )
2055: );
2056:
2057: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all SKU records to error, if trying to update variant value, count='||SQL%ROWCOUNT, 1);
2058: END IF;
2059:
2060: --------------------------------------------------------------------------------
2061: -- Mark as errors all rows that share the same logical Attribute Group --

Line 2091: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all SKU records to error, if trying to update inherited attribute value, count='||SQL%ROWCOUNT, 1);

2087: AND msib.STYLE_ITEM_FLAG = 'N'
2088: )
2089: );
2090:
2091: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all SKU records to error, if trying to update inherited attribute value, count='||SQL%ROWCOUNT, 1);
2092:
2093:
2094: ---------------------------------------
2095: -- Set Lifecycle of the revision items.

Line 2210: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Policy conversion/erroring', 0);

2206:
2207:
2208:
2209: IF (p_debug_level > 0) THEN
2210: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Policy conversion/erroring', 0);
2211: END IF;
2212: -------------------------------------------------------------------------------
2213: -- 5). Mark as errors all rows that share the same logical Attribute Group --
2214: -- row with any rows for which the Change Policy is defined as NOT_ALLOWED --

Line 2240: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Style value set processing', 1);

2236: -- We are changing the process_status of all the variant attribute groups --
2237: -- to G_PS_STYLE_VARIANT_IN_PROCESS so that they are not picked up by --
2238: -- UDA bulkloader. --
2239: -------------------------------------------------------------------------------
2240: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Style value set processing', 1);
2241:
2242: -- Fix for bug#9336604
2243: -- Added index hint
2244: UPDATE /*+ index(INTF, EGO_ITM_USR_ATTR_INTRFC_N3 ) */ EGO_ITM_USR_ATTR_INTRFC INTF

Line 2269: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Updated Style records count='||SQL%ROWCOUNT, 1);

2265: AND INTF.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
2266: AND AG_EXT1.APPLICATION_ID = 431 /* Bug 9678667 */
2267: );
2268:
2269: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Updated Style records count='||SQL%ROWCOUNT, 1);
2270:
2271: -------------------------------------------------------------------------------
2272: -- Mark as errors all rows that share the same logical Attribute Group --
2273: -- Associated value set can not be changed if any sku exists for the style --

Line 2287: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Updated records to error where SKU exists for style, count='||SQL%ROWCOUNT, 1);

2283: AND MSIK.STYLE_ITEM_ID = INTF.INVENTORY_ITEM_ID
2284: AND MSIK.ORGANIZATION_ID = INTF.ORGANIZATION_ID
2285: );
2286:
2287: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Updated records to error where SKU exists for style, count='||SQL%ROWCOUNT, 1);
2288:
2289: -------------------------------------------------------------------------------
2290: -- Converting all the value set names entered by user to value set id --
2291: -- Value set name is expected in ATTR_DISP_VALUE column, we convert it to --

Line 2302: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Converted value set name to value set Id for styles, count='||SQL%ROWCOUNT, 1);

2298: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
2299: AND INTF.ATTR_DISP_VALUE IS NOT NULL;
2300:
2301:
2302: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Converted value set name to value set Id for styles, count='||SQL%ROWCOUNT, 1);
2303: --------------------------------------------------------------------------------
2304: -- Mark as errors all rows that share the same logical Attribute Group --
2305: -- If not a valid value set i.e. Only value set associated at attribute level --
2306: -- or its child value set can be associated. --

Line 2330: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked error for invalid value sets, for styles, count='||SQL%ROWCOUNT, 1);

2326: )
2327: )
2328: );
2329:
2330: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked error for invalid value sets, for styles, count='||SQL%ROWCOUNT, 1);
2331:
2332: --------------------------------------------------------------------------------
2333: -- Processing Style variant value sets. Using a merge statement so that bulk --
2334: -- feature can be used --

Line 2387: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Inserted value sets to EGO_STYLE_VARIANT_ATTR_VS, for styles, count='||SQL%ROWCOUNT, 1);

2383: SYSDATE,
2384: l_user_id
2385: );
2386:
2387: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Inserted value sets to EGO_STYLE_VARIANT_ATTR_VS, for styles, count='||SQL%ROWCOUNT, 1);
2388:
2389: ---------------------------------------------------------------------------------
2390: -- Marking all these records as processed --
2391: -- All the records that are in status G_PS_STYLE_VARIANT_IN_PROCESS to success --

Line 2398: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all style records to success, count='||SQL%ROWCOUNT, 1);

2394: SET PROCESS_STATUS = G_PS_SUCCESS
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:

Line 2407: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversion error-reporting', 0);

2403: --========================================--
2404: -- ERROR REPORTING FOR FAILED CONVERSIONS --
2405: --========================================--
2406: IF (p_debug_level > 0) THEN
2407: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversion error-reporting', 0);
2408: END IF;
2409:
2410: -------------------------------------------------------------------------
2411: -- PIM for Telco item uda validations --

Line 2834: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Reported errors with '||l_debug_rowcount||' interface table rows', 0);

2830:
2831: END LOOP;
2832:
2833: IF (p_debug_level > 0) THEN
2834: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Reported errors with '||l_debug_rowcount||' interface table rows', 0);
2835: END IF;
2836:
2837: --=====================================--
2838: -- LOOP PROCESSING OF STILL-VALID ROWS --

Line 2841: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting loop processing of valid rows', 0);

2837: --=====================================--
2838: -- LOOP PROCESSING OF STILL-VALID ROWS --
2839: --=====================================--
2840: IF (p_debug_level > 0) THEN
2841: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting loop processing of valid rows', 0);
2842: END IF;
2843:
2844: ---------------------------------------------------------------
2845: -- ...and then use it to mark as errors all rows in the list --

Line 2930: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' Done Process_Copy_Options_For_UDAs with l_retcode, l_errbuf='||l_retcode||','||l_errbuf, 1);

2926: errbuf => l_errbuf,
2927: p_batch_id => p_data_set_id,
2928: p_copy_options_exist => l_copy_option_exists);
2929:
2930: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' Done Process_Copy_Options_For_UDAs with l_retcode, l_errbuf='||l_retcode||','||l_errbuf, 1);
2931:
2932: IF NVL(l_retcode, '0') > 0 THEN
2933: RETCODE := l_retcode;
2934: ERRBUF := l_errbuf;

Line 2957: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Returning because no data exists in interface table to process', 0);

2953: WHERE DATA_SET_ID = p_data_set_id
2954: AND (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (G_PS_TO_BE_PROCESSED, G_PS_IN_PROCESS, G_PS_STYLE_VARIANT_IN_PROCESS) );
2955:
2956: IF (l_rec_count = 0) THEN
2957: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Returning because no data exists in interface table to process', 0);
2958: RETURN;
2959: END IF;
2960: END IF; -- End of l_return = TRUE -- Bug 10263673
2961: -- Bug 10263673 : End

Line 2966: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting User Attributes Bulk Load', 1);

2962:
2963: -- Call the EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data API instead of
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

Line 3297: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);

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: ---------------------------------------------------------------------
3296:
3297: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);
3298: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3299: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3300: p_api_version =>1.0
3301: ,p_application_id =>431

Line 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);

3307: ,p_commit =>p_commit
3308: ,x_return_status =>l_return_status
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;

Line 3333: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);

3329:
3330:
3331:
3332:
3333: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);
3334: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3335: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3336: p_api_version =>1.0
3337: ,p_application_id =>431

Line 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);

3343: ,p_commit =>p_commit
3344: ,x_return_status =>l_return_status
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;

Line 3366: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);

3362: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN
3363: RETCODE := L_CONC_RET_STS_WARNING;
3364: END IF;
3365:
3366: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);
3367: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3368: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3369: p_api_version =>1.0
3370: ,p_application_id =>431

Line 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);

3376: ,p_commit =>p_commit
3377: ,x_return_status =>l_return_status
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;

Line 3408: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Policy conversion/erroring', 0);

3404: -- the exception to this is rows for pending Items, which we still processed --
3405: -- The user attrs API would not do the DML for these --
3406: ---------------------------------------------------------------------------------------
3407: IF (p_debug_level > 0) THEN
3408: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Policy conversion/erroring', 0);
3409: END IF;
3410:
3411: BEGIN
3412: --------------------------------------------------------------------------------------

Line 3417: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' Add all to Change flag is '||l_add_all_to_cm, 0);

3413: -- Bug#4679902 (If the user wants to have Change Order, Change ALLOWED attributes
3414: -- will also be forced to undergo Change Order)
3415: --------------------------------------------------------------------------------------
3416: l_add_all_to_cm := EGO_IMPORT_PVT.getAddAllToChangeFlag(p_batch_id => p_data_set_id);
3417: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' Add all to Change flag is '||l_add_all_to_cm, 0);
3418: IF( l_add_all_to_cm = 'Y' ) THEN
3419: /*UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
3420: SET UAI.PROCESS_STATUS = G_PS_CHG_POLICY_CO_REQUIRED
3421: WHERE UAI.DATA_SET_ID = p_data_set_id

Line 3502: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Before calling the GTIN validation API', 0);

3498:
3499: ------------------------------------------------------------
3500:
3501:
3502: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Before calling the GTIN validation API', 0);
3503:
3504: EGO_GTIN_ATTRS_PVT.VALIDATE_INTF_ROWS(
3505: p_data_set_id => p_data_set_id
3506: ,p_entity_id => G_ENTITY_ID

Line 3517: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('After calling the GTIN validation API', 0);

3513: ELSIF (l_gtinval_ret_code = 'E') THEN
3514: RETCODE := L_CONC_RET_STS_WARNING;
3515: END IF;
3516:
3517: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('After calling the GTIN validation API', 0);
3518:
3519: ------------------------------------------------
3520: -- Here we call the API in DML only mode for --
3521: -- all the attr group types --

Line 3643: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Completing User Attributes Bulk Load return status is ' || l_user_attrs_return_status, 1);

3639: RETCODE := L_CONC_RET_STS_WARNING;
3640: END IF;
3641: END IF; -- end of IF (l_item_gtin_multi_count > 0) /* Fix for bug#9660659 */
3642:
3643: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Completing User Attributes Bulk Load return status is ' || l_user_attrs_return_status, 1);
3644:
3645: --------------------------------------------------------
3646: -- This takes care of rolling up of GDSN attributes --
3647: -- and registration/publication status. --

Line 3650: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);

3646: -- This takes care of rolling up of GDSN attributes --
3647: -- and registration/publication status. --
3648: --------------------------------------------------------
3649:
3650: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);
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

Line 3659: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);

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);
3660:
3661:
3662: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
3663: -----------------------------------------------

Line 3682: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Item/Item Revision Concurrent Program', 0);

3678: AND PROCESS_STATUS = G_PS_IN_PROCESS;
3679: END IF;
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

Line 3882: EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line(

3878:
3879: -------------------------------------------------------------------------
3880: -- Now we invoke the UserAttrs procedure, passing Item-specific params --
3881: -------------------------------------------------------------------------
3882: EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line(
3883: p_api_version => 1.0
3884: ,p_object_name => G_ITEM_NAME
3885: ,p_production_b_table_name => 'EGO_MTL_SY_ITEMS_EXT_B'
3886: ,p_production_tl_table_name => 'EGO_MTL_SY_ITEMS_EXT_TL'