APPS.PA_ASSET_ALLOCATION_PVT dependencies on STANDARD

Line 158: standard_cost_not_found EXCEPTION;

154: null_total_basis EXCEPTION;
155: negative_total_basis EXCEPTION;
156: inconsistent_total_basis EXCEPTION;
157: asset_basis_sum_error EXCEPTION;
158: standard_cost_not_found EXCEPTION;
159: error_calling_update_cost EXCEPTION;
160:
161: BEGIN
162:

Line 722: --If the Asset Allocation Method is 'SC' for Standard Cost,

718: END LOOP;
719: END IF; -- 'EC' allocation method
720:
721:
722: --If the Asset Allocation Method is 'SC' for Standard Cost,
723: --then use each asset's Standard Cost * Actual Units as the basis amount
724: IF p_asset_allocation_method = 'SC' THEN
725:
726: --Determine the Total Basis Amount

Line 723: --then use each asset's Standard Cost * Actual Units as the basis amount

719: END IF; -- 'EC' allocation method
720:
721:
722: --If the Asset Allocation Method is 'SC' for Standard Cost,
723: --then use each asset's Standard Cost * Actual Units as the basis amount
724: IF p_asset_allocation_method = 'SC' THEN
725:
726: --Determine the Total Basis Amount
727: i := asset_basis_table.FIRST;

Line 733: --For Standard Cost method, Asset Basis Amount = Standard Cost * Actual Units

729: WHILE i IS NOT NULL LOOP
730:
731: v_project_asset_id := asset_basis_table(i).PROJECT_ASSET_ID;
732:
733: --For Standard Cost method, Asset Basis Amount = Standard Cost * Actual Units
734: v_asset_basis_amount := 0;
735:
736: SELECT NVL(asset_units,0),
737: NVL(asset_category_id,-99),

Line 747: FROM pa_standard_unit_costs

743: WHERE project_asset_id = asset_basis_table(i).PROJECT_ASSET_ID;
744:
745: SELECT COUNT(*)
746: INTO v_std_cost_count
747: FROM pa_standard_unit_costs
748: WHERE asset_category_id = v_asset_category_id
749: AND book_type_code = v_book_type_code;
750:
751: IF v_std_cost_count = 0 THEN

Line 752: RAISE standard_cost_not_found;

748: WHERE asset_category_id = v_asset_category_id
749: AND book_type_code = v_book_type_code;
750:
751: IF v_std_cost_count = 0 THEN
752: RAISE standard_cost_not_found;
753: ELSE
754: SELECT standard_unit_cost
755: INTO v_std_unit_cost
756: FROM pa_standard_unit_costs

Line 754: SELECT standard_unit_cost

750:
751: IF v_std_cost_count = 0 THEN
752: RAISE standard_cost_not_found;
753: ELSE
754: SELECT standard_unit_cost
755: INTO v_std_unit_cost
756: FROM pa_standard_unit_costs
757: WHERE asset_category_id = v_asset_category_id
758: AND book_type_code = v_book_type_code;

Line 756: FROM pa_standard_unit_costs

752: RAISE standard_cost_not_found;
753: ELSE
754: SELECT standard_unit_cost
755: INTO v_std_unit_cost
756: FROM pa_standard_unit_costs
757: WHERE asset_category_id = v_asset_category_id
758: AND book_type_code = v_book_type_code;
759: END IF;
760:

Line 1278: WHEN standard_cost_not_found THEN

1274: p_error_text => SUBSTRB(x_msg_data,1,240));
1275: RETURN;
1276:
1277:
1278: WHEN standard_cost_not_found THEN
1279: x_msg_data := 'Standard Cost not found for project asset id '||v_project_asset_id;
1280: x_asset_or_project_err := 'A';
1281: x_err_asset_id := v_project_asset_id;
1282: x_error_code := 'STANDARD_COST_MISSING';

Line 1279: x_msg_data := 'Standard Cost not found for project asset id '||v_project_asset_id;

1275: RETURN;
1276:
1277:
1278: WHEN standard_cost_not_found THEN
1279: x_msg_data := 'Standard Cost not found for project asset id '||v_project_asset_id;
1280: x_asset_or_project_err := 'A';
1281: x_err_asset_id := v_project_asset_id;
1282: x_error_code := 'STANDARD_COST_MISSING';
1283: x_return_status := 'E';

Line 1282: x_error_code := 'STANDARD_COST_MISSING';

1278: WHEN standard_cost_not_found THEN
1279: x_msg_data := 'Standard Cost not found for project asset id '||v_project_asset_id;
1280: x_asset_or_project_err := 'A';
1281: x_err_asset_id := v_project_asset_id;
1282: x_error_code := 'STANDARD_COST_MISSING';
1283: x_return_status := 'E';
1284: x_msg_count := x_msg_count + 1;
1285: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1286: p_procedure_name => 'ALLOCATE_UNASSIGNED',