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 138: okc_debug.log('700: updating article variable record ',2);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

443:
444: BEGIN
445:
446: IF (l_debug = 'Y') THEN
447: okc_debug.log('100: Entered update_local_var_values', 2);
448: END IF;
449:
450: -- Standard Start of API savepoint
451: SAVEPOINT g_update_local_var_values_GRP;

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

471: x_msg_data => x_msg_data,
472: x_msg_count => x_msg_count) ) THEN
473:
474: IF (l_debug = 'Y') THEN
475: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
476: END IF;
477: RAISE FND_API.G_EXC_ERROR ;
478: END IF;
479: END IF;

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

482: -- Initialize API return status to success
483: x_return_status := FND_API.G_RET_STS_SUCCESS;
484:
485: IF (l_debug = 'Y') THEN
486: okc_debug.log('400: Updating k article record', 2);
487: END IF;
488:
489: -- for Mode = AMEND mark articles as amended
490: IF p_mode='AMEND' THEN

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

550: -- Standard call to get message count and if count is 1, get message info.
551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
552:
553: IF (l_debug = 'Y') THEN
554: okc_debug.log('900: Leaving update_local_var_values', 2);
555: END IF;
556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN

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

556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: IF (l_debug = 'Y') THEN
560: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
561: END IF;
562:
563: ROLLBACK TO g_upd_article_var_values_GRP;
564: x_return_status := G_RET_STS_ERROR ;

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

565: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568: IF (l_debug = 'Y') THEN
569: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
570: );
571: END IF;
572:
573:

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

576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
577:
578: WHEN OTHERS THEN
579: IF (l_debug = 'Y') THEN
580: okc_debug.log('500: Leaving update_article_var_values because of EXCEPTION: '||sqlerrm, 2);
581: END IF;
582:
583:
584: ROLLBACK TO g_upd_article_var_values_GRP;

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

626:
627: BEGIN
628:
629: IF (l_debug = 'Y') THEN
630: okc_debug.log('100: Entered update_response_var_values', 2);
631: END IF;
632:
633: OPEN csr_new_cat_id;
634: FETCH csr_new_cat_id INTO l_cat_id;

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

634: FETCH csr_new_cat_id INTO l_cat_id;
635: CLOSE csr_new_cat_id;
636:
637: IF (l_debug = 'Y') THEN
638: okc_debug.log('200: l_cat_id : '||l_cat_id, 2);
639: END IF;
640:
641: -- now call update_local_var_values
642: update_local_var_values

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

661: p_override_global_yn => p_override_global_yn
662: );
663:
664: IF (l_debug = 'Y') THEN
665: okc_debug.log('900: Leaving update_response_var_values', 2);
666: END IF;
667:
668: EXCEPTION
669: WHEN OTHERS THEN

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

667:
668: EXCEPTION
669: WHEN OTHERS THEN
670: IF (l_debug = 'Y') THEN
671: okc_debug.log('500: Leaving update_response_var_values because of EXCEPTION: '||sqlerrm, 2);
672: END IF;
673: x_return_status := G_RET_STS_UNEXP_ERROR ;
674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );