DBA Data[Home] [Help]

APPS.IGS_UC_APP_CHOICES_PKG dependencies on IGS_GE_MSG_STACK

Line 101: igs_ge_msg_stack.add;

97: FETCH cur_old_ref_values INTO old_references;
98: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
99: CLOSE cur_old_ref_values;
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: RETURN;
104: END IF;
105: CLOSE cur_old_ref_values;

Line 220: igs_ge_msg_stack.add;

216: new_references.ucas_cycle
217: )
218: ) THEN
219: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
220: igs_ge_msg_stack.add;
221: app_exception.raise_exception;
222: END IF;
223:
224: END check_uniqueness;

Line 254: igs_ge_msg_stack.add;

250: ELSIF NOT igs_uc_applicants_pkg.get_pk_for_validation (
251: new_references.app_id
252: ) THEN
253: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;
257:
258: IF (((old_references.condition_category = new_references.condition_category) AND

Line 268: igs_ge_msg_stack.add;

264: new_references.condition_category,
265: new_references.condition_code
266: ) THEN
267: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
268: igs_ge_msg_stack.add;
269: app_exception.raise_exception;
270: END IF;
271:
272: IF (

Line 303: igs_ge_msg_stack.add;

299: new_references.campus,
300: new_references.system_code) THEN
301:
302: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305:
306: END IF;
307: END IF;

Line 416: igs_ge_msg_stack.add;

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

Line 455: igs_ge_msg_stack.add;

451: FETCH cur_rowid INTO lv_rowid;
452: IF (cur_rowid%FOUND) THEN
453: CLOSE cur_rowid;
454: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCH_UCOC_FK');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: RETURN;
458: END IF;
459: CLOSE cur_rowid;

Line 496: igs_ge_msg_stack.add;

492: FETCH cur_rowid INTO lv_rowid;
493: IF (cur_rowid%FOUND) THEN
494: CLOSE cur_rowid;
495: fnd_message.set_name ('IGS', 'IGS_UC_UCAPCH_UCCSDE_FK');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: RETURN;
499: END IF;
500: CLOSE cur_rowid;

Line 659: igs_ge_msg_stack.add;

655: new_references.app_choice_id
656: )
657: ) THEN
658: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
659: igs_ge_msg_stack.add;
660: app_exception.raise_exception;
661: END IF;
662: check_uniqueness;
663: check_parent_existance;

Line 675: igs_ge_msg_stack.add;

671: new_references.app_choice_id
672: )
673: ) THEN
674: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
675: igs_ge_msg_stack.add;
676: app_exception.raise_exception;
677: END IF;
678: check_uniqueness;
679: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 790: igs_ge_msg_stack.add;

786: x_last_update_login := -1;
787: END IF;
788: ELSE
789: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
790: igs_ge_msg_stack.add;
791: app_exception.raise_exception;
792: END IF;
793:
794: SELECT igs_uc_app_choices_s.NEXTVAL

Line 1015: igs_ge_msg_stack.add;

1011: WHEN OTHERS THEN
1012: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1013: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1014: fnd_message.set_token ('ERR_CD', SQLCODE);
1015: igs_ge_msg_stack.add;
1016: igs_sc_gen_001.unset_ctx('R');
1017: app_exception.raise_exception;
1018: ELSE
1019: igs_sc_gen_001.unset_ctx('R');

Line 1168: igs_ge_msg_stack.add;

1164: OPEN c1;
1165: FETCH c1 INTO tlinfo;
1166: IF (c1%notfound) THEN
1167: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1168: igs_ge_msg_stack.add;
1169: CLOSE c1;
1170: app_exception.raise_exception;
1171: RETURN;
1172: END IF;

Line 1236: igs_ge_msg_stack.add;

1232: ) THEN
1233: NULL;
1234: ELSE
1235: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1236: igs_ge_msg_stack.add;
1237: app_exception.raise_exception;
1238: END IF;
1239:
1240: RETURN;

Line 1339: igs_ge_msg_stack.add;

1335: x_last_update_login := -1;
1336: END IF;
1337: ELSE
1338: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1339: igs_ge_msg_stack.add;
1340: app_exception.raise_exception;
1341: END IF;
1342:
1343: before_dml(

Line 1479: igs_ge_msg_stack.add;

1475: WHERE rowid = x_rowid;
1476:
1477: IF (SQL%NOTFOUND) THEN
1478: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1479: igs_ge_msg_stack.add;
1480: igs_sc_gen_001.unset_ctx('R');
1481: app_exception.raise_exception;
1482: END IF;
1483: IF (x_mode = 'S') THEN

Line 1492: igs_ge_msg_stack.add;

1488: WHEN OTHERS THEN
1489: IF (SQLCODE = (-28115)) THEN
1490: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1491: fnd_message.set_token ('ERR_CD', SQLCODE);
1492: igs_ge_msg_stack.add;
1493: igs_sc_gen_001.unset_ctx('R');
1494: app_exception.raise_exception;
1495: ELSE
1496: igs_sc_gen_001.unset_ctx('R');

Line 1746: igs_ge_msg_stack.add;

1742: WHERE rowid = x_rowid;
1743:
1744: IF (SQL%NOTFOUND) THEN
1745: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1746: igs_ge_msg_stack.add;
1747: igs_sc_gen_001.unset_ctx('R');
1748: app_exception.raise_exception;
1749: END IF;
1750: IF (x_mode = 'S') THEN