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

Line 17: hr_utility.set_location('pywcdcr.insert_row', 0);

13: X_CALCULATION_METHOD VARCHAR2,
14: X_CALCULATION_METHOD2 VARCHAR2,
15: X_CALCULATION_METHOD3 VARCHAR2) IS
16: BEGIN
17: hr_utility.set_location('pywcdcr.insert_row', 0);
18: --
19: SELECT PAY_WC_FUNDS_S.NEXTVAL
20: INTO X_FUND_ID
21: FROM DUAL;

Line 23: hr_utility.set_location('pywcdcr.insert_row', 1);

19: SELECT PAY_WC_FUNDS_S.NEXTVAL
20: INTO X_FUND_ID
21: FROM DUAL;
22: --
23: hr_utility.set_location('pywcdcr.insert_row', 1);
24: --
25: IF (SQL%NOTFOUND) THEN
26: RAISE NO_DATA_FOUND;
27: END IF;

Line 29: hr_utility.set_location('pywcdcr.insert_row', 2);

25: IF (SQL%NOTFOUND) THEN
26: RAISE NO_DATA_FOUND;
27: END IF;
28: --
29: hr_utility.set_location('pywcdcr.insert_row', 2);
30: --
31: INSERT INTO PAY_WC_FUNDS
32: (FUND_ID, BUSINESS_GROUP_ID, CARRIER_ID, LOCATION_ID,
33: STATE_CODE, CALCULATION_METHOD, CALCULATION_METHOD2, CALCULATION_METHOD3)

Line 38: hr_utility.set_location('pywcdcr.insert_row', 3);

34: VALUES
35: (X_FUND_ID, X_BUSINESS_GROUP_ID, X_CARRIER_ID, X_LOCATION_ID,
36: X_STATE_CODE, X_CALCULATION_METHOD, X_CALCULATION_METHOD2, X_CALCULATION_METHOD3);
37: --
38: hr_utility.set_location('pywcdcr.insert_row', 3);
39: --
40: SELECT ROWID
41: INTO X_ROWID
42: FROM PAY_WC_FUNDS

Line 45: hr_utility.set_location('pywcdcr.insert_row', 4);

41: INTO X_ROWID
42: FROM PAY_WC_FUNDS
43: WHERE FUND_ID = X_FUND_ID;
44: --
45: hr_utility.set_location('pywcdcr.insert_row', 4);
46: --
47: IF (SQL%NOTFOUND) THEN
48: RAISE NO_DATA_FOUND;
49: END IF;

Line 65: hr_utility.set_location('pywcdcr.update_row', 0);

61: X_CALCULATION_METHOD VARCHAR2,
62: X_CALCULATION_METHOD2 VARCHAR2,
63: X_CALCULATION_METHOD3 VARCHAR2) IS
64: BEGIN
65: hr_utility.set_location('pywcdcr.update_row', 0);
66: --
67: UPDATE PAY_WC_FUNDS
68: SET FUND_ID = X_FUND_ID
69: , BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID

Line 78: hr_utility.set_location('pywcdcr.update_row', 1);

74: , CALCULATION_METHOD2 = X_CALCULATION_METHOD2
75: , CALCULATION_METHOD3 = X_CALCULATION_METHOD3
76: WHERE ROWID = X_ROWID;
77: --
78: hr_utility.set_location('pywcdcr.update_row', 1);
79: --
80: IF (SQL%NOTFOUND) THEN
81: RAISE NO_DATA_FOUND;
82: END IF;

Line 84: hr_utility.set_location('pywcdcr.update_row', 2);

80: IF (SQL%NOTFOUND) THEN
81: RAISE NO_DATA_FOUND;
82: END IF;
83: --
84: hr_utility.set_location('pywcdcr.update_row', 2);
85: --
86: END UPDATE_ROW;
87: --
88: --

Line 100: hr_utility.set_location('pywcdcr.delete_row', 0);

96: X_CALCULATION_METHOD VARCHAR2,
97: X_CALCULATION_METHOD2 VARCHAR2,
98: X_CALCULATION_METHOD3 VARCHAR2) IS
99: BEGIN
100: hr_utility.set_location('pywcdcr.delete_row', 0);
101: --
102: DELETE FROM PAY_WC_FUNDS
103: WHERE ROWID = X_ROWID;
104: --

Line 105: hr_utility.set_location('pywcdcr.delete_row', 1);

101: --
102: DELETE FROM PAY_WC_FUNDS
103: WHERE ROWID = X_ROWID;
104: --
105: hr_utility.set_location('pywcdcr.delete_row', 1);
106: --
107: IF (SQL%NOTFOUND) THEN
108: RAISE NO_DATA_FOUND;
109: END IF;

Line 111: hr_utility.set_location('pywcdcr.delete_row', 2);

107: IF (SQL%NOTFOUND) THEN
108: RAISE NO_DATA_FOUND;
109: END IF;
110: --
111: hr_utility.set_location('pywcdcr.delete_row', 2);
112: --
113: END DELETE_ROW;
114: --
115: --

Line 137: hr_utility.set_location('pywcdcr.lock_row', 0);

133: RECINFO C%ROWTYPE;
134: --
135: BEGIN
136:
137: hr_utility.set_location('pywcdcr.lock_row', 0);
138: --
139: OPEN C;
140: FETCH C INTO RECINFO;
141: IF (C%NOTFOUND) THEN

Line 147: hr_utility.set_location('pywcdcr.lock_row', 1);

143: RAISE NO_DATA_FOUND;
144: END IF;
145: CLOSE C;
146: --
147: hr_utility.set_location('pywcdcr.lock_row', 1);
148: --
149: --
150: -- rtrim char fields
151: --

Line 154: hr_utility.set_location('pywcdcr.lock_row', 2);

150: -- rtrim char fields
151: --
152: Recinfo.state_code := RTRIM(Recinfo.state_code);
153: --
154: hr_utility.set_location('pywcdcr.lock_row', 2);
155: --
156: IF( ( ( RECINFO.FUND_ID = X_FUND_ID)
157: OR ( RECINFO.FUND_ID IS NULL AND X_FUND_ID IS NULL))
158: AND

Line 181: hr_utility.set_location('pywcdcr.lock_row', 3);

177: ( ( RECINFO.CALCULATION_METHOD3 = X_CALCULATION_METHOD3)
178: OR ( RECINFO.CALCULATION_METHOD3 IS NULL AND X_CALCULATION_METHOD3 IS NULL))
179: ) THEN
180: --
181: hr_utility.set_location('pywcdcr.lock_row', 3);
182: --
183: RETURN;
184: ELSE
185: --

Line 186: hr_utility.set_location('pywcdcr.lock_row', 4);

182: --
183: RETURN;
184: ELSE
185: --
186: hr_utility.set_location('pywcdcr.lock_row', 4);
187: --
188: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');
189: hr_utility.raise_error;
190: END IF;

Line 188: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');

184: ELSE
185: --
186: hr_utility.set_location('pywcdcr.lock_row', 4);
187: --
188: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');
189: hr_utility.raise_error;
190: END IF;
191: --
192: END LOCK_ROW;

Line 189: hr_utility.raise_error;

185: --
186: hr_utility.set_location('pywcdcr.lock_row', 4);
187: --
188: hr_utility.set_message(0, 'FORM_RECORD_CHANGED');
189: hr_utility.raise_error;
190: END IF;
191: --
192: END LOCK_ROW;
193: --

Line 220: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 0);

216: --
217: --
218: BEGIN
219: --
220: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 0);
221: --
222: --
223: -- initialise variable
224: l_comb_exists := 'N';

Line 233: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 1);

229: OPEN DUP_REC;
230: FETCH DUP_REC INTO l_comb_exists;
231: CLOSE DUP_REC;
232: --
233: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 1);
234: --
235: -- go ahead and check the value of the local variable - if it's 'Y' then this
236: -- record is duplicated
237: --

Line 240: hr_utility.set_message(801, 'HR_13104_WC_FUND_STATE_LOC_DUP');

236: -- record is duplicated
237: --
238: IF (l_comb_exists = 'Y')
239: THEN
240: hr_utility.set_message(801, 'HR_13104_WC_FUND_STATE_LOC_DUP');
241: hr_utility.raise_error;
242: END IF;
243: --
244: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 2);

Line 241: hr_utility.raise_error;

237: --
238: IF (l_comb_exists = 'Y')
239: THEN
240: hr_utility.set_message(801, 'HR_13104_WC_FUND_STATE_LOC_DUP');
241: hr_utility.raise_error;
242: END IF;
243: --
244: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 2);
245: --

Line 244: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 2);

240: hr_utility.set_message(801, 'HR_13104_WC_FUND_STATE_LOC_DUP');
241: hr_utility.raise_error;
242: END IF;
243: --
244: hr_utility.set_location('pywcdcr.carrier_state_loc_unique', 2);
245: --
246: --
247: END CARRIER_STATE_LOC_UNIQUE;
248: --

Line 270: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 0);

266: --
267: --
268: BEGIN
269: --
270: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 0);
271: --
272: -- initialise variable
273: l_comb_exists := 'N';
274: --

Line 282: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 1);

278: OPEN DUP_REC;
279: FETCH DUP_REC INTO l_comb_exists;
280: CLOSE DUP_REC;
281: --
282: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 1);
283: --
284: -- go ahead and check the value of the local variable - if it's 'Y' then this
285: -- record is duplicated
286: --

Line 289: hr_utility.set_message(801, 'HR_13105_WC_DUP_WC_CODE');

285: -- record is duplicated
286: --
287: IF (l_comb_exists = 'Y')
288: THEN
289: hr_utility.set_message(801, 'HR_13105_WC_DUP_WC_CODE');
290: hr_utility.raise_error;
291: END IF;
292: --
293: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 2);

Line 290: hr_utility.raise_error;

286: --
287: IF (l_comb_exists = 'Y')
288: THEN
289: hr_utility.set_message(801, 'HR_13105_WC_DUP_WC_CODE');
290: hr_utility.raise_error;
291: END IF;
292: --
293: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 2);
294: --

Line 293: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 2);

289: hr_utility.set_message(801, 'HR_13105_WC_DUP_WC_CODE');
290: hr_utility.raise_error;
291: END IF;
292: --
293: hr_utility.set_location('pywcdcr.fund_wc_code_unique', 2);
294: --
295: --
296: END FUND_WC_CODE_UNIQUE;
297: --

Line 312: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 0);

308: --
309: --
310: BEGIN
311: --
312: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 0);
313: --
314: -- initialise variable
315: l_rec_exists := 'N';
316: --

Line 324: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 1);

320: OPEN REC_EXISTS;
321: FETCH REC_EXISTS INTO l_rec_exists;
322: CLOSE REC_EXISTS;
323: --
324: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 1);
325: --
326: -- go ahead and check the value of the local variable - if it's 'Y' then this
327: -- record is duplicated
328: --

Line 331: hr_utility.set_message(801, 'HR_13106_WC_CODES_RATES_EXIST');

327: -- record is duplicated
328: --
329: IF (l_rec_exists = 'Y')
330: THEN
331: hr_utility.set_message(801, 'HR_13106_WC_CODES_RATES_EXIST');
332: hr_utility.raise_error;
333: END IF;
334: --
335: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 2);

Line 332: hr_utility.raise_error;

328: --
329: IF (l_rec_exists = 'Y')
330: THEN
331: hr_utility.set_message(801, 'HR_13106_WC_CODES_RATES_EXIST');
332: hr_utility.raise_error;
333: END IF;
334: --
335: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 2);
336: --

Line 335: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 2);

331: hr_utility.set_message(801, 'HR_13106_WC_CODES_RATES_EXIST');
332: hr_utility.raise_error;
333: END IF;
334: --
335: hr_utility.set_location('pywcdcr.codes_and_rates_exist', 2);
336: --
337: --
338: END CODES_AND_RATES_EXIST;
339: --

Line 504: hr_utility.set_location('pywcdcr.code_in_use', 0);

500: AND P_LOCATION_ID IS NOT NULL)));
501: --
502: --
503: BEGIN
504: hr_utility.set_location('pywcdcr.code_in_use', 0);
505: --
506: -- initialise variable
507: --
508: l_rec_exists := 'N';

Line 517: hr_utility.set_location('pywcdcr.code_in_use', 1);

513: OPEN SAME_CODE_EXISTS;
514: FETCH SAME_CODE_EXISTS INTO l_rec_exists;
515: CLOSE SAME_CODE_EXISTS;
516: --
517: hr_utility.set_location('pywcdcr.code_in_use', 1);
518: --
519: -- go ahead and check the value of the local variable - if it's 'Y' then
520: -- another fund is using this code; so we can just go ahead and do the delete
521: --

Line 524: hr_utility.set_location('pywcdcr.code_in_use', 2);

520: -- another fund is using this code; so we can just go ahead and do the delete
521: --
522: IF (l_rec_exists = 'Y') THEN
523: --
524: hr_utility.set_location('pywcdcr.code_in_use', 2);
525: --
526: -- re-initialise variable
527: --
528: l_rec_exists := 'N';

Line 537: hr_utility.set_location('pywcdcr.code_in_use', 3);

533: OPEN MANY_CODES_AND_OVERRIDES_EXIST;
534: FETCH MANY_CODES_AND_OVERRIDES_EXIST INTO l_rec_exists;
535: CLOSE MANY_CODES_AND_OVERRIDES_EXIST;
536: --
537: hr_utility.set_location('pywcdcr.code_in_use', 3);
538: --
539: -- if a record exists then raise error and tell user that the code is
540: -- in use
541: --

Line 544: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');

540: -- in use
541: --
542: IF (l_rec_exists = 'Y')
543: THEN
544: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');
545: hr_utility.raise_error;
546: END IF;
547: hr_utility.set_location('pywcdcr.code_in_use', 4);
548: --

Line 545: hr_utility.raise_error;

541: --
542: IF (l_rec_exists = 'Y')
543: THEN
544: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');
545: hr_utility.raise_error;
546: END IF;
547: hr_utility.set_location('pywcdcr.code_in_use', 4);
548: --
549: ELSE

Line 547: hr_utility.set_location('pywcdcr.code_in_use', 4);

543: THEN
544: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');
545: hr_utility.raise_error;
546: END IF;
547: hr_utility.set_location('pywcdcr.code_in_use', 4);
548: --
549: ELSE
550: --
551: hr_utility.set_location('pywcdcr.code_in_use', 5);

Line 551: hr_utility.set_location('pywcdcr.code_in_use', 5);

547: hr_utility.set_location('pywcdcr.code_in_use', 4);
548: --
549: ELSE
550: --
551: hr_utility.set_location('pywcdcr.code_in_use', 5);
552: --
553: -- this WC code is not defined for this state anywhere else; check to see
554: -- if this WC code is associated with any jobs
555: --

Line 567: hr_utility.set_location('pywcdcr.code_in_use', 6);

563: OPEN CODE_USED_BY_JOB;
564: FETCH CODE_USED_BY_JOB INTO l_rec_exists;
565: CLOSE CODE_USED_BY_JOB;
566: --
567: hr_utility.set_location('pywcdcr.code_in_use', 6);
568: --
569: -- if a record exists then raise error and tell user that the code is
570: -- in use
571: --

Line 574: hr_utility.set_message(801, 'HR_13128_WC_CODE_USED_BY_JOB');

570: -- in use
571: --
572: IF (l_rec_exists = 'Y')
573: THEN
574: hr_utility.set_message(801, 'HR_13128_WC_CODE_USED_BY_JOB');
575: hr_utility.raise_error;
576: END IF;
577: --
578: hr_utility.set_location('pywcdcr.code_in_use', 7);

Line 575: hr_utility.raise_error;

571: --
572: IF (l_rec_exists = 'Y')
573: THEN
574: hr_utility.set_message(801, 'HR_13128_WC_CODE_USED_BY_JOB');
575: hr_utility.raise_error;
576: END IF;
577: --
578: hr_utility.set_location('pywcdcr.code_in_use', 7);
579: --

Line 578: hr_utility.set_location('pywcdcr.code_in_use', 7);

574: hr_utility.set_message(801, 'HR_13128_WC_CODE_USED_BY_JOB');
575: hr_utility.raise_error;
576: END IF;
577: --
578: hr_utility.set_location('pywcdcr.code_in_use', 7);
579: --
580: --
581: -- if we've got this far then we need to see if this code is being used
582: -- as an override on the assignment SCL!!!

Line 595: hr_utility.set_location('pywcdcr.code_in_use', 8);

591: OPEN ONE_CODE_AND_OVERRIDES_EXIST;
592: FETCH ONE_CODE_AND_OVERRIDES_EXIST INTO l_rec_exists;
593: CLOSE ONE_CODE_AND_OVERRIDES_EXIST;
594: --
595: hr_utility.set_location('pywcdcr.code_in_use', 8);
596: --
597: -- if a record exists then raise error and tell user that the code is
598: -- in use
599: --

Line 602: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');

598: -- in use
599: --
600: IF (l_rec_exists = 'Y')
601: THEN
602: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');
603: hr_utility.raise_error;
604: END IF;
605: --
606: hr_utility.set_location('pywcdcr.code_in_use', 9);

Line 603: hr_utility.raise_error;

599: --
600: IF (l_rec_exists = 'Y')
601: THEN
602: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');
603: hr_utility.raise_error;
604: END IF;
605: --
606: hr_utility.set_location('pywcdcr.code_in_use', 9);
607: --

Line 606: hr_utility.set_location('pywcdcr.code_in_use', 9);

602: hr_utility.set_message(801, 'HR_13129_WC_CODE_IS_OVERRIDE');
603: hr_utility.raise_error;
604: END IF;
605: --
606: hr_utility.set_location('pywcdcr.code_in_use', 9);
607: --
608: END IF;
609: --
610: hr_utility.set_location('pywcdcr.code_in_use', 10);

Line 610: hr_utility.set_location('pywcdcr.code_in_use', 10);

606: hr_utility.set_location('pywcdcr.code_in_use', 9);
607: --
608: END IF;
609: --
610: hr_utility.set_location('pywcdcr.code_in_use', 10);
611: --
612: END CODE_IN_USE;
613: --
614: --