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_PR_GEN_006 dependencies on IGS_PR_GEN_006

Line 1: PACKAGE BODY IGS_PR_GEN_006 AS

1: PACKAGE BODY IGS_PR_GEN_006 AS
2: /* $Header: IGSPR27B.pls 120.0 2005/07/05 11:48:45 appldev noship $ */
3: /*
4: ||==============================================================================||
5: || Created By : Nalin Kumar ||

Line 67: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SCSC_COMP');

63: END;
64: EXCEPTION
65: WHEN OTHERS THEN
66: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
67: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SCSC_COMP');
68: IGS_GE_MSG_STACK.ADD;
69: App_Exception.Raise_Exception;
70: END IGS_PR_get_scsc_comp;
71:

Line 122: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_APLY_DT');

118: RETURN TRUE;
119: EXCEPTION
120: WHEN OTHERS THEN
121: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
122: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_APLY_DT');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IGS_PR_get_spo_aply_dt;
126:

Line 233: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_CMT');

229: END;
230: EXCEPTION
231: WHEN OTHERS THEN
232: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
233: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_CMT');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IGS_PR_get_spo_cmt;
237: FUNCTION IGS_PR_get_spo_expiry(

Line 401: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY');

397: END;
398: EXCEPTION
399: WHEN OTHERS THEN
400: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
401: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY');
402: IGS_GE_MSG_STACK.ADD;
403: App_Exception.Raise_Exception;
404: END IGS_PR_get_spo_expiry;
405:

Line 522: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_STD_GPA');

518: END;
519: EXCEPTION
520: WHEN OTHERS THEN
521: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
522: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_STD_GPA');
523: IGS_GE_MSG_STACK.ADD;
524: App_Exception.Raise_Exception;
525: END IGS_PR_get_std_gpa;
526:

Line 559: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_STD_WAM');

555: END;
556: EXCEPTION
557: WHEN OTHERS THEN
558: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
559: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_STD_WAM');
560: IGS_GE_MSG_STACK.ADD;
561: App_Exception.Raise_Exception;
562: END IGS_PR_get_std_wam;
563:

Line 650: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_WITHIN_APPL.PRGPL_GET_ALIAS_VALUE');

646: END;
647: EXCEPTION
648: WHEN OTHERS THEN
649: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
650: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_WITHIN_APPL.PRGPL_GET_ALIAS_VALUE');
651: IGS_GE_MSG_STACK.ADD;
652: App_Exception.Raise_Exception;
653: END prgpl_get_alias_value;
654:

Line 702: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_WITHIN_APPL');

698: END;
699: EXCEPTION
700: WHEN OTHERS THEN
701: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_WITHIN_APPL');
703: IGS_GE_MSG_STACK.ADD;
704: App_Exception.Raise_Exception;
705: END IGS_PR_get_within_appl;
706:

Line 822: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POC');

818: END;
819: EXCEPTION
820: WHEN OTHERS THEN
821: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
822: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POC');
823: IGS_GE_MSG_STACK.ADD;
824: App_Exception.Raise_Exception;
825: END;
826: END LOOP;

Line 849: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POUS');

845: END;
846: EXCEPTION
847: WHEN OTHERS THEN
848: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
849: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POUS');
850: IGS_GE_MSG_STACK.ADD;
851: App_Exception.Raise_Exception;
852: END;
853: END LOOP;

Line 877: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POA');

873: END;
874: EXCEPTION
875: WHEN OTHERS THEN
876: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
877: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POA');
878: IGS_GE_MSG_STACK.ADD;
879: App_Exception.Raise_Exception;
880: END;
881:

Line 905: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POPU');

901: END;
902: EXCEPTION
903: WHEN OTHERS THEN
904: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
905: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POPU');
906: IGS_GE_MSG_STACK.ADD;
907: App_Exception.Raise_Exception;
908: END;
909: END LOOP;

Line 931: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POPF');

927: END;
928: EXCEPTION
929: WHEN OTHERS THEN
930: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
931: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.C_POPF');
932: IGS_GE_MSG_STACK.ADD;
933: App_Exception.Raise_Exception;
934: END;
935: END LOOP;

Line 962: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.PRGPL_INS_POC_POUS_POPU.');

958: END;
959: EXCEPTION
960: WHEN OTHERS THEN
961: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
962: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.PRGPL_INS_POC_POUS_POPU.');
963: IGS_GE_MSG_STACK.ADD;
964: App_Exception.Raise_Exception;
965: END prgpl_ins_poc_pous_popu;
966:

Line 1153: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.RULE_COPY');

1149: v_pra_rul_sequence_number);
1150: EXCEPTION
1151: WHEN OTHERS THEN
1152: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1153: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.RULE_COPY');
1154: IGS_GE_MSG_STACK.ADD;
1155: App_Exception.Raise_Exception;
1156: END;
1157: END IF;

Line 1236: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.INESRT_RULE_APPL');

1232: END;
1233: EXCEPTION
1234: WHEN OTHERS THEN
1235: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1236: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.INESRT_RULE_APPL');
1237: IGS_GE_MSG_STACK.ADD;
1238: App_Exception.Raise_Exception;
1239: END;
1240: IF v_error_ins_pra = FALSE THEN

Line 1264: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.INSERT_RU_CA');

1260: END;
1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1264: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.INSERT_RU_CA');
1265: IGS_GE_MSG_STACK.ADD;
1266: App_Exception.Raise_Exception;
1267: END;
1268: END LOOP;

Line 1406: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.PRGPL_INS_COPY_PRA');

1402: END;
1403: EXCEPTION
1404: WHEN OTHERS THEN
1405: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1406: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA.PRGPL_INS_COPY_PRA');
1407: IGS_GE_MSG_STACK.ADD;
1408: App_Exception.Raise_Exception;
1409: END prgpl_ins_copy_pra;
1410: BEGIN

Line 1453: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA');

1449: END;
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1453: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_COPY_PRA');
1454: IGS_GE_MSG_STACK.ADD;
1455: App_Exception.Raise_Exception;
1456: END IGS_PR_ins_copy_pra;
1457:

Line 1555: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_SSP_CMP_DTL');

1551: END;
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1555: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_INS_SSP_CMP_DTL');
1556: IGS_GE_MSG_STACK.ADD;
1557: App_Exception.Raise_Exception;
1558: END IGS_PR_ins_ssp_cmp_dtl;
1559:

Line 1634: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (

1630: spo.sequence_number <> p_spo_sequence_number AND
1631: spo.decision_status = cst_approved AND
1632: pot.progression_outcome_type = spo.progression_outcome_type AND
1633: pot.encumbrance_type IS NOT NULL AND
1634: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (
1635: p_person_id,
1636: p_course_cd,
1637: spo.sequence_number,
1638: spo.expiry_dt) <> cst_expired;

Line 1709: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (

1705: (
1706: ( pee.expiry_dt IS NOT NULL AND
1707: pee.expiry_dt > TRUNC(SYSDATE)) OR
1708: ( pee.expiry_dt IS NULL AND
1709: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (
1710: p_person_id,
1711: p_course_cd,
1712: cp_spo_sequence_number,
1713: cp_spo_expiry_dt) <> cst_expired)

Line 2033: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_PEN_CLASH.PRGPL_UPD_PEN_CHECK_CLASH');

2029: END;
2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2033: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_PEN_CLASH.PRGPL_UPD_PEN_CHECK_CLASH');
2034: IGS_GE_MSG_STACK.ADD;
2035: App_Exception.Raise_Exception;
2036: END prgpl_upd_pen_check_clash;
2037: BEGIN

Line 2271: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_PEN_CLASH');

2267: END;
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2271: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_PEN_CLASH');
2272: IGS_GE_MSG_STACK.ADD;
2273: App_Exception.Raise_Exception;
2274: END IGS_PR_upd_pen_clash;
2275:

Line 2463: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SCA_STATUS');

2459: END;
2460: EXCEPTION
2461: WHEN OTHERS THEN
2462: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2463: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SCA_STATUS');
2464: IGS_GE_MSG_STACK.ADD;
2465: App_Exception.Raise_Exception;
2466: END IGS_PR_upd_sca_status;
2467:

Line 3292: IF NOT IGS_PR_GEN_006.IGS_PR_upd_pen_clash (

3288: -- If the encumbrance effect is being re-opened then check for clashes.
3289: IF v_pee_rec.expiry_dt IS NOT NULL AND
3290: v_pee_rec.expiry_dt <= TRUNC(SYSDATE) AND
3291: (p_expiry_dt IS NULL OR p_expiry_dt > TRUNC(SYSDATE)) THEN
3292: IF NOT IGS_PR_GEN_006.IGS_PR_upd_pen_clash (
3293: p_person_id,
3294: p_course_cd,
3295: p_spo_sequence_number,
3296: p_application_type,

Line 3404: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN.PRGPL_UPD_EXPIRY_DT1');

3400: END;
3401: EXCEPTION
3402: WHEN OTHERS THEN
3403: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3404: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN.PRGPL_UPD_EXPIRY_DT1');
3405: IGS_GE_MSG_STACK.ADD;
3406: App_Exception.Raise_Exception;
3407: END prgpl_upd_expiry_dt1;
3408:

Line 3747: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN.PRGPL_UPD_EXPIRY_DT2');

3743: END;
3744: EXCEPTION
3745: WHEN OTHERS THEN
3746: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3747: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN.PRGPL_UPD_EXPIRY_DT2');
3748: IGS_GE_MSG_STACK.ADD;
3749: App_Exception.Raise_Exception;
3750: END prgpl_upd_expiry_dt2;
3751:

Line 3829: v_expiry_status := IGS_PR_GEN_006.IGS_PR_get_spo_expiry (

3825: END IF;
3826: -- Alter expiry date of person encumbrance structures where required
3827:
3828: IF v_spo_rec.expiry_dt <= TRUNC(SYSDATE) THEN
3829: v_expiry_status := IGS_PR_GEN_006.IGS_PR_get_spo_expiry (
3830: p_person_id,
3831: p_course_cd,
3832: p_spo_sequence_number,
3833: v_spo_rec.expiry_dt,

Line 4598: IF NOT IGS_PR_GEN_006.IGS_PR_upd_pen_clash (

4594: IF v_expiry_dt < gcst_sysdate THEN
4595: RETURN TRUE;
4596: END IF;
4597:
4598: IF NOT IGS_PR_GEN_006.IGS_PR_upd_pen_clash (
4599: p_person_id,
4600: p_course_cd,
4601: p_spo_sequence_number,
4602: p_application_type,

Line 4978: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN');

4974: END;
4975: EXCEPTION
4976: WHEN OTHERS THEN
4977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4978: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_UPD_SPO_PEN');
4979: IGS_GE_MSG_STACK.ADD;
4980: App_Exception.Raise_Exception;
4981: END igs_pr_upd_spo_pen;
4982:

Line 5020: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY');

5016:
5017: EXCEPTION
5018: WHEN OTHERS THEN
5019: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5020: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY');
5021: IGS_GE_MSG_STACK.ADD;
5022: App_Exception.Raise_Exception;
5023: END igs_pr_get_spo_expiry;
5024:

Line 5058: END IGS_PR_GEN_006;

5054: RETURN NULL;
5055:
5056: END get_antcp_compl_dt;
5057:
5058: END IGS_PR_GEN_006;