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

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

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

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

90: --
91: hr_api.set_legislation_context(l_legislation_code);
92: end if;
93: --
94: hr_utility.set_location(' Leaving:'|| l_proc, 20);
95: --
96: end set_security_group_id;
97: --
98: -- ---------------------------------------------------------------------------

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

121: l_proc varchar2(72) := g_package||'return_legislation_code';
122: --
123: Begin
124: --
125: hr_utility.set_location('Entering:'|| l_proc, 10);
126: --
127: -- Ensure that all the mandatory parameter are not null
128: --
129: hr_api.mandatory_arg_error

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

146: -- call to this function. Just return the value in the global
147: -- variable.
148: --
149: l_legislation_code := ota_cpr_bus.g_legislation_code;
150: hr_utility.set_location(l_proc, 20);
151: else
152: --
153: -- The ID is different to the last call to this function
154: -- or this is the first call to this function.

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

163: close csr_leg_code;
164: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
165: fnd_message.raise_error;
166: end if;
167: hr_utility.set_location(l_proc,30);
168: --
169: -- Set the global variables so the values are
170: -- available for the next call to this function.
171: --

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

173: ota_cpr_bus.g_activity_version_id := p_activity_version_id;
174: ota_cpr_bus.g_prerequisite_course_id := p_prerequisite_course_id;
175: ota_cpr_bus.g_legislation_code := l_legislation_code;
176: end if;
177: hr_utility.set_location(' Leaving:'|| l_proc, 40);
178: return l_legislation_code;
179: end return_legislation_code;
180: --
181: -- ----------------------------------------------------------------------------

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

258: where cpr.activity_version_id = p_activity_version_id
259: and cpr.prerequisite_course_id = p_prerequisite_course_id;
260: --
261: Begin
262: hr_utility.set_location('Entering:'|| l_proc, 5);
263: --
264: Open sel_unique_key;
265: fetch sel_unique_key into l_exists;
266: --

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

271: fnd_message.raise_error;
272: end if;
273: close sel_unique_key;
274: --
275: hr_utility.set_location(' Leaving:'|| l_proc, 10);
276: Exception
277: WHEN app_exception.application_exception THEN
278: IF hr_multi_message.exception_add(
279: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',

Line 282: hr_utility.set_location(' Leaving:'||l_proc, 22);

278: IF hr_multi_message.exception_add(
279: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
280: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
281: THEN
282: hr_utility.set_location(' Leaving:'||l_proc, 22);
283: RAISE;
284:
285: END IF;
286: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 286: hr_utility.set_location(' Leaving:'||l_proc, 25);

282: hr_utility.set_location(' Leaving:'||l_proc, 22);
283: RAISE;
284:
285: END IF;
286: hr_utility.set_location(' Leaving:'||l_proc, 25);
287: End check_unique_key;
288: --
289: -- ----------------------------------------------------------------------------
290: -- |----------------------------< check_prereq_course_expiry >----------------|

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

308: l_proc varchar2(72) := g_package||'check_prereq_course_expiry';
309: --
310: Begin
311: --
312: hr_utility.set_location('Entering:'|| l_proc, 5);
313: --
314: Open get_prereq_crs_end_date;
315: fetch get_prereq_crs_end_date into l_prereq_crs_end_date;
316: close get_prereq_crs_end_date;

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

319: fnd_message.set_name('OTA', 'OTA_443751_PREREQ_CRS_EXPIRED');
320: fnd_message.raise_error;
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'|| l_proc, 10);
324:
325: Exception
326: WHEN app_exception.application_exception THEN
327: IF hr_multi_message.exception_add(

Line 331: hr_utility.set_location(' Leaving:'||l_proc, 22);

327: IF hr_multi_message.exception_add(
328: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
329: THEN
330:
331: hr_utility.set_location(' Leaving:'||l_proc, 22);
332: RAISE;
333:
334: END IF;
335: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 335: hr_utility.set_location(' Leaving:'||l_proc, 25);

331: hr_utility.set_location(' Leaving:'||l_proc, 22);
332: RAISE;
333:
334: END IF;
335: hr_utility.set_location(' Leaving:'||l_proc, 25);
336: --
337: End check_prereq_course_expiry;
338: --
339: -- ----------------------------------------------------------------------------

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

361: l_proc varchar2(72) := g_package||'check_course_start_date';
362: --
363: Begin
364: --
365: hr_utility.set_location('Entering:'|| l_proc, 5);
366: --
367: Open get_course_start_date(p_activity_version_id);
368: fetch get_course_start_date into l_dest_course_start_date;
369: close get_course_start_date;

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

376: fnd_message.set_name('OTA', 'OTA_443708_CRS_PREREQ_ST_DT_GR');
377: fnd_message.raise_error;
378: End If;
379: --
380: hr_utility.set_location(' Leaving:'|| l_proc, 10);
381:
382: Exception
383: WHEN app_exception.application_exception THEN
384: IF hr_multi_message.exception_add(

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

385: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
386: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
387: THEN
388:
389: hr_utility.set_location(' Leaving:'||l_proc, 22);
390: RAISE;
391:
392: END IF;
393: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 393: hr_utility.set_location(' Leaving:'||l_proc, 25);

389: hr_utility.set_location(' Leaving:'||l_proc, 22);
390: RAISE;
391:
392: END IF;
393: hr_utility.set_location(' Leaving:'||l_proc, 25);
394: --
395: End check_course_start_date;
396: --
397: -- ----------------------------------------------------------------------------

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

420: l_flag varchar2(1);
421: --
422: Begin
423: --
424: hr_utility.set_location('Entering:'|| l_proc, 5);
425: --
426: Open get_valid_classes;
427: fetch get_valid_classes into l_flag;
428:

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

434: End If;
435: close get_valid_classes;
436:
437: --
438: hr_utility.set_location(' Leaving:'|| l_proc, 10);
439:
440: Exception
441: WHEN app_exception.application_exception THEN
442:

Line 447: hr_utility.set_location(' Leaving:'||l_proc, 22);

443: IF hr_multi_message.exception_add(
444: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
445: THEN
446:
447: hr_utility.set_location(' Leaving:'||l_proc, 22);
448: RAISE;
449:
450: END IF;
451: hr_utility.set_location(' Leaving:'||l_proc, 25);

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

447: hr_utility.set_location(' Leaving:'||l_proc, 22);
448: RAISE;
449:
450: END IF;
451: hr_utility.set_location(' Leaving:'||l_proc, 25);
452: --
453: End check_valid_classes_available;
454: --
455: -- ----------------------------------------------------------------------------

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

480: l_flag varchar2(1);
481: --
482: Begin
483: --
484: hr_utility.set_location('Entering:'|| l_proc, 5);
485: --
486: if ( p_activity_version_id = p_prerequisite_course_id ) then
487: fnd_message.set_name('OTA', 'OTA_443727_CRS_PREREQ_CHAINING');
488: fnd_message.raise_error;

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

499: close is_course_chained;
500: end if;
501:
502: --
503: hr_utility.set_location(' Leaving:'|| l_proc, 10);
504:
505: Exception
506: WHEN app_exception.application_exception THEN
507:

Line 513: hr_utility.set_location(' Leaving:'||l_proc, 22);

509: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
510: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
511: THEN
512:
513: hr_utility.set_location(' Leaving:'||l_proc, 22);
514: RAISE;
515:
516: END IF;
517: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 517: hr_utility.set_location(' Leaving:'||l_proc, 25);

513: hr_utility.set_location(' Leaving:'||l_proc, 22);
514: RAISE;
515:
516: END IF;
517: hr_utility.set_location(' Leaving:'||l_proc, 25);
518: --
519: End check_course_chaining;
520: --
521: -- ----------------------------------------------------------------------------

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

528: --
529: l_proc varchar2(72) := g_package||'insert_validate';
530: --
531: Begin
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: -- Call all supporting business operations
535: --
536:

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

560: check_course_chaining( p_rec.activity_version_id
561: , p_rec.prerequisite_course_id );
562:
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: End insert_validate;
566: --
567: -- ----------------------------------------------------------------------------
568: -- |---------------------------< update_validate >----------------------------|

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

574: --
575: l_proc varchar2(72) := g_package||'update_validate';
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Call all supporting business operations
581: --
582:

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

598: ,p_rec => p_rec
599: );
600: --
601: --
602: hr_utility.set_location(' Leaving:'||l_proc, 10);
603: End update_validate;
604: --
605: -- ----------------------------------------------------------------------------
606: -- |---------------------------< delete_validate >----------------------------|

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

611: --
612: l_proc varchar2(72) := g_package||'delete_validate';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);
616: --
617: -- Call all supporting business operations
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

615: hr_utility.set_location('Entering:'||l_proc, 5);
616: --
617: -- Call all supporting business operations
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
620: End delete_validate;
621: --
622: end ota_cpr_bus;