DBA Data[Home] [Help]

APPS.XNP_CVU_PKG dependencies on HTP

Line 38: htp.p(htf.bodyOpen);

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;

Line 39: htp.p(gc_error_display||' : '||fnd_message.get);

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;
43:

Line 40: htp.p(htf.br);

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:

Line 41: htp.p(htf.bodyClose);

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

Line 85: htp.p(htf.bodyOpen);

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;

Line 86: htp.p(gc_error_display||' : '||fnd_message.get);

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;
90:

Line 87: htp.p(htf.br);

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

Line 88: htp.p(htf.bodyClose);

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

Line 104: htp.p(htf.nl);

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;

Line 105: htp.p(htf.nl);

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

Line 106: htp.fontOpen(ccolor=>'blue', csize=>5);

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);
110: htp.p(htf.nl);

Line 107: htp.p(htf.italic(p_text)) ;

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

Line 108: htp.fontClose;

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
112: htp.fontOpen(ccolor=>'gray', csize=>3);

Line 109: 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
112: htp.fontOpen(ccolor=>'gray', csize=>3);
113: htp.p(htf.para);

Line 110: 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);
114: htp.p(htf.strong(p_text)) ;

Line 112: htp.fontOpen(ccolor=>'gray', csize=>3);

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)) ;
115: htp.fontClose;
116: htp.p(htf.line);

Line 113: htp.p(htf.para);

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

Line 114: htp.p(htf.strong(p_text)) ;

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

Line 115: htp.fontClose;

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);
119: htp.p(htf.strong(p_text)) ;

Line 116: htp.p(htf.line);

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;

Line 118: htp.fontOpen(ccolor=>'gray', csize=>3);

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;
121: ELSIF p_text_type = gc_RECORDS THEN
122: htp.p(htf.strong(p_text)) ;

Line 119: 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;
121: ELSIF p_text_type = gc_RECORDS THEN
122: htp.p(htf.strong(p_text)) ;
123: END IF;

Line 120: 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;
124:

Line 122: htp.p(htf.strong(p_text)) ;

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

Line 132: htp.p(htf.bodyOpen);

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;

Line 133: htp.p(gc_error_display||' : '||fnd_message.get);

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;
137:

Line 134: htp.p(htf.br);

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)

Line 135: htp.p(htf.bodyClose);

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

Line 185: htp.p('HandleError'|| sqlerrm);

181: Print(p_custom_message || ' ' ||p_sqlerrm, gc_OK, gc_message);
182:
183: EXCEPTION
184: WHEN OTHERS THEN
185: htp.p('HandleError'|| sqlerrm);
186: END HandleError;
187:
188:
189:

Line 342: htp.p ('PrintReportDetails' || sqlerrm);

338: END IF;
339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: htp.p ('PrintReportDetails' || sqlerrm);
343: END PrintReportDetails;
344:
345: -- Table is opened in the heading printing.
346: -- heading is printed only for the first time (in most cases)

Line 365: htp.p ('EndOfTable' || sqlerrm);

361:
362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: htp.p ('EndOfTable' || sqlerrm);
366: END EndOfTable;
367:
368: -- Message Names:
369: -- INITIAL_STATUS_OF_SV

Line 2937: htp.p(htf.htmlOpen);

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

Line 2938: htp.p(htf.title(GetMsgTxt('XNP_CVU_REPORT')));

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

Line 2939: htp.p(htf.header(nsize=>2,

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

Line 2941: htp.p(htf.bodyOpen);

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

Line 2942: htp.p(htf.nl);

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

Line 2943: htp.p(htf.nl);

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

Line 2957: htp.p(htf.nl);

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

Line 2958: htp.p(htf.nl);

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

Line 2959: htp.p(htf.header(nsize=>2, cheader=>GetMsgTxt('XNP_END_OF_REPORT'),

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

Line 2961: htp.p(htf.line);

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

Line 2962: htp.p(htf.bodyClose);

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

Line 2963: htp.p(htf.htmlClose);

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