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_EN_GEN_010 dependencies on FND_LOG

Line 77: -- to log messages using FND logging instead of throwing unhandled exceptions. Bug# 3360336.

73: --ptandon 11-Dec-2003 Modified procedure adv_stand_trans as part of Bug# 3271754.
74: --ptandon 29-Dec-2003 Removed the Exception Handling sections of functions Enrp_Ins_Sut_Trnsfr and Enrp_Ins_Sua_Trnsfr
75: -- so that the correct error message is displayed. Bug# 3328083 and 3328268.
76: --ptandon 13-Feb-2004 Modified the exception handling sections of enrpl_upd_candidature, enrpl_create_sca and enrp_ins_snew_prenrl
77: -- to log messages using FND logging instead of throwing unhandled exceptions. Bug# 3360336.
78: --ptandon 23-Feb-2004 Modified procedure adv_stand_trans as part of Bug# 3461036.
79: -- amuthu 21-NOV-2004 Modified as part of program transfer build, modified enrp_ins_sua_trnsfr.
80: -- Added new procedure to copy outcome and placement details and added a call to the same in enrp_ins_sua_trnsfr
81: -- ckasu 08-DEC-2004 modfied enrf_unit_from_past procedure as a part of bug#4048203 inorder

Line 971: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

967: END IF;
968: IF c_ca_upd%ISOPEN THEN
969: CLOSE c_ca_upd;
970: END IF;
971: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
972: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
973: END IF;
974: RAISE;
975: WHEN OTHERS THEN

Line 972: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

968: IF c_ca_upd%ISOPEN THEN
969: CLOSE c_ca_upd;
970: END IF;
971: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
972: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.APP_EXP','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
973: END IF;
974: RAISE;
975: WHEN OTHERS THEN
976: IF c_ca%ISOPEN THEN

Line 985: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

981: END IF;
982: IF c_ca_upd%ISOPEN THEN
983: CLOSE c_ca_upd;
984: END IF;
985: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
987: END IF;
988: RAISE;
989: END;

Line 986: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

982: IF c_ca_upd%ISOPEN THEN
983: CLOSE c_ca_upd;
984: END IF;
985: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_upd_candidature.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
987: END IF;
988: RAISE;
989: END;
990: END enrpl_upd_candidature;

Line 1534: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1530: END IF;
1531: IF c_crv%ISOPEN THEN
1532: CLOSE c_crv;
1533: END IF;
1534: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1535: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP1','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1536: END IF;
1537: RAISE;
1538: WHEN OTHERS THEN

Line 1535: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP1','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1531: IF c_crv%ISOPEN THEN
1532: CLOSE c_crv;
1533: END IF;
1534: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1535: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP1','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1536: END IF;
1537: RAISE;
1538: WHEN OTHERS THEN
1539: IF c_sca_upd%ISOPEN THEN

Line 1554: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1550: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_010.enrpl_create_sca1');
1551: IGS_GE_MSG_STACK.ADD;
1552: App_Exception.Raise_Exception;
1553: */
1554: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1555: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP1','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1556: END IF;
1557: RAISE;
1558: END;

Line 1555: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP1','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1551: IGS_GE_MSG_STACK.ADD;
1552: App_Exception.Raise_Exception;
1553: */
1554: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1555: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP1','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1556: END IF;
1557: RAISE;
1558: END;
1559: ELSIF v_sca_rec.course_attempt_status = cst_discontin THEN

Line 1680: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1676: END IF;
1677: IF c_crv%ISOPEN THEN
1678: CLOSE c_crv;
1679: END IF;
1680: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1681: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP2','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1682: END IF;
1683: RAISE;
1684: WHEN OTHERS THEN

Line 1681: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP2','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1677: IF c_crv%ISOPEN THEN
1678: CLOSE c_crv;
1679: END IF;
1680: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1681: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP2','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1682: END IF;
1683: RAISE;
1684: WHEN OTHERS THEN
1685: IF c_sca_upd%ISOPEN THEN

Line 1694: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1690: END IF;
1691: IF c_crv%ISOPEN THEN
1692: CLOSE c_crv;
1693: END IF;
1694: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1695: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP2','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1696: END IF;
1697: RAISE;
1698: END;

Line 1695: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP2','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1691: IF c_crv%ISOPEN THEN
1692: CLOSE c_crv;
1693: END IF;
1694: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1695: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP2','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1696: END IF;
1697: RAISE;
1698: END;
1699: ELSE

Line 1833: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1829: END IF;
1830: IF c_crv%ISOPEN THEN
1831: CLOSE c_crv;
1832: END IF;
1833: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP3','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1835: END IF;
1836: RAISE;
1837: WHEN OTHERS THEN

Line 1834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP3','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1830: IF c_crv%ISOPEN THEN
1831: CLOSE c_crv;
1832: END IF;
1833: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.APP_EXP3','Application Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1835: END IF;
1836: RAISE;
1837: WHEN OTHERS THEN
1838: IF c_sca_upd%ISOPEN THEN

Line 1847: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1843: END IF;
1844: IF c_crv%ISOPEN THEN
1845: CLOSE c_crv;
1846: END IF;
1847: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP3','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1849: END IF;
1850: RAISE;
1851: END;

Line 1848: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP3','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1844: IF c_crv%ISOPEN THEN
1845: CLOSE c_crv;
1846: END IF;
1847: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP3','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1849: END IF;
1850: RAISE;
1851: END;
1852: END IF;

Line 1894: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1890: END IF;
1891: IF c_crv%ISOPEN THEN
1892: CLOSE c_crv;
1893: END IF;
1894: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1895: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1896: END IF;
1897: RAISE;
1898: END;

Line 1895: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

1891: IF c_crv%ISOPEN THEN
1892: CLOSE c_crv;
1893: END IF;
1894: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1895: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.enrpl_create_sca.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
1896: END IF;
1897: RAISE;
1898: END;
1899:

Line 3977: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3973: p_text => l_mesg_txt);
3974: END IF;
3975: l_message_name := NULL;
3976: ELSE
3977: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3978: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
3979: END IF;
3980: RAISE;
3981: END IF;

Line 3978: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);

3974: END IF;
3975: l_message_name := NULL;
3976: ELSE
3977: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3978: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'igs.plsql.igs_en_gen_010.enrp_ins_snew_prenrl.UNH_EXP','Unhandled Exception raised with code '||SQLCODE||' and error '||SQLERRM);
3979: END IF;
3980: RAISE;
3981: END IF;
3982: END;

Line 7297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

7293: v_unt_lvl_transfer_flag VARCHAR2(2) := 'Y';
7294: --
7295: BEGIN
7296: --
7297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
7298: fnd_log.string (
7299: fnd_log.level_procedure,
7300: g_module_head || 'adv_stand_trans.begin',
7301: 'In Params : p_person_id => ' || p_person_id || ';' ||

Line 7298: fnd_log.string (

7294: --
7295: BEGIN
7296: --
7297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
7298: fnd_log.string (
7299: fnd_log.level_procedure,
7300: g_module_head || 'adv_stand_trans.begin',
7301: 'In Params : p_person_id => ' || p_person_id || ';' ||
7302: 'p_course_cd => ' || p_course_cd || ';' ||

Line 7299: fnd_log.level_procedure,

7295: BEGIN
7296: --
7297: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
7298: fnd_log.string (
7299: fnd_log.level_procedure,
7300: g_module_head || 'adv_stand_trans.begin',
7301: 'In Params : p_person_id => ' || p_person_id || ';' ||
7302: 'p_course_cd => ' || p_course_cd || ';' ||
7303: 'p_version_number => ' || p_version_number || ';' ||

Line 7313: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7309: -- Creating the Advance Standing with the new Course_cd.
7310: --
7311: FOR rec_adv_stnd IN cur_adv_stnd (p_person_id, p_course_cd, p_version_number) LOOP
7312: --
7313: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7314: fnd_log.string (
7315: fnd_log.level_statement,
7316: g_module_head || 'adv_stand_trans.cur_adv_stnd',
7317: 'Exemption Institution:' || rec_adv_stnd.exemption_institution_cd

Line 7314: fnd_log.string (

7310: --
7311: FOR rec_adv_stnd IN cur_adv_stnd (p_person_id, p_course_cd, p_version_number) LOOP
7312: --
7313: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7314: fnd_log.string (
7315: fnd_log.level_statement,
7316: g_module_head || 'adv_stand_trans.cur_adv_stnd',
7317: 'Exemption Institution:' || rec_adv_stnd.exemption_institution_cd
7318: );

Line 7315: fnd_log.level_statement,

7311: FOR rec_adv_stnd IN cur_adv_stnd (p_person_id, p_course_cd, p_version_number) LOOP
7312: --
7313: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7314: fnd_log.string (
7315: fnd_log.level_statement,
7316: g_module_head || 'adv_stand_trans.cur_adv_stnd',
7317: 'Exemption Institution:' || rec_adv_stnd.exemption_institution_cd
7318: );
7319: END IF;

Line 7337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7333: ELSE
7334: v_transfer_type := 'NORMAL_TRANSFER';
7335: END IF;
7336: --
7337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7338: fnd_log.string (
7339: fnd_log.level_statement,
7340: g_module_head || 'adv_stand_trans.transfer_type',
7341: 'Transfer Type:' || v_transfer_type

Line 7338: fnd_log.string (

7334: v_transfer_type := 'NORMAL_TRANSFER';
7335: END IF;
7336: --
7337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7338: fnd_log.string (
7339: fnd_log.level_statement,
7340: g_module_head || 'adv_stand_trans.transfer_type',
7341: 'Transfer Type:' || v_transfer_type
7342: );

Line 7339: fnd_log.level_statement,

7335: END IF;
7336: --
7337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7338: fnd_log.string (
7339: fnd_log.level_statement,
7340: g_module_head || 'adv_stand_trans.transfer_type',
7341: 'Transfer Type:' || v_transfer_type
7342: );
7343: END IF;

Line 7368: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7364: );
7365: EXCEPTION
7366: WHEN OTHERS THEN
7367: --
7368: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7369: fnd_log.string (
7370: fnd_log.level_exception,
7371: g_module_head || 'adv_stand_trans.igs_av_adv_standing_pkg_insert_exception',
7372: 'Error:' || SQLERRM

Line 7369: fnd_log.string (

7365: EXCEPTION
7366: WHEN OTHERS THEN
7367: --
7368: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7369: fnd_log.string (
7370: fnd_log.level_exception,
7371: g_module_head || 'adv_stand_trans.igs_av_adv_standing_pkg_insert_exception',
7372: 'Error:' || SQLERRM
7373: );

Line 7370: fnd_log.level_exception,

7366: WHEN OTHERS THEN
7367: --
7368: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7369: fnd_log.string (
7370: fnd_log.level_exception,
7371: g_module_head || 'adv_stand_trans.igs_av_adv_standing_pkg_insert_exception',
7372: 'Error:' || SQLERRM
7373: );
7374: END IF;

Line 7388: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7384: p_version_number,
7385: rec_adv_stnd.exemption_institution_cd
7386: ) LOOP
7387: --
7388: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7389: fnd_log.string (
7390: fnd_log.level_statement,
7391: g_module_head || 'adv_stand_trans.cur_unit_dtls',
7392: rec_unit_dtls.person_id || ';' || rec_unit_dtls.as_course_cd || ';' ||

Line 7389: fnd_log.string (

7385: rec_adv_stnd.exemption_institution_cd
7386: ) LOOP
7387: --
7388: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7389: fnd_log.string (
7390: fnd_log.level_statement,
7391: g_module_head || 'adv_stand_trans.cur_unit_dtls',
7392: rec_unit_dtls.person_id || ';' || rec_unit_dtls.as_course_cd || ';' ||
7393: rec_unit_dtls.as_version_number || ';' || rec_unit_dtls.s_adv_stnd_type || ';' ||

Line 7390: fnd_log.level_statement,

7386: ) LOOP
7387: --
7388: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7389: fnd_log.string (
7390: fnd_log.level_statement,
7391: g_module_head || 'adv_stand_trans.cur_unit_dtls',
7392: rec_unit_dtls.person_id || ';' || rec_unit_dtls.as_course_cd || ';' ||
7393: rec_unit_dtls.as_version_number || ';' || rec_unit_dtls.s_adv_stnd_type || ';' ||
7394: rec_unit_dtls.unit_cd || ';' || rec_unit_dtls.version_number || ';' ||

Line 7423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7419: rec_dest_unit_dtls_found := FALSE;
7420: END IF;
7421: CLOSE cur_dest_unit_dtls;
7422: --
7423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7424: fnd_log.string (
7425: fnd_log.level_statement,
7426: g_module_head || 'adv_stand_trans.dest_unit_dtls_found',
7427: rec_dest_unit_dtls.s_adv_stnd_granting_status

Line 7424: fnd_log.string (

7420: END IF;
7421: CLOSE cur_dest_unit_dtls;
7422: --
7423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7424: fnd_log.string (
7425: fnd_log.level_statement,
7426: g_module_head || 'adv_stand_trans.dest_unit_dtls_found',
7427: rec_dest_unit_dtls.s_adv_stnd_granting_status
7428: );

Line 7425: fnd_log.level_statement,

7421: CLOSE cur_dest_unit_dtls;
7422: --
7423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7424: fnd_log.string (
7425: fnd_log.level_statement,
7426: g_module_head || 'adv_stand_trans.dest_unit_dtls_found',
7427: rec_dest_unit_dtls.s_adv_stnd_granting_status
7428: );
7429: END IF;

Line 7477: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7473: );
7474: EXCEPTION
7475: WHEN OTHERS THEN
7476: --
7477: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7478: fnd_log.string (
7479: fnd_log.level_exception,
7480: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_insert_exception',
7481: 'Error:' || SQLERRM

Line 7478: fnd_log.string (

7474: EXCEPTION
7475: WHEN OTHERS THEN
7476: --
7477: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7478: fnd_log.string (
7479: fnd_log.level_exception,
7480: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_insert_exception',
7481: 'Error:' || SQLERRM
7482: );

Line 7479: fnd_log.level_exception,

7475: WHEN OTHERS THEN
7476: --
7477: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7478: fnd_log.string (
7479: fnd_log.level_exception,
7480: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_insert_exception',
7481: 'Error:' || SQLERRM
7482: );
7483: END IF;

Line 7506: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7502: );
7503: EXCEPTION
7504: WHEN OTHERS THEN
7505: --
7506: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7507: fnd_log.string (
7508: fnd_log.level_exception,
7509: g_module_head || 'adv_stand_trans.igs_av_std_unt_basis_pkg_insert_exception',
7510: 'Error:' || SQLERRM

Line 7507: fnd_log.string (

7503: EXCEPTION
7504: WHEN OTHERS THEN
7505: --
7506: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7507: fnd_log.string (
7508: fnd_log.level_exception,
7509: g_module_head || 'adv_stand_trans.igs_av_std_unt_basis_pkg_insert_exception',
7510: 'Error:' || SQLERRM
7511: );

Line 7508: fnd_log.level_exception,

7504: WHEN OTHERS THEN
7505: --
7506: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7507: fnd_log.string (
7508: fnd_log.level_exception,
7509: g_module_head || 'adv_stand_trans.igs_av_std_unt_basis_pkg_insert_exception',
7510: 'Error:' || SQLERRM
7511: );
7512: END IF;

Line 7535: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7531: );
7532: EXCEPTION
7533: WHEN OTHERS THEN
7534: --
7535: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7536: fnd_log.string (
7537: fnd_log.level_exception,
7538: g_module_head || 'adv_stand_trans.igs_av_stnd_alt_unit_pkg_insert_exception',
7539: 'Error:' || SQLERRM

Line 7536: fnd_log.string (

7532: EXCEPTION
7533: WHEN OTHERS THEN
7534: --
7535: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7536: fnd_log.string (
7537: fnd_log.level_exception,
7538: g_module_head || 'adv_stand_trans.igs_av_stnd_alt_unit_pkg_insert_exception',
7539: 'Error:' || SQLERRM
7540: );

Line 7537: fnd_log.level_exception,

7533: WHEN OTHERS THEN
7534: --
7535: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7536: fnd_log.string (
7537: fnd_log.level_exception,
7538: g_module_head || 'adv_stand_trans.igs_av_stnd_alt_unit_pkg_insert_exception',
7539: 'Error:' || SQLERRM
7540: );
7541: END IF;

Line 7585: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7581: );
7582: EXCEPTION
7583: WHEN OTHERS THEN
7584: --
7585: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7586: fnd_log.string (
7587: fnd_log.level_exception,
7588: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_dest_update_exception',
7589: 'Error:' || SQLERRM

Line 7586: fnd_log.string (

7582: EXCEPTION
7583: WHEN OTHERS THEN
7584: --
7585: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7586: fnd_log.string (
7587: fnd_log.level_exception,
7588: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_dest_update_exception',
7589: 'Error:' || SQLERRM
7590: );

Line 7587: fnd_log.level_exception,

7583: WHEN OTHERS THEN
7584: --
7585: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7586: fnd_log.string (
7587: fnd_log.level_exception,
7588: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_dest_update_exception',
7589: 'Error:' || SQLERRM
7590: );
7591: END IF;

Line 7638: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7634: END IF;
7635: EXCEPTION
7636: WHEN OTHERS THEN
7637: --
7638: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7639: fnd_log.string (
7640: fnd_log.level_exception,
7641: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_src_update_exception',
7642: 'Error:' || SQLERRM

Line 7639: fnd_log.string (

7635: EXCEPTION
7636: WHEN OTHERS THEN
7637: --
7638: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7639: fnd_log.string (
7640: fnd_log.level_exception,
7641: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_src_update_exception',
7642: 'Error:' || SQLERRM
7643: );

Line 7640: fnd_log.level_exception,

7636: WHEN OTHERS THEN
7637: --
7638: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7639: fnd_log.string (
7640: fnd_log.level_exception,
7641: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_src_update_exception',
7642: 'Error:' || SQLERRM
7643: );
7644: END IF;

Line 7659: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7655: p_version_number,
7656: rec_adv_stnd.exemption_institution_cd
7657: ) LOOP
7658: --
7659: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7660: fnd_log.string (
7661: fnd_log.level_statement,
7662: g_module_head || 'adv_stand_trans.cur_unit_lvl_dtls',
7663: rec_unit_lvl_dtls.person_id || ';' || rec_unit_lvl_dtls.as_course_cd || ';' ||

Line 7660: fnd_log.string (

7656: rec_adv_stnd.exemption_institution_cd
7657: ) LOOP
7658: --
7659: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7660: fnd_log.string (
7661: fnd_log.level_statement,
7662: g_module_head || 'adv_stand_trans.cur_unit_lvl_dtls',
7663: rec_unit_lvl_dtls.person_id || ';' || rec_unit_lvl_dtls.as_course_cd || ';' ||
7664: rec_unit_lvl_dtls.as_version_number || ';' || rec_unit_lvl_dtls.s_adv_stnd_type || ';' ||

Line 7661: fnd_log.level_statement,

7657: ) LOOP
7658: --
7659: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7660: fnd_log.string (
7661: fnd_log.level_statement,
7662: g_module_head || 'adv_stand_trans.cur_unit_lvl_dtls',
7663: rec_unit_lvl_dtls.person_id || ';' || rec_unit_lvl_dtls.as_course_cd || ';' ||
7664: rec_unit_lvl_dtls.as_version_number || ';' || rec_unit_lvl_dtls.s_adv_stnd_type || ';' ||
7665: rec_unit_lvl_dtls.unit_level || ';' || rec_unit_lvl_dtls.crs_group_ind || ';' ||

Line 7695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7691: rec_dest_unit_lvl_dtls_found := FALSE;
7692: END IF;
7693: CLOSE cur_dest_unit_lvl_dtls;
7694: --
7695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7696: fnd_log.string (
7697: fnd_log.level_statement,
7698: g_module_head || 'adv_stand_trans.dest_unit_lvl_dtls_found',
7699: rec_dest_unit_lvl_dtls.s_adv_stnd_granting_status

Line 7696: fnd_log.string (

7692: END IF;
7693: CLOSE cur_dest_unit_lvl_dtls;
7694: --
7695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7696: fnd_log.string (
7697: fnd_log.level_statement,
7698: g_module_head || 'adv_stand_trans.dest_unit_lvl_dtls_found',
7699: rec_dest_unit_lvl_dtls.s_adv_stnd_granting_status
7700: );

Line 7697: fnd_log.level_statement,

7693: CLOSE cur_dest_unit_lvl_dtls;
7694: --
7695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7696: fnd_log.string (
7697: fnd_log.level_statement,
7698: g_module_head || 'adv_stand_trans.dest_unit_lvl_dtls_found',
7699: rec_dest_unit_lvl_dtls.s_adv_stnd_granting_status
7700: );
7701: END IF;

Line 7743: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7739: );
7740: EXCEPTION
7741: WHEN OTHERS THEN
7742: --
7743: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7744: fnd_log.string (
7745: fnd_log.level_exception,
7746: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7747: 'Error:' || SQLERRM

Line 7744: fnd_log.string (

7740: EXCEPTION
7741: WHEN OTHERS THEN
7742: --
7743: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7744: fnd_log.string (
7745: fnd_log.level_exception,
7746: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7747: 'Error:' || SQLERRM
7748: );

Line 7745: fnd_log.level_exception,

7741: WHEN OTHERS THEN
7742: --
7743: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7744: fnd_log.string (
7745: fnd_log.level_exception,
7746: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7747: 'Error:' || SQLERRM
7748: );
7749: END IF;

Line 7773: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7769: );
7770: EXCEPTION
7771: WHEN OTHERS THEN
7772: --
7773: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7774: fnd_log.string (
7775: fnd_log.level_exception,
7776: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7777: 'Error:' || SQLERRM

Line 7774: fnd_log.string (

7770: EXCEPTION
7771: WHEN OTHERS THEN
7772: --
7773: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7774: fnd_log.string (
7775: fnd_log.level_exception,
7776: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7777: 'Error:' || SQLERRM
7778: );

Line 7775: fnd_log.level_exception,

7771: WHEN OTHERS THEN
7772: --
7773: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7774: fnd_log.string (
7775: fnd_log.level_exception,
7776: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7777: 'Error:' || SQLERRM
7778: );
7779: END IF;

Line 7818: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7814: );
7815: EXCEPTION
7816: WHEN OTHERS THEN
7817: --
7818: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7819: fnd_log.string (
7820: fnd_log.level_exception,
7821: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_dest_update_exception',
7822: 'Error:' || SQLERRM

Line 7819: fnd_log.string (

7815: EXCEPTION
7816: WHEN OTHERS THEN
7817: --
7818: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7819: fnd_log.string (
7820: fnd_log.level_exception,
7821: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_dest_update_exception',
7822: 'Error:' || SQLERRM
7823: );

Line 7820: fnd_log.level_exception,

7816: WHEN OTHERS THEN
7817: --
7818: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7819: fnd_log.string (
7820: fnd_log.level_exception,
7821: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_dest_update_exception',
7822: 'Error:' || SQLERRM
7823: );
7824: END IF;

Line 7866: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

7862: END IF;
7863: EXCEPTION
7864: WHEN OTHERS THEN
7865: --
7866: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7867: fnd_log.string (
7868: fnd_log.level_exception,
7869: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_src_update_exception',
7870: 'Error:' || SQLERRM

Line 7867: fnd_log.string (

7863: EXCEPTION
7864: WHEN OTHERS THEN
7865: --
7866: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7867: fnd_log.string (
7868: fnd_log.level_exception,
7869: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_src_update_exception',
7870: 'Error:' || SQLERRM
7871: );

Line 7868: fnd_log.level_exception,

7864: WHEN OTHERS THEN
7865: --
7866: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7867: fnd_log.string (
7868: fnd_log.level_exception,
7869: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_src_update_exception',
7870: 'Error:' || SQLERRM
7871: );
7872: END IF;