DBA Data[Home] [Help]

APPS.PER_ZA_ABS_DURATION dependencies on HR_UTILITY

Line 59: hr_utility.set_location('************************',9999);

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);

Line 60: hr_utility.trace(substr(SQLERRM,1,254));

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);

Line 61: hr_utility.trace('SQLCODE' || SQLCODE);

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);

Line 62: hr_utility.set_location('Count of wrong record ' || l_count,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);

Line 63: hr_utility.set_location('rec_value.value ' || rec_hol_dt.value,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);

Line 64: hr_utility.set_location('user_column_instance_id ' || rec_hol_dt.user_column_instance_id,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);

Line 65: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_start_date,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;

Line 66: hr_utility.set_location('Effective_End_date ' || rec_hol_dt.effective_end_date,9999);

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:

Line 67: hr_utility.set_location('user_column_name ' || rec_hol_dt.user_column_name,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:
71: end loop;

Line 68: hr_utility.set_location('************************',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;
72: v_count := publichol_table.count;