APPS.INVPVHDR dependencies on INVPUTLI

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

406: --3360280:KFV validation using fnd_flex_keyval
407: l_valid_segments BOOLEAN := FALSE;
408: l_item_number mtl_system_items_interface.item_number%TYPE;
409: l_deliminator_count NUMBER(10) := 0;
410: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
411: l_col_name VARCHAR2(100);
412: l_is_gdsn_batch NUMBER;
413:
414: begin

Line 489: ** The code fragment here mimics the code in INVPUTLI.get_dynamic_sql_str()

485: /* This dynamic sql is trying to create entries in plsql tables
486: ** bindvarsX bindvalsX
487: ** to facilitate the dynamic binding of variables: For example:
488: ** dbms_sql.bind_variable(DSQL_c1, 'cr_segment1_bind', cr.segment1);
489: ** The code fragment here mimics the code in INVPUTLI.get_dynamic_sql_str()
490: */
491:
492: for n in 1..totalsegs loop
493: segnum_temp := to_char(SEG_TAB(n));

Line 498: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(2, statement_temp1,

494: bindvars1(n) := 'cr_segment'||segnum_temp||'_bind';
495: end loop;
496:
497: /* Call the function to dynamically build the where clause */
498: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(2, statement_temp1,
499: err_temp);
500: /* The same where clause is needed for the 1st
501: ** and 3rd dynamic sql statements in this package
502: */

Line 506: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(3, statement_temp4,

502: */
503: statement_temp3 := statement_temp1;
504:
505: err_temp := NULL;
506: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(3, statement_temp4,
507: err_temp);
508: /* The same where clause is needed for the 2nd and 4th
509: ** dynamic sql statements in this package
510: */

Line 733: INVPUTLI.info('INVPVHDR: stmt0 latest');

729:
730: If (no_of_masterorgs > 1) then
731: BEGIN /* PLSQL Block1 */
732: IF l_inv_debug_level IN(101, 102) THEN
733: INVPUTLI.info('INVPVHDR: stmt0 latest');
734: END IF;
735:
736: DSQL_statement1 := 'select distinct msi.inventory_item_id
737: from mtl_system_items msi,

Line 771: INVPUTLI.info('INVPVHDR: BIND values ' ||

767:
768: for n in 1..totalsegs loop
769: BEGIN
770: IF l_inv_debug_level IN(101, 102) THEN
771: INVPUTLI.info('INVPVHDR: BIND values ' ||
772: bindvars1(n)||' gets '|| bindvals1(n));
773: END IF;
774:
775: dbms_sql.bind_variable(DSQL_c1, bindvars1(n), bindvals1(n) );

Line 843: INVPUTLI.info('INVPVHDR: entering DSQL2 ');

839:
840: else /*The cursor DSQL_c1 fetched no rows at all*/
841: dbms_sql.close_cursor(DSQL_c1);
842: IF l_inv_debug_level IN(101, 102) THEN
843: INVPUTLI.info('INVPVHDR: entering DSQL2 ');
844: END IF;
845:
846: /* This else clause simulates the earlier
847: ** exception when NO_DATA_FOUND then

Line 886: INVPUTLI.info('INVPVHDR: BIND2 values ' ||

882:
883: for n in 1..totalsegs loop
884: BEGIN
885: IF l_inv_debug_level IN(101, 102) THEN
886: INVPUTLI.info('INVPVHDR: BIND2 values ' ||
887: bindvars1(n)||' gets '|| bindvals1(n));
888: END IF;
889:
890: dbms_sql.bind_variable(DSQL_c2, bindvars1(n), bindvals1(n) );

Line 922: INVPUTLI.info('INVPVHDR: Same item being added to MULTIPLE masters ');

918: ** clause because
919: ** the TWO_PASS design ensures that item WILL be
920: ** found in masterorg in MSI*/
921: IF l_inv_debug_level IN(101, 102) THEN
922: INVPUTLI.info('INVPVHDR: Same item being added to MULTIPLE masters ');
923: INVPUTLI.info('INVPVHDR: So now updating inv_item_id in MSII, MIRI ');
924: END IF;
925: update mtl_system_items_interface
926: set inventory_item_id = l_item_id

Line 923: INVPUTLI.info('INVPVHDR: So now updating inv_item_id in MSII, MIRI ');

919: ** the TWO_PASS design ensures that item WILL be
920: ** found in masterorg in MSI*/
921: IF l_inv_debug_level IN(101, 102) THEN
922: INVPUTLI.info('INVPVHDR: Same item being added to MULTIPLE masters ');
923: INVPUTLI.info('INVPVHDR: So now updating inv_item_id in MSII, MIRI ');
924: END IF;
925: update mtl_system_items_interface
926: set inventory_item_id = l_item_id
927: where transaction_id = DSQL2_transaction_id

Line 1014: INVPUTLI.info('INVPVHDR: check 3-1');

1010: */
1011: stmt := 1;
1012:
1013: IF l_inv_debug_level IN(101, 102) THEN
1014: INVPUTLI.info('INVPVHDR: check 3-1');
1015: END IF;
1016:
1017: select count(*)
1018: into ext_flag

Line 1024: INVPUTLI.info('INVPVHDR: check 3-1');

1020: where inventory_item_id = l_item_id
1021: and organization_id = cr.organization_id
1022: and cr.transaction_type = 'CREATE';
1023: IF l_inv_debug_level IN(101, 102) THEN
1024: INVPUTLI.info('INVPVHDR: check 3-1');
1025: END IF;
1026:
1027: stmt := 2;
1028: if ext_flag > 0 then

Line 1067: INVPUTLI.info('INVPVHDR: check 4-1');

1063: and organization_id = cr.organization_id
1064: and process_flag = 2
1065: and set_process_id = xset_id;
1066: IF l_inv_debug_level IN(101, 102) THEN
1067: INVPUTLI.info('INVPVHDR: check 4-1');
1068: END IF;
1069:
1070: if ext_flag > 1 then
1071: stmt := 5;

Line 1116: INVPUTLI.info('INVPVHDR: stmt6');

1112: ** and organization id
1113: */
1114: stmt := 6;
1115: IF l_inv_debug_level IN(101, 102) THEN
1116: INVPUTLI.info('INVPVHDR: stmt6');
1117: END IF;
1118: BEGIN /* PLSQL Block 2*/
1119:
1120: DSQL_statement3 := 'select count(*)

Line 1186: INVPUTLI.info('INVPVHDR: stmt7');

1182:
1183: stmt := 7;
1184:
1185: IF l_inv_debug_level IN(101, 102) THEN
1186: INVPUTLI.info('INVPVHDR: stmt7');
1187: END IF;
1188: IF ext_flag > 0 AND status=0 THEN /* Crucial If:*/ --Bug:5208039
1189:
1190: /*

Line 1378: /*INVPUTLI.info('INVPVHDR: Validating flags'); */

1374:
1375: /*
1376: ** Check for integrity rules/restrictions for item attributes
1377: */
1378: /*INVPUTLI.info('INVPVHDR: Validating flags'); */
1379:
1380: -- validate that UOM values exist
1381: /*NP 28DEC94 New validation
1382: ** if both PRIMARY_UOM_CODE and PRIMARY_UNIT_OF_MEASURE null