371: g_do_not_cascade := 'N';
372:
373: l_log_text := substr(l_log_text || ', Message : ' || 'Record Inserted',1,2000);
374:
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(
372:
373: l_log_text := substr(l_log_text || ', Message : ' || 'Record Inserted',1,2000);
374:
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,