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.FII_MSG dependencies on FII_GL_UTIL_PKG

Line 23: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN

19:
20: stmt VARCHAR2(240);
21: BEGIN
22:
23: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN
24:
25:
26: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
27: stmt := 'YTD';

Line 26: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN

22:
23: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN
24:
25:
26: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
27: stmt := 'YTD';
28: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
29: stmt := 'QTD';
30: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

Line 28: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN

24:
25:
26: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
27: stmt := 'YTD';
28: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
29: stmt := 'QTD';
30: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
31: stmt := 'MTD';
32: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

Line 30: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

26: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
27: stmt := 'YTD';
28: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
29: stmt := 'QTD';
30: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
31: stmt := 'MTD';
32: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
33: stmt := 'WTD';
34: END IF;

Line 32: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

28: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
29: stmt := 'QTD';
30: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
31: stmt := 'MTD';
32: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
33: stmt := 'WTD';
34: END IF;
35:
36: ELSE

Line 55: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN

51:
52: stmt VARCHAR2(240);
53: BEGIN
54:
55: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN
56:
57:
58: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
59: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';

Line 58: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN

54:
55: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN
56:
57:
58: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
59: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

Line 60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN

56:
57:
58: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
59: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
63: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
64: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

Line 62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

58: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
59: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
63: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
64: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
65: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
66: END IF;

Line 64: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
63: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
64: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
65: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
66: END IF;
67:
68: ELSE

Line 87: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN

83:
84: stmt VARCHAR2(240);
85: BEGIN
86:
87: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN
88: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
89: ELSIF fii_gl_util_pkg.g_mgr_id = -99999 THEN
90:
91:

Line 89: ELSIF fii_gl_util_pkg.g_mgr_id = -99999 THEN

85: BEGIN
86:
87: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN
88: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
89: ELSIF fii_gl_util_pkg.g_mgr_id = -99999 THEN
90:
91:
92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
93: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';

Line 92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN

88: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
89: ELSIF fii_gl_util_pkg.g_mgr_id = -99999 THEN
90:
91:
92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
93: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

Line 94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN

90:
91:
92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
93: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
97: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
98: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

Line 96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
93: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
97: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
98: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
99: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
100: END IF;

Line 98: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
97: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
98: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
99: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
100: END IF;
101:
102: ELSE

Line 138: l_asof_date:=fii_gl_util_pkg.g_as_of_date;

134: l_week VARCHAR2(10);
135: l_year VARCHAR2(10);
136: BEGIN
137: IF (p_current = 'Y') THEN
138: l_asof_date:=fii_gl_util_pkg.g_as_of_date;
139: ELSE
140: l_asof_date:=fii_gl_util_pkg.g_previous_asof_date;
141: END IF;
142:

Line 140: l_asof_date:=fii_gl_util_pkg.g_previous_asof_date;

136: BEGIN
137: IF (p_current = 'Y') THEN
138: l_asof_date:=fii_gl_util_pkg.g_as_of_date;
139: ELSE
140: l_asof_date:=fii_gl_util_pkg.g_previous_asof_date;
141: END IF;
142:
143: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET' AND p_current = 'N') THEN
144: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');

Line 143: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET' AND p_current = 'N') THEN

139: ELSE
140: l_asof_date:=fii_gl_util_pkg.g_previous_asof_date;
141: END IF;
142:
143: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET' AND p_current = 'N') THEN
144: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
145: ELSE
146: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
147: select name into stmt

Line 146: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN

142:
143: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET' AND p_current = 'N') THEN
144: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
145: ELSE
146: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
147: select name into stmt
148: from fii_time_ent_year
149: where l_asof_date between start_date and end_date;
150: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN

Line 150: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN

146: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
147: select name into stmt
148: from fii_time_ent_year
149: where l_asof_date between start_date and end_date;
150: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
151: select name into stmt
152: from fii_time_ent_qtr
153: where l_asof_date between start_date and end_date;
154: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

Line 154: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN

150: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
151: select name into stmt
152: from fii_time_ent_qtr
153: where l_asof_date between start_date and end_date;
154: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
155: select name into stmt
156: from fii_time_ent_period
157: where l_asof_date between start_date and end_date;
158: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

Line 158: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN

154: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
155: select name into stmt
156: from fii_time_ent_period
157: where l_asof_date between start_date and end_date;
158: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
159: select to_char(sequence) into l_week
160: from fii_time_week
161: where l_asof_date between start_date and end_date;
162:

Line 225: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') THEN

221:
222: stmt VARCHAR2(240);
223: BEGIN
224:
225: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') THEN
226: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
227: ELSE
228: stmt := fnd_message.get_string('FII', 'FII_GL_PRIOR_MARGIN');
229: END IF;