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 620: p_init_msg_list => FND_API.G_FALSE,

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

Line 621: p_commit => FND_API.G_FALSE,

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

Line 720: p_init_msg_list => FND_API.G_FALSE,

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

Line 721: p_commit => FND_API.G_FALSE,

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

Line 851: p_init_msg_list => FND_API.G_FALSE,

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

Line 852: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 853: p_commit => FND_API.G_FALSE,

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

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 905: RAISE FND_API.G_EXC_ERROR ;

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

Line 923: p_init_msg_list => FND_API.G_FALSE,

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

Line 924: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 925: p_commit => FND_API.G_FALSE,

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

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 971: RAISE FND_API.G_EXC_ERROR ;

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

Line 989: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1469: p_init_msg_list => FND_API.G_FALSE,

1465: --------------------------------------------
1466: --Bug 3341342 Included cat_type
1467: OKC_K_ARTICLES_GRP.create_article(
1468: p_api_version => p_api_version,
1469: p_init_msg_list => FND_API.G_FALSE,
1470: x_return_status => x_return_status,
1471: x_msg_count => x_msg_count,
1472: x_msg_data => x_msg_data,
1473: p_id => gi_catv_rec.id,