44: OPEN cur_old_ref_values;
45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
93: new_references.cost_centre,
94: new_references.subject
95: )
96: ) THEN
97: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
226: IF ( get_pk_for_validation(
227: new_references.he_spa_cc_id
228: )
229: ) THEN
230: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: END IF;
234: check_uniqueness;
240: IF ( get_pk_for_validation (
241: new_references.he_spa_cc_id
242: )
243: ) THEN
244: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: END IF;
248: check_uniqueness;
296: IF (x_last_update_login IS NULL) THEN
297: x_last_update_login := -1;
298: END IF;
299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.INSERT_ROW');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
297: x_last_update_login := -1;
298: END IF;
299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.INSERT_ROW');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:
359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
364: fnd_message.set_token ('ERR_CD', SQLCODE);
365: igs_ge_msg_stack.add;
366: igs_sc_gen_001.unset_ctx('R');
367: app_exception.raise_exception;
360: EXCEPTION
361: WHEN OTHERS THEN
362: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
364: fnd_message.set_token ('ERR_CD', SQLCODE);
365: igs_ge_msg_stack.add;
366: igs_sc_gen_001.unset_ctx('R');
367: app_exception.raise_exception;
368: ELSE
407:
408: OPEN c1;
409: FETCH c1 INTO tlinfo;
410: IF (c1%notfound) THEN
411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
412: igs_ge_msg_stack.add;
413: CLOSE c1;
414: app_exception.raise_exception;
415: RETURN;
424: AND (tlinfo.proportion = x_proportion)
425: ) THEN
426: NULL;
427: ELSE
428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429: igs_ge_msg_stack.add;
430: app_exception.raise_exception;
431: END IF;
432:
473: IF (x_last_update_login IS NULL) THEN
474: x_last_update_login := -1;
475: END IF;
476: ELSE
477: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
478: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.UPDATE_ROW');
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481: END IF;
474: x_last_update_login := -1;
475: END IF;
476: ELSE
477: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
478: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.UPDATE_ROW');
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481: END IF;
482:
511: last_update_login = x_last_update_login
512: WHERE rowid = x_rowid;
513:
514: IF (SQL%NOTFOUND) THEN
515: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
516: igs_ge_msg_stack.add;
517: igs_sc_gen_001.unset_ctx('R');
518: app_exception.raise_exception;
519: END IF;
526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF (SQLCODE = (-28115)) THEN
530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
531: fnd_message.set_token ('ERR_CD', SQLCODE);
532: igs_ge_msg_stack.add;
533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF (SQLCODE = (-28115)) THEN
530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
531: fnd_message.set_token ('ERR_CD', SQLCODE);
532: igs_ge_msg_stack.add;
533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
535: ELSE
625: DELETE FROM igs_he_st_spa_cc
626: WHERE rowid = x_rowid;
627:
628: IF (SQL%NOTFOUND) THEN
629: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
630: igs_ge_msg_stack.add;
631: igs_sc_gen_001.unset_ctx('R');
632: app_exception.raise_exception;
633: END IF;