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

Line 148: pa_fp_gen_amount_utils.fp_debug

144: END IF;
145:
146: --Calling the conv_mc_bulk api
147: IF p_pa_debug_mode = 'Y' THEN
148: pa_fp_gen_amount_utils.fp_debug
149: (p_msg => 'Before calling
150: pa_fp_multi_currency_pkg.conv_mc_bulk',
151: p_module_name => l_module_name,
152: p_log_level => 5);

Line 297: pa_fp_gen_amount_utils.fp_debug

293: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
294: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
295: END IF;
296: IF p_pa_debug_mode = 'Y' THEN
297: pa_fp_gen_amount_utils.fp_debug
298: (p_msg => 'Status after calling
299: pa_fp_multi_currency_pkg.conv_mc_bulk: '
300: ||x_return_status,
301: p_module_name => l_module_name,

Line 408: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

404:
405: PROCEDURE GEN_BILLING_AMOUNTS
406: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
407: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
408: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
409: P_ETC_START_DATE IN
410: PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
411: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
412: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 705: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

701: l_TXN_RBS_ELEMENT_ID_tab(bb) := null;
702: END LOOP;
703: --dbms_output.put_line('l_TXN_SOURCE_ID_tab.count: '||l_TXN_SOURCE_ID_tab.count);
704: IF P_PA_DEBUG_MODE = 'Y' THEN
705: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
706: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
707: P_MODULE_NAME => l_module_name);
708: END IF;
709: PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS (

Line 759: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

755: X_RETURN_STATUS => x_return_status,
756: X_MSG_COUNT => x_msg_count,
757: X_MSG_DATA => x_msg_data );
758: IF P_PA_DEBUG_MODE = 'Y' THEN
759: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
760: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
761: x_return_status,
762: P_MODULE_NAME => l_module_name);
763: END IF;

Line 788: pa_fp_gen_amount_utils.fp_debug

784: -- hr_utility.trace('tmp4 count aft mapping api call '||l_count);
785: --dbms_output.put_line('tmp4 count :'||l_count);
786: /* Calling the API to get the resource_assignment_id */
787: IF p_pa_debug_mode = 'Y' THEN
788: pa_fp_gen_amount_utils.fp_debug
789: (p_msg => 'Before calling
790: pa_fp_gen_budget_amt_pub.create_res_asg',
791: p_module_name => l_module_name,
792: p_log_level => 5);

Line 812: pa_fp_gen_amount_utils.fp_debug

808:
809: /* Calling the API to update the tmp4
810: table with resource_assignment_id */
811: IF p_pa_debug_mode = 'Y' THEN
812: pa_fp_gen_amount_utils.fp_debug
813: (p_msg => 'Before calling
814: pa_fp_gen_budget_amt_pub.update_res_asg',
815: p_module_name => l_module_name,
816: p_log_level => 5);

Line 831: pa_fp_gen_amount_utils.fp_debug

827: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
828: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
829: END IF;
830: IF p_pa_debug_mode = 'Y' THEN
831: pa_fp_gen_amount_utils.fp_debug
832: (p_msg => 'Status after calling
833: pa_fp_gen_budget_amt_pub.update_res_asg'
834: ||x_return_status,
835: p_module_name => l_module_name,

Line 843: pa_fp_gen_amount_utils.fp_debug

839: '||X_RETURN_STATUS);*/
840:
841: /* Calling Del manual bdgt lines api
842: IF p_pa_debug_mode = 'Y' THEN
843: pa_fp_gen_amount_utils.fp_debug
844: (p_msg => 'Before calling
845: pa_fp_gen_budget_amt_pub.del_manual_bdgt_lines',
846: p_module_name => l_module_name,
847: p_log_level => 5);

Line 861: pa_fp_gen_amount_utils.fp_debug

857: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
858: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
859: END IF;
860: IF p_pa_debug_mode = 'Y' THEN
861: pa_fp_gen_amount_utils.fp_debug
862: (p_msg => 'Status after calling
863: pa_fp_gen_budget_amt_pub.del_manual_bdgt_lines'
864: ||x_return_status,
865: p_module_name => l_module_name,

Line 873: pa_fp_gen_amount_utils.fp_debug

869: -- '||X_RETURN_STATUS);
870:
871: --Calling get generated res asg api
872: IF p_pa_debug_mode = 'Y' THEN
873: pa_fp_gen_amount_utils.fp_debug
874: (p_msg => 'Before calling
875: pa_fp_gen_budget_amt_pub.get_generated_res_asg',
876: p_module_name => l_module_name,
877: p_log_level => 5);

Line 891: pa_fp_gen_amount_utils.fp_debug

887: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
888: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
889: END IF;
890: IF p_pa_debug_mode = 'Y' THEN
891: pa_fp_gen_amount_utils.fp_debug
892: (p_msg => 'Status after calling
893: pa_fp_gen_budget_amt_pub.get_generated_res_asg'
894: ||x_return_status,
895: p_module_name => l_module_name,

Line 974: pa_fp_gen_amount_utils.fp_debug

970: l_curr_code := p_fp_cols_rec.x_projfunc_currency_code;
971:
972: --Calling the convert_currency_code api
973: IF p_pa_debug_mode = 'Y' THEN
974: pa_fp_gen_amount_utils.fp_debug
975: (p_msg => 'Before calling
976: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC',
977: p_module_name => l_module_name,
978: p_log_level => 5);

Line 1005: pa_fp_gen_amount_utils.fp_debug

1001: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1002: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1003: END IF;
1004: IF p_pa_debug_mode = 'Y' THEN
1005: pa_fp_gen_amount_utils.fp_debug
1006: (p_msg => 'Status after calling
1007: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC:'
1008: ||x_return_status,
1009: p_module_name => l_module_name,

Line 1178: pa_fp_gen_amount_utils.fp_debug

1174: dbms_output.put_line('No.of records updated into
1175: bdgt lines table: '||l_ucount);*/
1176: IF P_FP_COLS_REC.X_PLAN_IN_MULTI_CURR_FLAG = 'Y' THEN
1177: IF p_pa_debug_mode = 'Y' THEN
1178: pa_fp_gen_amount_utils.fp_debug
1179: (p_msg => 'Before calling
1180: pa_fp_gen_budget_amt_pub.insert_txn_currency',
1181: p_module_name => l_module_name,
1182: p_log_level => 5);

Line 1195: pa_fp_gen_amount_utils.fp_debug

1191: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1192: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1193: END IF;
1194: IF p_pa_debug_mode = 'Y' THEN
1195: pa_fp_gen_amount_utils.fp_debug
1196: (p_msg => 'Status after calling
1197: pa_fp_gen_budget_amt_pub.insert_txn_currency'
1198: ||x_return_status,
1199: p_module_name => l_module_name,

Line 1208: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1204: END IF;
1205:
1206: -- Added 11/30/2004 by dkuo to synch billing event dates
1207: IF p_pa_debug_mode = 'Y' THEN
1208: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1209: ( p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1210: 'SYNC_UP_PLANNING_DATES',
1211: p_module_name => l_module_name,
1212: p_log_level => 5 );

Line 1221: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1217: X_RETURN_STATUS => x_return_Status,
1218: X_MSG_COUNT => x_msg_count,
1219: X_MSG_DATA => x_msg_data );
1220: IF p_pa_debug_mode = 'Y' THEN
1221: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1222: ( p_msg => 'Aft calling PA_FP_MAINTAIN_ACTUAL_PUB.' ||
1223: 'SYNC_UP_PLANNING_DATES return status ' ||
1224: x_return_status,
1225: p_module_name => l_module_name,

Line 1309: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1305: END IF;
1306:
1307: -- CALL the maintenance api in INSERT mode
1308: IF p_pa_debug_mode = 'Y' THEN
1309: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1310: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
1311: 'MAINTAIN_DATA',
1312: --P_CALLED_MODE => p_called_mode,
1313: P_MODULE_NAME => l_module_name);

Line 1325: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1321: X_RETURN_STATUS => x_return_status,
1322: X_MSG_COUNT => x_msg_count,
1323: X_MSG_DATA => x_msg_data );
1324: IF p_pa_debug_mode = 'Y' THEN
1325: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1326: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
1327: 'MAINTAIN_DATA: '||x_return_status,
1328: --P_CALLED_MODE => p_called_mode,
1329: P_MODULE_NAME => l_module_name);

Line 1387: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1383:
1384: PROCEDURE GET_BILLING_EVENT_AMT_IN_PFC
1385: (P_PROJECT_ID IN pa_projects_all.project_id%type,
1386: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%type,
1387: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1388: P_PROJFUNC_CURRENCY_CODE IN pa_projects_all.projfunc_currency_code%type,
1389: P_PROJECT_CURRENCY_CODE IN pa_projects_all.project_currency_code%type,
1390: X_PROJFUNC_REVENUE OUT NOCOPY NUMBER,
1391: X_PROJECT_REVENUE OUT NOCOPY NUMBER,

Line 1487: pa_fp_gen_amount_utils.fp_debug

1483: ELSIF p_fp_cols_rec.x_gen_ret_manual_line_flag = 'Y' THEN
1484: -- Call the Billing Events mapping API wrapper to populate the tm4
1485: -- table with the mapping from billing events to target resources.
1486: IF p_pa_debug_mode = 'Y' THEN
1487: pa_fp_gen_amount_utils.fp_debug
1488: ( p_msg => 'Before calling pa_fp_gen_billing_amounts.
1489: MAP_BILLING_EVENT_RLMI_RBS',
1490: p_module_name => l_module_name,
1491: p_log_level => 5 );

Line 1506: pa_fp_gen_amount_utils.fp_debug

1502: X_RETURN_STATUS => x_return_status,
1503: X_MSG_COUNT => x_msg_count,
1504: X_MSG_DATA => x_msg_data );
1505: IF p_pa_debug_mode = 'Y' THEN
1506: pa_fp_gen_amount_utils.fp_debug
1507: ( p_msg => 'Status after calling pa_fp_gen_billing_amounts.
1508: MAP_BILLING_EVENT_RLMI_RBS:'
1509: ||x_return_status,
1510: p_module_name => l_module_name,

Line 1530: pa_fp_gen_amount_utils.fp_debug

1526:
1527: -- Call API to update tmp4 with txn_resource_assignment_ids and to
1528: -- clear records for manually added resources from the tmp4 table.
1529: IF p_pa_debug_mode = 'Y' THEN
1530: pa_fp_gen_amount_utils.fp_debug
1531: ( p_msg => 'Before calling pa_fp_gen_billing_amounts.
1532: UPD_TMP4_TXN_RA_ID_AND_ML',
1533: p_module_name => l_module_name,
1534: p_log_level => 5 );

Line 1545: pa_fp_gen_amount_utils.fp_debug

1541: X_RETURN_STATUS => x_return_status,
1542: X_MSG_COUNT => x_msg_count,
1543: X_MSG_DATA => x_msg_data );
1544: IF p_pa_debug_mode = 'Y' THEN
1545: pa_fp_gen_amount_utils.fp_debug
1546: ( p_msg => 'Status after calling pa_fp_gen_billing_amounts.
1547: UPD_TMP4_TXN_RA_ID_AND_ML:'
1548: ||x_return_status,
1549: p_module_name => l_module_name,

Line 1618: pa_fp_gen_amount_utils.fp_debug

1614: END IF;
1615:
1616: IF l_conversion_required_flag = 'Y' THEN
1617: IF p_pa_debug_mode = 'Y' THEN
1618: pa_fp_gen_amount_utils.fp_debug
1619: (p_msg => 'Before calling
1620: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC',
1621: p_module_name => l_module_name,
1622: p_log_level => 5);

Line 1646: pa_fp_gen_amount_utils.fp_debug

1642: X_RETURN_STATUS => x_return_status,
1643: X_MSG_COUNT => x_MSG_COUNT,
1644: X_MSG_DATA => x_MSG_DATA);
1645: IF p_pa_debug_mode = 'Y' THEN
1646: pa_fp_gen_amount_utils.fp_debug
1647: (p_msg => 'Status after calling
1648: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC:'
1649: ||x_return_status,
1650: p_module_name => l_module_name,

Line 1685: pa_fp_gen_amount_utils.fp_debug

1681: ROLLBACK;
1682:
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: IF P_PA_DEBUG_MODE = 'Y' THEN
1685: pa_fp_gen_amount_utils.fp_debug
1686: (p_msg => 'Invalid Arguments Passed',
1687: p_module_name => l_module_name,
1688: p_log_level => 5);
1689: PA_DEBUG.Reset_Curr_Function;

Line 1700: pa_fp_gen_amount_utils.fp_debug

1696: FND_MSG_PUB.add_exc_msg
1697: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS',
1698: p_procedure_name => 'GET_BILLING_EVENT_AMT_IN_PFC');
1699: IF P_PA_DEBUG_MODE = 'Y' THEN
1700: pa_fp_gen_amount_utils.fp_debug
1701: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1702: p_module_name => l_module_name,
1703: p_log_level => 5);
1704: PA_DEBUG.Reset_Curr_Function;

Line 1723: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1719: */
1720: PROCEDURE MAP_BILLING_EVENT_RLMI_RBS
1721: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1722: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1723: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1724: X_TXN_SOURCE_ID_COUNT OUT NOCOPY NUMBER,
1725: X_TXN_SOURCE_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1726: X_RES_LIST_MEMBER_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
1727: X_RBS_ELEMENT_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 1855: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1851: l_TXN_RBS_ELEMENT_ID_tab(bb) := null;
1852: END LOOP;
1853: --dbms_output.put_line('l_TXN_SOURCE_ID_tab.count: '||l_TXN_SOURCE_ID_tab.count);
1854: IF P_PA_DEBUG_MODE = 'Y' THEN
1855: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1856: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
1857: P_MODULE_NAME => l_module_name);
1858: END IF;
1859: PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS (

Line 1909: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1905: X_RETURN_STATUS => x_return_status,
1906: X_MSG_COUNT => x_msg_count,
1907: X_MSG_DATA => x_msg_data );
1908: IF P_PA_DEBUG_MODE = 'Y' THEN
1909: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1910: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
1911: x_return_status,
1912: P_MODULE_NAME => l_module_name);
1913: END IF;

Line 1996: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1992: */
1993: PROCEDURE UPD_TMP4_TXN_RA_ID_AND_ML
1994: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1995: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1996: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1997: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
1998: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
1999: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2000: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2169: pa_fp_gen_amount_utils.fp_debug

2165:
2166: --@@
2167: IF P_PA_DEBUG_MODE = 'Y' THEN
2168: for i in 1..l_res_assgn_id_tab.count loop
2169: pa_fp_gen_amount_utils.fp_debug
2170: (p_msg => 'within update when share partial and planning at lowest task i:'
2171: ||i||'; ra id in cursor:'||l_res_assgn_id_tab(i)
2172: ||';rlm id in cursor:'||l_rlm_id_tab(i)
2173: ||';task id in cursor:'||l_txn_task_id_tab(i)

Line 2289: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

2285: FROM pa_budget_lines bl
2286: WHERE bl.resource_assignment_id = ra.resource_assignment_id
2287: AND rownum = 1 ));
2288: ELSIF p_fp_cols_rec.x_plan_class_code = 'FORECAST' THEN
2289: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
2290: ( p_budget_version_id );
2291: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
2292: DELETE FROM pa_res_list_map_tmp4 tmp
2293: WHERE EXISTS