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

Line 16: l_params wip_logger.param_tbl_t;

12: x_returnStatus OUT NOCOPY VARCHAR2,
13: x_errorMsg OUT NOCOPY VARCHAR2) IS
14: l_errMsg VARCHAR2(2000);
15: l_errCode VARCHAR2(2000);
16: l_params wip_logger.param_tbl_t;
17: l_retStatus VARCHAR2(1);
18: l_logRetStatus VARCHAR2(1);
19: l_retCode NUMBER;
20: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

Line 37: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,

33: l_params(2).paramName := 'p_processInv';
34: l_params(2).paramValue := p_processInv;
35: l_params(3).paramName := 'p_txnHdrID';
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;

Line 63: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

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,
64: p_procReturnStatus => x_returnStatus,
65: p_msg => 'normal completion. errMsg:' || x_errorMsg,
66: x_returnStatus => l_retStatus);
67: wip_logger.cleanup(l_retStatus);

Line 67: wip_logger.cleanup(l_retStatus);

63: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
64: p_procReturnStatus => x_returnStatus,
65: p_msg => 'normal completion. errMsg:' || x_errorMsg,
66: x_returnStatus => l_retStatus);
67: wip_logger.cleanup(l_retStatus);
68: end if;
69: exception
70: when others then
71: rollback to wiptmppb0;

Line 95: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

91: wip_constants.issnegc_action,
92: wip_constants.retnegc_action);
93:
94: if (l_logLevel <= wip_constants.trace_logging) then
95: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
96: p_procReturnStatus => x_returnStatus,
97: p_msg => 'unhandled exception: ' || SQLERRM,
98: x_returnStatus => l_retStatus);
99: wip_logger.cleanup(l_retStatus);

Line 99: wip_logger.cleanup(l_retStatus);

95: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
96: p_procReturnStatus => x_returnStatus,
97: p_msg => 'unhandled exception: ' || SQLERRM,
98: x_returnStatus => l_retStatus);
99: wip_logger.cleanup(l_retStatus);
100: end if;
101: end processTemp;
102:
103: procedure processWIP(p_txnTmpID IN NUMBER,

Line 143: l_params wip_logger.param_tbl_t;

139: l_txnActionID NUMBER;
140: l_procName VARCHAR2(30) := 'isTxnIDRequired';
141: l_retStatus VARCHAR2(1);
142: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
143: l_params wip_logger.param_tbl_t;
144: begin
145: if (l_logLevel <= wip_constants.trace_logging) then
146: l_params(1).paramName := 'p_txnTmpID';
147: l_params(1).paramValue := p_txnTmpID;

Line 148: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,

144: begin
145: if (l_logLevel <= wip_constants.trace_logging) then
146: l_params(1).paramName := 'p_txnTmpID';
147: l_params(1).paramValue := p_txnTmpID;
148: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
149: p_params => l_params,
150: x_returnStatus => l_retStatus);
151: end if;
152:

Line 167: wip_logger.log(' txn src type:' || l_txnSrcTypID, l_retStatus);

163: from mtl_material_transactions_temp
164: where transaction_temp_id = p_txnTmpID;
165:
166: if(l_logLevel <= wip_constants.full_logging) then
167: wip_logger.log(' txn src type:' || l_txnSrcTypID, l_retStatus);
168: wip_logger.log('wip entity type:' || l_wipEntityType, l_retStatus);
169: wip_logger.log(' wip entity id:' || l_wipEntityID, l_retStatus);
170: wip_logger.log(' org id:' || l_orgID, l_retStatus);
171: wip_logger.log(' txn action id:' || l_txnActionID, l_retStatus);

Line 168: wip_logger.log('wip entity type:' || l_wipEntityType, l_retStatus);

164: where transaction_temp_id = p_txnTmpID;
165:
166: if(l_logLevel <= wip_constants.full_logging) then
167: wip_logger.log(' txn src type:' || l_txnSrcTypID, l_retStatus);
168: wip_logger.log('wip entity type:' || l_wipEntityType, l_retStatus);
169: wip_logger.log(' wip entity id:' || l_wipEntityID, l_retStatus);
170: wip_logger.log(' org id:' || l_orgID, l_retStatus);
171: wip_logger.log(' txn action id:' || l_txnActionID, l_retStatus);
172: end if;

Line 169: wip_logger.log(' wip entity id:' || l_wipEntityID, l_retStatus);

165:
166: if(l_logLevel <= wip_constants.full_logging) then
167: wip_logger.log(' txn src type:' || l_txnSrcTypID, l_retStatus);
168: wip_logger.log('wip entity type:' || l_wipEntityType, l_retStatus);
169: wip_logger.log(' wip entity id:' || l_wipEntityID, l_retStatus);
170: wip_logger.log(' org id:' || l_orgID, l_retStatus);
171: wip_logger.log(' txn action id:' || l_txnActionID, l_retStatus);
172: end if;
173:

Line 170: wip_logger.log(' org id:' || l_orgID, l_retStatus);

166: if(l_logLevel <= wip_constants.full_logging) then
167: wip_logger.log(' txn src type:' || l_txnSrcTypID, l_retStatus);
168: wip_logger.log('wip entity type:' || l_wipEntityType, l_retStatus);
169: wip_logger.log(' wip entity id:' || l_wipEntityID, l_retStatus);
170: wip_logger.log(' org id:' || l_orgID, l_retStatus);
171: wip_logger.log(' txn action id:' || l_txnActionID, l_retStatus);
172: end if;
173:
174: if(l_txnSrcTypID = 5) then

Line 171: wip_logger.log(' txn action id:' || l_txnActionID, l_retStatus);

167: wip_logger.log(' txn src type:' || l_txnSrcTypID, l_retStatus);
168: wip_logger.log('wip entity type:' || l_wipEntityType, l_retStatus);
169: wip_logger.log(' wip entity id:' || l_wipEntityID, l_retStatus);
170: wip_logger.log(' org id:' || l_orgID, l_retStatus);
171: wip_logger.log(' txn action id:' || l_txnActionID, l_retStatus);
172: end if;
173:
174: if(l_txnSrcTypID = 5) then
175: if(l_wipEntityType = wip_constants.repetitive) then

Line 177: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

173:
174: if(l_txnSrcTypID = 5) then
175: if(l_wipEntityType = wip_constants.repetitive) then
176: if (l_logLevel <= wip_constants.trace_logging) then
177: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
178: p_procReturnStatus => 'true',
179: p_msg => 'found repetitive',
180: x_returnStatus => l_retStatus);
181: wip_logger.cleanup(l_retStatus);

Line 181: wip_logger.cleanup(l_retStatus);

177: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
178: p_procReturnStatus => 'true',
179: p_msg => 'found repetitive',
180: x_returnStatus => l_retStatus);
181: wip_logger.cleanup(l_retStatus);
182: end if;
183: return true;
184: elsif(l_wipEntityType is null) then
185: select entity_type

Line 192: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

188: where wip_entity_id = l_wipEntityID
189: and organization_id = l_orgID;
190:
191: if (l_logLevel <= wip_constants.trace_logging) then
192: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
193: p_procReturnStatus => l_wipEntityType || '==' || wip_constants.repetitive,
194: p_msg => 'queried for wip_entity_type',
195: x_returnStatus => l_retStatus);
196: wip_logger.cleanup(l_retStatus);

Line 196: wip_logger.cleanup(l_retStatus);

192: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
193: p_procReturnStatus => l_wipEntityType || '==' || wip_constants.repetitive,
194: p_msg => 'queried for wip_entity_type',
195: x_returnStatus => l_retStatus);
196: wip_logger.cleanup(l_retStatus);
197: end if;
198: return (l_wipEntityType = wip_constants.repetitive);
199: end if;
200: end if;

Line 203: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

199: end if;
200: end if;
201:
202: if (l_logLevel <= wip_constants.trace_logging) then
203: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
204: p_procReturnStatus => 'false',
205: p_msg => 'not repetitive',
206: x_returnStatus => l_retStatus);
207: wip_logger.cleanup(l_retStatus);

Line 207: wip_logger.cleanup(l_retStatus);

203: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
204: p_procReturnStatus => 'false',
205: p_msg => 'not repetitive',
206: x_returnStatus => l_retStatus);
207: wip_logger.cleanup(l_retStatus);
208: end if;
209: return false;
210: exception
211: when others then

Line 213: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

209: return false;
210: exception
211: when others then
212: if (l_logLevel <= wip_constants.trace_logging) then
213: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
214: p_procReturnStatus => 'false',
215: p_msg => 'sql error:' || SQLERRM,
216: x_returnStatus => l_retStatus);
217: wip_logger.cleanup(l_retStatus);

Line 217: wip_logger.cleanup(l_retStatus);

213: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
214: p_procReturnStatus => 'false',
215: p_msg => 'sql error:' || SQLERRM,
216: x_returnStatus => l_retStatus);
217: wip_logger.cleanup(l_retStatus);
218: end if;
219: return false;
220: end isTxnIDRequired;
221: