DBA Data[Home] [Help]

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 667: pa_fp_gen_amount_utils.fp_debug

663: l_record_type := l_record_type||'N';
664: END IF;
665: l_record_type := l_record_type||'N';
666: IF P_PA_DEBUG_MODE = 'Y' THEN
667: pa_fp_gen_amount_utils.fp_debug
668: (p_msg => 'Before calling pji_fm_xbs_accum_tmp1',
669: p_module_name => l_module_name,
670: p_log_level => 5);
671: END IF;

Line 703: pa_fp_gen_amount_utils.fp_debug

699: --hr_utility.trace('after entering get_sum:'||x_return_status);
700: --delete from get_sum_test;
701: --insert into get_sum_test (select * from pji_fm_xbs_accum_tmp1);
702: IF P_PA_DEBUG_MODE = 'Y' THEN
703: pa_fp_gen_amount_utils.fp_debug
704: (p_msg => 'After calling pji_fm_xbs_accum_tmp1,return status is: '||x_return_status,
705: p_module_name => l_module_name,
706: p_log_level => 5);
707: END IF;

Line 715: pa_fp_gen_amount_utils.fp_debug

711: END IF;
712:
713: IF l_count = 0 THEN
714: IF P_PA_DEBUG_MODE = 'Y' THEN
715: pa_fp_gen_amount_utils.fp_debug
716: (p_msg => 'no actual data as of '||
717: to_char(p_end_date,'dd-mon-rrrr'),
718: p_module_name => l_module_name,
719: p_log_level => 5);

Line 744: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID (

740: FROM pa_resource_lists_all_bg
741: WHERE resource_list_id = p_fp_cols_rec.X_RESOURCE_LIST_ID;
742:
743: IF l_uncategorized_flag = 'Y' THEN
744: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID (
745: p_project_id => p_project_id,
746: p_resource_list_id => p_fp_cols_rec.X_RESOURCE_LIST_ID,
747: p_resource_class_code => 'FINANCIAL_ELEMENTS' );
748: UPDATE pji_fm_xbs_accum_tmp1

Line 781: pa_fp_gen_amount_utils.fp_debug

777: -- select count(*) into l_count from pa_resource_assignments where
778: -- budget_version_id = p_budget_version_id;
779: --dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
780: IF P_PA_DEBUG_MODE = 'Y' THEN
781: pa_fp_gen_amount_utils.fp_debug
782: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
783: p_module_name => l_module_name,
784: p_log_level => 5);
785: END IF;

Line 795: pa_fp_gen_amount_utils.fp_debug

791: X_MSG_COUNT => x_msg_count,
792: X_MSG_DATA => x_msg_data );
793: --dbms_output.put_line('Status after calling cre res asg api: '||x_return_status);
794: IF P_PA_DEBUG_MODE = 'Y' THEN
795: pa_fp_gen_amount_utils.fp_debug
796: (p_msg => 'After calling create_res_asg,return status is: '||x_return_status,
797: p_module_name => l_module_name,
798: p_log_level => 5);
799: END IF;

Line 808: pa_fp_gen_amount_utils.fp_debug

804: /**Calling update_res_asg to populate the newly created resource_assignment_id back to
805: *pa_fp_planning_res_tmp1. Then this value needs to populated back to pji_fm_xbs_accum_tmp1
806: **/
807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_fp_gen_amount_utils.fp_debug
809: (p_msg => 'Before calling update_res_asg',
810: p_module_name => l_module_name,
811: p_log_level => 5);
812: END IF;

Line 822: pa_fp_gen_amount_utils.fp_debug

818: X_MSG_COUNT => x_msg_count,
819: X_MSG_DATA => x_msg_data);
820: --dbms_output.put_line('Status after calling upd res asg api: '||x_return_status);
821: IF P_PA_DEBUG_MODE = 'Y' THEN
822: pa_fp_gen_amount_utils.fp_debug
823: (p_msg => 'After calling update_res_asg,return status is: '||x_return_status,
824: p_module_name => l_module_name,
825: p_log_level => 5);
826: END IF;

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

869: -- ra.rate_based_flag = 'N'
870: -- WHERE ra.resource_assignment_id = l_res_asg_id_tmp_tab(k);
871:
872: If p_fp_cols_rec.x_time_phased_code IN ('P','G') then
873: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date(p_fp_cols_rec.x_budget_version_id);
874:
875: FORALL k IN 1..l_res_asg_id_tmp_tab.count
876: UPDATE pa_resource_assignments ra
877: SET ra.unit_of_measure = 'DOLLARS',

Line 1046: pa_fp_gen_amount_utils.fp_debug

1042:
1043: END LOOP;
1044:
1045: IF P_PA_DEBUG_MODE = 'Y' THEN
1046: pa_fp_gen_amount_utils.fp_debug
1047: (p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA',
1048: p_module_name => l_module_name,
1049: p_log_level => 5);
1050: END IF;

Line 1067: pa_fp_gen_amount_utils.fp_debug

1063: X_MSG_COUNT => x_msg_count,
1064: X_MSG_DATA => x_msg_data );
1065: --dbms_output.put_line('Status after calling MAINTAIN_ACTUAL_AMT_RA api: '||x_return_status);
1066: IF P_PA_DEBUG_MODE = 'Y' THEN
1067: pa_fp_gen_amount_utils.fp_debug
1068: (p_msg => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA,
1069: return status is: '||x_return_status,
1070: p_module_name => l_module_name,
1071: p_log_level => 5);

Line 1083: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1079: /* the planning start date and end date in pa_resource assignments table
1080: * should be synched up with the budget lines after copying the actual
1081: * data for all the planning resources. */
1082: IF p_pa_debug_mode = 'Y' THEN
1083: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1084: ( p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1085: 'SYNC_UP_PLANNING_DATES',
1086: p_module_name => l_module_name,
1087: p_log_level => 5 );

Line 1098: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1094: X_MSG_COUNT => x_msg_count,
1095: X_MSG_DATA => x_msg_data );
1096: --dbms_output.put_line('Status after calling SYNC_UP_PLANNING_DATES api: '||x_return_status);
1097: IF p_pa_debug_mode = 'Y' THEN
1098: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1099: ( p_msg => 'Aft calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1100: 'SYNC_UP_PLANNING_DATES return status ' ||
1101: x_return_status,
1102: p_module_name => l_module_name,

Line 1138: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1134: AND tmp.txn_currency_code = rbc.txn_currency_code );
1135:
1136: -- Call the maintenance api in ROLLUP mode
1137: IF p_pa_debug_mode = 'Y' THEN
1138: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1139: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
1140: 'MAINTAIN_DATA',
1141: --P_CALLED_MODE => p_called_mode,
1142: P_MODULE_NAME => l_module_name);

Line 1155: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1151:
1152: X_MSG_COUNT => x_msg_count,
1153: X_MSG_DATA => x_msg_data );
1154: IF p_pa_debug_mode = 'Y' THEN
1155: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1156: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
1157: 'MAINTAIN_DATA: '||x_return_status,
1158: --P_CALLED_MODE => p_called_mode,
1159: P_MODULE_NAME => l_module_name);

Line 1195: pa_fp_gen_amount_utils.fp_debug

1191: ROLLBACK;
1192:
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: IF P_PA_DEBUG_MODE = 'Y' THEN
1195: pa_fp_gen_amount_utils.fp_debug
1196: (p_msg => 'Invalid Arguments Passed',
1197: p_module_name => l_module_name,
1198: p_log_level => 5);
1199: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1214: pa_fp_gen_amount_utils.fp_debug

1210: p_procedure_name => 'COPY_ACTUALS',
1211: p_error_text => substr(sqlerrm,1,240));
1212:
1213: IF P_PA_DEBUG_MODE = 'Y' THEN
1214: pa_fp_gen_amount_utils.fp_debug
1215: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1216: p_module_name => l_module_name,
1217: p_log_level => 5);
1218: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1228: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1224:
1225: PROCEDURE CREATE_RES_ASG (
1226: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1227: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1228: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1229: P_CALLING_PROCESS IN VARCHAR2,
1230: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1231: X_MSG_COUNT OUT NOCOPY NUMBER,
1232: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1236: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1232: X_MSG_DATA OUT NOCOPY VARCHAR2)
1233: IS
1234: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.create_res_asg';
1235:
1236: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1237: l_res_plan_level VARCHAR2(15);
1238:
1239: CURSOR project_res_asg_cur
1240: ( p_proj_start_date DATE,

Line 1500: pa_fp_gen_amount_utils.fp_debug

1496: l_Cbs_Enabled := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => P_PROJECT_ID); -- bug#16200605
1497:
1498: IF (P_FP_COLS_REC.X_BUDGET_VERSION_ID IS NULL) THEN
1499: IF P_PA_DEBUG_MODE = 'Y' THEN
1500: pa_fp_gen_amount_utils.fp_debug
1501: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',
1502: p_module_name => l_module_name,
1503: p_log_level => 5);
1504: END IF;

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

1497:
1498: IF (P_FP_COLS_REC.X_BUDGET_VERSION_ID IS NULL) THEN
1499: IF P_PA_DEBUG_MODE = 'Y' THEN
1500: pa_fp_gen_amount_utils.fp_debug
1501: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',
1502: p_module_name => l_module_name,
1503: p_log_level => 5);
1504: END IF;
1505: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

Line 1505: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1501: (p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTL',
1502: p_module_name => l_module_name,
1503: p_log_level => 5);
1504: END IF;
1505: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1506: P_PROJECT_ID => P_PROJECT_ID,
1507: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1508: X_FP_COLS_REC => l_fp_cols_rec,
1509: X_RETURN_STATUS => x_return_status,

Line 1513: pa_fp_gen_amount_utils.fp_debug

1509: X_RETURN_STATUS => x_return_status,
1510: X_MSG_COUNT => x_msg_count,
1511: X_MSG_DATA => x_msg_data);
1512: IF P_PA_DEBUG_MODE = 'Y' THEN
1513: pa_fp_gen_amount_utils.fp_debug
1514: (p_msg => 'After calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS,
1515: return status:'||x_return_status,
1516: p_module_name => l_module_name,
1517: p_log_level => 5);

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

1510: X_MSG_COUNT => x_msg_count,
1511: X_MSG_DATA => x_msg_data);
1512: IF P_PA_DEBUG_MODE = 'Y' THEN
1513: pa_fp_gen_amount_utils.fp_debug
1514: (p_msg => 'After calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS,
1515: return status:'||x_return_status,
1516: p_module_name => l_module_name,
1517: p_log_level => 5);
1518: END IF;

Line 1732: pa_fp_gen_amount_utils.fp_debug

1728: END IF;
1729: */
1730:
1731: IF P_PA_DEBUG_MODE = 'Y' THEN
1732: pa_fp_gen_amount_utils.fp_debug
1733: (p_msg => 'Before calling update_res_defaults',
1734: p_module_name => l_module_name,
1735: p_log_level => 5);
1736: END IF;

Line 1744: pa_fp_gen_amount_utils.fp_debug

1740: X_RETURN_STATUS => x_return_status,
1741: X_MSG_COUNT => x_msg_count,
1742: X_MSG_DATA => x_msg_data );
1743: IF P_PA_DEBUG_MODE = 'Y' THEN
1744: pa_fp_gen_amount_utils.fp_debug
1745: (p_msg => 'Before calling update_res_defaults',
1746: p_module_name => l_module_name,
1747: p_log_level => 5);
1748: END IF;

Line 1788: pa_fp_gen_amount_utils.fp_debug

1784: ROLLBACK;
1785:
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: IF P_PA_DEBUG_MODE = 'Y' THEN
1788: pa_fp_gen_amount_utils.fp_debug
1789: (p_msg => 'Invalid Arguments Passed',
1790: p_module_name => l_module_name,
1791: p_log_level => 5);
1792: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1807: pa_fp_gen_amount_utils.fp_debug

1803: p_procedure_name => 'CREATE_RES_ASG',
1804: p_error_text => substr(sqlerrm,1,240));
1805:
1806: IF P_PA_DEBUG_MODE = 'Y' THEN
1807: pa_fp_gen_amount_utils.fp_debug
1808: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1809: p_module_name => l_module_name,
1810: p_log_level => 5);
1811: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1820: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1816:
1817: PROCEDURE UPDATE_RES_ASG (
1818: P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1819: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1820: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1821: P_CALLING_PROCESS IN VARCHAR2,
1822: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1823: X_MSG_COUNT OUT NOCOPY NUMBER,
1824: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1958: pa_fp_gen_amount_utils.fp_debug

1954:
1955: x_return_status := FND_API.G_RET_STS_ERROR;
1956:
1957: IF P_PA_DEBUG_MODE = 'Y' THEN
1958: pa_fp_gen_amount_utils.fp_debug
1959: (p_msg => 'Invalid Arguments Passed',
1960: p_module_name => l_module_name,
1961: p_log_level => 5);
1962: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1977: pa_fp_gen_amount_utils.fp_debug

1973: p_procedure_name => 'UPDATE_RES_ASG',
1974: p_error_text => substr(sqlerrm,1,240));
1975:
1976: IF P_PA_DEBUG_MODE = 'Y' THEN
1977: pa_fp_gen_amount_utils.fp_debug
1978: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1979: p_module_name => l_module_name,
1980: p_log_level => 5);
1981: PA_DEBUG.RESET_CURR_FUNCTION;

Line 2007: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

2003: l_msg_data VARCHAR2(2000);
2004: l_data VARCHAR2(2000);
2005: l_msg_index_out NUMBER:=0;
2006:
2007: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2008:
2009: l_actuals_through_date DATE;
2010: l_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2011: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 2395: pa_fp_gen_amount_utils.fp_debug

2391: into l_record_version_number
2392: from pa_budget_versions
2393: where budget_version_id = p_budget_version_id;
2394: IF p_pa_debug_mode = 'Y' THEN
2395: pa_fp_gen_amount_utils.fp_debug
2396: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',
2397: p_module_name => l_module_name);
2398: END IF;
2399: pa_fin_plan_pvt.lock_unlock_version(

Line 2409: pa_fp_gen_amount_utils.fp_debug

2405: x_return_status => x_return_status,
2406: x_msg_count => x_msg_count,
2407: x_msg_data => x_msg_data);
2408: IF p_pa_debug_mode = 'Y' THEN
2409: pa_fp_gen_amount_utils.fp_debug
2410: (p_msg => 'Status after calling pa_fin_plan_pvt.lock_unlock_version:'
2411: ||x_return_status,
2412: p_module_name => l_module_name);
2413: END IF;

Line 2429: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2425: --acquire lock for collect_actual
2426: -- using copy_actuals api to acquire lock for collect_acutuals
2427: -- as the underlying table are same in both cases.
2428: IF p_pa_debug_mode = 'Y' THEN
2429: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2430: P_MSG => 'Before calling PA_FP_COPY_FROM_PKG.'
2431: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL',
2432: P_MODULE_NAME => l_module_name);
2433: END IF;

Line 2450: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2446: RETURN;
2447: END IF;
2448:
2449: IF p_pa_debug_mode = 'Y' THEN
2450: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2451: P_MSG => 'After calling PA_FP_COPY_FROM_PKG.'
2452: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL: '
2453: ||x_return_status,
2454: P_MODULE_NAME => l_module_name);

Line 2472: pa_fp_gen_amount_utils.fp_debug

2468: /* Validation - End */
2469:
2470: /* Calling utility api to get plan version details - Begin */
2471: if p_pa_debug_mode = 'Y' then
2472: pa_fp_gen_amount_utils.fp_debug
2473: (p_msg => 'Before calling
2474: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
2475: p_module_name => l_module_name,
2476: p_log_level => 5);

Line 2474: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',

2470: /* Calling utility api to get plan version details - Begin */
2471: if p_pa_debug_mode = 'Y' then
2472: pa_fp_gen_amount_utils.fp_debug
2473: (p_msg => 'Before calling
2474: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
2475: p_module_name => l_module_name,
2476: p_log_level => 5);
2477: end if;
2478: pa_fp_gen_amount_utils.get_plan_version_dtls

Line 2478: pa_fp_gen_amount_utils.get_plan_version_dtls

2474: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
2475: p_module_name => l_module_name,
2476: p_log_level => 5);
2477: end if;
2478: pa_fp_gen_amount_utils.get_plan_version_dtls
2479: (p_budget_version_id => p_budget_version_id,
2480: x_fp_cols_rec => l_fp_cols_rec,
2481: x_return_status => x_return_status,
2482: x_msg_count => x_msg_count,

Line 2488: pa_fp_gen_amount_utils.fp_debug

2484: if x_return_status <> fnd_api.g_ret_sts_success then
2485: raise pa_fp_constants_pkg.invalid_arg_exc;
2486: end if;
2487: if p_pa_debug_mode = 'Y' then
2488: pa_fp_gen_amount_utils.fp_debug
2489: (p_msg => 'Status after calling
2490: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
2491: ||x_return_status,
2492: p_module_name => l_module_name,

Line 2490: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '

2486: end if;
2487: if p_pa_debug_mode = 'Y' then
2488: pa_fp_gen_amount_utils.fp_debug
2489: (p_msg => 'Status after calling
2490: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
2491: ||x_return_status,
2492: p_module_name => l_module_name,
2493: p_log_level => 5);
2494: end if;

Line 2554: pa_fp_gen_amount_utils.fp_debug

2550: END IF;
2551: l_record_type := l_record_type||'N';
2552:
2553: IF P_PA_DEBUG_MODE = 'Y' THEN
2554: pa_fp_gen_amount_utils.fp_debug
2555: (p_msg => 'Before calling pji_fm_xbs_accum_tmp1',
2556: p_module_name => l_module_name,
2557: p_log_level => 5);
2558: END IF;

Line 2574: pa_fp_gen_amount_utils.fp_debug

2570:
2571: select count(*) into l_count from pji_fm_xbs_accum_tmp1;
2572:
2573: IF P_PA_DEBUG_MODE = 'Y' THEN
2574: pa_fp_gen_amount_utils.fp_debug
2575: (p_msg => 'After calling pji_fm_xbs_accum_tmp1,return status is: '||x_return_status,
2576: p_module_name => l_module_name,
2577: p_log_level => 5);
2578: END IF;

Line 2586: pa_fp_gen_amount_utils.fp_debug

2582: END IF;
2583:
2584: IF l_count = 0 THEN
2585: IF P_PA_DEBUG_MODE = 'Y' THEN
2586: pa_fp_gen_amount_utils.fp_debug
2587: (p_msg => 'no actual data ',
2588: p_module_name => l_module_name,
2589: p_log_level => 5);
2590: PA_DEBUG.RESET_CURR_FUNCTION;

Line 2614: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID (

2610: FROM pa_resource_lists_all_bg
2611: WHERE resource_list_id = l_fp_cols_rec.X_RESOURCE_LIST_ID;
2612:
2613: IF l_uncategorized_flag = 'Y' THEN
2614: l_rlm_id := PA_FP_GEN_AMOUNT_UTILS.GET_RLM_ID (
2615: p_project_id => p_project_id,
2616: p_resource_list_id => l_fp_cols_rec.X_RESOURCE_LIST_ID,
2617: p_resource_class_code => 'FINANCIAL_ELEMENTS' );
2618: UPDATE pji_fm_xbs_accum_tmp1

Line 2888: pa_fp_gen_amount_utils.fp_debug

2884: END IF;
2885: END LOOP;
2886:
2887: IF P_PA_DEBUG_MODE = 'Y' THEN
2888: pa_fp_gen_amount_utils.fp_debug
2889: (p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA',
2890: p_module_name => l_module_name,
2891: p_log_level => 5);
2892: END IF;

Line 2907: pa_fp_gen_amount_utils.fp_debug

2903: X_RETURN_STATUS => x_return_Status,
2904: X_MSG_COUNT => x_msg_count,
2905: X_MSG_DATA => x_msg_data );
2906: IF P_PA_DEBUG_MODE = 'Y' THEN
2907: pa_fp_gen_amount_utils.fp_debug
2908: (p_msg => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA,
2909: return status is: '||x_return_status,
2910: p_module_name => l_module_name,
2911: p_log_level => 5);

Line 2934: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2930: ,x_msg_data => l_msg_data
2931: );
2932:
2933: IF p_pa_debug_mode = 'Y' THEN
2934: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2935: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.' ||
2936: 'MAINTAIN_BUDGET_VERSION',
2937: P_MODULE_NAME => l_module_name);
2938: END IF;

Line 2949: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

2945: X_MSG_COUNT => x_msg_count,
2946: X_MSG_DATA => x_msg_data );
2947:
2948: IF p_pa_debug_mode = 'Y' THEN
2949: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2950: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.' ||
2951: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,
2952: P_MODULE_NAME => l_module_name);
2953: END IF;

Line 2986: pa_fp_gen_amount_utils.fp_debug

2982:
2983: x_return_status := FND_API.G_RET_STS_ERROR;
2984:
2985: IF P_PA_DEBUG_MODE = 'Y' THEN
2986: pa_fp_gen_amount_utils.fp_debug
2987: (p_msg => 'Invalid Arguments Passed',
2988: p_module_name => l_module_name,
2989: p_log_level => 5);
2990: PA_DEBUG.RESET_CURR_FUNCTION;

Line 3004: pa_fp_gen_amount_utils.fp_debug

3000: p_procedure_name => 'COLLECT_ACTUALS',
3001: p_error_text => substr(sqlerrm,1,240));
3002:
3003: IF P_PA_DEBUG_MODE = 'Y' THEN
3004: pa_fp_gen_amount_utils.fp_debug
3005: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
3006: p_module_name => l_module_name,
3007: p_log_level => 5);
3008: PA_DEBUG.RESET_CURR_FUNCTION;