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.26.12010000.2 2008/11/14 08:03:45 harchand 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 2727: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_document_type, p_document_id);

2723: CLOSE l_get_article_org_csr;
2724:
2725: -- current Org Id
2726: -- fnd_profile.get('ORG_ID',l_current_org_id);
2727: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_document_type, p_document_id);
2728:
2729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2730: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_article_org_id : '||l_article_org_id);
2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_current_org_id : '||l_current_org_id);

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

3415: l_return_status VARCHAR2(30);
3416:
3417: BEGIN
3418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Entered OKC_TERMS_UTIL_PVT.deliverable_amendment_exists');
3420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1010: p_cat_id='||p_cat_id);
3421: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1020: p_document_id='||p_document_id);
3422: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1030: p_document_type='||p_document_type);
3423: END IF;

Line 3455: 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);

3451:
3452: EXCEPTION
3453: WHEN OTHERS THEN
3454: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3455: 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);
3456: END IF;
3457: RETURN 'N';
3458:
3459: END deliverable_amendment_exists;

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

3480: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3481:
3482: BEGIN
3483: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3484: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'100: Inside OKC_TERMS_UTIL_PVT.PURGE_QA_RESULTS');
3485: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'Parameters: p_num_days='||p_num_days);
3486: END IF;
3487:
3488: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameters: p_num_days='||p_num_days);

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

3501:
3502: commit;
3503:
3504: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3505: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_api_name,'100: leaving OKC_TERMS_UTIL_PVT.PURGE_QA_RESULTS');
3506: END IF;
3507: EXCEPTION
3508: WHEN E_Resource_Busy THEN
3509: l_return_status := fnd_api.g_ret_sts_error;

Line 4253: 'Entered OKC_TERMS_UTIL_PVT.update_contract_admin');

4249: l_api_version := 1.0;
4250:
4251: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4252: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4253: 'Entered OKC_TERMS_UTIL_PVT.update_contract_admin');
4254: END IF;
4255:
4256: -- Standard Start of API savepoint
4257: SAVEPOINT update_contract_admin;

Line 4280: 'Leaving OKC_TERMS_UTIL_PVT.update_contract_admin');

4276: AND document_type = p_doc_types_tbl(i);
4277:
4278: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4280: 'Leaving OKC_TERMS_UTIL_PVT.update_contract_admin');
4281: END IF;
4282:
4283: EXCEPTION
4284:

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

4285: WHEN OTHERS THEN
4286: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4287: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4288: g_module || l_api_name,
4289: 'Leaving OKC_TERMS_UTIL_PVT.update_contract_admin because of EXCEPTION: ' || sqlerrm);
4290: END IF;
4291:
4292: ROLLBACK TO update_contract_admin;
4293:

Line 4404: 'Entered OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');

4400: l_api_version := 1.0;
4401:
4402: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4403: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4404: 'Entered OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');
4405: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4406: 'p_doc_id: ' || p_doc_id);
4407: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4408: 'p_doc_type: ' || p_doc_type);

Line 4498: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');

4494:
4495:
4496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4498: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');
4499: END IF;
4500:
4501: EXCEPTION
4502:

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

4503: WHEN OTHERS THEN
4504: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4505: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4506: g_module || l_api_name,
4507: 'Leaving OKC_TERMS_UTIL_PVT.get_sales_group_con_admin because of EXCEPTION: ' || sqlerrm);
4508: END IF;
4509:
4510: x_return_status := FND_API.G_RET_STS_ERROR;
4511: FND_MSG_PUB.Count_And_Get(

Line 5549: l_variable_value := OKC_TERMS_UTIL_PVT.GET_VALUE_SET_VARIABLE_VALUE (

5545:
5546: /* Valueset is Independent type */
5547: ELSIF l_validation_type = 'I' THEN
5548:
5549: l_variable_value := OKC_TERMS_UTIL_PVT.GET_VALUE_SET_VARIABLE_VALUE (
5550: p_CONTEXT => l_validation_type,
5551: p_VALUE_SET_ID => l_value_set_id,
5552: p_FLEX_VALUE_ID => l_variable_value_id);
5553:

Line 5631: END OKC_TERMS_UTIL_PVT;

5627:
5628: END get_udv_with_proc_value;
5629:
5630:
5631: END OKC_TERMS_UTIL_PVT;