DBA Data[Home] [Help]

APPS.IGS_PE_FUND_EXCL_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

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

Line 111: app_exception.raise_exception;

107: )
108: ) THEN
109: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_uniqueness;
115:

Line 137: app_exception.raise_exception;

133: new_references.fund_code
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: IF (((old_references.person_id = new_references.person_id) AND
141: (old_references.encumbrance_type = new_references.encumbrance_type) AND

Line 163: app_exception.raise_exception;

159: new_references.pee_sequence_number
160: ) THEN
161: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165:
166: END check_parent_existance;
167:

Line 280: app_exception.raise_exception;

276: IF (cur_rowid%FOUND) THEN
277: CLOSE cur_rowid;
278: fnd_message.set_name ('IGS', 'IGS_PE_FCAT_PEE_FK');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: RETURN;
282: END IF;
283: CLOSE cur_rowid;
284:

Line 325: app_exception.raise_exception;

321: IF (cur_rowid%FOUND) THEN
322: CLOSE cur_rowid;
323: fnd_message.set_name ('IGS', 'IGS_PE_PFE_PEE_FK');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: RETURN;
327: END IF;
328: CLOSE cur_rowid;
329:

Line 351: APP_EXCEPTION.RAISE_EXCEPTION;

347: new_references.pfe_start_dt,
348: l_message_name) = FALSE THEN
349: FND_MESSAGE.SET_NAME('IGS', l_message_name);
350: IGS_GE_MSG_STACK.ADD;
351: APP_EXCEPTION.RAISE_EXCEPTION;
352: END IF;
353: END IF;
354:
355: -- Validate that start date is not less than the parent IGS_PE_PERSON

Line 364: APP_EXCEPTION.RAISE_EXCEPTION;

360: new_references.pfe_start_dt,
361: l_message_name) = FALSE THEN
362: FND_MESSAGE.SET_NAME('IGS', l_message_name);
363: IGS_GE_MSG_STACK.ADD;
364: APP_EXCEPTION.RAISE_EXCEPTION;
365: END IF;
366: END IF;
367:
368: -- Validate that if expiry date is specified, then expiry date is not

Line 381: APP_EXCEPTION.RAISE_EXCEPTION;

377: new_references.expiry_dt,
378: l_message_name) = FALSE THEN
379: FND_MESSAGE.SET_NAME('IGS', l_message_name);
380: IGS_GE_MSG_STACK.ADD;
381: APP_EXCEPTION.RAISE_EXCEPTION;
382: END IF;
383:
384: IF igs_en_val_pce.enrp_val_encmb_dt (
385: new_references.expiry_dt,

Line 389: APP_EXCEPTION.RAISE_EXCEPTION;

385: new_references.expiry_dt,
386: l_message_name) = FALSE THEN
387: FND_MESSAGE.SET_NAME('IGS', l_message_name);
388: IGS_GE_MSG_STACK.ADD;
389: APP_EXCEPTION.RAISE_EXCEPTION;
390: END IF;
391: END IF;
392:
393:

Line 400: APP_EXCEPTION.RAISE_EXCEPTION;

396: IF p_inserting THEN
397: IF new_references.s_encmb_effect_type NOT IN ('EX_AWD','EX_DISB','EX_SP_AWD','EX_SP_DISB') THEN
398: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_CANT_CREATE_REC_ENCUMB');
399: IGS_GE_MSG_STACK.ADD;
400: APP_EXCEPTION.RAISE_EXCEPTION;
401: END IF;
402: END IF;
403:
404: END BeforeRowInsertUpdate;

Line 433: APP_EXCEPTION.RAISE_EXCEPTION;

429: IF fund_exclusion_cur%FOUND THEN
430: CLOSE fund_exclusion_cur;
431: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_FUND_EXCL_OPEN');
432: IGS_GE_MSG_STACK.ADD;
433: APP_EXCEPTION.RAISE_EXCEPTION;
434: END IF;
435: CLOSE fund_exclusion_cur;
436:
437: END AfterRowInsertUpdateDelete;

Line 504: app_exception.raise_exception;

500: )
501: ) THEN
502: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: check_uniqueness;
507: check_parent_existance;
508: ELSIF (p_action = 'UPDATE') THEN

Line 530: app_exception.raise_exception;

526: )
527: ) THEN
528: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
529: igs_ge_msg_stack.add;
530: app_exception.raise_exception;
531: END IF;
532: check_uniqueness;
533: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
534:

Line 619: app_exception.raise_exception;

615: END IF;
616: ELSE
617: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: END IF;
621:
622: before_dml(
623: p_action => 'INSERT',

Line 734: app_exception.raise_exception;

730: IF (c1%notfound) THEN
731: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
732: igs_ge_msg_stack.add;
733: CLOSE c1;
734: app_exception.raise_exception;
735: RETURN;
736: END IF;
737: CLOSE c1;
738:

Line 754: app_exception.raise_exception;

750: NULL;
751: ELSE
752: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
753: igs_ge_msg_stack.add;
754: app_exception.raise_exception;
755: END IF;
756:
757: RETURN;
758:

Line 807: app_exception.raise_exception;

803: END IF;
804: ELSE
805: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
806: igs_ge_msg_stack.add;
807: app_exception.raise_exception;
808: END IF;
809:
810: before_dml(
811: p_action => 'UPDATE',