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_MTLINTERFACEPROC_PUB

Line 1: package body wip_mtlInterfaceProc_pub as

1: package body wip_mtlInterfaceProc_pub as
2: /* $Header: wipintpb.pls 120.0.12000000.2 2007/05/17 13:37:06 mraman ship $ */
3:
4: type err_tbl_t is table of varchar2(240);
5: type num_tbl_t is table of number;

Line 32: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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,
34: x_returnStatus => x_returnStatus);
35: end if;
36:

Line 55: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
59: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

Line 68: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
72:

Line 97: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
101:

Line 105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

101:
102: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
103: end if;
104: rollback to wipintpb0;
105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',
106: p_procedure_name => 'processInterface',
107: p_error_text => SQLERRM);
108: wip_utilities.get_message_stack(p_msg => l_errMessage,
109: p_separator => ' ',

Line 113: set error_code = 'wip_mtlInterfaceProc_pub.processInterface()',

109: p_separator => ' ',
110: p_delete_stack => fnd_api.g_false);
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;

Line 140: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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,
142: x_returnStatus => x_returnStatus);
143:
144: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 178: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
182:

Line 193: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
197: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

Line 201: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

197: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
198: end if;
199: when TOO_MANY_ROWS then
200: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
201: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',
202: p_procedure_name => 'processInterface',
203: p_error_text => SQLERRM);
204: wip_utilities.get_message_stack(p_msg => x_errorMsg,
205: p_separator => ' ',

Line 209: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
213: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

Line 217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

213: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
214: end if;
215: when NO_DATA_FOUND then
216: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',
218: p_procedure_name => 'processInterface',
219: p_error_text => SQLERRM);
220:
221: wip_utilities.get_message_stack(p_msg => x_errorMsg,

Line 226: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
230: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

Line 234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

230: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
231: end if;
232: when others then
233: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',
235: p_procedure_name => 'processInterface',
236: p_error_text => SQLERRM);
237: wip_utilities.get_message_stack(p_msg => x_errorMsg,
238: p_separator => ' ',

Line 242: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

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
246: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

Line 287: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

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;
287: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
288: p_params => l_params,
289: x_returnStatus => x_returnStatus);
290:
291: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 322: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

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
326: end if;

Line 334: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

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
338: end if;

Line 345: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

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
349: end if;

Line 357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

353:
354: when others then
355: x_returnStatus := fnd_api.g_ret_sts_error;
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',

Line 361: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

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
365: end if;

Line 371: end wip_mtlInterfaceProc_pub;

367: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
368: end if;
369: end processInterfaceRows;
370:
371: end wip_mtlInterfaceProc_pub;