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_ARTICLES_GRP dependencies on OKC_DEBUG

Line 121: okc_debug.log('600: Entered create_article', 2);

117:
118: BEGIN
119:
120: IF (l_debug = 'Y') THEN
121: okc_debug.log('600: Entered create_article', 2);
122: END IF;
123:
124: -- Standard Start of API savepoint
125: SAVEPOINT g_create_article_GRP;

Line 271: okc_debug.log('120: Variables of article '||p_sav_sae_id||' is being created',2);

267: --------------------------------------------
268: IF p_document_type <> 'TEMPLATE' THEN
269:
270: IF (l_debug = 'Y') THEN
271: okc_debug.log('120: Variables of article '||p_sav_sae_id||' is being created',2);
272: END IF;
273:
274: FOR l_article_var_rec IN l_article_var_csr(p_article_version_id) LOOP
275: OKC_K_ART_VARIABLES_PVT.insert_row(

Line 296: okc_debug.log('130: Variables '||l_variable_code||' for cat_id '||l_cat_id||' is created',2);

292: RAISE FND_API.G_EXC_ERROR ;
293: END IF;
294: --------------------------------------------
295: IF (l_debug = 'Y') THEN
296: okc_debug.log('130: Variables '||l_variable_code||' for cat_id '||l_cat_id||' is created',2);
297: END IF;
298: END LOOP;
299: END IF;
300:

Line 309: okc_debug.log('700: Leaving create_article', 2);

305: -- Standard call to get message count and if count is 1, get message info.
306: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
307:
308: IF (l_debug = 'Y') THEN
309: okc_debug.log('700: Leaving create_article', 2);
310: END IF;
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN

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

311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: IF (l_debug = 'Y') THEN
315: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
316: END IF;
317:
318: IF l_article_var_csr%ISOPEN THEN
319: CLOSE l_article_var_csr;

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

324: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: IF (l_debug = 'Y') THEN
328: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
329: END IF;
330:
331: IF l_article_var_csr%ISOPEN THEN
332: CLOSE l_article_var_csr;

Line 342: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);

338: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
339:
340: WHEN OTHERS THEN
341: IF (l_debug = 'Y') THEN
342: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);
343: END IF;
344:
345: IF l_article_var_csr%ISOPEN THEN
346: CLOSE l_article_var_csr;

Line 413: okc_debug.log('100: Entered validate_row', 2);

409:
410: BEGIN
411:
412: IF (l_debug = 'Y') THEN
413: okc_debug.log('100: Entered validate_row', 2);
414: END IF;
415:
416: -- Standard Start of API savepoint
417: SAVEPOINT g_validate_row_GRP;

Line 487: okc_debug.log('200: Leaving validate_row', 2);

483: -- Standard call to get message count and if count is 1, get message info.
484: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
485:
486: IF (l_debug = 'Y') THEN
487: okc_debug.log('200: Leaving validate_row', 2);
488: END IF;
489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN

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

489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: IF (l_debug = 'Y') THEN
493: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
494: END IF;
495: ROLLBACK TO g_validate_row_GRP;
496: x_return_status := G_RET_STS_ERROR ;
497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF (l_debug = 'Y') THEN
501: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
502: END IF;
503: ROLLBACK TO g_validate_row_GRP;
504: x_return_status := G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 509: okc_debug.log('500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);

505: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
506:
507: WHEN OTHERS THEN
508: IF (l_debug = 'Y') THEN
509: okc_debug.log('500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
510: END IF;
511:
512: ROLLBACK TO g_validate_row_GRP;
513: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 538: okc_debug.log('1100: Entered lock_row', 2);

534: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
535: BEGIN
536:
537: IF (l_debug = 'Y') THEN
538: okc_debug.log('1100: Entered lock_row', 2);
539: END IF;
540:
541: -- Standard Start of API savepoint
542: SAVEPOINT g_lock_row_GRP;

Line 574: okc_debug.log('1200: Leaving lock_row', 2);

570: -- Standard call to get message count and if count is 1, get message info.
571: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
572:
573: IF (l_debug = 'Y') THEN
574: okc_debug.log('1200: Leaving lock_row', 2);
575: END IF;
576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN

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

576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: IF (l_debug = 'Y') THEN
580: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
581: END IF;
582: ROLLBACK TO g_lock_row_GRP;
583: x_return_status := G_RET_STS_ERROR ;
584: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

584: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: IF (l_debug = 'Y') THEN
588: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
589: END IF;
590: ROLLBACK TO g_lock_row_GRP;
591: x_return_status := G_RET_STS_UNEXP_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 596: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);

592: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
593:
594: WHEN OTHERS THEN
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);
597: END IF;
598:
599: ROLLBACK TO g_lock_row_GRP;
600: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 750: okc_debug.log('1600: Entered update_article', 2);

746:
747: BEGIN
748:
749: IF (l_debug = 'Y') THEN
750: okc_debug.log('1600: Entered update_article', 2);
751: END IF;
752:
753: -- Standard Start of API savepoint
754: SAVEPOINT g_update_article_grp;

Line 788: okc_debug.log('700: Issue with document header Record.Cannot commit', 2);

784: x_msg_data => x_msg_data,
785: x_msg_count => x_msg_count) ) THEN
786:
787: IF (l_debug = 'Y') THEN
788: okc_debug.log('700: Issue with document header Record.Cannot commit', 2);
789: END IF;
790: RAISE FND_API.G_EXC_ERROR ;
791: END IF;
792: END IF;

Line 863: okc_debug.log('710: Before Calling Lock Entity', 2);

859: END IF;
860: --------------------------------------------
861:
862: IF (l_debug = 'Y') THEN
863: okc_debug.log('710: Before Calling Lock Entity', 2);
864: END IF;
865:
866:
867: okc_k_entity_locks_grp.lock_entity

Line 954: okc_debug.log('1710: Creating New article variables for article version '|| l_article_version_id, 2);

950:
951:
952: -- creating new article variables
953: IF (l_debug = 'Y') THEN
954: okc_debug.log('1710: Creating New article variables for article version '|| l_article_version_id, 2);
955: END IF;
956:
957: FOR l_create_variable_rec IN l_create_variable_csr LOOP
958: OKC_K_ART_VARIABLES_PVT.insert_row(

Line 980: okc_debug.log('1710: Deleing old article variables for article version '|| p_article_version_id||' which are not present in new article version', 2);

976: END LOOP;
977:
978: -- deleting old article variables
979: IF (l_debug = 'Y') THEN
980: okc_debug.log('1710: Deleing old article variables for article version '|| p_article_version_id||' which are not present in new article version', 2);
981: END IF;
982:
983: FOR l_delete_variable_rec IN l_delete_variable_csr LOOP
984: OKC_K_ART_VARIABLES_PVT.delete_row(

Line 1001: okc_debug.log('1710: Updating article variables values for article version '|| p_article_version_id, 2);

997:
998:
999: -- Update old article variable values
1000: IF (l_debug = 'Y') THEN
1001: okc_debug.log('1710: Updating article variables values for article version '|| p_article_version_id, 2);
1002: END IF;
1003:
1004: FOR l_update_variable_rec IN l_update_variable_csr LOOP
1005:

Line 1035: okc_debug.log('1800: Leaving update_article', 2);

1031: -- Standard call to get message count and if count is 1, get message info.
1032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1033:
1034: IF (l_debug = 'Y') THEN
1035: okc_debug.log('1800: Leaving update_article', 2);
1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN FND_API.G_EXC_ERROR THEN

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

1037:
1038: EXCEPTION
1039: WHEN FND_API.G_EXC_ERROR THEN
1040: IF (l_debug = 'Y') THEN
1041: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1042: END IF;
1043:
1044: IF l_document_id_csr%ISOPEN THEN
1045: CLOSE l_document_id_csr;

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

1066: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: IF (l_debug = 'Y') THEN
1070: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1071: END IF;
1072:
1073: IF l_document_id_csr%ISOPEN THEN
1074: CLOSE l_document_id_csr;

Line 1099: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);

1095: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1096:
1097: WHEN OTHERS THEN
1098: IF (l_debug = 'Y') THEN
1099: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);
1100: END IF;
1101:
1102: IF l_document_id_csr%ISOPEN THEN
1103: CLOSE l_document_id_csr;

Line 1185: okc_debug.log('2200: Entered delete_article', 2);

1181:
1182: BEGIN
1183:
1184: IF (l_debug = 'Y') THEN
1185: okc_debug.log('2200: Entered delete_article', 2);
1186: END IF;
1187:
1188: -- Standard Start of API savepoint
1189: SAVEPOINT g_delete_article_grp;

Line 1241: okc_debug.log('2250: Issue with document header Record.Cannot commit', 2) ;

1237: x_msg_count => x_msg_count)
1238: ) THEN
1239:
1240: IF (l_debug = 'Y') THEN
1241: okc_debug.log('2250: Issue with document header Record.Cannot commit', 2) ;
1242: END IF;
1243: RAISE FND_API.G_EXC_ERROR ;
1244: END IF;
1245: END IF;

Line 1340: okc_debug.log('2260: Deleting Child record from okc_k_art_varibles', 2) ;

1336:
1337: IF p_mode<>'AMEND' or l_delete_rec THEN
1338: -- Delete Child records from OKC_K_ART_VARIABLES_TABLE
1339: IF (l_debug = 'Y') THEN
1340: okc_debug.log('2260: Deleting Child record from okc_k_art_varibles', 2) ;
1341: END IF;
1342:
1343: OKC_K_ART_VARIABLES_PVT.delete_set(
1344: x_return_status => x_return_status,

Line 1355: okc_debug.log('760: Deleting Record from okc_k_articles', 2) ;

1351: RAISE FND_API.G_EXC_ERROR ;
1352: END IF;
1353:
1354: IF (l_debug = 'Y') THEN
1355: okc_debug.log('760: Deleting Record from okc_k_articles', 2) ;
1356: END IF;
1357: --------------------------------------------
1358: -- Calling Simple API for Deleting A Row
1359: --------------------------------------------

Line 1381: okc_debug.log('2300: Leaving delete_article', 2);

1377: -- Standard call to get message count and if count is 1, get message info.
1378: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1379:
1380: IF (l_debug = 'Y') THEN
1381: okc_debug.log('2300: Leaving delete_article', 2);
1382: END IF;
1383:
1384: EXCEPTION
1385: WHEN FND_API.G_EXC_ERROR THEN

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

1383:
1384: EXCEPTION
1385: WHEN FND_API.G_EXC_ERROR THEN
1386: IF (l_debug = 'Y') THEN
1387: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1388: END IF;
1389:
1390: IF l_document_id_csr%ISOPEN THEN
1391: CLOSE l_document_id_csr;

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

1397: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1398:
1399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1400: IF (l_debug = 'Y') THEN
1401: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1402: END IF;
1403:
1404: IF l_document_id_csr%ISOPEN THEN
1405: CLOSE l_document_id_csr;

Line 1415: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);

1411: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1412:
1413: WHEN OTHERS THEN
1414: IF (l_debug = 'Y') THEN
1415: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);
1416: END IF;
1417:
1418: IF l_document_id_csr%ISOPEN THEN
1419: CLOSE l_document_id_csr;