1156: if(C_Sel2 % NOTFOUND) then
1157: l_approver := 'Invalid approver';
1158: end if;
1159: close C_Sel2;
1160: fnd_message.set_name('PER', 'AME_400616_SUB_ACT_DESC');
1161: fnd_message.set_token('APPROVER', l_approver);
1162: l_description := fnd_message.get;
1163: end if;
1164: -- insert the row in ame_actions
1157: l_approver := 'Invalid approver';
1158: end if;
1159: close C_Sel2;
1160: fnd_message.set_name('PER', 'AME_400616_SUB_ACT_DESC');
1161: fnd_message.set_token('APPROVER', l_approver);
1162: l_description := fnd_message.get;
1163: end if;
1164: -- insert the row in ame_actions
1165: ame_act_ins.ins(p_effective_date => l_effective_date,
1158: end if;
1159: close C_Sel2;
1160: fnd_message.set_name('PER', 'AME_400616_SUB_ACT_DESC');
1161: fnd_message.set_token('APPROVER', l_approver);
1162: l_description := fnd_message.get;
1163: end if;
1164: -- insert the row in ame_actions
1165: ame_act_ins.ins(p_effective_date => l_effective_date,
1166: p_action_type_id => p_action_type_id,
1591: if(C_Sel2 % NOTFOUND) then
1592: l_approver := 'Invalid approver';
1593: end if;
1594: close C_Sel2;
1595: fnd_message.set_name('PER', 'AME_400616_SUB_ACT_DESC');
1596: fnd_message.set_token('APPROVER', l_approver);
1597: l_description := fnd_message.get;
1598: end if;
1599: ame_act_upd.upd(p_effective_date => l_effective_date,
1592: l_approver := 'Invalid approver';
1593: end if;
1594: close C_Sel2;
1595: fnd_message.set_name('PER', 'AME_400616_SUB_ACT_DESC');
1596: fnd_message.set_token('APPROVER', l_approver);
1597: l_description := fnd_message.get;
1598: end if;
1599: ame_act_upd.upd(p_effective_date => l_effective_date,
1600: p_datetrack_mode => hr_api.g_update,
1593: end if;
1594: close C_Sel2;
1595: fnd_message.set_name('PER', 'AME_400616_SUB_ACT_DESC');
1596: fnd_message.set_token('APPROVER', l_approver);
1597: l_description := fnd_message.get;
1598: end if;
1599: ame_act_upd.upd(p_effective_date => l_effective_date,
1600: p_datetrack_mode => hr_api.g_update,
1601: p_action_id => p_action_id,
1788: p_effective_date => l_effective_date);
1789: Fetch action_type_conf_cur into l_config_count;
1790: Close action_type_conf_cur;
1791: if(l_config_count <> 0) then
1792: fnd_message.set_name('PER', 'AME_400608_ACT_TYP_CONF_EXISTS');
1793: fnd_message.raise_error;
1794: end if;
1795: open rule_usage_cur(p_action_type_id => p_action_type_id,
1796: p_effective_date => l_effective_date);
1789: Fetch action_type_conf_cur into l_config_count;
1790: Close action_type_conf_cur;
1791: if(l_config_count <> 0) then
1792: fnd_message.set_name('PER', 'AME_400608_ACT_TYP_CONF_EXISTS');
1793: fnd_message.raise_error;
1794: end if;
1795: open rule_usage_cur(p_action_type_id => p_action_type_id,
1796: p_effective_date => l_effective_date);
1797: fetch rule_usage_cur into l_rule_usage_count;
1796: p_effective_date => l_effective_date);
1797: fetch rule_usage_cur into l_rule_usage_count;
1798: close rule_usage_cur;
1799: if(l_rule_usage_count <> 0) then
1800: fnd_message.set_name('PER', 'AME_400609_ACT_USG_EXISTS');
1801: fnd_message.raise_error;
1802: end if;
1803: -- Remove action type usages
1804: Open action_type_usage_cur(p_action_type_id => p_action_type_id,
1797: fetch rule_usage_cur into l_rule_usage_count;
1798: close rule_usage_cur;
1799: if(l_rule_usage_count <> 0) then
1800: fnd_message.set_name('PER', 'AME_400609_ACT_USG_EXISTS');
1801: fnd_message.raise_error;
1802: end if;
1803: -- Remove action type usages
1804: Open action_type_usage_cur(p_action_type_id => p_action_type_id,
1805: p_effective_date => l_effective_date);