DBA Data[Home] [Help]

APPS.BIS_ERROR_MESSAGE_FORM_PVT dependencies on FND_API

Line 57: x_return_status := FND_API.G_RET_STS_ERROR ;

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;

Line 58: 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

Line 59: when FND_API.G_EXC_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 ;

Line 60: x_return_status := FND_API.G_RET_STS_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;

Line 61: RAISE FND_API.G_EXC_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

Line 62: when FND_API.G_EXC_UNEXPECTED_ERROR 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 ;

Line 63: 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

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 66: x_return_status := FND_API.G_RET_STS_UNEXP_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
69: , p_error_description => SQLERRM
70: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 118: x_return_status := FND_API.G_RET_STS_ERROR ;

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;

Line 119: 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

Line 120: when FND_API.G_EXC_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 ;

Line 121: x_return_status := FND_API.G_RET_STS_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;

Line 122: RAISE FND_API.G_EXC_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

Line 123: when FND_API.G_EXC_UNEXPECTED_ERROR 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 ;

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

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_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
130: , p_error_description => SQLERRM
131: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 176: x_return_status := FND_API.G_RET_STS_ERROR ;

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;

Line 177: 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

Line 178: when FND_API.G_EXC_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 ;

Line 179: x_return_status := FND_API.G_RET_STS_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;

Line 180: RAISE FND_API.G_EXC_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

Line 181: when FND_API.G_EXC_UNEXPECTED_ERROR 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 ;

Line 182: 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

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_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
188: , p_error_description => SQLERRM
189: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 247: x_return_status := FND_API.G_RET_STS_ERROR ;

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;

Line 248: 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

Line 249: when FND_API.G_EXC_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 ;

Line 250: x_return_status := FND_API.G_RET_STS_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;

Line 251: RAISE FND_API.G_EXC_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

Line 252: when FND_API.G_EXC_UNEXPECTED_ERROR 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 ;

Line 253: 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

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_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
259: , p_error_description => SQLERRM
260: , p_error_proc_name => G_PKG_NAME||'.Put_Errors'

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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.

Line 303: x_return_status := FND_API.G_RET_STS_ERROR ;

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;

Line 304: 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

Line 305: when FND_API.G_EXC_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 ;

Line 306: x_return_status := FND_API.G_RET_STS_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;

Line 307: RAISE FND_API.G_EXC_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

Line 308: when FND_API.G_EXC_UNEXPECTED_ERROR 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 ;

Line 309: 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

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_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
315: , p_error_description => SQLERRM
316: , p_error_proc_name => G_PKG_NAME||'.Put_Error_Variable'

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 340: x_return_status := FND_API.G_RET_STS_ERROR ;

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;

Line 341: 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

Line 342: when FND_API.G_EXC_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 ;

Line 343: x_return_status := FND_API.G_RET_STS_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;

Line 344: RAISE FND_API.G_EXC_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

Line 345: when FND_API.G_EXC_UNEXPECTED_ERROR 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 ;

Line 346: 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

Line 347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 349: x_return_status := FND_API.G_RET_STS_UNEXP_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
352: , p_error_description => SQLERRM
353: , p_error_proc_name => G_PKG_NAME||'.Put_Error_Variable'

Line 357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 377: if (BIS_UTILITIES_PUB.Value_Not_NULL(p_caption) = FND_API.G_TRUE) then

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

Line 425: x_return_status := FND_API.G_RET_STS_ERROR ;

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;

Line 426: 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

Line 427: when FND_API.G_EXC_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 ;

Line 428: x_return_status := FND_API.G_RET_STS_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;

Line 429: RAISE FND_API.G_EXC_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

Line 430: when FND_API.G_EXC_UNEXPECTED_ERROR 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 ;

Line 431: 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

Line 432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_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
437: , p_error_description => SQLERRM
438: , p_error_proc_name => G_PKG_NAME||'.Get_Error_String'

Line 442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;