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 3694: IF (WSMPUTIL.check_osp_operation(p_wip_entity_id => l_wip_entity_id,

3690: current_job_op_seq_num = l_new_op_added
3691: where wip_entity_id = l_wip_entity_id;
3692:
3693: --osp
3694: IF (WSMPUTIL.check_osp_operation(p_wip_entity_id => l_wip_entity_id,
3695: p_operation_seq_num => l_new_op_added,
3696: p_organization_id => l_org_id))
3697: THEN
3698:

Line 3726: --WSMPUTIL.check_osp_operation

3722: end if;
3723: end if;
3724:
3725: END IF;
3726: --WSMPUTIL.check_osp_operation
3727: --osp end
3728:
3729: x_err_code := 0;
3730: x_err_buf := null;

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

3810: l_stmt_num := 20;
3811: l_err_code := 0;
3812: l_err_buf := null;
3813:
3814: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(l_err_code,
3815: l_err_buf,
3816: p_txn_org_id,
3817: p_txn_date);
3818: --End NL BugFix 3126650

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

3821: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3822:
3823: l_msg_tokens.delete;
3824: WSM_log_PVT.logMessage(p_module_name => l_module ,
3825: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,
3826: p_stmt_num => l_stmt_num ,
3827: p_msg_tokens => l_msg_tokens,
3828: p_fnd_msg_level => G_MSG_LVL_ERROR ,
3829: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

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

4052: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).bom_reference_id;
4053: end if;
4054:
4055:
4056: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id);
4057: --OPTII-PERF:Find if phantom exists or not.
4058: BEGIN
4059: select 1 into l_phantom_exists
4060: from bom_inventory_components

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

4315: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).routing_reference_id;
4316: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).bom_reference_id;
4317: end if;
4318:
4319: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id);
4320: --OPTII-PERF
4321: BEGIN
4322: select 1 into l_phantom_exists
4323: from bom_inventory_components

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

4449: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).routing_reference_id;
4450: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).bom_reference_id;
4451: end if;
4452:
4453: l_res_bill_seq_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).wip_entity_id);
4454: --OPTII-PERF:Find l_phantom_exists
4455: BEGIN
4456: select 1 into l_phantom_exists
4457: from bom_inventory_components

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

4895: END IF;
4896: end if;
4897: End if;
4898:
4899: l_profile_value := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_txn_org_id); -- This returns the Profile value
4900:
4901: l_stmt_num := 20;
4902:
4903: select meaning

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

6815: where wip_entity_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id;
6816:
6817: l_stmt_num := 158;
6818:
6819: IF (WSMPUTIL.check_osp_operation(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
6820: p_operation_seq_num => p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_num,
6821: p_organization_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).organization_id
6822: )
6823: )

Line 7314: 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);

7310: l_acct_period_id := -1;
7311: l_err_code := -1;
7312: l_err_buf := null;
7313:
7314: 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);
7315:
7316: IF (l_err_code <> 0) THEN
7317: /*error out*/
7318: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN