DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on WSMPUTIL

Line 3058: WSMPUTIL.check_charges_exist (p_wip_entity_id => p_wip_entity_id,

3054: l_stmt_num := 40;
3055: x_err_code := 0;
3056: x_err_buf := null;
3057:
3058: WSMPUTIL.check_charges_exist (p_wip_entity_id => p_wip_entity_id,
3059: p_organization_id => p_org_id,
3060: p_op_seq_num => l_job_op_seq_num,
3061: p_op_seq_id => l_job_op_seq_id,
3062: p_charges_exist => l_charges_exist,

Line 3688: IF (WSMPUTIL.check_osp_operation(p_wip_entity_id => l_wip_entity_id,

3684: current_job_op_seq_num = l_new_op_added
3685: where wip_entity_id = l_wip_entity_id;
3686:
3687: --osp
3688: IF (WSMPUTIL.check_osp_operation(p_wip_entity_id => l_wip_entity_id,
3689: p_operation_seq_num => l_new_op_added,
3690: p_organization_id => l_org_id))
3691: THEN
3692:

Line 3720: --WSMPUTIL.check_osp_operation

3716: end if;
3717: end if;
3718:
3719: END IF;
3720: --WSMPUTIL.check_osp_operation
3721: --osp end
3722:
3723: x_err_code := 0;
3724: x_err_buf := null;

Line 3808: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(l_err_code,

3804: l_stmt_num := 20;
3805: l_err_code := 0;
3806: l_err_buf := null;
3807:
3808: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(l_err_code,
3809: l_err_buf,
3810: p_txn_org_id,
3811: p_txn_date);
3812: --End NL BugFix 3126650

Line 3819: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,

3815: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3816:
3817: l_msg_tokens.delete;
3818: WSM_log_PVT.logMessage(p_module_name => l_module ,
3819: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,
3820: p_stmt_num => l_stmt_num ,
3821: p_msg_tokens => l_msg_tokens,
3822: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3823: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 4050: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id);

4046: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).bom_reference_id;
4047: end if;
4048:
4049:
4050: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id);
4051: --OPTII-PERF:Find if phantom exists or not.
4052: BEGIN
4053: select 1 into l_phantom_exists
4054: from bom_inventory_components

Line 4311: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id);

4307: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).routing_reference_id;
4308: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).bom_reference_id;
4309: end if;
4310:
4311: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id);
4312: --OPTII-PERF
4313: BEGIN
4314: select 1 into l_phantom_exists
4315: from bom_inventory_components

Line 4445: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).wip_entity_id);

4441: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).routing_reference_id;
4442: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).bom_reference_id;
4443: end if;
4444:
4445: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).wip_entity_id);
4446: --OPTII-PERF:Find l_phantom_exists
4447: BEGIN
4448: select 1 into l_phantom_exists
4449: from bom_inventory_components

Line 4874: l_profile_value := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_txn_org_id); -- This returns the Profile value

4870: END IF;
4871: end if;
4872: End if;
4873:
4874: l_profile_value := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_txn_org_id); -- This returns the Profile value
4875:
4876: l_stmt_num := 20;
4877:
4878: select meaning

Line 6755: IF (WSMPUTIL.check_osp_operation(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,

6751: where wip_entity_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id;
6752:
6753: l_stmt_num := 158;
6754:
6755: IF (WSMPUTIL.check_osp_operation(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
6756: p_operation_seq_num => p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_num,
6757: p_organization_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).organization_id
6758: )
6759: )

Line 7250: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(l_err_code, l_err_buf, p_wltx_resulting_jobs_tbl(l_rj_index).organization_id, p_wltx_header.transaction_date);

7246: l_acct_period_id := -1;
7247: l_err_code := -1;
7248: l_err_buf := null;
7249:
7250: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(l_err_code, l_err_buf, p_wltx_resulting_jobs_tbl(l_rj_index).organization_id, p_wltx_header.transaction_date);
7251:
7252: IF (l_err_code <> 0) THEN
7253: /*error out*/
7254: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN