DBA Data[Home] [Help]

APPS.IGS_PE_HZ_PARTIES_PKG dependencies on APP_EXCEPTION

Line 86: app_exception.raise_exception;

82: CLOSE cur_old_ref_values;
83: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
84:
85: igs_ge_msg_stack.add;
86: app_exception.raise_exception;
87: RETURN;
88: END IF;
89: CLOSE cur_old_ref_values;
90:

Line 214: APP_EXCEPTION.Raise_Exception;

210: ELSIF x_inst_org_ind = 'I' THEN
211: FND_MESSAGE.SET_TOKEN('ORG_INST_CD',FND_MESSAGE.GET_STRING('IGS','IGS_OR_INSTITUTION_CODE'));
212: END IF;
213: IGS_GE_MSG_STACK.Add;
214: APP_EXCEPTION.Raise_Exception;
215: RETURN;
216: END IF;
217:
218: CLOSE cur_org_unit_exists;

Line 244: APP_EXCEPTION.Raise_Exception;

240: IF cur_rowid%FOUND THEN
241: CLOSE cur_rowid;
242: FND_MESSAGE.Set_Name('IGS','IGS_OR_PHP1_ACC');
243: IGS_GE_MSG_STACK.Add;
244: APP_EXCEPTION.Raise_Exception;
245: RETURN;
246: END IF;
247: CLOSE cur_rowid;
248:

Line 292: App_Exception.Raise_Exception;

288: ELSE
289: if Not validate_pk ( new_references.party_id ) then
290: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: end if;
294: END IF;
295:
296: -- added by ssawhney 2203778. veteran is now a lookup so validate.

Line 305: APP_EXCEPTION.RAISE_EXCEPTION;

301: ELSE
302: IF NOT IGS_LOOKUPS_VIEW_PKG.get_pk_for_validation('VETERAN_STATUS',new_references.veteran) THEN
303: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
304: IGS_GE_MSG_STACK.ADD;
305: APP_EXCEPTION.RAISE_EXCEPTION;
306: END IF;
307: END IF;
308:
309: IF (((old_references.inst_priority_cd = new_references.inst_priority_cd)) OR

Line 316: APP_EXCEPTION.RAISE_EXCEPTION;

312: ELSE
313: IF NOT IGS_LOOKUPS_VIEW_PKG.get_pk_for_validation('OR_INST_PRIORITY_CD',new_references.inst_priority_cd) THEN
314: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
315: IGS_GE_MSG_STACK.ADD;
316: APP_EXCEPTION.RAISE_EXCEPTION;
317: END IF;
318: END IF;
319:
320: END check_parent_existance;

Line 368: APP_EXCEPTION.RAISE_EXCEPTION;

364:
365: EXCEPTION
366: WHEN e_resource_busy THEN
367: -- ssawhney just raise the exception.
368: APP_EXCEPTION.RAISE_EXCEPTION;
369:
370: END validate_local_ind ;
371:
372:

Line 503: app_exception.raise_exception;

499: )
500: ) THEN
501: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
502: igs_ge_msg_stack.add;
503: app_exception.raise_exception;
504: END IF;
505:
506: IF new_references.oss_org_unit_cd IS NOT NULL THEN
507: get_uk_for_validation(new_references.oss_org_unit_cd,new_references.inst_org_ind);

Line 531: app_exception.raise_exception;

527: )
528: ) THEN
529: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
530: igs_ge_msg_stack.add;
531: app_exception.raise_exception;
532: END IF;
533:
534: IF new_references.oss_org_unit_cd IS NOT NULL THEN
535: get_uk_for_validation(new_references.oss_org_unit_cd,new_references.inst_org_ind);

Line 641: app_exception.raise_exception;

637: END IF;
638: ELSE
639: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
640: igs_ge_msg_stack.add;
641: app_exception.raise_exception;
642: END IF;
643:
644:
645: before_dml(

Line 823: app_exception.raise_exception;

819: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
820: fnd_message.set_token ('ERR_CD', SQLCODE);
821: igs_ge_msg_stack.add;
822: igs_sc_gen_001.unset_ctx('R');
823: app_exception.raise_exception;
824: ELSE
825: igs_sc_gen_001.unset_ctx('R');
826: RAISE;
827: END IF;

Line 940: app_exception.raise_exception;

936: IF (c1%notfound) THEN
937: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
938: igs_ge_msg_stack.add;
939: CLOSE c1;
940: app_exception.raise_exception;
941: RETURN;
942: END IF;
943: CLOSE c1;
944:

Line 991: app_exception.raise_exception;

987: NULL;
988: ELSE
989: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
990: igs_ge_msg_stack.add;
991: app_exception.raise_exception;
992: END IF;
993:
994: RETURN;
995:

Line 1079: app_exception.raise_exception;

1075: END IF;
1076: ELSE
1077: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1078: igs_ge_msg_stack.add;
1079: app_exception.raise_exception;
1080: END IF;
1081:
1082: before_dml(
1083: p_action => 'UPDATE',

Line 1205: app_exception.raise_exception;

1201: IF (SQL%NOTFOUND) THEN
1202: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1203: igs_ge_msg_stack.add;
1204: igs_sc_gen_001.unset_ctx('R');
1205: app_exception.raise_exception;
1206: END IF;
1207: IF (x_mode = 'S') THEN
1208: igs_sc_gen_001.unset_ctx('R');
1209: END IF;

Line 1220: app_exception.raise_exception;

1216: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1217: fnd_message.set_token ('ERR_CD', SQLCODE);
1218: igs_ge_msg_stack.add;
1219: igs_sc_gen_001.unset_ctx('R');
1220: app_exception.raise_exception;
1221: ELSE
1222: igs_sc_gen_001.unset_ctx('R');
1223: RAISE;
1224: END IF;

Line 1422: app_exception.raise_exception;

1418: IF (SQL%NOTFOUND) THEN
1419: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1420: igs_ge_msg_stack.add;
1421: igs_sc_gen_001.unset_ctx('R');
1422: app_exception.raise_exception;
1423: END IF;
1424: IF (x_mode = 'S') THEN
1425: igs_sc_gen_001.unset_ctx('R');
1426: END IF;