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

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

144: where option_type_id = p_option_type_id;
145:
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc,10);
149:
150: hr_api.mandatory_arg_error
151: (p_api_name => l_proc
152: ,p_argument => 'OPTION_TYPE_ID'

Line 158: hr_utility.set_location('After fetching:'||l_proc,20);

154: );
155:
156: open csr_name;
157: fetch csr_name into l_key;
158: hr_utility.set_location('After fetching:'||l_proc,20);
159: if (csr_name%notfound) then
160: close csr_name;
161: fnd_message.set_name('PER','PER_449953_OPT_OP_TY_ID_ABSENT');
162: fnd_message.raise_error;

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

163: end if;
164:
165: close csr_name;
166:
167: hr_utility.set_location(' Leaving:'||l_proc,30);
168: exception
169: when app_exception.application_exception then
170: if hr_multi_message.exception_add
171: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'

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

169: when app_exception.application_exception then
170: if hr_multi_message.exception_add
171: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
172: )then
173: hr_utility.set_location(' Leaving:'||l_proc, 40);
174: raise;
175: end if;
176: hr_utility.set_location(' Leaving:'||l_proc,50);
177: End CHK_OPTION_TYPE_ID;

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

172: )then
173: hr_utility.set_location(' Leaving:'||l_proc, 40);
174: raise;
175: end if;
176: hr_utility.set_location(' Leaving:'||l_proc,50);
177: End CHK_OPTION_TYPE_ID;
178:
179: -- ----------------------------------------------------------------------------
180: -- |-----------------------< CHK_OPTION_LEVEL>------------------------|

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

206: --
207: l_proc varchar2(72) := g_package || 'CHK_OPTION_LEVEL';
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211:
212: hr_api.mandatory_arg_error
213: (p_api_name => l_proc
214: ,p_argument => 'OPTION_LEVEL'

Line 219: hr_utility.set_location('validating:'||l_proc,20);

215: ,p_argument_value => p_option_level
216: );
217:
218:
219: hr_utility.set_location('validating:'||l_proc,20);
220:
221: --Is it neccessary to validate against not_exists_in_fnd_lookups?
222: if hr_api.not_exists_in_hrstanlookups
223: (p_effective_date => p_effective_date

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

232: when app_exception.application_exception then
233: if hr_multi_message.exception_add
234: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
235: )then
236: hr_utility.set_location(' Leaving:'||l_proc, 30);
237: raise;
238: end if;
239: hr_utility.set_location(' Leaving:'||l_proc,40);
240: End CHK_OPTION_LEVEL;

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

235: )then
236: hr_utility.set_location(' Leaving:'||l_proc, 30);
237: raise;
238: end if;
239: hr_utility.set_location(' Leaving:'||l_proc,40);
240: End CHK_OPTION_LEVEL;
241:
242:
243: -- ----------------------------------------------------------------------------

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

309:
310:
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc,10);
314:
315: -- Only proceed with OPTION_LEVEL_ID validation when the
316: -- Multiple Message List does not already contain an errors
317: -- associated with the OPTION_LEVEL column.

Line 335: hr_utility.set_location('level id is not null:'||l_proc, 20);

331: ,p_argument => 'OPTION_LEVEL_ID'
332: ,p_argument_value => p_option_level_id
333: );
334:
335: hr_utility.set_location('level id is not null:'||l_proc, 20);
336:
337: --if level is application
338: --check validity of id against fnd_application table
339: IF p_option_level=l_app_value THEN

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

431: when app_exception.application_exception then
432: if hr_multi_message.exception_add
433: (p_same_associated_columns => 'Y'
434: )then
435: hr_utility.set_location(' Leaving:'||l_proc, 30);
436: raise;
437: end if;
438: hr_utility.set_location(' Leaving:'||l_proc,40);
439: End CHK_OPTION_LEVEL_ID;

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

434: )then
435: hr_utility.set_location(' Leaving:'||l_proc, 30);
436: raise;
437: end if;
438: hr_utility.set_location(' Leaving:'||l_proc,40);
439: End CHK_OPTION_LEVEL_ID;
440:
441: -- ----------------------------------------------------------------------------
442: -- |-----------------------< CHK_ENCRYPTED>-----------------------------------|

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

467: --
468: l_proc varchar2(72) := g_package || 'CHK_ENCRYPTED';
469: --
470: Begin
471: hr_utility.set_location('Entering:'||l_proc,10);
472:
473: --encrypted column should not be null
474: hr_api.mandatory_arg_error
475: (p_api_name => l_proc

Line 480: hr_utility.set_location('validating:'||l_proc,20);

476: ,p_argument => 'ENCRYPTED'
477: ,p_argument_value => p_encrypted
478: );
479:
480: hr_utility.set_location('validating:'||l_proc,20);
481:
482: if upper(p_encrypted) ='Y' or upper(p_encrypted)='N' then
483: null;
484: else

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

491: when app_exception.application_exception then
492: if hr_multi_message.exception_add
493: (p_associated_column1 => 'HR_KI_OPTIONS.ENCRYPTED'
494: )then
495: hr_utility.set_location(' Leaving:'||l_proc, 30);
496: raise;
497: end if;
498: hr_utility.set_location(' Leaving:'||l_proc,40);
499: End CHK_ENCRYPTED;

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

494: )then
495: hr_utility.set_location(' Leaving:'||l_proc, 30);
496: raise;
497: end if;
498: hr_utility.set_location(' Leaving:'||l_proc,40);
499: End CHK_ENCRYPTED;
500:
501: -- ----------------------------------------------------------------------------
502: -- |-----------------------< chk_integration_id>------------------------|

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

535:
536:
537: --
538: Begin
539: hr_utility.set_location('Entering:'||l_proc,10);
540:
541: --integration_id should not be null
542:
543: hr_api.mandatory_arg_error

Line 550: hr_utility.set_location('Validating:'||l_proc,20);

546: ,p_argument_value => p_integration_id
547: );
548:
549:
550: hr_utility.set_location('Validating:'||l_proc,20);
551:
552:
553: open csr_int;
554: fetch csr_int into l_key;

Line 555: hr_utility.set_location('After fetching :'||l_proc,30);

551:
552:
553: open csr_int;
554: fetch csr_int into l_key;
555: hr_utility.set_location('After fetching :'||l_proc,30);
556: if (csr_int%notfound) then
557: close csr_int;
558: fnd_message.set_name('PER','PER_449955_OPT_INT_ID_ABSENT');
559: fnd_message.raise_error;

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

559: fnd_message.raise_error;
560: end if;
561: close csr_int;
562:
563: hr_utility.set_location(' Leaving:'||l_proc,40);
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'HR_KI_OPTIONS.INTEGRATION_ID'

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

565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'HR_KI_OPTIONS.INTEGRATION_ID'
568: )then
569: hr_utility.set_location(' Leaving:'||l_proc, 50);
570: raise;
571: end if;
572: hr_utility.set_location(' Leaving:'||l_proc,60);
573: End chk_integration_id;

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

568: )then
569: hr_utility.set_location(' Leaving:'||l_proc, 50);
570: raise;
571: end if;
572: hr_utility.set_location(' Leaving:'||l_proc,60);
573: End chk_integration_id;
574:
575:
576:

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

619: and (option_level_id=p_option_level_id
620: or option_level_id is null);
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc,10);
624:
625: -- Only proceed with unique record validation when the
626: -- Multiple Message List does not already contain an errors
627: -- associated with the OPTION_TYPE_ID,INTEGRATION_ID,OPTION_LEVEL

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

654: when app_exception.application_exception then
655: if hr_multi_message.exception_add
656: (p_same_associated_columns => 'Y'
657: )then
658: hr_utility.set_location(' Leaving:'||l_proc, 40);
659: raise;
660: end if;
661: hr_utility.set_location(' Leaving:'||l_proc,50);
662: End CHK_UNIQUE_RECORD;

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

657: )then
658: hr_utility.set_location(' Leaving:'||l_proc, 40);
659: raise;
660: end if;
661: hr_utility.set_location(' Leaving:'||l_proc,50);
662: End CHK_UNIQUE_RECORD;
663:
664:
665: --

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

673: --
674: l_proc varchar2(72) := g_package||'insert_validate';
675: --
676: Begin
677: hr_utility.set_location('Entering:'||l_proc, 5);
678: --
679: -- Call all supporting business operations
680: --
681: --

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

721: ,p_option_level_id =>p_rec.option_level_id
722:
723: );
724:
725: hr_utility.set_location(' Leaving:'||l_proc, 10);
726: End insert_validate;
727: --
728: -- ----------------------------------------------------------------------------
729: -- |---------------------------< update_validate >----------------------------|

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

735: --
736: l_proc varchar2(72) := g_package||'update_validate';
737: --
738: Begin
739: hr_utility.set_location('Entering:'||l_proc, 5);
740: --
741: -- Call all supporting business operations
742: --
743: --

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

757: ,p_value =>p_rec.value
758: );
759: --
760: --
761: hr_utility.set_location(' Leaving:'||l_proc, 10);
762: End update_validate;
763: --
764: -- ----------------------------------------------------------------------------
765: -- |---------------------------< delete_validate >----------------------------|

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

770: --
771: l_proc varchar2(72) := g_package||'delete_validate';
772: --
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777: --
778: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777: --
778: hr_utility.set_location(' Leaving:'||l_proc, 10);
779: End delete_validate;
780: --
781: end hr_opt_bus;