DBA Data[Home] [Help]

APPS.IGS_FI_GET_SUAEH dependencies on IGS_GE_MSG_STACK

Line 133: IGS_GE_MSG_STACK.ADD;

129: WHEN OTHERS THEN
130: if SQLCODE <> -20001 then
131: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
132: Fnd_Message.Set_Token('NAME','IGS_FI_GET_SUAEH.FINPL_INS_SUA_REC');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
135: else
136: RAISE;
137: end if;

Line 318: IGS_GE_MSG_STACK.ADD;

314: WHEN OTHERS THEN
315: if SQLCODE <> -20001 then
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
317: Fnd_Message.Set_Token('NAME','IGS_FI_GET_SUAEH.FINP_INS_SUAH_REC');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
320: else
321: RAISE;
322: end if;

Line 381: IGS_GE_MSG_STACK.ADD;

377: WHEN OTHERS THEN
378: if SQLCODE <> -20001 then
379: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
380: Fnd_Message.Set_Token('NAME','IGS_FI_GET_SUAEH.FINPL_INS_SUAHV_REC');
381: IGS_GE_MSG_STACK.ADD;
382: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
383: else
384: RAISE;
385: end if;

Line 456: IGS_GE_MSG_STACK.ADD;

452: WHEN OTHERS THEN
453: if SQLCODE <> -20001 then
454: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
455: Fnd_Message.Set_Token('NAME','IGS_FI_GET_SUAEH.FINPL_PRC_SUA_ENRHIST');
456: IGS_GE_MSG_STACK.ADD;
457: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
458: else
459: RAISE;
460: end if;

Line 494: IGS_GE_MSG_STACK.ADD;

490:
491: IF p_person_id IS NULL OR
492: p_effective_dt IS NULL THEN
493: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
496: END IF;
497: -- check if the effective history has already been captured
498: IF gv_person_id IS NOT NULL AND

Line 561: IGS_GE_MSG_STACK.ADD;

557: gv_effective_dt,
558: r_sua);
559: ELSE -- unrecognised status
560: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UNRECOG_SUA_STATUS');
561: IGS_GE_MSG_STACK.ADD;
562: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
563: END IF;
564: ELSE -- processing history effective up until the current day
565: -- check if effective date falls within the current SUA history

Line 807: IGS_GE_MSG_STACK.ADD;

803: RETURN; -- no history
804: END IF;
805: ELSE -- unrecognised status
806: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UNRECOG_SUA_STATUS');
807: IGS_GE_MSG_STACK.ADD;
808: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
809: END IF;
810: END IF;
811: END LOOP;

Line 820: IGS_GE_MSG_STACK.ADD;

816: WHEN OTHERS THEN
817: if SQLCODE <> -20001 then
818: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
819: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_GET_SUAEH.FINP_GET_SUAEH');
820: IGS_GE_MSG_STACK.ADD;
821: lv_param_values := to_char(p_person_id)||','||
822: p_course_cd||','||p_unit_cd||','||
823: igs_ge_date.igschardt(p_effective_dt);
824: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');

Line 826: IGS_GE_MSG_STACK.ADD;

822: p_course_cd||','||p_unit_cd||','||
823: igs_ge_date.igschardt(p_effective_dt);
824: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
825: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
826: IGS_GE_MSG_STACK.ADD;
827: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
828: else
829: RAISE;
830: end if;