DBA Data[Home] [Help]

APPS.IGS_AS_DUP_DOCS_PKG dependencies on FND_API

Line 23: p_init_msg_list => fnd_api.g_true,

19: --
20: igs_as_documents_api.update_document_details (
21: p_order_number => x_order_number,
22: p_item_number => x_item_number,
23: p_init_msg_list => fnd_api.g_true,
24: p_return_status => x_return_status,
25: p_msg_count => x_msg_count,
26: p_msg_data => x_msg_data
27: );

Line 32: IF (NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) THEN

28: --
29: -- Check if there was an error during the process of updating the Order and
30: -- Details records, and creating an interface item
31: --
32: IF (NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) THEN
33: RETURN;
34: END IF;
35: -- Initialize API return status to success.
36: x_return_status := fnd_api.g_ret_sts_success;

Line 36: x_return_status := fnd_api.g_ret_sts_success;

32: IF (NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) THEN
33: RETURN;
34: END IF;
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,

Line 40: p_encoded => fnd_api.g_false,

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:

Line 46: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 47: x_return_status := fnd_api.g_ret_sts_error;

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

Line 49: p_encoded => fnd_api.g_false,

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: );
53: RETURN;

Line 54: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

50: p_count => x_msg_count,
51: p_data => x_msg_data
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,

Line 55: x_return_status := fnd_api.g_ret_sts_unexp_error;

51: p_data => x_msg_data
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

Line 57: p_encoded => fnd_api.g_false,

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: );
61: RETURN;

Line 63: x_return_status := fnd_api.g_ret_sts_unexp_error;

59: p_data => x_msg_data
60: );
61: RETURN;
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(

Line 68: p_encoded => fnd_api.g_false,

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: );
72: RETURN;

Line 290: IF (NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) THEN

286: x_msg_data => x_msg_data,
287: x_msg_count => x_msg_count
288: );
289:
290: IF (NVL (x_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) THEN
291: RETURN;
292: END IF;
293:
294: -- Initialize API return status to success.

Line 295: x_return_status := fnd_api.g_ret_sts_success;

291: RETURN;
292: END IF;
293:
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,

Line 299: p_encoded => fnd_api.g_false,

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:

Line 305: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 306: x_return_status := fnd_api.g_ret_sts_error;

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

Line 308: p_encoded => fnd_api.g_false,

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: );
312: RETURN;

Line 313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

309: p_count => x_msg_count,
310: p_data => x_msg_data
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,

Line 314: x_return_status := fnd_api.g_ret_sts_unexp_error;

310: p_data => x_msg_data
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

Line 316: p_encoded => fnd_api.g_false,

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: );
320: RETURN;

Line 322: x_return_status := fnd_api.g_ret_sts_unexp_error;

318: p_data => x_msg_data
319: );
320: RETURN;
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(

Line 327: p_encoded => fnd_api.g_false,

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: );
331: RETURN;

Line 398: x_return_status := fnd_api.g_ret_sts_success;

394: app_exception.raise_exception;
395: END IF;
396:
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,

Line 402: p_encoded => fnd_api.g_false,

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:

Line 408: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 409: x_return_status := fnd_api.g_ret_sts_error;

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

Line 411: p_encoded => fnd_api.g_false,

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: );
415: RETURN;

Line 416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

412: p_count => x_msg_count,
413: p_data => x_msg_data
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,

Line 417: x_return_status := fnd_api.g_ret_sts_unexp_error;

413: p_data => x_msg_data
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

Line 419: p_encoded => fnd_api.g_false,

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: );
423: RETURN;

Line 425: x_return_status := fnd_api.g_ret_sts_unexp_error;

421: p_data => x_msg_data
422: );
423: RETURN;
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(

Line 430: p_encoded => fnd_api.g_false,

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: );
434: RETURN;