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_NUMBER_SCHEME_DTL_GRP dependencies on FND_LOG

Line 33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
30: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
31: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: ---------------------------------------

Line 34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

30: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
31: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: ---------------------------------------
38: -- PROCEDURE Validate_Number_Scheme_Dtl --

Line 35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

31: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: ---------------------------------------
38: -- PROCEDURE Validate_Number_Scheme_Dtl --
39: ---------------------------------------

Line 69: FND_LOG.STRING(G_PROC_LEVEL,

65: okc_debug.log('100: Entered Validate_Number_Scheme_Dtl', 2);
66: END IF;*/
67:
68: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
69: FND_LOG.STRING(G_PROC_LEVEL,
70: G_PKG_NAME, '100: Entered Validate_Number_Scheme_Dtl' );
71: END IF;
72:
73: -- Standard Start of API savepoint

Line 115: FND_LOG.STRING(G_PROC_LEVEL,

111: okc_debug.log('200: Leaving Validate_Number_Scheme_Dtl', 2);
112: END IF;*/
113:
114: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
115: FND_LOG.STRING(G_PROC_LEVEL,
116: G_PKG_NAME, '200: Leaving Validate_Number_Scheme_Dtl' );
117: END IF;
118:
119: EXCEPTION

Line 126: FND_LOG.STRING(G_EXCP_LEVEL,

122: okc_debug.log('300: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
123: END IF;*/
124:
125: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
126: FND_LOG.STRING(G_EXCP_LEVEL,
127: G_PKG_NAME, '300: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );
128: END IF;
129: ROLLBACK TO g_Validate_Num_Scheme_Dtl_GRP;
130: x_return_status := G_RET_STS_ERROR ;

Line 139: FND_LOG.STRING(G_EXCP_LEVEL,

135: okc_debug.log('400: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
136: END IF;*/
137:
138: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
139: FND_LOG.STRING(G_EXCP_LEVEL,
140: G_PKG_NAME, '400: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
141: END IF;
142: ROLLBACK TO g_Validate_Num_Scheme_Dtl_GRP;
143: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 152: FND_LOG.STRING(G_EXCP_LEVEL,

148: okc_debug.log('500: Leaving Validate_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);
149: END IF;*/
150:
151: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
152: FND_LOG.STRING(G_EXCP_LEVEL,
153: G_PKG_NAME, '500: Leaving Validate_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );
154: END IF;
155: ROLLBACK TO g_Validate_Num_Scheme_Dtl_GRP;
156: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 206: FND_LOG.STRING(G_PROC_LEVEL,

202: okc_debug.log('600: Entered Insert_Number_Scheme_Dtl', 2);
203: END IF;*/
204:
205: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
206: FND_LOG.STRING(G_PROC_LEVEL,
207: G_PKG_NAME, '600: Entered Insert_Number_Scheme_Dtl' );
208: END IF;
209:
210: -- Standard Start of API savepoint

Line 258: FND_LOG.STRING(G_PROC_LEVEL,

254: okc_debug.log('700: Leaving Insert_Number_Scheme_Dtl', 2);
255: END IF;*/
256:
257: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
258: FND_LOG.STRING(G_PROC_LEVEL,
259: G_PKG_NAME, '700: Leaving Insert_Number_Scheme_Dtl' );
260: END IF;
261:
262: EXCEPTION

Line 269: FND_LOG.STRING(G_EXCP_LEVEL,

265: okc_debug.log('800: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
266: END IF;*/
267:
268: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
269: FND_LOG.STRING(G_EXCP_LEVEL,
270: G_PKG_NAME, '800: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );
271: END IF;
272: ROLLBACK TO g_Insert_Number_Scheme_Dtl_GRP;
273: x_return_status := G_RET_STS_ERROR ;

Line 282: FND_LOG.STRING(G_EXCP_LEVEL,

278: okc_debug.log('900: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
279: END IF;*/
280:
281: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
282: FND_LOG.STRING(G_EXCP_LEVEL,
283: G_PKG_NAME, '900: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
284: END IF;
285: ROLLBACK TO g_Insert_Number_Scheme_Dtl_GRP;
286: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 295: FND_LOG.STRING(G_EXCP_LEVEL,

291: okc_debug.log('1000: Leaving Insert_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);
292: END IF;*/
293:
294: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
295: FND_LOG.STRING(G_EXCP_LEVEL,
296: G_PKG_NAME, '1000: Leaving Insert_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );
297: END IF;
298: ROLLBACK TO g_Insert_Number_Scheme_Dtl_GRP;
299: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 331: FND_LOG.STRING(G_PROC_LEVEL,

327: okc_debug.log('1100: Entered Lock_Number_Scheme_Dtl', 2);
328: END IF;*/
329:
330: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
331: FND_LOG.STRING(G_PROC_LEVEL,
332: G_PKG_NAME, '1100: Entered Lock_Number_Scheme_Dtl' );
333: END IF;
334:
335: -- Standard Start of API savepoint

Line 374: FND_LOG.STRING(G_PROC_LEVEL,

370: okc_debug.log('1200: Leaving Lock_Number_Scheme_Dtl', 2);
371: END IF;*/
372:
373: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
374: FND_LOG.STRING(G_PROC_LEVEL,
375: G_PKG_NAME, '1200: Leaving Lock_Number_Scheme_Dtl' );
376: END IF;
377:
378: EXCEPTION

Line 385: FND_LOG.STRING(G_EXCP_LEVEL,

381: okc_debug.log('1300: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
382: END IF;*/
383:
384: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
385: FND_LOG.STRING(G_EXCP_LEVEL,
386: G_PKG_NAME, '1300: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );
387: END IF;
388: ROLLBACK TO g_Lock_Number_Scheme_Dtl_GRP;
389: x_return_status := G_RET_STS_ERROR ;

Line 398: FND_LOG.STRING(G_EXCP_LEVEL,

394: okc_debug.log('1400: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
395: END IF;*/
396:
397: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
398: FND_LOG.STRING(G_EXCP_LEVEL,
399: G_PKG_NAME, '1400: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
400: END IF;
401: ROLLBACK TO g_Lock_Number_Scheme_Dtl_GRP;
402: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 411: FND_LOG.STRING(G_EXCP_LEVEL,

407: okc_debug.log('1500: Leaving Lock_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);
408: END IF;*/
409:
410: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
411: FND_LOG.STRING(G_EXCP_LEVEL,
412: G_PKG_NAME, '1500: Leaving Lock_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );
413: END IF;
414: ROLLBACK TO g_Lock_Number_Scheme_Dtl_GRP;
415: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 458: FND_LOG.STRING(G_PROC_LEVEL,

454: okc_debug.log('1700: Locking row', 2);
455: END IF;*/
456:
457: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
458: FND_LOG.STRING(G_PROC_LEVEL,
459: G_PKG_NAME, '1600: Entered Update_Number_Scheme_Dtl');
460: FND_LOG.STRING(G_PROC_LEVEL,
461: G_PKG_NAME, '1700: Locking row');
462: END IF;

Line 460: FND_LOG.STRING(G_PROC_LEVEL,

456:
457: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
458: FND_LOG.STRING(G_PROC_LEVEL,
459: G_PKG_NAME, '1600: Entered Update_Number_Scheme_Dtl');
460: FND_LOG.STRING(G_PROC_LEVEL,
461: G_PKG_NAME, '1700: Locking row');
462: END IF;
463:
464: -- Standard Start of API savepoint

Line 510: FND_LOG.STRING(G_PROC_LEVEL,

506: okc_debug.log('1800: Leaving Update_Number_Scheme_Dtl', 2);
507: END IF;*/
508:
509: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
510: FND_LOG.STRING(G_PROC_LEVEL,
511: G_PKG_NAME, '1800: Leaving Update_Number_Scheme_Dtl' );
512: END IF;
513:
514: EXCEPTION

Line 521: FND_LOG.STRING(G_EXCP_LEVEL,

517: okc_debug.log('1900: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
518: END IF;*/
519:
520: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
521: FND_LOG.STRING(G_EXCP_LEVEL,
522: G_PKG_NAME, '1900: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );
523: END IF;
524: ROLLBACK TO g_Update_Number_Scheme_Dtl_GRP;
525: x_return_status := G_RET_STS_ERROR ;

Line 534: FND_LOG.STRING(G_EXCP_LEVEL,

530: okc_debug.log('2000: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
531: END IF;*/
532:
533: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
534: FND_LOG.STRING(G_EXCP_LEVEL,
535: G_PKG_NAME, '2000: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
536: END IF;
537: ROLLBACK TO g_Update_Number_Scheme_Dtl_GRP;
538: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 547: FND_LOG.STRING(G_EXCP_LEVEL,

543: okc_debug.log('2100: Leaving Update_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);
544: END IF;*/
545:
546: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
547: FND_LOG.STRING(G_EXCP_LEVEL,
548: G_PKG_NAME, '2100: Leaving Update_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );
549: END IF;
550: ROLLBACK TO g_Update_Number_Scheme_Dtl_GRP;
551: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 585: FND_LOG.STRING(G_PROC_LEVEL,

581: okc_debug.log('2200: Entered Delete_Number_Scheme_Dtl', 2);
582: END IF;*/
583:
584: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
585: FND_LOG.STRING(G_PROC_LEVEL,
586: G_PKG_NAME, '2200: Entered Delete_Number_Scheme_Dtl' );
587: END IF;
588:
589: -- Standard Start of API savepoint

Line 632: FND_LOG.STRING(G_PROC_LEVEL,

628: okc_debug.log('2300: Leaving Delete_Number_Scheme_Dtl', 2);
629: END IF;*/
630:
631: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
632: FND_LOG.STRING(G_PROC_LEVEL,
633: G_PKG_NAME, '2300: Leaving Delete_Number_Scheme_Dtl' );
634: END IF;
635:
636: EXCEPTION

Line 643: FND_LOG.STRING(G_EXCP_LEVEL,

639: okc_debug.log('2400: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception', 2);
640: END IF;*/
641:
642: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
643: FND_LOG.STRING(G_EXCP_LEVEL,
644: G_PKG_NAME, '2400: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );
645: END IF;
646: ROLLBACK TO g_Delete_Number_Scheme_Dtl_GRP;
647: x_return_status := G_RET_STS_ERROR ;

Line 656: FND_LOG.STRING(G_EXCP_LEVEL,

652: okc_debug.log('2500: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
653: END IF;*/
654:
655: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
656: FND_LOG.STRING(G_EXCP_LEVEL,
657: G_PKG_NAME, '2500: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
658: END IF;
659: ROLLBACK TO g_Delete_Number_Scheme_Dtl_GRP;
660: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 669: FND_LOG.STRING(G_EXCP_LEVEL,

665: okc_debug.log('2600: Leaving Delete_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm, 2);
666: END IF;*/
667:
668: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
669: FND_LOG.STRING(G_EXCP_LEVEL,
670: G_PKG_NAME, '2600: Leaving Delete_Number_Scheme_Dtl because of EXCEPTION: '||sqlerrm );
671: END IF;
672: ROLLBACK TO g_Delete_Number_Scheme_Dtl_GRP;
673: x_return_status := G_RET_STS_UNEXP_ERROR ;