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

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

42: -- l_proc varchar2(72) := g_package||'set_security_group_id';
43: --
44: --begin
45: --
46: -- hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: -- hr_api.mandatory_arg_error

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

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

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

108: -- l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: --Begin
111: --
112: -- hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: -- hr_api.mandatory_arg_error

Line 130: -- hr_utility.set_location(l_proc, 20);

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: -- l_legislation_code := pay_gbe_bus.g_legislation_code;
130: -- hr_utility.set_location(l_proc, 20);
131: -- else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: -- hr_utility.set_location(l_proc,30);

143: -- close csr_leg_code;
144: -- fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: -- fnd_message.raise_error;
146: -- end if;
147: -- hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: -- close csr_leg_code;
153: -- pay_gbe_bus.g_grossup_balances_i:= p_grossup_balances_id;
154: -- pay_gbe_bus.g_legislation_code := l_legislation_code;
155: -- end if;
156: -- hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: -- return l_legislation_code;
158: --end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

Line 218: hr_utility.set_location(l_proc, 7);

214: nvl(pay_gbe_shd.g_old_rec.grossup_balances_id, hr_api.g_number) then
215: l_argument := 'grossup_balances_id';
216: raise l_error;
217: end if;
218: hr_utility.set_location(l_proc, 7);
219: --
220: EXCEPTION
221: WHEN l_error THEN
222: hr_api.argument_changed_error

Line 289: hr_utility.set_location('Entering:'|| l_proc, 1);

285: And source_id = p_source_id
286: And balance_type_id = p_balance_type_id ;
287: --
288: begin
289: hr_utility.set_location('Entering:'|| l_proc, 1);
290: --
291: -- check that the start date is not on or more than the end date
292: --
293: IF nvl(p_start_date, hr_general.START_OF_TIME)

Line 296: hr_utility.set_message

292: --
293: IF nvl(p_start_date, hr_general.START_OF_TIME)
294: > NVL(p_end_date, hr_general.END_OF_TIME) THEN
295: --
296: hr_utility.set_message
297: (800
298: ,'PAY_52900_GBE_DATE_ERROR'
299: );
300: hr_utility.raise_error;

Line 300: hr_utility.raise_error;

296: hr_utility.set_message
297: (800
298: ,'PAY_52900_GBE_DATE_ERROR'
299: );
300: hr_utility.raise_error;
301: --
302: END IF;
303: --
304: l_api_updating := pay_gbe_shd.api_updating (

Line 313: hr_utility.set_location(l_proc, 4);

309: and ( nvl(p_start_date,hr_general.start_of_time)
310: <> nvl(per_asp_shd.g_old_rec.start_date, hr_general.start_of_time)
311: or nvl(p_end_date,hr_general.end_of_time)
312: <> nvl(per_asp_shd.g_old_rec.end_date, hr_general.end_of_time))) then
313: hr_utility.set_location(l_proc, 4);
314: open c1_upd;
315: fetch c1_upd into l_exists;
316: If c1_upd%found then
317: hr_utility.set_location(l_proc, 5);

Line 317: hr_utility.set_location(l_proc, 5);

313: hr_utility.set_location(l_proc, 4);
314: open c1_upd;
315: fetch c1_upd into l_exists;
316: If c1_upd%found then
317: hr_utility.set_location(l_proc, 5);
318: Close c1_upd;
319: hr_utility.set_message
320: (800
321: ,'PAY_52901_GBE_OVERLAP_ERROR'

Line 319: hr_utility.set_message

315: fetch c1_upd into l_exists;
316: If c1_upd%found then
317: hr_utility.set_location(l_proc, 5);
318: Close c1_upd;
319: hr_utility.set_message
320: (800
321: ,'PAY_52901_GBE_OVERLAP_ERROR'
322: );
323: hr_utility.raise_error;

Line 323: hr_utility.raise_error;

319: hr_utility.set_message
320: (800
321: ,'PAY_52901_GBE_OVERLAP_ERROR'
322: );
323: hr_utility.raise_error;
324: else Close c1_upd;
325: End if;
326: end if;
327: --

Line 387: hr_utility.set_location('Entering:'|| l_proc, 1);

383: And source_id = p_source_id
384: And balance_type_id = p_balance_type_id ;
385: --
386: begin
387: hr_utility.set_location('Entering:'|| l_proc, 1);
388: --
389: -- check that the start date is not on or more than the end date
390: --
391: IF nvl(p_start_date, hr_general.START_OF_TIME)

Line 394: hr_utility.set_message

390: --
391: IF nvl(p_start_date, hr_general.START_OF_TIME)
392: > NVL(p_end_date, hr_general.END_OF_TIME) THEN
393: --
394: hr_utility.set_message
395: (800
396: ,'PAY_52900_GBE_DATE_ERROR'
397: );
398: hr_utility.raise_error;

Line 398: hr_utility.raise_error;

394: hr_utility.set_message
395: (800
396: ,'PAY_52900_GBE_DATE_ERROR'
397: );
398: hr_utility.raise_error;
399: --
400: END IF;
401: --
402: open C1_ins;

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

401: --
402: open C1_ins;
403: fetch C1_ins into l_exists;
404: If C1_ins%found then
405: hr_utility.set_location(l_proc, 5);
406: Close C1_ins;
407: hr_utility.set_message
408: (800
409: ,'PAY_52901_GBE_OVERLAP_ERROR'

Line 407: hr_utility.set_message

403: fetch C1_ins into l_exists;
404: If C1_ins%found then
405: hr_utility.set_location(l_proc, 5);
406: Close C1_ins;
407: hr_utility.set_message
408: (800
409: ,'PAY_52901_GBE_OVERLAP_ERROR'
410: );
411: hr_utility.raise_error;

Line 411: hr_utility.raise_error;

407: hr_utility.set_message
408: (800
409: ,'PAY_52901_GBE_OVERLAP_ERROR'
410: );
411: hr_utility.raise_error;
412: else Close C1_ins;
413: End if;
414: --
415: END chk_ins_dates;

Line 465: hr_utility.set_location('Entering:'|| p_source_type, 1);

461: where et.element_type_id = p_source_id ;
462: --
463: begin
464: --
465: hr_utility.set_location('Entering:'|| p_source_type, 1);
466: hr_api.mandatory_arg_error
467: (p_api_name => l_proc
468: ,p_argument => 'source_type'
469: ,p_argument_value => p_source_type

Line 485: hr_utility.set_location(l_proc, 3);

481: if (p_source_type = 'EE') then
482: open C_ee;
483: fetch C_ee into l_exists;
484: if C_ee%notfound then
485: hr_utility.set_location(l_proc, 3);
486: close C_ee;
487: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');
488: hr_utility.raise_error;
489: end if;

Line 487: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');

483: fetch C_ee into l_exists;
484: if C_ee%notfound then
485: hr_utility.set_location(l_proc, 3);
486: close C_ee;
487: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');
488: hr_utility.raise_error;
489: end if;
490: close C_ee;
491: elsif (p_source_type = 'ET') then

Line 488: hr_utility.raise_error;

484: if C_ee%notfound then
485: hr_utility.set_location(l_proc, 3);
486: close C_ee;
487: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');
488: hr_utility.raise_error;
489: end if;
490: close C_ee;
491: elsif (p_source_type = 'ET') then
492: open C_et;

Line 495: hr_utility.set_location(l_proc, 3);

491: elsif (p_source_type = 'ET') then
492: open C_et;
493: fetch C_et into l_exists;
494: if C_et%notfound then
495: hr_utility.set_location(l_proc, 3);
496: close C_et;
497: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');
498: hr_utility.raise_error;
499: end if;

Line 497: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');

493: fetch C_et into l_exists;
494: if C_et%notfound then
495: hr_utility.set_location(l_proc, 3);
496: close C_et;
497: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');
498: hr_utility.raise_error;
499: end if;
500: close C_et;
501: end if;

Line 498: hr_utility.raise_error;

494: if C_et%notfound then
495: hr_utility.set_location(l_proc, 3);
496: close C_et;
497: hr_utility.set_message(801, 'PAY_52902_GBE_SOURCE_ERROR');
498: hr_utility.raise_error;
499: end if;
500: close C_et;
501: end if;
502: --

Line 503: hr_utility.set_location(l_proc, 2);

499: end if;
500: close C_et;
501: end if;
502: --
503: hr_utility.set_location(l_proc, 2);
504: --
505: end chk_source;
506: --
507: -- ----------------------------------------------------------------------------

Line 555: hr_utility.set_location(l_proc, 3);

551: --
552: open C1;
553: fetch C1 into l_exists;
554: if C1%notfound then
555: hr_utility.set_location(l_proc, 3);
556: close C1;
557: -- raise error as FK does not relate to PK in pay_balance_types
558: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_FK1');
559: end if;

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

557: -- raise error as FK does not relate to PK in pay_balance_types
558: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_FK1');
559: end if;
560: close C1;
561: hr_utility.set_location('Leaving:'|| l_proc, 10);
562: end chk_bal_type_id;
563: --
564: -- ----------------------------------------------------------------------------
565: -- |---------------------------< chk_unique_key >-----------------------------|

Line 613: hr_utility.set_location('Entering:'|| l_proc, 1);

609: and gbe.source_id = p_source_id ;
610: --
611: begin
612: --
613: hr_utility.set_location('Entering:'|| l_proc, 1);
614: --
615: open C1;
616: fetch C1 into l_exists;
617: if C1%found then

Line 618: hr_utility.set_location(l_proc, 3);

614: --
615: open C1;
616: fetch C1 into l_exists;
617: if C1%found then
618: hr_utility.set_location(l_proc, 3);
619: -- row is not unique
620: close C1;
621: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_UK1');
622: end if;

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

621: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_UK1');
622: end if;
623: close C1;
624: --
625: hr_utility.set_location('Leaving:'|| l_proc, 10);
626: --
627: end chk_unique_key;
628: --
629: -- ----------------------------------------------------------------------------

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

635: --
636: l_proc varchar2(72) := g_package||'insert_validate';
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- Call all supporting business operations
642: --
643: chk_ins_dates (

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

658: ,p_end_date => p_rec.end_date
659: ,p_source_type => p_rec.source_type
660: ,p_source_id => p_rec.source_id );
661: --
662: hr_utility.set_location(' Leaving:'||l_proc, 10);
663: --
664: End insert_validate;
665: --
666: -- ----------------------------------------------------------------------------

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

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

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

699: ,p_end_date => p_rec.end_date
700: ,p_source_type => p_rec.source_type
701: ,p_source_id => p_rec.source_id );
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 10);
704: --
705: End update_validate;
706: --
707: -- ----------------------------------------------------------------------------

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

713: --
714: l_proc varchar2(72) := g_package||'delete_validate';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Call all supporting business operations
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Call all supporting business operations
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 10);
722: End delete_validate;
723: --
724: end pay_gbe_bus;