APPS.AS_LEAD_ROUTING_WF_CUHK dependencies on AS_UTILITY_PVT

Line 175: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

171: FND_MSG_PUB.initialize;
172: END IF;
173:
174: -- Debug Message
175: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
176: 'PVT:' || l_api_name || ' Start');
177:
178: -- Initialize API return status to SUCCESS
179: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 192: AS_UTILITY_PVT.Set_Message(

188: IF FND_GLOBAL.User_Id IS NULL
189: THEN
190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
191: THEN
192: AS_UTILITY_PVT.Set_Message(
193: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
194: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
195: p_token1 => 'PROFILE',
196: p_token1_value => 'USER_ID');

Line 219: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

215:
216: IF l_resource_id IS NULL
217: THEN
218:
219: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
220: 'There''s no Telesales Agent');
221: OPEN c_get_terr_resource2(p_sales_lead_rec.sales_lead_id,
222: l_customer_id, l_address_id, 'LEAD',
223: 'ACCOUNT');

Line 255: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

251: COMMIT WORK;
252: END IF;
253:
254: -- Debug Message
255: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
256: 'PVT: ' || l_api_name || ' End');
257:
258: -- Standard call to get message count and IF count is 1, get message info.
259: FND_MSG_PUB.Count_And_Get

Line 265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

261: p_data => x_msg_data );
262:
263: EXCEPTION
264: WHEN FND_API.G_EXC_ERROR THEN
265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
266: P_API_NAME => L_API_NAME
267: ,P_PKG_NAME => G_PKG_NAME
268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
266: P_API_NAME => L_API_NAME
267: ,P_PKG_NAME => G_PKG_NAME
268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
270: ,X_MSG_COUNT => X_MSG_COUNT
271: ,X_MSG_DATA => X_MSG_DATA
272: ,X_RETURN_STATUS => X_RETURN_STATUS);
273:

Line 275: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

271: ,X_MSG_DATA => X_MSG_DATA
272: ,X_RETURN_STATUS => X_RETURN_STATUS);
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
276: P_API_NAME => L_API_NAME
277: ,P_PKG_NAME => G_PKG_NAME
278: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
279: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 279: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

275: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
276: P_API_NAME => L_API_NAME
277: ,P_PKG_NAME => G_PKG_NAME
278: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
279: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
280: ,X_MSG_COUNT => X_MSG_COUNT
281: ,X_MSG_DATA => X_MSG_DATA
282: ,X_RETURN_STATUS => X_RETURN_STATUS);
283:

Line 285: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

281: ,X_MSG_DATA => X_MSG_DATA
282: ,X_RETURN_STATUS => X_RETURN_STATUS);
283:
284: WHEN OTHERS THEN
285: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
286: P_API_NAME => L_API_NAME
287: ,P_PKG_NAME => G_PKG_NAME
288: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
289: ,P_SQLCODE => SQLCODE

Line 288: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

284: WHEN OTHERS THEN
285: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
286: P_API_NAME => L_API_NAME
287: ,P_PKG_NAME => G_PKG_NAME
288: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
289: ,P_SQLCODE => SQLCODE
290: ,P_SQLERRM => SQLERRM
291: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
292: ,X_MSG_COUNT => X_MSG_COUNT

Line 291: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

287: ,P_PKG_NAME => G_PKG_NAME
288: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
289: ,P_SQLCODE => SQLCODE
290: ,P_SQLERRM => SQLERRM
291: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
292: ,X_MSG_COUNT => X_MSG_COUNT
293: ,X_MSG_DATA => X_MSG_DATA
294: ,X_RETURN_STATUS => X_RETURN_STATUS);
295: END Get_Owner_Pre;