378: g_do_not_cascade := 'N';
379:
380: l_log_text := substr(l_log_text || ', Message : ' || 'Record Inserted',1,2000);
381:
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(
379:
380: l_log_text := substr(l_log_text || ', Message : ' || 'Record Inserted',1,2000);
381:
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,