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 OKC_API

Line 9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_NUMBER_SCHEME_DTL_GRP';

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_NUMBER_SCHEME_DTL_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

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

118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: /*IF (l_debug = 'Y') THEN
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,

Line 127: G_PKG_NAME, '300: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

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 ;
131: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

131: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
132:
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: /*IF (l_debug = 'Y') THEN
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,

Line 140: G_PKG_NAME, '400: Leaving Validate_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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 ;
144: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

261:
262: EXCEPTION
263: WHEN FND_API.G_EXC_ERROR THEN
264: /*IF (l_debug = 'Y') THEN
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,

Line 270: G_PKG_NAME, '800: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

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 ;
274: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

274: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: /*IF (l_debug = 'Y') THEN
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,

Line 283: G_PKG_NAME, '900: Leaving Insert_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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 ;
287: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

377:
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: /*IF (l_debug = 'Y') THEN
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,

Line 386: G_PKG_NAME, '1300: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

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 ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: /*IF (l_debug = 'Y') THEN
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,

Line 399: G_PKG_NAME, '1400: Leaving Lock_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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 ;
403: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: /*IF (l_debug = 'Y') THEN
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,

Line 522: G_PKG_NAME, '1900: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

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 ;
526: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

526: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: /*IF (l_debug = 'Y') THEN
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,

Line 535: G_PKG_NAME, '2000: Leaving Update_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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 ;
539: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

635:
636: EXCEPTION
637: WHEN FND_API.G_EXC_ERROR THEN
638: /*IF (l_debug = 'Y') THEN
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,

Line 644: G_PKG_NAME, '2400: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_ERROR Exception' );

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 ;
648: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

648: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
649:
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: /*IF (l_debug = 'Y') THEN
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,

Line 657: G_PKG_NAME, '2500: Leaving Delete_Number_Scheme_Dtl: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

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 ;
661: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );