DBA Data[Home] [Help]

APPS.PA_WP_EXCEPTION_UTILS dependencies on PA_WP_EXCEPTION_UTILS

Line 1: package body PA_WP_EXCEPTION_UTILS as

1: package body PA_WP_EXCEPTION_UTILS as
2: /*$Header: PAWPXCUB.pls 120.1.12010000.2 2008/09/12 19:31:01 snizam ship $*/
3:
4: -- API name : get_wp_exception_value
5: -- Type : Utils Procedure

Line 32: PA_WP_EXCEPTION_UTILS.get_ITD_workplan_effort_var(

28: --once measure has been seeded
29: -- IF (p_measure_id = 11) THEN
30: IF (p_measure_id = 427) THEN
31: --get ITD workplan effort variance
32: PA_WP_EXCEPTION_UTILS.get_ITD_workplan_effort_var(
33: p_object_type => p_object_type,
34: p_object_id => p_object_id,
35: p_measure_id => p_measure_id,
36: p_period_type => p_period_type,

Line 46: PA_WP_EXCEPTION_UTILS.get_forecast_wp_eff_var(

42: );
43: -- ELSIF (p_measure_id = 12) THEN
44: ELSIF (p_measure_id = 428) THEN
45: --get forecast workplan effor variance
46: PA_WP_EXCEPTION_UTILS.get_forecast_wp_eff_var(
47: p_object_type => p_object_type,
48: p_object_id => p_object_id,
49: p_measure_id => p_measure_id,
50: p_period_type => p_period_type,

Line 60: PA_WP_EXCEPTION_UTILS.get_cur_fc_to_pri_effort_var(

56: );
57: -- ELSIF (p_measure_id = 13) THEN
58: ELSIF (p_measure_id = 429) THEN
59: --get current forecast to prior forecast workplan effor variance
60: PA_WP_EXCEPTION_UTILS.get_cur_fc_to_pri_effort_var(
61: p_object_type => p_object_type,
62: p_object_id => p_object_id,
63: p_measure_id => p_measure_id,
64: p_period_type => p_period_type,

Line 74: PA_WP_EXCEPTION_UTILS.get_sch_bsln_fin_var(

70: );
71: -- ELSIF (p_measure_id = 14) THEN
72: ELSIF (p_measure_id = 430) THEN
73: --get schedule baseline finish variance
74: PA_WP_EXCEPTION_UTILS.get_sch_bsln_fin_var(
75: p_object_type => p_object_type,
76: p_object_id => p_object_id,
77: p_measure_id => p_measure_id,
78: p_period_type => p_period_type,

Line 88: PA_WP_EXCEPTION_UTILS.get_sch_bsln_st_var(

84: );
85: -- ELSIF (p_measure_id = 15) THEN
86: ELSIF (p_measure_id = 431) THEN
87: --get schedule baseline start variance
88: PA_WP_EXCEPTION_UTILS.get_sch_bsln_st_var(
89: p_object_type => p_object_type,
90: p_object_id => p_object_id,
91: p_measure_id => p_measure_id,
92: p_period_type => p_period_type,

Line 102: PA_WP_EXCEPTION_UTILS.get_sch_pri_pub_ver_fin_var(

98: );
99: -- ELSIF (p_measure_id = 16) THEN
100: ELSIF (p_measure_id = 432) THEN
101: --get schedule prior published version finish variance
102: PA_WP_EXCEPTION_UTILS.get_sch_pri_pub_ver_fin_var(
103: p_object_type => p_object_type,
104: p_object_id => p_object_id,
105: p_measure_id => p_measure_id,
106: p_period_type => p_period_type,

Line 116: PA_WP_EXCEPTION_UTILS.get_sch_pri_pub_ver_st_var(

112: );
113: -- ELSIF (p_measure_id = 17) THEN
114: ELSIF (p_measure_id = 433) THEN
115: --get schedule prior published version start variance
116: PA_WP_EXCEPTION_UTILS.get_sch_pri_pub_ver_st_var(
117: p_object_type => p_object_type,
118: p_object_id => p_object_id,
119: p_measure_id => p_measure_id,
120: p_period_type => p_period_type,

Line 130: PA_WP_EXCEPTION_UTILS.get_sch_est_fin_var(

126: );
127: -- ELSIF (p_measure_id = 18) THEN
128: ELSIF (p_measure_id = 434) THEN
129: --get schedule estimated finish variance
130: PA_WP_EXCEPTION_UTILS.get_sch_est_fin_var(
131: p_object_type => p_object_type,
132: p_object_id => p_object_id,
133: p_measure_id => p_measure_id,
134: p_period_type => p_period_type,

Line 144: PA_WP_EXCEPTION_UTILS.get_sch_est_st_var(

140: );
141: -- ELSIF (p_measure_id = 19) THEN
142: ELSIF (p_measure_id = 435) THEN
143: --get schedule estimated start variance
144: PA_WP_EXCEPTION_UTILS.get_sch_est_st_var(
145: p_object_type => p_object_type,
146: p_object_id => p_object_id,
147: p_measure_id => p_measure_id,
148: p_period_type => p_period_type,

Line 166: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

162: x_msg_count := 1;
163: x_msg_data := SQLERRM;
164:
165: Fnd_Msg_Pub.add_exc_msg
166: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
167: , p_procedure_name => 'get_wp_exception_value'
168: , p_error_text => x_msg_data);
169:
170: RAISE;

Line 233: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

229: x_msg_count := 1;
230: x_msg_data := SQLERRM;
231:
232: Fnd_Msg_Pub.add_exc_msg
233: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
234: , p_procedure_name => 'get_ITD_workplan_effort_var'
235: , p_error_text => x_msg_data);
236:
237: RAISE;

Line 304: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

300: x_msg_count := 1;
301: x_msg_data := SQLERRM;
302:
303: Fnd_Msg_Pub.add_exc_msg
304: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
305: , p_procedure_name => 'get_forecast_wp_eff_var'
306: , p_error_text => x_msg_data);
307:
308: RAISE;

Line 373: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

369: x_msg_count := 1;
370: x_msg_data := SQLERRM;
371:
372: Fnd_Msg_Pub.add_exc_msg
373: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
374: , p_procedure_name => 'get_cur_fc_to_pri_effort_var'
375: , p_error_text => x_msg_data);
376:
377: RAISE;

Line 422: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

418: x_msg_count := 1;
419: x_msg_data := SQLERRM;
420:
421: Fnd_Msg_Pub.add_exc_msg
422: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
423: , p_procedure_name => 'get_sch_bsln_fin_var'
424: , p_error_text => x_msg_data);
425:
426: RAISE;

Line 471: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

467: x_msg_count := 1;
468: x_msg_data := SQLERRM;
469:
470: Fnd_Msg_Pub.add_exc_msg
471: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
472: , p_procedure_name => 'get_sch_bsln_st_var'
473: , p_error_text => x_msg_data);
474:
475: RAISE;

Line 536: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

532: x_msg_count := 1;
533: x_msg_data := SQLERRM;
534:
535: Fnd_Msg_Pub.add_exc_msg
536: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
537: , p_procedure_name => 'get_sch_pri_pub_ver_fin_var'
538: , p_error_text => x_msg_data);
539:
540: RAISE;

Line 601: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

597: x_msg_count := 1;
598: x_msg_data := SQLERRM;
599:
600: Fnd_Msg_Pub.add_exc_msg
601: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
602: , p_procedure_name => 'get_sch_pri_pub_ver_st_var'
603: , p_error_text => x_msg_data);
604:
605: RAISE;

Line 660: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

656: x_msg_count := 1;
657: x_msg_data := SQLERRM;
658:
659: Fnd_Msg_Pub.add_exc_msg
660: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
661: , p_procedure_name => 'get_sch_est_fin_var'
662: , p_error_text => x_msg_data);
663:
664: RAISE;

Line 719: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'

715: x_msg_count := 1;
716: x_msg_data := SQLERRM;
717:
718: Fnd_Msg_Pub.add_exc_msg
719: ( p_pkg_name => 'PA_WP_EXCEPTION_UTILS'
720: , p_procedure_name => 'get_sch_est_st_var'
721: , p_error_text => x_msg_data);
722:
723: RAISE;

Line 727: end PA_WP_EXCEPTION_UTILS;

723: RAISE;
724: END get_sch_est_st_var;
725:
726:
727: end PA_WP_EXCEPTION_UTILS;