eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVPAGI2 dependencies on INVPUTLI

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

219:
220: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;
221: l_msg_text fnd_new_messages.message_text%TYPE;
222:
223: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
224: l_ret_status VARCHAR2(1);
225: l_msg_count NUMBER;
226: l_msg_data VARCHAR2(100);
227: l_style_item_id NUMBER;

Line 296: INVPUTLI.info('INVPAGI2: uom default is '|| uom_default);

292: err_text);
293: uom_default := substr(uom_default_tmp,1,25);
294:
295: IF l_inv_debug_level IN(101, 102) THEN
296: INVPUTLI.info('INVPAGI2: uom default is '|| uom_default);
297: END IF;
298:
299:
300: if rtn_status <> 0 and

Line 384: INVPUTLI.info('INVPAGI2: About to handle sequence generated item number case');

380:
381: IF default_flag = 2 THEN --Sequence generated item nos only in pre-defaulting phase
382:
383: IF l_inv_debug_level IN(101, 102) THEN
384: INVPUTLI.info('INVPAGI2: About to handle sequence generated item number case');
385: END IF;
386:
387: SELECT DISTINCT item_catalog_group_id BULK COLLECT INTO catalog_table
388: FROM mtl_system_items_interface

Line 414: INVPUTLI.info('INVPAGI2: Identified rows for SEQ generation are:' || SQL%ROWCOUNT);

410: FROM mtl_parameters)
411: AND (msii.item_catalog_group_id IS NOT NULL AND msii.item_catalog_group_id = catalog_table(i));
412:
413: IF l_inv_debug_level IN(101, 102) THEN
414: INVPUTLI.info('INVPAGI2: Identified rows for SEQ generation are:' || SQL%ROWCOUNT);
415: END IF;
416:
417: l_seq_exists := 1;
418: END IF;

Line 458: INVPUTLI.info('INVPAGI2: About to handle SKU items');

454: -- End of Bug 5118572
455: END IF; --Seq gen Item Nos only in pre defaulting phase
456:
457: IF l_inv_debug_level IN(101, 102) THEN
458: INVPUTLI.info('INVPAGI2: About to handle SKU items');
459: END IF;
460:
461: /* Mark all SKU items with no style item to error */
462: UPDATE mtl_system_items_interface msii

Line 549: INVPUTLI.info('INVPAGI2: About to enter DSQL block');

545: END IF;
546: END IF;
547:
548: IF l_inv_debug_level IN(101, 102) THEN
549: INVPUTLI.info('INVPAGI2: About to enter DSQL block');
550: END IF;
551:
552:
553: BEGIN /* PL-SQL Block for doing the dynamic SQL part*/

Line 558: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, ff_statement_temp, ff_err_temp);

554:
555: ff_statement_temp := NULL;
556: ff_err_temp := NULL;
557: DSQL_ff_c := dbms_sql.open_cursor;
558: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, ff_statement_temp, ff_err_temp);
559:
560: /* Now append the sql statement to the generated dynamic sql where clause
561: ** NP 02MAY96 Added xset_id and a i
562: ** statement to BIND the set_id variable to DSQL_ff_c */

Line 582: INVPUTLI.info('INVPAGI2: About to enter DSQL loop');

578:
579: DSQL_ff_rows_processed := dbms_sql.execute(DSQL_ff_c);
580:
581: IF l_inv_debug_level IN(101, 102) THEN
582: INVPUTLI.info('INVPAGI2: About to enter DSQL loop');
583: END IF;
584:
585: loop
586: if dbms_sql.fetch_rows(DSQL_ff_c) > 0 then

Line 620: INVPUTLI.info('INVPAGI2:out of loop ');

616: if dbms_sql.is_open(DSQL_ff_c) then
617: dbms_sql.close_cursor(DSQL_ff_c);
618: end if;
619: IF l_inv_debug_level IN(101, 102) THEN
620: INVPUTLI.info('INVPAGI2:out of loop ');
621: END IF;
622:
623: EXCEPTION
624: when others then

Line 661: INVPUTLI.info('INVPAGI2: About to enter header cursorloop');

657: and msi.organization_id = mp.organization_id
658: and ' || ff_statement_temp;
659:
660: IF l_inv_debug_level IN(101, 102) THEN
661: INVPUTLI.info('INVPAGI2: About to enter header cursorloop');
662: END IF;
663:
664:
665: update MTL_ITEM_REVISIONS_INTERFACE i

Line 697: INVPUTLI.info('INVPAGI2: Set_id for current_row is '||cr.set_process_id);

693: --End : Performance enhancements
694:
695: FOR cr in header loop
696: IF l_inv_debug_level IN(101, 102) THEN
697: INVPUTLI.info('INVPAGI2: Set_id for current_row is '||cr.set_process_id);
698: END IF;
699: rtn_status := 0;
700: org_flag := 0;
701: tran_id := cr.transaction_id;

Line 974: INVPUTLI.info('INVPAGI2: About to process DSQL 2 ');

970: */
971: if cr.inventory_item_id is null then
972: BEGIN
973: IF l_inv_debug_level IN(101, 102) THEN
974: INVPUTLI.info('INVPAGI2: About to process DSQL 2 ');
975: END IF;
976: DSQL_c := dbms_sql.open_cursor;
977: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
978: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);

Line 1005: INVPUTLI.info('INVPAGI2: About to process DSQL 3 ');

1001:
1002: else
1003: --Adding resolution of Item Id from Master in same batch (from Intf table)
1004: IF l_inv_debug_level IN(101, 102) THEN
1005: INVPUTLI.info('INVPAGI2: About to process DSQL 3 ');
1006: END IF;
1007: -- Fix for bug#9336604
1008: DSQL_Statement_Msii := 'SELECT /*+ index(msii MTL_SYSTEM_ITEMS_INTERFACE_N6) index(msi MTL_SYSTEM_ITEMS_INTERFACE_N4) */ msi.inventory_item_id
1009: FROM mtl_system_items_interface msi, mtl_system_items_interface msii

Line 1051: INVPUTLI.info('INVPAGI2: No match in MSI; Creating Inventory Item Id from sequence');

1047: -- No such row found. Close the cursor after
1048: -- Assigning missing inventory_item_id from sequence
1049:
1050: IF l_inv_debug_level IN(101, 102) THEN
1051: INVPUTLI.info('INVPAGI2: No match in MSI; Creating Inventory Item Id from sequence');
1052: END IF;
1053:
1054: /*update MTL_SYSTEM_ITEMS_INTERFACE
1055: set inventory_item_id = MTL_SYSTEM_ITEMS_S.nextval

Line 1098: INVPUTLI.info('INVPAGI2: Determining whether the item is in master org');

1094: end if; /* cr.inventory_item_id is null */
1095:
1096: -- determine if item is in master org.
1097: IF l_inv_debug_level IN(101, 102) THEN
1098: INVPUTLI.info('INVPAGI2: Determining whether the item is in master org');
1099: END IF;
1100: if l_old_organization_id <> cr.organization_id then
1101: select mp.master_organization_id ,
1102: mp.starting_revision ,

Line 1121: INVPUTLI.info('cr.rev is ' || cr.revision);

1117: if (cr.revision is null) then
1118: cr.revision := default_rev;
1119: end if;
1120: IF l_inv_debug_level IN(101, 102) THEN
1121: INVPUTLI.info('cr.rev is ' || cr.revision);
1122: END IF;
1123: msiicount := 0;
1124:
1125: select count(*) into msiicount

Line 1130: INVPUTLI.info('Processing itemid '|| cr.inventory_item_id );

1126: from mtl_system_items msii
1127: where cr.inventory_item_id = msii.inventory_item_id
1128: and msii.organization_id = master_org_id;
1129: IF l_inv_debug_level IN(101, 102) THEN
1130: INVPUTLI.info('Processing itemid '|| cr.inventory_item_id );
1131: INVPUTLI.info('with Org id '|| cr.organization_id );
1132: INVPUTLI.info('with segment1 '|| cr.segment1 );
1133: END IF;
1134: --assign master_org attribute defaults if in child org AND parent exists

Line 1131: INVPUTLI.info('with Org id '|| cr.organization_id );

1127: where cr.inventory_item_id = msii.inventory_item_id
1128: and msii.organization_id = master_org_id;
1129: IF l_inv_debug_level IN(101, 102) THEN
1130: INVPUTLI.info('Processing itemid '|| cr.inventory_item_id );
1131: INVPUTLI.info('with Org id '|| cr.organization_id );
1132: INVPUTLI.info('with segment1 '|| cr.segment1 );
1133: END IF;
1134: --assign master_org attribute defaults if in child org AND parent exists
1135:

Line 1132: INVPUTLI.info('with segment1 '|| cr.segment1 );

1128: and msii.organization_id = master_org_id;
1129: IF l_inv_debug_level IN(101, 102) THEN
1130: INVPUTLI.info('Processing itemid '|| cr.inventory_item_id );
1131: INVPUTLI.info('with Org id '|| cr.organization_id );
1132: INVPUTLI.info('with segment1 '|| cr.segment1 );
1133: END IF;
1134: --assign master_org attribute defaults if in child org AND parent exists
1135:
1136: if ((master_org_id <> cr.organization_id) and (msiicount = 1)) then

Line 1141: INVPUTLI.info('INVPAGI2: calling assign_master_defaults with set_id '||xset_id);

1137: if rtn_status = 0 then
1138: IF INVPOPIF.g_source_org /*Added for bug 6372595*/
1139: THEN
1140: IF l_inv_debug_level IN(101, 102) THEN
1141: INVPUTLI.info('INVPAGI2: calling assign_master_defaults with set_id '||xset_id);
1142: END IF;
1143: rtn_status := INVPUTLI.assign_master_defaults(
1144: cr.transaction_id,
1145: cr.inventory_item_id,

Line 1143: rtn_status := INVPUTLI.assign_master_defaults(

1139: THEN
1140: IF l_inv_debug_level IN(101, 102) THEN
1141: INVPUTLI.info('INVPAGI2: calling assign_master_defaults with set_id '||xset_id);
1142: END IF;
1143: rtn_status := INVPUTLI.assign_master_defaults(
1144: cr.transaction_id,
1145: cr.inventory_item_id,
1146: cr.organization_id,
1147: master_org_id,

Line 1188: INVPUTLI.info('INVPAGI2: Orphan found; about to call error ');

1184: else
1185: if ((master_org_id <> cr.organization_id) and (msiicount = 0)) then
1186: if rtn_status = 0 then
1187: IF l_inv_debug_level IN(101, 102) THEN
1188: INVPUTLI.info('INVPAGI2: Orphan found; about to call error ');
1189: INVPUTLI.info('INVPAGI2: Orphan found; checking in msii ');
1190: END IF;
1191:
1192: select count(*) into msiicount

Line 1189: INVPUTLI.info('INVPAGI2: Orphan found; checking in msii ');

1185: if ((master_org_id <> cr.organization_id) and (msiicount = 0)) then
1186: if rtn_status = 0 then
1187: IF l_inv_debug_level IN(101, 102) THEN
1188: INVPUTLI.info('INVPAGI2: Orphan found; about to call error ');
1189: INVPUTLI.info('INVPAGI2: Orphan found; checking in msii ');
1190: END IF;
1191:
1192: select count(*) into msiicount
1193: from mtl_system_items_interface

Line 1219: INVPUTLI.info('INVPAGI2: Orphan found; error called '|| rtn_status);

1215: if dumm_status < 0 then
1216: raise LOGGING_ERR;
1217: end if;
1218: IF l_inv_debug_level IN(101, 102) THEN
1219: INVPUTLI.info('INVPAGI2: Orphan found; error called '|| rtn_status);
1220: END IF;
1221: else
1222: rtn_status := INVPUTLI.predefault_child_master(
1223: cr.inventory_item_id,

Line 1222: rtn_status := INVPUTLI.predefault_child_master(

1218: IF l_inv_debug_level IN(101, 102) THEN
1219: INVPUTLI.info('INVPAGI2: Orphan found; error called '|| rtn_status);
1220: END IF;
1221: else
1222: rtn_status := INVPUTLI.predefault_child_master(
1223: cr.inventory_item_id,
1224: cr.organization_id,
1225: master_org_id,
1226: err_text,

Line 1237: INVPUTLI.info('INVPAGI2: In the new-item-in-master case ');

1233: end if; /*rtn_status = 0*/
1234: else
1235: if rtn_status = 0 then
1236: IF l_inv_debug_level IN(101, 102) THEN
1237: INVPUTLI.info('INVPAGI2: In the new-item-in-master case ');
1238: INVPUTLI.info('INVPAGI2: Calling assign_item_defaults with set_id '|| xset_id);
1239: END IF;
1240:
1241: rtn_status := INVPUTLI.assign_item_defaults(

Line 1238: INVPUTLI.info('INVPAGI2: Calling assign_item_defaults with set_id '|| xset_id);

1234: else
1235: if rtn_status = 0 then
1236: IF l_inv_debug_level IN(101, 102) THEN
1237: INVPUTLI.info('INVPAGI2: In the new-item-in-master case ');
1238: INVPUTLI.info('INVPAGI2: Calling assign_item_defaults with set_id '|| xset_id);
1239: END IF;
1240:
1241: rtn_status := INVPUTLI.assign_item_defaults(
1242: cr.inventory_item_id,

Line 1241: rtn_status := INVPUTLI.assign_item_defaults(

1237: INVPUTLI.info('INVPAGI2: In the new-item-in-master case ');
1238: INVPUTLI.info('INVPAGI2: Calling assign_item_defaults with set_id '|| xset_id);
1239: END IF;
1240:
1241: rtn_status := INVPUTLI.assign_item_defaults(
1242: cr.inventory_item_id,
1243: cr.organization_id,
1244: status_default,
1245: uom_default,