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 676: okc_debug.log('1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);

672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: /*IF (l_debug = 'Y') THEN
676: okc_debug.log('1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
677: END IF;*/
678:
679: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
680: FND_LOG.STRING(G_EXCP_LEVEL,

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

677: END IF;*/
678:
679: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
680: FND_LOG.STRING(G_EXCP_LEVEL,
681: G_PKG_NAME, '1900: Leaving update_section: OKC_API.G_EXCEPTION_ERROR Exception' );
682: END IF;
683:
684: IF l_document_id_csr%ISOPEN THEN
685: CLOSE l_document_id_csr;

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

690: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
691:
692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: /*IF (l_debug = 'Y') THEN
694: okc_debug.log('2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
695: END IF;*/
696:
697: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
698: FND_LOG.STRING(G_EXCP_LEVEL,

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

695: END IF;*/
696:
697: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
698: FND_LOG.STRING(G_EXCP_LEVEL,
699: G_PKG_NAME, '2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
700: END IF;
701:
702: IF l_document_id_csr%ISOPEN THEN
703: CLOSE l_document_id_csr;

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

715: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
716: FND_LOG.STRING(G_EXCP_LEVEL,
717: G_PKG_NAME, '2100: Leaving update_section because of EXCEPTION: '||sqlerrm );
718: END IF;
719: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
720: p_msg_name => G_UNEXPECTED_ERROR,
721: p_token1 => G_SQLCODE_TOKEN,
722: p_token1_value => sqlcode,
723: p_token2 => G_SQLERRM_TOKEN,

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

922: FND_LOG.STRING(G_PROC_LEVEL,
923: G_PKG_NAME, '800: Error: Ref point should be either A,B or S' );
924: END IF;
925:
926: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');
927: RAISE FND_API.G_EXC_ERROR ;
928:
929: END IF;
930:

Line 1077: p_init_msg_list => OKC_API.G_FALSE,

1073: END IF;
1074:
1075: OKC_TERMS_SECTIONS_GRP.update_section(
1076: p_api_version =>1,
1077: p_init_msg_list => OKC_API.G_FALSE,
1078: x_return_status => x_return_status,
1079: x_msg_count => x_msg_count,
1080: x_msg_data => x_msg_data,
1081: p_mode => 'NORMAL',

Line 1100: p_init_msg_list => OKC_API.G_FALSE,

1096: END IF;
1097:
1098: OKC_K_ARTICLES_GRP.update_article(
1099: p_api_version =>1,
1100: p_init_msg_list => OKC_API.G_FALSE,
1101: x_return_status => x_return_status,
1102: x_msg_count => x_msg_count,
1103: x_msg_data => x_msg_data,
1104: p_mode => 'NORMAL',

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

1140:
1141: EXCEPTION
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: /*IF (l_debug = 'Y') THEN
1144: okc_debug.log('1200: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1145: END IF;*/
1146:
1147: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1148: FND_LOG.STRING(G_EXCP_LEVEL,

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

1145: END IF;*/
1146:
1147: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1148: FND_LOG.STRING(G_EXCP_LEVEL,
1149: G_PKG_NAME, '1200: Leaving add_section: OKC_API.G_EXCEPTION_ERROR Exception' );
1150: END IF;
1151:
1152: IF l_get_scn_csr%ISOPEN THEN
1153: CLOSE l_get_scn_csr;

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

1170: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1171:
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: /*IF (l_debug = 'Y') THEN
1174: okc_debug.log('1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1175: END IF;*/
1176:
1177: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1178: FND_LOG.STRING(G_EXCP_LEVEL,

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

1175: END IF;*/
1176:
1177: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1178: FND_LOG.STRING(G_EXCP_LEVEL,
1179: G_PKG_NAME, '1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1180: END IF;
1181:
1182: IF l_get_scn_csr%ISOPEN THEN
1183: CLOSE l_get_scn_csr;

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

1208: FND_LOG.STRING(G_EXCP_LEVEL,
1209: G_PKG_NAME, '1400: Leaving add_section because of EXCEPTION: '||sqlerrm );
1210: END IF;
1211:
1212: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1213: p_msg_name => G_UNEXPECTED_ERROR,
1214: p_token1 => G_SQLCODE_TOKEN,
1215: p_token1_value => sqlcode,
1216: p_token2 => G_SQLERRM_TOKEN,

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

1310:
1311: EXCEPTION
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: /*IF (l_debug = 'Y') THEN
1314: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1315: END IF;*/
1316:
1317: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1318: FND_LOG.STRING(G_EXCP_LEVEL,

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

1315: END IF;*/
1316:
1317: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1318: FND_LOG.STRING(G_EXCP_LEVEL,
1319: G_PKG_NAME, '1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception' );
1320: END IF;
1321: ROLLBACK TO g_lock_row_GRP;
1322: x_return_status := G_RET_STS_ERROR ;
1323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

1323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1324:
1325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1326: /*IF (l_debug = 'Y') THEN
1327: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1328: END IF;*/
1329:
1330: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1331: FND_LOG.STRING(G_EXCP_LEVEL,

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

1328: END IF;*/
1329:
1330: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1331: FND_LOG.STRING(G_EXCP_LEVEL,
1332: G_PKG_NAME, '1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1333: END IF;
1334: ROLLBACK TO g_lock_row_GRP;
1335: x_return_status := G_RET_STS_UNEXP_ERROR ;
1336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

1343: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1344: FND_LOG.STRING(G_EXCP_LEVEL,
1345: G_PKG_NAME, '1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm );
1346: END IF;
1347: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1348: p_msg_name => G_UNEXPECTED_ERROR,
1349: p_token1 => G_SQLCODE_TOKEN,
1350: p_token1_value => sqlcode,
1351: p_token2 => G_SQLERRM_TOKEN,

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

1677:
1678: EXCEPTION
1679: WHEN FND_API.G_EXC_ERROR THEN
1680: /*IF (l_debug = 'Y') THEN
1681: okc_debug.log('2400: Leaving delete_section: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1682: END IF;*/
1683:
1684: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1685: FND_LOG.STRING(G_EXCP_LEVEL,

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

1682: END IF;*/
1683:
1684: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1685: FND_LOG.STRING(G_EXCP_LEVEL,
1686: G_PKG_NAME, '2400: Leaving delete_section: OKC_API.G_EXCEPTION_ERROR Exception' );
1687: END IF;
1688:
1689: IF l_document_id_csr%ISOPEN THEN
1690: CLOSE l_document_id_csr;

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

1703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1704:
1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1706: /*IF (l_debug = 'Y') THEN
1707: okc_debug.log('2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1708: END IF;*/
1709:
1710: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1711: FND_LOG.STRING(G_EXCP_LEVEL,

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

1708: END IF;*/
1709:
1710: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1711: FND_LOG.STRING(G_EXCP_LEVEL,
1712: G_PKG_NAME, '2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1713: END IF;
1714:
1715: IF l_document_id_csr%ISOPEN THEN
1716: CLOSE l_document_id_csr;

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

1737: FND_LOG.STRING(G_EXCP_LEVEL,
1738: G_PKG_NAME, '2600: Leaving delete_section because of EXCEPTION: '||sqlerrm );
1739: END IF;
1740:
1741: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1742: p_msg_name => G_UNEXPECTED_ERROR,
1743: p_token1 => G_SQLCODE_TOKEN,
1744: p_token1_value => sqlcode,
1745: p_token2 => G_SQLERRM_TOKEN,