DBA Data[Home] [Help]

APPS.PQP_GB_OMP_DAILY_ABSENCES dependencies on FND_NEW_MESSAGES

Line 71: l_message fnd_new_messages.message_text%TYPE;

67: (p_proc_name IN VARCHAR2
68: ,p_last_step_number IN NUMBER DEFAULT NULL
69: )
70: IS
71: l_message fnd_new_messages.message_text%TYPE;
72: BEGIN
73: IF g_debug THEN
74: debug(p_proc_name,SQLCODE);
75: debug(SQLERRM);

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

180:
181: l_generate_start_date DATE;
182: l_generate_end_date DATE;
183:
184: l_error_code fnd_new_messages.message_number%TYPE := 0 ;
185: l_message VARCHAR2(2500) ;
186: l_length_of_service NUMBER ;
187: l_value VARCHAR2(240) ;
188: l_datatype VARCHAR2(6);

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

1248:
1249: l_absence_end_date DATE;
1250: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;
1251: l_first_entitled_day_of_noband pqp_absval_pkg.csr_first_entitled_day_of_band%ROWTYPE;
1252: l_error_code fnd_new_messages.message_number%TYPE:=0;
1253: l_error_message fnd_new_messages.message_text%TYPE;
1254:
1255: l_proc_name VARCHAR2(61):=
1256: g_package_name||

Line 1253: l_error_message fnd_new_messages.message_text%TYPE;

1249: l_absence_end_date DATE;
1250: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;
1251: l_first_entitled_day_of_noband pqp_absval_pkg.csr_first_entitled_day_of_band%ROWTYPE;
1252: l_error_code fnd_new_messages.message_number%TYPE:=0;
1253: l_error_message fnd_new_messages.message_text%TYPE;
1254:
1255: l_proc_name VARCHAR2(61):=
1256: g_package_name||
1257: 'update_absence_plan_details';