DBA Data[Home] [Help]

APPS.IGS_FI_APP_RULES_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 131: app_exception.raise_exception;

127: IF l_b_bool THEN
128: fnd_message.set_name ( 'IGS', 'IGS_FI_AHR_FTYP_CANT_ENABLE' );
129: fnd_message.set_token('FEE_TYPE',x_fee_type);
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:
134: END chk_unique_fee;
135:

Line 198: app_exception.raise_exception;

194: )
195: ) THEN
196: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199:
200: END IF;
201:
202: IF ( unique_rule_seq (new_references.appl_hierarchy_id,

Line 209: app_exception.raise_exception;

205: )
206: ) THEN
207: fnd_message.set_name ('IGS', 'IGS_FI_UNQ_RULE_SEQ');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210:
211: END IF;
212:
213: END check_uniqueness;

Line 236: app_exception.raise_exception;

232: new_references.appl_hierarchy_id
233: ) THEN
234: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238:
239: IF (((old_references.rule_type = new_references.rule_type)) OR
240: ((new_references.rule_type IS NULL))) THEN

Line 249: App_Exception.Raise_Exception;

245: new_references.rule_type
246: ) THEN
247: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: END IF;
252:
253: END check_parent_existance;

Line 357: app_exception.raise_exception;

353: IF (cur_rowid%FOUND) THEN
354: CLOSE cur_rowid;
355: fnd_message.set_name ('IGS', 'IGS_FI_HRRL_APHR_FK');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: RETURN;
359: END IF;
360: CLOSE cur_rowid;
361:

Line 417: app_exception.raise_exception;

413: )
414: ) THEN
415: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: END IF;
419: check_uniqueness;
420: check_parent_existance;
421: chk_unique_fee(x_appl_hierarchy_id,

Line 441: app_exception.raise_exception;

437: )
438: ) THEN
439: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
440: igs_ge_msg_stack.add;
441: app_exception.raise_exception;
442: END IF;
443: check_uniqueness;
444: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
445: check_uniqueness;

Line 497: app_exception.raise_exception;

493: END IF;
494: ELSE
495: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499:
500: SELECT igs_fi_app_rules_s.NEXTVAL
501: INTO x_appl_rule_id

Line 596: app_exception.raise_exception;

592: IF (c1%notfound) THEN
593: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
594: igs_ge_msg_stack.add;
595: CLOSE c1;
596: app_exception.raise_exception;
597: RETURN;
598: END IF;
599: CLOSE c1;
600:

Line 612: app_exception.raise_exception;

608: NULL;
609: ELSE
610: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
611: igs_ge_msg_stack.add;
612: app_exception.raise_exception;
613: END IF;
614:
615: RETURN;
616:

Line 661: app_exception.raise_exception;

657: END IF;
658: ELSE
659: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
660: igs_ge_msg_stack.add;
661: app_exception.raise_exception;
662: END IF;
663:
664: before_dml(
665: p_action => 'UPDATE',