DBA Data[Home] [Help]

APPS.AS_INTEREST_PUB dependencies on AS_UTILITY_PVT

Line 177: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 182: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 194: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 201: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 208: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 427: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 432: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 443: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 995: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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'));

Line 998: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1009: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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'));

Line 1057: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 1069: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1074: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1080: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1085: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1091: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 1098: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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: