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

Line 30: P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

26:
27: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS
28: (P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
29: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
30: P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
31: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
32: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
33: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
34: P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,

Line 31: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

27: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS
28: (P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
29: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
30: P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
31: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
32: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
33: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
34: P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,
35: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

Line 275: pa_fp_gen_amount_utils.fp_debug(

271: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
272: to get actuals data, we query directly to pa_budget_lines to get actual
273: data from source workplan budget version */
274: IF P_PA_DEBUG_MODE = 'Y' THEN
275: pa_fp_gen_amount_utils.fp_debug(
276: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
277: 'GET_WP_ACTUALS_FOR_RA',
278: p_module_name => l_module_name,
279: p_log_level => 5);

Line 300: pa_fp_gen_amount_utils.fp_debug(

296: X_RETURN_STATUS => x_return_status,
297: X_MSG_COUNT => x_msg_count,
298: X_MSG_DATA => x_msg_data );
299: IF P_PA_DEBUG_MODE = 'Y' THEN
300: pa_fp_gen_amount_utils.fp_debug(
301: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
302: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
303: p_module_name => l_module_name,
304: p_log_level => 5);

Line 510: pa_fp_gen_amount_utils.fp_debug(

506: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
507: to get actuals data, we query directly to pa_budget_lines to get actual
508: data from source workplan budget version */
509: IF P_PA_DEBUG_MODE = 'Y' THEN
510: pa_fp_gen_amount_utils.fp_debug(
511: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
512: 'GET_WP_ACTUALS_FOR_RA',
513: p_module_name => l_module_name,
514: p_log_level => 5);

Line 535: pa_fp_gen_amount_utils.fp_debug(

531: X_RETURN_STATUS => x_return_status,
532: X_MSG_COUNT => x_msg_count,
533: X_MSG_DATA => x_msg_data );
534: IF P_PA_DEBUG_MODE = 'Y' THEN
535: pa_fp_gen_amount_utils.fp_debug(
536: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
537: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
538: p_module_name => l_module_name,
539: p_log_level => 5);

Line 804: pa_fp_gen_amount_utils.fp_debug(

800: resource, so still rely on pa_progress_utils.get_actuals_for_task to
801: get actuals data. This part needs to be revisted when workplan side is
802: changed to support multi currencies.*/
803: IF P_PA_DEBUG_MODE = 'Y' THEN
804: pa_fp_gen_amount_utils.fp_debug(
805: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
806: 'GET_WP_ACTUALS_FOR_RA',
807: p_module_name => l_module_name,
808: p_log_level => 5);

Line 829: pa_fp_gen_amount_utils.fp_debug(

825: X_RETURN_STATUS => x_return_status,
826: X_MSG_COUNT => x_msg_count,
827: X_MSG_DATA => x_msg_data );
828: IF P_PA_DEBUG_MODE = 'Y' THEN
829: pa_fp_gen_amount_utils.fp_debug(
830: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
831: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
832: p_module_name => l_module_name,
833: p_log_level => 5);

Line 884: pa_fp_gen_amount_utils.fp_debug(

880: l_task_id := NULL;
881: l_planning_start_date := NULL;
882: END;
883: IF P_PA_DEBUG_MODE = 'Y' THEN
884: pa_fp_gen_amount_utils.fp_debug(
885: p_msg => 'Before calling pa_multi_currency_txn.'||
886: 'get_currency_amounts in remain_bdgt',
887: p_module_name => l_module_name,
888: p_log_level => 5);

Line 945: pa_fp_gen_amount_utils.fp_debug(

941: ,p_value3 => l_tot_currency_code_tab(i) );
942: x_msg_data := 'PA_FP_PROJ_NO_TXNCONVRATE';
943: END IF;
944: IF P_PA_DEBUG_MODE = 'Y' THEN
945: pa_fp_gen_amount_utils.fp_debug(
946: p_msg => 'After calling pa_multi_currency_txn.'||
947: 'get_currency_amounts in remain_bdgt:'||x_return_status,
948: p_module_name => l_module_name,
949: p_log_level => 5);

Line 1071: pa_fp_gen_amount_utils.fp_debug

1067: ROLLBACK;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069:
1070: IF P_PA_DEBUG_MODE = 'Y' THEN
1071: pa_fp_gen_amount_utils.fp_debug
1072: (p_msg => 'Invalid Arguments Passed',
1073: p_module_name => l_module_name,
1074: p_log_level => 5);
1075: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1090: pa_fp_gen_amount_utils.fp_debug

1086: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS',
1087: p_error_text => substr(sqlerrm,1,240));
1088:
1089: IF P_PA_DEBUG_MODE = 'Y' THEN
1090: pa_fp_gen_amount_utils.fp_debug
1091: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1092: p_module_name => l_module_name,
1093: p_log_level => 5);
1094: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1175: pa_fp_gen_amount_utils.fp_debug

1171: ROLLBACK;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173:
1174: IF P_PA_DEBUG_MODE = 'Y' THEN
1175: pa_fp_gen_amount_utils.fp_debug
1176: (p_msg => 'Invalid Arguments Passed',
1177: p_module_name => l_module_name,
1178: p_log_level => 5);
1179: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1194: pa_fp_gen_amount_utils.fp_debug

1190: p_procedure_name => 'CHECK_SINGLE_CURRENCY',
1191: p_error_text => substr(sqlerrm,1,240));
1192:
1193: IF P_PA_DEBUG_MODE = 'Y' THEN
1194: pa_fp_gen_amount_utils.fp_debug
1195: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1196: p_module_name => l_module_name,
1197: p_log_level => 5);
1198: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1217: (P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1213: /* Bug 4369741: Replaced single planning options flag parameter with
1214: * 2 separate parameters - 1 for Workplan and 1 for Financial Plan. */
1215:
1216: PROCEDURE GET_ETC_COMMITMENT_AMTS
1217: (P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1218: P_WP_PLANNING_OPTIONS_FLAG IN VARCHAR2, /* Added for Bug 4369741 */
1219: P_FP_PLANNING_OPTIONS_FLAG IN VARCHAR2, /* Added for Bug 4369741 */
1220: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1221: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2116: pa_fp_gen_amount_utils.fp_debug(

2112: l_task_id := NULL;
2113: l_planning_start_date := NULL;
2114: END;
2115: IF P_PA_DEBUG_MODE = 'Y' THEN
2116: pa_fp_gen_amount_utils.fp_debug(
2117: p_msg => 'Before calling pa_multi_currency_txn.'||
2118: 'get_currency_amounts in remain_bdgt',
2119: p_module_name => l_module_name,
2120: p_log_level => 5);

Line 2154: pa_fp_gen_amount_utils.fp_debug(

2150: P_system_linkage => 'NER',
2151: P_status => x_return_status,
2152: P_stage => x_msg_count) ;
2153: IF P_PA_DEBUG_MODE = 'Y' THEN
2154: pa_fp_gen_amount_utils.fp_debug(
2155: p_msg => 'After calling pa_multi_currency_txn.'||
2156: 'get_currency_amounts in remain_bdgt:'||x_return_status,
2157: p_module_name => l_module_name,
2158: p_log_level => 5);

Line 2281: pa_fp_gen_amount_utils.fp_debug

2277: ROLLBACK;
2278: x_return_status := FND_API.G_RET_STS_ERROR;
2279:
2280: IF P_PA_DEBUG_MODE = 'Y' THEN
2281: pa_fp_gen_amount_utils.fp_debug
2282: (p_msg => 'Invalid Arguments Passed',
2283: p_module_name => l_module_name,
2284: p_log_level => 5);
2285: PA_DEBUG.RESET_CURR_FUNCTION;

Line 2300: pa_fp_gen_amount_utils.fp_debug

2296: p_procedure_name => 'GEN_ETC_COMMITMENT_AMTS',
2297: p_error_text => substr(sqlerrm,1,240));
2298:
2299: IF P_PA_DEBUG_MODE = 'Y' THEN
2300: pa_fp_gen_amount_utils.fp_debug
2301: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2302: p_module_name => l_module_name,
2303: p_log_level => 5);
2304: PA_DEBUG.RESET_CURR_FUNCTION;

Line 2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

2329: */
2330: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS_BLK
2331: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2332: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

2330: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS_BLK
2331: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2332: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2338: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

2331: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2332: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2338: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
2339: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

Line 2464: l_fp_cols_src_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

2460:
2461: /* Variables for Performance Bug 4194849 */
2462: l_src_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2463: l_tgt_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2464: l_fp_cols_src_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2465: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
2466: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
2467: l_etc_source_code PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
2468:

Line 2695: pa_fp_gen_amount_utils.fp_debug(

2691: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
2692: to get actuals data, we query directly to pa_budget_lines to get actual
2693: data from source workplan budget version */
2694: IF P_PA_DEBUG_MODE = 'Y' THEN
2695: pa_fp_gen_amount_utils.fp_debug(
2696: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2697: 'GET_WP_ACTUALS_FOR_RA',
2698: p_module_name => l_module_name,
2699: p_log_level => 5);

Line 2720: pa_fp_gen_amount_utils.fp_debug(

2716: X_RETURN_STATUS => x_return_status,
2717: X_MSG_COUNT => x_msg_count,
2718: X_MSG_DATA => x_msg_data );
2719: IF P_PA_DEBUG_MODE = 'Y' THEN
2720: pa_fp_gen_amount_utils.fp_debug(
2721: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2722: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
2723: p_module_name => l_module_name,
2724: p_log_level => 5);

Line 2984: pa_fp_gen_amount_utils.fp_debug(

2980: resource. Instead of relying on pa_progress_utils.get_actuals_for_task
2981: to get actuals data, we query directly to pa_budget_lines to get actual
2982: data from source workplan budget version */
2983: IF P_PA_DEBUG_MODE = 'Y' THEN
2984: pa_fp_gen_amount_utils.fp_debug(
2985: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2986: 'GET_WP_ACTUALS_FOR_RA',
2987: p_module_name => l_module_name,
2988: p_log_level => 5);

Line 3009: pa_fp_gen_amount_utils.fp_debug(

3005: X_RETURN_STATUS => x_return_status,
3006: X_MSG_COUNT => x_msg_count,
3007: X_MSG_DATA => x_msg_data );
3008: IF P_PA_DEBUG_MODE = 'Y' THEN
3009: pa_fp_gen_amount_utils.fp_debug(
3010: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
3011: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3012: p_module_name => l_module_name,
3013: p_log_level => 5);

Line 3350: pa_fp_gen_amount_utils.fp_debug(

3346: resource, so still rely on pa_progress_utils.get_actuals_for_task to
3347: get actuals data. This part needs to be revisted when workplan side is
3348: changed to support multi currencies.*/
3349: IF P_PA_DEBUG_MODE = 'Y' THEN
3350: pa_fp_gen_amount_utils.fp_debug(
3351: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
3352: 'GET_WP_ACTUALS_FOR_RA',
3353: p_module_name => l_module_name,
3354: p_log_level => 5);

Line 3375: pa_fp_gen_amount_utils.fp_debug(

3371: X_RETURN_STATUS => x_return_status,
3372: X_MSG_COUNT => x_msg_count,
3373: X_MSG_DATA => x_msg_data );
3374: IF P_PA_DEBUG_MODE = 'Y' THEN
3375: pa_fp_gen_amount_utils.fp_debug(
3376: p_msg => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
3377: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3378: p_module_name => l_module_name,
3379: p_log_level => 5);

Line 3443: pa_fp_gen_amount_utils.fp_debug(

3439: l_task_id := NULL;
3440: l_planning_start_date := NULL;
3441: END;
3442: IF P_PA_DEBUG_MODE = 'Y' THEN
3443: pa_fp_gen_amount_utils.fp_debug(
3444: p_msg => 'Before calling pa_multi_currency_txn.'||
3445: 'get_currency_amounts in remain_bdgt',
3446: p_module_name => l_module_name,
3447: p_log_level => 5);

Line 3504: pa_fp_gen_amount_utils.fp_debug(

3500: ,p_value3 => l_tot_currency_code_tab(i) );
3501: x_msg_data := 'PA_FP_PROJ_NO_TXNCONVRATE';
3502: END IF;
3503: IF P_PA_DEBUG_MODE = 'Y' THEN
3504: pa_fp_gen_amount_utils.fp_debug(
3505: p_msg => 'After calling pa_multi_currency_txn.'||
3506: 'get_currency_amounts in remain_bdgt:'||x_return_status,
3507: p_module_name => l_module_name,
3508: p_log_level => 5);

Line 3697: pa_fp_gen_amount_utils.fp_debug

3693: ROLLBACK;
3694: x_return_status := FND_API.G_RET_STS_ERROR;
3695:
3696: IF P_PA_DEBUG_MODE = 'Y' THEN
3697: pa_fp_gen_amount_utils.fp_debug
3698: (p_msg => 'Invalid Arguments Passed',
3699: p_module_name => l_module_name,
3700: p_log_level => 5);
3701: PA_DEBUG.RESET_CURR_FUNCTION;

Line 3716: pa_fp_gen_amount_utils.fp_debug

3712: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
3713: p_error_text => substr(sqlerrm,1,240));
3714:
3715: IF P_PA_DEBUG_MODE = 'Y' THEN
3716: pa_fp_gen_amount_utils.fp_debug
3717: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3718: p_module_name => l_module_name,
3719: p_log_level => 5);
3720: PA_DEBUG.RESET_CURR_FUNCTION;