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

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

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

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

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pay_pbd_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: pay_pbd_bus.g_bal_attribute_default_id := p_bal_attribute_default_id;
147: pay_pbd_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

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

234: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;
235: --
236: Begin
237: --
238: hr_utility.set_location('Entering: '||l_proc,5);
239: --
240: -- Only execute the cursor if absolutely necessary.
241: -- a) During update, the attribute_name has actually changed to another not
242: -- null value, i,e, the value passed to this procedure is different to the

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

251: nvl(p_attribute_id, hr_api.g_varchar2))
252: or
253: (p_bal_attribute_default_id is null)) then
254: --
255: hr_utility.set_location(l_proc, 10);
256: --
257: -- Only need to open the cursor if attribute_id is not null
258: --
259: if p_attribute_id is not null then

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

258: --
259: if p_attribute_id is not null then
260: --
261: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
262: hr_utility.set_location(l_proc, 15);
263: --
264: OPEN csr_chk_attribute_id_g;
265: FETCH csr_chk_attribute_id_g into l_exists;
266: IF csr_chk_attribute_id_g%NOTFOUND THEN

Line 269: hr_utility.set_message(801, 'PAY_34251_INV_ATTID_4_MODEG');

265: FETCH csr_chk_attribute_id_g into l_exists;
266: IF csr_chk_attribute_id_g%NOTFOUND THEN
267: --
268: CLOSE csr_chk_attribute_id_g;
269: hr_utility.set_message(801, 'PAY_34251_INV_ATTID_4_MODEG');
270: hr_utility.raise_error;
271: END IF;
272: CLOSE csr_chk_attribute_id_g;
273: --

Line 270: hr_utility.raise_error;

266: IF csr_chk_attribute_id_g%NOTFOUND THEN
267: --
268: CLOSE csr_chk_attribute_id_g;
269: hr_utility.set_message(801, 'PAY_34251_INV_ATTID_4_MODEG');
270: hr_utility.raise_error;
271: END IF;
272: CLOSE csr_chk_attribute_id_g;
273: --
274: elsif hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN

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

271: END IF;
272: CLOSE csr_chk_attribute_id_g;
273: --
274: elsif hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
275: hr_utility.set_location(l_proc, 20);
276: --
277: OPEN csr_chk_attribute_id_s(p_legislation_code);
278: FETCH csr_chk_attribute_id_s into l_exists;
279: IF csr_chk_attribute_id_s%NOTFOUND THEN

Line 282: hr_utility.set_message(801, 'PAY_34252_INV_ATTID_4_MODES');

278: FETCH csr_chk_attribute_id_s into l_exists;
279: IF csr_chk_attribute_id_s%NOTFOUND THEN
280: --
281: CLOSE csr_chk_attribute_id_s;
282: hr_utility.set_message(801, 'PAY_34252_INV_ATTID_4_MODES');
283: hr_utility.raise_error;
284: END IF;
285: CLOSE csr_chk_attribute_id_s;
286: --

Line 283: hr_utility.raise_error;

279: IF csr_chk_attribute_id_s%NOTFOUND THEN
280: --
281: CLOSE csr_chk_attribute_id_s;
282: hr_utility.set_message(801, 'PAY_34252_INV_ATTID_4_MODES');
283: hr_utility.raise_error;
284: END IF;
285: CLOSE csr_chk_attribute_id_s;
286: --
287: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

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

284: END IF;
285: CLOSE csr_chk_attribute_id_s;
286: --
287: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
288: hr_utility.set_location(l_proc, 25);
289: --
290: if p_bal_attribute_default_id is not null then
291: l_legislation_code := pay_pbd_bus.return_legislation_code
292: (p_bal_attribute_default_id);

Line 304: hr_utility.set_message(801, 'PAY_34253_INV_ATTID_4_MODEU');

300: FETCH csr_chk_attribute_id_u into l_exists;
301: IF csr_chk_attribute_id_u%NOTFOUND THEN
302: --
303: CLOSE csr_chk_attribute_id_u;
304: hr_utility.set_message(801, 'PAY_34253_INV_ATTID_4_MODEU');
305: hr_utility.raise_error;
306: END IF;
307: CLOSE csr_chk_attribute_id_u;
308: --

Line 305: hr_utility.raise_error;

301: IF csr_chk_attribute_id_u%NOTFOUND THEN
302: --
303: CLOSE csr_chk_attribute_id_u;
304: hr_utility.set_message(801, 'PAY_34253_INV_ATTID_4_MODEU');
305: hr_utility.raise_error;
306: END IF;
307: CLOSE csr_chk_attribute_id_u;
308: --
309: END IF;

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

310: --
311: end if;
312: --
313: end if;
314: hr_utility.set_location('Leaving: '||l_proc, 20);
315: --
316: END chk_attribute_id;
317: -- ----------------------------------------------------------------------------
318: -- |--------------------< chk_balance_category_id >---------------------------|

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

396: l_exists number;
397: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;
398: Begin
399: --
400: hr_utility.set_location('Entering: '||l_proc,5);
401: --
402: -- Only execute the cursor if absolutely necessary.
403: -- a) During update, the attribute_name has actually changed to another not
404: -- null value, i,e, the value passed to this procedure is different to the

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

413: nvl(p_balance_category_id, hr_api.g_varchar2))
414: or
415: (p_bal_attribute_default_id is null)) then
416: --
417: hr_utility.set_location(l_proc, 10);
418: --
419: -- Only need to open the cursor if balance_category_id is not null
420: --
421: if p_balance_category_id is not null then

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

420: --
421: if p_balance_category_id is not null then
422: --
423: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
424: hr_utility.set_location(l_proc, 15);
425: --
426: OPEN csr_chk_bal_cat_id_g;
427: FETCH csr_chk_bal_cat_id_g into l_exists;
428: IF csr_chk_bal_cat_id_g%NOTFOUND THEN

Line 430: hr_utility.set_message(801, 'PAY_34254_INV_CATID_4_MODEG');

426: OPEN csr_chk_bal_cat_id_g;
427: FETCH csr_chk_bal_cat_id_g into l_exists;
428: IF csr_chk_bal_cat_id_g%NOTFOUND THEN
429: CLOSE csr_chk_bal_cat_id_g;
430: hr_utility.set_message(801, 'PAY_34254_INV_CATID_4_MODEG');
431: hr_utility.raise_error;
432: END IF;
433: CLOSE csr_chk_bal_cat_id_g;
434: --

Line 431: hr_utility.raise_error;

427: FETCH csr_chk_bal_cat_id_g into l_exists;
428: IF csr_chk_bal_cat_id_g%NOTFOUND THEN
429: CLOSE csr_chk_bal_cat_id_g;
430: hr_utility.set_message(801, 'PAY_34254_INV_CATID_4_MODEG');
431: hr_utility.raise_error;
432: END IF;
433: CLOSE csr_chk_bal_cat_id_g;
434: --
435: elsif hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN

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

432: END IF;
433: CLOSE csr_chk_bal_cat_id_g;
434: --
435: elsif hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
436: hr_utility.set_location(l_proc, 20);
437: --
438: OPEN csr_chk_bal_cat_id_s(p_legislation_code);
439: FETCH csr_chk_bal_cat_id_s into l_exists;
440: IF csr_chk_bal_cat_id_s%NOTFOUND THEN

Line 442: hr_utility.set_message(801, 'PAY_34255_INV_CATID_4_MODES');

438: OPEN csr_chk_bal_cat_id_s(p_legislation_code);
439: FETCH csr_chk_bal_cat_id_s into l_exists;
440: IF csr_chk_bal_cat_id_s%NOTFOUND THEN
441: CLOSE csr_chk_bal_cat_id_s;
442: hr_utility.set_message(801, 'PAY_34255_INV_CATID_4_MODES');
443: hr_utility.raise_error;
444: END IF;
445: CLOSE csr_chk_bal_cat_id_s;
446: --

Line 443: hr_utility.raise_error;

439: FETCH csr_chk_bal_cat_id_s into l_exists;
440: IF csr_chk_bal_cat_id_s%NOTFOUND THEN
441: CLOSE csr_chk_bal_cat_id_s;
442: hr_utility.set_message(801, 'PAY_34255_INV_CATID_4_MODES');
443: hr_utility.raise_error;
444: END IF;
445: CLOSE csr_chk_bal_cat_id_s;
446: --
447: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

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

444: END IF;
445: CLOSE csr_chk_bal_cat_id_s;
446: --
447: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
448: hr_utility.set_location(l_proc, 25);
449: --
450: if p_bal_attribute_default_id is not null then
451: l_legislation_code := pay_pbd_bus.return_legislation_code
452: (p_bal_attribute_default_id);

Line 464: hr_utility.set_message(801, 'PAY_34256_INV_CATID_4_MODEU');

460: FETCH csr_chk_bal_cat_id_u into l_exists;
461: IF csr_chk_bal_cat_id_u%NOTFOUND THEN
462: --
463: CLOSE csr_chk_bal_cat_id_u;
464: hr_utility.set_message(801, 'PAY_34256_INV_CATID_4_MODEU');
465: hr_utility.raise_error;
466: END IF;
467: CLOSE csr_chk_bal_cat_id_u;
468: --

Line 465: hr_utility.raise_error;

461: IF csr_chk_bal_cat_id_u%NOTFOUND THEN
462: --
463: CLOSE csr_chk_bal_cat_id_u;
464: hr_utility.set_message(801, 'PAY_34256_INV_CATID_4_MODEU');
465: hr_utility.raise_error;
466: END IF;
467: CLOSE csr_chk_bal_cat_id_u;
468: --
469: END IF;

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

470: --
471: end if;
472: --
473: end if;
474: hr_utility.set_location('Leaving: '||l_proc, 20);
475: --
476: END chk_balance_category_id;
477: -- ----------------------------------------------------------------------------
478: -- |-----------------------< chk_balance_dimension_id >-----------------------|

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

559: l_legislation_code pay_bal_attribute_defaults.legislation_code%type;
560: --
561: Begin
562: --
563: hr_utility.set_location('Entering: '||l_proc,5);
564: --
565: -- Only execute the cursor if absolutely necessary.
566: -- a) During update, the attribute_name has actually changed to another not
567: -- null value, i,e, the value passed to this procedure is different to the

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

576: nvl(p_balance_dimension_id, hr_api.g_varchar2))
577: or
578: (p_bal_attribute_default_id is null)) then
579: --
580: hr_utility.set_location(l_proc, 10);
581: --
582: -- Only need to open the cursor if balance_dimension_id is not null
583: --
584: if p_balance_dimension_id is not null then

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

583: --
584: if p_balance_dimension_id is not null then
585: --
586: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
587: hr_utility.set_location(l_proc, 15);
588: --
589: OPEN csr_chk_bal_dim_id_g;
590: FETCH csr_chk_bal_dim_id_g into l_exists;
591: IF csr_chk_bal_dim_id_g%NOTFOUND THEN

Line 593: hr_utility.set_message(801, 'PAY_34258_INV_DIMID_4_MODEG');

589: OPEN csr_chk_bal_dim_id_g;
590: FETCH csr_chk_bal_dim_id_g into l_exists;
591: IF csr_chk_bal_dim_id_g%NOTFOUND THEN
592: CLOSE csr_chk_bal_dim_id_g;
593: hr_utility.set_message(801, 'PAY_34258_INV_DIMID_4_MODEG');
594: hr_utility.raise_error;
595: END IF;
596: CLOSE csr_chk_bal_dim_id_g;
597: --

Line 594: hr_utility.raise_error;

590: FETCH csr_chk_bal_dim_id_g into l_exists;
591: IF csr_chk_bal_dim_id_g%NOTFOUND THEN
592: CLOSE csr_chk_bal_dim_id_g;
593: hr_utility.set_message(801, 'PAY_34258_INV_DIMID_4_MODEG');
594: hr_utility.raise_error;
595: END IF;
596: CLOSE csr_chk_bal_dim_id_g;
597: --
598: elsif hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN

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

595: END IF;
596: CLOSE csr_chk_bal_dim_id_g;
597: --
598: elsif hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
599: hr_utility.set_location(l_proc, 20);
600: --
601: OPEN csr_chk_bal_dim_id_s(p_legislation_code);
602: FETCH csr_chk_bal_dim_id_s into l_exists;
603: IF csr_chk_bal_dim_id_s%NOTFOUND THEN

Line 605: hr_utility.set_message(801, 'PAY_34257_INV_DIMID_4_MODES');

601: OPEN csr_chk_bal_dim_id_s(p_legislation_code);
602: FETCH csr_chk_bal_dim_id_s into l_exists;
603: IF csr_chk_bal_dim_id_s%NOTFOUND THEN
604: CLOSE csr_chk_bal_dim_id_s;
605: hr_utility.set_message(801, 'PAY_34257_INV_DIMID_4_MODES');
606: hr_utility.raise_error;
607: END IF;
608: CLOSE csr_chk_bal_dim_id_s;
609: --

Line 606: hr_utility.raise_error;

602: FETCH csr_chk_bal_dim_id_s into l_exists;
603: IF csr_chk_bal_dim_id_s%NOTFOUND THEN
604: CLOSE csr_chk_bal_dim_id_s;
605: hr_utility.set_message(801, 'PAY_34257_INV_DIMID_4_MODES');
606: hr_utility.raise_error;
607: END IF;
608: CLOSE csr_chk_bal_dim_id_s;
609: --
610: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

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

607: END IF;
608: CLOSE csr_chk_bal_dim_id_s;
609: --
610: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
611: hr_utility.set_location(l_proc, 25);
612: --
613: if p_bal_attribute_default_id is not null then
614: l_legislation_code := pay_pbd_bus.return_legislation_code
615: (p_bal_attribute_default_id);

Line 626: hr_utility.set_message(801, 'PAY_34259_INV_DIMID_4_MODEU');

622: ,p_business_group_id);
623: FETCH csr_chk_bal_dim_id_u into l_exists;
624: IF csr_chk_bal_dim_id_u%NOTFOUND THEN
625: CLOSE csr_chk_bal_dim_id_u;
626: hr_utility.set_message(801, 'PAY_34259_INV_DIMID_4_MODEU');
627: hr_utility.raise_error;
628: END IF;
629: CLOSE csr_chk_bal_dim_id_u;
630: --

Line 627: hr_utility.raise_error;

623: FETCH csr_chk_bal_dim_id_u into l_exists;
624: IF csr_chk_bal_dim_id_u%NOTFOUND THEN
625: CLOSE csr_chk_bal_dim_id_u;
626: hr_utility.set_message(801, 'PAY_34259_INV_DIMID_4_MODEU');
627: hr_utility.raise_error;
628: END IF;
629: CLOSE csr_chk_bal_dim_id_u;
630: --
631: END IF;

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

632: --
633: end if;
634: --
635: end if;
636: hr_utility.set_location('Leaving: '||l_proc, 20);
637: --
638: END chk_balance_dimension_id;
639: -- ----------------------------------------------------------------------------
640: -- |-----------------------< chk_non_updateable_args >------------------------|

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

689: nvl(pay_pbd_shd.g_old_rec.business_group_id, hr_api.g_number) then
690: l_argument := 'business_group_id';
691: raise l_error;
692: end if;
693: hr_utility.set_location(l_proc, 15);
694: --
695: if p_rec.balance_category_id <> pay_pbd_shd.g_old_rec.balance_category_id then
696: l_argument := 'balance_category_id';
697: raise l_error;

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

695: if p_rec.balance_category_id <> pay_pbd_shd.g_old_rec.balance_category_id then
696: l_argument := 'balance_category_id';
697: raise l_error;
698: end if;
699: hr_utility.set_location(l_proc, 20);
700: --
701: if p_rec.legislation_code <> pay_pbd_shd.g_old_rec.legislation_code then
702: l_argument := 'legislation_code';
703: raise l_error;

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

701: if p_rec.legislation_code <> pay_pbd_shd.g_old_rec.legislation_code then
702: l_argument := 'legislation_code';
703: raise l_error;
704: end if;
705: hr_utility.set_location(l_proc, 25);
706: --
707: if p_rec.bal_attribute_default_id <>
708: pay_pbd_shd.g_old_rec.bal_attribute_default_id then
709: l_argument := 'bal_attribute_default_id';

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

708: pay_pbd_shd.g_old_rec.bal_attribute_default_id then
709: l_argument := 'bal_attribute_default_id';
710: raise l_error;
711: end if;
712: hr_utility.set_location(l_proc, 30);
713: --
714: if p_rec.attribute_id <> pay_pbd_shd.g_old_rec.attribute_id then
715: l_argument := 'attribute_id';
716: raise l_error;

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

714: if p_rec.attribute_id <> pay_pbd_shd.g_old_rec.attribute_id then
715: l_argument := 'attribute_id';
716: raise l_error;
717: end if;
718: hr_utility.set_location(l_proc, 35);
719: --
720: if p_rec.balance_dimension_id <> pay_pbd_shd.g_old_rec.balance_dimension_id
721: then
722: l_argument := 'balance_dimension_id';

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

721: then
722: l_argument := 'balance_dimension_id';
723: raise l_error;
724: end if;
725: hr_utility.set_location(l_proc, 40);
726: --
727: End chk_non_updateable_args;
728: --
729: -- ----------------------------------------------------------------------------

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

777: --
778: l_proc varchar2(72) := g_package||'insert_validate';
779: --
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: -- Call all supporting business operations
784: --
785: --

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

812: ,p_business_group_id => p_rec.business_group_id
813: ,p_legislation_code => p_rec.legislation_code
814: );
815: --
816: hr_utility.set_location(l_proc, 10);
817: --
818: pay_pbd_bus.chk_balance_category_id
819: (p_bal_attribute_default_id => p_rec.bal_attribute_default_id
820: ,p_balance_category_id => p_rec.balance_category_id

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

820: ,p_balance_category_id => p_rec.balance_category_id
821: ,p_business_group_id => p_rec.business_group_id
822: ,p_legislation_code => p_rec.legislation_code
823: );
824: hr_utility.set_location(l_proc, 15);
825: --
826: pay_pbd_bus.chk_balance_dimension_id
827: (p_bal_attribute_default_id => p_rec.bal_attribute_default_id
828: ,p_balance_dimension_id => p_rec.balance_dimension_id

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

829: ,p_business_group_id => p_rec.business_group_id
830: ,p_legislation_code => p_rec.legislation_code
831: );
832: --
833: hr_utility.set_location(' Leaving:'||l_proc, 20);
834: End insert_validate;
835: --
836: -- ----------------------------------------------------------------------------
837: -- |---------------------------< delete_validate >----------------------------|

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

842: --
843: l_proc varchar2(72) := g_package||'delete_validate';
844: --
845: Begin
846: hr_utility.set_location('Entering:'||l_proc, 5);
847: --
848: -- NB. need to use g_old_rec, as p_rec is not pupulated with all the columns
849: -- for delete mode.
850: --

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

866: END IF;
867: --
868: -- Call all supporting business operations
869: --
870: hr_utility.set_location(' Leaving:'||l_proc, 10);
871: End delete_validate;
872: --
873: end pay_pbd_bus;