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.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 88: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');

84: FETCH csr_chk_contribution_ac_type into l_chk;
85: CLOSE csr_chk_contribution_ac_type;
86: --
87: IF l_chk = 'Y' THEN
88: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
89: hr_utility.raise_error;
90: END IF;
91: */
92: --

Line 89: hr_utility.raise_error;

85: CLOSE csr_chk_contribution_ac_type;
86: --
87: IF l_chk = 'Y' THEN
88: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
89: hr_utility.raise_error;
90: END IF;
91: */
92: --
93: END IF;

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

96: --
97: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
98: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
99: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
100: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
101: hr_utility.raise_error;
102: END IF;
103: END IF;
104: END IF;

Line 101: hr_utility.raise_error;

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

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

107: --
108: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
109: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
110: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
111: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
112: hr_utility.raise_error;
113: END IF;
114: END IF;
115: END IF;

Line 112: hr_utility.raise_error;

108: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
109: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
110: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
111: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
112: hr_utility.raise_error;
113: END IF;
114: END IF;
115: END IF;
116: --

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

118: --
119: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
120: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
121: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
122: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
123: hr_utility.raise_error;
124: END IF;
125: END IF;
126: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN

Line 123: hr_utility.raise_error;

119: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
120: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
121: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
122: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
123: hr_utility.raise_error;
124: END IF;
125: END IF;
126: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
127: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

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

123: hr_utility.raise_error;
124: END IF;
125: END IF;
126: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
127: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
128: hr_utility.raise_error;
129: END IF;
130: END IF;
131: --

Line 128: hr_utility.raise_error;

124: END IF;
125: END IF;
126: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
127: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
128: hr_utility.raise_error;
129: END IF;
130: END IF;
131: --
132: -- Validation for Contribution Exempt Situation dates

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

133: --
134: IF p_org_info_type_code='ES_CONTRIB_EXEMPT' THEN
135: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
136: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
137: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
138: hr_utility.raise_error;
139: END IF;
140: END IF;
141: END IF;

Line 138: hr_utility.raise_error;

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

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

144: --
145: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
146: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
147: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
148: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
149: hr_utility.raise_error;
150: END IF;
151: END IF;
152: END IF;

Line 149: hr_utility.raise_error;

145: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
146: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
147: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
148: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
149: hr_utility.raise_error;
150: END IF;
151: END IF;
152: END IF;
153: --

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

162: -- Validation for Benefit Uplift Formulas -- Employer level.
163: --
164: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
165: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
166: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
167: hr_utility.raise_error;
168: END IF;
169: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
170: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN

Line 167: hr_utility.raise_error;

163: --
164: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
165: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
166: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
167: hr_utility.raise_error;
168: END IF;
169: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
170: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
171: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');

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

167: hr_utility.raise_error;
168: END IF;
169: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
170: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
171: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
172: hr_utility.raise_error;
173: END IF;
174: END IF;
175: END IF;

Line 172: hr_utility.raise_error;

168: END IF;
169: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
170: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
171: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
172: hr_utility.raise_error;
173: END IF;
174: END IF;
175: END IF;
176: --

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

185: FETCH csr_chk_province_code into l_chk;
186: CLOSE csr_chk_province_code;
187: --
188: IF l_chk <> 'Y' THEN
189: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
190: hr_utility.raise_error;
191: END IF;
192: END IF;
193: --

Line 190: hr_utility.raise_error;

186: CLOSE csr_chk_province_code;
187: --
188: IF l_chk <> 'Y' THEN
189: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
190: hr_utility.raise_error;
191: END IF;
192: END IF;
193: --
194: END IF;

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

249: BEGIN
250: --
251: -- Added for GSI Bug 5472781
252: --
253: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
254: --
255: --
256: OPEN get_business_group;
257: FETCH get_business_group into l_business_group_id;

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

284: FETCH csr_chk_contribution_ac_type into l_chk;
285: CLOSE csr_chk_contribution_ac_type;
286: --
287: IF l_chk = 'Y' THEN
288: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
289: hr_utility.raise_error;
290: END IF;
291: */
292: --

Line 289: hr_utility.raise_error;

285: CLOSE csr_chk_contribution_ac_type;
286: --
287: IF l_chk = 'Y' THEN
288: hr_utility.set_message(800, 'HR_ES_CAT_UNIQUE_ERROR');
289: hr_utility.raise_error;
290: END IF;
291: */
292: --
293: END IF;

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

296: --
297: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
298: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
299: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
300: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
301: hr_utility.raise_error;
302: END IF;
303: END IF;
304: END IF;

Line 301: hr_utility.raise_error;

297: IF p_org_info_type_code = 'ES_WC_NATURAL_DISASTER' THEN
298: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
299: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
300: hr_utility.set_message(800, 'HR_ES_NAT_DIS_DATE_VALIDATION');
301: hr_utility.raise_error;
302: END IF;
303: END IF;
304: END IF;
305: --

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

307: --
308: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
309: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
310: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
311: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
312: hr_utility.raise_error;
313: END IF;
314: END IF;
315: END IF;

Line 312: hr_utility.raise_error;

308: IF p_org_info_type_code = 'ES_WC_SHUTDOWN' THEN
309: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
310: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
311: hr_utility.set_message(800, 'HR_ES_SD_DATE_VALIDATION');
312: hr_utility.raise_error;
313: END IF;
314: END IF;
315: END IF;
316: --

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

318: --
319: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
320: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
321: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
322: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
323: hr_utility.raise_error;
324: END IF;
325: END IF;
326: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN

Line 323: hr_utility.raise_error;

319: IF p_org_info_type_code = 'ES_WC_PARTIAL_UNEMPLOYMENT' THEN
320: IF (p_org_information1 IS NOT NULL) AND (p_org_information2 IS NOT NULL) THEN
321: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) THEN
322: hr_utility.set_message(800, 'HR_ES_PAR_UE_DATE_VALIDATION');
323: hr_utility.raise_error;
324: END IF;
325: END IF;
326: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
327: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

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

323: hr_utility.raise_error;
324: END IF;
325: END IF;
326: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
327: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
328: hr_utility.raise_error;
329: END IF;
330: END IF;
331: --

Line 328: hr_utility.raise_error;

324: END IF;
325: END IF;
326: IF (p_org_information5 = 'GROSS_PAY' ) AND (p_org_information6 IS NULL) THEN
327: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
328: hr_utility.raise_error;
329: END IF;
330: END IF;
331: --
332: -- Validation for Contribution Exempt Situation dates

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

333: --
334: IF p_org_info_type_code = 'ES_CONTRIB_EXEMPT' THEN
335: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
336: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
337: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
338: hr_utility.raise_error;
339: END IF;
340: END IF;
341: END IF;

Line 338: hr_utility.raise_error;

334: IF p_org_info_type_code = 'ES_CONTRIB_EXEMPT' THEN
335: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
336: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
337: hr_utility.set_message(800, 'HR_ES_CON_EXMT_DATE_VALIDATION');
338: hr_utility.raise_error;
339: END IF;
340: END IF;
341: END IF;
342: --

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

344: --
345: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
346: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
347: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
348: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
349: hr_utility.raise_error;
350: END IF;
351: END IF;
352: END IF;

Line 349: hr_utility.raise_error;

345: IF p_org_info_type_code='ES_TEMP_DISABILITY_MGT' THEN
346: IF (p_org_information2 IS NOT NULL) AND (p_org_information3 IS NOT NULL) THEN
347: IF fnd_date.canonical_to_date(p_org_information2) > fnd_date.canonical_to_date(p_org_information3) THEN
348: hr_utility.set_message(800, 'HR_ES_TEMP_DIS_DATE_VALIDATION');
349: hr_utility.raise_error;
350: END IF;
351: END IF;
352: END IF;
353: --

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

362: -- Validation for Benefit Uplift Formulas -- Employer level.
363: --
364: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
365: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
366: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
367: hr_utility.raise_error;
368: END IF;
369: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
370: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN

Line 367: hr_utility.raise_error;

363: --
364: IF p_org_info_type_code = 'ES_BENEFIT_UPLIFT' THEN
365: IF (p_org_information2 = 'GROSS_PAY' ) AND (p_org_information3 IS NULL) THEN
366: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
367: hr_utility.raise_error;
368: END IF;
369: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
370: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
371: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');

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

367: hr_utility.raise_error;
368: END IF;
369: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
370: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
371: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
372: hr_utility.raise_error;
373: END IF;
374: END IF;
375: END IF;

Line 372: hr_utility.raise_error;

368: END IF;
369: IF (p_org_information5 IS NOT NULL) AND (p_org_information6 IS NOT NULL) THEN
370: IF fnd_date.canonical_to_date(p_org_information5) > fnd_date.canonical_to_date(p_org_information6) THEN
371: hr_utility.set_message(800, 'HR_ES_BU_DATE_VALIDATION');
372: hr_utility.raise_error;
373: END IF;
374: END IF;
375: END IF;
376: --

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

385: FETCH csr_chk_province_code into l_chk;
386: CLOSE csr_chk_province_code;
387: --
388: IF l_chk <> 'Y' THEN
389: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
390: hr_utility.raise_error;
391: END IF;
392: END IF;
393: --

Line 390: hr_utility.raise_error;

386: CLOSE csr_chk_province_code;
387: --
388: IF l_chk <> 'Y' THEN
389: hr_utility.set_message(800, 'HR_ES_INVALID_TAX_CODE');
390: hr_utility.raise_error;
391: END IF;
392: END IF;
393: --
394: END IF;