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

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

5:
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) := 'OKC_TERMS_SECTIONS_GRP';

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

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_SECTIONS_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

Line 169: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);

165:
166: EXCEPTION
167: WHEN FND_API.G_EXC_ERROR THEN
168: /*IF (l_debug = 'Y') THEN
169: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
170: END IF;*/
171:
172: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
173: FND_LOG.STRING(G_EXCP_LEVEL,

Line 174: G_PKG_NAME, '300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception' );

170: END IF;*/
171:
172: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
173: FND_LOG.STRING(G_EXCP_LEVEL,
174: G_PKG_NAME, '300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception' );
175: END IF;
176: ROLLBACK TO g_validate_row_GRP;
177: x_return_status := G_RET_STS_ERROR ;
178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 182: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
179:
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: /*IF (l_debug = 'Y') THEN
182: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
183: END IF;*/
184:
185: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
186: FND_LOG.STRING(G_EXCP_LEVEL,

Line 187: G_PKG_NAME, '400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

183: END IF;*/
184:
185: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
186: FND_LOG.STRING(G_EXCP_LEVEL,
187: G_PKG_NAME, '400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
188: END IF;
189: ROLLBACK TO g_validate_row_GRP;
190: x_return_status := G_RET_STS_UNEXP_ERROR ;
191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

198: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
199: FND_LOG.STRING(G_EXCP_LEVEL,
200: G_PKG_NAME, '500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);
201: END IF;
202: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
203: p_msg_name => G_UNEXPECTED_ERROR,
204: p_token1 => G_SQLCODE_TOKEN,
205: p_token1_value => sqlcode,
206: p_token2 => G_SQLERRM_TOKEN,

Line 374: okc_debug.log('800: Leaving create_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);

370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: /*IF (l_debug = 'Y') THEN
374: okc_debug.log('800: Leaving create_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
375: END IF;*/
376:
377: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
378: FND_LOG.STRING(G_EXCP_LEVEL,

Line 379: G_PKG_NAME, '800: Leaving create_section: OKC_API.G_EXCEPTION_ERROR Exception');

375: END IF;*/
376:
377: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
378: FND_LOG.STRING(G_EXCP_LEVEL,
379: G_PKG_NAME, '800: Leaving create_section: OKC_API.G_EXCEPTION_ERROR Exception');
380: END IF;
381: ROLLBACK TO g_create_section_GRP;
382: x_return_status := G_RET_STS_ERROR ;
383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 387: okc_debug.log('900: Leaving create_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: /*IF (l_debug = 'Y') THEN
387: okc_debug.log('900: Leaving create_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
388: END IF;*/
389:
390: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
391: FND_LOG.STRING(G_EXCP_LEVEL,

Line 392: G_PKG_NAME, '900: Leaving create_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

388: END IF;*/
389:
390: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
391: FND_LOG.STRING(G_EXCP_LEVEL,
392: G_PKG_NAME, '900: Leaving create_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
393: END IF;
394: ROLLBACK TO g_create_section_GRP;
395: x_return_status := G_RET_STS_UNEXP_ERROR ;
396: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

403: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
404: FND_LOG.STRING(G_EXCP_LEVEL,
405: G_PKG_NAME, '1000: Leaving create_section because of EXCEPTION: '||sqlerrm);
406: END IF;
407: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
408: p_msg_name => G_UNEXPECTED_ERROR,
409: p_token1 => G_SQLCODE_TOKEN,
410: p_token1_value => sqlcode,
411: p_token2 => G_SQLERRM_TOKEN,

Line 638: okc_debug.log('1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);

634:
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: /*IF (l_debug = 'Y') THEN
638: okc_debug.log('1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
639: END IF;*/
640:
641: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
642: FND_LOG.STRING(G_EXCP_LEVEL,

Line 643: G_PKG_NAME, '1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception' );

639: END IF;*/
640:
641: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
642: FND_LOG.STRING(G_EXCP_LEVEL,
643: G_PKG_NAME, '1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception' );
644: END IF;
645:
646: IF l_document_id_csr%ISOPEN THEN
647: CLOSE l_document_id_csr;

Line 656: okc_debug.log('2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

652: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: /*IF (l_debug = 'Y') THEN
656: okc_debug.log('2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
657: END IF;*/
658:
659: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
660: FND_LOG.STRING(G_EXCP_LEVEL,

Line 661: G_PKG_NAME, '2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

657: END IF;*/
658:
659: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
660: FND_LOG.STRING(G_EXCP_LEVEL,
661: G_PKG_NAME, '2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
662: END IF;
663:
664: IF l_document_id_csr%ISOPEN THEN
665: CLOSE l_document_id_csr;

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

677: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
678: FND_LOG.STRING(G_EXCP_LEVEL,
679: G_PKG_NAME, '2100: Leaving update_section because of EXCEPTION: '||sqlerrm );
680: END IF;
681: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
682: p_msg_name => G_UNEXPECTED_ERROR,
683: p_token1 => G_SQLCODE_TOKEN,
684: p_token1_value => sqlcode,
685: p_token2 => G_SQLERRM_TOKEN,

Line 888: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');

884: FND_LOG.STRING(G_PROC_LEVEL,
885: G_PKG_NAME, '800: Error: Ref point should be either A,B or S' );
886: END IF;
887:
888: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');
889: RAISE FND_API.G_EXC_ERROR ;
890:
891: END IF;
892:

Line 1039: p_init_msg_list => OKC_API.G_FALSE,

1035: END IF;
1036:
1037: OKC_TERMS_SECTIONS_GRP.update_section(
1038: p_api_version =>1,
1039: p_init_msg_list => OKC_API.G_FALSE,
1040: x_return_status => x_return_status,
1041: x_msg_count => x_msg_count,
1042: x_msg_data => x_msg_data,
1043: p_mode => 'NORMAL',

Line 1062: p_init_msg_list => OKC_API.G_FALSE,

1058: END IF;
1059:
1060: OKC_K_ARTICLES_GRP.update_article(
1061: p_api_version =>1,
1062: p_init_msg_list => OKC_API.G_FALSE,
1063: x_return_status => x_return_status,
1064: x_msg_count => x_msg_count,
1065: x_msg_data => x_msg_data,
1066: p_mode => 'NORMAL',

Line 1106: okc_debug.log('1200: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1102:
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN
1105: /*IF (l_debug = 'Y') THEN
1106: okc_debug.log('1200: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1107: END IF;*/
1108:
1109: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1110: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1111: G_PKG_NAME, '1200: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception' );

1107: END IF;*/
1108:
1109: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1110: FND_LOG.STRING(G_EXCP_LEVEL,
1111: G_PKG_NAME, '1200: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception' );
1112: END IF;
1113:
1114: IF l_get_scn_csr%ISOPEN THEN
1115: CLOSE l_get_scn_csr;

Line 1136: okc_debug.log('1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1133:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: /*IF (l_debug = 'Y') THEN
1136: okc_debug.log('1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1137: END IF;*/
1138:
1139: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1140: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1141: G_PKG_NAME, '1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

1137: END IF;*/
1138:
1139: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1140: FND_LOG.STRING(G_EXCP_LEVEL,
1141: G_PKG_NAME, '1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1142: END IF;
1143:
1144: IF l_get_scn_csr%ISOPEN THEN
1145: CLOSE l_get_scn_csr;

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

1170: FND_LOG.STRING(G_EXCP_LEVEL,
1171: G_PKG_NAME, '1400: Leaving add_section because of EXCEPTION: '||sqlerrm );
1172: END IF;
1173:
1174: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1175: p_msg_name => G_UNEXPECTED_ERROR,
1176: p_token1 => G_SQLCODE_TOKEN,
1177: p_token1_value => sqlcode,
1178: p_token2 => G_SQLERRM_TOKEN,

Line 1276: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1272:
1273: EXCEPTION
1274: WHEN FND_API.G_EXC_ERROR THEN
1275: /*IF (l_debug = 'Y') THEN
1276: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1277: END IF;*/
1278:
1279: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1280: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1281: G_PKG_NAME, '1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception' );

1277: END IF;*/
1278:
1279: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1280: FND_LOG.STRING(G_EXCP_LEVEL,
1281: G_PKG_NAME, '1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception' );
1282: END IF;
1283: ROLLBACK TO g_lock_row_GRP;
1284: x_return_status := G_RET_STS_ERROR ;
1285: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1289: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1285: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: /*IF (l_debug = 'Y') THEN
1289: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1290: END IF;*/
1291:
1292: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1293: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1294: G_PKG_NAME, '1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

1290: END IF;*/
1291:
1292: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1293: FND_LOG.STRING(G_EXCP_LEVEL,
1294: G_PKG_NAME, '1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1295: END IF;
1296: ROLLBACK TO g_lock_row_GRP;
1297: x_return_status := G_RET_STS_UNEXP_ERROR ;
1298: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

1305: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1306: FND_LOG.STRING(G_EXCP_LEVEL,
1307: G_PKG_NAME, '1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm );
1308: END IF;
1309: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1310: p_msg_name => G_UNEXPECTED_ERROR,
1311: p_token1 => G_SQLCODE_TOKEN,
1312: p_token1_value => sqlcode,
1313: p_token2 => G_SQLERRM_TOKEN,

Line 1601: okc_debug.log('2400: Leaving delete_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1597:
1598: EXCEPTION
1599: WHEN FND_API.G_EXC_ERROR THEN
1600: /*IF (l_debug = 'Y') THEN
1601: okc_debug.log('2400: Leaving delete_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1602: END IF;*/
1603:
1604: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1605: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1606: G_PKG_NAME, '2400: Leaving delete_section: OKC_API.G_EXCEPTION_ERROR Exception' );

1602: END IF;*/
1603:
1604: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1605: FND_LOG.STRING(G_EXCP_LEVEL,
1606: G_PKG_NAME, '2400: Leaving delete_section: OKC_API.G_EXCEPTION_ERROR Exception' );
1607: END IF;
1608:
1609: IF l_document_id_csr%ISOPEN THEN
1610: CLOSE l_document_id_csr;

Line 1627: okc_debug.log('2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1623: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: /*IF (l_debug = 'Y') THEN
1627: okc_debug.log('2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1628: END IF;*/
1629:
1630: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1631: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1632: G_PKG_NAME, '2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

1628: END IF;*/
1629:
1630: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1631: FND_LOG.STRING(G_EXCP_LEVEL,
1632: G_PKG_NAME, '2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1633: END IF;
1634:
1635: IF l_document_id_csr%ISOPEN THEN
1636: CLOSE l_document_id_csr;

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

1657: FND_LOG.STRING(G_EXCP_LEVEL,
1658: G_PKG_NAME, '2600: Leaving delete_section because of EXCEPTION: '||sqlerrm );
1659: END IF;
1660:
1661: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1662: p_msg_name => G_UNEXPECTED_ERROR,
1663: p_token1 => G_SQLCODE_TOKEN,
1664: p_token1_value => sqlcode,
1665: p_token2 => G_SQLERRM_TOKEN,