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.26.12010000.3 2008/11/25 02:24:19 akbharga ship $ */
3: FUNCTION inproit_process_item
4: (
5: prg_appid in NUMBER,

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

145:
146: BEGIN
147:
148: IF l_inv_debug_level IN(101, 102) THEN
149: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MSI_B with xset_id = '|| xset_id);
150: END IF;
151: --Bug 4767919 Anmurali
152: IF (INSTR(INV_EGO_REVISION_VALIDATE.Get_Process_Control,'PLM_UI:Y') <> 0) THEN
153:

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

1069: AND I.set_process_id = xset_id
1070: AND I.transaction_type = l_transaction_type;
1071:
1072: IF l_inv_debug_level IN(101, 102) THEN
1073: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MSI_TL with xset_id = '||xset_id);
1074: END IF;
1075:
1076: -- R11.5 MLS
1077:

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

1179: END LOOP;
1180:
1181:
1182: IF l_inv_debug_level IN(101, 102) THEN
1183: INVPUTLI.info('INVPPROC.inproit_process_item: deleting from MDEV with xset_id = '||xset_id);
1184: END IF;
1185:
1186: -- Bug #1068191 (1031733)
1187: --

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

1198: and I.organization_id = MP.master_organization_id
1199: );
1200:
1201: IF l_inv_debug_level IN(101, 102) THEN
1202: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MDEV with xset_id = '|| xset_id);
1203: END IF;
1204:
1205: table_name := 'MTL_DESCR_ELEMENT_VALUES';
1206:

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

1254: ** with the Two_pass design
1255: */
1256:
1257: IF l_inv_debug_level IN(101, 102) THEN
1258: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MIR from MIRI');
1259: END IF;
1260:
1261: table_name := 'MTL_ITEM_REVISIONS';
1262:

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

1398: ** Note the use of the last_updated_by who column
1399: ** This is initialized in INVPUTLI and holds the master_org_id
1400: **NP 26SEP95 Deleted the commented out code in version 50.12
1401: ** To see it refer to a prior version
1402: **INVPUTLI.info('INVPPROC: Skipped the orphan ins code in MTL_ITEM_REVISIONS');
1403: */
1404:
1405: -- create child orgs category assignment
1406:

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

1483: -- Insert item assignments to default categories of the
1484: -- mandatory category sets for all functional areas.
1485: --------------------------------------------------------
1486: IF l_inv_debug_level IN(101, 102) THEN
1487: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into MIC from MCS/MSII');
1488: END IF;
1489:
1490: /*
1491: SQL Modified to fix 4869915

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

1636: ---------------------------------------------
1637: -- Insert into MTL_PENDING_ITEM_STATUS table
1638: ---------------------------------------------
1639: IF l_inv_debug_level IN(101, 102) THEN
1640: INVPUTLI.info('INVPPROC.inproit_process_item: inserting into mtl_pending_item_status');
1641: END IF;
1642:
1643: l_pending_flag := 'N';
1644: -- l_last_updated_by := 0;

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

1830: ** This is a major fix to the code.
1831: */
1832:
1833: IF l_inv_debug_level IN(101, 102) THEN
1834: INVPUTLI.info('INVPPROC: Finished inserting in mtl_uom_conversions');
1835: END IF;
1836:
1837:
1838:

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

1841: ** NP 06MAY96 Added new parameter xset_id to call to CSTPIICP
1842: */
1843:
1844: IF l_inv_debug_level IN(101, 102) THEN
1845: INVPUTLI.info('INVPPROC: Calling Costing procedure CSTPIICP');
1846: END IF;
1847:
1848: INVPCOII.CSTPIICP(user_id,
1849: login_id,

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

1859: end if;
1860:
1861: --Bug: 3033702 Added for EGO grants on item
1862: --Moved support of user attribs code to INVEGRVB
1863: --INVPUTLI.info('INVPPROC: Calling Ego procedure Insert_Grants_And_UserAttr');
1864: --INV_EGO_REVISION_VALIDATE.Insert_Grants_And_UserAttr(xset_id);
1865: --Bug: 3033702 Ended
1866: INV_EGO_REVISION_VALIDATE.Create_New_Item_Request(xset_id);
1867: --Bug:3777954 added call to new processing for NIR required items (for EGO)

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

1912: WHEN no_data_found THEN
1913: RETURN (0);
1914:
1915: WHEN cost_err THEN
1916: error_message := SUBSTR('INVPPROC.inproit_process_item: ' || return_err, 1,240);
1917: message_name := 'COST_ERROR';
1918: RETURN (1);
1919:
1920: WHEN LOGGING_ERR THEN

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

1917: message_name := 'COST_ERROR';
1918: RETURN (1);
1919:
1920: WHEN LOGGING_ERR THEN
1921: error_message := SUBSTR('INVPPROC.inproit_process_item : Logging Error',1,240);
1922: message_name := 'LOGGING_ERROR';
1923: RETURN (1);
1924:
1925: WHEN others THEN

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

1923: RETURN (1);
1924:
1925: WHEN others THEN
1926: IF l_inv_debug_level IN(101, 102) THEN
1927: INVPUTLI.info('INVPPROC: Exception during INSERT '||FND_MESSAGE.GET);
1928: END IF;
1929: error_message := SUBSTR('INVPPROC.inproit_process_item ' || sqlerrm, 1,240);
1930: message_name := 'OTHER_INVPPROC_ERROR';
1931: RETURN (1);

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

1925: WHEN others THEN
1926: IF l_inv_debug_level IN(101, 102) THEN
1927: INVPUTLI.info('INVPPROC: Exception during INSERT '||FND_MESSAGE.GET);
1928: END IF;
1929: error_message := SUBSTR('INVPPROC.inproit_process_item ' || sqlerrm, 1,240);
1930: message_name := 'OTHER_INVPPROC_ERROR';
1931: RETURN (1);
1932:
1933: END inproit_process_item;

Line 1930: message_name := 'OTHER_INVPPROC_ERROR';

1926: IF l_inv_debug_level IN(101, 102) THEN
1927: INVPUTLI.info('INVPPROC: Exception during INSERT '||FND_MESSAGE.GET);
1928: END IF;
1929: error_message := SUBSTR('INVPPROC.inproit_process_item ' || sqlerrm, 1,240);
1930: message_name := 'OTHER_INVPPROC_ERROR';
1931: RETURN (1);
1932:
1933: END inproit_process_item;
1934:

Line 1936: END INVPPROC;

1932:
1933: END inproit_process_item;
1934:
1935:
1936: END INVPPROC;