55: end if;
56: exception
57: when others then
58: l_count := l_count +1;
59: hr_utility.set_location('************************',9999);
60: hr_utility.trace(substr(SQLERRM,1,254));
61: hr_utility.trace('SQLCODE' || SQLCODE);
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
56: exception
57: when others then
58: l_count := l_count +1;
59: hr_utility.set_location('************************',9999);
60: hr_utility.trace(substr(SQLERRM,1,254));
61: hr_utility.trace('SQLCODE' || SQLCODE);
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
57: when others then
58: l_count := l_count +1;
59: hr_utility.set_location('************************',9999);
60: hr_utility.trace(substr(SQLERRM,1,254));
61: hr_utility.trace('SQLCODE' || SQLCODE);
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
58: l_count := l_count +1;
59: hr_utility.set_location('************************',9999);
60: hr_utility.trace(substr(SQLERRM,1,254));
61: hr_utility.trace('SQLCODE' || SQLCODE);
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);
59: hr_utility.set_location('************************',9999);
60: hr_utility.trace(substr(SQLERRM,1,254));
61: hr_utility.trace('SQLCODE' || SQLCODE);
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);
67: hr_utility.set_location('user_column_name ' || rec_hol_dt.user_column_name,9999);
60: hr_utility.trace(substr(SQLERRM,1,254));
61: hr_utility.trace('SQLCODE' || SQLCODE);
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);
67: hr_utility.set_location('user_column_name ' || rec_hol_dt.user_column_name,9999);
68: hr_utility.set_location('************************',9999);
61: hr_utility.trace('SQLCODE' || SQLCODE);
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);
67: hr_utility.set_location('user_column_name ' || rec_hol_dt.user_column_name,9999);
68: hr_utility.set_location('************************',9999);
69: end;
62: hr_utility.set_location('Count of wrong record ' || l_count,9999);
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);
67: hr_utility.set_location('user_column_name ' || rec_hol_dt.user_column_name,9999);
68: hr_utility.set_location('************************',9999);
69: end;
70:
63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,9999);
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);
67: hr_utility.set_location('user_column_name ' || rec_hol_dt.user_column_name,9999);
68: hr_utility.set_location('************************',9999);
69: end;
70:
71: end loop;
64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,9999);
65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,9999);
66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);
67: hr_utility.set_location('user_column_name ' || rec_hol_dt.user_column_name,9999);
68: hr_utility.set_location('************************',9999);
69: end;
70:
71: end loop;
72: v_count := publichol_table.count;