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_UTIL_PVT dependencies on OKC_TERMS_UTIL_PVT

Line 1: PACKAGE BODY OKC_TERMS_UTIL_PVT AS

1: PACKAGE BODY OKC_TERMS_UTIL_PVT AS
2: /* $Header: OKCVDUTB.pls 120.34.12020000.4 2013/03/12 06:50:46 nbingi ship $ */
3: g_concat_art_no VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_CONCAT_ART_NO'),'N');
4:
5: ---------------------------------------------------------------------------

Line 21: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_UTIL_PVT';

17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: ---------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ---------------------------------------------------------------------------
21: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_UTIL_PVT';
22: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
23: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
24:
25: G_TMPL_DOC_TYPE CONSTANT VARCHAR2(30) := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;

Line 2769: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_document_type, p_document_id);

2765: CLOSE l_get_article_org_csr;
2766:
2767: -- current Org Id
2768: -- fnd_profile.get('ORG_ID',l_current_org_id);
2769: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_document_type, p_document_id);
2770:
2771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_article_org_id : '||l_article_org_id);
2773: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_current_org_id : '||l_current_org_id);

Line 3461: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Entered OKC_TERMS_UTIL_PVT.deliverable_amendment_exists');

3457: l_return_status VARCHAR2(30);
3458:
3459: BEGIN
3460: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3461: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Entered OKC_TERMS_UTIL_PVT.deliverable_amendment_exists');
3462: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1010: p_cat_id='||p_cat_id);
3463: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1020: p_document_id='||p_document_id);
3464: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1030: p_document_type='||p_document_type);
3465: END IF;

Line 3497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1090: Leaving OKC_TERMS_UTIL_PVT.deliverable_amendment_exists because of EXCEPTION: '||sqlerrm);

3493:
3494: EXCEPTION
3495: WHEN OTHERS THEN
3496: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1090: Leaving OKC_TERMS_UTIL_PVT.deliverable_amendment_exists because of EXCEPTION: '||sqlerrm);
3498: END IF;
3499: RETURN 'N';
3500:
3501: END deliverable_amendment_exists;

Line 3526: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'100: Inside OKC_TERMS_UTIL_PVT.PURGE_QA_RESULTS');

3522: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3523:
3524: BEGIN
3525: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3526: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'100: Inside OKC_TERMS_UTIL_PVT.PURGE_QA_RESULTS');
3527: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'Parameters: p_num_days='||p_num_days);
3528: END IF;
3529:
3530: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameters: p_num_days='||p_num_days);

Line 3547: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'100: leaving OKC_TERMS_UTIL_PVT.PURGE_QA_RESULTS');

3543:
3544: commit;
3545:
3546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3547: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'100: leaving OKC_TERMS_UTIL_PVT.PURGE_QA_RESULTS');
3548: END IF;
3549: EXCEPTION
3550: WHEN E_Resource_Busy THEN
3551: l_return_status := fnd_api.g_ret_sts_error;

Line 4302: 'Entered OKC_TERMS_UTIL_PVT.update_contract_admin');

4298: l_api_version := 1.0;
4299:
4300: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4302: 'Entered OKC_TERMS_UTIL_PVT.update_contract_admin');
4303: END IF;
4304:
4305: -- Standard Start of API savepoint
4306: SAVEPOINT update_contract_admin;

Line 4329: 'Leaving OKC_TERMS_UTIL_PVT.update_contract_admin');

4325: AND document_type = p_doc_types_tbl(i);
4326:
4327: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4328: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4329: 'Leaving OKC_TERMS_UTIL_PVT.update_contract_admin');
4330: END IF;
4331:
4332: EXCEPTION
4333:

Line 4338: 'Leaving OKC_TERMS_UTIL_PVT.update_contract_admin because of EXCEPTION: ' || sqlerrm);

4334: WHEN OTHERS THEN
4335: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4336: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4337: g_module || l_api_name,
4338: 'Leaving OKC_TERMS_UTIL_PVT.update_contract_admin because of EXCEPTION: ' || sqlerrm);
4339: END IF;
4340:
4341: ROLLBACK TO update_contract_admin;
4342:

Line 4453: 'Entered OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');

4449: l_api_version := 1.0;
4450:
4451: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4452: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4453: 'Entered OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');
4454: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4455: 'p_doc_id: ' || p_doc_id);
4456: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4457: 'p_doc_type: ' || p_doc_type);

Line 4547: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');

4543:
4544:
4545: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4547: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');
4548: END IF;
4549:
4550: EXCEPTION
4551:

Line 4556: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin because of EXCEPTION: ' || sqlerrm);

4552: WHEN OTHERS THEN
4553: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4554: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4555: g_module || l_api_name,
4556: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin because of EXCEPTION: ' || sqlerrm);
4557: END IF;
4558:
4559: x_return_status := FND_API.G_RET_STS_ERROR;
4560: FND_MSG_PUB.Count_And_Get(

Line 5598: l_variable_value := OKC_TERMS_UTIL_PVT.GET_VALUE_SET_VARIABLE_VALUE (

5594:
5595: /* Valueset is Independent type */
5596: ELSIF l_validation_type = 'I' THEN
5597:
5598: l_variable_value := OKC_TERMS_UTIL_PVT.GET_VALUE_SET_VARIABLE_VALUE (
5599: p_CONTEXT => l_validation_type,
5600: p_VALUE_SET_ID => l_value_set_id,
5601: p_FLEX_VALUE_ID => l_variable_value_id);
5602:

Line 5680: END OKC_TERMS_UTIL_PVT;

5676:
5677: END get_udv_with_proc_value;
5678:
5679:
5680: END OKC_TERMS_UTIL_PVT;