62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');
65: hr_general_utilities.g_date_format :=
66: hr_session_utilities.get_user_date_format;
67: hr_general_utilities.g_attribute_application_id := 800;
68:
69: --
70: END reset_globals;
269: RETURN l_person_rec;
270: ELSE
271: CLOSE csr_people_rec;
272:
273: RAISE hr_session_utilities.g_fatal_error;
274: END IF;
275: --
276: EXCEPTION
277: WHEN OTHERS THEN
275: --
276: EXCEPTION
277: WHEN OTHERS THEN
278: hr_utility.set_message
279: ( hr_session_utilities.g_PER_application_id
280: , 'HR_52214_CM_NO_PERSON_DATA'
281: );
282: RAISE ;
283: END Get_Person_Record;
327:
328: RETURN l_person_rec;
329: ELSE
330: CLOSE csr_people_rec;
331: RAISE hr_session_utilities.g_fatal_error;
332: END IF;
333: --
334: EXCEPTION
335: WHEN OTHERS THEN
333: --
334: EXCEPTION
335: WHEN OTHERS THEN
336: hr_utility.set_message
337: ( hr_session_utilities.g_PER_application_id
338: , 'HR_52214_CM_NO_PERSON_DATA'
339: );
340: RAISE ;
341: END Get_Person_Details;
762: RETURN l_data;
763: EXCEPTION
764: WHEN OTHERS THEN
765: hr_utility.set_message
766: ( hr_session_utilities.g_PER_application_id
767: , 'HR_6153_ALL_PROCEDURE_FAIL'
768: );
769: hr_utility.set_message_token('PROCEDURE', l_proc);
770: hr_utility.set_message_token('STEP', sqlerrm);
767: , 'HR_6153_ALL_PROCEDURE_FAIL'
768: );
769: hr_utility.set_message_token('PROCEDURE', l_proc);
770: hr_utility.set_message_token('STEP', sqlerrm);
771: RAISE hr_session_utilities.g_coding_error;
772: END Get_Column_Data;
773: -- ----------------------------------------------------------------------------
774: -- |--< Get_lookup_Meaning >--------------------------------------------------|
775: -- ----------------------------------------------------------------------------
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: p_bind_values_tab := l_empty_values_tab;
1697: hr_utility.set_message
1698: ( hr_session_utilities.g_PER_application_id
1699: , 'HR_6153_ALL_PROCEDURE_FAIL'
1700: );
1701: hr_utility.set_message_token('PROCEDURE', l_proc);
1702: hr_utility.set_message_token('STEP', sqlerrm);
1699: , 'HR_6153_ALL_PROCEDURE_FAIL'
1700: );
1701: hr_utility.set_message_token('PROCEDURE', l_proc);
1702: hr_utility.set_message_token('STEP', sqlerrm);
1703: RAISE hr_session_utilities.g_coding_error;
1704:
1705: END BPFD;
1706: --
1707: -- ----------------------------------------------------------------------------
1911: ( p_instring => g_execute_handles(Counter)
1912: );
1913: END LOOP;
1914: ELSE
1915: RAISE hr_session_utilities.g_coding_error;
1916: END IF;
1917: --
1918:
1919: IF g_debug THEN
1931: -- this must be a coding error
1932: -- mechanism not really suitable for executing so many sql statements
1933: --
1934: hr_utility.set_message
1935: ( hr_session_utilities.g_PER_application_id
1936: , 'HR_6153_ALL_PROCEDURE_FAIL'
1937: );
1938: hr_utility.set_message_token('PROCEDURE', l_proc);
1939: hr_utility.set_message_token('STEP', sqlerrm);
1936: , 'HR_6153_ALL_PROCEDURE_FAIL'
1937: );
1938: hr_utility.set_message_token('PROCEDURE', l_proc);
1939: hr_utility.set_message_token('STEP', sqlerrm);
1940: RAISE hr_session_utilities.g_coding_error;
1941: END CCEI;
1942: -- ----------------------------------------------------------------------------
1943: -- |--< EXPD >----------------------------------------------------------------|
1944: -- ----------------------------------------------------------------------------
2038: -- decrypt2 returns -1 if the session is invalid
2039: --
2040: IF l_index_string = '-1' THEN
2041: hr_utility.set_message
2042: ( hr_session_utilities.g_PER_application_id
2043: , 'PER_DEXL_SESSION_FAIL'
2044: );
2045: RAISE g_fatal_error;
2046: ELSE
2288: end if;
2289: EXCEPTION
2290: WHEN g_fatal_error THEN
2291: hr_utility.set_message
2292: ( hr_session_utilities.g_PER_application_id
2293: , 'HR_6153_ALL_PROCEDURE_FAIL'
2294: );
2295: hr_utility.set_message_token('PROCEDURE', l_proc);
2296: hr_utility.set_message_token('STEP', sqlerrm);
2302: --
2303: -- an error trying to decode the string
2304: --
2305: hr_utility.set_message
2306: ( hr_session_utilities.g_PER_application_id
2307: , 'HR_6153_ALL_PROCEDURE_FAIL'
2308: );
2309: hr_utility.set_message_token('PROCEDURE', l_proc);
2310: hr_utility.set_message_token('STEP', sqlerrm);
2307: , 'HR_6153_ALL_PROCEDURE_FAIL'
2308: );
2309: hr_utility.set_message_token('PROCEDURE', l_proc);
2310: hr_utility.set_message_token('STEP', sqlerrm);
2311: RAISE hr_session_utilities.g_coding_error;
2312: END DexL;
2313: -- ----------------------------------------------------------------------------
2314: -- |--< SDER >----------------------------------------------------------------|
2315: -- ----------------------------------------------------------------------------
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: hr_utility.set_message
2544: ( hr_session_utilities.g_PER_application_id
2545: , 'HR_6153_ALL_PROCEDURE_FAIL'
2546: );
2547: hr_utility.set_message_token('PROCEDURE', l_proc);
2548: hr_utility.set_message_token('STEP', sqlerrm);
2545: , 'HR_6153_ALL_PROCEDURE_FAIL'
2546: );
2547: hr_utility.set_message_token('PROCEDURE', l_proc);
2548: hr_utility.set_message_token('STEP', sqlerrm);
2549: RAISE hr_session_utilities.g_coding_error;
2550: END Execute_Dynamic_SQL;
2551: -- ----------------------------------------------------------------------------
2552: -- |--< Set_Message_Txt_And_Number >------------------------------------------|
2553: -- ----------------------------------------------------------------------------
2600: RETURN l_record;
2601: EXCEPTION
2602: WHEN OTHERS THEN
2603: hr_utility.set_message
2604: ( hr_session_utilities.g_PER_application_id
2605: , 'HR_6153_ALL_PROCEDURE_FAIL'
2606: );
2607: hr_utility.set_message_token('PROCEDURE', l_proc);
2608: hr_utility.set_message_token('STEP', sqlerrm);
2605: , 'HR_6153_ALL_PROCEDURE_FAIL'
2606: );
2607: hr_utility.set_message_token('PROCEDURE', l_proc);
2608: hr_utility.set_message_token('STEP', sqlerrm);
2609: RAISE hr_session_utilities.g_coding_error;
2610: END Set_Message_Txt_And_Number;
2611: -- ----------------------------------------------------------------------------
2612: -- |--< Set_Workflow_Section_Attribute >--------------------------------------|
2613: -- ----------------------------------------------------------------------------