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 68: from MTL_SYSTEM_ITEMS_INTERFACE

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

Line 89: from mtl_system_items_interface child

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

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

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

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

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

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

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

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

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

Line 216: l_item_number mtl_system_items_interface.item_number%TYPE;

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

Line 217: l_item_id mtl_system_items_interface.inventory_item_id%TYPE;

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

Line 244: update mtl_system_items_interface

240: l_temp_org_id number;
241:
242: BEGIN
243:
244: update mtl_system_items_interface
245: set transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
246: where transaction_id is NULL
247: and set_process_id = xset_id;
248:

Line 245: set transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

241:
242: BEGIN
243:
244: update mtl_system_items_interface
245: set transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
246: where transaction_id is NULL
247: and set_process_id = xset_id;
248:
249: --Get profile options for default assignment

Line 275: 'MTL_SYSTEM_ITEMS_INTERFACE',

271: request_id,
272: tran_id,
273: err_text,
274: 'INV_STATUS_DEFAULT',
275: 'MTL_SYSTEM_ITEMS_INTERFACE',
276: 'INV_NO_DEFAULT_STATUS',
277: err_text);
278: if dumm_status < 0 then
279: raise LOGGING_ERR;

Line 316: 'MTL_SYSTEM_ITEMS_INTERFACE',

312: request_id,
313: tran_id,
314: err_text,
315: 'INV_UOM_DEFAULT',
316: 'MTL_SYSTEM_ITEMS_INTERFACE',
317: 'INV_NO_DEFAULT_UOM',
318: err_text);
319: if dumm_status < 0 then
320: raise LOGGING_ERR;

Line 363: 'MTL_SYSTEM_ITEMS_INTERFACE',

359: request_id,
360: cr.transaction_id,
361: 'INVPAGI2: Invalid Item ID',
362: 'inventory_item_id',
363: 'MTL_SYSTEM_ITEMS_INTERFACE',
364: 'INV_INVALID_INV_ITEM_ID',
365: err_text);
366: if dumm_status < 0 then
367: raise LOGGING_ERR;

Line 370: update mtl_system_items_interface

366: if dumm_status < 0 then
367: raise LOGGING_ERR;
368: end if;
369:
370: update mtl_system_items_interface
371: set process_flag = l_process_flag_3
372: where rowid = cr.rowid ;
373:
374: END IF;

Line 388: FROM mtl_system_items_interface

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
389: WHERE process_flag = 1
390: AND set_process_id = xset_id
391: AND ((organization_id = org_id) or (all_org = 1))
392: AND organization_id IN (SELECT master_organization_id /*Bug 6158936*/

Line 403: UPDATE mtl_system_items_interface msii

399: (p_item_catalog_group_id => catalog_table(i),
400: x_item_num_gen_method => l_item_num_gen_method,
401: x_item_desc_gen_method => l_item_desc_gen_method);
402: IF l_item_num_gen_method = 'S' THEN
403: UPDATE mtl_system_items_interface msii
404: SET msii.set_process_id = xset_id + 5000000000000
405: WHERE msii.process_flag = 1
406: AND msii.set_process_id = xset_id
407: AND nvl(msii.style_item_flag, 'N') <> 'Y' --Bug 6182208

Line 440: 'MTL_SYSTEM_ITEMS_INTERFACE',

436: request_id,
437: tran_id,
438: err_text,
439: null,
440: 'MTL_SYSTEM_ITEMS_INTERFACE',
441: 'SEQUENCE GEN ITEM NUM ' || l_msg_data,
442: err_text);
443: UPDATE mtl_system_items_interface
444: SET process_flag = 3

Line 443: UPDATE mtl_system_items_interface

439: null,
440: 'MTL_SYSTEM_ITEMS_INTERFACE',
441: 'SEQUENCE GEN ITEM NUM ' || l_msg_data,
442: err_text);
443: UPDATE mtl_system_items_interface
444: SET process_flag = 3
445: ,set_process_id = xset_id
446: WHERE set_process_id = xset_id + 5000000000000;
447: ELSE

Line 448: UPDATE mtl_system_items_interface

444: SET process_flag = 3
445: ,set_process_id = xset_id
446: WHERE set_process_id = xset_id + 5000000000000;
447: ELSE
448: UPDATE mtl_system_items_interface
449: SET set_process_id = xset_id
450: WHERE set_process_id = xset_id + 5000000000000;
451: END IF;
452: END IF; --Sequence Generated ICC items exist

Line 462: UPDATE mtl_system_items_interface msii

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
463: SET msii.process_flag = 3
464: WHERE msii.process_flag = 1
465: AND msii.transaction_type = 'CREATE'
466: AND msii.set_process_id = xset_id

Line 484: 'MTL_SYSTEM_ITEMS_INTERFACE',

480: request_id,
481: transaction_table(j),
482: err_text,
483: 'STYLE_ITEM_ID',
484: 'MTL_SYSTEM_ITEMS_INTERFACE',
485: 'INV_INVALID_STYLE_FOR_SKU' ,
486: err_text);
487: END LOOP;
488: END IF;

Line 493: FROM mtl_system_items_interface msii

489:
490: /* Resolve Style Item Numbers into Ids for SKU Items */
491: SELECT msii.style_item_number,msii.organization_id,transaction_id
492: BULK COLLECT INTO style_item_num_table, org_table, transaction_table
493: FROM mtl_system_items_interface msii
494: WHERE msii.process_flag = 1
495: AND msii.transaction_type = 'CREATE'
496: AND msii.set_process_id = xset_id
497: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp

Line 518: 'MTL_SYSTEM_ITEMS_INTERFACE',

514: request_id,
515: transaction_table(i),
516: err_text,
517: 'STYLE_ITEM_NUMBER',
518: 'MTL_SYSTEM_ITEMS_INTERFACE',
519: 'INV_INVALID_STYLE_FOR_SKU',
520: err_text);
521: IF dumm_status < 0 then
522: raise LOGGING_ERR;

Line 525: UPDATE mtl_system_items_interface msii

521: IF dumm_status < 0 then
522: raise LOGGING_ERR;
523: END IF;
524:
525: UPDATE mtl_system_items_interface msii
526: SET process_flag = 3
527: WHERE msii.process_flag = 1
528: AND msii.transaction_type = 'CREATE'
529: AND msii.set_process_id = xset_id

Line 534: UPDATE mtl_system_items_interface msii

530: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
531: WHERE mp.organization_id = msii.organization_id )
532: AND msii.style_item_number = style_item_num_table(i);
533: ELSE
534: UPDATE mtl_system_items_interface msii
535: SET msii.style_item_id = l_style_item_id
536: WHERE msii.process_flag = 1
537: AND msii.transaction_type = 'CREATE'
538: AND msii.set_process_id = xset_id

Line 566: from mtl_system_items_interface msii

562: ** statement to BIND the set_id variable to DSQL_ff_c */
563:
564: --3701962: Changed to exists clause.
565: DSQL_ff_statement := 'select msii.transaction_id
566: from mtl_system_items_interface msii
567: where msii.inventory_item_id is NULL
568: and msii.organization_id is not NULL
569: and msii.process_flag = 1
570: and msii.set_process_id = :set_id_bind

Line 598: 'MTL_SYSTEM_ITEMS_INTERFACE',

594: request_id,
595: DSQL_ff_transaction_id,
596: 'INVPAGI2: Duplicate Org ID and segments in MSI',
597: 'inventory_item_id',
598: 'MTL_SYSTEM_ITEMS_INTERFACE',
599: 'INV_DUPL_ORG_ITEM_SEG',
600: err_text);
601: if dumm_status < 0 then
602: raise LOGGING_ERR;

Line 605: update mtl_system_items_interface

601: if dumm_status < 0 then
602: raise LOGGING_ERR;
603: end if;
604:
605: update mtl_system_items_interface
606: set process_flag = l_process_flag_3
607: where transaction_id = DSQL_ff_transaction_id
608: and set_process_id = nvl(xset_id, set_process_id);
609: else

Line 639: 'MTL_SYSTEM_ITEMS_INTERFACE',

635: request_id,
636: tran_id,
637: err_text,
638: null,
639: 'MTL_SYSTEM_ITEMS_INTERFACE',
640: 'DYN_SQL_ERROR',
641: err_text);
642:
643: return(SQLCODE);

Line 652: mtl_system_items_interface msii

648: /*Bug 8808591 - Changing driving table according to Perf team suggestion*/
649: DSQL_statement := 'select msi.inventory_item_id
650: from mtl_parameters mp,
651: mtl_system_items msi,
652: mtl_system_items_interface msii
653:
654: where msii.transaction_id = :transaction_id_bind
655: and msii.set_process_id = :set_id_bind2
656: and rownum = 1

Line 733: 'MTL_SYSTEM_ITEMS_INTERFACE',

729: request_id,
730: tran_id,
731: err_text,
732: null,
733: 'MTL_SYSTEM_ITEMS_INTERFACE',
734: 'INV_ITEM_INVALID',
735: err_text);
736:
737: UPDATE mtl_system_items_interface

Line 737: UPDATE mtl_system_items_interface

733: 'MTL_SYSTEM_ITEMS_INTERFACE',
734: 'INV_ITEM_INVALID',
735: err_text);
736:
737: UPDATE mtl_system_items_interface
738: SET process_flag = 3
739: WHERE ROWID= cr.ROWID;
740:
741: CONTINUE;

Line 776: 'MTL_SYSTEM_ITEMS_INTERFACE',

772: request_id,
773: tran_id,
774: err_text,
775: null,
776: 'MTL_SYSTEM_ITEMS_INTERFACE',
777: 'INV_SEG_ITM_NUMB_VAL',
778: err_text);
779: if dumm_status < 0 then
780: raise LOGGING_ERR;

Line 786: update mtl_system_items_interface

782: validation_check_status := -1;
783: end if;
784: end if;
785:
786: update mtl_system_items_interface
787: --Bug: 2821206 Replaced ltrim with trim for segment1..20
788: set segment1 = trim(segment1),
789: segment2 = trim(segment2),
790: segment3 = trim(segment3),

Line 988: update MTL_SYSTEM_ITEMS_INTERFACE

984: if dbms_sql.fetch_rows(DSQL_c) > 0 then
985: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
986: exists_id := DSQL_inventory_item_id;
987:
988: update MTL_SYSTEM_ITEMS_INTERFACE
989: set inventory_item_id = exists_id
990: where rowid = cr.rowid ;
991:
992: cr.inventory_item_id := exists_id;

Line 1008: DSQL_Statement_Msii := 'SELECT /+ index(msii MTL_SYSTEM_ITEMS_INTERFACE_N6) index(msi MTL_SYSTEM_ITEMS_INTERFACE_N4) / msi.inventory_item_id

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
1010: WHERE msi.set_process_id = msii.set_process_id
1011: AND msi.organization_id =
1012: (SELECT mp.master_organization_id FROM mtl_parameters mp

Line 1009: FROM mtl_system_items_interface msi, mtl_system_items_interface msii

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
1010: WHERE msi.set_process_id = msii.set_process_id
1011: AND msi.organization_id =
1012: (SELECT mp.master_organization_id FROM mtl_parameters mp
1013: WHERE mp.organization_id = msii.organization_id)

Line 1038: update MTL_SYSTEM_ITEMS_INTERFACE

1034: end if;
1035:
1036: if exists_id IS NOT NULL then
1037:
1038: update MTL_SYSTEM_ITEMS_INTERFACE
1039: set inventory_item_id = exists_id
1040: where rowid = cr.rowid ;
1041:
1042: cr.inventory_item_id := exists_id;

Line 1054: /*update MTL_SYSTEM_ITEMS_INTERFACE

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
1056: where rowid = cr.rowid
1057: returning inventory_item_id INTO cr.inventory_item_id;*/ /*Changed for bug 8808591*/
1058:

Line 1059: update MTL_SYSTEM_ITEMS_INTERFACE

1055: set inventory_item_id = MTL_SYSTEM_ITEMS_S.nextval
1056: where rowid = cr.rowid
1057: returning inventory_item_id INTO cr.inventory_item_id;*/ /*Changed for bug 8808591*/
1058:
1059: update MTL_SYSTEM_ITEMS_INTERFACE
1060: set inventory_item_id = MTL_SYSTEM_ITEMS_S.nextval
1061: where rowid = cr.rowid;
1062:
1063: select MTL_SYSTEM_ITEMS_S.CURRVAL INTO cr.inventory_item_id FROM DUAL;

Line 1088: 'MTL_SYSTEM_ITEMS_INTERFACE',

1084: request_id,
1085: tran_id,
1086: err_text,
1087: null,
1088: 'MTL_SYSTEM_ITEMS_INTERFACE',
1089: 'DYN_SQL_ERROR',
1090: err_text);
1091:
1092: return(SQLCODE);

Line 1193: from mtl_system_items_interface

1189: INVPUTLI.info('INVPAGI2: Orphan found; checking in msii ');
1190: END IF;
1191:
1192: select count(*) into msiicount
1193: from mtl_system_items_interface
1194: where inventory_item_id = cr.inventory_item_id
1195: and organization_id = master_org_id
1196: and set_process_id = xset_id
1197: and process_flag in (1,60000+1); /*masters are moved to 60000+ to before calling child create*/

Line 1212: 'MTL_SYSTEM_ITEMS_INTERFACE',

1208: request_id,
1209: tran_id,
1210: error_msg,
1211: 'ORGANIZATION_ID',
1212: 'MTL_SYSTEM_ITEMS_INTERFACE',
1213: 'INV_IOI_ORPHAN_CHILD',
1214: err_text);
1215: if dumm_status < 0 then
1216: raise LOGGING_ERR;

Line 1260: update MTL_SYSTEM_ITEMS_INTERFACE

1256: end if; /*rtn_status = 0*/
1257: end if;
1258: end if;
1259:
1260: update MTL_SYSTEM_ITEMS_INTERFACE
1261: set cost_of_sales_account = nvl(cost_of_sales_account,d_cost_of_sales_account),
1262: encumbrance_account = nvl(encumbrance_account,d_encumbrance_account),
1263: sales_account = nvl(sales_account,d_sales_account),
1264: expense_account = nvl(expense_account,d_expense_account)

Line 1271: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII

1267: /*Bug 6417006 - Converting '!' to NULL and -999999 to NULL. This done to
1268: * ensure NULL attribute values while applying
1269: * Template with enabled attribute values as NULL. This is for the 'CREATE'
1270: * mode of the IOI*/
1271: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
1272: SET
1273: -- Serial_Tagging Eng -- bug 9913552
1274: copy_item_id = Decode (copy_item_id, g_upd_null_NUM, NULL,
1275: copy_item_id),

Line 1718: update MTL_SYSTEM_ITEMS_INTERFACE

1714: cr.rowid);
1715: if rtn_status <> 0 then
1716: -- raise ASS_ITEM_ERR;
1717: -- 14170679, doesn't break import, flag it and continue
1718: update MTL_SYSTEM_ITEMS_INTERFACE
1719: set process_flag = l_process_flag_3
1720: where rowid = cr.rowid ;
1721:
1722: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1732: 'MTL_SYSTEM_ITEMS_INTERFACE',

1728: request_id,
1729: cr.transaction_id,
1730: 'INVPAGI2: Invalid Item Status Code',
1731: 'INVENTORY_ITEM_STATUS_CODE',
1732: 'MTL_SYSTEM_ITEMS_INTERFACE',
1733: 'INV_IOI_STATUS_CODE',
1734: err_text);
1735: if dumm_status < 0 then
1736: raise LOGGING_ERR;

Line 1779: 'MTL_SYSTEM_ITEMS_INTERFACE',

1775: request_id,
1776: tran_id,
1777: error_msg,
1778: 'SERIAL_TAGGING_FLAG',
1779: 'MTL_SYSTEM_ITEMS_INTERFACE',
1780: 'INV_COPY_SER_FAIL_UNEXP',
1781: err_text);
1782: if dumm_status < 0 then
1783: raise LOGGING_ERR;

Line 1826: 'MTL_SYSTEM_ITEMS_INTERFACE',

1822: request_id,
1823: tran_id,
1824: error_msg,
1825: 'SERIAL_TAGGING_FLAG',
1826: 'MTL_SYSTEM_ITEMS_INTERFACE',
1827: 'NV_COPY_SER_FAIL_UNEXP',
1828: err_text);
1829: if dumm_status < 0 then
1830: raise LOGGING_ERR;

Line 1882: 'MTL_SYSTEM_ITEMS_INTERFACE',

1878: request_id,
1879: tran_id,
1880: err_text,
1881: null,
1882: 'MTL_SYSTEM_ITEMS_INTERFACE',
1883: 'INV_ITEM_INVALID',
1884: err_text);
1885:
1886: UPDATE mtl_system_items_interface

Line 1886: UPDATE mtl_system_items_interface

1882: 'MTL_SYSTEM_ITEMS_INTERFACE',
1883: 'INV_ITEM_INVALID',
1884: err_text);
1885:
1886: UPDATE mtl_system_items_interface
1887: SET process_flag = 3
1888: WHERE ROWID= cr.ROWID;
1889:
1890: CONTINUE;

Line 2050: update MTL_SYSTEM_ITEMS_INTERFACE

2046: else /*validation check failed */
2047: process_flag_temp := 3;
2048: end if;
2049:
2050: update MTL_SYSTEM_ITEMS_INTERFACE
2051: set process_flag = process_flag_temp,
2052: creation_date = nvl(creation_date, l_sysdate),
2053: revision = cr.revision
2054: where rowid = cr.rowid ;

Line 2069: 'MTL_SYSTEM_ITEMS_INTERFACE',

2065: request_id,
2066: tran_id,
2067: error_msg,
2068: 'DESCRIPTION',
2069: 'MTL_SYSTEM_ITEMS_INTERFACE',
2070: 'INV_DESC_ITEM_ERROR',
2071: err_text);
2072: else
2073: rtn_status := INVPUOPI.mtl_log_interface_err(

Line 2083: 'MTL_SYSTEM_ITEMS_INTERFACE',

2079: request_id,
2080: cr.transaction_id,
2081: error_msg,
2082: null,
2083: 'MTL_SYSTEM_ITEMS_INTERFACE',
2084: 'BOM_PARSE_ITEM_ERROR',
2085: err_text);
2086: end if;
2087: if rtn_status < 0 then

Line 2102: 'MTL_SYSTEM_ITEMS_INTERFACE',

2098: request_id,
2099: tran_id,
2100: err_text,
2101: 'ORGANIZATION_ID',
2102: 'MTL_SYSTEM_ITEMS_INTERFACE',
2103: 'INVALID ORGANIZATION',
2104: err_text);
2105: if dumm_status < 0 then
2106: raise LOGGING_ERR;

Line 2109: update mtl_system_items_interface

2105: if dumm_status < 0 then
2106: raise LOGGING_ERR;
2107: end if;
2108:
2109: update mtl_system_items_interface
2110: set process_flag = l_process_flag_3
2111: where rowid = cr.rowid ;
2112: end if; --org_flag <> 0
2113:

Line 2124: TABNAME => 'MTL_SYSTEM_ITEMS_INTERFACE',

2120:
2121: IF (nvl(fnd_profile.value('EGO_ENABLE_GATHER_STATS'),'N') = 'Y') THEN
2122:
2123: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2124: TABNAME => 'MTL_SYSTEM_ITEMS_INTERFACE',
2125: CASCADE => True);
2126: END IF;
2127:
2128: END IF;

Line 2145: 'MTL_SYSTEM_ITEMS_INTERFACE',

2141: request_id,
2142: tran_id,
2143: error_msg,
2144: null,
2145: 'MTL_SYSTEM_ITEMS_INTERFACE',
2146: 'BOM_PARSE_ITEM_ERROR',
2147: err_text);
2148: return(rtn_status);
2149:

Line 2167: 'MTL_SYSTEM_ITEMS_INTERFACE',

2163: request_id,
2164: tran_id,
2165: err_text,
2166: null,
2167: 'MTL_SYSTEM_ITEMS_INTERFACE',
2168: 'INV_ITEM_INVALID',
2169: err_text);
2170: return(rtn_status);
2171: */

Line 2184: 'MTL_SYSTEM_ITEMS_INTERFACE',

2180: request_id,
2181: tran_id,
2182: error_msg,
2183: null,
2184: 'MTL_SYSTEM_ITEMS_INTERFACE',
2185: 'BOM_PARSE_ITEM_ERROR',
2186: err_text);
2187: if (rtn_status = 0) then
2188: rtn_status := -1;