APPS.IGS_HE_ST_SPA_CC_PKG dependencies on IGS_GE_MSG_STACK

Line 49: igs_ge_msg_stack.add;

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;
53: CLOSE cur_old_ref_values;

Line 98: igs_ge_msg_stack.add;

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:
102: END check_uniqueness;

Line 231: igs_ge_msg_stack.add;

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;
235: ELSIF (p_action = 'UPDATE') THEN

Line 245: igs_ge_msg_stack.add;

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;
249: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 302: igs_ge_msg_stack.add;

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:
306: x_he_spa_cc_id := NULL;

Line 365: igs_ge_msg_stack.add;

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
369: igs_sc_gen_001.unset_ctx('R');

Line 412: igs_ge_msg_stack.add;

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;
416: END IF;

Line 429: igs_ge_msg_stack.add;

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:
433: RETURN;

Line 479: igs_ge_msg_stack.add;

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:
483: before_dml(

Line 516: igs_ge_msg_stack.add;

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;
520: IF (x_mode = 'S') THEN

Line 532: igs_ge_msg_stack.add;

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
536: igs_sc_gen_001.unset_ctx('R');

Line 630: igs_ge_msg_stack.add;

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;
634: IF (x_mode = 'S') THEN