APPS.IGS_PS_REF_CD_PKG dependencies on IGS_GE_MSG_STACK

Line 43: igs_ge_msg_stack.add;

39: FETCH cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: CLOSE cur_old_ref_values;
42: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
43: igs_ge_msg_stack.add;
44: app_exception.raise_exception;
45: RETURN;
46: END IF;
47: CLOSE cur_old_ref_values;

Line 98: igs_ge_msg_stack.add;

94: v_course_cd,
95: v_version_number,
96: v_message_name) = FALSE THEN
97: fnd_message.set_name('IGS',v_message_name);
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101: -- Validate reference code type.
102: IF p_inserting OR

Line 109: igs_ge_msg_stack.add;

105: IF igs_ps_val_crfc.crsp_val_ref_cd_type(
106: new_references.reference_cd_type,
107: v_message_name) = FALSE THEN
108: fnd_message.set_name('IGS',v_message_name);
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112: END IF;
113: IF p_updating THEN

Line 136: igs_ge_msg_stack.add;

132: END IF;
133: IF p_deleting THEN
134: IF igs_ps_val_atl.chk_mandatory_ref_cd(old_references.reference_cd_type) THEN
135: fnd_message.set_name ('IGS', 'IGS_PS_REF_CD_MANDATORY');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139: -- Create history record for deletion
140: igs_ps_gen_007.crsp_ins_crc_hist(

Line 186: igs_ge_msg_stack.add;

182: new_references.version_number,
183: new_references.reference_cd_type
184: )THEN
185: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189: END check_uniqueness;
190:

Line 210: igs_ge_msg_stack.add;

206: IF UPPER(column_name)= 'COURSE_CD' OR
207: column_name IS NULL THEN
208: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
209: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END IF;
213: END IF;
214:

Line 219: igs_ge_msg_stack.add;

215: IF UPPER(column_name)= 'REFERENCE_CD' OR
216: column_name IS NULL THEN
217: IF new_references.reference_cd <> UPPER(new_references.reference_cd) THEN
218: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
219: igs_ge_msg_stack.add;
220: app_exception.raise_exception;
221: END IF;
222: END IF;
223:

Line 228: igs_ge_msg_stack.add;

224: IF UPPER(column_name)= 'REFERENCE_CD_TYPE' OR
225: column_name IS NULL THEN
226: IF new_references.reference_cd_type <> UPPER(new_references.reference_cd_type) THEN
227: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: END IF;
231: END IF;
232:

Line 249: igs_ge_msg_stack.add;

245: new_references.course_cd,
246: new_references.version_number
247: )THEN
248: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252: END IF;
253: IF (((old_references.reference_cd_type = new_references.reference_cd_type)) OR

Line 261: igs_ge_msg_stack.add;

257: ELSE
258: IF NOT igs_ge_ref_cd_type_pkg.get_pk_for_validation (
259: new_references.reference_cd_type )THEN
260: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: END IF;
265: END check_parent_existance;

Line 350: igs_ge_msg_stack.add;

346: FETCH cur_rowid INTO lv_rowid;
347: IF (cur_rowid%FOUND) THEN
348: CLOSE cur_rowid;
349: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_CRV_FK');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: RETURN;
353: END IF;
354: CLOSE cur_rowid;

Line 376: igs_ge_msg_stack.add;

372: FETCH cur_rowid INTO lv_rowid;
373: IF (cur_rowid%FOUND) THEN
374: CLOSE cur_rowid;
375: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_RCT_FK');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: RETURN;
379: END IF;
380: CLOSE cur_rowid;

Line 415: igs_ge_msg_stack.add;

411: FETCH cur_rowid INTO lv_rowid;
412: IF (cur_rowid%FOUND) THEN
413: CLOSE cur_rowid;
414: fnd_message.set_name ('IGS', 'IGS_PS_CRFC_RC_FK');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: RETURN;
418: END IF;
419: CLOSE cur_rowid;

Line 465: igs_ge_msg_stack.add;

461: new_references.reference_cd_type ,
462: new_references.reference_cd
463: ) THEN
464: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: check_uniqueness;
469: check_constraints;

Line 487: igs_ge_msg_stack.add;

483: new_references.version_number ,
484: new_references.reference_cd_type ,
485: new_references.reference_cd ) THEN
486: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: check_uniqueness;
491: check_constraints;

Line 554: igs_ge_msg_stack.add;

550: x_last_update_login := -1;
551: END IF;
552: ELSE
553: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
554: igs_ge_msg_stack.add;
555: app_exception.raise_exception;
556: END IF;
557: before_dml (
558: p_action => 'INSERT',

Line 629: igs_ge_msg_stack.add;

625: FETCH c1 INTO tlinfo;
626: IF (c1%NOTFOUND) THEN
627: CLOSE c1;
628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: RETURN;
632: END IF;
633: CLOSE c1;

Line 642: igs_ge_msg_stack.add;

638: ) THEN
639: NULL;
640: ELSE
641: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
642: igs_ge_msg_stack.add;
643: app_exception.raise_exception;
644: END IF;
645: RETURN;
646: END lock_row;

Line 676: igs_ge_msg_stack.add;

672: x_last_update_login := -1;
673: END IF;
674: ELSE
675: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
676: igs_ge_msg_stack.add;
677: app_exception.raise_exception;
678: END IF;
679: before_dml (
680: p_action => 'UPDATE',