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_PPR_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_ppr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prmry_care_prvdr_id => p_prmry_care_prvdr_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_prmry_care_prvdr_id;
78: --
79: -- ----------------------------------------------------------------------------

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

105: l_proc varchar2(72) := g_package||'chk_pcp_name_spclty_not_null';
106: --
107: begin
108: --
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: if p_name is null or p_prmry_care_prvdr_typ_cd is null then
112: hr_utility.set_location('Error Provider Name or Speciality is null',99);
113: fnd_message.set_name('BEN','BEN_94126_PCP_NAME_SPL_REQD');

Line 112: hr_utility.set_location('Error Provider Name or Speciality is null',99);

108: --
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: if p_name is null or p_prmry_care_prvdr_typ_cd is null then
112: hr_utility.set_location('Error Provider Name or Speciality is null',99);
113: fnd_message.set_name('BEN','BEN_94126_PCP_NAME_SPL_REQD');
114: fnd_message.raise_error;
115: end if;
116: --

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

113: fnd_message.set_name('BEN','BEN_94126_PCP_NAME_SPL_REQD');
114: fnd_message.raise_error;
115: end if;
116: --
117: hr_utility.set_location('Leaving:'||l_proc,10);
118: --
119: end chk_pcp_name_spclty_not_null;
120:
121: -- ----------------------------------------------------------------------------

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

154: l_pcp_rpstry_flag varchar2(1);
155: --
156: Begin
157: --
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: l_api_updating := ben_ppr_shd.api_updating
161: (p_prmry_care_prvdr_id => p_prmry_care_prvdr_id,
162: p_effective_date => p_effective_date,

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

215: Null;
216: End;
217: End if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_prmry_care_prvdr_typ_cd;
222:
223:

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

231: l_api_updating boolean;
232: --
233: Begin
234: --
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: l_api_updating := ben_ppr_shd.api_updating
238: (p_prmry_care_prvdr_id => p_prmry_care_prvdr_id,
239: p_effective_date => p_effective_date,

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

262: end if;
263: --
264: end if;
265: --
266: hr_utility.set_location('Leaving:'||l_proc,10);
267: --
268: end chk_prmry_care_prvdr_typ_cd;
269:
270: ************************************************************************************* */

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

312: l_api_updating boolean;
313:
314: Begin
315: --
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: l_api_updating := ben_ppr_shd.api_updating
319: (p_prmry_care_prvdr_id => p_prmry_care_prvdr_id,
320: p_effective_date => p_effective_date,

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

339: end if;
340:
341: end if;
342: --
343: hr_utility.set_location('Leaving:'||l_proc, 10);
344: --
345: End chk_unique_type;
346:
347: -- ------------------------------------------------------------------------

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

491: l_api_updating boolean;
492: --
493: Begin
494: --
495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: if p_prtt_enrt_rslt_id is null and p_elig_cvrd_dpnt_id is null then
498: fnd_message.set_name('BEN','BEN_91819_RSLT_DPNT_NULL');
499: fnd_message.raise_error;

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

502: fnd_message.set_name('BEN','BEN_91820_RSLT_DPNT_NOTNULL');
503: fnd_message.raise_error;
504: end if;
505: --
506: hr_utility.set_location('Leaving:'||l_proc, 10);
507: --
508: End chk_rslt_dpnt_id;
509: --
510: -- ----------------------------------------------------------------------------

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

581: and effective_end_date;
582:
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);
586: --
587: if p_elig_cvrd_dpnt_id is not null then
588: -- get result id, dpnt person id.
589: open c_rslt_id;

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

635: end if;
636: end if;
637: end if;
638:
639: hr_utility.set_location('Leaving:'||l_proc, 15);
640: End chk_age_gendr_ppr_record;
641: --
642: -- ----------------------------------------------------------------------------
643: -- |------< chk_max_chgs_ppr_record >------|

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

697: and ppr.effective_start_date between p_first_day and p_last_day;
698:
699: --
700: Begin
701: hr_utility.set_location('Entering:'||l_proc, 5);
702: --
703: if p_elig_cvrd_dpnt_id is not null then
704: -- get rslt-id from dpnt record.
705: open c_prtt_enrt_rslt_id;

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

731: fnd_message.set_name('BEN','BEN_92580_MAX_NUM_CHGS');
732: fnd_message.set_token('NDATE', (l_last_day + 1));
733: fnd_message.raise_error;
734: end if;
735: hr_utility.set_location('Leaving:'||l_proc, 15);
736: End chk_max_chgs_ppr_record ;
737: --
738: --
739: -- ----------------------------------------------------------------------------

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

776: l_integrity_error Exception;
777: l_table_name all_tables.table_name%TYPE;
778: --
779: Begin
780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: -- Ensure that the p_datetrack_mode argument is not null
783: --
784: hr_api.mandatory_arg_error

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

825: End If;
826: --
827: End If;
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 10);
830: Exception
831: When l_integrity_error Then
832: --
833: -- A referential integrity check was violated therefore

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

891: l_rows_exist Exception;
892: l_table_name all_tables.table_name%TYPE;
893: --
894: Begin
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- Ensure that the p_datetrack_mode argument is not null
898: --
899: hr_api.mandatory_arg_error

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

928: --
929: --
930: End If;
931: --
932: hr_utility.set_location(' Leaving:'||l_proc, 10);
933: Exception
934: When l_rows_exist Then
935: --
936: -- A referential integrity check was violated therefore

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

961: --
962: l_proc varchar2(72) := g_package||'insert_validate';
963: --
964: Begin
965: hr_utility.set_location('Entering:'||l_proc, 5);
966: --
967: -- Call all supporting business operations
968: --
969: --

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

1016: p_elig_cvrd_dpnt_id => p_rec.elig_cvrd_dpnt_id,
1017: p_effective_date => p_effective_date);
1018:
1019: --
1020: hr_utility.set_location(' Leaving:'||l_proc, 10);
1021: End insert_validate;
1022: --
1023: -- ----------------------------------------------------------------------------
1024: -- |---------------------------< update_validate >----------------------------|

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

1033: l_proc varchar2(72) := g_package||'update_validate';
1034: --
1035: Begin
1036:
1037: hr_utility.set_location('Entering:'||l_proc, 5);
1038: --
1039: -- Call all supporting business operations
1040: --
1041: --

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

1098: p_datetrack_mode => p_datetrack_mode,
1099: p_validation_start_date => p_validation_start_date,
1100: p_validation_end_date => p_validation_end_date);
1101: --
1102: hr_utility.set_location(' Leaving:'||l_proc, 10);
1103: End update_validate;
1104: --
1105: -- ----------------------------------------------------------------------------
1106: -- |---------------------------< delete_validate >----------------------------|

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

1114: --
1115: l_proc varchar2(72) := g_package||'delete_validate';
1116: --
1117: Begin
1118: hr_utility.set_location('Entering:'||l_proc, 5);
1119: --
1120: -- Call all supporting business operations
1121: --
1122: dt_delete_validate

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

1124: p_validation_start_date => p_validation_start_date,
1125: p_validation_end_date => p_validation_end_date,
1126: p_prmry_care_prvdr_id => p_rec.prmry_care_prvdr_id);
1127: --
1128: hr_utility.set_location(' Leaving:'||l_proc, 10);
1129: End delete_validate;
1130: --
1131: --
1132: -- ---------------------------------------------------------------------------

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

1151: l_proc varchar2(72) := g_package||'return_legislation_code';
1152: --
1153: begin
1154: --
1155: hr_utility.set_location('Entering:'|| l_proc, 10);
1156: --
1157: -- Ensure that all the mandatory parameter are not null
1158: --
1159: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1176: end if;
1177: --
1178: close csr_leg_code;
1179: --
1180: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1181: --
1182: return l_legislation_code;
1183: --
1184: end return_legislation_code;