APPS.IGS_EN_METHOD_TYPE_PKG dependencies on APP_EXCEPTION

Line 41: App_Exception.Raise_Exception;

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

Line 92: App_Exception.Raise_Exception;

88: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN
89: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) THEN
90: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95: IF ((UPPER (column_name) = 'BULK_JOB_IND') OR (column_name IS NULL)) THEN
96: IF new_references.bulk_job_ind NOT IN ( 'Y' , 'N' ) THEN

Line 99: App_Exception.Raise_Exception;

95: IF ((UPPER (column_name) = 'BULK_JOB_IND') OR (column_name IS NULL)) THEN
96: IF new_references.bulk_job_ind NOT IN ( 'Y' , 'N' ) THEN
97: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102:
103: IF ((UPPER (column_name) = 'ENR_METHOD_TYPE') OR (column_name IS NULL)) THEN

Line 107: App_Exception.Raise_Exception;

103: IF ((UPPER (column_name) = 'ENR_METHOD_TYPE') OR (column_name IS NULL)) THEN
104: IF (new_references.enr_method_type <> UPPER (new_references.enr_method_type)) 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) = 'TRANSFER_FLAG') OR (column_name IS NULL)) THEN

Line 115: App_Exception.Raise_Exception;

111: IF ((UPPER (column_name) = 'TRANSFER_FLAG') OR (column_name IS NULL)) THEN
112: IF new_references.transfer_flag NOT IN ( 'Y' , 'N' ) 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: IF ((UPPER (column_name) = 'DFLT_TRANS_DETAILS_FLAG') OR (column_name IS NULL)) THEN

Line 123: App_Exception.Raise_Exception;

119: IF ((UPPER (column_name) = 'DFLT_TRANS_DETAILS_FLAG') OR (column_name IS NULL)) THEN
120: IF new_references.dflt_trans_details_flag NOT IN ( 'Y' , 'N' ) THEN
121: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125: END IF;
126:
127:

Line 213: App_Exception.Raise_Exception;

209: new_references.enr_method_type) THEN
210:
211: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214:
215: END IF;
216:
217: Check_Constraints;

Line 229: App_Exception.Raise_Exception;

225: ELSIF (p_action = 'VALIDATE_INSERT') THEN
226: IF Get_PK_For_Validation ( new_references.enr_method_type) THEN
227: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
228: IGS_GE_MSG_STACK.ADD;
229: App_Exception.Raise_Exception;
230: END IF;
231: Check_Constraints;
232: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
233: Check_Constraints;

Line 296: app_exception.raise_exception;

292: end if;
293: else
294: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
295: IGS_GE_MSG_STACK.ADD;
296: app_exception.raise_exception;
297: end if;
298: Before_DML (
299: p_action =>'INSERT',
300: x_rowid => X_ROWID,

Line 390: app_exception.raise_exception;

386: if (c1%notfound) then
387: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
388: IGS_GE_MSG_STACK.ADD;
389: close c1;
390: app_exception.raise_exception;
391: return;
392: end if;
393: close c1;
394:

Line 415: app_exception.raise_exception;

411: null;
412: else
413: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
414: IGS_GE_MSG_STACK.ADD;
415: app_exception.raise_exception;
416: end if;
417: return;
418: end LOCK_ROW;
419:

Line 452: app_exception.raise_exception;

448: end if;
449: else
450: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
451: IGS_GE_MSG_STACK.ADD;
452: app_exception.raise_exception;
453: end if;
454: Before_DML (
455: p_action =>'UPDATE',
456: x_rowid => X_ROWID,