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

Line 75: okc_debug.log('100: Entered Validate_Allowed_Tmpl_Usages', 2);

71:
72: BEGIN
73:
74: IF (l_debug = 'Y') THEN
75: okc_debug.log('100: Entered Validate_Allowed_Tmpl_Usages', 2);
76: END IF;
77:
78: -- Standard Start of API savepoint
79: SAVEPOINT g_Validate_Allowed_Usages_GRP;

Line 131: okc_debug.log('200: Leaving Validate_Allowed_Tmpl_Usages', 2);

127: -- Standard call to get message count and if count is 1, get message info.
128: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
129:
130: IF (l_debug = 'Y') THEN
131: okc_debug.log('200: Leaving Validate_Allowed_Tmpl_Usages', 2);
132: END IF;
133:
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN

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

133:
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: IF (l_debug = 'Y') THEN
137: okc_debug.log('300: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
138: END IF;
139: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
140: x_return_status := G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: IF (l_debug = 'Y') THEN
145: okc_debug.log('400: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
146: END IF;
147: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
148: x_return_status := G_RET_STS_UNEXP_ERROR ;
149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
150:
151: WHEN OTHERS THEN
152: IF (l_debug = 'Y') THEN
153: okc_debug.log('500: Leaving Validate_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);
154: END IF;
155:
156: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
157: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 215: okc_debug.log('600: Entered Create_Allowed_Tmpl_Usages', 2);

211: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
212: BEGIN
213:
214: IF (l_debug = 'Y') THEN
215: okc_debug.log('600: Entered Create_Allowed_Tmpl_Usages', 2);
216: END IF;
217:
218: -- Standard Start of API savepoint
219: SAVEPOINT g_Create_Allowed_Usages_GRP;

Line 275: okc_debug.log('700: Leaving Create_Allowed_Tmpl_Usages', 2);

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

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

277:
278: EXCEPTION
279: WHEN FND_API.G_EXC_ERROR THEN
280: IF (l_debug = 'Y') THEN
281: okc_debug.log('800: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
282: END IF;
283: ROLLBACK TO g_Create_Allowed_Usages_GRP;
284: x_return_status := G_RET_STS_ERROR ;
285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
286:
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: IF (l_debug = 'Y') THEN
289: okc_debug.log('900: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
290: END IF;
291: ROLLBACK TO g_Create_Allowed_Usages_GRP;
292: x_return_status := G_RET_STS_UNEXP_ERROR ;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
294:
295: WHEN OTHERS THEN
296: IF (l_debug = 'Y') THEN
297: okc_debug.log('1000: Leaving Create_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);
298: END IF;
299:
300: ROLLBACK TO g_Create_Allowed_Usages_GRP;
301: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 327: okc_debug.log('1100: Entered Lock_Allowed_Tmpl_Usages', 2);

323: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Allowed_Tmpl_Usages';
324: BEGIN
325:
326: IF (l_debug = 'Y') THEN
327: okc_debug.log('1100: Entered Lock_Allowed_Tmpl_Usages', 2);
328: END IF;
329:
330: -- Standard Start of API savepoint
331: SAVEPOINT g_Lock_Allowed_Usages_GRP;

Line 363: okc_debug.log('1200: Leaving Lock_Allowed_Tmpl_Usages', 2);

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

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

365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: IF (l_debug = 'Y') THEN
369: okc_debug.log('1300: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
370: END IF;
371: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
372: x_return_status := G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: IF (l_debug = 'Y') THEN
377: okc_debug.log('1400: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
378: END IF;
379: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
380: x_return_status := G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN OTHERS THEN
384: IF (l_debug = 'Y') THEN
385: okc_debug.log('1500: Leaving Lock_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);
386: END IF;
387:
388: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
389: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 441: okc_debug.log('1600: Entered Update_Allowed_Tmpl_Usages', 2);

437:
438: BEGIN
439:
440: IF (l_debug = 'Y') THEN
441: okc_debug.log('1600: Entered Update_Allowed_Tmpl_Usages', 2);
442: okc_debug.log('1700: Locking row', 2);
443: END IF;
444:
445: -- Standard Start of API savepoint

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

438: BEGIN
439:
440: IF (l_debug = 'Y') THEN
441: okc_debug.log('1600: Entered Update_Allowed_Tmpl_Usages', 2);
442: okc_debug.log('1700: Locking row', 2);
443: END IF;
444:
445: -- Standard Start of API savepoint
446: SAVEPOINT g_Update_Allowed_Usages_GRP;

Line 502: okc_debug.log('1800: Leaving Update_Allowed_Tmpl_Usages', 2);

498: -- Standard call to get message count and if count is 1, get message info.
499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
500:
501: IF (l_debug = 'Y') THEN
502: okc_debug.log('1800: Leaving Update_Allowed_Tmpl_Usages', 2);
503: END IF;
504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN

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

504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: IF (l_debug = 'Y') THEN
508: okc_debug.log('1900: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
509: END IF;
510: ROLLBACK TO g_Update_Allowed_Usages_GRP;
511: x_return_status := G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: IF (l_debug = 'Y') THEN
516: okc_debug.log('2000: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
517: END IF;
518: ROLLBACK TO g_Update_Allowed_Usages_GRP;
519: x_return_status := G_RET_STS_UNEXP_ERROR ;
520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
521:
522: WHEN OTHERS THEN
523: IF (l_debug = 'Y') THEN
524: okc_debug.log('2100: Leaving Update_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);
525: END IF;
526:
527: ROLLBACK TO g_Update_Allowed_Usages_GRP;
528: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 556: okc_debug.log('2200: Entered Delete_Allowed_Tmpl_Usages', 2);

552: l_api_name CONSTANT VARCHAR2(30) := 'g_Delete_Allowed_Tmpl_Usages';
553: BEGIN
554:
555: IF (l_debug = 'Y') THEN
556: okc_debug.log('2200: Entered Delete_Allowed_Tmpl_Usages', 2);
557: END IF;
558:
559: -- Standard Start of API savepoint
560: SAVEPOINT g_Delete_Allowed_Usages_GRP;

Line 596: okc_debug.log('2300: Leaving Delete_Allowed_Tmpl_Usages', 2);

592: -- Standard call to get message count and if count is 1, get message info.
593: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
594:
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('2300: Leaving Delete_Allowed_Tmpl_Usages', 2);
597: END IF;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN

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

598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: IF (l_debug = 'Y') THEN
602: okc_debug.log('2400: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
603: END IF;
604: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
605: x_return_status := G_RET_STS_ERROR ;
606: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

606: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: IF (l_debug = 'Y') THEN
610: okc_debug.log('2500: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
611: END IF;
612: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
613: x_return_status := G_RET_STS_UNEXP_ERROR ;
614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
615:
616: WHEN OTHERS THEN
617: IF (l_debug = 'Y') THEN
618: okc_debug.log('2600: Leaving Delete_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);
619: END IF;
620:
621: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
622: x_return_status := G_RET_STS_UNEXP_ERROR ;