DBA Data[Home] [Help]

APPS.IGS_AS_GPC_CLS_STNDG_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
50: CLOSE cur_old_ref_values;
51:

Line 91: app_exception.raise_exception;

87: )
88: ) THEN
89: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
94: END check_uniqueness;
95:

Line 118: app_exception.raise_exception;

114: new_references.class_standing
115: ) THEN
116: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception;
119:
120: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation ('AS_GRADING_PERIOD',
121: new_references.grading_period_cd ) THEN
122:

Line 125: APP_EXCEPTION.RAISE_EXCEPTION ;

121: new_references.grading_period_cd ) THEN
122:
123: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD ;
125: APP_EXCEPTION.RAISE_EXCEPTION ;
126:
127: END IF;
128:
129: END check_parent_existance;

Line 156: APP_EXCEPTION.RAISE_EXCEPTION ;

152: IGS_GE_MSG_STACK.ADD ;
153:
154: CLOSE cur_rowid ;
155:
156: APP_EXCEPTION.RAISE_EXCEPTION ;
157:
158: END IF;
159:
160: CLOSE cur_rowid ;

Line 263: app_exception.raise_exception;

259: IF (cur_rowid%FOUND) THEN
260: CLOSE cur_rowid;
261: fnd_message.set_name ('IGS', 'IGS_AS_GCS_PCS_FK');
262: igs_ge_msg_stack.add;
263: app_exception.raise_exception;
264: RETURN;
265: END IF;
266: CLOSE cur_rowid;
267:

Line 318: app_exception.raise_exception;

314: )
315: ) THEN
316: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
320: check_uniqueness;
321: check_parent_existance;
322: ELSIF (p_action = 'UPDATE') THEN

Line 334: app_exception.raise_exception;

330: )
331: ) THEN
332: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
333: igs_ge_msg_stack.add;
334: app_exception.raise_exception;
335: END IF;
336: check_uniqueness;
337: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
338: check_uniqueness;

Line 387: app_exception.raise_exception;

383: END IF;
384: ELSE
385: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: END IF;
389:
390: SELECT igs_as_gpc_cls_stndg_s.NEXTVAL
391: INTO x_gpc_cls_stndg_id

Line 471: app_exception.raise_exception;

467: IF (c1%notfound) THEN
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: igs_ge_msg_stack.add;
470: CLOSE c1;
471: app_exception.raise_exception;
472: RETURN;
473: END IF;
474: CLOSE c1;
475:

Line 484: app_exception.raise_exception;

480: NULL;
481: ELSE
482: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:
487: RETURN;
488:

Line 530: app_exception.raise_exception;

526: END IF;
527: ELSE
528: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
529: igs_ge_msg_stack.add;
530: app_exception.raise_exception;
531: END IF;
532:
533: before_dml(
534: p_action => 'UPDATE',