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.HR_SUM_STORE dependencies on FND_MESSAGE

Line 128: l_error_mesg := fnd_message.get_string('PER','PER_74874_PARSE_ERROR')||' '||p_item_name;

124:
125: <>
126: begin
127: l_error := false;
128: l_error_mesg := fnd_message.get_string('PER','PER_74874_PARSE_ERROR')||' '||p_item_name;
129: -- dbms_sql.parse(source_cursor,p_stmt,dbms_sql.v7);
130: hr_utility.trace('parse stmt');
131: dbms_sql.parse(source_cursor,l_new_stmt,dbms_sql.v7);
132: hr_utility.trace('complete parse stmt');

Line 134: fnd_message.set_name('PER','PER_74877_DEFINE_COLUMN');

130: hr_utility.trace('parse stmt');
131: dbms_sql.parse(source_cursor,l_new_stmt,dbms_sql.v7);
132: hr_utility.trace('complete parse stmt');
133: l_error_mesg := null;
134: fnd_message.set_name('PER','PER_74877_DEFINE_COLUMN');
135: fnd_message.set_token('NUM','1');
136: l_error_mesg := fnd_message.get;
137: If p_debug = 'Y' Then
138: dbms_sql.define_column(source_cursor,1,l_item_value_char,240);

Line 135: fnd_message.set_token('NUM','1');

131: dbms_sql.parse(source_cursor,l_new_stmt,dbms_sql.v7);
132: hr_utility.trace('complete parse stmt');
133: l_error_mesg := null;
134: fnd_message.set_name('PER','PER_74877_DEFINE_COLUMN');
135: fnd_message.set_token('NUM','1');
136: l_error_mesg := fnd_message.get;
137: If p_debug = 'Y' Then
138: dbms_sql.define_column(source_cursor,1,l_item_value_char,240);
139: Else

Line 136: l_error_mesg := fnd_message.get;

132: hr_utility.trace('complete parse stmt');
133: l_error_mesg := null;
134: fnd_message.set_name('PER','PER_74877_DEFINE_COLUMN');
135: fnd_message.set_token('NUM','1');
136: l_error_mesg := fnd_message.get;
137: If p_debug = 'Y' Then
138: dbms_sql.define_column(source_cursor,1,l_item_value_char,240);
139: Else
140: dbms_sql.define_column(source_cursor,1,l_item_value);

Line 146: fnd_message.set_token('NUM','2');

142: l_error_mesg := null;
143: --
144: if p_debug <> 'Y' then
145: if p_count_clause2 is not null then
146: fnd_message.set_token('NUM','2');
147: l_error_mesg := fnd_message.get;
148: dbms_sql.define_column(source_cursor,2,l_item_value2);
149: l_error_mesg := null;
150: --

Line 147: l_error_mesg := fnd_message.get;

143: --
144: if p_debug <> 'Y' then
145: if p_count_clause2 is not null then
146: fnd_message.set_token('NUM','2');
147: l_error_mesg := fnd_message.get;
148: dbms_sql.define_column(source_cursor,2,l_item_value2);
149: l_error_mesg := null;
150: --
151: -- Define subsequent columns based on the group by columns

Line 160: fnd_message.set_token('NUM',to_char(j));

156: end if;
157: --
158: if hrsumrep.ktyTab.count > 0 then
159: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
160: fnd_message.set_token('NUM',to_char(j));
161: l_error_mesg := fnd_message.get;
162: dbms_sql.define_column(source_cursor,j,l_key_value,80);
163: l_error_mesg := null;
164: j := j + 1;

Line 161: l_error_mesg := fnd_message.get;

157: --
158: if hrsumrep.ktyTab.count > 0 then
159: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
160: fnd_message.set_token('NUM',to_char(j));
161: l_error_mesg := fnd_message.get;
162: dbms_sql.define_column(source_cursor,j,l_key_value,80);
163: l_error_mesg := null;
164: j := j + 1;
165: end loop;

Line 176: fnd_message.set_token('NUM',to_char(j));

172: l_columns_required := l_columns_required + nvl(hrsumrep.ktyTab.last,0);
173: hr_utility.trace('l_columns_required after adding is ' || l_columns_required);
174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop
176: fnd_message.set_token('NUM',to_char(j));
177: l_error_mesg := fnd_message.get;
178: hr_utility.trace('define col');
179: dbms_sql.define_column(source_cursor,j,l_key_value,80);
180: hr_utility.trace('define col2');

Line 177: l_error_mesg := fnd_message.get;

173: hr_utility.trace('l_columns_required after adding is ' || l_columns_required);
174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop
176: fnd_message.set_token('NUM',to_char(j));
177: l_error_mesg := fnd_message.get;
178: hr_utility.trace('define col');
179: dbms_sql.define_column(source_cursor,j,l_key_value,80);
180: hr_utility.trace('define col2');
181: l_error_mesg := null;

Line 187: l_error_mesg := fnd_message.get_string('PER','PER_74875_EXECUTE_ERROR')||' '||p_item_name;

183: end loop;
184: end if;
185: end if;
186: --
187: l_error_mesg := fnd_message.get_string('PER','PER_74875_EXECUTE_ERROR')||' '||p_item_name;
188: ignore := dbms_sql.execute(source_cursor);
189: l_error_mesg := null;
190: --
191: z := 0;

Line 194: fnd_message.set_name('PER','PER_74878_COLUMN_VALUE');

190: --
191: z := 0;
192: loop
193: if dbms_sql.fetch_rows(source_cursor) > 0 then
194: fnd_message.set_name('PER','PER_74878_COLUMN_VALUE');
195: fnd_message.set_token('NUM','1');
196: l_error_mesg := fnd_message.get;
197:
198: if p_debug = 'Y' then

Line 195: fnd_message.set_token('NUM','1');

191: z := 0;
192: loop
193: if dbms_sql.fetch_rows(source_cursor) > 0 then
194: fnd_message.set_name('PER','PER_74878_COLUMN_VALUE');
195: fnd_message.set_token('NUM','1');
196: l_error_mesg := fnd_message.get;
197:
198: if p_debug = 'Y' then
199: hr_utility.trace(' col value');

Line 196: l_error_mesg := fnd_message.get;

192: loop
193: if dbms_sql.fetch_rows(source_cursor) > 0 then
194: fnd_message.set_name('PER','PER_74878_COLUMN_VALUE');
195: fnd_message.set_token('NUM','1');
196: l_error_mesg := fnd_message.get;
197:
198: if p_debug = 'Y' then
199: hr_utility.trace(' col value');
200: dbms_sql.column_value(source_cursor,1,l_item_value_char);

Line 212: fnd_message.set_token('NUM','2');

208:
209: if p_debug <> 'Y' then
210:
211: if p_count_clause2 is not null then
212: fnd_message.set_token('NUM','2');
213: l_error_mesg := fnd_message.get;
214: dbms_sql.column_value(source_cursor,2,l_item_value2);
215: l_error_mesg := null;
216: end if;

Line 213: l_error_mesg := fnd_message.get;

209: if p_debug <> 'Y' then
210:
211: if p_count_clause2 is not null then
212: fnd_message.set_token('NUM','2');
213: l_error_mesg := fnd_message.get;
214: dbms_sql.column_value(source_cursor,2,l_item_value2);
215: l_error_mesg := null;
216: end if;
217: --

Line 237: fnd_message.set_token('NUM',to_char(j));

233: j := 3;
234: end if;
235: if hrsumrep.ktyTab.count > 0 then
236: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
237: fnd_message.set_token('NUM',to_char(j));
238: l_error_mesg := fnd_message.get;
239: dbms_sql.column_value(source_cursor,j,l_key_value);
240: l_error_mesg := null;
241: --

Line 238: l_error_mesg := fnd_message.get;

234: end if;
235: if hrsumrep.ktyTab.count > 0 then
236: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
237: fnd_message.set_token('NUM',to_char(j));
238: l_error_mesg := fnd_message.get;
239: dbms_sql.column_value(source_cursor,j,l_key_value);
240: l_error_mesg := null;
241: --
242: -- Populate the key value

Line 290: fnd_message.set_token('NUM',to_char(j));

286: end if;
287: -- for i in hrsumrep.ktyTab.first..l_columns_required loop
288: l_concat_debug_string := ' ';
289: for i in l_start_index..(l_columns_required-1) loop
290: fnd_message.set_token('NUM',to_char(j));
291: l_error_mesg := fnd_message.get;
292: dbms_sql.column_value(source_cursor,j,l_key_value);
293: l_error_mesg := null;
294: if i < ColNameTab.count then

Line 291: l_error_mesg := fnd_message.get;

287: -- for i in hrsumrep.ktyTab.first..l_columns_required loop
288: l_concat_debug_string := ' ';
289: for i in l_start_index..(l_columns_required-1) loop
290: fnd_message.set_token('NUM',to_char(j));
291: l_error_mesg := fnd_message.get;
292: dbms_sql.column_value(source_cursor,j,l_key_value);
293: l_error_mesg := null;
294: if i < ColNameTab.count then
295: --hrsumrep.write_stmt_log(ColNameTab(i).Col_Name || ' = ' || l_key_value);