575: --
576: -- Initialize the message stack
577: --
578: fnd_msg_pub.initialize;
579: fnd_message.set_name('HXC','HXC_NOT_VALID_ASSIGNMENT');
580: fnd_msg_pub.add;
581: else
582: --
583: -- Populate property structure
737: fetch c_period_info into l_period_type, l_duration_in_days, l_start_date;
738:
739: if(c_period_info%NOTFOUND) then
740: close c_period_info;
741: FND_MESSAGE.SET_NAME('HXC','HXC_NO_PERIOD_FOR_PREF');
742: FND_MESSAGE.RAISE_ERROR;
743: end if;
744: close c_period_info;
745:
738:
739: if(c_period_info%NOTFOUND) then
740: close c_period_info;
741: FND_MESSAGE.SET_NAME('HXC','HXC_NO_PERIOD_FOR_PREF');
742: FND_MESSAGE.RAISE_ERROR;
743: end if;
744: close c_period_info;
745:
746: if(l_period_type is not null) then
839: open c_ref_obj(p_alias_definition_id);
840: fetch c_ref_obj into l_reference_object;
841: if(c_ref_obj%notfound) then
842: close c_ref_obj;
843: fnd_message.set_name('HXC','HXC_NO_ALIAS_TYPE');
844: fnd_message.set_token('DEF_ID',to_char(p_alias_definition_id));
845: fnd_message.raise_error;
846: else
847: close c_ref_obj;
840: fetch c_ref_obj into l_reference_object;
841: if(c_ref_obj%notfound) then
842: close c_ref_obj;
843: fnd_message.set_name('HXC','HXC_NO_ALIAS_TYPE');
844: fnd_message.set_token('DEF_ID',to_char(p_alias_definition_id));
845: fnd_message.raise_error;
846: else
847: close c_ref_obj;
848: end if;
841: if(c_ref_obj%notfound) then
842: close c_ref_obj;
843: fnd_message.set_name('HXC','HXC_NO_ALIAS_TYPE');
844: fnd_message.set_token('DEF_ID',to_char(p_alias_definition_id));
845: fnd_message.raise_error;
846: else
847: close c_ref_obj;
848: end if;
849:
1356: fetch c_prop_name into l_property_name;
1357:
1358: if(c_prop_name%notfound) then
1359: close c_prop_name;
1360: fnd_message.set_name('HXC','HXC_UNKNOWN_PROP');
1361: fnd_message.raise_error;
1362: else
1363: close c_prop_name;
1364: end if;
1357:
1358: if(c_prop_name%notfound) then
1359: close c_prop_name;
1360: fnd_message.set_name('HXC','HXC_UNKNOWN_PROP');
1361: fnd_message.raise_error;
1362: else
1363: close c_prop_name;
1364: end if;
1365: else