DBA Data[Home] [Help]

APPS.PER_SEU_BUS dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := 'per_seu_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

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

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

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

95: --
96: hr_api.set_legislation_context(l_legislation_code);
97: end if;
98: --
99: hr_utility.set_location(' Leaving:'|| l_proc, 20);
100: --
101: end set_security_group_id;
102: --
103: -- ---------------------------------------------------------------------------

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

134: l_proc varchar2(72) := g_package||'return_legislation_code';
135: --
136: Begin
137: --
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- Ensure that all the mandatory parameter are not null
141: --
142: hr_api.mandatory_arg_error

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

152: -- call to this function. Just return the value in the global
153: -- variable.
154: --
155: l_legislation_code := per_seu_bus.g_legislation_code;
156: hr_utility.set_location(l_proc, 20);
157: else
158: --
159: -- The ID is different to the last call to this function
160: -- or this is the first call to this function.

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

173: close csr_leg_code;
174: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
175: fnd_message.raise_error;
176: end if;
177: hr_utility.set_location(l_proc,30);
178: --
179: -- Set the global variables so the values are
180: -- available for the next call to this function.
181: --

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

182: close csr_leg_code;
183: per_seu_bus.g_security_user_id := p_security_user_id;
184: per_seu_bus.g_legislation_code := l_legislation_code;
185: end if;
186: hr_utility.set_location(' Leaving:'|| l_proc, 40);
187: return l_legislation_code;
188: end return_legislation_code;
189: --
190: -- ----------------------------------------------------------------------------

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

272: --
273: Begin
274:
275: IF g_debug THEN
276: hr_utility.set_location('Entering: '||l_proc, 10);
277: END IF;
278:
279: --
280: -- Only proceed with validation if:

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

306: -- If the user_id is null, the user either does not exist, or
307: -- is not effective as of the effective date passed in.
308: --
309: IF g_debug THEN
310: hr_utility.set_location(l_proc, 20);
311: END IF;
312:
313: hr_utility.set_message(800, 'HR_50128_INVALID_USER');
314: hr_multi_message.add

Line 313: hr_utility.set_message(800, 'HR_50128_INVALID_USER');

309: IF g_debug THEN
310: hr_utility.set_location(l_proc, 20);
311: END IF;
312:
313: hr_utility.set_message(800, 'HR_50128_INVALID_USER');
314: hr_multi_message.add
315: (p_associated_column1 => 'PER_SECURITY_USERS.USER_ID');
316:
317: END IF;

Line 320: hr_utility.set_location(' Leaving:'|| l_proc, 999);

316:
317: END IF;
318:
319: IF g_debug THEN
320: hr_utility.set_location(' Leaving:'|| l_proc, 999);
321: END IF;
322:
323: End chk_user_id;
324: --

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

350: --
351: Begin
352:
353: IF g_debug THEN
354: hr_utility.set_location('Entering: '||l_proc, 10);
355: END IF;
356:
357: --
358: -- Only proceed with validation if:

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

384: -- If the security_profile_id is null, then the security profile
385: -- does not exist.
386: --
387: IF g_debug THEN
388: hr_utility.set_location(l_proc, 20);
389: END IF;
390:
391: hr_utility.set_message(800, 'HR_50143_INVALID_SEC_PROF');
392: hr_multi_message.add

Line 391: hr_utility.set_message(800, 'HR_50143_INVALID_SEC_PROF');

387: IF g_debug THEN
388: hr_utility.set_location(l_proc, 20);
389: END IF;
390:
391: hr_utility.set_message(800, 'HR_50143_INVALID_SEC_PROF');
392: hr_multi_message.add
393: (p_associated_column1 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID');
394:
395: END IF;

Line 398: hr_utility.set_location(' Leaving:'|| l_proc, 999);

394:
395: END IF;
396:
397: IF g_debug THEN
398: hr_utility.set_location(' Leaving:'|| l_proc, 999);
399: END IF;
400:
401: END chk_security_profile_id;
402: --

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

432: --
433: Begin
434:
435: IF g_debug THEN
436: hr_utility.set_location('Entering: '||l_proc, 10);
437: END IF;
438:
439: --
440: -- Only proceed with validation if:

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

461: --
462: -- Only proceed if the dependent validation has not errored.
463: --
464: IF g_debug THEN
465: hr_utility.set_location(l_proc, 20);
466: END IF;
467:
468: OPEN csr_chk_unique;
469: FETCH csr_chk_unique INTO l_user_id;

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

474: -- If the user_id is set then this user / security profile association
475: -- is not unique; raise an error.
476: --
477: IF g_debug THEN
478: hr_utility.set_location(l_proc, 30);
479: END IF;
480:
481: hr_utility.set_message(800, 'HR_50145_SEU_NOT_UNIQUE');
482: hr_multi_message.add

Line 481: hr_utility.set_message(800, 'HR_50145_SEU_NOT_UNIQUE');

477: IF g_debug THEN
478: hr_utility.set_location(l_proc, 30);
479: END IF;
480:
481: hr_utility.set_message(800, 'HR_50145_SEU_NOT_UNIQUE');
482: hr_multi_message.add
483: (p_associated_column1 => 'PER_SECURITY_USERS.USER_ID'
484: ,p_associated_column2 => 'PER_SECURITY_USERS.SECURITY_PROFILE_ID');
485:

Line 491: hr_utility.set_location(' Leaving:'|| l_proc, 999);

487:
488: END IF;
489:
490: IF g_debug THEN
491: hr_utility.set_location(' Leaving:'|| l_proc, 999);
492: END IF;
493:
494: END chk_association_unique;
495: --

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

513: --
514: Begin
515:
516: IF g_debug THEN
517: hr_utility.set_location('Entering: '||l_proc, 10);
518: END IF;
519: --
520: -- Only proceed with validation if:
521: -- a) inserting or

Line 541: hr_utility.set_message(800, 'HR_50292_INVALID_PINR_FLAG');

537: --
538: -- If the process_in_next_run_flag is not null, Y or N
539: -- raise an error message informing the user of this fact.
540: --
541: hr_utility.set_message(800, 'HR_50292_INVALID_PINR_FLAG');
542: hr_multi_message.add
543: (p_associated_column1 => 'PER_SECURITY_USERS.PROCESS_IN_NEXT_RUN_FLAG');
544:
545: IF g_debug THEN

Line 546: hr_utility.set_location(l_proc, 69);

542: hr_multi_message.add
543: (p_associated_column1 => 'PER_SECURITY_USERS.PROCESS_IN_NEXT_RUN_FLAG');
544:
545: IF g_debug THEN
546: hr_utility.set_location(l_proc, 69);
547: hr_utility.set_location('process_in_next_run_flag is not null Y or N',69);
548: END IF;
549: END IF;
550:

Line 547: hr_utility.set_location('process_in_next_run_flag is not null Y or N',69);

543: (p_associated_column1 => 'PER_SECURITY_USERS.PROCESS_IN_NEXT_RUN_FLAG');
544:
545: IF g_debug THEN
546: hr_utility.set_location(l_proc, 69);
547: hr_utility.set_location('process_in_next_run_flag is not null Y or N',69);
548: END IF;
549: END IF;
550:
551: IF g_debug THEN

Line 552: hr_utility.set_location(' Leaving:'|| l_proc, 999);

548: END IF;
549: END IF;
550:
551: IF g_debug THEN
552: hr_utility.set_location(' Leaving:'|| l_proc, 999);
553: END IF;
554:
555: END chk_process_in_next_run_flag;
556: --

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

566: --
567: Begin
568:
569: IF g_debug THEN
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: END IF;
572:
573: --
574: -- Call all supporting business operations

Line 596: hr_utility.set_location(l_proc, 10);

592: ,p_security_profile_id => p_rec.security_profile_id
593: ,p_object_version_number => p_rec.object_version_number);
594:
595: IF g_debug THEN
596: hr_utility.set_location(l_proc, 10);
597: END IF;
598:
599: --
600: -- Validate the user.

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

618: --
619: hr_multi_message.end_validation_set;
620:
621: IF g_debug THEN
622: hr_utility.set_location(l_proc, 20);
623: END IF;
624:
625: --
626: -- Dependent validation.

Line 637: hr_utility.set_location(' Leaving:'||l_proc, 999);

633: ,p_security_profile_id => p_rec.security_profile_id
634: ,p_object_version_number => p_rec.object_version_number);
635:
636: IF g_debug THEN
637: hr_utility.set_location(' Leaving:'||l_proc, 999);
638: END IF;
639:
640: End insert_validate;
641: --

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

651: --
652: Begin
653:
654: IF g_debug THEN
655: hr_utility.set_location('Entering:'||l_proc, 5);
656: END IF;
657:
658: --
659: -- Call all supporting business operations

Line 685: hr_utility.set_location(l_proc, 10);

681: ,p_security_profile_id => p_rec.security_profile_id
682: ,p_object_version_number => p_rec.object_version_number);
683:
684: IF g_debug THEN
685: hr_utility.set_location(l_proc, 10);
686: END IF;
687:
688: --
689: -- Validate the user.

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

707: --
708: hr_multi_message.end_validation_set;
709:
710: IF g_debug THEN
711: hr_utility.set_location(l_proc, 20);
712: END IF;
713:
714: --
715: -- Dependent validation.

Line 726: hr_utility.set_location(' Leaving:'||l_proc, 999);

722: ,p_security_profile_id => p_rec.security_profile_id
723: ,p_object_version_number => p_rec.object_version_number);
724:
725: IF g_debug THEN
726: hr_utility.set_location(' Leaving:'||l_proc, 999);
727: END IF;
728:
729: End update_validate;
730: --

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

737: --
738: l_proc varchar2(72) := g_package||'delete_validate';
739: --
740: Begin
741: hr_utility.set_location('Entering:'||l_proc, 5);
742: --
743: -- Call all supporting business operations
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

741: hr_utility.set_location('Entering:'||l_proc, 5);
742: --
743: -- Call all supporting business operations
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 10);
746: End delete_validate;
747: --
748: end per_seu_bus;