APPS.IGS_ST_CITIZENSHP_CD_PKG dependencies on IGS_GE_MSG_STACK

Line 39: IGS_GE_MSG_STACK.ADD;

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;
43: Close cur_old_ref_values;

Line 79: IGS_GE_MSG_STACK.ADD;

75: IF IGS_EN_VAL_CIC.enrp_val_cic_govt (
76: new_references.govt_citizenship_cd,
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:

Line 105: IGS_GE_MSG_STACK.ADD;

101:
102: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
103: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
104: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception ;
107: END IF;
108:
109: IF new_references.CLOSED_IND not in ('Y','N') then

Line 111: IGS_GE_MSG_STACK.ADD;

107: END IF;
108:
109: IF new_references.CLOSED_IND not in ('Y','N') then
110: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception ;
113: END IF;
114:
115: END IF ;

Line 120: IGS_GE_MSG_STACK.ADD;

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

Line 134: IGS_GE_MSG_STACK.ADD;

130:
131: IF Get_PK_For_Validation (
132: new_references.citizenship_cd ) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END Check_Uniqueness ;
138:

Line 151: IGS_GE_MSG_STACK.ADD;

147: IF NOT IGS_PE_GOVCITIZEN_CD_PKG.Get_PK_For_Validation (
148: new_references.govt_citizenship_cd
149: ) THEN
150: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF ;
155: END Check_Parent_Existance;

Line 202: IGS_GE_MSG_STACK.ADD;

198: Fetch cur_rowid INTO lv_rowid;
199: IF (cur_rowid%FOUND) THEN
200: Close cur_rowid;
201: Fnd_Message.Set_Name ('IGS', 'IGS_ST_CIC_GCC_FK');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: Return;
205: END IF;
206: Close cur_rowid;

Line 248: IGS_GE_MSG_STACK.ADD;

244: IF Get_PK_For_Validation (
245: new_references.govt_citizenship_cd
246: ) THEN
247: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: Check_Constraints;
252: Check_Parent_Existance;

Line 269: IGS_GE_MSG_STACK.ADD;

265: IF Get_PK_For_Validation (
266: new_references.govt_citizenship_cd
267: ) THEN
268: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: Check_Constraints;
273: Check_Uniqueness;

Line 323: IGS_GE_MSG_STACK.ADD;

319: X_LAST_UPDATE_LOGIN := -1;
320: end if;
321: else
322: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
323: IGS_GE_MSG_STACK.ADD;
324: app_exception.raise_exception;
325: end if;
326:
327: Before_DML(

Line 403: IGS_GE_MSG_STACK.ADD;

399: fetch c1 into tlinfo;
400: if (c1%notfound) then
401: close c1;
402: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
403: IGS_GE_MSG_STACK.ADD;
404: app_exception.raise_exception;
405: return;
406: end if;
407: close c1;

Line 419: IGS_GE_MSG_STACK.ADD;

415: ) then
416: null;
417: else
418: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: return;
423: end LOCK_ROW;

Line 453: IGS_GE_MSG_STACK.ADD;

449: X_LAST_UPDATE_LOGIN := -1;
450: end if;
451: else
452: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
453: IGS_GE_MSG_STACK.ADD;
454: app_exception.raise_exception;
455: end if;
456:
457: Before_DML(