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 198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

194: --
195: OPEN C;
196: FETCH C INTO X_Rowid;
197: if (SQL%NOTFOUND) then
198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
199: hr_utility.set_message_token('PROCEDURE','Insert_Row');
200: hr_utility.set_message_token('STEP','1');
201: hr_utility.raise_error;
202: end if;

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

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

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

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

Line 201: hr_utility.raise_error;

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

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

237: BEGIN
238: OPEN C;
239: FETCH C INTO Recinfo;
240: if (SQL%NOTFOUND) then
241: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
242: hr_utility.set_message_token('PROCEDURE','Lock_Row');
243: hr_utility.set_message_token('STEP','1');
244: hr_utility.raise_error;
245: end if;

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

238: OPEN C;
239: FETCH C INTO Recinfo;
240: if (SQL%NOTFOUND) then
241: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
242: hr_utility.set_message_token('PROCEDURE','Lock_Row');
243: hr_utility.set_message_token('STEP','1');
244: hr_utility.raise_error;
245: end if;
246: CLOSE C;

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

239: FETCH C INTO Recinfo;
240: if (SQL%NOTFOUND) then
241: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
242: hr_utility.set_message_token('PROCEDURE','Lock_Row');
243: hr_utility.set_message_token('STEP','1');
244: hr_utility.raise_error;
245: end if;
246: CLOSE C;
247: --

Line 244: hr_utility.raise_error;

240: if (SQL%NOTFOUND) then
241: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
242: hr_utility.set_message_token('PROCEDURE','Lock_Row');
243: hr_utility.set_message_token('STEP','1');
244: hr_utility.raise_error;
245: end if;
246: CLOSE C;
247: --
248: Recinfo.active_flag := rtrim(Recinfo.active_flag);

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

316: user_person_type = X_User_Person_Type
317: WHERE rowid = X_rowid;
318:
319: if (SQL%NOTFOUND) then
320: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
321: hr_utility.set_message_token('PROCEDURE','Update_Row');
322: hr_utility.set_message_token('STEP','1');
323: hr_utility.raise_error;
324: end if;

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

317: WHERE rowid = X_rowid;
318:
319: if (SQL%NOTFOUND) then
320: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
321: hr_utility.set_message_token('PROCEDURE','Update_Row');
322: hr_utility.set_message_token('STEP','1');
323: hr_utility.raise_error;
324: end if;
325:

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

318:
319: if (SQL%NOTFOUND) then
320: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
321: hr_utility.set_message_token('PROCEDURE','Update_Row');
322: hr_utility.set_message_token('STEP','1');
323: hr_utility.raise_error;
324: end if;
325:
326: -- MLS

Line 323: hr_utility.raise_error;

319: if (SQL%NOTFOUND) then
320: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
321: hr_utility.set_message_token('PROCEDURE','Update_Row');
322: hr_utility.set_message_token('STEP','1');
323: hr_utility.raise_error;
324: end if;
325:
326: -- MLS
327: update PER_PERSON_TYPES_TL set

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

345: X_Person_type_Id number) IS
346: BEGIN
347: --
348: if X_Default_flag = 'Y' then
349: hr_utility.set_message(801,'HR_6618_PERSON_TYPE_NO_DEL_DEF');
350: hr_utility.raise_error;
351: end if;
352: --
353: -- if the system name is in use then disallow the deletion

Line 350: hr_utility.raise_error;

346: BEGIN
347: --
348: if X_Default_flag = 'Y' then
349: hr_utility.set_message(801,'HR_6618_PERSON_TYPE_NO_DEL_DEF');
350: hr_utility.raise_error;
351: end if;
352: --
353: -- if the system name is in use then disallow the deletion
354: --

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

387: DELETE FROM per_person_types
388: WHERE rowid = X_Rowid;
389:
390: if (SQL%NOTFOUND) then
391: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE','Delete_Row');
393: hr_utility.set_message_token('STEP','1');
394: hr_utility.raise_error;
395: end if;

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

388: WHERE rowid = X_Rowid;
389:
390: if (SQL%NOTFOUND) then
391: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE','Delete_Row');
393: hr_utility.set_message_token('STEP','1');
394: hr_utility.raise_error;
395: end if;
396: END Delete_Row;

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

389:
390: if (SQL%NOTFOUND) then
391: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE','Delete_Row');
393: hr_utility.set_message_token('STEP','1');
394: hr_utility.raise_error;
395: end if;
396: END Delete_Row;
397:

Line 394: hr_utility.raise_error;

390: if (SQL%NOTFOUND) then
391: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE','Delete_Row');
393: hr_utility.set_message_token('STEP','1');
394: hr_utility.raise_error;
395: end if;
396: END Delete_Row;
397:
398: PROCEDURE Check_Delete (X_Business_Group_Id NUMBER) IS

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

420: FETCH C INTO System_Name;
421: CLOSE C;
422:
423: if System_Name is not null then
424: hr_utility.set_message(801,'HR_6318_SYS_PRIM_DEFAULT');
425: hr_utility.set_message_token('SYSTEM_NAME',System_Name);
426: hr_utility.raise_error;
427: end if;
428:

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

421: CLOSE C;
422:
423: if System_Name is not null then
424: hr_utility.set_message(801,'HR_6318_SYS_PRIM_DEFAULT');
425: hr_utility.set_message_token('SYSTEM_NAME',System_Name);
426: hr_utility.raise_error;
427: end if;
428:
429: END Check_Delete;

Line 426: hr_utility.raise_error;

422:
423: if System_Name is not null then
424: hr_utility.set_message(801,'HR_6318_SYS_PRIM_DEFAULT');
425: hr_utility.set_message_token('SYSTEM_NAME',System_Name);
426: hr_utility.raise_error;
427: end if;
428:
429: END Check_Delete;
430:

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

484: FETCH csr_nodefault INTO l_system_name_nodefault;
485: CLOSE csr_nodefault;
486:
487: IF l_system_name_nodefault IS NOT NULL THEN
488: hr_utility.set_message(800,'HR_289007_SYS_PRIM_NODEFAULT');
489: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_nodefault);
490: hr_utility.raise_error;
491: END IF;
492:

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

485: CLOSE csr_nodefault;
486:
487: IF l_system_name_nodefault IS NOT NULL THEN
488: hr_utility.set_message(800,'HR_289007_SYS_PRIM_NODEFAULT');
489: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_nodefault);
490: hr_utility.raise_error;
491: END IF;
492:
493: --

Line 490: hr_utility.raise_error;

486:
487: IF l_system_name_nodefault IS NOT NULL THEN
488: hr_utility.set_message(800,'HR_289007_SYS_PRIM_NODEFAULT');
489: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_nodefault);
490: hr_utility.raise_error;
491: END IF;
492:
493: --
494: -- Check to see if there are any system names with more than one default

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

499: FETCH csr_default INTO l_system_name_default;
500: CLOSE csr_default;
501:
502: IF l_system_name_default IS NOT NULL THEN
503: hr_utility.set_message(800,'HR_6318_SYS_PRIM_DEFAULT');
504: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_default);
505: hr_utility.raise_error;
506: END IF;
507:

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

500: CLOSE csr_default;
501:
502: IF l_system_name_default IS NOT NULL THEN
503: hr_utility.set_message(800,'HR_6318_SYS_PRIM_DEFAULT');
504: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_default);
505: hr_utility.raise_error;
506: END IF;
507:
508: END Check_Default;

Line 505: hr_utility.raise_error;

501:
502: IF l_system_name_default IS NOT NULL THEN
503: hr_utility.set_message(800,'HR_6318_SYS_PRIM_DEFAULT');
504: hr_utility.set_message_token('SYSTEM_NAME',l_system_name_default);
505: hr_utility.raise_error;
506: END IF;
507:
508: END Check_Default;
509:

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

540: v_system_used := csr_system%FOUND;
541: close csr_system;
542: --
543: if v_system_used then
544: hr_utility.set_message(801,'HR_6619_PERSON_TYPE_EXISTS');
545: hr_utility.raise_error;
546: end if;
547: --
548: END Check_System_Delete;

Line 545: hr_utility.raise_error;

541: close csr_system;
542: --
543: if v_system_used then
544: hr_utility.set_message(801,'HR_6619_PERSON_TYPE_EXISTS');
545: hr_utility.raise_error;
546: end if;
547: --
548: END Check_System_Delete;
549: --

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

581: open csr_business_group(x_business_group_name);
582: fetch csr_business_group into l_business_group;
583: if csr_business_group%notfound then
584: close csr_business_group;
585: hr_utility.set_message(800,'HR_7208_API_BUS_GRP_INVALID');
586: hr_utility.raise_error;
587: end if;
588: close csr_business_group;
589: -- Insert or update as appropriate

Line 586: hr_utility.raise_error;

582: fetch csr_business_group into l_business_group;
583: if csr_business_group%notfound then
584: close csr_business_group;
585: hr_utility.set_message(800,'HR_7208_API_BUS_GRP_INVALID');
586: hr_utility.raise_error;
587: end if;
588: close csr_business_group;
589: -- Insert or update as appropriate
590: open csr_person_type(x_person_type,l_business_group.organization_id);

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

761: l_package_name VARCHAR2(80) := 'PER_PERSON_TYPES_PKG.VALIDATE_TRANSLATION';
762: l_business_group_id NUMBER := nvl(p_business_group_id, g_business_group_id);
763:
764: BEGIN
765: hr_utility.set_location (l_package_name,10);
766: OPEN c_translation(language, user_person_type,person_type_id,
767: l_business_group_id);
768: hr_utility.set_location (l_package_name,50);
769: FETCH c_translation INTO g_dummy;

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

764: BEGIN
765: hr_utility.set_location (l_package_name,10);
766: OPEN c_translation(language, user_person_type,person_type_id,
767: l_business_group_id);
768: hr_utility.set_location (l_package_name,50);
769: FETCH c_translation INTO g_dummy;
770:
771: IF c_translation%NOTFOUND THEN
772: hr_utility.set_location (l_package_name,60);

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

768: hr_utility.set_location (l_package_name,50);
769: FETCH c_translation INTO g_dummy;
770:
771: IF c_translation%NOTFOUND THEN
772: hr_utility.set_location (l_package_name,60);
773: CLOSE c_translation;
774: ELSE
775: hr_utility.set_location (l_package_name,70);
776: CLOSE c_translation;

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

771: IF c_translation%NOTFOUND THEN
772: hr_utility.set_location (l_package_name,60);
773: CLOSE c_translation;
774: ELSE
775: hr_utility.set_location (l_package_name,70);
776: CLOSE c_translation;
777: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
778: fnd_message.raise_error;
779: END IF;

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

776: CLOSE c_translation;
777: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
778: fnd_message.raise_error;
779: END IF;
780: hr_utility.set_location ('Leaving:'||l_package_name,80);
781: END validate_translation;
782: --------------------------------------------------------------------------------
783:
784: END PER_PERSON_TYPES_PKG;