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.WIP_MTLINTERFACEPROC_PUB dependencies on WIP_CONSTANTS

Line 29: if (l_logLevel <= wip_constants.trace_logging) then

25: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
26: begin
27: savepoint wipintpb0;
28:
29: if (l_logLevel <= wip_constants.trace_logging) then
30: l_params(1).paramName := 'p_txnHdrID';
31: l_params(1).paramValue := p_txnHdrID;
32: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
33: p_params => l_params,

Line 54: if (l_logLevel <= wip_constants.trace_logging) then

50: if(fnd_api.to_boolean(p_commit)) then
51: commit;
52: end if;
53:
54: if (l_logLevel <= wip_constants.trace_logging) then
55: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
56: p_procReturnStatus => x_returnStatus,
57: p_msg => 'attempted to process all rows successfully (no exceptions encountered).',
58: x_returnStatus => l_returnStatus); --discard logging return status

Line 67: if (l_logLevel <= wip_constants.trace_logging) then

63: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
64: wip_utilities.get_message_stack(p_msg => l_errMessage,
65: p_separator => ' ',
66: p_delete_stack => fnd_api.g_false);
67: if (l_logLevel <= wip_constants.trace_logging) then
68: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
69: p_procReturnStatus => x_returnStatus,
70: p_msg => 'proc failure:' || l_errMessage,
71: x_returnStatus => l_returnStatus); --discard logging return status

Line 90: process_flag = wip_constants.mti_error

86: for i in 1..l_intTbl.count loop
87: update mtl_transactions_interface
88: set error_code = l_errCodeTbl(i),
89: error_explanation = l_errExpTbl(i),
90: process_flag = wip_constants.mti_error
91: where transaction_header_id = p_txnHdrID
92: and transaction_interface_id = l_intTbl(i);
93: end loop;
94: when others then --some unhandled exception occurred. rollback everything.

Line 96: if (l_logLevel <= wip_constants.trace_logging) then

92: and transaction_interface_id = l_intTbl(i);
93: end loop;
94: when others then --some unhandled exception occurred. rollback everything.
95: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
96: if (l_logLevel <= wip_constants.trace_logging) then
97: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
98: p_procReturnStatus => x_returnStatus,
99: p_msg => 'exception' || SQLERRM,
100: x_returnStatus => l_returnStatus); --discard logging return status

Line 115: process_flag = wip_constants.mti_error

111: l_errMessage := substr(l_errMessage,1,240);
112: update mtl_transactions_interface
113: set error_code = 'wip_mtlInterfaceProc_pub.processInterface()',
114: error_explanation = l_errMessage,
115: process_flag = wip_constants.mti_error
116: where transaction_header_id = p_txnHdrID;
117: end processInterface;
118:
119: procedure processInterface(p_txnIntID IN NUMBER,

Line 137: if (l_logLevel <= wip_constants.trace_logging) then

133: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
134: begin
135: savepoint wipintpb10;
136:
137: if (l_logLevel <= wip_constants.trace_logging) then
138: l_params(1).paramName := 'p_txnIntID';
139: l_params(1).paramValue := p_txnIntID;
140: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
141: p_params => l_params,

Line 156: and process_flag = wip_constants.mti_inventory;

152: into l_rowID, l_txnHdrID
153: from mtl_transactions_interface
154: where transaction_interface_id = p_txnIntID
155: and transaction_source_type_id = 5
156: and process_flag = wip_constants.mti_inventory;
157:
158:
159: processInterfaceRows(p_initMsgList => fnd_api.g_true,
160: p_processInv => fnd_api.g_true,

Line 177: if (l_logLevel <= wip_constants.trace_logging) then

173: commit;
174: end if;
175:
176: l_msg := 'success';
177: if (l_logLevel <= wip_constants.trace_logging) then
178: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
179: p_procReturnStatus => x_returnStatus,
180: p_msg => l_msg,
181: x_returnStatus => l_returnStatus); --discard logging return status

Line 192: if (l_logLevel <= wip_constants.trace_logging) then

188: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
189: wip_utilities.get_message_stack(p_msg => x_errorMsg,
190: p_separator => ' ',
191: p_delete_stack => fnd_api.g_false);
192: if (l_logLevel <= wip_constants.trace_logging) then
193: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
194: p_procReturnStatus => x_returnStatus,
195: p_msg => 'MTI failure: ' || l_msg,
196: x_returnStatus => l_returnStatus); --discard logging return status

Line 208: if (l_logLevel <= wip_constants.trace_logging) then

204: wip_utilities.get_message_stack(p_msg => x_errorMsg,
205: p_separator => ' ',
206: p_delete_stack => fnd_api.g_false);
207:
208: if (l_logLevel <= wip_constants.trace_logging) then
209: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
210: p_procReturnStatus => x_returnStatus,
211: p_msg => 'to many rows: ' || SQLERRM,
212: x_returnStatus => l_returnStatus); --discard logging return status

Line 225: if (l_logLevel <= wip_constants.trace_logging) then

221: wip_utilities.get_message_stack(p_msg => x_errorMsg,
222: p_separator => ' ',
223: p_delete_stack => fnd_api.g_false);
224:
225: if (l_logLevel <= wip_constants.trace_logging) then
226: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
227: p_procReturnStatus => x_returnStatus,
228: p_msg => 'no data found: ' || SQLERRM,
229: x_returnStatus => l_returnStatus); --discard logging return status

Line 241: if (l_logLevel <= wip_constants.trace_logging) then

237: wip_utilities.get_message_stack(p_msg => x_errorMsg,
238: p_separator => ' ',
239: p_delete_stack => fnd_api.g_false);
240:
241: if (l_logLevel <= wip_constants.trace_logging) then
242: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'MMTT failure: ' || l_msg,
245: x_returnStatus => l_returnStatus); --discard logging return status

Line 282: if (l_logLevel <= wip_constants.trace_logging) then

278: l_msgData VARCHAR2(2000);
279: l_txnCount NUMBER;
280: begin
281:
282: if (l_logLevel <= wip_constants.trace_logging) then
283: l_params(1).paramName := 'p_processInv (now ignored)';
284: l_params(1).paramValue := p_processInv;
285: l_params(2).paramName := 'p_txnHdrID';
286: l_params(2).paramValue := p_txnHdrID;

Line 321: if (l_logLevel <= wip_constants.trace_logging) then

317: l_msg := 'error from INV MTI processor:' || l_msgData;
318: raise fnd_api.g_exc_error;
319: end if;
320:
321: if (l_logLevel <= wip_constants.trace_logging) then
322: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
323: p_procReturnStatus => x_returnStatus,
324: p_msg => l_msg,
325: x_returnStatus => l_returnStatus); --discard logging return status

Line 333: if (l_logLevel <= wip_constants.trace_logging) then

329: end if;
330: exception
331: when fnd_api.g_exc_unexpected_error then
332: x_returnStatus := fnd_api.g_ret_sts_error;
333: if (l_logLevel <= wip_constants.trace_logging) then
334: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
335: p_procReturnStatus => x_returnStatus,
336: p_msg => l_msg,
337: x_returnStatus => l_returnStatus); --discard logging return status

Line 344: if (l_logLevel <= wip_constants.trace_logging) then

340: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
341: end if;
342: when fnd_api.g_exc_error then
343: x_returnStatus := fnd_api.g_ret_sts_error;
344: if (l_logLevel <= wip_constants.trace_logging) then
345: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
346: p_procReturnStatus => x_returnStatus,
347: p_msg => l_msg,
348: x_returnStatus => l_returnStatus); --discard logging return status

Line 360: if (l_logLevel <= wip_constants.trace_logging) then

356: l_msg := 'unexpected error: ' || SQLERRM;
357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',
358: p_procedure_name => 'processInterfaceRows',
359: p_error_text => SQLERRM);
360: if (l_logLevel <= wip_constants.trace_logging) then
361: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
362: p_procReturnStatus => x_returnStatus,
363: p_msg => l_msg,
364: x_returnStatus => l_returnStatus); --discard logging return status