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_PO_MOD_PKG dependencies on OKC_API

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

4: ------------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'okc_po_mod_pkg';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application

Line 13: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:

Line 25: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;

21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
25: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
26:
27: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
28: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
29: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 27: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
25: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
26:
27: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
28: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
29: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
30: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
31:

Line 28: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;

24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
25: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
26:
27: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
28: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
29: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
30: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
31:
32:

Line 29: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

25: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
26:
27: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
28: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
29: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
30: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
31:
32:
33:

Line 30: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;

26:
27: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
28: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
29: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
30: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
31:
32:
33:
34: /*This procedure will get the readable format of the messages*/

Line 112: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

108: from okc_articles_all
109: where article_id = l_article_id;
110:
111: --Clause does not have a default section. So error out.
112: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
113: p_msg_name => 'OKC_NO_DEFAULT_SCN_FOR_CLAUSE',
114: p_token1 => 'P_CLS_TITLE',
115: p_token1_value => l_article_title);
116: x_return_status := G_RET_STS_ERROR;

Line 127: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving update_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');

123:
124: WHEN FND_API.G_EXC_ERROR THEN
125:
126: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving update_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');
128: END IF;
129:
130: ROLLBACK TO g_clause_default_section_GRP;
131: x_return_status := G_RET_STS_ERROR ;

Line 136: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
137: END IF;
138:
139: ROLLBACK TO g_clause_default_section_GRP;
140: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 259: OKC_API.init_msg_list(p_init_msg_list);

255: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_type ' || p_document_type);
256: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_document_id ' || p_document_id);
257: END IF;
258:
259: OKC_API.init_msg_list(p_init_msg_list);
260:
261: -- Standard Start of API savepoint
262: SAVEPOINT g_upd_clause_changes_GRP;
263:

Line 273: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

269: OPEN l_tmpl_doc_exist_csr;
270: FETCH l_tmpl_doc_exist_csr INTO l_terms_exist ;
271: IF l_tmpl_doc_exist_csr%NOTFOUND THEN
272: --Document does not have a template applied
273: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
274: p_msg_name => 'OKC_TERMS_DOES_NOT_EXIST');
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276: RAISE FND_API.G_EXC_ERROR ;
277: END IF;

Line 298: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

294: OPEN c_get_article_details_csr(l_new_article_version_id);
295: FETCH c_get_article_details_csr INTO l_get_art_details_rec ;
296: IF c_get_article_details_csr%NOTFOUND THEN
297: --Document does not have a template applied
298: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
299: p_msg_name => 'OKC_TERMS_INV_CLS_NAME',
300: p_token1 => 'P_CLS_TITLE',
301: p_token1_value => l_dummy);
302: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 357: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

353:
354: ELSE
355: /*Print error that section is null and so cannot add a clause to the PO*/
356: --Clause does not have a default section. So error out.
357: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
358: p_msg_name => 'OKC_NO_DEFAULT_SCN_FOR_CLAUSE',
359: p_token1 => 'P_CLS_TITLE',
360: p_token1_value => l_dummy);
361: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 460: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving update_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');

456:
457: WHEN FND_API.G_EXC_ERROR THEN
458:
459: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
460: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving update_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');
461: END IF;
462: IF c_get_clause_changes_csr%ISOPEN THEN
463: CLOSE c_get_clause_changes_csr;
464: END IF;

Line 490: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

486: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
491: END IF;
492:
493: ROLLBACK TO g_upd_clause_changes_GRP;
494: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 547: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving delete_mulmod_clause_changes: OKC_API.G_EXCEPTION_ERROR Exception');

543:
544: WHEN FND_API.G_EXC_ERROR THEN
545:
546: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving delete_mulmod_clause_changes: OKC_API.G_EXCEPTION_ERROR Exception');
548: END IF;
549:
550: ROLLBACK TO g_del_clause_changes_GRP;
551: x_return_status := G_RET_STS_ERROR ;

Line 556: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving delete_mulmod_clause_changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

552: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving delete_mulmod_clause_changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
557: END IF;
558:
559: ROLLBACK TO g_del_clause_changes_GRP;
560: x_return_status := G_RET_STS_UNEXP_ERROR ;