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

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_cqr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_cbr_quald_bnf_rt_id;
78:
79: --

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

139: and p_validation_end_date >= effective_start_date;
140: --
141: BEGIN
142: --
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: l_api_updating := ben_cqr_shd.api_updating
146: (p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
147: p_effective_date => p_effective_date,

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

172: end if;
173: close c_dup;
174: --
175: end if;
176: hr_utility.set_location('Leaving:'||l_proc,10);
177: --
178: END chk_dup_record;
179:
180:

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

219: where a.pgm_id = p_pgm_id;
220: --
221: Begin
222: --
223: hr_utility.set_location('Entering:'||l_proc,5);
224: --
225: l_api_updating := ben_cqr_shd.api_updating
226: (p_effective_date => p_effective_date,
227: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,

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

251: close c1;
252: --
253: end if;
254: --
255: hr_utility.set_location('Leaving:'||l_proc,10);
256: --
257: End chk_pgm_id;
258: --
259: -- ----------------------------------------------------------------------------

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

296: where a.ptip_id = p_ptip_id;
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := ben_cqr_shd.api_updating
303: (p_effective_date => p_effective_date,
304: p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,

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

328: close c1;
329: --
330: end if;
331: --
332: hr_utility.set_location('Leaving:'||l_proc,10);
333: --
334: End chk_ptip_id;
335: --
336: -- ----------------------------------------------------------------------------

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

368: l_api_updating boolean;
369: --
370: Begin
371: --
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: l_api_updating := ben_cqr_shd.api_updating
375: (p_cbr_quald_bnf_rt_id => p_cbr_quald_bnf_rt_id,
376: p_effective_date => p_effective_date,

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

399: end if;
400: --
401: end if;
402: --
403: hr_utility.set_location('Leaving:'||l_proc,10);
404: --
405: end chk_quald_bnf_flag;
406: --
407: -- added for Bug 5078478 .. add this procedure to check the duplicate seq no

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

453: and business_group_id + 0 = p_business_group_id
454: and ordr_num = p_ordr_num;
455: --
456: Begin
457: hr_utility.set_location('Entering:'||l_proc, 5);
458:
459: --
460: open c1;
461: fetch c1 into l_dummy;

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

465: fnd_message.raise_error;
466: end if;
467: close c1;
468: --
469: hr_utility.set_location('Leaving:'||l_proc, 15);
470: End chk_duplicate_ordr_num;
471:
472: --
473: -- ----------------------------------------------------------------------------

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

511: l_integrity_error Exception;
512: l_table_name all_tables.table_name%TYPE;
513: --
514: Begin
515: hr_utility.set_location('Entering:'||l_proc, 5);
516: --
517: -- Ensure that the p_datetrack_mode argument is not null
518: --
519: hr_api.mandatory_arg_error

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

570: End If;
571: --
572: End If;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: Exception
576: When l_integrity_error Then
577: --
578: -- A referential integrity check was violated therefore

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

636: l_rows_exist Exception;
637: l_table_name all_tables.table_name%TYPE;
638: --
639: Begin
640: hr_utility.set_location('Entering:'||l_proc, 5);
641: --
642: -- Ensure that the p_datetrack_mode argument is not null
643: --
644: hr_api.mandatory_arg_error

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

673: --
674: --
675: End If;
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: Exception
679: When l_rows_exist Then
680: --
681: -- A referential integrity check was violated therefore

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

707: --
708: l_proc varchar2(72) := g_package||'insert_validate';
709: --
710: Begin
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: -- Call all supporting business operations
714: --
715: --

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

759: ,p_validation_end_date => p_validation_end_date
760: ,p_business_group_id => p_rec.business_group_id);
761:
762: --
763: hr_utility.set_location(' Leaving:'||l_proc, 10);
764: End insert_validate;
765: --
766: -- ----------------------------------------------------------------------------
767: -- |---------------------------< update_validate >----------------------------|

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

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

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

836: p_datetrack_mode => p_datetrack_mode,
837: p_validation_start_date => p_validation_start_date,
838: p_validation_end_date => p_validation_end_date);
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 10);
841: End update_validate;
842: --
843: -- ----------------------------------------------------------------------------
844: -- |---------------------------< delete_validate >----------------------------|

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

852: --
853: l_proc varchar2(72) := g_package||'delete_validate';
854: --
855: Begin
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: -- Call all supporting business operations
859: --
860: dt_delete_validate

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

862: p_validation_start_date => p_validation_start_date,
863: p_validation_end_date => p_validation_end_date,
864: p_cbr_quald_bnf_rt_id => p_rec.cbr_quald_bnf_rt_id);
865: --
866: hr_utility.set_location(' Leaving:'||l_proc, 10);
867: End delete_validate;
868: --
869: --
870: -- ---------------------------------------------------------------------------

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

889: l_proc varchar2(72) := g_package||'return_legislation_code';
890: --
891: begin
892: --
893: hr_utility.set_location('Entering:'|| l_proc, 10);
894: --
895: -- Ensure that all the mandatory parameter are not null
896: --
897: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

914: end if;
915: --
916: close csr_leg_code;
917: --
918: hr_utility.set_location(' Leaving:'|| l_proc, 20);
919: --
920: return l_legislation_code;
921: --
922: end return_legislation_code;