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_BILLING_AMOUNTS

Line 1: PACKAGE body PA_FP_GEN_BILLING_AMOUNTS as

1: PACKAGE body PA_FP_GEN_BILLING_AMOUNTS as
2: /* $Header: PAFPGABB.pls 120.5 2007/02/06 09:54:47 dthakker ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 52: 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC';

48: X_MSG_COUNT OUT NOCOPY NUMBER,
49: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
50:
51: l_module_name VARCHAR2(200) :=
52: 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC';
53:
54: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 394: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'

390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: x_msg_data := SUBSTR(SQLERRM,1,240);
393: FND_MSG_PUB.add_exc_msg
394: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
395: ,p_procedure_name => 'CONVERT_TXN_AMT_TO_PC_PFC');
396:
397: IF P_PA_DEBUG_MODE = 'Y' THEN
398: PA_DEBUG.Reset_curr_function;

Line 417: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.GEN_BILLING_AMOUNTS';

413: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
414: X_MSG_COUNT OUT NOCOPY NUMBER,
415: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
416:
417: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.GEN_BILLING_AMOUNTS';
418:
419: --Cursor used to sum the revenue amount
420: CURSOR SUM_BILL_CRSR(c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
421: c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE,

Line 976: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC',

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);
979: END IF;
980: PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC

Line 980: PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC

976: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC',
977: p_module_name => l_module_name,
978: p_log_level => 5);
979: END IF;
980: PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC
981: (P_PROJECT_ID => p_project_id,
982: P_BUDGET_VERSION_ID => p_budget_version_id,
983: P_RES_ASG_ID => l_resource_asg_id,
984: P_START_DATE => l_start_date,

Line 1007: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC:'

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,
1010: p_log_level => 5);
1011: END IF;

Line 1373: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'

1369: WHEN OTHERS THEN
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: x_msg_data := SUBSTR(SQLERRM,1,240);
1372: FND_MSG_PUB.add_exc_msg
1373: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
1374: ,p_procedure_name => 'GEN_BILLING_AMOUNTS');
1375:
1376: IF P_PA_DEBUG_MODE = 'Y' THEN
1377: PA_DEBUG.Reset_curr_function;

Line 1396: 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.GET_BILLING_EVENT_AMT_IN_PFC';

1392: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1393: X_MSG_COUNT OUT NOCOPY NUMBER,
1394: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1395: l_module_name VARCHAR2(200) :=
1396: 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.GET_BILLING_EVENT_AMT_IN_PFC';
1397: l_event_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1398: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1399: l_txn_rev_amt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1400: l_projfunc_rev_amt_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1488: ( p_msg => 'Before calling pa_fp_gen_billing_amounts.

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 );
1492: END IF;

Line 1493: PA_FP_GEN_BILLING_AMOUNTS.MAP_BILLING_EVENT_RLMI_RBS

1489: MAP_BILLING_EVENT_RLMI_RBS',
1490: p_module_name => l_module_name,
1491: p_log_level => 5 );
1492: END IF;
1493: PA_FP_GEN_BILLING_AMOUNTS.MAP_BILLING_EVENT_RLMI_RBS
1494: ( P_PROJECT_ID => p_project_id,
1495: P_BUDGET_VERSION_ID => p_budget_version_id,
1496: P_FP_COLS_REC => p_fp_cols_rec,
1497: X_TXN_SOURCE_ID_COUNT => l_txn_source_id_count,

Line 1507: ( p_msg => 'Status after calling pa_fp_gen_billing_amounts.

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,
1511: p_log_level => 5 );

Line 1531: ( p_msg => 'Before calling pa_fp_gen_billing_amounts.

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 );
1535: END IF;

Line 1536: PA_FP_GEN_BILLING_AMOUNTS.UPD_TMP4_TXN_RA_ID_AND_ML

1532: UPD_TMP4_TXN_RA_ID_AND_ML',
1533: p_module_name => l_module_name,
1534: p_log_level => 5 );
1535: END IF;
1536: PA_FP_GEN_BILLING_AMOUNTS.UPD_TMP4_TXN_RA_ID_AND_ML
1537: ( P_PROJECT_ID => p_project_id,
1538: P_BUDGET_VERSION_ID => p_budget_version_id,
1539: P_FP_COLS_REC => p_fp_cols_rec,
1540: P_GEN_SRC_CODE => 'BILLING_EVENTS',

Line 1546: ( p_msg => 'Status after calling pa_fp_gen_billing_amounts.

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,
1550: p_log_level => 5 );

Line 1620: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC',

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);
1623: END IF;
1624: PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC

Line 1624: PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC

1620: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC',
1621: p_module_name => l_module_name,
1622: p_log_level => 5);
1623: END IF;
1624: PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC
1625: (P_PROJECT_ID => P_PROJECT_ID,
1626: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1627: P_RES_ASG_ID => NULL,
1628: P_START_DATE => l_event_date_tab(i),

Line 1648: pa_fp_gen_billing_amounts.CONVERT_TXN_AMT_TO_PC_PFC:'

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,
1651: p_log_level => 5);
1652: END IF;

Line 1697: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS',

1693: WHEN OTHERS THEN
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: x_msg_data := SUBSTR(SQLERRM,1,240);
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),

Line 1733: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.MAP_BILLING_EVENT_RLMI_RBS';

1729: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1730: X_MSG_COUNT OUT NOCOPY NUMBER,
1731: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1732:
1733: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.MAP_BILLING_EVENT_RLMI_RBS';
1734:
1735: l_ret_status VARCHAR2(100);
1736: l_msg_count NUMBER;
1737: l_msg_data VARCHAR2(2000);

Line 1968: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'

1964: WHEN OTHERS THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: x_msg_data := SUBSTR(SQLERRM,1,240);
1967: FND_MSG_PUB.add_exc_msg
1968: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
1969: ,p_procedure_name => 'MAP_BILLING_EVENT_RLMI_RBS');
1970:
1971: IF P_PA_DEBUG_MODE = 'Y' THEN
1972: PA_DEBUG.Reset_curr_function;

Line 2003: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.UPD_TMP4_TXN_RA_ID_AND_ML';

1999: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2000: X_MSG_COUNT OUT NOCOPY NUMBER,
2001: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2002:
2003: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.UPD_TMP4_TXN_RA_ID_AND_ML';
2004:
2005: l_etc_start_date DATE;
2006: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
2007:

Line 2358: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'

2354: WHEN OTHERS THEN
2355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2356: x_msg_data := SUBSTR(SQLERRM,1,240);
2357: FND_MSG_PUB.add_exc_msg
2358: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
2359: ,p_procedure_name => 'UPD_TMP4_TXN_RA_ID_AND_ML');
2360:
2361: IF P_PA_DEBUG_MODE = 'Y' THEN
2362: PA_DEBUG.Reset_curr_function;

Line 2370: END PA_FP_GEN_BILLING_AMOUNTS;

2366:
2367: END UPD_TMP4_TXN_RA_ID_AND_ML;
2368:
2369:
2370: END PA_FP_GEN_BILLING_AMOUNTS;