APPS.IGS_HE_UT_PRS_DTLS_PKG dependencies on IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

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

Line 98: igs_ge_msg_stack.add;

94: new_references.tariff_calc_type_cd,
95: new_references.person_id
96: ) THEN
97: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: -- Check for award cd existance

Line 108: igs_ge_msg_stack.add;

104: (new_references.award_cd IS NULL)) THEN
105: NULL;
106: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation(new_references.award_cd) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: END check_parent_existance;

Line 173: igs_ge_msg_stack.add;

169:
170: IF (cur_rowid%FOUND) THEN
171: CLOSE cur_rowid;
172: fnd_message.set_name ('IGS', 'IGS_HE_HUPD_HUPC_FK');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: RETURN;
176: END IF;
177: CLOSE cur_rowid;

Line 231: igs_ge_msg_stack.add;

227: new_references.award_cd
228: )
229: ) THEN
230: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: END IF;
234: check_parent_existance;
235: ELSIF (p_action = 'VALIDATE_INSERT') THEN

Line 244: igs_ge_msg_stack.add;

240: new_references.award_cd
241: )
242: ) THEN
243: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;
247: END IF;
248:

Line 297: igs_ge_msg_stack.add;

293: END IF;
294: ELSE
295: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
296: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.INSERT_ROW');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300:
301: before_dml(

Line 355: igs_ge_msg_stack.add;

351: WHEN OTHERS THEN
352: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
353: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
354: fnd_message.set_token ('ERR_CD', SQLCODE);
355: igs_ge_msg_stack.add;
356: igs_sc_gen_001.unset_ctx('R');
357: app_exception.raise_exception;
358: ELSE
359: igs_sc_gen_001.unset_ctx('R');

Line 398: igs_ge_msg_stack.add;

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

Line 412: igs_ge_msg_stack.add;

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

Line 461: igs_ge_msg_stack.add;

457: END IF;
458: ELSE
459: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
460: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_DTLS_PKG.UPDATE_ROW');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;
464:
465: before_dml(

Line 494: igs_ge_msg_stack.add;

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

Line 510: igs_ge_msg_stack.add;

506: WHEN OTHERS THEN
507: IF (SQLCODE = (-28115)) THEN
508: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
514: igs_sc_gen_001.unset_ctx('R');

Line 607: igs_ge_msg_stack.add;

603: WHERE rowid = x_rowid;
604:
605: IF (SQL%NOTFOUND) THEN
606: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
607: igs_ge_msg_stack.add;
608: igs_sc_gen_001.unset_ctx('R');
609: app_exception.raise_exception;
610: END IF;
611: IF (x_mode = 'S') THEN