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_UTIL dependencies on WIP_WS_UTIL

Line 1: package body wip_ws_util as

1: package body wip_ws_util as
2: /* $Header: wipwsutb.pls 120.25.12010000.4 2008/09/16 21:53:58 awongwai ship $ */
3:
4: --Bug 6889755 Component Shortage Constants
5: ORG_CALCULATION_LEVEL CONSTANT NUMBER := 1;

Line 521: l_emp_name := wip_ws_util.get_employee_name(p_employee_id, null);

517: l_date date;
518: l_date_str varchar2(256);
519: Begin
520:
521: l_emp_name := wip_ws_util.get_employee_name(p_employee_id, null);
522:
523: /* seem we have re-read the timezone profile to be synch with oa */
524: init_timezone;
525:

Line 612: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_job_note');

608: exception when others then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610:
611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
612: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_job_note');
613: END IF;
614:
615: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
616: end append_job_note;

Line 647: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_job_note');

643: exception when others then
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645:
646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
647: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_job_note');
648: END IF;
649:
650: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
651: end append_job_note;

Line 686: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_exception_note');

682: exception when others then
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684:
685: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
686: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_exception_note');
687: END IF;
688:
689: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
690: end append_exception_note;

Line 1355: l_row_seq_num := wip_ws_util.get_multival_pref_seq(

1351: l_row_seq_num NUMBER;
1352: l_shortage_calc_level NUMBER;
1353: BEGIN
1354: --Bug 6889755 - Return component shortage depending on the calculation level setup
1355: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1356: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));
1357:
1358: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1359: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);

Line 1358: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(

1354: --Bug 6889755 - Return component shortage depending on the calculation level setup
1355: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1356: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));
1357:
1358: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1359: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);
1360: --End Bug 6889755
1361:
1362: --Bug 6889755 - added IF condition and the ELSE block for subinv level check

Line 1428: l_row_seq_num := wip_ws_util.get_multival_pref_seq(

1424: l_calc_level NUMBER;
1425: l_row_seq_num NUMBER;
1426: BEGIN
1427: --get the sequence number
1428: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1429: g_pref_id_comp_short, g_pref_level_id_site, g_pref_val_mast_org_att, to_char(p_org_id));
1430:
1431: if(l_row_seq_num is null) then
1432: return 1; --return org level by default inorder to avoid error

Line 1435: l_calc_level := wip_ws_util.get_multival_pref_val_code(

1431: if(l_row_seq_num is null) then
1432: return 1; --return org level by default inorder to avoid error
1433: end if;
1434:
1435: l_calc_level := wip_ws_util.get_multival_pref_val_code(
1436: g_pref_id_comp_short, g_pref_level_id_site, l_row_seq_num, g_pref_val_calclevel_att);
1437:
1438: return l_calc_level;
1439:

Line 1449: wip_ws_util.trace_log('Program application id '|| p_program_application_id);

1445: p_org_id in number) RETURN number
1446: IS
1447: l_pgm_count number;
1448: BEGIN
1449: wip_ws_util.trace_log('Program application id '|| p_program_application_id);
1450: wip_ws_util.trace_log('Concurrent program id '|| p_concurrent_program_id);
1451: wip_ws_util.trace_log('Oraganization id '|| p_org_id);
1452: SELECT count(1)
1453: INTO l_pgm_count

Line 1450: wip_ws_util.trace_log('Concurrent program id '|| p_concurrent_program_id);

1446: IS
1447: l_pgm_count number;
1448: BEGIN
1449: wip_ws_util.trace_log('Program application id '|| p_program_application_id);
1450: wip_ws_util.trace_log('Concurrent program id '|| p_concurrent_program_id);
1451: wip_ws_util.trace_log('Oraganization id '|| p_org_id);
1452: SELECT count(1)
1453: INTO l_pgm_count
1454: FROM fnd_concurrent_requests

Line 1451: wip_ws_util.trace_log('Oraganization id '|| p_org_id);

1447: l_pgm_count number;
1448: BEGIN
1449: wip_ws_util.trace_log('Program application id '|| p_program_application_id);
1450: wip_ws_util.trace_log('Concurrent program id '|| p_concurrent_program_id);
1451: wip_ws_util.trace_log('Oraganization id '|| p_org_id);
1452: SELECT count(1)
1453: INTO l_pgm_count
1454: FROM fnd_concurrent_requests
1455: WHERE program_application_id = p_program_application_id

Line 1459: wip_ws_util.trace_log('Running concurrent program '|| l_pgm_count);

1455: WHERE program_application_id = p_program_application_id
1456: AND concurrent_program_id = p_concurrent_program_id
1457: AND upper(phase_code) = 'R'
1458: AND argument1 = to_char(p_org_id);
1459: wip_ws_util.trace_log('Running concurrent program '|| l_pgm_count);
1460: return l_pgm_count;
1461: END get_no_of_running_concurrent;
1462:
1463:

Line 1471: wip_ws_util.trace_log('Unable to run '|| p_program_name ||' calculation program for organization ' || get_calendar_code(p_org_id));

1467: IS
1468: l_org_code varchar2(3);
1469: BEGIN
1470:
1471: wip_ws_util.trace_log('Unable to run '|| p_program_name ||' calculation program for organization ' || get_calendar_code(p_org_id));
1472: wip_ws_util.trace_log('Another instance may be running. Please try again after some time.');
1473:
1474: END log_for_duplicate_concurrent;
1475:

Line 1472: wip_ws_util.trace_log('Another instance may be running. Please try again after some time.');

1468: l_org_code varchar2(3);
1469: BEGIN
1470:
1471: wip_ws_util.trace_log('Unable to run '|| p_program_name ||' calculation program for organization ' || get_calendar_code(p_org_id));
1472: wip_ws_util.trace_log('Another instance may be running. Please try again after some time.');
1473:
1474: END log_for_duplicate_concurrent;
1475:
1476:

Line 1477: end wip_ws_util;

1473:
1474: END log_for_duplicate_concurrent;
1475:
1476:
1477: end wip_ws_util;
1478: