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_K_ART_VARIABLES_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: E_Resource_Busy EXCEPTION;

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: E_Resource_Busy EXCEPTION;
55: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);

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: E_Resource_Busy EXCEPTION;
55: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
56:

Line 101: FND_LOG.STRING(G_PROC_LEVEL,

97: Okc_Debug.Log('400: Entered get_rec', 2);
98: END IF;*/
99:
100: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
101: FND_LOG.STRING(G_PROC_LEVEL,
102: G_PKG_NAME, '400: Entered get_rec' );
103: END IF;
104:
105: -- Get current database values

Line 130: FND_LOG.STRING(G_PROC_LEVEL,

126: Okc_Debug.Log('500: Leaving get_rec ', 2);
127: END IF;*/
128:
129: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
130: FND_LOG.STRING(G_PROC_LEVEL,
131: G_PKG_NAME, '500: Leaving get_rec ' );
132: END IF;
133:
134: RETURN G_RET_STS_SUCCESS ;

Line 144: FND_LOG.STRING(G_PROC_LEVEL,

140: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
141: END IF;*/
142:
143: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
144: FND_LOG.STRING(G_PROC_LEVEL,
145: G_PKG_NAME, '600: Leaving get_rec because of EXCEPTION: '||sqlerrm );
146: END IF;
147:
148: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 198: FND_LOG.STRING(G_PROC_LEVEL,

194: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
195: END IF;*/
196:
197: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
198: FND_LOG.STRING(G_PROC_LEVEL,
199: G_PKG_NAME, '700: Entered Set_Attributes ' );
200: END IF;
201:
202: IF( p_cat_id IS NOT NULL AND p_variable_code IS NOT NULL ) THEN

Line 274: FND_LOG.STRING(G_PROC_LEVEL,

270: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
271: END IF;*/
272:
273: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
274: FND_LOG.STRING(G_PROC_LEVEL,
275: G_PKG_NAME, '800: Leaving Set_Attributes ' );
276: END IF;
277:
278: RETURN G_RET_STS_SUCCESS ;

Line 286: FND_LOG.STRING(G_PROC_LEVEL,

282: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
283: END IF;*/
284:
285: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
286: FND_LOG.STRING(G_PROC_LEVEL,
287: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception' );
288: END IF;
289: RETURN G_RET_STS_ERROR;
290:

Line 297: FND_LOG.STRING(G_PROC_LEVEL,

293: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
294: END IF;*/
295:
296: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
297: FND_LOG.STRING(G_PROC_LEVEL,
298: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
299: END IF;
300: RETURN G_RET_STS_UNEXP_ERROR;
301:

Line 308: FND_LOG.STRING(G_PROC_LEVEL,

304: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
305: END IF;*/
306:
307: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
308: FND_LOG.STRING(G_PROC_LEVEL,
309: G_PKG_NAME, '1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm );
310: END IF;
311: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
312: p_msg_name => G_UNEXPECTED_ERROR,

Line 360: FND_LOG.STRING(G_PROC_LEVEL,

356: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
357: END IF;*/
358:
359: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
360: FND_LOG.STRING(G_PROC_LEVEL,
361: G_PKG_NAME, '1200: Entered Validate_Attributes' );
362: END IF;
363:
364: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN

Line 370: FND_LOG.STRING(G_PROC_LEVEL,

366: Okc_Debug.Log('1300: required values validation', 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, '1300: required values validation' );
372: END IF;
373:
374: /*IF (l_debug = 'Y') THEN

Line 379: FND_LOG.STRING(G_PROC_LEVEL,

375: Okc_Debug.Log('1400: - attribute CAT_ID ', 2);
376: END IF;*/
377:
378: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
379: FND_LOG.STRING(G_PROC_LEVEL,
380: G_PKG_NAME, '1400: - attribute CAT_ID ' );
381: END IF;
382: IF ( p_cat_id IS NULL) THEN
383: /*IF (l_debug = 'Y') THEN

Line 388: FND_LOG.STRING(G_PROC_LEVEL,

384: Okc_Debug.Log('1500: - attribute CAT_ID is invalid', 2);
385: END IF;*/
386:
387: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
388: FND_LOG.STRING(G_PROC_LEVEL,
389: G_PKG_NAME, '1500: - attribute CAT_ID is invalid' );
390: END IF;
391: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'CAT_ID');
392: l_return_status := G_RET_STS_ERROR;

Line 400: FND_LOG.STRING(G_PROC_LEVEL,

396: Okc_Debug.Log('1400: - attribute VARIABLE_CODE ', 2);
397: END IF;*/
398:
399: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
400: FND_LOG.STRING(G_PROC_LEVEL,
401: G_PKG_NAME, '1400: - attribute VARIABLE_CODE ' );
402: END IF;
403: IF ( p_variable_code IS NULL) THEN
404: /*IF (l_debug = 'Y') THEN

Line 409: FND_LOG.STRING(G_PROC_LEVEL,

405: Okc_Debug.Log('1500: - attribute VARIABLE_CODE is invalid', 2);
406: END IF;*/
407:
408: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
409: FND_LOG.STRING(G_PROC_LEVEL,
410: G_PKG_NAME, '1500: - attribute VARIABLE_CODE is invalid' );
411: END IF;
412: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'VARIABLE_CODE');
413: l_return_status := G_RET_STS_ERROR;

Line 421: FND_LOG.STRING(G_PROC_LEVEL,

417: Okc_Debug.Log('1400: - attribute VARIABLE_TYPE ', 2);
418: END IF;*/
419:
420: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
421: FND_LOG.STRING(G_PROC_LEVEL,
422: G_PKG_NAME, '1400: - attribute VARIABLE_TYPE ' );
423: END IF;
424: IF ( p_variable_type IS NULL) THEN
425: /*IF (l_debug = 'Y') THEN

Line 430: FND_LOG.STRING(G_PROC_LEVEL,

426: Okc_Debug.Log('1500: - attribute VARIABLE_TYPE is invalid', 2);
427: END IF;*/
428:
429: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
430: FND_LOG.STRING(G_PROC_LEVEL,
431: G_PKG_NAME, '1500: - attribute VARIABLE_TYPE is invalid' );
432: END IF;
433: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'VARIABLE_TYPE');
434: l_return_status := G_RET_STS_ERROR;

Line 442: FND_LOG.STRING(G_PROC_LEVEL,

438: Okc_Debug.Log('1400: - attribute EXTERNAL_YN ', 2);
439: END IF;*/
440:
441: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
442: FND_LOG.STRING(G_PROC_LEVEL,
443: G_PKG_NAME, '1400: - attribute EXTERNAL_YN ' );
444: END IF;
445: IF ( p_external_yn IS NULL) THEN
446: /*IF (l_debug = 'Y') THEN

Line 451: FND_LOG.STRING(G_PROC_LEVEL,

447: Okc_Debug.Log('1500: - attribute EXTERNAL_YN is invalid', 2);
448: END IF;*/
449:
450: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
451: FND_LOG.STRING(G_PROC_LEVEL,
452: G_PKG_NAME, '1500: - attribute EXTERNAL_YN is invalid' );
453: END IF;
454: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_YN');
455: l_return_status := G_RET_STS_ERROR;

Line 466: FND_LOG.STRING(G_PROC_LEVEL,

462: Okc_Debug.Log('1600: static values and range validation', 2);
463: END IF;*/
464:
465: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
466: FND_LOG.STRING(G_PROC_LEVEL,
467: G_PKG_NAME, '1600: static values and range validation' );
468: END IF;
469:
470: /*IF (l_debug = 'Y') THEN

Line 475: FND_LOG.STRING(G_PROC_LEVEL,

471: Okc_Debug.Log('1700: - attribute EXTERNAL_YN ', 2);
472: END IF;*/
473:
474: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
475: FND_LOG.STRING(G_PROC_LEVEL,
476: G_PKG_NAME, '1700: - attribute EXTERNAL_YN ' );
477: END IF;
478:
479: IF ( p_external_yn NOT IN ('Y','N') AND p_external_yn IS NOT NULL) THEN

Line 485: FND_LOG.STRING(G_PROC_LEVEL,

481: Okc_Debug.Log('1800: - attribute EXTERNAL_YN is invalid', 2);
482: END IF;*/
483:
484: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
485: FND_LOG.STRING(G_PROC_LEVEL,
486: G_PKG_NAME, '1800: - attribute EXTERNAL_YN is invalid' );
487: END IF;
488: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'EXTERNAL_YN');
489: l_return_status := G_RET_STS_ERROR;

Line 498: FND_LOG.STRING(G_PROC_LEVEL,

494: Okc_Debug.Log('1700: - attribute OVERRIDE_GLOBAL_YN ', 2);
495: END IF;*/
496:
497: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
498: FND_LOG.STRING(G_PROC_LEVEL,
499: G_PKG_NAME, '1700: - attribute OVERRIDE_GLOBAL_YN ' );
500: END IF;
501:
502: IF ( p_OVERRIDE_GLOBAL_YN NOT IN ('Y','N') AND p_OVERRIDE_GLOBAL_YN IS NOT NULL) THEN

Line 508: FND_LOG.STRING(G_PROC_LEVEL,

504: Okc_Debug.Log('1800: - attribute OVERRIDE_GLOBAL_YN is invalid', 2);
505: END IF;*/
506:
507: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
508: FND_LOG.STRING(G_PROC_LEVEL,
509: G_PKG_NAME, '1800: - attribute OVERRIDE_GLOBAL_YN is invalid' );
510: END IF;
511:
512: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'OVERRIDE_GLOBAL_YN');

Line 523: FND_LOG.STRING(G_PROC_LEVEL,

519: Okc_Debug.Log('1900: lookup codes validation', 2);
520: END IF;*/
521:
522: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
523: FND_LOG.STRING(G_PROC_LEVEL,
524: G_PKG_NAME, '1900: lookup codes validation' );
525: END IF;
526: END IF;
527:

Line 534: FND_LOG.STRING(G_PROC_LEVEL,

530: Okc_Debug.Log('2100: foreign keys validation ', 2);
531: END IF;*/
532:
533: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
534: FND_LOG.STRING(G_PROC_LEVEL,
535: G_PKG_NAME, '2100: foreign keys validation ' );
536: END IF;
537:
538: /*IF (l_debug = 'Y') THEN

Line 543: FND_LOG.STRING(G_PROC_LEVEL,

539: Okc_Debug.Log('2200: - attribute CAT_ID ', 2);
540: END IF;*/
541:
542: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
543: FND_LOG.STRING(G_PROC_LEVEL,
544: G_PKG_NAME, '2200: - attribute CAT_ID ' );
545: END IF;
546:
547: IF p_cat_id IS NOT NULL THEN

Line 558: FND_LOG.STRING(G_PROC_LEVEL,

554: Okc_Debug.Log('2300: - attribute CAT_ID is invalid', 2);
555: END IF;*/
556:
557: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
558: FND_LOG.STRING(G_PROC_LEVEL,
559: G_PKG_NAME, '2300: - attribute CAT_ID is invalid' );
560: END IF;
561: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CAT_ID');
562: l_return_status := G_RET_STS_ERROR;

Line 588: FND_LOG.STRING(G_PROC_LEVEL,

584: Okc_Debug.Log('2200: - attribute ATTRIBUTE_VALUE_SET_ID ', 2);
585: END IF;*/
586:
587: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
588: FND_LOG.STRING(G_PROC_LEVEL,
589: G_PKG_NAME, '2200: - attribute ATTRIBUTE_VALUE_SET_ID ' );
590: END IF;
591: IF p_attribute_value_set_id IS NOT NULL THEN
592: l_dummy_var := '?';

Line 602: FND_LOG.STRING(G_PROC_LEVEL,

598: Okc_Debug.Log('2300: - attribute ATTRIBUTE_VALUE_SET_ID is invalid', 2);
599: END IF;*/
600:
601: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
602: FND_LOG.STRING(G_PROC_LEVEL,
603: G_PKG_NAME, '2300: - attribute ATTRIBUTE_VALUE_SET_ID is invalid' );
604: END IF;
605: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ATTRIBUTE_VALUE_SET_ID');
606: l_return_status := G_RET_STS_ERROR;

Line 615: FND_LOG.STRING(G_PROC_LEVEL,

611: Okc_Debug.Log('2200: - attribute VARIABLE_CODE ', 2);
612: END IF;*/
613:
614: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
615: FND_LOG.STRING(G_PROC_LEVEL,
616: G_PKG_NAME, '2200: - attribute VARIABLE_CODE ' );
617: END IF;
618: IF p_variable_code IS NOT NULL THEN
619: l_dummy_var := '?';

Line 629: FND_LOG.STRING(G_PROC_LEVEL,

625: Okc_Debug.Log('2300: - attribute VARIABLE_CODE is invalid', 2);
626: END IF;*/
627:
628: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
629: FND_LOG.STRING(G_PROC_LEVEL,
630: G_PKG_NAME, '2300: - attribute VARIABLE_CODE is invalid' );
631: END IF;
632: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VARIABLE_CODE');
633: l_return_status := G_RET_STS_ERROR;

Line 644: FND_LOG.STRING(G_PROC_LEVEL,

640: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
641: END IF;*/
642:
643: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
644: FND_LOG.STRING(G_PROC_LEVEL,
645: G_PKG_NAME, '2400: Leaving Validate_Attributes ' );
646: END IF;
647: RETURN l_return_status;
648:

Line 653: FND_LOG.STRING(G_EXCP_LEVEL,

649: EXCEPTION
650: WHEN OTHERS THEN
651: --Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
652: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
653: FND_LOG.STRING(G_EXCP_LEVEL,
654: G_PKG_NAME, '2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm );
655: END IF;
656: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
657: p_msg_name => G_UNEXPECTED_ERROR,

Line 709: FND_LOG.STRING(G_PROC_LEVEL,

705: Okc_Debug.Log('2600: Entered Validate_Record', 2);
706: END IF;*/
707:
708: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
709: FND_LOG.STRING(G_PROC_LEVEL,
710: G_PKG_NAME, '2600: Entered Validate_Record' );
711: END IF;
712: --- Validate all non-missing attributes (Item Level Validation)
713: l_return_status := Validate_Attributes(

Line 731: FND_LOG.STRING(G_PROC_LEVEL,

727: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
728: END IF;*/
729:
730: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
731: FND_LOG.STRING(G_PROC_LEVEL,
732: G_PKG_NAME, '2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm );
733: END IF;
734: RETURN G_RET_STS_UNEXP_ERROR;
735: END IF;

Line 744: FND_LOG.STRING(G_PROC_LEVEL,

740: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
741: END IF;*/
742:
743: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
744: FND_LOG.STRING(G_PROC_LEVEL,
745: G_PKG_NAME, '2800: Entered Record Level Validations' );
746: END IF;
747:
748: IF P_ATTRIBUTE_VALUE_SET_ID IS NOT NULL AND

Line 762: FND_LOG.STRING(G_PROC_LEVEL,

758: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
759: END IF;*/
760:
761: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
762: FND_LOG.STRING(G_PROC_LEVEL,
763: G_PKG_NAME, '2900: Leaving Validate_Record : '||sqlerrm );
764: END IF;
765:
766: RETURN l_return_status ;

Line 776: FND_LOG.STRING(G_EXCP_LEVEL,

772: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
773: END IF;*/
774:
775: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
776: FND_LOG.STRING(G_EXCP_LEVEL,
777: G_PKG_NAME, '3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm );
778: END IF;
779: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
780: p_msg_name => G_UNEXPECTED_ERROR,

Line 828: FND_LOG.STRING(G_PROC_LEVEL,

824: Okc_Debug.Log('3100: Entered validate_row', 2);
825: END IF;*/
826:
827: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
828: FND_LOG.STRING(G_PROC_LEVEL,
829: G_PKG_NAME, '3100: Entered validate_row' );
830: END IF;
831:
832: -- Setting attributes

Line 875: FND_LOG.STRING(G_PROC_LEVEL,

871: Okc_Debug.Log('3200: Leaving validate_row', 2);
872: END IF;*/
873:
874: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
875: FND_LOG.STRING(G_PROC_LEVEL,
876: G_PKG_NAME, '3200: Leaving validate_row' );
877: END IF;
878:
879: EXCEPTION

Line 886: FND_LOG.STRING(G_EXCP_LEVEL,

882: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
883: END IF;*/
884:
885: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
886: FND_LOG.STRING(G_EXCP_LEVEL,
887: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception' );
888: END IF;
889: x_return_status := G_RET_STS_ERROR;
890:

Line 897: FND_LOG.STRING(G_EXCP_LEVEL,

893: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
894: END IF;*/
895:
896: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
897: FND_LOG.STRING(G_EXCP_LEVEL,
898: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
899: END IF;
900: x_return_status := G_RET_STS_UNEXP_ERROR;
901:

Line 908: FND_LOG.STRING(G_EXCP_LEVEL,

904: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
905: END IF;*/
906:
907: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
908: FND_LOG.STRING(G_EXCP_LEVEL,
909: G_PKG_NAME, '3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm );
910: END IF;
911: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
912: p_msg_name => G_UNEXPECTED_ERROR,

Line 952: FND_LOG.STRING(G_PROC_LEVEL,

948: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
949: END IF;*/
950:
951: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
952: FND_LOG.STRING(G_PROC_LEVEL,
953: G_PKG_NAME, '3600: Entered Insert_Row function' );
954: END IF;
955: INSERT INTO OKC_K_ART_VARIABLES(
956: CAT_ID,

Line 991: FND_LOG.STRING(G_PROC_LEVEL,

987: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
988: END IF;*/
989:
990: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
991: FND_LOG.STRING(G_PROC_LEVEL,
992: G_PKG_NAME, '3700: Leaving Insert_Row' );
993: END IF;
994:
995: RETURN( G_RET_STS_SUCCESS );

Line 1005: FND_LOG.STRING(G_EXCP_LEVEL,

1001: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
1002: END IF;*/
1003:
1004: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1005: FND_LOG.STRING(G_EXCP_LEVEL,
1006: G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
1007: END IF;
1008:
1009: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1055: FND_LOG.STRING(G_PROC_LEVEL,

1051: Okc_Debug.Log('4200: Entered Insert_Row', 2);
1052: END IF;*/
1053:
1054: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1055: FND_LOG.STRING(G_PROC_LEVEL,
1056: G_PKG_NAME, '4200: Entered Insert_Row' );
1057: END IF;
1058:
1059: -- Set Internal columns

Line 1095: FND_LOG.STRING(G_PROC_LEVEL,

1091: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
1092: END IF;*/
1093:
1094: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1095: FND_LOG.STRING(G_PROC_LEVEL,
1096: G_PKG_NAME, '4300: Call the internal Insert_Row for Base Table' );
1097: END IF;
1098:
1099: x_return_status := Insert_Row(

Line 1128: FND_LOG.STRING(G_PROC_LEVEL,

1124: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
1125: END IF;*/
1126:
1127: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1128: FND_LOG.STRING(G_PROC_LEVEL,
1129: G_PKG_NAME, '4500: Leaving Insert_Row' );
1130: END IF;
1131:
1132: EXCEPTION

Line 1139: FND_LOG.STRING(G_EXCP_LEVEL,

1135: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1136: END IF;*/
1137:
1138: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1139: FND_LOG.STRING(G_EXCP_LEVEL,
1140: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
1141: END IF;
1142: x_return_status := G_RET_STS_ERROR;
1143:

Line 1150: FND_LOG.STRING(G_EXCP_LEVEL,

1146: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1147: END IF;*/
1148:
1149: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1150: FND_LOG.STRING(G_EXCP_LEVEL,
1151: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1152: END IF;
1153: x_return_status := G_RET_STS_UNEXP_ERROR;
1154:

Line 1161: FND_LOG.STRING(G_EXCP_LEVEL,

1157: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
1158: END IF;*/
1159:
1160: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1161: FND_LOG.STRING(G_EXCP_LEVEL,
1162: G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm );
1163: END IF;
1164: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1165: p_msg_name => G_UNEXPECTED_ERROR,

Line 1210: FND_LOG.STRING(G_PROC_LEVEL,

1206: Okc_Debug.Log('4900: Entered Lock_Row', 2);
1207: END IF;*/
1208:
1209: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1210: FND_LOG.STRING(G_PROC_LEVEL,
1211: G_PKG_NAME, '4900: Entered Lock_Row' );
1212: END IF;
1213:
1214: BEGIN

Line 1229: FND_LOG.STRING(G_EXCP_LEVEL,

1225: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1226: END IF;*/
1227:
1228: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1229: FND_LOG.STRING(G_EXCP_LEVEL,
1230: G_PKG_NAME, '5000: Leaving Lock_Row:E_Resource_Busy Exception' );
1231: END IF;
1232:
1233: IF (lock_csr%ISOPEN) THEN

Line 1266: FND_LOG.STRING(G_PROC_LEVEL,

1262: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1263: END IF;*/
1264:
1265: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1266: FND_LOG.STRING(G_PROC_LEVEL,
1267: G_PKG_NAME, '5100: Leaving Lock_Row' );
1268: END IF;
1269:
1270: RETURN( l_return_status );

Line 1287: FND_LOG.STRING(G_EXCP_LEVEL,

1283: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1284: END IF;*/
1285:
1286: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1287: FND_LOG.STRING(G_EXCP_LEVEL,
1288: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1289: END IF;
1290:
1291: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1319: FND_LOG.STRING(G_PROC_LEVEL,

1315: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1316: END IF;*/
1317:
1318: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1319: FND_LOG.STRING(G_PROC_LEVEL,
1320: G_PKG_NAME, '5700: Entered Lock_Row');
1321: FND_LOG.STRING(G_PROC_LEVEL,
1322: G_PKG_NAME, '5800: Locking Row for Base Table');
1323: END IF;

Line 1321: FND_LOG.STRING(G_PROC_LEVEL,

1317:
1318: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1319: FND_LOG.STRING(G_PROC_LEVEL,
1320: G_PKG_NAME, '5700: Entered Lock_Row');
1321: FND_LOG.STRING(G_PROC_LEVEL,
1322: G_PKG_NAME, '5800: Locking Row for Base Table');
1323: END IF;
1324:
1325: --------------------------------------------

Line 1346: FND_LOG.STRING(G_PROC_LEVEL,

1342: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1343: END IF;*/
1344:
1345: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1346: FND_LOG.STRING(G_PROC_LEVEL,
1347: G_PKG_NAME, '6000: Leaving Lock_Row' );
1348: END IF;
1349:
1350: EXCEPTION

Line 1357: FND_LOG.STRING(G_EXCP_LEVEL,

1353: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1354: END IF;*/
1355:
1356: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1357: FND_LOG.STRING(G_EXCP_LEVEL,
1358: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
1359: END IF;
1360: x_return_status := G_RET_STS_ERROR;
1361:

Line 1368: FND_LOG.STRING(G_EXCP_LEVEL,

1364: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1365: END IF;*/
1366:
1367: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1368: FND_LOG.STRING(G_EXCP_LEVEL,
1369: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1370: END IF;
1371: x_return_status := G_RET_STS_UNEXP_ERROR;
1372:

Line 1379: FND_LOG.STRING(G_EXCP_LEVEL,

1375: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1376: END IF;*/
1377:
1378: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1379: FND_LOG.STRING(G_EXCP_LEVEL,
1380: G_PKG_NAME, '6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1381: END IF;
1382: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1383: p_msg_name => G_UNEXPECTED_ERROR,

Line 1421: FND_LOG.STRING(G_PROC_LEVEL,

1417: Okc_Debug.Log('6400: Entered Update_Row', 2);
1418: END IF;*/
1419:
1420: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1421: FND_LOG.STRING(G_PROC_LEVEL,
1422: G_PKG_NAME, '6400: Entered Update_Row' );
1423: END IF;
1424:
1425: UPDATE OKC_K_ART_VARIABLES

Line 1444: FND_LOG.STRING(G_PROC_LEVEL,

1440: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1441: END IF;*/
1442:
1443: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1444: FND_LOG.STRING(G_PROC_LEVEL,
1445: G_PKG_NAME, '6500: Leaving Update_Row' );
1446: END IF;
1447:
1448: RETURN G_RET_STS_SUCCESS ;

Line 1458: FND_LOG.STRING(G_EXCP_LEVEL,

1454: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1455: END IF;*/
1456:
1457: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1458: FND_LOG.STRING(G_EXCP_LEVEL,
1459: G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1460: END IF;
1461:
1462: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1514: FND_LOG.STRING(G_PROC_LEVEL,

1510: Okc_Debug.Log('7100: Locking _B row', 2);
1511: END IF;*/
1512:
1513: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1514: FND_LOG.STRING(G_PROC_LEVEL,
1515: G_PKG_NAME, '7000: Entered Update_Row');
1516: FND_LOG.STRING(G_PROC_LEVEL,
1517: G_PKG_NAME, '7100: Locking _B row');
1518: END IF;

Line 1516: FND_LOG.STRING(G_PROC_LEVEL,

1512:
1513: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1514: FND_LOG.STRING(G_PROC_LEVEL,
1515: G_PKG_NAME, '7000: Entered Update_Row');
1516: FND_LOG.STRING(G_PROC_LEVEL,
1517: G_PKG_NAME, '7100: Locking _B row');
1518: END IF;
1519:
1520: x_return_status := Lock_row(

Line 1536: FND_LOG.STRING(G_PROC_LEVEL,

1532: Okc_Debug.Log('7300: Setting attributes', 2);
1533: END IF;*/
1534:
1535: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1536: FND_LOG.STRING(G_PROC_LEVEL,
1537: G_PKG_NAME, '7300: Setting attributes' );
1538: END IF;
1539:
1540: x_return_status := Set_Attributes(

Line 1569: FND_LOG.STRING(G_PROC_LEVEL,

1565: Okc_Debug.Log('7400: Record Validation', 2);
1566: END IF;*/
1567:
1568: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1569: FND_LOG.STRING(G_PROC_LEVEL,
1570: G_PKG_NAME, '7400: Record Validation' );
1571: END IF;
1572:
1573: --- Validate all non-missing attributes

Line 1597: FND_LOG.STRING(G_PROC_LEVEL,

1593: Okc_Debug.Log('7500: Filling WHO columns', 2);
1594: END IF;*/
1595:
1596: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1597: FND_LOG.STRING(G_PROC_LEVEL,
1598: G_PKG_NAME, '7500: Filling WHO columns' );
1599: END IF;
1600:
1601: -- Filling who columns

Line 1619: FND_LOG.STRING(G_PROC_LEVEL,

1615: Okc_Debug.Log('7600: Updating Row', 2);
1616: END IF;*/
1617:
1618: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1619: FND_LOG.STRING(G_PROC_LEVEL,
1620: G_PKG_NAME, '7600: Updating Row' );
1621: END IF;
1622:
1623: x_return_status := Update_Row(

Line 1651: FND_LOG.STRING(G_PROC_LEVEL,

1647: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1648: END IF;*/
1649:
1650: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1651: FND_LOG.STRING(G_PROC_LEVEL,
1652: G_PKG_NAME, '7800: Leaving Update_Row' );
1653: END IF;
1654:
1655: EXCEPTION

Line 1662: FND_LOG.STRING(G_EXCP_LEVEL,

1658: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1659: END IF;*/
1660:
1661: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1662: FND_LOG.STRING(G_EXCP_LEVEL,
1663: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
1664: END IF;
1665:
1666: x_return_status := G_RET_STS_ERROR;

Line 1674: FND_LOG.STRING(G_EXCP_LEVEL,

1670: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1671: END IF;*/
1672:
1673: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1674: FND_LOG.STRING(G_EXCP_LEVEL,
1675: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1676: END IF;
1677:
1678: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1686: FND_LOG.STRING(G_EXCP_LEVEL,

1682: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1683: END IF;*/
1684:
1685: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1686: FND_LOG.STRING(G_EXCP_LEVEL,
1687: G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1688: END IF;
1689:
1690: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1718: FND_LOG.STRING(G_PROC_LEVEL,

1714: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1715: END IF;*/
1716:
1717: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1718: FND_LOG.STRING(G_PROC_LEVEL,
1719: G_PKG_NAME, '8200: Entered Delete_Row' );
1720: END IF;
1721:
1722: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID = p_CAT_ID AND VARIABLE_CODE = p_VARIABLE_CODE;

Line 1729: FND_LOG.STRING(G_PROC_LEVEL,

1725: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1726: END IF;*/
1727:
1728: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1729: FND_LOG.STRING(G_PROC_LEVEL,
1730: G_PKG_NAME, '8300: Leaving Delete_Row' );
1731: END IF;
1732:
1733: RETURN( G_RET_STS_SUCCESS );

Line 1743: FND_LOG.STRING(G_EXCP_LEVEL,

1739: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1740: END IF;*/
1741:
1742: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1743: FND_LOG.STRING(G_EXCP_LEVEL,
1744: G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1745: END IF;
1746:
1747: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1776: FND_LOG.STRING(G_PROC_LEVEL,

1772: Okc_Debug.Log('8900: Locking _B row', 2);
1773: END IF;*/
1774:
1775: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1776: FND_LOG.STRING(G_PROC_LEVEL,
1777: G_PKG_NAME, '8800: Entered Delete_Row');
1778: FND_LOG.STRING(G_PROC_LEVEL,
1779: G_PKG_NAME, '8900: Locking _B row');
1780: END IF;

Line 1778: FND_LOG.STRING(G_PROC_LEVEL,

1774:
1775: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1776: FND_LOG.STRING(G_PROC_LEVEL,
1777: G_PKG_NAME, '8800: Entered Delete_Row');
1778: FND_LOG.STRING(G_PROC_LEVEL,
1779: G_PKG_NAME, '8900: Locking _B row');
1780: END IF;
1781:
1782: x_return_status := Lock_row(

Line 1798: FND_LOG.STRING(G_PROC_LEVEL,

1794: Okc_Debug.Log('9100: Removing _B row', 2);
1795: END IF;*/
1796:
1797: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1798: FND_LOG.STRING(G_PROC_LEVEL,
1799: G_PKG_NAME, '9100: Removing _B row' );
1800: END IF;
1801: x_return_status := Delete_Row( p_cat_id => p_cat_id,p_variable_code => p_variable_code );
1802: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1814: FND_LOG.STRING(G_PROC_LEVEL,

1810: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1811: END IF;*/
1812:
1813: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1814: FND_LOG.STRING(G_PROC_LEVEL,
1815: G_PKG_NAME, '9300: Leaving Delete_Row' );
1816: END IF;
1817:
1818: EXCEPTION

Line 1825: FND_LOG.STRING(G_EXCP_LEVEL,

1821: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1822: END IF;*/
1823:
1824: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1825: FND_LOG.STRING(G_EXCP_LEVEL,
1826: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
1827: END IF;
1828: x_return_status := G_RET_STS_ERROR;
1829:

Line 1836: FND_LOG.STRING(G_EXCP_LEVEL,

1832: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1833: END IF;*/
1834:
1835: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1836: FND_LOG.STRING(G_EXCP_LEVEL,
1837: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1838: END IF;
1839: x_return_status := G_RET_STS_UNEXP_ERROR;
1840:

Line 1847: FND_LOG.STRING(G_EXCP_LEVEL,

1843: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1844: END IF;*/
1845:
1846: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1847: FND_LOG.STRING(G_EXCP_LEVEL,
1848: G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1849: END IF;
1850: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1851: p_msg_name => G_UNEXPECTED_ERROR,

Line 1878: FND_LOG.STRING(G_PROC_LEVEL,

1874: Okc_Debug.Log('9701: Locking Records', 2);
1875: END IF;*/
1876:
1877: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1878: FND_LOG.STRING(G_PROC_LEVEL,
1879: G_PKG_NAME, '9700: Entered Delete_Set');
1880: FND_LOG.STRING(G_PROC_LEVEL,
1881: G_PKG_NAME, '9701: Locking Records');
1882: END IF;

Line 1880: FND_LOG.STRING(G_PROC_LEVEL,

1876:
1877: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1878: FND_LOG.STRING(G_PROC_LEVEL,
1879: G_PKG_NAME, '9700: Entered Delete_Set');
1880: FND_LOG.STRING(G_PROC_LEVEL,
1881: G_PKG_NAME, '9701: Locking Records');
1882: END IF;
1883:
1884: -- making OPEN/CLOSE cursor to lock records

Line 1896: FND_LOG.STRING(G_PROC_LEVEL,

1892: Okc_Debug.Log('11000: Leaving Delete_set', 2);
1893: END IF;*/
1894:
1895: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1896: FND_LOG.STRING(G_PROC_LEVEL,
1897: G_PKG_NAME, '11000: Leaving Delete_set' );
1898: END IF;
1899:
1900: EXCEPTION

Line 1907: FND_LOG.STRING(G_EXCP_LEVEL,

1903: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
1904: END IF;*/
1905:
1906: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1907: FND_LOG.STRING(G_EXCP_LEVEL,
1908: G_PKG_NAME, '000: Leaving Delete_set:E_Resource_Busy Exception' );
1909: END IF;
1910:
1911: IF (lock_csr%ISOPEN) THEN

Line 1923: FND_LOG.STRING(G_EXCP_LEVEL,

1919: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
1920: END IF;*/
1921:
1922: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1923: FND_LOG.STRING(G_EXCP_LEVEL,
1924: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
1925: END IF;
1926:
1927: IF (lock_csr%ISOPEN) THEN

Line 1939: FND_LOG.STRING(G_EXCP_LEVEL,

1935: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1936: END IF;*/
1937:
1938: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1939: FND_LOG.STRING(G_EXCP_LEVEL,
1940: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1941: END IF;
1942:
1943: IF (lock_csr%ISOPEN) THEN

Line 1954: FND_LOG.STRING(G_EXCP_LEVEL,

1950: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
1951: END IF;*/
1952:
1953: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1954: FND_LOG.STRING(G_EXCP_LEVEL,
1955: G_PKG_NAME, '11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm );
1956: END IF;
1957:
1958: IF (lock_csr%ISOPEN) THEN

Line 1990: FND_LOG.STRING(G_PROC_LEVEL,

1986: Okc_Debug.Log('9700: Locking Records', 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, '9700: Entered Delete_Set');
1992: FND_LOG.STRING(G_PROC_LEVEL,
1993: G_PKG_NAME, '9700: Locking Records');
1994: END IF;

Line 1992: FND_LOG.STRING(G_PROC_LEVEL,

1988:
1989: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1990: FND_LOG.STRING(G_PROC_LEVEL,
1991: G_PKG_NAME, '9700: Entered Delete_Set');
1992: FND_LOG.STRING(G_PROC_LEVEL,
1993: G_PKG_NAME, '9700: Locking Records');
1994: END IF;
1995:
1996: -- making OPEN/CLOSE cursor to lock records

Line 2009: FND_LOG.STRING(G_PROC_LEVEL,

2005: Okc_Debug.Log('11000: Leaving Delete_set', 2);
2006: END IF;*/
2007:
2008: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2009: FND_LOG.STRING(G_PROC_LEVEL,
2010: G_PKG_NAME, '11000: Leaving Delete_set' );
2011: END IF;
2012:
2013: EXCEPTION

Line 2020: FND_LOG.STRING(G_EXCP_LEVEL,

2016: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
2017: END IF;*/
2018:
2019: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2020: FND_LOG.STRING(G_EXCP_LEVEL,
2021: G_PKG_NAME, '000: Leaving Delete_set:E_Resource_Busy Exception' );
2022: END IF;
2023:
2024: IF (lock_csr%ISOPEN) THEN

Line 2036: FND_LOG.STRING(G_EXCP_LEVEL,

2032: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2033: END IF;*/
2034:
2035: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2036: FND_LOG.STRING(G_EXCP_LEVEL,
2037: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
2038: END IF;
2039:
2040: IF (lock_csr%ISOPEN) THEN

Line 2051: FND_LOG.STRING(G_EXCP_LEVEL,

2047: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2048: END IF;*/
2049:
2050: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2051: FND_LOG.STRING(G_EXCP_LEVEL,
2052: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2053: END IF;
2054:
2055: IF (lock_csr%ISOPEN) THEN

Line 2066: FND_LOG.STRING(G_EXCP_LEVEL,

2062: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
2063: END IF;*/
2064:
2065: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2066: FND_LOG.STRING(G_EXCP_LEVEL,
2067: G_PKG_NAME, '11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm );
2068: END IF;
2069:
2070: IF (lock_csr%ISOPEN) THEN

Line 2106: FND_LOG.STRING(G_PROC_LEVEL,

2102: Okc_Debug.Log('9710: Locking Records', 2);
2103: END IF;*/
2104:
2105: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2106: FND_LOG.STRING(G_PROC_LEVEL,
2107: G_PKG_NAME, '9700: Entered Delete_Set');
2108: FND_LOG.STRING(G_PROC_LEVEL,
2109: G_PKG_NAME, '9710: Locking Records');
2110: END IF;

Line 2108: FND_LOG.STRING(G_PROC_LEVEL,

2104:
2105: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2106: FND_LOG.STRING(G_PROC_LEVEL,
2107: G_PKG_NAME, '9700: Entered Delete_Set');
2108: FND_LOG.STRING(G_PROC_LEVEL,
2109: G_PKG_NAME, '9710: Locking Records');
2110: END IF;
2111:
2112: -- making OPEN/CLOSE cursor to lock records

Line 2126: FND_LOG.STRING(G_PROC_LEVEL,

2122: Okc_Debug.Log('11000: Leaving Delete_set', 2);
2123: END IF;*/
2124:
2125: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2126: FND_LOG.STRING(G_PROC_LEVEL,
2127: G_PKG_NAME, '11000: Leaving Delete_set' );
2128: END IF;
2129:
2130: EXCEPTION

Line 2137: FND_LOG.STRING(G_EXCP_LEVEL,

2133: Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
2134: END IF;*/
2135:
2136: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2137: FND_LOG.STRING(G_EXCP_LEVEL,
2138: G_PKG_NAME, '000: Leaving Delete_set:E_Resource_Busy Exception' );
2139: END IF;
2140:
2141: IF (lock_csr%ISOPEN) THEN

Line 2153: FND_LOG.STRING(G_EXCP_LEVEL,

2149: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2150: END IF;*/
2151:
2152: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2153: FND_LOG.STRING(G_EXCP_LEVEL,
2154: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
2155: END IF;
2156:
2157: IF (lock_csr%ISOPEN) THEN

Line 2169: FND_LOG.STRING(G_EXCP_LEVEL,

2165: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2166: END IF;*/
2167:
2168: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2169: FND_LOG.STRING(G_EXCP_LEVEL,
2170: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2171: END IF;
2172:
2173: IF (lock_csr%ISOPEN) THEN

Line 2185: FND_LOG.STRING(G_EXCP_LEVEL,

2181: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
2182: END IF;*/
2183:
2184: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2185: FND_LOG.STRING(G_EXCP_LEVEL,
2186: G_PKG_NAME, '11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm );
2187: END IF;
2188:
2189: IF (lock_csr%ISOPEN) THEN

Line 2218: FND_LOG.STRING(G_PROC_LEVEL,

2214: Okc_Debug.Log('9800: Saving Base Table', 2);
2215: END IF;*/
2216:
2217: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2218: FND_LOG.STRING(G_PROC_LEVEL,
2219: G_PKG_NAME, '9700: Entered create_version');
2220: FND_LOG.STRING(G_PROC_LEVEL,
2221: G_PKG_NAME, '9800: Saving Base Table');
2222: END IF;

Line 2220: FND_LOG.STRING(G_PROC_LEVEL,

2216:
2217: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2218: FND_LOG.STRING(G_PROC_LEVEL,
2219: G_PKG_NAME, '9700: Entered create_version');
2220: FND_LOG.STRING(G_PROC_LEVEL,
2221: G_PKG_NAME, '9800: Saving Base Table');
2222: END IF;
2223:
2224: -----------------------------------------

Line 2269: FND_LOG.STRING(G_PROC_LEVEL,

2265: Okc_Debug.Log('10000: Leaving create_version', 2);
2266: END IF;*/
2267:
2268: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2269: FND_LOG.STRING(G_PROC_LEVEL,
2270: G_PKG_NAME, '10000: Leaving create_version' );
2271: END IF;
2272:
2273: RETURN( G_RET_STS_SUCCESS );

Line 2283: FND_LOG.STRING(G_EXCP_LEVEL,

2279: Okc_Debug.Log('10100: Leaving create_version because of EXCEPTION: '||sqlerrm, 2);
2280: END IF;*/
2281:
2282: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2283: FND_LOG.STRING(G_EXCP_LEVEL,
2284: G_PKG_NAME, '10100: Leaving create_version because of EXCEPTION: '||sqlerrm );
2285: END IF;
2286:
2287: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2316: FND_LOG.STRING(G_PROC_LEVEL,

2312: Okc_Debug.Log('10300: Restoring Base Table', 2);
2313: END IF;*/
2314:
2315: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2316: FND_LOG.STRING(G_PROC_LEVEL,
2317: G_PKG_NAME, '10200: Entered restore_version');
2318: FND_LOG.STRING(G_PROC_LEVEL,
2319: G_PKG_NAME, '10300: Restoring Base Table');
2320: END IF;

Line 2318: FND_LOG.STRING(G_PROC_LEVEL,

2314:
2315: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2316: FND_LOG.STRING(G_PROC_LEVEL,
2317: G_PKG_NAME, '10200: Entered restore_version');
2318: FND_LOG.STRING(G_PROC_LEVEL,
2319: G_PKG_NAME, '10300: Restoring Base Table');
2320: END IF;
2321:
2322: -----------------------------------------

Line 2366: FND_LOG.STRING(G_PROC_LEVEL,

2362: Okc_Debug.Log('10500: Leaving restore_version', 2);
2363: END IF;*/
2364:
2365: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2366: FND_LOG.STRING(G_PROC_LEVEL,
2367: G_PKG_NAME, '10500: Leaving restore_version' );
2368: END IF;
2369:
2370: RETURN( G_RET_STS_SUCCESS );

Line 2380: FND_LOG.STRING(G_EXCP_LEVEL,

2376: Okc_Debug.Log('10600: Leaving restore_version because of EXCEPTION: '||sqlerrm, 2);
2377: END IF;*/
2378:
2379: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2380: FND_LOG.STRING(G_EXCP_LEVEL,
2381: G_PKG_NAME, '10600: Leaving restore_version because of EXCEPTION: '||sqlerrm );
2382: END IF;
2383:
2384: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2408: FND_LOG.STRING(G_PROC_LEVEL,

2404: Okc_Debug.Log('7200: Entered Delete_Version', 2);
2405: END IF;*/
2406:
2407: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2408: FND_LOG.STRING(G_PROC_LEVEL,
2409: G_PKG_NAME, '7200: Entered Delete_Version' );
2410: END IF;
2411:
2412: -----------------------------------------

Line 2426: FND_LOG.STRING(G_PROC_LEVEL,

2422: Okc_Debug.Log('7300: Leaving Delete_Version', 2);
2423: END IF;*/
2424:
2425: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2426: FND_LOG.STRING(G_PROC_LEVEL,
2427: G_PKG_NAME, '7300: Leaving Delete_Version' );
2428: END IF;
2429:
2430: RETURN( G_RET_STS_SUCCESS );

Line 2440: FND_LOG.STRING(G_EXCP_LEVEL,

2436: Okc_Debug.Log('7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm, 2);
2437: END IF;*/
2438:
2439: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2440: FND_LOG.STRING(G_EXCP_LEVEL,
2441: G_PKG_NAME, '7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm );
2442: END IF;
2443:
2444: Okc_Api.Set_Message(p_app_name => G_APP_NAME,