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 IGS_GE_MSG_STACK

Line 45: igs_ge_msg_stack.add;

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;
49: CLOSE cur_old_ref_values;

Line 105: IGS_GE_MSG_STACK.ADD;

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
109: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');

Line 110: 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
114: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');

Line 115: 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;
119:

Line 153: IGS_GE_MSG_STACK.ADD;

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
157: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');

Line 158: 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
162: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STRT_DT_LESS_BIRTH_DT');

Line 163: 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;
167:

Line 243: igs_ge_msg_stack.add;

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
247: -- Call all the procedures related to Before Update.

Line 256: igs_ge_msg_stack.add;

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;
260:

Line 303: igs_ge_msg_stack.add;

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:
307:

Line 354: igs_ge_msg_stack.add;

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
358: igs_sc_gen_001.unset_ctx('R');

Line 396: igs_ge_msg_stack.add;

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;
400: END IF;

Line 411: igs_ge_msg_stack.add;

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:
415: RETURN;

Line 458: igs_ge_msg_stack.add;

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:
462: before_dml(

Line 490: igs_ge_msg_stack.add;

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;
494: IF (x_mode = 'S') THEN

Line 505: igs_ge_msg_stack.add;

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
509: igs_sc_gen_001.unset_ctx('R');

Line 593: igs_ge_msg_stack.add;

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;
597: IF (x_mode = 'S') THEN