[Home] [Help]
46: OPEN cur_old_ref_values;
47: FETCH cur_old_ref_values INTO old_references;
48: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
49: CLOSE cur_old_ref_values;
50: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
51: igs_ge_msg_stack.add;
52: app_exception.raise_exception;
53: RETURN;
54: END IF;
95: IF ( get_uk_for_validation (
96: new_references.display_order
97: )
98: ) THEN
99: fnd_message.set_name ('IGS', 'IGS_PR_DUP_DIS_ORD');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
120: NULL;
121: ELSIF NOT igs_pr_stat_type_pkg.get_pk_for_validation (
122: new_references.stat_type
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
240: OPEN cur_rowid;
241: FETCH cur_rowid INTO lv_rowid;
242: IF (cur_rowid%FOUND) THEN
243: CLOSE cur_rowid;
244: fnd_message.set_name ('IGS', 'IGS_PR_INST_STTY_FK');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: RETURN;
248: END IF;
303: IF ( get_pk_for_validation(
304: new_references.stat_type
305: )
306: ) THEN
307: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311: check_uniqueness;
322: IF ( get_pk_for_validation (
323: new_references.stat_type
324: )
325: ) 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_uniqueness;
389: IF (x_last_update_login IS NULL) THEN
390: x_last_update_login := -1;
391: END IF;
392: ELSE
393: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END IF;
397:
497: END IF;
498: ELSIF l_std_ind = 'Y'
499: AND (l_c1_rec.timeframe = 'BOTH'
500: OR l_both_std_flag ='Y' ) THEN
501: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
502: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
498: ELSIF l_std_ind = 'Y'
499: AND (l_c1_rec.timeframe = 'BOTH'
500: OR l_both_std_flag ='Y' ) THEN
501: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
502: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: END IF;
508:
509: OPEN c2;
510: FETCH c2 INTO dummy;
511: IF c2%FOUND THEN
512: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
513: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
514: igs_ge_msg_stack.add;
515: app_exception.raise_exception;
516: END IF;
509: OPEN c2;
510: FETCH c2 INTO dummy;
511: IF c2%FOUND THEN
512: fnd_message.set_name ('IGS','IGS_PR_STAT_TYPE_IND');
513: FND_MESSAGE.SET_TOKEN('STATTYPE_IND','Standard');
514: igs_ge_msg_stack.add;
515: app_exception.raise_exception;
516: END IF;
517: CLOSE c2;
566:
567: OPEN c1;
568: FETCH c1 INTO tlinfo;
569: IF (c1%notfound) THEN
570: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
571: igs_ge_msg_stack.add;
572: CLOSE c1;
573: app_exception.raise_exception;
574: RETURN;
585: AND (tlinfo.include_other_ind = x_include_other_ind)
586: ) THEN
587: NULL;
588: ELSE
589: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
636: IF (x_last_update_login IS NULL) THEN
637: x_last_update_login := -1;
638: END IF;
639: ELSE
640: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644: