DBA Data[Home] [Help]

APPS.IGS_PR_MILESTONE_HST_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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

Line 184: IGS_GE_MSG_STACK.ADD;

180: new_references.sequence_number,
181: new_references.hist_start_dt
182: ) THEN
183: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: Check_Constraints;
188: ELSIF (p_action = 'UPDATE') THEN

Line 200: IGS_GE_MSG_STACK.ADD;

196: new_references.sequence_number,
197: new_references.hist_start_dt
198: ) THEN
199: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: Check_Constraints;
204: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 256: IGS_GE_MSG_STACK.ADD;

252: X_LAST_UPDATE_LOGIN := -1;
253: end if;
254: else
255: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
256: IGS_GE_MSG_STACK.ADD;
257: app_exception.raise_exception;
258: end if;
259:
260: Before_DML (

Line 385: IGS_GE_MSG_STACK.ADD;

381: open c1;
382: fetch c1 into tlinfo;
383: if (c1%notfound) then
384: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
385: IGS_GE_MSG_STACK.ADD;
386: close c1;
387: app_exception.raise_exception;
388: return;
389: end if;

Line 429: IGS_GE_MSG_STACK.ADD;

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

Line 474: IGS_GE_MSG_STACK.ADD;

470: X_LAST_UPDATE_LOGIN := -1;
471: end if;
472: else
473: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
474: IGS_GE_MSG_STACK.ADD;
475: app_exception.raise_exception;
476: end if;
477: Before_DML (
478: p_action => 'UPDATE',

Line 643: IGS_GE_MSG_STACK.ADD;

639:
640: IF upper(Column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
641: IF new_references.CA_SEQUENCE_NUMBER < 1 or new_references.CA_SEQUENCE_NUMBER > 999999 then
642: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
643: IGS_GE_MSG_STACK.ADD;
644: App_Exception.Raise_Exception ;
645: END IF;
646:
647: END IF ;

Line 652: IGS_GE_MSG_STACK.ADD;

648:
649: IF upper(Column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
650: IF new_references.SEQUENCE_NUMBER < 1 or new_references.SEQUENCE_NUMBER > 999999 then
651: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
652: IGS_GE_MSG_STACK.ADD;
653: App_Exception.Raise_Exception ;
654: END IF;
655:
656: END IF ;

Line 661: IGS_GE_MSG_STACK.ADD;

657:
658: IF upper(Column_name) = 'PRECED_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
659: IF new_references.PRECED_SEQUENCE_NUMBER < 1 or new_references.PRECED_SEQUENCE_NUMBER > 999999 then
660: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
661: IGS_GE_MSG_STACK.ADD;
662: App_Exception.Raise_Exception ;
663: END IF;
664:
665: END IF ;