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 10231: l_error_code fnd_new_messages.message_number%TYPE:= 0;

10227: l_absence_total NUMBER;
10228: l_absence csr_absence_details%ROWTYPE;
10229: --l_absence_assignment_details csr_absence_primary_assignment%ROWTYPE;
10230:
10231: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10232: l_error_msg fnd_new_messages.message_text%TYPE;
10233:
10234: BEGIN
10235:

Line 10232: l_error_msg fnd_new_messages.message_text%TYPE;

10228: l_absence csr_absence_details%ROWTYPE;
10229: --l_absence_assignment_details csr_absence_primary_assignment%ROWTYPE;
10230:
10231: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10232: l_error_msg fnd_new_messages.message_text%TYPE;
10233:
10234: BEGIN
10235:
10236: g_debug := hr_utility.debug_enabled;

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

10332: ) RETURN NUMBER
10333: IS
10334:
10335: l_absence csr_absence_details%ROWTYPE;
10336: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10337: --l_error_msg fnd_new_messages.message_text%TYPE;
10338:
10339:
10340: l_proc_step NUMBER(38,10);

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

10333: IS
10334:
10335: l_absence csr_absence_details%ROWTYPE;
10336: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10337: --l_error_msg fnd_new_messages.message_text%TYPE;
10338:
10339:
10340: l_proc_step NUMBER(38,10);
10341: l_proc_name VARCHAR2(61):=

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

10646: ,p_band4_ent_bal OUT NOCOPY NUMBER
10647: ,p_noband_ent_bal OUT NOCOPY NUMBER
10648: ,p_error_message OUT NOCOPY VARCHAR2 )
10649: RETURN NUMBER IS
10650: l_error_code fnd_new_messages.message_number%TYPE:= 0;
10651: l_proc_step NUMBER(38,10):=0;
10652: l_proc_name VARCHAR2(61):=
10653: g_package_name||'get_all_band_cs_4_yr_ent_bal';
10654: l_retval number ;

Line 10802: l_error_message fnd_new_messages.message_text%TYPE ;

10798: g_package_name||'get_entitlements';
10799:
10800: i BINARY_INTEGER := 1 ;
10801: l_entitlement_override_is_set BOOLEAN:= FALSE;
10802: l_error_message fnd_new_messages.message_text%TYPE ;
10803:
10804:
10805:
10806: BEGIN