34: WHEN OTHERS THEN
35: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
36: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
37: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
38: htp.p(htf.bodyOpen);
39: htp.p(gc_error_display||' : '||fnd_message.get);
40: htp.p(htf.br);
41: htp.p(htf.bodyClose);
42: END GetNumErrMsg;
36: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
37: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
38: htp.p(htf.bodyOpen);
39: htp.p(gc_error_display||' : '||fnd_message.get);
40: htp.p(htf.br);
41: htp.p(htf.bodyClose);
42: END GetNumErrMsg;
43:
44:
37: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
38: htp.p(htf.bodyOpen);
39: htp.p(gc_error_display||' : '||fnd_message.get);
40: htp.p(htf.br);
41: htp.p(htf.bodyClose);
42: END GetNumErrMsg;
43:
44:
45: -- GetMsgTxt: Using msg_name and msg_tokens, form the message
81: WHEN OTHERS THEN
82: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
83: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
84: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
85: htp.p(htf.bodyOpen);
86: htp.p(gc_error_display||' : '||fnd_message.get);
87: htp.p(htf.br);
88: htp.p(htf.bodyClose);
89: END GetMsgTxt;
83: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
84: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
85: htp.p(htf.bodyOpen);
86: htp.p(gc_error_display||' : '||fnd_message.get);
87: htp.p(htf.br);
88: htp.p(htf.bodyClose);
89: END GetMsgTxt;
90:
91: -- Print: Print the message based on the paramters passed
84: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
85: htp.p(htf.bodyOpen);
86: htp.p(gc_error_display||' : '||fnd_message.get);
87: htp.p(htf.br);
88: htp.p(htf.bodyClose);
89: END GetMsgTxt;
90:
91: -- Print: Print the message based on the paramters passed
92: -- p_text: Text to be printed
100: IS
101: BEGIN
102:
103: IF p_text_type = gc_HEADER THEN
104: htp.p(htf.nl);
105: htp.p(htf.nl);
106: htp.fontOpen(ccolor=>'blue', csize=>5);
107: htp.p(htf.italic(p_text)) ;
108: htp.fontClose;
101: BEGIN
102:
103: IF p_text_type = gc_HEADER THEN
104: htp.p(htf.nl);
105: htp.p(htf.nl);
106: htp.fontOpen(ccolor=>'blue', csize=>5);
107: htp.p(htf.italic(p_text)) ;
108: htp.fontClose;
109: htp.p(htf.nl);
103: IF p_text_type = gc_HEADER THEN
104: htp.p(htf.nl);
105: htp.p(htf.nl);
106: htp.fontOpen(ccolor=>'blue', csize=>5);
107: htp.p(htf.italic(p_text)) ;
108: htp.fontClose;
109: htp.p(htf.nl);
110: htp.p(htf.nl);
111: ELSIF p_text_type = gc_CONTEXT OR p_text_type = gc_MESSAGE THEN
105: htp.p(htf.nl);
106: htp.fontOpen(ccolor=>'blue', csize=>5);
107: htp.p(htf.italic(p_text)) ;
108: htp.fontClose;
109: htp.p(htf.nl);
110: htp.p(htf.nl);
111: ELSIF p_text_type = gc_CONTEXT OR p_text_type = gc_MESSAGE THEN
112: htp.fontOpen(ccolor=>'gray', csize=>3);
113: htp.p(htf.para);
106: htp.fontOpen(ccolor=>'blue', csize=>5);
107: htp.p(htf.italic(p_text)) ;
108: htp.fontClose;
109: htp.p(htf.nl);
110: htp.p(htf.nl);
111: ELSIF p_text_type = gc_CONTEXT OR p_text_type = gc_MESSAGE THEN
112: htp.fontOpen(ccolor=>'gray', csize=>3);
113: htp.p(htf.para);
114: htp.p(htf.strong(p_text)) ;
109: htp.p(htf.nl);
110: htp.p(htf.nl);
111: ELSIF p_text_type = gc_CONTEXT OR p_text_type = gc_MESSAGE THEN
112: htp.fontOpen(ccolor=>'gray', csize=>3);
113: htp.p(htf.para);
114: htp.p(htf.strong(p_text)) ;
115: htp.fontClose;
116: htp.p(htf.line);
117: ELSIF p_text_type = gc_SUB_CONTEXT THEN
110: htp.p(htf.nl);
111: ELSIF p_text_type = gc_CONTEXT OR p_text_type = gc_MESSAGE THEN
112: htp.fontOpen(ccolor=>'gray', csize=>3);
113: htp.p(htf.para);
114: htp.p(htf.strong(p_text)) ;
115: htp.fontClose;
116: htp.p(htf.line);
117: ELSIF p_text_type = gc_SUB_CONTEXT THEN
118: htp.fontOpen(ccolor=>'gray', csize=>3);
112: htp.fontOpen(ccolor=>'gray', csize=>3);
113: htp.p(htf.para);
114: htp.p(htf.strong(p_text)) ;
115: htp.fontClose;
116: htp.p(htf.line);
117: ELSIF p_text_type = gc_SUB_CONTEXT THEN
118: htp.fontOpen(ccolor=>'gray', csize=>3);
119: htp.p(htf.strong(p_text)) ;
120: htp.fontClose;
115: htp.fontClose;
116: htp.p(htf.line);
117: ELSIF p_text_type = gc_SUB_CONTEXT THEN
118: htp.fontOpen(ccolor=>'gray', csize=>3);
119: htp.p(htf.strong(p_text)) ;
120: htp.fontClose;
121: ELSIF p_text_type = gc_RECORDS THEN
122: htp.p(htf.strong(p_text)) ;
123: END IF;
118: htp.fontOpen(ccolor=>'gray', csize=>3);
119: htp.p(htf.strong(p_text)) ;
120: htp.fontClose;
121: ELSIF p_text_type = gc_RECORDS THEN
122: htp.p(htf.strong(p_text)) ;
123: END IF;
124:
125:
126: EXCEPTION
128: -- log error;
129: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
130: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
131: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
132: htp.p(htf.bodyOpen);
133: htp.p(gc_error_display||' : '||fnd_message.get);
134: htp.p(htf.br);
135: htp.p(htf.bodyClose);
136: END Print;
130: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
131: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
132: htp.p(htf.bodyOpen);
133: htp.p(gc_error_display||' : '||fnd_message.get);
134: htp.p(htf.br);
135: htp.p(htf.bodyClose);
136: END Print;
137:
138: FUNCTION GetGeoCode(id IN NUMBER)
131: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
132: htp.p(htf.bodyOpen);
133: htp.p(gc_error_display||' : '||fnd_message.get);
134: htp.p(htf.br);
135: htp.p(htf.bodyClose);
136: END Print;
137:
138: FUNCTION GetGeoCode(id IN NUMBER)
139: RETURN VARCHAR2
200: IF p_type = gc_HEADING THEN
201: v_text := p_text;
202: ELSIF p_type = gc_DETAILS THEN
203: IF p_indicator = gc_ERROR THEN
204: v_text := htf.fontOpen(ccolor=>'red')||p_text||htf.fontClose;
205: ELSIF p_indicator = gc_WARNING THEN
206: v_text := htf.fontOpen(ccolor=>'amber')||p_text||htf.fontClose;
207: ELSE
208: v_text := p_text;
202: ELSIF p_type = gc_DETAILS THEN
203: IF p_indicator = gc_ERROR THEN
204: v_text := htf.fontOpen(ccolor=>'red')||p_text||htf.fontClose;
205: ELSIF p_indicator = gc_WARNING THEN
206: v_text := htf.fontOpen(ccolor=>'amber')||p_text||htf.fontClose;
207: ELSE
208: v_text := p_text;
209: END IF;
210: ELSE
2933: PROCEDURE InitializeDisplay(p_display_type VARCHAR2)
2934: IS
2935: BEGIN
2936: IF p_display_type = gc_HTML THEN
2937: htp.p(htf.htmlOpen);
2938: htp.p(htf.title(GetMsgTxt('XNP_CVU_REPORT')));
2939: htp.p(htf.header(nsize=>2,
2940: cheader=>GetMsgTxt('XNP_CVU_REPORT'), calign=>'center'));
2941: htp.p(htf.bodyOpen);
2934: IS
2935: BEGIN
2936: IF p_display_type = gc_HTML THEN
2937: htp.p(htf.htmlOpen);
2938: htp.p(htf.title(GetMsgTxt('XNP_CVU_REPORT')));
2939: htp.p(htf.header(nsize=>2,
2940: cheader=>GetMsgTxt('XNP_CVU_REPORT'), calign=>'center'));
2941: htp.p(htf.bodyOpen);
2942: htp.p(htf.nl);
2935: BEGIN
2936: IF p_display_type = gc_HTML THEN
2937: htp.p(htf.htmlOpen);
2938: htp.p(htf.title(GetMsgTxt('XNP_CVU_REPORT')));
2939: htp.p(htf.header(nsize=>2,
2940: cheader=>GetMsgTxt('XNP_CVU_REPORT'), calign=>'center'));
2941: htp.p(htf.bodyOpen);
2942: htp.p(htf.nl);
2943: htp.p(htf.nl);
2937: htp.p(htf.htmlOpen);
2938: htp.p(htf.title(GetMsgTxt('XNP_CVU_REPORT')));
2939: htp.p(htf.header(nsize=>2,
2940: cheader=>GetMsgTxt('XNP_CVU_REPORT'), calign=>'center'));
2941: htp.p(htf.bodyOpen);
2942: htp.p(htf.nl);
2943: htp.p(htf.nl);
2944: END IF;
2945: EXCEPTION
2938: htp.p(htf.title(GetMsgTxt('XNP_CVU_REPORT')));
2939: htp.p(htf.header(nsize=>2,
2940: cheader=>GetMsgTxt('XNP_CVU_REPORT'), calign=>'center'));
2941: htp.p(htf.bodyOpen);
2942: htp.p(htf.nl);
2943: htp.p(htf.nl);
2944: END IF;
2945: EXCEPTION
2946: WHEN OTHERS THEN
2939: htp.p(htf.header(nsize=>2,
2940: cheader=>GetMsgTxt('XNP_CVU_REPORT'), calign=>'center'));
2941: htp.p(htf.bodyOpen);
2942: htp.p(htf.nl);
2943: htp.p(htf.nl);
2944: END IF;
2945: EXCEPTION
2946: WHEN OTHERS THEN
2947: HandleError('IniTializeDisplay', SQLCODE, SQLERRM);
2953: PROCEDURE CloseDisplay(p_display_type VARCHAR2)
2954: IS
2955: BEGIN
2956: IF p_display_type = gc_HTML THEN
2957: htp.p(htf.nl);
2958: htp.p(htf.nl);
2959: htp.p(htf.header(nsize=>2, cheader=>GetMsgTxt('XNP_END_OF_REPORT'),
2960: calign=>'center'));
2961: htp.p(htf.line);
2954: IS
2955: BEGIN
2956: IF p_display_type = gc_HTML THEN
2957: htp.p(htf.nl);
2958: htp.p(htf.nl);
2959: htp.p(htf.header(nsize=>2, cheader=>GetMsgTxt('XNP_END_OF_REPORT'),
2960: calign=>'center'));
2961: htp.p(htf.line);
2962: htp.p(htf.bodyClose);
2955: BEGIN
2956: IF p_display_type = gc_HTML THEN
2957: htp.p(htf.nl);
2958: htp.p(htf.nl);
2959: htp.p(htf.header(nsize=>2, cheader=>GetMsgTxt('XNP_END_OF_REPORT'),
2960: calign=>'center'));
2961: htp.p(htf.line);
2962: htp.p(htf.bodyClose);
2963: htp.p(htf.htmlClose);
2957: htp.p(htf.nl);
2958: htp.p(htf.nl);
2959: htp.p(htf.header(nsize=>2, cheader=>GetMsgTxt('XNP_END_OF_REPORT'),
2960: calign=>'center'));
2961: htp.p(htf.line);
2962: htp.p(htf.bodyClose);
2963: htp.p(htf.htmlClose);
2964: END IF;
2965: EXCEPTION
2958: htp.p(htf.nl);
2959: htp.p(htf.header(nsize=>2, cheader=>GetMsgTxt('XNP_END_OF_REPORT'),
2960: calign=>'center'));
2961: htp.p(htf.line);
2962: htp.p(htf.bodyClose);
2963: htp.p(htf.htmlClose);
2964: END IF;
2965: EXCEPTION
2966: WHEN OTHERS THEN
2959: htp.p(htf.header(nsize=>2, cheader=>GetMsgTxt('XNP_END_OF_REPORT'),
2960: calign=>'center'));
2961: htp.p(htf.line);
2962: htp.p(htf.bodyClose);
2963: htp.p(htf.htmlClose);
2964: END IF;
2965: EXCEPTION
2966: WHEN OTHERS THEN
2967: HandleError('CloseDisplay', SQLCODE, SQLERRM);