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.

[Home] [Help]

APPS.PA_FP_VIEW_PLANS_PUB dependencies on FND_API

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: fin_plan_option_level_code='PLAN_TYPE';
472:
473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: x_msg_count := 1;
477: x_msg_data := SQLERRM;
478: FND_MSG_PUB.add_exc_msg
479: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 699: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

695: x_return_status => l_return_status,
696: x_msg_count => l_msg_count,
697: x_msg_data => l_msg_data );
698: -- if view_plan_temp_tables fails, error out right away
699: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: x_msg_count := FND_MSG_PUB.Count_Msg;
702: if x_msg_count = 1 then
703: PA_INTERFACE_UTILS_PUB.get_messages

Line 700: x_return_status := FND_API.G_RET_STS_ERROR;

696: x_msg_count => l_msg_count,
697: x_msg_data => l_msg_data );
698: -- if view_plan_temp_tables fails, error out right away
699: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: x_msg_count := FND_MSG_PUB.Count_Msg;
702: if x_msg_count = 1 then
703: PA_INTERFACE_UTILS_PUB.get_messages
704: (p_encoded => FND_API.G_TRUE,

Line 704: (p_encoded => FND_API.G_TRUE,

700: x_return_status := FND_API.G_RET_STS_ERROR;
701: x_msg_count := FND_MSG_PUB.Count_Msg;
702: if x_msg_count = 1 then
703: PA_INTERFACE_UTILS_PUB.get_messages
704: (p_encoded => FND_API.G_TRUE,
705: p_msg_index => 1,
706: p_data => x_msg_data,
707: p_msg_index_out => l_msg_index_out);
708: end if;

Line 1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1020: --hr_utility.trace('x_rev_rv_number= ' || TO_CHAR(x_rev_rv_number));
1021:
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: x_msg_count := 1;
1026: x_msg_data := SQLERRM;
1027: FND_MSG_PUB.add_exc_msg
1028: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 1184: x_return_status := FND_API.G_RET_STS_SUCCESS;

1180: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1181:
1182: BEGIN
1183: x_msg_count := 0;
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;
1185:
1186: -- GET AUTO BASELINED FLAG
1187: x_auto_baselined_flag :=
1188: Pa_Fp_Control_Items_Utils.IsFpAutoBaselineEnabled(p_project_id);

Line 1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1669: fin_plan_option_level_code='PLAN_TYPE';
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: --hr_utility.trace('no_data_found 1');
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674: x_msg_count := 1;
1675: x_msg_data := SQLERRM;
1676: FND_MSG_PUB.add_exc_msg
1677: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1842: fin_plan_option_level_code='PLAN_TYPE';
1843:
1844: EXCEPTION
1845: WHEN NO_DATA_FOUND THEN
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: x_msg_count := 1;
1848: x_msg_data := SQLERRM;
1849: FND_MSG_PUB.add_exc_msg
1850: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 1982: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1978: x_return_status => l_return_status,
1979: x_msg_count => l_msg_count,
1980: x_msg_data => l_msg_data );
1981: -- if view_plan_temp_tables fails, error out right away
1982: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1983: x_return_status := FND_API.G_RET_STS_ERROR;
1984: x_msg_count := FND_MSG_PUB.Count_Msg;
1985: if x_msg_count = 1 then
1986: PA_INTERFACE_UTILS_PUB.get_messages

Line 1983: x_return_status := FND_API.G_RET_STS_ERROR;

1979: x_msg_count => l_msg_count,
1980: x_msg_data => l_msg_data );
1981: -- if view_plan_temp_tables fails, error out right away
1982: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1983: x_return_status := FND_API.G_RET_STS_ERROR;
1984: x_msg_count := FND_MSG_PUB.Count_Msg;
1985: if x_msg_count = 1 then
1986: PA_INTERFACE_UTILS_PUB.get_messages
1987: (p_encoded => FND_API.G_TRUE,

Line 1987: (p_encoded => FND_API.G_TRUE,

1983: x_return_status := FND_API.G_RET_STS_ERROR;
1984: x_msg_count := FND_MSG_PUB.Count_Msg;
1985: if x_msg_count = 1 then
1986: PA_INTERFACE_UTILS_PUB.get_messages
1987: (p_encoded => FND_API.G_TRUE,
1988: p_msg_index => 1,
1989: p_data => x_msg_data,
1990: p_msg_index_out => l_msg_index_out);
1991: end if;

Line 2131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2127: */
2128:
2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2132: x_msg_count := 1;
2133: x_msg_data := SQLERRM;
2134: FND_MSG_PUB.add_exc_msg
2135: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 2159: x_return_status := FND_API.G_RET_STS_SUCCESS;

2155: l_start_date VARCHAR2(30);
2156:
2157: BEGIN
2158:
2159: x_return_status := FND_API.G_RET_STS_SUCCESS;
2160:
2161: pa_fp_view_plans_pub.G_FP_AMOUNT_TYPE_CODE := p_amount_type_code;
2162: pa_fp_view_plans_pub.G_FP_RA_ID := p_resource_assignment_id;
2163: l_budget_version_id := p_budget_version_id;

Line 2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2171: x_msg_count => l_msg_count,
2172: x_msg_data => l_msg_data);
2173: EXCEPTION
2174: WHEN OTHERS THEN
2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176: x_msg_count := 1;
2177: x_msg_data := SQLERRM;
2178: FND_MSG_PUB.add_exc_msg
2179: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

Line 2207: x_return_status := FND_API.G_RET_STS_SUCCESS;

2203: )
2204: where rownum <= l_rownum;
2205:
2206: BEGIN
2207: x_return_status := FND_API.G_RET_STS_SUCCESS;
2208: /* Bug Fix 4373890
2209: Adding a format mask for the GSCC file.Date.5 fix
2210: */
2211: l_start_date := to_date(p_period_start_date);---,'YYYY/MM/DD');

Line 2856: x_return_status := FND_API.G_RET_STS_SUCCESS;

2852: --hr_utility.trace_on(null, 'dlai');
2853: --hr_utility.trace('entered view_plan_temp_tables');
2854: --hr_utility.trace('p_budget_version_id= ' || TO_CHAR(p_budget_version_id));
2855: x_msg_count := 0;
2856: x_return_status := FND_API.G_RET_STS_SUCCESS;
2857: SAVEPOINT VIEW_PLAN_TEMP_TABLES;
2858: l_diff_pd_profile_flag := 'N';
2859:
2860: -- FOR ADVANCED DISPLAY OPTIONS CUSTOMIZATION: USER-SELECTED BUDGET VERSIONS

Line 3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3713: EXCEPTION
3714: when others then
3715: --hr_utility.trace('UNHANDLED EXCEPTION');
3716: rollback to VIEW_PLAN_TEMP_TABLES;
3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3718: x_msg_count := 1;
3719: x_msg_data := SQLERRM;
3720: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
3721: p_procedure_name => 'view_plan_temp_tables');

Line 3723: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3719: x_msg_data := SQLERRM;
3720: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
3721: p_procedure_name => 'view_plan_temp_tables');
3722: pa_debug.reset_err_stack;
3723: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3724:
3725: end; -- procedure view_plan_temp_tables
3726: /* --------------------------------------------------------------------- */
3727:

Line 3981: x_return_status := FND_API.G_RET_STS_SUCCESS;

3977: begin
3978: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_separate', '100: entering procedure', 2);
3979: l_err_stage := 100;
3980: --hr_utility.trace('entered pa_fp_vp_pop_tables_separate');
3981: x_return_status := FND_API.G_RET_STS_SUCCESS;
3982: x_msg_count := 0;
3983: SAVEPOINT VIEW_PLANS_POP_TABLES_SEP;
3984:
3985: -- used to query pa_proj_periods_denorm table

Line 6823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6819: EXCEPTION
6820: when others then
6821: rollback to VIEW_PLANS_POP_TABLES_SEP;
6822: --hr_utility.trace('error stage= ' || to_char(l_err_stage));
6823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6824: x_msg_count := 1;
6825: x_msg_data := SQLERRM;
6826: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
6827: p_procedure_name => 'pa_fp_vp_pop_tables_separate');

Line 7059: x_return_status := FND_API.G_RET_STS_SUCCESS;

7055: --hr_utility.trace_on(null, 'dlai');
7056: l_err_stage := 100;
7057: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_together', '100: entering pa_fp_vp_pop_tables_together', 2);
7058: --hr_utility.trace('entered pa_fp_vp_pop_tables_together: 100');
7059: x_return_status := FND_API.G_RET_STS_SUCCESS;
7060: x_msg_count := 0;
7061: SAVEPOINT VIEW_PLANS_POP_TABLES_SAME;
7062:
7063: -- used to query pa_proj_periods_denorm table

Line 8258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8254: EXCEPTION
8255: when others then
8256: rollback to VIEW_PLANS_POP_TABLES_SAME;
8257: --hr_utility.trace('l_err_stage= ' || to_char(l_err_stage));
8258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8259: x_msg_count := 1;
8260: x_msg_data := SQLERRM;
8261: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
8262: p_procedure_name => 'View_Plans_Pop_Tables_Tog');

Line 8533: x_return_status := FND_API.G_RET_STS_SUCCESS;

8529: --hr_utility.trace_on(null, 'dlai');
8530: l_err_stage := 100;
8531: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_single', '100: entering procedure', 2);
8532: --hr_utility.trace('entered pa_fp_vp_pop_tables_single:100');
8533: x_return_status := FND_API.G_RET_STS_SUCCESS;
8534: x_msg_count := 0;
8535: SAVEPOINT VIEW_PLANS_POP_TABLES_SINGLE;
8536: -- used to query pa_proj_periods_denorm table
8537: select DECODE(pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE,

Line 10578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10574: EXCEPTION
10575: when others then
10576: rollback to VIEW_PLANS_POP_TABLES_SINGLE;
10577: --hr_utility.trace('l_err_stage= ' || to_char(l_err_stage));
10578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10579: x_msg_count := 1;
10580: x_msg_data := SQLERRM;
10581: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
10582: p_procedure_name => 'View_Plans_Pop_Tables_Single');