APPS.IGS_AD_CONV_GS_VALS_PKG dependencies on IGS_GE_MSG_STACK

Line 47: IGS_GE_MSG_STACK.ADD;

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

Line 99: -- IGS_GE_MSG_STACK.ADD;

95:
96: IF upper(column_name) = 'FROM_GPA' OR column_name IS NULL THEN
97: -- IF new_references.from_gpa < 0 THEN
98: -- FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
99: -- IGS_GE_MSG_STACK.ADD;
100: -- APP_EXCEPTION.RAISE_EXCEPTION;
101: -- END IF;
102: null;
103: END IF;

Line 108: -- IGS_GE_MSG_STACK.ADD;

104:
105: IF upper(column_name) = 'TO_GPA' OR column_name IS NULL THEN
106: -- IF new_references.to_gpa < 0 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: null;
112: END IF;

Line 135: IGS_GE_MSG_STACK.ADD;

131: ,new_references.from_gpa
132: ,new_references.to_gpa
133: ) THEN
134: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
135: IGS_GE_MSG_STACK.ADD;
136: app_exception.raise_exception;
137: END IF;
138: END Check_Uniqueness ;
139:

Line 158: IGS_GE_MSG_STACK.ADD;

154: NULL;
155: ELSIF NOT Igs_Ad_Conv_Gs_Types_Pkg.Get_PK_For_Validation (
156: new_references.conv_gs_types_id ) THEN
157: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END Check_Parent_Existance;
162:

Line 254: IGS_GE_MSG_STACK.ADD;

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

Line 305: IGS_GE_MSG_STACK.ADD;

301: IF Get_Pk_For_Validation(
302: new_references.conv_gs_values_id
303: ) THEN
304: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END IF;
308: Check_Uniqueness;
309: --Check_Constraints;

Line 322: IGS_GE_MSG_STACK.ADD;

318: IF Get_PK_For_Validation (
319: new_references.conv_gs_values_id
320: ) 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 374: IGS_GE_MSG_STACK.ADD;

370: X_LAST_UPDATE_LOGIN := -1;
371: end if;
372: else
373: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
374: IGS_GE_MSG_STACK.ADD;
375: app_exception.raise_exception;
376: end if;
377:
378: X_CONV_GS_VALUES_ID := -1;

Line 452: IGS_GE_MSG_STACK.ADD;

448: open c1;
449: fetch c1 into tlinfo;
450: if (c1%notfound) then
451: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
452: IGS_GE_MSG_STACK.ADD;
453: close c1;
454: app_exception.raise_exception;
455: return;
456: end if;

Line 465: IGS_GE_MSG_STACK.ADD;

461: ) then
462: null;
463: else
464: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: end if;
468: return;
469: end LOCK_ROW;

Line 508: IGS_GE_MSG_STACK.ADD;

504: X_LAST_UPDATE_LOGIN := -1;
505: end if;
506: else
507: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
508: IGS_GE_MSG_STACK.ADD;
509: app_exception.raise_exception;
510: end if;
511: Before_DML(
512: p_action=>'UPDATE',