80:
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list )
83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86:
87:
88: -- Initialize API return status to SUCCESS
95: -- Validate Environment
96: -- ******************************************************************
97: IF FND_GLOBAL.User_Id IS NULL
98: THEN
99: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
100: THEN
101: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
102: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
103: FND_MSG_PUB.ADD;
99: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
100: THEN
101: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
102: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
103: FND_MSG_PUB.ADD;
104: END IF;
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: -- IF PG_DEBUG < 10 THEN
128: IF (p_case_contact_rec.cas_id IS NULL) OR (p_case_contact_rec.cas_ID = FND_API.G_MISS_NUM) THEN
129: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
130: fnd_message.set_token('API_NAME', l_api_name);
131: fnd_message.set_token('MISSING_PARAM', 'cas_id');
132: fnd_msg_pub.add;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
140: IF (p_case_contact_rec.contact_party_id IS NULL) OR (p_case_contact_rec.contact_party_id = FND_API.G_MISS_NUM) THEN
141: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
142: fnd_message.set_token('API_NAME', l_api_name);
143: fnd_message.set_token('MISSING_PARAM', 'contact_party_id');
144: fnd_msg_pub.add;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: -- IF PG_DEBUG < 10 THEN
148: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
239:
240:
241:
242: -- Standard call to get message count and if count is 1, get message info.
243: FND_MSG_PUB.Count_And_Get
244: ( p_count => x_msg_count,
245: p_data => x_msg_data
246: );
247: -- IF PG_DEBUG < 10 THEN
252: WHEN FND_API.G_EXC_ERROR THEN
253: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
254: P_API_NAME => L_API_NAME
255: ,P_PKG_NAME => G_PKG_NAME
256: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
257: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
258: ,X_MSG_COUNT => X_MSG_COUNT
259: ,X_MSG_DATA => X_MSG_DATA
260: ,X_RETURN_STATUS => X_RETURN_STATUS);
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
264: P_API_NAME => L_API_NAME
265: ,P_PKG_NAME => G_PKG_NAME
266: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
268: ,X_MSG_COUNT => X_MSG_COUNT
269: ,X_MSG_DATA => X_MSG_DATA
270: ,X_RETURN_STATUS => X_RETURN_STATUS);
321:
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean( p_init_msg_list )
324: THEN
325: FND_MSG_PUB.initialize;
326: END IF;
327:
328:
329:
389:
390:
391:
392: -- Standard call to get message count and if count is 1, get message info.
393: FND_MSG_PUB.Count_And_Get
394: ( p_count => x_msg_count,
395: p_data => x_msg_data
396: );
397: -- IF PG_DEBUG < 10 THEN
402: WHEN FND_API.G_EXC_ERROR THEN
403: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
404: P_API_NAME => L_API_NAME
405: ,P_PKG_NAME => G_PKG_NAME
406: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
407: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
408: ,X_MSG_COUNT => X_MSG_COUNT
409: ,X_MSG_DATA => X_MSG_DATA
410: ,X_RETURN_STATUS => X_RETURN_STATUS);
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME
415: ,P_PKG_NAME => G_PKG_NAME
416: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
417: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
418: ,X_MSG_COUNT => X_MSG_COUNT
419: ,X_MSG_DATA => X_MSG_DATA
420: ,X_RETURN_STATUS => X_RETURN_STATUS);
470:
471: -- Initialize message list if p_init_msg_list is set to TRUE.
472: IF FND_API.to_Boolean( p_init_msg_list )
473: THEN
474: FND_MSG_PUB.initialize;
475: END IF;
476:
477: -- Initialize API return status to SUCCESS
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497:
498:
499: -- Standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504: -- IF PG_DEBUG < 10 THEN
509: WHEN FND_API.G_EXC_ERROR THEN
510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
511: P_API_NAME => L_API_NAME
512: ,P_PKG_NAME => G_PKG_NAME
513: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
514: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
515: ,X_MSG_COUNT => X_MSG_COUNT
516: ,X_MSG_DATA => X_MSG_DATA
517: ,X_RETURN_STATUS => X_RETURN_STATUS);
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
521: P_API_NAME => L_API_NAME
522: ,P_PKG_NAME => G_PKG_NAME
523: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
524: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
525: ,X_MSG_COUNT => X_MSG_COUNT
526: ,X_MSG_DATA => X_MSG_DATA
527: ,X_RETURN_STATUS => X_RETURN_STATUS);