eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_HZ_PTY_SITES_PKG dependencies on APP_EXCEPTION

Line 46: app_exception.raise_exception;

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

Line 106: APP_EXCEPTION.RAISE_EXCEPTION;

102:
103: IF p_start_dt IS NULL AND p_end_dt IS NOT NULL THEN
104: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SPECIFY_END_DATE');
105: IGS_GE_MSG_STACK.ADD;
106: APP_EXCEPTION.RAISE_EXCEPTION;
107:
108: ELSIF p_end_dt IS NOT NULL AND p_start_dt > p_end_dt THEN
109: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
110: IGS_GE_MSG_STACK.ADD;

Line 111: APP_EXCEPTION.RAISE_EXCEPTION;

107:
108: ELSIF p_end_dt IS NOT NULL AND p_start_dt > p_end_dt THEN
109: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
110: IGS_GE_MSG_STACK.ADD;
111: APP_EXCEPTION.RAISE_EXCEPTION;
112:
113: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > p_start_dt THEN
114: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
115: IGS_GE_MSG_STACK.ADD;

Line 116: APP_EXCEPTION.RAISE_EXCEPTION;

112:
113: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > p_start_dt THEN
114: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
115: IGS_GE_MSG_STACK.ADD;
116: APP_EXCEPTION.RAISE_EXCEPTION;
117: END IF;
118: END BeforeRowInsertUpdate;
119:
120:

Line 154: APP_EXCEPTION.RAISE_EXCEPTION;

150:
151: IF p_start_dt IS NULL AND p_end_dt IS NOT NULL THEN
152: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SPECIFY_END_DATE');
153: IGS_GE_MSG_STACK.ADD;
154: APP_EXCEPTION.RAISE_EXCEPTION;
155:
156: ELSIF p_end_dt IS NOT NULL AND p_start_dt > p_end_dt THEN
157: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
158: IGS_GE_MSG_STACK.ADD;

Line 159: APP_EXCEPTION.RAISE_EXCEPTION;

155:
156: ELSIF p_end_dt IS NOT NULL AND p_start_dt > p_end_dt THEN
157: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
158: IGS_GE_MSG_STACK.ADD;
159: APP_EXCEPTION.RAISE_EXCEPTION;
160:
161: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > p_start_dt THEN
162: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');
163: IGS_GE_MSG_STACK.ADD;

Line 164: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 244: app_exception.raise_exception;

240: BeforeRowInsertUpdate(new_references.party_site_id , new_references.start_date , new_references.end_date );
241: IF (get_pk_for_validation( new_references.party_site_id)) THEN
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
246: ELSIF (p_action = 'UPDATE') THEN
247: -- Call all the procedures related to Before Update.
248: BeforeRowInsertUpdate(new_references.party_site_id , new_references.start_date , new_references.end_date );

Line 257: app_exception.raise_exception;

253: BeforeRowInsertUpdate(new_references.party_site_id , new_references.start_date , new_references.end_date );
254: IF ( get_pk_for_validation ( new_references.party_site_id)) THEN
255: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: END IF;
259: END IF;
260:
261: END before_dml;

Line 304: app_exception.raise_exception;

300: ELSE
301: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
302: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.INSERT_ROW');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306:
307:
308: before_dml(

Line 356: app_exception.raise_exception;

352: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
353: fnd_message.set_token ('ERR_CD', SQLCODE);
354: igs_ge_msg_stack.add;
355: igs_sc_gen_001.unset_ctx('R');
356: app_exception.raise_exception;
357: ELSE
358: igs_sc_gen_001.unset_ctx('R');
359: RAISE;
360: END IF;

Line 398: app_exception.raise_exception;

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

Line 412: app_exception.raise_exception;

408: NULL;
409: ELSE
410: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414:
415: RETURN;
416:

Line 459: app_exception.raise_exception;

455: ELSE
456: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
457: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.UPDATE_ROW');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception;
460: END IF;
461:
462: before_dml(
463: p_action => 'UPDATE',

Line 492: app_exception.raise_exception;

488: IF (SQL%NOTFOUND) THEN
489: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
490: igs_ge_msg_stack.add;
491: igs_sc_gen_001.unset_ctx('R');
492: app_exception.raise_exception;
493: END IF;
494: IF (x_mode = 'S') THEN
495: igs_sc_gen_001.unset_ctx('R');
496: END IF;

Line 507: app_exception.raise_exception;

503: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
504: fnd_message.set_token ('ERR_CD', SQLCODE);
505: igs_ge_msg_stack.add;
506: igs_sc_gen_001.unset_ctx('R');
507: app_exception.raise_exception;
508: ELSE
509: igs_sc_gen_001.unset_ctx('R');
510: RAISE;
511: END IF;

Line 595: app_exception.raise_exception;

591: IF (SQL%NOTFOUND) THEN
592: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
593: igs_ge_msg_stack.add;
594: igs_sc_gen_001.unset_ctx('R');
595: app_exception.raise_exception;
596: END IF;
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.unset_ctx('R');
599: END IF;