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_CONTRACT_DOCS_GRP 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:

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

30: G_APP_ABSTRACT_CATEGORY CONSTANT VARCHAR2(200) := 'OKC_REPO_APP_ABSTRACT';
31: G_SUPPORTING_DOC_CATEGORY CONSTANT VARCHAR2(200) := 'OKC_REPO_SUPPORTING_DOC';
32: G_PKG_NAME CONSTANT VARCHAR2(40) := 'OKC_CONTRACT_DOCS_GRP';
33: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME ||'.';
34: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
35: G_COPY_ALL_DOCS CONSTANT VARCHAR2(30) := 'OKC_REP_COPY_ALL_CON_DOCS';
36:
37:
38: G_QA_STS_SUCCESS CONSTANT varchar2(1) := 'S';

Line 355: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800: Leaving Insert_Contract_Doc: OKC_API.G_EXCEPTION_ERROR Exception');

351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800: Leaving Insert_Contract_Doc: OKC_API.G_EXCEPTION_ERROR Exception');
356: END IF;
357: IF l_attachment_id_csr%ISOPEN THEN
358: CLOSE l_attachment_id_csr;
359: END IF;

Line 366: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving Insert_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

362: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
366: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving Insert_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
367: END IF;
368: IF l_attachment_id_csr%ISOPEN THEN
369: CLOSE l_attachment_id_csr;
370: END IF;

Line 578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1900: Leaving Update_Contract_Doc: OKC_API.G_EXCEPTION_ERROR Exception');

574:
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1900: Leaving Update_Contract_Doc: OKC_API.G_EXCEPTION_ERROR Exception');
579: END IF;
580: IF (contract_doc_csr%ISOPEN) THEN
581: CLOSE contract_doc_csr ;
582: END IF;

Line 589: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2000: Leaving Update_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

585: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2000: Leaving Update_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
590: END IF;
591: IF (contract_doc_csr%ISOPEN) THEN
592: CLOSE contract_doc_csr ;
593: END IF;

Line 996: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2400: Leaving Delete_Contract_Doc: OKC_API.G_EXCEPTION_ERROR Exception');

992:
993: EXCEPTION
994: WHEN FND_API.G_EXC_ERROR THEN
995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2400: Leaving Delete_Contract_Doc: OKC_API.G_EXCEPTION_ERROR Exception');
997: END IF;
998: --close cursors
999: IF (fnd_attached_doc_csr%ISOPEN) THEN
1000: CLOSE fnd_attached_doc_csr ;

Line 1011: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Leaving Delete_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1007: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1008:
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1011: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Leaving Delete_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1012: END IF;
1013: IF (fnd_attached_doc_csr%ISOPEN) THEN
1014: CLOSE fnd_attached_doc_csr ;
1015: END IF;

Line 1386: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2900: Leaving Version_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');

1382:
1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1386: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2900: Leaving Version_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
1387: END IF;
1388: IF (datatype_csr%ISOPEN) THEN
1389: CLOSE datatype_csr ;
1390: END IF;

Line 1397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3000: Leaving Version_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1394:
1395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1396: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3000: Leaving Version_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1398: END IF;
1399: IF (datatype_csr%ISOPEN) THEN
1400: CLOSE datatype_csr ;
1401: END IF;

Line 1534: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');

1530:
1531: EXCEPTION
1532: WHEN FND_API.G_EXC_ERROR THEN
1533: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1534: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
1535: END IF;
1536: ROLLBACK TO Delete_Ver_Attachments_GRP;
1537: x_return_status := G_RET_STS_ERROR ;
1538: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 1542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1538: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1539:
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1543: END IF;
1544: ROLLBACK TO Delete_Ver_Attachments_GRP;
1545: x_return_status := G_RET_STS_UNEXP_ERROR ;
1546: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 1686: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4000: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');

1682:
1683: EXCEPTION
1684: WHEN FND_API.G_EXC_ERROR THEN
1685: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1686: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4000: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
1687: END IF;
1688: ROLLBACK TO Delete_Doc_Attachments_GRP;
1689: x_return_status := G_RET_STS_ERROR ;
1690: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 1694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4100: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1690: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4100: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1695: END IF;
1696: ROLLBACK TO Delete_Doc_Attachments_GRP;
1697: x_return_status := G_RET_STS_UNEXP_ERROR ;
1698: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2068: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4840: Leaving Copy_Attachment_Docs: OKC_API.G_EXCEPTION_ERROR Exception');

2064:
2065: EXCEPTION
2066: WHEN FND_API.G_EXC_ERROR THEN
2067: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2068: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4840: Leaving Copy_Attachment_Docs: OKC_API.G_EXCEPTION_ERROR Exception');
2069: END IF;
2070:
2071: --Bug 6468721
2072: IF (doc_version_view_name_csr%ISOPEN) THEN

Line 2081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4841: Leaving Copy_Attachment_Docs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2077: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2078:
2079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2080: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4841: Leaving Copy_Attachment_Docs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2082: END IF;
2083:
2084: --Bug 6468721
2085: IF (doc_version_view_name_csr%ISOPEN) THEN

Line 2298: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5081: Leaving Copy_Attachment_Refs: OKC_API.G_EXCEPTION_ERROR Exception');

2294:
2295: EXCEPTION
2296: WHEN FND_API.G_EXC_ERROR THEN
2297: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2298: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5081: Leaving Copy_Attachment_Refs: OKC_API.G_EXCEPTION_ERROR Exception');
2299: END IF;
2300: IF (category_csr%ISOPEN) THEN
2301: CLOSE category_csr ;
2302: END IF;

Line 2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5082: Leaving Copy_Attachment_Refs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2304: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2305:
2306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5082: Leaving Copy_Attachment_Refs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2309: END IF;
2310: IF (category_csr%ISOPEN) THEN
2311: CLOSE category_csr ;
2312: END IF;

Line 2478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');

2474:
2475: EXCEPTION
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
2479: END IF;
2480: ROLLBACK TO Copy_Attachments_GRP;
2481: x_return_status := G_RET_STS_ERROR ;
2482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2483:
2484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2487: END IF;
2488: ROLLBACK TO Copy_Attachments_GRP;
2489: x_return_status := G_RET_STS_UNEXP_ERROR ;
2490: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2590: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');

2586:
2587: EXCEPTION
2588: WHEN FND_API.G_EXC_ERROR THEN
2589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2590: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
2591: END IF;
2592: IF (l_get_qa_detail_csr%ISOPEN) THEN
2593: CLOSE l_get_qa_detail_csr ;
2594: END IF;

Line 2602: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2598:
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: ROLLBACK TO g_QA_Doc;
2601: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2602: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2603: END IF;
2604: IF (l_get_qa_detail_csr%ISOPEN) THEN
2605: CLOSE l_get_qa_detail_csr ;
2606: END IF;