DBA Data[Home] [Help]

APPS.IGS_PS_CATLG_VERS_PKG dependencies on FND_MESSAGE

Line 49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

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: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;

Line 107: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

103: -- The following code checks for check constraints on the Columns.
104: IF Upper(Column_Name) = 'CLOSED_IND' OR
105: Column_Name IS NULL THEN
106: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
107: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;

Line 117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

113: -- The following code checks for check constraints on the Columns.
114: IF Upper(Column_Name) = 'CATALOG_SCHEDULE' OR
115: Column_Name IS NULL THEN
116: IF NOT (new_references.catalog_schedule IN ('CATALOG', 'SCHEDULE')) THEN
117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121: END IF;

Line 143: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

139: IF Get_Uk_For_Validation (
140: new_references.catalog_schedule
141: ,new_references.catalog_version
142: ) THEN
143: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
144: IGS_GE_MSG_STACK.ADD;
145: app_exception.raise_exception;
146: END IF;
147: END Check_Uniqueness ;

Line 290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

286: -- Call all the procedures related to Before Insert.
287: Null;
288: IF Get_Pk_For_Validation(
289: new_references.catalog_version_id) THEN
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: Check_Uniqueness;

Line 309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

305: ELSIF (p_action = 'VALIDATE_INSERT') THEN
306: -- Call all the procedures related to Before Insert.
307: IF Get_PK_For_Validation (
308: new_references.catalog_version_id) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: Check_Uniqueness;

Line 398: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

394: if X_LAST_UPDATE_LOGIN is NULL then
395: X_LAST_UPDATE_LOGIN := -1;
396: end if;
397: else
398: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
399: IGS_GE_MSG_STACK.ADD;
400: app_exception.raise_exception;
401: end if;
402:

Line 491: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

487: begin
488: open c1;
489: fetch c1 into tlinfo;
490: if (c1%notfound) then
491: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
492: IGS_GE_MSG_STACK.ADD;
493: close c1;
494: app_exception.raise_exception;
495: return;

Line 505: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

501: AND (tlinfo.CATALOG_SCHEDULE = X_CATALOG_SCHEDULE)
502: ) then
503: null;
504: else
505: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
506: IGS_GE_MSG_STACK.ADD;
507: app_exception.raise_exception;
508: end if;
509: return;

Line 549: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

545: if X_LAST_UPDATE_LOGIN is NULL then
546: X_LAST_UPDATE_LOGIN := -1;
547: end if;
548: else
549: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
550: IGS_GE_MSG_STACK.ADD;
551: app_exception.raise_exception;
552: end if;
553: Before_DML(