DBA Data[Home] [Help]

APPS.IGR_GEN_001 dependencies on APP_EXCEPTION

Line 83: APP_EXCEPTION.RAISE_EXCEPTION;

79: -- And if yes stop the Processing.
80: IF p_enquiry_dt_high < p_enquiry_dt_low THEN
81: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_VALIDATION');
82: IGS_GE_MSG_STACK.ADD;
83: APP_EXCEPTION.RAISE_EXCEPTION;
84: END IF;
85: DECLARE
86: cst_acknowlege CONSTANT VARCHAR2(30) := 'OSS_ACKNOWLEGE';
87: cst_complete CONSTANT VARCHAR2(30) := 'OSS_COMPLETE';

Line 315: APP_EXCEPTION.RAISE_EXCEPTION;

311: CLOSE c_eapmpi_epi;
312: END IF;
313: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CANPRC_CURUPD_USER');
314: IGS_GE_MSG_STACK.ADD;
315: APP_EXCEPTION.RAISE_EXCEPTION;
316: WHEN OTHERS THEN
317: IF c_eapmpi_epi%ISOPEN THEN
318: CLOSE c_eapmpi_epi;
319: END IF;

Line 320: app_exception.raise_exception;

316: WHEN OTHERS THEN
317: IF c_eapmpi_epi%ISOPEN THEN
318: CLOSE c_eapmpi_epi;
319: END IF;
320: app_exception.raise_exception;
321: END;
322: EXCEPTION
323: WHEN OTHERS THEN
324: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 327: App_Exception.Raise_Exception;

323: WHEN OTHERS THEN
324: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
325: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_012.update_mailed_dt');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END update_mailed_dt;
329:
330: /***********New local procedure added as part of IDOPA2 to update mailed_dt in case of inq_info_type not null ******/
331: PROCEDURE create_person_id_group_secur (

Line 368: App_Exception.Raise_Exception;

364: WHEN OTHERS THEN
365: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
366: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_012.create_person_id_group_secur');
367: IGS_GE_MSG_STACK.ADD;
368: App_Exception.Raise_Exception;
369: END create_person_id_group_secur;
370:
371: FUNCTION create_person_id_group(p_responsible_user IN NUMBER)
372: RETURN NUMBER

Line 442: app_exception.raise_exception;

438: WHEN OTHERS THEN
439: IF c_get_next_seq%ISOPEN THEN
440: CLOSE c_get_next_seq;
441: END IF;
442: app_exception.raise_exception;
443: END;
444: EXCEPTION
445: WHEN OTHERS THEN
446: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 449: App_Exception.Raise_Exception;

445: WHEN OTHERS THEN
446: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
447: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_012.create_person_id_group');
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END create_person_id_group;
451:
452: PROCEDURE create_person_id_group_member (
453: p_group_id igs_pe_prsid_grp_mem.group_id%TYPE,

Line 505: APP_EXCEPTION.RAISE_EXCEPTION;

501: WHEN OTHERS THEN
502: IF c_pigm%ISOPEN THEN
503: CLOSE c_pigm;
504: END IF;
505: APP_EXCEPTION.RAISE_EXCEPTION;
506: END;
507: EXCEPTION
508: WHEN OTHERS THEN
509: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 512: App_Exception.Raise_Exception;

508: WHEN OTHERS THEN
509: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
510: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_012.create_person_id_group_member');
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception;
513: END create_person_id_group_member;
514: BEGIN
515: -- 1. Set default values for later processing
516: -- Get default status values for system enquiry statuses 'OSS_COMPLETE' and

Line 1533: APP_EXCEPTION.RAISE_EXCEPTION;

1529:
1530:
1531: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CANPRC_CURUPD_USER');
1532: IGS_GE_MSG_STACK.ADD;
1533: APP_EXCEPTION.RAISE_EXCEPTION;
1534: WHEN OTHERS THEN
1535: IF c_es%ISOPEN THEN
1536: CLOSE c_es;
1537: END IF;

Line 1569: APP_EXCEPTION.RAISE_EXCEPTION;

1565: IF c_pkgitems_get_avail%ISOPEN THEN
1566: CLOSE c_pkgitems_get_avail;
1567: END IF;
1568:
1569: APP_EXCEPTION.RAISE_EXCEPTION;
1570: END;
1571: EXCEPTION
1572: WHEN OTHERS THEN
1573: retcode := 2;

Line 1689: App_Exception.Raise_Exception;

1685: ROLLBACK TO sp_save_point;
1686: p_message_name := 'IGS_AD_NOTDEL_ENQUIRYPACKAGE';
1687: RETURN FALSE;
1688: WHEN OTHERS THEN
1689: App_Exception.Raise_Exception;
1690: END;
1691: END LOOP;
1692:
1693: RETURN TRUE;

Line 1705: App_Exception.Raise_Exception;

1701: END IF;
1702: IF c_eapmpi_del%ISOPEN THEN
1703: CLOSE c_eapmpi_del;
1704: END IF;
1705: App_Exception.Raise_Exception;
1706: END;
1707: EXCEPTION
1708: WHEN OTHERS THEN
1709: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 1712: App_Exception.Raise_Exception;

1708: WHEN OTHERS THEN
1709: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1710: Fnd_Message.Set_Token('NAME','IGR_GEN_001.admp_del_eap_eitpi');
1711: IGS_GE_MSG_STACK.ADD;
1712: App_Exception.Raise_Exception;
1713: END admp_del_eap_eitpi;
1714:
1715: Function Admp_Ins_Eap_Eitpi(
1716: p_person_id IN NUMBER ,

Line 1811: APP_EXCEPTION.RAISE_EXCEPTION;

1807: END IF;
1808: IF c_eapmpi_exists%ISOPEN THEN
1809: CLOSE c_eapmpi_exists;
1810: END IF;
1811: APP_EXCEPTION.RAISE_EXCEPTION;
1812: END;
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 1818: App_Exception.Raise_Exception;

1814: WHEN OTHERS THEN
1815: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1816: Fnd_Message.Set_Token('NAME','IGR_GEN_001.admp_ins_eap_eitpi');
1817: IGS_GE_MSG_STACK.ADD;
1818: App_Exception.Raise_Exception;
1819: END; -- admp_ins_eap_eitpi
1820:
1821:
1822: END igr_gen_001;