APPS.WIP_MTLTEMPPROC_PRIV dependencies on WIP_MTLTEMPPROC_PRIV

Line 1: package body wip_mtlTempProc_priv as

1: package body wip_mtlTempProc_priv as
2: /* $Header: wiptmpvb.pls 120.3.12010000.2 2008/08/12 19:00:19 kboonyap ship $ */
3:
4: non_txactable_value CONSTANT VARCHAR2(1) := 'N';
5:

Line 6: g_pkgName VARCHAR2(30) := 'wip_mtlTempProc_priv';

2: /* $Header: wiptmpvb.pls 120.3.12010000.2 2008/08/12 19:00:19 kboonyap ship $ */
3:
4: non_txactable_value CONSTANT VARCHAR2(1) := 'N';
5:
6: g_pkgName VARCHAR2(30) := 'wip_mtlTempProc_priv';
7:
8: procedure processTemp(p_initMsgList IN VARCHAR2,
9: p_txnHdrID IN NUMBER,
10: p_txnMode IN NUMBER,

Line 45: wip_logger.entryPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

41: l_params(3).paramName := 'p_txnMode';
42: l_params(3).paramValue := p_txnMode;
43: l_params(4).paramName := 'p_destroyQtyTrees';
44: l_params(4).paramValue := p_destroyQtyTrees;
45: wip_logger.entryPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
46: p_params => l_params,
47: x_returnStatus => x_returnStatus);
48: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
49: raise fnd_api.g_exc_unexpected_error;

Line 90: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

86: inv_quantity_tree_pub.clear_quantity_cache;
87: end if;
88:
89: if (l_logLevel <= wip_constants.trace_logging) then
90: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
91: p_procReturnStatus => x_returnStatus,
92: p_msg => 'success',
93: x_returnStatus => l_retStatus);
94: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 105: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

101: wip_utilities.get_message_stack(p_msg => x_errorMsg,
102: p_delete_stack => fnd_api.g_false,
103: p_separator => ' ');
104: if (l_logLevel <= wip_constants.trace_logging) then
105: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
106: p_procReturnStatus => x_returnStatus,
107: p_msg => 'unhandled exception: ' || SQLERRM,
108: x_returnStatus => l_retStatus);
109: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 116: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlTempProc_priv',

112: end if;
113: when others then
114: rollback to wiptmpvb0;
115: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlTempProc_priv',
117: p_procedure_name => 'processTemp',
118: p_error_text => SQLERRM);
119: wip_utilities.get_message_stack(p_msg => x_errorMsg,
120: p_delete_stack => fnd_api.g_false,

Line 138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

134: wip_constants.issnegc_action,
135: wip_constants.retnegc_action);
136:
137: if (l_logLevel <= wip_constants.trace_logging) then
138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
139: p_procReturnStatus => x_returnStatus,
140: p_msg => 'unhandled exception: ' || SQLERRM,
141: x_returnStatus => l_retStatus);
142: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 608: end wip_mtlTempProc_priv;

604: end if;
605: end if;
606: end validateInterfaceTxns;
607:
608: end wip_mtlTempProc_priv;