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_WEBADI_UTILS dependencies on PA_FP_WEBADI_PKG

Line 10: G_TXN_CURRENCY_CODE_TBL PA_FP_WEBADI_PKG.l_txn_currency_code_tbl_typ ;

6: /***************************************************************/
7:
8: G_BUDGET_VERSION_ID pa_budget_versions.budget_version_id%TYPE := -99 ;
9: G_TABLE_POPULATED VARCHAR2(1) := 'N' ;
10: G_TXN_CURRENCY_CODE_TBL PA_FP_WEBADI_PKG.l_txn_currency_code_tbl_typ ;
11:
12:
13: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FP_WEBADI_UTILS';
14:

Line 1223: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895

1219:
1220: /* Bug 5350437: Commented the below API
1221: PROCEDURE GET_VERSION_PERIODS_INFO
1222: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1223: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895
1224: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895
1225: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895
1226: ,x_number_of_pds OUT NOCOPY pa_proj_period_profiles.number_of_periods%TYPE --File.Sql.39 bug 4440895
1227: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895

Line 1224: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895

1220: /* Bug 5350437: Commented the below API
1221: PROCEDURE GET_VERSION_PERIODS_INFO
1222: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1223: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895
1224: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895
1225: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895
1226: ,x_number_of_pds OUT NOCOPY pa_proj_period_profiles.number_of_periods%TYPE --File.Sql.39 bug 4440895
1227: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
1228: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1225: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895

1221: PROCEDURE GET_VERSION_PERIODS_INFO
1222: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1223: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895
1224: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895
1225: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895
1226: ,x_number_of_pds OUT NOCOPY pa_proj_period_profiles.number_of_periods%TYPE --File.Sql.39 bug 4440895
1227: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
1228: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1229: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1418: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.GET_VERSION_PERIOD_INFO');

1414: x_return_status := FND_API.G_RET_STS_SUCCESS;
1415: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
1416:
1417: IF l_debug_mode = 'Y' THEN
1418: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.GET_VERSION_PERIOD_INFO');
1419: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1420: END IF;
1421:
1422: IF l_debug_mode = 'Y' THEN

Line 1423: pa_debug.g_err_stage := ':In PA_FP_WEBADI_PKG.GET_VERSION_PERIOD_INFO' ;

1419: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1420: END IF;
1421:
1422: IF l_debug_mode = 'Y' THEN
1423: pa_debug.g_err_stage := ':In PA_FP_WEBADI_PKG.GET_VERSION_PERIOD_INFO' ;
1424: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1425: END IF;
1426:
1427: IF (p_budget_version_id IS NULL) THEN

Line 1663: ( p_pkg_name => 'PA_FP_WEBADI_PKG'

1659: CLOSE C_PERIOD_DATES_CUR ;
1660: END IF ;
1661:
1662: FND_MSG_PUB.add_exc_msg
1663: ( p_pkg_name => 'PA_FP_WEBADI_PKG'
1664: ,p_procedure_name => 'GET_VERSION_PERIOD_INFO' );
1665: IF l_debug_mode = 'Y' THEN
1666: pa_debug.write('DELETE_XFACE' || g_module_name,SQLERRM,4);
1667: pa_debug.write('DELETE_XFACE' || g_module_name,pa_debug.G_Err_Stack,4);

Line 1728: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.CHECK_OVERLAPPING_DATES');

1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
1726:
1727: IF l_debug_mode = 'Y' THEN
1728: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.CHECK_OVERLAPPING_DATES');
1729: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1730: END IF;
1731:
1732: IF l_debug_mode = 'Y' THEN

Line 1733: pa_debug.g_err_stage := ':In PA_FP_WEBADI_PKG.CHECK_OVERLAPPING_DATES' ;

1729: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1730: END IF;
1731:
1732: IF l_debug_mode = 'Y' THEN
1733: pa_debug.g_err_stage := ':In PA_FP_WEBADI_PKG.CHECK_OVERLAPPING_DATES' ;
1734: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1735: END IF;
1736:
1737: IF (p_budget_version_id IS NULL) THEN

Line 1822: ( p_pkg_name => 'PA_FP_WEBADI_PKG'

1818: CLOSE C_OVERLAPPING_CUR ;
1819: END IF ;
1820:
1821: FND_MSG_PUB.add_exc_msg
1822: ( p_pkg_name => 'PA_FP_WEBADI_PKG'
1823: ,p_procedure_name => 'C_OVERLAPPING_CUR' );
1824: IF l_debug_mode = 'Y' THEN
1825: pa_debug.write('check_overlapping_dates' || g_module_name,SQLERRM,4);
1826: pa_debug.write('check_overlapping_dates' || g_module_name,pa_debug.G_Err_Stack,4);

Line 2488: pa_debug.g_err_stage:='Calling PA_FP_WEBADI_PKG.delete_xface';

2484: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2485: END;
2486:
2487: IF l_debug_mode = 'Y' THEN
2488: pa_debug.g_err_stage:='Calling PA_FP_WEBADI_PKG.delete_xface';
2489: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2490: END IF;
2491:
2492: PA_FP_WEBADI_PKG.delete_xface

Line 2492: PA_FP_WEBADI_PKG.delete_xface

2488: pa_debug.g_err_stage:='Calling PA_FP_WEBADI_PKG.delete_xface';
2489: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2490: END IF;
2491:
2492: PA_FP_WEBADI_PKG.delete_xface
2493: ( p_run_id => l_run_id
2494: ,x_return_status => x_return_status
2495: ,x_msg_count => x_msg_count
2496: ,x_msg_data => x_msg_data);

Line 2500: pa_debug.g_err_stage := 'Call to PA_FP_WEBADI_PKG.delete_xface returned with error';

2496: ,x_msg_data => x_msg_data);
2497:
2498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2499: IF l_debug_mode = 'Y' THEN
2500: pa_debug.g_err_stage := 'Call to PA_FP_WEBADI_PKG.delete_xface returned with error';
2501: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2502: END IF;
2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2504: END IF;

Line 2507: pa_debug.g_err_stage:='PA_FP_WEBADI_PKG.delete_xface Called';

2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2504: END IF;
2505:
2506: IF l_debug_mode = 'Y' THEN
2507: pa_debug.g_err_stage:='PA_FP_WEBADI_PKG.delete_xface Called';
2508: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2509: pa_debug.g_err_stage:='Updating pa_budget_versions';
2510: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2511: END IF;