');
1595:
1596: for r in Resps loop
1597:
1598: c_menu_id := r.menu_id;
Line 1639: htp.tableRowOpen;
1635: where menu_id = c_menu_id
1636: and function_id is not null
1637: and sub_menu_id is not null;
1638:
1639: htp.tableRowOpen;
1640: htp.tableData(''||
1641: --mputman convert to execute effort
1642: --htf.anchor('OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]',n_session_id),
1643: htf.anchor('OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]')),
Line 1640: htp.tableData(''||
1636: and function_id is not null
1637: and sub_menu_id is not null;
1638:
1639: htp.tableRowOpen;
1640: htp.tableData(''||
1641: --mputman convert to execute effort
1642: --htf.anchor('OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]',n_session_id),
1643: htf.anchor('OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]')),
1644: r.responsibility_name,'','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(r.description)||''';return true"')||
Line 1646: htp.tableRowClose;
1642: --htf.anchor('OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]',n_session_id),
1643: htf.anchor('OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]')),
1644: r.responsibility_name,'','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(r.description)||''';return true"')||
1645: '','','','','','4','');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.tableData('
1649: || v_color_image || ' height=3 width=500>',
1650: '','','','','4','');
Line 1647: htp.tableRowOpen;
1643: htf.anchor('OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]')),
1644: r.responsibility_name,'','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(r.description)||''';return true"')||
1645: '','','','','','4','');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.tableData('
1649: || v_color_image || ' height=3 width=500>',
1650: '','','','','4','');
1651: htp.tableRowClose;
Line 1648: htp.tableData('
1644: r.responsibility_name,'','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(r.description)||''';return true"')||
1645: '','','','','','4','');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.tableData('
1649: || v_color_image || ' height=3 width=500>',
1650: '','','','','4','');
1651: htp.tableRowClose;
1652:
Line 1651: htp.tableRowClose;
1647: htp.tableRowOpen;
1648: htp.tableData('
1649: || v_color_image || ' height=3 width=500>',
1650: '','','','','4','');
1651: htp.tableRowClose;
1652:
1653: htp.tableRowOpen;
1654: htp.tableRowClose;
1655:
Line 1653: htp.tableRowOpen;
1649: || v_color_image || ' height=3 width=500>',
1650: '','','','','4','');
1651: htp.tableRowClose;
1652:
1653: htp.tableRowOpen;
1654: htp.tableRowClose;
1655:
1656: htp.tableRowOpen;
1657: htp.tableRowClose;
Line 1654: htp.tableRowClose;
1650: '','','','','4','');
1651: htp.tableRowClose;
1652:
1653: htp.tableRowOpen;
1654: htp.tableRowClose;
1655:
1656: htp.tableRowOpen;
1657: htp.tableRowClose;
1658:
Line 1656: htp.tableRowOpen;
1652:
1653: htp.tableRowOpen;
1654: htp.tableRowClose;
1655:
1656: htp.tableRowOpen;
1657: htp.tableRowClose;
1658:
1659: else -- l_count <> 1
1660:
Line 1657: htp.tableRowClose;
1653: htp.tableRowOpen;
1654: htp.tableRowClose;
1655:
1656: htp.tableRowOpen;
1657: htp.tableRowClose;
1658:
1659: else -- l_count <> 1
1660:
1661: htp.tableRowOpen;
Line 1661: htp.tableRowOpen;
1657: htp.tableRowClose;
1658:
1659: else -- l_count <> 1
1660:
1661: htp.tableRowOpen;
1662: htp.tableData(''||r.responsibility_name||' ','','','','','4','');
1663: htp.tableRowClose;
1664: htp.tableRowOpen;
1665: htp.tableData('
Line 1662: htp.tableData(''||r.responsibility_name||' ','','','','','4','');
1658:
1659: else -- l_count <> 1
1660:
1661: htp.tableRowOpen;
1662: htp.tableData(''||r.responsibility_name||' ','','','','','4','');
1663: htp.tableRowClose;
1664: htp.tableRowOpen;
1665: htp.tableData('
1666: || v_color_image || ' height=3 width=500>',
Line 1663: htp.tableRowClose;
1659: else -- l_count <> 1
1660:
1661: htp.tableRowOpen;
1662: htp.tableData(''||r.responsibility_name||' ','','','','','4','');
1663: htp.tableRowClose;
1664: htp.tableRowOpen;
1665: htp.tableData('
1666: || v_color_image || ' height=3 width=500>',
1667: '','','','','4','');
Line 1664: htp.tableRowOpen;
1660:
1661: htp.tableRowOpen;
1662: htp.tableData(''||r.responsibility_name||' ','','','','','4','');
1663: htp.tableRowClose;
1664: htp.tableRowOpen;
1665: htp.tableData('
1666: || v_color_image || ' height=3 width=500>',
1667: '','','','','4','');
1668: htp.tableRowClose;
Line 1665: htp.tableData('
1661: htp.tableRowOpen;
1662: htp.tableData(''||r.responsibility_name||' ','','','','','4','');
1663: htp.tableRowClose;
1664: htp.tableRowOpen;
1665: htp.tableData('
1666: || v_color_image || ' height=3 width=500>',
1667: '','','','','4','');
1668: htp.tableRowClose;
1669:
Line 1668: htp.tableRowClose;
1664: htp.tableRowOpen;
1665: htp.tableData('
1666: || v_color_image || ' height=3 width=500>',
1667: '','','','','4','');
1668: htp.tableRowClose;
1669:
1670: -- if HR responsibility, paint while looping through the functions
1671: -- if others, construct the table while looping, and paint at the end
1672:
Line 1710: htp.tableRowOpen;
1706:
1707: if mi.web_icon is not null
1708: then
1709: if i_counter = 0 then
1710: htp.tableRowOpen;
1711: end if;
1712: i_counter := i_counter+1;
1713:
1714: -- paint 4 icons on one line
Line 1717: htp.tableRowClose;
1713:
1714: -- paint 4 icons on one line
1715: if ((i_counter <> 1) AND (MOD(i_counter, 4) = 1))
1716: then
1717: htp.tableRowClose;
1718: htp.tableRowOpen;
1719: end if;
1720:
1721: htp.p('
');
Line 1718: htp.tableRowOpen;
1714: -- paint 4 icons on one line
1715: if ((i_counter <> 1) AND (MOD(i_counter, 4) = 1))
1716: then
1717: htp.tableRowClose;
1718: htp.tableRowOpen;
1719: end if;
1720:
1721: htp.p('
');
1722: htp.anchor(curl => l_url,
Line 1721: htp.p('');
1717: htp.tableRowClose;
1718: htp.tableRowOpen;
1719: end if;
1720:
1721: htp.p('
');
1722: htp.anchor(curl => l_url,
1723: ctext =>
1724: htf.img(curl => '/OA_MEDIA/'|| mi.web_icon,
1725: cattributes => 'BORDER=0',
Line 1722: htp.anchor(curl => l_url,
1718: htp.tableRowOpen;
1719: end if;
1720:
1721: htp.p('
');
1722: htp.anchor(curl => l_url,
1723: ctext =>
1724: htf.img(curl => '/OA_MEDIA/'|| mi.web_icon,
1725: cattributes => 'BORDER=0',
1726: calt => l_prompt)||
Line 1733: htp.p(' ');
1729: cattributes =>
1730: 'TARGET="_top", onMouseOver="window.status='''||
1731: icx_util.replace_onMouseOver_quotes(l_description)||
1732: ''';return true"');
1733: htp.p('
');
1734:
1735: else -- mi.web_icon is null
1736:
1737: f_counter := f_counter+1;
Line 1761: htp.tableRowClose;
1757:
1758: -- if there's image associated menu entries
1759: if i_counter > 0
1760: then
1761: htp.tableRowClose;
1762: end if;
1763:
1764: -- if there's text URL associated menu entries
1765: if f_counter > 0
Line 1771: htp.tableRowOpen;
1767: icx_admin_sig.displayTable(p_funcTable,f_counter,2, c_language_code,v_bullet_image);
1768: end if;
1769: end if; -- l_count = 1
1770:
1771: htp.tableRowOpen;
1772: htp.tableData('','','','','','4','');
1773: htp.tableRowClose;
1774:
1775: p_funcTable := p_funcEmpty; -- reset pl/sql table
Line 1772: htp.tableData('','','','','','4','');
1768: end if;
1769: end if; -- l_count = 1
1770:
1771: htp.tableRowOpen;
1772: htp.tableData('','','','','','4','');
1773: htp.tableRowClose;
1774:
1775: p_funcTable := p_funcEmpty; -- reset pl/sql table
1776: f_counter := 0;
Line 1773: htp.tableRowClose;
1769: end if; -- l_count = 1
1770:
1771: htp.tableRowOpen;
1772: htp.tableData('','','','','','4','');
1773: htp.tableRowClose;
1774:
1775: p_funcTable := p_funcEmpty; -- reset pl/sql table
1776: f_counter := 0;
1777: i_counter := 0;
Line 1779: htp.tableRowOpen;
1775: p_funcTable := p_funcEmpty; -- reset pl/sql table
1776: f_counter := 0;
1777: i_counter := 0;
1778:
1779: htp.tableRowOpen;
1780: htp.tableRowClose;
1781:
1782: end loop; -- Responsiblities
1783: htp.tableClose;
Line 1780: htp.tableRowClose;
1776: f_counter := 0;
1777: i_counter := 0;
1778:
1779: htp.tableRowOpen;
1780: htp.tableRowClose;
1781:
1782: end loop; -- Responsiblities
1783: htp.tableClose;
1784:
Line 1783: htp.tableClose;
1779: htp.tableRowOpen;
1780: htp.tableRowClose;
1781:
1782: end loop; -- Responsiblities
1783: htp.tableClose;
1784:
1785: if c_toolbar = 'Y'
1786: then
1787:
Line 1788: htp.bodyClose;
1784:
1785: if c_toolbar = 'Y'
1786: then
1787:
1788: htp.bodyClose;
1789: htp.htmlClose;
1790:
1791: end if; -- c_toolbar = 'Y'
1792:
Line 1789: htp.htmlClose;
1785: if c_toolbar = 'Y'
1786: then
1787:
1788: htp.bodyClose;
1789: htp.htmlClose;
1790:
1791: end if; -- c_toolbar = 'Y'
1792:
1793: end if;
Line 1921: -- htp.p('Length of params = '||params.count);
1917: Y:=icx_call.decrypt2(Q);
1918: icx_on_utilities.unpack_parameters(Y, params);
1919:
1920: -- DEBUG --
1921: -- htp.p('Length of params = '||params.count);
1922: -- htp.nl;
1923:
1924: l_level := to_number(params(1));
1925: v_color := params(2);
Line 1922: -- htp.nl;
1918: icx_on_utilities.unpack_parameters(Y, params);
1919:
1920: -- DEBUG --
1921: -- htp.p('Length of params = '||params.count);
1922: -- htp.nl;
1923:
1924: l_level := to_number(params(1));
1925: v_color := params(2);
1926: v_color_image := params(3);
Line 1939: htp.p('table size='||params.COUNT);
1935: 11 - sunb menu handler
1936: */
1937:
1938: /*
1939: htp.p('table size='||params.COUNT);
1940: htp.nl;
1941: htp.p('l_level='||l_level);
1942: htp.nl;
1943: htp.p('v_color='||v_color);
Line 1940: htp.nl;
1936: */
1937:
1938: /*
1939: htp.p('table size='||params.COUNT);
1940: htp.nl;
1941: htp.p('l_level='||l_level);
1942: htp.nl;
1943: htp.p('v_color='||v_color);
1944: htp.nl;
Line 1941: htp.p('l_level='||l_level);
1937:
1938: /*
1939: htp.p('table size='||params.COUNT);
1940: htp.nl;
1941: htp.p('l_level='||l_level);
1942: htp.nl;
1943: htp.p('v_color='||v_color);
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
Line 1942: htp.nl;
1938: /*
1939: htp.p('table size='||params.COUNT);
1940: htp.nl;
1941: htp.p('l_level='||l_level);
1942: htp.nl;
1943: htp.p('v_color='||v_color);
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
Line 1943: htp.p('v_color='||v_color);
1939: htp.p('table size='||params.COUNT);
1940: htp.nl;
1941: htp.p('l_level='||l_level);
1942: htp.nl;
1943: htp.p('v_color='||v_color);
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
Line 1944: htp.nl;
1940: htp.nl;
1941: htp.p('l_level='||l_level);
1942: htp.nl;
1943: htp.p('v_color='||v_color);
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
1948: htp.nl;
Line 1945: htp.p('v_color_image='||v_color_image);
1941: htp.p('l_level='||l_level);
1942: htp.nl;
1943: htp.p('v_color='||v_color);
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
1948: htp.nl;
1949: htp.p('l_responsibility_id='||l_responsibility_id);
Line 1946: htp.nl;
1942: htp.nl;
1943: htp.p('v_color='||v_color);
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
1948: htp.nl;
1949: htp.p('l_responsibility_id='||l_responsibility_id);
1950: htp.nl;
Line 1947: htp.p('v_bullet_image='||v_bullet_image);
1943: htp.p('v_color='||v_color);
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
1948: htp.nl;
1949: htp.p('l_responsibility_id='||l_responsibility_id);
1950: htp.nl;
1951:
Line 1948: htp.nl;
1944: htp.nl;
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
1948: htp.nl;
1949: htp.p('l_responsibility_id='||l_responsibility_id);
1950: htp.nl;
1951:
1952: */
Line 1949: htp.p('l_responsibility_id='||l_responsibility_id);
1945: htp.p('v_color_image='||v_color_image);
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
1948: htp.nl;
1949: htp.p('l_responsibility_id='||l_responsibility_id);
1950: htp.nl;
1951:
1952: */
1953:
Line 1950: htp.nl;
1946: htp.nl;
1947: htp.p('v_bullet_image='||v_bullet_image);
1948: htp.nl;
1949: htp.p('l_responsibility_id='||l_responsibility_id);
1950: htp.nl;
1951:
1952: */
1953:
1954: l_encrypt_string := params(1)||'*'||params(2)||'*'||params(3)||'*'||
Line 2013: htp.htmlOpen;
2009: l_temp_name := l_temp_name||' : '||htf.anchor(l_menuItems(i).menuURL||'?Q='||pass_ons, l_menuItems(i).userMenuName,'','onMouseOver= "window.status='''||l_menu_description||''';return true" TARGET="_top"');
2010: end if;
2011: end loop;
2012:
2013: htp.htmlOpen;
2014: htp.headOpen;
2015: icx_util.copyright;
2016: js.scriptOpen;
2017: icx_admin_sig.help_win_script('/OA_DOC/'||c_language_code||'/aic/icxhlpw.htm');
Line 2014: htp.headOpen;
2010: end if;
2011: end loop;
2012:
2013: htp.htmlOpen;
2014: htp.headOpen;
2015: icx_util.copyright;
2016: js.scriptOpen;
2017: icx_admin_sig.help_win_script('/OA_DOC/'||c_language_code||'/aic/icxhlpw.htm');
2018: js.scriptClose;
Line 2020: htp.p('function new_browser(url,x,y)
2016: js.scriptOpen;
2017: icx_admin_sig.help_win_script('/OA_DOC/'||c_language_code||'/aic/icxhlpw.htm');
2018: js.scriptClose;
2019: js.scriptOpen;
2020: htp.p('function new_browser(url,x,y)
2021: {
2022: attributes = "resizable=yes,scrollbars=yes,toolbar=yes,width="+x+",height="+y;
2023: new_browser = window.open(url, "new_browser", attributes);
2024: };');
Line 2026: htp.title(l_menu_name);
2022: attributes = "resizable=yes,scrollbars=yes,toolbar=yes,width="+x+",height="+y;
2023: new_browser = window.open(url, "new_browser", attributes);
2024: };');
2025: js.scriptClose;
2026: htp.title(l_menu_name);
2027: htp.headClose;
2028:
2029: icx_admin_sig.toolbar(language_code => c_language_code,
2030: disp_mainmenu => 'N');
Line 2027: htp.headClose;
2023: new_browser = window.open(url, "new_browser", attributes);
2024: };');
2025: js.scriptClose;
2026: htp.title(l_menu_name);
2027: htp.headClose;
2028:
2029: icx_admin_sig.toolbar(language_code => c_language_code,
2030: disp_mainmenu => 'N');
2031:
Line 2032: htp.tableOpen('','','','','');
2028:
2029: icx_admin_sig.toolbar(language_code => c_language_code,
2030: disp_mainmenu => 'N');
2031:
2032: htp.tableOpen('','','','','');
2033: htp.tableRowOpen;
2034: htp.tableData(''||l_temp_name||' ','','','','','4','');
2035: htp.tableRowClose;
2036: htp.tableRowOpen;
Line 2033: htp.tableRowOpen;
2029: icx_admin_sig.toolbar(language_code => c_language_code,
2030: disp_mainmenu => 'N');
2031:
2032: htp.tableOpen('','','','','');
2033: htp.tableRowOpen;
2034: htp.tableData(''||l_temp_name||' ','','','','','4','');
2035: htp.tableRowClose;
2036: htp.tableRowOpen;
2037: htp.tableData('
Line 2034: htp.tableData(''||l_temp_name||' ','','','','','4','');
2030: disp_mainmenu => 'N');
2031:
2032: htp.tableOpen('','','','','');
2033: htp.tableRowOpen;
2034: htp.tableData(''||l_temp_name||' ','','','','','4','');
2035: htp.tableRowClose;
2036: htp.tableRowOpen;
2037: htp.tableData('
2038: || v_color_image || ' height=3 width=500>',
Line 2035: htp.tableRowClose;
2031:
2032: htp.tableOpen('','','','','');
2033: htp.tableRowOpen;
2034: htp.tableData(''||l_temp_name||' ','','','','','4','');
2035: htp.tableRowClose;
2036: htp.tableRowOpen;
2037: htp.tableData('
2038: || v_color_image || ' height=3 width=500>',
2039: '','','','','4','');
Line 2036: htp.tableRowOpen;
2032: htp.tableOpen('','','','','');
2033: htp.tableRowOpen;
2034: htp.tableData(''||l_temp_name||' ','','','','','4','');
2035: htp.tableRowClose;
2036: htp.tableRowOpen;
2037: htp.tableData('
2038: || v_color_image || ' height=3 width=500>',
2039: '','','','','4','');
2040: htp.tableRowClose;
Line 2037: htp.tableData('
2033: htp.tableRowOpen;
2034: htp.tableData(''||l_temp_name||' ','','','','','4','');
2035: htp.tableRowClose;
2036: htp.tableRowOpen;
2037: htp.tableData('
2038: || v_color_image || ' height=3 width=500>',
2039: '','','','','4','');
2040: htp.tableRowClose;
2041:
Line 2040: htp.tableRowClose;
2036: htp.tableRowOpen;
2037: htp.tableData('
2038: || v_color_image || ' height=3 width=500>',
2039: '','','','','4','');
2040: htp.tableRowClose;
2041:
2042: for mi in menuItems loop
2043:
2044: l_prompt := null;
Line 2068: htp.tableRowOpen;
2064:
2065: if mi.web_icon is not null
2066: then
2067: if i_counter = 0 then
2068: htp.tableRowOpen;
2069: end if;
2070: i_counter := i_counter+1;
2071:
2072: -- paint 4 icons on one line
Line 2075: htp.tableRowClose;
2071:
2072: -- paint 4 icons on one line
2073: if ((i_counter <> 1) AND (MOD(i_counter, 4) = 1))
2074: then
2075: htp.tableRowClose;
2076: htp.tableRowOpen;
2077: end if;
2078:
2079: htp.tabledata
Line 2076: htp.tableRowOpen;
2072: -- paint 4 icons on one line
2073: if ((i_counter <> 1) AND (MOD(i_counter, 4) = 1))
2074: then
2075: htp.tableRowClose;
2076: htp.tableRowOpen;
2077: end if;
2078:
2079: htp.tabledata
2080: (htf.anchor(curl => 'OracleApps.RF?F='||c_encrypted_func,
Line 2079: htp.tabledata
2075: htp.tableRowClose;
2076: htp.tableRowOpen;
2077: end if;
2078:
2079: htp.tabledata
2080: (htf.anchor(curl => 'OracleApps.RF?F='||c_encrypted_func,
2081: ctext =>
2082: htf.img(curl => '/OA_MEDIA/'|| mi.web_icon,
2083: cattributes => 'BORDER=0',
Line 2129: htp.tableRowOpen;
2125:
2126: if mi.web_icon is not null
2127: then
2128: if i_counter = 0 then
2129: htp.tableRowOpen;
2130: end if;
2131: i_counter := i_counter+1;
2132:
2133: -- paint 4 icons on one line
Line 2136: htp.tableRowClose;
2132:
2133: -- paint 4 icons on one line
2134: if ((i_counter <> 1) AND (MOD(i_counter, 4) = 1))
2135: then
2136: htp.tableRowClose;
2137: htp.tableRowOpen;
2138: end if;
2139:
2140: htp.tabledata
Line 2137: htp.tableRowOpen;
2133: -- paint 4 icons on one line
2134: if ((i_counter <> 1) AND (MOD(i_counter, 4) = 1))
2135: then
2136: htp.tableRowClose;
2137: htp.tableRowOpen;
2138: end if;
2139:
2140: htp.tabledata
2141: (htf.anchor(curl => 'OracleApps.DSM?Q='||l_encrypt_menu,
Line 2140: htp.tabledata
2136: htp.tableRowClose;
2137: htp.tableRowOpen;
2138: end if;
2139:
2140: htp.tabledata
2141: (htf.anchor(curl => 'OracleApps.DSM?Q='||l_encrypt_menu,
2142: ctext =>
2143: htf.img(curl => '/OA_MEDIA/'|| mi.web_icon,
2144: cattributes => 'BORDER=0',
Line 2171: htp.tableRowClose;
2167:
2168: -- if there's image associated menu entries
2169: if i_counter > 0
2170: then
2171: htp.tableRowClose;
2172: end if;
2173:
2174: -- if there's text URL associated menu entries
2175: if f_counter > 0
Line 2184: htp.tableClose;
2180: p_funcTable := p_funcEmpty; -- reset pl/sql table
2181: f_counter := 0;
2182: i_counter := 0;
2183:
2184: htp.tableClose;
2185: htp.bodyClose;
2186: htp.htmlClose;
2187:
2188: end if;
Line 2185: htp.bodyClose;
2181: f_counter := 0;
2182: i_counter := 0;
2183:
2184: htp.tableClose;
2185: htp.bodyClose;
2186: htp.htmlClose;
2187:
2188: end if;
2189: end if;
Line 2186: htp.htmlClose;
2182: i_counter := 0;
2183:
2184: htp.tableClose;
2185: htp.bodyClose;
2186: htp.htmlClose;
2187:
2188: end if;
2189: end if;
2190:
Line 2286: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2282: then
2283: -- l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);
2284: l_URL := l_URL||'&'||'P='||P;
2285: end if;
2286: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2287: htp.bodyClose;
2288:
2289: ELSE
2290:
Line 2287: htp.bodyClose;
2283: -- l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);
2284: l_URL := l_URL||'&'||'P='||P;
2285: end if;
2286: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2287: htp.bodyClose;
2288:
2289: ELSE
2290:
2291: --following code was removed as applications standard method for connection is via PHP or Portal
Line 2307: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2303: if P is not null
2304: then
2305: l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);
2306: end if;
2307: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2308: htp.bodyClose;
2309: */
2310: NULL;
2311: END IF; -- if added to support timeout feature.. if there is a session, use it, else create pseudo. mputman
Line 2308: htp.bodyClose;
2304: then
2305: l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);
2306: end if;
2307: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2308: htp.bodyClose;
2309: */
2310: NULL;
2311: END IF; -- if added to support timeout feature.. if there is a session, use it, else create pseudo. mputman
2312:
Line 2323: --htp.p(SQLERRM);
2319: icx_util.add_error(err_mesg);
2320: icx_admin_sig.error_screen(err_mesg);
2321:
2322: when others then
2323: --htp.p(SQLERRM);
2324: htp.p(dbms_utility.format_error_stack);
2325:
2326: end;
2327:
Line 2324: htp.p(dbms_utility.format_error_stack);
2320: icx_admin_sig.error_screen(err_mesg);
2321:
2322: when others then
2323: --htp.p(SQLERRM);
2324: htp.p(dbms_utility.format_error_stack);
2325:
2326: end;
2327:
2328: -- ***********************************************
Line 2511: --htp.p(SQLERRM);
2507:
2508: exception
2509: when others then
2510: icx_sec.g_validateSession_flag := true;
2511: --htp.p(SQLERRM);
2512: htp.p(dbms_utility.format_error_stack);
2513: end;
2514:
2515: -- ***********************************************
Line 2512: htp.p(dbms_utility.format_error_stack);
2508: exception
2509: when others then
2510: icx_sec.g_validateSession_flag := true;
2511: --htp.p(SQLERRM);
2512: htp.p(dbms_utility.format_error_stack);
2513: end;
2514:
2515: -- ***********************************************
2516: -- procedure runFunction
Line 2749: htp.p(l_message||' not set, contact Administrator');
2745: l_message := 'Applications Servlet Agent';
2746: end if;
2747:
2748: if(c_anchor is null) then
2749: htp.p(l_message||' not set, contact Administrator');
2750: else
2751: c_anchor := FND_WEB_CONFIG.TRAIL_SLASH(c_anchor);
2752:
2753: index1 := INSTRB(c_anchor, '//', 1) + 2; /* skip 'http://' */
Line 2761: htp.p('Invalid '||l_message||', contact Administrator');
2757: if(index1 <> index2) AND (index1 <> 2) AND (index2 > 2)
2758: AND (index1 is not NULL) AND (index2 is not NULL) then
2759: c_anchor := FND_WEB_CONFIG.TRAIL_SLASH(SUBSTRB(c_anchor, 1, index2-1));
2760: else
2761: htp.p('Invalid '||l_message||', contact Administrator');
2762: c_anchor := '';
2763: end if;
2764:
2765: l_encrypted_transaction_id :=
Line 3081: htp.headopen;
3077: -- Check session and current user
3078: wfa_sec.GetSession(username);
3079: username := upper(username);
3080:
3081: htp.headopen;
3082: htp.p('');
Line 3086: htp.p('');
3082: htp.p('');
3087: htp.headclose;
3088:
3089: l_toolbar.title := wf_core.translate('ICX_PREFERENCES');
3090: l_toolbar.help_url := 'javascript:top.help_window()';
Line 3087: htp.headclose;
3083:
3084: icx_admin_sig.help_win_script('GENPREF', null, 'FND');
3085:
3086: htp.p('');
3087: htp.headclose;
3088:
3089: l_toolbar.title := wf_core.translate('ICX_PREFERENCES');
3090: l_toolbar.help_url := 'javascript:top.help_window()';
3091: fnd_message.set_name('ICX','ICX_HELP');
Line 3301: htp.htmlOpen;
3297: l_curr_mail_pref := wf_pref.get_pref (username, 'MAILTYPE');
3298: -- get the document management home node information
3299: fnd_document_management.get_dm_home (username, dm_node_id, dm_node_name);
3300:
3301: htp.htmlOpen;
3302: htp.headOpen;
3303: icx_util.copyright;
3304:
3305:
Line 3302: htp.headOpen;
3298: -- get the document management home node information
3299: fnd_document_management.get_dm_home (username, dm_node_id, dm_node_name);
3300:
3301: htp.htmlOpen;
3302: htp.headOpen;
3303: icx_util.copyright;
3304:
3305:
3306: htp.p('');
3359: htp.headClose;
3360:
3361: htp.p('
');
Line 3358: htp.p('');
3354: }');
3355:
3356:
3357: htp.p('// -->');
3358: htp.p('');
3359: htp.headClose;
3360:
3361: htp.p('
');
3362: icx_util.getPrompts(601,'ICX_PREFERENCE',c_title,c_prompts);
Line 3359: htp.headClose;
3355:
3356:
3357: htp.p('// -->');
3358: htp.p('');
3359: htp.headClose;
3360:
3361: htp.p('
');
3362: icx_util.getPrompts(601,'ICX_PREFERENCE',c_title,c_prompts);
3363:
Line 3361: htp.p('');
3357: htp.p('// -->');
3358: htp.p('');
3359: htp.headClose;
3360:
3361: htp.p('');
3362: icx_util.getPrompts(601,'ICX_PREFERENCE',c_title,c_prompts);
3363:
3364: /* use Oracle logo */
3365: -- icx_admin_sig.toolbar(language_code => c_language_code);
Line 3366: -- htp.title(c_title);
3362: icx_util.getPrompts(601,'ICX_PREFERENCE',c_title,c_prompts);
3363:
3364: /* use Oracle logo */
3365: -- icx_admin_sig.toolbar(language_code => c_language_code);
3366: -- htp.title(c_title);
3367: -- htp.p('
'||c_title||' ');
3368:
3369: htp.br;
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
Line 3367: -- htp.p(''||c_title||' ');
3363:
3364: /* use Oracle logo */
3365: -- icx_admin_sig.toolbar(language_code => c_language_code);
3366: -- htp.title(c_title);
3367: -- htp.p(''||c_title||' ');
3368:
3369: htp.br;
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3371: htp.tableOpen(calign=>'CENTER');
Line 3369: htp.br;
3365: -- icx_admin_sig.toolbar(language_code => c_language_code);
3366: -- htp.title(c_title);
3367: -- htp.p('
'||c_title||' ');
3368:
3369: htp.br;
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3371: htp.tableOpen(calign=>'CENTER');
3372: htp.tableRowOpen; -- Known As
3373: htp.tableData(c_prompts(1),'RIGHT');
Line 3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3366: -- htp.title(c_title);
3367: -- htp.p('
'||c_title||' ');
3368:
3369: htp.br;
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3371: htp.tableOpen(calign=>'CENTER');
3372: htp.tableRowOpen; -- Known As
3373: htp.tableData(c_prompts(1),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
Line 3371: htp.tableOpen(calign=>'CENTER');
3367: -- htp.p('
'||c_title||' ');
3368:
3369: htp.br;
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3371: htp.tableOpen(calign=>'CENTER');
3372: htp.tableRowOpen; -- Known As
3373: htp.tableData(c_prompts(1),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3375: htp.tableRowClose;
Line 3372: htp.tableRowOpen; -- Known As
3368:
3369: htp.br;
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3371: htp.tableOpen(calign=>'CENTER');
3372: htp.tableRowOpen; -- Known As
3373: htp.tableData(c_prompts(1),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3375: htp.tableRowClose;
3376:
Line 3373: htp.tableData(c_prompts(1),'RIGHT');
3369: htp.br;
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3371: htp.tableOpen(calign=>'CENTER');
3372: htp.tableRowOpen; -- Known As
3373: htp.tableData(c_prompts(1),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3375: htp.tableRowClose;
3376:
3377: htp.tableRowOpen; -- Language
Line 3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3370: htp.formOpen('OracleApps.UUI','POST','','','NAME="userpref"');
3371: htp.tableOpen(calign=>'CENTER');
3372: htp.tableRowOpen; -- Known As
3373: htp.tableData(c_prompts(1),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3375: htp.tableRowClose;
3376:
3377: htp.tableRowOpen; -- Language
3378: htp.tableData(c_prompts(2),'RIGHT');
Line 3375: htp.tableRowClose;
3371: htp.tableOpen(calign=>'CENTER');
3372: htp.tableRowOpen; -- Known As
3373: htp.tableData(c_prompts(1),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3375: htp.tableRowClose;
3376:
3377: htp.tableRowOpen; -- Language
3378: htp.tableData(c_prompts(2),'RIGHT');
3379: htp.p('
');
Line 3377: htp.tableRowOpen; -- Language
3373: htp.tableData(c_prompts(1),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3375: htp.tableRowClose;
3376:
3377: htp.tableRowOpen; -- Language
3378: htp.tableData(c_prompts(2),'RIGHT');
3379: htp.p('
');
3380: htp.p('');
3381: for prec in get_lang loop
Line 3378: htp.tableData(c_prompts(2),'RIGHT');
3374: htp.tableData(htf.formText('i_1','40','50',icx_util.replace_alt_quotes(u.description))); -- added call to replcae quotes 2637147
3375: htp.tableRowClose;
3376:
3377: htp.tableRowOpen; -- Language
3378: htp.tableData(c_prompts(2),'RIGHT');
3379: htp.p('
');
3380: htp.p('');
3381: for prec in get_lang loop
3382: if (prec.LANGUAGE_CODE = c_language_code) then
Line 3379: htp.p('');
3375: htp.tableRowClose;
3376:
3377: htp.tableRowOpen; -- Language
3378: htp.tableData(c_prompts(2),'RIGHT');
3379: htp.p('
');
3380: htp.p('');
3381: for prec in get_lang loop
3382: if (prec.LANGUAGE_CODE = c_language_code) then
3383: htp.p('');
3376:
3377: htp.tableRowOpen; -- Language
3378: htp.tableData(c_prompts(2),'RIGHT');
3379: htp.p('
');
3380: htp.p('');
3381: for prec in get_lang loop
3382: if (prec.LANGUAGE_CODE = c_language_code) then
3383: htp.p(' ' || prec.description );
Line 3383: htp.p('');
3380: htp.p('');
3381: for prec in get_lang loop
3382: if (prec.LANGUAGE_CODE = c_language_code) then
3383: htp.p(' ' || prec.description );
3385: else
3386: htp.p(' ' || prec.description );
Line 3386: htp.p('
3384: '" SELECTED> ' || prec.description );
3385: else
3386: htp.p(' ' || prec.description );
3388: end if;
3389: end loop;
3390: htp.p(' ');
Line 3390: htp.p('');
3386: htp.p(' ' || prec.description );
3388: end if;
3389: end loop;
3390: htp.p('');
3391: htp.p('
');
3392: htp.tableRowClose;
3393: --toggle this off if not using timezones
3394: IF l_tz_enabled = 'Y' THEN
Line 3391: htp.p(' ');
3387: '"> ' || prec.description );
3388: end if;
3389: end loop;
3390: htp.p('
');
3391: htp.p(' ');
3392: htp.tableRowClose;
3393: --toggle this off if not using timezones
3394: IF l_tz_enabled = 'Y' THEN
3395:
Line 3392: htp.tableRowClose;
3388: end if;
3389: end loop;
3390: htp.p('
');
3391: htp.p(' ');
3392: htp.tableRowClose;
3393: --toggle this off if not using timezones
3394: IF l_tz_enabled = 'Y' THEN
3395:
3396: --TZ
Line 3397: htp.tableRowOpen; -- Timezone
3393: --toggle this off if not using timezones
3394: IF l_tz_enabled = 'Y' THEN
3395:
3396: --TZ
3397: htp.tableRowOpen; -- Timezone
3398: htp.tableData(c_prompts(11),'RIGHT');
3399: htp.p('
');
3400: htp.p('');
3401: htp.p(' ');
Line 3398: htp.tableData(c_prompts(11),'RIGHT');
3394: IF l_tz_enabled = 'Y' THEN
3395:
3396: --TZ
3397: htp.tableRowOpen; -- Timezone
3398: htp.tableData(c_prompts(11),'RIGHT');
3399: htp.p('
');
3400: htp.p('');
3401: htp.p(' ');
3402: for tz in get_tz loop
Line 3399: htp.p('');
3395:
3396: --TZ
3397: htp.tableRowOpen; -- Timezone
3398: htp.tableData(c_prompts(11),'RIGHT');
3399: htp.p('
');
3400: htp.p('');
3401: htp.p(' ');
3402: for tz in get_tz loop
3403: --need if tz%ROWCOUNT>0 then ... here
Line 3400: htp.p('');
3396: --TZ
3397: htp.tableRowOpen; -- Timezone
3398: htp.tableData(c_prompts(11),'RIGHT');
3399: htp.p('
');
3400: htp.p('');
3401: htp.p(' ');
3402: for tz in get_tz loop
3403: --need if tz%ROWCOUNT>0 then ... here
3404: if (tz.PROFILE_VALUE = l_timezone) then
Line 3401: htp.p(' ');
3397: htp.tableRowOpen; -- Timezone
3398: htp.tableData(c_prompts(11),'RIGHT');
3399: htp.p('
');
3400: htp.p('');
3401: htp.p(' ');
3402: for tz in get_tz loop
3403: --need if tz%ROWCOUNT>0 then ... here
3404: if (tz.PROFILE_VALUE = l_timezone) then
3405: htp.p('
3401: htp.p(' ');
3402: for tz in get_tz loop
3403: --need if tz%ROWCOUNT>0 then ... here
3404: if (tz.PROFILE_VALUE = l_timezone) then
3405: htp.p(' ' || tz.DISPLAYED_NAME );
3407: else
3408: htp.p(' ' || tz.DISPLAYED_NAME );
Line 3408: htp.p('
3406: '" SELECTED> ' || tz.DISPLAYED_NAME );
3407: else
3408: htp.p(' ' || tz.DISPLAYED_NAME );
3410: end if;
3411: end loop;
3412: htp.p(' ');
Line 3412: htp.p('');
3408: htp.p(' ' || tz.DISPLAYED_NAME );
3410: end if;
3411: end loop;
3412: htp.p('');
3413: htp.p('
');
3414: htp.tableRowClose;
3415:
3416: --end TZ
Line 3413: htp.p(' ');
3409: '"> ' || tz.DISPLAYED_NAME );
3410: end if;
3411: end loop;
3412: htp.p('
');
3413: htp.p(' ');
3414: htp.tableRowClose;
3415:
3416: --end TZ
3417: ELSE
Line 3414: htp.tableRowClose;
3410: end if;
3411: end loop;
3412: htp.p('
');
3413: htp.p(' ');
3414: htp.tableRowClose;
3415:
3416: --end TZ
3417: ELSE
3418: htp.formHidden('i_11',l_timezone);-- timezone hidden/disabled
Line 3418: htp.formHidden('i_11',l_timezone);-- timezone hidden/disabled
3414: htp.tableRowClose;
3415:
3416: --end TZ
3417: ELSE
3418: htp.formHidden('i_11',l_timezone);-- timezone hidden/disabled
3419:
3420: END IF;
3421: --FND CLIENT ENCODING
3422: htp.tableRowOpen;
Line 3422: htp.tableRowOpen;
3418: htp.formHidden('i_11',l_timezone);-- timezone hidden/disabled
3419:
3420: END IF;
3421: --FND CLIENT ENCODING
3422: htp.tableRowOpen;
3423: htp.tableData(c_prompts(12),'RIGHT');
3424: htp.p('
');
3425: htp.p('');
3426: htp.p(' ');
Line 3423: htp.tableData(c_prompts(12),'RIGHT');
3419:
3420: END IF;
3421: --FND CLIENT ENCODING
3422: htp.tableRowOpen;
3423: htp.tableData(c_prompts(12),'RIGHT');
3424: htp.p('
');
3425: htp.p('');
3426: htp.p(' ');
3427:
Line 3424: htp.p('');
3420: END IF;
3421: --FND CLIENT ENCODING
3422: htp.tableRowOpen;
3423: htp.tableData(c_prompts(12),'RIGHT');
3424: htp.p('
');
3425: htp.p('');
3426: htp.p(' ');
3427:
3428: for i in 1..l_enc_lookup_meanings.COUNT loop
Line 3425: htp.p('');
3421: --FND CLIENT ENCODING
3422: htp.tableRowOpen;
3423: htp.tableData(c_prompts(12),'RIGHT');
3424: htp.p('
');
3425: htp.p('');
3426: htp.p(' ');
3427:
3428: for i in 1..l_enc_lookup_meanings.COUNT loop
3429: if (l_encoding = l_enc_lookup_codes(i)) then
Line 3426: htp.p(' ');
3422: htp.tableRowOpen;
3423: htp.tableData(c_prompts(12),'RIGHT');
3424: htp.p('
');
3425: htp.p('');
3426: htp.p(' ');
3427:
3428: for i in 1..l_enc_lookup_meanings.COUNT loop
3429: if (l_encoding = l_enc_lookup_codes(i)) then
3430: htp.p('
3426: htp.p(' ');
3427:
3428: for i in 1..l_enc_lookup_meanings.COUNT loop
3429: if (l_encoding = l_enc_lookup_codes(i)) then
3430: htp.p(' ' || l_enc_lookup_meanings(i) );
3432: else
3433: htp.p(' ' || l_enc_lookup_meanings(i) );
Line 3433: htp.p('
3431: '" SELECTED> ' || l_enc_lookup_meanings(i) );
3432: else
3433: htp.p(' ' || l_enc_lookup_meanings(i) );
3435: end if;
3436: end loop;
3437: htp.p(' ');
Line 3437: htp.p('');
3433: htp.p(' ' || l_enc_lookup_meanings(i) );
3435: end if;
3436: end loop;
3437: htp.p('');
3438: htp.p('
');
3439: htp.tableRowClose;
3440:
3441:
Line 3438: htp.p(' ');
3434: '"> ' || l_enc_lookup_meanings(i) );
3435: end if;
3436: end loop;
3437: htp.p('
');
3438: htp.p(' ');
3439: htp.tableRowClose;
3440:
3441:
3442: --fce
Line 3439: htp.tableRowClose;
3435: end if;
3436: end loop;
3437: htp.p('
');
3438: htp.p(' ');
3439: htp.tableRowClose;
3440:
3441:
3442: --fce
3443:
Line 3445: htp.tableRowOpen; -- date format
3441:
3442: --fce
3443:
3444:
3445: htp.tableRowOpen; -- date format
3446: htp.tableData(c_prompts(3),'RIGHT');
3447: fnd_message.set_name('ICX','ICX_RRRR');
3448: l_message := fnd_message.get;
3449: htp.p('
');
Line 3446: htp.tableData(c_prompts(3),'RIGHT');
3442: --fce
3443:
3444:
3445: htp.tableRowOpen; -- date format
3446: htp.tableData(c_prompts(3),'RIGHT');
3447: fnd_message.set_name('ICX','ICX_RRRR');
3448: l_message := fnd_message.get;
3449: htp.p('
');
3450: htp.formSelectOpen('i_3');
Line 3449: htp.p('');
3445: htp.tableRowOpen; -- date format
3446: htp.tableData(c_prompts(3),'RIGHT');
3447: fnd_message.set_name('ICX','ICX_RRRR');
3448: l_message := fnd_message.get;
3449: htp.p('
');
3450: htp.formSelectOpen('i_3');
3451: for i in 1..l_lookup_meanings.COUNT loop
3452: if l_date_format = l_lookup_codes(i)
3453: then
Line 3450: htp.formSelectOpen('i_3');
3446: htp.tableData(c_prompts(3),'RIGHT');
3447: fnd_message.set_name('ICX','ICX_RRRR');
3448: l_message := fnd_message.get;
3449: htp.p('
');
3450: htp.formSelectOpen('i_3');
3451: for i in 1..l_lookup_meanings.COUNT loop
3452: if l_date_format = l_lookup_codes(i)
3453: then
3454: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
Line 3454: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
3450: htp.formSelectOpen('i_3');
3451: for i in 1..l_lookup_meanings.COUNT loop
3452: if l_date_format = l_lookup_codes(i)
3453: then
3454: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
3455: else
3456: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'','VALUE="'||l_lookup_codes(i)||'"');
3457: end if;
3458: end loop;
Line 3456: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'','VALUE="'||l_lookup_codes(i)||'"');
3452: if l_date_format = l_lookup_codes(i)
3453: then
3454: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
3455: else
3456: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'','VALUE="'||l_lookup_codes(i)||'"');
3457: end if;
3458: end loop;
3459: htp.formSelectClose;
3460: htp.p('
');
Line 3459: htp.formSelectClose;
3455: else
3456: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'','VALUE="'||l_lookup_codes(i)||'"');
3457: end if;
3458: end loop;
3459: htp.formSelectClose;
3460: htp.p('
');
3461: htp.tableRowClose;
3462:
3463: htp.tableRowOpen; -- nls numeric characters
Line 3460: htp.p(' ');
3456: htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'','VALUE="'||l_lookup_codes(i)||'"');
3457: end if;
3458: end loop;
3459: htp.formSelectClose;
3460: htp.p('
');
3461: htp.tableRowClose;
3462:
3463: htp.tableRowOpen; -- nls numeric characters
3464: htp.tableData(c_prompts(9), 'RIGHT');
Line 3461: htp.tableRowClose;
3457: end if;
3458: end loop;
3459: htp.formSelectClose;
3460: htp.p('');
3461: htp.tableRowClose;
3462:
3463: htp.tableRowOpen; -- nls numeric characters
3464: htp.tableData(c_prompts(9), 'RIGHT');
3465: htp.p('
');
Line 3463: htp.tableRowOpen; -- nls numeric characters
3459: htp.formSelectClose;
3460: htp.p('
');
3461: htp.tableRowClose;
3462:
3463: htp.tableRowOpen; -- nls numeric characters
3464: htp.tableData(c_prompts(9), 'RIGHT');
3465: htp.p('');
3466: htp.p('');
3467: -- change to use lookup for icx_numeric_characters
Line 3464: htp.tableData(c_prompts(9), 'RIGHT');
3460: htp.p('
');
3461: htp.tableRowClose;
3462:
3463: htp.tableRowOpen; -- nls numeric characters
3464: htp.tableData(c_prompts(9), 'RIGHT');
3465: htp.p('');
3466: htp.p('');
3467: -- change to use lookup for icx_numeric_characters
3468: FOR i IN 1..l_numeric_lookup_meanings.count LOOP
Line 3465: htp.p('');
3461: htp.tableRowClose;
3462:
3463: htp.tableRowOpen; -- nls numeric characters
3464: htp.tableData(c_prompts(9), 'RIGHT');
3465: htp.p('
');
3466: htp.p('');
3467: -- change to use lookup for icx_numeric_characters
3468: FOR i IN 1..l_numeric_lookup_meanings.count LOOP
3469: /*
Line 3466: htp.p('');
3462:
3463: htp.tableRowOpen; -- nls numeric characters
3464: htp.tableData(c_prompts(9), 'RIGHT');
3465: htp.p('
');
3466: htp.p('');
3467: -- change to use lookup for icx_numeric_characters
3468: FOR i IN 1..l_numeric_lookup_meanings.count LOOP
3469: /*
3470: if l_numeric_characters = ',.'
Line 3472: htp.p(' ' || '10,000.00' );
3468: FOR i IN 1..l_numeric_lookup_meanings.count LOOP
3469: /*
3470: if l_numeric_characters = ',.'
3471: then
3472: htp.p(' ' || '10,000.00' );
3473: htp.p(' ' || '10.000,00' );
3474: else
3475: htp.p(' ' || '10,000.00' );
3476: htp.p(' ' || '10.000,00' );
Line 3473: htp.p(' ' || '10.000,00' );
3469: /*
3470: if l_numeric_characters = ',.'
3471: then
3472: htp.p(' ' || '10,000.00' );
3473: htp.p(' ' || '10.000,00' );
3474: else
3475: htp.p(' ' || '10,000.00' );
3476: htp.p(' ' || '10.000,00' );
3477: end if;
Line 3475: htp.p(' ' || '10,000.00' );
3471: then
3472: htp.p(' ' || '10,000.00' );
3473: htp.p(' ' || '10.000,00' );
3474: else
3475: htp.p(' ' || '10,000.00' );
3476: htp.p(' ' || '10.000,00' );
3477: end if;
3478: */
3479: if (l_numeric_characters = l_numeric_lookup_codes(i)) then
Line 3476: htp.p(' ' || '10.000,00' );
3472: htp.p(' ' || '10,000.00' );
3473: htp.p(' ' || '10.000,00' );
3474: else
3475: htp.p(' ' || '10,000.00' );
3476: htp.p(' ' || '10.000,00' );
3477: end if;
3478: */
3479: if (l_numeric_characters = l_numeric_lookup_codes(i)) then
3480: htp.p('
3476: htp.p(' ' || '10.000,00' );
3477: end if;
3478: */
3479: if (l_numeric_characters = l_numeric_lookup_codes(i)) then
3480: htp.p(' ' || l_numeric_lookup_meanings(i) );
3482: else
3483: htp.p(' ' || l_numeric_lookup_meanings(i) );
Line 3483: htp.p('
3481: '" SELECTED> ' || l_numeric_lookup_meanings(i) );
3482: else
3483: htp.p(' ' || l_numeric_lookup_meanings(i) );
3485: end if;
3486: END LOOP;
3487:
Line 3488: htp.p('');
3484: '"> ' || l_numeric_lookup_meanings(i) );
3485: end if;
3486: END LOOP;
3487:
3488: htp.p('');
3489: htp.p('
');
3490: htp.tableRowClose;
3491:
3492: htp.tableRowOpen; -- nls territory
Line 3489: htp.p(' ');
3485: end if;
3486: END LOOP;
3487:
3488: htp.p('
');
3489: htp.p(' ');
3490: htp.tableRowClose;
3491:
3492: htp.tableRowOpen; -- nls territory
3493: htp.tableData(c_prompts(10), 'RIGHT');
Line 3490: htp.tableRowClose;
3486: END LOOP;
3487:
3488: htp.p('');
3489: htp.p('');
3490: htp.tableRowClose;
3491:
3492: htp.tableRowOpen; -- nls territory
3493: htp.tableData(c_prompts(10), 'RIGHT');
3494: htp.p('
');
Line 3492: htp.tableRowOpen; -- nls territory
3488: htp.p('');
3489: htp.p('
');
3490: htp.tableRowClose;
3491:
3492: htp.tableRowOpen; -- nls territory
3493: htp.tableData(c_prompts(10), 'RIGHT');
3494: htp.p('');
3495: htp.p('');
3496:
Line 3493: htp.tableData(c_prompts(10), 'RIGHT');
3489: htp.p('
');
3490: htp.tableRowClose;
3491:
3492: htp.tableRowOpen; -- nls territory
3493: htp.tableData(c_prompts(10), 'RIGHT');
3494: htp.p('');
3495: htp.p('');
3496:
3497: for trec in get_territory loop
Line 3494: htp.p('');
3490: htp.tableRowClose;
3491:
3492: htp.tableRowOpen; -- nls territory
3493: htp.tableData(c_prompts(10), 'RIGHT');
3494: htp.p('
');
3495: htp.p('');
3496:
3497: for trec in get_territory loop
3498: if (trec.nls_territory = l_territory) then
Line 3495: htp.p('');
3491:
3492: htp.tableRowOpen; -- nls territory
3493: htp.tableData(c_prompts(10), 'RIGHT');
3494: htp.p('
');
3495: htp.p('');
3496:
3497: for trec in get_territory loop
3498: if (trec.nls_territory = l_territory) then
3499: htp.p(' ' || trec.territory_name);
Line 3499: htp.p(' ' || trec.territory_name);
3495: htp.p('');
3496:
3497: for trec in get_territory loop
3498: if (trec.nls_territory = l_territory) then
3499: htp.p(' ' || trec.territory_name);
3500: else
3501: htp.p(' ' || trec.territory_name );
3502: end if;
3503: end loop;
Line 3501: htp.p(' ' || trec.territory_name );
3497: for trec in get_territory loop
3498: if (trec.nls_territory = l_territory) then
3499: htp.p(' ' || trec.territory_name);
3500: else
3501: htp.p(' ' || trec.territory_name );
3502: end if;
3503: end loop;
3504:
3505: htp.p('');
Line 3505: htp.p('');
3501: htp.p(' ' || trec.territory_name );
3502: end if;
3503: end loop;
3504:
3505: htp.p('');
3506: htp.p('
');
3507: htp.tableRowClose;
3508:
3509: htp.tableRowOpen; -- Mail Preference
Line 3506: htp.p(' ');
3502: end if;
3503: end loop;
3504:
3505: htp.p('
');
3506: htp.p(' ');
3507: htp.tableRowClose;
3508:
3509: htp.tableRowOpen; -- Mail Preference
3510: htp.tableData(wf_core.translate('WFPREF_SENDEMAIL_PROMPT'),'RIGHT');
Line 3507: htp.tableRowClose;
3503: end loop;
3504:
3505: htp.p('');
3506: htp.p('');
3507: htp.tableRowClose;
3508:
3509: htp.tableRowOpen; -- Mail Preference
3510: htp.tableData(wf_core.translate('WFPREF_SENDEMAIL_PROMPT'),'RIGHT');
3511: htp.p('
');
Line 3509: htp.tableRowOpen; -- Mail Preference
3505: htp.p('');
3506: htp.p('
');
3507: htp.tableRowClose;
3508:
3509: htp.tableRowOpen; -- Mail Preference
3510: htp.tableData(wf_core.translate('WFPREF_SENDEMAIL_PROMPT'),'RIGHT');
3511: htp.p('');
3512: htp.p('');
3513:
Line 3510: htp.tableData(wf_core.translate('WFPREF_SENDEMAIL_PROMPT'),'RIGHT');
3506: htp.p('
');
3507: htp.tableRowClose;
3508:
3509: htp.tableRowOpen; -- Mail Preference
3510: htp.tableData(wf_core.translate('WFPREF_SENDEMAIL_PROMPT'),'RIGHT');
3511: htp.p('');
3512: htp.p('');
3513:
3514: /*
Line 3511: htp.p('');
3507: htp.tableRowClose;
3508:
3509: htp.tableRowOpen; -- Mail Preference
3510: htp.tableData(wf_core.translate('WFPREF_SENDEMAIL_PROMPT'),'RIGHT');
3511: htp.p('
');
3512: htp.p('');
3513:
3514: /*
3515: ** The get_mail cursor is used to fetch the codes and display names
Line 3512: htp.p('');
3508:
3509: htp.tableRowOpen; -- Mail Preference
3510: htp.tableData(wf_core.translate('WFPREF_SENDEMAIL_PROMPT'),'RIGHT');
3511: htp.p('
');
3512: htp.p('');
3513:
3514: /*
3515: ** The get_mail cursor is used to fetch the codes and display names
3516: ** used for the mail preference values.
Line 3530: htp.p(' ' || mail.text);
3526: for mail in get_mail loop
3527: l_mail_pref := SUBSTR(mail.name, INSTR(mail.name, '-') + 1);
3528:
3529: if (l_mail_pref = l_curr_mail_pref) then
3530: htp.p(' ' || mail.text);
3531: else
3532: htp.p(' ' || mail.text );
3533: end if;
3534: end loop;
Line 3532: htp.p(' ' || mail.text );
3528:
3529: if (l_mail_pref = l_curr_mail_pref) then
3530: htp.p(' ' || mail.text);
3531: else
3532: htp.p(' ' || mail.text );
3533: end if;
3534: end loop;
3535:
3536: htp.p('');
Line 3536: htp.p('');
3532: htp.p(' ' || mail.text );
3533: end if;
3534: end loop;
3535:
3536: htp.p('');
3537: htp.p('
');
3538: htp.tableRowClose;
3539:
3540: ---------
Line 3537: htp.p(' ');
3533: end if;
3534: end loop;
3535:
3536: htp.p('
');
3537: htp.p(' ');
3538: htp.tableRowClose;
3539:
3540: ---------
3541: OPEN get_dm;
Line 3538: htp.tableRowClose;
3534: end loop;
3535:
3536: htp.p('');
3537: htp.p('');
3538: htp.tableRowClose;
3539:
3540: ---------
3541: OPEN get_dm;
3542: FETCH get_dm bulk collect INTO v_node_id, v_node_name;
Line 3545: htp.tableRowOpen; -- DM Home Preference
3541: OPEN get_dm;
3542: FETCH get_dm bulk collect INTO v_node_id, v_node_name;
3543: CLOSE get_dm;
3544: IF v_node_id.count > 0 THEN
3545: htp.tableRowOpen; -- DM Home Preference
3546: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3547: htp.p('
');
3548: htp.p('');
3549: FOR counter IN 1..v_node_id.count LOOP
Line 3546: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3542: FETCH get_dm bulk collect INTO v_node_id, v_node_name;
3543: CLOSE get_dm;
3544: IF v_node_id.count > 0 THEN
3545: htp.tableRowOpen; -- DM Home Preference
3546: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3547: htp.p('
');
3548: htp.p('');
3549: FOR counter IN 1..v_node_id.count LOOP
3550:
Line 3547: htp.p('');
3543: CLOSE get_dm;
3544: IF v_node_id.count > 0 THEN
3545: htp.tableRowOpen; -- DM Home Preference
3546: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3547: htp.p('
');
3548: htp.p('');
3549: FOR counter IN 1..v_node_id.count LOOP
3550:
3551:
Line 3548: htp.p('');
3544: IF v_node_id.count > 0 THEN
3545: htp.tableRowOpen; -- DM Home Preference
3546: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3547: htp.p('
');
3548: htp.p('');
3549: FOR counter IN 1..v_node_id.count LOOP
3550:
3551:
3552: if (v_node_id(counter) = dm_node_id) then
Line 3554: htp.p('
3555: '" SELECTED> ' || v_node_name(counter));
3556:
3557: else
3558:
Line 3559: htp.p(' ' || v_node_name(counter));
3556:
3557: else
3558:
3559: htp.p(' ' || v_node_name(counter));
3561:
3562: end if;
3563:
Line 3566: htp.p('');
3562: end if;
3563:
3564: end loop;
3565:
3566: htp.p('');
3567: htp.p('
');
3568: htp.tableRowClose;
3569:
3570: ELSE
Line 3567: htp.p(' ');
3563:
3564: end loop;
3565:
3566: htp.p('
');
3567: htp.p(' ');
3568: htp.tableRowClose;
3569:
3570: ELSE
3571: htp.formHidden('i_8','');-- DM Home
Line 3568: htp.tableRowClose;
3564: end loop;
3565:
3566: htp.p('
');
3567: htp.p(' ');
3568: htp.tableRowClose;
3569:
3570: ELSE
3571: htp.formHidden('i_8','');-- DM Home
3572: END IF;
Line 3571: htp.formHidden('i_8','');-- DM Home
3567: htp.p('');
3568: htp.tableRowClose;
3569:
3570: ELSE
3571: htp.formHidden('i_8','');-- DM Home
3572: END IF;
3573: /*
3574: ---------
3575: htp.tableRowOpen; -- DM Home Preference
Line 3575: htp.tableRowOpen; -- DM Home Preference
3571: htp.formHidden('i_8','');-- DM Home
3572: END IF;
3573: /*
3574: ---------
3575: htp.tableRowOpen; -- DM Home Preference
3576: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3577: htp.p('
');
3578: htp.p('');
3579:
Line 3576: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3572: END IF;
3573: /*
3574: ---------
3575: htp.tableRowOpen; -- DM Home Preference
3576: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3577: htp.p('
');
3578: htp.p('');
3579:
3580: for dm in get_dm loop
Line 3577: htp.p('');
3573: /*
3574: ---------
3575: htp.tableRowOpen; -- DM Home Preference
3576: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3577: htp.p('
');
3578: htp.p('');
3579:
3580: for dm in get_dm loop
3581: if (dm.node_id = dm_node_id) then
Line 3578: htp.p('');
3574: ---------
3575: htp.tableRowOpen; -- DM Home Preference
3576: htp.tableData(wf_core.translate('WFPREF_DMHOME_PROMPT'),'RIGHT');
3577: htp.p('
');
3578: htp.p('');
3579:
3580: for dm in get_dm loop
3581: if (dm.node_id = dm_node_id) then
3582:
Line 3583: htp.p('
3584: '" SELECTED> ' || dm.node_name);
3585:
3586: else
3587:
Line 3588: htp.p(' ' || dm.node_name);
3585:
3586: else
3587:
3588: htp.p(' ' || dm.node_name );
3590:
3591: end if;
3592:
Line 3595: htp.p('');
3591: end if;
3592:
3593: end loop;
3594:
3595: htp.p('');
3596: htp.p('
');
3597: htp.tableRowClose;
3598:
3599: */
Line 3596: htp.p(' ');
3592:
3593: end loop;
3594:
3595: htp.p('
');
3596: htp.p(' ');
3597: htp.tableRowClose;
3598:
3599: */
3600: IF l_auth_mode <>'LDAP' THEN
Line 3597: htp.tableRowClose;
3593: end loop;
3594:
3595: htp.p('
');
3596: htp.p(' ');
3597: htp.tableRowClose;
3598:
3599: */
3600: IF l_auth_mode <>'LDAP' THEN
3601:
Line 3602: htp.tableRowOpen; -- Old Password
3598:
3599: */
3600: IF l_auth_mode <>'LDAP' THEN
3601:
3602: htp.tableRowOpen; -- Old Password
3603: htp.tableData(c_prompts(4),'RIGHT');
3604: htp.tableData(htf.formPassword('i_4','30','50'));
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
Line 3603: htp.tableData(c_prompts(4),'RIGHT');
3599: */
3600: IF l_auth_mode <>'LDAP' THEN
3601:
3602: htp.tableRowOpen; -- Old Password
3603: htp.tableData(c_prompts(4),'RIGHT');
3604: htp.tableData(htf.formPassword('i_4','30','50'));
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
Line 3604: htp.tableData(htf.formPassword('i_4','30','50'));
3600: IF l_auth_mode <>'LDAP' THEN
3601:
3602: htp.tableRowOpen; -- Old Password
3603: htp.tableData(c_prompts(4),'RIGHT');
3604: htp.tableData(htf.formPassword('i_4','30','50'));
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
Line 3605: htp.tableRowClose;
3601:
3602: htp.tableRowOpen; -- Old Password
3603: htp.tableData(c_prompts(4),'RIGHT');
3604: htp.tableData(htf.formPassword('i_4','30','50'));
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
Line 3606: htp.tableRowOpen; -- Password
3602: htp.tableRowOpen; -- Old Password
3603: htp.tableData(c_prompts(4),'RIGHT');
3604: htp.tableData(htf.formPassword('i_4','30','50'));
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
Line 3607: htp.tableData(c_prompts(5),'RIGHT');
3603: htp.tableData(c_prompts(4),'RIGHT');
3604: htp.tableData(htf.formPassword('i_4','30','50'));
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
3611: htp.tableData(c_prompts(6),'RIGHT');
Line 3608: htp.tableData(htf.formPassword('i_5','30','50'));
3604: htp.tableData(htf.formPassword('i_4','30','50'));
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
3611: htp.tableData(c_prompts(6),'RIGHT');
3612: htp.tableData(htf.formPassword('i_6','30','50'));
Line 3609: htp.tableRowClose;
3605: htp.tableRowClose;
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
3611: htp.tableData(c_prompts(6),'RIGHT');
3612: htp.tableData(htf.formPassword('i_6','30','50'));
3613: htp.tableRowClose;
Line 3610: htp.tableRowOpen; -- Repeat Password
3606: htp.tableRowOpen; -- Password
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
3611: htp.tableData(c_prompts(6),'RIGHT');
3612: htp.tableData(htf.formPassword('i_6','30','50'));
3613: htp.tableRowClose;
3614: ELSE
Line 3611: htp.tableData(c_prompts(6),'RIGHT');
3607: htp.tableData(c_prompts(5),'RIGHT');
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
3611: htp.tableData(c_prompts(6),'RIGHT');
3612: htp.tableData(htf.formPassword('i_6','30','50'));
3613: htp.tableRowClose;
3614: ELSE
3615: htp.formHidden('i_4','');-- Old Password
Line 3612: htp.tableData(htf.formPassword('i_6','30','50'));
3608: htp.tableData(htf.formPassword('i_5','30','50'));
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
3611: htp.tableData(c_prompts(6),'RIGHT');
3612: htp.tableData(htf.formPassword('i_6','30','50'));
3613: htp.tableRowClose;
3614: ELSE
3615: htp.formHidden('i_4','');-- Old Password
3616: htp.formHidden('i_5','');-- Password
Line 3613: htp.tableRowClose;
3609: htp.tableRowClose;
3610: htp.tableRowOpen; -- Repeat Password
3611: htp.tableData(c_prompts(6),'RIGHT');
3612: htp.tableData(htf.formPassword('i_6','30','50'));
3613: htp.tableRowClose;
3614: ELSE
3615: htp.formHidden('i_4','');-- Old Password
3616: htp.formHidden('i_5','');-- Password
3617: htp.formHidden('i_6','');-- Repeat Password
Line 3615: htp.formHidden('i_4','');-- Old Password
3611: htp.tableData(c_prompts(6),'RIGHT');
3612: htp.tableData(htf.formPassword('i_6','30','50'));
3613: htp.tableRowClose;
3614: ELSE
3615: htp.formHidden('i_4','');-- Old Password
3616: htp.formHidden('i_5','');-- Password
3617: htp.formHidden('i_6','');-- Repeat Password
3618: END IF;
3619: htp.tableClose;
Line 3616: htp.formHidden('i_5','');-- Password
3612: htp.tableData(htf.formPassword('i_6','30','50'));
3613: htp.tableRowClose;
3614: ELSE
3615: htp.formHidden('i_4','');-- Old Password
3616: htp.formHidden('i_5','');-- Password
3617: htp.formHidden('i_6','');-- Repeat Password
3618: END IF;
3619: htp.tableClose;
3620: htp.nl;
Line 3617: htp.formHidden('i_6','');-- Repeat Password
3613: htp.tableRowClose;
3614: ELSE
3615: htp.formHidden('i_4','');-- Old Password
3616: htp.formHidden('i_5','');-- Password
3617: htp.formHidden('i_6','');-- Repeat Password
3618: END IF;
3619: htp.tableClose;
3620: htp.nl;
3621:
Line 3619: htp.tableClose;
3615: htp.formHidden('i_4','');-- Old Password
3616: htp.formHidden('i_5','');-- Password
3617: htp.formHidden('i_6','');-- Repeat Password
3618: END IF;
3619: htp.tableClose;
3620: htp.nl;
3621:
3622: htp.formClose; --userpref
3623:
Line 3620: htp.nl;
3616: htp.formHidden('i_5','');-- Password
3617: htp.formHidden('i_6','');-- Repeat Password
3618: END IF;
3619: htp.tableClose;
3620: htp.nl;
3621:
3622: htp.formClose; --userpref
3623:
3624:
Line 3622: htp.formClose; --userpref
3618: END IF;
3619: htp.tableClose;
3620: htp.nl;
3621:
3622: htp.formClose; --userpref
3623:
3624:
3625: l_actions(0).name := 'Cancel';
3626: l_actions(0).text := wf_core.translate('CANCEL');
Line 3656: htp.bodyClose;
3652: icx_cabo.buttons(p_actions => l_actions,
3653: p_actiontext => l_actiontext);
3654: end if;
3655:
3656: htp.bodyClose;
3657: htp.htmlClose;
3658:
3659: end if; --validatesession
3660:
Line 3657: htp.htmlClose;
3653: p_actiontext => l_actiontext);
3654: end if;
3655:
3656: htp.bodyClose;
3657: htp.htmlClose;
3658:
3659: end if; --validatesession
3660:
3661: exception
Line 3693: htp.p(c_error_message);
3689: then
3690:
3691: fnd_message.set_name('IBE','IBE_PRMT_UNAUTHORIZED');
3692: c_error_message := fnd_message.get;
3693: htp.p(c_error_message);
3694: else
3695:
3696: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3697: htp.htmlOpen;
Line 3697: htp.htmlOpen;
3693: htp.p(c_error_message);
3694: else
3695:
3696: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3697: htp.htmlOpen;
3698: htp.headOpen;
3699: --icx_util.copyright;
3700: htp.p('');
3735: document.newpass.submit()
3736: };
3737: }');
3738:
3739: htp.p('');
3740: htp.headClose;
3741:
3742: icx_util.getPrompts(601,'ICX_NEW_PASSWORD',c_title,c_prompts);
3743:
Line 3740: htp.headClose;
3736: };
3737: }');
3738:
3739: htp.p('');
3740: htp.headClose;
3741:
3742: icx_util.getPrompts(601,'ICX_NEW_PASSWORD',c_title,c_prompts);
3743:
3744: /* use Oracle logo */
Line 3753: htp.title(c_title);
3749:
3750: fnd_message.set_name('FND','PASSWORD-EXPIRED');
3751: c_title := fnd_message.get;
3752:
3753: htp.title(c_title);
3754: htp.p('
'||c_title||' ');
3755:
3756: --switched the following statments so correct URL is created in stateful environment MPUTMAN
3757: --htp.formOpen(icx_plug_utilities.getPLSQLagent || 'OracleApps.UNP','POST','','','NAME="newpass"');
Line 3754: htp.p(''||c_title||' ');
3750: fnd_message.set_name('FND','PASSWORD-EXPIRED');
3751: c_title := fnd_message.get;
3752:
3753: htp.title(c_title);
3754: htp.p(''||c_title||' ');
3755:
3756: --switched the following statments so correct URL is created in stateful environment MPUTMAN
3757: --htp.formOpen(icx_plug_utilities.getPLSQLagent || 'OracleApps.UNP','POST','','','NAME="newpass"');
3758: htp.formOpen('OracleApps.UNP','POST','','','NAME="newpass"');
Line 3757: --htp.formOpen(icx_plug_utilities.getPLSQLagent || 'OracleApps.UNP','POST','','','NAME="newpass"');
3753: htp.title(c_title);
3754: htp.p('
'||c_title||' ');
3755:
3756: --switched the following statments so correct URL is created in stateful environment MPUTMAN
3757: --htp.formOpen(icx_plug_utilities.getPLSQLagent || 'OracleApps.UNP','POST','','','NAME="newpass"');
3758: htp.formOpen('OracleApps.UNP','POST','','','NAME="newpass"');
3759:
3760: htp.formHidden('i_1', i_1);
3761: htp.formHidden('c_url', c_url);
Line 3758: htp.formOpen('OracleApps.UNP','POST','','','NAME="newpass"');
3754: htp.p('
'||c_title||' ');
3755:
3756: --switched the following statments so correct URL is created in stateful environment MPUTMAN
3757: --htp.formOpen(icx_plug_utilities.getPLSQLagent || 'OracleApps.UNP','POST','','','NAME="newpass"');
3758: htp.formOpen('OracleApps.UNP','POST','','','NAME="newpass"');
3759:
3760: htp.formHidden('i_1', i_1);
3761: htp.formHidden('c_url', c_url);
3762: htp.formHidden('c_mode_code', c_mode_code);
Line 3760: htp.formHidden('i_1', i_1);
3756: --switched the following statments so correct URL is created in stateful environment MPUTMAN
3757: --htp.formOpen(icx_plug_utilities.getPLSQLagent || 'OracleApps.UNP','POST','','','NAME="newpass"');
3758: htp.formOpen('OracleApps.UNP','POST','','','NAME="newpass"');
3759:
3760: htp.formHidden('i_1', i_1);
3761: htp.formHidden('c_url', c_url);
3762: htp.formHidden('c_mode_code', c_mode_code);
3763:
3764: htp.tableOpen;
Line 3761: htp.formHidden('c_url', c_url);
3757: --htp.formOpen(icx_plug_utilities.getPLSQLagent || 'OracleApps.UNP','POST','','','NAME="newpass"');
3758: htp.formOpen('OracleApps.UNP','POST','','','NAME="newpass"');
3759:
3760: htp.formHidden('i_1', i_1);
3761: htp.formHidden('c_url', c_url);
3762: htp.formHidden('c_mode_code', c_mode_code);
3763:
3764: htp.tableOpen;
3765: htp.tableRowOpen; -- Old Password
Line 3762: htp.formHidden('c_mode_code', c_mode_code);
3758: htp.formOpen('OracleApps.UNP','POST','','','NAME="newpass"');
3759:
3760: htp.formHidden('i_1', i_1);
3761: htp.formHidden('c_url', c_url);
3762: htp.formHidden('c_mode_code', c_mode_code);
3763:
3764: htp.tableOpen;
3765: htp.tableRowOpen; -- Old Password
3766: htp.tableData(c_prompts(2),'RIGHT');
Line 3764: htp.tableOpen;
3760: htp.formHidden('i_1', i_1);
3761: htp.formHidden('c_url', c_url);
3762: htp.formHidden('c_mode_code', c_mode_code);
3763:
3764: htp.tableOpen;
3765: htp.tableRowOpen; -- Old Password
3766: htp.tableData(c_prompts(2),'RIGHT');
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
Line 3765: htp.tableRowOpen; -- Old Password
3761: htp.formHidden('c_url', c_url);
3762: htp.formHidden('c_mode_code', c_mode_code);
3763:
3764: htp.tableOpen;
3765: htp.tableRowOpen; -- Old Password
3766: htp.tableData(c_prompts(2),'RIGHT');
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
Line 3766: htp.tableData(c_prompts(2),'RIGHT');
3762: htp.formHidden('c_mode_code', c_mode_code);
3763:
3764: htp.tableOpen;
3765: htp.tableRowOpen; -- Old Password
3766: htp.tableData(c_prompts(2),'RIGHT');
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
Line 3767: htp.tableData(htf.formPassword('i_2','30','50'));
3763:
3764: htp.tableOpen;
3765: htp.tableRowOpen; -- Old Password
3766: htp.tableData(c_prompts(2),'RIGHT');
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
Line 3768: htp.tableRowClose;
3764: htp.tableOpen;
3765: htp.tableRowOpen; -- Old Password
3766: htp.tableData(c_prompts(2),'RIGHT');
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
Line 3769: htp.tableRowOpen; -- Password
3765: htp.tableRowOpen; -- Old Password
3766: htp.tableData(c_prompts(2),'RIGHT');
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
Line 3770: htp.tableData(c_prompts(3),'RIGHT');
3766: htp.tableData(c_prompts(2),'RIGHT');
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
Line 3771: htp.tableData(htf.formPassword('i_3','30','50'));
3767: htp.tableData(htf.formPassword('i_2','30','50'));
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
Line 3772: htp.tableRowClose;
3768: htp.tableRowClose;
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
3776: htp.tableRowClose;
Line 3773: htp.tableRowOpen; -- Repeat Password
3769: htp.tableRowOpen; -- Password
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
3776: htp.tableRowClose;
3777: htp.tableClose;
Line 3774: htp.tableData(c_prompts(4),'RIGHT');
3770: htp.tableData(c_prompts(3),'RIGHT');
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
3776: htp.tableRowClose;
3777: htp.tableClose;
3778: htp.nl;
Line 3775: htp.tableData(htf.formPassword('i_4','30','50'));
3771: htp.tableData(htf.formPassword('i_3','30','50'));
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
3776: htp.tableRowClose;
3777: htp.tableClose;
3778: htp.nl;
3779:
Line 3776: htp.tableRowClose;
3772: htp.tableRowClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
3776: htp.tableRowClose;
3777: htp.tableClose;
3778: htp.nl;
3779:
3780: icx_util.DynamicButton(P_ButtonText => c_prompts(5),
Line 3777: htp.tableClose;
3773: htp.tableRowOpen; -- Repeat Password
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
3776: htp.tableRowClose;
3777: htp.tableClose;
3778: htp.nl;
3779:
3780: icx_util.DynamicButton(P_ButtonText => c_prompts(5),
3781: P_ImageFileName => 'FNDBSBMT',
Line 3778: htp.nl;
3774: htp.tableData(c_prompts(4),'RIGHT');
3775: htp.tableData(htf.formPassword('i_4','30','50'));
3776: htp.tableRowClose;
3777: htp.tableClose;
3778: htp.nl;
3779:
3780: icx_util.DynamicButton(P_ButtonText => c_prompts(5),
3781: P_ImageFileName => 'FNDBSBMT',
3782: P_OnMouseOverText => c_prompts(5),
Line 3786: htp.formClose;
3782: P_OnMouseOverText => c_prompts(5),
3783: P_HyperTextCall => 'javascript:update_user()',
3784: P_LanguageCode => c_language_code,
3785: P_JavaScriptFlag => FALSE);
3786: htp.formClose;
3787: htp.bodyClose;
3788: htp.p(''); --2330653
Line 3787: htp.bodyClose;
3783: P_HyperTextCall => 'javascript:update_user()',
3784: P_LanguageCode => c_language_code,
3785: P_JavaScriptFlag => FALSE);
3786: htp.formClose;
3787: htp.bodyClose;
3788: htp.p(''); --2330653
3791: htp.htmlClose;
Line 3788: htp.p(''); --2330653
3791: htp.htmlClose;
3792:
Line 3789: htp.p('document.newpass.i_2.focus();'); --2330653
3785: P_JavaScriptFlag => FALSE);
3786: htp.formClose;
3787: htp.bodyClose;
3788: htp.p(''); --2330653
3791: htp.htmlClose;
3792:
3793: end if;
Line 3790: htp.p(''); --2330653
3786: htp.formClose;
3787: htp.bodyClose;
3788: htp.p(''); --2330653
3791: htp.htmlClose;
3792:
3793: end if;
3794:
Line 3791: htp.htmlClose;
3787: htp.bodyClose;
3788: htp.p(''); --2330653
3791: htp.htmlClose;
3792:
3793: end if;
3794:
3795: exception
Line 3934: htp.htmlOpen;
3930: fnd_message.set_encoded(l_msg_data);
3931: -- fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
3932: c_error_msg := fnd_message.get;
3933:
3934: htp.htmlOpen;
3935: htp.headOpen;
3936: icx_util.copyright;
3937:
3938: htp.p('');
Line 3939: htp.p('');
3942: htp.p('');
3943: htp.headClose;
Line 3941: htp.p('// -->');
3937:
3938: htp.p('');
3943: htp.headClose;
3944: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
3945: icx_admin_sig.Closeheader( c_language_code);
Line 3942: htp.p('');
3938: htp.p('');
3943: htp.headClose;
3944: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
3945: icx_admin_sig.Closeheader( c_language_code);
3946: htp.p(c_error_msg);
Line 3943: htp.headClose;
3939: htp.p('');
3942: htp.p('');
3943: htp.headClose;
3944: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
3945: icx_admin_sig.Closeheader( c_language_code);
3946: htp.p(c_error_msg);
3947: htp.htmlClose;
Line 3946: htp.p(c_error_msg);
3942: htp.p('');
3943: htp.headClose;
3944: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
3945: icx_admin_sig.Closeheader( c_language_code);
3946: htp.p(c_error_msg);
3947: htp.htmlClose;
3948: */
3949:
3950: end if; -- not l_password_updated
Line 3947: htp.htmlClose;
3943: htp.headClose;
3944: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
3945: icx_admin_sig.Closeheader( c_language_code);
3946: htp.p(c_error_msg);
3947: htp.htmlClose;
3948: */
3949:
3950: end if; -- not l_password_updated
3951: end if;
Line 4066: htp.p('
4062:
4063: l_url:=l_agent||'OracleApps.displaywebuser';
4064: l_url:='"'||l_url||'"';
4065:
4066: htp.p('
4067:
4068:
4069: ');
Line 4201: htp.p('');
4204: htp.p('');
4205: htp.headClose;
Line 4203: htp.p('// -->');
4199:
4200: htp.p('');
4205: htp.headClose;
4206: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4207: icx_admin_sig.Closeheader( c_language_code);
Line 4204: htp.p('');
4200: htp.p('');
4205: htp.headClose;
4206: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4207: icx_admin_sig.Closeheader( c_language_code);
4208: htp.p(c_error_msg);
Line 4205: htp.headClose;
4201: htp.p('');
4204: htp.p('');
4205: htp.headClose;
4206: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4207: icx_admin_sig.Closeheader( c_language_code);
4208: htp.p(c_error_msg);
4209: htp.nl;
Line 4208: htp.p(c_error_msg);
4204: htp.p('');
4205: htp.headClose;
4206: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4207: icx_admin_sig.Closeheader( c_language_code);
4208: htp.p(c_error_msg);
4209: htp.nl;
4210: htp.p(l_ret_msg); --bug 2766487
4211: htp.htmlClose;
4212: else
Line 4209: htp.nl;
4205: htp.headClose;
4206: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4207: icx_admin_sig.Closeheader( c_language_code);
4208: htp.p(c_error_msg);
4209: htp.nl;
4210: htp.p(l_ret_msg); --bug 2766487
4211: htp.htmlClose;
4212: else
4213:
Line 4210: htp.p(l_ret_msg); --bug 2766487
4206: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4207: icx_admin_sig.Closeheader( c_language_code);
4208: htp.p(c_error_msg);
4209: htp.nl;
4210: htp.p(l_ret_msg); --bug 2766487
4211: htp.htmlClose;
4212: else
4213:
4214: --l_server := rtrim(FND_WEB_CONFIG.WEB_SERVER,'/'); -- mputman removed 1574527
Line 4211: htp.htmlClose;
4207: icx_admin_sig.Closeheader( c_language_code);
4208: htp.p(c_error_msg);
4209: htp.nl;
4210: htp.p(l_ret_msg); --bug 2766487
4211: htp.htmlClose;
4212: else
4213:
4214: --l_server := rtrim(FND_WEB_CONFIG.WEB_SERVER,'/'); -- mputman removed 1574527
4215: --return_to_url := l_server || c_url; -- mputman removed 1574527
Line 4225: htp.htmlOpen;
4221: l_message := icx_sec.validatePassword(c_user_name => c_USERNAME,
4222: c_user_password => c_PASSWORD2,
4223: n_session_id => l_session_id,
4224: c_mode_code => p_mode_code);
4225: htp.htmlOpen;
4226: htp.bodyOpen(cattributes => 'onLoad="top.location.href='''||return_to_url||'''"'); htp.nl;
4227: htp.bodyClose;
4228: htp.htmlClose;
4229:
Line 4226: htp.bodyOpen(cattributes => 'onLoad="top.location.href='''||return_to_url||'''"'); htp.nl;
4222: c_user_password => c_PASSWORD2,
4223: n_session_id => l_session_id,
4224: c_mode_code => p_mode_code);
4225: htp.htmlOpen;
4226: htp.bodyOpen(cattributes => 'onLoad="top.location.href='''||return_to_url||'''"'); htp.nl;
4227: htp.bodyClose;
4228: htp.htmlClose;
4229:
4230: end if; -- not l_password_updated
Line 4227: htp.bodyClose;
4223: n_session_id => l_session_id,
4224: c_mode_code => p_mode_code);
4225: htp.htmlOpen;
4226: htp.bodyOpen(cattributes => 'onLoad="top.location.href='''||return_to_url||'''"'); htp.nl;
4227: htp.bodyClose;
4228: htp.htmlClose;
4229:
4230: end if; -- not l_password_updated
4231: end if;
Line 4228: htp.htmlClose;
4224: c_mode_code => p_mode_code);
4225: htp.htmlOpen;
4226: htp.bodyOpen(cattributes => 'onLoad="top.location.href='''||return_to_url||'''"'); htp.nl;
4227: htp.bodyClose;
4228: htp.htmlClose;
4229:
4230: end if; -- not l_password_updated
4231: end if;
4232: exception
Line 4234: --htp.p(SQLERRM);
4230: end if; -- not l_password_updated
4231: end if;
4232: exception
4233: when others then
4234: --htp.p(SQLERRM);
4235: htp.p(dbms_utility.format_error_stack);
4236: end;
4237:
4238: -- ***********************************************
Line 4235: htp.p(dbms_utility.format_error_stack);
4231: end if;
4232: exception
4233: when others then
4234: --htp.p(SQLERRM);
4235: htp.p(dbms_utility.format_error_stack);
4236: end;
4237:
4238: -- ***********************************************
4239: -- Procedure updateNewPassword
Line 4314: htp.htmlOpen;
4310: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
4311: fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
4312: c_error_msg := fnd_message.get;
4313:
4314: htp.htmlOpen;
4315: htp.headOpen;
4316: icx_util.copyright;
4317:
4318: htp.p('');
Line 4319: htp.p('');
4322: htp.p('');
4323: htp.headClose;
Line 4321: htp.p('// -->');
4317:
4318: htp.p('');
4323: htp.headClose;
4324: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4325: icx_admin_sig.Closeheader( c_language_code);
Line 4322: htp.p('');
4318: htp.p('');
4323: htp.headClose;
4324: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4325: icx_admin_sig.Closeheader( c_language_code);
4326: htp.p(c_error_msg);
Line 4323: htp.headClose;
4319: htp.p('');
4322: htp.p('');
4323: htp.headClose;
4324: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4325: icx_admin_sig.Closeheader( c_language_code);
4326: htp.p(c_error_msg);
4327: htp.htmlClose;
Line 4326: htp.p(c_error_msg);
4322: htp.p('');
4323: htp.headClose;
4324: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4325: icx_admin_sig.Closeheader( c_language_code);
4326: htp.p(c_error_msg);
4327: htp.htmlClose;
4328: else
4329:
4330: commit; -- 2752387
Line 4327: htp.htmlClose;
4323: htp.headClose;
4324: icx_admin_sig.Openheader( NULL, NULL, c_language_code);
4325: icx_admin_sig.Closeheader( c_language_code);
4326: htp.p(c_error_msg);
4327: htp.htmlClose;
4328: else
4329:
4330: commit; -- 2752387
4331: oraclemypage.home(rmode => 2,
Line 4339: --htp.p(SQLERRM);
4335: end if; -- not l_password_updated
4336: end if;
4337: exception
4338: when others then
4339: --htp.p(SQLERRM);
4340: htp.p(dbms_utility.format_error_stack);
4341: end;
4342:
4343: procedure icxLogin (rmode in number,
Line 4340: htp.p(dbms_utility.format_error_stack);
4336: end if;
4337: exception
4338: when others then
4339: --htp.p(SQLERRM);
4340: htp.p(dbms_utility.format_error_stack);
4341: end;
4342:
4343: procedure icxLogin (rmode in number,
4344: i_1 in varchar2,
Line 4366: -- htp.p(SQLERRM);
4362: c_mode_code => l_mode_code);
4363:
4364: exception
4365: when others then
4366: -- htp.p(SQLERRM);
4367: htp.p(dbms_utility.format_error_stack);
4368: end;
4369:
4370: procedure DF(i_direct IN VARCHAR2,
Line 4367: htp.p(dbms_utility.format_error_stack);
4363:
4364: exception
4365: when others then
4366: -- htp.p(SQLERRM);
4367: htp.p(dbms_utility.format_error_stack);
4368: end;
4369:
4370: procedure DF(i_direct IN VARCHAR2,
4371: i_mode IN NUMBER)
Line 4377: htp.p('');
4380: ELSE
4381: htp.p('');
4380: ELSE
4381: htp.p('');
4375:
4376: IF icx_sec.validatesession(c_validate_only=>'Y') THEN
4377: htp.p('');
4380: ELSE
4381: htp.p('');
Line 4381: htp.p('');
4380: ELSE
4381: htp.p('');
4384:
4385: END IF;
Line 4382: htp.p('this.location="OracleApps.displayLogin?i_direct='||i_direct||'&i_mode='||i_mode||'"');
4378: htp.p('this.location="'||i_direct||'"');
4379: htp.p('');
4380: ELSE
4381: htp.p('');
4384:
4385: END IF;
4386:
Line 4383: htp.p('');
4379: htp.p('');
4380: ELSE
4381: htp.p('');
4384:
4385: END IF;
4386:
4387: END; -- end DF
Line 4447: htp.p('');
4450: END IF;--l_browser_is_IE
4451:
Line 4458: htp.p('');
4464: }
4465: }
4466: window.close();');
4467:
4468: htp.p('');
4469:
4470: ELSE
4471: htp.p('');
4469:
4470: ELSE
4471: htp.p('');
4477: }
4478: }
4479: window.close();');
4480:
4481: htp.p('');
4482:
4483: END IF;
4484: END;
4485:
Line 4541: htp.p(' ');
4537: b_hosted:=TRUE;
4538: END IF;
4539: icx_util.getPrompts(601,'ICX_LOGIN',c_title,c_prompts);
4540: icx_util.copyright;
4541: htp.p(' ');
4542: htp.title(c_title);
4543: htp.p('');
Line 4551: htp.p('document.Logon0.submit();
4547: document.Logon0.i_2.value = document.Logon2.i_2.value;');
4548: IF b_hosted THEN
4549: htp.p('document.Logon0.c_sec_grp_id.value = document.Logon3.site.value;');
4550: END IF;
4551: htp.p('document.Logon0.submit();
4552: }'); --mputman hosted update
4553: htp.p('');
4554: htp.p('');
4549: htp.p('document.Logon0.c_sec_grp_id.value = document.Logon3.site.value;');
4550: END IF;
4551: htp.p('document.Logon0.submit();
4552: }'); --mputman hosted update
4553: htp.p('');
4554: htp.p('');
4554: htp.p('');
Line 4555: htp.p('');
4558: htp.p('');
4559: if c_display = 'IC' and c_logo = 'Y'
Line 4557: htp.p('// -->');
4553: htp.p('');
4554: htp.p('');
4559: if c_display = 'IC' and c_logo = 'Y'
4560: then
4561: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
Line 4558: htp.p('');
4554: htp.p('');
4559: if c_display = 'IC' and c_logo = 'Y'
4560: then
4561: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4562: cattributes => 'BORDER=0');
Line 4561: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4557: htp.p('// -->');
4558: htp.p('');
4559: if c_display = 'IC' and c_logo = 'Y'
4560: then
4561: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4562: cattributes => 'BORDER=0');
4563: htp.tableRowClose;
4564: htp.tableClose;
4565: htp.line;
Line 4563: htp.tableRowClose;
4559: if c_display = 'IC' and c_logo = 'Y'
4560: then
4561: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4562: cattributes => 'BORDER=0');
4563: htp.tableRowClose;
4564: htp.tableClose;
4565: htp.line;
4566: end if;
4567: htp.p(nvl(c_message,'
'||c_title||' '));
Line 4564: htp.tableClose;
4560: then
4561: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4562: cattributes => 'BORDER=0');
4563: htp.tableRowClose;
4564: htp.tableClose;
4565: htp.line;
4566: end if;
4567: htp.p(nvl(c_message,'
'||c_title||' '));
4568: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
Line 4565: htp.line;
4561: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4562: cattributes => 'BORDER=0');
4563: htp.tableRowClose;
4564: htp.tableClose;
4565: htp.line;
4566: end if;
4567: htp.p(nvl(c_message,'
'||c_title||' '));
4568: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4569: l_agent := icx_plug_utilities.getPLSQLagent;
Line 4567: htp.p(nvl(c_message,''||c_title||' '));
4563: htp.tableRowClose;
4564: htp.tableClose;
4565: htp.line;
4566: end if;
4567: htp.p(nvl(c_message,''||c_title||' '));
4568: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4569: l_agent := icx_plug_utilities.getPLSQLagent;
4570: htp.p('
');
4571: htp.formHidden('i_1','');
4572: htp.formHidden('i_2','');
4573: htp.formHidden('c_sec_grp_id',''); --mputman hosted update
4574: htp.formHidden('rmode','2');
4575: htp.formClose;
Line 4572: htp.formHidden('i_2','');
4568: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4569: l_agent := icx_plug_utilities.getPLSQLagent;
4570: htp.p('
');
4571: htp.formHidden('i_1','');
4572: htp.formHidden('i_2','');
4573: htp.formHidden('c_sec_grp_id',''); --mputman hosted update
4574: htp.formHidden('rmode','2');
4575: htp.formClose;
4576: htp.tableOpen;
Line 4573: htp.formHidden('c_sec_grp_id',''); --mputman hosted update
4569: l_agent := icx_plug_utilities.getPLSQLagent;
4570: htp.p('
');
4571: htp.formHidden('i_1','');
4572: htp.formHidden('i_2','');
4573: htp.formHidden('c_sec_grp_id',''); --mputman hosted update
4574: htp.formHidden('rmode','2');
4575: htp.formClose;
4576: htp.tableOpen;
4577:
Line 4574: htp.formHidden('rmode','2');
4570: htp.p('
');
4571: htp.formHidden('i_1','');
4572: htp.formHidden('i_2','');
4573: htp.formHidden('c_sec_grp_id',''); --mputman hosted update
4574: htp.formHidden('rmode','2');
4575: htp.formClose;
4576: htp.tableOpen;
4577:
4578: IF b_hosted THEN
Line 4575: htp.formClose;
4571: htp.formHidden('i_1','');
4572: htp.formHidden('i_2','');
4573: htp.formHidden('c_sec_grp_id',''); --mputman hosted update
4574: htp.formHidden('rmode','2');
4575: htp.formClose;
4576: htp.tableOpen;
4577:
4578: IF b_hosted THEN
4579: htp.tableRowOpen; -- SITE --mputman hosted update
Line 4576: htp.tableOpen;
4572: htp.formHidden('i_2','');
4573: htp.formHidden('c_sec_grp_id',''); --mputman hosted update
4574: htp.formHidden('rmode','2');
4575: htp.formClose;
4576: htp.tableOpen;
4577:
4578: IF b_hosted THEN
4579: htp.tableRowOpen; -- SITE --mputman hosted update
4580: htp.tableData(c_prompts(5),'RIGHT');
Line 4579: htp.tableRowOpen; -- SITE --mputman hosted update
4575: htp.formClose;
4576: htp.tableOpen;
4577:
4578: IF b_hosted THEN
4579: htp.tableRowOpen; -- SITE --mputman hosted update
4580: htp.tableData(c_prompts(5),'RIGHT');
4581: htp.p('
');
4582: htp.tableData(htf.formText('site',30));
4583: htp.formClose;
Line 4580: htp.tableData(c_prompts(5),'RIGHT');
4576: htp.tableOpen;
4577:
4578: IF b_hosted THEN
4579: htp.tableRowOpen; -- SITE --mputman hosted update
4580: htp.tableData(c_prompts(5),'RIGHT');
4581: htp.p('
');
4582: htp.tableData(htf.formText('site',30));
4583: htp.formClose;
4584: htp.p(' ');
Line 4581: htp.p(' ');
4577:
4578: IF b_hosted THEN
4579: htp.tableRowOpen; -- SITE --mputman hosted update
4580: htp.tableData(c_prompts(5),'RIGHT');
4581: htp.p('');
4582: htp.tableData(htf.formText('site',30));
4583: htp.formClose;
4584: htp.p('
');
4585: htp.tableRowClose;
Line 4582: htp.tableData(htf.formText('site',30));
4578: IF b_hosted THEN
4579: htp.tableRowOpen; -- SITE --mputman hosted update
4580: htp.tableData(c_prompts(5),'RIGHT');
4581: htp.p('
');
4582: htp.tableData(htf.formText('site',30));
4583: htp.formClose;
4584: htp.p(' ');
4585: htp.tableRowClose;
4586: END IF;
Line 4583: htp.formClose;
4579: htp.tableRowOpen; -- SITE --mputman hosted update
4580: htp.tableData(c_prompts(5),'RIGHT');
4581: htp.p('
');
4582: htp.tableData(htf.formText('site',30));
4583: htp.formClose;
4584: htp.p(' ');
4585: htp.tableRowClose;
4586: END IF;
4587:
Line 4584: htp.p(' ');
4580: htp.tableData(c_prompts(5),'RIGHT');
4581: htp.p('
');
4582: htp.tableData(htf.formText('site',30));
4583: htp.formClose;
4584: htp.p(' ');
4585: htp.tableRowClose;
4586: END IF;
4587:
4588: htp.tableRowOpen; -- Username
Line 4585: htp.tableRowClose;
4581: htp.p('
');
4582: htp.tableData(htf.formText('site',30));
4583: htp.formClose;
4584: htp.p(' ');
4585: htp.tableRowClose;
4586: END IF;
4587:
4588: htp.tableRowOpen; -- Username
4589: htp.tableData(c_prompts(1),'RIGHT');
Line 4588: htp.tableRowOpen; -- Username
4584: htp.p('
');
4585: htp.tableRowClose;
4586: END IF;
4587:
4588: htp.tableRowOpen; -- Username
4589: htp.tableData(c_prompts(1),'RIGHT');
4590: htp.p(' ');
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
Line 4589: htp.tableData(c_prompts(1),'RIGHT');
4585: htp.tableRowClose;
4586: END IF;
4587:
4588: htp.tableRowOpen; -- Username
4589: htp.tableData(c_prompts(1),'RIGHT');
4590: htp.p('
');
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
4593: htp.p(' ');
Line 4590: htp.p(' ');
4586: END IF;
4587:
4588: htp.tableRowOpen; -- Username
4589: htp.tableData(c_prompts(1),'RIGHT');
4590: htp.p('');
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
4593: htp.p('
');
4594: htp.tableRowClose;
Line 4591: htp.tableData(htf.formText('i_1',30));
4587:
4588: htp.tableRowOpen; -- Username
4589: htp.tableData(c_prompts(1),'RIGHT');
4590: htp.p('
');
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
4593: htp.p(' ');
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
Line 4592: htp.formClose;
4588: htp.tableRowOpen; -- Username
4589: htp.tableData(c_prompts(1),'RIGHT');
4590: htp.p('
');
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
4593: htp.p(' ');
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
Line 4593: htp.p(' ');
4589: htp.tableData(c_prompts(1),'RIGHT');
4590: htp.p('
');
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
4593: htp.p(' ');
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p(' ');
Line 4594: htp.tableRowClose;
4590: htp.p('
');
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
4593: htp.p(' ');
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p(' ');
4598: htp.tableData(htf.formPassword('i_2',30));
Line 4595: htp.tableRowOpen; -- Password
4591: htp.tableData(htf.formText('i_1',30));
4592: htp.formClose;
4593: htp.p('
');
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p(' ');
4598: htp.tableData(htf.formPassword('i_2',30));
4599: htp.formClose;
Line 4596: htp.tableData(c_prompts(2),'RIGHT');
4592: htp.formClose;
4593: htp.p('
');
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p(' ');
4598: htp.tableData(htf.formPassword('i_2',30));
4599: htp.formClose;
4600: htp.p('');
Line 4597: htp.p(' ');
4593: htp.p('
');
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p('');
4598: htp.tableData(htf.formPassword('i_2',30));
4599: htp.formClose;
4600: htp.p('');
4601: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
Line 4598: htp.tableData(htf.formPassword('i_2',30));
4594: htp.tableRowClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p('
');
4598: htp.tableData(htf.formPassword('i_2',30));
4599: htp.formClose;
4600: htp.p('');
4601: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4602: htp.p(' ');
Line 4599: htp.formClose;
4595: htp.tableRowOpen; -- Password
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p('
');
4598: htp.tableData(htf.formPassword('i_2',30));
4599: htp.formClose;
4600: htp.p('');
4601: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4602: htp.p(' ');
4603: htp.tableRowClose;
Line 4600: htp.p('');
4596: htp.tableData(c_prompts(2),'RIGHT');
4597: htp.p('
');
4598: htp.tableData(htf.formPassword('i_2',30));
4599: htp.formClose;
4600: htp.p(' ');
4601: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4602: htp.p(' ');
4603: htp.tableRowClose;
4604: htp.tableClose;
Line 4602: htp.p(' ');
4598: htp.tableData(htf.formPassword('i_2',30));
4599: htp.formClose;
4600: htp.p('
');
4601: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4602: htp.p(' ');
4603: htp.tableRowClose;
4604: htp.tableClose;
4605: htp.formClose;
4606: htp.p('');
Line 4607: htp.p('');
4610: htp.p('');
4611: exception
Line 4608: htp.p('document.Logon1.i_1.focus();');
4604: htp.tableClose;
4605: htp.formClose;
4606: htp.p('');
4611: exception
4612: when others then
Line 4609: htp.p('// -->');
4605: htp.formClose;
4606: htp.p('');
4611: exception
4612: when others then
4613: -- htp.p(SQLERRM);
Line 4610: htp.p('');
4606: htp.p('');
4611: exception
4612: when others then
4613: -- htp.p(SQLERRM);
4614: htp.p(dbms_utility.format_error_stack);
Line 4613: -- htp.p(SQLERRM);
4609: htp.p('// -->');
4610: htp.p('');
4611: exception
4612: when others then
4613: -- htp.p(SQLERRM);
4614: htp.p(dbms_utility.format_error_stack);
4615: end;
4616:
4617: -- ***********************************************
Line 4614: htp.p(dbms_utility.format_error_stack);
4610: htp.p('');
4611: exception
4612: when others then
4613: -- htp.p(SQLERRM);
4614: htp.p(dbms_utility.format_error_stack);
4615: end;
4616:
4617: -- ***********************************************
4618: -- Procedure convertSession
Line 4702: -- htp.p('MPUTMAN - ConvertSession Begin');
4698: l_use_portal:=TRUE;
4699: ELSE
4700: l_use_portal:=FALSE;
4701: END IF;
4702: -- htp.p('MPUTMAN - ConvertSession Begin');
4703:
4704: IF l_use_portal THEN -- just a double check
4705:
4706: IF l_portal_sso THEN
Line 4759: --htp.p('MPUTMAN - pre validate pwd');htp.nl;
4755: -- resp_id => -1,
4756: -- resp_appl_id => -1,
4757: -- security_group_id => i_S);--mputman hosted update
4758: END IF;
4759: --htp.p('MPUTMAN - pre validate pwd');htp.nl;
4760: l_validated := fnd_web_sec.validate_login(upper(i_1), i_2);
4761: IF l_validated ='N' THEN --login failed
4762: --htp.p('MPUTMAN - pwd NOT validated');htp.nl;
4763: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
Line 4762: --htp.p('MPUTMAN - pwd NOT validated');htp.nl;
4758: END IF;
4759: --htp.p('MPUTMAN - pre validate pwd');htp.nl;
4760: l_validated := fnd_web_sec.validate_login(upper(i_1), i_2);
4761: IF l_validated ='N' THEN --login failed
4762: --htp.p('MPUTMAN - pwd NOT validated');htp.nl;
4763: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4764: l_message := fnd_message.get;
4765: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4766: l_message := l_message||' '||fnd_message.get;
Line 4771: --htp.p('MPUTMAN - PWD VALID');htp.nl;
4767:
4768: OracleApps.convertSession(c_token => c_token,
4769: c_message =>l_message);
4770: ELSE --valid login
4771: --htp.p('MPUTMAN - PWD VALID');htp.nl;
4772: --update session for new user.
4773: BEGIN
4774: SELECT user_id
4775: INTO l_user_id
Line 4826: --htp.p('MPUTMAN - pre VSP');htp.nl;
4822: EXCEPTION
4823: WHEN OTHERS THEN
4824: NULL;
4825: END;
4826: --htp.p('MPUTMAN - pre VSP');htp.nl;
4827: icx_sec.g_prog_appl_id := -999;--need to set back everywhere!!
4828:
4829: IF (icx_sec.VALIDATESessionPrivate(c_session_id => l_session_id,
4830: c_function_id => l_function_id,
Line 4859: -- htp.p('SUCCESS!!!!');
4855: p_security_group_id => nvl(l_security_group_id,'0'),
4856: c_function_id => l_function_id,
4857: n_session_id => l_session_id);
4858: END IF;
4859: -- htp.p('SUCCESS!!!!');
4860: ELSE
4861: icx_sec.g_prog_appl_id := -1;
4862: OracleApps.convertSession(c_token => c_token);
4863: END IF;
Line 4873: htp.p(' ');
4869:
4870: -------------
4871: icx_util.getPrompts(601,'ICX_LOGIN',c_title,c_prompts);
4872: icx_util.copyright;
4873: htp.p(' ');
4874: htp.title(c_title);
4875: htp.p('');
Line 4883: htp.p('document.Logon0.submit();
4879: document.Logon0.i_2.value = document.Logon2.i_2.value;');
4880: IF b_hosted THEN
4881: htp.p('document.Logon0.i_S.value = document.Logon3.site.value;');
4882: END IF;
4883: htp.p('document.Logon0.submit();
4884: }'); --mputman hosted update
4885: htp.p('');
4886: htp.p('');
4881: htp.p('document.Logon0.i_S.value = document.Logon3.site.value;');
4882: END IF;
4883: htp.p('document.Logon0.submit();
4884: }'); --mputman hosted update
4885: htp.p('');
4886: htp.p('');
4886: htp.p('');
Line 4887: htp.p('');
4890: htp.p('');
4891: -- if c_display = 'IC' and c_logo = 'Y'
Line 4889: htp.p('// -->');
4885: htp.p('');
4886: htp.p('');
4891: -- if c_display = 'IC' and c_logo = 'Y'
4892: -- then
4893: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
Line 4890: htp.p('');
4886: htp.p('');
4891: -- if c_display = 'IC' and c_logo = 'Y'
4892: -- then
4893: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4894: cattributes => 'BORDER=0');
Line 4893: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4889: htp.p('// -->');
4890: htp.p('');
4891: -- if c_display = 'IC' and c_logo = 'Y'
4892: -- then
4893: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4894: cattributes => 'BORDER=0');
4895: htp.tableRowClose;
4896: htp.tableClose;
4897: htp.line;
Line 4895: htp.tableRowClose;
4891: -- if c_display = 'IC' and c_logo = 'Y'
4892: -- then
4893: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4894: cattributes => 'BORDER=0');
4895: htp.tableRowClose;
4896: htp.tableClose;
4897: htp.line;
4898: -- end if;
4899: htp.p(nvl(c_message,'
'||c_title||' '));
Line 4896: htp.tableClose;
4892: -- then
4893: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4894: cattributes => 'BORDER=0');
4895: htp.tableRowClose;
4896: htp.tableClose;
4897: htp.line;
4898: -- end if;
4899: htp.p(nvl(c_message,'
'||c_title||' '));
4900: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
Line 4897: htp.line;
4893: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
4894: cattributes => 'BORDER=0');
4895: htp.tableRowClose;
4896: htp.tableClose;
4897: htp.line;
4898: -- end if;
4899: htp.p(nvl(c_message,'
'||c_title||' '));
4900: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4901: l_agent := icx_plug_utilities.getPLSQLagent;
Line 4899: htp.p(nvl(c_message,''||c_title||' '));
4895: htp.tableRowClose;
4896: htp.tableClose;
4897: htp.line;
4898: -- end if;
4899: htp.p(nvl(c_message,''||c_title||' '));
4900: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4901: l_agent := icx_plug_utilities.getPLSQLagent;
4902: htp.p('
');
4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
Line 4902: htp.p(' ');
4898: -- end if;
4899: htp.p(nvl(c_message,'
'||c_title||' '));
4900: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4901: l_agent := icx_plug_utilities.getPLSQLagent;
4902: htp.p('');
4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
4904: htp.formHidden('c_token',c_token);
4905: htp.formHidden('i_1','');
4906: htp.formHidden('i_2','');
Line 4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
4899: htp.p(nvl(c_message,'
'||c_title||' '));
4900: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4901: l_agent := icx_plug_utilities.getPLSQLagent;
4902: htp.p(' ');
4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
4904: htp.formHidden('c_token',c_token);
4905: htp.formHidden('i_1','');
4906: htp.formHidden('i_2','');
4907: htp.formHidden('i_S','');
Line 4904: htp.formHidden('c_token',c_token);
4900: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
4901: l_agent := icx_plug_utilities.getPLSQLagent;
4902: htp.p('
');
4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
4904: htp.formHidden('c_token',c_token);
4905: htp.formHidden('i_1','');
4906: htp.formHidden('i_2','');
4907: htp.formHidden('i_S','');
4908: htp.formClose;
Line 4905: htp.formHidden('i_1','');
4901: l_agent := icx_plug_utilities.getPLSQLagent;
4902: htp.p('
');
4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
4904: htp.formHidden('c_token',c_token);
4905: htp.formHidden('i_1','');
4906: htp.formHidden('i_2','');
4907: htp.formHidden('i_S','');
4908: htp.formClose;
4909:
Line 4906: htp.formHidden('i_2','');
4902: htp.p('
');
4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
4904: htp.formHidden('c_token',c_token);
4905: htp.formHidden('i_1','');
4906: htp.formHidden('i_2','');
4907: htp.formHidden('i_S','');
4908: htp.formClose;
4909:
4910: IF b_hosted THEN
Line 4907: htp.formHidden('i_S','');
4903: --htp.formHidden('c_token',wfa_html.conv_special_url_chars(c_token));
4904: htp.formHidden('c_token',c_token);
4905: htp.formHidden('i_1','');
4906: htp.formHidden('i_2','');
4907: htp.formHidden('i_S','');
4908: htp.formClose;
4909:
4910: IF b_hosted THEN
4911: htp.tableRowOpen; -- SITE --mputman hosted update
Line 4908: htp.formClose;
4904: htp.formHidden('c_token',c_token);
4905: htp.formHidden('i_1','');
4906: htp.formHidden('i_2','');
4907: htp.formHidden('i_S','');
4908: htp.formClose;
4909:
4910: IF b_hosted THEN
4911: htp.tableRowOpen; -- SITE --mputman hosted update
4912: htp.tableData(c_prompts(5),'RIGHT');
Line 4911: htp.tableRowOpen; -- SITE --mputman hosted update
4907: htp.formHidden('i_S','');
4908: htp.formClose;
4909:
4910: IF b_hosted THEN
4911: htp.tableRowOpen; -- SITE --mputman hosted update
4912: htp.tableData(c_prompts(5),'RIGHT');
4913: htp.p('
');
4914: htp.tableData(htf.formText('site',30));
4915: htp.formClose;
Line 4912: htp.tableData(c_prompts(5),'RIGHT');
4908: htp.formClose;
4909:
4910: IF b_hosted THEN
4911: htp.tableRowOpen; -- SITE --mputman hosted update
4912: htp.tableData(c_prompts(5),'RIGHT');
4913: htp.p('
');
4914: htp.tableData(htf.formText('site',30));
4915: htp.formClose;
4916: htp.p(' ');
Line 4913: htp.p(' ');
4909:
4910: IF b_hosted THEN
4911: htp.tableRowOpen; -- SITE --mputman hosted update
4912: htp.tableData(c_prompts(5),'RIGHT');
4913: htp.p('');
4914: htp.tableData(htf.formText('site',30));
4915: htp.formClose;
4916: htp.p('
');
4917: htp.tableRowClose;
Line 4914: htp.tableData(htf.formText('site',30));
4910: IF b_hosted THEN
4911: htp.tableRowOpen; -- SITE --mputman hosted update
4912: htp.tableData(c_prompts(5),'RIGHT');
4913: htp.p('
');
4914: htp.tableData(htf.formText('site',30));
4915: htp.formClose;
4916: htp.p(' ');
4917: htp.tableRowClose;
4918: END IF;
Line 4915: htp.formClose;
4911: htp.tableRowOpen; -- SITE --mputman hosted update
4912: htp.tableData(c_prompts(5),'RIGHT');
4913: htp.p('
');
4914: htp.tableData(htf.formText('site',30));
4915: htp.formClose;
4916: htp.p(' ');
4917: htp.tableRowClose;
4918: END IF;
4919:
Line 4916: htp.p(' ');
4912: htp.tableData(c_prompts(5),'RIGHT');
4913: htp.p('
');
4914: htp.tableData(htf.formText('site',30));
4915: htp.formClose;
4916: htp.p(' ');
4917: htp.tableRowClose;
4918: END IF;
4919:
4920: htp.tableOpen;
Line 4917: htp.tableRowClose;
4913: htp.p('
');
4914: htp.tableData(htf.formText('site',30));
4915: htp.formClose;
4916: htp.p(' ');
4917: htp.tableRowClose;
4918: END IF;
4919:
4920: htp.tableOpen;
4921: htp.tableRowOpen; -- Username
Line 4920: htp.tableOpen;
4916: htp.p('
');
4917: htp.tableRowClose;
4918: END IF;
4919:
4920: htp.tableOpen;
4921: htp.tableRowOpen; -- Username
4922: htp.tableData(c_prompts(1),'RIGHT');
4923: htp.p(' ');
4924: htp.tableData(htf.formText('i_1',30));
Line 4921: htp.tableRowOpen; -- Username
4917: htp.tableRowClose;
4918: END IF;
4919:
4920: htp.tableOpen;
4921: htp.tableRowOpen; -- Username
4922: htp.tableData(c_prompts(1),'RIGHT');
4923: htp.p('
');
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
Line 4922: htp.tableData(c_prompts(1),'RIGHT');
4918: END IF;
4919:
4920: htp.tableOpen;
4921: htp.tableRowOpen; -- Username
4922: htp.tableData(c_prompts(1),'RIGHT');
4923: htp.p('
');
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
4926: htp.p(' ');
Line 4923: htp.p(' ');
4919:
4920: htp.tableOpen;
4921: htp.tableRowOpen; -- Username
4922: htp.tableData(c_prompts(1),'RIGHT');
4923: htp.p('');
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
4926: htp.p('
');
4927: htp.tableRowClose;
Line 4924: htp.tableData(htf.formText('i_1',30));
4920: htp.tableOpen;
4921: htp.tableRowOpen; -- Username
4922: htp.tableData(c_prompts(1),'RIGHT');
4923: htp.p('
');
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
4926: htp.p(' ');
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
Line 4925: htp.formClose;
4921: htp.tableRowOpen; -- Username
4922: htp.tableData(c_prompts(1),'RIGHT');
4923: htp.p('
');
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
4926: htp.p(' ');
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
Line 4926: htp.p(' ');
4922: htp.tableData(c_prompts(1),'RIGHT');
4923: htp.p('
');
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
4926: htp.p(' ');
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p(' ');
Line 4927: htp.tableRowClose;
4923: htp.p('
');
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
4926: htp.p(' ');
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p(' ');
4931: htp.tableData(htf.formPassword('i_2',30));
Line 4928: htp.tableRowOpen; -- Password
4924: htp.tableData(htf.formText('i_1',30));
4925: htp.formClose;
4926: htp.p('
');
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p(' ');
4931: htp.tableData(htf.formPassword('i_2',30));
4932: htp.formClose;
Line 4929: htp.tableData(c_prompts(2),'RIGHT');
4925: htp.formClose;
4926: htp.p('
');
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p(' ');
4931: htp.tableData(htf.formPassword('i_2',30));
4932: htp.formClose;
4933: htp.p('');
Line 4930: htp.p(' ');
4926: htp.p('
');
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p('');
4931: htp.tableData(htf.formPassword('i_2',30));
4932: htp.formClose;
4933: htp.p('');
4934: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
Line 4931: htp.tableData(htf.formPassword('i_2',30));
4927: htp.tableRowClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p('
');
4931: htp.tableData(htf.formPassword('i_2',30));
4932: htp.formClose;
4933: htp.p('');
4934: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4935: htp.p(' ');
Line 4932: htp.formClose;
4928: htp.tableRowOpen; -- Password
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p('
');
4931: htp.tableData(htf.formPassword('i_2',30));
4932: htp.formClose;
4933: htp.p('');
4934: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4935: htp.p(' ');
4936: htp.tableRowClose;
Line 4933: htp.p('');
4929: htp.tableData(c_prompts(2),'RIGHT');
4930: htp.p('
');
4931: htp.tableData(htf.formPassword('i_2',30));
4932: htp.formClose;
4933: htp.p(' ');
4934: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4935: htp.p(' ');
4936: htp.tableRowClose;
4937: htp.tableClose;
Line 4935: htp.p(' ');
4931: htp.tableData(htf.formPassword('i_2',30));
4932: htp.formClose;
4933: htp.p('
');
4934: icx_plug_utilities.buttonBoth(c_prompts(3),'javascript:logon_submit()','FNDJLFOK.gif'); -- Connect
4935: htp.p(' ');
4936: htp.tableRowClose;
4937: htp.tableClose;
4938: htp.formClose;
4939: htp.p('');
Line 4940: htp.p('');
4943: htp.p('');
4944: END IF; --i_1 and i_2 null check
Line 4941: htp.p('document.Logon1.i_1.focus();');
4937: htp.tableClose;
4938: htp.formClose;
4939: htp.p('');
4944: END IF; --i_1 and i_2 null check
4945: ELSE --check_session failed
Line 4942: htp.p('// -->');
4938: htp.formClose;
4939: htp.p('');
4944: END IF; --i_1 and i_2 null check
4945: ELSE --check_session failed
4946: OracleApps.displayLogin;
Line 4943: htp.p('');
4939: htp.p('');
4944: END IF; --i_1 and i_2 null check
4945: ELSE --check_session failed
4946: OracleApps.displayLogin;
4947: END IF; -- check_session
Line 4958: -- htp.p(SQLERRM);
4954:
4955: when others then
4956: rollback;
4957: icx_sec.g_prog_appl_id := -1;
4958: -- htp.p(SQLERRM);
4959: htp.p(dbms_utility.format_error_stack);
4960: end;
4961:
4962:
Line 4959: htp.p(dbms_utility.format_error_stack);
4955: when others then
4956: rollback;
4957: icx_sec.g_prog_appl_id := -1;
4958: -- htp.p(SQLERRM);
4959: htp.p(dbms_utility.format_error_stack);
4960: end;
4961:
4962:
4963: end OracleApps;