DBA Data[Home] [Help]

APPS.IGS_PE_STAT_DETAILS_PKG dependencies on FND_MESSAGE

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

106: OPEN cur_old_ref_values;
107: FETCH cur_old_ref_values INTO old_references;
108: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
109: CLOSE cur_old_ref_values;
110: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 1');
111: igs_ge_msg_stack.ADD;
112: app_exception.raise_exception;
113: RETURN;
114: END IF;

Line 237: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PST_CI_FK');

233: BEGIN
234: Open cur_rowid;
235: Fetch cur_rowid INTO lv_rowid;
236: IF (cur_rowid%FOUND) THEN
237: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PST_CI_FK');
238: Igs_Ge_Msg_Stack.Add;
239: Close cur_rowid;
240: App_Exception.Raise_Exception;
241: Return;

Line 276: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED 2');

272:
273: OPEN cur_rowid;
274: FETCH cur_rowid INTO lv_rowid;
275: IF (cur_rowid%NOTFOUND) THEN
276: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED 2');
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280: CLOSE cur_rowid;

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

289: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
290: new_references.MATR_CAL_TYPE,
291: new_references.MATR_SEQUENCE_NUMBER
292: ) THEN
293: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 3');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297:

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

303: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
304: new_references.INIT_CAL_TYPE,
305: new_references.INIT_SEQUENCE_NUMBER
306: ) THEN
307: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 4');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311:

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

317: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
318: new_references.RECENT_CAL_TYPE,
319: new_references.RECENT_SEQUENCE_NUMBER
320: ) THEN
321: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 5');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325:

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

331: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
332: new_references.CATALOG_CAL_TYPE,
333: new_references.CATALOG_SEQUENCE_NUMBER
334: ) THEN
335: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 6');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339:

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

472: IF ( get_pk_for_validation(
473: new_references.person_id
474: )
475: ) THEN
476: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
477: igs_ge_msg_stack.ADD;
478: app_exception.raise_exception;
479: END IF;
480: ELSIF (p_action = 'UPDATE') THEN

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

485: IF ( get_pk_for_validation (
486: new_references.person_id
487: )
488: ) THEN
489: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
490: igs_ge_msg_stack.ADD;
491: app_exception.raise_exception;
492: END IF;
493: END IF;

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

596: ELSE
597: x_program_update_date := SYSDATE;
598: END IF;
599: ELSE
600: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
601: igs_ge_msg_stack.ADD;
602: app_exception.raise_exception;
603: END IF;
604:

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

794:
795: EXCEPTION
796: WHEN OTHERS THEN
797: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
798: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
799: fnd_message.set_token ('ERR_CD', SQLCODE);
800: igs_ge_msg_stack.add;
801: igs_sc_gen_001.unset_ctx('R');
802: app_exception.raise_exception;

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

795: EXCEPTION
796: WHEN OTHERS THEN
797: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
798: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
799: fnd_message.set_token ('ERR_CD', SQLCODE);
800: igs_ge_msg_stack.add;
801: igs_sc_gen_001.unset_ctx('R');
802: app_exception.raise_exception;
803: ELSE

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

924: BEGIN
925: OPEN c1;
926: FETCH c1 INTO tlinfo;
927: IF (c1%NOTFOUND) THEN
928: fnd_message.set_name('FND', 'FORM_RECORD_DELETED 7');
929: igs_ge_msg_stack.ADD;
930: CLOSE c1;
931: app_exception.raise_exception;
932: RETURN;

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

1024: AND (X_ATTRIBUTE20 IS NULL)))
1025: ) THEN
1026: NULL;
1027: ELSE
1028: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1029: igs_ge_msg_stack.ADD;
1030: app_exception.raise_exception;
1031: END IF;
1032:

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

1119: IF (x_last_update_login IS NULL) THEN
1120: x_last_update_login := -1;
1121: END IF;
1122: ELSE
1123: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1124: igs_ge_msg_stack.ADD;
1125: app_exception.raise_exception;
1126: END IF;
1127:

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

1255: BIRTH_CNTRY_RESN_CODE =new_references.BIRTH_CNTRY_RESN_CODE
1256: WHERE ROWID = x_rowid;
1257:
1258: IF (SQL%NOTFOUND) THEN
1259: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1260: igs_ge_msg_stack.add;
1261: igs_sc_gen_001.unset_ctx('R');
1262: app_exception.raise_exception;
1263: END IF;

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

1269:
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: IF (SQLCODE = (-28115)) THEN
1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;

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

1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: IF (SQLCODE = (-28115)) THEN
1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;
1278: ELSE

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

1492: DELETE FROM igs_pe_stat_details
1493: WHERE ROWID = x_rowid;
1494:
1495: IF (SQL%NOTFOUND) THEN
1496: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1497: igs_ge_msg_stack.add;
1498: igs_sc_gen_001.unset_ctx('R');
1499: app_exception.raise_exception;
1500: END IF;