226: OPEN cur_old_ref_values;
227: FETCH cur_old_ref_values INTO old_references;
228: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
229: CLOSE cur_old_ref_values;
230: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: RETURN;
234: END IF;
851: IF ( get_pk_for_validation( new_references.loansh_id
852:
853: )
854: ) THEN
855: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
856: igs_ge_msg_stack.add;
857: app_exception.raise_exception;
858: END IF;
859: ELSIF (p_action = 'VALIDATE_INSERT') THEN
861: IF ( get_pk_for_validation ( new_references.loansh_id
862:
863: )
864: ) THEN
865: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
866: igs_ge_msg_stack.add;
867: app_exception.raise_exception;
868: END IF;
869: END IF;
1142: ELSE
1143: x_program_update_date := SYSDATE;
1144: END IF;
1145: ELSE
1146: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1147: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.INSERT_ROW');
1148: igs_ge_msg_stack.add;
1149: app_exception.raise_exception;
1150: END IF;
1143: x_program_update_date := SYSDATE;
1144: END IF;
1145: ELSE
1146: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1147: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.INSERT_ROW');
1148: igs_ge_msg_stack.add;
1149: app_exception.raise_exception;
1150: END IF;
1151:
2151:
2152: OPEN c1;
2153: FETCH c1 INTO tlinfo;
2154: IF (c1%notfound) THEN
2155: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2156: igs_ge_msg_stack.add;
2157: CLOSE c1;
2158: app_exception.raise_exception;
2159: RETURN;
2351: AND ((tlinfo.source_txt = x_source_txt) OR ((tlinfo.source_txt IS NULL) AND (X_source_txt IS NULL)))
2352: ) THEN
2353: NULL;
2354: ELSE
2355: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2356: igs_ge_msg_stack.add;
2357: app_exception.raise_exception;
2358: END IF;
2359:
2586: IF (x_last_update_login IS NULL) THEN
2587: x_last_update_login := -1;
2588: END IF;
2589: ELSE
2590: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2591: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.UPDATE_ROW');
2592: igs_ge_msg_stack.add;
2593: app_exception.raise_exception;
2594: END IF;
2587: x_last_update_login := -1;
2588: END IF;
2589: ELSE
2590: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2591: fnd_message.set_token ('ROUTINE', 'igf_sl_lor_loc_history_PKG.UPDATE_ROW');
2592: igs_ge_msg_stack.add;
2593: app_exception.raise_exception;
2594: END IF;
2595: