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 1388: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2900: Leaving Version_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');

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

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

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

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

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

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

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

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

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

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

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

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

2075:
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2079: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4840: Leaving Copy_Attachment_Docs: OKC_API.G_EXCEPTION_ERROR Exception');
2080: END IF;
2081:
2082: --Bug 6468721
2083: IF (doc_version_view_name_csr%ISOPEN) THEN

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

2088: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2089:
2090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2091: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2092: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4841: Leaving Copy_Attachment_Docs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2093: END IF;
2094:
2095: --Bug 6468721
2096: IF (doc_version_view_name_csr%ISOPEN) THEN

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

2305:
2306: EXCEPTION
2307: WHEN FND_API.G_EXC_ERROR THEN
2308: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5081: Leaving Copy_Attachment_Refs: OKC_API.G_EXCEPTION_ERROR Exception');
2310: END IF;
2311: IF (category_csr%ISOPEN) THEN
2312: CLOSE category_csr ;
2313: END IF;

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

2315: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2316:
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5082: Leaving Copy_Attachment_Refs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2320: END IF;
2321: IF (category_csr%ISOPEN) THEN
2322: CLOSE category_csr ;
2323: END IF;

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

2485:
2486: EXCEPTION
2487: WHEN FND_API.G_EXC_ERROR THEN
2488: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2489: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
2490: END IF;
2491: ROLLBACK TO Copy_Attachments_GRP;
2492: x_return_status := G_RET_STS_ERROR ;
2493: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

2493: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2494:
2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2498: END IF;
2499: ROLLBACK TO Copy_Attachments_GRP;
2500: x_return_status := G_RET_STS_UNEXP_ERROR ;
2501: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

2597:
2598: EXCEPTION
2599: WHEN FND_API.G_EXC_ERROR THEN
2600: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2601: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
2602: END IF;
2603: IF (l_get_qa_detail_csr%ISOPEN) THEN
2604: CLOSE l_get_qa_detail_csr ;
2605: END IF;

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

2609:
2610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2611: ROLLBACK TO g_QA_Doc;
2612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2614: END IF;
2615: IF (l_get_qa_detail_csr%ISOPEN) THEN
2616: CLOSE l_get_qa_detail_csr ;
2617: END IF;