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 608: okc_Api.Set_Message(p_app_name => G_APP_NAME,

604:
605: IF l_get_variables_csr%ISOPEN THEN
606: CLOSE l_get_variables_csr;
607: END IF;
608: okc_Api.Set_Message(p_app_name => G_APP_NAME,
609: p_msg_name => G_UNEXPECTED_ERROR,
610: p_token1 => G_SQLCODE_TOKEN,
611: p_token1_value => sqlcode,
612: p_token2 => G_SQLERRM_TOKEN,

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

892: FROM OKC_K_ARTICLES_BH KART,
893: OKC_SECTIONS_B SCN
894: WHERE KART.DOCUMENT_TYPE=p_source_doc_type
895: AND KART.DOCUMENT_ID=p_source_doc_id
896: AND KART.MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)
897: AND SCN.DOCUMENT_TYPE = p_target_doc_type
898: AND SCN.DOCUMENT_ID =p_target_doc_id
899: AND SCN.ORIG_SYSTEM_REFERENCE_CODE =G_COPY
900: AND SCN.ORIG_SYSTEM_REFERENCE_ID1=KART.SCN_ID;

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

1215:
1216: IF l_get_max_local_article_csr%NOTFOUND THEN
1217: -- discard this record
1218: l_discard := true;
1219: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1220: p_msg_name => 'OKC_ART_NOT_ADOPTED',
1221: p_token1 => 'ART_TITLE',
1222: p_token1_value => l_art_title,
1223: p_token2 => 'ORG_ID',

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

1283:
1284: -- if article_version_id is still null then discard this record
1285: IF article_version_tbl(i) IS NULL THEN
1286: l_discard := true;
1287: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1288: p_msg_name => 'OKC_ART_NO_APP_VERSION',
1289: p_token1 => 'ART_TITLE',
1290: p_token1_value => l_art_title);
1291: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1353: FETCH l_get_max_local_article_csr INTO article_version_tbl(i),l_adoption_type;
1354:
1355: IF l_get_max_local_article_csr%NOTFOUND THEN
1356: l_discard := true;
1357: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1358: p_msg_name => 'OKC_ART_NOT_ADOPTED',
1359: p_token1 => 'ART_TITLE',
1360: p_token1_value => l_art_title,
1361: p_token2 => 'ORG_ID',

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

1705: IF l_get_org_csr%ISOPEN THEN
1706: CLOSE l_get_org_csr;
1707: END IF;
1708:
1709: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1710: p_msg_name => G_UNEXPECTED_ERROR,
1711: p_token1 => G_SQLCODE_TOKEN,
1712: p_token1_value => sqlcode,
1713: p_token2 => G_SQLERRM_TOKEN,

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

1877: DESCRIPTION
1878: FROM OKC_SECTIONS_BH
1879: WHERE DOCUMENT_TYPE=P_SOURCE_DOC_TYPE
1880: AND DOCUMENT_ID=P_SOURCE_DOC_ID
1881: AND MAJOR_VERSION = nvl(p_source_version_number,OKC_API.G_MISS_NUM)
1882: AND (( l_scn_drp_action = 'DROP_AMEND_SEC' AND
1883: heading <> Nvl(fnd_profile.Value('OKC_AMENDMENT_SPECIFIC_SECTION'),'~!@#$%')
1884: ) OR
1885: (

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

2200: IF l_get_scn_csr %ISOPEN THEN
2201: CLOSE l_get_scn_csr ;
2202: END IF;
2203:
2204: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2205: p_msg_name => G_UNEXPECTED_ERROR,
2206: p_token1 => G_SQLCODE_TOKEN,
2207: p_token1_value => sqlcode,
2208: p_token2 => G_SQLERRM_TOKEN,

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

2489: IF l_check_unassigned_section_csr%ISOPEN THEN
2490: CLOSE l_check_unassigned_section_csr ;
2491: END IF;
2492:
2493: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2494: x_return_status := G_RET_STS_ERROR ;
2495: WHEN FND_API.G_EXC_ERROR THEN
2496:
2497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2571: IF l_check_unassigned_section_csr%ISOPEN THEN
2572: CLOSE l_check_unassigned_section_csr ;
2573: END IF;
2574:
2575: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2576: p_msg_name => G_UNEXPECTED_ERROR,
2577: p_token1 => G_SQLCODE_TOKEN,
2578: p_token1_value => sqlcode,
2579: p_token2 => G_SQLERRM_TOKEN,

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

2737:
2738: IF (p_source_doc_type IS NOT NULL
2739: 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
2740:
2741: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2742: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2743: p_token1 => 'DOCUMENT_TYPE',
2744: p_token2_value => p_source_doc_type);
2745: RAISE FND_API.G_EXC_ERROR ;

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

2749:
2750: IF (p_target_doc_type IS NOT NULL
2751: 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
2752:
2753: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2754: p_msg_name => 'OKC_INVALID_DOC_TYPE',
2755: p_token1 => 'DOCUMENT_TYPE',
2756: p_token2_value => p_target_doc_type);
2757: RAISE FND_API.G_EXC_ERROR ;

Line 3032: p_init_msg_list => OKC_API.G_FALSE,

3028:
3029: /* Call Copy Config API provided by Contract Expert Team */
3030: OKC_XPRT_CZ_INT_PVT.copy_configuration(
3031: p_api_version => 1,
3032: p_init_msg_list => OKC_API.G_FALSE,
3033: p_config_header_id =>l_usage_rec.config_header_id,
3034: p_config_rev_nbr =>l_usage_rec.config_revision_number,
3035: p_new_config_flag => FND_API.G_TRUE,
3036: x_new_config_header_id => l_header_id,

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

3346: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3347: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300:For this Template,Doc type usage not defined ');
3348: END IF;
3349:
3350: okc_Api.Set_Message(p_app_name => G_APP_NAME,
3351: p_msg_name => 'OKC_ALLOWED_USAGE',
3352: p_token1 => 'TEMPLATE_NAME',
3353: p_token1_value => l_tmpl_rec.template_name,
3354: p_token2 => 'DOCUMENT_TYPE',

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

3666: END IF;
3667:
3668: ROLLBACK TO g_copy_tc_pvt;
3669: x_return_status := G_RET_STS_ERROR ;
3670: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
3671:
3672: WHEN FND_API.G_EXC_ERROR THEN
3673:
3674: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3671:
3672: WHEN FND_API.G_EXC_ERROR THEN
3673:
3674: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_tc: OKC_API.G_EXCEPTION_ERROR Exception');
3676: END IF;
3677:
3678: IF l_get_doc_type_name_csr%ISOPEN THEN
3679: CLOSE l_get_doc_type_name_csr;

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

3708: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3709:
3710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3711: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3712: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_tc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3713: END IF;
3714:
3715: IF l_get_doc_type_name_csr%ISOPEN THEN
3716: CLOSE l_get_doc_type_name_csr;

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

4096:
4097: WHEN FND_API.G_EXC_ERROR THEN
4098:
4099: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4100: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');
4101: END IF;
4102:
4103: IF l_get_usage_csr%ISOPEN THEN
4104: CLOSE l_get_usage_csr;

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

4114:
4115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4116:
4117: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4118: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4119: END IF;
4120:
4121: IF l_get_usage_csr%ISOPEN THEN
4122: CLOSE l_get_usage_csr;