DBA Data[Home] [Help]

APPS.IGS_PE_MIL_SERVICES_PKG dependencies on FND_MESSAGE

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

74: Open cur_old_ref_values;
75: Fetch cur_old_ref_values INTO old_references;
76: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
77: Close cur_old_ref_values;
78: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: Return;
82: END IF;

Line 159: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_DATE');

155: FETCH validate_mil_dt INTO l_bth_dt;
156: CLOSE validate_mil_dt;
157:
158: IF new_references.END_DATE IS NOT NULL AND new_references.END_DATE < new_references.START_DATE THEN
159: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_DATE');
160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162:
163: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN

Line 164: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SERVICE_STDT_LS_BRDT');

160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162:
163: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > new_references.START_DATE THEN
164: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SERVICE_STDT_LS_BRDT');
165: IGS_GE_MSG_STACK.ADD;
166: APP_EXCEPTION.RAISE_EXCEPTION;
167: END IF;
168:

Line 242: Fnd_Message.Set_Name ('IGS', 'IGS_PE_MILTARY_DUP_EXISTS');

238: new_references.person_id,
239: new_references.military_type_cd,
240: new_references.start_date
241: )THEN
242: Fnd_Message.Set_Name ('IGS', 'IGS_PE_MILTARY_DUP_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: End Check_Uniqueness;

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

269:
270: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
271: 'PE_MIL_SEV_TYPE',new_references.military_type_cd
272: ) THEN
273: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
274: IGS_GE_MSG_STACK.ADD;
275: App_Exception.Raise_Exception;
276: END IF;
277:

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

280: NULL;
281: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
282: new_references.person_id
283: ) THEN
284: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287: END IF;
288:

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

292: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
293: 'PE_MIL_SEP_TYPE',new_references.separation_type_cd
294:
295: ) THEN
296: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300:

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

303: NULL;
304: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
305: 'PE_MIL_ASS_STATUS',new_references.assistance_status_cd
306: ) THEN
307: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311:

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

315: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
316: 'PE_MIL_ASS_TYPE',new_references.assistance_type_cd
317:
318: ) THEN
319: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323:

Line 398: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PMS_PP_FK');

394: Open cur_rowid;
395: Fetch cur_rowid INTO lv_rowid;
396: IF (cur_rowid%FOUND) THEN
397: Close cur_rowid;
398: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PMS_PP_FK');
399: IGS_GE_MSG_STACK.ADD;
400: App_Exception.Raise_Exception;
401: Return;
402: END IF;

Line 510: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

506: BeforeRowInsertUpdate( TRUE, FALSE,FALSE );
507: Null;
508: IF Get_Pk_For_Validation(
509: new_references.milit_service_id) THEN
510: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception;
513: END IF;
514: Check_Constraints;

Line 531: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

527: ELSIF (p_action = 'VALIDATE_INSERT') THEN
528: -- Call all the procedures related to Before Insert.
529: IF Get_PK_For_Validation (
530: new_references.milit_service_id) THEN
531: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
532: IGS_GE_MSG_STACK.ADD;
533: App_Exception.Raise_Exception;
534: END IF;
535: Check_Constraints;

Line 652: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

648: if X_LAST_UPDATE_LOGIN is NULL then
649: X_LAST_UPDATE_LOGIN := -1;
650: end if;
651: else
652: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
653: IGS_GE_MSG_STACK.ADD;
654: app_exception.raise_exception;
655: end if;
656: SELECT IGS_PE_MIL_SERVICE_S.NEXTVAL INTO X_MILIT_SERVICE_ID

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

785: x_rowid => X_ROWID );
786: EXCEPTION
787: WHEN OTHERS THEN
788: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
789: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
790: fnd_message.set_token ('ERR_CD', SQLCODE);
791: igs_ge_msg_stack.add;
792: igs_sc_gen_001.unset_ctx('R');
793: app_exception.raise_exception;

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

786: EXCEPTION
787: WHEN OTHERS THEN
788: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
789: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
790: fnd_message.set_token ('ERR_CD', SQLCODE);
791: igs_ge_msg_stack.add;
792: igs_sc_gen_001.unset_ctx('R');
793: app_exception.raise_exception;
794: ELSE

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

881: begin
882: open c1;
883: fetch c1 into tlinfo;
884: if (c1%notfound) then
885: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
886: IGS_GE_MSG_STACK.ADD;
887: close c1;
888: app_exception.raise_exception;
889: return;

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

971: AND (X_ASSISTANCE_STATUS_CD is null)))
972: ) then
973: null;
974: else
975: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
976: IGS_GE_MSG_STACK.ADD;
977: app_exception.raise_exception;
978: end if;
979: return;

Line 1048: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

1044: if X_LAST_UPDATE_LOGIN is NULL then
1045: X_LAST_UPDATE_LOGIN := -1;
1046: end if;
1047: else
1048: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1049: IGS_GE_MSG_STACK.ADD;
1050: app_exception.raise_exception;
1051: end if;
1052: Before_DML(

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

1127: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1128: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
1129: where ROWID = X_ROWID;
1130: if (sql%notfound) then
1131: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1132: igs_ge_msg_stack.add;
1133: igs_sc_gen_001.unset_ctx('R');
1134: app_exception.raise_exception;
1135: end if;

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

1144: );
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF (SQLCODE = (-28115)) THEN
1148: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1149: fnd_message.set_token ('ERR_CD', SQLCODE);
1150: igs_ge_msg_stack.add;
1151: igs_sc_gen_001.unset_ctx('R');
1152: app_exception.raise_exception;

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

1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF (SQLCODE = (-28115)) THEN
1148: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1149: fnd_message.set_token ('ERR_CD', SQLCODE);
1150: igs_ge_msg_stack.add;
1151: igs_sc_gen_001.unset_ctx('R');
1152: app_exception.raise_exception;
1153: ELSE

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

1313: END IF;
1314: delete from IGS_PE_MIL_SERVICES_ALL
1315: where ROWID = X_ROWID;
1316: if (sql%notfound) then
1317: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1318: igs_ge_msg_stack.add;
1319: igs_sc_gen_001.unset_ctx('R');
1320: app_exception.raise_exception;
1321: end if;