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

Line 40: hr_utility.set_message(801,'HR_6163_SETUP_DUP');

36: v_not_unique := csr_user_name%FOUND;
37: close csr_user_name;
38: --
39: if v_not_unique then
40: hr_utility.set_message(801,'HR_6163_SETUP_DUP');
41: hr_utility.raise_error;
42: end if;
43: --
44: end check_duplicate_name;

Line 41: hr_utility.raise_error;

37: close csr_user_name;
38: --
39: if v_not_unique then
40: hr_utility.set_message(801,'HR_6163_SETUP_DUP');
41: hr_utility.raise_error;
42: end if;
43: --
44: end check_duplicate_name;
45: --

Line 70: hr_utility.set_location('BG id '||to_char(p_business_group_Id),1);

66: dummy_number number;
67: not_unique boolean := FALSE;
68:
69: begin
70: hr_utility.set_location('BG id '||to_char(p_business_group_Id),1);
71: hr_utility.set_location('system name '||p_system_name,2);
72: hr_utility.set_location('default flag'||p_default_flag,3);
73: hr_utility.set_location('row id'||p_rowid,4);
74:

Line 71: hr_utility.set_location('system name '||p_system_name,2);

67: not_unique boolean := FALSE;
68:
69: begin
70: hr_utility.set_location('BG id '||to_char(p_business_group_Id),1);
71: hr_utility.set_location('system name '||p_system_name,2);
72: hr_utility.set_location('default flag'||p_default_flag,3);
73: hr_utility.set_location('row id'||p_rowid,4);
74:
75: open csr_system_name;

Line 72: hr_utility.set_location('default flag'||p_default_flag,3);

68:
69: begin
70: hr_utility.set_location('BG id '||to_char(p_business_group_Id),1);
71: hr_utility.set_location('system name '||p_system_name,2);
72: hr_utility.set_location('default flag'||p_default_flag,3);
73: hr_utility.set_location('row id'||p_rowid,4);
74:
75: open csr_system_name;
76: fetch csr_system_name into dummy_number;

Line 73: hr_utility.set_location('row id'||p_rowid,4);

69: begin
70: hr_utility.set_location('BG id '||to_char(p_business_group_Id),1);
71: hr_utility.set_location('system name '||p_system_name,2);
72: hr_utility.set_location('default flag'||p_default_flag,3);
73: hr_utility.set_location('row id'||p_rowid,4);
74:
75: open csr_system_name;
76: fetch csr_system_name into dummy_number;
77: not_unique := csr_system_name%FOUND;

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

77: not_unique := csr_system_name%FOUND;
78: close csr_system_name;
79:
80: if not_unique then
81: hr_utility.set_message (800,'HR_52775_SYS_PRIM_DEFAULT');
82: hr_utility.raise_error;
83: end if;
84:
85: end check_duplicate_system_name;

Line 82: hr_utility.raise_error;

78: close csr_system_name;
79:
80: if not_unique then
81: hr_utility.set_message (800,'HR_52775_SYS_PRIM_DEFAULT');
82: hr_utility.raise_error;
83: end if;
84:
85: end check_duplicate_system_name;
86: --

Line 157: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

153: --
154: OPEN C;
155: FETCH C INTO X_Rowid;
156: if (SQL%NOTFOUND) then
157: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
158: hr_utility.set_message_token('PROCEDURE','Insert_Row');
159: hr_utility.set_message_token('STEP','1');
160: hr_utility.raise_error;
161: end if;

Line 158: hr_utility.set_message_token('PROCEDURE','Insert_Row');

154: OPEN C;
155: FETCH C INTO X_Rowid;
156: if (SQL%NOTFOUND) then
157: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
158: hr_utility.set_message_token('PROCEDURE','Insert_Row');
159: hr_utility.set_message_token('STEP','1');
160: hr_utility.raise_error;
161: end if;
162: CLOSE C;

Line 159: hr_utility.set_message_token('STEP','1');

155: FETCH C INTO X_Rowid;
156: if (SQL%NOTFOUND) then
157: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
158: hr_utility.set_message_token('PROCEDURE','Insert_Row');
159: hr_utility.set_message_token('STEP','1');
160: hr_utility.raise_error;
161: end if;
162: CLOSE C;
163: END Insert_Row;

Line 160: hr_utility.raise_error;

156: if (SQL%NOTFOUND) then
157: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
158: hr_utility.set_message_token('PROCEDURE','Insert_Row');
159: hr_utility.set_message_token('STEP','1');
160: hr_utility.raise_error;
161: end if;
162: CLOSE C;
163: END Insert_Row;
164:

Line 200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

196: BEGIN
197: OPEN C;
198: FETCH C INTO Recinfo;
199: if (SQL%NOTFOUND) then
200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
201: hr_utility.set_message_token('PROCEDURE','Lock_Row');
202: hr_utility.set_message_token('STEP','1');
203: hr_utility.raise_error;
204: end if;

Line 201: hr_utility.set_message_token('PROCEDURE','Lock_Row');

197: OPEN C;
198: FETCH C INTO Recinfo;
199: if (SQL%NOTFOUND) then
200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
201: hr_utility.set_message_token('PROCEDURE','Lock_Row');
202: hr_utility.set_message_token('STEP','1');
203: hr_utility.raise_error;
204: end if;
205: CLOSE C;

Line 202: hr_utility.set_message_token('STEP','1');

198: FETCH C INTO Recinfo;
199: if (SQL%NOTFOUND) then
200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
201: hr_utility.set_message_token('PROCEDURE','Lock_Row');
202: hr_utility.set_message_token('STEP','1');
203: hr_utility.raise_error;
204: end if;
205: CLOSE C;
206: --

Line 203: hr_utility.raise_error;

199: if (SQL%NOTFOUND) then
200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
201: hr_utility.set_message_token('PROCEDURE','Lock_Row');
202: hr_utility.set_message_token('STEP','1');
203: hr_utility.raise_error;
204: end if;
205: CLOSE C;
206: --
207: Recinfo.active_flag := rtrim(Recinfo.active_flag);

Line 279: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

275: user_person_type = X_User_Person_Type
276: WHERE rowid = X_rowid;
277:
278: if (SQL%NOTFOUND) then
279: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
280: hr_utility.set_message_token('PROCEDURE','Update_Row');
281: hr_utility.set_message_token('STEP','1');
282: hr_utility.raise_error;
283: end if;

Line 280: hr_utility.set_message_token('PROCEDURE','Update_Row');

276: WHERE rowid = X_rowid;
277:
278: if (SQL%NOTFOUND) then
279: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
280: hr_utility.set_message_token('PROCEDURE','Update_Row');
281: hr_utility.set_message_token('STEP','1');
282: hr_utility.raise_error;
283: end if;
284:

Line 281: hr_utility.set_message_token('STEP','1');

277:
278: if (SQL%NOTFOUND) then
279: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
280: hr_utility.set_message_token('PROCEDURE','Update_Row');
281: hr_utility.set_message_token('STEP','1');
282: hr_utility.raise_error;
283: end if;
284:
285: -- MLS

Line 282: hr_utility.raise_error;

278: if (SQL%NOTFOUND) then
279: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
280: hr_utility.set_message_token('PROCEDURE','Update_Row');
281: hr_utility.set_message_token('STEP','1');
282: hr_utility.raise_error;
283: end if;
284:
285: -- MLS
286: update PER_PERSON_TYPES_TL set

Line 308: hr_utility.set_message(801,'HR_6618_PERSON_TYPE_NO_DEL_DEF');

304: X_Person_type_Id number) IS
305: BEGIN
306: --
307: if X_Default_flag = 'Y' then
308: hr_utility.set_message(801,'HR_6618_PERSON_TYPE_NO_DEL_DEF');
309: hr_utility.raise_error;
310: end if;
311: --
312: -- if the system name is in use then disallow the deletion

Line 309: hr_utility.raise_error;

305: BEGIN
306: --
307: if X_Default_flag = 'Y' then
308: hr_utility.set_message(801,'HR_6618_PERSON_TYPE_NO_DEL_DEF');
309: hr_utility.raise_error;
310: end if;
311: --
312: -- if the system name is in use then disallow the deletion
313: --

Line 329: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

325: DELETE FROM per_person_types
326: WHERE rowid = X_Rowid;
327:
328: if (SQL%NOTFOUND) then
329: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
330: hr_utility.set_message_token('PROCEDURE','Delete_Row');
331: hr_utility.set_message_token('STEP','1');
332: hr_utility.raise_error;
333: end if;

Line 330: hr_utility.set_message_token('PROCEDURE','Delete_Row');

326: WHERE rowid = X_Rowid;
327:
328: if (SQL%NOTFOUND) then
329: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
330: hr_utility.set_message_token('PROCEDURE','Delete_Row');
331: hr_utility.set_message_token('STEP','1');
332: hr_utility.raise_error;
333: end if;
334: END Delete_Row;

Line 331: hr_utility.set_message_token('STEP','1');

327:
328: if (SQL%NOTFOUND) then
329: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
330: hr_utility.set_message_token('PROCEDURE','Delete_Row');
331: hr_utility.set_message_token('STEP','1');
332: hr_utility.raise_error;
333: end if;
334: END Delete_Row;
335:

Line 332: hr_utility.raise_error;

328: if (SQL%NOTFOUND) then
329: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
330: hr_utility.set_message_token('PROCEDURE','Delete_Row');
331: hr_utility.set_message_token('STEP','1');
332: hr_utility.raise_error;
333: end if;
334: END Delete_Row;
335:
336: PROCEDURE Check_Delete (X_Business_Group_Id NUMBER) IS

Line 362: hr_utility.set_message(801,'HR_6318_SYS_PRIM_DEFAULT');

358: FETCH C INTO System_Name;
359: CLOSE C;
360:
361: if System_Name is not null then
362: hr_utility.set_message(801,'HR_6318_SYS_PRIM_DEFAULT');
363: hr_utility.set_message_token('SYSTEM_NAME',System_Name);
364: hr_utility.raise_error;
365: end if;
366:

Line 363: hr_utility.set_message_token('SYSTEM_NAME',System_Name);

359: CLOSE C;
360:
361: if System_Name is not null then
362: hr_utility.set_message(801,'HR_6318_SYS_PRIM_DEFAULT');
363: hr_utility.set_message_token('SYSTEM_NAME',System_Name);
364: hr_utility.raise_error;
365: end if;
366:
367: END Check_Delete;

Line 364: hr_utility.raise_error;

360:
361: if System_Name is not null then
362: hr_utility.set_message(801,'HR_6318_SYS_PRIM_DEFAULT');
363: hr_utility.set_message_token('SYSTEM_NAME',System_Name);
364: hr_utility.raise_error;
365: end if;
366:
367: END Check_Delete;
368:

Line 426: hr_utility.set_message(800,'HR_289007_SYS_PRIM_NODEFAULT');

422: FETCH csr_nodefault INTO l_system_name_nodefault;
423: CLOSE csr_nodefault;
424:
425: IF l_system_name_nodefault IS NOT NULL THEN
426: hr_utility.set_message(800,'HR_289007_SYS_PRIM_NODEFAULT');
427: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_nodefault);
428: hr_utility.raise_error;
429: END IF;
430:

Line 427: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_nodefault);

423: CLOSE csr_nodefault;
424:
425: IF l_system_name_nodefault IS NOT NULL THEN
426: hr_utility.set_message(800,'HR_289007_SYS_PRIM_NODEFAULT');
427: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_nodefault);
428: hr_utility.raise_error;
429: END IF;
430:
431: --

Line 428: hr_utility.raise_error;

424:
425: IF l_system_name_nodefault IS NOT NULL THEN
426: hr_utility.set_message(800,'HR_289007_SYS_PRIM_NODEFAULT');
427: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_nodefault);
428: hr_utility.raise_error;
429: END IF;
430:
431: --
432: -- Check to see if there are any system names with more than one default

Line 441: hr_utility.set_message(800,'HR_6318_SYS_PRIM_DEFAULT');

437: FETCH csr_default INTO l_system_name_default;
438: CLOSE csr_default;
439:
440: IF l_system_name_default IS NOT NULL THEN
441: hr_utility.set_message(800,'HR_6318_SYS_PRIM_DEFAULT');
442: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_default);
443: hr_utility.raise_error;
444: END IF;
445:

Line 442: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_default);

438: CLOSE csr_default;
439:
440: IF l_system_name_default IS NOT NULL THEN
441: hr_utility.set_message(800,'HR_6318_SYS_PRIM_DEFAULT');
442: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_default);
443: hr_utility.raise_error;
444: END IF;
445:
446: END Check_Default;

Line 443: hr_utility.raise_error;

439:
440: IF l_system_name_default IS NOT NULL THEN
441: hr_utility.set_message(800,'HR_6318_SYS_PRIM_DEFAULT');
442: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_default);
443: hr_utility.raise_error;
444: END IF;
445:
446: END Check_Default;
447:

Line 482: hr_utility.set_message(801,'HR_6619_PERSON_TYPE_EXISTS');

478: v_system_used := csr_system%FOUND;
479: close csr_system;
480: --
481: if v_system_used then
482: hr_utility.set_message(801,'HR_6619_PERSON_TYPE_EXISTS');
483: hr_utility.raise_error;
484: end if;
485: --
486: END Check_System_Delete;

Line 483: hr_utility.raise_error;

479: close csr_system;
480: --
481: if v_system_used then
482: hr_utility.set_message(801,'HR_6619_PERSON_TYPE_EXISTS');
483: hr_utility.raise_error;
484: end if;
485: --
486: END Check_System_Delete;
487: --

Line 523: hr_utility.set_message(800,'HR_7208_API_BUS_GRP_INVALID');

519: open csr_business_group(x_business_group_name);
520: fetch csr_business_group into l_business_group;
521: if csr_business_group%notfound then
522: close csr_business_group;
523: hr_utility.set_message(800,'HR_7208_API_BUS_GRP_INVALID');
524: hr_utility.raise_error;
525: end if;
526: close csr_business_group;
527: -- Insert or update as appropriate

Line 524: hr_utility.raise_error;

520: fetch csr_business_group into l_business_group;
521: if csr_business_group%notfound then
522: close csr_business_group;
523: hr_utility.set_message(800,'HR_7208_API_BUS_GRP_INVALID');
524: hr_utility.raise_error;
525: end if;
526: close csr_business_group;
527: -- Insert or update as appropriate
528: open csr_person_type(x_person_type,l_business_group.organization_id);

Line 703: hr_utility.set_location (l_package_name,10);

699: l_package_name VARCHAR2(80) := 'PER_PERSON_TYPES_PKG.VALIDATE_TRANSLATION';
700: l_business_group_id NUMBER := nvl(p_business_group_id, g_business_group_id);
701:
702: BEGIN
703: hr_utility.set_location (l_package_name,10);
704: OPEN c_translation(language, user_person_type,person_type_id,
705: l_business_group_id);
706: hr_utility.set_location (l_package_name,50);
707: FETCH c_translation INTO g_dummy;

Line 706: hr_utility.set_location (l_package_name,50);

702: BEGIN
703: hr_utility.set_location (l_package_name,10);
704: OPEN c_translation(language, user_person_type,person_type_id,
705: l_business_group_id);
706: hr_utility.set_location (l_package_name,50);
707: FETCH c_translation INTO g_dummy;
708:
709: IF c_translation%NOTFOUND THEN
710: hr_utility.set_location (l_package_name,60);

Line 710: hr_utility.set_location (l_package_name,60);

706: hr_utility.set_location (l_package_name,50);
707: FETCH c_translation INTO g_dummy;
708:
709: IF c_translation%NOTFOUND THEN
710: hr_utility.set_location (l_package_name,60);
711: CLOSE c_translation;
712: ELSE
713: hr_utility.set_location (l_package_name,70);
714: CLOSE c_translation;

Line 713: hr_utility.set_location (l_package_name,70);

709: IF c_translation%NOTFOUND THEN
710: hr_utility.set_location (l_package_name,60);
711: CLOSE c_translation;
712: ELSE
713: hr_utility.set_location (l_package_name,70);
714: CLOSE c_translation;
715: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
716: fnd_message.raise_error;
717: END IF;

Line 718: hr_utility.set_location ('Leaving:'||l_package_name,80);

714: CLOSE c_translation;
715: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
716: fnd_message.raise_error;
717: END IF;
718: hr_utility.set_location ('Leaving:'||l_package_name,80);
719: END validate_translation;
720: --------------------------------------------------------------------------------
721:
722: END PER_PERSON_TYPES_PKG;