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

Line 9: g_fnd_app CONSTANT VARCHAR2 (200) := okc_api.g_fnd_app;

5: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: g_fnd_app CONSTANT VARCHAR2 (200) := okc_api.g_fnd_app;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: g_pkg_name CONSTANT VARCHAR2 (200)

Line 15: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;

11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: g_pkg_name CONSTANT VARCHAR2 (200)
14: := 'OKC_K_ENTITY_LOCKS_GRP';
15: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
16:
17: g_module CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS

Line 171: okc_api.set_message

167: '9990: exception - record does not exist'
168: );
169: END IF;
170:
171: okc_api.set_message
172: (p_app_name => g_app_name,
173: p_msg_name => 'OKC_BASE_ENT_NOT_FOUND'
174: );
175: x_rec_exists := 'N';

Line 187: okc_api.set_message (p_app_name => g_app_name,

183: '9992: exception - ' || SQLERRM
184: );
185: END IF;
186:
187: okc_api.set_message (p_app_name => g_app_name,
188: p_msg_name => g_unexpected_error,
189: p_token1 => g_sqlcode_token,
190: p_token1_value => SQLCODE,
191: p_token2 => g_sqlerrm_token,

Line 269: okc_api.set_message

265: THEN
266: x_lock_sts := 1;
267: x_return_status := g_ret_sts_success;
268: ELSE
269: okc_api.set_message
270: (p_app_name => g_app_name,
271: p_msg_name => 'OKC_BASE_ENT_LOCKED'
272: );
273: x_lock_sts := -1;

Line 285: okc_api.set_message

281: WHEN TOO_MANY_ROWS
282: THEN
283: x_return_status := g_ret_sts_error;
284: x_lock_sts := 2;
285: okc_api.set_message
286: (p_app_name => g_app_name,
287: p_msg_name => 'OKC_BASE_ENT_LOCKED'
288: );
289: WHEN OTHERS

Line 293: okc_api.set_message (p_app_name => g_app_name,

289: WHEN OTHERS
290: THEN
291: x_return_status := g_ret_sts_unexp_error;
292: x_lock_sts := NULL;
293: okc_api.set_message (p_app_name => g_app_name,
294: p_msg_name => g_unexpected_error,
295: p_token1 => g_sqlcode_token,
296: p_token1_value => SQLCODE,
297: p_token2 => g_sqlerrm_token,

Line 534: '9999: Leaving lock_entity: OKC_API.G_EXCEPTION_ERROR Exception'

530: THEN
531: fnd_log.STRING
532: (FND_LOG.LEVEL_STATEMENT,
533: g_pkg_name,
534: '9999: Leaving lock_entity: OKC_API.G_EXCEPTION_ERROR Exception'
535: );
536: END IF;
537:
538: ROLLBACK TO g_lock_entity_grp;

Line 551: '9999: Leaving lock_entity: OKC_API.G_RET_STS_UNEXP_ERROR Exception'

547: THEN
548: fnd_log.STRING
549: (FND_LOG.LEVEL_STATEMENT,
550: g_pkg_name,
551: '9999: Leaving lock_entity: OKC_API.G_RET_STS_UNEXP_ERROR Exception'
552: );
553: END IF;
554: okc_api.set_message (p_app_name => g_app_name,
555: p_msg_name => g_unexpected_error,

Line 554: okc_api.set_message (p_app_name => g_app_name,

550: g_pkg_name,
551: '9999: Leaving lock_entity: OKC_API.G_RET_STS_UNEXP_ERROR Exception'
552: );
553: END IF;
554: okc_api.set_message (p_app_name => g_app_name,
555: p_msg_name => g_unexpected_error,
556: p_token1 => g_sqlcode_token,
557: p_token1_value => SQLCODE,
558: p_token2 => g_sqlerrm_token,

Line 924: '0000: Leaving unlock_entity: OKC_API.G_EXCEPTION_ERROR Exception'

920: THEN
921: fnd_log.STRING
922: (FND_LOG.LEVEL_STATEMENT,
923: g_pkg_name,
924: '0000: Leaving unlock_entity: OKC_API.G_EXCEPTION_ERROR Exception'
925: );
926: END IF;
927:
928: ROLLBACK TO g_unlock_entity_grp;

Line 941: '0000: Leaving unlock_entity: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception'

937: THEN
938: fnd_log.STRING
939: (FND_LOG.LEVEL_STATEMENT,
940: g_pkg_name,
941: '0000: Leaving unlock_entity: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception'
942: );
943: END IF;
944:
945: ROLLBACK TO g_unlock_entity_grp;

Line 963: okc_api.set_message (p_app_name => g_app_name,

959: || SQLERRM
960: );
961: END IF;
962:
963: okc_api.set_message (p_app_name => g_app_name,
964: p_msg_name => g_unexpected_error,
965: p_token1 => g_sqlcode_token,
966: p_token1_value => SQLCODE,
967: p_token2 => g_sqlerrm_token,

Line 1144: okc_api.set_message

1140: IF l_get_art_csr%NOTFOUND
1141: THEN
1142: CLOSE l_get_art_csr;
1143:
1144: okc_api.set_message
1145: (p_app_name => g_app_name,
1146: p_msg_name => 'OKC_SRC_ART_NOT_FOUND_RVRT'
1147: );
1148: x_return_status := g_ret_sts_error;

Line 1170: okc_api.set_message

1166: END IF;
1167:
1168: IF NVL (l_target_doc_scn1_rec.amendment_operation_code, '?') = 'DELETED'
1169: THEN
1170: okc_api.set_message
1171: (p_app_name => g_app_name,
1172: p_msg_name => 'OKC_RVRT_SEC_BEFORE_ART'
1173: );
1174: x_return_status := g_ret_sts_error;

Line 1349: okc_api.set_message (p_app_name => g_app_name,

1345: );
1346: END IF;
1347:
1348: x_return_status := g_ret_sts_unexp_error;
1349: okc_api.set_message (p_app_name => g_app_name,
1350: p_msg_name => g_unexpected_error,
1351: p_token1 => g_sqlcode_token,
1352: p_token1_value => SQLCODE,
1353: p_token2 => g_sqlerrm_token,

Line 1436: okc_api.set_message (p_app_name => g_app_name,

1432: );
1433: END IF;
1434:
1435: x_return_status := g_ret_sts_unexp_error;
1436: okc_api.set_message (p_app_name => g_app_name,
1437: p_msg_name => g_unexpected_error,
1438: p_token1 => g_sqlcode_token,
1439: p_token1_value => SQLCODE,
1440: p_token2 => g_sqlerrm_token,

Line 1679: p_init_msg_list => okc_api.g_false,

1675:
1676: /* Call Copy Config API provided by Contract Expert Team */
1677: okc_xprt_cz_int_pvt.copy_configuration
1678: (p_api_version => 1,
1679: p_init_msg_list => okc_api.g_false,
1680: p_config_header_id => l_src_config_header_id,
1681: p_config_rev_nbr => l_src_config_revision_number,
1682: p_new_config_flag => fnd_api.g_true,
1683: x_new_config_header_id => l_new_config_header_id,

Line 1896: okc_api.set_message (p_app_name => g_app_name,

1892: );
1893: END IF;
1894:
1895: x_return_status := g_ret_sts_unexp_error;
1896: okc_api.set_message (p_app_name => g_app_name,
1897: p_msg_name => g_unexpected_error,
1898: p_token1 => g_sqlcode_token,
1899: p_token1_value => SQLCODE,
1900: p_token2 => g_sqlerrm_token,

Line 1962: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1958: OPEN cur_scn_details(l_tgt_scn_details_rec.orig_system_reference_id1);
1959: FETCH cur_scn_details INTO l_src_scn_details_rec;
1960: IF cur_scn_details%NOTFOUND THEN
1961: CLOSE cur_scn_details;
1962: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1963: p_msg_name => 'OKC_SRC_SEC_NOT_FOUND_RVRT'
1964: );
1965: x_return_status := G_RET_STS_ERROR;
1966: RAISE FND_API.G_EXC_ERROR;

Line 1978: okc_api.set_message

1974: CLOSE cur_scn_details1;
1975:
1976: IF l_parent_scn_details_rec.amendment_operation_code = 'DELETED'
1977: THEN
1978: okc_api.set_message
1979: (p_app_name => g_app_name,
1980: p_msg_name => 'OKC_RVRT_P_SEC_BEFORE_SEC',
1981: p_token1 => 'SEC_NAME',
1982: p_token1_value => l_parent_scn_details_rec.heading

Line 2073: okc_Api.Set_Message(p_app_name => G_APP_NAME,

2069: FROM okc_sections_b
2070: WHERE ID = p_source_section_id;
2071:
2072: IF SQL%ROWCOUNT = 0 THEN
2073: okc_Api.Set_Message(p_app_name => G_APP_NAME,
2074: p_msg_name => 'OKC_SRC_ART_NOT_FOUND_RVRT'
2075: );
2076: x_return_status := G_RET_STS_ERROR;
2077: RAISE FND_API.G_EXC_ERROR;

Line 2567: '0000: Leaving revert_changes: OKC_API.G_EXCEPTION_ERROR Exception'

2563: THEN
2564: fnd_log.STRING
2565: (FND_LOG.LEVEL_STATEMENT,
2566: g_pkg_name,
2567: '0000: Leaving revert_changes: OKC_API.G_EXCEPTION_ERROR Exception'
2568: );
2569: END IF;
2570:
2571: ROLLBACK TO g_revert_changes_grp;

Line 2584: '0000: Leaving revert_changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception'

2580: THEN
2581: fnd_log.STRING
2582: (FND_LOG.LEVEL_STATEMENT,
2583: g_pkg_name,
2584: '0000: Leaving revert_changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception'
2585: );
2586: END IF;
2587:
2588: ROLLBACK TO g_revert_changes_grp;

Line 2606: okc_api.set_message (p_app_name => g_app_name,

2602: || SQLERRM
2603: );
2604: END IF;
2605:
2606: okc_api.set_message (p_app_name => g_app_name,
2607: p_msg_name => g_unexpected_error,
2608: p_token1 => g_sqlcode_token,
2609: p_token1_value => SQLCODE,
2610: p_token2 => g_sqlerrm_token,

Line 2736: OKC_API.SET_MESSAGE( p_app_name => g_app_name

2732: OPEN cur_get_details_from_sections;
2733: FETCH cur_get_details_from_sections INTO x_src_doc_type,x_src_doc_id;
2734: IF cur_get_details_from_sections%NOTFOUND THEN
2735: x_return_status := G_RET_STS_ERROR;
2736: OKC_API.SET_MESSAGE( p_app_name => g_app_name
2737: , p_msg_name => 'OKC_SRC_DOC_NOT_FOUND');
2738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2739: fnd_log.STRING
2740: (FND_LOG.LEVEL_STATEMENT,

Line 3149: okc_api.set_message (p_app_name => g_app_name,

3145: EXCEPTION
3146: WHEN OTHERS THEN
3147: fnd_msg_pub.initialize;
3148: x_return_status := G_RET_STS_ERROR;
3149: okc_api.set_message (p_app_name => g_app_name,
3150: p_msg_name => g_unexpected_error,
3151: p_token1 => g_sqlcode_token,
3152: p_token1_value => SQLCODE,
3153: p_token2 => g_sqlerrm_token,

Line 3337: okc_api.set_message (p_app_name => g_app_name,

3333: EXCEPTION
3334: WHEN OTHERS
3335: THEN
3336: x_return_status := g_ret_sts_error;
3337: okc_api.set_message (p_app_name => g_app_name,
3338: p_msg_name => g_unexpected_error,
3339: p_token1 => g_sqlcode_token,
3340: p_token1_value => SQLCODE,
3341: p_token2 => g_sqlerrm_token,

Line 3557: okc_api.set_message (p_app_name => g_app_name,

3553: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3554: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving rebuild_ids because of EXCEPTION: '||sqlerrm);
3555: END IF;
3556:
3557: okc_api.set_message (p_app_name => g_app_name,
3558: p_msg_name => g_unexpected_error,
3559: p_token1 => g_sqlcode_token,
3560: p_token1_value => SQLCODE,
3561: p_token2 => g_sqlerrm_token,