DBA Data[Home] [Help]

APPS.IGS_AS_GPC_PE_ID_GRP_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 117: app_exception.raise_exception;

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

Line 123: APP_EXCEPTION.RAISE_EXCEPTION ;

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

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 242: App_Exception.Raise_Exception;

238: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.group_id <> old_references.group_id ) ) THEN
239: IF NOT IGS_PE_PERSID_GROUP_PKG.val_persid_group(new_references.group_id,p_message_name) THEN
240: Fnd_Message.Set_Name('IGS', p_message_name);
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: END IF;
244: END IF;
245: END BeforeInsertUpdate;
246:

Line 293: app_exception.raise_exception;

289: )
290: ) THEN
291: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
292: igs_ge_msg_stack.add;
293: app_exception.raise_exception;
294: END IF;
295: check_uniqueness;
296: check_parent_existance;
297: ELSIF (p_action = 'UPDATE') THEN

Line 310: app_exception.raise_exception;

306: )
307: ) THEN
308: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: END IF;
312: check_uniqueness;
313: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
314: check_uniqueness;

Line 363: app_exception.raise_exception;

359: END IF;
360: ELSE
361: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
362: igs_ge_msg_stack.add;
363: app_exception.raise_exception;
364: END IF;
365:
366: SELECT igs_as_gpc_pe_id_grp_s.NEXTVAL
367: INTO x_gpc_pe_grp_id

Line 447: app_exception.raise_exception;

443: IF (c1%notfound) THEN
444: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
445: igs_ge_msg_stack.add;
446: CLOSE c1;
447: app_exception.raise_exception;
448: RETURN;
449: END IF;
450: CLOSE c1;
451:

Line 460: app_exception.raise_exception;

456: NULL;
457: ELSE
458: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: END IF;
462:
463: RETURN;
464:

Line 506: app_exception.raise_exception;

502: END IF;
503: ELSE
504: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: END IF;
508:
509: before_dml(
510: p_action => 'UPDATE',