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_QSF_BUS dependencies on HR_UTILITY

Line 27: hr_utility.set_location('Entering: '||l_proc,10);

23: is
24: --
25: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
26: begin
27: hr_utility.set_location('Entering: '||l_proc,10);
28: --
29: -- Only proceed with the validation if a row exists for the current
30: -- record in the HR Schema
31: --

Line 41: hr_utility.set_location(l_proc,30);

37: fnd_message.set_token('PROCEDURE',l_proc);
38: fnd_message.set_token('STEP','20');
39: fnd_message.raise_error;
40: end if;
41: hr_utility.set_location(l_proc,30);
42: --
43: if nvl(p_rec.questionnaire_template_id,hr_api.g_number) <>
44: hr_qsf_shd.g_old_rec.questionnaire_template_id then
45:

Line 52: hr_utility.set_location(l_proc,40);

48: ,p_argument => 'QUESTIONNAIRE_TEMPLATE_ID'
49: ,p_base_table => hr_qsf_shd.g_tab_nam
50: );
51: end if;
52: hr_utility.set_location(l_proc,40);
53: --
54: if nvl(p_rec.html_text,hr_api.g_varchar2) <> 'BLANK' then
55:
56: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsf_shd.g_old_rec.name then

Line 64: hr_utility.set_location(l_proc,50);

60: ,p_argument => 'NAME'
61: ,p_base_table => hr_qsf_shd.g_tab_nam
62: );
63: end if;
64: hr_utility.set_location(l_proc,50);
65: --
66: if nvl(p_rec.type,hr_api.g_varchar2) <> hr_qsf_shd.g_old_rec.type then
67:
68: hr_api.argument_changed_error

Line 74: hr_utility.set_location(l_proc,60);

70: ,p_argument => 'TYPE'
71: ,p_base_table => hr_qsf_shd.g_tab_nam
72: );
73: end if;
74: hr_utility.set_location(l_proc,60);
75: --
76: if nvl(p_rec.html_text,hr_api.g_varchar2)
77: <> hr_qsf_shd.g_old_rec.html_text then
78:

Line 85: hr_utility.set_location(l_proc,70);

81: ,p_argument => 'HTML_TEXT'
82: ,p_base_table => hr_qsf_shd.g_tab_nam
83: );
84: end if;
85: hr_utility.set_location(l_proc,70);
86: --
87: if nvl(p_rec.sql_required_flag,hr_api.g_varchar2)
88: <> hr_qsf_shd.g_old_rec.sql_required_flag then
89:

Line 97: hr_utility.set_location('Leaving: '||l_proc,80);

93: ,p_base_table => hr_qsf_shd.g_tab_nam
94: );
95: end if;
96: end if;
97: hr_utility.set_location('Leaving: '||l_proc,80);
98: --
99: end chk_non_updateable_args;
100: --
101: --

Line 123: hr_utility.set_location('Entering: '||l_proc,10);

119: from hr_questionnaires
120: where questionnaire_template_id = p_questionnaire_template_id;
121: --
122: begin
123: hr_utility.set_location('Entering: '||l_proc,10);
124: --
125: if p_questionnaire_template_id is not null then
126: -- check that it exists
127: open csr_id_exists;

Line 141: hr_utility.set_location('Leaving: '||l_proc,50);

137: fnd_message.set_name('PER','PER_52419_QSF_MAND_TEMPLATE_ID');
138: fnd_message.raise_error;
139: end if;
140: --
141: hr_utility.set_location('Leaving: '||l_proc,50);
142:
143: exception when app_exception.application_exception then
144: if hr_multi_message.exception_add
145: (p_associated_column1 => 'HR_QUEST_FIELDS.QUESTIONNAIRE_TEMPLATE_ID'

Line 147: hr_utility.set_location(' Leaving:'|| l_proc, 60);

143: exception when app_exception.application_exception then
144: if hr_multi_message.exception_add
145: (p_associated_column1 => 'HR_QUEST_FIELDS.QUESTIONNAIRE_TEMPLATE_ID'
146: ) then
147: hr_utility.set_location(' Leaving:'|| l_proc, 60);
148: raise;
149: end if;
150: hr_utility.set_location(' Leaving:'|| l_proc, 70);
151: --

Line 150: hr_utility.set_location(' Leaving:'|| l_proc, 70);

146: ) then
147: hr_utility.set_location(' Leaving:'|| l_proc, 60);
148: raise;
149: end if;
150: hr_utility.set_location(' Leaving:'|| l_proc, 70);
151: --
152: end chk_questionnaire_template_id;
153: --
154: -- ----------------------------------------------------------------------------

Line 167: hr_utility.set_location('Entering: '||l_proc,10);

163: l_proc varchar2(72) := g_package || 'chk_name';
164: --
165: begin
166: --
167: hr_utility.set_location('Entering: '||l_proc,10);
168: --
169: if p_name is null then
170: -- Raise error, since name is a mandatory column.
171: fnd_message.set_name('PER','PER_52423_QSF_MAND_NAME');

Line 175: hr_utility.set_location('Leaving: '||l_proc,20);

171: fnd_message.set_name('PER','PER_52423_QSF_MAND_NAME');
172: fnd_message.raise_error;
173: end if;
174: --
175: hr_utility.set_location('Leaving: '||l_proc,20);
176:
177: exception when app_exception.application_exception then
178: if hr_multi_message.exception_add
179: (p_associated_column1 => 'HR_QUEST_FIELDS.NAME'

Line 181: hr_utility.set_location(' Leaving:'|| l_proc, 30);

177: exception when app_exception.application_exception then
178: if hr_multi_message.exception_add
179: (p_associated_column1 => 'HR_QUEST_FIELDS.NAME'
180: ) then
181: hr_utility.set_location(' Leaving:'|| l_proc, 30);
182: raise;
183: end if;
184: hr_utility.set_location(' Leaving:'|| l_proc, 40);
185: --

Line 184: hr_utility.set_location(' Leaving:'|| l_proc, 40);

180: ) then
181: hr_utility.set_location(' Leaving:'|| l_proc, 30);
182: raise;
183: end if;
184: hr_utility.set_location(' Leaving:'|| l_proc, 40);
185: --
186: end chk_name;
187: -- ----------------------------------------------------------------------------
188: -- |----------------------------< chk_type >----------------------------------|

Line 200: hr_utility.set_location('Entering: '||l_proc,10);

196: l_proc varchar2(72) := g_package || 'chk_type';
197: --
198: begin
199: --
200: hr_utility.set_location('Entering: '||l_proc,10);
201: --
202: if p_type is not null then
203: -- Check that p_type exists in lookup
204: if hr_api.not_exists_in_hr_lookups

Line 218: hr_utility.set_location('Leaving: '||l_proc,20);

214: fnd_message.set_name('PER','PER_52426_QSF_MAND_TYPE');
215: fnd_message.raise_error;
216: end if;
217: --
218: hr_utility.set_location('Leaving: '||l_proc,20);
219:
220: exception when app_exception.application_exception then
221: if hr_multi_message.exception_add
222: (p_associated_column1 => 'HR_QUEST_FIELDS.TYPE'

Line 224: hr_utility.set_location(' Leaving:'|| l_proc, 30);

220: exception when app_exception.application_exception then
221: if hr_multi_message.exception_add
222: (p_associated_column1 => 'HR_QUEST_FIELDS.TYPE'
223: ) then
224: hr_utility.set_location(' Leaving:'|| l_proc, 30);
225: raise;
226: end if;
227: hr_utility.set_location(' Leaving:'|| l_proc, 40);
228: --

Line 227: hr_utility.set_location(' Leaving:'|| l_proc, 40);

223: ) then
224: hr_utility.set_location(' Leaving:'|| l_proc, 30);
225: raise;
226: end if;
227: hr_utility.set_location(' Leaving:'|| l_proc, 40);
228: --
229: end chk_type;
230: --
231: -- ---------------------------------------------------------------------------

Line 245: hr_utility.set_location('Entering: '||l_proc,10);

241: l_proc varchar2(72) := g_package || 'chk_html_text';
242: --
243: begin
244: --
245: hr_utility.set_location('Entering: '||l_proc,10);
246: --
247: if p_html_text is not null then
248: -- Check that the size of the text is less than max_size
249: -- if Length(p_html_text) > c_max_size then

Line 261: hr_utility.set_location('Leaving: '||l_proc,20);

257: fnd_message.set_name('PER','PER_52421_QSF_MAND_HTML_TEXT');
258: fnd_message.raise_error;
259: end if;
260: --
261: hr_utility.set_location('Leaving: '||l_proc,20);
262:
263: exception when app_exception.application_exception then
264: if hr_multi_message.exception_add
265: (p_associated_column1 => 'HR_QUEST_FIELDS.HTML_TEXT'

Line 267: hr_utility.set_location(' Leaving:'|| l_proc, 30);

263: exception when app_exception.application_exception then
264: if hr_multi_message.exception_add
265: (p_associated_column1 => 'HR_QUEST_FIELDS.HTML_TEXT'
266: ) then
267: hr_utility.set_location(' Leaving:'|| l_proc, 30);
268: raise;
269: end if;
270: hr_utility.set_location(' Leaving:'|| l_proc, 40);
271: --

Line 270: hr_utility.set_location(' Leaving:'|| l_proc, 40);

266: ) then
267: hr_utility.set_location(' Leaving:'|| l_proc, 30);
268: raise;
269: end if;
270: hr_utility.set_location(' Leaving:'|| l_proc, 40);
271: --
272: end chk_html_text;
273: --
274: -- ---------------------------------------------------------------------------

Line 287: hr_utility.set_location('Entering: '||l_proc,10);

283: l_proc varchar2(72) := g_package || 'chk_sql_required_flag';
284: --
285: begin
286: --
287: hr_utility.set_location('Entering: '||l_proc,10);
288: --
289: if p_sql_required_flag is not null then
290: -- Check that it exists in HR_LOOKUPS
291: if hr_api.not_exists_in_hr_lookups

Line 305: hr_utility.set_location('Leaving: '||l_proc,20);

301: fnd_message.set_name('PER','PER_52422_QSF_MAND_REQD_FLAG');
302: fnd_message.raise_error;
303: end if;
304: --
305: hr_utility.set_location('Leaving: '||l_proc,20);
306:
307: exception when app_exception.application_exception then
308: if hr_multi_message.exception_add
309: (p_associated_column1 => 'HR_QUEST_FIELDS.SQL_REQUIRED_FLAG'

Line 311: hr_utility.set_location(' Leaving:'|| l_proc, 30);

307: exception when app_exception.application_exception then
308: if hr_multi_message.exception_add
309: (p_associated_column1 => 'HR_QUEST_FIELDS.SQL_REQUIRED_FLAG'
310: ) then
311: hr_utility.set_location(' Leaving:'|| l_proc, 30);
312: raise;
313: end if;
314: hr_utility.set_location(' Leaving:'|| l_proc, 40);
315: --

Line 314: hr_utility.set_location(' Leaving:'|| l_proc, 40);

310: ) then
311: hr_utility.set_location(' Leaving:'|| l_proc, 30);
312: raise;
313: end if;
314: hr_utility.set_location(' Leaving:'|| l_proc, 40);
315: --
316: end chk_sql_required_flag;
317: --
318: -- ----------------------------------------------------------------------------

Line 327: hr_utility.set_location('Entering:'||l_proc, 5);

323: --
324: l_proc varchar2(72) := g_package||'insert_validate';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: hr_qsn_bus.set_security_group_id
330: (p_questionnaire_template_id => p_rec.questionnaire_template_id);
331: --

Line 332: hr_utility.set_location('Entering:'||l_proc, 7);

328: --
329: hr_qsn_bus.set_security_group_id
330: (p_questionnaire_template_id => p_rec.questionnaire_template_id);
331: --
332: hr_utility.set_location('Entering:'||l_proc, 7);
333: -- Call all supporting business operations
334: --
335: chk_questionnaire_template_id(p_rec.questionnaire_template_id);
336: chk_name(p_rec.name);

Line 344: hr_utility.set_location(' Leaving:'||l_proc, 10);

340:
341: hr_multi_message.end_validation_set;
342: --
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: End insert_validate;
346: --
347: -- ----------------------------------------------------------------------------
348: -- |---------------------------< update_validate >----------------------------|

Line 356: hr_utility.set_location('Entering:'||l_proc, 5);

352: --
353: l_proc varchar2(72) := g_package||'update_validate';
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: hr_qsn_bus.set_security_group_id
359: (p_questionnaire_template_id => p_rec.questionnaire_template_id
360: ,p_associated_column1 => hr_qsn_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

Line 365: hr_utility.set_location('Entering:'||l_proc, 7);

361: );
362:
363: hr_multi_message.end_validation_set;
364: --
365: hr_utility.set_location('Entering:'||l_proc, 7);
366: -- Call all supporting business operations
367: --
368: chk_non_updateable_args
369: (p_rec => p_rec

Line 373: hr_utility.set_location(' Leaving:'||l_proc, 10);

369: (p_rec => p_rec
370: ,p_effective_date => p_effective_date
371: );
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: End update_validate;
375: --
376: -- ----------------------------------------------------------------------------
377: -- |---------------------------< delete_validate >----------------------------|

Line 384: hr_utility.set_location('Entering:'||l_proc, 5);

380: --
381: l_proc varchar2(72) := g_package||'delete_validate';
382: --
383: Begin
384: hr_utility.set_location('Entering:'||l_proc, 5);
385: --
386: -- Call all supporting business operations
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 388: hr_utility.set_location(' Leaving:'||l_proc, 10);

384: hr_utility.set_location('Entering:'||l_proc, 5);
385: --
386: -- Call all supporting business operations
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End delete_validate;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |--------------------< return_legislation_code >---------------------------|

Line 414: hr_utility.set_location('Entering: '||l_proc,10);

410: --
411: l_legislation_code varchar2(150);
412: l_proc varchar2(72) := 'return_legislation_code';
413: begin
414: hr_utility.set_location('Entering: '||l_proc,10);
415: hr_api.mandatory_arg_error(p_api_name => l_proc
416: ,p_argument => 'field_id'
417: ,p_argument_value => p_field_id
418: );

Line 426: hr_utility.set_location(l_proc,20);

422: -- call to this function. Just return the value in the global
423: -- variable.
424: --
425: l_legislation_code := g_legislation_code;
426: hr_utility.set_location(l_proc,20);
427: else
428: --
429: -- The ID is different to the last call to this function
430: -- or this is the first call to this function.

Line 442: hr_utility.set_location(l_proc,30);

438: close csr_leg_code;
439: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
440: fnd_message.raise_error;
441: end if;
442: hr_utility.set_location(l_proc,30);
443: --
444: -- Set the global variables so the values are available
445: -- for the next call to this function.
446: --

Line 451: hr_utility.set_location(' Leaving: '||l_proc, 40);

447: close csr_leg_code;
448: g_field_id := p_field_id;
449: g_legislation_code := l_legislation_code;
450: end if;
451: hr_utility.set_location(' Leaving: '||l_proc, 40);
452: --
453: return l_legislation_code;
454: end return_legislation_code;
455: --