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

Line 204: hr_utility.set_location('Entering:'|| l_proc, 10);

200: from per_analysis_criteria
201: where analysis_criteria_id = l_analysis_criteria_id;
202: --
203: begin
204: hr_utility.set_location('Entering:'|| l_proc, 10);
205: --
206: -- Issue a savepoint
207: --
208: savepoint create_sit;

Line 210: hr_utility.set_location(l_proc, 20);

206: -- Issue a savepoint
207: --
208: savepoint create_sit;
209: --
210: hr_utility.set_location(l_proc, 20);
211: --
212: -- Truncate date, date_from, date_to and program_update_date values,
213: -- effectively removing time element.
214: --

Line 226: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

222: open csr_bg;
223: fetch csr_bg into l_discard;
224: if csr_bg%notfound then
225: close csr_bg;
226: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
227: hr_utility.raise_error;
228: end if;
229: close csr_bg;
230: --

Line 227: hr_utility.raise_error;

223: fetch csr_bg into l_discard;
224: if csr_bg%notfound then
225: close csr_bg;
226: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
227: hr_utility.raise_error;
228: end if;
229: close csr_bg;
230: --
231: -- Check if the p_person_id is valid

Line 373: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');

369: open ancerrsel1;
370: fetch ancerrsel1 into l_discard;
371: if ancerrsel1%notfound then
372: close ancerrsel1;
373: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
374: hr_utility.set_message_token('FLEXFIELD_STRUCTURE',
375: p_id_flex_num);
376: hr_utility.raise_error;
377: end if;

Line 374: hr_utility.set_message_token('FLEXFIELD_STRUCTURE',

370: fetch ancerrsel1 into l_discard;
371: if ancerrsel1%notfound then
372: close ancerrsel1;
373: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
374: hr_utility.set_message_token('FLEXFIELD_STRUCTURE',
375: p_id_flex_num);
376: hr_utility.raise_error;
377: end if;
378: close ancerrsel1;

Line 376: hr_utility.raise_error;

372: close ancerrsel1;
373: hr_utility.set_message(801, 'HR_6039_ALL_CANT_GET_FFIELD');
374: hr_utility.set_message_token('FLEXFIELD_STRUCTURE',
375: p_id_flex_num);
376: hr_utility.raise_error;
377: end if;
378: close ancerrsel1;
379: --
380: open ancerrsel2;

Line 387: hr_utility.set_message(801, 'HR_51114_JBR_SPCIAL_NOT_EXIST');

383: close ancerrsel2;
384: --
385: -- the row does not exist in PER_SPECIAL_INFO_TYPES
386: --
387: hr_utility.set_message(801, 'HR_51114_JBR_SPCIAL_NOT_EXIST');
388: hr_utility.raise_error;
389: end if;
390: close ancerrsel2;
391: --

Line 388: hr_utility.raise_error;

384: --
385: -- the row does not exist in PER_SPECIAL_INFO_TYPES
386: --
387: hr_utility.set_message(801, 'HR_51114_JBR_SPCIAL_NOT_EXIST');
388: hr_utility.raise_error;
389: end if;
390: close ancerrsel2;
391: --
392: -- the row is not enabled in PER_SPECIAL_INFO_TYPES

Line 394: hr_utility.set_message(801, 'HR_51115_JBR_SPCIAL_NOT_ENABLE');

390: close ancerrsel2;
391: --
392: -- the row is not enabled in PER_SPECIAL_INFO_TYPES
393: --
394: hr_utility.set_message(801, 'HR_51115_JBR_SPCIAL_NOT_ENABLE');
395: hr_utility.raise_error;
396: end if;
397: close ancsel;
398: --

Line 395: hr_utility.raise_error;

391: --
392: -- the row is not enabled in PER_SPECIAL_INFO_TYPES
393: --
394: hr_utility.set_message(801, 'HR_51115_JBR_SPCIAL_NOT_ENABLE');
395: hr_utility.raise_error;
396: end if;
397: close ancsel;
398: --
399: hr_utility.set_location(l_proc, 30);

Line 399: hr_utility.set_location(l_proc, 30);

395: hr_utility.raise_error;
396: end if;
397: close ancsel;
398: --
399: hr_utility.set_location(l_proc, 30);
400: --
401: -- Only call this if p_analysis_criteria_id has no value
402: --
403: if l_analysis_criteria_id is null

Line 447: hr_utility.set_location(l_proc, 40);

443: ,p_ccid => l_analysis_criteria_id
444: ,p_concat_segments_out => l_name
445: );
446: --
447: hr_utility.set_location(l_proc, 40);
448: --
449: end if;
450: --
451: if l_analysis_criteria_id is not null

Line 493: hr_utility.set_location(l_proc, 50);

489: ,p_object_version_number => l_object_version_number
490: ,p_person_analysis_id => l_person_analysis_id
491: );
492: end if;
493: hr_utility.set_location(l_proc, 50);
494: --
495: -- Call After Process User Hook
496: --
497: begin

Line 577: hr_utility.set_location(l_proc, 70);

573: -- End of API User Hook for the after hook of create_sit
574: --
575: end;
576: --
577: hr_utility.set_location(l_proc, 70);
578: --
579: if p_validate then
580: raise hr_api.validate_enabled;
581: end if;

Line 583: hr_utility.set_location(l_proc, 75);

579: if p_validate then
580: raise hr_api.validate_enabled;
581: end if;
582: --
583: hr_utility.set_location(l_proc, 75);
584: --
585: -- Set OUT parameters
586: --
587: if l_null_ind = 1

Line 597: hr_utility.set_location(' Leaving:'||l_proc, 80);

593: p_person_analysis_id := l_person_analysis_id;
594: p_pea_object_version_number := l_object_version_number;
595: end if;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 80);
598: exception
599: when hr_api.validate_enabled then
600: --
601: -- As the Validate_Enabled exception has been raised

Line 618: hr_utility.set_location(' Leaving:'||l_proc, 90);

614: p_person_analysis_id := null;
615: p_pea_object_version_number := null;
616: end if;
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 90);
619: --
620: when others then
621: --
622: -- A validation or unexpected error has occured

Line 631: hr_utility.set_location(' Leaving:'||l_proc, 100);

627: p_person_analysis_id := null;
628: p_pea_object_version_number := null;
629: ROLLBACK TO create_sit;
630: --
631: hr_utility.set_location(' Leaving:'||l_proc, 100);
632: --
633: raise;
634: --
635: end create_sit;

Line 801: hr_utility.set_location('Entering:'|| l_proc, 10);

797: where person_analysis_id = p_person_analysis_id;
798: --
799: --
800: begin
801: hr_utility.set_location('Entering:'|| l_proc, 10);
802: --
803: -- Issue a savepoint
804: --
805: savepoint update_sit;

Line 807: hr_utility.set_location(l_proc, 20);

803: -- Issue a savepoint
804: --
805: savepoint update_sit;
806: --
807: hr_utility.set_location(l_proc, 20);
808: --
809: -- Truncate date, date_from, date_to and program_update_date values,
810: -- effectively removing time element.
811: --

Line 938: hr_utility.set_message(800, 'PER_52508_PEA_INV_FLEX');

934: --
935: close c2;
936: -- the row is not enabled in PER_SPECIAL_INFO_TYPES
937: --
938: hr_utility.set_message(800, 'PER_52508_PEA_INV_FLEX');
939: hr_utility.raise_error;
940: --
941: end if;
942: close c2;

Line 939: hr_utility.raise_error;

935: close c2;
936: -- the row is not enabled in PER_SPECIAL_INFO_TYPES
937: --
938: hr_utility.set_message(800, 'PER_52508_PEA_INV_FLEX');
939: hr_utility.raise_error;
940: --
941: end if;
942: close c2;
943: --

Line 944: hr_utility.set_location(l_proc, 30);

940: --
941: end if;
942: close c2;
943: --
944: hr_utility.set_location(l_proc, 30);
945: --
946: --
947: -- Retrieve Current person analysis Details from person_analyses
948: --

Line 953: hr_utility.set_location(l_proc, 40);

949: l_api_updating := per_pea_shd.api_updating
950: (p_person_analysis_id => p_person_analysis_id
951: ,p_object_version_number => p_pea_object_version_number);
952: --
953: hr_utility.set_location(l_proc, 40);
954: --
955: if not l_api_updating then
956: hr_utility.set_location(l_proc, 50);
957: --

Line 956: hr_utility.set_location(l_proc, 50);

952: --
953: hr_utility.set_location(l_proc, 40);
954: --
955: if not l_api_updating then
956: hr_utility.set_location(l_proc, 50);
957: --
958: -- As this an updating API, the person_analysis_id must exist.
959: --
960: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

Line 960: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

956: hr_utility.set_location(l_proc, 50);
957: --
958: -- As this an updating API, the person_analysis_id must exist.
959: --
960: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
961: hr_utility.raise_error;
962: else
963: hr_utility.set_location(l_proc, 60);
964: l_id_flex_num := per_pea_shd.g_old_rec.id_flex_num;

Line 961: hr_utility.raise_error;

957: --
958: -- As this an updating API, the person_analysis_id must exist.
959: --
960: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
961: hr_utility.raise_error;
962: else
963: hr_utility.set_location(l_proc, 60);
964: l_id_flex_num := per_pea_shd.g_old_rec.id_flex_num;
965: l_business_group_id := per_pea_shd.g_old_rec.business_group_id;

Line 963: hr_utility.set_location(l_proc, 60);

959: --
960: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
961: hr_utility.raise_error;
962: else
963: hr_utility.set_location(l_proc, 60);
964: l_id_flex_num := per_pea_shd.g_old_rec.id_flex_num;
965: l_business_group_id := per_pea_shd.g_old_rec.business_group_id;
966: end if;
967: --

Line 968: hr_utility.set_location(l_proc, 70);

964: l_id_flex_num := per_pea_shd.g_old_rec.id_flex_num;
965: l_business_group_id := per_pea_shd.g_old_rec.business_group_id;
966: end if;
967: --
968: hr_utility.set_location(l_proc, 70);
969: --
970: -- update analysis criteria in PER_ANALYSIS_CRITERIA
971: --
972: -- Determine the position defintion by calling upd_or_sel

Line 1019: hr_utility.set_location(l_proc, 80);

1015: ,p_concat_segments_out => l_name
1016: );
1017: END IF;
1018: --
1019: hr_utility.set_location(l_proc, 80);
1020: --
1021: -- update person_analyses into PER_PERSON_ANALYSES
1022: --
1023: per_pea_upd.upd

Line 1058: hr_utility.set_location(l_proc, 90);

1054: ,p_attribute20 => p_attribute20
1055: ,p_object_version_number => l_object_version_number
1056: );
1057: --
1058: hr_utility.set_location(l_proc, 90);
1059: --
1060: begin
1061: --
1062: -- Start of API User Hook for the after hook of update_sit

Line 1143: hr_utility.set_location(l_proc, 95);

1139: if p_validate then
1140: raise hr_api.validate_enabled;
1141: end if;
1142: --
1143: hr_utility.set_location(l_proc, 95);
1144: --
1145: --Set OUT parameters
1146: --
1147: if l_null_ind = 1

Line 1155: hr_utility.set_location(' Leaving:'||l_proc, 100);

1151: p_analysis_criteria_id := l_analysis_criteria_id;
1152: p_pea_object_version_number := l_object_version_number;
1153: end if;
1154: --
1155: hr_utility.set_location(' Leaving:'||l_proc, 100);
1156: --
1157: exception
1158: --
1159: when hr_api.validate_enabled then

Line 1176: hr_utility.set_location(' Leaving:' ||l_proc, 110);

1172: then
1173: p_analysis_criteria_id := null;
1174: end if;
1175: --
1176: hr_utility.set_location(' Leaving:' ||l_proc, 110);
1177: --
1178: when others then
1179: --
1180: -- A validation or unexpected error has occured

Line 1188: hr_utility.set_location(' Leaving:'||l_proc, 120);

1184: p_pea_object_version_number := l_pea_object_version_number;
1185: p_analysis_criteria_id := l_analysis_criteria_id;
1186: ROLLBACK TO update_sit;
1187: --
1188: hr_utility.set_location(' Leaving:'||l_proc, 120);
1189: --
1190: raise;
1191: --
1192: end update_sit;

Line 1246: hr_utility.set_location('Entering:'|| l_proc,10);

1242: l_proc varchar2(72) := g_package||'delete_sit';
1243: --
1244: BEGIN
1245: --
1246: hr_utility.set_location('Entering:'|| l_proc,10);
1247: --
1248: -- Issue a savepoint
1249: --
1250: savepoint delete_sit;

Line 1252: hr_utility.set_location('Entering:'|| l_proc,20);

1248: -- Issue a savepoint
1249: --
1250: savepoint delete_sit;
1251: --
1252: hr_utility.set_location('Entering:'|| l_proc,20);
1253: --
1254: -- Insert Before delete user hook
1255: --
1256: begin

Line 1278: hr_utility.set_location('Entering:'|| l_proc,20);

1274: per_pea_del.del(p_person_analysis_id => p_person_analysis_id,
1275: p_object_version_number => p_pea_object_version_number,
1276: p_validate => false);
1277: --
1278: hr_utility.set_location('Entering:'|| l_proc,20);
1279: --
1280: -- Insert After delete user hook
1281: --
1282: begin

Line 1339: hr_utility.set_location('Entering:'|| l_proc, 10);

1335: l_proc varchar2(72) := g_package||' lck';
1336: --
1337: begin
1338: --
1339: hr_utility.set_location('Entering:'|| l_proc, 10);
1340: --
1341: per_pea_shd.lck
1342: (
1343: p_person_analysis_id => p_person_analysis_id

Line 1347: hr_utility.set_location(' Leaving:'||l_proc, 70);

1343: p_person_analysis_id => p_person_analysis_id
1344: ,p_object_version_number => p_pea_object_version_number
1345: );
1346: --
1347: hr_utility.set_location(' Leaving:'||l_proc, 70);
1348: --
1349: end lck;
1350: end hr_sit_api;