APPS.OKC_SAE_PVT dependencies on OKC_DEBUG

Line 52: okc_debug.Set_Indentation('OKC_SAE_PVT');

48: PROCEDURE add_language IS
49: BEGIN
50:
51: IF (l_debug = 'Y') THEN
52: okc_debug.Set_Indentation('OKC_SAE_PVT');
53: okc_debug.log('500: Entered add_language', 2);
54: END IF;
55:
56: /* Mar/19/03 requested by Ric Ginsberg */

Line 53: okc_debug.log('500: Entered add_language', 2);

49: BEGIN
50:
51: IF (l_debug = 'Y') THEN
52: okc_debug.Set_Indentation('OKC_SAE_PVT');
53: okc_debug.log('500: Entered add_language', 2);
54: END IF;
55:
56: /* Mar/19/03 requested by Ric Ginsberg */
57: /* The following delete and update statements are commented out */

Line 121: okc_debug.log('500: Leaving add_language ', 2);

117: AND T.LANGUAGE = L.LANGUAGE_CODE
118: );
119:
120: IF (l_debug = 'Y') THEN
121: okc_debug.log('500: Leaving add_language ', 2);
122: okc_debug.Reset_Indentation;
123: END IF;
124:
125: END add_language;

Line 122: okc_debug.Reset_Indentation;

118: );
119:
120: IF (l_debug = 'Y') THEN
121: okc_debug.log('500: Leaving add_language ', 2);
122: okc_debug.Reset_Indentation;
123: END IF;
124:
125: END add_language;
126:

Line 167: okc_debug.Set_Indentation('OKC_SAE_PVT');

163: l_sae_rec sae_rec_type;
164: BEGIN
165:
166: IF (l_debug = 'Y') THEN
167: okc_debug.Set_Indentation('OKC_SAE_PVT');
168: okc_debug.log('600: Entered get_rec', 2);
169: END IF;
170:
171: x_no_data_found := TRUE;

Line 168: okc_debug.log('600: Entered get_rec', 2);

164: BEGIN
165:
166: IF (l_debug = 'Y') THEN
167: okc_debug.Set_Indentation('OKC_SAE_PVT');
168: okc_debug.log('600: Entered get_rec', 2);
169: END IF;
170:
171: x_no_data_found := TRUE;
172: -- Get current database values

Line 203: okc_debug.log('900: Leaving Fn Get_Rec ', 2);

199: x_no_data_found := sae_pk_csr%NOTFOUND;
200: CLOSE sae_pk_csr;
201:
202: IF (l_debug = 'Y') THEN
203: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
204: okc_debug.Reset_Indentation;
205: END IF;
206:
207: RETURN(l_sae_rec);

Line 204: okc_debug.Reset_Indentation;

200: CLOSE sae_pk_csr;
201:
202: IF (l_debug = 'Y') THEN
203: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
204: okc_debug.Reset_Indentation;
205: END IF;
206:
207: RETURN(l_sae_rec);
208:

Line 248: okc_debug.Set_Indentation('OKC_SAE_PVT');

244: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
245: BEGIN
246:
247: IF (l_debug = 'Y') THEN
248: okc_debug.Set_Indentation('OKC_SAE_PVT');
249: okc_debug.log('800: Entered get_rec', 2);
250: END IF;
251:
252: x_no_data_found := TRUE;

Line 249: okc_debug.log('800: Entered get_rec', 2);

245: BEGIN
246:
247: IF (l_debug = 'Y') THEN
248: okc_debug.Set_Indentation('OKC_SAE_PVT');
249: okc_debug.log('800: Entered get_rec', 2);
250: END IF;
251:
252: x_no_data_found := TRUE;
253: -- Get current database values

Line 271: okc_debug.log('900: Leaving Fn Get_Rec ', 2);

267: x_no_data_found := sae_pktl_csr%NOTFOUND;
268: CLOSE sae_pktl_csr;
269:
270: IF (l_debug = 'Y') THEN
271: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
272: okc_debug.Reset_Indentation;
273: END IF;
274:
275: RETURN(l_okc_std_articles_tl_rec);

Line 272: okc_debug.Reset_Indentation;

268: CLOSE sae_pktl_csr;
269:
270: IF (l_debug = 'Y') THEN
271: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
272: okc_debug.Reset_Indentation;
273: END IF;
274:
275: RETURN(l_okc_std_articles_tl_rec);
276:

Line 330: okc_debug.Set_Indentation('OKC_SAE_PVT');

326: l_saev_rec saev_rec_type;
327: BEGIN
328:
329: IF (l_debug = 'Y') THEN
330: okc_debug.Set_Indentation('OKC_SAE_PVT');
331: okc_debug.log('1000: Entered get_rec', 2);
332: END IF;
333:
334: x_no_data_found := TRUE;

Line 331: okc_debug.log('1000: Entered get_rec', 2);

327: BEGIN
328:
329: IF (l_debug = 'Y') THEN
330: okc_debug.Set_Indentation('OKC_SAE_PVT');
331: okc_debug.log('1000: Entered get_rec', 2);
332: END IF;
333:
334: x_no_data_found := TRUE;
335: -- Get current database values

Line 368: okc_debug.log('900: Leaving Fn Get_Rec ', 2);

364: x_no_data_found := okc_saev_pk_csr%NOTFOUND;
365: CLOSE okc_saev_pk_csr;
366:
367: IF (l_debug = 'Y') THEN
368: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
369: okc_debug.Reset_Indentation;
370: END IF;
371:
372: RETURN(l_saev_rec);

Line 369: okc_debug.Reset_Indentation;

365: CLOSE okc_saev_pk_csr;
366:
367: IF (l_debug = 'Y') THEN
368: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
369: okc_debug.Reset_Indentation;
370: END IF;
371:
372: RETURN(l_saev_rec);
373: END get_rec;

Line 395: okc_debug.Set_Indentation('OKC_SAE_PVT');

391: l_saev_rec saev_rec_type := p_saev_rec;
392: BEGIN
393:
394: IF (l_debug = 'Y') THEN
395: okc_debug.Set_Indentation('OKC_SAE_PVT');
396: okc_debug.log('1200: Entered null_out_defaults', 2);
397: END IF;
398:
399: IF (l_saev_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

Line 396: okc_debug.log('1200: Entered null_out_defaults', 2);

392: BEGIN
393:
394: IF (l_debug = 'Y') THEN
395: okc_debug.Set_Indentation('OKC_SAE_PVT');
396: okc_debug.log('1200: Entered null_out_defaults', 2);
397: END IF;
398:
399: IF (l_saev_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
400: l_saev_rec.object_version_number := NULL;

Line 476: okc_debug.log('500: Leaving null_out_defaults ', 2);

472: l_saev_rec.last_update_login := NULL;
473: END IF;
474:
475: IF (l_debug = 'Y') THEN
476: okc_debug.log('500: Leaving null_out_defaults ', 2);
477: okc_debug.Reset_Indentation;
478: END IF;
479:
480: RETURN(l_saev_rec);

Line 477: okc_debug.Reset_Indentation;

473: END IF;
474:
475: IF (l_debug = 'Y') THEN
476: okc_debug.log('500: Leaving null_out_defaults ', 2);
477: okc_debug.Reset_Indentation;
478: END IF;
479:
480: RETURN(l_saev_rec);
481:

Line 508: okc_debug.Set_Indentation('OKC_SAE_PVT');

504:
505: BEGIN
506:
507: IF (l_debug = 'Y') THEN
508: okc_debug.Set_Indentation('OKC_SAE_PVT');
509: okc_debug.log('1300: Entered validate_no_k_attached', 2);
510: END IF;
511:
512: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 509: okc_debug.log('1300: Entered validate_no_k_attached', 2);

505: BEGIN
506:
507: IF (l_debug = 'Y') THEN
508: okc_debug.Set_Indentation('OKC_SAE_PVT');
509: okc_debug.log('1300: Entered validate_no_k_attached', 2);
510: END IF;
511:
512: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
513:

Line 523: okc_debug.log('1400: Leaving validate_no_k_attached', 2);

519: x_return_status:=OKC_API.G_RET_STS_ERROR;
520: End If;
521:
522: IF (l_debug = 'Y') THEN
523: okc_debug.log('1400: Leaving validate_no_k_attached', 2);
524: okc_debug.Reset_Indentation;
525: END IF;
526: EXCEPTION
527: -- other appropriate handlers

Line 524: okc_debug.Reset_Indentation;

520: End If;
521:
522: IF (l_debug = 'Y') THEN
523: okc_debug.log('1400: Leaving validate_no_k_attached', 2);
524: okc_debug.Reset_Indentation;
525: END IF;
526: EXCEPTION
527: -- other appropriate handlers
528: When others then

Line 531: okc_debug.log('1500: Exiting validate_no_k_attached:others Exception', 2);

527: -- other appropriate handlers
528: When others then
529:
530: IF (l_debug = 'Y') THEN
531: okc_debug.log('1500: Exiting validate_no_k_attached:others Exception', 2);
532: okc_debug.Reset_Indentation;
533: END IF;
534:
535: -- store SQL error message on message stack

Line 532: okc_debug.Reset_Indentation;

528: When others then
529:
530: IF (l_debug = 'Y') THEN
531: okc_debug.log('1500: Exiting validate_no_k_attached:others Exception', 2);
532: okc_debug.Reset_Indentation;
533: END IF;
534:
535: -- store SQL error message on message stack
536: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 561: okc_debug.Set_Indentation('OKC_SAE_PVT');

557:
558: BEGIN
559:
560: IF (l_debug = 'Y') THEN
561: okc_debug.Set_Indentation('OKC_SAE_PVT');
562: okc_debug.log('1600: Entered validate_id', 2);
563: END IF;
564:
565: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 562: okc_debug.log('1600: Entered validate_id', 2);

558: BEGIN
559:
560: IF (l_debug = 'Y') THEN
561: okc_debug.Set_Indentation('OKC_SAE_PVT');
562: okc_debug.log('1600: Entered validate_id', 2);
563: END IF;
564:
565: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
566: --check not null

Line 578: okc_debug.log('1700: Leaving validate_id', 2);

574: RAISE G_EXCEPTION_HALT_VALIDATION;
575: End If;
576:
577: IF (l_debug = 'Y') THEN
578: okc_debug.log('1700: Leaving validate_id', 2);
579: okc_debug.Reset_Indentation;
580: END IF;
581:
582: EXCEPTION

Line 579: okc_debug.Reset_Indentation;

575: End If;
576:
577: IF (l_debug = 'Y') THEN
578: okc_debug.log('1700: Leaving validate_id', 2);
579: okc_debug.Reset_Indentation;
580: END IF;
581:
582: EXCEPTION
583: When G_EXCEPTION_HALT_VALIDATION then

Line 586: okc_debug.log('1800: Exiting validate_id:G_EXCEPTION_HALT_VALIDATION Exception', 2);

582: EXCEPTION
583: When G_EXCEPTION_HALT_VALIDATION then
584:
585: IF (l_debug = 'Y') THEN
586: okc_debug.log('1800: Exiting validate_id:G_EXCEPTION_HALT_VALIDATION Exception', 2);
587: okc_debug.Reset_Indentation;
588: END IF;
589:
590: --just come out with return status

Line 587: okc_debug.Reset_Indentation;

583: When G_EXCEPTION_HALT_VALIDATION then
584:
585: IF (l_debug = 'Y') THEN
586: okc_debug.log('1800: Exiting validate_id:G_EXCEPTION_HALT_VALIDATION Exception', 2);
587: okc_debug.Reset_Indentation;
588: END IF;
589:
590: --just come out with return status
591: null;

Line 596: okc_debug.log('1900: Exiting validate_id:others Exception', 2);

592: -- other appropriate handlers
593: When others then
594:
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('1900: Exiting validate_id:others Exception', 2);
597: okc_debug.Reset_Indentation;
598: END IF;
599:
600: -- store SQL error message on message stack

Line 597: okc_debug.Reset_Indentation;

593: When others then
594:
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('1900: Exiting validate_id:others Exception', 2);
597: okc_debug.Reset_Indentation;
598: END IF;
599:
600: -- store SQL error message on message stack
601: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 626: okc_debug.Set_Indentation('OKC_SAE_PVT');

622:
623: BEGIN
624:
625: IF (l_debug = 'Y') THEN
626: okc_debug.Set_Indentation('OKC_SAE_PVT');
627: okc_debug.log('2000: Entered validate_Object_Version_Number', 2);
628: END IF;
629:
630: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 627: okc_debug.log('2000: Entered validate_Object_Version_Number', 2);

623: BEGIN
624:
625: IF (l_debug = 'Y') THEN
626: okc_debug.Set_Indentation('OKC_SAE_PVT');
627: okc_debug.log('2000: Entered validate_Object_Version_Number', 2);
628: END IF;
629:
630: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
631: --check not null

Line 644: okc_debug.log('2100: Leaving validate_Object_Version_Number', 2);

640: End If;
641:
642:
643: IF (l_debug = 'Y') THEN
644: okc_debug.log('2100: Leaving validate_Object_Version_Number', 2);
645: okc_debug.Reset_Indentation;
646: END IF;
647:
648: EXCEPTION

Line 645: okc_debug.Reset_Indentation;

641:
642:
643: IF (l_debug = 'Y') THEN
644: okc_debug.log('2100: Leaving validate_Object_Version_Number', 2);
645: okc_debug.Reset_Indentation;
646: END IF;
647:
648: EXCEPTION
649: When G_EXCEPTION_HALT_VALIDATION then

Line 652: okc_debug.log('2200: Exiting validate_Object_Version_Number:G_EXCEPTION_HALT_VALIDATION Exception', 2);

648: EXCEPTION
649: When G_EXCEPTION_HALT_VALIDATION then
650:
651: IF (l_debug = 'Y') THEN
652: okc_debug.log('2200: Exiting validate_Object_Version_Number:G_EXCEPTION_HALT_VALIDATION Exception', 2);
653: okc_debug.Reset_Indentation;
654: END IF;
655:
656: --just come out with return status

Line 653: okc_debug.Reset_Indentation;

649: When G_EXCEPTION_HALT_VALIDATION then
650:
651: IF (l_debug = 'Y') THEN
652: okc_debug.log('2200: Exiting validate_Object_Version_Number:G_EXCEPTION_HALT_VALIDATION Exception', 2);
653: okc_debug.Reset_Indentation;
654: END IF;
655:
656: --just come out with return status
657: null;

Line 662: okc_debug.log('2300: Exiting validate_Object_Version_Number:others Exception', 2);

658: -- other appropriate handlers
659: When others then
660:
661: IF (l_debug = 'Y') THEN
662: okc_debug.log('2300: Exiting validate_Object_Version_Number:others Exception', 2);
663: okc_debug.Reset_Indentation;
664: END IF;
665:
666: -- store SQL error message on message stack

Line 663: okc_debug.Reset_Indentation;

659: When others then
660:
661: IF (l_debug = 'Y') THEN
662: okc_debug.log('2300: Exiting validate_Object_Version_Number:others Exception', 2);
663: okc_debug.Reset_Indentation;
664: END IF;
665:
666: -- store SQL error message on message stack
667: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 693: okc_debug.Set_Indentation('OKC_SAE_PVT');

689: x_return_status OUT NOCOPY VARCHAR2) is
690: BEGIN
691:
692: IF (l_debug = 'Y') THEN
693: okc_debug.Set_Indentation('OKC_SAE_PVT');
694: okc_debug.log('2400: Entered validate_sfwt_flag', 2);
695: END IF;
696:
697: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 694: okc_debug.log('2400: Entered validate_sfwt_flag', 2);

690: BEGIN
691:
692: IF (l_debug = 'Y') THEN
693: okc_debug.Set_Indentation('OKC_SAE_PVT');
694: okc_debug.log('2400: Entered validate_sfwt_flag', 2);
695: END IF;
696:
697: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
698: --check not null

Line 736: okc_debug.log('2500: Leaving validate_sfwt_flag', 2);

732: RAISE G_EXCEPTION_HALT_VALIDATION;
733: End If;
734:
735: IF (l_debug = 'Y') THEN
736: okc_debug.log('2500: Leaving validate_sfwt_flag', 2);
737: okc_debug.Reset_Indentation;
738: END IF;
739:
740: EXCEPTION

Line 737: okc_debug.Reset_Indentation;

733: End If;
734:
735: IF (l_debug = 'Y') THEN
736: okc_debug.log('2500: Leaving validate_sfwt_flag', 2);
737: okc_debug.Reset_Indentation;
738: END IF;
739:
740: EXCEPTION
741: When G_EXCEPTION_HALT_VALIDATION then

Line 744: okc_debug.log('2600: Exiting validate_sfwt_flag:G_EXCEPTION_HALT_VALIDATION Exception', 2);

740: EXCEPTION
741: When G_EXCEPTION_HALT_VALIDATION then
742:
743: IF (l_debug = 'Y') THEN
744: okc_debug.log('2600: Exiting validate_sfwt_flag:G_EXCEPTION_HALT_VALIDATION Exception', 2);
745: okc_debug.Reset_Indentation;
746: END IF;
747:
748: --just come out with return status

Line 745: okc_debug.Reset_Indentation;

741: When G_EXCEPTION_HALT_VALIDATION then
742:
743: IF (l_debug = 'Y') THEN
744: okc_debug.log('2600: Exiting validate_sfwt_flag:G_EXCEPTION_HALT_VALIDATION Exception', 2);
745: okc_debug.Reset_Indentation;
746: END IF;
747:
748: --just come out with return status
749: null;

Line 754: okc_debug.log('2700: Exiting validate_sfwt_flag:others Exception', 2);

750: -- other appropriate handlers
751: When others then
752:
753: IF (l_debug = 'Y') THEN
754: okc_debug.log('2700: Exiting validate_sfwt_flag:others Exception', 2);
755: okc_debug.Reset_Indentation;
756: END IF;
757:
758: -- store SQL error message on message stack

Line 755: okc_debug.Reset_Indentation;

751: When others then
752:
753: IF (l_debug = 'Y') THEN
754: okc_debug.log('2700: Exiting validate_sfwt_flag:others Exception', 2);
755: okc_debug.Reset_Indentation;
756: END IF;
757:
758: -- store SQL error message on message stack
759: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 785: okc_debug.Set_Indentation('OKC_SAE_PVT');

781:
782: BEGIN
783:
784: IF (l_debug = 'Y') THEN
785: okc_debug.Set_Indentation('OKC_SAE_PVT');
786: okc_debug.log('2800: Entered validate_sbt_code', 2);
787: END IF;
788:
789: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 786: okc_debug.log('2800: Entered validate_sbt_code', 2);

782: BEGIN
783:
784: IF (l_debug = 'Y') THEN
785: okc_debug.Set_Indentation('OKC_SAE_PVT');
786: okc_debug.log('2800: Entered validate_sbt_code', 2);
787: END IF;
788:
789: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
790: --check not null

Line 827: okc_debug.log('2900: Leaving validate_sbt_code', 2);

823: RAISE G_EXCEPTION_HALT_VALIDATION;
824: End If;
825:
826: IF (l_debug = 'Y') THEN
827: okc_debug.log('2900: Leaving validate_sbt_code', 2);
828: okc_debug.Reset_Indentation;
829: END IF;
830:
831: EXCEPTION

Line 828: okc_debug.Reset_Indentation;

824: End If;
825:
826: IF (l_debug = 'Y') THEN
827: okc_debug.log('2900: Leaving validate_sbt_code', 2);
828: okc_debug.Reset_Indentation;
829: END IF;
830:
831: EXCEPTION
832: When G_EXCEPTION_HALT_VALIDATION then

Line 835: okc_debug.log('3000: Exiting validate_sbt_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);

831: EXCEPTION
832: When G_EXCEPTION_HALT_VALIDATION then
833:
834: IF (l_debug = 'Y') THEN
835: okc_debug.log('3000: Exiting validate_sbt_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);
836: okc_debug.Reset_Indentation;
837: END IF;
838:
839: --just come out with return status

Line 836: okc_debug.Reset_Indentation;

832: When G_EXCEPTION_HALT_VALIDATION then
833:
834: IF (l_debug = 'Y') THEN
835: okc_debug.log('3000: Exiting validate_sbt_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);
836: okc_debug.Reset_Indentation;
837: END IF;
838:
839: --just come out with return status
840: null;

Line 845: okc_debug.log('3100: Exiting validate_sbt_code:others Exception', 2);

841: -- other appropriate handlers
842: When others then
843:
844: IF (l_debug = 'Y') THEN
845: okc_debug.log('3100: Exiting validate_sbt_code:others Exception', 2);
846: okc_debug.Reset_Indentation;
847: END IF;
848:
849: -- store SQL error message on message stack

Line 846: okc_debug.Reset_Indentation;

842: When others then
843:
844: IF (l_debug = 'Y') THEN
845: okc_debug.log('3100: Exiting validate_sbt_code:others Exception', 2);
846: okc_debug.Reset_Indentation;
847: END IF;
848:
849: -- store SQL error message on message stack
850: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 878: okc_debug.Set_Indentation('OKC_SAE_PVT');

874: l_id number:=OKC_API.G_MISS_NUM;
875: BEGIN
876:
877: IF (l_debug = 'Y') THEN
878: okc_debug.Set_Indentation('OKC_SAE_PVT');
879: okc_debug.log('3200: Entered validate_name', 2);
880: END IF;
881:
882: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 879: okc_debug.log('3200: Entered validate_name', 2);

875: BEGIN
876:
877: IF (l_debug = 'Y') THEN
878: okc_debug.Set_Indentation('OKC_SAE_PVT');
879: okc_debug.log('3200: Entered validate_name', 2);
880: END IF;
881:
882: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
883: --check not null

Line 905: okc_debug.log('3300: Leaving validate_name', 2);

901: RAISE G_EXCEPTION_HALT_VALIDATION;
902: END IF;
903:
904: IF (l_debug = 'Y') THEN
905: okc_debug.log('3300: Leaving validate_name', 2);
906: okc_debug.Reset_Indentation;
907: END IF;
908:
909: EXCEPTION

Line 906: okc_debug.Reset_Indentation;

902: END IF;
903:
904: IF (l_debug = 'Y') THEN
905: okc_debug.log('3300: Leaving validate_name', 2);
906: okc_debug.Reset_Indentation;
907: END IF;
908:
909: EXCEPTION
910: When G_EXCEPTION_HALT_VALIDATION then

Line 913: okc_debug.log('3400: Exiting validate_name:G_EXCEPTION_HALT_VALIDATION Exception', 2);

909: EXCEPTION
910: When G_EXCEPTION_HALT_VALIDATION then
911:
912: IF (l_debug = 'Y') THEN
913: okc_debug.log('3400: Exiting validate_name:G_EXCEPTION_HALT_VALIDATION Exception', 2);
914: okc_debug.Reset_Indentation;
915: END IF;
916:
917: --just come out with return status

Line 914: okc_debug.Reset_Indentation;

910: When G_EXCEPTION_HALT_VALIDATION then
911:
912: IF (l_debug = 'Y') THEN
913: okc_debug.log('3400: Exiting validate_name:G_EXCEPTION_HALT_VALIDATION Exception', 2);
914: okc_debug.Reset_Indentation;
915: END IF;
916:
917: --just come out with return status
918: null;

Line 923: okc_debug.log('3500: Exiting validate_name:others Exception', 2);

919: -- other appropriate handlers
920: When others then
921:
922: IF (l_debug = 'Y') THEN
923: okc_debug.log('3500: Exiting validate_name:others Exception', 2);
924: okc_debug.Reset_Indentation;
925: END IF;
926:
927: -- store SQL error message on message stack

Line 924: okc_debug.Reset_Indentation;

920: When others then
921:
922: IF (l_debug = 'Y') THEN
923: okc_debug.log('3500: Exiting validate_name:others Exception', 2);
924: okc_debug.Reset_Indentation;
925: END IF;
926:
927: -- store SQL error message on message stack
928: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 954: okc_debug.Set_Indentation('OKC_SAE_PVT');

950: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
951: BEGIN
952:
953: IF (l_debug = 'Y') THEN
954: okc_debug.Set_Indentation('OKC_SAE_PVT');
955: okc_debug.log('3600: Entered Validate_Attributes', 2);
956: END IF;
957:
958: validate_id(p_saev_rec,l_return_status);

Line 955: okc_debug.log('3600: Entered Validate_Attributes', 2);

951: BEGIN
952:
953: IF (l_debug = 'Y') THEN
954: okc_debug.Set_Indentation('OKC_SAE_PVT');
955: okc_debug.log('3600: Entered Validate_Attributes', 2);
956: END IF;
957:
958: validate_id(p_saev_rec,l_return_status);
959: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1009: okc_debug.log('3700: Leaving Validate_Attributes', 2);

1005: END IF;
1006: END IF;
1007:
1008: IF (l_debug = 'Y') THEN
1009: okc_debug.log('3700: Leaving Validate_Attributes', 2);
1010: okc_debug.Reset_Indentation;
1011: END IF;
1012:
1013: RETURN(l_return_status);

Line 1010: okc_debug.Reset_Indentation;

1006: END IF;
1007:
1008: IF (l_debug = 'Y') THEN
1009: okc_debug.log('3700: Leaving Validate_Attributes', 2);
1010: okc_debug.Reset_Indentation;
1011: END IF;
1012:
1013: RETURN(l_return_status);
1014:

Line 1019: okc_debug.log('3800: Exiting Validate_Attributes:G_EXCEPTION_HALT_VALIDATION Exception', 2);

1015: EXCEPTION
1016: When G_EXCEPTION_HALT_VALIDATION then
1017:
1018: IF (l_debug = 'Y') THEN
1019: okc_debug.log('3800: Exiting Validate_Attributes:G_EXCEPTION_HALT_VALIDATION Exception', 2);
1020: okc_debug.Reset_Indentation;
1021: END IF;
1022:
1023: --just come out with return status

Line 1020: okc_debug.Reset_Indentation;

1016: When G_EXCEPTION_HALT_VALIDATION then
1017:
1018: IF (l_debug = 'Y') THEN
1019: okc_debug.log('3800: Exiting Validate_Attributes:G_EXCEPTION_HALT_VALIDATION Exception', 2);
1020: okc_debug.Reset_Indentation;
1021: END IF;
1022:
1023: --just come out with return status
1024: RETURN(l_return_status);

Line 1029: okc_debug.log('3900: Exiting Validate_Attributes:others Exception', 2);

1025: -- other appropriate handlers
1026: When others then
1027:
1028: IF (l_debug = 'Y') THEN
1029: okc_debug.log('3900: Exiting Validate_Attributes:others Exception', 2);
1030: okc_debug.Reset_Indentation;
1031: END IF;
1032:
1033: -- store SQL error message on message stack

Line 1030: okc_debug.Reset_Indentation;

1026: When others then
1027:
1028: IF (l_debug = 'Y') THEN
1029: okc_debug.log('3900: Exiting Validate_Attributes:others Exception', 2);
1030: okc_debug.Reset_Indentation;
1031: END IF;
1032:
1033: -- store SQL error message on message stack
1034: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 1190: okc_debug.Set_Indentation('OKC_SAE_PVT');

1186: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
1187: BEGIN
1188:
1189: IF (l_debug = 'Y') THEN
1190: okc_debug.Set_Indentation('OKC_SAE_PVT');
1191: okc_debug.log('4500: Entered validate_row', 2);
1192: END IF;
1193:
1194: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1191: okc_debug.log('4500: Entered validate_row', 2);

1187: BEGIN
1188:
1189: IF (l_debug = 'Y') THEN
1190: okc_debug.Set_Indentation('OKC_SAE_PVT');
1191: okc_debug.log('4500: Entered validate_row', 2);
1192: END IF;
1193:
1194: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1195: G_PKG_NAME,

Line 1223: okc_debug.log('4600: Leaving validate_row', 2);

1219: END IF;
1220: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1221:
1222: IF (l_debug = 'Y') THEN
1223: okc_debug.log('4600: Leaving validate_row', 2);
1224: okc_debug.Reset_Indentation;
1225: END IF;
1226:
1227: EXCEPTION

Line 1224: okc_debug.Reset_Indentation;

1220: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1221:
1222: IF (l_debug = 'Y') THEN
1223: okc_debug.log('4600: Leaving validate_row', 2);
1224: okc_debug.Reset_Indentation;
1225: END IF;
1226:
1227: EXCEPTION
1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1231: okc_debug.log('4700: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1227: EXCEPTION
1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1229:
1230: IF (l_debug = 'Y') THEN
1231: okc_debug.log('4700: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1232: okc_debug.Reset_Indentation;
1233: END IF;
1234:
1235: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1232: okc_debug.Reset_Indentation;

1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1229:
1230: IF (l_debug = 'Y') THEN
1231: okc_debug.log('4700: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1232: okc_debug.Reset_Indentation;
1233: END IF;
1234:
1235: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1236: (

Line 1247: okc_debug.log('4800: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1243: );
1244: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1245:
1246: IF (l_debug = 'Y') THEN
1247: okc_debug.log('4800: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1248: okc_debug.Reset_Indentation;
1249: END IF;
1250:
1251: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1248: okc_debug.Reset_Indentation;

1244: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1245:
1246: IF (l_debug = 'Y') THEN
1247: okc_debug.log('4800: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1248: okc_debug.Reset_Indentation;
1249: END IF;
1250:
1251: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1252: (

Line 1263: okc_debug.log('4900: Exiting validate_row:OTHERS Exception', 2);

1259: );
1260: WHEN OTHERS THEN
1261:
1262: IF (l_debug = 'Y') THEN
1263: okc_debug.log('4900: Exiting validate_row:OTHERS Exception', 2);
1264: okc_debug.Reset_Indentation;
1265: END IF;
1266:
1267: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1264: okc_debug.Reset_Indentation;

1260: WHEN OTHERS THEN
1261:
1262: IF (l_debug = 'Y') THEN
1263: okc_debug.log('4900: Exiting validate_row:OTHERS Exception', 2);
1264: okc_debug.Reset_Indentation;
1265: END IF;
1266:
1267: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1268: (

Line 1296: okc_debug.Set_Indentation('OKC_SAE_PVT');

1292: i NUMBER := 0;
1293: BEGIN
1294:
1295: IF (l_debug = 'Y') THEN
1296: okc_debug.Set_Indentation('OKC_SAE_PVT');
1297: okc_debug.log('5000: Entered validate_row', 2);
1298: END IF;
1299:
1300: -- Make sure PL/SQL table has records in it before passing

Line 1297: okc_debug.log('5000: Entered validate_row', 2);

1293: BEGIN
1294:
1295: IF (l_debug = 'Y') THEN
1296: okc_debug.Set_Indentation('OKC_SAE_PVT');
1297: okc_debug.log('5000: Entered validate_row', 2);
1298: END IF;
1299:
1300: -- Make sure PL/SQL table has records in it before passing
1301: IF (p_saev_tbl.COUNT > 0) THEN

Line 1317: okc_debug.log('5100: Leaving validate_row', 2);

1313: END LOOP;
1314: END IF;
1315:
1316: IF (l_debug = 'Y') THEN
1317: okc_debug.log('5100: Leaving validate_row', 2);
1318: okc_debug.Reset_Indentation;
1319: END IF;
1320:
1321: EXCEPTION

Line 1318: okc_debug.Reset_Indentation;

1314: END IF;
1315:
1316: IF (l_debug = 'Y') THEN
1317: okc_debug.log('5100: Leaving validate_row', 2);
1318: okc_debug.Reset_Indentation;
1319: END IF;
1320:
1321: EXCEPTION
1322: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1325: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1321: EXCEPTION
1322: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1323:
1324: IF (l_debug = 'Y') THEN
1325: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1326: okc_debug.Reset_Indentation;
1327: END IF;
1328:
1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1326: okc_debug.Reset_Indentation;

1322: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1323:
1324: IF (l_debug = 'Y') THEN
1325: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1326: okc_debug.Reset_Indentation;
1327: END IF;
1328:
1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1330: (

Line 1341: okc_debug.log('5300: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1337: );
1338: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1339:
1340: IF (l_debug = 'Y') THEN
1341: okc_debug.log('5300: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1342: okc_debug.Reset_Indentation;
1343: END IF;
1344:
1345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1342: okc_debug.Reset_Indentation;

1338: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1339:
1340: IF (l_debug = 'Y') THEN
1341: okc_debug.log('5300: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1342: okc_debug.Reset_Indentation;
1343: END IF;
1344:
1345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1346: (

Line 1357: okc_debug.log('5400: Exiting validate_row:OTHERS Exception', 2);

1353: );
1354: WHEN OTHERS THEN
1355:
1356: IF (l_debug = 'Y') THEN
1357: okc_debug.log('5400: Exiting validate_row:OTHERS Exception', 2);
1358: okc_debug.Reset_Indentation;
1359: END IF;
1360:
1361: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1358: okc_debug.Reset_Indentation;

1354: WHEN OTHERS THEN
1355:
1356: IF (l_debug = 'Y') THEN
1357: okc_debug.log('5400: Exiting validate_row:OTHERS Exception', 2);
1358: okc_debug.Reset_Indentation;
1359: END IF;
1360:
1361: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1362: (

Line 1409: okc_debug.Set_Indentation('OKC_SAE_PVT');

1405: END Set_Attributes;
1406: BEGIN
1407:
1408: IF (l_debug = 'Y') THEN
1409: okc_debug.Set_Indentation('OKC_SAE_PVT');
1410: okc_debug.log('5600: Entered insert_row', 2);
1411: END IF;
1412:
1413: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1410: okc_debug.log('5600: Entered insert_row', 2);

1406: BEGIN
1407:
1408: IF (l_debug = 'Y') THEN
1409: okc_debug.Set_Indentation('OKC_SAE_PVT');
1410: okc_debug.log('5600: Entered insert_row', 2);
1411: END IF;
1412:
1413: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1414: p_init_msg_list,

Line 1487: okc_debug.log('5700: Leaving insert_row', 2);

1483: x_sae_rec := l_sae_rec;
1484: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1485:
1486: IF (l_debug = 'Y') THEN
1487: okc_debug.log('5700: Leaving insert_row', 2);
1488: okc_debug.Reset_Indentation;
1489: END IF;
1490:
1491: EXCEPTION

Line 1488: okc_debug.Reset_Indentation;

1484: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1485:
1486: IF (l_debug = 'Y') THEN
1487: okc_debug.log('5700: Leaving insert_row', 2);
1488: okc_debug.Reset_Indentation;
1489: END IF;
1490:
1491: EXCEPTION
1492: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1495: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1491: EXCEPTION
1492: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1493:
1494: IF (l_debug = 'Y') THEN
1495: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1496: okc_debug.Reset_Indentation;
1497: END IF;
1498:
1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1496: okc_debug.Reset_Indentation;

1492: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1493:
1494: IF (l_debug = 'Y') THEN
1495: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1496: okc_debug.Reset_Indentation;
1497: END IF;
1498:
1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1500: (

Line 1511: okc_debug.log('5900: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1507: );
1508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1509:
1510: IF (l_debug = 'Y') THEN
1511: okc_debug.log('5900: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1512: okc_debug.Reset_Indentation;
1513: END IF;
1514:
1515: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1512: okc_debug.Reset_Indentation;

1508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1509:
1510: IF (l_debug = 'Y') THEN
1511: okc_debug.log('5900: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1512: okc_debug.Reset_Indentation;
1513: END IF;
1514:
1515: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1516: (

Line 1527: okc_debug.log('6000: Exiting insert_row:OTHERS Exception', 2);

1523: );
1524: WHEN OTHERS THEN
1525:
1526: IF (l_debug = 'Y') THEN
1527: okc_debug.log('6000: Exiting insert_row:OTHERS Exception', 2);
1528: okc_debug.Reset_Indentation;
1529: END IF;
1530:
1531: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1528: okc_debug.Reset_Indentation;

1524: WHEN OTHERS THEN
1525:
1526: IF (l_debug = 'Y') THEN
1527: okc_debug.log('6000: Exiting insert_row:OTHERS Exception', 2);
1528: okc_debug.Reset_Indentation;
1529: END IF;
1530:
1531: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1532: (

Line 1583: okc_debug.Set_Indentation('OKC_SAE_PVT');

1579: END Set_Attributes;
1580: BEGIN
1581:
1582: IF (l_debug = 'Y') THEN
1583: okc_debug.Set_Indentation('OKC_SAE_PVT');
1584: okc_debug.log('6200: Entered insert_row', 2);
1585: END IF;
1586:
1587: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1584: okc_debug.log('6200: Entered insert_row', 2);

1580: BEGIN
1581:
1582: IF (l_debug = 'Y') THEN
1583: okc_debug.Set_Indentation('OKC_SAE_PVT');
1584: okc_debug.log('6200: Entered insert_row', 2);
1585: END IF;
1586:
1587: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1588: p_init_msg_list,

Line 1636: okc_debug.log('6300: Leaving insert_row', 2);

1632: x_okc_std_articles_tl_rec := l_okc_std_articles_tl_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1634:
1635: IF (l_debug = 'Y') THEN
1636: okc_debug.log('6300: Leaving insert_row', 2);
1637: okc_debug.Reset_Indentation;
1638: END IF;
1639:
1640: EXCEPTION

Line 1637: okc_debug.Reset_Indentation;

1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1634:
1635: IF (l_debug = 'Y') THEN
1636: okc_debug.log('6300: Leaving insert_row', 2);
1637: okc_debug.Reset_Indentation;
1638: END IF;
1639:
1640: EXCEPTION
1641: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1644: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1640: EXCEPTION
1641: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1642:
1643: IF (l_debug = 'Y') THEN
1644: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1645: okc_debug.Reset_Indentation;
1646: END IF;
1647:
1648: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1645: okc_debug.Reset_Indentation;

1641: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1642:
1643: IF (l_debug = 'Y') THEN
1644: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1645: okc_debug.Reset_Indentation;
1646: END IF;
1647:
1648: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1649: (

Line 1660: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1656: );
1657: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1658:
1659: IF (l_debug = 'Y') THEN
1660: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1661: okc_debug.Reset_Indentation;
1662: END IF;
1663:
1664: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1661: okc_debug.Reset_Indentation;

1657: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1658:
1659: IF (l_debug = 'Y') THEN
1660: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1661: okc_debug.Reset_Indentation;
1662: END IF;
1663:
1664: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1665: (

Line 1676: okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);

1672: );
1673: WHEN OTHERS THEN
1674:
1675: IF (l_debug = 'Y') THEN
1676: okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);
1677: okc_debug.Reset_Indentation;
1678: END IF;
1679:
1680: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1677: okc_debug.Reset_Indentation;

1673: WHEN OTHERS THEN
1674:
1675: IF (l_debug = 'Y') THEN
1676: okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);
1677: okc_debug.Reset_Indentation;
1678: END IF;
1679:
1680: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1681: (

Line 1755: okc_debug.Set_Indentation('OKC_SAE_PVT');

1751: END Set_Attributes;
1752: BEGIN
1753:
1754: IF (l_debug = 'Y') THEN
1755: okc_debug.Set_Indentation('OKC_SAE_PVT');
1756: okc_debug.log('6900: Entered insert_row', 2);
1757: END IF;
1758:
1759: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1756: okc_debug.log('6900: Entered insert_row', 2);

1752: BEGIN
1753:
1754: IF (l_debug = 'Y') THEN
1755: okc_debug.Set_Indentation('OKC_SAE_PVT');
1756: okc_debug.log('6900: Entered insert_row', 2);
1757: END IF;
1758:
1759: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1760: G_PKG_NAME,

Line 1841: okc_debug.log('7000: Leaving insert_row', 2);

1837: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1838:
1839:
1840: IF (l_debug = 'Y') THEN
1841: okc_debug.log('7000: Leaving insert_row', 2);
1842: okc_debug.Reset_Indentation;
1843: END IF;
1844:
1845: EXCEPTION

Line 1842: okc_debug.Reset_Indentation;

1838:
1839:
1840: IF (l_debug = 'Y') THEN
1841: okc_debug.log('7000: Leaving insert_row', 2);
1842: okc_debug.Reset_Indentation;
1843: END IF;
1844:
1845: EXCEPTION
1846: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1849: okc_debug.log('7100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1845: EXCEPTION
1846: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1847:
1848: IF (l_debug = 'Y') THEN
1849: okc_debug.log('7100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1850: okc_debug.Reset_Indentation;
1851: END IF;
1852:
1853: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1850: okc_debug.Reset_Indentation;

1846: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1847:
1848: IF (l_debug = 'Y') THEN
1849: okc_debug.log('7100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1850: okc_debug.Reset_Indentation;
1851: END IF;
1852:
1853: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1854: (

Line 1865: okc_debug.log('7200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1861: );
1862: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1863:
1864: IF (l_debug = 'Y') THEN
1865: okc_debug.log('7200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1866: okc_debug.Reset_Indentation;
1867: END IF;
1868:
1869: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1866: okc_debug.Reset_Indentation;

1862: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1863:
1864: IF (l_debug = 'Y') THEN
1865: okc_debug.log('7200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1866: okc_debug.Reset_Indentation;
1867: END IF;
1868:
1869: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1870: (

Line 1881: okc_debug.log('7300: Exiting insert_row:OTHERS Exception', 2);

1877: );
1878: WHEN OTHERS THEN
1879:
1880: IF (l_debug = 'Y') THEN
1881: okc_debug.log('7300: Exiting insert_row:OTHERS Exception', 2);
1882: okc_debug.Reset_Indentation;
1883: END IF;
1884:
1885: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1882: okc_debug.Reset_Indentation;

1878: WHEN OTHERS THEN
1879:
1880: IF (l_debug = 'Y') THEN
1881: okc_debug.log('7300: Exiting insert_row:OTHERS Exception', 2);
1882: okc_debug.Reset_Indentation;
1883: END IF;
1884:
1885: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1886: (

Line 1915: okc_debug.Set_Indentation('OKC_SAE_PVT');

1911: i NUMBER := 0;
1912: BEGIN
1913:
1914: IF (l_debug = 'Y') THEN
1915: okc_debug.Set_Indentation('OKC_SAE_PVT');
1916: okc_debug.log('7400: Entered insert_row', 2);
1917: END IF;
1918:
1919: -- Make sure PL/SQL table has records in it before passing

Line 1916: okc_debug.log('7400: Entered insert_row', 2);

1912: BEGIN
1913:
1914: IF (l_debug = 'Y') THEN
1915: okc_debug.Set_Indentation('OKC_SAE_PVT');
1916: okc_debug.log('7400: Entered insert_row', 2);
1917: END IF;
1918:
1919: -- Make sure PL/SQL table has records in it before passing
1920: IF (p_saev_tbl.COUNT > 0) THEN

Line 1937: okc_debug.log('7500: Leaving insert_row', 2);

1933: END LOOP;
1934: END IF;
1935:
1936: IF (l_debug = 'Y') THEN
1937: okc_debug.log('7500: Leaving insert_row', 2);
1938: okc_debug.Reset_Indentation;
1939: END IF;
1940:
1941: EXCEPTION

Line 1938: okc_debug.Reset_Indentation;

1934: END IF;
1935:
1936: IF (l_debug = 'Y') THEN
1937: okc_debug.log('7500: Leaving insert_row', 2);
1938: okc_debug.Reset_Indentation;
1939: END IF;
1940:
1941: EXCEPTION
1942: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1945: okc_debug.log('7600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

1941: EXCEPTION
1942: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1943:
1944: IF (l_debug = 'Y') THEN
1945: okc_debug.log('7600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1946: okc_debug.Reset_Indentation;
1947: END IF;
1948:
1949: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1946: okc_debug.Reset_Indentation;

1942: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1943:
1944: IF (l_debug = 'Y') THEN
1945: okc_debug.log('7600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1946: okc_debug.Reset_Indentation;
1947: END IF;
1948:
1949: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1950: (

Line 1961: okc_debug.log('7700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1957: );
1958: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1959:
1960: IF (l_debug = 'Y') THEN
1961: okc_debug.log('7700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1962: okc_debug.Reset_Indentation;
1963: END IF;
1964:
1965: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1962: okc_debug.Reset_Indentation;

1958: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1959:
1960: IF (l_debug = 'Y') THEN
1961: okc_debug.log('7700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1962: okc_debug.Reset_Indentation;
1963: END IF;
1964:
1965: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1966: (

Line 1977: okc_debug.log('7800: Exiting insert_row:OTHERS Exception', 2);

1973: );
1974: WHEN OTHERS THEN
1975:
1976: IF (l_debug = 'Y') THEN
1977: okc_debug.log('7800: Exiting insert_row:OTHERS Exception', 2);
1978: okc_debug.Reset_Indentation;
1979: END IF;
1980:
1981: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1978: okc_debug.Reset_Indentation;

1974: WHEN OTHERS THEN
1975:
1976: IF (l_debug = 'Y') THEN
1977: okc_debug.log('7800: Exiting insert_row:OTHERS Exception', 2);
1978: okc_debug.Reset_Indentation;
1979: END IF;
1980:
1981: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1982: (

Line 2029: okc_debug.Set_Indentation('OKC_SAE_PVT');

2025: lc_row_notfound BOOLEAN := FALSE;
2026: BEGIN
2027:
2028: IF (l_debug = 'Y') THEN
2029: okc_debug.Set_Indentation('OKC_SAE_PVT');
2030: okc_debug.log('7900: Entered lock_row', 2);
2031: END IF;
2032:
2033: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2030: okc_debug.log('7900: Entered lock_row', 2);

2026: BEGIN
2027:
2028: IF (l_debug = 'Y') THEN
2029: okc_debug.Set_Indentation('OKC_SAE_PVT');
2030: okc_debug.log('7900: Entered lock_row', 2);
2031: END IF;
2032:
2033: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2034: p_init_msg_list,

Line 2045: okc_debug.Set_Indentation('OKC_SAE_PVT');

2041: END IF;
2042: BEGIN
2043:
2044: IF (l_debug = 'Y') THEN
2045: okc_debug.Set_Indentation('OKC_SAE_PVT');
2046: okc_debug.log('8000: Entered lock_row', 2);
2047: END IF;
2048:
2049: OPEN lock_csr(p_sae_rec);

Line 2046: okc_debug.log('8000: Entered lock_row', 2);

2042: BEGIN
2043:
2044: IF (l_debug = 'Y') THEN
2045: okc_debug.Set_Indentation('OKC_SAE_PVT');
2046: okc_debug.log('8000: Entered lock_row', 2);
2047: END IF;
2048:
2049: OPEN lock_csr(p_sae_rec);
2050: FETCH lock_csr INTO l_object_version_number;

Line 2055: okc_debug.log('8100: Leaving lock_row', 2);

2051: l_row_notfound := lock_csr%NOTFOUND;
2052: CLOSE lock_csr;
2053:
2054: IF (l_debug = 'Y') THEN
2055: okc_debug.log('8100: Leaving lock_row', 2);
2056: okc_debug.Reset_Indentation;
2057: END IF;
2058:
2059: EXCEPTION

Line 2056: okc_debug.Reset_Indentation;

2052: CLOSE lock_csr;
2053:
2054: IF (l_debug = 'Y') THEN
2055: okc_debug.log('8100: Leaving lock_row', 2);
2056: okc_debug.Reset_Indentation;
2057: END IF;
2058:
2059: EXCEPTION
2060: WHEN E_Resource_Busy THEN

Line 2063: okc_debug.log('8200: Exiting lock_row:E_Resource_Busy Exception', 2);

2059: EXCEPTION
2060: WHEN E_Resource_Busy THEN
2061:
2062: IF (l_debug = 'Y') THEN
2063: okc_debug.log('8200: Exiting lock_row:E_Resource_Busy Exception', 2);
2064: okc_debug.Reset_Indentation;
2065: END IF;
2066:
2067: IF (lock_csr%ISOPEN) THEN

Line 2064: okc_debug.Reset_Indentation;

2060: WHEN E_Resource_Busy THEN
2061:
2062: IF (l_debug = 'Y') THEN
2063: okc_debug.log('8200: Exiting lock_row:E_Resource_Busy Exception', 2);
2064: okc_debug.Reset_Indentation;
2065: END IF;
2066:
2067: IF (lock_csr%ISOPEN) THEN
2068: CLOSE lock_csr;

Line 2096: okc_debug.log('8300: Leaving lock_row', 2);

2092: END IF;
2093: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2094:
2095: IF (l_debug = 'Y') THEN
2096: okc_debug.log('8300: Leaving lock_row', 2);
2097: okc_debug.Reset_Indentation;
2098: END IF;
2099:
2100: EXCEPTION

Line 2097: okc_debug.Reset_Indentation;

2093: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2094:
2095: IF (l_debug = 'Y') THEN
2096: okc_debug.log('8300: Leaving lock_row', 2);
2097: okc_debug.Reset_Indentation;
2098: END IF;
2099:
2100: EXCEPTION
2101: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2104: okc_debug.log('8400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2100: EXCEPTION
2101: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2102:
2103: IF (l_debug = 'Y') THEN
2104: okc_debug.log('8400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2105: okc_debug.Reset_Indentation;
2106: END IF;
2107:
2108: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2105: okc_debug.Reset_Indentation;

2101: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2102:
2103: IF (l_debug = 'Y') THEN
2104: okc_debug.log('8400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2105: okc_debug.Reset_Indentation;
2106: END IF;
2107:
2108: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2109: (

Line 2120: okc_debug.log('8500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2116: );
2117: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2118:
2119: IF (l_debug = 'Y') THEN
2120: okc_debug.log('8500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2121: okc_debug.Reset_Indentation;
2122: END IF;
2123:
2124: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2121: okc_debug.Reset_Indentation;

2117: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2118:
2119: IF (l_debug = 'Y') THEN
2120: okc_debug.log('8500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2121: okc_debug.Reset_Indentation;
2122: END IF;
2123:
2124: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2125: (

Line 2136: okc_debug.log('8600: Exiting lock_row:OTHERS Exception', 2);

2132: );
2133: WHEN OTHERS THEN
2134:
2135: IF (l_debug = 'Y') THEN
2136: okc_debug.log('8600: Exiting lock_row:OTHERS Exception', 2);
2137: okc_debug.Reset_Indentation;
2138: END IF;
2139:
2140: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2137: okc_debug.Reset_Indentation;

2133: WHEN OTHERS THEN
2134:
2135: IF (l_debug = 'Y') THEN
2136: okc_debug.log('8600: Exiting lock_row:OTHERS Exception', 2);
2137: okc_debug.Reset_Indentation;
2138: END IF;
2139:
2140: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2141: (

Line 2178: okc_debug.Set_Indentation('OKC_SAE_PVT');

2174: lc_row_notfound BOOLEAN := FALSE;
2175: BEGIN
2176:
2177: IF (l_debug = 'Y') THEN
2178: okc_debug.Set_Indentation('OKC_SAE_PVT');
2179: okc_debug.log('8700: Entered lock_row', 2);
2180: END IF;
2181:
2182: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2179: okc_debug.log('8700: Entered lock_row', 2);

2175: BEGIN
2176:
2177: IF (l_debug = 'Y') THEN
2178: okc_debug.Set_Indentation('OKC_SAE_PVT');
2179: okc_debug.log('8700: Entered lock_row', 2);
2180: END IF;
2181:
2182: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2183: p_init_msg_list,

Line 2194: okc_debug.Set_Indentation('OKC_SAE_PVT');

2190: END IF;
2191: BEGIN
2192:
2193: IF (l_debug = 'Y') THEN
2194: okc_debug.Set_Indentation('OKC_SAE_PVT');
2195: okc_debug.log('8800: Entered lock_row', 2);
2196: END IF;
2197:
2198: OPEN lock_csr(p_okc_std_articles_tl_rec);

Line 2195: okc_debug.log('8800: Entered lock_row', 2);

2191: BEGIN
2192:
2193: IF (l_debug = 'Y') THEN
2194: okc_debug.Set_Indentation('OKC_SAE_PVT');
2195: okc_debug.log('8800: Entered lock_row', 2);
2196: END IF;
2197:
2198: OPEN lock_csr(p_okc_std_articles_tl_rec);
2199: FETCH lock_csr INTO l_lock_var;

Line 2204: okc_debug.log('8900: Leaving lock_row', 2);

2200: l_row_notfound := lock_csr%NOTFOUND;
2201: CLOSE lock_csr;
2202:
2203: IF (l_debug = 'Y') THEN
2204: okc_debug.log('8900: Leaving lock_row', 2);
2205: okc_debug.Reset_Indentation;
2206: END IF;
2207:
2208: EXCEPTION

Line 2205: okc_debug.Reset_Indentation;

2201: CLOSE lock_csr;
2202:
2203: IF (l_debug = 'Y') THEN
2204: okc_debug.log('8900: Leaving lock_row', 2);
2205: okc_debug.Reset_Indentation;
2206: END IF;
2207:
2208: EXCEPTION
2209: WHEN E_Resource_Busy THEN

Line 2212: okc_debug.log('9000: Exiting lock_row:E_Resource_Busy Exception', 2);

2208: EXCEPTION
2209: WHEN E_Resource_Busy THEN
2210:
2211: IF (l_debug = 'Y') THEN
2212: okc_debug.log('9000: Exiting lock_row:E_Resource_Busy Exception', 2);
2213: okc_debug.Reset_Indentation;
2214: END IF;
2215:
2216: IF (lock_csr%ISOPEN) THEN

Line 2213: okc_debug.Reset_Indentation;

2209: WHEN E_Resource_Busy THEN
2210:
2211: IF (l_debug = 'Y') THEN
2212: okc_debug.log('9000: Exiting lock_row:E_Resource_Busy Exception', 2);
2213: okc_debug.Reset_Indentation;
2214: END IF;
2215:
2216: IF (lock_csr%ISOPEN) THEN
2217: CLOSE lock_csr;

Line 2230: okc_debug.log('9100: Leaving lock_row', 2);

2226: END IF;
2227: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2228:
2229: IF (l_debug = 'Y') THEN
2230: okc_debug.log('9100: Leaving lock_row', 2);
2231: okc_debug.Reset_Indentation;
2232: END IF;
2233:
2234: EXCEPTION

Line 2231: okc_debug.Reset_Indentation;

2227: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2228:
2229: IF (l_debug = 'Y') THEN
2230: okc_debug.log('9100: Leaving lock_row', 2);
2231: okc_debug.Reset_Indentation;
2232: END IF;
2233:
2234: EXCEPTION
2235: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2238: okc_debug.log('9200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2234: EXCEPTION
2235: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2236:
2237: IF (l_debug = 'Y') THEN
2238: okc_debug.log('9200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2239: okc_debug.Reset_Indentation;
2240: END IF;
2241:
2242: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2239: okc_debug.Reset_Indentation;

2235: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2236:
2237: IF (l_debug = 'Y') THEN
2238: okc_debug.log('9200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2239: okc_debug.Reset_Indentation;
2240: END IF;
2241:
2242: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2243: (

Line 2254: okc_debug.log('9300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2250: );
2251: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2252:
2253: IF (l_debug = 'Y') THEN
2254: okc_debug.log('9300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2255: okc_debug.Reset_Indentation;
2256: END IF;
2257:
2258: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2255: okc_debug.Reset_Indentation;

2251: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2252:
2253: IF (l_debug = 'Y') THEN
2254: okc_debug.log('9300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2255: okc_debug.Reset_Indentation;
2256: END IF;
2257:
2258: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2259: (

Line 2270: okc_debug.log('9400: Exiting lock_row:OTHERS Exception', 2);

2266: );
2267: WHEN OTHERS THEN
2268:
2269: IF (l_debug = 'Y') THEN
2270: okc_debug.log('9400: Exiting lock_row:OTHERS Exception', 2);
2271: okc_debug.Reset_Indentation;
2272: END IF;
2273:
2274: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2271: okc_debug.Reset_Indentation;

2267: WHEN OTHERS THEN
2268:
2269: IF (l_debug = 'Y') THEN
2270: okc_debug.log('9400: Exiting lock_row:OTHERS Exception', 2);
2271: okc_debug.Reset_Indentation;
2272: END IF;
2273:
2274: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2275: (

Line 2304: okc_debug.Set_Indentation('OKC_SAE_PVT');

2300: l_okc_std_articles_tl_rec okc_std_articles_tl_rec_type;
2301: BEGIN
2302:
2303: IF (l_debug = 'Y') THEN
2304: okc_debug.Set_Indentation('OKC_SAE_PVT');
2305: okc_debug.log('9500: Entered lock_row', 2);
2306: END IF;
2307:
2308: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2305: okc_debug.log('9500: Entered lock_row', 2);

2301: BEGIN
2302:
2303: IF (l_debug = 'Y') THEN
2304: okc_debug.Set_Indentation('OKC_SAE_PVT');
2305: okc_debug.log('9500: Entered lock_row', 2);
2306: END IF;
2307:
2308: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2309: G_PKG_NAME,

Line 2355: okc_debug.log('9600: Leaving lock_row', 2);

2351: END IF;
2352: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2353:
2354: IF (l_debug = 'Y') THEN
2355: okc_debug.log('9600: Leaving lock_row', 2);
2356: okc_debug.Reset_Indentation;
2357: END IF;
2358:
2359: EXCEPTION

Line 2356: okc_debug.Reset_Indentation;

2352: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2353:
2354: IF (l_debug = 'Y') THEN
2355: okc_debug.log('9600: Leaving lock_row', 2);
2356: okc_debug.Reset_Indentation;
2357: END IF;
2358:
2359: EXCEPTION
2360: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2363: okc_debug.log('9700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2359: EXCEPTION
2360: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2361:
2362: IF (l_debug = 'Y') THEN
2363: okc_debug.log('9700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2364: okc_debug.Reset_Indentation;
2365: END IF;
2366:
2367: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2364: okc_debug.Reset_Indentation;

2360: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2361:
2362: IF (l_debug = 'Y') THEN
2363: okc_debug.log('9700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2364: okc_debug.Reset_Indentation;
2365: END IF;
2366:
2367: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2368: (

Line 2379: okc_debug.log('9800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2375: );
2376: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2377:
2378: IF (l_debug = 'Y') THEN
2379: okc_debug.log('9800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2380: okc_debug.Reset_Indentation;
2381: END IF;
2382:
2383: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2380: okc_debug.Reset_Indentation;

2376: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2377:
2378: IF (l_debug = 'Y') THEN
2379: okc_debug.log('9800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2380: okc_debug.Reset_Indentation;
2381: END IF;
2382:
2383: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2384: (

Line 2395: okc_debug.log('9900: Exiting lock_row:OTHERS Exception', 2);

2391: );
2392: WHEN OTHERS THEN
2393:
2394: IF (l_debug = 'Y') THEN
2395: okc_debug.log('9900: Exiting lock_row:OTHERS Exception', 2);
2396: okc_debug.Reset_Indentation;
2397: END IF;
2398:
2399: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2396: okc_debug.Reset_Indentation;

2392: WHEN OTHERS THEN
2393:
2394: IF (l_debug = 'Y') THEN
2395: okc_debug.log('9900: Exiting lock_row:OTHERS Exception', 2);
2396: okc_debug.Reset_Indentation;
2397: END IF;
2398:
2399: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2400: (

Line 2428: okc_debug.Set_Indentation('OKC_SAE_PVT');

2424: i NUMBER := 0;
2425: BEGIN
2426:
2427: IF (l_debug = 'Y') THEN
2428: okc_debug.Set_Indentation('OKC_SAE_PVT');
2429: okc_debug.log('10000: Entered lock_row', 2);
2430: END IF;
2431:
2432: -- Make sure PL/SQL table has records in it before passing

Line 2429: okc_debug.log('10000: Entered lock_row', 2);

2425: BEGIN
2426:
2427: IF (l_debug = 'Y') THEN
2428: okc_debug.Set_Indentation('OKC_SAE_PVT');
2429: okc_debug.log('10000: Entered lock_row', 2);
2430: END IF;
2431:
2432: -- Make sure PL/SQL table has records in it before passing
2433: IF (p_saev_tbl.COUNT > 0) THEN

Line 2449: okc_debug.log('10100: Leaving lock_row', 2);

2445: END LOOP;
2446: END IF;
2447:
2448: IF (l_debug = 'Y') THEN
2449: okc_debug.log('10100: Leaving lock_row', 2);
2450: okc_debug.Reset_Indentation;
2451: END IF;
2452:
2453: EXCEPTION

Line 2450: okc_debug.Reset_Indentation;

2446: END IF;
2447:
2448: IF (l_debug = 'Y') THEN
2449: okc_debug.log('10100: Leaving lock_row', 2);
2450: okc_debug.Reset_Indentation;
2451: END IF;
2452:
2453: EXCEPTION
2454: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2457: okc_debug.log('10200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2453: EXCEPTION
2454: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2455:
2456: IF (l_debug = 'Y') THEN
2457: okc_debug.log('10200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2458: okc_debug.Reset_Indentation;
2459: END IF;
2460:
2461: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2458: okc_debug.Reset_Indentation;

2454: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2455:
2456: IF (l_debug = 'Y') THEN
2457: okc_debug.log('10200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2458: okc_debug.Reset_Indentation;
2459: END IF;
2460:
2461: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2462: (

Line 2473: okc_debug.log('10300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2469: );
2470: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2471:
2472: IF (l_debug = 'Y') THEN
2473: okc_debug.log('10300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2474: okc_debug.Reset_Indentation;
2475: END IF;
2476:
2477: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2474: okc_debug.Reset_Indentation;

2470: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2471:
2472: IF (l_debug = 'Y') THEN
2473: okc_debug.log('10300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2474: okc_debug.Reset_Indentation;
2475: END IF;
2476:
2477: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2478: (

Line 2489: okc_debug.log('10400: Exiting lock_row:OTHERS Exception', 2);

2485: );
2486: WHEN OTHERS THEN
2487:
2488: IF (l_debug = 'Y') THEN
2489: okc_debug.log('10400: Exiting lock_row:OTHERS Exception', 2);
2490: okc_debug.Reset_Indentation;
2491: END IF;
2492:
2493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2490: okc_debug.Reset_Indentation;

2486: WHEN OTHERS THEN
2487:
2488: IF (l_debug = 'Y') THEN
2489: okc_debug.log('10400: Exiting lock_row:OTHERS Exception', 2);
2490: okc_debug.Reset_Indentation;
2491: END IF;
2492:
2493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2494: (

Line 2538: okc_debug.Set_Indentation('OKC_SAE_PVT');

2534: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2535: BEGIN
2536:
2537: IF (l_debug = 'Y') THEN
2538: okc_debug.Set_Indentation('OKC_SAE_PVT');
2539: okc_debug.log('10500: Entered populate_new_record', 2);
2540: END IF;
2541:
2542: x_sae_rec := p_sae_rec;

Line 2539: okc_debug.log('10500: Entered populate_new_record', 2);

2535: BEGIN
2536:
2537: IF (l_debug = 'Y') THEN
2538: okc_debug.Set_Indentation('OKC_SAE_PVT');
2539: okc_debug.log('10500: Entered populate_new_record', 2);
2540: END IF;
2541:
2542: x_sae_rec := p_sae_rec;
2543: -- Get current database values

Line 2646: okc_debug.log('11950: Leaving populate_new_record ', 2);

2642: x_sae_rec.attribute15 := l_sae_rec.attribute15;
2643: END IF;
2644:
2645: IF (l_debug = 'Y') THEN
2646: okc_debug.log('11950: Leaving populate_new_record ', 2);
2647: okc_debug.Reset_Indentation;
2648: END IF;
2649:
2650: RETURN(l_return_status);

Line 2647: okc_debug.Reset_Indentation;

2643: END IF;
2644:
2645: IF (l_debug = 'Y') THEN
2646: okc_debug.log('11950: Leaving populate_new_record ', 2);
2647: okc_debug.Reset_Indentation;
2648: END IF;
2649:
2650: RETURN(l_return_status);
2651:

Line 2670: okc_debug.Set_Indentation('OKC_SAE_PVT');

2666: END Set_Attributes;
2667: BEGIN
2668:
2669: IF (l_debug = 'Y') THEN
2670: okc_debug.Set_Indentation('OKC_SAE_PVT');
2671: okc_debug.log('10700: Entered update_row', 2);
2672: END IF;
2673:
2674: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2671: okc_debug.log('10700: Entered update_row', 2);

2667: BEGIN
2668:
2669: IF (l_debug = 'Y') THEN
2670: okc_debug.Set_Indentation('OKC_SAE_PVT');
2671: okc_debug.log('10700: Entered update_row', 2);
2672: END IF;
2673:
2674: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2675: p_init_msg_list,

Line 2729: okc_debug.log('10800: Leaving update_row', 2);

2725: x_sae_rec := l_def_sae_rec;
2726: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2727:
2728: IF (l_debug = 'Y') THEN
2729: okc_debug.log('10800: Leaving update_row', 2);
2730: okc_debug.Reset_Indentation;
2731: END IF;
2732:
2733: EXCEPTION

Line 2730: okc_debug.Reset_Indentation;

2726: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2727:
2728: IF (l_debug = 'Y') THEN
2729: okc_debug.log('10800: Leaving update_row', 2);
2730: okc_debug.Reset_Indentation;
2731: END IF;
2732:
2733: EXCEPTION
2734: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2737: okc_debug.log('10900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2733: EXCEPTION
2734: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2735:
2736: IF (l_debug = 'Y') THEN
2737: okc_debug.log('10900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2738: okc_debug.Reset_Indentation;
2739: END IF;
2740:
2741: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2738: okc_debug.Reset_Indentation;

2734: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2735:
2736: IF (l_debug = 'Y') THEN
2737: okc_debug.log('10900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2738: okc_debug.Reset_Indentation;
2739: END IF;
2740:
2741: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2742: (

Line 2753: okc_debug.log('11000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2749: );
2750: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2751:
2752: IF (l_debug = 'Y') THEN
2753: okc_debug.log('11000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2754: okc_debug.Reset_Indentation;
2755: END IF;
2756:
2757: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2754: okc_debug.Reset_Indentation;

2750: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2751:
2752: IF (l_debug = 'Y') THEN
2753: okc_debug.log('11000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2754: okc_debug.Reset_Indentation;
2755: END IF;
2756:
2757: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2758: (

Line 2769: okc_debug.log('11100: Exiting update_row:OTHERS Exception', 2);

2765: );
2766: WHEN OTHERS THEN
2767:
2768: IF (l_debug = 'Y') THEN
2769: okc_debug.log('11100: Exiting update_row:OTHERS Exception', 2);
2770: okc_debug.Reset_Indentation;
2771: END IF;
2772:
2773: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2770: okc_debug.Reset_Indentation;

2766: WHEN OTHERS THEN
2767:
2768: IF (l_debug = 'Y') THEN
2769: okc_debug.log('11100: Exiting update_row:OTHERS Exception', 2);
2770: okc_debug.Reset_Indentation;
2771: END IF;
2772:
2773: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2774: (

Line 2815: okc_debug.Set_Indentation('OKC_SAE_PVT');

2811: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2812: BEGIN
2813:
2814: IF (l_debug = 'Y') THEN
2815: okc_debug.Set_Indentation('OKC_SAE_PVT');
2816: okc_debug.log('11200: Entered populate_new_record', 2);
2817: END IF;
2818:
2819: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

Line 2816: okc_debug.log('11200: Entered populate_new_record', 2);

2812: BEGIN
2813:
2814: IF (l_debug = 'Y') THEN
2815: okc_debug.Set_Indentation('OKC_SAE_PVT');
2816: okc_debug.log('11200: Entered populate_new_record', 2);
2817: END IF;
2818:
2819: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
2820: -- Get current database values

Line 2867: okc_debug.log('11250: Leaving populate_new_record ', 2);

2863: x_okc_std_articles_tl_rec.last_update_login := l_okc_std_articles_tl_rec.last_update_login;
2864: END IF;
2865:
2866: IF (l_debug = 'Y') THEN
2867: okc_debug.log('11250: Leaving populate_new_record ', 2);
2868: okc_debug.Reset_Indentation;
2869: END IF;
2870:
2871: RETURN(l_return_status);

Line 2868: okc_debug.Reset_Indentation;

2864: END IF;
2865:
2866: IF (l_debug = 'Y') THEN
2867: okc_debug.log('11250: Leaving populate_new_record ', 2);
2868: okc_debug.Reset_Indentation;
2869: END IF;
2870:
2871: RETURN(l_return_status);
2872:

Line 2895: okc_debug.Set_Indentation('OKC_SAE_PVT');

2891: END Set_Attributes;
2892: BEGIN
2893:
2894: IF (l_debug = 'Y') THEN
2895: okc_debug.Set_Indentation('OKC_SAE_PVT');
2896: okc_debug.log('11400: Entered update_row', 2);
2897: END IF;
2898:
2899: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2896: okc_debug.log('11400: Entered update_row', 2);

2892: BEGIN
2893:
2894: IF (l_debug = 'Y') THEN
2895: okc_debug.Set_Indentation('OKC_SAE_PVT');
2896: okc_debug.log('11400: Entered update_row', 2);
2897: END IF;
2898:
2899: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2900: p_init_msg_list,

Line 2949: okc_debug.log('11500: Leaving update_row', 2);

2945: x_okc_std_articles_tl_rec := ldefokcstdarticlestlrec;
2946: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2947:
2948: IF (l_debug = 'Y') THEN
2949: okc_debug.log('11500: Leaving update_row', 2);
2950: okc_debug.Reset_Indentation;
2951: END IF;
2952:
2953: EXCEPTION

Line 2950: okc_debug.Reset_Indentation;

2946: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2947:
2948: IF (l_debug = 'Y') THEN
2949: okc_debug.log('11500: Leaving update_row', 2);
2950: okc_debug.Reset_Indentation;
2951: END IF;
2952:
2953: EXCEPTION
2954: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2957: okc_debug.log('11600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

2953: EXCEPTION
2954: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2955:
2956: IF (l_debug = 'Y') THEN
2957: okc_debug.log('11600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2958: okc_debug.Reset_Indentation;
2959: END IF;
2960:
2961: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2958: okc_debug.Reset_Indentation;

2954: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2955:
2956: IF (l_debug = 'Y') THEN
2957: okc_debug.log('11600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2958: okc_debug.Reset_Indentation;
2959: END IF;
2960:
2961: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2962: (

Line 2973: okc_debug.log('11700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2969: );
2970: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2971:
2972: IF (l_debug = 'Y') THEN
2973: okc_debug.log('11700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2974: okc_debug.Reset_Indentation;
2975: END IF;
2976:
2977: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2974: okc_debug.Reset_Indentation;

2970: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2971:
2972: IF (l_debug = 'Y') THEN
2973: okc_debug.log('11700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2974: okc_debug.Reset_Indentation;
2975: END IF;
2976:
2977: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2978: (

Line 2989: okc_debug.log('11800: Exiting update_row:OTHERS Exception', 2);

2985: );
2986: WHEN OTHERS THEN
2987:
2988: IF (l_debug = 'Y') THEN
2989: okc_debug.log('11800: Exiting update_row:OTHERS Exception', 2);
2990: okc_debug.Reset_Indentation;
2991: END IF;
2992:
2993: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2990: okc_debug.Reset_Indentation;

2986: WHEN OTHERS THEN
2987:
2988: IF (l_debug = 'Y') THEN
2989: okc_debug.log('11800: Exiting update_row:OTHERS Exception', 2);
2990: okc_debug.Reset_Indentation;
2991: END IF;
2992:
2993: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2994: (

Line 3053: okc_debug.Set_Indentation('OKC_SAE_PVT');

3049: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3050: BEGIN
3051:
3052: IF (l_debug = 'Y') THEN
3053: okc_debug.Set_Indentation('OKC_SAE_PVT');
3054: okc_debug.log('12000: Entered populate_new_record', 2);
3055: END IF;
3056:
3057: x_saev_rec := p_saev_rec;

Line 3054: okc_debug.log('12000: Entered populate_new_record', 2);

3050: BEGIN
3051:
3052: IF (l_debug = 'Y') THEN
3053: okc_debug.Set_Indentation('OKC_SAE_PVT');
3054: okc_debug.log('12000: Entered populate_new_record', 2);
3055: END IF;
3056:
3057: x_saev_rec := p_saev_rec;
3058: -- Get current database values

Line 3169: okc_debug.log('12100: Leaving populate_new_record ', 2);

3165: x_saev_rec.last_update_login := l_saev_rec.last_update_login;
3166: END IF;
3167:
3168: IF (l_debug = 'Y') THEN
3169: okc_debug.log('12100: Leaving populate_new_record ', 2);
3170: okc_debug.Reset_Indentation;
3171: END IF;
3172:
3173: RETURN(l_return_status);

Line 3170: okc_debug.Reset_Indentation;

3166: END IF;
3167:
3168: IF (l_debug = 'Y') THEN
3169: okc_debug.log('12100: Leaving populate_new_record ', 2);
3170: okc_debug.Reset_Indentation;
3171: END IF;
3172:
3173: RETURN(l_return_status);
3174:

Line 3200: okc_debug.Set_Indentation('OKC_SAE_PVT');

3196: END Set_Attributes;
3197: BEGIN
3198:
3199: IF (l_debug = 'Y') THEN
3200: okc_debug.Set_Indentation('OKC_SAE_PVT');
3201: okc_debug.log('12200: Entered update_row', 2);
3202: END IF;
3203:
3204: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3201: okc_debug.log('12200: Entered update_row', 2);

3197: BEGIN
3198:
3199: IF (l_debug = 'Y') THEN
3200: okc_debug.Set_Indentation('OKC_SAE_PVT');
3201: okc_debug.log('12200: Entered update_row', 2);
3202: END IF;
3203:
3204: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3205: G_PKG_NAME,

Line 3289: okc_debug.log('12300: Leaving update_row', 2);

3285: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3286:
3287:
3288: IF (l_debug = 'Y') THEN
3289: okc_debug.log('12300: Leaving update_row', 2);
3290: okc_debug.Reset_Indentation;
3291: END IF;
3292:
3293: EXCEPTION

Line 3290: okc_debug.Reset_Indentation;

3286:
3287:
3288: IF (l_debug = 'Y') THEN
3289: okc_debug.log('12300: Leaving update_row', 2);
3290: okc_debug.Reset_Indentation;
3291: END IF;
3292:
3293: EXCEPTION
3294: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3297: okc_debug.log('12400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3293: EXCEPTION
3294: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3295:
3296: IF (l_debug = 'Y') THEN
3297: okc_debug.log('12400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3298: okc_debug.Reset_Indentation;
3299: END IF;
3300:
3301: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3298: okc_debug.Reset_Indentation;

3294: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3295:
3296: IF (l_debug = 'Y') THEN
3297: okc_debug.log('12400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3298: okc_debug.Reset_Indentation;
3299: END IF;
3300:
3301: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3302: (

Line 3313: okc_debug.log('12500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3309: );
3310: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3311:
3312: IF (l_debug = 'Y') THEN
3313: okc_debug.log('12500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3314: okc_debug.Reset_Indentation;
3315: END IF;
3316:
3317: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3314: okc_debug.Reset_Indentation;

3310: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3311:
3312: IF (l_debug = 'Y') THEN
3313: okc_debug.log('12500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3314: okc_debug.Reset_Indentation;
3315: END IF;
3316:
3317: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3318: (

Line 3329: okc_debug.log('12600: Exiting update_row:OTHERS Exception', 2);

3325: );
3326: WHEN OTHERS THEN
3327:
3328: IF (l_debug = 'Y') THEN
3329: okc_debug.log('12600: Exiting update_row:OTHERS Exception', 2);
3330: okc_debug.Reset_Indentation;
3331: END IF;
3332:
3333: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3330: okc_debug.Reset_Indentation;

3326: WHEN OTHERS THEN
3327:
3328: IF (l_debug = 'Y') THEN
3329: okc_debug.log('12600: Exiting update_row:OTHERS Exception', 2);
3330: okc_debug.Reset_Indentation;
3331: END IF;
3332:
3333: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3334: (

Line 3363: okc_debug.Set_Indentation('OKC_SAE_PVT');

3359: i NUMBER := 0;
3360: BEGIN
3361:
3362: IF (l_debug = 'Y') THEN
3363: okc_debug.Set_Indentation('OKC_SAE_PVT');
3364: okc_debug.log('12700: Entered update_row', 2);
3365: END IF;
3366:
3367: -- Make sure PL/SQL table has records in it before passing

Line 3364: okc_debug.log('12700: Entered update_row', 2);

3360: BEGIN
3361:
3362: IF (l_debug = 'Y') THEN
3363: okc_debug.Set_Indentation('OKC_SAE_PVT');
3364: okc_debug.log('12700: Entered update_row', 2);
3365: END IF;
3366:
3367: -- Make sure PL/SQL table has records in it before passing
3368: IF (p_saev_tbl.COUNT > 0) THEN

Line 3385: okc_debug.log('12800: Leaving update_row', 2);

3381: END LOOP;
3382: END IF;
3383:
3384: IF (l_debug = 'Y') THEN
3385: okc_debug.log('12800: Leaving update_row', 2);
3386: okc_debug.Reset_Indentation;
3387: END IF;
3388:
3389: EXCEPTION

Line 3386: okc_debug.Reset_Indentation;

3382: END IF;
3383:
3384: IF (l_debug = 'Y') THEN
3385: okc_debug.log('12800: Leaving update_row', 2);
3386: okc_debug.Reset_Indentation;
3387: END IF;
3388:
3389: EXCEPTION
3390: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3393: okc_debug.log('12900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3389: EXCEPTION
3390: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3391:
3392: IF (l_debug = 'Y') THEN
3393: okc_debug.log('12900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3394: okc_debug.Reset_Indentation;
3395: END IF;
3396:
3397: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3394: okc_debug.Reset_Indentation;

3390: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3391:
3392: IF (l_debug = 'Y') THEN
3393: okc_debug.log('12900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3394: okc_debug.Reset_Indentation;
3395: END IF;
3396:
3397: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3398: (

Line 3409: okc_debug.log('13000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3405: );
3406: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3407:
3408: IF (l_debug = 'Y') THEN
3409: okc_debug.log('13000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3410: okc_debug.Reset_Indentation;
3411: END IF;
3412:
3413: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3410: okc_debug.Reset_Indentation;

3406: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3407:
3408: IF (l_debug = 'Y') THEN
3409: okc_debug.log('13000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3410: okc_debug.Reset_Indentation;
3411: END IF;
3412:
3413: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3414: (

Line 3425: okc_debug.log('13100: Exiting update_row:OTHERS Exception', 2);

3421: );
3422: WHEN OTHERS THEN
3423:
3424: IF (l_debug = 'Y') THEN
3425: okc_debug.log('13100: Exiting update_row:OTHERS Exception', 2);
3426: okc_debug.Reset_Indentation;
3427: END IF;
3428:
3429: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3426: okc_debug.Reset_Indentation;

3422: WHEN OTHERS THEN
3423:
3424: IF (l_debug = 'Y') THEN
3425: okc_debug.log('13100: Exiting update_row:OTHERS Exception', 2);
3426: okc_debug.Reset_Indentation;
3427: END IF;
3428:
3429: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3430: (

Line 3462: okc_debug.Set_Indentation('OKC_SAE_PVT');

3458: l_row_notfound BOOLEAN := TRUE;
3459: BEGIN
3460:
3461: IF (l_debug = 'Y') THEN
3462: okc_debug.Set_Indentation('OKC_SAE_PVT');
3463: okc_debug.log('13200: Entered delete_row', 2);
3464: END IF;
3465:
3466: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3463: okc_debug.log('13200: Entered delete_row', 2);

3459: BEGIN
3460:
3461: IF (l_debug = 'Y') THEN
3462: okc_debug.Set_Indentation('OKC_SAE_PVT');
3463: okc_debug.log('13200: Entered delete_row', 2);
3464: END IF;
3465:
3466: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3467: p_init_msg_list,

Line 3481: okc_debug.log('13300: Leaving delete_row', 2);

3477:
3478: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3479:
3480: IF (l_debug = 'Y') THEN
3481: okc_debug.log('13300: Leaving delete_row', 2);
3482: okc_debug.Reset_Indentation;
3483: END IF;
3484:
3485: EXCEPTION

Line 3482: okc_debug.Reset_Indentation;

3478: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3479:
3480: IF (l_debug = 'Y') THEN
3481: okc_debug.log('13300: Leaving delete_row', 2);
3482: okc_debug.Reset_Indentation;
3483: END IF;
3484:
3485: EXCEPTION
3486: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3489: okc_debug.log('13400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3485: EXCEPTION
3486: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3487:
3488: IF (l_debug = 'Y') THEN
3489: okc_debug.log('13400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3490: okc_debug.Reset_Indentation;
3491: END IF;
3492:
3493: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3490: okc_debug.Reset_Indentation;

3486: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3487:
3488: IF (l_debug = 'Y') THEN
3489: okc_debug.log('13400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3490: okc_debug.Reset_Indentation;
3491: END IF;
3492:
3493: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3494: (

Line 3505: okc_debug.log('13500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3501: );
3502: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3503:
3504: IF (l_debug = 'Y') THEN
3505: okc_debug.log('13500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3506: okc_debug.Reset_Indentation;
3507: END IF;
3508:
3509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3506: okc_debug.Reset_Indentation;

3502: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3503:
3504: IF (l_debug = 'Y') THEN
3505: okc_debug.log('13500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3506: okc_debug.Reset_Indentation;
3507: END IF;
3508:
3509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3510: (

Line 3521: okc_debug.log('13600: Exiting delete_row:OTHERS Exception', 2);

3517: );
3518: WHEN OTHERS THEN
3519:
3520: IF (l_debug = 'Y') THEN
3521: okc_debug.log('13600: Exiting delete_row:OTHERS Exception', 2);
3522: okc_debug.Reset_Indentation;
3523: END IF;
3524:
3525: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3522: okc_debug.Reset_Indentation;

3518: WHEN OTHERS THEN
3519:
3520: IF (l_debug = 'Y') THEN
3521: okc_debug.log('13600: Exiting delete_row:OTHERS Exception', 2);
3522: okc_debug.Reset_Indentation;
3523: END IF;
3524:
3525: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3526: (

Line 3562: okc_debug.Set_Indentation('OKC_SAE_PVT');

3558: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3559: BEGIN
3560:
3561: IF (l_debug = 'Y') THEN
3562: okc_debug.Set_Indentation('OKC_SAE_PVT');
3563: okc_debug.log('13700: Entered Set_Attributes', 2);
3564: END IF;
3565:
3566: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;

Line 3563: okc_debug.log('13700: Entered Set_Attributes', 2);

3559: BEGIN
3560:
3561: IF (l_debug = 'Y') THEN
3562: okc_debug.Set_Indentation('OKC_SAE_PVT');
3563: okc_debug.log('13700: Entered Set_Attributes', 2);
3564: END IF;
3565:
3566: x_okc_std_articles_tl_rec := p_okc_std_articles_tl_rec;
3567: --x_okc_std_articles_tl_rec.LANGUAGE := USERENV('LANG');

Line 3575: okc_debug.Set_Indentation('OKC_SAE_PVT');

3571: END Set_Attributes;
3572: BEGIN
3573:
3574: IF (l_debug = 'Y') THEN
3575: okc_debug.Set_Indentation('OKC_SAE_PVT');
3576: okc_debug.log('13800: Entered delete_row', 2);
3577: END IF;
3578:
3579: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3576: okc_debug.log('13800: Entered delete_row', 2);

3572: BEGIN
3573:
3574: IF (l_debug = 'Y') THEN
3575: okc_debug.Set_Indentation('OKC_SAE_PVT');
3576: okc_debug.log('13800: Entered delete_row', 2);
3577: END IF;
3578:
3579: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3580: p_init_msg_list,

Line 3604: okc_debug.log('13900: Leaving delete_row', 2);

3600:
3601: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3602:
3603: IF (l_debug = 'Y') THEN
3604: okc_debug.log('13900: Leaving delete_row', 2);
3605: okc_debug.Reset_Indentation;
3606: END IF;
3607:
3608: EXCEPTION

Line 3605: okc_debug.Reset_Indentation;

3601: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3602:
3603: IF (l_debug = 'Y') THEN
3604: okc_debug.log('13900: Leaving delete_row', 2);
3605: okc_debug.Reset_Indentation;
3606: END IF;
3607:
3608: EXCEPTION
3609: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3612: okc_debug.log('14000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3608: EXCEPTION
3609: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3610:
3611: IF (l_debug = 'Y') THEN
3612: okc_debug.log('14000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3613: okc_debug.Reset_Indentation;
3614: END IF;
3615:
3616: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3613: okc_debug.Reset_Indentation;

3609: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3610:
3611: IF (l_debug = 'Y') THEN
3612: okc_debug.log('14000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3613: okc_debug.Reset_Indentation;
3614: END IF;
3615:
3616: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3617: (

Line 3628: okc_debug.log('14100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3624: );
3625: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3626:
3627: IF (l_debug = 'Y') THEN
3628: okc_debug.log('14100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3629: okc_debug.Reset_Indentation;
3630: END IF;
3631:
3632: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3629: okc_debug.Reset_Indentation;

3625: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3626:
3627: IF (l_debug = 'Y') THEN
3628: okc_debug.log('14100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3629: okc_debug.Reset_Indentation;
3630: END IF;
3631:
3632: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3633: (

Line 3644: okc_debug.log('14200: Exiting delete_row:OTHERS Exception', 2);

3640: );
3641: WHEN OTHERS THEN
3642:
3643: IF (l_debug = 'Y') THEN
3644: okc_debug.log('14200: Exiting delete_row:OTHERS Exception', 2);
3645: okc_debug.Reset_Indentation;
3646: END IF;
3647:
3648: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3645: okc_debug.Reset_Indentation;

3641: WHEN OTHERS THEN
3642:
3643: IF (l_debug = 'Y') THEN
3644: okc_debug.log('14200: Exiting delete_row:OTHERS Exception', 2);
3645: okc_debug.Reset_Indentation;
3646: END IF;
3647:
3648: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3649: (

Line 3679: okc_debug.Set_Indentation('OKC_SAE_PVT');

3675: l_sae_rec sae_rec_type;
3676: BEGIN
3677:
3678: IF (l_debug = 'Y') THEN
3679: okc_debug.Set_Indentation('OKC_SAE_PVT');
3680: okc_debug.log('14300: Entered delete_row', 2);
3681: END IF;
3682:
3683: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3680: okc_debug.log('14300: Entered delete_row', 2);

3676: BEGIN
3677:
3678: IF (l_debug = 'Y') THEN
3679: okc_debug.Set_Indentation('OKC_SAE_PVT');
3680: okc_debug.log('14300: Entered delete_row', 2);
3681: END IF;
3682:
3683: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3684: G_PKG_NAME,

Line 3730: okc_debug.log('14400: Leaving delete_row', 2);

3726: END IF;
3727: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3728:
3729: IF (l_debug = 'Y') THEN
3730: okc_debug.log('14400: Leaving delete_row', 2);
3731: okc_debug.Reset_Indentation;
3732: END IF;
3733:
3734: EXCEPTION

Line 3731: okc_debug.Reset_Indentation;

3727: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3728:
3729: IF (l_debug = 'Y') THEN
3730: okc_debug.log('14400: Leaving delete_row', 2);
3731: okc_debug.Reset_Indentation;
3732: END IF;
3733:
3734: EXCEPTION
3735: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3738: okc_debug.log('14500: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3734: EXCEPTION
3735: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3736:
3737: IF (l_debug = 'Y') THEN
3738: okc_debug.log('14500: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3739: okc_debug.Reset_Indentation;
3740: END IF;
3741:
3742: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3739: okc_debug.Reset_Indentation;

3735: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3736:
3737: IF (l_debug = 'Y') THEN
3738: okc_debug.log('14500: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3739: okc_debug.Reset_Indentation;
3740: END IF;
3741:
3742: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3743: (

Line 3754: okc_debug.log('14600: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3750: );
3751: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3752:
3753: IF (l_debug = 'Y') THEN
3754: okc_debug.log('14600: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3755: okc_debug.Reset_Indentation;
3756: END IF;
3757:
3758: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3755: okc_debug.Reset_Indentation;

3751: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3752:
3753: IF (l_debug = 'Y') THEN
3754: okc_debug.log('14600: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3755: okc_debug.Reset_Indentation;
3756: END IF;
3757:
3758: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3759: (

Line 3770: okc_debug.log('14700: Exiting delete_row:OTHERS Exception', 2);

3766: );
3767: WHEN OTHERS THEN
3768:
3769: IF (l_debug = 'Y') THEN
3770: okc_debug.log('14700: Exiting delete_row:OTHERS Exception', 2);
3771: okc_debug.Reset_Indentation;
3772: END IF;
3773:
3774: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3771: okc_debug.Reset_Indentation;

3767: WHEN OTHERS THEN
3768:
3769: IF (l_debug = 'Y') THEN
3770: okc_debug.log('14700: Exiting delete_row:OTHERS Exception', 2);
3771: okc_debug.Reset_Indentation;
3772: END IF;
3773:
3774: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3775: (

Line 3803: okc_debug.Set_Indentation('OKC_SAE_PVT');

3799: i NUMBER := 0;
3800: BEGIN
3801:
3802: IF (l_debug = 'Y') THEN
3803: okc_debug.Set_Indentation('OKC_SAE_PVT');
3804: okc_debug.log('14800: Entered delete_row', 2);
3805: END IF;
3806:
3807: -- Make sure PL/SQL table has records in it before passing

Line 3804: okc_debug.log('14800: Entered delete_row', 2);

3800: BEGIN
3801:
3802: IF (l_debug = 'Y') THEN
3803: okc_debug.Set_Indentation('OKC_SAE_PVT');
3804: okc_debug.log('14800: Entered delete_row', 2);
3805: END IF;
3806:
3807: -- Make sure PL/SQL table has records in it before passing
3808: IF (p_saev_tbl.COUNT > 0) THEN

Line 3824: okc_debug.log('14900: Leaving delete_row', 2);

3820: END LOOP;
3821: END IF;
3822:
3823: IF (l_debug = 'Y') THEN
3824: okc_debug.log('14900: Leaving delete_row', 2);
3825: okc_debug.Reset_Indentation;
3826: END IF;
3827:
3828: EXCEPTION

Line 3825: okc_debug.Reset_Indentation;

3821: END IF;
3822:
3823: IF (l_debug = 'Y') THEN
3824: okc_debug.log('14900: Leaving delete_row', 2);
3825: okc_debug.Reset_Indentation;
3826: END IF;
3827:
3828: EXCEPTION
3829: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3832: okc_debug.log('15000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

3828: EXCEPTION
3829: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3830:
3831: IF (l_debug = 'Y') THEN
3832: okc_debug.log('15000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3833: okc_debug.Reset_Indentation;
3834: END IF;
3835:
3836: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3833: okc_debug.Reset_Indentation;

3829: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3830:
3831: IF (l_debug = 'Y') THEN
3832: okc_debug.log('15000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3833: okc_debug.Reset_Indentation;
3834: END IF;
3835:
3836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3837: (

Line 3848: okc_debug.log('15100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3844: );
3845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3846:
3847: IF (l_debug = 'Y') THEN
3848: okc_debug.log('15100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3849: okc_debug.Reset_Indentation;
3850: END IF;
3851:
3852: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3849: okc_debug.Reset_Indentation;

3845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3846:
3847: IF (l_debug = 'Y') THEN
3848: okc_debug.log('15100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3849: okc_debug.Reset_Indentation;
3850: END IF;
3851:
3852: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3853: (

Line 3864: okc_debug.log('15200: Exiting delete_row:OTHERS Exception', 2);

3860: );
3861: WHEN OTHERS THEN
3862:
3863: IF (l_debug = 'Y') THEN
3864: okc_debug.log('15200: Exiting delete_row:OTHERS Exception', 2);
3865: okc_debug.Reset_Indentation;
3866: END IF;
3867:
3868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3865: okc_debug.Reset_Indentation;

3861: WHEN OTHERS THEN
3862:
3863: IF (l_debug = 'Y') THEN
3864: okc_debug.log('15200: Exiting delete_row:OTHERS Exception', 2);
3865: okc_debug.Reset_Indentation;
3866: END IF;
3867:
3868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3869: (