DBA Data[Home] [Help]

APPS.WIP_MTLINTERFACEPROC_PUB dependencies on FND_MSG_PUB

Line 37: fnd_msg_pub.initialize;

33: p_params => l_params,
34: x_returnStatus => x_returnStatus);
35: end if;
36:
37: fnd_msg_pub.initialize;
38:
39: processInterfaceRows(p_initMsgList => fnd_api.g_true,
40: p_processInv => fnd_api.g_true,
41: p_endDebug => fnd_api.g_false,

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 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 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 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 315: fnd_msg_pub.add;

311: if(l_retStatus <> 0) then
312: if(l_msgData is not null) then
313: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
314: fnd_message.set_token('MESSAGE', l_msgData);
315: fnd_msg_pub.add;
316: end if;
317: l_msg := 'error from INV MTI processor:' || l_msgData;
318: raise fnd_api.g_exc_error;
319: 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',