DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on FND_NEW_MESSAGES

Line 4383: l_error_msg fnd_new_messages.message_text%TYPE;

4379: l_proc_step NUMBER(38,10):=0;
4380: l_proc_name VARCHAR2(61):=
4381: g_package_name||'get_next_working_date_wp';
4382: l_retval NUMBER;
4383: l_error_msg fnd_new_messages.message_text%TYPE;
4384: -- nocopy changes
4385: l_curr_date_nc DATE;
4386: l_balance_days_nc NUMBER;
4387: BEGIN -- get_next_working_date_wp

Line 4560: l_err_msg_name fnd_new_messages.message_name%TYPE;

4556: l_hours NUMBER := 0;
4557: l_continue VARCHAR2(1) := 'Y';
4558: l_asg_wp_found BOOLEAN := FALSE;
4559: l_error_code NUMBER := 0;
4560: l_err_msg_name fnd_new_messages.message_name%TYPE;
4561: l_proc_step NUMBER(38,10):=0;
4562: l_proc_name VARCHAR2(61):=
4563: g_package_name||'get_next_working_date';
4564: r_wp_dets pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE;

Line 10203: l_error_code fnd_new_messages.message_number%TYPE:= 0;

10199: l_absence_total NUMBER;
10200: l_absence csr_absence_details%ROWTYPE;
10201: --l_absence_assignment_details csr_absence_primary_assignment%ROWTYPE;
10202:
10203: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10204: l_error_msg fnd_new_messages.message_text%TYPE;
10205:
10206: BEGIN
10207:

Line 10204: l_error_msg fnd_new_messages.message_text%TYPE;

10200: l_absence csr_absence_details%ROWTYPE;
10201: --l_absence_assignment_details csr_absence_primary_assignment%ROWTYPE;
10202:
10203: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10204: l_error_msg fnd_new_messages.message_text%TYPE;
10205:
10206: BEGIN
10207:
10208: g_debug := hr_utility.debug_enabled;

Line 10308: l_error_code fnd_new_messages.message_number%TYPE:= 0;

10304: ) RETURN NUMBER
10305: IS
10306:
10307: l_absence csr_absence_details%ROWTYPE;
10308: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10309: --l_error_msg fnd_new_messages.message_text%TYPE;
10310:
10311:
10312: l_proc_step NUMBER(38,10);

Line 10309: --l_error_msg fnd_new_messages.message_text%TYPE;

10305: IS
10306:
10307: l_absence csr_absence_details%ROWTYPE;
10308: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10309: --l_error_msg fnd_new_messages.message_text%TYPE;
10310:
10311:
10312: l_proc_step NUMBER(38,10);
10313: l_proc_name VARCHAR2(61):=

Line 10622: l_error_code fnd_new_messages.message_number%TYPE:= 0;

10618: ,p_band4_ent_bal OUT NOCOPY NUMBER
10619: ,p_noband_ent_bal OUT NOCOPY NUMBER
10620: ,p_error_message OUT NOCOPY VARCHAR2 )
10621: RETURN NUMBER IS
10622: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10623: l_proc_step NUMBER(38,10):=0;
10624: l_proc_name VARCHAR2(61):=
10625: g_package_name||'get_all_band_cs_4_yr_ent_bal';
10626: l_retval number ;

Line 10774: l_error_message fnd_new_messages.message_text%TYPE ;

10770: g_package_name||'get_entitlements';
10771:
10772: i BINARY_INTEGER := 1 ;
10773: l_entitlement_override_is_set BOOLEAN:= FALSE;
10774: l_error_message fnd_new_messages.message_text%TYPE ;
10775:
10776:
10777:
10778: BEGIN