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.OTA_FRM_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := ota_frm_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: ota_frm_bus.g_forum_id := p_forum_id;
154: ota_frm_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

Line 231: hr_utility.set_location('Entering:'|| v_proc, 5);

227: v_proc varchar2(72) := g_package||'check_start_end_dates';
228: --
229: Begin
230: --
231: hr_utility.set_location('Entering:'|| v_proc, 5);
232: --
233: ota_general.check_start_end_dates( p_start_date, p_end_date);
234: --
235: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 235: hr_utility.set_location(' Leaving:'|| v_proc, 10);

231: hr_utility.set_location('Entering:'|| v_proc, 5);
232: --
233: ota_general.check_start_end_dates( p_start_date, p_end_date);
234: --
235: hr_utility.set_location(' Leaving:'|| v_proc, 10);
236:
237: Exception
238: WHEN app_exception.application_exception THEN
239:

Line 245: hr_utility.set_location(' Leaving:'||v_proc, 22);

241: p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE')
242: -- ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE')
243: THEN
244:
245: hr_utility.set_location(' Leaving:'||v_proc, 22);
246: RAISE;
247:
248: END IF;
249: hr_utility.set_location(' Leaving:'||v_proc, 25);

Line 249: hr_utility.set_location(' Leaving:'||v_proc, 25);

245: hr_utility.set_location(' Leaving:'||v_proc, 22);
246: RAISE;
247:
248: END IF;
249: hr_utility.set_location(' Leaving:'||v_proc, 25);
250: --
251: End check_start_end_dates;
252: --
253: --

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

288: l_cat_start_date date;
289: l_cat_end_date date;
290:
291: Begin
292: hr_utility.set_location(' Entering:' || l_proc,10);
293: --
294: if(hr_multi_message.no_exclusive_error
295: (p_check_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
296: ,p_check_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'

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

317:
318: End IF;
319: End IF;
320: --
321: hr_utility.set_location(' Leaving:' || l_proc,10);
322: Exception
323: when app_exception.application_exception then
324: IF hr_multi_message.exception_add
325: (p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'

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

324: IF hr_multi_message.exception_add
325: (p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
326: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
327: ) THEN
328: hr_utility.set_location(' Leaving:'|| l_proc,20);
329: raise;
330: END IF;
331:
332: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

328: hr_utility.set_location(' Leaving:'|| l_proc,20);
329: raise;
330: END IF;
331:
332: hr_utility.set_location(' Leaving:'|| l_proc,30);
333: --
334: End chk_category_start_end_dates;
335: --
336: -- BUG#4654544

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

368: l_proc varchar2(72) := g_package ||'chk_forum_end_date';
369: l_cat_end_date date;
370:
371: Begin
372: hr_utility.set_location(' Entering:' || l_proc,10);
373: --
374: --
375: OPEN csr_cat_start_end_date;
376: FETCH csr_cat_start_end_date into l_cat_end_date;

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

385: End IF;
386: CLOSE csr_cat_start_end_date;
387:
388: --
389: hr_utility.set_location(' Leaving:' || l_proc,10);
390: Exception
391: when app_exception.application_exception then
392: IF hr_multi_message.exception_add
393: (p_associated_column1 => 'OTA_FORUMS_B.END_DATE_ACTIVE'

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

391: when app_exception.application_exception then
392: IF hr_multi_message.exception_add
393: (p_associated_column1 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
394: ) THEN
395: hr_utility.set_location(' Leaving:'|| l_proc,20);
396: raise;
397: END IF;
398:
399: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

395: hr_utility.set_location(' Leaving:'|| l_proc,20);
396: raise;
397: END IF;
398:
399: hr_utility.set_location(' Leaving:'|| l_proc,30);
400: --
401: End chk_forum_end_date;
402: --
403: --

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

411: --
412: l_proc varchar2(72) := g_package||'insert_validate';
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- Call all supporting business operations
418: --
419: hr_api.validate_bus_grp_id

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

433:
434: -- Validate Dependent Attributes
435: --
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: End insert_validate;
439: --
440: -- ----------------------------------------------------------------------------
441: -- |---------------------------< update_validate >----------------------------|

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

447: --
448: l_proc varchar2(72) := g_package||'update_validate';
449: --
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Call all supporting business operations
454: --
455: hr_api.validate_bus_grp_id

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

482:
483:
484: --
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: End update_validate;
488: --
489: -- ----------------------------------------------------------------------------
490: -- |---------------------------< delete_validate >----------------------------|

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

495: --
496: l_proc varchar2(72) := g_package||'delete_validate';
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Call all supporting business operations
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Call all supporting business operations
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 10);
504: End delete_validate;
505: --
506: end ota_frm_bus;