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_CONSTANTS

Line 41: P_routing_exists := WIP_CONSTANTS.NO;

37: AND REPETITIVE_SCHEDULE_ID = P_repetitive_schedule_id
38: AND PREVIOUS_OPERATION_SEQ_NUM IS NULL;
39: END IF;
40: IF SQL%NOTFOUND THEN
41: P_routing_exists := WIP_CONSTANTS.NO;
42: ELSE
43: P_routing_exists := WIP_CONSTANTS.YES;
44: END IF;
45: END LOAD_QUEUE;

Line 43: P_routing_exists := WIP_CONSTANTS.YES;

39: END IF;
40: IF SQL%NOTFOUND THEN
41: P_routing_exists := WIP_CONSTANTS.NO;
42: ELSE
43: P_routing_exists := WIP_CONSTANTS.YES;
44: END IF;
45: END LOAD_QUEUE;
46:
47:

Line 63: if (l_logLevel <= wip_constants.trace_logging) then

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';
65: l_params(1).paramValue := P_wip_entity_id;
66: l_params(2).paramName := 'P_organization_id';
67: l_params(2).paramValue := P_organization_id;

Line 128: if (l_logLevel <= wip_constants.trace_logging) then

124: WHERE WPB.WIP_ENTITY_ID = P_wip_entity_id
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:

Line 175: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,

171: FROM WIP_REPETITIVE_SCHEDULES
172: WHERE WIP_ENTITY_ID = P_wip_entity_id
173: AND ORGANIZATION_ID = P_organization_id
174: AND LINE_ID = P_line_id
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 ',

Line 176: WIP_CONSTANTS.COMP_CHRG,

172: WHERE WIP_ENTITY_ID = P_wip_entity_id
173: AND ORGANIZATION_ID = P_organization_id
174: AND LINE_ID = P_line_id
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);

Line 177: WIP_CONSTANTS.HOLD));

173: AND ORGANIZATION_ID = P_organization_id
174: AND LINE_ID = P_line_id
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;

Line 178: if (l_logLevel <= wip_constants.trace_logging) then

174: AND LINE_ID = P_line_id
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;

Line 197: if (l_logLevel <= wip_constants.trace_logging) then

193:
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');

Line 221: if (l_logLevel <= wip_constants.trace_logging) then

217: OPEN C1;
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');

Line 236: if (l_logLevel <= wip_constants.trace_logging) then

232: END IF;
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

Line 269: AND wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,

265: AND wo2.wip_entity_id = P_wip_entity_id
266: AND wo1.repetitive_schedule_id = P_repetitive_schedule_id
267: AND wrs.repetitive_schedule_id = wo2.repetitive_schedule_id
268: AND wrs.line_id = P_line_id
269: AND wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
270: WIP_CONSTANTS.HOLD)
271: AND wo1.operation_seq_num = wo2.operation_seq_num
272: AND wo1.department_id = wo2.department_id
273: AND wo1.count_point_type = wo2.count_point_type

Line 270: WIP_CONSTANTS.HOLD)

266: AND wo1.repetitive_schedule_id = P_repetitive_schedule_id
267: AND wrs.repetitive_schedule_id = wo2.repetitive_schedule_id
268: AND wrs.line_id = P_line_id
269: AND wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
270: WIP_CONSTANTS.HOLD)
271: AND wo1.operation_seq_num = wo2.operation_seq_num
272: AND wo1.department_id = wo2.department_id
273: AND wo1.count_point_type = wo2.count_point_type
274: AND wo1.backflush_flag = wo2.backflush_flag

Line 284: AND S.status_type in (WIP_CONSTANTS.RELEASED,

280: AND S.organization_id = P_organization_id
281: AND O.wip_entity_id = P_wip_entity_id
282: AND S.wip_entity_id = P_wip_entity_id
283: AND S.line_id = P_line_id
284: AND S.status_type in (WIP_CONSTANTS.RELEASED,
285: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
286: AND O.repetitive_schedule_id = P_repetitive_schedule_id)
287: AND count(*) =
288: (SELECT count(*)

Line 285: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)

281: AND O.wip_entity_id = P_wip_entity_id
282: AND S.wip_entity_id = P_wip_entity_id
283: AND S.line_id = P_line_id
284: AND S.status_type in (WIP_CONSTANTS.RELEASED,
285: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
286: AND O.repetitive_schedule_id = P_repetitive_schedule_id)
287: AND count(*) =
288: (SELECT count(*)
289: FROM wip_operations O,

Line 296: AND S.status_type in (WIP_CONSTANTS.RELEASED,

292: AND S.organization_id = P_organization_id
293: AND O.wip_entity_id = P_wip_entity_id
294: AND S.wip_entity_id = P_wip_entity_id
295: AND S.line_id = P_line_id
296: AND S.status_type in (WIP_CONSTANTS.RELEASED,
297: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
298: AND O.repetitive_schedule_id = S.repetitive_schedule_id);
299:
300:

Line 297: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)

293: AND O.wip_entity_id = P_wip_entity_id
294: AND S.wip_entity_id = P_wip_entity_id
295: AND S.line_id = P_line_id
296: AND S.status_type in (WIP_CONSTANTS.RELEASED,
297: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
298: AND O.repetitive_schedule_id = S.repetitive_schedule_id);
299:
300:
301: BEGIN

Line 332: if (l_logLevel <= wip_constants.trace_logging) then

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';
334: l_params(1).paramValue := P_wip_entity_id;
335: l_params(2).paramName := 'P_organization_id';
336: l_params(2).paramValue := P_organization_id;

Line 359: IF(P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG) AND P_old_status_type = WIP_CONSTANTS.HOLD) THEN

355: end if;
356: end if;
357:
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);

Line 361: if (l_logLevel <= wip_constants.trace_logging) then

357:
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

Line 370: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/

366: l_release_date := P_release_date;
367: END IF;
368:
369:
370: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
371: /* Bug 13004887(FP of 11935424 and 13003859) remove WIP_CONSTANTS.HOLD for EAM job. when change from hold to release for EAM work order,
372: EAM will call this method, we need to populate back all the missing WPB*/
373: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
374: WIP_CONSTANTS.HOLD) AND

Line 371: /* Bug 13004887(FP of 11935424 and 13003859) remove WIP_CONSTANTS.HOLD for EAM job. when change from hold to release for EAM work order,

367: END IF;
368:
369:
370: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
371: /* Bug 13004887(FP of 11935424 and 13003859) remove WIP_CONSTANTS.HOLD for EAM job. when change from hold to release for EAM work order,
372: EAM will call this method, we need to populate back all the missing WPB*/
373: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
374: WIP_CONSTANTS.HOLD) AND
375: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,

Line 373: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,

369:
370: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
371: /* Bug 13004887(FP of 11935424 and 13003859) remove WIP_CONSTANTS.HOLD for EAM job. when change from hold to release for EAM work order,
372: EAM will call this method, we need to populate back all the missing WPB*/
373: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
374: WIP_CONSTANTS.HOLD) AND
375: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
376: WIP_CONSTANTS.COMP_CHRG)) THEN
377:

Line 374: WIP_CONSTANTS.HOLD) AND

370: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and old status list*/
371: /* Bug 13004887(FP of 11935424 and 13003859) remove WIP_CONSTANTS.HOLD for EAM job. when change from hold to release for EAM work order,
372: EAM will call this method, we need to populate back all the missing WPB*/
373: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
374: WIP_CONSTANTS.HOLD) AND
375: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
376: WIP_CONSTANTS.COMP_CHRG)) THEN
377:
378: INSERT_PERIOD_BALANCES (P_wip_entity_id, P_organization_id,

Line 375: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,

371: /* Bug 13004887(FP of 11935424 and 13003859) remove WIP_CONSTANTS.HOLD for EAM job. when change from hold to release for EAM work order,
372: EAM will call this method, we need to populate back all the missing WPB*/
373: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
374: WIP_CONSTANTS.HOLD) AND
375: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
376: WIP_CONSTANTS.COMP_CHRG)) THEN
377:
378: INSERT_PERIOD_BALANCES (P_wip_entity_id, P_organization_id,
379: P_repetitive_schedule_id, P_line_id,

Line 376: WIP_CONSTANTS.COMP_CHRG)) THEN

372: EAM will call this method, we need to populate back all the missing WPB*/
373: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
374: WIP_CONSTANTS.HOLD) AND
375: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
376: WIP_CONSTANTS.COMP_CHRG)) THEN
377:
378: INSERT_PERIOD_BALANCES (P_wip_entity_id, P_organization_id,
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) */

Line 382: if (l_logLevel <= wip_constants.trace_logging) then

378: INSERT_PERIOD_BALANCES (P_wip_entity_id, P_organization_id,
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:

Line 400: IF(P_old_status_type <> WIP_CONSTANTS.HOLD) THEN

396:
397: */
398:
399: /*Bug 13004887(FP of 11935424 and 13003859) we only want to call INSERT_PERIOD_BALANCES when change EAM work orders from hold to release*/
400: IF(P_old_status_type <> WIP_CONSTANTS.HOLD) THEN
401: /* For Bug 5859224: load_queue API would be called only if the sum of quantity_in_queue,quantity_running
402: and quantity_completed of first operation is zero */
403: BEGIN
404: SELECT (nvl(QUANTITY_IN_QUEUE,0) + nvl(QUANTITY_RUNNING,0) + nvl(QUANTITY_COMPLETED,0))

Line 418: in WIP_OPERATIONS and so the P_routing_exists flag should be 1(WIP_CONSTANTS.YES). If it throws exception,

414: Previously, when QUANTITY_IN_QUEUE, QUANTITY_RUNNING, QUANTITY_COMPLETED is not 0, the P_routing_exists
415: flag was not being set properly and is equal to NULL and resulted into the issue in bug 7304606.
416: If the sql SELECT (nvl(QUANTITY_IN_QUEUE,0) + nvl(QUANTITY_RUNNING,0) + nvl(QUANTITY_COMPLETED,0))
417: INTO x_tot_op_qty FROM WIP_OPERATIONS does not throw exception it implies that there is a routing exists
418: in WIP_OPERATIONS and so the P_routing_exists flag should be 1(WIP_CONSTANTS.YES). If it throws exception,
419: LOAD_QUEUE will handle the P_routing_exists flag
420: */
421: P_routing_exists := WIP_CONSTANTS.YES;
422:

Line 421: P_routing_exists := WIP_CONSTANTS.YES;

417: INTO x_tot_op_qty FROM WIP_OPERATIONS does not throw exception it implies that there is a routing exists
418: in WIP_OPERATIONS and so the P_routing_exists flag should be 1(WIP_CONSTANTS.YES). If it throws exception,
419: LOAD_QUEUE will handle the P_routing_exists flag
420: */
421: P_routing_exists := WIP_CONSTANTS.YES;
422:
423:
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN

Line 426: P_routing_exists := WIP_CONSTANTS.NO;

422:
423:
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: P_routing_exists := WIP_CONSTANTS.NO;
427: END;
428:
429:
430:

Line 431: IF (x_tot_op_qty = 0 AND P_routing_exists = WIP_CONSTANTS.YES)then

427: END;
428:
429:
430:
431: IF (x_tot_op_qty = 0 AND P_routing_exists = WIP_CONSTANTS.YES)then
432: LOAD_QUEUE (P_wip_entity_id, P_organization_id,
433: P_repetitive_schedule_id, P_routing_exists);
434: END IF;
435:

Line 437: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,

433: P_repetitive_schedule_id, P_routing_exists);
434: END IF;
435:
436: IF P_repetitive_schedule_id IS NOT NULL THEN
437: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
438: WIP_CONSTANTS.COMP_CHRG,
439: WIP_CONSTANTS.HOLD) AND
440: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
441: WIP_CONSTANTS.COMP_CHRG,

Line 438: WIP_CONSTANTS.COMP_CHRG,

434: END IF;
435:
436: IF P_repetitive_schedule_id IS NOT NULL THEN
437: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
438: WIP_CONSTANTS.COMP_CHRG,
439: WIP_CONSTANTS.HOLD) AND
440: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
441: WIP_CONSTANTS.COMP_CHRG,
442: WIP_CONSTANTS.HOLD)) THEN

Line 439: WIP_CONSTANTS.HOLD) AND

435:
436: IF P_repetitive_schedule_id IS NOT NULL THEN
437: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
438: WIP_CONSTANTS.COMP_CHRG,
439: WIP_CONSTANTS.HOLD) AND
440: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
441: WIP_CONSTANTS.COMP_CHRG,
442: WIP_CONSTANTS.HOLD)) THEN
443: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,

Line 440: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,

436: IF P_repetitive_schedule_id IS NOT NULL THEN
437: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
438: WIP_CONSTANTS.COMP_CHRG,
439: WIP_CONSTANTS.HOLD) AND
440: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
441: WIP_CONSTANTS.COMP_CHRG,
442: WIP_CONSTANTS.HOLD)) THEN
443: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,
444: P_repetitive_schedule_id, P_line_id);

Line 441: WIP_CONSTANTS.COMP_CHRG,

437: IF (P_new_status_type IN (WIP_CONSTANTS.RELEASED,
438: WIP_CONSTANTS.COMP_CHRG,
439: WIP_CONSTANTS.HOLD) AND
440: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
441: WIP_CONSTANTS.COMP_CHRG,
442: WIP_CONSTANTS.HOLD)) THEN
443: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,
444: P_repetitive_schedule_id, P_line_id);
445: END IF;

Line 442: WIP_CONSTANTS.HOLD)) THEN

438: WIP_CONSTANTS.COMP_CHRG,
439: WIP_CONSTANTS.HOLD) AND
440: P_old_status_type NOT IN (WIP_CONSTANTS.RELEASED,
441: WIP_CONSTANTS.COMP_CHRG,
442: WIP_CONSTANTS.HOLD)) THEN
443: CHECK_REPETITIVE_ROUTING (P_wip_entity_id, P_organization_id,
444: P_repetitive_schedule_id, P_line_id);
445: END IF;
446: END IF;

Line 449: if (l_logLevel <= wip_constants.trace_logging) then

445: END IF;
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

Line 458: WHEN wip_constants.records_locked THEN

454: end if;
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);

Line 479: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,

475: CLASS_CODE
476: FROM WIP_DISCRETE_JOBS
477: WHERE WIP_ENTITY_ID = P_wip_entity_id
478: AND ORGANIZATION_ID = P_organization_id
479: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
480: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,
481: WIP_CONSTANTS.PEND_SCHED);
482:
483: X_status_type NUMBER;

Line 480: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,

476: FROM WIP_DISCRETE_JOBS
477: WHERE WIP_ENTITY_ID = P_wip_entity_id
478: AND ORGANIZATION_ID = P_organization_id
479: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
480: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,
481: WIP_CONSTANTS.PEND_SCHED);
482:
483: X_status_type NUMBER;
484: X_class_code VARCHAR2(10) := '';

Line 481: WIP_CONSTANTS.PEND_SCHED);

477: WHERE WIP_ENTITY_ID = P_wip_entity_id
478: AND ORGANIZATION_ID = P_organization_id
479: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
480: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,
481: WIP_CONSTANTS.PEND_SCHED);
482:
483: X_status_type NUMBER;
484: X_class_code VARCHAR2(10) := '';
485: X_valid_job BOOLEAN;

Line 501: X_class_code, X_status_type, WIP_CONSTANTS.HOLD,

497: FND_MESSAGE.SET_NAME('WIP', 'WIP_QA_ACTION_NO_HOLD');
498: APP_EXCEPTION.RAISE_EXCEPTION;
499: END IF;
500: RELEASE (P_wip_entity_id, P_organization_id, '', '',
501: X_class_code, X_status_type, WIP_CONSTANTS.HOLD,
502: X_routing_exists, SYSDATE); /* fix for bug 2424987 */
503:
504: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
505:

Line 506: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,

502: X_routing_exists, SYSDATE); /* fix for bug 2424987 */
503:
504: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
505:
506: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
507: WIP_CONSTANTS.COMP_CHRG,
508: WIP_CONSTANTS.HOLD,
509: WIP_CONSTANTS.CANCELLED) THEN
510: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;

Line 507: WIP_CONSTANTS.COMP_CHRG,

503:
504: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
505:
506: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
507: WIP_CONSTANTS.COMP_CHRG,
508: WIP_CONSTANTS.HOLD,
509: WIP_CONSTANTS.CANCELLED) THEN
510: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;
511:

Line 508: WIP_CONSTANTS.HOLD,

504: /* Fix for Bug#2034660 .Calling wip_osp.release_validation since release is not calling this procedure */
505:
506: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
507: WIP_CONSTANTS.COMP_CHRG,
508: WIP_CONSTANTS.HOLD,
509: WIP_CONSTANTS.CANCELLED) THEN
510: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;
511:
512: end if ;

Line 509: WIP_CONSTANTS.CANCELLED) THEN

505:
506: if x_status_type NOT IN (WIP_CONSTANTS.RELEASED,
507: WIP_CONSTANTS.COMP_CHRG,
508: WIP_CONSTANTS.HOLD,
509: WIP_CONSTANTS.CANCELLED) THEN
510: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;
511:
512: end if ;
513:

Line 525: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,

521: raise fnd_api.g_exc_unexpected_error;
522: END IF;*/
523:
524: UPDATE WIP_DISCRETE_JOBS
525: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
526: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
527: LAST_UPDATE_DATE = SYSDATE,
528: LAST_UPDATED_BY = X_user_id,
529: LAST_UPDATE_LOGIN = X_login_id

Line 546: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,

542: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
543:
544: BEGIN
545: UPDATE WIP_REPETITIVE_SCHEDULES
546: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
547: LAST_UPDATE_DATE = SYSDATE,
548: LAST_UPDATED_BY = X_user_id,
549: LAST_UPDATE_LOGIN = X_login_id
550: WHERE LINE_ID = P_line_id

Line 553: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,

549: LAST_UPDATE_LOGIN = X_login_id
550: WHERE LINE_ID = P_line_id
551: AND WIP_ENTITY_ID = P_wip_entity_id
552: AND ORGANIZATION_ID = P_organization_id
553: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
554: WIP_CONSTANTS.HOLD);
555: END PUT_LINE_ON_HOLD;
556:
557: PROCEDURE RELEASE_MES_WRAPPER

Line 554: WIP_CONSTANTS.HOLD);

550: WHERE LINE_ID = P_line_id
551: AND WIP_ENTITY_ID = P_wip_entity_id
552: AND ORGANIZATION_ID = P_organization_id
553: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
554: WIP_CONSTANTS.HOLD);
555: END PUT_LINE_ON_HOLD;
556:
557: PROCEDURE RELEASE_MES_WRAPPER
558: (P_wip_entity_id NUMBER,

Line 588: X_class_code, X_status_type, WIP_CONSTANTS.RELEASED,

584: APP_EXCEPTION.RAISE_EXCEPTION;
585: END IF;
586:
587: RELEASE (P_wip_entity_id, P_organization_id, '', '',
588: X_class_code, X_status_type, WIP_CONSTANTS.RELEASED,
589: X_routing_exists, SYSDATE);
590:
591: /*Add for bug 10013678*/
592: WIP_OSP.RELEASE_VALIDATION(P_wip_entity_id,

Line 597: SET STATUS_TYPE = WIP_CONSTANTS.RELEASED,

593: P_organization_id,
594: null);
595:
596: UPDATE WIP_DISCRETE_JOBS
597: SET STATUS_TYPE = WIP_CONSTANTS.RELEASED,
598: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
599: LAST_UPDATE_DATE = SYSDATE,
600: LAST_UPDATED_BY = X_user_id,
601: LAST_UPDATE_LOGIN = X_login_id