60: open c;
61: fetch c into X_ROWID;
62: if (c%notfound) then
63: close c;
64: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
65: hr_utility.set_message_token('PROCEDURE',
66: 'HR_KI_HIERARCHIES.insert_row');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
61: fetch c into X_ROWID;
62: if (c%notfound) then
63: close c;
64: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
65: hr_utility.set_message_token('PROCEDURE',
66: 'HR_KI_HIERARCHIES.insert_row');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
69: end if;
63: close c;
64: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
65: hr_utility.set_message_token('PROCEDURE',
66: 'HR_KI_HIERARCHIES.insert_row');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
69: end if;
70: close c;
71:
64: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
65: hr_utility.set_message_token('PROCEDURE',
66: 'HR_KI_HIERARCHIES.insert_row');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
69: end if;
70: close c;
71:
72: end INSERT_ROW;