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 118: okc_debug.log('600: Entered create_article', 2);

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

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

236: --------------------------------------------
237: IF p_document_type <> 'TEMPLATE' THEN
238:
239: IF (l_debug = 'Y') THEN
240: okc_debug.log('120: Variables of article '||p_sav_sae_id||' is being created',2);
241: END IF;
242:
243: FOR l_article_var_rec IN l_article_var_csr(p_article_version_id) LOOP
244: OKC_K_ART_VARIABLES_PVT.insert_row(

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

261: RAISE FND_API.G_EXC_ERROR ;
262: END IF;
263: --------------------------------------------
264: IF (l_debug = 'Y') THEN
265: okc_debug.log('130: Variables '||l_variable_code||' for cat_id '||l_cat_id||' is created',2);
266: END IF;
267: END LOOP;
268: END IF;
269:

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

274: -- Standard call to get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
276:
277: IF (l_debug = 'Y') THEN
278: okc_debug.log('700: Leaving create_article', 2);
279: END IF;
280:
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN

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

280:
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: IF (l_debug = 'Y') THEN
284: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
285: END IF;
286:
287: IF l_article_var_csr%ISOPEN THEN
288: CLOSE l_article_var_csr;

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

293: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: IF (l_debug = 'Y') THEN
297: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
298: END IF;
299:
300: IF l_article_var_csr%ISOPEN THEN
301: CLOSE l_article_var_csr;

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

307: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
308:
309: WHEN OTHERS THEN
310: IF (l_debug = 'Y') THEN
311: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);
312: END IF;
313:
314: IF l_article_var_csr%ISOPEN THEN
315: CLOSE l_article_var_csr;

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

377:
378: BEGIN
379:
380: IF (l_debug = 'Y') THEN
381: okc_debug.log('100: Entered validate_row', 2);
382: END IF;
383:
384: -- Standard Start of API savepoint
385: SAVEPOINT g_validate_row_GRP;

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

450: -- Standard call to get message count and if count is 1, get message info.
451: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
452:
453: IF (l_debug = 'Y') THEN
454: okc_debug.log('200: Leaving validate_row', 2);
455: END IF;
456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN

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

456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: IF (l_debug = 'Y') THEN
460: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
461: END IF;
462: ROLLBACK TO g_validate_row_GRP;
463: x_return_status := G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

464: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: IF (l_debug = 'Y') THEN
468: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
469: END IF;
470: ROLLBACK TO g_validate_row_GRP;
471: x_return_status := G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

472: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
473:
474: WHEN OTHERS THEN
475: IF (l_debug = 'Y') THEN
476: okc_debug.log('500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
477: END IF;
478:
479: ROLLBACK TO g_validate_row_GRP;
480: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

501: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
502: BEGIN
503:
504: IF (l_debug = 'Y') THEN
505: okc_debug.log('1100: Entered lock_row', 2);
506: END IF;
507:
508: -- Standard Start of API savepoint
509: SAVEPOINT g_lock_row_GRP;

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

537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
539:
540: IF (l_debug = 'Y') THEN
541: okc_debug.log('1200: Leaving lock_row', 2);
542: END IF;
543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN

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

543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: IF (l_debug = 'Y') THEN
547: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
548: END IF;
549: ROLLBACK TO g_lock_row_GRP;
550: x_return_status := G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: IF (l_debug = 'Y') THEN
555: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
556: END IF;
557: ROLLBACK TO g_lock_row_GRP;
558: x_return_status := G_RET_STS_UNEXP_ERROR ;
559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
560:
561: WHEN OTHERS THEN
562: IF (l_debug = 'Y') THEN
563: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);
564: END IF;
565:
566: ROLLBACK TO g_lock_row_GRP;
567: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

710:
711: BEGIN
712:
713: IF (l_debug = 'Y') THEN
714: okc_debug.log('1600: Entered update_article', 2);
715: END IF;
716:
717: -- Standard Start of API savepoint
718: SAVEPOINT g_update_article_grp;

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

743: x_msg_data => x_msg_data,
744: x_msg_count => x_msg_count) ) THEN
745:
746: IF (l_debug = 'Y') THEN
747: okc_debug.log('700: Issue with document header Record.Cannot commit', 2);
748: END IF;
749: RAISE FND_API.G_EXC_ERROR ;
750: END IF;
751: END IF;

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

844:
845:
846: -- creating new article variables
847: IF (l_debug = 'Y') THEN
848: okc_debug.log('1710: Creating New article variables for article version '|| l_article_version_id, 2);
849: END IF;
850:
851: FOR l_create_variable_rec IN l_create_variable_csr LOOP
852: OKC_K_ART_VARIABLES_PVT.insert_row(

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

870: END LOOP;
871:
872: -- deleting old article variables
873: IF (l_debug = 'Y') THEN
874: okc_debug.log('1710: Deleing old article variables for article version '|| p_article_version_id||' which are not present in new article version', 2);
875: END IF;
876:
877: FOR l_delete_variable_rec IN l_delete_variable_csr LOOP
878: OKC_K_ART_VARIABLES_PVT.delete_row(

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

891:
892:
893: -- Update old article variable values
894: IF (l_debug = 'Y') THEN
895: okc_debug.log('1710: Updating article variables values for article version '|| p_article_version_id, 2);
896: END IF;
897:
898: FOR l_update_variable_rec IN l_update_variable_csr LOOP
899:

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

925: -- Standard call to get message count and if count is 1, get message info.
926: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
927:
928: IF (l_debug = 'Y') THEN
929: okc_debug.log('1800: Leaving update_article', 2);
930: END IF;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN

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

931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: IF (l_debug = 'Y') THEN
935: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
936: END IF;
937:
938: IF l_document_id_csr%ISOPEN THEN
939: CLOSE l_document_id_csr;

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

960: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
963: IF (l_debug = 'Y') THEN
964: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
965: END IF;
966:
967: IF l_document_id_csr%ISOPEN THEN
968: CLOSE l_document_id_csr;

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

989: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
990:
991: WHEN OTHERS THEN
992: IF (l_debug = 'Y') THEN
993: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);
994: END IF;
995:
996: IF l_document_id_csr%ISOPEN THEN
997: CLOSE l_document_id_csr;

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

1073:
1074: BEGIN
1075:
1076: IF (l_debug = 'Y') THEN
1077: okc_debug.log('2200: Entered delete_article', 2);
1078: END IF;
1079:
1080: -- Standard Start of API savepoint
1081: SAVEPOINT g_delete_article_grp;

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

1129: x_msg_count => x_msg_count)
1130: ) THEN
1131:
1132: IF (l_debug = 'Y') THEN
1133: okc_debug.log('2250: Issue with document header Record.Cannot commit', 2) ;
1134: END IF;
1135: RAISE FND_API.G_EXC_ERROR ;
1136: END IF;
1137: END IF;

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

1174:
1175: IF p_mode<>'AMEND' or l_delete_rec THEN
1176: -- Delete Child records from OKC_K_ART_VARIABLES_TABLE
1177: IF (l_debug = 'Y') THEN
1178: okc_debug.log('2260: Deleting Child record from okc_k_art_varibles', 2) ;
1179: END IF;
1180:
1181: OKC_K_ART_VARIABLES_PVT.delete_set(
1182: x_return_status => x_return_status,

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

1189: RAISE FND_API.G_EXC_ERROR ;
1190: END IF;
1191:
1192: IF (l_debug = 'Y') THEN
1193: okc_debug.log('760: Deleting Record from okc_k_articles', 2) ;
1194: END IF;
1195: --------------------------------------------
1196: -- Calling Simple API for Deleting A Row
1197: --------------------------------------------

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

1215: -- Standard call to get message count and if count is 1, get message info.
1216: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1217:
1218: IF (l_debug = 'Y') THEN
1219: okc_debug.log('2300: Leaving delete_article', 2);
1220: END IF;
1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN

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

1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: IF (l_debug = 'Y') THEN
1225: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1226: END IF;
1227:
1228: IF l_document_id_csr%ISOPEN THEN
1229: CLOSE l_document_id_csr;

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

1235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: IF (l_debug = 'Y') THEN
1239: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1240: END IF;
1241:
1242: IF l_document_id_csr%ISOPEN THEN
1243: CLOSE l_document_id_csr;

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

1249: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1250:
1251: WHEN OTHERS THEN
1252: IF (l_debug = 'Y') THEN
1253: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);
1254: END IF;
1255:
1256: IF l_document_id_csr%ISOPEN THEN
1257: CLOSE l_document_id_csr;