DBA Data[Home] [Help]

APPS.IGS_AD_OU_STAT_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 80: App_Exception.Raise_Exception;

76: new_references.s_adm_outcome_status,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS',v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
84: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');

Line 86: App_Exception.Raise_Exception;

82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
84: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END BeforeRowInsertUpdate1;
89:
90:

Line 120: App_Exception.Raise_Exception ;

116: IF upper(Column_name) = 'ADM_OUTCOME_STATUS' OR COLUMN_NAME IS NULL THEN
117: IF new_references.ADM_OUTCOME_STATUS<> upper(new_references.ADM_OUTCOME_STATUS) then
118: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception ;
121: END IF;
122:
123: END IF ;
124:

Line 129: App_Exception.Raise_Exception ;

125: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
126: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131:
132: IF new_references.CLOSED_IND not in ('Y','N') then
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 135: App_Exception.Raise_Exception ;

131:
132: IF new_references.CLOSED_IND not in ('Y','N') then
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception ;
136: END IF;
137:
138: END IF ;
139:

Line 145: App_Exception.Raise_Exception ;

141: IF upper(Column_name) = 'SYSTEM_DEFAULT_IND' OR COLUMN_NAME IS NULL THEN
142: IF new_references.SYSTEM_DEFAULT_IND<> upper(new_references.SYSTEM_DEFAULT_IND) then
143: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception ;
146: END IF;
147:
148: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then
149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 151: App_Exception.Raise_Exception ;

147:
148: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then
149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception ;
152: END IF;
153:
154: END IF ;
155:

Line 160: App_Exception.Raise_Exception ;

156: IF upper(Column_name) = 'S_ADM_OUTCOME_STATUS' OR COLUMN_NAME IS NULL THEN
157: IF new_references.S_ADM_OUTCOME_STATUS<> upper(new_references.S_ADM_OUTCOME_STATUS) then
158: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception ;
161: END IF;
162:
163: END IF ;
164:

Line 180: App_Exception.Raise_Exception;

176: 'ADM_OUTCOME_STATUS', new_references.s_adm_outcome_status
177: ) THEN
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:
184:

Line 254: App_Exception.Raise_Exception;

250: IF (cur_rowid%FOUND) THEN
251: Close cur_rowid;
252: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_SLV_FK');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: Return;
256: END IF;
257: Close cur_rowid;
258:

Line 300: App_Exception.Raise_Exception;

296: IF Get_PK_For_Validation (
297: new_references.adm_outcome_status ) THEN
298: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: END IF;
302: Check_Constraints;
303: Check_Parent_Existance;
304: ELSIF (p_action = 'UPDATE') THEN

Line 318: App_Exception.Raise_Exception;

314: new_references.adm_outcome_status
315: ) THEN
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: Check_Constraints;
321: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
322: Check_Constraints;

Line 370: app_exception.raise_exception;

366: end if;
367: else
368: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
369: IGS_GE_MSG_STACK.ADD;
370: app_exception.raise_exception;
371: end if;
372:
373: Before_DML(
374: p_action=>'INSERT' ,

Line 453: app_exception.raise_exception;

449: if (c1%notfound) then
450: close c1;
451: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
452: IGS_GE_MSG_STACK.ADD;
453: app_exception.raise_exception;
454: return;
455: end if;
456: close c1;
457:

Line 467: app_exception.raise_exception;

463: null;
464: else
465: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469: return;
470: end LOCK_ROW;
471:

Line 501: app_exception.raise_exception;

497: end if;
498: else
499: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
500: IGS_GE_MSG_STACK.ADD;
501: app_exception.raise_exception;
502: end if;
503:
504:
505: Before_DML(