54: open c;
55: fetch c into X_ROWID;
56: if (c%notfound) then
57: close c;
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE',
60: 'HR_KI_HIERARCHY_NODE_MAPS.insert_row');
61: hr_utility.set_message_token('STEP','1');
62: hr_utility.raise_error;
55: fetch c into X_ROWID;
56: if (c%notfound) then
57: close c;
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE',
60: 'HR_KI_HIERARCHY_NODE_MAPS.insert_row');
61: hr_utility.set_message_token('STEP','1');
62: hr_utility.raise_error;
63: end if;
57: close c;
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE',
60: 'HR_KI_HIERARCHY_NODE_MAPS.insert_row');
61: hr_utility.set_message_token('STEP','1');
62: hr_utility.raise_error;
63: end if;
64: close c;
65:
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE',
60: 'HR_KI_HIERARCHY_NODE_MAPS.insert_row');
61: hr_utility.set_message_token('STEP','1');
62: hr_utility.raise_error;
63: end if;
64: close c;
65:
66: