eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_COPY_PVT dependencies on OKC_API

Line 8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

4:
5: ---------------------------------------------------------------------------
6: -- GLOBAL MESSAGE CONSTANTS
7: ---------------------------------------------------------------------------
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: ---------------------------------------------------------------------------
10: -- GLOBAL VARIABLES
11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_PVT';

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: -- GLOBAL VARIABLES
11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_PVT';
13: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME||'.';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15: G_TEMPLATE_DOC_TYPE CONSTANT okc_bus_doc_types_b.document_type%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
16: G_ATTACHED_CONTRACT_SOURCE CONSTANT okc_template_usages.contract_source_code%TYPE := 'ATTACHED';
17:
18: ------------------------------------------------------------------------------

Line 31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;

27:
28: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
29: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
32: G_AMEND_CODE_DELETED CONSTANT VARCHAR2(30) := 'DELETED';
33: G_STRUCT_CONTRACT_SOURCE CONSTANT VARCHAR2(30) := 'STRUCTURED';
34: G_INTERNAL_PARTY_CODE CONSTANT VARCHAR2(30) := 'INTERNAL_ORG';
35: G_COPY CONSTANT VARCHAR2(30) := 'COPY';

Line 372: okc_Api.Set_Message(p_app_name => G_APP_NAME,

368:
369: IF l_get_variables_csr%ISOPEN THEN
370: CLOSE l_get_variables_csr;
371: END IF;
372: okc_Api.Set_Message(p_app_name => G_APP_NAME,
373: p_msg_name => G_UNEXPECTED_ERROR,
374: p_token1 => G_SQLCODE_TOKEN,
375: p_token1_value => sqlcode,
376: p_token2 => G_SQLERRM_TOKEN,

Line 640: AND KART.MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)

636: FROM OKC_K_ARTICLES_BH KART,
637: OKC_SECTIONS_B SCN
638: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
639: AND KART.DOCUMENT_ID=p_source_doc_id
640: AND KART.MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)
641: AND SCN.DOCUMENT_TYPE = p_target_doc_type
642: AND SCN.DOCUMENT_ID =p_target_doc_id
643: AND SCN.ORIG_SYSTEM_REFERENCE_CODE =G_COPY
644: AND SCN.ORIG_SYSTEM_REFERENCE_ID1=KART.SCN_ID;

Line 907: okc_Api.Set_Message(p_app_name => G_APP_NAME,

903:
904: IF l_get_max_local_article_csr%NOTFOUND THEN
905: -- discard this record
906: l_discard := true;
907: okc_Api.Set_Message(p_app_name => G_APP_NAME,
908: p_msg_name => 'OKC_ART_NOT_ADOPTED',
909: p_token1 => 'ART_TITLE',
910: p_token1_value => l_art_title,
911: p_token2 => 'ORG_ID',

Line 975: okc_Api.Set_Message(p_app_name => G_APP_NAME,

971:
972: -- if article_version_id is still null then discard this record
973: IF article_version_tbl(i) IS NULL THEN
974: l_discard := true;
975: okc_Api.Set_Message(p_app_name => G_APP_NAME,
976: p_msg_name => 'OKC_ART_NO_APP_VERSION',
977: p_token1 => 'ART_TITLE',
978: p_token1_value => l_art_title);
979: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1045: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1041: FETCH l_get_max_local_article_csr INTO article_version_tbl(i),l_adoption_type;
1042:
1043: IF l_get_max_local_article_csr%NOTFOUND THEN
1044: l_discard := true;
1045: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1046: p_msg_name => 'OKC_ART_NOT_ADOPTED',
1047: p_token1 => 'ART_TITLE',
1048: p_token1_value => l_art_title,
1049: p_token2 => 'ORG_ID',

Line 1335: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1331: IF l_get_org_csr%ISOPEN THEN
1332: CLOSE l_get_org_csr;
1333: END IF;
1334:
1335: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1336: p_msg_name => G_UNEXPECTED_ERROR,
1337: p_token1 => G_SQLCODE_TOKEN,
1338: p_token1_value => sqlcode,
1339: p_token2 => G_SQLERRM_TOKEN,

Line 1466: AND MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM);

1462: DESCRIPTION
1463: FROM OKC_SECTIONS_BH
1464: WHERE DOCUMENT_TYPE=P_SOURCE_DOC_TYPE
1465: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1466: AND MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM);
1467:
1468: BEGIN
1469:
1470: x_return_status := G_RET_STS_SUCCESS;

Line 1687: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1683: IF l_get_scn_csr %ISOPEN THEN
1684: CLOSE l_get_scn_csr ;
1685: END IF;
1686:
1687: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1688: p_msg_name => G_UNEXPECTED_ERROR,
1689: p_token1 => G_SQLCODE_TOKEN,
1690: p_token1_value => sqlcode,
1691: p_token2 => G_SQLERRM_TOKEN,

Line 1926: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);

1922: IF l_check_unassigned_section_csr%ISOPEN THEN
1923: CLOSE l_check_unassigned_section_csr ;
1924: END IF;
1925:
1926: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
1927: x_return_status := G_RET_STS_ERROR ;
1928: WHEN FND_API.G_EXC_ERROR THEN
1929:
1930: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2008: okc_Api.Set_Message(p_app_name => G_APP_NAME,

2004: IF l_check_unassigned_section_csr%ISOPEN THEN
2005: CLOSE l_check_unassigned_section_csr ;
2006: END IF;
2007:
2008: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2009: p_msg_name => G_UNEXPECTED_ERROR,
2010: p_token1 => G_SQLCODE_TOKEN,
2011: p_token1_value => sqlcode,
2012: p_token2 => G_SQLERRM_TOKEN,

Line 2147: okc_Api.Set_Message(p_app_name => G_APP_NAME,

2143:
2144: IF (p_source_doc_type IS NOT NULL
2145: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_PVT.is_doc_type_valid ( p_doc_type => p_source_doc_type , x_return_status => x_return_status))) THEN
2146:
2147: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2148: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2149: p_token1 => 'DOCUMENT_TYPE',
2150: p_token2_value => p_source_doc_type);
2151: RAISE FND_API.G_EXC_ERROR ;

Line 2159: okc_Api.Set_Message(p_app_name => G_APP_NAME,

2155:
2156: IF (p_target_doc_type IS NOT NULL
2157: AND NOT FND_API.To_Boolean(OKC_TERMS_UTIL_PVT.is_doc_type_valid ( p_doc_type => p_target_doc_type , x_return_status => x_return_status))) THEN
2158:
2159: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2160: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2161: p_token1 => 'DOCUMENT_TYPE',
2162: p_token2_value => p_target_doc_type);
2163: RAISE FND_API.G_EXC_ERROR ;

Line 2388: p_init_msg_list => OKC_API.G_FALSE,

2384:
2385: /* Call Copy Config API provided by Contract Expert Team */
2386: OKC_XPRT_CZ_INT_PVT.copy_configuration(
2387: p_api_version => 1,
2388: p_init_msg_list => OKC_API.G_FALSE,
2389: p_config_header_id =>l_usage_rec.config_header_id,
2390: p_config_rev_nbr =>l_usage_rec.config_revision_number,
2391: p_new_config_flag => FND_API.G_TRUE,
2392: x_new_config_header_id => l_header_id,

Line 2601: okc_Api.Set_Message(p_app_name => G_APP_NAME,

2597: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300:For this Template,Doc type usage not defined ');
2599: END IF;
2600:
2601: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2602: p_msg_name => 'OKC_ALLOWED_USAGE',
2603: p_token1 => 'TEMPLATE_NAME',
2604: p_token1_value => l_tmpl_rec.template_name,
2605: p_token2 => 'DOCUMENT_TYPE',

Line 2855: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);

2851: END IF;
2852:
2853: ROLLBACK TO g_copy_tc_pvt;
2854: x_return_status := G_RET_STS_ERROR ;
2855: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2856:
2857: WHEN FND_API.G_EXC_ERROR THEN
2858:
2859: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2860: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_tc: OKC_API.G_EXCEPTION_ERROR Exception');

2856:
2857: WHEN FND_API.G_EXC_ERROR THEN
2858:
2859: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2860: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_tc: OKC_API.G_EXCEPTION_ERROR Exception');
2861: END IF;
2862:
2863: IF l_get_doc_type_name_csr%ISOPEN THEN
2864: CLOSE l_get_doc_type_name_csr;

Line 2897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_tc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2893: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_tc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2898: END IF;
2899:
2900: IF l_get_doc_type_name_csr%ISOPEN THEN
2901: CLOSE l_get_doc_type_name_csr;

Line 3261: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');

3257:
3258: WHEN FND_API.G_EXC_ERROR THEN
3259:
3260: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3261: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');
3262: END IF;
3263:
3264: IF l_get_usage_csr%ISOPEN THEN
3265: CLOSE l_get_usage_csr;

Line 3279: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

3275:
3276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3277:
3278: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3279: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3280: END IF;
3281:
3282: IF l_get_usage_csr%ISOPEN THEN
3283: CLOSE l_get_usage_csr;