DBA Data[Home] [Help]

APPS.IGS_AD_APPL_STAT_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

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

Line 85: IGS_GE_MSG_STACK.ADD;

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

Line 91: IGS_GE_MSG_STACK.ADD;

87: END IF;
88: END IF;
89: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
90: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END BeforeRowInsertUpdate1;
95:

Line 118: IGS_GE_MSG_STACK.ADD;

114:
115: IF upper(column_name) = 'ADM_APPL_STATUS' OR column_name is null Then
116: IF new_references.adm_appl_status <> UPPER(new_references.adm_appl_status ) Then
117: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;
122: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then

Line 125: IGS_GE_MSG_STACK.ADD;

121: END IF;
122: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
123: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) 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;
129: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then

Line 132: IGS_GE_MSG_STACK.ADD;

128: END IF;
129: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then
130: IF new_references.system_default_ind NOT IN ( 'Y' , 'N' ) 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:

Line 142: IGS_GE_MSG_STACK.ADD;

138:
139: IF new_references.s_adm_appl_status <> UPPER(new_references.s_adm_appl_status ) Then
140:
141: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144:
145: END IF;
146: END IF;

Line 160: IGS_GE_MSG_STACK.ADD;

156: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
157: 'ADM_APPL_STATUS',
158: new_references.s_adm_appl_status ) THEN
159: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: END IF;
164:

Line 217: IGS_GE_MSG_STACK.ADD;

213: Fetch cur_rowid INTO lv_rowid;
214: IF (cur_rowid%FOUND) THEN
215: Close cur_rowid;
216: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAS_SLV_FK');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: Return;
220: END IF;
221: Close cur_rowid;

Line 262: IGS_GE_MSG_STACK.ADD;

258: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
259: IF Get_PK_For_Validation (
260: new_references.adm_appl_status ) THEN
261: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: Check_Constraints;
266: Check_Parent_Existance;

Line 279: IGS_GE_MSG_STACK.ADD;

275: ELSIF (p_action = 'VALIDATE_INSERT') THEN
276: IF Get_PK_For_Validation (
277: new_references.adm_appl_status ) THEN
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: Check_Constraints;
283: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 338: IGS_GE_MSG_STACK.ADD;

334: X_LAST_UPDATE_LOGIN := -1;
335: end if;
336: else
337: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
338: IGS_GE_MSG_STACK.ADD;
339: app_exception.raise_exception;
340: end if;
341:
342: Before_DML(

Line 417: IGS_GE_MSG_STACK.ADD;

413: open c1;
414: fetch c1 into tlinfo;
415: if (c1%notfound) then
416: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: close c1;
420: return;
421: end if;

Line 432: IGS_GE_MSG_STACK.ADD;

428: ) then
429: null;
430: else
431: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
432: IGS_GE_MSG_STACK.ADD;
433: app_exception.raise_exception;
434: end if;
435: return;
436: end LOCK_ROW;

Line 466: IGS_GE_MSG_STACK.ADD;

462: X_LAST_UPDATE_LOGIN := -1;
463: end if;
464: else
465: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469:
470: Before_DML(