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_ROM_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_rom_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_rom_bus.g_run_type_org_method_id := p_run_type_org_method_id;
142: pay_rom_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 203: hr_utility.set_location(l_proc, 10);

199: --
200: -- EDIT_HERE: Add checks to ensure non-updateable args have
201: -- not been updated.
202: --
203: hr_utility.set_location(l_proc, 10);
204: --
205: if nvl(p_rec.business_group_id, hr_api.g_number) <>
206: nvl(pay_rom_shd.g_old_rec.business_group_id, hr_api.g_number) then
207: l_argument := 'business_group_id';

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

206: nvl(pay_rom_shd.g_old_rec.business_group_id, hr_api.g_number) then
207: l_argument := 'business_group_id';
208: raise l_error;
209: end if;
210: hr_utility.set_location(l_proc, 15);
211: --
212: if nvl(p_rec.run_type_org_method_id, hr_api.g_number) <>
213: nvl(pay_rom_shd.g_old_rec.run_type_org_method_id,hr_api.g_number) then
214: l_argument := 'run_type_org_method_id';

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

213: nvl(pay_rom_shd.g_old_rec.run_type_org_method_id,hr_api.g_number) then
214: l_argument := 'run_type_org_method_id';
215: raise l_error;
216: end if;
217: hr_utility.set_location(l_proc, 20);
218: --
219: if nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
220: nvl(pay_rom_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
221: l_argument := 'legislation_code';

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

220: nvl(pay_rom_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
221: l_argument := 'legislation_code';
222: raise l_error;
223: end if;
224: hr_utility.set_location(l_proc, 25);
225: --
226: if nvl(p_rec.run_type_id, hr_api.g_number) <>
227: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) then
228: l_argument := 'run_type_id';

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

227: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) then
228: l_argument := 'run_type_id';
229: raise l_error;
230: end if;
231: hr_utility.set_location(l_proc, 30);
232: --
233: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
234: nvl(pay_rom_shd.g_old_rec.org_payment_method_id,hr_api.g_number) then
235: l_argument := 'org_payment_method_id';

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

234: nvl(pay_rom_shd.g_old_rec.org_payment_method_id,hr_api.g_number) then
235: l_argument := 'org_payment_method_id';
236: raise l_error;
237: end if;
238: hr_utility.set_location(l_proc, 35);
239: --
240: EXCEPTION
241: WHEN l_error THEN
242: hr_api.argument_changed_error

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

339: and prt.legislation_code is null;
340: --
341: BEGIN
342: --
343: hr_utility.set_location('Entering: '|| l_proc, 5);
344: --
345: -- Only execute the cursor if absolutely necessary.
346: -- a) During update, the run_type_id has actually changed to another not
347: -- null value, i,e, the value passed to this procedure is different to the

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

355: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) <>
356: nvl(p_run_type_id, hr_api.g_number)) or
357: (p_run_type_org_method_id is null)) THEN
358: --
359: hr_utility.set_location(l_proc, 10);
360: --
361: -- Only need to open the cursor if run_type_id is not null
362: --
363: IF p_run_type_id is not null THEN

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

362: --
363: IF p_run_type_id is not null THEN
364: --
365: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
366: hr_utility.set_location(l_proc, 15);
367: --
368: OPEN csr_chk_generic_run_type;
369: FETCH csr_chk_generic_run_type INTO l_exists;
370: IF csr_chk_generic_run_type%NOTFOUND THEN

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

369: FETCH csr_chk_generic_run_type INTO l_exists;
370: IF csr_chk_generic_run_type%NOTFOUND THEN
371: --
372: CLOSE csr_chk_generic_run_type;
373: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
374: hr_utility.raise_error;
375: --
376: END IF;
377: CLOSE csr_chk_generic_run_type;

Line 374: hr_utility.raise_error;

370: IF csr_chk_generic_run_type%NOTFOUND THEN
371: --
372: CLOSE csr_chk_generic_run_type;
373: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
374: hr_utility.raise_error;
375: --
376: END IF;
377: CLOSE csr_chk_generic_run_type;
378: --

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

376: END IF;
377: CLOSE csr_chk_generic_run_type;
378: --
379: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
380: hr_utility.set_location(l_proc, 20);
381: --
382: OPEN csr_chk_startup_run_type;
383: FETCH csr_chk_startup_run_type INTO l_exists;
384: IF csr_chk_startup_run_type%NOTFOUND THEN

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

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

Line 388: hr_utility.raise_error;

384: IF csr_chk_startup_run_type%NOTFOUND THEN
385: --
386: CLOSE csr_chk_startup_run_type;
387: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
388: hr_utility.raise_error;
389: END IF;
390: CLOSE csr_chk_startup_run_type;
391: --
392: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

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

389: END IF;
390: CLOSE csr_chk_startup_run_type;
391: --
392: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
393: hr_utility.set_location(l_proc, 25);
394: --
395: IF p_run_type_org_method_id is not null THEN
396: l_legislation_code := pay_rom_bus.return_legislation_code(p_run_type_org_method_id);
397: ELSE

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

402: FETCH csr_chk_user_run_type INTO l_exists;
403: IF csr_chk_user_run_type%NOTFOUND THEN
404: --
405: CLOSE csr_chk_user_run_type;
406: hr_utility.set_message(801, 'HR_33589_INVALID_RUN_TYPE');
407: hr_utility.raise_error;
408: END IF;
409: CLOSE csr_chk_user_run_type;
410: --

Line 407: hr_utility.raise_error;

403: IF csr_chk_user_run_type%NOTFOUND THEN
404: --
405: CLOSE csr_chk_user_run_type;
406: hr_utility.set_message(801, 'HR_33589_INVALID_RUN_TYPE');
407: hr_utility.raise_error;
408: END IF;
409: CLOSE csr_chk_user_run_type;
410: --
411: END IF;

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

413: END IF;
414: --
415: END IF;
416: --
417: hr_utility.set_location('Leaving: '||l_proc, 30);
418: --
419: end chk_run_type_id;
420: --
421: -- ---------------------------------------------------------------------------

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

477: and opm.business_group_id = p_business_group_id;
478: --
479: BEGIN
480: --
481: hr_utility.set_location('Entering: '|| l_proc, 5);
482: --
483: -- Only execute the cursor if absolutely necessary.
484: -- a) During update, the org_payment_method_id has actually changed to another not
485: -- null value, i,e, the value passed to this procedure is different to the

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

493: nvl(pay_rom_shd.g_old_rec.org_payment_method_id, hr_api.g_number) <>
494: nvl(p_org_payment_method_id, hr_api.g_number)) or
495: (p_run_type_org_method_id is null)) THEN
496: --
497: hr_utility.set_location(l_proc, 10);
498: --
499: -- Only need to open the cursor if org_payment_method_id is not null
500: --
501: IF p_org_payment_method_id is not null THEN

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

500: --
501: IF p_org_payment_method_id is not null THEN
502: --
503: IF hr_startup_data_api_support.g_startup_mode in ('GENERIC','STARTUP') THEN
504: hr_utility.set_location(l_proc, 15);
505: --
506: hr_utility.set_message(801, 'HR_33591_ROM_INV_PAYM_METHOD');
507: hr_utility.raise_error;
508: --

Line 506: hr_utility.set_message(801, 'HR_33591_ROM_INV_PAYM_METHOD');

502: --
503: IF hr_startup_data_api_support.g_startup_mode in ('GENERIC','STARTUP') THEN
504: hr_utility.set_location(l_proc, 15);
505: --
506: hr_utility.set_message(801, 'HR_33591_ROM_INV_PAYM_METHOD');
507: hr_utility.raise_error;
508: --
509: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
510: --

Line 507: hr_utility.raise_error;

503: IF hr_startup_data_api_support.g_startup_mode in ('GENERIC','STARTUP') THEN
504: hr_utility.set_location(l_proc, 15);
505: --
506: hr_utility.set_message(801, 'HR_33591_ROM_INV_PAYM_METHOD');
507: hr_utility.raise_error;
508: --
509: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
510: --
511: hr_utility.set_location(l_proc, 20);

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

507: hr_utility.raise_error;
508: --
509: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
510: --
511: hr_utility.set_location(l_proc, 20);
512: --
513: OPEN csr_chk_org_pay_method;
514: FETCH csr_chk_org_pay_method INTO l_exists;
515: IF csr_chk_org_pay_method%NOTFOUND THEN

Line 518: hr_utility.set_message(801, 'HR_33591_ROM_INV_PAYM_METHOD');

514: FETCH csr_chk_org_pay_method INTO l_exists;
515: IF csr_chk_org_pay_method%NOTFOUND THEN
516: --
517: CLOSE csr_chk_org_pay_method;
518: hr_utility.set_message(801, 'HR_33591_ROM_INV_PAYM_METHOD');
519: hr_utility.raise_error;
520: END IF;
521: CLOSE csr_chk_org_pay_method;
522: --

Line 519: hr_utility.raise_error;

515: IF csr_chk_org_pay_method%NOTFOUND THEN
516: --
517: CLOSE csr_chk_org_pay_method;
518: hr_utility.set_message(801, 'HR_33591_ROM_INV_PAYM_METHOD');
519: hr_utility.raise_error;
520: END IF;
521: CLOSE csr_chk_org_pay_method;
522: --
523: END IF;

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

525: END IF;
526: --
527: END IF;
528: --
529: hr_utility.set_location('Leaving: '||l_proc, 25);
530: --
531: end chk_org_payment_method_id;
532: --
533: -- ---------------------------------------------------------------------------

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

604: and rom.legislation_code = p_legislation_code;
605: --
606: BEGIN
607: --
608: hr_utility.set_location('Entering: '|| l_proc, 5);
609: --
610: IF ((p_priority is not null) AND (p_priority NOT BETWEEN 1 and 99)) THEN
611: --
612: hr_utility.set_message(801, 'HR_33582_ROM_PRIORITY_RANGE');

Line 612: hr_utility.set_message(801, 'HR_33582_ROM_PRIORITY_RANGE');

608: hr_utility.set_location('Entering: '|| l_proc, 5);
609: --
610: IF ((p_priority is not null) AND (p_priority NOT BETWEEN 1 and 99)) THEN
611: --
612: hr_utility.set_message(801, 'HR_33582_ROM_PRIORITY_RANGE');
613: hr_utility.raise_error;
614: --
615: END IF;
616: --

Line 613: hr_utility.raise_error;

609: --
610: IF ((p_priority is not null) AND (p_priority NOT BETWEEN 1 and 99)) THEN
611: --
612: hr_utility.set_message(801, 'HR_33582_ROM_PRIORITY_RANGE');
613: hr_utility.raise_error;
614: --
615: END IF;
616: --
617: -- Only execute the cursor if absolutely necessary.

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

628: nvl(p_priority, hr_api.g_number))
629: or
630: (p_run_type_org_method_id is null)) then
631: --
632: hr_utility.set_location(l_proc, 10);
633: --
634: -- Only need to open the cursors if priority is not null
635: --
636: if p_priority is not null then

Line 645: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');

641: FETCH csr_chk_unique_priority_leg INTO l_exists;
642: IF csr_chk_unique_priority_leg%FOUND THEN
643: --
644: CLOSE csr_chk_unique_priority_leg;
645: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');
646: hr_utility.raise_error;
647: END IF;
648: CLOSE csr_chk_unique_priority_leg;
649: hr_utility.set_location(l_proc, 15);

Line 646: hr_utility.raise_error;

642: IF csr_chk_unique_priority_leg%FOUND THEN
643: --
644: CLOSE csr_chk_unique_priority_leg;
645: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');
646: hr_utility.raise_error;
647: END IF;
648: CLOSE csr_chk_unique_priority_leg;
649: hr_utility.set_location(l_proc, 15);
650: --

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

645: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');
646: hr_utility.raise_error;
647: END IF;
648: CLOSE csr_chk_unique_priority_leg;
649: hr_utility.set_location(l_proc, 15);
650: --
651: ELSE
652: OPEN csr_chk_unique_priority_bg;
653: FETCH csr_chk_unique_priority_bg INTO l_exists;

Line 657: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');

653: FETCH csr_chk_unique_priority_bg INTO l_exists;
654: IF csr_chk_unique_priority_bg%FOUND THEN
655: --
656: CLOSE csr_chk_unique_priority_bg;
657: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');
658: hr_utility.raise_error;
659: END IF;
660: CLOSE csr_chk_unique_priority_bg;
661: hr_utility.set_location(l_proc, 20);

Line 658: hr_utility.raise_error;

654: IF csr_chk_unique_priority_bg%FOUND THEN
655: --
656: CLOSE csr_chk_unique_priority_bg;
657: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');
658: hr_utility.raise_error;
659: END IF;
660: CLOSE csr_chk_unique_priority_bg;
661: hr_utility.set_location(l_proc, 20);
662: --

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

657: hr_utility.set_message(801, 'HR_33584_ROM_PRIORITY_UNIQUE');
658: hr_utility.raise_error;
659: END IF;
660: CLOSE csr_chk_unique_priority_bg;
661: hr_utility.set_location(l_proc, 20);
662: --
663: END IF;
664: hr_utility.set_location(l_proc, 25);
665: --

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

660: CLOSE csr_chk_unique_priority_bg;
661: hr_utility.set_location(l_proc, 20);
662: --
663: END IF;
664: hr_utility.set_location(l_proc, 25);
665: --
666: else -- p_priority is null
667: hr_utility.set_message(801, 'HR_33583_ROM_PRIORITY_NULL');
668: hr_utility.raise_error;

Line 667: hr_utility.set_message(801, 'HR_33583_ROM_PRIORITY_NULL');

663: END IF;
664: hr_utility.set_location(l_proc, 25);
665: --
666: else -- p_priority is null
667: hr_utility.set_message(801, 'HR_33583_ROM_PRIORITY_NULL');
668: hr_utility.raise_error;
669: end if;
670: hr_utility.set_location(l_proc, 30);
671: END IF;

Line 668: hr_utility.raise_error;

664: hr_utility.set_location(l_proc, 25);
665: --
666: else -- p_priority is null
667: hr_utility.set_message(801, 'HR_33583_ROM_PRIORITY_NULL');
668: hr_utility.raise_error;
669: end if;
670: hr_utility.set_location(l_proc, 30);
671: END IF;
672: hr_utility.set_location('Leaving: '||l_proc, 35);

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

666: else -- p_priority is null
667: hr_utility.set_message(801, 'HR_33583_ROM_PRIORITY_NULL');
668: hr_utility.raise_error;
669: end if;
670: hr_utility.set_location(l_proc, 30);
671: END IF;
672: hr_utility.set_location('Leaving: '||l_proc, 35);
673: END chk_priority;
674: --

Line 672: hr_utility.set_location('Leaving: '||l_proc, 35);

668: hr_utility.raise_error;
669: end if;
670: hr_utility.set_location(l_proc, 30);
671: END IF;
672: hr_utility.set_location('Leaving: '||l_proc, 35);
673: END chk_priority;
674: --
675: -- ---------------------------------------------------------------------------
676: -- |-----------------------< chk_amount_percent >--------------------------|

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

722: from pay_org_payment_methods_f
723: where org_payment_method_id = p_org_payment_method_id;
724: --
725: BEGIN
726: hr_utility.set_location('Entering: '||l_proc, 5);
727: --
728: -- if amount is not null then percent is null, and vice versa
729: --
730: IF p_amount is null THEN

Line 732: hr_utility.set_message(801, 'HR_6680_PPM_AMT_PERC');

728: -- if amount is not null then percent is null, and vice versa
729: --
730: IF p_amount is null THEN
731: IF p_percent is null then
732: hr_utility.set_message(801, 'HR_6680_PPM_AMT_PERC');
733: hr_utility.raise_error;
734: END IF;
735: --
736: hr_utility.set_location('Entering: '||l_proc, 10);

Line 733: hr_utility.raise_error;

729: --
730: IF p_amount is null THEN
731: IF p_percent is null then
732: hr_utility.set_message(801, 'HR_6680_PPM_AMT_PERC');
733: hr_utility.raise_error;
734: END IF;
735: --
736: hr_utility.set_location('Entering: '||l_proc, 10);
737: --

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

732: hr_utility.set_message(801, 'HR_6680_PPM_AMT_PERC');
733: hr_utility.raise_error;
734: END IF;
735: --
736: hr_utility.set_location('Entering: '||l_proc, 10);
737: --
738: ELSE
739: IF p_percent is not null THEN
740: hr_utility.set_message(801, 'HR_6221_PAYM_INVALID_PPM');

Line 740: hr_utility.set_message(801, 'HR_6221_PAYM_INVALID_PPM');

736: hr_utility.set_location('Entering: '||l_proc, 10);
737: --
738: ELSE
739: IF p_percent is not null THEN
740: hr_utility.set_message(801, 'HR_6221_PAYM_INVALID_PPM');
741: hr_utility.raise_error;
742: END IF;
743: END IF;
744: --

Line 741: hr_utility.raise_error;

737: --
738: ELSE
739: IF p_percent is not null THEN
740: hr_utility.set_message(801, 'HR_6221_PAYM_INVALID_PPM');
741: hr_utility.raise_error;
742: END IF;
743: END IF;
744: --
745: hr_utility.set_location(l_proc, 15);

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

741: hr_utility.raise_error;
742: END IF;
743: END IF;
744: --
745: hr_utility.set_location(l_proc, 15);
746: --
747: -- Check formats
748: --
749: if p_amount < 0 then

Line 750: hr_utility.set_message(801, 'HR_7355_PPM_AMOUNT_NEGATIVE');

746: --
747: -- Check formats
748: --
749: if p_amount < 0 then
750: hr_utility.set_message(801, 'HR_7355_PPM_AMOUNT_NEGATIVE');
751: hr_utility.raise_error;
752: end if;
753: --
754: if p_percent not between 0 and 100 then

Line 751: hr_utility.raise_error;

747: -- Check formats
748: --
749: if p_amount < 0 then
750: hr_utility.set_message(801, 'HR_7355_PPM_AMOUNT_NEGATIVE');
751: hr_utility.raise_error;
752: end if;
753: --
754: if p_percent not between 0 and 100 then
755: hr_utility.set_message(801, 'HR_7040_PERCENT_RANGE');

Line 755: hr_utility.set_message(801, 'HR_7040_PERCENT_RANGE');

751: hr_utility.raise_error;
752: end if;
753: --
754: if p_percent not between 0 and 100 then
755: hr_utility.set_message(801, 'HR_7040_PERCENT_RANGE');
756: hr_utility.raise_error;
757: end if;
758: --
759: hr_utility.set_location(l_proc, 20);

Line 756: hr_utility.raise_error;

752: end if;
753: --
754: if p_percent not between 0 and 100 then
755: hr_utility.set_message(801, 'HR_7040_PERCENT_RANGE');
756: hr_utility.raise_error;
757: end if;
758: --
759: hr_utility.set_location(l_proc, 20);
760: --

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

755: hr_utility.set_message(801, 'HR_7040_PERCENT_RANGE');
756: hr_utility.raise_error;
757: end if;
758: --
759: hr_utility.set_location(l_proc, 20);
760: --
761: if p_amount is not null then
762: --
763: -- Check that Amount has a money format

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

772: p_format => 'M',
773: p_curcode => l_curcode);
774: else
775: --
776: hr_utility.set_location(l_proc, 25);
777: --
778: -- p_percent is not null so check that format is decimal with
779: -- 2 decimal places
780: --

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

784: p_arg_name => 'PERCENTAGE',
785: p_format => 'H_DECIMAL2');
786: end if;
787: --
788: hr_utility.set_location('Leaving: '||l_proc, 30);
789: END chk_percent_amount;
790: --
791: -- ---------------------------------------------------------------------------
792: -- |--------------------------< chk_bg_leg_code >----------------------------|

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

830: l_proc varchar2(72) := g_package||'chk_bg_leg_code';
831: --
832: BEGIN
833: --
834: hr_utility.set_location('Entering: '|| l_proc, 5);
835: --
836: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
837: --
838: hr_utility.set_location(l_proc, 15);

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

834: hr_utility.set_location('Entering: '|| l_proc, 5);
835: --
836: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
837: --
838: hr_utility.set_location(l_proc, 15);
839: --
840: IF ((p_business_group_id is not null)
841: or (p_legislation_code is not null)) THEN
842: --

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

839: --
840: IF ((p_business_group_id is not null)
841: or (p_legislation_code is not null)) THEN
842: --
843: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
844: hr_utility.raise_error;
845: --
846: END IF;
847: --

Line 844: hr_utility.raise_error;

840: IF ((p_business_group_id is not null)
841: or (p_legislation_code is not null)) THEN
842: --
843: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
844: hr_utility.raise_error;
845: --
846: END IF;
847: --
848: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN

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

846: END IF;
847: --
848: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
849: --
850: hr_utility.set_location(l_proc, 20);
851: --
852: IF ((p_business_group_id is not null)
853: or (p_legislation_code is null)) THEN
854: --

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

851: --
852: IF ((p_business_group_id is not null)
853: or (p_legislation_code is null)) THEN
854: --
855: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
856: hr_utility.raise_error;
857: --
858: END IF;
859: --

Line 856: hr_utility.raise_error;

852: IF ((p_business_group_id is not null)
853: or (p_legislation_code is null)) THEN
854: --
855: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
856: hr_utility.raise_error;
857: --
858: END IF;
859: --
860: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

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

858: END IF;
859: --
860: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
861: --
862: hr_utility.set_location(l_proc, 25);
863: --
864: IF ((p_business_group_id is null)
865: or (p_legislation_code is not null)) THEN
866: --

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

863: --
864: IF ((p_business_group_id is null)
865: or (p_legislation_code is not null)) THEN
866: --
867: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
868: hr_utility.raise_error;
869: --
870: END IF;
871: --

Line 868: hr_utility.raise_error;

864: IF ((p_business_group_id is null)
865: or (p_legislation_code is not null)) THEN
866: --
867: hr_utility.set_message(801, 'HR_33586_INVALID_BG_LEG_COMBI');
868: hr_utility.raise_error;
869: --
870: END IF;
871: --
872: END IF;

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

870: END IF;
871: --
872: END IF;
873: --
874: hr_utility.set_location('Leaving: '||l_proc, 30);
875: --
876: end chk_bg_leg_code;
877: --
878: -- ----------------------------------------------------------------------------

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

1151: --
1152: l_proc varchar2(72) := g_package||'insert_validate';
1153: --
1154: Begin
1155: hr_utility.set_location('Entering:'||l_proc, 5);
1156: --
1157: -- Call all supporting business operations
1158: --
1159: chk_startup_action(True

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

1162: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1163: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1164: END IF;
1165: --
1166: hr_utility.set_location(l_proc, 10);
1167: --
1168: chk_run_type_id(p_run_type_org_method_id => p_rec.run_type_org_method_id
1169: ,p_run_type_id => p_rec.run_type_id
1170: ,p_effective_date => p_effective_date

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

1170: ,p_effective_date => p_effective_date
1171: ,p_business_group_id => p_rec.business_group_id
1172: ,p_legislation_code => p_rec.legislation_code);
1173: --
1174: hr_utility.set_location(l_proc, 15);
1175: --
1176: chk_org_payment_method_id
1177: (p_run_type_org_method_id => p_rec.run_type_org_method_id
1178: ,p_org_payment_method_id => p_rec.org_payment_method_id

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

1178: ,p_org_payment_method_id => p_rec.org_payment_method_id
1179: ,p_effective_date => p_effective_date
1180: ,p_business_group_id => p_rec.business_group_id);
1181: --
1182: hr_utility.set_location(l_proc, 20);
1183: --
1184: chk_priority(p_run_type_org_method_id => p_rec.run_type_org_method_id
1185: ,p_org_payment_method_id => p_rec.org_payment_method_id
1186: ,p_run_type_id => p_rec.run_type_id

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

1189: ,p_legislation_code => p_rec.legislation_code
1190: ,p_validation_start_date => p_validation_start_date
1191: ,p_validation_end_date => p_validation_end_date);
1192: --
1193: hr_utility.set_location(l_proc, 25);
1194: --
1195: chk_percent_amount(p_percent => p_rec.percentage
1196: ,p_amount => p_rec.amount
1197: ,p_org_payment_method_id => p_rec.org_payment_method_id);

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

1195: chk_percent_amount(p_percent => p_rec.percentage
1196: ,p_amount => p_rec.amount
1197: ,p_org_payment_method_id => p_rec.org_payment_method_id);
1198: --
1199: hr_utility.set_location(l_proc, 30);
1200: --
1201: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1202: ,p_legislation_code => p_rec.legislation_code);
1203: --

Line 1204: hr_utility.set_location(' Leaving:'||l_proc, 35);

1200: --
1201: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1202: ,p_legislation_code => p_rec.legislation_code);
1203: --
1204: hr_utility.set_location(' Leaving:'||l_proc, 35);
1205: End insert_validate;
1206: --
1207: -- ----------------------------------------------------------------------------
1208: -- |---------------------------< update_validate >----------------------------|

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

1217: --
1218: l_proc varchar2(72) := g_package||'update_validate';
1219: --
1220: Begin
1221: hr_utility.set_location('Entering:'||l_proc, 5);
1222: --
1223: -- Call all supporting business operations
1224: --
1225: chk_startup_action(False

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

1228: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1229: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1230: END IF;
1231: --
1232: hr_utility.set_location(l_proc, 10);
1233: --
1234: chk_run_type_id(p_run_type_org_method_id => p_rec.run_type_org_method_id
1235: ,p_run_type_id => p_rec.run_type_id
1236: ,p_effective_date => p_effective_date

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

1236: ,p_effective_date => p_effective_date
1237: ,p_business_group_id => p_rec.business_group_id
1238: ,p_legislation_code => p_rec.legislation_code);
1239: --
1240: hr_utility.set_location(l_proc, 15);
1241: --
1242: chk_org_payment_method_id
1243: (p_run_type_org_method_id => p_rec.run_type_org_method_id
1244: ,p_org_payment_method_id => p_rec.org_payment_method_id

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

1244: ,p_org_payment_method_id => p_rec.org_payment_method_id
1245: ,p_effective_date => p_effective_date
1246: ,p_business_group_id => p_rec.business_group_id);
1247: --
1248: hr_utility.set_location(l_proc, 20);
1249: --
1250: chk_priority(p_run_type_org_method_id => p_rec.run_type_org_method_id
1251: ,p_org_payment_method_id => p_rec.org_payment_method_id
1252: ,p_run_type_id => p_rec.run_type_id

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

1255: ,p_legislation_code => p_rec.legislation_code
1256: ,p_validation_start_date => p_validation_start_date
1257: ,p_validation_end_date => p_validation_end_date);
1258: --
1259: hr_utility.set_location(l_proc, 25);
1260: --
1261: chk_percent_amount(p_percent => p_rec.percentage
1262: ,p_amount => p_rec.amount
1263: ,p_org_payment_method_id => p_rec.org_payment_method_id);

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

1261: chk_percent_amount(p_percent => p_rec.percentage
1262: ,p_amount => p_rec.amount
1263: ,p_org_payment_method_id => p_rec.org_payment_method_id);
1264: --
1265: hr_utility.set_location(l_proc, 30);
1266: --
1267: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1268: ,p_legislation_code => p_rec.legislation_code);
1269: --

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

1266: --
1267: chk_bg_leg_code(p_business_group_id => p_rec.business_group_id
1268: ,p_legislation_code => p_rec.legislation_code);
1269: --
1270: hr_utility.set_location(l_proc, 35);
1271: --
1272: -- Call the datetrack update integrity operation
1273: --
1274: dt_update_validate

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

1278: ,p_validation_start_date => p_validation_start_date
1279: ,p_validation_end_date => p_validation_end_date
1280: );
1281: --
1282: hr_utility.set_location(l_proc, 40);
1283: --
1284: chk_non_updateable_args
1285: (p_effective_date => p_effective_date
1286: ,p_rec => p_rec

Line 1289: hr_utility.set_location(' Leaving:'||l_proc, 45);

1285: (p_effective_date => p_effective_date
1286: ,p_rec => p_rec
1287: );
1288: --
1289: hr_utility.set_location(' Leaving:'||l_proc, 45);
1290: End update_validate;
1291: --
1292: -- ----------------------------------------------------------------------------
1293: -- |---------------------------< delete_validate >----------------------------|

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

1302: --
1303: l_proc varchar2(72) := g_package||'delete_validate';
1304: --
1305: Begin
1306: hr_utility.set_location('Entering:'||l_proc, 5);
1307: --
1308: -- Call all supporting business operations
1309: --
1310: chk_startup_action(False

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

1317: ,p_validation_end_date => p_validation_end_date
1318: ,p_run_type_org_method_id => p_rec.run_type_org_method_id
1319: );
1320: --
1321: hr_utility.set_location(' Leaving:'||l_proc, 10);
1322: End delete_validate;
1323: --
1324: end pay_rom_bus;