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

Line 136: HR_UTILITY.set_location(' Entering: '||l_proc, 10);

132: --
133: BEGIN
134: --
135: --Log entry
136: HR_UTILITY.set_location(' Entering: '||l_proc, 10);
137: --
138: --Issue savepoint
139: SAVEPOINT pre_state;
140: --

Line 178: HR_UTILITY.set_location('Checking the eligibility criteria ', 40);

174: CLOSE csr_overlaps;
175: END IF;
176: --
177: -- Checking whether user satisfies the eligibility criteria for going to a situation
178: HR_UTILITY.set_location('Checking the eligibility criteria ', 40);
179: l_rul_sit_return_st := pqh_sit_engine.is_situation_valid(p_person_id,p_provisional_start_date,p_statutory_situation_id);
180: HR_UTILITY.set_location('Return status for the eligibility criteria '||l_rul_sit_return_st, 40);
181: IF l_rul_sit_return_st = 'N' then
182: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN

Line 180: HR_UTILITY.set_location('Return status for the eligibility criteria '||l_rul_sit_return_st, 40);

176: --
177: -- Checking whether user satisfies the eligibility criteria for going to a situation
178: HR_UTILITY.set_location('Checking the eligibility criteria ', 40);
179: l_rul_sit_return_st := pqh_sit_engine.is_situation_valid(p_person_id,p_provisional_start_date,p_statutory_situation_id);
180: HR_UTILITY.set_location('Return status for the eligibility criteria '||l_rul_sit_return_st, 40);
181: IF l_rul_sit_return_st = 'N' then
182: IF HR_MULTI_MESSAGE.get_return_status = 'E' THEN
183: RAISE HR_MULTI_MESSAGE.error_message_exist;
184: END IF;

Line 294: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);

290: RAISE HR_MULTI_MESSAGE.error_message_exist;
291: END IF;
292: --
293: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
294: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);
295: --
296: EXCEPTION
297: WHEN HR_MULTI_MESSAGE.error_message_exist THEN
298: --Catch Multiple Message List exception

Line 304: HR_UTILITY.set_location(' Leaving: '||l_proc, 30);

300: --Reset IN OUT parameters and set OUT parameters
301: p_emp_stat_situation_id := NULL;
302: p_object_version_number := NULL;
303: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
304: HR_UTILITY.set_location(' Leaving: '||l_proc, 30);
305: WHEN others THEN
306: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
307: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
308: ROLLBACK TO pre_state;

Line 310: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);

306: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
307: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
308: ROLLBACK TO pre_state;
309: IF HR_MULTI_MESSAGE.unexpected_error_add(l_proc) THEN
310: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);
311: RAISE;
312: END IF;
313: --Reset IN OUT and set OUT parameters
314: p_emp_stat_situation_id := NULL;

Line 317: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);

313: --Reset IN OUT and set OUT parameters
314: p_emp_stat_situation_id := NULL;
315: p_object_version_number := NULL;
316: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
317: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);
318: END create_emp_stat_situation;
319: --
320: -- ---------------------------------------------------------------------------
321: -- ----------------------< update_emp_stat_situation >------------------------

Line 451: HR_UTILITY.set_location(' Entering: '||l_proc, 10);

447: --
448: BEGIN
449: --
450: --Log entry
451: HR_UTILITY.set_location(' Entering: '||l_proc, 10);
452: --
453: --Issue savepoint
454: SAVEPOINT pre_state;
455: --

Line 653: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);

649: END IF;
650: END IF;
651: --
652: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
653: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);
654: --
655: EXCEPTION
656: WHEN HR_MULTI_MESSAGE.error_message_exist THEN
657: --Catch Multiple Message List exception

Line 662: HR_UTILITY.set_location(' Leaving: '||l_proc, 30);

658: ROLLBACK TO pre_state;
659: --Reset IN OUT parameters and set OUT parameters
660: p_object_version_number := l_object_version_number;
661: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
662: HR_UTILITY.set_location(' Leaving: '||l_proc, 30);
663: WHEN others THEN
664: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
665: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
666: ROLLBACK TO pre_state;

Line 668: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);

664: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
665: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
666: ROLLBACK TO pre_state;
667: IF HR_MULTI_MESSAGE.unexpected_error_add(l_proc) THEN
668: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);
669: RAISE;
670: END IF;
671: --Reset IN OUT and set OUT parameters
672: p_object_version_number := l_object_version_number;

Line 674: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);

670: END IF;
671: --Reset IN OUT and set OUT parameters
672: p_object_version_number := l_object_version_number;
673: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
674: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);
675: END update_emp_stat_situation;
676: --
677: -- ---------------------------------------------------------------------------
678: -- --------------------< reinstate_emp_stat_situation >-----------------------

Line 723: HR_UTILITY.set_location(' Entering: '||l_proc, 10);

719: --
720: BEGIN
721: --
722: --Log entry
723: HR_UTILITY.set_location(' Entering: '||l_proc, 10);
724: --
725: --Issue savepoint
726: SAVEPOINT pre_state;
727: --

Line 815: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);

811: END IF;
812: --
813: p_new_emp_stat_situation_id := l_iand_emp_stat_sit_id;
814: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
815: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);
816: --
817: EXCEPTION
818: WHEN HR_MULTI_MESSAGE.error_message_exist THEN
819: --Catch Multiple Message List exception

Line 824: HR_UTILITY.set_location(' Leaving: '||l_proc, 30);

820: ROLLBACK TO pre_state;
821: --Reset IN OUT parameters and set OUT parameters
822: p_new_emp_stat_situation_id := NULL;
823: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
824: HR_UTILITY.set_location(' Leaving: '||l_proc, 30);
825: WHEN others THEN
826: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
827: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
828: ROLLBACK TO pre_state;

Line 830: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);

826: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
827: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
828: ROLLBACK TO pre_state;
829: IF HR_MULTI_MESSAGE.unexpected_error_add(l_proc) THEN
830: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);
831: RAISE;
832: END IF;
833: --Reset IN OUT and set OUT parameters
834: p_new_emp_stat_situation_id := NULL;

Line 836: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);

832: END IF;
833: --Reset IN OUT and set OUT parameters
834: p_new_emp_stat_situation_id := NULL;
835: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
836: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);
837: END reinstate_emp_stat_situation;
838: --
839: -- ---------------------------------------------------------------------------
840: -- |-----------------------< renew_emp_stat_situation >-----------------------

Line 926: HR_UTILITY.set_location(' Entering: '||l_proc, 10);

922: --
923: BEGIN
924: --
925: --Log entry
926: HR_UTILITY.set_location(' Entering: '||l_proc, 10);
927: --
928: --Issue savepoint
929: SAVEPOINT pre_state;
930: --

Line 1070: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);

1066: END IF;
1067: --
1068: */
1069: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
1070: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);
1071: --
1072: EXCEPTION
1073: WHEN HR_MULTI_MESSAGE.error_message_exist THEN
1074: --Catch Multiple Message List exception

Line 1080: HR_UTILITY.set_location(' Leaving:' || l_proc, 30);

1076: --Reset IN OUT parameters and set OUT parameters
1077: p_emp_stat_situation_id := l_emp_stat_situation_id;
1078: p_object_version_number := l_object_version_number;
1079: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
1080: HR_UTILITY.set_location(' Leaving:' || l_proc, 30);
1081: WHEN others THEN
1082: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
1083: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
1084: ROLLBACK TO pre_state;

Line 1086: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);

1082: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
1083: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
1084: ROLLBACK TO pre_state;
1085: IF HR_MULTI_MESSAGE.unexpected_error_add(l_proc) THEN
1086: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);
1087: RAISE;
1088: END IF;
1089: --Reset IN OUT and set OUT parameters
1090: p_emp_stat_situation_id := l_emp_stat_situation_id;

Line 1093: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);

1089: --Reset IN OUT and set OUT parameters
1090: p_emp_stat_situation_id := l_emp_stat_situation_id;
1091: p_object_version_number := l_object_version_number;
1092: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
1093: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);
1094: END renew_emp_stat_situation;
1095: --
1096: -- ---------------------------------------------------------------------------
1097: -- |-----------------------< delete_emp_stat_situation >----------------------

Line 1158: HR_UTILITY.set_location(' Entering: '||l_proc, 10);

1154: --
1155: BEGIN
1156: --
1157: --Log entry
1158: HR_UTILITY.set_location(' Entering: '||l_proc, 10);
1159: --
1160: --Issue savepoint
1161: SAVEPOINT pre_state;
1162: --

Line 1330: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);

1326: --
1327: END IF;
1328: --
1329: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
1330: HR_UTILITY.set_location(' Leaving: '||l_proc, 20);
1331: --
1332: EXCEPTION
1333: WHEN HR_MULTI_MESSAGE.error_message_exist THEN
1334: --Catch Multiple Message List exception

Line 1338: HR_UTILITY.set_location(' Leaving:' || l_proc, 30);

1334: --Catch Multiple Message List exception
1335: ROLLBACK TO pre_state;
1336: --Reset IN OUT parameters and set OUT parameters
1337: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
1338: HR_UTILITY.set_location(' Leaving:' || l_proc, 30);
1339: WHEN others THEN
1340: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
1341: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
1342: ROLLBACK TO pre_state;

Line 1344: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);

1340: --When Multiple Message Detection is enabled catch any Application specific or other unexpected exceptions.
1341: --Adding appropriate details to Multiple Message List. Otherwise re-raise the error.
1342: ROLLBACK TO pre_state;
1343: IF HR_MULTI_MESSAGE.unexpected_error_add(l_proc) THEN
1344: HR_UTILITY.set_location(' Leaving: '||l_proc, 40);
1345: RAISE;
1346: END IF;
1347: --Reset IN OUT and set OUT parameters
1348: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;

Line 1349: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);

1345: RAISE;
1346: END IF;
1347: --Reset IN OUT and set OUT parameters
1348: p_return_status := HR_MULTI_MESSAGE.get_return_status_disable;
1349: HR_UTILITY.set_location(' Leaving: '||l_proc, 50);
1350: END delete_emp_stat_situation;
1351: --
1352: --
1353: -- ---------------------------------------------------------------------------