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_EVENTS_PKG dependencies on HR_UTILITY

Line 70: HR_UTILITY.SET_MESSAGE('801','HR_6627_EVENTS_ORG_NOT_VAL');

66: OPEN CH2;
67: FETCH CH2 INTO L_TEMP2;
68: IF CH2%NOTFOUND THEN
69: CLOSE CH2;
70: HR_UTILITY.SET_MESSAGE('801','HR_6627_EVENTS_ORG_NOT_VAL');
71: HR_UTILITY.RAISE_ERROR;
72: END IF;
73: CLOSE CH2;
74: END IF;

Line 71: HR_UTILITY.RAISE_ERROR;

67: FETCH CH2 INTO L_TEMP2;
68: IF CH2%NOTFOUND THEN
69: CLOSE CH2;
70: HR_UTILITY.SET_MESSAGE('801','HR_6627_EVENTS_ORG_NOT_VAL');
71: HR_UTILITY.RAISE_ERROR;
72: END IF;
73: CLOSE CH2;
74: END IF;
75: IF X_LOCATION_ID IS NOT NULL THEN

Line 80: HR_UTILITY.SET_MESSAGE('801','HR_6628_EVENTS_LOC_NOT_VAL');

76: OPEN CH3;
77: FETCH CH3 INTO L_TEMP3;
78: IF CH3%NOTFOUND THEN
79: CLOSE CH3;
80: HR_UTILITY.SET_MESSAGE('801','HR_6628_EVENTS_LOC_NOT_VAL');
81: HR_UTILITY.RAISE_ERROR;
82: END IF;
83: CLOSE CH3;
84: END IF;

Line 81: HR_UTILITY.RAISE_ERROR;

77: FETCH CH3 INTO L_TEMP3;
78: IF CH3%NOTFOUND THEN
79: CLOSE CH3;
80: HR_UTILITY.SET_MESSAGE('801','HR_6628_EVENTS_LOC_NOT_VAL');
81: HR_UTILITY.RAISE_ERROR;
82: END IF;
83: CLOSE CH3;
84: END IF;
85: IF X_INTERNAL_CONTACT_PERSON_ID IS NOT NULL THEN

Line 90: HR_UTILITY.SET_MESSAGE('801','HR_6660_EVENTS_INVAL_PERSON');

86: OPEN CH1;
87: FETCH CH1 INTO L_TEMP1;
88: IF CH1%NOTFOUND THEN
89: CLOSE CH1;
90: HR_UTILITY.SET_MESSAGE('801','HR_6660_EVENTS_INVAL_PERSON');
91: HR_UTILITY.RAISE_ERROR;
92: END IF;
93: CLOSE CH1;
94: END IF;

Line 91: HR_UTILITY.RAISE_ERROR;

87: FETCH CH1 INTO L_TEMP1;
88: IF CH1%NOTFOUND THEN
89: CLOSE CH1;
90: HR_UTILITY.SET_MESSAGE('801','HR_6660_EVENTS_INVAL_PERSON');
91: HR_UTILITY.RAISE_ERROR;
92: END IF;
93: CLOSE CH1;
94: END IF;
95:

Line 104: HR_UTILITY.SET_MESSAGE('801','HR_6656_EVENTS_PERSON_INVALID');

100: OPEN CH5;
101: FETCH CH5 INTO L_TEMP5;
102: IF CH5%NOTFOUND THEN
103: CLOSE CH5;
104: HR_UTILITY.SET_MESSAGE('801','HR_6656_EVENTS_PERSON_INVALID');
105: HR_UTILITY.RAISE_ERROR;
106: ELSE
107: CLOSE CH5;
108: END IF;

Line 105: HR_UTILITY.RAISE_ERROR;

101: FETCH CH5 INTO L_TEMP5;
102: IF CH5%NOTFOUND THEN
103: CLOSE CH5;
104: HR_UTILITY.SET_MESSAGE('801','HR_6656_EVENTS_PERSON_INVALID');
105: HR_UTILITY.RAISE_ERROR;
106: ELSE
107: CLOSE CH5;
108: END IF;
109: ELSE

Line 135: hr_utility.set_location ('per_events_pkg.event_causes_assignment_change',1);

131: and effective_start_date = p_event_date;
132: --
133: begin
134: --
135: hr_utility.set_location ('per_events_pkg.event_causes_assignment_change',1);
136: --
137: open csr_assignment;
138: fetch csr_assignment into g_dummy;
139: v_change_exists := csr_assignment%found;

Line 181: hr_utility.set_location ('per_events_pkg.interview_double_booked',1);

177: event.date_start);
178: --
179: begin
180: --
181: hr_utility.set_location ('per_events_pkg.interview_double_booked',1);
182: --
183: open csr_double_booking;
184: fetch csr_double_booking into l_time_start, l_time_end;
185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);

Line 185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);

181: hr_utility.set_location ('per_events_pkg.interview_double_booked',1);
182: --
183: open csr_double_booking;
184: fetch csr_double_booking into l_time_start, l_time_end;
185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);
186: v_interview_double_booked := csr_double_booking%found;
187: close csr_double_booking;
188: --
189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);

Line 189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);

185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);
186: v_interview_double_booked := csr_double_booking%found;
187: close csr_double_booking;
188: --
189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);
190: l_same_time := v_interview_double_booked;
191: if v_interview_double_booked and p_time_start is not null and l_time_start is not null then
192: hr_utility.set_location ('per_events_pkg.interview_double_booked',4);
193: --

Line 192: hr_utility.set_location ('per_events_pkg.interview_double_booked',4);

188: --
189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);
190: l_same_time := v_interview_double_booked;
191: if v_interview_double_booked and p_time_start is not null and l_time_start is not null then
192: hr_utility.set_location ('per_events_pkg.interview_double_booked',4);
193: --
194: -- If interview has start time entered then compare on basis ofstart and end time.
195: -- The following code checks for the time overlap.
196: --

Line 216: hr_utility.set_location ('per_events_pkg.interview_double_booked',5);

212: ( (substr(p_time_end,1,2) * 60) + substr(p_time_end,4,2))
213: )
214: ) ;
215: --
216: hr_utility.set_location ('per_events_pkg.interview_double_booked',5);
217:
218: end if;
219: hr_utility.set_location ('per_events_pkg.interview_double_booked',99);
220: --

Line 219: hr_utility.set_location ('per_events_pkg.interview_double_booked',99);

215: --
216: hr_utility.set_location ('per_events_pkg.interview_double_booked',5);
217:
218: end if;
219: hr_utility.set_location ('per_events_pkg.interview_double_booked',99);
220: --
221: return l_same_time;
222: --
223: end interview_double_booked;

Line 246: hr_utility.set_location ('per_events_pkg.interviewers_are_booked',1);

242: v_booking_exists boolean := FALSE;
243: --
244: begin
245: --
246: hr_utility.set_location ('per_events_pkg.interviewers_are_booked',1);
247: --
248: open csr_booking;
249: fetch csr_booking into g_dummy;
250: v_booking_exists := csr_booking%found;

Line 254: hr_utility.set_message (801,'PER_7517_APP_INT_DELETE');

250: v_booking_exists := csr_booking%found;
251: close csr_booking;
252: --
253: if v_booking_exists and p_error_if_true then
254: hr_utility.set_message (801,'PER_7517_APP_INT_DELETE');
255: hr_utility.raise_error;
256: end if;
257: --
258: return v_booking_exists;

Line 255: hr_utility.raise_error;

251: close csr_booking;
252: --
253: if v_booking_exists and p_error_if_true then
254: hr_utility.set_message (801,'PER_7517_APP_INT_DELETE');
255: hr_utility.raise_error;
256: end if;
257: --
258: return v_booking_exists;
259: --

Line 305: hr_utility.set_location ('Entering per_events_pkg.check_current_interviewers',1);

301: l_dummy varchar2(1);
302: --
303: begin
304: --
305: hr_utility.set_location ('Entering per_events_pkg.check_current_interviewers',1);
306: --
307: for interview in csr_interview LOOP
308: -- bug fix 2708777 starts here.
309: open csr_person_exists(interview.person_id);

Line 316: hr_utility.set_message (801,'HR_6752_EVENTS_DATE_INVALID');

312: if csr_person_exists%notfound then
313:
314: close csr_person_exists;
315: -- bug fix 2708777 ends here.
316: hr_utility.set_message (801,'HR_6752_EVENTS_DATE_INVALID');
317: hr_utility.raise_error;
318: --
319: end if;
320: --

Line 317: hr_utility.raise_error;

313:
314: close csr_person_exists;
315: -- bug fix 2708777 ends here.
316: hr_utility.set_message (801,'HR_6752_EVENTS_DATE_INVALID');
317: hr_utility.raise_error;
318: --
319: end if;
320: --
321: close csr_person_exists;

Line 325: hr_utility.set_location ('Leaving per_events_pkg.check_current_interviewers',2);

321: close csr_person_exists;
322: --
323: end loop;
324: --
325: hr_utility.set_location ('Leaving per_events_pkg.check_current_interviewers',2);
326: --
327: end check_current_interviewers;
328: --------------------------------------------------------------------------------
329: procedure REQUEST_LETTER (

Line 375: hr_utility.set_location ('per_events_pkg.request_letter', 1);

371: --fix for bug 7019343 ends here.
372:
373: begin
374: --
375: hr_utility.set_location ('per_events_pkg.request_letter', 1);
376: --
377: open csr_check_letter;
378: fetch csr_check_letter into g_dummy;
379: if csr_check_letter%notfound then

Line 400: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);

396: close csr_check_manual_or_auto;
397:
398: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then
399:
400: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
401: insert into per_letter_requests
402: ( letter_request_id
403: , business_group_id
404: , letter_type_id

Line 679: HR_UTILITY.SET_MESSAGE('801','HR_6747_EVENTS_LOC_INACTIVE');

675: OPEN LOCATION_CHECK;
676: FETCH LOCATION_CHECK INTO L_DUMMY;
677: IF LOCATION_CHECK%NOTFOUND THEN
678: CLOSE LOCATION_CHECK;
679: HR_UTILITY.SET_MESSAGE('801','HR_6747_EVENTS_LOC_INACTIVE');
680: HR_UTILITY.RAISE_ERROR;
681: ELSE
682: CLOSE LOCATION_CHECK;
683: END IF;

Line 680: HR_UTILITY.RAISE_ERROR;

676: FETCH LOCATION_CHECK INTO L_DUMMY;
677: IF LOCATION_CHECK%NOTFOUND THEN
678: CLOSE LOCATION_CHECK;
679: HR_UTILITY.SET_MESSAGE('801','HR_6747_EVENTS_LOC_INACTIVE');
680: HR_UTILITY.RAISE_ERROR;
681: ELSE
682: CLOSE LOCATION_CHECK;
683: END IF;
684: END IF;

Line 781: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

777: OPEN C;
778: FETCH C INTO X_Rowid;
779: if (C%NOTFOUND) then
780: CLOSE C;
781: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
782: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');
783: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
784: HR_UTILITY.RAISE_ERROR;
785: end if;

Line 782: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');

778: FETCH C INTO X_Rowid;
779: if (C%NOTFOUND) then
780: CLOSE C;
781: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
782: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');
783: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
784: HR_UTILITY.RAISE_ERROR;
785: end if;
786: CLOSE C;

Line 783: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

779: if (C%NOTFOUND) then
780: CLOSE C;
781: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
782: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');
783: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
784: HR_UTILITY.RAISE_ERROR;
785: end if;
786: CLOSE C;
787: END Insert_Row;

Line 784: HR_UTILITY.RAISE_ERROR;

780: CLOSE C;
781: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
782: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');
783: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
784: HR_UTILITY.RAISE_ERROR;
785: end if;
786: CLOSE C;
787: END Insert_Row;
788: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 839: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

835: OPEN C;
836: FETCH C INTO Recinfo;
837: if (C%NOTFOUND) then
838: CLOSE C;
839: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
840: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
841: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
842: HR_UTILITY.RAISE_ERROR;
843: end if;

Line 840: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');

836: FETCH C INTO Recinfo;
837: if (C%NOTFOUND) then
838: CLOSE C;
839: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
840: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
841: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
842: HR_UTILITY.RAISE_ERROR;
843: end if;
844: CLOSE C;

Line 841: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

837: if (C%NOTFOUND) then
838: CLOSE C;
839: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
840: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
841: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
842: HR_UTILITY.RAISE_ERROR;
843: end if;
844: CLOSE C;
845: Recinfo.attribute19 := rtrim(Recinfo.attribute19);

Line 842: HR_UTILITY.RAISE_ERROR;

838: CLOSE C;
839: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
840: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
841: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
842: HR_UTILITY.RAISE_ERROR;
843: end if;
844: CLOSE C;
845: Recinfo.attribute19 := rtrim(Recinfo.attribute19);
846: Recinfo.attribute20 := rtrim(Recinfo.attribute20);

Line 1067: HR_UTILITY.SET_MESSAGE('801','HR_6747_EVENTS_LOC_INACTIVE');

1063: OPEN LOCATION_CHECK;
1064: FETCH LOCATION_CHECK INTO L_DUMMY;
1065: IF LOCATION_CHECK%NOTFOUND THEN
1066: CLOSE LOCATION_CHECK;
1067: HR_UTILITY.SET_MESSAGE('801','HR_6747_EVENTS_LOC_INACTIVE');
1068: HR_UTILITY.RAISE_ERROR;
1069: ELSE
1070: CLOSE LOCATION_CHECK;
1071: END IF;

Line 1068: HR_UTILITY.RAISE_ERROR;

1064: FETCH LOCATION_CHECK INTO L_DUMMY;
1065: IF LOCATION_CHECK%NOTFOUND THEN
1066: CLOSE LOCATION_CHECK;
1067: HR_UTILITY.SET_MESSAGE('801','HR_6747_EVENTS_LOC_INACTIVE');
1068: HR_UTILITY.RAISE_ERROR;
1069: ELSE
1070: CLOSE LOCATION_CHECK;
1071: END IF;
1072: END IF;

Line 1118: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

1114: attribute20 = X_Attribute20
1115: WHERE rowid = X_rowid;
1116:
1117: if (SQL%NOTFOUND) then
1118: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1119: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
1120: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1121: HR_UTILITY.RAISE_ERROR;
1122: end if;

Line 1119: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');

1115: WHERE rowid = X_rowid;
1116:
1117: if (SQL%NOTFOUND) then
1118: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1119: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
1120: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1121: HR_UTILITY.RAISE_ERROR;
1122: end if;
1123:

Line 1120: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

1116:
1117: if (SQL%NOTFOUND) then
1118: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1119: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
1120: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1121: HR_UTILITY.RAISE_ERROR;
1122: end if;
1123:
1124: END Update_Row;

Line 1121: HR_UTILITY.RAISE_ERROR;

1117: if (SQL%NOTFOUND) then
1118: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1119: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
1120: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1121: HR_UTILITY.RAISE_ERROR;
1122: end if;
1123:
1124: END Update_Row;
1125:

Line 1157: HR_UTILITY.SET_MESSAGE('801',X_Message);

1153: OPEN CHILD_CHECK;
1154: FETCH CHILD_CHECK INTO L_DUMMY;
1155: IF CHILD_CHECK%FOUND THEN
1156: CLOSE CHILD_CHECK;
1157: HR_UTILITY.SET_MESSAGE('801',X_Message);
1158: HR_UTILITY.RAISE_ERROR;
1159: ELSE
1160: CLOSE CHILD_CHECK;
1161: END IF;

Line 1158: HR_UTILITY.RAISE_ERROR;

1154: FETCH CHILD_CHECK INTO L_DUMMY;
1155: IF CHILD_CHECK%FOUND THEN
1156: CLOSE CHILD_CHECK;
1157: HR_UTILITY.SET_MESSAGE('801',X_Message);
1158: HR_UTILITY.RAISE_ERROR;
1159: ELSE
1160: CLOSE CHILD_CHECK;
1161: END IF;
1162:

Line 1170: HR_UTILITY.SET_MESSAGE('801','HR_7100_EVENTS_CHANGE_EXIST');

1166: OPEN PAY_CHANGE_CHECK;
1167: FETCH PAY_CHANGE_CHECK INTO L_DUMMY2;
1168: IF PAY_CHANGE_CHECK%FOUND THEN
1169: CLOSE PAY_CHANGE_CHECK;
1170: HR_UTILITY.SET_MESSAGE('801','HR_7100_EVENTS_CHANGE_EXIST');
1171: HR_UTILITY.RAISE_ERROR;
1172: ELSE
1173: CLOSE PAY_CHANGE_CHECK;
1174: END IF;

Line 1171: HR_UTILITY.RAISE_ERROR;

1167: FETCH PAY_CHANGE_CHECK INTO L_DUMMY2;
1168: IF PAY_CHANGE_CHECK%FOUND THEN
1169: CLOSE PAY_CHANGE_CHECK;
1170: HR_UTILITY.SET_MESSAGE('801','HR_7100_EVENTS_CHANGE_EXIST');
1171: HR_UTILITY.RAISE_ERROR;
1172: ELSE
1173: CLOSE PAY_CHANGE_CHECK;
1174: END IF;
1175: END IF;

Line 1181: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

1177: DELETE FROM PER_EVENTS
1178: WHERE rowid = X_Rowid;
1179:
1180: if (SQL%NOTFOUND) then
1181: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1182: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
1183: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1184: HR_UTILITY.RAISE_ERROR;
1185: end if;

Line 1182: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');

1178: WHERE rowid = X_Rowid;
1179:
1180: if (SQL%NOTFOUND) then
1181: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1182: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
1183: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1184: HR_UTILITY.RAISE_ERROR;
1185: end if;
1186: END Delete_Row;

Line 1183: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

1179:
1180: if (SQL%NOTFOUND) then
1181: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1182: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
1183: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1184: HR_UTILITY.RAISE_ERROR;
1185: end if;
1186: END Delete_Row;
1187:

Line 1184: HR_UTILITY.RAISE_ERROR;

1180: if (SQL%NOTFOUND) then
1181: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
1182: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
1183: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
1184: HR_UTILITY.RAISE_ERROR;
1185: end if;
1186: END Delete_Row;
1187:
1188: END PER_EVENTS_PKG;