DBA Data[Home] [Help]

APPS.IGS_AD_LOCATION_PKG dependencies on IGS_OR_VAL_LOC

Line 142: IF IGS_OR_VAL_LOC.orgp_val_loc_type (

138: v_message_name varchar2(30);
139: BEGIN
140: IF p_inserting OR
141: (old_references.location_type <> new_references.location_type) THEN
142: IF IGS_OR_VAL_LOC.orgp_val_loc_type (
143: new_references.location_type,
144: v_message_name) = FALSE THEN
145: Fnd_Message.Set_Name('IGS',v_message_name);
146: IGS_GE_MSG_STACK.ADD;

Line 152: IF IGS_OR_VAL_LOC.assp_val_loc_ve_xist (

148: END IF;
149: END IF;
150: IF p_inserting OR p_updating THEN
151: IF new_references.location_cd <> old_references.location_cd THEN
152: IF IGS_OR_VAL_LOC.assp_val_loc_ve_xist (
153: new_references.location_cd,
154: new_references.location_type,
155: v_message_name) = FALSE THEN
156: Fnd_Message.Set_Name('IGS',v_message_name);

Line 161: IF IGS_OR_VAL_LOC.assp_val_loc_ve_open (

157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161: IF IGS_OR_VAL_LOC.assp_val_loc_ve_open (
162: new_references.location_cd,
163: new_references.location_type,
164: new_references.closed_ind,
165: v_message_name) = FALSE THEN

Line 170: IF IGS_OR_VAL_LOC.assp_val_loc_coord (

166: Fnd_Message.Set_Name('IGS',v_message_name);
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170: IF IGS_OR_VAL_LOC.assp_val_loc_coord (
171: new_references.location_type,
172: new_references.coord_person_id,
173: v_message_name) = FALSE THEN
174: Fnd_Message.Set_Name('IGS',v_message_name);