59: IF (csr_grp_owner_id%NOTFOUND)
60:
61: THEN
62:
63: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
64:
65: FND_MSG_PUB.ADD;
66:
67: x_error_message := 'NO owner found for the given group - '||p_group_id;
198: WHEN OTHERS
199:
200: THEN
201:
202: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
203: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: l_sqlerrno := TO_CHAR(SQLCODE);
199:
200: THEN
201:
202: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
203: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: l_sqlerrno := TO_CHAR(SQLCODE);
207: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
274: IF (csr_grp_owner_id%NOTFOUND)
275:
276: THEN
277:
278: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
279:
280: FND_MSG_PUB.ADD;
281:
282: x_error_message := 'NO owner found for the given group - '||p_group_id;
431: WHEN OTHERS
432:
433: THEN
434:
435: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
436: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
437: FND_MSG_PUB.ADD;
438: ROLLBACK;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432:
433: THEN
434:
435: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
436: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
437: FND_MSG_PUB.ADD;
438: ROLLBACK;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: l_sqlerrno := TO_CHAR(SQLCODE);
500: IF (csr_get_owner_id%NOTFOUND)
501:
502: THEN
503:
504: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
505:
506: FND_MSG_PUB.ADD;
507:
508: l_error_message := 'NO Data found for the given group - '||p_group_id;
527: IF l_rel_group_id_tbl.COUNT = 0
528:
529: THEN
530:
531: FND_MESSAGE.SET_NAME ('CSM', 'CSM_REL_GROUPS_NOT_FOUND');
532:
533: FND_MSG_PUB.ADD;
534:
535: x_error_message := 'NO related groups for the given group id - '||p_group_id;
580: WHEN OTHERS
581:
582: THEN
583:
584: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_UNKNOWN_ERROR');
585: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
586: FND_MSG_PUB.ADD;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: l_sqlerrno := TO_CHAR(SQLCODE);
581:
582: THEN
583:
584: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_UNKNOWN_ERROR');
585: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
586: FND_MSG_PUB.ADD;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: l_sqlerrno := TO_CHAR(SQLCODE);
589: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);