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

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

53: l_legislation_code varchar2(150);
54: --
55: begin
56: --
57: hr_utility.set_location('Entering:'|| l_proc, 10);
58: --
59: -- Ensure that all the mandatory parameter are not null
60: --
61: hr_api.mandatory_arg_error

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

107: --
108: hr_api.set_legislation_context(l_legislation_code);
109: end if;
110: --
111: hr_utility.set_location(' Leaving:'|| l_proc, 20);
112: --
113: end set_security_group_id;
114: --
115: -- ---------------------------------------------------------------------------

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

146: l_proc varchar2(72) := g_package||'return_legislation_code';
147: --
148: Begin
149: --
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Ensure that all the mandatory parameter are not null
153: --
154: hr_api.mandatory_arg_error

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

178: -- call to this function. Just return the value in the global
179: -- variable.
180: --
181: l_legislation_code := ota_coi_bus.g_legislation_code;
182: hr_utility.set_location(l_proc, 20);
183: else
184: --
185: -- The ID is different to the last call to this function
186: -- or this is the first call to this function.

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

195: close csr_leg_code;
196: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: end if;
199: hr_utility.set_location(l_proc,30);
200: --
201: -- Set the global variables so the values are
202: -- available for the next call to this function.
203: --

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

206: ota_coi_bus.g_object_id := p_object_id;
207: ota_coi_bus.g_object_type := p_object_type;
208: ota_coi_bus.g_legislation_code := l_legislation_code;
209: end if;
210: hr_utility.set_location(' Leaving:'|| l_proc, 40);
211: return l_legislation_code;
212: end return_legislation_code;
213: --
214: -- ----------------------------------------------------------------------------

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

292: and coi.object_id = p_object_id
293: and coi.object_type = 'C';
294: --
295: Begin
296: hr_utility.set_location('Entering:'|| v_proc, 5);
297: --
298: Open sel_unique_key;
299: fetch sel_unique_key into v_exists;
300: --

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

305: fnd_message.raise_error;
306: end if;
307: close sel_unique_key;
308: --
309: hr_utility.set_location(' Leaving:'|| v_proc, 10);
310: Exception
311: WHEN app_exception.application_exception THEN
312:
313: IF hr_multi_message.exception_add(

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

313: IF hr_multi_message.exception_add(
314: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.chat_id',
315: p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.object_id')
316: THEN
317: hr_utility.set_location(' Leaving:'||v_proc, 22);
318: RAISE;
319:
320: END IF;
321: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

317: hr_utility.set_location(' Leaving:'||v_proc, 22);
318: RAISE;
319:
320: END IF;
321: hr_utility.set_location(' Leaving:'||v_proc, 25);
322: End check_unique_key;
323: --
324: -- ----------------------------------------------------------------------------
325: -- |--------------------------< check_chat_category_dates >------------------------|

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

361: l_chat_start_date date;
362: l_chat_end_date date;
363:
364: Begin
365: hr_utility.set_location(' Entering:' || l_proc,10);
366: --
367: IF hr_multi_message.no_exclusive_error
368: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
369: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'

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

393: CLOSE csr_chat_start_end_date;
394: End IF;
395: End IF;
396: --
397: hr_utility.set_location(' Leaving:' || l_proc,10);
398: Exception
399: when app_exception.application_exception then
400: IF hr_multi_message.exception_add
401: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'

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

400: IF hr_multi_message.exception_add
401: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
402: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
403: ) THEN
404: hr_utility.set_location(' Leaving:'|| l_proc,20);
405: raise;
406: END IF;
407:
408: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

404: hr_utility.set_location(' Leaving:'|| l_proc,20);
405: raise;
406: END IF;
407:
408: hr_utility.set_location(' Leaving:'|| l_proc,30);
409: --
410: End check_chat_category_dates;
411: --
412: -- ----------------------------------------------------------------------------

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

430: where coi.chat_id = p_chat_id
431: and coi.primary_flag = 'Y';
432: --
433: Begin
434: hr_utility.set_location('Entering:'|| v_proc, 5);
435: --
436: Open sel_multiple_primary;
437: fetch sel_multiple_primary into v_exists;
438: --

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

443: fnd_message.raise_error;
444: end if;
445: close sel_multiple_primary;
446: --
447: hr_utility.set_location(' Leaving:'|| v_proc, 10);
448:
449: Exception
450: WHEN app_exception.application_exception THEN
451:

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

453: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.PRIMARY_FLAG')
454:
455: THEN
456:
457: hr_utility.set_location(' Leaving:'||v_proc, 22);
458: RAISE;
459:
460: END IF;
461: End check_multiple_primary_ctgr;

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

485: and coi.object_id = p_object_id
486: and coi.primary_flag = 'Y';
487: --
488: Begin
489: hr_utility.set_location('Entering:'|| v_proc, 5);
490: --
491: Open sel_primary_category;
492: fetch sel_primary_category into v_exists;
493: --

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

498: fnd_message.raise_error;
499: end if;
500: close sel_primary_category;
501: --
502: hr_utility.set_location(' Leaving:'|| v_proc, 10);
503: Exception
504: WHEN app_exception.application_exception THEN
505:
506: IF hr_multi_message.exception_add(

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

507: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.PRIMARY_FLAG')
508:
509: THEN
510:
511: hr_utility.set_location(' Leaving:'||v_proc, 22);
512: RAISE;
513:
514: END IF;
515: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

511: hr_utility.set_location(' Leaving:'||v_proc, 22);
512: RAISE;
513:
514: END IF;
515: hr_utility.set_location(' Leaving:'||v_proc, 25);
516: End check_if_primary_category;
517: --
518: -- ----------------------------------------------------------------------------
519: -- |----------------------------< check_start_end_dates >-----------------|

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

532: v_proc varchar2(72) := g_package||'check_start_end_dates';
533: --
534: Begin
535: --
536: hr_utility.set_location('Entering:'|| v_proc, 5);
537: --
538: ota_general.check_start_end_dates( p_start_date, p_end_date);
539: --
540: hr_utility.set_location(' Leaving:'|| v_proc, 10);

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

536: hr_utility.set_location('Entering:'|| v_proc, 5);
537: --
538: ota_general.check_start_end_dates( p_start_date, p_end_date);
539: --
540: hr_utility.set_location(' Leaving:'|| v_proc, 10);
541:
542: Exception
543: WHEN app_exception.application_exception THEN
544:

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

546: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.START_DATE_ACTIVE'
547: ,p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.END_DATE_ACTIVE')
548: THEN
549:
550: hr_utility.set_location(' Leaving:'||v_proc, 22);
551: RAISE;
552:
553: END IF;
554: hr_utility.set_location(' Leaving:'||v_proc, 25);

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

550: hr_utility.set_location(' Leaving:'||v_proc, 22);
551: RAISE;
552:
553: END IF;
554: hr_utility.set_location(' Leaving:'||v_proc, 25);
555: --
556: End check_start_end_dates;
557: --
558:

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

569: --
570: l_proc varchar2(72) := g_package||'insert_validate';
571: --
572: Begin
573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: -- Call all supporting business operations
576: --
577: --

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

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

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

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

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

632: ,p_rec => p_rec
633: );
634: --
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 10);
637: End update_validate;
638: --
639: -- ----------------------------------------------------------------------------
640: -- |---------------------------< delete_validate >----------------------------|

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

645: --
646: l_proc varchar2(72) := g_package||'delete_validate';
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Call all supporting business operations
652: --
653: -- check_if_primary_category(p_rec.chat_id, p_rec.object_id);

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

651: -- Call all supporting business operations
652: --
653: -- check_if_primary_category(p_rec.chat_id, p_rec.object_id);
654:
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End delete_validate;
657: --
658: end ota_coi_bus;