APPS.IGS_AD_SYSSRC_CAT_PKG dependencies on IGS_GE_MSG_STACK

Line 52: IGS_GE_MSG_STACK.ADD;

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

Line 108: IGS_GE_MSG_STACK.ADD;

104: IF Upper(Column_Name) = 'MANDATORY_IND' OR
105: Column_Name IS NULL THEN
106: IF NOT (new_references.mandatory_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;
112:

Line 141: IGS_GE_MSG_STACK.ADD;

137: 'SYSTEM_SOURCE_TYPES',
138: new_references.system_source_type
139: ) THEN
140: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144:
145: */

Line 243: IGS_GE_MSG_STACK.ADD;

239: new_references.category_name
240: ,new_references.system_source_type
241: ) THEN
242: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: app_exception.raise_exception;
245: END IF;
246: END Check_Uniqueness ;
247:

Line 304: IGS_GE_MSG_STACK.ADD;

300: IF Get_Pk_For_Validation(
301: new_references.category_name,
302: new_references.system_source_type) THEN
303: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307: --kumma, called the Check_Uniqueness 2664699
308: Check_Uniqueness;

Line 327: IGS_GE_MSG_STACK.ADD;

323: IF Get_PK_For_Validation (
324: new_references.category_name,
325: new_references.system_source_type) THEN
326: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: END IF;
330: Check_Constraints;
331: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 417: IGS_GE_MSG_STACK.ADD;

413: X_LAST_UPDATE_LOGIN := -1;
414: end if;
415: else
416: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: end if;
420: Before_DML(
421: p_action=>'INSERT',

Line 516: IGS_GE_MSG_STACK.ADD;

512: open c1;
513: fetch c1 into tlinfo;
514: if (c1%notfound) then
515: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
516: IGS_GE_MSG_STACK.ADD;
517: close c1;
518: app_exception.raise_exception;
519: return;
520: end if;

Line 530: IGS_GE_MSG_STACK.ADD;

526: ) then
527: null;
528: else
529: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
530: IGS_GE_MSG_STACK.ADD;
531: app_exception.raise_exception;
532: end if;
533: return;
534: end LOCK_ROW;

Line 577: IGS_GE_MSG_STACK.ADD;

573: X_LAST_UPDATE_LOGIN := -1;
574: end if;
575: else
576: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
577: IGS_GE_MSG_STACK.ADD;
578: app_exception.raise_exception;
579: end if;
580: Before_DML(
581: p_action=>'UPDATE',