APPS.GHR_SES_CONV_PKG dependencies on GHR_WGI_PKG

Line 227: ghr_wgi_pkg.create_ghr_errorlog(

223: ---
224: --- Update failed then capture the error and Enter the log.
225: ---
226: l_log_text := substr(l_log_text || ', Message : ' || 'ERROR NOT UPDATED ,',1,2000);
227: ghr_wgi_pkg.create_ghr_errorlog(
228: p_program_name => g_proc_name,
229: p_message_name => 'ERR-PER_POSITION_EXTRA_INFO',
230: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
231: p_log_date => sysdate);

Line 239: ghr_wgi_pkg.create_ghr_errorlog(

235: ---
236: --- Update Successful - Enter log.
237: ---
238: l_log_text := substr(l_log_text || ', Message : ' || 'Updated Successful ',1,2000);
239: ghr_wgi_pkg.create_ghr_errorlog(
240: p_program_name => g_proc_name,
241: p_message_name => 'PER_POSITION_EXTRA_INFO',
242: p_log_text => l_log_text,
243: p_log_date => sysdate);

Line 255: ghr_wgi_pkg.create_ghr_errorlog(

251: IF l_counter = 0 THEN
252: ---
253: --- No Records in PER_POSITION_EXTRA_INFO - so Enter log.
254: ---
255: ghr_wgi_pkg.create_ghr_errorlog(
256: p_program_name => g_proc_name,
257: p_message_name => 'NO-PER_POSITION_EXTRA_INFO',
258: p_log_text => 'Error : NO Valid Extra Position Info records found for Update' ,
259: p_log_date => sysdate);

Line 264: ghr_wgi_pkg.create_ghr_errorlog(

260: ELSE
261: ---
262: --- All Records in PER_POSITION_EXTRA_INFO updated - so Enter log.
263: ---
264: ghr_wgi_pkg.create_ghr_errorlog(
265: p_program_name => g_proc_name,
266: p_message_name => 'TOT-PER_POSITION_EXTRA_INFO',
267: p_log_text => 'Total Records updated with SES equivalent plans are ' || to_char(l_counter),
268: p_log_date => sysdate);

Line 386: ghr_wgi_pkg.create_ghr_errorlog(

382: ghr_validate_perwsdpo.validate_perwsdpo(l_position_id,l_effective_date);
383: ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);
384:
385: l_counter1 := l_counter1 + 1;
386: ghr_wgi_pkg.create_ghr_errorlog(
387: p_program_name => g_proc_name,
388: p_message_name => 'INS-GHR_PA_HISTORY',
389: p_log_text => l_log_text,
390: p_log_date => sysdate);

Line 395: ghr_wgi_pkg.create_ghr_errorlog(

391:
392: END IF;
393: Exception when others then
394: l_log_text := substr(l_log_text || ', Message : ' || 'Record Not Inserted',1,2000);
395: ghr_wgi_pkg.create_ghr_errorlog(
396: p_program_name => g_proc_name,
397: p_message_name => 'INSERR-GHR_PA_HISTORY',
398: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
399: p_log_date => sysdate);

Line 446: ghr_wgi_pkg.create_ghr_errorlog(

442: WHERE pa_history_id = l_hist_id;
443:
444: IF SQL%NOTFOUND THEN
445: l_log_text := substr(l_log_text || ', Message : ' || 'ERROR NOT UPDATED ,',1,2000);
446: ghr_wgi_pkg.create_ghr_errorlog(
447: p_program_name => g_proc_name,
448: p_message_name => 'UPDERR-GHR_PA_HISTORY',
449: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
450: p_log_date => sysdate);

Line 454: ghr_wgi_pkg.create_ghr_errorlog(

450: p_log_date => sysdate);
451: ELSE
452: l_counter := l_counter + 1;
453: l_log_text := substr(l_log_text || ', Message : ' || 'Updated Successful ',1,2000);
454: ghr_wgi_pkg.create_ghr_errorlog(
455: p_program_name => g_proc_name,
456: p_message_name => 'UPD-GHR_PA_HISTORY',
457: p_log_text => l_log_text,
458: p_log_date => sysdate);

Line 468: ghr_wgi_pkg.create_ghr_errorlog(

464: END IF;
465: END LOOP; -- Hist records cursor
466:
467: IF l_counter1 = 0 AND l_counter = 0 THEN
468: ghr_wgi_pkg.create_ghr_errorlog(
469: p_program_name => g_proc_name,
470: p_message_name => 'GHR_PA_HISTORY',
471: p_log_text => 'Error : NO Valid History Position Records found for Update',
472: p_log_date => sysdate);

Line 474: ghr_wgi_pkg.create_ghr_errorlog(

470: p_message_name => 'GHR_PA_HISTORY',
471: p_log_text => 'Error : NO Valid History Position Records found for Update',
472: p_log_date => sysdate);
473: ELSE
474: ghr_wgi_pkg.create_ghr_errorlog(
475: p_program_name => g_proc_name,
476: p_message_name => 'TOT-GHR_PA_HISTORY',
477: p_log_text => 'Total Records inserted with SES equivalent plans are ' ||
478: to_char(l_counter1) || ' and Updates are ' || to_char(l_counter),