DBA Data[Home] [Help]

APPS.IGS_AD_UNIT_OU_STAT_PKG dependencies on FND_MESSAGE

Line 38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
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;

Line 78: Fnd_Message.Set_Name('IGS', v_message_name);

74: (old_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN
75: IF IGS_AD_VAL_AUOS.admp_val_saos_clsd(
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;

Line 84: Fnd_Message.Set_Name('IGS', 'IGS_AD_SYS_DFLT_IND_NOTSET_CLS');

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');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: -- Validate System admission outcome status unit outcome ind.

Line 94: Fnd_Message.Set_Name('IGS', v_message_name);

90: new_references.s_adm_outcome_status) THEN
91: IF IGS_AD_VAL_AUOS.admp_val_saos_uniout(
92: new_references.s_adm_outcome_status,
93: v_message_name) = FALSE THEN
94: Fnd_Message.Set_Name('IGS', v_message_name);
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;

Line 124: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

120: END IF;
121:
122: IF upper(Column_Name) = 'ADM_UNIT_OUTCOME_STATUS' OR Column_Name IS NULL THEN
123: IF new_references.adm_unit_outcome_status <> UPPER(new_references.adm_unit_outcome_status) 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;

Line 132: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

128: END IF;
129:
130: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
131: IF new_references.closed_ind NOT IN ('Y','N') THEN
132: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;

Line 141: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

137:
138:
139: IF upper(Column_Name) = 'SYSTEM_DEFAULT_IND' OR Column_Name IS NULL THEN
140: IF new_references.system_default_ind NOT IN ('Y','N') THEN
141: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;

Line 149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

145: END IF;
146:
147: IF upper(Column_Name) = 'S_ADM_OUTCOME_STATUS' OR Column_Name IS NULL THEN
148: IF new_references.s_adm_outcome_status <> UPPER(new_references.s_adm_outcome_status) 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: END IF;

Line 167: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

163: ELSE
164: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
165: 'ADM_OUTCOME_STATUS',new_references.s_adm_outcome_status
166: ) THEN
167: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;

Line 229: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUOS_SLV_FK');

225: Open cur_rowid;
226: Fetch cur_rowid INTO lv_rowid;
227: IF (cur_rowid%FOUND) THEN
228: Close cur_rowid;
229: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUOS_SLV_FK');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: Return;
233: END IF;

Line 275: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

271: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
272: IF Get_PK_For_Validation (
273: new_references.adm_unit_outcome_status
274: ) THEN
275: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
276: IGS_GE_MSG_STACK.ADD;
277: App_Exception.Raise_Exception;
278: END IF;
279: Check_Constraints;

Line 294: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

290: ELSIF (p_action = 'VALIDATE_INSERT') THEN
291: IF Get_PK_For_Validation (
292: new_references.adm_unit_outcome_status
293: ) THEN
294: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: Check_Constraints;

Line 345: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

341: if X_LAST_UPDATE_LOGIN is NULL then
342: X_LAST_UPDATE_LOGIN := -1;
343: end if;
344: else
345: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
346: IGS_GE_MSG_STACK.ADD;
347: app_exception.raise_exception;
348: end if;
349: Before_DML (

Line 424: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

420: open c1;
421: fetch c1 into tlinfo;
422: if (c1%notfound) then
423: close c1;
424: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
425: IGS_GE_MSG_STACK.ADD;
426: app_exception.raise_exception;
427: return;
428: end if;

Line 438: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

434: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
435: ) then
436: null;
437: else
438: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
439: IGS_GE_MSG_STACK.ADD;
440: app_exception.raise_exception;
441: end if;
442: return;

Line 472: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

468: if X_LAST_UPDATE_LOGIN is NULL then
469: X_LAST_UPDATE_LOGIN := -1;
470: end if;
471: else
472: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
473: IGS_GE_MSG_STACK.ADD;
474: app_exception.raise_exception;
475: end if;
476: Before_DML (