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.31.12020000.4 2012/12/25 00:47:13 hliew ship $ */
3:
4: --Bug 6889755 Component Shortage Constants
5: ORG_CALCULATION_LEVEL CONSTANT NUMBER := 1;

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

558: l_date date;
559: l_date_str varchar2(256);
560: Begin
561:
562: l_emp_name := wip_ws_util.get_employee_name(p_employee_id, null);
563:
564: /* seem we have re-read the timezone profile to be synch with oa */
565: init_timezone;
566:

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

649: exception when others then
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651:
652: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
653: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_job_note');
654: END IF;
655:
656: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
657: end append_job_note;

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

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

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

723: exception when others then
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
725:
726: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
727: FND_MSG_PUB.Add_Exc_Msg ('wip_ws_util' ,'append_exception_note');
728: END IF;
729:
730: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
731: end append_exception_note;

Line 1396: l_row_seq_num := wip_ws_util.get_multival_pref_seq(

1392: l_row_seq_num NUMBER;
1393: l_shortage_calc_level NUMBER;
1394: BEGIN
1395: --Bug 6889755 - Return component shortage depending on the calculation level setup
1396: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1397: 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));
1398:
1399: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1400: 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 1399: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(

1395: --Bug 6889755 - Return component shortage depending on the calculation level setup
1396: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1397: 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));
1398:
1399: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1400: 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);
1401: --End Bug 6889755
1402:
1403: --Bug 6889755 - added IF condition and the ELSE block for subinv level check

Line 1474: l_row_seq_num := wip_ws_util.get_multival_pref_seq(

1470: l_calc_level NUMBER;
1471: l_row_seq_num NUMBER;
1472: BEGIN
1473: --get the sequence number
1474: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1475: g_pref_id_comp_short, g_pref_level_id_site, g_pref_val_mast_org_att, to_char(p_org_id));
1476:
1477: if(l_row_seq_num is null) then
1478: return 1; --return org level by default inorder to avoid error

Line 1481: l_calc_level := wip_ws_util.get_multival_pref_val_code(

1477: if(l_row_seq_num is null) then
1478: return 1; --return org level by default inorder to avoid error
1479: end if;
1480:
1481: l_calc_level := wip_ws_util.get_multival_pref_val_code(
1482: g_pref_id_comp_short, g_pref_level_id_site, l_row_seq_num, g_pref_val_calclevel_att);
1483:
1484: return l_calc_level;
1485:

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

1491: p_org_id in number) RETURN number
1492: IS
1493: l_pgm_count number;
1494: BEGIN
1495: wip_ws_util.trace_log('Program application id '|| p_program_application_id);
1496: wip_ws_util.trace_log('Concurrent program id '|| p_concurrent_program_id);
1497: wip_ws_util.trace_log('Oraganization id '|| p_org_id);
1498: SELECT count(1)
1499: INTO l_pgm_count

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

1492: IS
1493: l_pgm_count number;
1494: BEGIN
1495: wip_ws_util.trace_log('Program application id '|| p_program_application_id);
1496: wip_ws_util.trace_log('Concurrent program id '|| p_concurrent_program_id);
1497: wip_ws_util.trace_log('Oraganization id '|| p_org_id);
1498: SELECT count(1)
1499: INTO l_pgm_count
1500: FROM fnd_concurrent_requests

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

1493: l_pgm_count number;
1494: BEGIN
1495: wip_ws_util.trace_log('Program application id '|| p_program_application_id);
1496: wip_ws_util.trace_log('Concurrent program id '|| p_concurrent_program_id);
1497: wip_ws_util.trace_log('Oraganization id '|| p_org_id);
1498: SELECT count(1)
1499: INTO l_pgm_count
1500: FROM fnd_concurrent_requests
1501: WHERE program_application_id = p_program_application_id

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

1501: WHERE program_application_id = p_program_application_id
1502: AND concurrent_program_id = p_concurrent_program_id
1503: AND upper(phase_code) = 'R'
1504: AND argument1 = to_char(p_org_id);
1505: wip_ws_util.trace_log('Running concurrent program '|| l_pgm_count);
1506: return l_pgm_count;
1507: END get_no_of_running_concurrent;
1508:
1509:

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

1513: IS
1514: l_org_code varchar2(3);
1515: BEGIN
1516:
1517: wip_ws_util.trace_log('Unable to run '|| p_program_name ||' calculation program for organization ' || get_calendar_code(p_org_id));
1518: wip_ws_util.trace_log('Another instance may be running. Please try again after some time.');
1519:
1520: END log_for_duplicate_concurrent;
1521:

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

1514: l_org_code varchar2(3);
1515: BEGIN
1516:
1517: wip_ws_util.trace_log('Unable to run '|| p_program_name ||' calculation program for organization ' || get_calendar_code(p_org_id));
1518: wip_ws_util.trace_log('Another instance may be running. Please try again after some time.');
1519:
1520: END log_for_duplicate_concurrent;
1521:
1522: -- Bug 10364497.

Line 1795: select wip_ws_util.get_jobop_name(l_job_name, l_op_seq)

1791: select to_char(l_c_clock_date, WIP_CONSTANTS.DATETIME_FMT)
1792: into l_clock_desc
1793: from dual;
1794:
1795: select wip_ws_util.get_jobop_name(l_job_name, l_op_seq)
1796: into l_job_desc
1797: from dual;
1798:
1799: l_result := l_job_desc || ', ' || l_clock_desc;

Line 1916: end wip_ws_util;

1912: return l_issue_qty;
1913: End get_assy_serial_issue_qty;
1914:
1915:
1916: end wip_ws_util;
1917: