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

Line 9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5: /**This procedure is called to copy actuals to budget version lines**/
6: PROCEDURE COPY_ACTUALS
7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
8: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: P_END_DATE IN DATE,
11: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
12: P_COMMIT_FLAG IN VARCHAR2 default 'N',
13: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 631: pa_fp_gen_amount_utils.fp_debug

627: l_record_type := l_record_type||'N';
628: END IF;
629: l_record_type := l_record_type||'N';
630: IF P_PA_DEBUG_MODE = 'Y' THEN
631: pa_fp_gen_amount_utils.fp_debug
632: (p_msg => 'Before calling pji_fm_xbs_accum_tmp1',
633: p_module_name => l_module_name,
634: p_log_level => 5);
635: END IF;

Line 667: pa_fp_gen_amount_utils.fp_debug

663: --hr_utility.trace('after entering get_sum:'||x_return_status);
664: --delete from get_sum_test;
665: --insert into get_sum_test (select * from pji_fm_xbs_accum_tmp1);
666: IF P_PA_DEBUG_MODE = 'Y' THEN
667: pa_fp_gen_amount_utils.fp_debug
668: (p_msg => 'After calling pji_fm_xbs_accum_tmp1,return status is: '||x_return_status,
669: p_module_name => l_module_name,
670: p_log_level => 5);
671: END IF;

Line 679: pa_fp_gen_amount_utils.fp_debug

675: END IF;
676:
677: IF l_count = 0 THEN
678: IF P_PA_DEBUG_MODE = 'Y' THEN
679: pa_fp_gen_amount_utils.fp_debug
680: (p_msg => 'no actual data as of '||
681: to_char(p_end_date,'dd-mon-rrrr'),
682: p_module_name => l_module_name,
683: p_log_level => 5);

Line 708: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID (

704: FROM pa_resource_lists_all_bg
705: WHERE resource_list_id = p_fp_cols_rec.X_RESOURCE_LIST_ID;
706:
707: IF l_uncategorized_flag = 'Y' THEN
708: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID (
709: p_project_id => p_project_id,
710: p_resource_list_id => p_fp_cols_rec.X_RESOURCE_LIST_ID,
711: p_resource_class_code => 'FINANCIAL_ELEMENTS' );
712: UPDATE pji_fm_xbs_accum_tmp1

Line 742: pa_fp_gen_amount_utils.fp_debug

738: -- select count(*) into l_count from pa_resource_assignments where
739: -- budget_version_id = p_budget_version_id;
740: --dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
741: IF P_PA_DEBUG_MODE = 'Y' THEN
742: pa_fp_gen_amount_utils.fp_debug
743: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
744: p_module_name => l_module_name,
745: p_log_level => 5);
746: END IF;

Line 756: pa_fp_gen_amount_utils.fp_debug

752: X_MSG_COUNT => x_msg_count,
753: X_MSG_DATA => x_msg_data );
754: --dbms_output.put_line('Status after calling cre res asg api: '||x_return_status);
755: IF P_PA_DEBUG_MODE = 'Y' THEN
756: pa_fp_gen_amount_utils.fp_debug
757: (p_msg => 'After calling create_res_asg,return status is: '||x_return_status,
758: p_module_name => l_module_name,
759: p_log_level => 5);
760: END IF;

Line 769: pa_fp_gen_amount_utils.fp_debug

765: /**Calling update_res_asg to populate the newly created resource_assignment_id back to
766: *pa_fp_planning_res_tmp1. Then this value needs to populated back to pji_fm_xbs_accum_tmp1
767: **/
768: IF P_PA_DEBUG_MODE = 'Y' THEN
769: pa_fp_gen_amount_utils.fp_debug
770: (p_msg => 'Before calling update_res_asg',
771: p_module_name => l_module_name,
772: p_log_level => 5);
773: END IF;

Line 783: pa_fp_gen_amount_utils.fp_debug

779: X_MSG_COUNT => x_msg_count,
780: X_MSG_DATA => x_msg_data);
781: --dbms_output.put_line('Status after calling upd res asg api: '||x_return_status);
782: IF P_PA_DEBUG_MODE = 'Y' THEN
783: pa_fp_gen_amount_utils.fp_debug
784: (p_msg => 'After calling update_res_asg,return status is: '||x_return_status,
785: p_module_name => l_module_name,
786: p_log_level => 5);
787: END IF;

Line 832: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date(p_fp_cols_rec.x_budget_version_id);

828: -- ra.rate_based_flag = 'N'
829: -- WHERE ra.resource_assignment_id = l_res_asg_id_tmp_tab(k);
830:
831: If p_fp_cols_rec.x_time_phased_code IN ('P','G') then
832: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date(p_fp_cols_rec.x_budget_version_id);
833:
834: FORALL k IN 1..l_res_asg_id_tmp_tab.count
835: UPDATE pa_resource_assignments ra
836: SET ra.unit_of_measure = 'DOLLARS',

Line 1005: pa_fp_gen_amount_utils.fp_debug

1001:
1002: END LOOP;
1003:
1004: IF P_PA_DEBUG_MODE = 'Y' THEN
1005: pa_fp_gen_amount_utils.fp_debug
1006: (p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA',
1007: p_module_name => l_module_name,
1008: p_log_level => 5);
1009: END IF;

Line 1026: pa_fp_gen_amount_utils.fp_debug

1022: X_MSG_COUNT => x_msg_count,
1023: X_MSG_DATA => x_msg_data );
1024: --dbms_output.put_line('Status after calling MAINTAIN_ACTUAL_AMT_RA api: '||x_return_status);
1025: IF P_PA_DEBUG_MODE = 'Y' THEN
1026: pa_fp_gen_amount_utils.fp_debug
1027: (p_msg => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA,
1028: return status is: '||x_return_status,
1029: p_module_name => l_module_name,
1030: p_log_level => 5);

Line 1042: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1038: /* the planning start date and end date in pa_resource assignments table
1039: * should be synched up with the budget lines after copying the actual
1040: * data for all the planning resources. */
1041: IF p_pa_debug_mode = 'Y' THEN
1042: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1043: ( p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1044: 'SYNC_UP_PLANNING_DATES',
1045: p_module_name => l_module_name,
1046: p_log_level => 5 );

Line 1057: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1053: X_MSG_COUNT => x_msg_count,
1054: X_MSG_DATA => x_msg_data );
1055: --dbms_output.put_line('Status after calling SYNC_UP_PLANNING_DATES api: '||x_return_status);
1056: IF p_pa_debug_mode = 'Y' THEN
1057: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1058: ( p_msg => 'Aft calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1059: 'SYNC_UP_PLANNING_DATES return status ' ||
1060: x_return_status,
1061: p_module_name => l_module_name,

Line 1097: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1093: AND tmp.txn_currency_code = rbc.txn_currency_code );
1094:
1095: -- Call the maintenance api in ROLLUP mode
1096: IF p_pa_debug_mode = 'Y' THEN
1097: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1098: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
1099: 'MAINTAIN_DATA',
1100: --P_CALLED_MODE => p_called_mode,
1101: P_MODULE_NAME => l_module_name);

Line 1114: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1110:
1111: X_MSG_COUNT => x_msg_count,
1112: X_MSG_DATA => x_msg_data );
1113: IF p_pa_debug_mode = 'Y' THEN
1114: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1115: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
1116: 'MAINTAIN_DATA: '||x_return_status,
1117: --P_CALLED_MODE => p_called_mode,
1118: P_MODULE_NAME => l_module_name);

Line 1154: pa_fp_gen_amount_utils.fp_debug

1150: ROLLBACK;
1151:
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: IF P_PA_DEBUG_MODE = 'Y' THEN
1154: pa_fp_gen_amount_utils.fp_debug
1155: (p_msg => 'Invalid Arguments Passed',
1156: p_module_name => l_module_name,
1157: p_log_level => 5);
1158: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1173: pa_fp_gen_amount_utils.fp_debug

1169: p_procedure_name => 'COPY_ACTUALS',
1170: p_error_text => substr(sqlerrm,1,240));
1171:
1172: IF P_PA_DEBUG_MODE = 'Y' THEN
1173: pa_fp_gen_amount_utils.fp_debug
1174: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1175: p_module_name => l_module_name,
1176: p_log_level => 5);
1177: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1187: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1183:
1184: PROCEDURE CREATE_RES_ASG (
1185: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1186: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1187: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1188: P_CALLING_PROCESS IN VARCHAR2,
1189: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1190: X_MSG_COUNT OUT NOCOPY NUMBER,
1191: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1195: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1191: X_MSG_DATA OUT NOCOPY VARCHAR2)
1192: IS
1193: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.create_res_asg';
1194:
1195: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1196: l_res_plan_level VARCHAR2(15);
1197:
1198: CURSOR project_res_asg_cur
1199: ( p_proj_start_date DATE,

Line 1353: pa_fp_gen_amount_utils.fp_debug

1349: x_msg_count := 0;
1350:
1351: IF (P_FP_COLS_REC.X_BUDGET_VERSION_ID IS NULL) THEN
1352: IF P_PA_DEBUG_MODE = 'Y' THEN
1353: pa_fp_gen_amount_utils.fp_debug
1354: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',
1355: p_module_name => l_module_name,
1356: p_log_level => 5);
1357: END IF;

Line 1354: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',

1350:
1351: IF (P_FP_COLS_REC.X_BUDGET_VERSION_ID IS NULL) THEN
1352: IF P_PA_DEBUG_MODE = 'Y' THEN
1353: pa_fp_gen_amount_utils.fp_debug
1354: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',
1355: p_module_name => l_module_name,
1356: p_log_level => 5);
1357: END IF;
1358: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

Line 1358: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1354: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',
1355: p_module_name => l_module_name,
1356: p_log_level => 5);
1357: END IF;
1358: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1359: P_PROJECT_ID => P_PROJECT_ID,
1360: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1361: X_FP_COLS_REC => l_fp_cols_rec,
1362: X_RETURN_STATUS => x_return_status,

Line 1366: pa_fp_gen_amount_utils.fp_debug

1362: X_RETURN_STATUS => x_return_status,
1363: X_MSG_COUNT => x_msg_count,
1364: X_MSG_DATA => x_msg_data);
1365: IF P_PA_DEBUG_MODE = 'Y' THEN
1366: pa_fp_gen_amount_utils.fp_debug
1367: (p_msg => 'After calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS,
1368: return status:'||x_return_status,
1369: p_module_name => l_module_name,
1370: p_log_level => 5);

Line 1367: (p_msg => 'After calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS,

1363: X_MSG_COUNT => x_msg_count,
1364: X_MSG_DATA => x_msg_data);
1365: IF P_PA_DEBUG_MODE = 'Y' THEN
1366: pa_fp_gen_amount_utils.fp_debug
1367: (p_msg => 'After calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS,
1368: return status:'||x_return_status,
1369: p_module_name => l_module_name,
1370: p_log_level => 5);
1371: END IF;

Line 1497: pa_fp_gen_amount_utils.fp_debug

1493: l_rec_ver_number_1,
1494: l_etc_src_code_tab(i)
1495: );
1496: IF P_PA_DEBUG_MODE = 'Y' THEN
1497: pa_fp_gen_amount_utils.fp_debug
1498: (p_msg => 'Before calling update_res_defaults',
1499: p_module_name => l_module_name,
1500: p_log_level => 5);
1501: END IF;

Line 1509: pa_fp_gen_amount_utils.fp_debug

1505: X_RETURN_STATUS => x_return_status,
1506: X_MSG_COUNT => x_msg_count,
1507: X_MSG_DATA => x_msg_data );
1508: IF P_PA_DEBUG_MODE = 'Y' THEN
1509: pa_fp_gen_amount_utils.fp_debug
1510: (p_msg => 'Before calling update_res_defaults',
1511: p_module_name => l_module_name,
1512: p_log_level => 5);
1513: END IF;

Line 1553: pa_fp_gen_amount_utils.fp_debug

1549: ROLLBACK;
1550:
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: IF P_PA_DEBUG_MODE = 'Y' THEN
1553: pa_fp_gen_amount_utils.fp_debug
1554: (p_msg => 'Invalid Arguments Passed',
1555: p_module_name => l_module_name,
1556: p_log_level => 5);
1557: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1572: pa_fp_gen_amount_utils.fp_debug

1568: p_procedure_name => 'CREATE_RES_ASG',
1569: p_error_text => substr(sqlerrm,1,240));
1570:
1571: IF P_PA_DEBUG_MODE = 'Y' THEN
1572: pa_fp_gen_amount_utils.fp_debug
1573: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1574: p_module_name => l_module_name,
1575: p_log_level => 5);
1576: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1585: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1581:
1582: PROCEDURE UPDATE_RES_ASG (
1583: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1584: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1585: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1586: P_CALLING_PROCESS IN VARCHAR2,
1587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1588: X_MSG_COUNT OUT NOCOPY NUMBER,
1589: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1713: pa_fp_gen_amount_utils.fp_debug

1709:
1710: x_return_status := FND_API.G_RET_STS_ERROR;
1711:
1712: IF P_PA_DEBUG_MODE = 'Y' THEN
1713: pa_fp_gen_amount_utils.fp_debug
1714: (p_msg => 'Invalid Arguments Passed',
1715: p_module_name => l_module_name,
1716: p_log_level => 5);
1717: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1732: pa_fp_gen_amount_utils.fp_debug

1728: p_procedure_name => 'UPDATE_RES_ASG',
1729: p_error_text => substr(sqlerrm,1,240));
1730:
1731: IF P_PA_DEBUG_MODE = 'Y' THEN
1732: pa_fp_gen_amount_utils.fp_debug
1733: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1734: p_module_name => l_module_name,
1735: p_log_level => 5);
1736: PA_DEBUG.RESET_CURR_FUNCTION;