DBA Data[Home] [Help]

APPS.HR_GENERAL_UTILITIES dependencies on HR_SESSION_UTILITIES

Line 66: hr_session_utilities.get_user_date_format;

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;

Line 273: RAISE hr_session_utilities.g_fatal_error;

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

Line 279: ( hr_session_utilities.g_PER_application_id

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;

Line 331: RAISE hr_session_utilities.g_fatal_error;

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

Line 337: ( hr_session_utilities.g_PER_application_id

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;

Line 766: ( hr_session_utilities.g_PER_application_id

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);

Line 771: RAISE hr_session_utilities.g_coding_error;

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: -- ----------------------------------------------------------------------------

Line 1698: ( hr_session_utilities.g_PER_application_id

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);

Line 1703: RAISE hr_session_utilities.g_coding_error;

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: -- ----------------------------------------------------------------------------

Line 1915: RAISE hr_session_utilities.g_coding_error;

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

Line 1935: ( hr_session_utilities.g_PER_application_id

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);

Line 1940: RAISE hr_session_utilities.g_coding_error;

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: -- ----------------------------------------------------------------------------

Line 2042: ( hr_session_utilities.g_PER_application_id

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

Line 2292: ( hr_session_utilities.g_PER_application_id

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);

Line 2306: ( hr_session_utilities.g_PER_application_id

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);

Line 2311: RAISE hr_session_utilities.g_coding_error;

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: -- ----------------------------------------------------------------------------

Line 2544: ( hr_session_utilities.g_PER_application_id

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);

Line 2549: RAISE hr_session_utilities.g_coding_error;

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: -- ----------------------------------------------------------------------------

Line 2604: ( hr_session_utilities.g_PER_application_id

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);

Line 2609: RAISE hr_session_utilities.g_coding_error;

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: -- ----------------------------------------------------------------------------