DBA Data[Home] [Help]

APPS.INVPPROC dependencies on INVPPROC

Line 1: PACKAGE BODY INVPPROC AS

1: PACKAGE BODY INVPPROC AS
2: /* $Header: INVPPROB.pls 120.39.12020000.4 2013/01/23 08:28:26 lmai ship $ */
3: FUNCTION inproit_process_item
4: (
5: prg_appid in NUMBER,

Line 186: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MSI_B with xset_id = '|| xset_id);

182:
183: BEGIN
184:
185: IF l_inv_debug_level IN(101, 102) THEN
186: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MSI_B with xset_id = '|| xset_id);
187: END IF;
188: --Bug 4767919 Anmurali
189: IF (INSTR(INV_EGO_REVISION_VALIDATE.Get_Process_Control,'PLM_UI:Y') <> 0) THEN
190:

Line 1142: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MSI_TL with xset_id = '||xset_id);

1138: AND I.set_process_id = xset_id
1139: AND I.transaction_type = l_transaction_type;
1140:
1141: IF l_inv_debug_level IN(101, 102) THEN
1142: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MSI_TL with xset_id = '||xset_id);
1143: END IF;
1144:
1145: -- R11.5 MLS
1146: -- bug 10373720, set last_update date and creation date to sysdate

Line 1257: INVPUTLI.info('INVPPROC.inproit_process_item: deleting from MDEV with xset_id = '||xset_id);

1253: END LOOP;
1254:
1255:
1256: IF l_inv_debug_level IN(101, 102) THEN
1257: INVPUTLI.info('INVPPROC.inproit_process_item: deleting from MDEV with xset_id = '||xset_id);
1258: END IF;
1259:
1260: -- Bug #1068191 (1031733)
1261: --

Line 1276: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MDEV with xset_id = '|| xset_id);

1272: and I.organization_id = MP.master_organization_id
1273: );
1274:
1275: IF l_inv_debug_level IN(101, 102) THEN
1276: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MDEV with xset_id = '|| xset_id);
1277: END IF;
1278:
1279: table_name := 'MTL_DESCR_ELEMENT_VALUES';
1280:

Line 1334: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MIR from MIRI');

1330: ** with the Two_pass design
1331: */
1332:
1333: IF l_inv_debug_level IN(101, 102) THEN
1334: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MIR from MIRI');
1335: END IF;
1336:
1337: table_name := 'MTL_ITEM_REVISIONS';
1338:

Line 1486: **INVPUTLI.info('INVPPROC: Skipped the orphan ins code in MTL_ITEM_REVISIONS');

1482: ** Note the use of the last_updated_by who column
1483: ** This is initialized in INVPUTLI and holds the master_org_id
1484: **NP 26SEP95 Deleted the commented out code in version 50.12
1485: ** To see it refer to a prior version
1486: **INVPUTLI.info('INVPPROC: Skipped the orphan ins code in MTL_ITEM_REVISIONS');
1487: */
1488:
1489: -- create child orgs category assignment
1490:

Line 1571: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MIC from MCS/MSII');

1567: -- Insert item assignments to default categories of the
1568: -- mandatory category sets for all functional areas.
1569: --------------------------------------------------------
1570: IF l_inv_debug_level IN(101, 102) THEN
1571: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MIC from MCS/MSII');
1572: END IF;
1573:
1574: /*
1575: SQL Modified to fix 4869915

Line 1726: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into mtl_pending_item_status');

1722: ---------------------------------------------
1723: -- Insert into MTL_PENDING_ITEM_STATUS table
1724: ---------------------------------------------
1725: IF l_inv_debug_level IN(101, 102) THEN
1726: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into mtl_pending_item_status');
1727: END IF;
1728:
1729: l_pending_flag := 'N';
1730: -- l_last_updated_by := 0;

Line 1920: INVPUTLI.info('INVPPROC: Finished inserting in mtl_uom_conversions');

1916: ** This is a major fix to the code.
1917: */
1918:
1919: IF l_inv_debug_level IN(101, 102) THEN
1920: INVPUTLI.info('INVPPROC: Finished inserting in mtl_uom_conversions');
1921: END IF;
1922:
1923:
1924:

Line 1931: INVPUTLI.info('INVPPROC: Calling Costing procedure CSTPIICP');

1927: ** NP 06MAY96 Added new parameter xset_id to call to CSTPIICP
1928: */
1929:
1930: IF l_inv_debug_level IN(101, 102) THEN
1931: INVPUTLI.info('INVPPROC: Calling Costing procedure CSTPIICP');
1932: END IF;
1933:
1934: INVPCOII.CSTPIICP(user_id,
1935: login_id,

Line 1949: --INVPUTLI.info('INVPPROC: Calling Ego procedure Insert_Grants_And_UserAttr');

1945: end if;
1946:
1947: --Bug: 3033702 Added for EGO grants on item
1948: --Moved support of user attribs code to INVEGRVB
1949: --INVPUTLI.info('INVPPROC: Calling Ego procedure Insert_Grants_And_UserAttr');
1950: --INV_EGO_REVISION_VALIDATE.Insert_Grants_And_UserAttr(xset_id);
1951: --Bug: 3033702 Ended
1952: INV_EGO_REVISION_VALIDATE.Create_New_Item_Request(xset_id);
1953: --Bug:3777954 added call to new processing for NIR required items (for EGO)

Line 2002: error_message := SUBSTR('INVPPROC.inproit_process_item: ' || return_err, 1,240);

1998: WHEN no_data_found THEN
1999: RETURN (0);
2000:
2001: WHEN cost_err THEN
2002: error_message := SUBSTR('INVPPROC.inproit_process_item: ' || return_err, 1,240);
2003: message_name := 'COST_ERROR';
2004: RETURN (1);
2005:
2006: WHEN LOGGING_ERR THEN

Line 2007: error_message := SUBSTR('INVPPROC.inproit_process_item : Logging Error',1,240);

2003: message_name := 'COST_ERROR';
2004: RETURN (1);
2005:
2006: WHEN LOGGING_ERR THEN
2007: error_message := SUBSTR('INVPPROC.inproit_process_item : Logging Error',1,240);
2008: message_name := 'LOGGING_ERROR';
2009: RETURN (1);
2010:
2011: WHEN others THEN

Line 2013: INVPUTLI.info('INVPPROC: Exception during INSERT '||FND_MESSAGE.GET);

2009: RETURN (1);
2010:
2011: WHEN others THEN
2012: IF l_inv_debug_level IN(101, 102) THEN
2013: INVPUTLI.info('INVPPROC: Exception during INSERT '||FND_MESSAGE.GET);
2014: END IF;
2015: error_message := SUBSTR('INVPPROC.inproit_process_item ' || sqlerrm, 1,240);
2016: message_name := 'OTHER_INVPPROC_ERROR';
2017: RETURN (1);

Line 2015: error_message := SUBSTR('INVPPROC.inproit_process_item ' || sqlerrm, 1,240);

2011: WHEN others THEN
2012: IF l_inv_debug_level IN(101, 102) THEN
2013: INVPUTLI.info('INVPPROC: Exception during INSERT '||FND_MESSAGE.GET);
2014: END IF;
2015: error_message := SUBSTR('INVPPROC.inproit_process_item ' || sqlerrm, 1,240);
2016: message_name := 'OTHER_INVPPROC_ERROR';
2017: RETURN (1);
2018:
2019: END inproit_process_item;

Line 2016: message_name := 'OTHER_INVPPROC_ERROR';

2012: IF l_inv_debug_level IN(101, 102) THEN
2013: INVPUTLI.info('INVPPROC: Exception during INSERT '||FND_MESSAGE.GET);
2014: END IF;
2015: error_message := SUBSTR('INVPPROC.inproit_process_item ' || sqlerrm, 1,240);
2016: message_name := 'OTHER_INVPPROC_ERROR';
2017: RETURN (1);
2018:
2019: END inproit_process_item;
2020:

Line 2022: END INVPPROC;

2018:
2019: END inproit_process_item;
2020:
2021:
2022: END INVPPROC;