DBA Data[Home] [Help]

APPS.IGS_RU_NAMED_RULE_GR_PKG dependencies on APP_EXCEPTION

Line 53: App_Exception.Raise_Exception;

49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION INSERT, VALIDATE_INSERT : IGSUI17B.PLS');
52: IGS_GE_MSG_STACK.ADD;
53: App_Exception.Raise_Exception;
54: Return;
55: END IF;
56: Close cur_old_ref_values;
57:

Line 115: App_Exception.Raise_Exception;

111: IF NOT (new_references.select_group BETWEEN 1
112: AND 999999) THEN
113: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118:
119: -- The following code checks for check constraints on the Columns.

Line 126: App_Exception.Raise_Exception;

122: IF NOT (new_references.message_group BETWEEN 1
123: AND 999999) THEN
124: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: END IF;
129:
130: -- The following code checks for check constraints on the Columns.

Line 137: App_Exception.Raise_Exception;

133: IF NOT (new_references.rug_sequence_number BETWEEN 1
134: AND 999999) THEN
135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
140:
141:

Line 168: App_Exception.Raise_Exception;

164: ) THEN
165: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
166: IGS_RU_GEN_006.SET_TOKEN('Igs_Ru_Ret_Type : P_ACTION Check_Parent_Existance s_return_type : IGSUI17B.PLS');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170:
171: IF (((old_references.group_cd = new_references.group_cd)) OR
172: ((new_references.group_cd IS NULL))) THEN

Line 180: App_Exception.Raise_Exception;

176: ) THEN
177: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
178: IGS_RU_GEN_006.SET_TOKEN('Igs_Ru_Nrg_Group : P_ACTION Check_Parent_Existance group_cd : IGSUI17B.PLS');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182:
183: IF (((old_references.message_group = new_references.message_group)) OR
184: ((new_references.message_group IS NULL))) THEN

Line 192: App_Exception.Raise_Exception;

188: ) THEN
189: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
190: IGS_RU_GEN_006.SET_TOKEN('Igs_Ru_Group : P_ACTION Check_Parent_Existance message_group : IGSUI17B.PLS');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: END IF;
194:
195: IF (((old_references.rug_sequence_number = new_references.rug_sequence_number)) OR
196: ((new_references.rug_sequence_number IS NULL))) THEN

Line 204: App_Exception.Raise_Exception;

200: ) THEN
201: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
202: IGS_RU_GEN_006.SET_TOKEN('Igs_Ru_Group : P_ACTION Check_Parent_Existance rug_sequence_number : IGSUI17B.PLS');
203: IGS_GE_MSG_STACK.ADD;
204: App_Exception.Raise_Exception;
205: END IF;
206:
207: IF (((old_references.select_group = new_references.select_group)) OR
208: ((new_references.select_group IS NULL))) THEN

Line 216: App_Exception.Raise_Exception;

212: ) THEN
213: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
214: IGS_RU_GEN_006.SET_TOKEN('Igs_Ru_Group : P_ACTION Check_Parent_Existance select_group : IGSUI17B.PLS');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218:
219: END Check_Parent_Existance;
220:

Line 289: App_Exception.Raise_Exception;

285: IF (cur_rowid%FOUND) THEN
286: Close cur_rowid;
287: Fnd_Message.Set_Name ('IGS', 'IGS_RU_NRG_SRRT_FK');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: Return;
291: END IF;
292: Close cur_rowid;
293:

Line 326: App_Exception.Raise_Exception;

322: IF (cur_rowid%FOUND) THEN
323: Close cur_rowid;
324: Fnd_Message.Set_Name ('IGS', 'IGS_RU_NRG_NGC_FK');
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: Return;
328: END IF;
329: Close cur_rowid;
330:

Line 363: App_Exception.Raise_Exception;

359: IF (cur_rowid%FOUND) THEN
360: Close cur_rowid;
361: Fnd_Message.Set_Name ('IGS', 'IGS_RU_NRG_MG_RUG_FK');
362: IGS_GE_MSG_STACK.ADD;
363: App_Exception.Raise_Exception;
364: Return;
365: END IF;
366: Close cur_rowid;
367:

Line 400: App_Exception.Raise_Exception;

396: IF (cur_rowid%FOUND) THEN
397: Close cur_rowid;
398: Fnd_Message.Set_Name ('IGS', 'IGS_RU_NRG_MG_RUG_FK');
399: IGS_GE_MSG_STACK.ADD;
400: App_Exception.Raise_Exception;
401: Return;
402: END IF;
403: Close cur_rowid;
404:

Line 437: App_Exception.Raise_Exception;

433: IF (cur_rowid%FOUND) THEN
434: Close cur_rowid;
435: Fnd_Message.Set_Name ('IGS', 'IGS_RU_NRG_MG_RUG_FK');
436: IGS_GE_MSG_STACK.ADD;
437: App_Exception.Raise_Exception;
438: Return;
439: END IF;
440: Close cur_rowid;
441:

Line 499: App_Exception.Raise_Exception;

495: new_references.group_cd,
496: new_references.name_cd) THEN
497: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
498: IGS_GE_MSG_STACK.ADD;
499: App_Exception.Raise_Exception;
500: END IF;
501: Check_Constraints;
502: Check_Parent_Existance;
503: ELSIF (p_action = 'UPDATE') THEN

Line 518: App_Exception.Raise_Exception;

514: new_references.group_cd,
515: new_references.name_cd) THEN
516: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
517: IGS_GE_MSG_STACK.ADD;
518: App_Exception.Raise_Exception;
519: END IF;
520: Check_Constraints;
521: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
522: Check_Constraints;

Line 609: app_exception.raise_exception;

605: end if;
606: else
607: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
608: IGS_GE_MSG_STACK.ADD;
609: app_exception.raise_exception;
610: end if;
611: Before_DML(
612: p_action=>'INSERT',
613: x_rowid=>X_ROWID,

Line 703: app_exception.raise_exception;

699: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
700: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION LOCK_ROW : IGSUI17B.PLS');
701: IGS_GE_MSG_STACK.ADD;
702: close c1;
703: app_exception.raise_exception;
704: return;
705: end if;
706: close c1;
707: if ( ( tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 720: app_exception.raise_exception;

716: else
717: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
718: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_NAMED_RULE_GR : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI17B.PLS');
719: IGS_GE_MSG_STACK.ADD;
720: app_exception.raise_exception;
721: end if;
722: return;
723: end LOCK_ROW;
724: Procedure UPDATE_ROW (

Line 767: app_exception.raise_exception;

763: end if;
764: else
765: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
766: IGS_GE_MSG_STACK.ADD;
767: app_exception.raise_exception;
768: end if;
769: Before_DML(
770: p_action=>'UPDATE',
771: x_rowid=>X_ROWID,