[Home] [Help]
102: EXCEPTION
103:
104: WHEN FND_API.G_EXC_ERROR THEN
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: -- Standard call to get message count and if count=1, get the message
107: FND_MSG_PUB.Count_And_Get (
108: p_encoded => FND_API.G_FALSE,
109: p_count => x_msg_count,
110: p_data => x_msg_data
111: );
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: -- Standard call to get message count and if count=1, get the message
116: FND_MSG_PUB.Count_And_Get (
117: p_encoded => FND_API.G_FALSE,
118: p_count => x_msg_count,
119: p_data => x_msg_data
124: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message
129: FND_MSG_PUB.Count_And_Get (
130: p_encoded => FND_API.G_FALSE,
131: p_count => x_msg_count,
132: p_data => x_msg_data
368:
369:
370: BEGIN
371:
372: -- Standard Start of API savepoint
373: --SAVEPOINT validate_quota_threshold;
374:
375: -- Debug Message
376: IF G_DEBUG THEN
993: l_api_name CONSTANT VARCHAR2(30) := 'operation_result';
994:
995:
996: BEGIN
997: -- Standard call to check for call compatibility.
998: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
999: p_api_version_number,
1000: l_api_name,
1001: G_PKG_NAME)
1042: END IF; -- for main IF/ELSIF
1043:
1044: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1045:
1046: -- Standard call to get message count and if count is 1, get message info.
1047: FND_MSG_PUB.Count_And_Get
1048: (p_count => x_msg_count,
1049: p_data => x_msg_data
1050: );
1052: EXCEPTION
1053:
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: -- Standard call to get message count and if count=1, get the message
1057: FND_MSG_PUB.Count_And_Get (
1058: p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );
1062:
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: -- Standard call to get message count and if count=1, get the message
1066: FND_MSG_PUB.Count_And_Get (
1067: p_encoded => FND_API.G_FALSE,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1074: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1077: END IF;
1078: -- Standard call to get message count and if count=1, get the message
1079: FND_MSG_PUB.Count_And_Get (
1080: p_encoded => FND_API.G_FALSE,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1094: -- p_frequency_period IN VARCHAR2 -- MONTHLY or DAILY
1095: -- p_repeat_frequency IN NUMBER
1096: -- It is a number . It signifies the frequency of resending the notifications
1097: -- p_rule_start_date IN DATE
1098: -- Standard Out params
1099: -- x_msg_count OUT NUMBER
1100: -- x_msg_data OUT VARCHAR2
1101: -- x_return_status OUT VARCHAR2
1102: -- x_result OUT VARCHAR2 -- NOTIFY OR NO_NOTIFY
1135: AND budget_id = x_budget_id
1136: AND threshold_id = x_threshold_id;
1137:
1138: BEGIN
1139: -- Standard call to check for call compatibility.
1140: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1141: p_api_version_number,
1142: l_api_name,
1143: G_PKG_NAME)
1200: IF G_DEBUG THEN
1201: OZF_UTILITY_PVT.debug_message('Private API: Notified day' || l_notify_freq_days || ' end ' ||x_result );
1202: END IF;
1203:
1204: -- Standard call to get message count and if count is 1, get message info.
1205: FND_MSG_PUB.Count_And_Get
1206: (p_count => x_msg_count,
1207: p_data => x_msg_data
1208: );
1209: EXCEPTION
1210:
1211: WHEN FND_API.G_EXC_ERROR THEN
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data
1231: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1232: THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,
1238: p_count => x_msg_count,
1239: p_data => x_msg_data
1271: SELECT ozf_quota_alerts_s.NEXTVAL
1272: FROM DUAL;
1273:
1274: BEGIN
1275: -- Standard call to check for call compatibility.
1276: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1277: p_api_version_number,
1278: l_api_name,
1279: G_PKG_NAME)
1397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1398: THEN
1399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1400: END IF;
1401: -- Standard call to get message count and if count=1, get the message
1402: FND_MSG_PUB.Count_And_Get (
1403: p_encoded => FND_API.G_FALSE,
1404: p_count => x_msg_count,
1405: p_data => x_msg_data
1494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1495: THEN
1496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1497: END IF;
1498: -- Standard call to get message count and if count=1, get the message
1499: FND_MSG_PUB.Count_And_Get (
1500: p_encoded => FND_API.G_FALSE,
1501: p_count => x_msg_count,
1502: p_data => x_msg_data
1568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1569: THEN
1570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1571: END IF;
1572: -- Standard call to get message count and if count=1, get the message
1573: FND_MSG_PUB.Count_And_Get (
1574: p_encoded => FND_API.G_FALSE,
1575: p_count => x_msg_count,
1576: p_data => x_msg_data
1581:
1582:
1583: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1584:
1585: -- Standard call to get message count and if count is 1, get message info.
1586: FND_MSG_PUB.Count_And_Get
1587: (p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );
1593: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1594: THEN
1595: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1596: END IF;
1597: -- Standard call to get message count and if count=1, get the message
1598: FND_MSG_PUB.Count_And_Get (
1599: p_encoded => FND_API.G_FALSE,
1600: p_count => x_msg_count,
1601: p_data => x_msg_data