APPS.IGS_AD_RECRUIT_PI_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 130: App_Exception.Raise_Exception;

126: IF new_references.probability_value < 0 Then
127:
128: Fnd_Message.Set_Name ('IGS', 'IGS_AD_PROB_VAL');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131:
132: END IF;
133:
134: END IF;

Line 159: app_exception.raise_exception;

155: new_references.person_id
156: ) THEN
157: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
158: igs_ge_msg_stack.add;
159: app_exception.raise_exception;
160: END IF;
161:
162: IF (((old_references.probability_type_code_id = new_references.probability_type_code_id)) OR
163: ((new_references.probability_type_code_id IS NULL))) THEN

Line 172: app_exception.raise_exception;

168: 'N'
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
175: IF (((old_references.probability_source_code_id = new_references.probability_source_code_id)) OR
176: ((new_references.probability_source_code_id IS NULL))) THEN

Line 185: app_exception.raise_exception;

181: 'N'
182: ) THEN
183: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
184: igs_ge_msg_stack.add;
185: app_exception.raise_exception;
186: END IF;
187:
188: END check_parent_existance;
189:

Line 292: app_exception.raise_exception;

288: IF (cur_rowid%FOUND) THEN
289: CLOSE cur_rowid;
290: fnd_message.set_name ('IGS', 'IGS_AD_IARP_PE_FK');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: RETURN;
294: END IF;
295: CLOSE cur_rowid;
296:

Line 328: app_exception.raise_exception;

324: IF (cur_rowid%FOUND) THEN
325: CLOSE cur_rowid;
326: fnd_message.set_name ('IGS', 'IGS_AD_IARP_ADCC_FK');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: RETURN;
330: END IF;
331: CLOSE cur_rowid;
332:

Line 387: app_exception.raise_exception;

383: )
384: ) THEN
385: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: END IF;
389: check_uniqueness;
390: Check_Constraints;
391: check_parent_existance;

Line 405: app_exception.raise_exception;

401: )
402: ) THEN
403: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407: check_uniqueness;
408: Check_Constraints;
409: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 463: app_exception.raise_exception;

459: END IF;
460: ELSE
461: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
462: igs_ge_msg_stack.add;
463: app_exception.raise_exception;
464: END IF;
465:
466: x_probability_index_id := -1;
467: before_dml(

Line 559: app_exception.raise_exception;

555: IF (c1%notfound) THEN
556: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
557: igs_ge_msg_stack.add;
558: CLOSE c1;
559: app_exception.raise_exception;
560: RETURN;
561: END IF;
562: CLOSE c1;
563:

Line 575: app_exception.raise_exception;

571: NULL;
572: ELSE
573: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577:
578: RETURN;
579:

Line 624: app_exception.raise_exception;

620: END IF;
621: ELSE
622: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
623: igs_ge_msg_stack.add;
624: app_exception.raise_exception;
625: END IF;
626:
627: before_dml(
628: p_action => 'UPDATE',