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 625: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Returning because no data exists in interface table to process', 0);

621: WHERE DATA_SET_ID = p_data_set_id
622: AND (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (G_PS_TO_BE_PROCESSED, G_PS_IN_PROCESS, G_PS_STYLE_VARIANT_IN_PROCESS) );
623:
624: IF (l_rec_count = 0) THEN
625: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Returning because no data exists in interface table to process', 0);
626: RETURN;
627: END IF;
628:
629: l_attr_group_type := 'EGO_ITEMMGMT_GROUP';

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

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

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

655: -- session (unless our caller already did so) --
656: ---------------------------------------------------
657:
658: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
659: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
660: END IF;
661: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item/Item Revision Concurrent Program for data set ID: '||p_data_set_id, 0);
662: END IF;
663: --------------------------------------------------------

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

657:
658: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
659: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
660: END IF;
661: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item/Item Revision Concurrent Program for data set ID: '||p_data_set_id, 0);
662: END IF;
663: --------------------------------------------------------
664: -- Related classification query is required for
665: -- User Attributes Bulk Load API

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

679: -- GETTING THE INTERFACE TABLE READY --
680: --===================================--
681:
682: IF (p_debug_level > 0) THEN
683: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Preparing interface table', 0);
684: END IF;
685:
686: -------------------------------------------------------------------
687: -- Gather statistics: since the data in interface tables changes --

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

713: WHERE OBJ_NAME = G_ITEM_NAME;
714: EXCEPTION
715: WHEN OTHERS THEN
716: IF (p_debug_level > 0) THEN
717: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Cannot find object EGO_ITEM in fnd_objects ', 0);
718: END IF;
719: G_ITEM_OBJECT_ID := NULL;
720: END;
721: ---------------------------------------------------------------------

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

741: ,CREATION_DATE = NVL(CREATION_DATE, SYSDATE)
742: ,LAST_UPDATED_BY = G_USER_ID
743: ,LAST_UPDATE_DATE = SYSDATE
744: ,LAST_UPDATE_LOGIN = G_LOGIN_ID
745: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))
746: WHERE DATA_SET_ID = p_data_set_id
747: AND (PROCESS_STATUS IS NULL OR PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
748:
749: --==================================--

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

750: -- THE FIVE PRELIMINARY CONVERSIONS --
751: --==================================--
752:
753: IF (p_debug_level > 0) THEN
754: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversions', 0);
755: END IF;
756:
757: ----------------------------------------------
758: -- 1). Validate passed-in Organization IDs --

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

758: -- 1). Validate passed-in Organization IDs --
759: -- and convert passed-in Organization Codes --
760: ----------------------------------------------
761: IF (p_debug_level > 0) THEN
762: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Org validation/conversion', 0);
763: END IF;
764:
765:
766: -----------------------------------------------------------------

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

807: -- 2). Validate passed-in Inventory Item --
808: -- IDs and convert passed-in Item Numbers --
809: --------------------------------------------
810: IF (p_debug_level > 0) THEN
811: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item Number validation/conversion', 0);
812: END IF;
813:
814: ----------------------------------------------------------------------------
815: -- First, verify that all passed-in Inventory Item IDs belong to existing --

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

907: -- 3). Validate passed-in Revision IDs --
908: -- and convert passed-in Revisions --
909: -----------------------------------------
910: IF (p_debug_level > 0) THEN
911: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Revision conversion', 0);
912: END IF;
913:
914: ---------------------------------------------------------------
915: -- First, verify that all passed-in Revision IDs are valid; --

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

1030: ---------------------------------------------------------
1031: -- 4). Find the Item Catalog Group ID for each Item --
1032: ---------------------------------------------------------
1033: IF (p_debug_level > 0) 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

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

1163: ---------------------------------------------------------
1164: -- Find the Bad Attr Group Id for Attribute Name --
1165: ---------------------------------------------------------
1166: IF (p_debug_level > 0) THEN
1167: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID validation', 0);
1168: END IF;
1169: ----------------------------------------------------------------------------
1170: -- Note: Attribute Internal Name take precidence over Attribute Group Id --
1171: ----------------------------------------------------------------------------

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

1198: ---------------------------------------------------------
1199: -- Find the Attr Group Id for Attribute Name --
1200: ---------------------------------------------------------
1201: IF (p_debug_level > 0) THEN
1202: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID conversion', 0);
1203: END IF;
1204: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1205: SET ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1206: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

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

1623: AND ext_prod.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
1624: )
1625: );
1626:
1627: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all SKU records to error, if trying to update variant value, count='||SQL%ROWCOUNT, 1);
1628: END IF;
1629:
1630: --------------------------------------------------------------------------------
1631: -- Mark as errors all rows that share the same logical Attribute Group --

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

1657: AND msib.STYLE_ITEM_FLAG = 'N'
1658: )
1659: );
1660:
1661: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked all SKU records to error, if trying to update inherited attribute value, count='||SQL%ROWCOUNT, 1);
1662:
1663:
1664: ---------------------------------------
1665: -- Set Lifecycle of the revision items.

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

1776:
1777:
1778:
1779: IF (p_debug_level > 0) THEN
1780: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Policy conversion/erroring', 0);
1781: END IF;
1782: -------------------------------------------------------------------------------
1783: -- 5). Mark as errors all rows that share the same logical Attribute Group --
1784: -- row with any rows for which the Change Policy is defined as NOT_ALLOWED --

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

1806: -- We are changing the process_status of all the variant attribute groups --
1807: -- to G_PS_STYLE_VARIANT_IN_PROCESS so that they are not picked up by --
1808: -- UDA bulkloader. --
1809: -------------------------------------------------------------------------------
1810: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Style value set processing', 1);
1811:
1812: UPDATE EGO_ITM_USR_ATTR_INTRFC INTF
1813: SET PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1814: WHERE INTF.DATA_SET_ID = p_data_set_id

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

1831: AND MSIB.STYLE_ITEM_FLAG = 'Y'
1832: AND INTF.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
1833: );
1834:
1835: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Updated Style records count='||SQL%ROWCOUNT, 1);
1836:
1837: -------------------------------------------------------------------------------
1838: -- Mark as errors all rows that share the same logical Attribute Group --
1839: -- Associated value set can not be changed if any sku exists for the style --

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

1849: AND MSIK.STYLE_ITEM_ID = INTF.INVENTORY_ITEM_ID
1850: AND MSIK.ORGANIZATION_ID = INTF.ORGANIZATION_ID
1851: );
1852:
1853: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Updated records to error where SKU exists for style, count='||SQL%ROWCOUNT, 1);
1854:
1855: -------------------------------------------------------------------------------
1856: -- Converting all the value set names entered by user to value set id --
1857: -- Value set name is expected in ATTR_DISP_VALUE column, we convert it to --

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

1864: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1865: AND INTF.ATTR_DISP_VALUE IS NOT NULL;
1866:
1867:
1868: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Converted value set name to value set Id for styles, count='||SQL%ROWCOUNT, 1);
1869: --------------------------------------------------------------------------------
1870: -- Mark as errors all rows that share the same logical Attribute Group --
1871: -- If not a valid value set i.e. Only value set associated at attribute level --
1872: -- or its child value set can be associated. --

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

1892: )
1893: )
1894: );
1895:
1896: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Marked error for invalid value sets, for styles, count='||SQL%ROWCOUNT, 1);
1897:
1898: --------------------------------------------------------------------------------
1899: -- Processing Style variant value sets. Using a merge statement so that bulk --
1900: -- feature can be used --

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

1949: SYSDATE,
1950: l_user_id
1951: );
1952:
1953: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Inserted value sets to EGO_STYLE_VARIANT_ATTR_VS, for styles, count='||SQL%ROWCOUNT, 1);
1954:
1955: ---------------------------------------------------------------------------------
1956: -- Marking all these records as processed --
1957: -- All the records that are in status G_PS_STYLE_VARIANT_IN_PROCESS to success --

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

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

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

1969: --========================================--
1970: -- ERROR REPORTING FOR FAILED CONVERSIONS --
1971: --========================================--
1972: IF (p_debug_level > 0) THEN
1973: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversion error-reporting', 0);
1974: END IF;
1975:
1976: --------------------------------------------------------------------------
1977: -- We fetch representative rows marked as errors and add error messages --

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

2284:
2285: END LOOP;
2286:
2287: IF (p_debug_level > 0) THEN
2288: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Reported errors with '||l_debug_rowcount||' interface table rows', 0);
2289: END IF;
2290:
2291: --=====================================--
2292: -- LOOP PROCESSING OF STILL-VALID ROWS --

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

2291: --=====================================--
2292: -- LOOP PROCESSING OF STILL-VALID ROWS --
2293: --=====================================--
2294: IF (p_debug_level > 0) THEN
2295: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting loop processing of valid rows', 0);
2296: END IF;
2297:
2298: ---------------------------------------------------------------
2299: -- ...and then use it to mark as errors all rows in the list --

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

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

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

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: ---------------------------------------------------------------------
2608:
2609: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);
2610: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2611: p_api_version =>1.0
2612: ,p_application_id =>431
2613: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'

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

2617: ,p_new_status =>4
2618: ,x_return_status =>l_return_status
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;

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

2639:
2640:
2641:
2642:
2643: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);
2644: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2645: p_api_version =>1.0
2646: ,p_application_id =>431
2647: ,p_attr_group_type =>'EGO_ITEM_GTIN_ATTRS'

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

2651: ,p_new_status =>4
2652: ,x_return_status =>l_return_status
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;

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

2670: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN
2671: RETCODE := L_CONC_RET_STS_WARNING;
2672: END IF;
2673:
2674: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);
2675: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
2676: p_api_version =>1.0
2677: ,p_application_id =>431
2678: ,p_attr_group_type =>'EGO_ITEM_GTIN_MULTI_ATTRS'

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

2682: ,p_new_status =>4
2683: ,x_return_status =>l_return_status
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;

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

2710: -- the exception to this is rows for pending Items, which we still processed --
2711: -- The user attrs API would not do the DML for these --
2712: ---------------------------------------------------------------------------------------
2713: IF (p_debug_level > 0) THEN
2714: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Policy conversion/erroring', 0);
2715: END IF;
2716:
2717: BEGIN
2718: --------------------------------------------------------------------------------------

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

2719: -- Bug#4679902 (If the user wants to have Change Order, Change ALLOWED attributes
2720: -- will also be forced to undergo Change Order)
2721: --------------------------------------------------------------------------------------
2722: l_add_all_to_cm := EGO_IMPORT_PVT.getAddAllToChangeFlag(p_batch_id => p_data_set_id);
2723: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' Add all to Change flag is '||l_add_all_to_cm, 0);
2724: IF( l_add_all_to_cm = 'Y' ) THEN
2725: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
2726: SET UAI.PROCESS_STATUS = G_PS_CHG_POLICY_CO_REQUIRED
2727: WHERE UAI.DATA_SET_ID = p_data_set_id

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

2762:
2763: ------------------------------------------------------------
2764:
2765:
2766: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Before calling the GTIN validation API', 0);
2767:
2768: EGO_GTIN_ATTRS_PVT.VALIDATE_INTF_ROWS(
2769: p_data_set_id => p_data_set_id
2770: ,p_entity_id => G_ENTITY_ID

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

2777: ELSIF (l_gtinval_ret_code = 'E') THEN
2778: RETCODE := L_CONC_RET_STS_WARNING;
2779: END IF;
2780:
2781: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('After calling the GTIN validation API', 0);
2782:
2783: ------------------------------------------------
2784: -- Here we call the API in DML only mode for --
2785: -- all the attr group types --

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

2898: ELSIF l_user_attrs_return_status = G_FND_RET_STS_WARNING THEN
2899: RETCODE := L_CONC_RET_STS_WARNING;
2900: END IF;
2901:
2902: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Completing User Attributes Bulk Load return status is ' || l_user_attrs_return_status, 1);
2903:
2904: --------------------------------------------------------
2905: -- This takes care of rolling up of GDSN attributes --
2906: -- and registration/publication status. --

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

2905: -- This takes care of rolling up of GDSN attributes --
2906: -- and registration/publication status. --
2907: --------------------------------------------------------
2908:
2909: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting EGO_GTIN_ATTRS_PVT.Do_Post_UCCnet_Attrs_Action', 1);
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

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

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);
2919:
2920:
2921: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
2922: -----------------------------------------------

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

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

Line 3140: EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line(

3136:
3137: -------------------------------------------------------------------------
3138: -- Now we invoke the UserAttrs procedure, passing Item-specific params --
3139: -------------------------------------------------------------------------
3140: EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line(
3141: p_api_version => 1.0
3142: ,p_object_name => G_ITEM_NAME
3143: ,p_production_b_table_name => 'EGO_MTL_SY_ITEMS_EXT_B'
3144: ,p_production_tl_table_name => 'EGO_MTL_SY_ITEMS_EXT_TL'