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 193: status_str := to_char(wip_constants.RELEASED);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1294: from wip_discrete_jobs wdj
1295: where wdj.organization_id = p_org_id
1296: and wdj.primary_item_id = p_inv_item_id
1297: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1298: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1299: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1300: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1301: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1302: l_qty NUMBER := 0;

Line 1299: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)

1295: where wdj.organization_id = p_org_id
1296: and wdj.primary_item_id = p_inv_item_id
1297: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1298: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1299: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1300: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1301: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1302: l_qty NUMBER := 0;
1303: BEGIN

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

1297: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1298: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1299: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1300: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1301: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1302: l_qty NUMBER := 0;
1303: BEGIN
1304: for c_job_csr in job_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop
1305: l_qty := l_qty + (c_job_csr.item_qty - nvl(c_job_csr.reservation_qty,0));

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

1363: and wro.inventory_item_id = p_inv_item_id
1364: and trunc(wro.date_required) = trunc(p_rcpt_date)
1365: and wro.organization_id = wdj.organization_id
1366: and wro.wip_entity_id = wdj.wip_entity_id
1367: and wro.wip_supply_type <> wip_constants.PHANTOM
1368: and wro.required_quantity < 0
1369: and wro.operation_seq_num > 0
1370: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1371: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,

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

1366: and wro.wip_entity_id = wdj.wip_entity_id
1367: and wro.wip_supply_type <> wip_constants.PHANTOM
1368: and wro.required_quantity < 0
1369: and wro.operation_seq_num > 0
1370: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1371: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1372: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1373: l_qty NUMBER := 0;
1374: BEGIN

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

1367: and wro.wip_supply_type <> wip_constants.PHANTOM
1368: and wro.required_quantity < 0
1369: and wro.operation_seq_num > 0
1370: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1371: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1372: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1373: l_qty NUMBER := 0;
1374: BEGIN
1375: for c_wip_negreq_csr in wip_negreq_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop

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

1368: and wro.required_quantity < 0
1369: and wro.operation_seq_num > 0
1370: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1371: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1372: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1373: l_qty NUMBER := 0;
1374: BEGIN
1375: for c_wip_negreq_csr in wip_negreq_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop
1376: l_qty := c_wip_negreq_csr.item_qty;

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

1402: and rep_items.organization_id = p_org_id
1403: and rep_items.wip_entity_id = sched.wip_entity_id
1404: and rep_items.line_id = sched.line_id
1405: and sched.organization_id = rep_items.organization_id
1406: and sched.status_type IN (WIP_CONSTANTS.UNRELEASED,
1407: WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1408: and dates.seq_num is not null
1409: and TRUNC(dates.calendar_date) >= TRUNC(sched.first_unit_completion_date)
1410: and TRUNC(dates.calendar_date)

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

1403: and rep_items.wip_entity_id = sched.wip_entity_id
1404: and rep_items.line_id = sched.line_id
1405: and sched.organization_id = rep_items.organization_id
1406: and sched.status_type IN (WIP_CONSTANTS.UNRELEASED,
1407: WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1408: and dates.seq_num is not null
1409: and TRUNC(dates.calendar_date) >= TRUNC(sched.first_unit_completion_date)
1410: and TRUNC(dates.calendar_date)
1411: <= (select trunc(cal.calendar_date - 1)

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

2284: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: setting up savepoint WIP_SHORT_CALC_START');
2285: SAVEPOINT WIP_SHORT_CALC_START;
2286: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: savepoint WIP_SHORT_CALC_START successful');
2287:
2288: if (g_logLevel <= wip_constants.trace_logging) then
2289: l_params(1).paramName := 'p_org_id';
2290: l_params(1).paramValue := p_org_id;
2291: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2292: p_params => l_params,

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

2343: commit;
2344: wip_ws_util.log_time('WIPWSSHB:calc_shortage:Done with db commit');
2345: wip_ws_util.trace_log('WIPWSSHB:calc_shortage:Done with db commit');
2346:
2347: if (g_logLevel <= wip_constants.trace_logging) then
2348: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2349: p_procReturnStatus => retcode,
2350: p_msg => 'Request processed successfully!',
2351: x_returnStatus => l_returnStatus);

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

2358: retcode := 2; -- End with error
2359: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2360: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2361: errbuf := fnd_message.get;
2362: if (g_logLevel <= wip_constants.trace_logging) then
2363: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2364: p_procReturnStatus => retcode,
2365: p_msg => 'unexpected error: ' || SQLERRM,
2366: x_returnStatus => l_returnStatus);

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

2373: --bug 6756693 Get the message and write it
2374: errbuf := fnd_message.get;
2375: fnd_file.put_line(fnd_file.log, errbuf);
2376: --end bug 6756693
2377: if (g_logLevel <= wip_constants.trace_logging) then
2378: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2379: p_procReturnStatus => retcode,
2380: p_msg => 'expected error: ' || errbuf,
2381: x_returnStatus => l_returnStatus);

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

2384: WHEN OTHERS THEN
2385: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Others Exception: '|| SQLERRM);
2386: ROLLBACK TO WIP_SHORT_CALC_START;
2387: retcode := 2; --End with error
2388: if (g_logLevel <= wip_constants.trace_logging) then
2389: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2390: p_procReturnStatus => retcode,
2391: p_msg => 'error: ' || SQLERRM,
2392: x_returnStatus => l_returnStatus);