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 1512: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

1508: -- Bug 3836358 -- ADDED for usage when p_skip_duplicates_flag is passed as Y
1509: l_task_id_temp PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;
1510: l_pji_rollup_required VARCHAR2(1);
1511:
1512: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
1513: l_rm_temp_count number;
1514:
1515:
1516: CURSOR get_pc_code IS

Line 5156: pa_fp_gen_amount_utils.get_plan_version_dtls

5152:
5153: /* Commented for bug 7161809
5154: -- hr_utility.trace('p_project_id IS : ' || p_project_id);
5155: -- hr_utility.trace('l_budget_version_id IS : ' || l_budget_version_id);
5156: pa_fp_gen_amount_utils.get_plan_version_dtls
5157: (p_project_id => p_project_id,
5158: p_budget_version_id => l_budget_version_id,
5159: x_fp_cols_rec => l_fp_cols_rec,
5160: x_return_status => x_return_status,

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

5167:
5168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5169:
5170: IF l_debug_mode = 'Y' THEN
5171: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
5172: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5173: END IF;
5174: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5175: END IF;

Line 5592: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

5588: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
5589: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
5590: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;
5591:
5592: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
5593:
5594: BEGIN
5595:
5596: l_trace_stage := 10;

Line 7313: pa_fp_gen_amount_utils.get_plan_version_dtls

7309: -- IPM changes - rollup amounts in new entity
7310:
7311: -- Call the UTIL API to get the financial plan info l_fp_cols_rec
7312:
7313: pa_fp_gen_amount_utils.get_plan_version_dtls
7314: (p_project_id => l_project_id,
7315: p_budget_version_id => l_budget_version_id,
7316: x_fp_cols_rec => l_fp_cols_rec,
7317: x_return_status => x_return_status,

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

7320:
7321: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7322:
7323: IF l_debug_mode = 'Y' THEN
7324: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
7325: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
7326: END IF;
7327: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7328: END IF;

Line 7567: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

7563: l_pc pa_projects_all.project_currency_code%type;
7564: l_pfc pa_projects_all.projfunc_currency_code%type;
7565: --Code addition for bug#4200168 ends here.
7566:
7567: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
7568: l_resource_class_code VARCHAR2(30);
7569: l_exp_type VARCHAR2(30);
7570: l_inv_item_id NUMBER;
7571: l_res_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:=SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 7878: pa_fp_gen_amount_utils.get_plan_version_dtls

7874: -- IPM changes - rollup amounts in new entity
7875: -- Call the UTIL API to get the financial plan info l_fp_cols_rec
7876: -- Bug 5070740 - moved this to rollup into entity BEFORE calling calculate
7877:
7878: pa_fp_gen_amount_utils.get_plan_version_dtls
7879: (p_project_id => p_target_project_id,
7880: p_budget_version_id => l_targ_budget_version_id,
7881: x_fp_cols_rec => l_fp_cols_rec,
7882: x_return_status => x_return_status,

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

7885:
7886: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7887:
7888: IF l_debug_mode = 'Y' THEN
7889: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
7890: print_msg(pa_debug.g_err_stage,l_module_name);
7891: END IF;
7892: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7893: END IF;

Line 8591: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

8587:
8588:
8589: l_project_id pa_projects_all.project_id%TYPE; --Bug 4218331
8590: l_project_currency_code VARCHAR2(30);
8591: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
8592:
8593: BEGIN
8594:
8595: delete pa_resource_asgn_curr_tmp;

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

9636: -- if records have been inserted in pa_Resource_asgn_curr_tmp, in the delete flow.
9637: -- Note: Deriving l_budget_version_id may not be the right approach as we avoid calling BV/RA
9638: -- rollup api and pji api when l_budget_version_id is null (No BLs deleted)
9639: IF l_budget_version_id IS NOT NULL THEN
9640: pa_debug.g_err_stage:='Calling pa_fp_gen_amount_utils.get_plan_version_dtls:bv_id ' || l_budget_version_id;
9641: print_msg(pa_debug.g_err_stage,l_module_name);
9642:
9643: pa_fp_gen_amount_utils.get_plan_version_dtls
9644: (p_project_id => l_project_id,

Line 9643: pa_fp_gen_amount_utils.get_plan_version_dtls

9639: IF l_budget_version_id IS NOT NULL THEN
9640: pa_debug.g_err_stage:='Calling pa_fp_gen_amount_utils.get_plan_version_dtls:bv_id ' || l_budget_version_id;
9641: print_msg(pa_debug.g_err_stage,l_module_name);
9642:
9643: pa_fp_gen_amount_utils.get_plan_version_dtls
9644: (p_project_id => l_project_id,
9645: p_budget_version_id => l_budget_version_id,
9646: x_fp_cols_rec => l_fp_cols_rec,
9647: x_return_status => x_return_status,

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

9650:
9651: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9652:
9653: IF l_debug_mode = 'Y' THEN
9654: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
9655: print_msg(pa_debug.g_err_stage,l_module_name);
9656: END IF;
9657: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
9658: END IF;

Line 10739: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols;

10735:
10736: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10737:
10738: -- IPM changes Bug 5003827 Issue 22
10739: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols;
10740: l_delete_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10741: l_delete_flag VARCHAR2(1); -- Bug 5003827 Issue 28
10742: l_rollup_flag VARCHAR2(1); -- Bug 5003827 Issue 28
10743: -- END of IPM changes Bug 5003827 Issue 22

Line 10845: pa_fp_gen_amount_utils.get_plan_version_dtls

10841: -- --IPM Arch Enhancement Bug 4865563, Bug 5003827 Issue 28
10842: IF (nvl(p_ci_ver_agr_change_flag,'N') = 'Y'
10843: OR nvl(p_time_phase_change_flag, 'N') = 'Y') THEN
10844:
10845: pa_fp_gen_amount_utils.get_plan_version_dtls
10846: (p_budget_version_id => p_budget_version_id,
10847: x_fp_cols_rec => l_fp_cols_rec,
10848: x_return_status => x_return_status,
10849: x_msg_count => x_msg_count,

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

10851:
10852: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10853:
10854: IF l_debug_mode = 'Y' THEN
10855: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
10856: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
10857: END IF;
10858: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10859: END IF;

Line 10931: pa_fp_gen_amount_utils.get_plan_version_dtls

10927: -- END of IPM changes Bug 5003827 Issue 22
10928: */
10929: ----IPM Arch Enhancement Bug 5754758/4865563
10930: IF l_delete_ra_id_tbl.COUNT > 0 THEN --{
10931: pa_fp_gen_amount_utils.get_plan_version_dtls
10932: (p_budget_version_id => p_budget_version_id,
10933: x_fp_cols_rec => l_fp_cols_rec,
10934: x_return_status => x_return_status,
10935: x_msg_count => x_msg_count,

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

10937:
10938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10939:
10940: IF l_debug_mode = 'Y' THEN
10941: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
10942: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
10943: END IF;
10944: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10945: END IF;

Line 11090: pa_fp_gen_amount_utils.get_plan_version_dtls

11086: END IF;
11087:
11088: -- IPM changes Bug 5003827 Issue 22
11089: IF l_delete_ra_id_tbl.COUNT > 0 THEN --{
11090: pa_fp_gen_amount_utils.get_plan_version_dtls
11091: (p_project_id => budget_version_info_rec.project_id,
11092: p_budget_version_id => p_budget_version_id,
11093: x_fp_cols_rec => l_fp_cols_rec,
11094: x_return_status => x_return_status,

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

11097:
11098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11099:
11100: IF l_debug_mode = 'Y' THEN
11101: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11102: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11103: END IF;
11104: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11105: END IF;