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.EGO_ITEM_BULKLOAD_PKG dependencies on MTL_INTERFACE_ERRORS

Line 629: -- Insert into MTL_INTERFACE_ERRORS through autonomous transaction

625: RAISE;
626: END delete_records_from_MSII;
627: -----------------------------------------------------------------------
628: -- Fix for Bug# 3970069.
629: -- Insert into MTL_INTERFACE_ERRORS through autonomous transaction
630: -- commit. Earlier for any exception during Java Conc Program's
631: -- AM.commit(), the errors wouldnot get logged. By following Autonomous
632: -- Transaction block, that issue gets resolved.
633: -----------------------------------------------------------------------

Line 646: INSERT INTO MTL_INTERFACE_ERRORS

642:
643: BEGIN
644: SetGobals();
645:
646: INSERT INTO MTL_INTERFACE_ERRORS
647: ( ORGANIZATION_ID
648: , UNIQUE_ID
649: , LAST_UPDATE_DATE
650: , LAST_UPDATED_BY

Line 2933: l_dyn_sql := l_dyn_sql || 'INSERT INTO MTL_INTERFACE_ERRORS ';

2929: -----------------------------------------------------------------------
2930: --Insert the Pre-processed error messages.
2931: -----------------------------------------------------------------------
2932: l_dyn_sql := '';
2933: l_dyn_sql := l_dyn_sql || 'INSERT INTO MTL_INTERFACE_ERRORS ';
2934: l_dyn_sql := l_dyn_sql || '( ';
2935: l_dyn_sql := l_dyn_sql || ' ORGANIZATION_ID ';
2936: l_dyn_sql := l_dyn_sql || ', UNIQUE_ID ';
2937: l_dyn_sql := l_dyn_sql || ', LAST_UPDATE_DATE ';

Line 3051: Write_Debug('MIERR: Inserted Pre-processed error messages in MTL_INTERFACE_ERRORS');

3047: Write_Debug(SUBSTRB(l_dyn_sql, 1, 1000));
3048: Write_Debug(SUBSTRB(l_dyn_sql, 1001, 2000));
3049: EXECUTE IMMEDIATE l_dyn_sql USING p_resultfmt_usage_id;
3050:
3051: Write_Debug('MIERR: Inserted Pre-processed error messages in MTL_INTERFACE_ERRORS');
3052:
3053: -----------------------------------------------------------------------
3054: --Now that the error messages are inserted, update MSII lines to
3055: --Process status ERROR.

Line 3376: -- Errors are populated in MTL_INTERFACE_ERRORS

3372: -- TYPE : Private
3373: -- Pre-reqs : None
3374: -- FUNCTION : Populate and Load Item Revisions interfance lines.
3375: -- Loads Item Revision Attr Values
3376: -- Errors are populated in MTL_INTERFACE_ERRORS
3377: --
3378:
3379: ------------------------------------------------------------------------------------------
3380: -- To get the Item Revision Base attr columns in the Result Format.

Line 4391: -- Errors are populated in MTL_INTERFACE_ERRORS

4387: -- TYPE : Public
4388: -- Pre-reqs : None
4389: -- FUNCTION : Load Item User-Defined Attributes interfance lines.
4390: -- Loads Item User-Defined Attribute Values
4391: -- Errors are populated in MTL_INTERFACE_ERRORS
4392:
4393: ------------------------------------------------------------------------------
4394: -- To retrieve Attribute group codes, for given Result Format Usage ID.
4395: ------------------------------------------------------------------------------

Line 5353: -- Errors are populated in MTL_INTERFACE_ERRORS

5349: -- FUNCTION : Populate and Loads Item operational attribute values in MSII.
5350: -- These operational attributes made available in Item Search Results
5351: -- through User-Defined Attributes framework.
5352: --
5353: -- Errors are populated in MTL_INTERFACE_ERRORS
5354: --
5355:
5356: ------------------------------------------------------------------------
5357: -- To get the count of Item Operational Attr Groups Result Format. --

Line 5930: l_dyn_sql := l_dyn_sql || 'INSERT INTO MTL_INTERFACE_ERRORS ';

5926: -----------------------------------------------------------------------
5927: --Insert the Value Set error messages.
5928: -----------------------------------------------------------------------
5929: l_dyn_sql := '';
5930: l_dyn_sql := l_dyn_sql || 'INSERT INTO MTL_INTERFACE_ERRORS ';
5931: l_dyn_sql := l_dyn_sql || '( ';
5932: l_dyn_sql := l_dyn_sql || ' ORGANIZATION_ID ';
5933: l_dyn_sql := l_dyn_sql || ', UNIQUE_ID ';
5934: l_dyn_sql := l_dyn_sql || ', LAST_UPDATE_DATE ';

Line 6174: -- Errors are populated in MTL_INTERFACE_ERRORS

6170: -- TYPE : Public (called by Concurrent Program Wrapper API)
6171: -- Pre-reqs : None
6172: -- FUNCTION : Process and Load Item interfance lines.
6173: -- Loads Item Attr Values + Item User-Defined Attr Values
6174: -- Errors are populated in MTL_INTERFACE_ERRORS
6175: --
6176:
6177: CURSOR c_resultfmt_info (c_resultfmt_usage_id IN NUMBER) IS
6178: SELECT Nvl(fmt.data_level, G_ITEM_DATA_LEVEL)

Line 6201: FROM mtl_interface_errors

6197: AND attribute_code = G_REV_CODE_ATTR_CODE;
6198:
6199: CURSOR c_mtl_intf_err_row_exists IS
6200: SELECT 'x'
6201: FROM mtl_interface_errors
6202: WHERE request_id = FND_GLOBAL.conc_request_id;
6203:
6204:
6205: --Long Dynamic SQL String

Line 6548: -- Log Errors only to MTL_INTERFACE_ERRORS table.

6544: AND EIUAT.PROCESS_STATUS = 1
6545: AND EIUAT.DATA_LEVEL_ID=43106);
6546:
6547: -------------------------------------------------------------
6548: -- Log Errors only to MTL_INTERFACE_ERRORS table.
6549: -------------------------------------------------------------
6550: Error_Handler.Log_Error(
6551: p_write_err_to_inttable => 'Y',
6552: p_write_err_to_debugfile => 'Y'

Line 6565: l_dyn_sql := l_dyn_sql || 'FROM MTL_INTERFACE_ERRORS MIERR, '||G_NEWLINE;

6561: l_dyn_sql := l_dyn_sql || 'EBI.C_INTF_ATTR240 ITEM_NUMBER, '||G_NEWLINE;
6562: l_dyn_sql := l_dyn_sql || 'EBI.C_INTF_ATTR241 ORGANIZATION_CODE, '||G_NEWLINE;
6563: l_dyn_sql := l_dyn_sql || 'EBI.C_INTF_ATTR242 REVISION_CODE, '||G_NEWLINE;
6564: l_dyn_sql := l_dyn_sql || 'MIERR.ERROR_MESSAGE '||G_NEWLINE;
6565: l_dyn_sql := l_dyn_sql || 'FROM MTL_INTERFACE_ERRORS MIERR, '||G_NEWLINE;
6566: l_dyn_sql := l_dyn_sql || 'EGO_BULKLOAD_INTF EBI '||G_NEWLINE;
6567: l_dyn_sql := l_dyn_sql || 'WHERE MIERR.TRANSACTION_ID = EBI.TRANSACTION_ID '||G_NEWLINE;
6568: l_dyn_sql := l_dyn_sql || 'AND MIERR.request_id = '||G_REQUEST_ID||G_NEWLINE;
6569: Developer_Debug('In Case Error Reporting page has problems, Execute the following SQL to fetch the Concurrent Program CUMULATIVE Errors: ');

Line 6581: -- Check to See if Errors exist in MTL_INTERFACE_ERRORS.

6577: Developer_Debug('COMMITing at the end.');
6578: END IF;
6579:
6580: ------------------------------------------------------------
6581: -- Check to See if Errors exist in MTL_INTERFACE_ERRORS.
6582: -- If Exists, then set the Status as Completed w/ Warnings.
6583: ------------------------------------------------------------
6584: OPEN c_mtl_intf_err_row_exists;
6585: FETCH c_mtl_intf_err_row_exists INTO l_temp_txt;

Line 6587: Developer_Debug('Errors exist in MTL_INTERFACE_ERRORS.');

6583: ------------------------------------------------------------
6584: OPEN c_mtl_intf_err_row_exists;
6585: FETCH c_mtl_intf_err_row_exists INTO l_temp_txt;
6586: IF c_mtl_intf_err_row_exists%FOUND THEN
6587: Developer_Debug('Errors exist in MTL_INTERFACE_ERRORS.');
6588: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', --Status
6589: 'Completed with Warnings' --Message
6590: );
6591: x_retcode := Error_Handler.G_STATUS_WARNING;

Line 6593: Developer_Debug('NO Errors exist in MTL_INTERFACE_ERRORS.');

6589: 'Completed with Warnings' --Message
6590: );
6591: x_retcode := Error_Handler.G_STATUS_WARNING;
6592: ELSE
6593: Developer_Debug('*NO* Errors exist in MTL_INTERFACE_ERRORS.');
6594: x_retcode := G_STATUS_SUCCESS;
6595: END IF;
6596: CLOSE c_mtl_intf_err_row_exists;
6597: