DBA Data[Home] [Help]

APPS.IGS_AS_CAL_CONF_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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

Line 82: App_Exception.Raise_Exception;

78: new_references.ass_item_cutoff_dt_alias,
79: v_message_name) = FALSE THEN
80: Fnd_Message.Set_Name('IGS', v_message_name);
81: Igs_Ge_Msg_Stack.Add;
82: App_Exception.Raise_Exception;
83: END IF;
84: END IF;
85:
86: IF p_inserting OR

Line 95: App_Exception.Raise_Exception;

91: new_references.mid_mgs_start_dt_alias,
92: v_message_name) = FALSE THEN
93: Fnd_Message.Set_Name('IGS', v_message_name);
94: Igs_Ge_Msg_Stack.Add;
95: App_Exception.Raise_Exception;
96: END IF;
97: END IF;
98:
99: IF p_inserting OR

Line 108: App_Exception.Raise_Exception;

104: new_references.mid_mgs_end_dt_alias,
105: v_message_name) = FALSE THEN
106: Fnd_Message.Set_Name('IGS', v_message_name);
107: Igs_Ge_Msg_Stack.Add;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111:
112: IF p_inserting OR

Line 121: App_Exception.Raise_Exception;

117: new_references.efinal_mgs_start_dt_alias,
118: v_message_name) = FALSE THEN
119: Fnd_Message.Set_Name('IGS', v_message_name);
120: Igs_Ge_Msg_Stack.Add;
121: App_Exception.Raise_Exception;
122: END IF;
123: END IF;
124:
125: IF p_inserting OR

Line 134: App_Exception.Raise_Exception;

130: new_references.efinal_mgs_end_dt_alias,
131: v_message_name) = FALSE THEN
132: Fnd_Message.Set_Name('IGS', v_message_name);
133: Igs_Ge_Msg_Stack.Add;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137:
138: IF p_inserting OR

Line 147: App_Exception.Raise_Exception;

143: new_references.final_mgs_start_dt_alias,
144: v_message_name) = FALSE THEN
145: Fnd_Message.Set_Name('IGS', v_message_name);
146: Igs_Ge_Msg_Stack.Add;
147: App_Exception.Raise_Exception;
148: END IF;
149: END IF;
150:
151: IF p_inserting OR

Line 160: App_Exception.Raise_Exception;

156: new_references.final_mgs_end_dt_alias,
157: v_message_name) = FALSE THEN
158: Fnd_Message.Set_Name('IGS', v_message_name);
159: Igs_Ge_Msg_Stack.Add;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
163:
164:

Line 179: App_Exception.Raise_Exception;

175: new_references.ass_item_cutoff_dt_alias
176: ))THEN
177: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
178: Igs_Ge_Msg_Stack.Add;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;
182: END Check_Parent_Existance;
183: PROCEDURE Check_Constraints (

Line 201: App_Exception.Raise_Exception;

197: column_name is null Then
198: IF new_references.s_control_num < 1 AND new_references.s_control_num > 1 Then
199: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
200: Igs_Ge_Msg_Stack.Add;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
204: IF upper(column_name) = 'ASS_ITEM_CUTOFF_DT_ALIAS' OR
205: column_name is null Then

Line 209: App_Exception.Raise_Exception;

205: column_name is null Then
206: IF new_references.ass_item_cutoff_dt_alias <> UPPER(new_references.ass_item_cutoff_dt_alias) Then
207: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
208: Igs_Ge_Msg_Stack.Add;
209: App_Exception.Raise_Exception;
210: END IF;
211: END IF;
212:
213: IF upper(column_name) = 'MID_MGS_START_DT_ALIAS' OR

Line 218: App_Exception.Raise_Exception;

214: column_name is null Then
215: IF new_references.mid_mgs_start_dt_alias <> UPPER(new_references.mid_mgs_start_dt_alias) Then
216: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
217: Igs_Ge_Msg_Stack.Add;
218: App_Exception.Raise_Exception;
219: END IF;
220: END IF;
221:
222: IF upper(column_name) = 'MID_MGS_END_DT_ALIAS' OR

Line 227: App_Exception.Raise_Exception;

223: column_name is null Then
224: IF new_references.mid_mgs_end_dt_alias <> UPPER(new_references.mid_mgs_end_dt_alias) Then
225: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
226: Igs_Ge_Msg_Stack.Add;
227: App_Exception.Raise_Exception;
228: END IF;
229: END IF;
230:
231: IF upper(column_name) = 'EFINAL_MGS_START_DT_ALIAS' OR

Line 236: App_Exception.Raise_Exception;

232: column_name is null Then
233: IF new_references.efinal_mgs_start_dt_alias <> UPPER(new_references.efinal_mgs_start_dt_alias) Then
234: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
235: Igs_Ge_Msg_Stack.Add;
236: App_Exception.Raise_Exception;
237: END IF;
238: END IF;
239:
240: IF upper(column_name) = 'EFINAL_MGS_END_DT_ALIAS' OR

Line 245: App_Exception.Raise_Exception;

241: column_name is null Then
242: IF new_references.efinal_mgs_end_dt_alias <> UPPER(new_references.efinal_mgs_end_dt_alias) Then
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
244: Igs_Ge_Msg_Stack.Add;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248:
249: IF upper(column_name) = 'FINAL_MGS_START_DT_ALIAS' OR

Line 254: App_Exception.Raise_Exception;

250: column_name is null Then
251: IF new_references.final_mgs_start_dt_alias <> UPPER(new_references.final_mgs_start_dt_alias) Then
252: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
253: Igs_Ge_Msg_Stack.Add;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257:
258: IF upper(column_name) = 'FINAL_MGS_END_DT_ALIAS' OR

Line 263: App_Exception.Raise_Exception;

259: column_name is null Then
260: IF new_references.final_mgs_end_dt_alias <> UPPER(new_references.final_mgs_end_dt_alias) Then
261: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
262: Igs_Ge_Msg_Stack.Add;
263: App_Exception.Raise_Exception;
264: END IF;
265: END IF;
266:
267: END Check_Constraints;

Line 306: App_Exception.Raise_Exception;

302: IF (cur_rowid%FOUND) THEN
303: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SACC_DA_ASS_ITEM_FK');
304: Igs_Ge_Msg_Stack.Add;
305: Close cur_rowid;
306: App_Exception.Raise_Exception;
307: Return;
308: END IF;
309: Close cur_rowid;
310: END GET_FK_IGS_CA_DA;

Line 354: App_Exception.Raise_Exception;

350: new_references.s_control_num
351: ) THEN
352: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
353: Igs_Ge_Msg_Stack.Add;
354: App_Exception.Raise_Exception;
355: END IF;
356:
357: Check_Constraints;
358: Check_Parent_Existance;

Line 373: App_Exception.Raise_Exception;

369: new_references.s_control_num
370: ) THEN
371: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
372: Igs_Ge_Msg_Stack.Add;
373: App_Exception.Raise_Exception;
374: END IF;
375: Check_Constraints;
376: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
377: Check_Constraints;

Line 416: app_exception.raise_exception;

412: end if;
413: else
414: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
415: Igs_Ge_Msg_Stack.Add;
416: app_exception.raise_exception;
417: end if;
418: Before_DML(
419: p_action=>'INSERT',
420: x_rowid=>X_ROWID,

Line 501: app_exception.raise_exception;

497: if (c1%notfound) then
498: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
499: Igs_Ge_Msg_Stack.Add;
500: close c1;
501: app_exception.raise_exception;
502: return;
503: end if;
504: close c1;
505: if (

Line 518: app_exception.raise_exception;

514: null;
515: else
516: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
517: Igs_Ge_Msg_Stack.Add;
518: app_exception.raise_exception;
519: end if;
520: return;
521: end LOCK_ROW;
522: procedure UPDATE_ROW (

Line 554: app_exception.raise_exception;

550: end if;
551: else
552: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
553: Igs_Ge_Msg_Stack.Add;
554: app_exception.raise_exception;
555: end if;
556: Before_DML(
557: p_action=>'UPDATE',
558: x_rowid=>X_ROWID,