41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
86: new_references.lockbox_name,
87: new_references.record_type_code
88: )
89: ) THEN
90: fnd_message.set_name ('IGS', 'IGS_FI_LB_REC_TYPE_EXISTS');
91: fnd_message.set_token ('REC_TYPE',
92: igs_fi_gen_gl.get_lkp_meaning( 'IGS_FI_RECORD_IDENTIFIER', new_references.record_type_code ));
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
87: new_references.record_type_code
88: )
89: ) THEN
90: fnd_message.set_name ('IGS', 'IGS_FI_LB_REC_TYPE_EXISTS');
91: fnd_message.set_token ('REC_TYPE',
92: igs_fi_gen_gl.get_lkp_meaning( 'IGS_FI_RECORD_IDENTIFIER', new_references.record_type_code ));
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
114: NULL;
115: ELSIF NOT igs_fi_lockboxes_pkg.get_pk_for_validation (
116: new_references.lockbox_name
117: ) THEN
118: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
119: igs_ge_msg_stack.add;
120: app_exception.raise_exception;
121: END IF;
122:
241: new_references.lockbox_name,
242: new_references.record_identifier_cd
243: )
244: ) THEN
245: fnd_message.set_name('IGS','IGS_FI_LB_IDENTIFIER_EXITS');
246: fnd_message.set_token('TRAN_ID', new_references.record_identifier_cd);
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
242: new_references.record_identifier_cd
243: )
244: ) THEN
245: fnd_message.set_name('IGS','IGS_FI_LB_IDENTIFIER_EXITS');
246: fnd_message.set_token('TRAN_ID', new_references.record_identifier_cd);
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250: check_uniqueness;
259: new_references.lockbox_name,
260: new_references.record_identifier_cd
261: )
262: ) THEN
263: fnd_message.set_name('IGS','IGS_FI_LB_IDENTIFIER_EXITS');
264: fnd_message.set_token('TRAN_ID', new_references.record_identifier_cd);
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
260: new_references.record_identifier_cd
261: )
262: ) THEN
263: fnd_message.set_name('IGS','IGS_FI_LB_IDENTIFIER_EXITS');
264: fnd_message.set_token('TRAN_ID', new_references.record_identifier_cd);
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: check_uniqueness;
311: IF (x_last_update_login IS NULL) THEN
312: x_last_update_login := -1;
313: END IF;
314: ELSE
315: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
316: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_REC_TYPES_PKG.INSERT_ROW');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
312: x_last_update_login := -1;
313: END IF;
314: ELSE
315: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
316: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_REC_TYPES_PKG.INSERT_ROW');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
320:
382:
383: OPEN c1;
384: FETCH c1 INTO tlinfo;
385: IF (c1%notfound) THEN
386: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
387: igs_ge_msg_stack.add;
388: CLOSE c1;
389: app_exception.raise_exception;
390: RETURN;
395: (tlinfo.record_type_code = x_record_type_code)
396: ) THEN
397: NULL;
398: ELSE
399: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403:
441: IF (x_last_update_login IS NULL) THEN
442: x_last_update_login := -1;
443: END IF;
444: ELSE
445: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
446: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_REC_TYPES_PKG.UPDATE_ROW');
447: igs_ge_msg_stack.add;
448: app_exception.raise_exception;
449: END IF;
442: x_last_update_login := -1;
443: END IF;
444: ELSE
445: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
446: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_REC_TYPES_PKG.UPDATE_ROW');
447: igs_ge_msg_stack.add;
448: app_exception.raise_exception;
449: END IF;
450: