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_REV_GEN_PUB dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 8: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: PROCEDURE GEN_COST_BASED_REVENUE
7: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
9: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
10: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
11: X_MSG_COUNT OUT NOCOPY NUMBER,
12: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 168: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

164: WHERE bv.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
165: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;
166:
167: IF p_pa_debug_mode = 'Y' THEN
168: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
169: ( p_msg => 'Value of l_plan_class_code: '||l_plan_class_code,
170: p_module_name => l_module_name,
171: p_log_level => 5 );
172: END IF;

Line 266: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

262: END IF;
263:
264: -- Call the maintenance api in INSERT mode
265: IF p_pa_debug_mode = 'Y' THEN
266: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
267: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
268: 'MAINTAIN_DATA',
269: --P_CALLED_MODE => p_called_mode,
270: P_MODULE_NAME => l_module_name);

Line 282: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

278: X_RETURN_STATUS => x_return_status,
279: X_MSG_COUNT => x_msg_count,
280: X_MSG_DATA => x_msg_data );
281: IF p_pa_debug_mode = 'Y' THEN
282: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
283: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
284: 'MAINTAIN_DATA: '||x_return_status,
285: --P_CALLED_MODE => p_called_mode,
286: P_MODULE_NAME => l_module_name);

Line 321: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

317: l_pc_project_value := null;
318: END;
319: ELSE
320: IF P_PA_DEBUG_MODE = 'Y' THEN
321: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
322: ( P_MSG => 'Before calling PA_FIN_PLAN_UTILS.'||
323: 'Get_Appr_Rev_Plan_Type_Info',
324: P_MODULE_NAME => l_module_name,
325: P_LOG_LEVEL => 5 );

Line 334: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

330: x_return_status => x_return_status,
331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data );
333: IF P_PA_DEBUG_MODE = 'Y' THEN
334: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
335: ( P_MSG => 'After calling PA_FIN_PLAN_UTILS.'||
336: 'Get_Appr_Rev_Plan_Type_Info: '||x_return_status,
337: P_MODULE_NAME => l_module_name,
338: P_LOG_LEVEL => 5 );

Line 368: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

364: AND fin_plan_option_level_code = 'PLAN_TYPE'
365: AND project_id = P_FP_COLS_REC.X_PROJECT_ID;
366:
367: IF P_PA_DEBUG_MODE = 'Y' THEN
368: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
369: ( P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
370: 'Get_Curr_Original_Version_Info',
371: P_MODULE_NAME => l_module_name,
372: P_LOG_LEVEL => 5 );

Line 369: ( P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||

365: AND project_id = P_FP_COLS_REC.X_PROJECT_ID;
366:
367: IF P_PA_DEBUG_MODE = 'Y' THEN
368: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
369: ( P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
370: 'Get_Curr_Original_Version_Info',
371: P_MODULE_NAME => l_module_name,
372: P_LOG_LEVEL => 5 );
373: END IF;

Line 374: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info

370: 'Get_Curr_Original_Version_Info',
371: P_MODULE_NAME => l_module_name,
372: P_LOG_LEVEL => 5 );
373: END IF;
374: PA_FP_GEN_AMOUNT_UTILS.Get_Curr_Original_Version_Info
375: ( p_project_id => P_FP_COLS_REC.X_PROJECT_ID,
376: p_fin_plan_type_id => l_fin_plan_type_id,
377: p_version_type => l_version_type,
378: p_status_code => 'CURRENT_APPROVED',

Line 385: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

381: x_return_status => x_return_status,
382: x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data );
384: IF P_PA_DEBUG_MODE = 'Y' THEN
385: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
386: ( P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
387: 'Get_Curr_Original_Version_Info: '||x_return_status,
388: P_MODULE_NAME => l_module_name,
389: P_LOG_LEVEL => 5 );

Line 386: ( P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||

382: x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data );
384: IF P_PA_DEBUG_MODE = 'Y' THEN
385: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
386: ( P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
387: 'Get_Curr_Original_Version_Info: '||x_return_status,
388: P_MODULE_NAME => l_module_name,
389: P_LOG_LEVEL => 5 );
390: END IF;

Line 431: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

427: END IF;
428:
429: IF P_FP_COLS_REC.X_GEN_INCL_BILL_EVENT_FLAG = 'Y' THEN
430: IF P_PA_DEBUG_MODE = 'Y' THEN
431: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
432: ( P_MSG => 'Before calling PA_FP_GEN_BILLING_AMOUNTS.'
433: ||'GET_BILLING_EVENT_AMT_IN_PFC',
434: P_MODULE_NAME => l_module_name,
435: P_LOG_LEVEL => 5 );

Line 453: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

449: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
450: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
451: END IF;
452: IF P_PA_DEBUG_MODE = 'Y' THEN
453: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
454: ( P_MSG => 'After calling PA_FP_GEN_BILLING_AMOUNTS.'
455: ||'GET_BILLING_EVENT_AMT_IN_PFC',
456: P_MODULE_NAME => l_module_name,
457: P_LOG_LEVEL => 5);

Line 466: pa_fp_gen_amount_utils.fp_debug

462: l_pfc_project_value := l_pfc_project_value - NVL(l_bill_amt_pfc_revenue,0);
463: l_pc_project_value := l_pc_project_value - NVL(l_bill_amt_pc_revenue,0);
464:
465: IF p_pa_debug_mode = 'Y' THEN
466: pa_fp_gen_amount_utils.fp_debug
467: ( p_msg => 'Value of l_pfc_project_value: '
468: || l_pfc_project_value,
469: p_module_name => l_module_name,
470: p_log_level => 5 );

Line 471: pa_fp_gen_amount_utils.fp_debug

467: ( p_msg => 'Value of l_pfc_project_value: '
468: || l_pfc_project_value,
469: p_module_name => l_module_name,
470: p_log_level => 5 );
471: pa_fp_gen_amount_utils.fp_debug
472: ( p_msg => 'Value of l_pc_project_value: '
473: || l_pc_project_value,
474: p_module_name => l_module_name,
475: p_log_level => 5 );

Line 506: pa_fp_gen_amount_utils.fp_debug

502: WHERE budget_version_id = p_budget_version_id;
503: END IF;
504:
505: IF p_pa_debug_mode = 'Y' THEN
506: pa_fp_gen_amount_utils.fp_debug
507: ( p_msg => 'Value of l_init_rev_sum when the '
508: || 'plan_class_code is FORECAST:'
509: || l_init_rev_sum,
510: p_module_name => l_module_name,

Line 520: pa_fp_gen_amount_utils.fp_debug

516: l_pfc_project_value := l_pfc_project_value - l_init_rev_sum;
517: l_pc_project_value := l_pc_project_value - l_pc_init_rev_sum;
518:
519: IF p_pa_debug_mode = 'Y' THEN
520: pa_fp_gen_amount_utils.fp_debug
521: ( p_msg => 'Value of l_pfc_project_value when the '
522: || 'plan_class_code is FORECAST: '
523: || l_pfc_project_value,
524: p_module_name => l_module_name,

Line 526: pa_fp_gen_amount_utils.fp_debug

522: || 'plan_class_code is FORECAST: '
523: || l_pfc_project_value,
524: p_module_name => l_module_name,
525: p_log_level => 5 );
526: pa_fp_gen_amount_utils.fp_debug
527: ( p_msg => 'Value of l_pc_project_value when the '
528: || 'plan_class_code is FORECAST: '
529: || l_pc_project_value,
530: p_module_name => l_module_name,

Line 554: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

550: -- Insert/Update data from the temp table to the budget lines.
551:
552: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
553: IF P_PA_DEBUG_MODE = 'Y' THEN
554: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
555: ( P_MSG => 'Before calling PA_FP_REV_GEN_PUB.'
556: ||'PUSH_RES_SCH_DATA_TO_BL',
557: P_MODULE_NAME => l_module_name,
558: P_LOG_LEVEL => 5 );

Line 572: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

568: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
569: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
570: END IF;
571: IF P_PA_DEBUG_MODE = 'Y' THEN
572: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
573: ( P_MSG => 'After calling PA_FP_REV_GEN_PUB.'
574: ||'PUSH_RES_SCH_DATA_TO_BL',
575: P_MODULE_NAME => l_module_name,
576: P_LOG_LEVEL => 5);

Line 658: pa_fp_gen_amount_utils.fp_debug

654: AND bl.BILLABLE_FLAG = 'Y'
655: ORDER BY bl.resource_assignment_id,
656: bl.start_date;
657: IF p_pa_debug_mode = 'Y' THEN
658: pa_fp_gen_amount_utils.fp_debug
659: ( p_msg => 'Count of l_budget_line_id_tab when the '
660: || 'plan_class_code is BUDGET: '
661: || l_budget_line_id_tab.count,
662: p_module_name => l_module_name,

Line 715: pa_fp_gen_amount_utils.fp_debug

711: ORDER BY bl.resource_assignment_id,
712: bl.start_date;
713:
714: IF p_pa_debug_mode = 'Y' THEN
715: pa_fp_gen_amount_utils.fp_debug
716: ( p_msg => 'Count of l_budget_line_id_tab when the '
717: || 'plan_class_code is FORECAST: '
718: || l_budget_line_id_tab.count,
719: p_module_name => l_module_name,

Line 739: pa_fp_gen_amount_utils.fp_debug

735: AND bl.pfc_cur_conv_rejection_code is null
736: AND bl.BILLABLE_FLAG = 'Y';
737:
738: IF p_pa_debug_mode = 'Y' THEN
739: pa_fp_gen_amount_utils.fp_debug
740: ( p_msg => 'Value of l_pfc_burdened_cost when the '
741: || 'plan_class_code is FORECAST: '
742: || l_pfc_burdened_cost,
743: p_module_name => l_module_name,

Line 858: pa_fp_gen_amount_utils.fp_debug

854: AND ra.project_id = P_FP_COLS_REC.X_PROJECT_ID /* Added for Bug 4546405 */
855: ORDER BY bl.resource_assignment_id,
856: bl.start_date;
857: IF p_pa_debug_mode = 'Y' THEN
858: pa_fp_gen_amount_utils.fp_debug
859: ( p_msg => 'Count of l_budget_line_id_tab when the '
860: || 'plan_class_code is BUDGET: '
861: || l_budget_line_id_tab.count,
862: p_module_name => l_module_name,

Line 982: pa_fp_gen_amount_utils.fp_debug

978: bl.start_date;
979: END IF; -- timephased check
980:
981: IF p_pa_debug_mode = 'Y' THEN
982: pa_fp_gen_amount_utils.fp_debug
983: ( p_msg => 'Count of l_budget_line_id_tab when the '
984: || 'plan_class_code is FORECAST: '
985: || l_budget_line_id_tab.count,
986: p_module_name => l_module_name,

Line 1059: pa_fp_gen_amount_utils.fp_debug

1055: AND ra.project_id = P_FP_COLS_REC.X_PROJECT_ID; /* Added for Bug 4546405 */
1056: END IF; -- timephased check
1057:
1058: IF p_pa_debug_mode = 'Y' THEN
1059: pa_fp_gen_amount_utils.fp_debug
1060: ( p_msg => 'Value of l_pfc_burdened_cost when the '
1061: || 'plan_class_code is FORECAST: '
1062: || l_pfc_burdened_cost,
1063: p_module_name => l_module_name,

Line 1094: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1090: -- Insert/Update data from the temp table to the budget lines.
1091:
1092: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
1093: IF P_PA_DEBUG_MODE = 'Y' THEN
1094: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1095: ( P_MSG => 'Before calling PA_FP_REV_GEN_PUB.'
1096: ||'PUSH_RES_SCH_DATA_TO_BL',
1097: P_MODULE_NAME => l_module_name,
1098: P_LOG_LEVEL => 5 );

Line 1112: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1108: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1109: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1110: END IF;
1111: IF P_PA_DEBUG_MODE = 'Y' THEN
1112: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1113: ( P_MSG => 'After calling PA_FP_REV_GEN_PUB.'
1114: ||'PUSH_RES_SCH_DATA_TO_BL',
1115: P_MODULE_NAME => l_module_name,
1116: P_LOG_LEVEL => 5);

Line 1135: pa_fp_gen_amount_utils.fp_debug

1131: l_ratio_pc := l_pc_project_value/l_pc_revenue;
1132: END IF;
1133:
1134: IF p_pa_debug_mode = 'Y' THEN
1135: pa_fp_gen_amount_utils.fp_debug
1136: ( p_msg => 'Value of l_ratio, l_ratio_pc:'
1137: ||l_ratio||','||l_ratio_pc,
1138: p_module_name => l_module_name,
1139: p_log_level => 5 );

Line 1370: pa_fp_gen_amount_utils.fp_debug

1366: WHERE budget_line_id = l_budget_line_id_tab(jj);
1367: END IF; -- time phase check
1368: END IF;
1369: IF p_pa_debug_mode = 'Y' THEN
1370: pa_fp_gen_amount_utils.fp_debug
1371: ( p_msg => 'No. of rows updated in bdgt_lines '
1372: || 'table when multi_curr_flag is N: '
1373: || sql%rowcount,
1374: p_module_name => l_module_name,

Line 1398: pa_fp_gen_amount_utils.fp_debug

1394: l_pfc_rev_tab(i) := l_revenue_tab(i) * l_ratio;
1395: END LOOP;
1396: END IF;
1397: IF p_pa_debug_mode = 'Y' THEN
1398: pa_fp_gen_amount_utils.fp_debug
1399: ( p_msg => 'Value of l_txn_rev_tab.count:'||l_txn_rev_tab.count,
1400: p_module_name => l_module_name,
1401: p_log_level => 5 );
1402: END IF;

Line 1500: pa_fp_gen_amount_utils.fp_debug

1496: WHERE budget_line_id = l_budget_line_id_tab(kk);
1497: END IF; -- time phase check
1498: END IF;
1499: IF p_pa_debug_mode = 'Y' THEN
1500: pa_fp_gen_amount_utils.fp_debug
1501: ( p_msg => 'No. of rows updated in bdgt_lines table '
1502: || 'when multi_curr_flag is Y: '||sql%rowcount,
1503: p_module_name => l_module_name,
1504: p_log_level => 5 );

Line 1521: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1517:
1518: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
1519:
1520: IF P_PA_DEBUG_MODE = 'Y' THEN
1521: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1522: ( P_MSG => 'Before calling PA_FP_REV_GEN_PUB.'
1523: ||'PUSH_RES_SCH_DATA_TO_BL',
1524: P_MODULE_NAME => l_module_name,
1525: P_LOG_LEVEL => 5 );

Line 1539: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1535: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1536: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1537: END IF;
1538: IF P_PA_DEBUG_MODE = 'Y' THEN
1539: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1540: ( P_MSG => 'After calling PA_FP_REV_GEN_PUB.'
1541: ||'PUSH_RES_SCH_DATA_TO_BL',
1542: P_MODULE_NAME => l_module_name,
1543: P_LOG_LEVEL => 5);

Line 1618: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1614: * returning with return status of Success.
1615: **/
1616: PROCEDURE PUSH_RES_SCH_DATA_TO_BL
1617: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1618: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1619: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
1620: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
1621: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1622: X_MSG_COUNT OUT NOCOPY NUMBER,