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_VIEW_PLANS_PUB dependencies on FND_API

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144:
145: BEGIN
146: --hr_utility.trace_on(null, 'dlai');
147: --hr_utility.trace('STARTING');
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149: -- x_primary_pp_bv_id := p_orgfcst_version_id;
150: pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID := p_orgfcst_version_id;
151: pa_fp_view_plans_pub.G_AMT_OR_PD := p_amt_or_pd; -- this will be used by other procedures
152:

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: fin_plan_option_level_code='PLAN_TYPE';
213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: --hr_utility.trace('no_data_found 1');
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: x_msg_count := 1;
218: x_msg_data := SQLERRM;
219: FND_MSG_PUB.add_exc_msg
220: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

453: where pbv.budget_version_id = p_orgfcst_version_id
454: and pbv.period_profile_id = pp.period_profile_id;
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: x_msg_count := 1;
459: x_msg_data := SQLERRM;
460: FND_MSG_PUB.add_exc_msg
461: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 628: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

624: x_return_status => l_return_status,
625: x_msg_count => l_msg_count,
626: x_msg_data => l_msg_data );
627: -- if view_plan_temp_tables fails, error out right away
628: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: x_msg_count := FND_MSG_PUB.Count_Msg;
631: if x_msg_count = 1 then
632: PA_INTERFACE_UTILS_PUB.get_messages

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: x_msg_count => l_msg_count,
626: x_msg_data => l_msg_data );
627: -- if view_plan_temp_tables fails, error out right away
628: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: x_msg_count := FND_MSG_PUB.Count_Msg;
631: if x_msg_count = 1 then
632: PA_INTERFACE_UTILS_PUB.get_messages
633: (p_encoded => FND_API.G_TRUE,

Line 633: (p_encoded => FND_API.G_TRUE,

629: x_return_status := FND_API.G_RET_STS_ERROR;
630: x_msg_count := FND_MSG_PUB.Count_Msg;
631: if x_msg_count = 1 then
632: PA_INTERFACE_UTILS_PUB.get_messages
633: (p_encoded => FND_API.G_TRUE,
634: p_msg_index => 1,
635: p_data => x_msg_data,
636: p_msg_index_out => l_msg_index_out);
637: end if;

Line 928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

924: --hr_utility.trace('x_rev_rv_number= ' || TO_CHAR(x_rev_rv_number));
925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: x_msg_count := 1;
930: x_msg_data := SQLERRM;
931: FND_MSG_PUB.add_exc_msg
932: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 1088: x_return_status := FND_API.G_RET_STS_SUCCESS;

1084: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1085:
1086: BEGIN
1087: x_msg_count := 0;
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089:
1090: -- GET AUTO BASELINED FLAG
1091: x_auto_baselined_flag :=
1092: Pa_Fp_Control_Items_Utils.IsFpAutoBaselineEnabled(p_project_id);

Line 1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1573: fin_plan_option_level_code='PLAN_TYPE';
1574: EXCEPTION
1575: WHEN NO_DATA_FOUND THEN
1576: --hr_utility.trace('no_data_found 1');
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: x_msg_count := 1;
1579: x_msg_data := SQLERRM;
1580: FND_MSG_PUB.add_exc_msg
1581: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1731: where pbv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID
1732: and pp.period_profile_id = pbv.period_profile_id;
1733: EXCEPTION
1734: WHEN NO_DATA_FOUND THEN
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736: x_msg_count := 1;
1737: x_msg_data := SQLERRM;
1738: FND_MSG_PUB.add_exc_msg
1739: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 1871: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1867: x_return_status => l_return_status,
1868: x_msg_count => l_msg_count,
1869: x_msg_data => l_msg_data );
1870: -- if view_plan_temp_tables fails, error out right away
1871: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: x_msg_count := FND_MSG_PUB.Count_Msg;
1874: if x_msg_count = 1 then
1875: PA_INTERFACE_UTILS_PUB.get_messages

Line 1872: x_return_status := FND_API.G_RET_STS_ERROR;

1868: x_msg_count => l_msg_count,
1869: x_msg_data => l_msg_data );
1870: -- if view_plan_temp_tables fails, error out right away
1871: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: x_msg_count := FND_MSG_PUB.Count_Msg;
1874: if x_msg_count = 1 then
1875: PA_INTERFACE_UTILS_PUB.get_messages
1876: (p_encoded => FND_API.G_TRUE,

Line 1876: (p_encoded => FND_API.G_TRUE,

1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: x_msg_count := FND_MSG_PUB.Count_Msg;
1874: if x_msg_count = 1 then
1875: PA_INTERFACE_UTILS_PUB.get_messages
1876: (p_encoded => FND_API.G_TRUE,
1877: p_msg_index => 1,
1878: p_data => x_msg_data,
1879: p_msg_index_out => l_msg_index_out);
1880: end if;

Line 2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2016: */
2017:
2018: EXCEPTION
2019: WHEN OTHERS THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: x_msg_count := 1;
2022: x_msg_data := SQLERRM;
2023: FND_MSG_PUB.add_exc_msg
2024: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 2048: x_return_status := FND_API.G_RET_STS_SUCCESS;

2044: l_start_date VARCHAR2(30);
2045:
2046: BEGIN
2047:
2048: x_return_status := FND_API.G_RET_STS_SUCCESS;
2049:
2050: pa_fp_view_plans_pub.G_FP_AMOUNT_TYPE_CODE := p_amount_type_code;
2051: pa_fp_view_plans_pub.G_FP_RA_ID := p_resource_assignment_id;
2052: l_budget_version_id := p_budget_version_id;

Line 2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2060: x_msg_count => l_msg_count,
2061: x_msg_data => l_msg_data);
2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: x_msg_count := 1;
2066: x_msg_data := SQLERRM;
2067: FND_MSG_PUB.add_exc_msg
2068: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 2096: x_return_status := FND_API.G_RET_STS_SUCCESS;

2092: )
2093: where rownum <= l_rownum;
2094:
2095: BEGIN
2096: x_return_status := FND_API.G_RET_STS_SUCCESS;
2097: /* Bug Fix 4373890
2098: Adding a format mask for the GSCC file.Date.5 fix
2099: */
2100: l_start_date := to_date(p_period_start_date,'YYYY/MM/DD');

Line 2738: x_return_status := FND_API.G_RET_STS_SUCCESS;

2734: --hr_utility.trace_on(null, 'dlai');
2735: --hr_utility.trace('entered view_plan_temp_tables');
2736: --hr_utility.trace('p_budget_version_id= ' || TO_CHAR(p_budget_version_id));
2737: x_msg_count := 0;
2738: x_return_status := FND_API.G_RET_STS_SUCCESS;
2739: SAVEPOINT VIEW_PLAN_TEMP_TABLES;
2740: l_diff_pd_profile_flag := 'N';
2741:
2742: -- FOR ADVANCED DISPLAY OPTIONS CUSTOMIZATION: USER-SELECTED BUDGET VERSIONS

Line 3599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3595: EXCEPTION
3596: when others then
3597: --hr_utility.trace('UNHANDLED EXCEPTION');
3598: rollback to VIEW_PLAN_TEMP_TABLES;
3599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3600: x_msg_count := 1;
3601: x_msg_data := SQLERRM;
3602: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
3603: p_procedure_name => 'view_plan_temp_tables');

Line 3605: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3601: x_msg_data := SQLERRM;
3602: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
3603: p_procedure_name => 'view_plan_temp_tables');
3604: pa_debug.reset_err_stack;
3605: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3606:
3607: end; -- procedure view_plan_temp_tables
3608: /* --------------------------------------------------------------------- */
3609:

Line 3831: x_return_status := FND_API.G_RET_STS_SUCCESS;

3827: begin
3828: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_separate', '100: entering procedure', 2);
3829: l_err_stage := 100;
3830: --hr_utility.trace('entered pa_fp_vp_pop_tables_separate');
3831: x_return_status := FND_API.G_RET_STS_SUCCESS;
3832: x_msg_count := 0;
3833: SAVEPOINT VIEW_PLANS_POP_TABLES_SEP;
3834:
3835: -- used to query pa_proj_periods_denorm table

Line 6224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6220: EXCEPTION
6221: when others then
6222: rollback to VIEW_PLANS_POP_TABLES_SEP;
6223: --hr_utility.trace('error stage= ' || to_char(l_err_stage));
6224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6225: x_msg_count := 1;
6226: x_msg_data := SQLERRM;
6227: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
6228: p_procedure_name => 'pa_fp_vp_pop_tables_separate');

Line 6410: x_return_status := FND_API.G_RET_STS_SUCCESS;

6406: --hr_utility.trace_on(null, 'dlai');
6407: l_err_stage := 100;
6408: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_together', '100: entering pa_fp_vp_pop_tables_together', 2);
6409: --hr_utility.trace('entered pa_fp_vp_pop_tables_together: 100');
6410: x_return_status := FND_API.G_RET_STS_SUCCESS;
6411: x_msg_count := 0;
6412: SAVEPOINT VIEW_PLANS_POP_TABLES_SAME;
6413:
6414: -- used to query pa_proj_periods_denorm table

Line 7304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7300: EXCEPTION
7301: when others then
7302: rollback to VIEW_PLANS_POP_TABLES_SAME;
7303: --hr_utility.trace('l_err_stage= ' || to_char(l_err_stage));
7304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7305: x_msg_count := 1;
7306: x_msg_data := SQLERRM;
7307: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
7308: p_procedure_name => 'View_Plans_Pop_Tables_Tog');

Line 7525: x_return_status := FND_API.G_RET_STS_SUCCESS;

7521: --hr_utility.trace_on(null, 'dlai');
7522: l_err_stage := 100;
7523: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_single', '100: entering procedure', 2);
7524: --hr_utility.trace('entered pa_fp_vp_pop_tables_single:100');
7525: x_return_status := FND_API.G_RET_STS_SUCCESS;
7526: x_msg_count := 0;
7527: SAVEPOINT VIEW_PLANS_POP_TABLES_SINGLE;
7528: -- used to query pa_proj_periods_denorm table
7529: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,

Line 8969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8965: EXCEPTION
8966: when others then
8967: rollback to VIEW_PLANS_POP_TABLES_SINGLE;
8968: --hr_utility.trace('l_err_stage= ' || to_char(l_err_stage));
8969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8970: x_msg_count := 1;
8971: x_msg_data := SQLERRM;
8972: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
8973: p_procedure_name => 'View_Plans_Pop_Tables_Single');