DBA Data[Home] [Help]

APPS.IGS_AD_PRCS_CAT_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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

Line 93: IGS_GE_MSG_STACK.ADD;

89: IF IGS_AD_VAL_ACCT.admp_val_ac_closed (
90: v_admission_cat,
91: v_message_name) = FALSE THEN
92: Fnd_Message.Set_Name('IGS',v_message_name);
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END BeforeRowInsertUpdateDelete1;
97:

Line 133: IGS_GE_MSG_STACK.ADD;

129: IF UPPER(Column_Name) = 'ADMISSION_CAT' OR
130: Column_Name IS NULL THEN
131: IF new_references.ADMISSION_CAT <> UPPER(new_references.admission_cat) THEN
132: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137:

Line 142: IGS_GE_MSG_STACK.ADD;

138: IF UPPER(Column_Name) = 'S_ADMISSION_PROCESS_TYPE' OR
139: Column_Name IS NULL THEN
140: IF new_references.S_ADMISSION_PROCESS_TYPE <> UPPER(new_references.s_admission_process_type) THEN
141: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:

Line 152: IGS_GE_MSG_STACK.ADD;

148: column_name is null Then
149: IF new_references.offer_response_offset < 1 OR
150: new_references.offer_response_offset > 99 Then
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156:

Line 180: IGS_GE_MSG_STACK.ADD;

176: ELSIF NOT Igs_Ad_Cat_Pkg.Get_PK_For_Validation (
177: new_references.admission_cat ,
178: 'N') THEN
179: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183:
184:

Line 194: IGS_GE_MSG_STACK.ADD;

190: 'ADMISSION_PROCESS_TYPE',
191: new_references.s_admission_process_type
192: ) THEN
193: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
198: END Check_Parent_Existance;

Line 318: IGS_GE_MSG_STACK.ADD;

314: Fetch cur_rowid INTO lv_rowid;
315: IF (cur_rowid%FOUND) THEN
316: Close cur_rowid;
317: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APC_AC_FK');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: Return;
321: END IF;
322: Close cur_rowid;

Line 354: IGS_GE_MSG_STACK.ADD;

350: Fetch cur_rowid INTO lv_rowid;
351: IF (cur_rowid%FOUND) THEN
352: Close cur_rowid;
353: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APC_SAPT_FK');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356: Return;
357: END IF;
358: Close cur_rowid;

Line 412: IGS_GE_MSG_STACK.ADD;

408: IF Get_Pk_For_Validation(
409: new_references.admission_cat,
410: new_references.s_admission_process_type) THEN
411: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
412: IGS_GE_MSG_STACK.ADD;
413: App_Exception.Raise_Exception;
414: END IF;
415: Check_Constraints;
416: Check_Parent_Existance;

Line 432: IGS_GE_MSG_STACK.ADD;

428: IF Get_PK_For_Validation (
429: new_references.admission_cat,
430: new_references.s_admission_process_type) THEN
431: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
432: IGS_GE_MSG_STACK.ADD;
433: App_Exception.Raise_Exception;
434: END IF;
435: Check_Constraints;
436: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 519: IGS_GE_MSG_STACK.ADD;

515: X_LAST_UPDATE_LOGIN := -1;
516: end if;
517: else
518: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
519: IGS_GE_MSG_STACK.ADD;
520: app_exception.raise_exception;
521: end if;
522: Before_DML(
523: p_action=>'INSERT',

Line 599: IGS_GE_MSG_STACK.ADD;

595: open c1;
596: fetch c1 into tlinfo;
597: if (c1%notfound) then
598: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
599: IGS_GE_MSG_STACK.ADD;
600: close c1;
601: app_exception.raise_exception;
602: return;
603: end if;

Line 613: IGS_GE_MSG_STACK.ADD;

609: ) then
610: null;
611: else
612: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
613: IGS_GE_MSG_STACK.ADD;
614: app_exception.raise_exception;
615: end if;
616: return;
617: end LOCK_ROW;

Line 656: IGS_GE_MSG_STACK.ADD;

652: X_LAST_UPDATE_LOGIN := -1;
653: end if;
654: else
655: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
656: IGS_GE_MSG_STACK.ADD;
657: app_exception.raise_exception;
658: end if;
659: Before_DML(
660: p_action=>'UPDATE',