DBA Data[Home] [Help]

APPS.IGS_PE_EIT_PKG dependencies on FND_MESSAGE

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

48: OPEN cur_old_ref_values;
49: FETCH cur_old_ref_values INTO old_references;
50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;

Line 105: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_STATE_DUP_EXISTS');

101: new_references.start_date
102: )
103: ) THEN
104: IF new_references.information_type = 'PE_STAT_RES_STATE' THEN
105: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_STATE_DUP_EXISTS');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');

Line 109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');

105: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_STATE_DUP_EXISTS');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: ELSE
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

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

109: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_COUNTRY_DUP_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: ELSE
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117: END IF;

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

136: NULL;
137: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
138: new_references.person_id
139: ) THEN
140: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144:

Line 247: fnd_message.set_name ('IGS', 'IGS_PE_PEIT_HZ_FK');

243: OPEN cur_rowid;
244: FETCH cur_rowid INTO lv_rowid;
245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGS', 'IGS_PE_PEIT_HZ_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;

Line 306: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');

302: FETCH validate_brth_dt INTO l_bth_dt;
303: CLOSE validate_brth_dt;
304:
305: IF new_references.END_DATE IS NOT NULL AND new_references.END_DATE < new_references.START_DATE THEN
306: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
307: IGS_GE_MSG_STACK.ADD;
308: APP_EXCEPTION.RAISE_EXCEPTION;
309:
310: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN

Line 311: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');

307: IGS_GE_MSG_STACK.ADD;
308: APP_EXCEPTION.RAISE_EXCEPTION;
309:
310: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
311: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');
312: IGS_GE_MSG_STACK.ADD;
313: APP_EXCEPTION.RAISE_EXCEPTION;
314: END IF;
315:

Line 323: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_ST_RES');

319: FETCH validate_dt_overlap INTO l_Overlap_check;
320: IF (validate_dt_overlap%FOUND) THEN
321: CLOSE validate_dt_overlap;
322: IF new_references.information_type = 'PE_STAT_RES_STATE' THEN
323: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_ST_RES');
324: l_inf_type := FND_MESSAGE.GET;
325: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
326: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CON_PHY');
327: l_inf_type := FND_MESSAGE.GET;

Line 324: l_inf_type := FND_MESSAGE.GET;

320: IF (validate_dt_overlap%FOUND) THEN
321: CLOSE validate_dt_overlap;
322: IF new_references.information_type = 'PE_STAT_RES_STATE' THEN
323: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_ST_RES');
324: l_inf_type := FND_MESSAGE.GET;
325: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
326: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CON_PHY');
327: l_inf_type := FND_MESSAGE.GET;
328: ELSIF new_references.information_type = 'PE_INT_PERM_RES' THEN

Line 326: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CON_PHY');

322: IF new_references.information_type = 'PE_STAT_RES_STATE' THEN
323: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_ST_RES');
324: l_inf_type := FND_MESSAGE.GET;
325: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
326: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CON_PHY');
327: l_inf_type := FND_MESSAGE.GET;
328: ELSIF new_references.information_type = 'PE_INT_PERM_RES' THEN
329: l_inf_type := NULL;
330: ELSIF new_references.information_type = 'PE_STAT_RES_STATUS' THEN

Line 327: l_inf_type := FND_MESSAGE.GET;

323: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_ST_RES');
324: l_inf_type := FND_MESSAGE.GET;
325: ELSIF new_references.information_type = 'PE_STAT_RES_COUNTRY' THEN
326: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CON_PHY');
327: l_inf_type := FND_MESSAGE.GET;
328: ELSIF new_references.information_type = 'PE_INT_PERM_RES' THEN
329: l_inf_type := NULL;
330: ELSIF new_references.information_type = 'PE_STAT_RES_STATUS' THEN
331: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CIT');

Line 331: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CIT');

327: l_inf_type := FND_MESSAGE.GET;
328: ELSIF new_references.information_type = 'PE_INT_PERM_RES' THEN
329: l_inf_type := NULL;
330: ELSIF new_references.information_type = 'PE_STAT_RES_STATUS' THEN
331: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CIT');
332: l_inf_type := FND_MESSAGE.GET;
333: END IF;
334:
335: IF l_inf_type IS NOT NULL THEN

Line 332: l_inf_type := FND_MESSAGE.GET;

328: ELSIF new_references.information_type = 'PE_INT_PERM_RES' THEN
329: l_inf_type := NULL;
330: ELSIF new_references.information_type = 'PE_STAT_RES_STATUS' THEN
331: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_CIT');
332: l_inf_type := FND_MESSAGE.GET;
333: END IF;
334:
335: IF l_inf_type IS NOT NULL THEN
336: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DT_RANGE_OVLP');

Line 336: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DT_RANGE_OVLP');

332: l_inf_type := FND_MESSAGE.GET;
333: END IF;
334:
335: IF l_inf_type IS NOT NULL THEN
336: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DT_RANGE_OVLP');
337: FND_MESSAGE.SET_TOKEN('TOKEN',l_inf_type);
338: ELSE
339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PRDS_OVERLAP');
340: END IF;

Line 337: FND_MESSAGE.SET_TOKEN('TOKEN',l_inf_type);

333: END IF;
334:
335: IF l_inf_type IS NOT NULL THEN
336: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DT_RANGE_OVLP');
337: FND_MESSAGE.SET_TOKEN('TOKEN',l_inf_type);
338: ELSE
339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PRDS_OVERLAP');
340: END IF;
341:

Line 339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PRDS_OVERLAP');

335: IF l_inf_type IS NOT NULL THEN
336: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DT_RANGE_OVLP');
337: FND_MESSAGE.SET_TOKEN('TOKEN',l_inf_type);
338: ELSE
339: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PRDS_OVERLAP');
340: END IF;
341:
342: IGS_GE_MSG_STACK.ADD;
343: APP_EXCEPTION.RAISE_EXCEPTION;

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

404: IF ( get_pk_for_validation(
405: new_references.pe_eit_id
406: )
407: ) THEN
408: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412: check_uniqueness;

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

421: IF ( get_pk_for_validation (
422: new_references.pe_eit_id
423: )
424: ) THEN
425: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429: check_uniqueness;

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

481: IF (x_last_update_login IS NULL) THEN
482: x_last_update_login := -1;
483: END IF;
484: ELSE
485: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:

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

563:
564: EXCEPTION
565: WHEN OTHERS THEN
566: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
567: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
568: fnd_message.set_token ('ERR_CD', SQLCODE);
569: igs_ge_msg_stack.add;
570: igs_sc_gen_001.unset_ctx('R');
571: app_exception.raise_exception;

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

564: EXCEPTION
565: WHEN OTHERS THEN
566: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
567: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
568: fnd_message.set_token ('ERR_CD', SQLCODE);
569: igs_ge_msg_stack.add;
570: igs_sc_gen_001.unset_ctx('R');
571: app_exception.raise_exception;
572: ELSE

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

619:
620: OPEN c1;
621: FETCH c1 INTO tlinfo;
622: IF (c1%notfound) THEN
623: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
624: igs_ge_msg_stack.add;
625: CLOSE c1;
626: app_exception.raise_exception;
627: RETURN;

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

640: AND ((tlinfo.end_date = x_end_date) OR ((tlinfo.end_date IS NULL) AND (X_end_date IS NULL)))
641: ) THEN
642: NULL;
643: ELSE
644: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
645: igs_ge_msg_stack.add;
646: app_exception.raise_exception;
647: END IF;
648:

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

693: IF (x_last_update_login IS NULL) THEN
694: x_last_update_login := -1;
695: END IF;
696: ELSE
697: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
698: igs_ge_msg_stack.add;
699: app_exception.raise_exception;
700: END IF;
701:

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

738: last_update_login = x_last_update_login
739: WHERE rowid = x_rowid;
740:
741: IF (SQL%NOTFOUND) THEN
742: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
743: igs_ge_msg_stack.add;
744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: END IF;

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

752:
753: EXCEPTION
754: WHEN OTHERS THEN
755: IF (SQLCODE = (-28115)) THEN
756: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
757: fnd_message.set_token ('ERR_CD', SQLCODE);
758: igs_ge_msg_stack.add;
759: igs_sc_gen_001.unset_ctx('R');
760: app_exception.raise_exception;

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

753: EXCEPTION
754: WHEN OTHERS THEN
755: IF (SQLCODE = (-28115)) THEN
756: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
757: fnd_message.set_token ('ERR_CD', SQLCODE);
758: igs_ge_msg_stack.add;
759: igs_sc_gen_001.unset_ctx('R');
760: app_exception.raise_exception;
761: ELSE

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

862: DELETE FROM igs_pe_eit
863: WHERE rowid = x_rowid;
864:
865: IF (SQL%NOTFOUND) THEN
866: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
867: igs_ge_msg_stack.add;
868: igs_sc_gen_001.unset_ctx('R');
869: app_exception.raise_exception;
870: END IF;