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

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := pay_etu_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: pay_etu_bus.g_element_type_usage_id:= p_element_type_usage_id;
142: pay_etu_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

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

196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: hr_utility.set_location(l_proc, 10);
201: --
202: if nvl(p_rec.business_group_id, hr_api.g_number) <>
203: nvl(pay_etu_shd.g_old_rec.business_group_id, hr_api.g_number) then
204: l_argument := 'business_group_id';

Line 207: hr_utility.set_location(l_proc, 15);

203: nvl(pay_etu_shd.g_old_rec.business_group_id, hr_api.g_number) then
204: l_argument := 'business_group_id';
205: raise l_error;
206: end if;
207: hr_utility.set_location(l_proc, 15);
208: --
209: if nvl(p_rec.element_type_usage_id,hr_api.g_number) <>
210: nvl(pay_etu_shd.g_old_rec.element_type_usage_id,hr_api.g_number) then
211: l_argument := 'element_type_usage_id';

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

210: nvl(pay_etu_shd.g_old_rec.element_type_usage_id,hr_api.g_number) then
211: l_argument := 'element_type_usage_id';
212: raise l_error;
213: end if;
214: hr_utility.set_location(l_proc, 20);
215: --
216: if nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
217: nvl(pay_etu_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
218: l_argument := 'legislation_code';

Line 221: hr_utility.set_location(l_proc, 25);

217: nvl(pay_etu_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
218: l_argument := 'legislation_code';
219: raise l_error;
220: end if;
221: hr_utility.set_location(l_proc, 25);
222: --
223: if nvl(p_rec.element_type_id, hr_api.g_number) <>
224: nvl(pay_etu_shd.g_old_rec.element_type_id, hr_api.g_number) then
225: l_argument := 'element_type_id';

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

224: nvl(pay_etu_shd.g_old_rec.element_type_id, hr_api.g_number) then
225: l_argument := 'element_type_id';
226: raise l_error;
227: end if;
228: hr_utility.set_location(l_proc, 30);
229: --
230: if nvl(p_rec.run_type_id,hr_api.g_number) <>
231: nvl(pay_etu_shd.g_old_rec.run_type_id,hr_api.g_number) then
232: l_argument := 'run_type_id';

Line 235: hr_utility.set_location(l_proc, 35);

231: nvl(pay_etu_shd.g_old_rec.run_type_id,hr_api.g_number) then
232: l_argument := 'run_type_id';
233: raise l_error;
234: end if;
235: hr_utility.set_location(l_proc, 35);
236: --
237: --commented out as not required
238: /* if nvl(p_rec.inclusion_flag,hr_api.g_varchar2) <>
239: nvl(pay_etu_shd.g_old_rec.inclusion_flag,hr_api.g_varchar2) then

Line 243: hr_utility.set_location(l_proc, 40);

239: nvl(pay_etu_shd.g_old_rec.inclusion_flag,hr_api.g_varchar2) then
240: l_argument := 'inclusion_flag';
241: raise l_error;
242: end if;
243: hr_utility.set_location(l_proc, 40);
244: --
245: if nvl(p_rec.usage_type,hr_api.g_varchar2) <>
246: nvl(pay_etu_shd.g_old_rec.usage_type,hr_api.g_varchar2) then
247: l_argument := 'usage_type';

Line 250: hr_utility.set_location(l_proc, 50);

246: nvl(pay_etu_shd.g_old_rec.usage_type,hr_api.g_varchar2) then
247: l_argument := 'usage_type';
248: raise l_error;
249: end if;*/
250: hr_utility.set_location(l_proc, 50);
251: --
252: EXCEPTION
253: WHEN l_error THEN
254: hr_api.argument_changed_error

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

351: and prt.legislation_code is null;
352: --
353: BEGIN
354: --
355: hr_utility.set_location('Entering: '|| l_proc, 5);
356: --
357: -- Only execute the cursor if absolutely necessary.
358: -- a) During update, the run_type_id has actually changed to another not
359: -- null value, i,e, the value passed to this procedure is different to the

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

367: nvl(pay_etu_shd.g_old_rec.run_type_id, hr_api.g_number) <>
368: nvl(p_run_type_id, hr_api.g_number)) or
369: (p_element_type_usage_id is null)) THEN
370: --
371: hr_utility.set_location(l_proc, 10);
372: --
373: -- Only need to open the cursor if run_type_id is not null
374: --
375: IF p_run_type_id is not null THEN

Line 378: hr_utility.set_location(l_proc, 15);

374: --
375: IF p_run_type_id is not null THEN
376: --
377: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
378: hr_utility.set_location(l_proc, 15);
379: --
380: OPEN csr_chk_generic_run_type;
381: FETCH csr_chk_generic_run_type INTO l_exists;
382: IF csr_chk_generic_run_type%NOTFOUND THEN

Line 385: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');

381: FETCH csr_chk_generic_run_type INTO l_exists;
382: IF csr_chk_generic_run_type%NOTFOUND THEN
383: --
384: CLOSE csr_chk_generic_run_type;
385: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
386: hr_utility.raise_error;
387: --
388: END IF;
389: CLOSE csr_chk_generic_run_type;

Line 386: hr_utility.raise_error;

382: IF csr_chk_generic_run_type%NOTFOUND THEN
383: --
384: CLOSE csr_chk_generic_run_type;
385: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
386: hr_utility.raise_error;
387: --
388: END IF;
389: CLOSE csr_chk_generic_run_type;
390: --

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

388: END IF;
389: CLOSE csr_chk_generic_run_type;
390: --
391: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
392: hr_utility.set_location(l_proc, 20);
393: --
394: OPEN csr_chk_startup_run_type;
395: FETCH csr_chk_startup_run_type INTO l_exists;
396: IF csr_chk_startup_run_type%NOTFOUND THEN

Line 399: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');

395: FETCH csr_chk_startup_run_type INTO l_exists;
396: IF csr_chk_startup_run_type%NOTFOUND THEN
397: --
398: CLOSE csr_chk_startup_run_type;
399: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
400: hr_utility.raise_error;
401: END IF;
402: CLOSE csr_chk_startup_run_type;
403: --

Line 400: hr_utility.raise_error;

396: IF csr_chk_startup_run_type%NOTFOUND THEN
397: --
398: CLOSE csr_chk_startup_run_type;
399: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
400: hr_utility.raise_error;
401: END IF;
402: CLOSE csr_chk_startup_run_type;
403: --
404: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

Line 405: hr_utility.set_location(l_proc, 25);

401: END IF;
402: CLOSE csr_chk_startup_run_type;
403: --
404: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
405: hr_utility.set_location(l_proc, 25);
406: --
407: IF p_element_type_usage_id is not null THEN
408: l_legislation_code := pay_etu_bus.return_legislation_code(p_element_type_usage_id);
409: ELSE

Line 418: hr_utility.set_message(801, 'HR_33589_INVALID_RUN_TYPE');

414: FETCH csr_chk_user_run_type INTO l_exists;
415: IF csr_chk_user_run_type%NOTFOUND THEN
416: --
417: CLOSE csr_chk_user_run_type;
418: hr_utility.set_message(801, 'HR_33589_INVALID_RUN_TYPE');
419: hr_utility.raise_error;
420: END IF;
421: CLOSE csr_chk_user_run_type;
422: --

Line 419: hr_utility.raise_error;

415: IF csr_chk_user_run_type%NOTFOUND THEN
416: --
417: CLOSE csr_chk_user_run_type;
418: hr_utility.set_message(801, 'HR_33589_INVALID_RUN_TYPE');
419: hr_utility.raise_error;
420: END IF;
421: CLOSE csr_chk_user_run_type;
422: --
423: END IF;

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

425: END IF;
426: --
427: END IF;
428: --
429: hr_utility.set_location('Leaving: '||l_proc, 30);
430: --
431: end chk_run_type_id;
432: --
433: -- ---------------------------------------------------------------------------

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

568: );
569: --
570: BEGIN
571: --
572: hr_utility.set_location('Entering: '|| l_proc, 5);
573: --
574: -- Only execute the cursor if absolutely necessary.
575: -- a) During update, the element_type_id has actually changed to another not
576: -- null value, i,e, the value passed to this procedure is different to the

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

584: nvl(pay_etu_shd.g_old_rec.element_type_id, hr_api.g_number) <>
585: nvl(p_element_type_id, hr_api.g_number)) or
586: (p_element_type_usage_id is null)) THEN
587: --
588: hr_utility.set_location(l_proc, 10);
589: --
590: -- Only need to open the cursor if element_type_id is not null
591: --
592: IF p_element_type_id is not null THEN

Line 595: hr_utility.set_location(l_proc, 15);

591: --
592: IF p_element_type_id is not null THEN
593: --
594: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
595: hr_utility.set_location(l_proc, 15);
596: --
597: OPEN csr_chk_generic_element_type;
598: FETCH csr_chk_generic_element_type INTO l_exists;
599: IF csr_chk_generic_element_type%NOTFOUND THEN

Line 602: hr_utility.set_message(801, 'HR_33588_ETU_INVAL_ET_FOR_MODE');

598: FETCH csr_chk_generic_element_type INTO l_exists;
599: IF csr_chk_generic_element_type%NOTFOUND THEN
600: --
601: CLOSE csr_chk_generic_element_type;
602: hr_utility.set_message(801, 'HR_33588_ETU_INVAL_ET_FOR_MODE');
603: hr_utility.raise_error;
604: --
605: END IF;
606: CLOSE csr_chk_generic_element_type;

Line 603: hr_utility.raise_error;

599: IF csr_chk_generic_element_type%NOTFOUND THEN
600: --
601: CLOSE csr_chk_generic_element_type;
602: hr_utility.set_message(801, 'HR_33588_ETU_INVAL_ET_FOR_MODE');
603: hr_utility.raise_error;
604: --
605: END IF;
606: CLOSE csr_chk_generic_element_type;
607: --

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

605: END IF;
606: CLOSE csr_chk_generic_element_type;
607: --
608: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
609: hr_utility.set_location(l_proc, 20);
610: --
611: OPEN csr_chk_startup_element_type;
612: FETCH csr_chk_startup_element_type INTO l_exists;
613: IF csr_chk_startup_element_type%NOTFOUND THEN

Line 616: hr_utility.set_message(801, 'HR_33588_ETU_INVAL_ET_FOR_MODE');

612: FETCH csr_chk_startup_element_type INTO l_exists;
613: IF csr_chk_startup_element_type%NOTFOUND THEN
614: --
615: CLOSE csr_chk_startup_element_type;
616: hr_utility.set_message(801, 'HR_33588_ETU_INVAL_ET_FOR_MODE');
617: hr_utility.raise_error;
618: END IF;
619: CLOSE csr_chk_startup_element_type;
620: --

Line 617: hr_utility.raise_error;

613: IF csr_chk_startup_element_type%NOTFOUND THEN
614: --
615: CLOSE csr_chk_startup_element_type;
616: hr_utility.set_message(801, 'HR_33588_ETU_INVAL_ET_FOR_MODE');
617: hr_utility.raise_error;
618: END IF;
619: CLOSE csr_chk_startup_element_type;
620: --
621: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

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

618: END IF;
619: CLOSE csr_chk_startup_element_type;
620: --
621: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
622: hr_utility.set_location(l_proc, 25);
623: --
624: IF p_element_type_usage_id is not null THEN
625: l_legislation_code := pay_etu_bus.return_legislation_code(p_element_type_usage_id);
626: ELSE

Line 635: hr_utility.set_message(801, 'HR_33590_ETU_INVALID_ELE_TYPE');

631: FETCH csr_chk_user_element_type INTO l_exists;
632: IF csr_chk_user_element_type%NOTFOUND THEN
633: --
634: CLOSE csr_chk_user_element_type;
635: hr_utility.set_message(801, 'HR_33590_ETU_INVALID_ELE_TYPE');
636: hr_utility.raise_error;
637: END IF;
638: CLOSE csr_chk_user_element_type;
639: --

Line 636: hr_utility.raise_error;

632: IF csr_chk_user_element_type%NOTFOUND THEN
633: --
634: CLOSE csr_chk_user_element_type;
635: hr_utility.set_message(801, 'HR_33590_ETU_INVALID_ELE_TYPE');
636: hr_utility.raise_error;
637: END IF;
638: CLOSE csr_chk_user_element_type;
639: --
640: END IF;

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

642: END IF;
643: --
644: END IF;
645: --
646: hr_utility.set_location('Leaving: '||l_proc, 30);
647: --
648: end chk_element_type_id;
649: --
650: -- ----------------------------------------------------------------------------

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

689: -- will not be able to add new lookup_codes. Thus only need to validate against
690: -- hr_standard_lookups, even though the table does have a business_group_id
691: -- and would expect to need to validate against hr_lookups.
692: --
693: hr_utility.set_location('Entering: '||l_proc,5);
694: --
695: IF (hr_api.not_exists_in_dt_hrstanlookups
696: (p_effective_date => p_effective_date
697: ,p_validation_start_date => p_validation_start_date

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

706: --
707: fnd_message.set_name('PAY','HR_33585_ETU_INCLUSION_FLAG_N');
708: fnd_message.raise_error;
709: --
710: hr_utility.set_location(l_proc,10);
711: END IF;
712: --
713: hr_utility.set_location('Leaving: '||l_proc,15);
714: --

Line 713: hr_utility.set_location('Leaving: '||l_proc,15);

709: --
710: hr_utility.set_location(l_proc,10);
711: END IF;
712: --
713: hr_utility.set_location('Leaving: '||l_proc,15);
714: --
715: End chk_inclusion_flag;
716: --
717: -- ---------------------------------------------------------------------------

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

756: l_proc varchar2(72) := g_package||'chk_bg_leg_code';
757: --
758: BEGIN
759: --
760: hr_utility.set_location('Entering: '|| l_proc, 5);
761: --
762: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
763: --
764: hr_utility.set_location(l_proc, 15);

Line 764: hr_utility.set_location(l_proc, 15);

760: hr_utility.set_location('Entering: '|| l_proc, 5);
761: --
762: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
763: --
764: hr_utility.set_location(l_proc, 15);
765: --
766: IF ((p_business_group_id is not null)
767: or (p_legislation_code is not null)) THEN
768: --

Line 769: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');

765: --
766: IF ((p_business_group_id is not null)
767: or (p_legislation_code is not null)) THEN
768: --
769: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
770: hr_utility.raise_error;
771: --
772: END IF;
773: --

Line 770: hr_utility.raise_error;

766: IF ((p_business_group_id is not null)
767: or (p_legislation_code is not null)) THEN
768: --
769: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
770: hr_utility.raise_error;
771: --
772: END IF;
773: --
774: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN

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

772: END IF;
773: --
774: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
775: --
776: hr_utility.set_location(l_proc, 20);
777: --
778: IF ((p_business_group_id is not null)
779: or (p_legislation_code is null)) THEN
780: --

Line 781: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');

777: --
778: IF ((p_business_group_id is not null)
779: or (p_legislation_code is null)) THEN
780: --
781: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
782: hr_utility.raise_error;
783: --
784: END IF;
785: --

Line 782: hr_utility.raise_error;

778: IF ((p_business_group_id is not null)
779: or (p_legislation_code is null)) THEN
780: --
781: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
782: hr_utility.raise_error;
783: --
784: END IF;
785: --
786: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

Line 788: hr_utility.set_location(l_proc, 25);

784: END IF;
785: --
786: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
787: --
788: hr_utility.set_location(l_proc, 25);
789: --
790: IF ((p_business_group_id is null)
791: or (p_legislation_code is not null)) THEN
792: --

Line 793: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');

789: --
790: IF ((p_business_group_id is null)
791: or (p_legislation_code is not null)) THEN
792: --
793: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
794: hr_utility.raise_error;
795: --
796: END IF;
797: --

Line 794: hr_utility.raise_error;

790: IF ((p_business_group_id is null)
791: or (p_legislation_code is not null)) THEN
792: --
793: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
794: hr_utility.raise_error;
795: --
796: END IF;
797: --
798: END IF;

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

796: END IF;
797: --
798: END IF;
799: --
800: hr_utility.set_location('Leaving: '||l_proc, 30);
801: --
802: end chk_bg_leg_code;
803: --
804: -- ----------------------------------------------------------------------------

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

1077: --
1078: l_proc varchar2(72) := g_package||'insert_validate';
1079: --
1080: Begin
1081: hr_utility.set_location('Entering:'||l_proc, 5);
1082: --
1083: -- Call all supporting business operations
1084: --
1085: chk_startup_action(True

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

1088: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1089: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1090: END IF;
1091: --
1092: hr_utility.set_location(l_proc, 10);
1093: --
1094: chk_run_type_id(p_element_type_usage_id => p_rec.element_type_usage_id
1095: ,p_run_type_id => p_rec.run_type_id
1096: ,p_effective_date => p_effective_date

Line 1100: hr_utility.set_location(l_proc, 15);

1096: ,p_effective_date => p_effective_date
1097: ,p_business_group_id => p_rec.business_group_id
1098: ,p_legislation_code => p_rec.legislation_code);
1099: --
1100: hr_utility.set_location(l_proc, 15);
1101: --
1102: chk_element_type_id(p_element_type_usage_id => p_rec.element_type_usage_id
1103: ,p_element_type_id => p_rec.element_type_id
1104: ,p_effective_date => p_effective_date

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

1104: ,p_effective_date => p_effective_date
1105: ,p_business_group_id => p_rec.business_group_id
1106: ,p_legislation_code => p_rec.legislation_code);
1107: --
1108: hr_utility.set_location(l_proc, 20);
1109: --
1110: chk_inclusion_flag(p_effective_date => p_effective_date
1111: ,p_validation_start_date => p_validation_start_date
1112: ,p_validation_end_date => p_validation_end_date

Line 1115: hr_utility.set_location(l_proc, 25);

1111: ,p_validation_start_date => p_validation_start_date
1112: ,p_validation_end_date => p_validation_end_date
1113: ,p_inclusion_flag => p_rec.inclusion_flag);
1114: --
1115: hr_utility.set_location(l_proc, 25);
1116: --
1117: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1118: ,p_legislation_code => p_rec.legislation_code);
1119: --

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

1116: --
1117: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1118: ,p_legislation_code => p_rec.legislation_code);
1119: --
1120: hr_utility.set_location(' Leaving:'||l_proc, 30);
1121: End insert_validate;
1122: --
1123: -- ----------------------------------------------------------------------------
1124: -- |---------------------------< update_validate >----------------------------|

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

1133: --
1134: l_proc varchar2(72) := g_package||'update_validate';
1135: --
1136: Begin
1137: hr_utility.set_location('Entering:'||l_proc, 5);
1138: --
1139: -- Call all supporting business operations
1140: --
1141: chk_startup_action(False

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

1144: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1145: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1146: END IF;
1147: --
1148: hr_utility.set_location(l_proc, 10);
1149: --
1150: chk_run_type_id(p_element_type_usage_id => p_rec.element_type_usage_id
1151: ,p_run_type_id => p_rec.run_type_id
1152: ,p_effective_date => p_effective_date

Line 1156: hr_utility.set_location(l_proc, 15);

1152: ,p_effective_date => p_effective_date
1153: ,p_business_group_id => p_rec.business_group_id
1154: ,p_legislation_code => p_rec.legislation_code);
1155: --
1156: hr_utility.set_location(l_proc, 15);
1157: --
1158: chk_element_type_id(p_element_type_usage_id => p_rec.element_type_usage_id
1159: ,p_element_type_id => p_rec.element_type_id
1160: ,p_effective_date => p_effective_date

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

1160: ,p_effective_date => p_effective_date
1161: ,p_business_group_id => p_rec.business_group_id
1162: ,p_legislation_code => p_rec.legislation_code);
1163: --
1164: hr_utility.set_location(l_proc, 20);
1165: --
1166: chk_inclusion_flag(p_effective_date => p_effective_date
1167: ,p_validation_start_date => p_validation_start_date
1168: ,p_validation_end_date => p_validation_end_date

Line 1171: hr_utility.set_location(l_proc, 25);

1167: ,p_validation_start_date => p_validation_start_date
1168: ,p_validation_end_date => p_validation_end_date
1169: ,p_inclusion_flag => p_rec.inclusion_flag);
1170: --
1171: hr_utility.set_location(l_proc, 25);
1172: --
1173: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1174: ,p_legislation_code => p_rec.legislation_code);
1175: --

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

1172: --
1173: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1174: ,p_legislation_code => p_rec.legislation_code);
1175: --
1176: hr_utility.set_location(l_proc, 30);
1177: --
1178: -- Call the datetrack update integrity operation
1179: --
1180: dt_update_validate

Line 1188: hr_utility.set_location(l_proc, 35);

1184: ,p_validation_start_date => p_validation_start_date
1185: ,p_validation_end_date => p_validation_end_date
1186: );
1187: --
1188: hr_utility.set_location(l_proc, 35);
1189: --
1190: chk_non_updateable_args
1191: (p_effective_date => p_effective_date
1192: ,p_rec => p_rec

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

1192: ,p_rec => p_rec
1193: );
1194: --
1195: --
1196: hr_utility.set_location(' Leaving:'||l_proc, 40);
1197: End update_validate;
1198: --
1199: -- ----------------------------------------------------------------------------
1200: -- |---------------------------< delete_validate >----------------------------|

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

1209: --
1210: l_proc varchar2(72) := g_package||'delete_validate';
1211: --
1212: Begin
1213: hr_utility.set_location('Entering:'||l_proc, 5);
1214: --
1215: -- Call all supporting business operations
1216: --
1217: chk_startup_action(False

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

1224: ,p_validation_end_date => p_validation_end_date
1225: ,p_element_type_usage_id => p_rec.element_type_usage_id
1226: );
1227: --
1228: hr_utility.set_location(' Leaving:'||l_proc, 10);
1229: End delete_validate;
1230: --
1231: end pay_etu_bus;