DBA Data[Home] [Help]

APPS.IGS_UC_DEFAULTS_PKG dependencies on IGS_GE_MSG_STACK

Line 65: igs_ge_msg_stack.add;

61: FETCH cur_old_ref_values INTO old_references;
62: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
63: CLOSE cur_old_ref_values;
64: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
65: igs_ge_msg_stack.add;
66: app_exception.raise_exception;
67: RETURN;
68: END IF;
69: CLOSE cur_old_ref_values;

Line 128: IGS_GE_MSG_STACK.ADD;

124: NULL;
125: ELSE
126: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation ( new_references.obsolete_outcome_status , 'N' ) THEN
127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:

Line 140: IGS_GE_MSG_STACK.ADD;

136: NULL;
137: ELSE
138: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (new_references.pending_outcome_status , 'N' ) THEN
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144:

Line 152: IGS_GE_MSG_STACK.ADD;

148: NULL;
149: ELSE
150: IF NOT IGS_AD_OU_STAT_PKG.Get_PK_For_Validation (new_references.rejected_outcome_status , 'N') THEN
151: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155:
156: END IF;

Line 166: IGS_GE_MSG_STACK.ADD;

162: NULL;
163: ELSE
164: IF NOT IGS_AD_CODE_CLASSES_PKG.Get_PK_For_Validation (new_references.decision_reason_id, 'N' ) THEN
165: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169:
170: END IF;

Line 180: IGS_GE_MSG_STACK.ADD;

176: NULL;
177: ELSE
178: IF NOT IGS_AD_SS_APPL_TYP_PKG.get_pk_for_validation ( new_references.application_type, 'N') THEN
179: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183:
184: END IF;

Line 192: IGS_GE_MSG_STACK.ADD;

188: NULL;
189: ELSE
190: IF NOT IGS_PE_PERSON_ID_TYP_PKG.Get_PK_For_Validation (new_references.ni_number_alt_pers_type ) THEN
191: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195:
196: END IF;

Line 233: IGS_GE_MSG_STACK.ADD;

229: Fetch cur_rowid1 INTO lv_rowid1;
230: IF (cur_rowid1%FOUND) THEN
231: Close cur_rowid1;
232: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_UCDF_FK1');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: Return;
236: END IF;
237: Close cur_rowid1;

Line 244: IGS_GE_MSG_STACK.ADD;

240: Fetch cur_rowid2 INTO lv_rowid2;
241: IF (cur_rowid2%FOUND) THEN
242: Close cur_rowid2;
243: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_UCDF_FK2');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: Return;
247: END IF;
248: Close cur_rowid2;

Line 256: IGS_GE_MSG_STACK.ADD;

252: Fetch cur_rowid3 INTO lv_rowid3;
253: IF (cur_rowid3%FOUND) THEN
254: Close cur_rowid3;
255: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_UCDF_FK3');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
260: Close cur_rowid3;

Line 284: IGS_GE_MSG_STACK.ADD;

280: Fetch cur_rowid INTO lv_rowid;
281: IF (cur_rowid%FOUND) THEN
282: Close cur_rowid;
283: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ADCC_UCDF_FK');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: Return;
287: END IF;
288: Close cur_rowid;

Line 311: IGS_GE_MSG_STACK.ADD;

307: Fetch cur_rowid INTO lv_rowid;
308: IF (cur_rowid%FOUND) THEN
309: Close cur_rowid;
310: Fnd_Message.Set_Name ('IGS', 'IGS_UC_UCDF_SSAT_FK');
311: IGS_GE_MSG_STACK.ADD;
312: App_Exception.Raise_Exception;
313: Return;
314: END IF;
315: Close cur_rowid;

Line 434: igs_ge_msg_stack.add;

430: new_references.system_code
431: )
432: ) THEN
433: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437: Check_Parent_Existance;
438:

Line 445: igs_ge_msg_stack.add;

441: new_references.system_code
442: )
443: ) THEN
444: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
445: igs_ge_msg_stack.add;
446: app_exception.raise_exception;
447: END IF;
448:
449: END IF;

Line 515: igs_ge_msg_stack.add;

511: x_last_update_login := -1;
512: END IF;
513: ELSE
514: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518:
519: before_dml(

Line 685: igs_ge_msg_stack.add;

681: OPEN c1;
682: FETCH c1 INTO tlinfo;
683: IF (c1%notfound) THEN
684: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
685: igs_ge_msg_stack.add;
686: CLOSE c1;
687: app_exception.raise_exception;
688: RETURN;
689: END IF;

Line 719: igs_ge_msg_stack.add;

715:
716: NULL;
717: ELSE
718: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
719: igs_ge_msg_stack.add;
720: app_exception.raise_exception;
721: END IF;
722:
723: RETURN;

Line 785: igs_ge_msg_stack.add;

781: x_last_update_login := -1;
782: END IF;
783: ELSE
784: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
785: igs_ge_msg_stack.add;
786: app_exception.raise_exception;
787: END IF;
788:
789: before_dml(