APPS.IGS_PS_OFR_PKG dependencies on IGS_GE_MSG_STACK

Line 69: IGS_GE_MSG_STACK.ADD;

65: Fetch cur_old_ref_values INTO old_references;
66: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
67: Close cur_old_ref_values;
68: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71: Return;
72: END IF;
73: Close cur_old_ref_values;

Line 154: IGS_GE_MSG_STACK.ADD;

150: IF IGS_PS_VAL_CRS.CRSP_VAL_IUD_CRV_DTL(v_course_cd,
151: v_version_number,
152: v_message_name) = FALSE THEN
153: Fnd_Message.Set_Name('IGS',v_message_name);
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: -- Validate calendar type.
158: IF p_inserting OR

Line 164: IGS_GE_MSG_STACK.ADD;

160: IF IGS_PS_VAL_CO.crsp_val_co_cal_type (
161: new_references.cal_type,
162: v_message_name) = FALSE THEN
163: Fnd_Message.Set_Name('IGS',v_message_name);
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
168: END BeforeRowInsertUpdateDelete1;

Line 198: IGS_GE_MSG_STACK.ADD;

194: IF upper(column_name) = 'CAL_TYPE' OR
195: column_name is null Then
196: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202:

Line 207: IGS_GE_MSG_STACK.ADD;

203: IF upper(column_name) = 'COURSE_CD' OR
204: column_name is null Then
205: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
211:

Line 234: IGS_GE_MSG_STACK.ADD;

230: IF NOT IGS_CA_TYPE_PKG.Get_PK_For_Validation (
231: new_references.cal_type
232: ) THEN
233: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
238:

Line 250: IGS_GE_MSG_STACK.ADD;

246: new_references.course_cd,
247: new_references.version_number
248: ) THEN
249: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
254:

Line 380: IGS_GE_MSG_STACK.ADD;

376: Fetch cur_rowid INTO lv_rowid;
377: IF (cur_rowid%FOUND) THEN
378: Close cur_rowid;
379: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CO_CAT_FK');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;
382: Return;
383: END IF;
384: Close cur_rowid;

Line 416: IGS_GE_MSG_STACK.ADD;

412: Fetch cur_rowid INTO lv_rowid;
413: IF (cur_rowid%FOUND) THEN
414: Close cur_rowid;
415: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CO_CRV_FK');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: Return;
419: END IF;
420: Close cur_rowid;

Line 513: IGS_GE_MSG_STACK.ADD;

509: new_references.course_cd,
510: new_references.version_number,
511: new_references.cal_type) THEN
512: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
513: IGS_GE_MSG_STACK.ADD;
514: App_Exception.Raise_Exception;
515: END IF;
516: Check_Constraints;
517: Check_Parent_Existance;

Line 533: IGS_GE_MSG_STACK.ADD;

529: new_references.course_cd,
530: new_references.version_number,
531: new_references.cal_type) THEN
532: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
533: IGS_GE_MSG_STACK.ADD;
534: App_Exception.Raise_Exception;
535: END IF;
536: Check_Constraints;
537: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 618: IGS_GE_MSG_STACK.ADD;

614: X_LAST_UPDATE_LOGIN := -1;
615: end if;
616: else
617: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
618: IGS_GE_MSG_STACK.ADD;
619: app_exception.raise_exception;
620: end if;
621: Before_DML (
622: p_action => 'INSERT',

Line 783: IGS_GE_MSG_STACK.ADD;

779: fetch c1 into tlinfo;
780: if (c1%notfound) then
781: close c1;
782: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
783: IGS_GE_MSG_STACK.ADD;
784: app_exception.raise_exception;
785: return;
786: end if;
787: close c1;