DBA Data[Home] [Help]

APPS.CSM_PARTY_DOWNLOAD_PUB dependencies on FND_MESSAGE

Line 50: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');

46: IF (csr_owner_id%NOTFOUND)
47:
48: THEN
49:
50: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
51:
52: FND_MSG_PUB.ADD;
53:
54: l_error_message := 'NO owner found for the given user - '||p_user_id;

Line 138: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');

134: WHEN OTHERS
135:
136: THEN
137:
138: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
139: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: l_sqlerrno := TO_CHAR(SQLCODE);

Line 139: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);

135:
136: THEN
137:
138: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
139: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: l_sqlerrno := TO_CHAR(SQLCODE);
143: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 231: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');

227: IF (csr_owner_id%NOTFOUND)
228:
229: THEN
230:
231: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
232:
233: FND_MSG_PUB.ADD;
234:
235: l_error_message := 'NO owner found for the given user - '||l_user_id;

Line 324: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');

320: WHEN OTHERS
321:
322: THEN
323:
324: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
325: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
326: FND_MSG_PUB.ADD;
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 325: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);

321:
322: THEN
323:
324: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
325: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
326: FND_MSG_PUB.ADD;
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: l_sqlerrno := TO_CHAR(SQLCODE);

Line 386: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');

382: IF (csr_owner_id%NOTFOUND)
383:
384: THEN
385:
386: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
387:
388: FND_MSG_PUB.ADD;
389:
390: l_error_message := 'NO owner found for the given user - '||p_user_id;

Line 474: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');

470: WHEN OTHERS
471:
472: THEN
473:
474: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
475: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
476: FND_MSG_PUB.ADD;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: l_sqlerrno := TO_CHAR(SQLCODE);

Line 475: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);

471:
472: THEN
473:
474: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
475: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
476: FND_MSG_PUB.ADD;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: l_sqlerrno := TO_CHAR(SQLCODE);
479: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 572: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_OWNER_NOT_FOUND');

568: IF (csr_owner_id%NOTFOUND)
569:
570: THEN
571:
572: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_OWNER_NOT_FOUND');
573:
574: FND_MSG_PUB.ADD;
575:
576: l_error_message := 'NO owner found for the given user - '||l_user_id;

Line 665: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');

661: WHEN OTHERS
662:
663: THEN
664:
665: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
666: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
667: FND_MSG_PUB.ADD;
668: ROLLBACK;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 666: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);

662:
663: THEN
664:
665: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
666: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
667: FND_MSG_PUB.ADD;
668: ROLLBACK;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: l_sqlerrno := TO_CHAR(SQLCODE);

Line 737: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_FOR_USER_NOT_FOUND');

733: IF l_party_id_tbl.COUNT = 0
734:
735: THEN
736:
737: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_FOR_USER_NOT_FOUND');
738:
739: FND_MSG_PUB.ADD;
740:
741: l_error_message := 'NO Data found for the given user - '||p_user_id;

Line 782: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');

778: WHEN OTHERS
779:
780: THEN
781:
782: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
783: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: l_sqlerrno := TO_CHAR(SQLCODE);

Line 783: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);

779:
780: THEN
781:
782: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
783: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: l_sqlerrno := TO_CHAR(SQLCODE);
787: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 856: FND_MESSAGE.SET_NAME ('CSM', 'CSM_SITE_FOR_USER_NOT_FOUND');

852: IF l_party_site_id_tbl.COUNT = 0
853:
854: THEN
855:
856: FND_MESSAGE.SET_NAME ('CSM', 'CSM_SITE_FOR_USER_NOT_FOUND');
857:
858: FND_MSG_PUB.ADD;
859:
860: l_error_message := 'NO Data found for the given user - '||p_user_id;

Line 900: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');

896: WHEN OTHERS
897:
898: THEN
899:
900: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
901: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
902: FND_MSG_PUB.ADD;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: l_sqlerrno := TO_CHAR(SQLCODE);

Line 901: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);

897:
898: THEN
899:
900: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
901: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
902: FND_MSG_PUB.ADD;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: l_sqlerrno := TO_CHAR(SQLCODE);
905: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);