APPS.IGS_AV_STND_CONF_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: Igs_Ge_Msg_Stack.Add;
38: Close cur_old_ref_values;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
42: Close cur_old_ref_values;
43:

Line 88: App_Exception.Raise_Exception;

84: IF new_references.EXPIRY_DT_INCREMENT < 1 OR
85: new_references.EXPIRY_DT_INCREMENT > 99 Then
86: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
87: Igs_Ge_Msg_Stack.Add;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91:
92: IF upper(column_name) = 'S_CONTROL_NUM' OR

Line 98: App_Exception.Raise_Exception;

94: IF new_references.S_CONTROL_NUM < 1 OR
95: new_references.S_CONTROL_NUM > 1 Then
96: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
97: Igs_Ge_Msg_Stack.Add;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101:
102: IF upper(column_name) = 'ADV_STND_EXPIRY_DT_ALIAS' OR

Line 107: App_Exception.Raise_Exception;

103: column_name is null Then
104: IF new_references.ADV_STND_EXPIRY_DT_ALIAS <> UPPER(new_references.ADV_STND_EXPIRY_DT_ALIAS) Then
105: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
106: Igs_Ge_Msg_Stack.Add;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:
111: IF upper(column_name) = 'ADV_STND_BASIS_INST' OR

Line 116: App_Exception.Raise_Exception;

112: column_name is null Then
113: IF new_references.ADV_STND_BASIS_INST <> UPPER(new_references.ADV_STND_BASIS_INST) Then
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
115: Igs_Ge_Msg_Stack.Add;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119:
120: END Check_Constraints;

Line 188: App_Exception.Raise_Exception;

184: IF Get_PK_For_Validation (new_references.s_control_num )
185: THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
187: Igs_Ge_Msg_Stack.Add;
188: App_Exception.Raise_Exception;
189: END IF;
190: Check_Constraints ;
191: --*
192: ELSIF (p_action = 'UPDATE') THEN

Line 204: App_Exception.Raise_Exception;

200: ELSIF (p_action = 'VALIDATE_INSERT') THEN
201: IF Get_PK_For_Validation (new_references.s_control_num ) THEN
202: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
203: Igs_Ge_Msg_Stack.Add;
204: App_Exception.Raise_Exception;
205: END IF;
206: Check_Constraints;
207: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
208: Check_Constraints;

Line 246: app_exception.raise_exception;

242: end if;
243: else
244: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
245: Igs_Ge_Msg_Stack.Add;
246: app_exception.raise_exception;
247: end if;
248:
249: Before_DML(
250: p_action=>'INSERT',

Line 321: app_exception.raise_exception;

317: if (c1%notfound) then
318: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
319: Igs_Ge_Msg_Stack.Add;
320: close c1;
321: app_exception.raise_exception;
322: return;
323: end if;
324: close c1;
325:

Line 338: app_exception.raise_exception;

334: null;
335: else
336: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
337: Igs_Ge_Msg_Stack.Add;
338: app_exception.raise_exception;
339: end if;
340: return;
341: end LOCK_ROW;
342:

Line 371: app_exception.raise_exception;

367: end if;
368: else
369: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
370: Igs_Ge_Msg_Stack.Add;
371: app_exception.raise_exception;
372: end if;
373:
374: Before_DML(
375: p_action=>'UPDATE',