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.

[Home] [Help]

APPS.PER_ES_ORG_INFO dependencies on HR_UTILITY

Line 58: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

54: BEGIN
55: --
56: -- Added for GSI Bug 5472781
57: --
58: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
59: --
60: OPEN get_business_group;
61: FETCH get_business_group into l_business_group_id;
62: CLOSE get_business_group;

Line 81: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');

77: FETCH csr_chk_contribution_ac_type into l_chk;
78: CLOSE csr_chk_contribution_ac_type;
79: --
80: IF l_chk = 'Y' THEN
81: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
82: hr_utility.raise_error;
83: END IF;
84: --
85: END IF;

Line 82: hr_utility.raise_error;

78: CLOSE csr_chk_contribution_ac_type;
79: --
80: IF l_chk = 'Y' THEN
81: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
82: hr_utility.raise_error;
83: END IF;
84: --
85: END IF;
86: --

Line 92: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');

88: --
89: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
90: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
91: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
92: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
93: hr_utility.raise_error;
94: END IF;
95: END IF;
96: END IF;

Line 93: hr_utility.raise_error;

89: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
90: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
91: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
92: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
93: hr_utility.raise_error;
94: END IF;
95: END IF;
96: END IF;
97: --

Line 103: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');

99: --
100: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
101: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
102: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
103: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
104: hr_utility.raise_error;
105: END IF;
106: END IF;
107: END IF;

Line 104: hr_utility.raise_error;

100: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
101: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
102: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
103: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
104: hr_utility.raise_error;
105: END IF;
106: END IF;
107: END IF;
108: --

Line 114: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');

110: --
111: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
112: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
113: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
114: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
115: hr_utility.raise_error;
116: END IF;
117: END IF;
118: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN

Line 115: hr_utility.raise_error;

111: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
112: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
113: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
114: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
115: hr_utility.raise_error;
116: END IF;
117: END IF;
118: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
119: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

Line 119: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

115: hr_utility.raise_error;
116: END IF;
117: END IF;
118: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
119: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
120: hr_utility.raise_error;
121: END IF;
122: END IF;
123: --

Line 120: hr_utility.raise_error;

116: END IF;
117: END IF;
118: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
119: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
120: hr_utility.raise_error;
121: END IF;
122: END IF;
123: --
124: -- Validation for Contribution Exempt Situation dates

Line 129: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');

125: --
126: IF p_org_info_type_code='ES_CONTRIB_EXEMPT' THEN
127: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
128: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
129: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
130: hr_utility.raise_error;
131: END IF;
132: END IF;
133: END IF;

Line 130: hr_utility.raise_error;

126: IF p_org_info_type_code='ES_CONTRIB_EXEMPT' THEN
127: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
128: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
129: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
130: hr_utility.raise_error;
131: END IF;
132: END IF;
133: END IF;
134: --

Line 140: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');

136: --
137: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
138: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
139: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
140: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
141: hr_utility.raise_error;
142: END IF;
143: END IF;
144: END IF;

Line 141: hr_utility.raise_error;

137: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
138: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
139: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
140: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
141: hr_utility.raise_error;
142: END IF;
143: END IF;
144: END IF;
145: --

Line 158: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

154: -- Validation for Benefit Uplift Formulas -- Employer level.
155: --
156: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
157: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
158: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
159: hr_utility.raise_error;
160: END IF;
161: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
162: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN

Line 159: hr_utility.raise_error;

155: --
156: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
157: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
158: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
159: hr_utility.raise_error;
160: END IF;
161: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
162: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
163: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');

Line 163: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');

159: hr_utility.raise_error;
160: END IF;
161: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
162: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
163: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
164: hr_utility.raise_error;
165: END IF;
166: END IF;
167: END IF;

Line 164: hr_utility.raise_error;

160: END IF;
161: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
162: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
163: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
164: hr_utility.raise_error;
165: END IF;
166: END IF;
167: END IF;
168: --

Line 181: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');

177: FETCH csr_chk_province_code into l_chk;
178: CLOSE csr_chk_province_code;
179: --
180: IF l_chk <> 'Y' THEN
181: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
182: hr_utility.raise_error;
183: END IF;
184: END IF;
185: --

Line 182: hr_utility.raise_error;

178: CLOSE csr_chk_province_code;
179: --
180: IF l_chk <> 'Y' THEN
181: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
182: hr_utility.raise_error;
183: END IF;
184: END IF;
185: --
186: END IF;

Line 245: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

241: BEGIN
242: --
243: -- Added for GSI Bug 5472781
244: --
245: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
246: --
247: --
248: OPEN get_business_group;
249: FETCH get_business_group into l_business_group_id;

Line 274: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');

270: FETCH csr_chk_contribution_ac_type into l_chk;
271: CLOSE csr_chk_contribution_ac_type;
272: --
273: IF l_chk = 'Y' THEN
274: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
275: hr_utility.raise_error;
276: END IF;
277: --
278: END IF;

Line 275: hr_utility.raise_error;

271: CLOSE csr_chk_contribution_ac_type;
272: --
273: IF l_chk = 'Y' THEN
274: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
275: hr_utility.raise_error;
276: END IF;
277: --
278: END IF;
279: --

Line 285: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');

281: --
282: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
283: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
284: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
285: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
286: hr_utility.raise_error;
287: END IF;
288: END IF;
289: END IF;

Line 286: hr_utility.raise_error;

282: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
283: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
284: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
285: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
286: hr_utility.raise_error;
287: END IF;
288: END IF;
289: END IF;
290: --

Line 296: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');

292: --
293: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
294: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
295: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
296: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
297: hr_utility.raise_error;
298: END IF;
299: END IF;
300: END IF;

Line 297: hr_utility.raise_error;

293: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
294: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
295: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
296: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
297: hr_utility.raise_error;
298: END IF;
299: END IF;
300: END IF;
301: --

Line 307: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');

303: --
304: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
305: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
306: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
307: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
308: hr_utility.raise_error;
309: END IF;
310: END IF;
311: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN

Line 308: hr_utility.raise_error;

304: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
305: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
306: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
307: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
308: hr_utility.raise_error;
309: END IF;
310: END IF;
311: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
312: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

Line 312: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

308: hr_utility.raise_error;
309: END IF;
310: END IF;
311: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
312: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
313: hr_utility.raise_error;
314: END IF;
315: END IF;
316: --

Line 313: hr_utility.raise_error;

309: END IF;
310: END IF;
311: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
312: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
313: hr_utility.raise_error;
314: END IF;
315: END IF;
316: --
317: -- Validation for Contribution Exempt Situation dates

Line 322: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');

318: --
319: IF p_org_info_type_code = 'ES_CONTRIB_EXEMPT' THEN
320: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
321: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
322: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
323: hr_utility.raise_error;
324: END IF;
325: END IF;
326: END IF;

Line 323: hr_utility.raise_error;

319: IF p_org_info_type_code = 'ES_CONTRIB_EXEMPT' THEN
320: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
321: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
322: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
323: hr_utility.raise_error;
324: END IF;
325: END IF;
326: END IF;
327: --

Line 333: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');

329: --
330: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
331: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
332: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
333: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
334: hr_utility.raise_error;
335: END IF;
336: END IF;
337: END IF;

Line 334: hr_utility.raise_error;

330: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
331: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
332: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
333: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
334: hr_utility.raise_error;
335: END IF;
336: END IF;
337: END IF;
338: --

Line 351: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

347: -- Validation for Benefit Uplift Formulas -- Employer level.
348: --
349: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
350: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
351: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
352: hr_utility.raise_error;
353: END IF;
354: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
355: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN

Line 352: hr_utility.raise_error;

348: --
349: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
350: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
351: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
352: hr_utility.raise_error;
353: END IF;
354: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
355: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
356: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');

Line 356: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');

352: hr_utility.raise_error;
353: END IF;
354: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
355: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
356: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
357: hr_utility.raise_error;
358: END IF;
359: END IF;
360: END IF;

Line 357: hr_utility.raise_error;

353: END IF;
354: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
355: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
356: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
357: hr_utility.raise_error;
358: END IF;
359: END IF;
360: END IF;
361: --

Line 374: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');

370: FETCH csr_chk_province_code into l_chk;
371: CLOSE csr_chk_province_code;
372: --
373: IF l_chk <> 'Y' THEN
374: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
375: hr_utility.raise_error;
376: END IF;
377: END IF;
378: --

Line 375: hr_utility.raise_error;

371: CLOSE csr_chk_province_code;
372: --
373: IF l_chk <> 'Y' THEN
374: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
375: hr_utility.raise_error;
376: END IF;
377: END IF;
378: --
379: END IF;