APPS.GHR_SES_CONV_PKG dependencies on GHR_WGI_PKG

Line 223: ghr_wgi_pkg.create_ghr_errorlog(

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

Line 235: ghr_wgi_pkg.create_ghr_errorlog(

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

Line 251: ghr_wgi_pkg.create_ghr_errorlog(

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

Line 260: ghr_wgi_pkg.create_ghr_errorlog(

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

Line 379: ghr_wgi_pkg.create_ghr_errorlog(

375: ghr_validate_perwsdpo.validate_perwsdpo(l_position_id,l_effective_date);
376: ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);
377:
378: l_counter1 := l_counter1 + 1;
379: ghr_wgi_pkg.create_ghr_errorlog(
380: p_program_name => g_proc_name,
381: p_message_name => 'INS-GHR_PA_HISTORY',
382: p_log_text => l_log_text,
383: p_log_date => sysdate);

Line 388: ghr_wgi_pkg.create_ghr_errorlog(

384:
385: END IF;
386: Exception when others then
387: l_log_text := substr(l_log_text || ', Message : ' || 'Record Not Inserted',1,2000);
388: ghr_wgi_pkg.create_ghr_errorlog(
389: p_program_name => g_proc_name,
390: p_message_name => 'INSERR-GHR_PA_HISTORY',
391: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
392: p_log_date => sysdate);

Line 436: ghr_wgi_pkg.create_ghr_errorlog(

432: WHERE pa_history_id = l_hist_id;
433:
434: IF SQL%NOTFOUND THEN
435: l_log_text := substr(l_log_text || ', Message : ' || 'ERROR NOT UPDATED ,',1,2000);
436: ghr_wgi_pkg.create_ghr_errorlog(
437: p_program_name => g_proc_name,
438: p_message_name => 'UPDERR-GHR_PA_HISTORY',
439: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
440: p_log_date => sysdate);

Line 444: ghr_wgi_pkg.create_ghr_errorlog(

440: p_log_date => sysdate);
441: ELSE
442: l_counter := l_counter + 1;
443: l_log_text := substr(l_log_text || ', Message : ' || 'Updated Successful ',1,2000);
444: ghr_wgi_pkg.create_ghr_errorlog(
445: p_program_name => g_proc_name,
446: p_message_name => 'UPD-GHR_PA_HISTORY',
447: p_log_text => l_log_text,
448: p_log_date => sysdate);

Line 458: ghr_wgi_pkg.create_ghr_errorlog(

454: END IF;
455: END LOOP; -- Hist records cursor
456:
457: IF l_counter1 = 0 AND l_counter = 0 THEN
458: ghr_wgi_pkg.create_ghr_errorlog(
459: p_program_name => g_proc_name,
460: p_message_name => 'GHR_PA_HISTORY',
461: p_log_text => 'Error : NO Valid History Position Records found for Update',
462: p_log_date => sysdate);

Line 464: ghr_wgi_pkg.create_ghr_errorlog(

460: p_message_name => 'GHR_PA_HISTORY',
461: p_log_text => 'Error : NO Valid History Position Records found for Update',
462: p_log_date => sysdate);
463: ELSE
464: ghr_wgi_pkg.create_ghr_errorlog(
465: p_program_name => g_proc_name,
466: p_message_name => 'TOT-GHR_PA_HISTORY',
467: p_log_text => 'Total Records inserted with SES equivalent plans are ' ||
468: to_char(l_counter1) || ' and Updates are ' || to_char(l_counter),