APPS.WIP_MOVPROC_PUB dependencies on WIP_MOVPROC_PUB

Line 1: PACKAGE BODY wip_movProc_pub AS

1: PACKAGE BODY wip_movProc_pub AS
2: /* $Header: wipmvpbb.pls 120.0 2005/05/24 18:03:19 appldev noship $*/
3:
4: /*************************************************************************
5: * This procedure should be called if caller want to process one record

Line 31: wip_logger.entryPoint(p_procName => 'wip_movProc_pub.processInterface',

27:
28: IF(l_logLevel <= WIP_CONSTANTS.TRACE_LOGGING) THEN
29: l_params(1).paramName := 'p_txn_id';
30: l_params(1).paramValue := p_txn_id;
31: wip_logger.entryPoint(p_procName => 'wip_movProc_pub.processInterface',
32: p_params => l_params,
33: x_returnStatus => l_returnStatus);
34:
35: END IF;

Line 74: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

70: COMMIT;
71: END IF;
72:
73: IF (l_logLevel <= wip_constants.trace_logging) THEN
74: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
75: p_procReturnStatus => x_returnStatus,
76: p_msg => 'procedure complete',
77: x_returnStatus => l_returnStatus);
78: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 91: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

87: END LOOP;
88: x_errorMsg := substr(x_errorMsg, 1, 1000);
89:
90: IF (l_logLevel <= wip_constants.trace_logging) THEN
91: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
92: p_procReturnStatus => x_returnStatus,
93: p_msg => 'wip_movProc_priv.processIntf failed',
94: x_returnStatus => l_returnStatus);
95: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 105: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

101: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
102: x_errorMsg := substr(fnd_message.get, 1, 1000);
103:
104: IF (l_logLevel <= wip_constants.trace_logging) THEN
105: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
106: p_procReturnStatus => x_returnStatus,
107: p_msg => 'to many rows: ' || SQLERRM,
108: x_returnStatus => l_returnStatus);
109: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 120: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

116: 'TRANSACTION_ID/GROUP_ID/PROCESS_PHASE/PROCESS_STATUS');
117: x_errorMsg := substr(fnd_message.get, 1, 1000);
118:
119: IF (l_logLevel <= wip_constants.trace_logging) THEN
120: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
121: p_procReturnStatus => x_returnStatus,
122: p_msg => 'no data found: ' || SQLERRM,
123: x_returnStatus => l_returnStatus);
124: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 131: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

127: WHEN others THEN
128: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
129: x_errorMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
130: IF (l_logLevel <= wip_constants.trace_logging) THEN
131: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
132: p_procReturnStatus => x_returnStatus,
133: p_msg => x_errorMsg,
134: x_returnStatus => l_returnStatus);
135: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 158: wip_logger.entryPoint(p_procName => 'wip_movProc_pub.processInterface',

154:
155: IF(l_logLevel <= WIP_CONSTANTS.TRACE_LOGGING) THEN
156: l_params(1).paramName := 'p_group_id';
157: l_params(1).paramValue := p_group_id;
158: wip_logger.entryPoint(p_procName => 'wip_movProc_pub.processInterface',
159: p_params => l_params,
160: x_returnStatus => l_returnStatus);
161:
162: END IF;

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

189: COMMIT;
190: END IF;
191:
192: IF (l_logLevel <= wip_constants.trace_logging) THEN
193: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
194: p_procReturnStatus => x_returnStatus,
195: p_msg => 'no record in this group error out',
196: x_returnStatus => l_returnStatus);
197: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 205: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

201: WHEN fnd_api.g_exc_error THEN
202: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
203:
204: IF (l_logLevel <= wip_constants.trace_logging) THEN
205: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
206: p_procReturnStatus => x_returnStatus,
207: p_msg => 'some records in this group error out',
208: x_returnStatus => l_returnStatus);
209: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 216: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',

212: WHEN others THEN
213: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
214:
215: IF (l_logLevel <= wip_constants.trace_logging) THEN
216: wip_logger.exitPoint(p_procName => 'wip_movProc_pub.processInterface',
217: p_procReturnStatus => x_returnStatus,
218: p_msg => 'unexpected error: ' || SQLERRM,
219: x_returnStatus => l_returnStatus);
220: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 224: END wip_movProc_pub;

220: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
221: END IF;
222: END processInterface;
223:
224: END wip_movProc_pub;