DBA Data[Home] [Help]

APPS.IGS_AD_FEE_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 79: Fnd_Message.Set_Name('IGS',v_message_name);

75: (old_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN
76: IF IGS_AD_VAL_AFS.admp_val_safs_clsd(
77: new_references.s_adm_fee_status,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: END IF;

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

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

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

114: END IF ;
115:
116: IF upper(Column_name) = 'ADM_FEE_STATUS' OR COLUMN_NAME IS NULL THEN
117: IF new_references.ADM_FEE_STATUS<> upper(new_references.ADM_FEE_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:

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

123: END IF ;
124:
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:

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

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');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception ;
136: END IF;
137:

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

139:
140:
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:

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

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');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception ;
152: END IF;
153:

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

154: END IF ;
155:
156: IF upper(Column_name) = 'S_ADM_FEE_STATUS' OR COLUMN_NAME IS NULL THEN
157: IF new_references.S_ADM_FEE_STATUS<> upper(new_references.S_ADM_FEE_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:

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

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

Line 246: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AFS_SAFS_FK');

242: Open cur_rowid;
243: Fetch cur_rowid INTO lv_rowid;
244: IF (cur_rowid%FOUND) THEN
245: Close cur_rowid;
246: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AFS_SAFS_FK');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: Return;
250: END IF;

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

289:
290: IF Get_PK_For_Validation (
291: new_references.adm_fee_status
292: ) THEN
293: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: Check_Constraints;

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

307:
308: ELSIF (p_action = 'VALIDATE_INSERT') THEN
309: IF Get_PK_For_Validation (
310: new_references.adm_fee_status ) THEN
311: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: Check_Constraints;

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

358: if X_LAST_UPDATE_LOGIN is NULL then
359: X_LAST_UPDATE_LOGIN := -1;
360: end if;
361: else
362: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
363: IGS_GE_MSG_STACK.ADD;
364: app_exception.raise_exception;
365: end if;
366:

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

441: open c1;
442: fetch c1 into tlinfo;
443: if (c1%notfound) then
444: close c1;
445: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
446: IGS_GE_MSG_STACK.ADD;
447: app_exception.raise_exception;
448: return;
449: end if;

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

455: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
456: ) then
457: null;
458: else
459: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
460: IGS_GE_MSG_STACK.ADD;
461: app_exception.raise_exception;
462: end if;
463: return;

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

489: if X_LAST_UPDATE_LOGIN is NULL then
490: X_LAST_UPDATE_LOGIN := -1;
491: end if;
492: else
493: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497: