DBA Data[Home] [Help]

APPS.AR_DEFERRAL_REASONS_GRP dependencies on FND_API

Line 17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

13: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'), 'N');
14:
15: PROCEDURE default_reasons (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
18: p_commit IN VARCHAR2 := fnd_api.g_false,
19: p_mode IN VARCHAR2 DEFAULT 'ALL',
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,

Line 18: p_commit IN VARCHAR2 := fnd_api.g_false,

14:
15: PROCEDURE default_reasons (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
18: p_commit IN VARCHAR2 := fnd_api.g_false,
19: p_mode IN VARCHAR2 DEFAULT 'ALL',
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 33: IF NOT FND_API.Compatible_API_Call (

29: -- Standard Start of API savepoint
30: SAVEPOINT default_reasons_grp;
31:
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call (
34: p_current_version_number => l_api_version,
35: p_caller_version_number => p_api_version,
36: p_api_name => l_api_name,
37: p_pkg_name => g_pkg_name) THEN

Line 39: RAISE fnd_api.g_exc_unexpected_error;

35: p_caller_version_number => p_api_version,
36: p_api_name => l_api_name,
37: p_pkg_name => g_pkg_name) THEN
38:
39: RAISE fnd_api.g_exc_unexpected_error;
40:
41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 44: IF FND_API.to_Boolean( p_init_msg_list ) THEN

40:
41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: IF FND_API.to_Boolean( p_init_msg_list ) THEN
45: fnd_msg_pub.initialize;
46: END IF;
47:
48: /* 9968597 - Calling Hook Procedure to populate the attribute columns */

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: /* 9968597 - Calling Hook Procedure to populate the attribute columns */
49: AR_CUSTOM_PARAMS_HOOK_PKG.populateContingencyAttributes(p_source => p_mode);
50:
51: -- Initialize API return status to success
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: fun_rule_pub.apply_rule_bulk (
55: p_application_short_name => 'AR',
56: p_rule_object_name => ar_revenue_management_pvt.c_rule_object_name,

Line 63: WHEN fnd_api.g_exc_error THEN

59: p_primary_key_column_name => 'SOURCE_LINE_ID'
60: );
61:
62: EXCEPTION
63: WHEN fnd_api.g_exc_error THEN
64: ROLLBACK TO default_reasons_grp;
65: x_return_status := FND_API.G_RET_STS_ERROR ;
66: fnd_msg_pub.count_and_get (
67: p_encoded => fnd_api.g_false,

Line 65: x_return_status := FND_API.G_RET_STS_ERROR ;

61:
62: EXCEPTION
63: WHEN fnd_api.g_exc_error THEN
64: ROLLBACK TO default_reasons_grp;
65: x_return_status := FND_API.G_RET_STS_ERROR ;
66: fnd_msg_pub.count_and_get (
67: p_encoded => fnd_api.g_false,
68: p_count => x_msg_count,
69: p_data => x_msg_data);

Line 67: p_encoded => fnd_api.g_false,

63: WHEN fnd_api.g_exc_error THEN
64: ROLLBACK TO default_reasons_grp;
65: x_return_status := FND_API.G_RET_STS_ERROR ;
66: fnd_msg_pub.count_and_get (
67: p_encoded => fnd_api.g_false,
68: p_count => x_msg_count,
69: p_data => x_msg_data);
70:
71: WHEN fnd_api.g_exc_unexpected_error THEN

Line 71: WHEN fnd_api.g_exc_unexpected_error THEN

67: p_encoded => fnd_api.g_false,
68: p_count => x_msg_count,
69: p_data => x_msg_data);
70:
71: WHEN fnd_api.g_exc_unexpected_error THEN
72: ROLLBACK TO default_reasons_grp;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: fnd_msg_pub.count_and_get (
75: p_encoded => fnd_api.g_false,

Line 73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

69: p_data => x_msg_data);
70:
71: WHEN fnd_api.g_exc_unexpected_error THEN
72: ROLLBACK TO default_reasons_grp;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: fnd_msg_pub.count_and_get (
75: p_encoded => fnd_api.g_false,
76: p_count => x_msg_count,
77: p_data => x_msg_data);

Line 75: p_encoded => fnd_api.g_false,

71: WHEN fnd_api.g_exc_unexpected_error THEN
72: ROLLBACK TO default_reasons_grp;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: fnd_msg_pub.count_and_get (
75: p_encoded => fnd_api.g_false,
76: p_count => x_msg_count,
77: p_data => x_msg_data);
78:
79: WHEN OTHERS THEN

Line 81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

77: p_data => x_msg_data);
78:
79: WHEN OTHERS THEN
80: ROLLBACK TO default_reasons_grp;
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: fnd_msg_pub.count_and_get (
83: p_encoded => fnd_api.g_false,
84: p_count => x_msg_count,
85: p_data => x_msg_data);

Line 83: p_encoded => fnd_api.g_false,

79: WHEN OTHERS THEN
80: ROLLBACK TO default_reasons_grp;
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: fnd_msg_pub.count_and_get (
83: p_encoded => fnd_api.g_false,
84: p_count => x_msg_count,
85: p_data => x_msg_data);
86:
87: END default_reasons;

Line 118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

114: END is_rule_deferred;
115:
116: PROCEDURE record_acceptance (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_order_line IN line_flex_rec,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,

Line 119: p_commit IN VARCHAR2 := fnd_api.g_false,

115:
116: PROCEDURE record_acceptance (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_order_line IN line_flex_rec,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 178: IF NOT FND_API.Compatible_API_Call (

174: -- Standard Start of API savepoint
175: SAVEPOINT record_acceptance_grp;
176:
177: -- Standard call to check for call compatibility.
178: IF NOT FND_API.Compatible_API_Call (
179: p_current_version_number => l_api_version,
180: p_caller_version_number => p_api_version,
181: p_api_name => l_api_name,
182: p_pkg_name => g_pkg_name) THEN

Line 184: RAISE fnd_api.g_exc_unexpected_error;

180: p_caller_version_number => p_api_version,
181: p_api_name => l_api_name,
182: p_pkg_name => g_pkg_name) THEN
183:
184: RAISE fnd_api.g_exc_unexpected_error;
185:
186: END IF;
187:
188: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 189: IF FND_API.to_Boolean( p_init_msg_list ) THEN

185:
186: END IF;
187:
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF FND_API.to_Boolean( p_init_msg_list ) THEN
190: fnd_msg_pub.initialize;
191: END IF;
192:
193: /* 5283886 - initialize ar_raapi_util */

Line 197: x_return_status := FND_API.G_RET_STS_SUCCESS;

193: /* 5283886 - initialize ar_raapi_util */
194: ar_raapi_util.constant_system_values;
195:
196: -- Initialize API return status to success
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: /* Parent or target lines */
200: FOR p_line_rec IN parent_lines LOOP
201: IF pg_debug IN ('Y','C')

Line 349: WHEN fnd_api.g_exc_error THEN

345: arp_debug.debug('ar_deferral_reasons_grp.record_acceptance()-');
346: END IF;
347:
348: EXCEPTION
349: WHEN fnd_api.g_exc_error THEN
350: arp_debug.debug('EXCEPTION: fnd_api.g_exc_error');
351: ROLLBACK TO record_acceptance_grp;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: fnd_msg_pub.count_and_get (

Line 350: arp_debug.debug('EXCEPTION: fnd_api.g_exc_error');

346: END IF;
347:
348: EXCEPTION
349: WHEN fnd_api.g_exc_error THEN
350: arp_debug.debug('EXCEPTION: fnd_api.g_exc_error');
351: ROLLBACK TO record_acceptance_grp;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: fnd_msg_pub.count_and_get (
354: p_encoded => fnd_api.g_false,

Line 352: x_return_status := FND_API.G_RET_STS_ERROR ;

348: EXCEPTION
349: WHEN fnd_api.g_exc_error THEN
350: arp_debug.debug('EXCEPTION: fnd_api.g_exc_error');
351: ROLLBACK TO record_acceptance_grp;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: fnd_msg_pub.count_and_get (
354: p_encoded => fnd_api.g_false,
355: p_count => x_msg_count,
356: p_data => x_msg_data);

Line 354: p_encoded => fnd_api.g_false,

350: arp_debug.debug('EXCEPTION: fnd_api.g_exc_error');
351: ROLLBACK TO record_acceptance_grp;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: fnd_msg_pub.count_and_get (
354: p_encoded => fnd_api.g_false,
355: p_count => x_msg_count,
356: p_data => x_msg_data);
357:
358: WHEN fnd_api.g_exc_unexpected_error THEN

Line 358: WHEN fnd_api.g_exc_unexpected_error THEN

354: p_encoded => fnd_api.g_false,
355: p_count => x_msg_count,
356: p_data => x_msg_data);
357:
358: WHEN fnd_api.g_exc_unexpected_error THEN
359: arp_debug.debug('EXCEPTION: fnd_api.g_exc_unexpected_error');
360: ROLLBACK TO record_acceptance_grp;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: fnd_msg_pub.count_and_get (

Line 359: arp_debug.debug('EXCEPTION: fnd_api.g_exc_unexpected_error');

355: p_count => x_msg_count,
356: p_data => x_msg_data);
357:
358: WHEN fnd_api.g_exc_unexpected_error THEN
359: arp_debug.debug('EXCEPTION: fnd_api.g_exc_unexpected_error');
360: ROLLBACK TO record_acceptance_grp;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: fnd_msg_pub.count_and_get (
363: p_encoded => fnd_api.g_false,

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357:
358: WHEN fnd_api.g_exc_unexpected_error THEN
359: arp_debug.debug('EXCEPTION: fnd_api.g_exc_unexpected_error');
360: ROLLBACK TO record_acceptance_grp;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: fnd_msg_pub.count_and_get (
363: p_encoded => fnd_api.g_false,
364: p_count => x_msg_count,
365: p_data => x_msg_data);

Line 363: p_encoded => fnd_api.g_false,

359: arp_debug.debug('EXCEPTION: fnd_api.g_exc_unexpected_error');
360: ROLLBACK TO record_acceptance_grp;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: fnd_msg_pub.count_and_get (
363: p_encoded => fnd_api.g_false,
364: p_count => x_msg_count,
365: p_data => x_msg_data);
366:
367: WHEN OTHERS THEN

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

366:
367: WHEN OTHERS THEN
368: arp_debug.debug('EXCEPTION: Others');
369: ROLLBACK TO record_acceptance_grp;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: fnd_msg_pub.count_and_get (
372: p_encoded => fnd_api.g_false,
373: p_count => x_msg_count,
374: p_data => x_msg_data);

Line 372: p_encoded => fnd_api.g_false,

368: arp_debug.debug('EXCEPTION: Others');
369: ROLLBACK TO record_acceptance_grp;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: fnd_msg_pub.count_and_get (
372: p_encoded => fnd_api.g_false,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:
376: END record_acceptance;

Line 381: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

377:
378:
379: PROCEDURE record_proof_of_delivery (
380: p_api_version IN NUMBER,
381: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
382: p_commit IN VARCHAR2 := fnd_api.g_false,
383: p_delivery_id IN NUMBER,
384: p_pod_date IN DATE,
385: x_return_status OUT NOCOPY VARCHAR2,

Line 382: p_commit IN VARCHAR2 := fnd_api.g_false,

378:
379: PROCEDURE record_proof_of_delivery (
380: p_api_version IN NUMBER,
381: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
382: p_commit IN VARCHAR2 := fnd_api.g_false,
383: p_delivery_id IN NUMBER,
384: p_pod_date IN DATE,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,

Line 421: IF NOT FND_API.Compatible_API_Call (

417: -- Standard Start of API savepoint
418: SAVEPOINT record_proof_of_delivery_grp;
419:
420: -- Standard call to check for call compatibility.
421: IF NOT FND_API.Compatible_API_Call (
422: p_current_version_number => l_api_version,
423: p_caller_version_number => p_api_version,
424: p_api_name => l_api_name,
425: p_pkg_name => g_pkg_name) THEN

Line 427: RAISE fnd_api.g_exc_unexpected_error;

423: p_caller_version_number => p_api_version,
424: p_api_name => l_api_name,
425: p_pkg_name => g_pkg_name) THEN
426:
427: RAISE fnd_api.g_exc_unexpected_error;
428:
429: END IF;
430:
431: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 432: IF FND_API.to_Boolean( p_init_msg_list ) THEN

428:
429: END IF;
430:
431: -- Initialize message list if p_init_msg_list is set to TRUE.
432: IF FND_API.to_Boolean( p_init_msg_list ) THEN
433: fnd_msg_pub.initialize;
434: END IF;
435:
436: -- Initialize API return status to success

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433: fnd_msg_pub.initialize;
434: END IF;
435:
436: -- Initialize API return status to success
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: -- event name: oracle.apps.fte.delivery.pod.podreceived
440: -- l_delivery_id := p_event.GetValueForParameter('DELIVERY_ID');
441: -- l_pod_date := p_event.GetValueForParameter('POD_DATE');

Line 458: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

454: , x_msg_count => x_msg_count
455: , x_msg_data => x_msg_data
456: );
457:
458: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
459: THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462:

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456: );
457:
458: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
459: THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462:
463: -- for each invoice line call ar_revenue_managemet_id with
464: -- invoice line id andpod date

Line 478: WHEN fnd_api.g_exc_error THEN

474:
475: END LOOP;
476:
477: EXCEPTION
478: WHEN fnd_api.g_exc_error THEN
479: ROLLBACK TO record_proof_of_delivery_grp;
480: x_return_status := FND_API.G_RET_STS_ERROR ;
481: fnd_msg_pub.count_and_get (
482: p_encoded => fnd_api.g_false,

Line 480: x_return_status := FND_API.G_RET_STS_ERROR ;

476:
477: EXCEPTION
478: WHEN fnd_api.g_exc_error THEN
479: ROLLBACK TO record_proof_of_delivery_grp;
480: x_return_status := FND_API.G_RET_STS_ERROR ;
481: fnd_msg_pub.count_and_get (
482: p_encoded => fnd_api.g_false,
483: p_count => x_msg_count,
484: p_data => x_msg_data);

Line 482: p_encoded => fnd_api.g_false,

478: WHEN fnd_api.g_exc_error THEN
479: ROLLBACK TO record_proof_of_delivery_grp;
480: x_return_status := FND_API.G_RET_STS_ERROR ;
481: fnd_msg_pub.count_and_get (
482: p_encoded => fnd_api.g_false,
483: p_count => x_msg_count,
484: p_data => x_msg_data);
485:
486: WHEN fnd_api.g_exc_unexpected_error THEN

Line 486: WHEN fnd_api.g_exc_unexpected_error THEN

482: p_encoded => fnd_api.g_false,
483: p_count => x_msg_count,
484: p_data => x_msg_data);
485:
486: WHEN fnd_api.g_exc_unexpected_error THEN
487: ROLLBACK TO record_proof_of_delivery_grp;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: fnd_msg_pub.count_and_get (
490: p_encoded => fnd_api.g_false,

Line 488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

484: p_data => x_msg_data);
485:
486: WHEN fnd_api.g_exc_unexpected_error THEN
487: ROLLBACK TO record_proof_of_delivery_grp;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: fnd_msg_pub.count_and_get (
490: p_encoded => fnd_api.g_false,
491: p_count => x_msg_count,
492: p_data => x_msg_data);

Line 490: p_encoded => fnd_api.g_false,

486: WHEN fnd_api.g_exc_unexpected_error THEN
487: ROLLBACK TO record_proof_of_delivery_grp;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: fnd_msg_pub.count_and_get (
490: p_encoded => fnd_api.g_false,
491: p_count => x_msg_count,
492: p_data => x_msg_data);
493:
494: WHEN OTHERS THEN

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

492: p_data => x_msg_data);
493:
494: WHEN OTHERS THEN
495: ROLLBACK TO record_proof_of_delivery_grp;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: fnd_msg_pub.count_and_get (
498: p_encoded => fnd_api.g_false,
499: p_count => x_msg_count,
500: p_data => x_msg_data);

Line 498: p_encoded => fnd_api.g_false,

494: WHEN OTHERS THEN
495: ROLLBACK TO record_proof_of_delivery_grp;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: fnd_msg_pub.count_and_get (
498: p_encoded => fnd_api.g_false,
499: p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: END record_proof_of_delivery;