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_AD_SS_GEN_001 dependencies on IGS_AD_SS_GEN_001

Line 1: PACKAGE BODY IGS_AD_SS_GEN_001 AS

1: PACKAGE BODY IGS_AD_SS_GEN_001 AS
2: /* $Header: IGSADB8B.pls 120.36 2006/06/14 12:08:38 arvsrini ship $ */
3: /******************************************************************
4: Created By: tapash.ray
5: Date Created By: 11-DEC-2002

Line 96: IGS_AD_SS_GEN_001.g_admin_security_on := 'Y';

92: -- begin apadegal
93: -- Procedure to set the admin security on
94: PROCEDURE set_adm_secur_on IS
95: BEGIN
96: IGS_AD_SS_GEN_001.g_admin_security_on := 'Y';
97: END;
98: -- proceudre to set the admin security off
99: PROCEDURE set_adm_secur_off IS
100: BEGIN

Line 101: IGS_AD_SS_GEN_001.g_admin_security_on := 'N';

97: END;
98: -- proceudre to set the admin security off
99: PROCEDURE set_adm_secur_off IS
100: BEGIN
101: IGS_AD_SS_GEN_001.g_admin_security_on := 'N';
102: END;
103: -- end apadegal
104:
105:

Line 214: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_data -'||SQLERRM);

210:
211: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
212: FND_MSG_PUB.Count_Msg < 1 THEN
213: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
214: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_data -'||SQLERRM);
215: IGS_GE_MSG_STACK.ADD;
216: x_message_name := 'IGS_GE_UNHANDLED_EXP';
217: END IF;
218: App_Exception.Raise_Exception;

Line 332: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application -'||SQLERRM);

328:
329: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
330: FND_MSG_PUB.Count_Msg < 1 THEN
331: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
332: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application -'||SQLERRM);
333: IGS_GE_MSG_STACK.ADD;
334: p_message_name := 'IGS_GE_UNHANDLED_EXP';
335: END IF;
336: App_Exception.Raise_Exception;

Line 637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_program -'||SQLERRM);

633:
634: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
635: FND_MSG_PUB.Count_Msg < 1 THEN
636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_program -'||SQLERRM);
638: IGS_GE_MSG_STACK.ADD;
639: p_message_name := 'IGS_GE_UNHANDLED_EXP';
640: END IF;
641: App_Exception.Raise_Exception;

Line 690: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

686: -- Setting Person Mandatory Validations to False
687: IGS_PE_GEN_004.SKIP_MAND_DATA_VAL;
688:
689:
690: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
691: THEN
692: lv_mode := 'S';
693: END IF;
694:

Line 724: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_person_type -'||SQLERRM);

720: IGS_GE_NUMBER.TO_CANN(p_person_id),
721: 'S');
722: IF FND_MSG_PUB.Count_Msg < 1 THEN
723: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
724: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_person_type -'||SQLERRM);
725: IGS_GE_MSG_STACK.ADD;
726: END IF;
727: App_Exception.Raise_Exception;
728: END update_person_type;

Line 784: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

780: l_rowid := '';
781: l_unit_set_id := 0;
782:
783:
784: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
785: THEN
786: lv_mode := 'S';
787: END IF;
788:

Line 811: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_unit_set_dtls -'||SQLERRM);

807: IGS_GE_NUMBER.TO_CANN(p_person_id),
808: 'S');
809: IF FND_MSG_PUB.Count_Msg < 1 THEN
810: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
811: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_unit_set_dtls -'||SQLERRM);
812: IGS_GE_MSG_STACK.ADD;
813: END IF;
814:
815: App_Exception.Raise_Exception;

Line 850: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

846: l_rowid := '';
847: l_acad_interest_id := 0;
848:
849:
850: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
851: THEN
852: lv_mode := 'S';
853: END IF;
854:

Line 875: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_acad_interest -'||SQLERRM);

871: IGS_GE_NUMBER.TO_CANN(p_person_id),
872: 'S');
873: IF FND_MSG_PUB.Count_Msg < 1 THEN
874: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
875: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_acad_interest -'||SQLERRM);
876: IGS_GE_MSG_STACK.ADD;
877: END IF;
878: App_Exception.Raise_Exception;
879: END insert_acad_interest;

Line 911: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

907: logDetail('Before call to IGS_AD_APP_INTENT_PKG.insert_row', 'S');
908: l_rowid := '';
909: l_app_intent_id := 0;
910:
911: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
912: THEN
913: lv_mode := 'S';
914: END IF;
915: IGS_AD_APP_INTENT_PKG.insert_row(x_rowid => l_rowid,

Line 954: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_applicant_intent -'||SQLERRM);

950: IGS_GE_NUMBER.TO_CANN(p_person_id),
951: 'S');
952: IF FND_MSG_PUB.Count_Msg < 1 THEN
953: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
954: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_applicant_intent -'||SQLERRM);
955: IGS_GE_MSG_STACK.ADD;
956: END IF;
957: App_Exception.Raise_Exception;
958: END insert_applicant_intent;

Line 991: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

987: l_rowid := '';
988: l_spl_talent_id := 0;
989:
990:
991: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
992: THEN
993: lv_mode := 'S';
994: END IF;
995: IGS_AD_SPL_TALENTS_PKG.insert_row(x_rowid => l_rowid,

Line 1013: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_spl_talent -'||SQLERRM);

1009: IGS_GE_NUMBER.TO_CANN(p_person_id),
1010: 'S');
1011: IF FND_MSG_PUB.Count_Msg < 1 THEN
1012: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1013: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_spl_talent -'||SQLERRM);
1014: IGS_GE_MSG_STACK.ADD;
1015: END IF;
1016: App_Exception.Raise_Exception;
1017: END insert_spl_talent;

Line 1049: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

1045: 'S');
1046: l_rowid := '';
1047: l_spl_interest_id := 0;
1048:
1049: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
1050: THEN
1051: lv_mode := 'S';
1052: END IF;
1053:

Line 1072: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_special_interest -'||SQLERRM);

1068: IGS_GE_NUMBER.TO_CANN(p_person_id),
1069: 'S');
1070: IF FND_MSG_PUB.Count_Msg < 1 THEN
1071: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1072: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_special_interest -'||SQLERRM);
1073: IGS_GE_MSG_STACK.ADD;
1074: END IF;
1075: App_Exception.Raise_Exception;
1076: END insert_special_interest;

Line 1104: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

1100: AND othinst.ss_adm_appl_id = p_adm_appl_id; -- p_admission_appl_number;
1101:
1102: BEGIN
1103:
1104: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
1105: THEN
1106: lv_mode := 'S';
1107: END IF;
1108:

Line 1130: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_othinst -'||SQLERRM);

1126: IGS_GE_NUMBER.TO_CANN(p_person_id),
1127: 'S');
1128: IF FND_MSG_PUB.Count_Msg < 1 THEN
1129: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1130: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_othinst -'||SQLERRM);
1131: IGS_GE_MSG_STACK.ADD;
1132: END IF;
1133: App_Exception.Raise_Exception;
1134: END insert_othinst;

Line 1166: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

1162: AND person_id = p_person_id);
1163: BEGIN
1164: logHeader('insert_edugoal_details', 'S');
1165:
1166: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
1167: THEN
1168: lv_mode := 'S';
1169: END IF;
1170: FOR c_postenroll_edu_goal_rec IN c_postenroll_edu_goal LOOP

Line 1197: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_edugoal_details -'||SQLERRM);

1193: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1194: 'S');
1195: IF FND_MSG_PUB.Count_Msg < 1 THEN
1196: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1197: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_edugoal_details -'||SQLERRM);
1198: IGS_GE_MSG_STACK.ADD;
1199: END IF;
1200: App_Exception.Raise_Exception;
1201: END insert_edugoal_details;

Line 1266: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_stg -'||SQLERRM);

1262: x_return_status := 'E';
1263: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1264: IF FND_MSG_PUB.Count_Msg < 1 THEN
1265: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1266: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_stg -'||SQLERRM);
1267: IGS_GE_MSG_STACK.ADD;
1268: END IF;
1269: App_Exception.Raise_Exception;
1270: END insert_ss_appl_stg;

Line 1352: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_perstat_stg -'||SQLERRM);

1348: p_return_status := 'E';
1349: p_message_data := 'IGS_GE_UNHANDLED_EXP';
1350: IF FND_MSG_PUB.Count_Msg < 1 THEN
1351: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1352: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_perstat_stg -'||SQLERRM);
1353: IGS_GE_MSG_STACK.ADD;
1354: END IF;
1355: App_Exception.Raise_Exception;
1356: END insert_ss_appl_perstat_stg;

Line 1449: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.delete_ss_appl_stg -'||SQLERRM);

1445: x_return_status := 'E';
1446: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1447: IF FND_MSG_PUB.Count_Msg < 1 THEN
1448: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1449: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.delete_ss_appl_stg -'||SQLERRM);
1450: IGS_GE_MSG_STACK.ADD;
1451: END IF;
1452: App_Exception.Raise_Exception;
1453:

Line 1497: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

1493: c_ss_appl_perstat_rec c_ss_appl_perstat%ROWTYPE;
1494:
1495: BEGIN
1496:
1497: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
1498: THEN
1499: lv_mode := 'S';
1500: END IF;
1501: --

Line 1589: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_attachment -'||SQLERRM);

1585: x_return_status := 'E';
1586: logDetail('Exception from transfer_attachment ' || SQLERRM, 'S');
1587: IF FND_MSG_PUB.Count_Msg < 1 THEN
1588: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1589: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_attachment -'||SQLERRM);
1590: IGS_GE_MSG_STACK.ADD;
1591: END IF;
1592:
1593: App_Exception.Raise_Exception;

Line 1755: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_FeeExists -'||SQLERRM);

1751: x_message_data := 'IGS_GE_UNHANDLED_EXP';
1752: logDetail('Exception from Check_FeeExists ' || SQLERRM, 'S');
1753: IF FND_MSG_PUB.Count_Msg < 1 THEN
1754: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1755: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_FeeExists -'||SQLERRM);
1756: IGS_GE_MSG_STACK.ADD;
1757: END IF;
1758: App_Exception.Raise_Exception;
1759:

Line 1783: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop';

1779: l_debug_str VARCHAR2(4000);
1780:
1781: BEGIN
1782:
1783: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop';
1784: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.start';
1785:
1786: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1787: l_debug_str := 'Starting values : Person ID =' || p_person_id || 'Admission cat ='||p_admission_cat ||

Line 1784: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.start';

1780:
1781: BEGIN
1782:
1783: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop';
1784: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.start';
1785:
1786: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1787: l_debug_str := 'Starting values : Person ID =' || p_person_id || 'Admission cat ='||p_admission_cat ||
1788: 'sytem Admission process type ='|| p_admission_process_type;

Line 1803: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.After_Auto_accept_Step_incl';

1799: And STEP_GROUP_TYPE <> 'TRACK'; --2402377
1800:
1801:
1802: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1803: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.After_Auto_accept_Step_incl';
1804: l_debug_str := 'Auto Accept step is included for APC';
1805: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1806: END IF;
1807:

Line 1817: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.After_Auto_offer_Step_incl';

1813: And S_ADMISSION_PROCESS_TYPE = p_admission_process_type
1814: And STEP_GROUP_TYPE <> 'TRACK'; -- 2402377
1815:
1816: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1817: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.After_Auto_offer_Step_incl';
1818: l_debug_str := 'Auto Accept step is included for APC';
1819: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1820: END IF;
1821:

Line 1827: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.One_Stop';

1823: -- else return 'S'
1824:
1825: If (l_accept IS NOT NULL And l_offer IS NOT NULL) Then
1826: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1827: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.One_Stop';
1828: l_debug_str := 'Its One Stop Application !';
1829: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1830: END IF;
1831: l_one_stop := 'Y';

Line 1841: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.No_data_found';

1837:
1838: EXCEPTION
1839: WHEN NO_DATA_FOUND THEN
1840: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1841: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.No_data_found';
1842: l_debug_str := 'It Not An One Stop Application ';
1843: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1844: END IF;
1845:

Line 1853: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.Exception_when_others';

1849: x_message_data := 'IGS_AD_ONESTOP_NO_DATA_FOUND';
1850:
1851: WHEN OTHERS THEN
1852: IF fnd_log.test(fnd_log.level_Exception,l_prog_label) THEN
1853: l_label := 'igs.plsql.igs_ad_ss_gen_001.Check_OneStop.Exception_when_others';
1854: l_debug_str := 'In Exception- When Others block of Check_OneStop';
1855: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1856: END IF;
1857:

Line 1863: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_OneStop -'||SQLERRM);

1859: x_message_data := 'IGS_GE_UNHANDLED_EXP';
1860: logDetail('Exception from Check_OneStop ' || SQLERRM, 'S');
1861: IF FND_MSG_PUB.Count_Msg < 1 THEN
1862: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1863: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_OneStop -'||SQLERRM);
1864: IGS_GE_MSG_STACK.ADD;
1865: END IF;
1866: App_Exception.Raise_Exception;
1867:

Line 1902: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop';

1898:
1899:
1900: BEGIN
1901:
1902: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop';
1903: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.start';
1904:
1905: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1906: l_debug_str := 'Starting values : Adm appl No ='|| p_admission_appl_number ||'Person ID =' || p_person_id || 'Admission cat ='||p_admission_cat ||

Line 1903: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.start';

1899:
1900: BEGIN
1901:
1902: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop';
1903: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.start';
1904:
1905: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1906: l_debug_str := 'Starting values : Adm appl No ='|| p_admission_appl_number ||'Person ID =' || p_person_id || 'Admission cat ='||p_admission_cat ||
1907: 'sytem Admission process type ='|| p_admission_process_type;

Line 1929: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.Before_check_update_aeps_acs';

1925:
1926: BEGIN
1927:
1928: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1929: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.Before_check_update_aeps_acs';
1930: l_debug_str := 'Beofore IGS_AD_SS_APPL_FEE_PKG.check_update_aeps_acs';
1931: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1932: END IF;
1933:

Line 1943: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_update_aeps_acs_ret_Status';

1939: l_msg_count,
1940: l_msg_data);
1941:
1942: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1943: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_update_aeps_acs_ret_Status';
1944: l_debug_str := 'After check_update_aeps_acs l_return_status: ' || l_return_status;
1945: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1946:
1947: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_update_aeps_acs_msg_Data';

Line 1947: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_update_aeps_acs_msg_Data';

1943: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_update_aeps_acs_ret_Status';
1944: l_debug_str := 'After check_update_aeps_acs l_return_status: ' || l_return_status;
1945: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1946:
1947: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_update_aeps_acs_msg_Data';
1948: l_debug_str := 'After check_update_aeps_acs l_msg_data: ' || l_msg_data;
1949: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1950: END IF;
1951:

Line 1973: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.after_Update_Appl_Eqdo_Inst_ret_Stat';

1969: l_message_data);
1970:
1971:
1972: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1973: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.after_Update_Appl_Eqdo_Inst_ret_Stat';
1974: l_debug_str := 'After Update_Appl_Eqdo_Inst l_return_status: ' || l_return_status;
1975: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1976:
1977: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Eqdo_Inst_msg_Data';

Line 1977: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Eqdo_Inst_msg_Data';

1973: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.after_Update_Appl_Eqdo_Inst_ret_Stat';
1974: l_debug_str := 'After Update_Appl_Eqdo_Inst l_return_status: ' || l_return_status;
1975: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1976:
1977: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Eqdo_Inst_msg_Data';
1978: l_debug_str := 'After Update_Appl_Eqdo_Inst l_message_data: ' || l_message_data;
1979: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1980:
1981: END IF;

Line 2007: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_offer_update_return_Stat';

2003: l_msg_count,
2004: l_msg_data);
2005:
2006: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2007: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_offer_update_return_Stat';
2008: l_debug_str := 'After check_offer_update l_return_status: ' || l_return_status;
2009: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2010:
2011: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_offer_update_Data_msg_Data';

Line 2011: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_offer_update_Data_msg_Data';

2007: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_offer_update_return_Stat';
2008: l_debug_str := 'After check_offer_update l_return_status: ' || l_return_status;
2009: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2010:
2011: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_check_offer_update_Data_msg_Data';
2012: l_debug_str := 'After check_offer_update l_msg_data: ' || l_msg_data;
2013: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2014: END IF;
2015:

Line 2036: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Ofr_Inst_ret_Stat';

2032: l_return_status,
2033: l_message_data);
2034:
2035: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2036: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Ofr_Inst_ret_Stat';
2037: l_debug_str := 'After Update_Appl_Ofr_Inst l_return_status: ' || l_return_status;
2038: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2039:
2040: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Ofr_Inst_msg_Data';

Line 2040: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Ofr_Inst_msg_Data';

2036: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Ofr_Inst_ret_Stat';
2037: l_debug_str := 'After Update_Appl_Ofr_Inst l_return_status: ' || l_return_status;
2038: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2039:
2040: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.After_Update_Appl_Ofr_Inst_msg_Data';
2041: l_debug_str := 'After Update_Appl_Ofr_Inst l_message_data: ' || l_message_data;
2042: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2043: END IF;
2044:

Line 2091: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop -'||SQLERRM);

2087: x_message_data := 'IGS_AD_APPL_PRC_FAILED';
2088: ELSE
2089: IF FND_MSG_PUB.Count_Msg < 1 THEN
2090: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2091: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop -'||SQLERRM);
2092: IGS_GE_MSG_STACK.ADD;
2093: App_Exception.Raise_Exception;
2094: END IF;
2095: x_message_data := 'IGS_GE_UNHANDLED_EXP';

Line 2297: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_ad_offer_resp_and_fee -'||SQLERRM);

2293: x_return_status := 'E';
2294: x_msg_data := 'IGS_GE_UNHANDLED_EXP';
2295: IF FND_MSG_PUB.Count_Msg < 1 THEN
2296: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2297: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_ad_offer_resp_and_fee -'||SQLERRM);
2298: IGS_GE_MSG_STACK.ADD;
2299: END IF;
2300: END update_ad_offer_resp_and_fee;
2301:

Line 2363: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop';

2359: l_debug_str VARCHAR2(4000);
2360:
2361: BEGIN
2362:
2363: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop';
2364: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.start';
2365:
2366:
2367: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 2364: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.start';

2360:
2361: BEGIN
2362:
2363: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop';
2364: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.start';
2365:
2366:
2367: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2368: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.start';

Line 2368: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.start';

2364: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop.start';
2365:
2366:
2367: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2368: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.start';
2369: l_debug_str := 'In Process_OneStop2 Start';
2370: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2371: END IF;
2372:

Line 2384: FND_LOG.STRING(fnd_log.level_Statement, 'igs.patch.115.sql.igs_ad_ss_gen_001.Process_OneStop2 :', 'Before IGS_AD_SS_APPL_FEE_PKG.check_offer_resp_update');

2380: INTO c_course_rec;
2381: EXIT WHEN c_course%NOTFOUND;
2382: BEGIN
2383: IF (FND_LOG.LEVEL_STATEMENT>= g_debug_level ) THEN
2384: FND_LOG.STRING(fnd_log.level_Statement, 'igs.patch.115.sql.igs_ad_ss_gen_001.Process_OneStop2 :', 'Before IGS_AD_SS_APPL_FEE_PKG.check_offer_resp_update');
2385: END IF;
2386: IGS_AD_SS_APPL_FEE_PKG.check_offer_resp_update(p_person_id,
2387: p_admission_appl_number,
2388: c_course_rec.nominated_course_cd,

Line 2396: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_check_offer_resp_update_ret_Stat';

2392: l_msg_data);
2393:
2394:
2395: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2396: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_check_offer_resp_update_ret_Stat';
2397: l_debug_str := 'After IGS_AD_SS_APPL_FEE_PKG.check_offer_resp_update: l_return_status' || l_return_status;
2398: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2399:
2400: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_check_offer_resp_update_msg_data';

Line 2400: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_check_offer_resp_update_msg_data';

2396: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_check_offer_resp_update_ret_Stat';
2397: l_debug_str := 'After IGS_AD_SS_APPL_FEE_PKG.check_offer_resp_update: l_return_status' || l_return_status;
2398: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2399:
2400: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_check_offer_resp_update_msg_data';
2401: l_debug_str := 'After IGS_AD_SS_APPL_FEE_PKG.check_offer_resp_update: l_msg_data' || l_msg_data;
2402: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2403:
2404: END IF;

Line 2430: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.beofore_perform_pre_enrol';

2426: CLOSE get_enr_cat;
2427:
2428:
2429: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2430: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.beofore_perform_pre_enrol';
2431: l_debug_str := 'Before igs_ad_upd_initialise.perform_pre_enrol';
2432: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2433: END IF;
2434:

Line 2446: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_a_perform_pre_enrol_failed';

2442: v_message_name) =
2443: FALSE THEN
2444:
2445: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2446: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_a_perform_pre_enrol_failed';
2447: l_debug_str := 'After igs_ad_upd_initialise.perform_pre_enrol Failed v_message_name ' || v_message_name;
2448: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2449: END IF;
2450:

Line 2459: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_a_perform_pre_enrol_success';

2455: RETURN;
2456: ELSE
2457:
2458: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2459: l_label := 'igs.plsql.igs_ad_ss_gen_001.Process_OneStop2.after_a_perform_pre_enrol_success';
2460: l_debug_str := 'igs_ad_upd_initialise.perform_pre_enrol Succesful';
2461: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2462: END IF;
2463:

Line 2497: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop2 -'||SQLERRM);

2493: x_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2494: ELSE
2495: IF FND_MSG_PUB.Count_Msg < 1 THEN
2496: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2497: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop2 -'||SQLERRM);
2498: IGS_GE_MSG_STACK.ADD;
2499: App_Exception.Raise_Exception;
2500: END IF;
2501: x_msg_data := 'IGS_GE_UNHANDLED_EXP';

Line 2550: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

2546: l_sc_message_name VARCHAR2(50);
2547:
2548: BEGIN
2549:
2550: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
2551: THEN
2552: lv_mode := 'S';
2553: END IF;
2554:

Line 2740: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Eqdo_Inst -'||SQLERRM);

2736: END LOOP;
2737:
2738: IF FND_MSG_PUB.Count_Msg < 1 THEN
2739: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2740: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Eqdo_Inst -'||SQLERRM);
2741: IGS_GE_MSG_STACK.ADD;
2742: App_Exception.Raise_Exception;
2743: END IF;
2744: x_return_status := 'E';

Line 2785: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

2781: l_sc_app_short_name VARCHAR2(50);
2782: l_sc_message_name VARCHAR2(50);
2783: BEGIN
2784:
2785: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
2786: THEN
2787: lv_mode := 'S';
2788: END IF;
2789:

Line 2963: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Ofr_Inst -'||SQLERRM);

2959: END LOOP;
2960:
2961: IF FND_MSG_PUB.Count_Msg < 1 THEN
2962: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2963: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Ofr_Inst -'||SQLERRM);
2964: IGS_GE_MSG_STACK.ADD;
2965: App_Exception.Raise_Exception;
2966: END IF;
2967: x_return_status := 'E';

Line 2998: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

2994:
2995: lv_mode VARCHAR2(1) DEFAULT 'R';
2996: BEGIN
2997:
2998: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
2999: THEN
3000: lv_mode := 'S';
3001: END IF;
3002:

Line 3221: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_appl_section_stat -'||SQLERRM);

3217: EXCEPTION
3218: WHEN OTHERS THEN
3219: IF FND_MSG_PUB.Count_Msg < 1 THEN
3220: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3221: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_appl_section_stat -'||SQLERRM);
3222: IGS_GE_MSG_STACK.ADD;
3223: END IF;
3224: x_return_status := 'E';
3225: x_message_name := 'IGS_GE_UNHANDLED_EXP';

Line 3326: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'

3322: AND ss_adm_appl_id = p_adm_appl_id;
3323: lv_mode VARCHAR2(1) DEFAULT 'R';
3324: BEGIN
3325:
3326: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
3327: THEN
3328: lv_mode := 'S';
3329: END IF;
3330: logHeader('insert_application_fee', 'S');

Line 3370: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_application_fee -'||SQLERRM);

3366: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
3367: 'S');
3368: IF FND_MSG_PUB.Count_Msg < 1 THEN
3369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3370: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_application_fee -'||SQLERRM);
3371: IGS_GE_MSG_STACK.ADD;
3372: END IF;
3373: App_Exception.Raise_Exception;
3374:

Line 4019: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.update_appl_section_stat';

4015:
4016:
4017: BEGIN
4018:
4019: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.update_appl_section_stat';
4020: l_label := 'igs.plsql.igs_ad_ss_gen_001.update_appl_section_stat.start';
4021:
4022:
4023: -- Status Flag = Optional

Line 4020: l_label := 'igs.plsql.igs_ad_ss_gen_001.update_appl_section_stat.start';

4016:
4017: BEGIN
4018:
4019: l_prog_label := 'igs.plsql.igs_ad_ss_gen_001.update_appl_section_stat';
4020: l_label := 'igs.plsql.igs_ad_ss_gen_001.update_appl_section_stat.start';
4021:
4022:
4023: -- Status Flag = Optional
4024: -- String Required_componets = Null

Line 4571: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_appl_section_stat -'||SQLERRM);

4567: x_message_name := 'IGS_GE_UNHANDLED_EXP';
4568:
4569: IF FND_MSG_PUB.Count_Msg < 1 THEN
4570: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4571: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_appl_section_stat -'||SQLERRM);
4572: IGS_GE_MSG_STACK.ADD;
4573: END IF;
4574: END update_appl_section_stat;
4575:

Line 4637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.sync_appl_section_stat -'||SQLERRM);

4633: x_max_Sections := 0;
4634: logDetail('Exception from sync_appl_section_stat: ' || SQLERRM, 'S');
4635: IF FND_MSG_PUB.Count_Msg < 1 THEN
4636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.sync_appl_section_stat -'||SQLERRM);
4638: IGS_GE_MSG_STACK.ADD;
4639: END IF;
4640: IF c_NoPgs%ISOPEN THEN
4641: CLOSE c_NoPgs;

Line 4854: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.auto_assign_pgs_comps_terms -'||SQLERRM);

4850: x_return_status := 'E';
4851: x_message_name := 'IGS_GE_UNHANDLED_EXP';
4852: IF FND_MSG_PUB.Count_Msg < 1 THEN
4853: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4854: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.auto_assign_pgs_comps_terms -'||SQLERRM);
4855: IGS_GE_MSG_STACK.ADD;
4856: END IF;
4857: END auto_assign_pgs_comps_terms;
4858:

Line 5776: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.get_ss_lookup_desc -'||SQLERRM);

5772: x_message_name := 'IGS_GE_UNHANDLED_EXP';
5773: x_concat_desc := NULL;
5774: IF FND_MSG_PUB.Count_Msg < 1 THEN
5775: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5776: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.get_ss_lookup_desc -'||SQLERRM);
5777: IGS_GE_MSG_STACK.ADD;
5778: END IF;
5779: END get_ss_lookup_desc;
5780:

Line 5883: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application_detail -'||SQLERRM);

5879: WHEN OTHERS THEN
5880: logDetail('Exception from create_application_detail, MAIN LOOP: ' || SQLERRM, 'S');
5881: IF FND_MSG_PUB.Count_Msg < 1 THEN
5882: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
5883: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application_detail -'||SQLERRM);
5884: IGS_GE_MSG_STACK.ADD;
5885: END IF;
5886: App_Exception.Raise_Exception;
5887:

Line 5950: WF_CORE.CONTEXT('IGS_AD_SS_GEN_001','WF_SUBMIT_APPLICATION_SUB',p_event.getEventName(),p_subscription_guid);

5946: l_msg_data := l_hash_msg_name_text_type_tab(l_msg_count-1).text;
5947: p_event.AddParameterToList('P_RETURN_STATUS',l_return_status);
5948: p_event.AddParameterToList('P_MSG_DATA',l_msg_data);
5949:
5950: WF_CORE.CONTEXT('IGS_AD_SS_GEN_001','WF_SUBMIT_APPLICATION_SUB',p_event.getEventName(),p_subscription_guid);
5951: WF_EVENT.setErrorInfo(p_event, 'ERROR');
5952: return 'ERROR';
5953: END wf_submit_application_sub;
5954:

Line 5955: END IGS_AD_SS_GEN_001;

5951: WF_EVENT.setErrorInfo(p_event, 'ERROR');
5952: return 'ERROR';
5953: END wf_submit_application_sub;
5954:
5955: END IGS_AD_SS_GEN_001;