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_MOVPROC_PUB dependencies on WIP_LOGGER

Line 22: l_params wip_logger.param_tbl_t;

18: WHERE transaction_id = p_transaction_id;
19:
20: l_returnStatus VARCHAR2(1);
21: l_do_backflush VARCHAR2(1);
22: l_params wip_logger.param_tbl_t;
23: l_groupID NUMBER;
24: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
25: l_errors c_errors%ROWTYPE;
26: BEGIN

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 78: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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);
79: END IF;
80: EXCEPTION
81: WHEN fnd_api.g_exc_error THEN
82: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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 95: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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);
96: END IF;
97:
98: WHEN TOO_MANY_ROWS THEN
99: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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 109: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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);
110: END IF;
111:
112: WHEN NO_DATA_FOUND THEN
113: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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 124: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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);
125: END IF;
126:
127: WHEN others THEN
128: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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 135: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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);
136: END IF;
137:
138: END processInterface;
139:

Line 150: l_params wip_logger.param_tbl_t;

146: p_commit IN VARCHAR2,
147: x_returnStatus OUT NOCOPY VARCHAR2) IS
148: l_returnStatus VARCHAR2(1);
149: l_do_backflush VARCHAR2(1);
150: l_params wip_logger.param_tbl_t;
151: l_groupID NUMBER;
152: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
153: BEGIN
154:

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

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);
198: END IF;
199: EXCEPTION
200:
201: WHEN fnd_api.g_exc_error THEN

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 209: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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);
210: END IF;
211:
212: WHEN others THEN
213: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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 220: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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);
221: END IF;
222: END processInterface;
223:
224: END wip_movProc_pub;