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 FND_LOG

Line 26: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

22: nshee 29-Aug-2002 Bug 2395510 added 6 columns as part of deferments build
23: knag 29-OCT-2002 Bug 2647482 removed local procedure insert_acad_honors and its calls
24: stammine 10-Jun-2005 Added procedures at for IGS.M build
25: ******************************************************************/
26: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
27:
28: --Fwd Declarations
29: PROCEDURE logHeader(p_proc_name VARCHAR2, p_mode VARCHAR2);
30: PROCEDURE logDetail(p_debug_msg VARCHAR2, p_mode VARCHAR2);

Line 1786: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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;
1789: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1790: END IF;

Line 1789: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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;
1789: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1790: END IF;
1791:
1792:
1793: Select 'X'

Line 1802: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1798: And S_ADMISSION_PROCESS_TYPE = p_admission_process_type
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;

Line 1805: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
1808: Select 'X'
1809: Into l_offer

Line 1816: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1812: And ADMISSION_CAT = p_admission_cat
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;

Line 1819: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
1822: -- If no record exists for that combination RETURN 'N',
1823: -- else return 'S'

Line 1826: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1822: -- If no record exists for that combination RETURN 'N',
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;

Line 1829: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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';
1832: End If;
1833:

Line 1840: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1836: End If;
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;

Line 1843: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
1846: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_ONESTOP_NO_DATA_FOUND');
1847: IGS_GE_MSG_STACK.ADD;

Line 1852: IF fnd_log.test(fnd_log.level_Exception,l_prog_label) THEN

1848: x_return_status := 'N'; -- This is used to specify that application is not onestop
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;

Line 1855: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
1858: x_return_status := 'E';
1859: x_message_data := 'IGS_GE_UNHANDLED_EXP';

Line 1905: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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;
1908: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1909: END IF;

Line 1908: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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;
1908: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1909: END IF;
1910:
1911:
1912: -- Check whether the Admission Entry qualification status be updated

Line 1928: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1924: EXIT WHEN c_course%NOTFOUND;
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;

Line 1931: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
1934: IGS_AD_SS_APPL_FEE_PKG.check_update_aeps_acs(p_person_id,
1935: p_admission_appl_number,

Line 1942: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1938: l_return_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:

Line 1945: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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';
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);

Line 1949: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
1952: IF l_return_status = 'E' THEN ----check_update_aeps_acs return status
1953: IF p_role <> 'ADMIN' THEN

Line 1972: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1968: l_return_status,
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:

Line 1975: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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';
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);

Line 1979: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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;
1982:
1983: IF l_return_status = 'E' THEN --- Update_Appl_Eqdo_Inst return status

Line 2006: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

2002: l_return_status,
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:

Line 2009: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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';
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);

Line 2013: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
2016: IF l_return_status = 'E' THEN -- check_offer_update return status
2017: IF p_role <> 'ADMIN' THEN

Line 2035: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

2031: c_course_rec.sequence_number,
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:

Line 2038: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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';
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);

Line 2042: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
2045: IF l_return_status = 'E' THEN -- Update_Appl_Ofr_Inst return status
2046: IF p_role <> 'ADMIN' THEN

Line 2367: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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';
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;

Line 2370: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
2373: -- Check whether the Admission offer resp status be updated
2374: -- to 'ACCEPTED', If Yes, then update them to the respective values

Line 2383: IF (FND_LOG.LEVEL_STATEMENT>= g_debug_level ) THEN

2379: FETCH c_course
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,

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 2395: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

2391: l_msg_count,
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:

Line 2398: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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';
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);

Line 2402: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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;
2405:
2406: IF l_return_status = 'E' THEN ----check_offer_resp_update return status

Line 2429: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

2425: INTO get_enr_cat_rec;
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;

Line 2432: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
2435:
2436: IF igs_ad_upd_initialise.perform_pre_enrol(p_person_id,

Line 2445: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

2441: 'Y', -- Perform eligibility check indicator.
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;

Line 2448: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
2451: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_AUTO_ENR_FAILED');
2452: IGS_GE_MSG_STACK.ADD;

Line 2458: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

2454: x_msg_data := 'IGS_AD_AUTO_ENR_FAILED'; --Supressing the error message from the Pre Enr process as per communication on bug2405076
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;

Line 2461: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

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:
2464:
2465: /*Commenting as part of Bug 4234911

Line 4398: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

4394: CLOSE c_acad_hon;
4395: END IF;
4396:
4397: ELSIF pgComps.Component = 'PERSONAL_STMTS' THEN
4398: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4399: l_debug_str := ' Validating Personal Statements Component';
4400: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4401: END IF;
4402:

Line 4400: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

4396:
4397: ELSIF pgComps.Component = 'PERSONAL_STMTS' THEN
4398: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4399: l_debug_str := ' Validating Personal Statements Component';
4400: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4401: END IF;
4402:
4403: OPEN c_perstat_group(p_person_id,p_adm_appl_number,p_Appl_Type);
4404: LOOP

Line 4405: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

4401: END IF;
4402:
4403: OPEN c_perstat_group(p_person_id,p_adm_appl_number,p_Appl_Type);
4404: LOOP
4405: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4406: l_debug_str := 'In c_perstat_group with p_person_id ->' || p_person_id || ', p_adm_appl_number -> ' ||
4407: p_adm_appl_number || ', p_Appl_Type -> ' || p_Appl_Type;
4408: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4409: END IF;

Line 4408: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

4404: LOOP
4405: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4406: l_debug_str := 'In c_perstat_group with p_person_id ->' || p_person_id || ', p_adm_appl_number -> ' ||
4407: p_adm_appl_number || ', p_Appl_Type -> ' || p_Appl_Type;
4408: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4409: END IF;
4410:
4411: FETCH c_perstat_group INTO l_perstat_group_rec;
4412: EXIT WHEN c_perstat_group%NOTFOUND;

Line 4415: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

4411: FETCH c_perstat_group INTO l_perstat_group_rec;
4412: EXIT WHEN c_perstat_group%NOTFOUND;
4413: IF l_perstat_group_rec.group_number = -1 THEN
4414:
4415: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4416: l_debug_str := ' Personal Satement is not associated to Group with ss perstat id -> ' || l_perstat_group_rec.SS_PERSTAT_ID;
4417: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4418: END IF;
4419:

Line 4417: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

4413: IF l_perstat_group_rec.group_number = -1 THEN
4414:
4415: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4416: l_debug_str := ' Personal Satement is not associated to Group with ss perstat id -> ' || l_perstat_group_rec.SS_PERSTAT_ID;
4417: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4418: END IF;
4419:
4420: IF (l_perstat_group_rec.required = 'Yes' AND l_perstat_group_rec.attach_exists = 'N') THEN
4421: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 4421: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

4417: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4418: END IF;
4419:
4420: IF (l_perstat_group_rec.required = 'Yes' AND l_perstat_group_rec.attach_exists = 'N') THEN
4421: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4422: l_debug_str := ' Personal Satement is Required but not provided -> ' ;
4423: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4424: END IF;
4425: l_flag := 'N';

Line 4423: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

4419:
4420: IF (l_perstat_group_rec.required = 'Yes' AND l_perstat_group_rec.attach_exists = 'N') THEN
4421: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4422: l_debug_str := ' Personal Satement is Required but not provided -> ' ;
4423: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4424: END IF;
4425: l_flag := 'N';
4426: END IF;
4427: ELSE

Line 4428: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

4424: END IF;
4425: l_flag := 'N';
4426: END IF;
4427: ELSE
4428: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4429: l_debug_str := ' Personal Satement Group -> ' || l_perstat_group_rec.group_number;
4430: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4431: END IF;
4432:

Line 4430: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

4426: END IF;
4427: ELSE
4428: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4429: l_debug_str := ' Personal Satement Group -> ' || l_perstat_group_rec.group_number;
4430: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4431: END IF;
4432:
4433: l_perstat_count := 0;
4434: OPEN c_perstat(p_person_id,p_adm_appl_number,l_perstat_group_rec.group_number);

Line 4440: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

4436:
4437: FETCH c_perstat INTO l_perstat_rec;
4438: EXIT WHEN c_perstat%NOTFOUND;
4439:
4440: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4441: l_debug_str := ' Personal Satements ID -> ' || l_perstat_rec.SS_PERSTAT_ID ||
4442: 'Presnt Count of statments for this group' || l_perstat_count;
4443: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4444: END IF;

Line 4443: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

4439:
4440: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4441: l_debug_str := ' Personal Satements ID -> ' || l_perstat_rec.SS_PERSTAT_ID ||
4442: 'Presnt Count of statments for this group' || l_perstat_count;
4443: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4444: END IF;
4445:
4446: IF (l_perstat_rec.attach_exists = 'Y') THEN
4447: l_perstat_count := l_perstat_count + 1;

Line 4456: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

4452: END IF;
4453: END LOOP;
4454: CLOSE c_perstat;
4455:
4456: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4457: l_debug_str := ' Personal Satements count for Group -> ' || l_perstat_group_rec.group_number ||' is ' || l_perstat_count;
4458: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4459: END IF;
4460:

Line 4458: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

4454: CLOSE c_perstat;
4455:
4456: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4457: l_debug_str := ' Personal Satements count for Group -> ' || l_perstat_group_rec.group_number ||' is ' || l_perstat_count;
4458: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
4459: END IF;
4460:
4461: IF l_perstat_count < l_perstat_group_rec.group_min THEN
4462: l_flag := 'N';