DBA Data[Home] [Help]

APPS.OKC_K_ARTICLE_PUB dependencies on FND_API

Line 12: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

8: G_SCOPE CONSTANT varchar2(4) := '_PUB';
9: ------------------------------------------------------------------------------
10: -- GLOBAL CONSTANTS
11: ------------------------------------------------------------------------------
12: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

Line 13: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

9: ------------------------------------------------------------------------------
10: -- GLOBAL CONSTANTS
11: ------------------------------------------------------------------------------
12: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

10: -- GLOBAL CONSTANTS
11: ------------------------------------------------------------------------------
12: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

11: ------------------------------------------------------------------------------
12: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

12: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

14: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
22: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

15: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
16: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
22: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
23: -- ??? should be moved to OKC_TERMS_UTIL_PVT

Line 623: p_init_msg_list => FND_API.G_FALSE,

619: CLOSE get_unasgn_scn_id_crs;
620: IF l_scn_id IS NULL THEN
621: OKC_TERMS_UTIL_PVT.create_unassigned_section(
622: p_api_version => p_api_version,
623: p_init_msg_list => FND_API.G_FALSE,
624: p_commit => FND_API.G_FALSE,
625: x_return_status => x_return_status,
626: x_msg_data => x_msg_data,
627: x_msg_count => x_msg_count,

Line 624: p_commit => FND_API.G_FALSE,

620: IF l_scn_id IS NULL THEN
621: OKC_TERMS_UTIL_PVT.create_unassigned_section(
622: p_api_version => p_api_version,
623: p_init_msg_list => FND_API.G_FALSE,
624: p_commit => FND_API.G_FALSE,
625: x_return_status => x_return_status,
626: x_msg_data => x_msg_data,
627: x_msg_count => x_msg_count,
628: p_doc_type => p_doc_type,

Line 723: p_init_msg_list => FND_API.G_FALSE,

719: END IF;
720: IF l_tmpl_id IS NOT NULL THEN
721: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
722: p_api_version => p_api_version,
723: p_init_msg_list => FND_API.G_FALSE,
724: p_commit => FND_API.G_FALSE,
725: x_return_status => x_return_status,
726: x_msg_data => x_msg_data,
727: x_msg_count => x_msg_count,

Line 724: p_commit => FND_API.G_FALSE,

720: IF l_tmpl_id IS NOT NULL THEN
721: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
722: p_api_version => p_api_version,
723: p_init_msg_list => FND_API.G_FALSE,
724: p_commit => FND_API.G_FALSE,
725: x_return_status => x_return_status,
726: x_msg_data => x_msg_data,
727: x_msg_count => x_msg_count,
728: p_document_type => p_doc_type,

Line 854: p_init_msg_list => FND_API.G_FALSE,

850: END IF;
851:
852: OKC_ARTICLES_GRP.create_article(
853: p_api_version => 1,
854: p_init_msg_list => FND_API.G_FALSE,
855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
856: p_commit => FND_API.G_FALSE,
857: x_return_status => x_return_status,
858: x_msg_count => x_msg_count,

Line 855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

851:
852: OKC_ARTICLES_GRP.create_article(
853: p_api_version => 1,
854: p_init_msg_list => FND_API.G_FALSE,
855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
856: p_commit => FND_API.G_FALSE,
857: x_return_status => x_return_status,
858: x_msg_count => x_msg_count,
859: x_msg_data => x_msg_data,

Line 856: p_commit => FND_API.G_FALSE,

852: OKC_ARTICLES_GRP.create_article(
853: p_api_version => 1,
854: p_init_msg_list => FND_API.G_FALSE,
855: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
856: p_commit => FND_API.G_FALSE,
857: x_return_status => x_return_status,
858: x_msg_count => x_msg_count,
859: x_msg_data => x_msg_data,
860:

Line 906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

902: Dbms_Lob.freetemporary( l_txt );
903: END IF;
904: --------------------------------------------
905: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
907: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
908: RAISE FND_API.G_EXC_ERROR ;
909: END IF;
910: --------------------------------------------

Line 908: RAISE FND_API.G_EXC_ERROR ;

904: --------------------------------------------
905: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
907: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
908: RAISE FND_API.G_EXC_ERROR ;
909: END IF;
910: --------------------------------------------
911:
912: IF (l_debug = 'Y') THEN

Line 926: p_init_msg_list => FND_API.G_FALSE,

922: END IF;
923:
924: OKC_ARTICLES_GRP.update_article(
925: p_api_version => 1,
926: p_init_msg_list => FND_API.G_FALSE,
927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
928: p_commit => FND_API.G_FALSE,
929: x_return_status => x_return_status,
930: x_msg_count => x_msg_count,

Line 927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

923:
924: OKC_ARTICLES_GRP.update_article(
925: p_api_version => 1,
926: p_init_msg_list => FND_API.G_FALSE,
927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
928: p_commit => FND_API.G_FALSE,
929: x_return_status => x_return_status,
930: x_msg_count => x_msg_count,
931: x_msg_data => x_msg_data,

Line 928: p_commit => FND_API.G_FALSE,

924: OKC_ARTICLES_GRP.update_article(
925: p_api_version => 1,
926: p_init_msg_list => FND_API.G_FALSE,
927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
928: p_commit => FND_API.G_FALSE,
929: x_return_status => x_return_status,
930: x_msg_count => x_msg_count,
931: x_msg_data => x_msg_data,
932: p_article_id => l_art_id,

Line 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

968: x_std_art_id := p_catv_rec.ref_article_id;
969: x_std_art_ver_id := p_catv_rec.ref_article_version_id;
970: --------------------------------------------
971: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
973: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
974: RAISE FND_API.G_EXC_ERROR ;
975: END IF;
976: --------------------------------------------

Line 974: RAISE FND_API.G_EXC_ERROR ;

970: --------------------------------------------
971: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
973: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
974: RAISE FND_API.G_EXC_ERROR ;
975: END IF;
976: --------------------------------------------
977:
978: IF (l_debug = 'Y') THEN

Line 992: WHEN FND_API.G_EXC_ERROR THEN

988: okc_debug.log('900: Leaving Process_Non_Std_Article.', 2);
989: END IF;
990:
991: EXCEPTION
992: WHEN FND_API.G_EXC_ERROR THEN
993: IF (l_debug = 'Y') THEN
994: okc_debug.log('300: Leaving Process_Non_Std_Article: G_EXCEPTION_ERROR Exception', 2);
995: END IF;
996:

Line 1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1000:
1001: x_return_status := G_RET_STS_ERROR ;
1002: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1003:
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: IF (l_debug = 'Y') THEN
1006: okc_debug.log('400: Leaving Process_Non_Std_Article: G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1007: END IF;
1008:

Line 1476: p_init_msg_list => FND_API.G_FALSE,

1472: --------------------------------------------
1473: --Bug 3341342 Included cat_type
1474: OKC_K_ARTICLES_GRP.create_article(
1475: p_api_version => p_api_version,
1476: p_init_msg_list => FND_API.G_FALSE,
1477: x_return_status => x_return_status,
1478: x_msg_count => x_msg_count,
1479: x_msg_data => x_msg_data,
1480: p_id => gi_catv_rec.id,