34: p_line := p_line || g_field_sep;
35:
36: EXCEPTION
37: WHEN OTHERS THEN
38: htp.p('Error in get_line : ' || substr(SQLERRM, 1, 512));
39: -- icx_util.add_error(substr(SQLERRM, 12, 512));
40: -- icx_util.error_page_print;
41: END get_line;
42:
70:
71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: htp.p('Error in get_field : ' || substr(SQLERRM, 1, 512));
75: -- icx_util.add_error(substr(SQLERRM, 12, 512));
76: -- icx_util.error_page_print;
77: END get_field;
78:
102: END LOOP;
103:
104: EXCEPTION
105: WHEN OTHERS THEN
106: htp.p('Error in get_prompts_table : ' || substr(SQLERRM, 1, 512));
107: -- icx_util.add_error(substr(SQLERRM, 12, 512));
108: -- icx_util.error_page_print;
109: END get_prompts_table;
110:
133: EXCEPTION
134: WHEN OTHERS THEN
135: p_date := NULL;
136: p_error_flag := 'E';
137: -- htp.p('Error in convert_to_date : ' || substr(SQLERRM, 1, 512));
138: -- icx_util.add_error(substr(SQLERRM, 12, 512));
139: -- icx_util.error_page_print;
140: END convert_to_date;
141:
170: RETURN;
171:
172: EXCEPTION
173: WHEN OTHERS THEN
174: htp.p('Error in get_prompts_info : ' || substr(SQLERRM, 1, 512));
175: -- icx_util.add_error(substr(SQLERRM, 12, 512));
176: -- icx_util.error_page_print;
177: END get_prompts_info;
178:
193: RETURN l_string;
194:
195: EXCEPTION
196: WHEN OTHERS THEN
197: htp.p('Error in replace_crlf: ' || substr(SQLERRM, 1, 512));
198: -- icx_util.add_error(substr(SQLERRM, 12, 512));
199: -- icx_util.error_page_print;
200: END replace_crlf;
201: