DBA Data[Home] [Help]

APPS.WIP_MTLTEMPPROC_GRP dependencies on FND_API

Line 40: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

36: l_params(3).paramValue := p_txnHdrID;
37: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
38: p_params => l_params,
39: x_returnStatus => x_returnStatus);
40: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
41: raise fnd_api.g_exc_unexpected_error;
42: end if;
43: end if;
44:

Line 41: raise fnd_api.g_exc_unexpected_error;

37: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
38: p_params => l_params,
39: x_returnStatus => x_returnStatus);
40: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
41: raise fnd_api.g_exc_unexpected_error;
42: end if;
43: end if;
44:
45: if(fnd_api.to_boolean(p_initMsgList)) then

Line 45: if(fnd_api.to_boolean(p_initMsgList)) then

41: raise fnd_api.g_exc_unexpected_error;
42: end if;
43: end if;
44:
45: if(fnd_api.to_boolean(p_initMsgList)) then
46: fnd_msg_pub.initialize;
47: end if;
48:
49: l_retCode := inv_lpn_trx_pub.process_lpn_trx(p_trx_hdr_id => p_txnHdrID,

Line 57: x_returnStatus := fnd_api.g_ret_sts_error;

53: if(nvl(l_retCode, -1) <> 0) then
54: fnd_msg_pub.initialize;
55: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
56: fnd_message.set_token('MESSAGE', x_errorMsg);
57: x_returnStatus := fnd_api.g_ret_sts_error;
58: else
59: x_returnStatus := fnd_api.g_ret_sts_success;
60: end if;
61:

Line 59: x_returnStatus := fnd_api.g_ret_sts_success;

55: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
56: fnd_message.set_token('MESSAGE', x_errorMsg);
57: x_returnStatus := fnd_api.g_ret_sts_error;
58: else
59: x_returnStatus := fnd_api.g_ret_sts_success;
60: end if;
61:
62: if (l_logLevel <= wip_constants.trace_logging) then
63: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 72: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

68: end if;
69: exception
70: when others then
71: rollback to wiptmppb0;
72: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
73: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
74: p_procedure_name => l_procName,
75: p_error_text => SQLERRM);
76: wip_utilities.get_message_stack(p_msg => x_errorMsg,

Line 77: p_delete_stack => fnd_api.g_false,

73: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
74: p_procedure_name => l_procName,
75: p_error_text => SQLERRM);
76: wip_utilities.get_message_stack(p_msg => x_errorMsg,
77: p_delete_stack => fnd_api.g_false,
78: p_separator => ' ');
79: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');
80: l_errCode := fnd_message.get;
81:

Line 120: p_endDebug => fnd_api.g_false,

116: buff => 'AUDSID: ' || fnd_global.session_id);
117: end if;
118: end if;
119: wip_mtlTempProc_priv.processWIP(p_txnTmpID => p_txnTmpID,
120: p_endDebug => fnd_api.g_false,
121: p_processLpn => fnd_api.g_false,
122: x_returnStatus => x_returnStatus,
123: x_errorMsg => x_errorMsg);
124: exception

Line 121: p_processLpn => fnd_api.g_false,

117: end if;
118: end if;
119: wip_mtlTempProc_priv.processWIP(p_txnTmpID => p_txnTmpID,
120: p_endDebug => fnd_api.g_false,
121: p_processLpn => fnd_api.g_false,
122: x_returnStatus => x_returnStatus,
123: x_errorMsg => x_errorMsg);
124: exception
125: when others then

Line 127: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

123: x_errorMsg => x_errorMsg);
124: exception
125: when others then
126: rollback to wiptmppb100;
127: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
128: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlTempProc_grp',
129: p_procedure_name => 'processWIP',
130: p_error_text => SQLERRM);
131: x_errorMsg := substrb(SQLERRM, 1, 240);