APPS.IGS_PE_PERSON_TYPES_PKG dependencies on IGS_GE_MSG_STACK

Line 48: IGS_GE_MSG_STACK.ADD;

44: Fetch cur_old_ref_values INTO old_references;
45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: Close cur_old_ref_values;
47: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
48: IGS_GE_MSG_STACK.ADD;
49: App_Exception.Raise_Exception;
50: Return;
51: END IF;
52: Close cur_old_ref_values;

Line 106: IGS_GE_MSG_STACK.ADD;

102: OPEN dup_system_type;
103: FETCH dup_system_type INTO l_count;
104: IF l_count > 0 THEN
105: Fnd_Message.Set_Name('IGS','IGS_PE_ONE_PE_TY_SYS_TY');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: CLOSE dup_system_type;
110: END check_duplicate_per_type;

Line 199: IGS_GE_MSG_STACK.ADD;

195: OPEN C2;
196: FETCH C2 INTO tlinfo;
197: IF (C2%found) THEN
198: Fnd_Message.Set_Name('IGS','IGS_PE_ONE_PE_TY_SYS_TY');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END IF;
202: CLOSE C2;
203: END IF;

Line 236: IGS_GE_MSG_STACK.ADD;

232: OPEN C3;
233: FETCH C3 INTO tlinfo;
234: IF (C3%found) THEN
235: Fnd_Message.Set_Name('IGS','IGS_PE_ONE_PE_TY_SYS_TY');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: END IF;
239: CLOSE C3;
240: END IF;

Line 273: IGS_GE_MSG_STACK.ADD;

269: IF Upper(Column_Name) = 'CLOSED_IND' OR
270: Column_Name IS NULL THEN
271: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
272: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: END IF;
277:

Line 394: IGS_GE_MSG_STACK.ADD;

390: -- Call all the procedures related to Before Insert.
391: IF Get_Pk_For_Validation(
392: new_references.person_type_code) THEN
393: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397: Check_Constraints;
398: --BeforeInsertPTC;

Line 412: IGS_GE_MSG_STACK.ADD;

408: -- Call all the procedures related to Before Insert.
409: IF Get_PK_For_Validation (
410: new_references.person_type_code) THEN
411: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
412: IGS_GE_MSG_STACK.ADD;
413: App_Exception.Raise_Exception;
414: END IF;
415: Check_Constraints;
416: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 503: IGS_GE_MSG_STACK.ADD;

499: X_LAST_UPDATE_LOGIN := -1;
500: end if;
501: else
502: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506: Before_DML(
507: p_action=>'INSERT',

Line 584: IGS_GE_MSG_STACK.ADD;

580: open c1;
581: fetch c1 into tlinfo;
582: if (c1%notfound) then
583: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
584: IGS_GE_MSG_STACK.ADD;
585: close c1;
586: app_exception.raise_exception;
587: return;
588: end if;

Line 597: IGS_GE_MSG_STACK.ADD;

593: ) then
594: null;
595: else
596: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: end if;
600: return;
601: end LOCK_ROW;

Line 641: IGS_GE_MSG_STACK.ADD;

637: X_LAST_UPDATE_LOGIN := -1;
638: end if;
639: else
640: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
641: IGS_GE_MSG_STACK.ADD;
642: app_exception.raise_exception;
643: end if;
644:
645: Before_DML(