173: exception
174:
175: WHEN FND_API.G_EXC_ERROR THEN
176:
177: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
178: P_MODULE => l_module
179: ,P_API_NAME => L_API_NAME
180: ,P_PKG_NAME => G_PKG_NAME
181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
178: P_MODULE => l_module
179: ,P_API_NAME => L_API_NAME
180: ,P_PKG_NAME => G_PKG_NAME
181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
182: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
183: ,X_MSG_COUNT => P_MSG_COUNT
184: ,X_MSG_DATA => P_MSG_DATA
185: ,X_RETURN_STATUS => P_RETURN_STATUS);
186:
185: ,X_RETURN_STATUS => P_RETURN_STATUS);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188:
189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
190: P_MODULE => l_module
191: ,P_API_NAME => L_API_NAME
192: ,P_PKG_NAME => G_PKG_NAME
193: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
190: P_MODULE => l_module
191: ,P_API_NAME => L_API_NAME
192: ,P_PKG_NAME => G_PKG_NAME
193: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
194: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
195: ,X_MSG_COUNT => P_MSG_COUNT
196: ,X_MSG_DATA => P_MSG_DATA
197: ,X_RETURN_STATUS => P_RETURN_STATUS);
198:
197: ,X_RETURN_STATUS => P_RETURN_STATUS);
198:
199: WHEN OTHERS THEN
200:
201: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
202: P_MODULE => l_module
203: ,P_API_NAME => L_API_NAME
204: ,P_PKG_NAME => G_PKG_NAME
205: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
201: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
202: P_MODULE => l_module
203: ,P_API_NAME => L_API_NAME
204: ,P_PKG_NAME => G_PKG_NAME
205: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
206: ,P_SQLCODE => SQLCODE
207: ,P_SQLERRM => SQLERRM
208: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
209: ,X_MSG_COUNT => P_MSG_COUNT
204: ,P_PKG_NAME => G_PKG_NAME
205: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
206: ,P_SQLCODE => SQLCODE
207: ,P_SQLERRM => SQLERRM
208: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
209: ,X_MSG_COUNT => P_MSG_COUNT
210: ,X_MSG_DATA => P_MSG_DATA
211: ,X_RETURN_STATUS => P_RETURN_STATUS);
212:
423:
424: EXCEPTION
425:
426: WHEN FND_API.G_EXC_ERROR THEN
427: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
428: P_MODULE => l_module
429: ,P_API_NAME => L_API_NAME
430: ,P_PKG_NAME => G_PKG_NAME
431: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
428: P_MODULE => l_module
429: ,P_API_NAME => L_API_NAME
430: ,P_PKG_NAME => G_PKG_NAME
431: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
432: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
433: ,X_MSG_COUNT => X_MSG_COUNT
434: ,X_MSG_DATA => X_MSG_DATA
435: ,X_RETURN_STATUS => X_RETURN_STATUS);
436:
434: ,X_MSG_DATA => X_MSG_DATA
435: ,X_RETURN_STATUS => X_RETURN_STATUS);
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
439: P_MODULE => l_module
440: ,P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
439: P_MODULE => l_module
440: ,P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
443: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);
447:
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);
447:
448: WHEN OTHERS THEN
449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
450: P_MODULE => l_module
451: ,P_API_NAME => L_API_NAME
452: ,P_PKG_NAME => G_PKG_NAME
453: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
450: P_MODULE => l_module
451: ,P_API_NAME => L_API_NAME
452: ,P_PKG_NAME => G_PKG_NAME
453: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
454: ,P_SQLCODE => SQLCODE
455: ,P_SQLERRM => SQLERRM
456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
457: ,X_MSG_COUNT => X_MSG_COUNT
452: ,P_PKG_NAME => G_PKG_NAME
453: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
454: ,P_SQLCODE => SQLCODE
455: ,P_SQLERRM => SQLERRM
456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
457: ,X_MSG_COUNT => X_MSG_COUNT
458: ,X_MSG_DATA => X_MSG_DATA
459: ,X_RETURN_STATUS => X_RETURN_STATUS);
460:
991: END IF;
992:
993: -- Debug Message
994: IF l_debug THEN
995: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
996: 'Public API: ' || l_api_name || 'start');
997:
998: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
999: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
994: IF l_debug THEN
995: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
996: 'Public API: ' || l_api_name || 'start');
997:
998: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
999: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1000: END IF;
1001:
1002: -- Initialize API return status to SUCCESS
1005: --
1006: -- API body
1007: --
1008: IF l_debug THEN
1009: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1010: 'Public API: Calling AS_ACCESS_PVT.delete_interest');
1011: END IF;
1012:
1013: l_interest_rec.interest_id := p_interest_rec.interest_id;
1050:
1051:
1052: -- Debug Message
1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1055: 'Public API: ' || l_api_name || 'end');
1056:
1057: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1058: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1055: 'Public API: ' || l_api_name || 'end');
1056:
1057: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1058: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1059: END IF;
1060:
1061:
1065: );
1066:
1067: EXCEPTION
1068: WHEN FND_API.G_EXC_ERROR THEN
1069: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1070: P_MODULE => l_module
1071: ,P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME
1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1070: P_MODULE => l_module
1071: ,P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME
1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1074: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1075: ,X_MSG_COUNT => X_MSG_COUNT
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);
1078:
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1081: P_MODULE => l_module
1082: ,P_API_NAME => L_API_NAME
1083: ,P_PKG_NAME => G_PKG_NAME
1084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1081: P_MODULE => l_module
1082: ,P_API_NAME => L_API_NAME
1083: ,P_PKG_NAME => G_PKG_NAME
1084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1085: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1086: ,X_MSG_COUNT => X_MSG_COUNT
1087: ,X_MSG_DATA => X_MSG_DATA
1088: ,X_RETURN_STATUS => X_RETURN_STATUS);
1089:
1087: ,X_MSG_DATA => X_MSG_DATA
1088: ,X_RETURN_STATUS => X_RETURN_STATUS);
1089:
1090: WHEN OTHERS THEN
1091: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1092: P_MODULE => l_module
1093: ,P_API_NAME => L_API_NAME
1094: ,P_PKG_NAME => G_PKG_NAME
1095: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1091: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1092: P_MODULE => l_module
1093: ,P_API_NAME => L_API_NAME
1094: ,P_PKG_NAME => G_PKG_NAME
1095: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1096: ,P_SQLCODE => SQLCODE
1097: ,P_SQLERRM => SQLERRM
1098: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1099: ,X_MSG_COUNT => X_MSG_COUNT
1094: ,P_PKG_NAME => G_PKG_NAME
1095: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1096: ,P_SQLCODE => SQLCODE
1097: ,P_SQLERRM => SQLERRM
1098: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1099: ,X_MSG_COUNT => X_MSG_COUNT
1100: ,X_MSG_DATA => X_MSG_DATA
1101: ,X_RETURN_STATUS => X_RETURN_STATUS);
1102: