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.PO_VALIDATIONS dependencies on PO_VAL_DISTRIBUTIONS

Line 4286: PO_VAL_DISTRIBUTIONS.dist_num_unique(

4282: -- Distribution Validations
4283: ---------------------------------------------------------------
4284:
4285: WHEN c_dist_num_unique THEN
4286: PO_VAL_DISTRIBUTIONS.dist_num_unique(
4287: p_dist_id_tbl => p_distributions.po_distribution_id
4288: , p_line_loc_id_tbl => p_distributions.line_location_id
4289: , p_dist_num_tbl => p_distributions.distribution_num
4290: , x_result_set_id => l_result_set_id

Line 4295: PO_VAL_DISTRIBUTIONS.dist_num_gt_zero(

4291: , x_result_type => l_result_type
4292: );
4293:
4294: WHEN c_dist_num_gt_zero THEN
4295: PO_VAL_DISTRIBUTIONS.dist_num_gt_zero(
4296: p_dist_id_tbl => p_distributions.po_distribution_id
4297: , p_dist_num_tbl => p_distributions.distribution_num
4298: , x_results => x_results
4299: , x_result_type => l_result_type

Line 4303: PO_VAL_DISTRIBUTIONS.quantity_gt_zero(

4299: , x_result_type => l_result_type
4300: );
4301:
4302: WHEN c_dist_qty_gt_zero THEN
4303: PO_VAL_DISTRIBUTIONS.quantity_gt_zero(
4304: p_dist_id_tbl => p_distributions.po_distribution_id
4305: , p_qty_ordered_tbl => p_distributions.quantity_ordered
4306: -- : Use value_basis instead of order_type_lookup_code
4307: , p_value_basis_tbl => p_distributions.ship_value_basis

Line 4314: PO_VAL_DISTRIBUTIONS.quantity_ge_quantity_exec(

4310: );
4311:
4312: -- : Combined billed and del into exec
4313: WHEN c_dist_qty_ge_qty_exec THEN
4314: PO_VAL_DISTRIBUTIONS.quantity_ge_quantity_exec(
4315: p_dist_id_tbl => p_distributions.po_distribution_id
4316: , p_dist_type_tbl => p_distributions.distribution_type
4317: , p_qty_ordered_tbl => p_distributions.quantity_ordered
4318: , x_result_set_id => l_result_set_id

Line 4324: PO_VAL_DISTRIBUTIONS.amount_gt_zero(

4320: );
4321: --
4322:
4323: WHEN c_dist_amt_gt_zero THEN
4324: PO_VAL_DISTRIBUTIONS.amount_gt_zero(
4325: p_dist_id_tbl => p_distributions.po_distribution_id
4326: , p_amt_ordered_tbl => p_distributions.amount_ordered
4327: -- : Use value_basis instead of order_type_lookup_code
4328: , p_value_basis_tbl => p_distributions.ship_value_basis

Line 4335: PO_VAL_DISTRIBUTIONS.amount_ge_amount_exec(

4331: );
4332:
4333: -- : Combined billed and del into exec
4334: WHEN c_dist_amt_ge_amt_exec THEN
4335: PO_VAL_DISTRIBUTIONS.amount_ge_amount_exec(
4336: p_dist_id_tbl => p_distributions.po_distribution_id
4337: , p_dist_type_tbl => p_distributions.distribution_type
4338: , p_amt_ordered_tbl => p_distributions.amount_ordered
4339: , x_result_set_id => l_result_set_id

Line 4345: PO_VAL_DISTRIBUTIONS.pjm_unit_number_effective(

4341: );
4342: --
4343:
4344: WHEN c_pjm_unit_number_effective THEN
4345: PO_VAL_DISTRIBUTIONS.pjm_unit_number_effective(
4346: p_dist_id_tbl => p_distributions.po_distribution_id
4347: , p_end_item_unit_number_tbl => p_distributions.end_item_unit_number
4348: , p_item_id_tbl => p_distributions.line_item_id
4349: , p_ship_to_org_id_tbl => p_distributions.ship_to_organization_id

Line 4357: PO_VAL_DISTRIBUTIONS.amount_to_encumber_ge_zero(

4353: , x_result_type => l_result_type
4354: );
4355:
4356: WHEN c_amount_to_encumber_ge_zero THEN
4357: PO_VAL_DISTRIBUTIONS.amount_to_encumber_ge_zero(
4358: p_dist_id_tbl => p_distributions.po_distribution_id
4359: , p_amount_to_encumber_tbl => p_distributions.amount_to_encumber
4360: , x_results => x_results
4361: , x_result_type => l_result_type

Line 4365: PO_VAL_DISTRIBUTIONS.budget_account_id_not_null(

4361: , x_result_type => l_result_type
4362: );
4363:
4364: WHEN c_budget_account_id_not_null THEN
4365: PO_VAL_DISTRIBUTIONS.budget_account_id_not_null(
4366: p_dist_id_tbl => p_distributions.po_distribution_id
4367: , p_budget_account_id_tbl => p_distributions.budget_account_id
4368: , x_results => x_results
4369: , x_result_type => l_result_type

Line 4373: PO_VAL_DISTRIBUTIONS.gl_encumbered_date_not_null(

4369: , x_result_type => l_result_type
4370: );
4371:
4372: WHEN c_gl_encumbered_date_not_null THEN
4373: PO_VAL_DISTRIBUTIONS.gl_encumbered_date_not_null(
4374: p_dist_id_tbl => p_distributions.po_distribution_id
4375: , p_gl_encumbered_date_tbl => p_distributions.gl_encumbered_date
4376: , x_results => x_results
4377: , x_result_type => l_result_type

Line 4381: PO_VAL_DISTRIBUTIONS.gl_enc_date_not_null_open(

4377: , x_result_type => l_result_type
4378: );
4379:
4380: WHEN c_gl_enc_date_not_null_open THEN
4381: PO_VAL_DISTRIBUTIONS.gl_enc_date_not_null_open(
4382: p_dist_id_tbl => p_distributions.po_distribution_id
4383: , p_org_id_tbl => p_distributions.org_id
4384: , p_gl_encumbered_date_tbl => p_distributions.gl_encumbered_date
4385: , x_results => x_results

Line 4390: PO_VAL_DISTRIBUTIONS.unencum_amt_le_amt_to_encum(

4386: , x_result_type => l_result_type
4387: );
4388:
4389: WHEN c_unencum_amt_le_amt_to_encum THEN
4390: PO_VAL_DISTRIBUTIONS.unencum_amt_le_amt_to_encum(
4391: p_dist_id_tbl => p_distributions.po_distribution_id
4392: , p_amount_to_encumber_tbl => p_distributions.amount_to_encumber
4393: , p_unencumbered_amount_tbl => p_distributions.unencumbered_amount
4394: , x_results => x_results

Line 4399: PO_VAL_DISTRIBUTIONS.oop_enter_all_fields(

4395: , x_result_type => l_result_type
4396: );
4397:
4398: WHEN c_oop_enter_all_fields THEN
4399: PO_VAL_DISTRIBUTIONS.oop_enter_all_fields(
4400: p_dist_id_tbl => p_distributions.po_distribution_id
4401: , p_line_line_type_id_tbl => p_distributions.line_line_type_id
4402: , p_wip_entity_id_tbl => p_distributions.wip_entity_id
4403: , p_wip_line_id_tbl => p_distributions.wip_line_id

Line 4412: PO_VAL_DISTRIBUTIONS.gms_data_valid(

4408: , x_result_type => l_result_type
4409: );
4410:
4411: WHEN c_gms_data_valid THEN
4412: PO_VAL_DISTRIBUTIONS.gms_data_valid(
4413: p_dist_id_tbl => p_distributions.po_distribution_id
4414: , p_project_id_tbl => p_distributions.project_id
4415: , p_task_id_tbl => p_distributions.task_id
4416: , p_award_number_tbl => p_distributions.award_number

Line 4425: PO_VAL_DISTRIBUTIONS.check_fv_validations(

4421: );
4422:
4423: -- ECO 4059111 : FV Validation
4424: WHEN c_check_fv_validations THEN
4425: PO_VAL_DISTRIBUTIONS.check_fv_validations(
4426: p_dist_id_tbl => p_distributions.po_distribution_id
4427: , p_ccid_tbl => p_distributions.code_combination_id
4428: , p_org_id_tbl => p_distributions.org_id
4429: , p_attribute1_tbl => p_distributions.attribute1

Line 4454: PO_VAL_DISTRIBUTIONS.check_proj_related_validations(

4450: -- Need to check for PJM Parameters before making Task as mandatory.
4451: -- For fetching the PJM paramters passing ship to org id.
4452:
4453: WHEN c_check_proj_rel_validations THEN
4454: PO_VAL_DISTRIBUTIONS.check_proj_related_validations(
4455: p_dist_id_tbl => p_distributions.po_distribution_id
4456: , p_dest_type_code_tbl => p_distributions.destination_type_code
4457: , p_project_id_tbl => p_distributions.project_id
4458: , p_task_id_tbl => p_distributions.task_id

Line 4498: PO_VAL_DISTRIBUTIONS2.amount_ordered(p_id_tbl => p_distributions.interface_id,

4494: -------------------------------------------------------------------------
4495: -- PDOI Distributions Validation Subroutines
4496: -------------------------------------------------------------------------
4497: WHEN c_dist_amount_ordered THEN
4498: PO_VAL_DISTRIBUTIONS2.amount_ordered(p_id_tbl => p_distributions.interface_id,
4499: p_amount_ordered_tbl => p_distributions.amount_ordered,
4500: p_order_type_code_tbl => p_distributions.line_order_type_lookup_code,
4501: x_results => x_results,
4502: x_result_type => l_result_type);

Line 4504: PO_VAL_DISTRIBUTIONS2.quantity_ordered(p_id_tbl => p_distributions.interface_id,

4500: p_order_type_code_tbl => p_distributions.line_order_type_lookup_code,
4501: x_results => x_results,
4502: x_result_type => l_result_type);
4503: WHEN c_dist_quantity_ordered THEN
4504: PO_VAL_DISTRIBUTIONS2.quantity_ordered(p_id_tbl => p_distributions.interface_id,
4505: p_quantity_ordered_tbl => p_distributions.quantity_ordered,
4506: p_order_type_code_tbl => p_distributions.line_order_type_lookup_code,
4507: x_results => x_results,
4508: x_result_type => l_result_type);

Line 4510: PO_VAL_DISTRIBUTIONS2.destination_org_id(p_id_tbl => p_distributions.interface_id,

4506: p_order_type_code_tbl => p_distributions.line_order_type_lookup_code,
4507: x_results => x_results,
4508: x_result_type => l_result_type);
4509: WHEN c_dist_destination_org_id THEN
4510: PO_VAL_DISTRIBUTIONS2.destination_org_id(p_id_tbl => p_distributions.interface_id,
4511: p_dest_org_id_tbl => p_distributions.destination_organization_id,
4512: p_ship_to_org_id_tbl => p_distributions.ship_to_organization_id,
4513: x_results => x_results,
4514: x_result_type => l_result_type);

Line 4516: PO_VAL_DISTRIBUTIONS2.deliver_to_location_id(p_id_tbl => p_distributions.interface_id,

4512: p_ship_to_org_id_tbl => p_distributions.ship_to_organization_id,
4513: x_results => x_results,
4514: x_result_type => l_result_type);
4515: WHEN c_dist_deliver_to_location_id THEN
4516: PO_VAL_DISTRIBUTIONS2.deliver_to_location_id(p_id_tbl => p_distributions.interface_id,
4517: p_deliver_to_location_id_tbl => p_distributions.deliver_to_location_id,
4518: p_ship_to_org_id_tbl => p_distributions.ship_to_organization_id,
4519: x_result_set_id => l_result_set_id,
4520: x_result_type => l_result_type);

Line 4522: PO_VAL_DISTRIBUTIONS2.deliver_to_person_id(p_id_tbl => p_distributions.interface_id,

4518: p_ship_to_org_id_tbl => p_distributions.ship_to_organization_id,
4519: x_result_set_id => l_result_set_id,
4520: x_result_type => l_result_type);
4521: WHEN c_dist_deliver_to_person_id THEN
4522: PO_VAL_DISTRIBUTIONS2.deliver_to_person_id(p_id_tbl => p_distributions.interface_id,
4523: p_deliver_to_person_id_tbl => p_distributions.deliver_to_person_id,
4524: x_result_set_id => l_result_set_id,
4525: x_result_type => l_result_type);
4526: WHEN c_dist_destination_type_code THEN

Line 4527: PO_VAL_DISTRIBUTIONS2.destination_type_code(p_id_tbl => p_distributions.interface_id,

4523: p_deliver_to_person_id_tbl => p_distributions.deliver_to_person_id,
4524: x_result_set_id => l_result_set_id,
4525: x_result_type => l_result_type);
4526: WHEN c_dist_destination_type_code THEN
4527: PO_VAL_DISTRIBUTIONS2.destination_type_code(p_id_tbl => p_distributions.interface_id,
4528: p_dest_type_code_tbl => p_distributions.destination_type_code,
4529: p_ship_to_org_id_tbl => p_distributions.ship_to_organization_id,
4530: p_item_id_tbl => p_distributions.line_item_id,
4531: p_txn_flow_header_id_tbl => p_distributions.transaction_flow_header_id,

Line 4541: PO_VAL_DISTRIBUTIONS2.destination_subinv(p_id_tbl => p_distributions.interface_id,

4537: x_result_set_id => l_result_set_id,
4538: x_results => x_results,
4539: x_result_type => l_result_type);
4540: WHEN c_dist_destination_subinv THEN
4541: PO_VAL_DISTRIBUTIONS2.destination_subinv(p_id_tbl => p_distributions.interface_id,
4542: p_destination_subinv_tbl => p_distributions.destination_subinventory,
4543: p_dest_type_code_tbl => p_distributions.destination_type_code,
4544: p_item_id_tbl => p_distributions.line_item_id,
4545: p_ship_to_org_id_tbl => p_distributions.ship_to_organization_id,

Line 4551: PO_VAL_DISTRIBUTIONS2.wip_entity_id(p_id_tbl => p_distributions.interface_id,

4547: x_result_set_id => l_result_set_id,
4548: x_results => x_results,
4549: x_result_type => l_result_type);
4550: WHEN c_dist_wip_entity_id THEN
4551: PO_VAL_DISTRIBUTIONS2.wip_entity_id(p_id_tbl => p_distributions.interface_id,
4552: p_wip_entity_id_tbl => p_distributions.wip_entity_id,
4553: p_wip_rep_schedule_id_tbl => p_distributions.wip_repetitive_schedule_id,
4554: p_dest_type_code_tbl => p_distributions.destination_type_code,
4555: p_destination_org_id_tbl => p_distributions.destination_organization_id,

Line 4560: PO_VAL_DISTRIBUTIONS2.prevent_encumbrance_flag(p_id_tbl => p_distributions.interface_id,

4556: x_result_set_id => l_result_set_id,
4557: x_results => x_results,
4558: x_result_type => l_result_type);
4559: WHEN c_prevent_encumberance_flag THEN
4560: PO_VAL_DISTRIBUTIONS2.prevent_encumbrance_flag(p_id_tbl => p_distributions.interface_id,
4561: p_prevent_encum_flag_tbl => p_distributions.prevent_encumbrance_flag,
4562: p_dest_type_code_tbl => p_distributions.destination_type_code,
4563: x_results => x_results,
4564: x_result_type => l_result_type);

Line 4566: PO_VAL_DISTRIBUTIONS2.charge_account_id(p_id_tbl => p_distributions.interface_id,

4562: p_dest_type_code_tbl => p_distributions.destination_type_code,
4563: x_results => x_results,
4564: x_result_type => l_result_type);
4565: WHEN c_charge_account_id THEN
4566: PO_VAL_DISTRIBUTIONS2.charge_account_id(p_id_tbl => p_distributions.interface_id,
4567: p_charge_account_id_tbl => p_distributions.code_combination_id,
4568: p_gl_date_tbl => p_distributions.gl_encumbered_date,
4569: p_chart_of_account_id => l_chart_of_account_id,
4570: x_result_set_id => l_result_set_id,

Line 4573: PO_VAL_DISTRIBUTIONS2.budget_account_id(p_id_tbl => p_distributions.interface_id,

4569: p_chart_of_account_id => l_chart_of_account_id,
4570: x_result_set_id => l_result_set_id,
4571: x_result_type => l_result_type);
4572: WHEN c_budget_account_id THEN
4573: PO_VAL_DISTRIBUTIONS2.budget_account_id(p_id_tbl => p_distributions.interface_id,
4574: p_budget_account_id_tbl => p_distributions.budget_account_id,
4575: p_gl_date_tbl => p_distributions.gl_encumbered_date,
4576: p_dest_type_code_tbl => p_distributions.destination_type_code,
4577: p_chart_of_account_id => l_chart_of_account_id,

Line 4582: PO_VAL_DISTRIBUTIONS2.account_id(p_id_tbl => p_distributions.interface_id,

4578: p_po_encumberance_flag => l_po_encumbrance_flag,
4579: x_result_set_id => l_result_set_id,
4580: x_result_type => l_result_type);
4581: WHEN c_accrual_account_id THEN
4582: PO_VAL_DISTRIBUTIONS2.account_id(p_id_tbl => p_distributions.interface_id,
4583: p_account_id_tbl => p_distributions.accrual_account_id,
4584: p_gl_date_tbl => p_distributions.gl_encumbered_date,
4585: p_chart_of_account_id => l_chart_of_account_id,
4586: p_message_name => 'PO_PDOI_INVALID_ACCRUAL_ACCT',

Line 4592: PO_VAL_DISTRIBUTIONS2.account_id(p_id_tbl => p_distributions.interface_id,

4588: p_token_name => 'ACCRUAL_ACCOUNT',
4589: x_result_set_id => l_result_set_id,
4590: x_result_type => l_result_type);
4591: WHEN c_variance_account_id THEN
4592: PO_VAL_DISTRIBUTIONS2.account_id(p_id_tbl => p_distributions.interface_id,
4593: p_account_id_tbl => p_distributions.variance_account_id,
4594: p_gl_date_tbl => p_distributions.gl_encumbered_date,
4595: p_chart_of_account_id => l_chart_of_account_id,
4596: p_message_name => 'PO_PDOI_INVALID_VAR_ACCT',

Line 4602: PO_VAL_DISTRIBUTIONS2.project_acct_context(p_id_tbl => p_distributions.interface_id,

4598: p_token_name => 'VARIANCE_ACCOUNT',
4599: x_result_set_id => l_result_set_id,
4600: x_result_type => l_result_type);
4601: WHEN c_project_acct_context THEN
4602: PO_VAL_DISTRIBUTIONS2.project_acct_context(p_id_tbl => p_distributions.interface_id,
4603: p_project_acct_ctx_tbl => p_distributions.project_accounting_context,
4604: p_project_id_tbl => p_distributions.project_id,
4605: p_task_id_tbl => p_distributions.task_id,
4606: p_exp_type_tbl => p_distributions.expenditure_type,

Line 4611: PO_VAL_DISTRIBUTIONS2.project_info(p_id_tbl => p_distributions.interface_id,

4607: p_exp_org_id_tbl => p_distributions.expenditure_organization_id,
4608: x_results => x_results,
4609: x_result_type => l_result_type);
4610: WHEN c_project_info THEN
4611: PO_VAL_DISTRIBUTIONS2.project_info(p_id_tbl => p_distributions.interface_id,
4612: p_project_acct_ctx_tbl => p_distributions.project_accounting_context,
4613: p_dest_type_code_tbl => p_distributions.destination_type_code,
4614: p_project_id_tbl => p_distributions.project_id,
4615: p_task_id_tbl => p_distributions.task_id,

Line 4630: PO_VAL_DISTRIBUTIONS2.tax_recovery_override_flag(p_id_tbl => p_distributions.interface_id,

4626: x_results => x_results,
4627: x_result_type => l_result_type);
4628:
4629: WHEN c_tax_recovery_override_flag THEN
4630: PO_VAL_DISTRIBUTIONS2.tax_recovery_override_flag(p_id_tbl => p_distributions.interface_id,
4631: p_recovery_override_flag_tbl => p_distributions.tax_recovery_override_flag,
4632: p_allow_tax_rate_override => l_allow_tax_rate_override,
4633: x_results => x_results,
4634: x_result_type => l_result_type);