APPS.IGS_PS_USEC_LIM_WLST_PKG dependencies on IGS_GE_MSG_STACK

Line 54: IGS_GE_MSG_STACK.ADD;

50: Fetch cur_old_ref_values INTO old_references;
51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
52: Close cur_old_ref_values;
53: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
54: IGS_GE_MSG_STACK.ADD;
55: App_Exception.Raise_Exception;
56: Return;
57: END IF;
58: Close cur_old_ref_values;

Line 125: IGS_GE_MSG_STACK.ADD;

121: IF Get_Uk_For_Validation (
122: new_references.uoo_id
123: ) THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: IGS_GE_MSG_STACK.ADD;
126: app_exception.raise_exception;
127: END IF;
128: END Check_Uniqueness ;
129: PROCEDURE Check_Parent_Existance AS

Line 150: IGS_GE_MSG_STACK.ADD;

146: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
147: new_references.uoo_id
148: ) THEN
149: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153:
154: END Check_Parent_Existance;

Line 256: IGS_GE_MSG_STACK.ADD;

252: Fetch cur_rowid INTO lv_rowid;
253: IF (cur_rowid%FOUND) THEN
254: Close cur_rowid;
255: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USLW_UOO_UFK');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
260: Close cur_rowid;

Line 322: IGS_GE_MSG_STACK.ADD;

318: Null;
319: IF Get_Pk_For_Validation(
320: new_references.unit_section_limit_waitlist_id) THEN
321: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325: Check_Uniqueness;
326: Check_Constraints;

Line 342: IGS_GE_MSG_STACK.ADD;

338: -- Call all the procedures related to Before Insert.
339: IF Get_PK_For_Validation (
340: new_references.unit_section_limit_waitlist_id) THEN
341: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
342: IGS_GE_MSG_STACK.ADD;
343: App_Exception.Raise_Exception;
344: END IF;
345: Check_Uniqueness;
346: Check_Constraints;

Line 407: IGS_GE_MSG_STACK.ADD;

403: ) = FALSE THEN
404:
405:
406: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
407: IGS_GE_MSG_STACK.ADD;
408: app_exception.raise_exception;
409: END IF;
410: END IF;
411: ELSIF (p_action = 'UPDATE') THEN

Line 431: IGS_GE_MSG_STACK.ADD;

427: ) = FALSE THEN
428:
429:
430: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
431: IGS_GE_MSG_STACK.ADD;
432: app_exception.raise_exception;
433: END IF;
434: END IF;
435:

Line 461: IGS_GE_MSG_STACK.ADD;

457: ) = FALSE THEN
458:
459:
460: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
461: IGS_GE_MSG_STACK.ADD;
462: app_exception.raise_exception;
463: END IF;
464: END IF;
465:

Line 518: IGS_GE_MSG_STACK.ADD;

514: X_LAST_UPDATE_LOGIN := -1;
515: end if;
516: else
517: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
518: IGS_GE_MSG_STACK.ADD;
519: app_exception.raise_exception;
520: end if;
521: SELECT
522: igs_ps_usec_lim_wlst_s.nextval

Line 630: IGS_GE_MSG_STACK.ADD;

626: OPEN c1;
627: FETCH c1 INTO tlinfo;
628: IF (c1%NOTFOUND) THEN
629: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
630: IGS_GE_MSG_STACK.ADD;
631: CLOSE c1;
632: APP_EXCEPTION.RAISE_EXCEPTION;
633: RETURN;
634: END IF;

Line 661: IGS_GE_MSG_STACK.ADD;

657: ) THEN
658: NULL;
659: ELSE
660: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
661: IGS_GE_MSG_STACK.ADD;
662: APP_EXCEPTION.RAISE_EXCEPTION;
663: END IF;
664: RETURN;
665: END LOCK_ROW;

Line 711: IGS_GE_MSG_STACK.ADD;

707: X_LAST_UPDATE_LOGIN := -1;
708: end if;
709: else
710: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
711: IGS_GE_MSG_STACK.ADD;
712: app_exception.raise_exception;
713: end if;
714: Before_DML(
715: p_action =>'UPDATE',