DBA Data[Home] [Help]

APPS.IGS_AS_GEN_006 dependencies on APP_EXCEPTION

Line 11: -- kdande 23-Jan-2004 Removed app_exception.raise_exception since the message

7: -- to assign the grades for audited unit attempts separately.
8: -- For this purpose,added one more cursor to handle audited grades
9: -- 'c_grading_schema_audit_grade' and changed the existing cursor definition 'c_grading_schema_grade'
10: -- to exclude audited grades and retrieve only non-audited ones.
11: -- kdande 23-Jan-2004 Removed app_exception.raise_exception since the message
12: -- being logged is a proper message and not an exception.
13: -- ijeddy, Dec 3, 2003 Grade Book Enh build, bug no 3201661
14: -- gmaheswa 13-nov-2003 Bug No. 3227107 . Address changes. Modified address related cursor to select active records only.
15: -- smadathi 28-AUG-2001 Bug No. 1956374 .The call to igs_as_val_esvs.genp_val_staff_prsn

Line 112: App_Exception.Raise_Exception;

108: WHEN OTHERS THEN
109: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
110: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_GEN_006.assp_get_ese_key');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END assp_get_ese_key;
114: --
115: -- Process to insert administrative grades against student unit attempts which
116: -- have no grade recorded.

Line 909: App_Exception.Raise_Exception;

905: WHEN OTHERS THEN
906: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
907: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_GEN_006.assp_ins_aia');
908: IGS_GE_MSG_STACK.ADD;
909: App_Exception.Raise_Exception;
910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,

Line 985: App_Exception.Raise_Exception;

981: WHEN OTHERS THEN
982: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
983: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_GEN_006.assp_ins_aia_default');
984: IGS_GE_MSG_STACK.ADD;
985: App_Exception.Raise_Exception;
986: END assp_ins_aia_default;
987:
988: PROCEDURE assp_ins_ai_cvr_sht(
989: errbuf OUT NOCOPY VARCHAR2,

Line 1468: App_Exception.Raise_Exception;

1464: IF c_pe%NOTFOUND THEN -- Start of if 4
1465: CLOSE c_pe;
1466: Fnd_Message.Set_Name('FND', 'FORM_RECORD_DELETED');
1467: IGS_GE_MSG_STACK.ADD;
1468: App_Exception.Raise_Exception;
1469: END IF; -- End of if 4
1470:
1471:
1472: CLOSE c_pe;

Line 1539: App_Exception.Raise_Exception;

1535: CLOSE c_crv;
1536: RAISE NO_DATA_FOUND;
1537: Fnd_Message.Set_Name('FND', 'FORM_RECORD_DELETED');
1538: IGS_GE_MSG_STACK.ADD;
1539: App_Exception.Raise_Exception;
1540: END IF; -- End of if 9
1541:
1542: CLOSE c_crv;
1543:

Line 1565: App_Exception.Raise_Exception;

1561: IF c_uv%NOTFOUND THEN -- Start Of if 11
1562: CLOSE c_uv;
1563: Fnd_Message.Set_Name('FND', 'FORM_RECORD_DELETED');
1564: IGS_GE_MSG_STACK.ADD;
1565: App_Exception.Raise_Exception;
1566: END IF; -- End Of if 11
1567:
1568: CLOSE c_uv;
1569: END IF; -- End Of if 10

Line 1579: App_Exception.Raise_Exception;

1575: IF c_um%NOTFOUND THEN -- Start Of if 12
1576: CLOSE c_um;
1577: Fnd_Message.Set_Name('FND', 'FORM_RECORD_DELETED');
1578: IGS_GE_MSG_STACK.ADD;
1579: App_Exception.Raise_Exception;
1580: END IF; -- End Of if 12
1581:
1582: CLOSE c_um;
1583: v_record := v_record ||

Line 1613: App_Exception.Raise_Exception;

1609: IF c_suaav%NOTFOUND THEN -- Start Of if 13
1610: CLOSE c_suaav;
1611: Fnd_Message.Set_Name('FND', 'FORM_RECORD_DELETED');
1612: IGS_GE_MSG_STACK.ADD;
1613: App_Exception.Raise_Exception;
1614: END IF; -- End Of if 13
1615:
1616: CLOSE c_suaav;
1617: v_record := v_record ||

Line 1629: App_Exception.Raise_Exception;

1625: IF c_ai%NOTFOUND THEN --Start Of if 14
1626: CLOSE c_ai;
1627: Fnd_Message.Set_Name('FND', 'FORM_RECORD_DELETED');
1628: IGS_GE_MSG_STACK.ADD;
1629: App_Exception.Raise_Exception;
1630: END IF; -- End Of if 14
1631:
1632: CLOSE c_ai;
1633: v_record := v_record ||

Line 1955: App_Exception.Raise_Exception;

1951: WHEN OTHERS THEN
1952: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1953: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_GEN_006.assp_ins_asr1020_tmp');
1954: IGS_GE_MSG_STACK.ADD;
1955: App_Exception.Raise_Exception;
1956: END assp_ins_asr1020_tmp;
1957: PROCEDURE assp_ins_dflt_evsa_a(
1958: errbuf out NOCOPY varchar2,
1959: retcode out NOCOPY number,

Line 2454: App_Exception.Raise_Exception;

2450: WHEN OTHERS THEN
2451: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2452: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_GEN_006.assp_ins_ese_sprvsr');
2453: IGS_GE_MSG_STACK.ADD;
2454: App_Exception.Raise_Exception;
2455: END assp_ins_ese_sprvsr;
2456: PROCEDURE assp_ins_gs_duprec(
2457: p_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2458: p_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,

Line 2595: App_Exception.Raise_Exception;

2591: WHEN OTHERS THEN
2592: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2593: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_GEN_006.assp_ins_gs_duprec');
2594: IGS_GE_MSG_STACK.ADD;
2595: App_Exception.Raise_Exception;
2596: END assp_ins_gs_duprec;
2597:
2598: PROCEDURE assp_upd_suao_trans(
2599: errbuf out NOCOPY varchar2,