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_WS_SHORTAGE dependencies on WIP_CONSTANTS

Line 55: if (g_logLevel <= wip_constants.trace_logging) then

51: and wpv.attribute_name = g_pref_val_comp_type_cset_att;
52:
53: BEGIN
54: x_pref_exists := 'Y';
55: if (g_logLevel <= wip_constants.trace_logging) then
56: l_params(1).paramName := 'p_org_id';
57: l_params(1).paramValue := p_org_id;
58: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
59: p_params => l_params,

Line 123: if (g_logLevel <= wip_constants.trace_logging) then

119: g_org_comp_calc_rec.inc_released_jobs := 1;
120: g_org_comp_calc_rec.inc_unreleased_jobs := 1;
121: g_org_comp_calc_rec.inc_onhold_jobs := 2;
122: */
123: if (g_logLevel <= wip_constants.trace_logging) then
124: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
125: p_procReturnStatus => l_returnStatus,
126: p_msg => 'Request processed successfully!',
127: x_returnStatus => l_returnStatus);

Line 132: if (g_logLevel <= wip_constants.trace_logging) then

128: end if;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: if (g_logLevel <= wip_constants.trace_logging) then
133: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
134: p_procReturnStatus => l_returnStatus,
135: p_msg => 'unexpected error: ' || SQLERRM,
136: x_returnStatus => l_returnStatus);

Line 194: status_str := to_char(wip_constants.RELEASED);

190: FUNCTION get_pref_job_statuses RETURN VARCHAR2 IS
191: status_str VARCHAR2(240) := null;
192: BEGIN
193: if(g_org_comp_calc_rec.inc_released_jobs = 1) then
194: status_str := to_char(wip_constants.RELEASED);
195: end if;
196:
197: if(g_org_comp_calc_rec.inc_unreleased_jobs = 1) then
198: if(status_str is not null) then

Line 201: status_str := status_str || to_char(wip_constants.UNRELEASED);

197: if(g_org_comp_calc_rec.inc_unreleased_jobs = 1) then
198: if(status_str is not null) then
199: status_str := status_str|| ' , ';
200: end if;
201: status_str := status_str || to_char(wip_constants.UNRELEASED);
202: end if;
203:
204: if(g_org_comp_calc_rec.inc_onhold_jobs = 1) then
205: if(status_str is not null) then

Line 208: status_str := status_str || to_char(wip_constants.HOLD);

204: if(g_org_comp_calc_rec.inc_onhold_jobs = 1) then
205: if(status_str is not null) then
206: status_str := status_str|| ' , ';
207: end if;
208: status_str := status_str || to_char(wip_constants.HOLD);
209: end if;
210: return status_str;
211: END get_pref_job_statuses ;
212:

Line 220: job_type_str := to_char(wip_constants.STANDARD);

216: */
217: FUNCTION get_job_types RETURN VARCHAR2 IS
218: job_type_str VARCHAR2(240) := null;
219: BEGIN
220: job_type_str := to_char(wip_constants.STANDARD);
221: return job_type_str;
222: END get_job_types;
223:
224:

Line 359: if ( l_lot_control_code = WIP_CONSTANTS.LOT ) then

355: --bug 7045337 since lot number is passed as null, l_is_lot_control should be passed as false
356: --based on Inv team's suggestion passing null for l_is_revision_control and l_is_serial_control
357: --also since we are not calculating att at revision/serial
358: /**************
359: if ( l_lot_control_code = WIP_CONSTANTS.LOT ) then
360: l_is_lot_control := true;
361: else
362: l_is_lot_control := false;
363: end if;

Line 365: if( l_revision_control_code = WIP_CONSTANTS.REV ) then

361: else
362: l_is_lot_control := false;
363: end if;
364:
365: if( l_revision_control_code = WIP_CONSTANTS.REV ) then
366: l_is_revision_control := true;
367: else
368: l_is_revision_control := false;
369: end if;

Line 371: if( l_serial_control_code in (WIP_CONSTANTS.FULL_SN, WIP_CONSTANTS.DYN_RCV_SN) ) then

367: else
368: l_is_revision_control := false;
369: end if;
370:
371: if( l_serial_control_code in (WIP_CONSTANTS.FULL_SN, WIP_CONSTANTS.DYN_RCV_SN) ) then
372: l_is_serial_control := true;
373: else
374: l_is_serial_control := false;
375: end if;

Line 1369: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,

1365: from wip_discrete_jobs wdj
1366: where wdj.organization_id = p_org_id
1367: and wdj.primary_item_id = p_inv_item_id
1368: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1369: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1370: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1371: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1372: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1373: l_qty NUMBER := 0;

Line 1370: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)

1366: where wdj.organization_id = p_org_id
1367: and wdj.primary_item_id = p_inv_item_id
1368: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1369: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1370: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1371: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1372: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1373: l_qty NUMBER := 0;
1374: BEGIN

Line 1372: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);

1368: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1369: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1370: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1371: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1372: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1373: l_qty NUMBER := 0;
1374: BEGIN
1375: for c_job_csr in job_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop
1376: l_qty := l_qty + (c_job_csr.item_qty - nvl(c_job_csr.reservation_qty,0));

Line 1438: and wro.wip_supply_type <> wip_constants.PHANTOM

1434: and wro.inventory_item_id = p_inv_item_id
1435: and trunc(wro.date_required) = trunc(p_rcpt_date)
1436: and wro.organization_id = wdj.organization_id
1437: and wro.wip_entity_id = wdj.wip_entity_id
1438: and wro.wip_supply_type <> wip_constants.PHANTOM
1439: and wro.required_quantity < 0
1440: and wro.operation_seq_num > 0
1441: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1442: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,

Line 1441: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)

1437: and wro.wip_entity_id = wdj.wip_entity_id
1438: and wro.wip_supply_type <> wip_constants.PHANTOM
1439: and wro.required_quantity < 0
1440: and wro.operation_seq_num > 0
1441: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1442: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1443: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1444: l_qty NUMBER := 0;
1445: BEGIN

Line 1442: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,

1438: and wro.wip_supply_type <> wip_constants.PHANTOM
1439: and wro.required_quantity < 0
1440: and wro.operation_seq_num > 0
1441: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1442: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1443: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1444: l_qty NUMBER := 0;
1445: BEGIN
1446: for c_wip_negreq_csr in wip_negreq_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop

Line 1443: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);

1439: and wro.required_quantity < 0
1440: and wro.operation_seq_num > 0
1441: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1442: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1443: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1444: l_qty NUMBER := 0;
1445: BEGIN
1446: for c_wip_negreq_csr in wip_negreq_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop
1447: l_qty := c_wip_negreq_csr.item_qty;

Line 1477: and sched.status_type IN (WIP_CONSTANTS.UNRELEASED,

1473: and rep_items.organization_id = p_org_id
1474: and rep_items.wip_entity_id = sched.wip_entity_id
1475: and rep_items.line_id = sched.line_id
1476: and sched.organization_id = rep_items.organization_id
1477: and sched.status_type IN (WIP_CONSTANTS.UNRELEASED,
1478: WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1479: and dates.seq_num is not null
1480: and TRUNC(dates.calendar_date) >= TRUNC(sched.first_unit_completion_date)
1481: and TRUNC(dates.calendar_date)

Line 1478: WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)

1474: and rep_items.wip_entity_id = sched.wip_entity_id
1475: and rep_items.line_id = sched.line_id
1476: and sched.organization_id = rep_items.organization_id
1477: and sched.status_type IN (WIP_CONSTANTS.UNRELEASED,
1478: WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1479: and dates.seq_num is not null
1480: and TRUNC(dates.calendar_date) >= TRUNC(sched.first_unit_completion_date)
1481: and TRUNC(dates.calendar_date)
1482: <= (select trunc(cal.calendar_date - 1)

Line 2359: if (g_logLevel <= wip_constants.trace_logging) then

2355: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: setting up savepoint WIP_SHORT_CALC_START');
2356: SAVEPOINT WIP_SHORT_CALC_START;
2357: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: savepoint WIP_SHORT_CALC_START successful');
2358:
2359: if (g_logLevel <= wip_constants.trace_logging) then
2360: l_params(1).paramName := 'p_org_id';
2361: l_params(1).paramValue := p_org_id;
2362: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2363: p_params => l_params,

Line 2418: if (g_logLevel <= wip_constants.trace_logging) then

2414: commit;
2415: wip_ws_util.log_time('WIPWSSHB:calc_shortage:Done with db commit');
2416: wip_ws_util.trace_log('WIPWSSHB:calc_shortage:Done with db commit');
2417:
2418: if (g_logLevel <= wip_constants.trace_logging) then
2419: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2420: p_procReturnStatus => retcode,
2421: p_msg => 'Request processed successfully!',
2422: x_returnStatus => l_returnStatus);

Line 2433: if (g_logLevel <= wip_constants.trace_logging) then

2429: retcode := 2; -- End with error
2430: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2431: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2432: errbuf := fnd_message.get;
2433: if (g_logLevel <= wip_constants.trace_logging) then
2434: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2435: p_procReturnStatus => retcode,
2436: p_msg => 'unexpected error: ' || SQLERRM,
2437: x_returnStatus => l_returnStatus);

Line 2448: if (g_logLevel <= wip_constants.trace_logging) then

2444: --bug 6756693 Get the message and write it
2445: errbuf := fnd_message.get;
2446: fnd_file.put_line(fnd_file.log, errbuf);
2447: --end bug 6756693
2448: if (g_logLevel <= wip_constants.trace_logging) then
2449: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2450: p_procReturnStatus => retcode,
2451: p_msg => 'expected error: ' || errbuf,
2452: x_returnStatus => l_returnStatus);

Line 2459: if (g_logLevel <= wip_constants.trace_logging) then

2455: WHEN OTHERS THEN
2456: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Others Exception: '|| SQLERRM);
2457: ROLLBACK TO WIP_SHORT_CALC_START;
2458: retcode := 2; --End with error
2459: if (g_logLevel <= wip_constants.trace_logging) then
2460: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2461: p_procReturnStatus => retcode,
2462: p_msg => 'error: ' || SQLERRM,
2463: x_returnStatus => l_returnStatus);