DBA Data[Home] [Help]

APPS.IGS_HE_ST_SPA_CC_PKG dependencies on FND_MESSAGE

Line 48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

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;

Line 97: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

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:

Line 230: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

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;

Line 244: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

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;

Line 300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

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;

Line 301: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.INSERT_ROW');

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:

Line 363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

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;

Line 364: fnd_message.set_token ('ERR_CD', SQLCODE);

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

Line 411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

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;

Line 428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

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:

Line 477: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

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;

Line 478: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.UPDATE_ROW');

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:

Line 515: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

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;

Line 530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

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;

Line 531: fnd_message.set_token ('ERR_CD', SQLCODE);

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

Line 629: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

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;