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 FND_LOG

Line 33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

29: G_AMEND_CODE_DELETED CONSTANT VARCHAR2(30) := 'DELETED';
30: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
31: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: ---------------------------------------

Line 34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

30: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
31: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: ---------------------------------------
38: -- PROCEDURE validate_row --

Line 35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

31: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: ---------------------------------------
38: -- PROCEDURE validate_row --
39: ---------------------------------------

Line 90: FND_LOG.STRING(G_PROC_LEVEL,

86: okc_debug.log('100: Entered validate_row', 2);
87: END IF;*/
88:
89: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
90: FND_LOG.STRING(G_PROC_LEVEL,
91: G_PKG_NAME, '100: Entered validate_row' );
92: END IF;
93:
94: -- Standard Start of API savepoint

Line 162: FND_LOG.STRING(G_PROC_LEVEL,

158: okc_debug.log('200: Leaving validate_row', 2);
159: END IF;*/
160:
161: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
162: FND_LOG.STRING(G_PROC_LEVEL,
163: G_PKG_NAME, '200: Leaving validate_row' );
164: END IF;
165:
166: EXCEPTION

Line 173: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 186: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 199: FND_LOG.STRING(G_EXCP_LEVEL,

195: okc_debug.log('500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
196: END IF;*/
197:
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,

Line 278: FND_LOG.STRING(G_PROC_LEVEL,

274: okc_debug.log('600: Entered create_section', 2);
275: END IF;*/
276:
277: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
278: FND_LOG.STRING(G_PROC_LEVEL,
279: G_PKG_NAME, '600: Entered create_section' );
280: END IF;
281:
282: -- Standard Start of API savepoint

Line 367: FND_LOG.STRING(G_PROC_LEVEL,

363: okc_debug.log('700: Leaving create_section', 2);
364: END IF;*/
365:
366: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
367: FND_LOG.STRING(G_PROC_LEVEL,
368: G_PKG_NAME, '700: Leaving create_section' );
369: END IF;
370:
371: EXCEPTION

Line 378: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 391: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 404: FND_LOG.STRING(G_EXCP_LEVEL,

400: okc_debug.log('1000: Leaving create_section because of EXCEPTION: '||sqlerrm, 2);
401: END IF;*/
402:
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,

Line 501: FND_LOG.STRING(G_PROC_LEVEL,

497: okc_debug.log('1600: Entered update_section', 2);
498: END IF;*/
499:
500: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
501: FND_LOG.STRING(G_PROC_LEVEL,
502: G_PKG_NAME, '1600: Entered update_section' );
503: END IF;
504:
505: -- Standard Start of API savepoint

Line 541: FND_LOG.STRING(G_PROC_LEVEL,

537: okc_debug.log('700: Issue with document header Record.Cannot commit', 2);
538: END IF;*/
539:
540: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
541: FND_LOG.STRING(G_PROC_LEVEL,
542: G_PKG_NAME, '700: Issue with document header Record.Cannot commit' );
543: END IF;
544: RAISE FND_API.G_EXC_ERROR ;
545: END IF;

Line 631: FND_LOG.STRING(G_PROC_LEVEL,

627: okc_debug.log('1800: Leaving update_section', 2);
628: END IF;*/
629:
630: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
631: FND_LOG.STRING(G_PROC_LEVEL,
632: G_PKG_NAME, '1800: Leaving update_section' );
633: END IF;
634:
635: EXCEPTION

Line 642: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 660: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 678: FND_LOG.STRING(G_EXCP_LEVEL,

674: okc_debug.log('2100: Leaving update_section because of EXCEPTION: '||sqlerrm, 2);
675: END IF;*/
676:
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,

Line 837: FND_LOG.STRING(G_PROC_LEVEL,

833: okc_debug.log('600: Entered add_section', 2);
834: END IF;*/
835:
836: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
837: FND_LOG.STRING(G_PROC_LEVEL,
838: G_PKG_NAME, '600: Entered add_section' );
839: END IF;
840:
841: -- Standard Start of API savepoint

Line 868: FND_LOG.STRING(G_PROC_LEVEL,

864: okc_debug.log('700: Issue with document header Record.Cannot commit', 2);
865: END IF;*/
866:
867: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
868: FND_LOG.STRING(G_PROC_LEVEL,
869: G_PKG_NAME, '700: Issue with document header Record.Cannot commit' );
870: END IF;
871: RAISE FND_API.G_EXC_ERROR ;
872: END IF;

Line 884: FND_LOG.STRING(G_PROC_LEVEL,

880: okc_debug.log('800: Error: Ref point should be either A,B or S', 2);
881: END IF;*/
882:
883: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
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');

Line 963: FND_LOG.STRING(G_PROC_LEVEL,

959: okc_debug.log('900: Error: Reference not found', 2);
960: END IF;*/
961:
962: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
963: FND_LOG.STRING(G_PROC_LEVEL,
964: G_PKG_NAME, '900: Error: Reference not found' );
965: END IF;
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
967: END IF;

Line 1033: FND_LOG.STRING(G_PROC_LEVEL,

1029: okc_debug.log('1000: Updating Display Sequence of scn_id '||scn_tbl(k).id, 2);
1030: END IF;*/
1031:
1032: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1033: FND_LOG.STRING(G_PROC_LEVEL,
1034: G_PKG_NAME, '1000: Updating Display Sequence of scn_id '||scn_tbl(k).id );
1035: END IF;
1036:
1037: OKC_TERMS_SECTIONS_GRP.update_section(

Line 1056: FND_LOG.STRING(G_PROC_LEVEL,

1052: okc_debug.log('1200: Updating Display Sequence of cat_id '||scn_tbl(k).id, 2);
1053: END IF;*/
1054:
1055: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1056: FND_LOG.STRING(G_PROC_LEVEL,
1057: G_PKG_NAME, '1200: Updating Display Sequence of cat_id '||scn_tbl(k).id );
1058: END IF;
1059:
1060: OKC_K_ARTICLES_GRP.update_article(

Line 1099: FND_LOG.STRING(G_PROC_LEVEL,

1095: okc_debug.log('1100: Leaving add_section', 2);
1096: END IF;*/
1097:
1098: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1099: FND_LOG.STRING(G_PROC_LEVEL,
1100: G_PKG_NAME, '1100: Leaving add_section' );
1101: END IF;
1102:
1103: EXCEPTION

Line 1110: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 1140: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 1170: FND_LOG.STRING(G_EXCP_LEVEL,

1166: okc_debug.log('1400: Leaving add_section because of EXCEPTION: '||sqlerrm, 2);
1167: END IF;*/
1168:
1169: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
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,

Line 1228: FND_LOG.STRING(G_PROC_LEVEL,

1224: okc_debug.log('1100: Entered lock_row', 2);
1225: END IF;*/
1226:
1227: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1228: FND_LOG.STRING(G_PROC_LEVEL,
1229: G_PKG_NAME, '1100: Entered lock_row' );
1230: END IF;
1231:
1232: -- Standard Start of API savepoint

Line 1269: FND_LOG.STRING(G_PROC_LEVEL,

1265: okc_debug.log('1200: Leaving lock_row', 2);
1266: END IF;*/
1267:
1268: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1269: FND_LOG.STRING(G_PROC_LEVEL,
1270: G_PKG_NAME, '1200: Leaving lock_row' );
1271: END IF;
1272:
1273: EXCEPTION

Line 1280: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 1293: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 1306: FND_LOG.STRING(G_EXCP_LEVEL,

1302: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);
1303: END IF;*/
1304:
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,

Line 1382: FND_LOG.STRING(G_PROC_LEVEL,

1378: okc_debug.log('2200: Entered delete_section', 2);
1379: END IF;*/
1380:
1381: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1382: FND_LOG.STRING(G_PROC_LEVEL,
1383: G_PKG_NAME, '2200: Entered delete_section' );
1384: END IF;
1385:
1386: -- Standard Start of API savepoint

Line 1418: FND_LOG.STRING(G_PROC_LEVEL,

1414: okc_debug.log('2210: Issue with document header Record.Cannot commit', 2);
1415: END IF;*/
1416:
1417: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1418: FND_LOG.STRING(G_PROC_LEVEL,
1419: G_PKG_NAME, '2210: Issue with document header Record.Cannot commit' );
1420: END IF;
1421: RAISE FND_API.G_EXC_ERROR ;
1422: END IF;

Line 1446: FND_LOG.STRING(G_PROC_LEVEL,

1442: okc_debug.log('2220: Calling Delete API to delete Section '|| l_scn_id , 2);
1443: END IF;*/
1444:
1445: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1446: FND_LOG.STRING(G_PROC_LEVEL,
1447: G_PKG_NAME, '2220: Calling Delete API to delete Section '|| l_scn_id );
1448: END IF;
1449:
1450: OKC_TERMS_SECTIONS_GRP.delete_section(

Line 1475: FND_LOG.STRING(G_PROC_LEVEL,

1471: okc_debug.log('2230: Section '|| l_scn_id||' deleted' , 2);
1472: END IF;*/
1473:
1474: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1475: FND_LOG.STRING(G_PROC_LEVEL,
1476: G_PKG_NAME, '2230: Section '|| l_scn_id||' deleted' );
1477: END IF;
1478: END LOOP;
1479: IF l_subsection_csr%ISOPEN then

Line 1489: FND_LOG.STRING(G_PROC_LEVEL,

1485: okc_debug.log('2230: Going to delete Articles of section '|| p_id , 2);
1486: END IF;*/
1487:
1488: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1489: FND_LOG.STRING(G_PROC_LEVEL,
1490: G_PKG_NAME, '2230: Going to delete Articles of section '|| p_id );
1491: END IF;
1492:
1493: FOR l_article_rec IN l_get_article_csr(p_id) LOOP

Line 1524: FND_LOG.STRING(G_PROC_LEVEL,

1520: okc_debug.log('2240: Articles of section '|| p_id||' deleted' , 2);
1521: END IF;*/
1522:
1523: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1524: FND_LOG.STRING(G_PROC_LEVEL,
1525: G_PKG_NAME, '2240: Articles of section '|| p_id||' deleted' );
1526: END IF;
1527:
1528: IF p_mode='AMEND' THEN

Line 1594: FND_LOG.STRING(G_PROC_LEVEL,

1590: okc_debug.log('2300: Leaving delete_section', 2);
1591: END IF;*/
1592:
1593: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1594: FND_LOG.STRING(G_PROC_LEVEL,
1595: G_PKG_NAME, '2300: Leaving delete_section' );
1596: END IF;
1597:
1598: EXCEPTION

Line 1605: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 1631: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 1657: FND_LOG.STRING(G_EXCP_LEVEL,

1653: okc_debug.log('2600: Leaving delete_section because of EXCEPTION: '||sqlerrm, 2);
1654: END IF;*/
1655:
1656: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
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,