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 MTL_SYSTEM_ITEMS_INTERFACE

Line 66: from MTL_SYSTEM_ITEMS_INTERFACE

62: style_item_id,
63: style_item_number,
64: source_system_id,
65: source_system_reference
66: from MTL_SYSTEM_ITEMS_INTERFACE
67: where process_flag = 1
68: and set_process_id = xset_id
69: and ((organization_id = org_id) or (all_org = 1));
70:

Line 87: from mtl_system_items_interface child

83: AND process_flag = 1;
84:
85: CURSOR ee is
86: select rowid ,transaction_id,inventory_item_id
87: from mtl_system_items_interface child
88: where inventory_item_id is not NULL
89: and set_process_id = xset_id
90: and process_flag = 1
91: and not exists

Line 129: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE

125: ORDER BY LEVEL ASC
126: )
127: WHERE ROWNUM = 1;
128:
129: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
130: INDEX BY BINARY_INTEGER;
131:
132: TYPE style_number_type IS TABLE OF mtl_system_items_interface.style_item_number%TYPE
133: INDEX BY BINARY_INTEGER;

Line 132: TYPE style_number_type IS TABLE OF mtl_system_items_interface.style_item_number%TYPE

128:
129: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
130: INDEX BY BINARY_INTEGER;
131:
132: TYPE style_number_type IS TABLE OF mtl_system_items_interface.style_item_number%TYPE
133: INDEX BY BINARY_INTEGER;
134:
135: TYPE org_type IS TABLE OF mtl_system_items_interface.organization_id%TYPE
136: INDEX BY BINARY_INTEGER;

Line 135: TYPE org_type IS TABLE OF mtl_system_items_interface.organization_id%TYPE

131:
132: TYPE style_number_type IS TABLE OF mtl_system_items_interface.style_item_number%TYPE
133: INDEX BY BINARY_INTEGER;
134:
135: TYPE org_type IS TABLE OF mtl_system_items_interface.organization_id%TYPE
136: INDEX BY BINARY_INTEGER;
137:
138: TYPE catalog_type IS TABLE OF mtl_system_items_interface.item_catalog_group_id%TYPE
139: INDEX BY BINARY_INTEGER;

Line 138: TYPE catalog_type IS TABLE OF mtl_system_items_interface.item_catalog_group_id%TYPE

134:
135: TYPE org_type IS TABLE OF mtl_system_items_interface.organization_id%TYPE
136: INDEX BY BINARY_INTEGER;
137:
138: TYPE catalog_type IS TABLE OF mtl_system_items_interface.item_catalog_group_id%TYPE
139: INDEX BY BINARY_INTEGER;
140:
141: transaction_table transaction_type;
142: style_item_num_table style_number_type;

Line 213: l_item_number mtl_system_items_interface.item_number%TYPE;

209: l_rowid ROWID;
210:
211: l_curr_sysdate DATE; -- Bug 4539703 this will store sysdate- 1 sec
212: ---Start: Bug fix 3051653
213: l_item_number mtl_system_items_interface.item_number%TYPE;
214: l_item_id mtl_system_items_interface.inventory_item_id%TYPE;
215: l_Itemid_error BOOLEAN := FALSE;
216:
217: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;

Line 214: l_item_id mtl_system_items_interface.inventory_item_id%TYPE;

210:
211: l_curr_sysdate DATE; -- Bug 4539703 this will store sysdate- 1 sec
212: ---Start: Bug fix 3051653
213: l_item_number mtl_system_items_interface.item_number%TYPE;
214: l_item_id mtl_system_items_interface.inventory_item_id%TYPE;
215: l_Itemid_error BOOLEAN := FALSE;
216:
217: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;
218: l_msg_text fnd_new_messages.message_text%TYPE;

Line 232: update mtl_system_items_interface

228:
229:
230: BEGIN
231:
232: update mtl_system_items_interface
233: set transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
234: where transaction_id is NULL
235: and set_process_id = xset_id;
236:

Line 233: set transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

229:
230: BEGIN
231:
232: update mtl_system_items_interface
233: set transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
234: where transaction_id is NULL
235: and set_process_id = xset_id;
236:
237: --Get profile options for default assignment

Line 263: 'MTL_SYSTEM_ITEMS_INTERFACE',

259: request_id,
260: tran_id,
261: err_text,
262: 'INV_STATUS_DEFAULT',
263: 'MTL_SYSTEM_ITEMS_INTERFACE',
264: 'INV_NO_DEFAULT_STATUS',
265: err_text);
266: if dumm_status < 0 then
267: raise LOGGING_ERR;

Line 304: 'MTL_SYSTEM_ITEMS_INTERFACE',

300: request_id,
301: tran_id,
302: err_text,
303: 'INV_UOM_DEFAULT',
304: 'MTL_SYSTEM_ITEMS_INTERFACE',
305: 'INV_NO_DEFAULT_UOM',
306: err_text);
307: if dumm_status < 0 then
308: raise LOGGING_ERR;

Line 345: 'MTL_SYSTEM_ITEMS_INTERFACE',

341: request_id,
342: cr.transaction_id,
343: 'INVPAGI2: Invalid Item ID',
344: 'inventory_item_id',
345: 'MTL_SYSTEM_ITEMS_INTERFACE',
346: 'INV_INVALID_INV_ITEM_ID',
347: err_text);
348: if dumm_status < 0 then
349: raise LOGGING_ERR;

Line 352: update mtl_system_items_interface

348: if dumm_status < 0 then
349: raise LOGGING_ERR;
350: end if;
351:
352: update mtl_system_items_interface
353: set process_flag = l_process_flag_3
354: where rowid = cr.rowid ;
355:
356: END IF;

Line 370: FROM mtl_system_items_interface

366: INVPUTLI.info('INVPAGI2: About to handle sequence generated item number case');
367: END IF;
368:
369: SELECT DISTINCT item_catalog_group_id BULK COLLECT INTO catalog_table
370: FROM mtl_system_items_interface
371: WHERE process_flag = 1
372: AND set_process_id = xset_id
373: AND ((organization_id = org_id) or (all_org = 1))
374: AND organization_id IN (SELECT master_organization_id /*Bug 6158936*/

Line 385: UPDATE mtl_system_items_interface msii

381: (p_item_catalog_group_id => catalog_table(i),
382: x_item_num_gen_method => l_item_num_gen_method,
383: x_item_desc_gen_method => l_item_desc_gen_method);
384: IF l_item_num_gen_method = 'S' THEN
385: UPDATE mtl_system_items_interface msii
386: SET msii.set_process_id = xset_id + 5000000000000
387: WHERE msii.process_flag = 1
388: AND msii.set_process_id = xset_id
389: AND nvl(msii.style_item_flag, 'N') <> 'Y' --Bug 6182208

Line 422: 'MTL_SYSTEM_ITEMS_INTERFACE',

418: request_id,
419: tran_id,
420: err_text,
421: null,
422: 'MTL_SYSTEM_ITEMS_INTERFACE',
423: 'SEQUENCE GEN ITEM NUM ' || l_msg_data,
424: err_text);
425: UPDATE mtl_system_items_interface
426: SET process_flag = 3

Line 425: UPDATE mtl_system_items_interface

421: null,
422: 'MTL_SYSTEM_ITEMS_INTERFACE',
423: 'SEQUENCE GEN ITEM NUM ' || l_msg_data,
424: err_text);
425: UPDATE mtl_system_items_interface
426: SET process_flag = 3
427: ,set_process_id = xset_id
428: WHERE set_process_id = xset_id + 5000000000000;
429: ELSE

Line 430: UPDATE mtl_system_items_interface

426: SET process_flag = 3
427: ,set_process_id = xset_id
428: WHERE set_process_id = xset_id + 5000000000000;
429: ELSE
430: UPDATE mtl_system_items_interface
431: SET set_process_id = xset_id
432: WHERE set_process_id = xset_id + 5000000000000;
433: END IF;
434: END IF; --Sequence Generated ICC items exist

Line 444: UPDATE mtl_system_items_interface msii

440: INVPUTLI.info('INVPAGI2: About to handle SKU items');
441: END IF;
442:
443: /* Mark all SKU items with no style item to error */
444: UPDATE mtl_system_items_interface msii
445: SET msii.process_flag = 3
446: WHERE msii.process_flag = 1
447: AND msii.transaction_type = 'CREATE'
448: AND msii.set_process_id = xset_id

Line 466: 'MTL_SYSTEM_ITEMS_INTERFACE',

462: request_id,
463: transaction_table(j),
464: err_text,
465: 'STYLE_ITEM_ID',
466: 'MTL_SYSTEM_ITEMS_INTERFACE',
467: 'INV_INVALID_STYLE_FOR_SKU' ,
468: err_text);
469: END LOOP;
470: END IF;

Line 475: FROM mtl_system_items_interface msii

471:
472: /* Resolve Style Item Numbers into Ids for SKU Items */
473: SELECT msii.style_item_number,msii.organization_id,transaction_id
474: BULK COLLECT INTO style_item_num_table, org_table, transaction_table
475: FROM mtl_system_items_interface msii
476: WHERE msii.process_flag = 1
477: AND msii.transaction_type = 'CREATE'
478: AND msii.set_process_id = xset_id
479: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp

Line 500: 'MTL_SYSTEM_ITEMS_INTERFACE',

496: request_id,
497: transaction_table(i),
498: err_text,
499: 'STYLE_ITEM_NUMBER',
500: 'MTL_SYSTEM_ITEMS_INTERFACE',
501: 'INV_INVALID_STYLE_FOR_SKU',
502: err_text);
503: IF dumm_status < 0 then
504: raise LOGGING_ERR;

Line 507: UPDATE mtl_system_items_interface msii

503: IF dumm_status < 0 then
504: raise LOGGING_ERR;
505: END IF;
506:
507: UPDATE mtl_system_items_interface msii
508: SET process_flag = 3
509: WHERE msii.process_flag = 1
510: AND msii.transaction_type = 'CREATE'
511: AND msii.set_process_id = xset_id

Line 516: UPDATE mtl_system_items_interface msii

512: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
513: WHERE mp.organization_id = msii.organization_id )
514: AND msii.style_item_number = style_item_num_table(i);
515: ELSE
516: UPDATE mtl_system_items_interface msii
517: SET msii.style_item_id = l_style_item_id
518: WHERE msii.process_flag = 1
519: AND msii.transaction_type = 'CREATE'
520: AND msii.set_process_id = xset_id

Line 548: from mtl_system_items_interface msii

544: ** statement to BIND the set_id variable to DSQL_ff_c */
545:
546: --3701962: Changed to exists clause.
547: DSQL_ff_statement := 'select msii.transaction_id
548: from mtl_system_items_interface msii
549: where msii.inventory_item_id is NULL
550: and msii.organization_id is not NULL
551: and msii.process_flag = 1
552: and msii.set_process_id = :set_id_bind

Line 580: 'MTL_SYSTEM_ITEMS_INTERFACE',

576: request_id,
577: DSQL_ff_transaction_id,
578: 'INVPAGI2: Duplicate Org ID and segments in MSI',
579: 'inventory_item_id',
580: 'MTL_SYSTEM_ITEMS_INTERFACE',
581: 'INV_DUPL_ORG_ITEM_SEG',
582: err_text);
583: if dumm_status < 0 then
584: raise LOGGING_ERR;

Line 587: update mtl_system_items_interface

583: if dumm_status < 0 then
584: raise LOGGING_ERR;
585: end if;
586:
587: update mtl_system_items_interface
588: set process_flag = l_process_flag_3
589: where transaction_id = DSQL_ff_transaction_id
590: and set_process_id = nvl(xset_id, set_process_id);
591: else

Line 621: 'MTL_SYSTEM_ITEMS_INTERFACE',

617: request_id,
618: tran_id,
619: err_text,
620: null,
621: 'MTL_SYSTEM_ITEMS_INTERFACE',
622: 'DYN_SQL_ERROR',
623: err_text);
624:
625: return(SQLCODE);

Line 630: mtl_system_items_interface msii,

626: END; /* PL-SQL Block for doing the dynamic SQL part*/
627:
628: DSQL_statement := 'select msi.inventory_item_id
629: from mtl_system_items msi,
630: mtl_system_items_interface msii,
631: mtl_parameters mp
632: where msii.transaction_id = :transaction_id_bind
633: and msii.set_process_id = :set_id_bind2
634: and rownum = 1

Line 727: 'MTL_SYSTEM_ITEMS_INTERFACE',

723: request_id,
724: tran_id,
725: err_text,
726: null,
727: 'MTL_SYSTEM_ITEMS_INTERFACE',
728: 'INV_SEG_ITM_NUMB_VAL',
729: err_text);
730: if dumm_status < 0 then
731: raise LOGGING_ERR;

Line 737: update mtl_system_items_interface

733: validation_check_status := -1;
734: end if;
735: end if;
736:
737: update mtl_system_items_interface
738: --Bug: 2821206 Replaced ltrim with trim for segment1..20
739: set segment1 = trim(segment1),
740: segment2 = trim(segment2),
741: segment3 = trim(segment3),

Line 939: update MTL_SYSTEM_ITEMS_INTERFACE

935: if dbms_sql.fetch_rows(DSQL_c) > 0 then
936: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
937: exists_id := DSQL_inventory_item_id;
938:
939: update MTL_SYSTEM_ITEMS_INTERFACE
940: set inventory_item_id = exists_id
941: where rowid = cr.rowid ;
942:
943: cr.inventory_item_id := exists_id;

Line 950: FROM mtl_system_items_interface msi, mtl_system_items_interface msii

946: IF l_inv_debug_level IN(101, 102) THEN
947: INVPUTLI.info('INVPAGI2: About to process DSQL 3 ');
948: END IF;
949: DSQL_Statement_Msii := 'SELECT msi.inventory_item_id
950: FROM mtl_system_items_interface msi, mtl_system_items_interface msii
951: WHERE msi.set_process_id = msii.set_process_id
952: AND msi.organization_id =
953: (SELECT mp.master_organization_id FROM mtl_parameters mp
954: WHERE mp.organization_id = msii.organization_id)

Line 979: update MTL_SYSTEM_ITEMS_INTERFACE

975: end if;
976:
977: if exists_id IS NOT NULL then
978:
979: update MTL_SYSTEM_ITEMS_INTERFACE
980: set inventory_item_id = exists_id
981: where rowid = cr.rowid ;
982:
983: cr.inventory_item_id := exists_id;

Line 992: update MTL_SYSTEM_ITEMS_INTERFACE

988: IF l_inv_debug_level IN(101, 102) THEN
989: INVPUTLI.info('INVPAGI2: No match in MSI; Creating Inventory Item Id from sequence');
990: END IF;
991:
992: update MTL_SYSTEM_ITEMS_INTERFACE
993: set inventory_item_id = MTL_SYSTEM_ITEMS_S.nextval
994: where rowid = cr.rowid
995: returning inventory_item_id INTO cr.inventory_item_id;
996:

Line 1020: 'MTL_SYSTEM_ITEMS_INTERFACE',

1016: request_id,
1017: tran_id,
1018: err_text,
1019: null,
1020: 'MTL_SYSTEM_ITEMS_INTERFACE',
1021: 'DYN_SQL_ERROR',
1022: err_text);
1023:
1024: return(SQLCODE);

Line 1101: from mtl_system_items_interface

1097: INVPUTLI.info('INVPAGI2: Orphan found; checking in msii ');
1098: END IF;
1099:
1100: select count(*) into msiicount
1101: from mtl_system_items_interface
1102: where inventory_item_id = cr.inventory_item_id
1103: and organization_id = master_org_id
1104: and set_process_id = xset_id
1105: and process_flag in (1,60000+1); /*masters are moved to 60000+ to before calling child create*/

Line 1120: 'MTL_SYSTEM_ITEMS_INTERFACE',

1116: request_id,
1117: tran_id,
1118: error_msg,
1119: 'ORGANIZATION_ID',
1120: 'MTL_SYSTEM_ITEMS_INTERFACE',
1121: 'INV_IOI_ORPHAN_CHILD',
1122: err_text);
1123: if dumm_status < 0 then
1124: raise LOGGING_ERR;

Line 1168: update MTL_SYSTEM_ITEMS_INTERFACE

1164: end if; /*rtn_status = 0*/
1165: end if;
1166: end if;
1167:
1168: update MTL_SYSTEM_ITEMS_INTERFACE
1169: set cost_of_sales_account = nvl(cost_of_sales_account,d_cost_of_sales_account),
1170: encumbrance_account = nvl(encumbrance_account,d_encumbrance_account),
1171: sales_account = nvl(sales_account,d_sales_account),
1172: expense_account = nvl(expense_account,d_expense_account)

Line 1179: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII

1175: /*Bug 6417006 - Converting '!' to NULL and -999999 to NULL. This done to
1176: * ensure NULL attribute values while applying
1177: * Template with enabled attribute values as NULL. This is for the 'CREATE'
1178: * mode of the IOI*/
1179: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
1180: SET
1181: DESCRIPTION = DECODE( DESCRIPTION, g_Upd_Null_CHAR, NULL,
1182: trim(DESCRIPTION )),
1183: LONG_DESCRIPTION = DECODE( LONG_DESCRIPTION, g_Upd_Null_CHAR, NULL,

Line 1799: update MTL_SYSTEM_ITEMS_INTERFACE

1795: else /*validation check failed */
1796: process_flag_temp := 3;
1797: end if;
1798:
1799: update MTL_SYSTEM_ITEMS_INTERFACE
1800: set process_flag = process_flag_temp,
1801: creation_date = nvl(creation_date, l_sysdate),
1802: revision = cr.revision
1803: where rowid = cr.rowid ;

Line 1817: 'MTL_SYSTEM_ITEMS_INTERFACE',

1813: request_id,
1814: tran_id,
1815: err_text,
1816: 'DESCRIPTION',
1817: 'MTL_SYSTEM_ITEMS_INTERFACE',
1818: 'INV_DESC_ITEM_ERROR',
1819: err_text);
1820: else
1821: rtn_status := INVPUOPI.mtl_log_interface_err(

Line 1831: 'MTL_SYSTEM_ITEMS_INTERFACE',

1827: request_id,
1828: cr.transaction_id,
1829: err_text,
1830: null,
1831: 'MTL_SYSTEM_ITEMS_INTERFACE',
1832: 'BOM_PARSE_ITEM_ERROR',
1833: err_text);
1834: end if;
1835: if rtn_status < 0 then

Line 1850: 'MTL_SYSTEM_ITEMS_INTERFACE',

1846: request_id,
1847: tran_id,
1848: err_text,
1849: 'ORGANIZATION_ID',
1850: 'MTL_SYSTEM_ITEMS_INTERFACE',
1851: 'INVALID ORGANIZATION',
1852: err_text);
1853: if dumm_status < 0 then
1854: raise LOGGING_ERR;

Line 1857: update mtl_system_items_interface

1853: if dumm_status < 0 then
1854: raise LOGGING_ERR;
1855: end if;
1856:
1857: update mtl_system_items_interface
1858: set process_flag = l_process_flag_3
1859: where rowid = cr.rowid ;
1860: end if; --org_flag <> 0
1861:

Line 1880: 'MTL_SYSTEM_ITEMS_INTERFACE',

1876: request_id,
1877: tran_id,
1878: err_text,
1879: null,
1880: 'MTL_SYSTEM_ITEMS_INTERFACE',
1881: 'BOM_PARSE_ITEM_ERROR',
1882: err_text);
1883: return(rtn_status);
1884:

Line 1899: 'MTL_SYSTEM_ITEMS_INTERFACE',

1895: request_id,
1896: tran_id,
1897: err_text,
1898: null,
1899: 'MTL_SYSTEM_ITEMS_INTERFACE',
1900: 'BOM_PARSE_ITEM_ERROR',
1901: err_text);
1902: if (rtn_status = 0) then
1903: rtn_status := -1;