DBA Data[Home] [Help]

APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on FND_MESSAGE

Line 277: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

273: WHEN others THEN
274: IF(l_clob IS NOT NULL) THEN
275: DBMS_LOB.freetemporary(l_clob);
276: END IF;
277: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
278: RETURN ERROR_STATUS;
279:
280: END Create_Element;
281:

Line 358: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

354: RETURN l_element_id;
355:
356: EXCEPTION
357: WHEN OTHERS THEN
358: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
359: RETURN ERROR_STATUS;
360: END Create_Element_CLOB;
361:
362:

Line 452: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

448: WHEN others THEN
449: IF(l_clob IS NOT NULL) THEN
450: DBMS_LOB.freetemporary(l_clob);
451: END IF;
452: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
453: RETURN ERROR_STATUS;
454: END Update_Element;
455:
456:

Line 529: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

525: RETURN l_return;
526:
527: EXCEPTION
528: WHEN others THEN
529: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
530: RETURN ERROR_STATUS;
531: END Update_Element_CLOB;
532:
533:

Line 547: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

543: l_ret NUMBER;
544: l_count PLS_INTEGER;
545: BEGIN
546: IF p_element_number IS NULL THEN
547: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
548: RETURN ERROR_STATUS;
549: END IF;
550:
551: SELECT COUNT(*) INTO l_count

Line 555: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_IN_SET_ERR');

551: SELECT COUNT(*) INTO l_count
552: FROM CS_KB_SET_ELES
553: WHERE element_id = Get_Latest_Version_Id(p_element_number);
554: IF(l_count > 0) THEN
555: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_IN_SET_ERR');
556: RETURN ERROR_STATUS;
557: END IF;
558:
559: SELECT COUNT(*) INTO l_count

Line 563: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_IN_LINK_ERR');

559: SELECT COUNT(*) INTO l_count
560: FROM CS_KB_ELEMENT_LINKS
561: WHERE element_id = Get_Latest_Version_Id(p_element_number);
562: IF(l_count > 0) THEN
563: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_IN_LINK_ERR');
564: RETURN ERROR_STATUS;
565: END IF;
566:
567: --clean cs_kb_elements_audit_b , cs_kb_elements_audit_tl

Line 628: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

624: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
625: -- check params
626: IF(p_element_type_id IS NULL OR p_name IS NULL) THEN
627: FND_MSG_PUB.initialize;
628: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
629: FND_MSG_PUB.ADD;
630: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
631: X_ELEMENT_ID := -1;
632: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 644: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');

640: WHERE element_type_id = p_element_type_id;
641:
642: IF(l_count <1) THEN
643: FND_MSG_PUB.initialize;
644: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
645: FND_MSG_PUB.ADD;
646: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
647: X_ELEMENT_ID := -2;
648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 659: FND_MESSAGE.set_name('CS', 'CS_KB_EXPIRED_STMT_TYPE');

655: Close check_active_type_csr;
656:
657: If l_dummy Is Null Then
658: FND_MSG_PUB.initialize;
659: FND_MESSAGE.set_name('CS', 'CS_KB_EXPIRED_STMT_TYPE');
660: FND_MSG_PUB.ADD;
661: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
662: X_ELEMENT_ID := -3;
663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 684: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

680: END LOOP;
681:
682: IF x_element_id IS NULL OR l_element_number IS NULL THEN
683: FND_MSG_PUB.initialize;
684: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
685: FND_MSG_PUB.ADD;
686: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
687: X_ELEMENT_ID := -1;
688: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 752: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

748: END IF;
749:
750: EXCEPTION
751: WHEN others THEN
752: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754:
755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
756: p_data => x_msg_data);

Line 836: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

832: -- validate params
833: IF (p_element_id IS NULL) OR ( NOT p_element_type_id > 0) THEN
834: X_RETURN := -1; -- 'CS_KB_C_MISS_PARAM'
835: FND_MSG_PUB.initialize;
836: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
837: FND_MSG_PUB.ADD;
838: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
840: p_count => X_MSG_COUNT,

Line 852: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');

848:
849: IF(l_count <1) THEN
850: X_RETURN := -2;
851: FND_MSG_PUB.initialize;
852: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
853: FND_MSG_PUB.ADD;
854: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
855: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
856: p_count => X_MSG_COUNT,

Line 874: FND_MESSAGE.set_name('CS', 'CS_KB_END_DATED_TYPE');

870: Close validate_old_type_used_csr;
871: IF l_dummy Is Null Then
872: X_RETURN := -3;
873: FND_MSG_PUB.initialize;
874: FND_MESSAGE.set_name('CS', 'CS_KB_END_DATED_TYPE');
875: FND_MSG_PUB.ADD;
876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
878: p_count => X_MSG_COUNT,

Line 945: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');

941:
942: EXCEPTION
943: WHEN OTHERS THEN
944: X_RETURN := -7;--ERROR_STATUS;
945: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
948: p_count => X_MSG_COUNT,
949: p_data => X_MSG_DATA);

Line 1383: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');

1379: 'Unexpected Exception-'||substrb(sqlerrm,1,200) );
1380: END IF;
1381:
1382: X_RETURN_ELEMENT := NULL;
1383: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
1384: FND_MSG_PUB.ADD;
1385: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
1386: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1387: p_count => X_MSG_COUNT,

Line 1440: ERRBUF := fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: RETCODE := 2;
1440: ERRBUF := fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
1441: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
1442:
1443: END Obsolete_Unused_Statements;
1444: