[Home] [Help]
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,
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,
118: p_data => x_msg_data
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;
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
243: FROM ozf_fund_details_v
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)
345: x_result := l_commit_amt;
346:
347: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
348:
349: -- Standard call to get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: (p_count => x_msg_count,
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,
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,
370: p_count => x_msg_count,
371: p_data => x_msg_data
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;
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
453: FROM ozf_fund_details_v
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)
551: END IF;
552:
553: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
554:
555: -- Standard call to get message count and if count is 1, get message info.
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count,
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,
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,
576: p_count => x_msg_count,
577: p_data => x_msg_data
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;
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
612: l_api_name CONSTANT VARCHAR2(30) := 'operation_result';
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)
662: END IF; -- for main IF/ELSIF
663:
664: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
665:
666: -- Standard call to get message count and if count is 1, get message info.
667: FND_MSG_PUB.Count_And_Get
668: (p_count => x_msg_count,
669: p_data => x_msg_data
670: );
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,
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,
689: p_data => x_msg_data
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;
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
714: -- p_frequency_period IN VARCHAR2 -- MONTHLY or DAILY
715: -- p_repeat_frequency IN NUMBER
716: -- It is a number . It signifies the frequency of resending the notifications
717: -- p_rule_start_date IN DATE
718: -- Standard Out params
719: -- x_msg_count OUT NUMBER
720: -- x_msg_data OUT VARCHAR2
721: -- x_return_status OUT VARCHAR2
722: -- x_result OUT VARCHAR2 -- NOTIFY OR NO_NOTIFY
755: AND budget_id = x_budget_id
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)
821: IF G_DEBUG THEN
822: OZF_UTILITY_PVT.debug_message('Private API: Notified day' || l_notify_freq_days || ' end ' ||x_result );
823: END IF;
824:
825: -- Standard call to get message count and if count is 1, get message info.
826: FND_MSG_PUB.Count_And_Get
827: (p_count => x_msg_count,
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,
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,
846: p_count => x_msg_count,
847: p_data => x_msg_data
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;
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
1019:
1020:
1021: BEGIN
1022:
1023: -- Standard Start of API savepoint
1024: SAVEPOINT VALIDATE_THRESHOLD_RULE_PVT;
1025:
1026: -- Debug Message
1027: IF G_DEBUG THEN