35: -- Initialize API return status to success.
36: x_return_status := fnd_api.g_ret_sts_success;
37:
38: -- Standard call to get message count and if count is 1, get message info.
39: fnd_msg_pub.count_and_get (
40: p_encoded => fnd_api.g_false,
41: p_count => x_msg_count,
42: p_data => x_msg_data
43: );
44:
45: EXCEPTION
46: WHEN FND_API.G_EXC_ERROR THEN
47: x_return_status := fnd_api.g_ret_sts_error;
48: fnd_msg_pub.count_and_get(
49: p_encoded => fnd_api.g_false,
50: p_count => x_msg_count,
51: p_data => x_msg_data
52: );
52: );
53: RETURN;
54: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
55: x_return_status := fnd_api.g_ret_sts_unexp_error;
56: fnd_msg_pub.count_and_get(
57: p_encoded => fnd_api.g_false,
58: p_count => x_msg_count,
59: p_data => x_msg_data
60: );
62: WHEN OTHERS THEN
63: x_return_status := fnd_api.g_ret_sts_unexp_error;
64: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
65: FND_MESSAGE.SET_TOKEN('NAME','process_duplicate_documents : '||SQLERRM);
66: fnd_msg_pub.add;
67: fnd_msg_pub.count_and_get(
68: p_encoded => fnd_api.g_false,
69: p_count => x_msg_count,
70: p_data => x_msg_data
63: x_return_status := fnd_api.g_ret_sts_unexp_error;
64: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
65: FND_MESSAGE.SET_TOKEN('NAME','process_duplicate_documents : '||SQLERRM);
66: fnd_msg_pub.add;
67: fnd_msg_pub.count_and_get(
68: p_encoded => fnd_api.g_false,
69: p_count => x_msg_count,
70: p_data => x_msg_data
71: );
294: -- Initialize API return status to success.
295: x_return_status := fnd_api.g_ret_sts_success;
296:
297: -- Standard call to get message count and if count is 1, get message info.
298: fnd_msg_pub.count_and_get (
299: p_encoded => fnd_api.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303:
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(
308: p_encoded => fnd_api.g_false,
309: p_count => x_msg_count,
310: p_data => x_msg_data
311: );
311: );
312: RETURN;
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315: fnd_msg_pub.count_and_get(
316: p_encoded => fnd_api.g_false,
317: p_count => x_msg_count,
318: p_data => x_msg_data
319: );
321: WHEN OTHERS THEN
322: x_return_status := fnd_api.g_ret_sts_unexp_error;
323: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
324: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
325: fnd_msg_pub.add;
326: fnd_msg_pub.count_and_get(
327: p_encoded => fnd_api.g_false,
328: p_count => x_msg_count,
329: p_data => x_msg_data
322: x_return_status := fnd_api.g_ret_sts_unexp_error;
323: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
324: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
325: fnd_msg_pub.add;
326: fnd_msg_pub.count_and_get(
327: p_encoded => fnd_api.g_false,
328: p_count => x_msg_count,
329: p_data => x_msg_data
330: );
397: -- Initialize API return status to success.
398: x_return_status := fnd_api.g_ret_sts_success;
399:
400: -- Standard call to get message count and if count is 1, get message info.
401: fnd_msg_pub.count_and_get (
402: p_encoded => fnd_api.g_false,
403: p_count => x_msg_count,
404: p_data => x_msg_data
405: );
406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: x_return_status := fnd_api.g_ret_sts_error;
410: fnd_msg_pub.count_and_get(
411: p_encoded => fnd_api.g_false,
412: p_count => x_msg_count,
413: p_data => x_msg_data
414: );
414: );
415: RETURN;
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
417: x_return_status := fnd_api.g_ret_sts_unexp_error;
418: fnd_msg_pub.count_and_get(
419: p_encoded => fnd_api.g_false,
420: p_count => x_msg_count,
421: p_data => x_msg_data
422: );
424: WHEN OTHERS THEN
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
427: FND_MESSAGE.SET_TOKEN('NAME','Lock_Row : '||SQLERRM);
428: fnd_msg_pub.add;
429: fnd_msg_pub.count_and_get(
430: p_encoded => fnd_api.g_false,
431: p_count => x_msg_count,
432: p_data => x_msg_data
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
427: FND_MESSAGE.SET_TOKEN('NAME','Lock_Row : '||SQLERRM);
428: fnd_msg_pub.add;
429: fnd_msg_pub.count_and_get(
430: p_encoded => fnd_api.g_false,
431: p_count => x_msg_count,
432: p_data => x_msg_data
433: );