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

Line 60: okc_debug.log('100: Entered Validate_Doc_Qa_List', 2);

56:
57: BEGIN
58:
59: IF (l_debug = 'Y') THEN
60: okc_debug.log('100: Entered Validate_Doc_Qa_List', 2);
61: END IF;
62:
63: -- Standard Start of API savepoint
64: SAVEPOINT g_Validate_Doc_Qa_List_GRP;

Line 100: okc_debug.log('200: Leaving Validate_Doc_Qa_List', 2);

96: -- Standard call to get message count and if count is 1, get message info.
97: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
98:
99: IF (l_debug = 'Y') THEN
100: okc_debug.log('200: Leaving Validate_Doc_Qa_List', 2);
101: END IF;
102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN

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

102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: IF (l_debug = 'Y') THEN
106: okc_debug.log('300: Leaving Validate_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
107: END IF;
108: ROLLBACK TO g_Validate_Doc_Qa_List_GRP;
109: x_return_status := G_RET_STS_ERROR ;
110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: IF (l_debug = 'Y') THEN
114: okc_debug.log('400: Leaving Validate_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
115: END IF;
116: ROLLBACK TO g_Validate_Doc_Qa_List_GRP;
117: x_return_status := G_RET_STS_UNEXP_ERROR ;
118: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

118: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
119:
120: WHEN OTHERS THEN
121: IF (l_debug = 'Y') THEN
122: okc_debug.log('500: Leaving Validate_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
123: END IF;
124:
125: ROLLBACK TO g_Validate_Doc_Qa_List_GRP;
126: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 170: okc_debug.log('600: Entered Insert_Doc_Qa_List', 2);

166: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
167: BEGIN
168:
169: IF (l_debug = 'Y') THEN
170: okc_debug.log('600: Entered Insert_Doc_Qa_List', 2);
171: END IF;
172:
173: -- Standard Start of API savepoint
174: SAVEPOINT g_Insert_Doc_Qa_List_GRP;

Line 215: okc_debug.log('700: Leaving Insert_Doc_Qa_List', 2);

211: -- Standard call to get message count and if count is 1, get message info.
212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
213:
214: IF (l_debug = 'Y') THEN
215: okc_debug.log('700: Leaving Insert_Doc_Qa_List', 2);
216: END IF;
217:
218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN

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

217:
218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN
220: IF (l_debug = 'Y') THEN
221: okc_debug.log('800: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
222: END IF;
223: ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
224: x_return_status := G_RET_STS_ERROR ;
225: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

225: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: IF (l_debug = 'Y') THEN
229: okc_debug.log('900: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
230: END IF;
231: ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
232: x_return_status := G_RET_STS_UNEXP_ERROR ;
233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
234:
235: WHEN OTHERS THEN
236: IF (l_debug = 'Y') THEN
237: okc_debug.log('1000: Leaving Insert_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
238: END IF;
239:
240: ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
241: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 268: okc_debug.log('1100: Entered Lock_Doc_Qa_List', 2);

264: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Doc_Qa_List';
265: BEGIN
266:
267: IF (l_debug = 'Y') THEN
268: okc_debug.log('1100: Entered Lock_Doc_Qa_List', 2);
269: END IF;
270:
271: -- Standard Start of API savepoint
272: SAVEPOINT g_Lock_Doc_Qa_List_GRP;

Line 305: okc_debug.log('1200: Leaving Lock_Doc_Qa_List', 2);

301: -- Standard call to get message count and if count is 1, get message info.
302: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
303:
304: IF (l_debug = 'Y') THEN
305: okc_debug.log('1200: Leaving Lock_Doc_Qa_List', 2);
306: END IF;
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN

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

307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: IF (l_debug = 'Y') THEN
311: okc_debug.log('1300: Leaving Lock_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
312: END IF;
313: ROLLBACK TO g_Lock_Doc_Qa_List_GRP;
314: x_return_status := G_RET_STS_ERROR ;
315: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

315: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: IF (l_debug = 'Y') THEN
319: okc_debug.log('1400: Leaving Lock_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
320: END IF;
321: ROLLBACK TO g_Lock_Doc_Qa_List_GRP;
322: x_return_status := G_RET_STS_UNEXP_ERROR ;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
324:
325: WHEN OTHERS THEN
326: IF (l_debug = 'Y') THEN
327: okc_debug.log('1500: Leaving Lock_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
328: END IF;
329:
330: ROLLBACK TO g_Lock_Doc_Qa_List_GRP;
331: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 368: okc_debug.log('1600: Entered Update_Doc_Qa_List', 2);

364:
365: BEGIN
366:
367: IF (l_debug = 'Y') THEN
368: okc_debug.log('1600: Entered Update_Doc_Qa_List', 2);
369: okc_debug.log('1700: Locking row', 2);
370: END IF;
371:
372: -- Standard Start of API savepoint

Line 369: okc_debug.log('1700: Locking row', 2);

365: BEGIN
366:
367: IF (l_debug = 'Y') THEN
368: okc_debug.log('1600: Entered Update_Doc_Qa_List', 2);
369: okc_debug.log('1700: Locking row', 2);
370: END IF;
371:
372: -- Standard Start of API savepoint
373: SAVEPOINT g_Update_Doc_Qa_List_GRP;

Line 413: okc_debug.log('1800: Leaving Update_Doc_Qa_List', 2);

409: -- Standard call to get message count and if count is 1, get message info.
410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
411:
412: IF (l_debug = 'Y') THEN
413: okc_debug.log('1800: Leaving Update_Doc_Qa_List', 2);
414: END IF;
415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN

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

415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: IF (l_debug = 'Y') THEN
419: okc_debug.log('1900: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
420: END IF;
421: ROLLBACK TO g_Update_Doc_Qa_List_GRP;
422: x_return_status := G_RET_STS_ERROR ;
423: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

423: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
424:
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: IF (l_debug = 'Y') THEN
427: okc_debug.log('2000: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
428: END IF;
429: ROLLBACK TO g_Update_Doc_Qa_List_GRP;
430: x_return_status := G_RET_STS_UNEXP_ERROR ;
431: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

431: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
432:
433: WHEN OTHERS THEN
434: IF (l_debug = 'Y') THEN
435: okc_debug.log('2100: Leaving Update_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
436: END IF;
437:
438: ROLLBACK TO g_Update_Doc_Qa_List_GRP;
439: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 468: okc_debug.log('2200: Entered Delete_Doc_Qa_List', 2);

464: l_api_name CONSTANT VARCHAR2(30) := 'g_Delete_Doc_Qa_List';
465: BEGIN
466:
467: IF (l_debug = 'Y') THEN
468: okc_debug.log('2200: Entered Delete_Doc_Qa_List', 2);
469: END IF;
470:
471: -- Standard Start of API savepoint
472: SAVEPOINT g_Delete_Doc_Qa_List_GRP;

Line 509: okc_debug.log('2300: Leaving Delete_Doc_Qa_List', 2);

505: -- Standard call to get message count and if count is 1, get message info.
506: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
507:
508: IF (l_debug = 'Y') THEN
509: okc_debug.log('2300: Leaving Delete_Doc_Qa_List', 2);
510: END IF;
511:
512: EXCEPTION
513: WHEN FND_API.G_EXC_ERROR THEN

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

511:
512: EXCEPTION
513: WHEN FND_API.G_EXC_ERROR THEN
514: IF (l_debug = 'Y') THEN
515: okc_debug.log('2400: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
516: END IF;
517: ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
518: x_return_status := G_RET_STS_ERROR ;
519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
520:
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: IF (l_debug = 'Y') THEN
523: okc_debug.log('2500: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
524: END IF;
525: ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
526: x_return_status := G_RET_STS_UNEXP_ERROR ;
527: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

527: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
528:
529: WHEN OTHERS THEN
530: IF (l_debug = 'Y') THEN
531: okc_debug.log('2600: Leaving Delete_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
532: END IF;
533:
534: ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
535: x_return_status := G_RET_STS_UNEXP_ERROR ;