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 1836: INVPUTLI.info('INVPVDR6: Calling INVPVDR6 - Verifying lookup type for tax code ');

1832: /* R12 Enhancement - Adding validation */
1833:
1834: if cr.TAX_CODE is not null then
1835: IF l_inv_debug_level IN(101, 102) THEN
1836: INVPUTLI.info('INVPVDR6: Calling INVPVDR6 - Verifying lookup type for tax code ');
1837: END IF;
1838:
1839: temp := null;
1840: OPEN c_tax_code_exists(cr.TAX_CODE,cr.organization_id);

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

1929: ** which is absolutely unique.Moving this code above all beacause of perf reasons.
1930: 3515652: Performance enhancements, now validate flag works on setid
1931:
1932: IF l_inv_debug_level IN(101, 102) THEN
1933: INVPUTLI.info('INVPVDR6: Calling INVPUPI2.validate_flags');
1934: END IF;
1935: dumm_status := INVPUPI2.validate_flags (
1936: cr.rowid,
1937: prog_appid,

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

1956: ** for all the updates that CSTFVSUB does to MSII.
1957: */
1958:
1959: IF l_inv_debug_level IN(101, 102) THEN
1960: INVPUTLI.info('INVPVDR6: Calling INVPCOII.CSTFVSUB Costing package');
1961: END IF;
1962:
1963:
1964: /* INVPUTLI.info(cr.rowid|| ' ' ||user_id|| ' ' ||login_id||' ');

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

1960: INVPUTLI.info('INVPVDR6: Calling INVPCOII.CSTFVSUB Costing package');
1961: END IF;
1962:
1963:
1964: /* INVPUTLI.info(cr.rowid|| ' ' ||user_id|| ' ' ||login_id||' ');
1965: ** INVPUTLI.info(request_id||' ' || prog_id||' '||prog_appid||' '|| err_text);
1966: */
1967: dumm_status := INVPCOII.CSTFVSUB(cr.transaction_id,
1968: cr.material_sub_elem,

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

1961: END IF;
1962:
1963:
1964: /* INVPUTLI.info(cr.rowid|| ' ' ||user_id|| ' ' ||login_id||' ');
1965: ** INVPUTLI.info(request_id||' ' || prog_id||' '||prog_appid||' '|| err_text);
1966: */
1967: dumm_status := INVPCOII.CSTFVSUB(cr.transaction_id,
1968: cr.material_sub_elem,
1969: cr.material_oh_sub_elem,

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

1984: stmt := 48;
1985:
1986: --Bug: 3028216 check of defautl categories
1987: IF l_inv_debug_level IN(101, 102) THEN
1988: INVPUTLI.info('INVPPROC.inproit_process_item: Checking Default categories before insert');
1989: END IF;
1990:
1991: BEGIN
1992: l_logerr := 0;