DBA Data[Home] [Help]

APPS.XNP_WSGL dependencies on XNP_WSGLM

Line 114: DefinePageHead(MsgGetText(101,XNP_WSGLM.DSP101_WSGL_INFO));

110: order by product;
111: current_user varchar2(30) := GetUser;
112: begin
113: if p_full then
114: DefinePageHead(MsgGetText(101,XNP_WSGLM.DSP101_WSGL_INFO));
115: OpenPageBody;
116: DefaultPageCaption(MsgGetText(101,XNP_WSGLM.DSP101_WSGL_INFO));
117: end if;
118: LayoutOpen(LAYOUT_TABLE, TRUE);

Line 116: DefaultPageCaption(MsgGetText(101,XNP_WSGLM.DSP101_WSGL_INFO));

112: begin
113: if p_full then
114: DefinePageHead(MsgGetText(101,XNP_WSGLM.DSP101_WSGL_INFO));
115: OpenPageBody;
116: DefaultPageCaption(MsgGetText(101,XNP_WSGLM.DSP101_WSGL_INFO));
117: end if;
118: LayoutOpen(LAYOUT_TABLE, TRUE);
119: LayoutRowStart;
120: LayoutHeader(50, 'LEFT', NULL);

Line 124: LayoutData(MsgGetText(102,XNP_WSGLM.DSP102_WSGL));

120: LayoutHeader(50, 'LEFT', NULL);
121: LayoutHeader(50, 'LEFT', NULL);
122: LayoutRowEnd;
123: LayoutRowStart;
124: LayoutData(MsgGetText(102,XNP_WSGLM.DSP102_WSGL));
125: LayoutData(WSGL_VERSION);
126: LayoutRowEnd;
127: LayoutRowStart;
128: LayoutData(MsgGetText(103,XNP_WSGLM.DSP103_USER));

Line 128: LayoutData(MsgGetText(103,XNP_WSGLM.DSP103_USER));

124: LayoutData(MsgGetText(102,XNP_WSGLM.DSP102_WSGL));
125: LayoutData(WSGL_VERSION);
126: LayoutRowEnd;
127: LayoutRowStart;
128: LayoutData(MsgGetText(103,XNP_WSGLM.DSP103_USER));
129: LayoutData(current_user);
130: LayoutRowEnd;
131: for c1rec in c1 loop
132: LayoutRowStart;

Line 139: LayoutData(MsgGetText(105,XNP_WSGLM.DSP105_WEB_SERVER));

135: LayoutRowEnd;
136: end loop;
137: if not p_full then
138: LayoutRowStart;
139: LayoutData(MsgGetText(105,XNP_WSGLM.DSP105_WEB_SERVER));
140: LayoutData(owa_util.get_cgi_env('SERVER_SOFTWARE'));
141: LayoutRowEnd;
142: LayoutRowStart;
143: LayoutData(MsgGetText(106,XNP_WSGLM.DSP106_WEB_BROWSER));

Line 143: LayoutData(MsgGetText(106,XNP_WSGLM.DSP106_WEB_BROWSER));

139: LayoutData(MsgGetText(105,XNP_WSGLM.DSP105_WEB_SERVER));
140: LayoutData(owa_util.get_cgi_env('SERVER_SOFTWARE'));
141: LayoutRowEnd;
142: LayoutRowStart;
143: LayoutData(MsgGetText(106,XNP_WSGLM.DSP106_WEB_BROWSER));
144: LayoutData(owa_util.get_cgi_env('HTTP_USER_AGENT'));
145: LayoutRowEnd;
146: LayoutRowStart;
147: LayoutData(MsgGetText(125,XNP_WSGLM.DSP125_REPOS_APPSYS));

Line 147: LayoutData(MsgGetText(125,XNP_WSGLM.DSP125_REPOS_APPSYS));

143: LayoutData(MsgGetText(106,XNP_WSGLM.DSP106_WEB_BROWSER));
144: LayoutData(owa_util.get_cgi_env('HTTP_USER_AGENT'));
145: LayoutRowEnd;
146: LayoutRowStart;
147: LayoutData(MsgGetText(125,XNP_WSGLM.DSP125_REPOS_APPSYS));
148: LayoutData(p_app);
149: LayoutRowEnd;
150: LayoutRowStart;
151: LayoutData(MsgGetText(126,XNP_WSGLM.DSP126_REPOS_MODULE));

Line 151: LayoutData(MsgGetText(126,XNP_WSGLM.DSP126_REPOS_MODULE));

147: LayoutData(MsgGetText(125,XNP_WSGLM.DSP125_REPOS_APPSYS));
148: LayoutData(p_app);
149: LayoutRowEnd;
150: LayoutRowStart;
151: LayoutData(MsgGetText(126,XNP_WSGLM.DSP126_REPOS_MODULE));
152: LayoutData(p_mod);
153: LayoutRowEnd;
154: end if;
155: LayoutClose;

Line 157: htp.header(LayNumberOfPages, MsgGetText(104,XNP_WSGLM.DSP104_ENVIRONMENT));

153: LayoutRowEnd;
154: end if;
155: LayoutClose;
156: if p_full then
157: htp.header(LayNumberOfPages, MsgGetText(104,XNP_WSGLM.DSP104_ENVIRONMENT));
158: owa_util.print_cgi_env;
159: ClosePageBody;
160: end if;
161: exception

Line 844: elsif (l_field1 = MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN)) then

840: -- Support user defined expression
841: elsif (substr(ltrim(l_field1), 1, 1) = '#') then
842: l_predicate := p_sli || ' ' || substr(ltrim(l_field1),2);
843: -- Special case where 'Unknown' string is entered for an optional col in a domain
844: elsif (l_field1 = MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN)) then
845: l_predicate := p_sli || ' is null';
846: -- Add like ''
847: elsif (instr(l_field1, '%') <> 0) or (instr(l_field1, '_') <> 0) then
848: if p_datatype = TYPE_DATE then

Line 1621: raise_application_error(-20000, 'XNP_WSGL.ValidDomainValue
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));

1617: P_VALUE in OUT NOCOPY varchar2) return boolean is
1618: I_LOOP integer;
1619: begin
1620: if not P_DVREC.Initialised then
1621: raise_application_error(-20000, 'XNP_WSGL.ValidDomainValue
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));
1622: end if;
1623: -- if P_VALUE is null and P_DVREC.ColOptional then
1624: if P_VALUE is null then
1625: return true;

Line 1679: raise_application_error(-20000, 'XNP_WSGL.DomainMeaning
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));

1675: P_VALUE in varchar2) return varchar2 is
1676: I_LOOP integer;
1677: begin
1678: if not P_DVREC.Initialised then
1679: raise_application_error(-20000, 'XNP_WSGL.DomainMeaning
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));
1680: end if;
1681: if P_DVREC.UseMeanings then
1682: for I_LOOP in 1..P_DVREC.NumOfVV loop
1683: if P_VALUE = P_DVREC.Vals(I_LOOP) then

Line 1712: raise_application_error(-20000, 'XNP_WSGL.DomainValue
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));

1708: P_MEANING in varchar2) return varchar2 is
1709: I_LOOP integer;
1710: begin
1711: if not P_DVREC.Initialised then
1712: raise_application_error(-20000, 'XNP_WSGL.DomainValue
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));
1713: end if;
1714: if P_DVREC.UseMeanings then
1715: for I_LOOP in 1..P_DVREC.NumOfVV loop
1716: if P_MEANING = P_DVREC.Meanings(I_LOOP) then

Line 1804: raise_application_error(-20000, 'XNP_WSGL.BuildDVControl
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));

1800: l_events := l_events || ' onSelect="'||P_DVREC.ColAlias||'_OnSelect(this)"';
1801: end if;
1802: end if;
1803: if not P_DVREC.Initialised then
1804: raise_application_error(-20000, 'XNP_WSGL.BuildDVControl
'||MsgGetText(201,XNP_WSGLM.MSG201_DV_INIT_ERR));
1805: end if;
1806: if P_DVREC.UseMeanings then
1807: L_DISPLAY_VAL := DomainMeaning(P_DVREC, P_CURR_VAL);
1808: else

Line 1857: L_RET_VALUE := L_RET_VALUE || htf.formSelectOption(MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN));

1853: 'VALUE="'||P_DVREC.Vals(I_LOOP)||'"');
1854: end if;
1855: end loop;
1856: if P_CTL_STYLE = CTL_QUERY and P_DVREC.ColOptional then
1857: L_RET_VALUE := L_RET_VALUE || htf.formSelectOption(MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN));
1858: end if;
1859: L_RET_VALUE := L_RET_VALUE || htf.formSelectClose;
1860: elsif (P_DVREC.ControlType = DV_CHECK) and (P_CTL_STYLE <> CTL_QUERY) then
1861: if P_CURR_VAL = P_DVREC.Vals(1) then

Line 1920: MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN),

1916: cattributes=>l_events);
1917: else
1918: L_RET_VALUE := L_RET_VALUE ||
1919: htf.formRadio('P_'||P_DVREC.ColAlias,
1920: MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN),
1921: cattributes=>l_events);
1922: end if;
1923: L_RET_VALUE := L_RET_VALUE || ' ' || MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN);
1924:

Line 1923: L_RET_VALUE := L_RET_VALUE || ' ' || MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN);

1919: htf.formRadio('P_'||P_DVREC.ColAlias,
1920: MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN),
1921: cattributes=>l_events);
1922: end if;
1923: L_RET_VALUE := L_RET_VALUE || ' ' || MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN);
1924:
1925: end if;
1926: else
1927: raise_application_error(-20000, 'XNP_WSGL.BuildDVControl
'||MsgGetText(202,XNP_WSGLM.MSG202_DV_CTL_ERR));

Line 1927: raise_application_error(-20000, 'XNP_WSGL.BuildDVControl
'||MsgGetText(202,XNP_WSGLM.MSG202_DV_CTL_ERR));

1923: L_RET_VALUE := L_RET_VALUE || ' ' || MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN);
1924:
1925: end if;
1926: else
1927: raise_application_error(-20000, 'XNP_WSGL.BuildDVControl
'||MsgGetText(202,XNP_WSGLM.MSG202_DV_CTL_ERR));
1928: return '';
1929: end if;
1930: return L_RET_VALUE;
1931: exception

Line 2042: htf.bold(MsgGetText(119,XNP_WSGLM.DSP119_RANGE_TO)) || ' ' ||

2038: if not p_range then
2039: return htf.formText(cname=>l_name1, csize=>p_size, cattributes=>l_events);
2040: else
2041: return htf.formText(cname=>l_name1, csize=>p_size, cattributes=>l_events) || ' ' ||
2042: htf.bold(MsgGetText(119,XNP_WSGLM.DSP119_RANGE_TO)) || ' ' ||
2043: htf.formText(cname=>l_name2, csize=>p_size, cattributes=>l_events);
2044: end if;
2045: exception
2046: when others then

Line 2160: htp.bold(''||htf.italic(MsgGetText(121,XNP_WSGLM.DSP121_SUCCESS))||

2156: end if;
2157: if p_type = MESS_INFORMATION then
2158: htp.bold(l_mess);
2159: elsif p_type = MESS_SUCCESS then
2160: htp.bold(''||htf.italic(MsgGetText(121,XNP_WSGLM.DSP121_SUCCESS))||
2161: '
'||l_mess);
2162: elsif p_type = MESS_WARNING then
2163: -- NB, MESS_WARNING not used at present, just issue error message
2164: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||

Line 2164: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||

2160: htp.bold(''||htf.italic(MsgGetText(121,XNP_WSGLM.DSP121_SUCCESS))||
2161: '

'||l_mess);
2162: elsif p_type = MESS_WARNING then
2163: -- NB, MESS_WARNING not used at present, just issue error message
2164: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2165: '
'||l_mess);
2166: elsif p_type = MESS_ERROR then
2167:
2168: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||

Line 2168: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||

2164: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2165: '

'||l_mess);
2166: elsif p_type = MESS_ERROR then
2167:
2168: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2169: '
'||l_mess);
2170: elsif p_type = MESS_ERROR_QRY then
2171: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2172: '

');

Line 2171: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||

2167:
2168: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2169: '

'||l_mess);
2170: elsif p_type = MESS_ERROR_QRY then
2171: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2172: '
');
2173: htp.bold(p_context);
2174: htp.para;
2175: htp.small(l_mess);

Line 2181: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||

2177: htp.para;
2178: htp.bold(p_action);
2179: end if;
2180: elsif p_type = MESS_EXCEPTION then
2181: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2182: '
');
2183: htp.bold(MsgGetText(217,XNP_WSGLM.MSG217_EXCEPTION, p_location));
2184: htp.para;
2185: htp.p(l_mess);

Line 2183: htp.bold(MsgGetText(217,XNP_WSGLM.MSG217_EXCEPTION, p_location));

2179: end if;
2180: elsif p_type = MESS_EXCEPTION then
2181: htp.bold(''||htf.italic(MsgGetText(122,XNP_WSGLM.DSP122_ERROR))||
2182: '

');
2183: htp.bold(MsgGetText(217,XNP_WSGLM.MSG217_EXCEPTION, p_location));
2184: htp.para;
2185: htp.p(l_mess);
2186: htp.para;
2187: htp.bold(MsgGetText(218,XNP_WSGLM.MSG218_CONTACT_SUPPORT));

Line 2187: htp.bold(MsgGetText(218,XNP_WSGLM.MSG218_CONTACT_SUPPORT));

2183: htp.bold(MsgGetText(217,XNP_WSGLM.MSG217_EXCEPTION, p_location));
2184: htp.para;
2185: htp.p(l_mess);
2186: htp.para;
2187: htp.bold(MsgGetText(218,XNP_WSGLM.MSG218_CONTACT_SUPPORT));
2188: end if;
2189: htp.para;
2190: ClosePageBody;
2191: end;

Line 2378: DisplayMessage(MESS_ERROR, MsgGetText(231,XNP_WSGLM.MSG231_ACCESS_DENIED));

2374: pos_modname := instr(lower(http_referrer), lower(substr(path_info, 1, pos_dollar)));
2375: if (pos_host <> 0 and pos_script > pos_host and pos_modname > pos_script) then
2376: return false;
2377: else
2378: DisplayMessage(MESS_ERROR, MsgGetText(231,XNP_WSGLM.MSG231_ACCESS_DENIED));
2379: return true;
2380: end if;
2381: exception
2382: when others then

Line 2399: DisplayMessage(MESS_ERROR, MsgGetText(231,XNP_WSGLM.MSG231_ACCESS_DENIED));

2395: function CalledDirect(p_proc in varchar2) return boolean is
2396: begin
2397: URLComplete := true;
2398: if (lower(p_proc) = lower(substr(owa_util.get_cgi_env('PATH_INFO'),2))) then
2399: DisplayMessage(MESS_ERROR, MsgGetText(231,XNP_WSGLM.MSG231_ACCESS_DENIED));
2400: return true;
2401: else
2402: return false;
2403: end if;

Line 2530: NavLinks(p_style, MsgGetText(20,XNP_WSGLM.CAP020_RETURN_LINKS), 0);

2526: URLCookie := owa_cookie.get('WSG$'||modname||'URL'||next_level);
2527: CaptionCookie := owa_cookie.get('WSG$'||modname||'CAP'||next_level);
2528: if (nvl(URLCookie.num_vals,0) > 0) and (nvl(CaptionCookie.num_vals,0) > 0) then
2529: if not any_done then
2530: NavLinks(p_style, MsgGetText(20,XNP_WSGLM.CAP020_RETURN_LINKS), 0);
2531: any_done := true;
2532:
2533: end if;
2534: NavLinks(p_style, replace(CaptionCookie.vals(1),'_',' '), 1, URLCookie.vals(1));

Line 2578: DisplayMessage(MESS_ERROR, MsgGetText(231,XNP_WSGLM.MSG231_ACCESS_DENIED));

2574: function ValidateChecksum(p_buff in varchar2, p_checksum in varchar2)
2575: return boolean is
2576: begin
2577: if (nvl(to_number(p_checksum),-1) <> Checksum(p_buff)) then
2578: DisplayMessage(MESS_ERROR, MsgGetText(231,XNP_WSGLM.MSG231_ACCESS_DENIED));
2579: return false;
2580: else
2581: return true;
2582: end if;

Line 2691: return MsgGetText(203,XNP_WSGLM.MSG203_MAX_ROWS,to_char(MAX_ROWS));

2687:
2688: --------------------------------------------------------------------------------
2689: function MAX_ROWS_MESSAGE return varchar2 is
2690: begin
2691: return MsgGetText(203,XNP_WSGLM.MSG203_MAX_ROWS,to_char(MAX_ROWS));
2692: end;
2693: end;