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

Line 60: l_params wip_logger.param_tbl_t;

56: X_user_id NUMBER := FND_GLOBAL.USER_ID;
57: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
58: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
59: x_returnStatus varchar2(1);
60: l_params wip_logger.param_tbl_t;
61:
62: BEGIN
63: if (l_logLevel <= wip_constants.trace_logging) then
64: l_params(1).paramName := 'P_wip_entity_id';

Line 77: wip_logger.entryPoint(p_procName => 'WIP_CHANGE_STATUS.INSERT_PERIOD_BALANCES',

73: l_params(5).paramValue := P_class_code;
74: l_params(6).paramName := 'P_release_date';
75: l_params(6).paramValue := P_release_date;
76:
77: wip_logger.entryPoint(p_procName => 'WIP_CHANGE_STATUS.INSERT_PERIOD_BALANCES',
78: p_params => l_params,
79: x_returnStatus => x_returnStatus);
80: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
81: raise fnd_api.g_exc_unexpected_error;

Line 129: wip_logger.log(p_msg => SQL%ROWCOUNT ||' of rows inserted into WPB ',

125: AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID
126: AND WPB.ORGANIZATION_ID = OAP.ORGANIZATION_ID);
127:
128: if (l_logLevel <= wip_constants.trace_logging) then
129: wip_logger.log(p_msg => SQL%ROWCOUNT ||' of rows inserted into WPB ',
130: x_returnStatus => x_returnStatus);
131: end if;
132:
133: ELSE

Line 179: wip_logger.log(p_msg => SQL%ROWCOUNT ||' of rows inserted into WPB ',

175: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,
176: WIP_CONSTANTS.COMP_CHRG,
177: WIP_CONSTANTS.HOLD));
178: if (l_logLevel <= wip_constants.trace_logging) then
179: wip_logger.log(p_msg => SQL%ROWCOUNT ||' of rows inserted into WPB ',
180: x_returnStatus => x_returnStatus);
181: end if;
182: END IF;
183:

Line 198: wip_logger.log(p_msg => 'WIP_NO_ACCT_PERIOD exception' ,

194: IF SQL%NOTFOUND THEN
195: IF P_repetitive_schedule_id IS NOT NULL THEN
196:
197: if (l_logLevel <= wip_constants.trace_logging) then
198: wip_logger.log(p_msg => 'WIP_NO_ACCT_PERIOD exception' ,
199: x_returnStatus => x_returnStatus);
200: end if;
201: FND_MESSAGE.SET_NAME('WIP', 'WIP_NO_ACCT_PERIOD');
202: ROLLBACK;

Line 222: wip_logger.log(p_msg => 'no open accouting period for the released date pass in, raise exception' ,

218: FETCH C1 INTO dummy;
219: IF C1%NOTFOUND THEN
220: CLOSE C1;
221: if (l_logLevel <= wip_constants.trace_logging) then
222: wip_logger.log(p_msg => 'no open accouting period for the released date pass in, raise exception' ,
223: x_returnStatus => x_returnStatus);
224: end if;
225: FND_MESSAGE.SET_NAME('WIP', 'WIP_NO_ACCT_PERIOD');
226: ROLLBACK;

Line 237: wip_logger.exitPoint(p_procName => 'WIP_CHANGE_STATUS.INSERT_PERIOD_BALANCES',

233: END IF;
234:
235:
236: if (l_logLevel <= wip_constants.trace_logging) then
237: wip_logger.exitPoint(p_procName => 'WIP_CHANGE_STATUS.INSERT_PERIOD_BALANCES',
238: p_procReturnStatus => 'S',
239: p_msg => 'Finished!',
240: x_returnStatus => x_returnStatus); --discard logging return status
241: end if;

Line 329: l_params wip_logger.param_tbl_t;

325: X_tot_op_qty number; /* For Bug 5859224 */
326: l_release_date DATE; /* Bug 12849554 */
327: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
328: x_returnStatus varchar2(1);
329: l_params wip_logger.param_tbl_t;
330:
331: BEGIN
332: if (l_logLevel <= wip_constants.trace_logging) then
333: l_params(1).paramName := 'P_wip_entity_id';

Line 350: wip_logger.entryPoint(p_procName => 'WIP_CHANGE_STATUS.RELEASE',

346: l_params(7).paramValue := P_new_status_type;
347: l_params(8).paramName := 'P_release_date';
348: l_params(8).paramValue := P_release_date;
349:
350: wip_logger.entryPoint(p_procName => 'WIP_CHANGE_STATUS.RELEASE',
351: p_params => l_params,
352: x_returnStatus => x_returnStatus);
353: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
354: raise fnd_api.g_exc_unexpected_error;

Line 362: wip_logger.log(p_msg => 'Overiding released date to sysdate',

358: /* Bug 13003859(FP of bug#12849554) when changing from on hold to release/complete, we want INSERT_PERIOD_BALANCES only inserting wpb for current acct period only to prevent backdated txn*/
359: IF(P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG) AND P_old_status_type = WIP_CONSTANTS.HOLD) THEN
360: l_release_date := sysdate;
361: if (l_logLevel <= wip_constants.trace_logging) then
362: wip_logger.log(p_msg => 'Overiding released date to sysdate',
363: x_returnStatus => x_returnStatus);
364: end if;
365: ELSE
366: l_release_date := P_release_date;

Line 383: wip_logger.log(p_msg => 'INSERT_PERIOD_BALANCES successfully',

379: P_repetitive_schedule_id, P_line_id,
380: P_class_code, l_Release_Date); /* fix for bug 2424987 *//* Bug 13003859 (FP of bug#12849554) */
381:
382: if (l_logLevel <= wip_constants.trace_logging) then
383: wip_logger.log(p_msg => 'INSERT_PERIOD_BALANCES successfully',
384: x_returnStatus => x_returnStatus);
385: end if;
386:
387: /*

Line 450: wip_logger.exitPoint(p_procName => 'WIP_CHANGE_STATUS.RELEASE',

446: END IF;
447: END IF; /*Bug 13004887(FP of 11935424 and 13003859)*/
448: END IF;
449: if (l_logLevel <= wip_constants.trace_logging) then
450: wip_logger.exitPoint(p_procName => 'WIP_CHANGE_STATUS.RELEASE',
451: p_procReturnStatus => 'S',
452: p_msg => 'Finished!',
453: x_returnStatus => x_returnStatus); --discard logging return status
454: end if;

Line 459: wip_logger.exitPoint(p_procName => 'WIP_CHANGE_STATUS.RELEASE',

455:
456: /*Fix Bug 8977276 (FP 8946106)*/
457: EXCEPTION
458: WHEN wip_constants.records_locked THEN
459: wip_logger.exitPoint(p_procName => 'WIP_CHANGE_STATUS.RELEASE',
460: p_procReturnStatus => 'E',
461: p_msg => 'WIP_LOCKED_ROW_ALREADY_LOCKED',
462: x_returnStatus => x_returnStatus);
463: fnd_message.set_name('WIP', 'WIP_LOCKED_ROW_ALREADY_LOCKED');