DBA Data[Home] [Help]

APPS.IGF_SL_PNOTE_STAT_H_PKG dependencies on IGS_GE_MSG_STACK

Line 47: igs_ge_msg_stack.add;

43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;

Line 93: igs_ge_msg_stack.add;

89: ELSIF NOT igf_sl_lor_pkg.get_uk_For_validation (
90: new_references.loan_id
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: END check_parent_existance;

Line 163: igs_ge_msg_stack.add;

159: FETCH cur_rowid INTO lv_rowid;
160: IF (cur_rowid%FOUND) THEN
161: CLOSE cur_rowid;
162: fnd_message.set_name ('IGF', 'IGF_SL_DLPNH_LOR_FK');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: RETURN;
166: END IF;
167: CLOSE cur_rowid;

Line 218: igs_ge_msg_stack.add;

214: new_references.dlpnh_id
215: )
216: ) THEN
217: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221: check_parent_existance;
222: ELSIF (p_action = 'UPDATE') THEN

Line 232: igs_ge_msg_stack.add;

228: new_references.dlpnh_id
229: )
230: ) THEN
231: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235: END IF;
236:

Line 299: igs_ge_msg_stack.add;

295: x_program_update_date := SYSDATE;
296: END IF;
297: ELSE
298: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: END IF;
302:
303: SELECT igf_sl_pnote_stat_h_s.NEXTVAL

Line 395: igs_ge_msg_stack.add;

391: OPEN c1;
392: FETCH c1 INTO tlinfo;
393: IF (c1%notfound) THEN
394: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
395: igs_ge_msg_stack.add;
396: CLOSE c1;
397: app_exception.raise_exception;
398: RETURN;
399: END IF;

Line 410: igs_ge_msg_stack.add;

406: ) THEN
407: NULL;
408: ELSE
409: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
410: igs_ge_msg_stack.add;
411: app_exception.raise_exception;
412: END IF;
413:
414: RETURN;

Line 461: igs_ge_msg_stack.add;

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