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

Line 50: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

46: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
47: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
48: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
49:
50: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
53:
54: ---------------------------------------------------------------------------

Line 51: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

47: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
48: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
49:
50: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
53:
54: ---------------------------------------------------------------------------
55: -- FUNCTION get_seq_id

Line 52: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

48: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
49:
50: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
53:
54: ---------------------------------------------------------------------------
55: -- FUNCTION get_seq_id
56: ---------------------------------------------------------------------------

Line 69: FND_LOG.STRING(G_PROC_LEVEL,

65: Okc_Debug.Log('100: Entered get_seq_id', 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 get_seq_id' );
71: END IF;
72:
73: IF( p_num_scheme_id IS NULL ) THEN

Line 87: FND_LOG.STRING(G_PROC_LEVEL,

83: Okc_Debug.Log('200: Leaving get_seq_id', 2);
84: END IF;*/
85:
86: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
87: FND_LOG.STRING(G_PROC_LEVEL,
88: G_PKG_NAME, '200: Leaving get_seq_id' );
89: END IF;
90: RETURN G_RET_STS_SUCCESS;
91: EXCEPTION

Line 99: FND_LOG.STRING(G_EXCP_LEVEL,

95: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
96: END IF;*/
97:
98: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
99: FND_LOG.STRING(G_EXCP_LEVEL,
100: G_PKG_NAME, '300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm );
101: END IF;
102:
103: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 159: FND_LOG.STRING(G_PROC_LEVEL,

155: Okc_Debug.Log('400: Entered get_rec', 2);
156: END IF;*/
157:
158: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
159: FND_LOG.STRING(G_PROC_LEVEL,
160: G_PKG_NAME, '400: Entered get_rec' );
161: END IF;
162:
163: -- Get current database values

Line 187: FND_LOG.STRING(G_PROC_LEVEL,

183: Okc_Debug.Log('500: Leaving get_rec ', 2);
184: END IF;*/
185:
186: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
187: FND_LOG.STRING(G_PROC_LEVEL,
188: G_PKG_NAME, '500: Leaving get_rec ' );
189: END IF;
190: RETURN G_RET_STS_SUCCESS ;
191:

Line 200: FND_LOG.STRING(G_EXCP_LEVEL,

196: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
197: END IF;*/
198:
199: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
200: FND_LOG.STRING(G_EXCP_LEVEL,
201: G_PKG_NAME, '600: Leaving get_rec because of EXCEPTION: '||sqlerrm );
202: END IF;
203:
204: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 249: FND_LOG.STRING(G_PROC_LEVEL,

245: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
246: END IF;*/
247:
248: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
249: FND_LOG.STRING(G_PROC_LEVEL,
250: G_PKG_NAME, '700: Entered Set_Attributes ' );
251: END IF;
252:
253: IF( p_num_scheme_id IS NOT NULL ) THEN

Line 302: FND_LOG.STRING(G_PROC_LEVEL,

298: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
299: END IF;*/
300:
301: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
302: FND_LOG.STRING(G_PROC_LEVEL,
303: G_PKG_NAME, '800: Leaving Set_Attributes ' );
304: END IF;
305:
306: RETURN G_RET_STS_SUCCESS ;

Line 314: FND_LOG.STRING(G_EXCP_LEVEL,

310: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
311: END IF;*/
312:
313: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
314: FND_LOG.STRING(G_EXCP_LEVEL,
315: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception' );
316: END IF;
317: RETURN G_RET_STS_ERROR;
318:

Line 325: FND_LOG.STRING(G_EXCP_LEVEL,

321: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
322: END IF;*/
323:
324: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
325: FND_LOG.STRING(G_EXCP_LEVEL,
326: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
327: END IF;
328: RETURN G_RET_STS_UNEXP_ERROR;
329:

Line 336: FND_LOG.STRING(G_EXCP_LEVEL,

332: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
333: END IF;*/
334:
335: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
336: FND_LOG.STRING(G_EXCP_LEVEL,
337: G_PKG_NAME, '1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm );
338: END IF;
339: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
340: p_msg_name => G_UNEXPECTED_ERROR,

Line 370: FND_LOG.STRING(G_PROC_LEVEL,

366: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
367: END IF;*/
368:
369: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
370: FND_LOG.STRING(G_PROC_LEVEL,
371: G_PKG_NAME, '1200: Entered Validate_Attributes' );
372: END IF;
373:
374: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN

Line 380: FND_LOG.STRING(G_PROC_LEVEL,

376: Okc_Debug.Log('1300: required values validation', 2);
377: END IF;*/
378:
379: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
380: FND_LOG.STRING(G_PROC_LEVEL,
381: G_PKG_NAME, '1300: required values validation' );
382: END IF;
383:
384: /*IF (l_debug = 'Y') THEN

Line 389: FND_LOG.STRING(G_PROC_LEVEL,

385: Okc_Debug.Log('1400: - attribute NUM_SCHEME_ID ', 2);
386: END IF;*/
387:
388: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
389: FND_LOG.STRING(G_PROC_LEVEL,
390: G_PKG_NAME, '1400: - attribute NUM_SCHEME_ID ' );
391: END IF;
392: IF ( p_num_scheme_id IS NULL) THEN
393: /*IF (l_debug = 'Y') THEN

Line 398: FND_LOG.STRING(G_PROC_LEVEL,

394: Okc_Debug.Log('1500: - attribute NUM_SCHEME_ID is invalid', 2);
395: END IF;*/
396:
397: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
398: FND_LOG.STRING(G_PROC_LEVEL,
399: G_PKG_NAME, '1500: - attribute NUM_SCHEME_ID is invalid' );
400: END IF;
401: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUM_SCHEME_ID');
402: l_return_status := G_RET_STS_ERROR;

Line 410: FND_LOG.STRING(G_PROC_LEVEL,

406: Okc_Debug.Log('1400: - attribute NUMBER_ARTICLE_YN ', 2);
407: END IF;*/
408:
409: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
410: FND_LOG.STRING(G_PROC_LEVEL,
411: G_PKG_NAME, '1400: - attribute NUMBER_ARTICLE_YN ' );
412: END IF;
413: IF ( p_number_article_yn IS NULL) THEN
414: /*IF (l_debug = 'Y') THEN

Line 419: FND_LOG.STRING(G_PROC_LEVEL,

415: Okc_Debug.Log('1500: - attribute NUMBER_ARTICLE_YN is invalid', 2);
416: END IF;*/
417:
418: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
419: FND_LOG.STRING(G_PROC_LEVEL,
420: G_PKG_NAME, '1500: - attribute NUMBER_ARTICLE_YN is invalid' );
421: END IF;
422: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUMBER_ARTICLE_YN');
423: l_return_status := G_RET_STS_ERROR;

Line 431: FND_LOG.STRING(G_PROC_LEVEL,

427: Okc_Debug.Log('1400: - attribute SCHEME_NAME ', 2);
428: END IF;*/
429:
430: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
431: FND_LOG.STRING(G_PROC_LEVEL,
432: G_PKG_NAME, '1400: - attribute SCHEME_NAME ' );
433: END IF;
434: IF ( p_scheme_name IS NULL) THEN
435: /*IF (l_debug = 'Y') THEN

Line 440: FND_LOG.STRING(G_PROC_LEVEL,

436: Okc_Debug.Log('1500: - attribute SCHEME_NAME is invalid', 2);
437: END IF;*/
438:
439: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
440: FND_LOG.STRING(G_PROC_LEVEL,
441: G_PKG_NAME, '1500: - attribute SCHEME_NAME is invalid' );
442: END IF;
443: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SCHEME_NAME');
444: l_return_status := G_RET_STS_ERROR;

Line 455: FND_LOG.STRING(G_PROC_LEVEL,

451: Okc_Debug.Log('1600: static values and range validation', 2);
452: END IF;*/
453:
454: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
455: FND_LOG.STRING(G_PROC_LEVEL,
456: G_PKG_NAME, '1600: static values and range validation' );
457: END IF;
458:
459: /*IF (l_debug = 'Y') THEN

Line 464: FND_LOG.STRING(G_PROC_LEVEL,

460: Okc_Debug.Log('1700: - attribute NUMBER_ARTICLE_YN ', 2);
461: END IF;*/
462:
463: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
464: FND_LOG.STRING(G_PROC_LEVEL,
465: G_PKG_NAME, '1700: - attribute NUMBER_ARTICLE_YN ' );
466: END IF;
467:
468: IF ( p_number_article_yn NOT IN ('Y','N') AND p_number_article_yn IS NOT NULL) THEN

Line 474: FND_LOG.STRING(G_PROC_LEVEL,

470: Okc_Debug.Log('1800: - attribute NUMBER_ARTICLE_YN is invalid', 2);
471: END IF;*/
472:
473: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
474: FND_LOG.STRING(G_PROC_LEVEL,
475: G_PKG_NAME, '1800: - attribute NUMBER_ARTICLE_YN is invalid' );
476: END IF;
477: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'NUMBER_ARTICLE_YN');
478: l_return_status := G_RET_STS_ERROR;

Line 489: FND_LOG.STRING(G_PROC_LEVEL,

485: Okc_Debug.Log('1900: lookup codes validation', 2);
486: END IF;*/
487:
488: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
489: FND_LOG.STRING(G_PROC_LEVEL,
490: G_PKG_NAME, '1900: lookup codes validation' );
491: END IF;
492: END IF;
493:

Line 500: FND_LOG.STRING(G_PROC_LEVEL,

496: Okc_Debug.Log('2100: foreigh keys validation ', 2);
497: END IF;*/
498:
499: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
500: FND_LOG.STRING(G_PROC_LEVEL,
501: G_PKG_NAME, '2100: foreigh keys validation ' );
502: END IF;
503: END IF;
504:

Line 511: FND_LOG.STRING(G_PROC_LEVEL,

507: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
508: END IF;*/
509:
510: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
511: FND_LOG.STRING(G_PROC_LEVEL,
512: G_PKG_NAME, '2400: Leaving Validate_Attributes ' );
513: END IF;
514:
515: RETURN l_return_status;

Line 522: FND_LOG.STRING(G_EXCP_LEVEL,

518: WHEN OTHERS THEN
519: --Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
520:
521: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
522: FND_LOG.STRING(G_EXCP_LEVEL,
523: G_PKG_NAME, '2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm );
524: END IF;
525: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
526: p_msg_name => G_UNEXPECTED_ERROR,

Line 560: FND_LOG.STRING(G_PROC_LEVEL,

556: Okc_Debug.Log('2600: Entered Validate_Record', 2);
557: END IF;*/
558:
559: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
560: FND_LOG.STRING(G_PROC_LEVEL,
561: G_PKG_NAME, '2600: Entered Validate_Record' );
562: END IF;
563:
564: --- Validate all non-missing attributes (Item Level Validation)

Line 579: FND_LOG.STRING(G_PROC_LEVEL,

575: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
576: END IF;*/
577:
578: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
579: FND_LOG.STRING(G_PROC_LEVEL,
580: G_PKG_NAME, '2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm );
581: END IF;
582: RETURN G_RET_STS_UNEXP_ERROR;
583: END IF;

Line 592: FND_LOG.STRING(G_PROC_LEVEL,

588: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
589: END IF;*/
590:
591: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
592: FND_LOG.STRING(G_PROC_LEVEL,
593: G_PKG_NAME, '2800: Entered Record Level Validations' );
594: END IF;
595:
596: /*+++++++++++++start of hand code +++++++++++++++++++*/

Line 606: FND_LOG.STRING(G_PROC_LEVEL,

602: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
603: END IF;*/
604:
605: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
606: FND_LOG.STRING(G_PROC_LEVEL,
607: G_PKG_NAME, '2900: Leaving Validate_Record : '||sqlerrm );
608: END IF;
609: RETURN l_return_status ;
610:

Line 619: FND_LOG.STRING(G_EXCP_LEVEL,

615: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
616: END IF;*/
617:
618: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
619: FND_LOG.STRING(G_EXCP_LEVEL,
620: G_PKG_NAME, '3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm );
621: END IF;
622:
623: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 666: FND_LOG.STRING(G_PROC_LEVEL,

662: Okc_Debug.Log('3100: Entered validate_row', 2);
663: END IF;*/
664:
665: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
666: FND_LOG.STRING(G_PROC_LEVEL,
667: G_PKG_NAME, '3100: Entered validate_row' );
668: END IF;
669:
670: -- Setting attributes

Line 702: FND_LOG.STRING(G_PROC_LEVEL,

698: Okc_Debug.Log('3200: Leaving validate_row', 2);
699: END IF;*/
700:
701: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
702: FND_LOG.STRING(G_PROC_LEVEL,
703: G_PKG_NAME, '3200: Leaving validate_row' );
704: END IF;
705:
706: EXCEPTION

Line 713: FND_LOG.STRING(G_EXCP_LEVEL,

709: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
710: END IF;*/
711:
712: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
713: FND_LOG.STRING(G_EXCP_LEVEL,
714: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception' );
715: END IF;
716: x_return_status := G_RET_STS_ERROR;
717:

Line 724: FND_LOG.STRING(G_EXCP_LEVEL,

720: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
721: END IF;*/
722:
723: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
724: FND_LOG.STRING(G_EXCP_LEVEL,
725: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
726: END IF;
727: x_return_status := G_RET_STS_UNEXP_ERROR;
728:

Line 735: FND_LOG.STRING(G_EXCP_LEVEL,

731: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
732: END IF;*/
733:
734: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
735: FND_LOG.STRING(G_EXCP_LEVEL,
736: G_PKG_NAME, '3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm );
737: END IF;
738: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
739: p_msg_name => G_UNEXPECTED_ERROR,

Line 774: FND_LOG.STRING(G_PROC_LEVEL,

770: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
771: END IF;*/
772:
773: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
774: FND_LOG.STRING(G_PROC_LEVEL,
775: G_PKG_NAME, '3600: Entered Insert_Row function' );
776: END IF;
777:
778: INSERT INTO OKC_NUMBER_SCHEMES_B(

Line 804: FND_LOG.STRING(G_PROC_LEVEL,

800: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
801: END IF;*/
802:
803: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
804: FND_LOG.STRING(G_PROC_LEVEL,
805: G_PKG_NAME, '3700: Leaving Insert_Row' );
806: END IF;
807:
808: RETURN( G_RET_STS_SUCCESS );

Line 818: FND_LOG.STRING(G_EXCP_LEVEL,

814: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
815: END IF;*/
816:
817: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
818: FND_LOG.STRING(G_EXCP_LEVEL,
819: G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
820: END IF;
821:
822: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 860: FND_LOG.STRING(G_PROC_LEVEL,

856: Okc_Debug.Log('3900: Entered Insert_Row function', 2);
857: END IF;*/
858:
859: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
860: FND_LOG.STRING(G_PROC_LEVEL,
861: G_PKG_NAME, '3900: Entered Insert_Row function' );
862: END IF;
863:
864: FOR l_lang_rec IN get_languages LOOP

Line 892: FND_LOG.STRING(G_PROC_LEVEL,

888: Okc_Debug.Log('4000: Leaving Insert_Row', 2);
889: END IF;*/
890:
891: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
892: FND_LOG.STRING(G_PROC_LEVEL,
893: G_PKG_NAME, '4000: Leaving Insert_Row' );
894: END IF;
895:
896: RETURN( G_RET_STS_SUCCESS );

Line 906: FND_LOG.STRING(G_EXCP_LEVEL,

902: Okc_Debug.Log('4100: Leaving Insert_Row:OTHERS Exception', 2);
903: END IF;*/
904:
905: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
906: FND_LOG.STRING(G_EXCP_LEVEL,
907: G_PKG_NAME, '4100: Leaving Insert_Row:OTHERS Exception' );
908: END IF;
909:
910: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 953: FND_LOG.STRING(G_PROC_LEVEL,

949: Okc_Debug.Log('4200: Entered Insert_Row', 2);
950: END IF;*/
951:
952: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
953: FND_LOG.STRING(G_PROC_LEVEL,
954: G_PKG_NAME, '4200: Entered Insert_Row' );
955: END IF;
956:
957: --- Setting item attributes

Line 1005: FND_LOG.STRING(G_PROC_LEVEL,

1001: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
1002: END IF;*/
1003:
1004: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1005: FND_LOG.STRING(G_PROC_LEVEL,
1006: G_PKG_NAME, '4300: Call the internal Insert_Row for Base Table' );
1007: END IF;
1008:
1009: x_return_status := Insert_Row(

Line 1035: FND_LOG.STRING(G_PROC_LEVEL,

1031: Okc_Debug.Log('4400: Call the internal Insert_Row for TL Table', 2);
1032: END IF;*/
1033:
1034: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1035: FND_LOG.STRING(G_PROC_LEVEL,
1036: G_PKG_NAME, '4400: Call the internal Insert_Row for TL Table' );
1037: END IF;
1038:
1039: x_return_status := Insert_Row(

Line 1061: FND_LOG.STRING(G_PROC_LEVEL,

1057: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
1058: END IF;*/
1059:
1060: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1061: FND_LOG.STRING(G_PROC_LEVEL,
1062: G_PKG_NAME, '4500: Leaving Insert_Row' );
1063: END IF;
1064:
1065: EXCEPTION

Line 1072: FND_LOG.STRING(G_EXCP_LEVEL,

1068: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1069: END IF;*/
1070:
1071: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1072: FND_LOG.STRING(G_EXCP_LEVEL,
1073: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
1074: END IF;
1075: x_return_status := G_RET_STS_ERROR;
1076:

Line 1083: FND_LOG.STRING(G_EXCP_LEVEL,

1079: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1080: END IF;*/
1081:
1082: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1083: FND_LOG.STRING(G_EXCP_LEVEL,
1084: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1085: END IF;
1086: x_return_status := G_RET_STS_UNEXP_ERROR;
1087:

Line 1094: FND_LOG.STRING(G_EXCP_LEVEL,

1090: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
1091: END IF;*/
1092:
1093: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1094: FND_LOG.STRING(G_EXCP_LEVEL,
1095: G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm );
1096: END IF;
1097: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1098: p_msg_name => G_UNEXPECTED_ERROR,

Line 1144: FND_LOG.STRING(G_PROC_LEVEL,

1140: Okc_Debug.Log('4900: Entered Lock_Row', 2);
1141: END IF;*/
1142:
1143: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1144: FND_LOG.STRING(G_PROC_LEVEL,
1145: G_PKG_NAME, '4900: Entered Lock_Row' );
1146: END IF;
1147:
1148: BEGIN

Line 1163: FND_LOG.STRING(G_EXCP_LEVEL,

1159: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1160: END IF;*/
1161:
1162: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1163: FND_LOG.STRING(G_EXCP_LEVEL,
1164: G_PKG_NAME, '5000: Leaving Lock_Row:E_Resource_Busy Exception' );
1165: END IF;
1166:
1167: IF (lock_csr%ISOPEN) THEN

Line 1200: FND_LOG.STRING(G_PROC_LEVEL,

1196: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1197: END IF;*/
1198:
1199: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1200: FND_LOG.STRING(G_PROC_LEVEL,
1201: G_PKG_NAME, '5100: Leaving Lock_Row' );
1202: END IF;
1203:
1204: RETURN( l_return_status );

Line 1221: FND_LOG.STRING(G_EXCP_LEVEL,

1217: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1218: END IF;*/
1219:
1220: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1221: FND_LOG.STRING(G_EXCP_LEVEL,
1222: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1223: END IF;
1224:
1225: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1261: FND_LOG.STRING(G_PROC_LEVEL,

1257: Okc_Debug.Log('5300: Entered Lock_Row', 2);
1258: END IF;*/
1259:
1260: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1261: FND_LOG.STRING(G_PROC_LEVEL,
1262: G_PKG_NAME, '5300: Entered Lock_Row' );
1263: END IF;
1264:
1265: BEGIN

Line 1280: FND_LOG.STRING(G_EXCP_LEVEL,

1276: Okc_Debug.Log('5400: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1277: END IF;*/
1278:
1279: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1280: FND_LOG.STRING(G_EXCP_LEVEL,
1281: G_PKG_NAME, '5400: Leaving Lock_Row:E_Resource_Busy Exception' );
1282: END IF;
1283:
1284: IF (lock_csr%ISOPEN) THEN

Line 1303: FND_LOG.STRING(G_PROC_LEVEL,

1299: Okc_Debug.Log('5500: Leaving Lock_Row', 2);
1300: END IF;*/
1301:
1302: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1303: FND_LOG.STRING(G_PROC_LEVEL,
1304: G_PKG_NAME, '5500: Leaving Lock_Row' );
1305: END IF;
1306:
1307: RETURN( l_return_status );

Line 1321: FND_LOG.STRING(G_PROC_LEVEL,

1317: Okc_Debug.Log('5600: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1318: END IF;*/
1319:
1320: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1321: FND_LOG.STRING(G_PROC_LEVEL,
1322: G_PKG_NAME, '5600: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1323: END IF;
1324:
1325: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1352: FND_LOG.STRING(G_PROC_LEVEL,

1348: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1349: END IF;*/
1350:
1351: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1352: FND_LOG.STRING(G_PROC_LEVEL,
1353: G_PKG_NAME, '5700: Entered Lock_Row' );
1354: FND_LOG.STRING(G_PROC_LEVEL,
1355: G_PKG_NAME, '5800: Locking Row for Base Table' );
1356: END IF;

Line 1354: FND_LOG.STRING(G_PROC_LEVEL,

1350:
1351: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1352: FND_LOG.STRING(G_PROC_LEVEL,
1353: G_PKG_NAME, '5700: Entered Lock_Row' );
1354: FND_LOG.STRING(G_PROC_LEVEL,
1355: G_PKG_NAME, '5800: Locking Row for Base Table' );
1356: END IF;
1357:
1358: --------------------------------------------

Line 1381: FND_LOG.STRING(G_PROC_LEVEL,

1377: Okc_Debug.Log('5900: Locking Row for TL Table', 2);
1378: END IF;*/
1379:
1380: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1381: FND_LOG.STRING(G_PROC_LEVEL,
1382: G_PKG_NAME, '5900: Locking Row for TL Table' );
1383: END IF;
1384: x_return_status := Lock_Row(
1385: p_num_scheme_id => p_num_scheme_id

Line 1399: FND_LOG.STRING(G_PROC_LEVEL,

1395: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1396: END IF;*/
1397:
1398: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1399: FND_LOG.STRING(G_PROC_LEVEL,
1400: G_PKG_NAME, '6000: Leaving Lock_Row' );
1401: END IF;
1402:
1403: EXCEPTION

Line 1410: FND_LOG.STRING(G_EXCP_LEVEL,

1406: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1407: END IF;*/
1408:
1409: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1410: FND_LOG.STRING(G_EXCP_LEVEL,
1411: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
1412: END IF;
1413: x_return_status := G_RET_STS_ERROR;
1414:

Line 1421: FND_LOG.STRING(G_EXCP_LEVEL,

1417: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1418: END IF;*/
1419:
1420: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1421: FND_LOG.STRING(G_EXCP_LEVEL,
1422: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1423: END IF;
1424: x_return_status := G_RET_STS_UNEXP_ERROR;
1425:

Line 1432: FND_LOG.STRING(G_EXCP_LEVEL,

1428: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1429: END IF;*/
1430:
1431: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1432: FND_LOG.STRING(G_EXCP_LEVEL,
1433: G_PKG_NAME, '6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1434: END IF;
1435: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1436: p_msg_name => G_UNEXPECTED_ERROR,

Line 1467: FND_LOG.STRING(G_PROC_LEVEL,

1463: Okc_Debug.Log('6400: Entered Update_Row', 2);
1464: END IF;*/
1465:
1466: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1467: FND_LOG.STRING(G_PROC_LEVEL,
1468: G_PKG_NAME, '6400: Entered Update_Row' );
1469: END IF;
1470:
1471: UPDATE OKC_NUMBER_SCHEMES_B

Line 1485: FND_LOG.STRING(G_PROC_LEVEL,

1481: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1482: END IF;*/
1483:
1484: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1485: FND_LOG.STRING(G_PROC_LEVEL,
1486: G_PKG_NAME, '6500: Leaving Update_Row' );
1487: END IF;
1488:
1489: RETURN G_RET_STS_SUCCESS ;

Line 1499: FND_LOG.STRING(G_EXCP_LEVEL,

1495: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1496: END IF;*/
1497:
1498: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1499: FND_LOG.STRING(G_EXCP_LEVEL,
1500: G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1501: END IF;
1502:
1503: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1533: FND_LOG.STRING(G_PROC_LEVEL,

1529: Okc_Debug.Log('6700: Entered Update_Row', 2);
1530: END IF;*/
1531:
1532: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1533: FND_LOG.STRING(G_PROC_LEVEL,
1534: G_PKG_NAME, '6700: Entered Update_Row' );
1535: END IF;
1536:
1537: UPDATE OKC_NUMBER_SCHEMES_TL

Line 1551: FND_LOG.STRING(G_PROC_LEVEL,

1547: Okc_Debug.Log('6800: Leaving Update_Row', 2);
1548: END IF;*/
1549:
1550: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1551: FND_LOG.STRING(G_PROC_LEVEL,
1552: G_PKG_NAME, '6800: Leaving Update_Row' );
1553: END IF;
1554:
1555: RETURN G_RET_STS_SUCCESS ;

Line 1565: FND_LOG.STRING(G_EXCP_LEVEL,

1561: Okc_Debug.Log('6900: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1562: END IF;*/
1563:
1564: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1565: FND_LOG.STRING(G_EXCP_LEVEL,
1566: G_PKG_NAME, '6900: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1567: END IF;
1568:
1569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1613: FND_LOG.STRING(G_PROC_LEVEL,

1609: Okc_Debug.Log('7100: Locking _B row', 2);
1610: END IF;*/
1611:
1612: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1613: FND_LOG.STRING(G_PROC_LEVEL,
1614: G_PKG_NAME, '7000: Entered Update_Row' );
1615: FND_LOG.STRING(G_PROC_LEVEL,
1616: G_PKG_NAME, '7100: Locking _B row' );
1617: END IF;

Line 1615: FND_LOG.STRING(G_PROC_LEVEL,

1611:
1612: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1613: FND_LOG.STRING(G_PROC_LEVEL,
1614: G_PKG_NAME, '7000: Entered Update_Row' );
1615: FND_LOG.STRING(G_PROC_LEVEL,
1616: G_PKG_NAME, '7100: Locking _B row' );
1617: END IF;
1618:
1619: x_return_status := Lock_row(

Line 1634: FND_LOG.STRING(G_PROC_LEVEL,

1630: Okc_Debug.Log('7200: Locking _TL row', 2);
1631: END IF;*/
1632:
1633: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1634: FND_LOG.STRING(G_PROC_LEVEL,
1635: G_PKG_NAME, '7200: Locking _TL row' );
1636: END IF;
1637:
1638: x_return_status := Lock_row(

Line 1653: FND_LOG.STRING(G_PROC_LEVEL,

1649: Okc_Debug.Log('7300: Setting attributes', 2);
1650: END IF;*/
1651:
1652: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1653: FND_LOG.STRING(G_PROC_LEVEL,
1654: G_PKG_NAME, '7300: Setting attributes' );
1655: END IF;
1656:
1657: x_return_status := Set_Attributes(

Line 1679: FND_LOG.STRING(G_PROC_LEVEL,

1675: Okc_Debug.Log('7400: Record Validation', 2);
1676: END IF;*/
1677:
1678: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1679: FND_LOG.STRING(G_PROC_LEVEL,
1680: G_PKG_NAME, '7400: Record Validation' );
1681: END IF;
1682:
1683: --- Validate all non-missing attributes

Line 1703: FND_LOG.STRING(G_PROC_LEVEL,

1699: Okc_Debug.Log('7500: Filling WHO columns', 2);
1700: END IF;*/
1701:
1702: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1703: FND_LOG.STRING(G_PROC_LEVEL,
1704: G_PKG_NAME, '7500: Filling WHO columns' );
1705: END IF;
1706:
1707: -- Filling who columns

Line 1725: FND_LOG.STRING(G_PROC_LEVEL,

1721: Okc_Debug.Log('7600: Updating Row', 2);
1722: END IF;*/
1723:
1724: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1725: FND_LOG.STRING(G_PROC_LEVEL,
1726: G_PKG_NAME, '7600: Updating Row' );
1727: END IF;
1728:
1729: x_return_status := Update_Row(

Line 1750: FND_LOG.STRING(G_PROC_LEVEL,

1746: Okc_Debug.Log('7700: Updating TL Row', 2);
1747: END IF;*/
1748:
1749: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1750: FND_LOG.STRING(G_PROC_LEVEL,
1751: G_PKG_NAME, '7700: Updating TL Row' );
1752: END IF;
1753:
1754: x_return_status := Update_Row(

Line 1773: FND_LOG.STRING(G_PROC_LEVEL,

1769: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1770: END IF;*/
1771:
1772: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1773: FND_LOG.STRING(G_PROC_LEVEL,
1774: G_PKG_NAME, '7800: Leaving Update_Row' );
1775: END IF;
1776:
1777: EXCEPTION

Line 1784: FND_LOG.STRING(G_EXCP_LEVEL,

1780: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1781: END IF;*/
1782:
1783: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1784: FND_LOG.STRING(G_EXCP_LEVEL,
1785: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
1786: END IF;
1787: x_return_status := G_RET_STS_ERROR;
1788:

Line 1795: FND_LOG.STRING(G_EXCP_LEVEL,

1791: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1792: END IF;*/
1793:
1794: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1795: FND_LOG.STRING(G_EXCP_LEVEL,
1796: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1797: END IF;
1798: x_return_status := G_RET_STS_UNEXP_ERROR;
1799:

Line 1806: FND_LOG.STRING(G_EXCP_LEVEL,

1802: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1803: END IF;*/
1804:
1805: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1806: FND_LOG.STRING(G_EXCP_LEVEL,
1807: G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1808: END IF;
1809: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1810: p_msg_name => G_UNEXPECTED_ERROR,

Line 1836: FND_LOG.STRING(G_PROC_LEVEL,

1832: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1833: END IF;*/
1834:
1835: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1836: FND_LOG.STRING(G_PROC_LEVEL,
1837: G_PKG_NAME, '8200: Entered Delete_Row' );
1838: END IF;
1839:
1840: DELETE FROM OKC_NUMBER_SCHEMES_B

Line 1848: FND_LOG.STRING(G_PROC_LEVEL,

1844: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1845: END IF;*/
1846:
1847: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1848: FND_LOG.STRING(G_PROC_LEVEL,
1849: G_PKG_NAME, '8300: Leaving Delete_Row' );
1850: END IF;
1851:
1852: RETURN( G_RET_STS_SUCCESS );

Line 1862: FND_LOG.STRING(G_EXCP_LEVEL,

1858: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1859: END IF;*/
1860:
1861: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1862: FND_LOG.STRING(G_EXCP_LEVEL,
1863: G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1864: END IF;
1865:
1866: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1892: FND_LOG.STRING(G_PROC_LEVEL,

1888: Okc_Debug.Log('8500: Entered Delete_Row', 2);
1889: END IF;*/
1890:
1891: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1892: FND_LOG.STRING(G_PROC_LEVEL,
1893: G_PKG_NAME, '8500: Entered Delete_Row' );
1894: END IF;
1895:
1896: DELETE FROM OKC_NUMBER_SCHEMES_TL

Line 1904: FND_LOG.STRING(G_PROC_LEVEL,

1900: Okc_Debug.Log('8600: Leaving Delete_Row', 2);
1901: END IF;*/
1902:
1903: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1904: FND_LOG.STRING(G_PROC_LEVEL,
1905: G_PKG_NAME, '8600: Leaving Delete_Row' );
1906: END IF;
1907:
1908: RETURN( G_RET_STS_SUCCESS );

Line 1918: FND_LOG.STRING(G_EXCP_LEVEL,

1914: Okc_Debug.Log('8700: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1915: END IF;*/
1916:
1917: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1918: FND_LOG.STRING(G_EXCP_LEVEL,
1919: G_PKG_NAME, '8700: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1920: END IF;
1921:
1922: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1950: FND_LOG.STRING(G_PROC_LEVEL,

1946: Okc_Debug.Log('8900: Locking _B row', 2);
1947: END IF;*/
1948:
1949: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1950: FND_LOG.STRING(G_PROC_LEVEL,
1951: G_PKG_NAME, '8800: Entered Delete_Row' );
1952: FND_LOG.STRING(G_PROC_LEVEL,
1953: G_PKG_NAME, '8900: Locking _B row' );
1954: END IF;

Line 1952: FND_LOG.STRING(G_PROC_LEVEL,

1948:
1949: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1950: FND_LOG.STRING(G_PROC_LEVEL,
1951: G_PKG_NAME, '8800: Entered Delete_Row' );
1952: FND_LOG.STRING(G_PROC_LEVEL,
1953: G_PKG_NAME, '8900: Locking _B row' );
1954: END IF;
1955:
1956: x_return_status := Lock_row(

Line 1971: FND_LOG.STRING(G_PROC_LEVEL,

1967: Okc_Debug.Log('9000: Locking _TL row', 2);
1968: END IF;*/
1969:
1970: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1971: FND_LOG.STRING(G_PROC_LEVEL,
1972: G_PKG_NAME, '9000: Locking _TL row' );
1973: END IF;
1974:
1975: x_return_status := Lock_row(

Line 1990: FND_LOG.STRING(G_PROC_LEVEL,

1986: Okc_Debug.Log('9100: Removing _B row', 2);
1987: END IF;*/
1988:
1989: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1990: FND_LOG.STRING(G_PROC_LEVEL,
1991: G_PKG_NAME, '9100: Removing _B row' );
1992: END IF;
1993:
1994: x_return_status := Delete_Row( p_num_scheme_id => p_num_scheme_id );

Line 2007: FND_LOG.STRING(G_PROC_LEVEL,

2003: Okc_Debug.Log('9200: Removing _TL row', 2);
2004: END IF;*/
2005:
2006: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2007: FND_LOG.STRING(G_PROC_LEVEL,
2008: G_PKG_NAME, '9200: Removing _TL row' );
2009: END IF;
2010: x_return_status := Delete_Row_T( p_num_scheme_id => p_num_scheme_id );
2011: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2023: FND_LOG.STRING(G_PROC_LEVEL,

2019: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
2020: END IF;*/
2021:
2022: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2023: FND_LOG.STRING(G_PROC_LEVEL,
2024: G_PKG_NAME, '9300: Leaving Delete_Row' );
2025: END IF;
2026:
2027: EXCEPTION

Line 2034: FND_LOG.STRING(G_EXCP_LEVEL,

2030: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
2031: END IF;*/
2032:
2033: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2034: FND_LOG.STRING(G_EXCP_LEVEL,
2035: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
2036: END IF;
2037: x_return_status := G_RET_STS_ERROR;
2038:

Line 2045: FND_LOG.STRING(G_EXCP_LEVEL,

2041: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2042: END IF;*/
2043:
2044: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2045: FND_LOG.STRING(G_EXCP_LEVEL,
2046: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2047: END IF;
2048: x_return_status := G_RET_STS_UNEXP_ERROR;
2049:

Line 2056: FND_LOG.STRING(G_EXCP_LEVEL,

2052: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
2053: END IF;*/
2054:
2055: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2056: FND_LOG.STRING(G_EXCP_LEVEL,
2057: G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
2058: END IF;
2059: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2060: p_msg_name => G_UNEXPECTED_ERROR,