DBA Data[Home] [Help]

APPS.FV_CCR_GRP dependencies on FND_MSG_PUB

Line 32: FND_MSG_PUB.initialize;

28: END IF;
29:
30: -- Initialize message list if p_init_msg_list is set to TRUE.
31: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE) ) THEN
32: FND_MSG_PUB.initialize;
33: END IF;
34: -- Initialize API return status to success
35:
36: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 65: FND_MSG_PUB.Count_And_Get

61: WHERE nvl(bank_account_id,-99) = p_object_id;
62: END IF;
63: x_out_status := FND_API.G_TRUE;
64:
65: FND_MSG_PUB.Count_And_Get
66: (
67: p_count => x_msg_count ,
68: p_data => x_msg_data
69: );

Line 86: FND_MSG_PUB.ADD;

82: x_return_status := FND_API.G_RET_STS_ERROR ;
83: END IF;
84:
85: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
86: FND_MSG_PUB.ADD;
87:
88:
89: FND_MSG_PUB.Count_And_Get
90: ( p_count => x_msg_count ,

Line 89: FND_MSG_PUB.Count_And_Get

85: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
86: FND_MSG_PUB.ADD;
87:
88:
89: FND_MSG_PUB.Count_And_Get
90: ( p_count => x_msg_count ,
91: p_data => x_msg_data
92: );
93:

Line 98: FND_MSG_PUB.Count_And_Get

94: WHEN FND_API.G_EXC_ERROR THEN
95:
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97:
98: FND_MSG_PUB.Count_And_Get
99: ( p_count => x_msg_count ,
100: p_data => x_msg_data
101: );
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 105: FND_MSG_PUB.Count_And_Get

101: );
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103:
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: FND_MSG_PUB.Count_And_Get
106: ( p_count => x_msg_count ,
107: p_data => x_msg_data
108: );
109:

Line 113: IF FND_MSG_PUB.Check_Msg_Level

109:
110: WHEN OTHERS THEN
111:
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
113: IF FND_MSG_PUB.Check_Msg_Level
114: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
115: THEN
116: FND_MSG_PUB.Add_Exc_Msg
117: ( G_PKG_NAME ,

Line 114: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

110: WHEN OTHERS THEN
111:
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
113: IF FND_MSG_PUB.Check_Msg_Level
114: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
115: THEN
116: FND_MSG_PUB.Add_Exc_Msg
117: ( G_PKG_NAME ,
118: l_api_name

Line 116: FND_MSG_PUB.Add_Exc_Msg

112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
113: IF FND_MSG_PUB.Check_Msg_Level
114: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
115: THEN
116: FND_MSG_PUB.Add_Exc_Msg
117: ( G_PKG_NAME ,
118: l_api_name
119: );
120: END IF;

Line 121: FND_MSG_PUB.Count_And_Get

117: ( G_PKG_NAME ,
118: l_api_name
119: );
120: END IF;
121: FND_MSG_PUB.Count_And_Get
122: ( p_count => x_msg_count ,
123: p_data => x_msg_data
124: );
125: END FV_IS_CCR;

Line 158: FND_MSG_PUB.initialize;

154: END IF;
155:
156: -- Initialize message list if p_init_msg_list is set to TRUE.
157: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE) ) THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160: -- Initialize API return status to success
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 171: FND_MSG_PUB.Count_And_Get

167: AND (nvl(fco.pay_site_id,-99)=p_vendor_site_id
168: OR nvl(fco.main_address_site_id,-99)=p_vendor_site_id);
169:
170:
171: FND_MSG_PUB.Count_And_Get
172: (
173: p_count => x_msg_count ,
174: p_data => x_msg_data
175: );

Line 181: FND_MSG_PUB.ADD;

177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN
179: x_error_code := 2;
180: FND_MESSAGE.SET_NAME('FV','FV_SITE_NOT_CCR');
181: FND_MSG_PUB.ADD;
182: FND_MSG_PUB.Count_And_Get
183: (
184: p_count => x_msg_count ,
185: p_data => x_msg_data

Line 182: FND_MSG_PUB.Count_And_Get

178: WHEN NO_DATA_FOUND THEN
179: x_error_code := 2;
180: FND_MESSAGE.SET_NAME('FV','FV_SITE_NOT_CCR');
181: FND_MSG_PUB.ADD;
182: FND_MSG_PUB.Count_And_Get
183: (
184: p_count => x_msg_count ,
185: p_data => x_msg_data
186: );

Line 191: FND_MSG_PUB.ADD;

187:
188: x_return_status := FND_API.G_RET_STS_ERROR ;
189: WHEN TOO_MANY_ROWS THEN
190: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
191: FND_MSG_PUB.ADD;
192: x_error_code := 1;
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: FND_MSG_PUB.Count_And_Get
195: ( p_count => x_msg_count ,

Line 194: FND_MSG_PUB.Count_And_Get

190: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
191: FND_MSG_PUB.ADD;
192: x_error_code := 1;
193: x_return_status := FND_API.G_RET_STS_ERROR ;
194: FND_MSG_PUB.Count_And_Get
195: ( p_count => x_msg_count ,
196: p_data => x_msg_data
197: );
198: WHEN FND_API.G_EXC_ERROR THEN

Line 201: FND_MSG_PUB.Count_And_Get

197: );
198: WHEN FND_API.G_EXC_ERROR THEN
199:
200: x_return_status := FND_API.G_RET_STS_ERROR ;
201: FND_MSG_PUB.Count_And_Get
202: ( p_count => x_msg_count ,
203: p_data => x_msg_data
204: );
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 208: FND_MSG_PUB.Count_And_Get

204: );
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206:
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208: FND_MSG_PUB.Count_And_Get
209: ( p_count => x_msg_count ,
210: p_data => x_msg_data
211: );
212: WHEN OTHERS THEN

Line 215: IF FND_MSG_PUB.Check_Msg_Level

211: );
212: WHEN OTHERS THEN
213:
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: IF FND_MSG_PUB.Check_Msg_Level
216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
217: THEN
218: FND_MSG_PUB.Add_Exc_Msg
219: ( G_PKG_NAME ,

Line 216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

212: WHEN OTHERS THEN
213:
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: IF FND_MSG_PUB.Check_Msg_Level
216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
217: THEN
218: FND_MSG_PUB.Add_Exc_Msg
219: ( G_PKG_NAME ,
220: l_api_name

Line 218: FND_MSG_PUB.Add_Exc_Msg

214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: IF FND_MSG_PUB.Check_Msg_Level
216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
217: THEN
218: FND_MSG_PUB.Add_Exc_Msg
219: ( G_PKG_NAME ,
220: l_api_name
221: );
222: END IF;

Line 223: FND_MSG_PUB.Count_And_Get

219: ( G_PKG_NAME ,
220: l_api_name
221: );
222: END IF;
223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count ,
225: p_data => x_msg_data
226: );
227: END FV_CCR_REG_STATUS;

Line 261: fnd_msg_pub.initialize;

257:
258: -- Initialize API message list if necessary.
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF fnd_api.to_boolean(p_init_msg_list) THEN
261: fnd_msg_pub.initialize;
262: END IF;
263:
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:

Line 277: fnd_msg_pub.count_and_get

273: ELSE
274: x_federal := 'N';
275: END IF;
276:
277: fnd_msg_pub.count_and_get
278: (
279: p_count => x_msg_count,
280: p_data => x_msg_data
281: );

Line 286: fnd_msg_pub.count_and_get

282:
283: EXCEPTION
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: fnd_msg_pub.count_and_get
287: (
288: p_count => x_msg_count,
289: p_data => x_msg_data
290: );

Line 294: fnd_msg_pub.add;

290: );
291: WHEN NO_DATA_FOUND THEN
292: x_error_code := 2;
293: fnd_message.set_name('FV','FV_CCR_INVALID_VENDOR_ID');
294: fnd_msg_pub.add;
295: fnd_msg_pub.count_and_get
296: (
297: p_count => x_msg_count,
298: p_data => x_msg_data

Line 295: fnd_msg_pub.count_and_get

291: WHEN NO_DATA_FOUND THEN
292: x_error_code := 2;
293: fnd_message.set_name('FV','FV_CCR_INVALID_VENDOR_ID');
294: fnd_msg_pub.add;
295: fnd_msg_pub.count_and_get
296: (
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );

Line 303: fnd_msg_pub.count_and_get

299: );
300: x_return_status := FND_API.G_RET_STS_ERROR ;
301: WHEN FND_API.G_EXC_ERROR THEN
302: x_return_status := FND_API.G_RET_STS_ERROR ;
303: fnd_msg_pub.count_and_get
304: (
305: p_count => x_msg_count,
306: p_data => x_msg_data
307: );

Line 311: IF fnd_msg_pub.check_msg_level

307: );
308: WHEN OTHERS THEN
309: l_error := SQLERRM;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: IF fnd_msg_pub.check_msg_level
312: (
313: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error
314: )
315: THEN

Line 313: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error

309: l_error := SQLERRM;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: IF fnd_msg_pub.check_msg_level
312: (
313: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error
314: )
315: THEN
316: fnd_msg_pub.add_exc_msg
317: (

Line 316: fnd_msg_pub.add_exc_msg

312: (
313: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error
314: )
315: THEN
316: fnd_msg_pub.add_exc_msg
317: (
318: p_pkg_name => g_pkg_name,
319: p_procedure_name => l_api_name,
320: p_error_text => l_error

Line 323: fnd_msg_pub.count_and_get

319: p_procedure_name => l_api_name,
320: p_error_text => l_error
321: );
322: END IF;
323: fnd_msg_pub.count_and_get
324: (
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );

Line 357: FND_MSG_PUB.initialize;

353: END IF;
354:
355: -- Initialize message list if p_init_msg_list is set to TRUE.
356: IF FND_API.to_Boolean( nvl(p_init_msg_list,FND_API.G_FALSE) ) THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359: -- Initialize API return status to success
360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 380: FND_MSG_PUB.Count_And_Get

376:
377:
378:
379:
380: FND_MSG_PUB.Count_And_Get
381: (
382: p_count => x_msg_count ,
383: p_data => x_msg_data
384: );

Line 396: FND_MSG_PUB.ADD;

392: WHEN TOO_MANY_ROWS THEN
393: x_error_code := 1;
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
396: FND_MSG_PUB.ADD;
397:
398:
399: FND_MSG_PUB.Count_And_Get
400: ( p_count => x_msg_count ,

Line 399: FND_MSG_PUB.Count_And_Get

395: FND_MESSAGE.SET_NAME('FV', 'FV_CCR_GRP_TOO_MANY_ROWS');
396: FND_MSG_PUB.ADD;
397:
398:
399: FND_MSG_PUB.Count_And_Get
400: ( p_count => x_msg_count ,
401: p_data => x_msg_data
402: );
403:

Line 408: FND_MSG_PUB.Count_And_Get

404: WHEN FND_API.G_EXC_ERROR THEN
405:
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407:
408: FND_MSG_PUB.Count_And_Get
409: ( p_count => x_msg_count ,
410: p_data => x_msg_data
411: );
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 415: FND_MSG_PUB.Count_And_Get

411: );
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413:
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
415: FND_MSG_PUB.Count_And_Get
416: ( p_count => x_msg_count ,
417: p_data => x_msg_data
418: );
419:

Line 423: IF FND_MSG_PUB.Check_Msg_Level

419:
420: WHEN OTHERS THEN
421:
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg
427: ( G_PKG_NAME ,

Line 424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

420: WHEN OTHERS THEN
421:
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg
427: ( G_PKG_NAME ,
428: l_api_name

Line 426: FND_MSG_PUB.Add_Exc_Msg

422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg
427: ( G_PKG_NAME ,
428: l_api_name
429: );
430: END IF;

Line 431: FND_MSG_PUB.Count_And_Get

427: ( G_PKG_NAME ,
428: l_api_name
429: );
430: END IF;
431: FND_MSG_PUB.Count_And_Get
432: ( p_count => x_msg_count ,
433: p_data => x_msg_data
434: );
435: END FV_IS_BANK_ACCOUNT_USES_CCR;