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.WSMPLBMI dependencies on WSMPUTIL

Line 52: WSMPUTIL.check_charges_exist ( p_wip_entity_id,

48: l_stmt_num number;
49:
50: BEGIN
51: l_stmt_num := 10;
52: WSMPUTIL.check_charges_exist ( p_wip_entity_id,
53: p_org_id,
54: p_fm_op_seq_num,
55: p_wo_op_seq_id,
56: l_charges_exist,

Line 392: x_return_code := WSMPUTIL.CHECK_WSM_ORG (p_org_id, l_retcode, x_err_buf);

388: x_return_code := 1;
389: return(x_return_code);
390: END;
391:
392: x_return_code := WSMPUTIL.CHECK_WSM_ORG (p_org_id, l_retcode, x_err_buf);
393:
394: IF ( (x_return_code = 0) OR (l_retcode<>0) ) THEN
395: x_return_code := 1;
396:

Line 451: g_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(x_err_code => l_err_code,

447: AND ORGANIZATION_ID = p_org_id
448: AND TRUNC(NVL(p_txn_date,SYSDATE))
449: BETWEEN PERIOD_START_DATE and SCHEDULE_CLOSE_DATE;*/
450:
451: g_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(x_err_code => l_err_code,
452: x_err_msg => l_err_msg,
453: p_organization_id => p_org_id,
454: p_date => p_txn_date);
455:

Line 576: AND (WSMPUTIL.get_internal_copy_type(l_wip_entity_id)=3)) THEN

572:
573: --bug 3512105
574: l_stmt_num := 34;
575: IF ((g_aps_wps_profile = 'Y')
576: AND (WSMPUTIL.get_internal_copy_type(l_wip_entity_id)=3)) THEN
577: fnd_message.set_name(
578: application => 'WSM',
579: name => 'WSM_NO_VALID_COPY');
580: x_err_buf := FND_MESSAGE.GET;

Line 1073: /* l_res_rows := WSMPUTIL.CHECK_WMTI (l_wip_entity_id,

1069:
1070: l_stmt_num := 140;
1071:
1072: --bug 3453139 removed CHECK_WMTI, CHECK_WSMT
1073: /* l_res_rows := WSMPUTIL.CHECK_WMTI (l_wip_entity_id,
1074: NVL(p_wip_entity_name, l_wip_entity_name_temp), -- Fix for bug #2095035
1075: p_txn_date,
1076: x_return_code,
1077: x_err_buf,

Line 1092: l_res_rows := WSMPUTIL.CHECK_WSMT (l_wip_entity_id,

1088: END IF;
1089:
1090: l_stmt_num := 145;
1091:
1092: l_res_rows := WSMPUTIL.CHECK_WSMT (l_wip_entity_id,
1093: NVL(p_wip_entity_name, l_wip_entity_name_temp), -- Fix for bug #2095035
1094: p_txn_id,
1095: p_txn_date,
1096: x_return_code,

Line 1610: WSMPUTIL.find_routing_end(l_routing_seq_id,

1606: l_stmt_num := 190;
1607: l_op_seq_id := NULL;
1608:
1609: l_stmt_num := 195;
1610: WSMPUTIL.find_routing_end(l_routing_seq_id,
1611: l_rtg_revision_date, -- Add: CZH.I_OED-1, use rtg rev date
1612: l_end_op_seq_id,
1613: x_return_code,
1614: x_err_buf);

Line 1624: ||'): Returned success from WSMPUTIL.find_routing_end');

1620: return(x_return_code);
1621: ELSE
1622: if (l_debug = 'Y') then
1623: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num
1624: ||'): Returned success from WSMPUTIL.find_routing_end');
1625: end if;
1626: END IF;
1627:
1628: -- BA: CZH.I_OED-2, should consider operation replacement, will never get NULL since x_return_code = 0

Line 1629: l_end_op_seq_id := WSMPUTIL.replacement_op_seq_id(

1625: end if;
1626: END IF;
1627:
1628: -- BA: CZH.I_OED-2, should consider operation replacement, will never get NULL since x_return_code = 0
1629: l_end_op_seq_id := WSMPUTIL.replacement_op_seq_id(
1630: l_end_op_seq_id,
1631: l_rtg_revision_date);
1632: --NO CHECK FOR RETURN VALUES HERE....-VJ--
1633: -- EA: CZH.I_OED-2

Line 1664: IF(WSMPUTIL.effective_next_op_exists(

1660:
1661: -- BA: CZH.I_OED-1, give warning message if there is no effective next operation
1662: l_stmt_num := 202;
1663:
1664: IF(WSMPUTIL.effective_next_op_exists(
1665: p_organization_id => p_org_id,
1666: p_wip_entity_id => l_wip_entity_id,
1667: p_wo_op_seq_num => p_fm_op_seq_num,
1668: p_end_op_seq_id => l_end_op_seq_id, -- CZH.I_9999

Line 1879: --where WSMPUTIL.replacement_op_seq_id (

1875:
1876: select 1
1877: into l_temp
1878: from bom_operation_networks
1879: --where WSMPUTIL.replacement_op_seq_id (
1880: -- from_op_seq_id,
1881: -- l_rtg_revision_date) = l_wo_op_seq_id
1882: where from_op_seq_id IN (
1883: select bos.operation_sequence_id

Line 1890: and WSMPUTIL.replacement_op_seq_id (

1886: where bos.operation_seq_num = bos2.operation_seq_num
1887: AND bos.routing_sequence_id = bos2.routing_sequence_id
1888: AND bos2.operation_sequence_id = l_wo_op_seq_id
1889: )
1890: and WSMPUTIL.replacement_op_seq_id (
1891: to_op_seq_id,
1892: l_rtg_revision_date) = l_op_seq_id;
1893: -- EC: CZH.I_OED-2
1894: -- EC: CZH.I_OED-1

Line 3144: l_est_scrap_acc := wsmputil.wsm_esa_enabled(l_wip_entity_id,

3140:
3141: -- abb H optional scap accounting begin
3142: /*******************************************************************************
3143: bug 3571019 rewriting the ESA validations for clarity
3144: l_est_scrap_acc := wsmputil.wsm_esa_enabled(l_wip_entity_id,
3145: x_return_code,
3146: x_err_buf);
3147:
3148: IF (x_return_code <> 0) THEN

Line 3292: l_est_scrap_acc := wsmputil.wsm_esa_enabled(l_wip_entity_id,

3288: l_wlmti_scrap_acct_id := '';
3289:
3290: end if; -- org is scrap acc enabled.
3291: *******************************************************************************/
3292: l_est_scrap_acc := wsmputil.wsm_esa_enabled(l_wip_entity_id,
3293: x_return_code,
3294: x_err_buf);
3295:
3296: IF (x_return_code <> 0) THEN

Line 4242: l_est_scrap_acc := wsmputil.WSM_ESA_ENABLED(

4238:
4239: l_stmt_num := 410;
4240: -- abb bugfix 2484294 begin
4241: -- check that the class code and the dept of the last operation have the relevant accounts defined.
4242: l_est_scrap_acc := wsmputil.WSM_ESA_ENABLED(
4243: p_wip_entity_id => l_wip_entity_id,
4244: err_code => l_err_code,
4245: err_msg => l_err_msg,
4246: p_org_id => p_org_id,

Line 4911: l_est_scrap_acc := wsmputil.wsm_esa_enabled(l_wip_entity_id,

4907: where header_id = p_header_id;
4908: l_stmt_num := 455;
4909:
4910: --abb H optional scrap acc begin
4911: l_est_scrap_acc := wsmputil.wsm_esa_enabled(l_wip_entity_id,
4912: x_return_code,
4913: x_err_buf);
4914:
4915: IF (x_return_code <> 0) THEN

Line 5868: WSMPUTIL.AUTONOMOUS_TXN(p_user=> g_user_id,

5864: l_transaction_id NUMBER;
5865: BEGIN
5866: l_stmt_num := 10;
5867: fnd_file.put_line(fnd_file.log, 'Inside error_handler '||'p_error_msg='||p_error_msg||' p_header_id='||' p_txn_id='||p_transaction_id);
5868: WSMPUTIL.AUTONOMOUS_TXN(p_user=> g_user_id,
5869: p_login=> g_login_id,
5870: p_header_id => p_header_id,
5871: p_message => p_error_msg,
5872: p_request_id => g_request_id,

Line 6273: --move enh 115.137 changed from WSMPCNST to WSMPUTIL

6269: resp_id => 50511,
6270: resp_appl_id => 700);
6271: fnd_file.put_line(fnd_file.log, 'session ID = ' || fnd_global.session_id);*/
6272: END IF;
6273: --move enh 115.137 changed from WSMPCNST to WSMPUTIL
6274: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
6275: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
6276: END IF;
6277:

Line 6274: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN

6270: resp_appl_id => 700);
6271: fnd_file.put_line(fnd_file.log, 'session ID = ' || fnd_global.session_id);*/
6272: END IF;
6273: --move enh 115.137 changed from WSMPCNST to WSMPUTIL
6274: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
6275: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
6276: END IF;
6277:
6278: if (l_job_copy_flag = 1) then

Line 6275: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;

6271: fnd_file.put_line(fnd_file.log, 'session ID = ' || fnd_global.session_id);*/
6272: END IF;
6273: --move enh 115.137 changed from WSMPCNST to WSMPUTIL
6274: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
6275: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
6276: END IF;
6277:
6278: if (l_job_copy_flag = 1) then
6279: g_aps_wps_profile := 'Y';

Line 6414: --move enh 115.137 changed from WSMPCNST to WSMPUTIL

6410: l_jump_flag,
6411: l_scrap_qty,
6412: l_scrap_at_operation_flag,
6413: l_user_serial_tracking; -- ST : Serial Support Project --
6414: --move enh 115.137 changed from WSMPCNST to WSMPUTIL
6415: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
6416: if (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_organization_id) = 2) then
6417: g_aps_wps_profile := 'N';
6418: else

Line 6415: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN

6411: l_scrap_qty,
6412: l_scrap_at_operation_flag,
6413: l_user_serial_tracking; -- ST : Serial Support Project --
6414: --move enh 115.137 changed from WSMPCNST to WSMPUTIL
6415: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
6416: if (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_organization_id) = 2) then
6417: g_aps_wps_profile := 'N';
6418: else
6419: g_aps_wps_profile := 'Y';

Line 6416: if (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_organization_id) = 2) then

6412: l_scrap_at_operation_flag,
6413: l_user_serial_tracking; -- ST : Serial Support Project --
6414: --move enh 115.137 changed from WSMPCNST to WSMPUTIL
6415: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
6416: if (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_organization_id) = 2) then
6417: g_aps_wps_profile := 'N';
6418: else
6419: g_aps_wps_profile := 'Y';
6420: end if;

Line 7705: WSMPUTIL.find_routing_end(l_routing_seq_id,

7701: WHERE wip_entity_id = l_wip_entity_id;
7702: -- ST : Serial Project --
7703:
7704: l_stmt_num := 130.2;
7705: WSMPUTIL.find_routing_end(l_routing_seq_id,
7706: /* BA: CZH.I_OED-1 */
7707: TO_DATE(l_rtg_revision_date, 'YYYY/MM/DD HH24:MI:SS'), /* CHG: BUG2380517 add SS */ /* EA: CZH.I_OED-1 */
7708: l_end_op_seq_id,
7709: x_error_code,

Line 7732: l_end_op_seq_id := WSMPUTIL.replacement_op_seq_id(l_end_op_seq_id,

7728: END IF;
7729:
7730: /* BA: CZH.I_OED-2, should consider operation replacement */
7731: l_stmt_num := 140;
7732: l_end_op_seq_id := WSMPUTIL.replacement_op_seq_id(l_end_op_seq_id,
7733: TO_DATE(l_rtg_revision_date, 'YYYY/MM/DD HH24:MI:SS') ); /* CHG: BUG2380517 add SS */
7734: /* EA: CZH.I_OED-2 */
7735:
7736: IF (l_transaction_type = 4) THEN

Line 12303: x_estimated_scrap_accounting := wsmputil.wsm_esa_enabled(

12299: x_show_scrap_qty := 1;
12300: END IF;
12301:
12302: l_stmt_num := 80;
12303: x_estimated_scrap_accounting := wsmputil.wsm_esa_enabled(
12304: p_wip_entity_id => p_wip_entity_id,
12305: err_code => x_return_code,
12306: err_msg => x_error_msg,
12307: p_org_id => p_organization_id,