DBA Data[Home] [Help]

APPS.INVPVDR6 dependencies on INVPUTLI

Line 132: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

128: Cat_Set_No_Default_Cat EXCEPTION;
129: validate_source NUMBER;
130: l_dummy VARCHAR2(1);
131: l_logerr NUMBER;
132: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
133:
134: BEGIN
135:
136: IF l_inv_debug_level IN(101, 102) THEN

Line 137: INVPUTLI.info('INVPVDR6.validate_item_header6 : begin');

133:
134: BEGIN
135:
136: IF l_inv_debug_level IN(101, 102) THEN
137: INVPUTLI.info('INVPVDR6.validate_item_header6 : begin');
138: END IF;
139: reqst_id := request_id ;
140: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
141:

Line 201: INVPUTLI.info('INVPVDR6.validate_item_header6: validating foreign keys set 3');

197: and set_process_id = xset_id; */
198:
199: -- Validate second group of foreign keys
200: IF l_inv_debug_level IN(101, 102) THEN
201: INVPUTLI.info('INVPVDR6.validate_item_header6: validating foreign keys set 3');
202: END IF;
203:
204: stmt := 31;
205: -- validate foreign keys

Line 478: INVPUTLI.info('INVPVDR6: Validating foreign keys set 4');

474: end;
475: end if;
476:
477: IF l_inv_debug_level IN(101, 102) THEN
478: INVPUTLI.info('INVPVDR6: Validating foreign keys set 4');
479: END IF;
480:
481: stmt := 41;
482: -- validate foreign keys

Line 1827: INVPUTLI.info('INVPVDR6: Calling INVPVDR6 - Verifying lookup type for tax code ');

1823: /* R12 Enhancement - Adding validation */
1824:
1825: if cr.TAX_CODE is not null then
1826: IF l_inv_debug_level IN(101, 102) THEN
1827: INVPUTLI.info('INVPVDR6: Calling INVPVDR6 - Verifying lookup type for tax code ');
1828: END IF;
1829:
1830: temp := null;
1831: OPEN c_tax_code_exists(cr.TAX_CODE,cr.organization_id);

Line 1924: INVPUTLI.info('INVPVDR6: Calling INVPUPI2.validate_flags');

1920: ** which is absolutely unique.Moving this code above all beacause of perf reasons.
1921: 3515652: Performance enhancements, now validate flag works on setid
1922:
1923: IF l_inv_debug_level IN(101, 102) THEN
1924: INVPUTLI.info('INVPVDR6: Calling INVPUPI2.validate_flags');
1925: END IF;
1926: dumm_status := INVPUPI2.validate_flags (
1927: cr.rowid,
1928: prog_appid,

Line 1951: INVPUTLI.info('INVPVDR6: Calling INVPCOII.CSTFVSUB Costing package');

1947: ** for all the updates that CSTFVSUB does to MSII.
1948: */
1949:
1950: IF l_inv_debug_level IN(101, 102) THEN
1951: INVPUTLI.info('INVPVDR6: Calling INVPCOII.CSTFVSUB Costing package');
1952: END IF;
1953:
1954:
1955: /* INVPUTLI.info(cr.rowid|| ' ' ||user_id|| ' ' ||login_id||' ');

Line 1955: /* INVPUTLI.info(cr.rowid|| ' ' ||user_id|| ' ' ||login_id||' ');

1951: INVPUTLI.info('INVPVDR6: Calling INVPCOII.CSTFVSUB Costing package');
1952: END IF;
1953:
1954:
1955: /* INVPUTLI.info(cr.rowid|| ' ' ||user_id|| ' ' ||login_id||' ');
1956: ** INVPUTLI.info(request_id||' ' || prog_id||' '||prog_appid||' '|| err_text);
1957: */
1958: dumm_status := INVPCOII.CSTFVSUB(cr.transaction_id,
1959: cr.material_sub_elem,

Line 1956: ** INVPUTLI.info(request_id||' ' || prog_id||' '||prog_appid||' '|| err_text);

1952: END IF;
1953:
1954:
1955: /* INVPUTLI.info(cr.rowid|| ' ' ||user_id|| ' ' ||login_id||' ');
1956: ** INVPUTLI.info(request_id||' ' || prog_id||' '||prog_appid||' '|| err_text);
1957: */
1958: dumm_status := INVPCOII.CSTFVSUB(cr.transaction_id,
1959: cr.material_sub_elem,
1960: cr.material_oh_sub_elem,

Line 1979: INVPUTLI.info('INVPPROC.inproit_process_item: Checking Default categories before insert');

1975: stmt := 48;
1976:
1977: --Bug: 3028216 check of defautl categories
1978: IF l_inv_debug_level IN(101, 102) THEN
1979: INVPUTLI.info('INVPPROC.inproit_process_item: Checking Default categories before insert');
1980: END IF;
1981:
1982: BEGIN
1983: l_logerr := 0;