DBA Data[Home] [Help]

APPS.IGF_SL_DL_PNOTE_S_P_PKG dependencies on IGS_GE_MSG_STACK

Line 63: igs_ge_msg_stack.add;

59: FETCH cur_old_ref_values INTO old_references;
60: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
61: CLOSE cur_old_ref_values;
62: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
63: igs_ge_msg_stack.add;
64: app_exception.raise_exception;
65: RETURN;
66: END IF;
67: CLOSE cur_old_ref_values;

Line 125: igs_ge_msg_stack.add;

121: ELSIF NOT igf_sl_loans_pkg.get_pk_for_validation (
122: new_references.loan_id
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_parent_existance;

Line 193: igs_ge_msg_stack.add;

189: FETCH cur_rowid INTO lv_rowid;
190: IF (cur_rowid%FOUND) THEN
191: CLOSE cur_rowid;
192: fnd_message.set_name ('IGF', 'IGF_SL_PNSP_LAR_FK');
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: RETURN;
196: END IF;
197: CLOSE cur_rowid;

Line 280: igs_ge_msg_stack.add;

276: new_references.pnsp_id
277: )
278: ) THEN
279: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282: END IF;
283: check_parent_existance;
284: ELSIF (p_action = 'UPDATE') THEN

Line 294: igs_ge_msg_stack.add;

290: new_references.pnsp_id
291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: END IF;
298:

Line 377: igs_ge_msg_stack.add;

373: x_program_update_date := SYSDATE;
374: END IF;
375: ELSE
376: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
381: SELECT igf_sl_dl_pnote_s_p_all_s.NEXTVAL

Line 557: igs_ge_msg_stack.add;

553: OPEN c1;
554: FETCH c1 INTO tlinfo;
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;

Line 588: igs_ge_msg_stack.add;

584: ) THEN
585: NULL;
586: ELSE
587: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
588: igs_ge_msg_stack.add;
589: app_exception.raise_exception;
590: END IF;
591:
592: RETURN;

Line 655: igs_ge_msg_stack.add;

651: x_last_update_login := -1;
652: END IF;
653: ELSE
654: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657: END IF;
658:
659: before_dml(