53: htp.p('');
54:
55: EXCEPTION
56: WHEN NO_DATA_FOUND THEN
57: x_return_status := FND_API.G_RET_STS_ERROR ;
58: RAISE FND_API.G_EXC_ERROR;
59: when FND_API.G_EXC_ERROR then
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
54:
55: EXCEPTION
56: WHEN NO_DATA_FOUND THEN
57: x_return_status := FND_API.G_RET_STS_ERROR ;
58: RAISE FND_API.G_EXC_ERROR;
59: when FND_API.G_EXC_ERROR then
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
55: EXCEPTION
56: WHEN NO_DATA_FOUND THEN
57: x_return_status := FND_API.G_RET_STS_ERROR ;
58: RAISE FND_API.G_EXC_ERROR;
59: when FND_API.G_EXC_ERROR then
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
56: WHEN NO_DATA_FOUND THEN
57: x_return_status := FND_API.G_RET_STS_ERROR ;
58: RAISE FND_API.G_EXC_ERROR;
59: when FND_API.G_EXC_ERROR then
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: x_return_status := FND_API.G_RET_STS_ERROR ;
58: RAISE FND_API.G_EXC_ERROR;
59: when FND_API.G_EXC_ERROR then
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: when others then
58: RAISE FND_API.G_EXC_ERROR;
59: when FND_API.G_EXC_ERROR then
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: when others then
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
59: when FND_API.G_EXC_ERROR then
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: when others then
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
67: BIS_UTILITIES_PVT.Add_Error_Message
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: RAISE FND_API.G_EXC_ERROR;
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: when others then
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
67: BIS_UTILITIES_PVT.Add_Error_Message
68: ( p_error_msg_id => SQLCODE
62: when FND_API.G_EXC_UNEXPECTED_ERROR then
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: when others then
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
67: BIS_UTILITIES_PVT.Add_Error_Message
68: ( p_error_msg_id => SQLCODE
69: , p_error_description => SQLERRM
70: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
70: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
71: , p_error_table => x_error_tbl
72: , x_error_table => x_error_tbl
73: );
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75:
76: END Put_Errors;
77: --
78: -- Procedure just puts the relevant function in the javascript
114: end if;
115: */
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: RAISE FND_API.G_EXC_ERROR;
120: when FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
115: */
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: RAISE FND_API.G_EXC_ERROR;
120: when FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: RAISE FND_API.G_EXC_ERROR;
120: when FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
117: WHEN NO_DATA_FOUND THEN
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: RAISE FND_API.G_EXC_ERROR;
120: when FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: RAISE FND_API.G_EXC_ERROR;
120: when FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: when others then
119: RAISE FND_API.G_EXC_ERROR;
120: when FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: when others then
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120: when FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: when others then
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: BIS_UTILITIES_PVT.Add_Error_Message
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: RAISE FND_API.G_EXC_ERROR;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: when others then
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: BIS_UTILITIES_PVT.Add_Error_Message
129: ( p_error_msg_id => SQLCODE
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: when others then
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: BIS_UTILITIES_PVT.Add_Error_Message
129: ( p_error_msg_id => SQLCODE
130: , p_error_description => SQLERRM
131: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
131: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
132: , p_error_table => x_error_tbl
133: , x_error_table => x_error_tbl
134: );
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136:
137: END Put_Errors;
138: --
139: PROCEDURE Put_Errors
172: htp.p('}');
173: htp.p('');
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_ERROR then
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
173: htp.p('');
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_ERROR then
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_ERROR then
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
175: WHEN NO_DATA_FOUND THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_ERROR then
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_ERROR then
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_ERROR then
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
178: when FND_API.G_EXC_ERROR then
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: BIS_UTILITIES_PVT.Add_Error_Message
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: BIS_UTILITIES_PVT.Add_Error_Message
187: ( p_error_msg_id => SQLCODE
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: BIS_UTILITIES_PVT.Add_Error_Message
187: ( p_error_msg_id => SQLCODE
188: , p_error_description => SQLERRM
189: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
189: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
190: , p_error_table => x_error_tbl
191: , x_error_table => x_error_tbl
192: );
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194:
195: END Put_Errors;
196: ----
197: ---- Walid's verion: reads the error message form the form variable
243: htp.p('}'); --- closes the function definition
244: htp.p('');
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: RAISE FND_API.G_EXC_ERROR;
249: when FND_API.G_EXC_ERROR then
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
244: htp.p('');
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: RAISE FND_API.G_EXC_ERROR;
249: when FND_API.G_EXC_ERROR then
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: RAISE FND_API.G_EXC_ERROR;
249: when FND_API.G_EXC_ERROR then
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246: WHEN NO_DATA_FOUND THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: RAISE FND_API.G_EXC_ERROR;
249: when FND_API.G_EXC_ERROR then
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: RAISE FND_API.G_EXC_ERROR;
249: when FND_API.G_EXC_ERROR then
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: when others then
248: RAISE FND_API.G_EXC_ERROR;
249: when FND_API.G_EXC_ERROR then
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: when others then
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: when FND_API.G_EXC_ERROR then
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: when others then
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257: BIS_UTILITIES_PVT.Add_Error_Message
250: x_return_status := FND_API.G_RET_STS_ERROR ;
251: RAISE FND_API.G_EXC_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: when others then
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257: BIS_UTILITIES_PVT.Add_Error_Message
258: ( p_error_msg_id => SQLCODE
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: when others then
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
257: BIS_UTILITIES_PVT.Add_Error_Message
258: ( p_error_msg_id => SQLCODE
259: , p_error_description => SQLERRM
260: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
260: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'
261: , p_error_table => x_error_tbl
262: , x_error_table => x_error_tbl
263: );
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265:
266: END Put_Errors;
267: --
268: -- Just alerts the SQLERRM and go back 1 page.
299: );
300:
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304: RAISE FND_API.G_EXC_ERROR;
305: when FND_API.G_EXC_ERROR then
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
300:
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304: RAISE FND_API.G_EXC_ERROR;
305: when FND_API.G_EXC_ERROR then
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304: RAISE FND_API.G_EXC_ERROR;
305: when FND_API.G_EXC_ERROR then
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: WHEN NO_DATA_FOUND THEN
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304: RAISE FND_API.G_EXC_ERROR;
305: when FND_API.G_EXC_ERROR then
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304: RAISE FND_API.G_EXC_ERROR;
305: when FND_API.G_EXC_ERROR then
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: when others then
304: RAISE FND_API.G_EXC_ERROR;
305: when FND_API.G_EXC_ERROR then
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: when others then
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: when FND_API.G_EXC_ERROR then
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: when others then
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: BIS_UTILITIES_PVT.Add_Error_Message
306: x_return_status := FND_API.G_RET_STS_ERROR ;
307: RAISE FND_API.G_EXC_ERROR;
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: when others then
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: BIS_UTILITIES_PVT.Add_Error_Message
314: ( p_error_msg_id => SQLCODE
308: when FND_API.G_EXC_UNEXPECTED_ERROR then
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: when others then
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: BIS_UTILITIES_PVT.Add_Error_Message
314: ( p_error_msg_id => SQLCODE
315: , p_error_description => SQLERRM
316: , p_error_proc_name => G_PKG_NAME||'.Put_Error_Variable'
316: , p_error_proc_name => G_PKG_NAME||'.Put_Error_Variable'
317: , p_error_table => x_error_tbl
318: , x_error_table => x_error_tbl
319: );
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321:
322: END Put_Error_Variable;
323:
324: PROCEDURE Put_Error_Variable
336: );
337:
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: RAISE FND_API.G_EXC_ERROR;
342: when FND_API.G_EXC_ERROR then
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
337:
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: RAISE FND_API.G_EXC_ERROR;
342: when FND_API.G_EXC_ERROR then
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: RAISE FND_API.G_EXC_ERROR;
342: when FND_API.G_EXC_ERROR then
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: RAISE FND_API.G_EXC_ERROR;
342: when FND_API.G_EXC_ERROR then
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: RAISE FND_API.G_EXC_ERROR;
342: when FND_API.G_EXC_ERROR then
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
341: RAISE FND_API.G_EXC_ERROR;
342: when FND_API.G_EXC_ERROR then
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: when FND_API.G_EXC_ERROR then
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: BIS_UTILITIES_PVT.Add_Error_Message
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: RAISE FND_API.G_EXC_ERROR;
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: BIS_UTILITIES_PVT.Add_Error_Message
351: ( p_error_msg_id => SQLCODE
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: BIS_UTILITIES_PVT.Add_Error_Message
351: ( p_error_msg_id => SQLCODE
352: , p_error_description => SQLERRM
353: , p_error_proc_name => G_PKG_NAME||'.Put_Error_Variable'
353: , p_error_proc_name => G_PKG_NAME||'.Put_Error_Variable'
354: , p_error_table => x_error_tbl
355: , x_error_table => x_error_tbl
356: );
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358:
359: END Put_Error_Variable;
360:
361: -- Procedure returns a window_text_string to be used in any manner
373: BEGIN
374:
375: l_str := htf.tableOpen;
376:
377: if (BIS_UTILITIES_PUB.Value_Not_NULL(p_caption) = FND_API.G_TRUE) then
378: -- put main message
379: l_str := l_str || htf.tableRowOpen;
380: -- l_str := l_str || BIS_UTILITIES_PVT.PutNullString(p_caption, 'LEFT',1,5);
381: l_str := l_str || BIS_UTILITIES_PVT.PutNullString(htf.bold(p_caption), 'LEFT',1,5);
421: x_msg_window_text := l_str;
422:
423: EXCEPTION
424: WHEN NO_DATA_FOUND THEN
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426: RAISE FND_API.G_EXC_ERROR;
427: when FND_API.G_EXC_ERROR then
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
422:
423: EXCEPTION
424: WHEN NO_DATA_FOUND THEN
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426: RAISE FND_API.G_EXC_ERROR;
427: when FND_API.G_EXC_ERROR then
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
423: EXCEPTION
424: WHEN NO_DATA_FOUND THEN
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426: RAISE FND_API.G_EXC_ERROR;
427: when FND_API.G_EXC_ERROR then
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: WHEN NO_DATA_FOUND THEN
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426: RAISE FND_API.G_EXC_ERROR;
427: when FND_API.G_EXC_ERROR then
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426: RAISE FND_API.G_EXC_ERROR;
427: when FND_API.G_EXC_ERROR then
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: when others then
426: RAISE FND_API.G_EXC_ERROR;
427: when FND_API.G_EXC_ERROR then
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: when others then
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
427: when FND_API.G_EXC_ERROR then
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: when others then
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: BIS_UTILITIES_PVT.Add_Error_Message
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: RAISE FND_API.G_EXC_ERROR;
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: when others then
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: BIS_UTILITIES_PVT.Add_Error_Message
436: ( p_error_msg_id => SQLCODE
430: when FND_API.G_EXC_UNEXPECTED_ERROR then
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: when others then
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: BIS_UTILITIES_PVT.Add_Error_Message
436: ( p_error_msg_id => SQLCODE
437: , p_error_description => SQLERRM
438: , p_error_proc_name => G_PKG_NAME||'.Get_Error_String'
438: , p_error_proc_name => G_PKG_NAME||'.Get_Error_String'
439: , p_error_table => x_error_tbl
440: , x_error_table => x_error_tbl
441: );
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443:
444: END Get_Error_String;
445: --
446: END BIS_ERROR_MESSAGE_FORM_PVT;