eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_THRESHOLD_PVT dependencies on FND_API

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: END IF;
58:
59:
60: -- Initialize API return status to SUCCESS
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: fnd_message.set_name('OZF', 'OZF_THRESHOLD_SUBJECT');
64: l_strSubject := fnd_message.get;
65: fnd_message.set_name('OZF', 'OZF_THRESHOLD_CHILDSUBJ');

Line 82: IF l_return_status <> fnd_api.g_ret_sts_success THEN

78: ,x_notif_id => l_notification_id
79: ,x_return_status => l_return_status
80: );
81:
82: IF l_return_status <> fnd_api.g_ret_sts_success THEN
83: RAISE fnd_api.g_exc_error;
84: END IF;
85:
86:

Line 83: RAISE fnd_api.g_exc_error;

79: ,x_return_status => l_return_status
80: );
81:
82: IF l_return_status <> fnd_api.g_ret_sts_success THEN
83: RAISE fnd_api.g_exc_error;
84: END IF;
85:
86:
87: IF p_parent_owner_id <>0 THEN

Line 97: IF l_return_status <> fnd_api.g_ret_sts_success THEN

93: ,x_return_status => l_return_status
94: );
95: END IF;
96:
97: IF l_return_status <> fnd_api.g_ret_sts_success THEN
98: RAISE fnd_api.g_exc_error;
99: END IF;
100:
101: EXCEPTION

Line 98: RAISE fnd_api.g_exc_error;

94: );
95: END IF;
96:
97: IF l_return_status <> fnd_api.g_ret_sts_success THEN
98: RAISE fnd_api.g_exc_error;
99: END IF;
100:
101: EXCEPTION
102:

Line 103: WHEN FND_API.G_EXC_ERROR THEN

99: END IF;
100:
101: EXCEPTION
102:
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: -- Standard call to get message count and if count=1, get the message
106: FND_MSG_PUB.Count_And_Get (
107: p_encoded => FND_API.G_FALSE,

Line 104: x_return_status := FND_API.G_RET_STS_ERROR;

100:
101: EXCEPTION
102:
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: -- Standard call to get message count and if count=1, get the message
106: FND_MSG_PUB.Count_And_Get (
107: p_encoded => FND_API.G_FALSE,
108: p_count => x_msg_count,

Line 107: p_encoded => FND_API.G_FALSE,

103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: -- Standard call to get message count and if count=1, get the message
106: FND_MSG_PUB.Count_And_Get (
107: p_encoded => FND_API.G_FALSE,
108: p_count => x_msg_count,
109: p_data => x_msg_data
110: );
111:

Line 112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

108: p_count => x_msg_count,
109: p_data => x_msg_data
110: );
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: -- Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

109: p_data => x_msg_data
110: );
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: -- Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
117: p_count => x_msg_count,

Line 116: p_encoded => FND_API.G_FALSE,

112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: -- Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data
119: );
120:

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

118: p_data => x_msg_data
119: );
120:
121: WHEN OTHERS THEN
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
124: THEN
125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
126: END IF;

Line 129: p_encoded => FND_API.G_FALSE,

125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
126: END IF;
127: -- Standard call to get message count and if count=1, get the message
128: FND_MSG_PUB.Count_And_Get (
129: p_encoded => FND_API.G_FALSE,
130: p_count => x_msg_count,
131: p_data => x_msg_data
132: );
133: END start_process; /* START_PROCESS */

Line 173: RAISE Fnd_Api.g_exc_error;

169:
170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: RAISE Fnd_Api.g_exc_error;
174: ozf_utility_pvt.debug_message('Exception in raising business event');
175: END;
176:
177:

Line 187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

183:
184: -----------------------------------------------------------------------
185: PROCEDURE value_limit
186: ( p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: X_Msg_Count OUT NOCOPY NUMBER,
189: X_Msg_Data OUT NOCOPY VARCHAR2,
190: x_return_status OUT NOCOPY VARCHAR2,
191: p_budget_id IN NUMBER,

Line 248: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

244: WHERE fund_id = p_budget_id;
245:
246: BEGIN
247: -- Standard call to check for call compatibility.
248: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
249: p_api_version_number,
250: l_api_name,
251: G_PKG_NAME)
252: THEN

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: p_api_version_number,
250: l_api_name,
251: G_PKG_NAME)
252: THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: -- IF FND_API.to_Boolean( p_init_msg_list )

Line 257: -- IF FND_API.to_Boolean( p_init_msg_list )

253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: -- IF FND_API.to_Boolean( p_init_msg_list )
258: -- THEN
259: -- FND_MSG_PUB.initialize;
260: -- END IF;
261:

Line 267: x_return_status := FND_API.G_RET_STS_SUCCESS;

263: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
264:
265:
266: -- Initialize API return status to SUCCESS
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268:
269: -- Derive the value_limit amount based on value_limit_type
270:
271: IF p_value_limit_type = 'COMMITTED' THEN

Line 356: WHEN FND_API.G_EXC_ERROR THEN

352: p_data => x_msg_data
353: );
354: EXCEPTION
355:
356: WHEN FND_API.G_EXC_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: -- Standard call to get message count and if count=1, get the message
359: FND_MSG_PUB.Count_And_Get (
360: -- p_encoded => FND_API.G_FALSE,

Line 357: x_return_status := FND_API.G_RET_STS_ERROR;

353: );
354: EXCEPTION
355:
356: WHEN FND_API.G_EXC_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: -- Standard call to get message count and if count=1, get the message
359: FND_MSG_PUB.Count_And_Get (
360: -- p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,

Line 360: -- p_encoded => FND_API.G_FALSE,

356: WHEN FND_API.G_EXC_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: -- Standard call to get message count and if count=1, get the message
359: FND_MSG_PUB.Count_And_Get (
360: -- p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364:

Line 365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: -- Standard call to get message count and if count=1, get the message
368: FND_MSG_PUB.Count_And_Get (
369: --p_encoded => FND_API.G_FALSE,

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: p_data => x_msg_data
363: );
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: -- Standard call to get message count and if count=1, get the message
368: FND_MSG_PUB.Count_And_Get (
369: --p_encoded => FND_API.G_FALSE,
370: p_count => x_msg_count,

Line 369: --p_encoded => FND_API.G_FALSE,

365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: -- Standard call to get message count and if count=1, get the message
368: FND_MSG_PUB.Count_And_Get (
369: --p_encoded => FND_API.G_FALSE,
370: p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373:

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: p_data => x_msg_data
372: );
373:
374: WHEN OTHERS THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
377: THEN
378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
379: END IF;

Line 382: -- p_encoded => FND_API.G_FALSE,

378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
379: END IF;
380: -- Standard call to get message count and if count=1, get the message
381: FND_MSG_PUB.Count_And_Get (
382: -- p_encoded => FND_API.G_FALSE,
383: p_count => x_msg_count,
384: p_data => x_msg_data
385: );
386:

Line 397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

393:
394: -----------------------------------------------------------------------
395: PROCEDURE base_line_amt(
396: p_api_version_number IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: X_Msg_Count OUT NOCOPY NUMBER,
399: X_Msg_Data OUT NOCOPY VARCHAR2,
400: x_return_status OUT NOCOPY VARCHAR2,
401: p_budget_id IN NUMBER,

Line 458: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

454: WHERE fund_id = p_budget_id;
455:
456: BEGIN
457: -- Standard call to check for call compatibility.
458: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
459: p_api_version_number,
460: l_api_name,
461: G_PKG_NAME)
462: THEN

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: p_api_version_number,
460: l_api_name,
461: G_PKG_NAME)
462: THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list )

Line 467: IF FND_API.to_Boolean( p_init_msg_list )

463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list )
468: THEN
469: FND_MSG_PUB.initialize;
470: END IF;
471:

Line 477: x_return_status := FND_API.G_RET_STS_SUCCESS;

473: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
474:
475:
476: -- Initialize API return status to SUCCESS
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: IF p_base_line_type = 'BUDGET' THEN
480: -- Derive the percentage value on the base amount
481: OPEN c_budgeted_amt;

Line 562: WHEN FND_API.G_EXC_ERROR THEN

558: p_data => x_msg_data
559: );
560: EXCEPTION
561:
562: WHEN FND_API.G_EXC_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: );
560: EXCEPTION
561:
562: WHEN FND_API.G_EXC_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,

Line 566: p_encoded => FND_API.G_FALSE,

562: WHEN FND_API.G_EXC_ERROR THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,
568: p_data => x_msg_data
569: );
570:

Line 571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

567: p_count => x_msg_count,
568: p_data => x_msg_data
569: );
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: -- Standard call to get message count and if count=1, get the message
574: FND_MSG_PUB.Count_And_Get (
575: p_encoded => FND_API.G_FALSE,

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

568: p_data => x_msg_data
569: );
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: -- Standard call to get message count and if count=1, get the message
574: FND_MSG_PUB.Count_And_Get (
575: p_encoded => FND_API.G_FALSE,
576: p_count => x_msg_count,

Line 575: p_encoded => FND_API.G_FALSE,

571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: -- Standard call to get message count and if count=1, get the message
574: FND_MSG_PUB.Count_And_Get (
575: p_encoded => FND_API.G_FALSE,
576: p_count => x_msg_count,
577: p_data => x_msg_data
578: );
579:

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

577: p_data => x_msg_data
578: );
579:
580: WHEN OTHERS THEN
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
583: THEN
584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
585: END IF;

Line 588: p_encoded => FND_API.G_FALSE,

584: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
585: END IF;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,
589: p_count => x_msg_count,
590: p_data => x_msg_data
591: );
592: END base_line_amt;

Line 602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

598:
599: -----------------------------------------------------------------------
600: PROCEDURE operation_result(
601: p_api_version_number IN NUMBER,
602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
603: X_Msg_Count OUT NOCOPY NUMBER,
604: X_Msg_Data OUT NOCOPY VARCHAR2,
605: x_return_status OUT NOCOPY VARCHAR2,
606: p_lhs IN NUMBER,

Line 617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

613:
614:
615: BEGIN
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
621: THEN

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )

Line 626: IF FND_API.to_Boolean( p_init_msg_list )

622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )
627: THEN
628: FND_MSG_PUB.initialize;
629: END IF;
630:

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
633:
634:
635: -- Initialize API return status to SUCCESS
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638: -- Derive the result based on operator_code
639:
640: IF p_operator_code = '2' THEN

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670: );
671:
672: EXCEPTION
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671:
672: EXCEPTION
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,

Line 678: p_encoded => FND_API.G_FALSE,

674: WHEN FND_API.G_EXC_ERROR THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
682:

Line 683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

680: p_data => x_msg_data
681: );
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,

Line 687: p_encoded => FND_API.G_FALSE,

683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data
690: );
691:

Line 693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

689: p_data => x_msg_data
690: );
691:
692: WHEN OTHERS THEN
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;

Line 700: p_encoded => FND_API.G_FALSE,

696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );
704: END operation_result;

Line 710: -- p_init_msg_list IN VARCHAR2 := fnd_api.g_false

706: -- PROCEDURE
707: -- verify_notification
708: -- In Parozf
709: -- p_api_version_number IN NUMBER
710: -- p_init_msg_list IN VARCHAR2 := fnd_api.g_false
711: -- p_budget_id IN NUMBER -- budget to which the threshold applies
712: -- p_threshold_id IN NUMBER -- threshold_id
713: -- p_threshold_rule_id IN NUMBER -- threhold_rule_id
714: -- p_frequency_period IN VARCHAR2 -- MONTHLY or DAILY

Line 730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

726:
727: -----------------------------------------------------------------------
728: PROCEDURE verify_notification(
729: p_api_version_number IN NUMBER,
730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
731: X_Msg_Count OUT NOCOPY NUMBER,
732: X_Msg_Data OUT NOCOPY VARCHAR2,
733: x_return_status OUT NOCOPY VARCHAR2,
734: p_budget_id IN NUMBER,

Line 760: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

756: AND threshold_id = x_threshold_id;
757:
758: BEGIN
759: -- Standard call to check for call compatibility.
760: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
761: p_api_version_number,
762: l_api_name,
763: G_PKG_NAME)
764: THEN

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761: p_api_version_number,
762: l_api_name,
763: G_PKG_NAME)
764: THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: -- Initialize message list if p_init_msg_list is set to TRUE.
769: IF FND_API.to_Boolean( p_init_msg_list )

Line 769: IF FND_API.to_Boolean( p_init_msg_list )

765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: -- Initialize message list if p_init_msg_list is set to TRUE.
769: IF FND_API.to_Boolean( p_init_msg_list )
770: THEN
771: FND_MSG_PUB.initialize;
772: END IF;
773:

Line 779: x_return_status := FND_API.G_RET_STS_SUCCESS;

775: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
776:
777:
778: -- Initialize API return status to SUCCESS
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: IF p_frequency_period = 'DAILY' THEN
782: l_notify_freq_days := p_repeat_frequency;
783: END IF;

Line 832: WHEN FND_API.G_EXC_ERROR THEN

828: p_data => x_msg_data
829: );
830: EXCEPTION
831:
832: WHEN FND_API.G_EXC_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,

Line 833: x_return_status := FND_API.G_RET_STS_ERROR;

829: );
830: EXCEPTION
831:
832: WHEN FND_API.G_EXC_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,

Line 836: p_encoded => FND_API.G_FALSE,

832: WHEN FND_API.G_EXC_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840:

Line 841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,

Line 842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

838: p_data => x_msg_data
839: );
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,

Line 845: p_encoded => FND_API.G_FALSE,

841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );
849:

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

847: p_data => x_msg_data
848: );
849:
850: WHEN OTHERS THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
853: THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;

Line 858: p_encoded => FND_API.G_FALSE,

854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;
856: -- Standard call to get message count and if count=1, get the message
857: FND_MSG_PUB.Count_And_Get (
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data
861: );
862: END verify_notification;

Line 873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

869: -----------------------------------------------------------------------
870: PROCEDURE validate_threshold
871: ( /*p_api_version_number IN NUMBER,
872:
873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: x_msg_count OUT NOCOPY NUMBER,
877: x_msg_data OUT NOCOPY VARCHAR2,

Line 874: p_commit IN VARCHAR2 := FND_API.G_FALSE,

870: PROCEDURE validate_threshold
871: ( /*p_api_version_number IN NUMBER,
872:
873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: x_msg_count OUT NOCOPY NUMBER,
877: x_msg_data OUT NOCOPY VARCHAR2,
878: x_msg_buffer OUT NOCOPY VARCHAR2,

Line 875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

871: ( /*p_api_version_number IN NUMBER,
872:
873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: x_msg_count OUT NOCOPY NUMBER,
877: x_msg_data OUT NOCOPY VARCHAR2,
878: x_msg_buffer OUT NOCOPY VARCHAR2,
879: x_return_status OUT NOCOPY VARCHAR2

Line 1032: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

1028: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1029: END IF;
1030:
1031: -- Initialize API return status to SUCCESS
1032: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
1033:
1034: OPEN c_trans_seq;
1035: FETCH c_trans_seq INTO l_trans_id;
1036: CLOSE c_trans_seq;

Line 1045: FND_API.G_FALSE,

1041: FOR budget IN c_threshold_funds(rule.threshold_rule_id)
1042: LOOP
1043: BEGIN
1044: value_limit(l_api_version_number,
1045: FND_API.G_FALSE,
1046: l_Msg_Count,
1047: l_Msg_Data,
1048: l_return_status,
1049: budget.budget_id,

Line 1057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1053: IF G_DEBUG THEN
1054: OZF_UTILITY_PVT.debug_message('Value limit: ' || l_value_limit);
1055: END IF;
1056:
1057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:
1061: --l_value_limit is lhs for operation_result input.

Line 1058: RAISE FND_API.G_EXC_ERROR;

1054: OZF_UTILITY_PVT.debug_message('Value limit: ' || l_value_limit);
1055: END IF;
1056:
1057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060:
1061: --l_value_limit is lhs for operation_result input.
1062:

Line 1064: FND_API.G_FALSE,

1060:
1061: --l_value_limit is lhs for operation_result input.
1062:
1063: base_line_amt(l_api_version_number,
1064: FND_API.G_FALSE,
1065: l_Msg_Count,
1066: l_Msg_Data,
1067: l_return_status,
1068: budget.budget_id,

Line 1076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1072: IF G_DEBUG THEN
1073: OZF_UTILITY_PVT.debug_message('Base limit: ' || l_base_line_amt);
1074: END IF;
1075:
1076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079: --l_base_line_amt is rhs for operation_result imput.
1080:

Line 1077: RAISE FND_API.G_EXC_ERROR;

1073: OZF_UTILITY_PVT.debug_message('Base limit: ' || l_base_line_amt);
1074: END IF;
1075:
1076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079: --l_base_line_amt is rhs for operation_result imput.
1080:
1081: operation_result(l_api_version_number,

Line 1082: FND_API.G_FALSE,

1078: END IF;
1079: --l_base_line_amt is rhs for operation_result imput.
1080:
1081: operation_result(l_api_version_number,
1082: FND_API.G_FALSE,
1083: l_Msg_Count,
1084: l_Msg_Data,
1085: l_return_status,
1086: l_value_limit,

Line 1105: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1101: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
1102: l_operator_meaning := fnd_message.get;
1103: END IF;
1104:
1105: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: /* l_operation_result is deciding factor in calling verify_notification.
1109: if l_operation_result is 'VIOLATED' then we will call verify_notification

Line 1106: RAISE FND_API.G_EXC_ERROR;

1102: l_operator_meaning := fnd_message.get;
1103: END IF;
1104:
1105: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: /* l_operation_result is deciding factor in calling verify_notification.
1109: if l_operation_result is 'VIOLATED' then we will call verify_notification
1110: else if the l_opearation_result is 'NOT VIOLATED' then we will not call verify_notification*/

Line 1114: FND_API.G_FALSE,

1110: else if the l_opearation_result is 'NOT VIOLATED' then we will not call verify_notification*/
1111:
1112: IF l_operation_result = 'VIOLATED' THEN
1113: verify_notification( l_api_version_number,
1114: FND_API.G_FALSE,
1115: l_Msg_Count,
1116: l_Msg_Data,
1117: l_return_status,
1118: budget.budget_id,

Line 1126: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1122: budget.repeat_frequency,
1123: budget.rule_start_date,
1124: l_notification_result);
1125:
1126: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129: --l_notification_result will drive write_to_log
1130: IF G_DEBUG THEN

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123: budget.rule_start_date,
1124: l_notification_result);
1125:
1126: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129: --l_notification_result will drive write_to_log
1130: IF G_DEBUG THEN
1131: OZF_UTILITY_PVT.debug_message('Notify result: ' || l_notification_result );

Line 1175: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1171: l_trans_id,
1172: SYSDATE
1173: );
1174:
1175: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: END IF;
1179: END IF;

Line 1176: RAISE FND_API.G_EXC_ERROR;

1172: SYSDATE
1173: );
1174:
1175: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: END IF;
1179: END IF;
1180:

Line 1281: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1277: l_notify_table(i).message_text,
1278: l_log_id
1279: );
1280:
1281: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1282: RAISE FND_API.G_EXC_ERROR;
1283: END IF;
1284: END LOOP;
1285: END IF;

Line 1282: RAISE FND_API.G_EXC_ERROR;

1278: l_log_id
1279: );
1280:
1281: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1282: RAISE FND_API.G_EXC_ERROR;
1283: END IF;
1284: END LOOP;
1285: END IF;
1286:

Line 1306: RAISE FND_API.G_EXC_ERROR;

1302: IF l_retcode <> 0 THEN
1303: x_errbuf := l_errbuf;
1304: x_retcode := l_retcode;
1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN Quota Threshold ........ l_errbuf :' || l_errbuf);
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308: COMMIT;
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Quota Threshold ........ ');
1310: OZF_UTILITY_PVT.debug_message( 'End of Quota Threshold ........ ');

Line 1313: WHEN FND_API.G_EXC_ERROR THEN

1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Quota Threshold ........ ');
1310: OZF_UTILITY_PVT.debug_message( 'End of Quota Threshold ........ ');
1311: EXCEPTION
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_ERROR '||l_api_name);
1316: x_retcode := 1;
1317: x_errbuf := l_msg_data;

Line 1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1316: x_retcode := 1;
1317: x_errbuf := l_msg_data;
1318: ozf_utility_pvt.write_conc_log(x_errbuf);
1319:
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);
1323: x_retcode := 1;
1324: x_errbuf := l_msg_data;