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

Line 62: okc_debug.log('100: Entered update_article_var_values', 2);

58: AND variable_code=p_variable_code;
59:
60: BEGIN
61: IF (l_debug = 'Y') THEN
62: okc_debug.log('100: Entered update_article_var_values', 2);
63: END IF;
64:
65: -- Standard Start of API savepoint
66: SAVEPOINT g_upd_article_var_values_GRP;

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

85: x_msg_data => x_msg_data,
86: x_msg_count => x_msg_count) ) THEN
87:
88: IF (l_debug = 'Y') THEN
89: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
90: END IF;
91: RAISE FND_API.G_EXC_ERROR ;
92: END IF;
93: END IF;

Line 99: okc_debug.log('400: Updating k article record', 2);

95: -- Initialize API return status to success
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97:
98: IF (l_debug = 'Y') THEN
99: okc_debug.log('400: Updating k article record', 2);
100: END IF;
101:
102: IF p_mode='AMEND' THEN
103:

Line 137: okc_debug.log('700: updating article variable record ',2);

133: FETCH l_get_art_var_csr INTO l_ovn;
134: IF l_get_art_var_csr%FOUND THEN
135:
136: IF (l_debug = 'Y') THEN
137: okc_debug.log('700: updating article variable record ',2);
138: END IF;
139:
140: OKC_K_ART_VARIABLES_PVT.update_row(
141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 157: okc_debug.log('800: updated article variable record ', 2);

153: RAISE FND_API.G_EXC_ERROR ;
154: END IF;
155: --------------------------------------------
156: IF (l_debug = 'Y') THEN
157: okc_debug.log('800: updated article variable record ', 2);
158: END IF;
159: END IF;
160: CLOSE l_get_art_var_csr;
161:

Line 171: okc_debug.log('900: Leaving update_article_var_values', 2);

167: -- Standard call to get message count and if count is 1, get message info.
168: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
169:
170: IF (l_debug = 'Y') THEN
171: okc_debug.log('900: Leaving update_article_var_values', 2);
172: END IF;
173:
174:
175: EXCEPTION

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

174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: IF (l_debug = 'Y') THEN
178: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
179: END IF;
180:
181: IF l_get_art_var_csr%ISOPEN THEN
182: CLOSE l_get_art_var_csr;

Line 191: okc_debug.log('400: Leavingupdate_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: IF (l_debug = 'Y') THEN
191: okc_debug.log('400: Leavingupdate_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
192: END IF;
193:
194: IF l_get_art_var_csr%ISOPEN THEN
195: CLOSE l_get_art_var_csr;

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

201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
202:
203: WHEN OTHERS THEN
204: IF (l_debug = 'Y') THEN
205: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);
206: END IF;
207:
208: IF l_get_art_var_csr%ISOPEN THEN
209: CLOSE l_get_art_var_csr;

Line 256: okc_debug.log('100: Entered update_global_var_values', 2);

252:
253: BEGIN
254:
255: IF (l_debug = 'Y') THEN
256: okc_debug.log('100: Entered update_global_var_values', 2);
257: END IF;
258:
259: -- Standard Start of API savepoint
260: SAVEPOINT g_update_global_var_values_GRP;

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

279: x_msg_data => x_msg_data,
280: x_msg_count => x_msg_count) ) THEN
281:
282: IF (l_debug = 'Y') THEN
283: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
284: END IF;
285: RAISE FND_API.G_EXC_ERROR ;
286: END IF;
287: END IF;

Line 319: okc_debug.log('400: Updating k article record', 2);

315: (SELECT id FROM okc_k_articles_b WHERE document_type = p_doc_type AND document_id = p_doc_id);
316:
317:
318: IF (l_debug = 'Y') THEN
319: okc_debug.log('400: Updating k article record', 2);
320: END IF;
321:
322: -- for Mode = AMEND mark articles as amended
323: IF p_mode='AMEND' THEN

Line 364: okc_debug.log('900: Leaving update_global_var_values', 2);

360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
362:
363: IF (l_debug = 'Y') THEN
364: okc_debug.log('900: Leaving update_global_var_values', 2);
365: END IF;
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN

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

366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: IF (l_debug = 'Y') THEN
370: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
371: END IF;
372:
373: IF l_get_cat_id_csr%ISOPEN THEN
374: CLOSE l_get_cat_id_csr;

Line 383: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2

379: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: IF (l_debug = 'Y') THEN
383: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
384: );
385: END IF;
386:
387: IF l_get_cat_id_csr%ISOPEN THEN

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

394: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
395:
396: WHEN OTHERS THEN
397: IF (l_debug = 'Y') THEN
398: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);
399: END IF;
400:
401: IF l_get_cat_id_csr%ISOPEN THEN
402: CLOSE l_get_cat_id_csr;

Line 442: okc_debug.log('100: Entered update_local_var_values', 2);

438:
439: BEGIN
440:
441: IF (l_debug = 'Y') THEN
442: okc_debug.log('100: Entered update_local_var_values', 2);
443: END IF;
444:
445: -- Standard Start of API savepoint
446: SAVEPOINT g_update_local_var_values_GRP;

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

465: x_msg_data => x_msg_data,
466: x_msg_count => x_msg_count) ) THEN
467:
468: IF (l_debug = 'Y') THEN
469: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
470: END IF;
471: RAISE FND_API.G_EXC_ERROR ;
472: END IF;
473: END IF;

Line 480: okc_debug.log('400: Updating k article record', 2);

476: -- Initialize API return status to success
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: IF (l_debug = 'Y') THEN
480: okc_debug.log('400: Updating k article record', 2);
481: END IF;
482:
483: -- for Mode = AMEND mark articles as amended
484: IF p_mode='AMEND' THEN

Line 547: okc_debug.log('900: Leaving update_local_var_values', 2);

543: -- Standard call to get message count and if count is 1, get message info.
544: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
545:
546: IF (l_debug = 'Y') THEN
547: okc_debug.log('900: Leaving update_local_var_values', 2);
548: END IF;
549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN

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

549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: IF (l_debug = 'Y') THEN
553: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
554: END IF;
555:
556: ROLLBACK TO g_upd_article_var_values_GRP;
557: x_return_status := G_RET_STS_ERROR ;

Line 562: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2

558: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: IF (l_debug = 'Y') THEN
562: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
563: );
564: END IF;
565:
566:

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

569: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
570:
571: WHEN OTHERS THEN
572: IF (l_debug = 'Y') THEN
573: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);
574: END IF;
575:
576:
577: ROLLBACK TO g_upd_article_var_values_GRP;

Line 623: okc_debug.log('100: Entered update_response_var_values', 2);

619:
620: BEGIN
621:
622: IF (l_debug = 'Y') THEN
623: okc_debug.log('100: Entered update_response_var_values', 2);
624: END IF;
625:
626: OPEN csr_new_cat_id;
627: FETCH csr_new_cat_id INTO l_cat_id;

Line 631: okc_debug.log('200: l_cat_id : '||l_cat_id, 2);

627: FETCH csr_new_cat_id INTO l_cat_id;
628: CLOSE csr_new_cat_id;
629:
630: IF (l_debug = 'Y') THEN
631: okc_debug.log('200: l_cat_id : '||l_cat_id, 2);
632: END IF;
633:
634: -- now call update_local_var_values
635: update_local_var_values

Line 658: okc_debug.log('900: Leaving update_response_var_values', 2);

654: p_override_global_yn => p_override_global_yn
655: );
656:
657: IF (l_debug = 'Y') THEN
658: okc_debug.log('900: Leaving update_response_var_values', 2);
659: END IF;
660:
661: EXCEPTION
662: WHEN OTHERS THEN

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

660:
661: EXCEPTION
662: WHEN OTHERS THEN
663: IF (l_debug = 'Y') THEN
664: okc_debug.log('500: Leaving update_response_var_values because of EXCEPTION: '||sqlerrm, 2);
665: END IF;
666: x_return_status := G_RET_STS_UNEXP_ERROR ;
667: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
668: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );