DBA Data[Home] [Help]

APPS.CSM_PARTY_ASSIGNMENT_PKG dependencies on FND_API

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

56: THEN
57:
58: x_error_message := 'The party records does not exists in the HZ PARTIES base table for the party - '||p_party_id;
59:
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61:
62: ELSIF l_chk_party_site = 0
63:
64: THEN

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: THEN
65:
66: x_error_message := 'The party site records does not exists in the HZ PARTY SITES base table for the party - '||p_party_id|| ' and site -'||p_party_site_id;
67:
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69:
70: END IF;
71:
72: SELECT COUNT(1)

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: AND PARTY_SITE_ID = -2;
238:
239: END IF;
240:
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242: x_error_message := 'PARTY_ID successfully Inserted ';
243: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
244:
245: EXCEPTION

Line 247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

243: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
244:
245: EXCEPTION
246:
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
248:
249: THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
248:
249: THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
253:
254: WHEN OTHERS THEN
255: l_sqlerrno := TO_CHAR(SQLCODE);

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253:
254: WHEN OTHERS THEN
255: l_sqlerrno := TO_CHAR(SQLCODE);
256: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: x_error_message := 'Exception in CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG Procedure :'||'while inserting the party -'||p_party_id|| 'for the user -'||p_user_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
259: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.INSERT_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
260:
261: END INSERT_PARTY_ASSG;

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337: AND PARTY_SITE_ID = -2;
338:
339: END IF;
340:
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342: x_error_message := l_error_message;
343: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG Package ', 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
344:
345: EXCEPTION

Line 349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

345: EXCEPTION
346: WHEN others THEN
347: l_sqlerrno := TO_CHAR(SQLCODE);
348: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: x_error_message := 'Exception in CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG Procedure :'||'while deleting the party -'||p_party_id|| 'for the user -'||p_user_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
351: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_ASSIGNMENT_PKG.DELETE_PARTY_ASSG',FND_LOG.LEVEL_EXCEPTION);
352:
353: END DELETE_PARTY_ASSG;