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 FND_MESSAGE

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

40: OPEN cur_old_ref_values;
41: FETCH cur_old_ref_values INTO old_references;
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;

Line 104: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SPECIFY_END_DATE');

100: FETCH validate_brth_dt INTO l_bth_dt;
101: CLOSE validate_brth_dt;
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

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

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;
111: APP_EXCEPTION.RAISE_EXCEPTION;
112:
113: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > p_start_dt THEN

Line 114: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_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;
116: APP_EXCEPTION.RAISE_EXCEPTION;
117: END IF;
118: END BeforeRowInsertUpdate;

Line 152: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SPECIFY_END_DATE');

148: FETCH validate_brth_dt INTO l_bth_dt;
149: CLOSE validate_brth_dt;
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

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

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;
159: APP_EXCEPTION.RAISE_EXCEPTION;
160:
161: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > p_start_dt THEN

Line 162: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_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;
164: APP_EXCEPTION.RAISE_EXCEPTION;
165: END IF;
166: END BeforeRowInsertUpdate_ss;

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

238: IF (p_action = 'INSERT') THEN
239: -- Call all the procedures related to Before Insert.
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

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

251: ELSIF (p_action = 'VALIDATE_INSERT') THEN
252: -- Call all the procedures related to Before Insert.
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;

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

297: IF (x_last_update_login IS NULL) THEN
298: x_last_update_login := -1;
299: END IF;
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;

Line 302: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.INSERT_ROW');

298: x_last_update_login := -1;
299: END IF;
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:

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

348:
349: EXCEPTION
350: WHEN OTHERS THEN
351: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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;

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

349: EXCEPTION
350: WHEN OTHERS THEN
351: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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

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

391:
392: OPEN c1;
393: FETCH c1 INTO tlinfo;
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;

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

406: AND ((tlinfo.end_date = x_end_date) OR ((tlinfo.end_date IS NULL) AND (X_end_date IS NULL)))
407: ) THEN
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:

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

452: IF (x_last_update_login IS NULL) THEN
453: x_last_update_login := -1;
454: END IF;
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;

Line 457: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.UPDATE_ROW');

453: x_last_update_login := -1;
454: END IF;
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:

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

485: last_update_login = x_last_update_login
486: WHERE rowid = x_rowid;
487:
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;

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

499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: IF (SQLCODE = (-28115)) THEN
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;

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

500: EXCEPTION
501: WHEN OTHERS THEN
502: IF (SQLCODE = (-28115)) THEN
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

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

588: DELETE FROM igs_pe_hz_pty_sites
589: WHERE rowid = x_rowid;
590:
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;