DBA Data[Home] [Help]

APPS.IGS_HE_UT_PRS_DTLS_PKG dependencies on FND_MESSAGE

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

43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;

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

93: ELSIF NOT igs_he_ut_prs_calcs_pkg.get_pk_for_validation (
94: new_references.tariff_calc_type_cd,
95: new_references.person_id
96: ) THEN
97: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:

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

103: IF ((old_references.award_cd = new_references.award_cd) OR
104: (new_references.award_cd IS NULL)) THEN
105: NULL;
106: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation(new_references.award_cd) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:

Line 172: fnd_message.set_name ('IGS', 'IGS_HE_HUPD_HUPC_FK');

168: FETCH cur_rowid INTO lv_rowid;
169:
170: IF (cur_rowid%FOUND) THEN
171: CLOSE cur_rowid;
172: fnd_message.set_name ('IGS', 'IGS_HE_HUPD_HUPC_FK');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: RETURN;
176: END IF;

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

226: new_references.person_id,
227: new_references.award_cd
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_parent_existance;

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

239: new_references.person_id,
240: new_references.award_cd
241: )
242: ) THEN
243: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;
247: END IF;

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

291: IF (x_last_update_login IS NULL) THEN
292: x_last_update_login := -1;
293: END IF;
294: ELSE
295: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
296: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.INSERT_ROW');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;

Line 296: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.INSERT_ROW');

292: x_last_update_login := -1;
293: END IF;
294: ELSE
295: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
296: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.INSERT_ROW');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300:

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

349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
353: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
354: fnd_message.set_token ('ERR_CD', SQLCODE);
355: igs_ge_msg_stack.add;
356: igs_sc_gen_001.unset_ctx('R');
357: app_exception.raise_exception;

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

350: EXCEPTION
351: WHEN OTHERS THEN
352: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
353: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
354: fnd_message.set_token ('ERR_CD', SQLCODE);
355: igs_ge_msg_stack.add;
356: igs_sc_gen_001.unset_ctx('R');
357: app_exception.raise_exception;
358: ELSE

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

393:
394: OPEN c1;
395: FETCH c1 INTO tlinfo;
396: IF (c1%notfound) THEN
397: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
398: igs_ge_msg_stack.add;
399: CLOSE c1;
400: app_exception.raise_exception;
401: RETURN;

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

407: AND (tlinfo.tariff_score = x_tariff_score)
408: ) THEN
409: NULL;
410: ELSE
411: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: END IF;
415:

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

455: IF (x_last_update_login IS NULL) THEN
456: x_last_update_login := -1;
457: END IF;
458: ELSE
459: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
460: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.UPDATE_ROW');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;

Line 460: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.UPDATE_ROW');

456: x_last_update_login := -1;
457: END IF;
458: ELSE
459: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
460: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.UPDATE_ROW');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;
464:

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

489: last_update_login = x_last_update_login
490: WHERE rowid = x_rowid;
491:
492: IF (SQL%NOTFOUND) THEN
493: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
494: igs_ge_msg_stack.add;
495: igs_sc_gen_001.unset_ctx('R');
496: app_exception.raise_exception;
497: END IF;

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

504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: IF (SQLCODE = (-28115)) THEN
508: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;

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

505: EXCEPTION
506: WHEN OTHERS THEN
507: IF (SQLCODE = (-28115)) THEN
508: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE

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

602: DELETE FROM igs_he_ut_prs_dtls
603: WHERE rowid = x_rowid;
604:
605: IF (SQL%NOTFOUND) THEN
606: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
607: igs_ge_msg_stack.add;
608: igs_sc_gen_001.unset_ctx('R');
609: app_exception.raise_exception;
610: END IF;