DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_VER_RU_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: Close cur_old_ref_values;
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Return;
40: END IF;
41: Close cur_old_ref_values;
42:

Line 76: App_Exception.Raise_Exception;

72: new_references.version_number,
73: v_message_name) = FALSE THEN
74: Fnd_Message.Set_Name('IGS',v_message_name);
75: IGS_GE_MSG_STACK.ADD;
76: App_Exception.Raise_Exception;
77: END IF;
78: ELSE
79: IF IGS_PS_VAL_UNIT.crsp_val_iud_uv_dtl(
80: old_references.unit_cd,

Line 85: App_Exception.Raise_Exception;

81: old_references.version_number,
82: v_message_name) = FALSE THEN
83: Fnd_Message.Set_Name('IGS',v_message_name);
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;
88: -- Validate IGS_PS_COURSE Stage IGS_RU_RULE
89: IF p_inserting OR p_updating THEN

Line 101: App_Exception.Raise_Exception;

97: new_references.rul_sequence_number,
98: v_message_name) = FALSE THEN
99: Fnd_Message.Set_Name('IGS',v_message_name);
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:
105: END BeforeRowInsertUpdateDelete1;

Line 125: App_Exception.Raise_Exception;

121: IF Upper(Column_Name)='S_RULE_CALL_CD' OR Column_Name IS NULL Then
122: IF New_References.s_rule_call_cd <> UPPER(New_References.s_rule_call_cd) Then
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then

Line 133: App_Exception.Raise_Exception;

129: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
130: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
131: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: END Check_Constraints;

Line 150: App_Exception.Raise_Exception;

146: IF NOT IGS_RU_RULE_PKG.Get_PK_For_Validation (
147: new_references.rul_sequence_number) THEN
148: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152:
153:
154: END IF;

Line 164: App_Exception.Raise_Exception;

160: IF NOT IGS_RU_CALL_PKG.Get_PK_For_Validation (
161: new_references.s_rule_call_cd) THEN
162: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166:
167:
168: END IF;

Line 181: App_Exception.Raise_Exception;

177: new_references.unit_cd,
178: new_references.version_number) 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:
185: END IF;

Line 238: App_Exception.Raise_Exception;

234: IF (cur_rowid%FOUND) THEN
235: Close cur_rowid;
236: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVR_RUL_FK');
237: IGS_GE_MSG_STACK.ADD;
238: App_Exception.Raise_Exception;
239: Return;
240: END IF;
241: Close cur_rowid;
242:

Line 264: App_Exception.Raise_Exception;

260: IF (cur_rowid%FOUND) THEN
261: Close cur_rowid;
262: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVR_SRC_FK');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: Return;
266: END IF;
267: Close cur_rowid;
268:

Line 292: App_Exception.Raise_Exception;

288: IF (cur_rowid%FOUND) THEN
289: Close cur_rowid;
290: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UVR_UV_FK');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: Return;
294: END IF;
295: Close cur_rowid;
296:

Line 336: App_Exception.Raise_Exception;

332: New_References.version_number,
333: New_References.s_rule_call_cd) THEN
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: Check_Constraints;
339: Check_Parent_Existance;
340: ELSIF (p_action = 'UPDATE') THEN

Line 354: App_Exception.Raise_Exception;

350: New_References.version_number,
351: New_References.s_rule_call_cd) 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: Check_Constraints;
357: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
358: Check_Constraints;

Line 407: app_exception.raise_exception;

403: end if;
404: else
405: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
406: IGS_GE_MSG_STACK.ADD;
407: app_exception.raise_exception;
408: end if;
409:
410: Before_DML(
411: p_action => 'INSERT',

Line 480: app_exception.raise_exception;

476: if (c1%notfound) then
477: close c1;
478: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
479: IGS_GE_MSG_STACK.ADD;
480: app_exception.raise_exception;
481: return;
482: end if;
483: close c1;
484:

Line 491: app_exception.raise_exception;

487: null;
488: else
489: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
490: IGS_GE_MSG_STACK.ADD;
491: app_exception.raise_exception;
492: end if;
493: return;
494: end LOCK_ROW;
495:

Line 524: app_exception.raise_exception;

520: end if;
521: else
522: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
523: IGS_GE_MSG_STACK.ADD;
524: app_exception.raise_exception;
525: end if;
526:
527: Before_DML(
528: p_action => 'UPDATE',