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_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: -- GLOBAL EXCEPTION

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: -- GLOBAL EXCEPTION
56: ------------------------------------------------------------------------------

Line 99: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 124: FND_LOG.STRING(G_PROC_LEVEL,

120: Okc_Debug.Log('500: Leaving get_rec ', 2);
121: END IF;*/
122:
123: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
124: FND_LOG.STRING(G_PROC_LEVEL,
125: G_PKG_NAME, '500: Leaving get_rec ' );
126: END IF;
127:
128: RETURN G_RET_STS_SUCCESS ;

Line 138: FND_LOG.STRING(G_EXCP_LEVEL,

134: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
135: END IF;*/
136:
137: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
138: FND_LOG.STRING(G_EXCP_LEVEL,
139: G_PKG_NAME, '600: Leaving get_rec because of EXCEPTION: '||sqlerrm );
140: END IF;
141:
142: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 185: FND_LOG.STRING(G_PROC_LEVEL,

181: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
182: END IF;*/
183:
184: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
185: FND_LOG.STRING(G_PROC_LEVEL,
186: G_PKG_NAME, '700: Entered Set_Attributes ' );
187: END IF;
188:
189: IF( p_num_scheme_id IS NOT NULL AND p_num_sequence_code IS NOT NULL AND p_sequence_level IS NOT NULL ) THEN

Line 232: FND_LOG.STRING(G_PROC_LEVEL,

228: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
229: END IF;*/
230:
231: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
232: FND_LOG.STRING(G_PROC_LEVEL,
233: G_PKG_NAME, '800: Leaving Set_Attributes ' );
234: END IF;
235:
236: RETURN G_RET_STS_SUCCESS ;

Line 244: FND_LOG.STRING(G_EXCP_LEVEL,

240: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
241: END IF;*/
242:
243: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
244: FND_LOG.STRING(G_EXCP_LEVEL,
245: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception' );
246: END IF;
247: RETURN G_RET_STS_ERROR;
248:

Line 255: FND_LOG.STRING(G_EXCP_LEVEL,

251: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
252: END IF;*/
253:
254: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
255: FND_LOG.STRING(G_EXCP_LEVEL,
256: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
257: END IF;
258: RETURN G_RET_STS_UNEXP_ERROR;
259:

Line 266: FND_LOG.STRING(G_EXCP_LEVEL,

262: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
263: END IF;*/
264:
265: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
266: FND_LOG.STRING(G_EXCP_LEVEL,
267: G_PKG_NAME, '1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm );
268: END IF;
269: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
270: p_msg_name => G_UNEXPECTED_ERROR,

Line 306: FND_LOG.STRING(G_PROC_LEVEL,

302: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
303: END IF;*/
304:
305: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
306: FND_LOG.STRING(G_PROC_LEVEL,
307: G_PKG_NAME, '1200: Entered Validate_Attributes' );
308: END IF;
309:
310: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN

Line 316: FND_LOG.STRING(G_PROC_LEVEL,

312: Okc_Debug.Log('1300: required values validation', 2);
313: END IF;*/
314:
315: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
316: FND_LOG.STRING(G_PROC_LEVEL,
317: G_PKG_NAME, '1300: required values validation' );
318: END IF;
319:
320: /*IF (l_debug = 'Y') THEN

Line 325: FND_LOG.STRING(G_PROC_LEVEL,

321: Okc_Debug.Log('1400: - attribute NUM_SCHEME_ID ', 2);
322: END IF;*/
323:
324: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
325: FND_LOG.STRING(G_PROC_LEVEL,
326: G_PKG_NAME, '1400: - attribute NUM_SCHEME_ID ' );
327: END IF;
328:
329: IF ( p_num_scheme_id IS NULL) THEN

Line 335: FND_LOG.STRING(G_PROC_LEVEL,

331: Okc_Debug.Log('1500: - attribute NUM_SCHEME_ID is invalid', 2);
332: END IF;*/
333:
334: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
335: FND_LOG.STRING(G_PROC_LEVEL,
336: G_PKG_NAME, '1500: - attribute NUM_SCHEME_ID is invalid' );
337: END IF;
338:
339: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUM_SCHEME_ID');

Line 348: FND_LOG.STRING(G_PROC_LEVEL,

344: Okc_Debug.Log('1400: - attribute NUM_SEQUENCE_CODE ', 2);
345: END IF;*/
346:
347: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
348: FND_LOG.STRING(G_PROC_LEVEL,
349: G_PKG_NAME, '1400: - attribute NUM_SEQUENCE_CODE ' );
350: END IF;
351:
352: IF ( p_num_sequence_code IS NULL) THEN

Line 358: FND_LOG.STRING(G_PROC_LEVEL,

354: Okc_Debug.Log('1500: - attribute NUM_SEQUENCE_CODE is invalid', 2);
355: END IF;*/
356:
357: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
358: FND_LOG.STRING(G_PROC_LEVEL,
359: G_PKG_NAME, '1500: - attribute NUM_SEQUENCE_CODE is invalid' );
360: END IF;
361:
362: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'NUM_SEQUENCE_CODE');

Line 371: FND_LOG.STRING(G_PROC_LEVEL,

367: Okc_Debug.Log('1400: - attribute SEQUENCE_LEVEL ', 2);
368: END IF;*/
369:
370: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
371: FND_LOG.STRING(G_PROC_LEVEL,
372: G_PKG_NAME, '1400: - attribute SEQUENCE_LEVEL ' );
373: END IF;
374:
375: IF ( p_sequence_level IS NULL) THEN

Line 381: FND_LOG.STRING(G_PROC_LEVEL,

377: Okc_Debug.Log('1500: - attribute SEQUENCE_LEVEL is invalid', 2);
378: END IF;*/
379:
380: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
381: FND_LOG.STRING(G_PROC_LEVEL,
382: G_PKG_NAME, '1500: - attribute SEQUENCE_LEVEL is invalid' );
383: END IF;
384:
385: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SEQUENCE_LEVEL');

Line 394: FND_LOG.STRING(G_PROC_LEVEL,

390: Okc_Debug.Log('1400: - attribute CONCATENATION_YN ', 2);
391: END IF;*/
392:
393: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
394: FND_LOG.STRING(G_PROC_LEVEL,
395: G_PKG_NAME, '1400: - attribute CONCATENATION_YN ' );
396: END IF;
397:
398: IF ( p_concatenation_yn IS NULL) THEN

Line 404: FND_LOG.STRING(G_PROC_LEVEL,

400: Okc_Debug.Log('1500: - attribute CONCATENATION_YN is invalid', 2);
401: END IF;*/
402:
403: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
404: FND_LOG.STRING(G_PROC_LEVEL,
405: G_PKG_NAME, '1500: - attribute CONCATENATION_YN is invalid' );
406: END IF;
407:
408: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'CONCATENATION_YN');

Line 420: FND_LOG.STRING(G_PROC_LEVEL,

416: Okc_Debug.Log('1600: static values and range validation', 2);
417: END IF;*/
418:
419: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
420: FND_LOG.STRING(G_PROC_LEVEL,
421: G_PKG_NAME, '1600: static values and range validation' );
422: END IF;
423:
424: /*IF (l_debug = 'Y') THEN

Line 429: FND_LOG.STRING(G_PROC_LEVEL,

425: Okc_Debug.Log('1700: - attribute CONCATENATION_YN ', 2);
426: END IF;*/
427:
428: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
429: FND_LOG.STRING(G_PROC_LEVEL,
430: G_PKG_NAME, '1700: - attribute CONCATENATION_YN ' );
431: END IF;
432:
433: IF ( p_concatenation_yn NOT IN ('Y','N') AND p_concatenation_yn IS NOT NULL) THEN

Line 439: FND_LOG.STRING(G_PROC_LEVEL,

435: Okc_Debug.Log('1800: - attribute CONCATENATION_YN is invalid', 2);
436: END IF;*/
437:
438: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
439: FND_LOG.STRING(G_PROC_LEVEL,
440: G_PKG_NAME, '1800: - attribute CONCATENATION_YN is invalid' );
441: END IF;
442:
443: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'CONCATENATION_YN');

Line 455: FND_LOG.STRING(G_PROC_LEVEL,

451: Okc_Debug.Log('1900: lookup codes 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, '1900: lookup codes validation' );
457: END IF;
458:
459: /*IF (l_debug = 'Y') THEN

Line 464: FND_LOG.STRING(G_PROC_LEVEL,

460: Okc_Debug.Log('2000: - attribute NUM_SEQUENCE_CODE ', 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, '2000: - attribute NUM_SEQUENCE_CODE ' );
466: END IF;
467:
468: IF p_num_sequence_code IS NOT NULL THEN

Line 484: FND_LOG.STRING(G_PROC_LEVEL,

480: Okc_Debug.Log('2100: foreigh keys validation ', 2);
481: END IF;*/
482:
483: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
484: FND_LOG.STRING(G_PROC_LEVEL,
485: G_PKG_NAME, '2100: foreigh keys validation ' );
486: END IF;
487:
488: /*IF (l_debug = 'Y') THEN

Line 493: FND_LOG.STRING(G_PROC_LEVEL,

489: Okc_Debug.Log('2100: foreigh keys validation ', 2);
490: END IF;*/
491:
492: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
493: FND_LOG.STRING(G_PROC_LEVEL,
494: G_PKG_NAME, '2100: foreigh keys validation ' );
495: END IF;
496:
497: IF p_num_scheme_id IS NOT NULL THEN

Line 508: FND_LOG.STRING(G_PROC_LEVEL,

504: Okc_Debug.Log('2300: - attribute NUM_SCHEME_ID 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, '2300: - attribute NUM_SCHEME_ID is invalid' );
510: END IF;
511: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'NUM_SCHEME_ID');
512: l_return_status := G_RET_STS_ERROR;

Line 524: FND_LOG.STRING(G_PROC_LEVEL,

520: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
521: END IF;*/
522:
523: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
524: FND_LOG.STRING(G_PROC_LEVEL,
525: G_PKG_NAME, '2400: Leaving Validate_Attributes ' );
526: END IF;
527:
528: RETURN l_return_status;

Line 535: FND_LOG.STRING(G_EXCP_LEVEL,

531: WHEN OTHERS THEN
532: --Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
533:
534: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
535: FND_LOG.STRING(G_EXCP_LEVEL,
536: G_PKG_NAME, '2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm );
537: END IF;
538: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
539: p_msg_name => G_UNEXPECTED_ERROR,

Line 578: FND_LOG.STRING(G_PROC_LEVEL,

574: Okc_Debug.Log('2600: Entered Validate_Record', 2);
575: END IF;*/
576:
577: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
578: FND_LOG.STRING(G_PROC_LEVEL,
579: G_PKG_NAME, '2600: Entered Validate_Record' );
580: END IF;
581:
582: --- Validate all non-missing attributes (Item Level Validation)

Line 598: FND_LOG.STRING(G_PROC_LEVEL,

594: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
595: END IF;*/
596:
597: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
598: FND_LOG.STRING(G_PROC_LEVEL,
599: G_PKG_NAME, '2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm );
600: END IF;
601: RETURN G_RET_STS_UNEXP_ERROR;
602: END IF;

Line 611: FND_LOG.STRING(G_PROC_LEVEL,

607: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
608: END IF;*/
609:
610: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
611: FND_LOG.STRING(G_PROC_LEVEL,
612: G_PKG_NAME, '2800: Entered Record Level Validations' );
613: END IF;
614: /*+++++++++++++start of hand code +++++++++++++++++++*/
615: -- ?? manual coding for Record Level Validations if required ??

Line 624: FND_LOG.STRING(G_PROC_LEVEL,

620: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
621: END IF;*/
622:
623: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
624: FND_LOG.STRING(G_PROC_LEVEL,
625: G_PKG_NAME, '2900: Leaving Validate_Record : '||sqlerrm );
626: END IF;
627: RETURN l_return_status ;
628:

Line 637: FND_LOG.STRING(G_EXCP_LEVEL,

633: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
634: END IF;*/
635:
636: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
637: FND_LOG.STRING(G_EXCP_LEVEL,
638: G_PKG_NAME, '3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm );
639: END IF;
640:
641: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 687: FND_LOG.STRING(G_PROC_LEVEL,

683: Okc_Debug.Log('3100: Entered validate_row', 2);
684: END IF;*/
685:
686: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
687: FND_LOG.STRING(G_PROC_LEVEL,
688: G_PKG_NAME, '3100: Entered validate_row' );
689: END IF;
690:
691: -- Setting attributes

Line 724: FND_LOG.STRING(G_PROC_LEVEL,

720: Okc_Debug.Log('3200: Leaving validate_row', 2);
721: END IF;*/
722:
723: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
724: FND_LOG.STRING(G_PROC_LEVEL,
725: G_PKG_NAME, '3200: Leaving validate_row' );
726: END IF;
727:
728: EXCEPTION

Line 735: FND_LOG.STRING(G_EXCP_LEVEL,

731: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 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, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception' );
737: END IF;
738: x_return_status := G_RET_STS_ERROR;
739:

Line 746: FND_LOG.STRING(G_EXCP_LEVEL,

742: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
743: END IF;*/
744:
745: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
746: FND_LOG.STRING(G_EXCP_LEVEL,
747: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
748: END IF;
749: x_return_status := G_RET_STS_UNEXP_ERROR;
750:

Line 757: FND_LOG.STRING(G_EXCP_LEVEL,

753: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
754: END IF;*/
755:
756: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
757: FND_LOG.STRING(G_EXCP_LEVEL,
758: G_PKG_NAME, '3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm );
759: END IF;
760: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
761: p_msg_name => G_UNEXPECTED_ERROR,

Line 798: FND_LOG.STRING(G_PROC_LEVEL,

794: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
795: END IF;*/
796:
797: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
798: FND_LOG.STRING(G_PROC_LEVEL,
799: G_PKG_NAME, '3600: Entered Insert_Row function' );
800: END IF;
801:
802: INSERT INTO OKC_NUMBER_SCHEME_DTLS(

Line 832: FND_LOG.STRING(G_PROC_LEVEL,

828: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
829: END IF;*/
830:
831: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
832: FND_LOG.STRING(G_PROC_LEVEL,
833: G_PKG_NAME, '3700: Leaving Insert_Row' );
834: END IF;
835:
836: RETURN( G_RET_STS_SUCCESS );

Line 846: FND_LOG.STRING(G_EXCP_LEVEL,

842: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
843: END IF;*/
844:
845: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
846: FND_LOG.STRING(G_EXCP_LEVEL,
847: G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
848: END IF;
849:
850: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 898: FND_LOG.STRING(G_PROC_LEVEL,

894: Okc_Debug.Log('4200: Entered Insert_Row', 2);
895: END IF;*/
896:
897: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
898: FND_LOG.STRING(G_PROC_LEVEL,
899: G_PKG_NAME, '4200: Entered Insert_Row' );
900: END IF;
901:
902: --- Setting item attributes

Line 940: FND_LOG.STRING(G_PROC_LEVEL,

936: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
937: END IF;*/
938:
939: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
940: FND_LOG.STRING(G_PROC_LEVEL,
941: G_PKG_NAME, '4300: Call the internal Insert_Row for Base Table' );
942: END IF;
943:
944: x_return_status := Insert_Row(

Line 970: FND_LOG.STRING(G_PROC_LEVEL,

966: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
967: END IF;*/
968:
969: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
970: FND_LOG.STRING(G_PROC_LEVEL,
971: G_PKG_NAME, '4500: Leaving Insert_Row' );
972: END IF;
973:
974: EXCEPTION

Line 981: FND_LOG.STRING(G_EXCP_LEVEL,

977: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
978: END IF;*/
979:
980: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
981: FND_LOG.STRING(G_EXCP_LEVEL,
982: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
983: END IF;
984: x_return_status := G_RET_STS_ERROR;
985:

Line 992: FND_LOG.STRING(G_EXCP_LEVEL,

988: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
989: END IF;*/
990:
991: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
992: FND_LOG.STRING(G_EXCP_LEVEL,
993: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
994: END IF;
995: x_return_status := G_RET_STS_UNEXP_ERROR;
996:

Line 1003: FND_LOG.STRING(G_EXCP_LEVEL,

999: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
1000: END IF;*/
1001:
1002: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1003: FND_LOG.STRING(G_EXCP_LEVEL,
1004: G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm );
1005: END IF;
1006: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1007: p_msg_name => G_UNEXPECTED_ERROR,

Line 1052: FND_LOG.STRING(G_PROC_LEVEL,

1048: Okc_Debug.Log('4900: Entered Lock_Row', 2);
1049: END IF;*/
1050:
1051: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1052: FND_LOG.STRING(G_PROC_LEVEL,
1053: G_PKG_NAME, '4900: Entered Lock_Row' );
1054: END IF;
1055:
1056: BEGIN

Line 1071: FND_LOG.STRING(G_PROC_LEVEL,

1067: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1068: END IF;*/
1069:
1070: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1071: FND_LOG.STRING(G_PROC_LEVEL,
1072: G_PKG_NAME, '5000: Leaving Lock_Row:E_Resource_Busy Exception' );
1073: END IF;
1074:
1075: IF (lock_csr%ISOPEN) THEN

Line 1108: FND_LOG.STRING(G_PROC_LEVEL,

1104: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1105: END IF;*/
1106:
1107: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1108: FND_LOG.STRING(G_PROC_LEVEL,
1109: G_PKG_NAME, '5100: Leaving Lock_Row' );
1110: END IF;
1111:
1112: RETURN( l_return_status );

Line 1129: FND_LOG.STRING(G_EXCP_LEVEL,

1125: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1126: END IF;*/
1127:
1128: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1129: FND_LOG.STRING(G_EXCP_LEVEL,
1130: G_PKG_NAME, '5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm );
1131: END IF;
1132:
1133: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1162: FND_LOG.STRING(G_PROC_LEVEL,

1158: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1159: END IF;*/
1160:
1161: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1162: FND_LOG.STRING(G_PROC_LEVEL,
1163: G_PKG_NAME, '5700: Entered Lock_Row');
1164: FND_LOG.STRING(G_PROC_LEVEL,
1165: G_PKG_NAME, '5800: Locking Row for Base Table');
1166: END IF;

Line 1164: FND_LOG.STRING(G_PROC_LEVEL,

1160:
1161: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1162: FND_LOG.STRING(G_PROC_LEVEL,
1163: G_PKG_NAME, '5700: Entered Lock_Row');
1164: FND_LOG.STRING(G_PROC_LEVEL,
1165: G_PKG_NAME, '5800: Locking Row for Base Table');
1166: END IF;
1167:
1168: --------------------------------------------

Line 1190: FND_LOG.STRING(G_PROC_LEVEL,

1186: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1187: END IF;*/
1188:
1189: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1190: FND_LOG.STRING(G_PROC_LEVEL,
1191: G_PKG_NAME, '6000: Leaving Lock_Row' );
1192: END IF;
1193:
1194: EXCEPTION

Line 1201: FND_LOG.STRING(G_EXCP_LEVEL,

1197: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1198: END IF;*/
1199:
1200: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1201: FND_LOG.STRING(G_EXCP_LEVEL,
1202: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
1203: END IF;
1204: x_return_status := G_RET_STS_ERROR;
1205:

Line 1212: FND_LOG.STRING(G_EXCP_LEVEL,

1208: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1209: END IF;*/
1210:
1211: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1212: FND_LOG.STRING(G_EXCP_LEVEL,
1213: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1214: END IF;
1215: x_return_status := G_RET_STS_UNEXP_ERROR;
1216:

Line 1223: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 1260: FND_LOG.STRING(G_PROC_LEVEL,

1256: Okc_Debug.Log('6400: Entered Update_Row', 2);
1257: END IF;*/
1258:
1259: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1260: FND_LOG.STRING(G_PROC_LEVEL,
1261: G_PKG_NAME, '6400: Entered Update_Row' );
1262: END IF;
1263:
1264: UPDATE OKC_NUMBER_SCHEME_DTLS

Line 1278: FND_LOG.STRING(G_PROC_LEVEL,

1274: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1275: END IF;*/
1276:
1277: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1278: FND_LOG.STRING(G_PROC_LEVEL,
1279: G_PKG_NAME, '6500: Leaving Update_Row' );
1280: END IF;
1281:
1282: RETURN G_RET_STS_SUCCESS ;

Line 1292: FND_LOG.STRING(G_EXCP_LEVEL,

1288: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1289: END IF;*/
1290:
1291: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1292: FND_LOG.STRING(G_EXCP_LEVEL,
1293: G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
1294: END IF;
1295:
1296: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1340: FND_LOG.STRING(G_PROC_LEVEL,

1336: Okc_Debug.Log('7100: Locking _B row', 2);
1337: END IF;*/
1338:
1339: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1340: FND_LOG.STRING(G_PROC_LEVEL,
1341: G_PKG_NAME, '7000: Entered Update_Row');
1342: FND_LOG.STRING(G_PROC_LEVEL,
1343: G_PKG_NAME, '7100: Locking _B row');
1344: END IF;

Line 1342: FND_LOG.STRING(G_PROC_LEVEL,

1338:
1339: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1340: FND_LOG.STRING(G_PROC_LEVEL,
1341: G_PKG_NAME, '7000: Entered Update_Row');
1342: FND_LOG.STRING(G_PROC_LEVEL,
1343: G_PKG_NAME, '7100: Locking _B row');
1344: END IF;
1345:
1346: x_return_status := Lock_row(

Line 1364: FND_LOG.STRING(G_PROC_LEVEL,

1360: Okc_Debug.Log('7300: Setting attributes', 2);
1361: END IF;*/
1362:
1363: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1364: FND_LOG.STRING(G_PROC_LEVEL,
1365: G_PKG_NAME, '7300: Setting attributes');
1366: END IF;
1367:
1368: x_return_status := Set_Attributes(

Line 1390: FND_LOG.STRING(G_PROC_LEVEL,

1386: Okc_Debug.Log('7400: Record Validation', 2);
1387: END IF;*/
1388:
1389: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1390: FND_LOG.STRING(G_PROC_LEVEL,
1391: G_PKG_NAME, '7400: Record Validation');
1392: END IF;
1393:
1394: --- Validate all non-missing attributes

Line 1415: FND_LOG.STRING(G_PROC_LEVEL,

1411: Okc_Debug.Log('7500: Filling WHO columns', 2);
1412: END IF;*/
1413:
1414: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1415: FND_LOG.STRING(G_PROC_LEVEL,
1416: G_PKG_NAME, '7500: Filling WHO columns');
1417: END IF;
1418:
1419: -- Filling who columns

Line 1437: FND_LOG.STRING(G_PROC_LEVEL,

1433: Okc_Debug.Log('7600: Updating Row', 2);
1434: END IF;*/
1435:
1436: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1437: FND_LOG.STRING(G_PROC_LEVEL,
1438: G_PKG_NAME, '7600: Updating Row');
1439: END IF;
1440:
1441: x_return_status := Update_Row(

Line 1464: FND_LOG.STRING(G_PROC_LEVEL,

1460: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1461: END IF;*/
1462:
1463: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1464: FND_LOG.STRING(G_PROC_LEVEL,
1465: G_PKG_NAME, '7800: Leaving Update_Row');
1466: END IF;
1467:
1468: EXCEPTION

Line 1475: FND_LOG.STRING(G_EXCP_LEVEL,

1471: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1472: END IF;*/
1473:
1474: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1475: FND_LOG.STRING(G_EXCP_LEVEL,
1476: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
1477: END IF;
1478: x_return_status := G_RET_STS_ERROR;
1479:

Line 1486: FND_LOG.STRING(G_EXCP_LEVEL,

1482: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1483: END IF;*/
1484:
1485: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1486: FND_LOG.STRING(G_EXCP_LEVEL,
1487: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1488: END IF;
1489: x_return_status := G_RET_STS_UNEXP_ERROR;
1490:

Line 1497: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 1529: FND_LOG.STRING(G_PROC_LEVEL,

1525: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1526: END IF;*/
1527:
1528: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1529: FND_LOG.STRING(G_PROC_LEVEL,
1530: G_PKG_NAME, '8200: Entered Delete_Row' );
1531: END IF;
1532:
1533: DELETE FROM OKC_NUMBER_SCHEME_DTLS

Line 1541: FND_LOG.STRING(G_PROC_LEVEL,

1537: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1538: END IF;*/
1539:
1540: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1541: FND_LOG.STRING(G_PROC_LEVEL,
1542: G_PKG_NAME, '8300: Leaving Delete_Row' );
1543: END IF;
1544:
1545: RETURN( G_RET_STS_SUCCESS );

Line 1555: FND_LOG.STRING(G_EXCP_LEVEL,

1551: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1552: END IF;*/
1553:
1554: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1555: FND_LOG.STRING(G_EXCP_LEVEL,
1556: G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1557: END IF;
1558:
1559: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1588: FND_LOG.STRING(G_PROC_LEVEL,

1584: Okc_Debug.Log('8900: Locking _B row', 2);
1585: END IF;*/
1586:
1587: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1588: FND_LOG.STRING(G_PROC_LEVEL,
1589: G_PKG_NAME, '8800: Entered Delete_Row');
1590: FND_LOG.STRING(G_PROC_LEVEL,
1591: G_PKG_NAME, '8900: Locking _B row');
1592: END IF;

Line 1590: FND_LOG.STRING(G_PROC_LEVEL,

1586:
1587: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1588: FND_LOG.STRING(G_PROC_LEVEL,
1589: G_PKG_NAME, '8800: Entered Delete_Row');
1590: FND_LOG.STRING(G_PROC_LEVEL,
1591: G_PKG_NAME, '8900: Locking _B row');
1592: END IF;
1593:
1594: x_return_status := Lock_row(

Line 1612: FND_LOG.STRING(G_PROC_LEVEL,

1608: Okc_Debug.Log('9100: Removing _B row', 2);
1609: END IF;*/
1610:
1611: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1612: FND_LOG.STRING(G_PROC_LEVEL,
1613: G_PKG_NAME, '9100: Removing _B row' );
1614: END IF;
1615: x_return_status := Delete_Row( p_num_scheme_id => p_num_scheme_id,p_num_sequence_code => p_num_sequence_code,p_sequence_level => p_sequence_level );
1616: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1627: FND_LOG.STRING(G_PROC_LEVEL,

1623: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1624: END IF;*/
1625:
1626: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1627: FND_LOG.STRING(G_PROC_LEVEL,
1628: G_PKG_NAME, '9300: Leaving Delete_Row' );
1629: END IF;
1630:
1631: EXCEPTION

Line 1638: FND_LOG.STRING(G_EXCP_LEVEL,

1634: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1635: END IF;*/
1636:
1637: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1638: FND_LOG.STRING(G_EXCP_LEVEL,
1639: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
1640: END IF;
1641: x_return_status := G_RET_STS_ERROR;
1642:

Line 1649: FND_LOG.STRING(G_EXCP_LEVEL,

1645: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1646: END IF;*/
1647:
1648: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1649: FND_LOG.STRING(G_EXCP_LEVEL,
1650: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1651: END IF;
1652: x_return_status := G_RET_STS_UNEXP_ERROR;
1653:

Line 1660: FND_LOG.STRING(G_EXCP_LEVEL,

1656: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1657: END IF;*/
1658:
1659: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1660: FND_LOG.STRING(G_EXCP_LEVEL,
1661: G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
1662: END IF;
1663:
1664: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1692: FND_LOG.STRING(G_PROC_LEVEL,

1688: Okc_Debug.Log('9800: Locking the Set', 2);
1689: END IF;*/
1690:
1691: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1692: FND_LOG.STRING(G_PROC_LEVEL,
1693: G_PKG_NAME, '9700: Entered Delete_Set');
1694: FND_LOG.STRING(G_PROC_LEVEL,
1695: G_PKG_NAME, '9800: Locking the Set');
1696: END IF;

Line 1694: FND_LOG.STRING(G_PROC_LEVEL,

1690:
1691: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1692: FND_LOG.STRING(G_PROC_LEVEL,
1693: G_PKG_NAME, '9700: Entered Delete_Set');
1694: FND_LOG.STRING(G_PROC_LEVEL,
1695: G_PKG_NAME, '9800: Locking the Set');
1696: END IF;
1697:
1698: -- making OPEN/CLOSE cursor to lock records

Line 1707: FND_LOG.STRING(G_PROC_LEVEL,

1703: Okc_Debug.Log('9900: Deleting the Set', 2);
1704: END IF;*/
1705:
1706: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1707: FND_LOG.STRING(G_PROC_LEVEL,
1708: G_PKG_NAME, '9900: Deleting the Set' );
1709: END IF;
1710:
1711: DELETE FROM OKC_NUMBER_SCHEME_DTLS

Line 1719: FND_LOG.STRING(G_PROC_LEVEL,

1715: Okc_Debug.Log('10000: Leaving Delete_set', 2);
1716: END IF;*/
1717:
1718: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1719: FND_LOG.STRING(G_PROC_LEVEL,
1720: G_PKG_NAME, '10000: Leaving Delete_set' );
1721: END IF;
1722: EXCEPTION
1723: WHEN E_Resource_Busy THEN

Line 1729: FND_LOG.STRING(G_EXCP_LEVEL,

1725: Okc_Debug.Log('11000: Leaving Delete_set:E_Resource_Busy Exception', 2);
1726: END IF;*/
1727:
1728: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1729: FND_LOG.STRING(G_EXCP_LEVEL,
1730: G_PKG_NAME, '11000: Leaving Delete_set:E_Resource_Busy Exception' );
1731: END IF;
1732:
1733: IF (lock_csr%ISOPEN) THEN

Line 1745: FND_LOG.STRING(G_EXCP_LEVEL,

1741: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
1742: END IF;*/
1743:
1744: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1745: FND_LOG.STRING(G_EXCP_LEVEL,
1746: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
1747: END IF;
1748: x_return_status := G_RET_STS_ERROR;
1749:

Line 1756: FND_LOG.STRING(G_EXCP_LEVEL,

1752: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1753: END IF;*/
1754:
1755: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1756: FND_LOG.STRING(G_EXCP_LEVEL,
1757: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1758: END IF;
1759: x_return_status := G_RET_STS_UNEXP_ERROR;
1760:

Line 1767: FND_LOG.STRING(G_EXCP_LEVEL,

1763: Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
1764: END IF;*/
1765:
1766: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1767: FND_LOG.STRING(G_EXCP_LEVEL,
1768: G_PKG_NAME, '11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm );
1769: END IF;
1770:
1771: Okc_Api.Set_Message(p_app_name => G_APP_NAME,