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.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 1575: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

1571: -- Bug 3836358 -- ADDED for usage when p_skip_duplicates_flag is passed as Y
1572: l_task_id_temp PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;
1573: l_pji_rollup_required VARCHAR2(1);
1574:
1575: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
1576: l_rm_temp_count number;
1577:
1578: -- Bug 8370812
1579: l_ra_id_rollup_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 5809: pa_fp_gen_amount_utils.get_plan_version_dtls

5805:
5806: /* Commented for bug 7161809
5807: -- hr_utility.trace('p_project_id IS : ' || p_project_id);
5808: -- hr_utility.trace('l_budget_version_id IS : ' || l_budget_version_id);
5809: pa_fp_gen_amount_utils.get_plan_version_dtls
5810: (p_project_id => p_project_id,
5811: p_budget_version_id => l_budget_version_id,
5812: x_fp_cols_rec => l_fp_cols_rec,
5813: x_return_status => x_return_status,

Line 5824: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';

5820:
5821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5822:
5823: IF l_debug_mode = 'Y' THEN
5824: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
5825: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5826: END IF;
5827: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5828: END IF;

Line 6250: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

6246: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
6247: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
6248: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;
6249:
6250: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
6251:
6252: -- Bug 5906826
6253: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6254: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 8125: pa_fp_gen_amount_utils.get_plan_version_dtls

8121: WHERE resource_assignment_id= l_resource_assignment_id_tbl(i);
8122: END IF;
8123: END IF;
8124: --CBS Changes End here
8125: pa_fp_gen_amount_utils.get_plan_version_dtls
8126: (p_project_id => l_project_id,
8127: p_budget_version_id => l_budget_version_id,
8128: x_fp_cols_rec => l_fp_cols_rec,
8129: x_return_status => x_return_status,

Line 8136: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';

8132:
8133: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8134:
8135: IF l_debug_mode = 'Y' THEN
8136: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
8137: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
8138: END IF;
8139: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8140: END IF;

Line 8393: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

8389: l_pc pa_projects_all.project_currency_code%type;
8390: l_pfc pa_projects_all.projfunc_currency_code%type;
8391: --Code addition for bug#4200168 ends here.
8392:
8393: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
8394: l_resource_class_code VARCHAR2(30);
8395: l_exp_type VARCHAR2(30);
8396: l_inv_item_id NUMBER;
8397: l_res_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:=SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 8704: pa_fp_gen_amount_utils.get_plan_version_dtls

8700: -- IPM changes - rollup amounts in new entity
8701: -- Call the UTIL API to get the financial plan info l_fp_cols_rec
8702: -- Bug 5070740 - moved this to rollup into entity BEFORE calling calculate
8703:
8704: pa_fp_gen_amount_utils.get_plan_version_dtls
8705: (p_project_id => p_target_project_id,
8706: p_budget_version_id => l_targ_budget_version_id,
8707: x_fp_cols_rec => l_fp_cols_rec,
8708: x_return_status => x_return_status,

Line 8715: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';

8711:
8712: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8713:
8714: IF l_debug_mode = 'Y' THEN
8715: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
8716: print_msg(pa_debug.g_err_stage,l_module_name);
8717: END IF;
8718: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8719: END IF;

Line 9417: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

9413:
9414:
9415: l_project_id pa_projects_all.project_id%TYPE; --Bug 4218331
9416: l_project_currency_code VARCHAR2(30);
9417: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
9418:
9419: l_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ; --bug#16688443
9420:
9421: BEGIN

Line 10502: pa_debug.g_err_stage:='Calling pa_fp_gen_amount_utils.get_plan_version_dtls:bv_id ' || l_budget_version_id;

10498: -- if records have been inserted in pa_Resource_asgn_curr_tmp, in the delete flow.
10499: -- Note: Deriving l_budget_version_id may not be the right approach as we avoid calling BV/RA
10500: -- rollup api and pji api when l_budget_version_id is null (No BLs deleted)
10501: IF l_budget_version_id IS NOT NULL THEN
10502: pa_debug.g_err_stage:='Calling pa_fp_gen_amount_utils.get_plan_version_dtls:bv_id ' || l_budget_version_id;
10503: print_msg(pa_debug.g_err_stage,l_module_name);
10504:
10505: pa_fp_gen_amount_utils.get_plan_version_dtls
10506: (p_project_id => l_project_id,

Line 10505: pa_fp_gen_amount_utils.get_plan_version_dtls

10501: IF l_budget_version_id IS NOT NULL THEN
10502: pa_debug.g_err_stage:='Calling pa_fp_gen_amount_utils.get_plan_version_dtls:bv_id ' || l_budget_version_id;
10503: print_msg(pa_debug.g_err_stage,l_module_name);
10504:
10505: pa_fp_gen_amount_utils.get_plan_version_dtls
10506: (p_project_id => l_project_id,
10507: p_budget_version_id => l_budget_version_id,
10508: x_fp_cols_rec => l_fp_cols_rec,
10509: x_return_status => x_return_status,

Line 10516: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';

10512:
10513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10514:
10515: IF l_debug_mode = 'Y' THEN
10516: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
10517: print_msg(pa_debug.g_err_stage,l_module_name);
10518: END IF;
10519: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10520: END IF;

Line 11605: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols;

11601:
11602: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11603:
11604: -- IPM changes Bug 5003827 Issue 22
11605: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols;
11606: l_delete_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11607: l_delete_flag VARCHAR2(1); -- Bug 5003827 Issue 28
11608: l_rollup_flag VARCHAR2(1); -- Bug 5003827 Issue 28
11609: -- END of IPM changes Bug 5003827 Issue 22

Line 11712: pa_fp_gen_amount_utils.get_plan_version_dtls

11708: -- --IPM Arch Enhancement Bug 4865563, Bug 5003827 Issue 28
11709: IF (nvl(p_ci_ver_agr_change_flag,'N') = 'Y'
11710: OR nvl(p_time_phase_change_flag, 'N') = 'Y') THEN
11711:
11712: pa_fp_gen_amount_utils.get_plan_version_dtls
11713: (p_budget_version_id => p_budget_version_id,
11714: x_fp_cols_rec => l_fp_cols_rec,
11715: x_return_status => x_return_status,
11716: x_msg_count => x_msg_count,

Line 11722: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';

11718:
11719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11720:
11721: IF l_debug_mode = 'Y' THEN
11722: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11723: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11724: END IF;
11725: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11726: END IF;

Line 11798: pa_fp_gen_amount_utils.get_plan_version_dtls

11794: -- END of IPM changes Bug 5003827 Issue 22
11795: */
11796: ----IPM Arch Enhancement Bug 5754758/4865563
11797: IF l_delete_ra_id_tbl.COUNT > 0 THEN --{
11798: pa_fp_gen_amount_utils.get_plan_version_dtls
11799: (p_budget_version_id => p_budget_version_id,
11800: x_fp_cols_rec => l_fp_cols_rec,
11801: x_return_status => x_return_status,
11802: x_msg_count => x_msg_count,

Line 11808: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';

11804:
11805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11806:
11807: IF l_debug_mode = 'Y' THEN
11808: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11809: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11810: END IF;
11811: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11812: END IF;

Line 11898: l_res_class_flag := PA_FP_GEN_AMOUNT_UTILS.get_src_resource_class_flag(p_budget_version_id);

11894: -- Delete all the planning resources where neither rlmID is 0
11895: -- Or resource is 'FINANCIAL_ELEMENTS'
11896: -- Bug 3658232 added null handling for resource class flag
11897: --Bug 13701718 CBS related Chnages start here
11898: l_res_class_flag := PA_FP_GEN_AMOUNT_UTILS.get_src_resource_class_flag(p_budget_version_id);
11899: IF nvl(l_res_class_flag,'Y') = 'N' THEN
11900: DELETE FROM pa_resource_assignments
11901: WHERE budget_version_id = p_budget_version_id
11902: RETURNING resource_assignment_id BULK COLLECT INTO l_delete_ra_id_tbl;

Line 11964: pa_fp_gen_amount_utils.get_plan_version_dtls

11960: END IF;
11961:
11962: -- IPM changes Bug 5003827 Issue 22
11963: IF l_delete_ra_id_tbl.COUNT > 0 THEN --{
11964: pa_fp_gen_amount_utils.get_plan_version_dtls
11965: (p_project_id => budget_version_info_rec.project_id,
11966: p_budget_version_id => p_budget_version_id,
11967: x_fp_cols_rec => l_fp_cols_rec,
11968: x_return_status => x_return_status,

Line 11975: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';

11971:
11972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11973:
11974: IF l_debug_mode = 'Y' THEN
11975: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11976: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11977: END IF;
11978: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11979: END IF;