APPS.OKC_SCC_PVT dependencies on OKC_DEBUG

Line 30: okc_debug.Set_Indentation('OKC_SCC_PVT');

26:
27: Begin
28:
29: IF (l_debug = 'Y') THEN
30: okc_debug.Set_Indentation('OKC_SCC_PVT');
31: okc_debug.log('100: Entered validate_scn_id', 2);
32: END IF;
33:
34: -- initialize return status

Line 31: okc_debug.log('100: Entered validate_scn_id', 2);

27: Begin
28:
29: IF (l_debug = 'Y') THEN
30: okc_debug.Set_Indentation('OKC_SCC_PVT');
31: okc_debug.log('100: Entered validate_scn_id', 2);
32: END IF;
33:
34: -- initialize return status
35: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 73: okc_debug.log('200: Leaving validate_scn_id', 2);

69: x_return_status := OKC_API.G_RET_STS_ERROR;
70: End If;
71:
72: IF (l_debug = 'Y') THEN
73: okc_debug.log('200: Leaving validate_scn_id', 2);
74: okc_debug.Reset_Indentation;
75: END IF;
76:
77: exception

Line 74: okc_debug.Reset_Indentation;

70: End If;
71:
72: IF (l_debug = 'Y') THEN
73: okc_debug.log('200: Leaving validate_scn_id', 2);
74: okc_debug.Reset_Indentation;
75: END IF;
76:
77: exception
78: when OTHERS then

Line 81: okc_debug.log('300: Exiting validate_scn_id:OTHERS Exception', 2);

77: exception
78: when OTHERS then
79:
80: IF (l_debug = 'Y') THEN
81: okc_debug.log('300: Exiting validate_scn_id:OTHERS Exception', 2);
82: okc_debug.Reset_Indentation;
83: END IF;
84:
85: -- store SQL error message on message stack

Line 82: okc_debug.Reset_Indentation;

78: when OTHERS then
79:
80: IF (l_debug = 'Y') THEN
81: okc_debug.log('300: Exiting validate_scn_id:OTHERS Exception', 2);
82: okc_debug.Reset_Indentation;
83: END IF;
84:
85: -- store SQL error message on message stack
86: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 122: okc_debug.Set_Indentation('OKC_SCC_PVT');

118:
119: Begin
120:
121: IF (l_debug = 'Y') THEN
122: okc_debug.Set_Indentation('OKC_SCC_PVT');
123: okc_debug.log('400: Entered validate_cat_id', 2);
124: END IF;
125:
126: -- initialize return status

Line 123: okc_debug.log('400: Entered validate_cat_id', 2);

119: Begin
120:
121: IF (l_debug = 'Y') THEN
122: okc_debug.Set_Indentation('OKC_SCC_PVT');
123: okc_debug.log('400: Entered validate_cat_id', 2);
124: END IF;
125:
126: -- initialize return status
127: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 152: okc_debug.log('500: Leaving validate_cat_id', 2);

148: End If;
149: End If;
150:
151: IF (l_debug = 'Y') THEN
152: okc_debug.log('500: Leaving validate_cat_id', 2);
153: okc_debug.Reset_Indentation;
154: END IF;
155:
156: exception

Line 153: okc_debug.Reset_Indentation;

149: End If;
150:
151: IF (l_debug = 'Y') THEN
152: okc_debug.log('500: Leaving validate_cat_id', 2);
153: okc_debug.Reset_Indentation;
154: END IF;
155:
156: exception
157: when OTHERS then

Line 160: okc_debug.log('600: Exiting validate_cat_id:OTHERS Exception', 2);

156: exception
157: when OTHERS then
158:
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('600: Exiting validate_cat_id:OTHERS Exception', 2);
161: okc_debug.Reset_Indentation;
162: END IF;
163:
164: -- store SQL error message on message stack

Line 161: okc_debug.Reset_Indentation;

157: when OTHERS then
158:
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('600: Exiting validate_cat_id:OTHERS Exception', 2);
161: okc_debug.Reset_Indentation;
162: END IF;
163:
164: -- store SQL error message on message stack
165: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 201: okc_debug.Set_Indentation('OKC_SCC_PVT');

197:
198: Begin
199:
200: IF (l_debug = 'Y') THEN
201: okc_debug.Set_Indentation('OKC_SCC_PVT');
202: okc_debug.log('700: Entered validate_cle_id', 2);
203: END IF;
204:
205: -- initialize return status

Line 202: okc_debug.log('700: Entered validate_cle_id', 2);

198: Begin
199:
200: IF (l_debug = 'Y') THEN
201: okc_debug.Set_Indentation('OKC_SCC_PVT');
202: okc_debug.log('700: Entered validate_cle_id', 2);
203: END IF;
204:
205: -- initialize return status
206: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 231: okc_debug.log('800: Leaving validate_cle_id', 2);

227: End If;
228: End If;
229:
230: IF (l_debug = 'Y') THEN
231: okc_debug.log('800: Leaving validate_cle_id', 2);
232: okc_debug.Reset_Indentation;
233: END IF;
234:
235: exception

Line 232: okc_debug.Reset_Indentation;

228: End If;
229:
230: IF (l_debug = 'Y') THEN
231: okc_debug.log('800: Leaving validate_cle_id', 2);
232: okc_debug.Reset_Indentation;
233: END IF;
234:
235: exception
236: when OTHERS then

Line 239: okc_debug.log('900: Exiting validate_cle_id:OTHERS Exception', 2);

235: exception
236: when OTHERS then
237:
238: IF (l_debug = 'Y') THEN
239: okc_debug.log('900: Exiting validate_cle_id:OTHERS Exception', 2);
240: okc_debug.Reset_Indentation;
241: END IF;
242:
243: -- store SQL error message on message stack

Line 240: okc_debug.Reset_Indentation;

236: when OTHERS then
237:
238: IF (l_debug = 'Y') THEN
239: okc_debug.log('900: Exiting validate_cle_id:OTHERS Exception', 2);
240: okc_debug.Reset_Indentation;
241: END IF;
242:
243: -- store SQL error message on message stack
244: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 280: okc_debug.Set_Indentation('OKC_SCC_PVT');

276:
277: Begin
278:
279: IF (l_debug = 'Y') THEN
280: okc_debug.Set_Indentation('OKC_SCC_PVT');
281: okc_debug.log('1000: Entered validate_sae_id', 2);
282: END IF;
283:
284: -- initialize return status

Line 281: okc_debug.log('1000: Entered validate_sae_id', 2);

277: Begin
278:
279: IF (l_debug = 'Y') THEN
280: okc_debug.Set_Indentation('OKC_SCC_PVT');
281: okc_debug.log('1000: Entered validate_sae_id', 2);
282: END IF;
283:
284: -- initialize return status
285: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 310: okc_debug.log('1100: Leaving validate_sae_id', 2);

306: End If;
307: End If;
308:
309: IF (l_debug = 'Y') THEN
310: okc_debug.log('1100: Leaving validate_sae_id', 2);
311: okc_debug.Reset_Indentation;
312: END IF;
313:
314: exception

Line 311: okc_debug.Reset_Indentation;

307: End If;
308:
309: IF (l_debug = 'Y') THEN
310: okc_debug.log('1100: Leaving validate_sae_id', 2);
311: okc_debug.Reset_Indentation;
312: END IF;
313:
314: exception
315: when OTHERS then

Line 318: okc_debug.log('1200: Exiting validate_sae_id:OTHERS Exception', 2);

314: exception
315: when OTHERS then
316:
317: IF (l_debug = 'Y') THEN
318: okc_debug.log('1200: Exiting validate_sae_id:OTHERS Exception', 2);
319: okc_debug.Reset_Indentation;
320: END IF;
321:
322: -- store SQL error message on message stack

Line 319: okc_debug.Reset_Indentation;

315: when OTHERS then
316:
317: IF (l_debug = 'Y') THEN
318: okc_debug.log('1200: Exiting validate_sae_id:OTHERS Exception', 2);
319: okc_debug.Reset_Indentation;
320: END IF;
321:
322: -- store SQL error message on message stack
323: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 371: okc_debug.Set_Indentation('OKC_SCC_PVT');

367:
368: BEGIN
369:
370: IF (l_debug = 'Y') THEN
371: okc_debug.Set_Indentation('OKC_SCC_PVT');
372: okc_debug.log('1300: Entered validate_content_sequence', 2);
373: END IF;
374:
375: -- initialize return status

Line 372: okc_debug.log('1300: Entered validate_content_sequence', 2);

368: BEGIN
369:
370: IF (l_debug = 'Y') THEN
371: okc_debug.Set_Indentation('OKC_SCC_PVT');
372: okc_debug.log('1300: Entered validate_content_sequence', 2);
373: END IF;
374:
375: -- initialize return status
376: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 419: okc_debug.log('1400: Leaving validate_content_sequence', 2);

415: x_return_status := OKC_API.G_RET_STS_ERROR;
416: END IF;
417:
418: IF (l_debug = 'Y') THEN
419: okc_debug.log('1400: Leaving validate_content_sequence', 2);
420: okc_debug.Reset_Indentation;
421: END IF;
422:
423: EXCEPTION

Line 420: okc_debug.Reset_Indentation;

416: END IF;
417:
418: IF (l_debug = 'Y') THEN
419: okc_debug.log('1400: Leaving validate_content_sequence', 2);
420: okc_debug.Reset_Indentation;
421: END IF;
422:
423: EXCEPTION
424: WHEN OTHERS THEN

Line 427: okc_debug.log('1500: Exiting validate_content_sequence:OTHERS Exception', 2);

423: EXCEPTION
424: WHEN OTHERS THEN
425:
426: IF (l_debug = 'Y') THEN
427: okc_debug.log('1500: Exiting validate_content_sequence:OTHERS Exception', 2);
428: okc_debug.Reset_Indentation;
429: END IF;
430:
431: -- store SQL error message on message stack

Line 428: okc_debug.Reset_Indentation;

424: WHEN OTHERS THEN
425:
426: IF (l_debug = 'Y') THEN
427: okc_debug.log('1500: Exiting validate_content_sequence:OTHERS Exception', 2);
428: okc_debug.Reset_Indentation;
429: END IF;
430:
431: -- store SQL error message on message stack
432: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 501: okc_debug.Set_Indentation('OKC_SCC_PVT');

497: l_scc_rec scc_rec_type;
498: BEGIN
499:
500: IF (l_debug = 'Y') THEN
501: okc_debug.Set_Indentation('OKC_SCC_PVT');
502: okc_debug.log('1700: Entered get_rec', 2);
503: END IF;
504:
505: x_no_data_found := TRUE;

Line 502: okc_debug.log('1700: Entered get_rec', 2);

498: BEGIN
499:
500: IF (l_debug = 'Y') THEN
501: okc_debug.Set_Indentation('OKC_SCC_PVT');
502: okc_debug.log('1700: Entered get_rec', 2);
503: END IF;
504:
505: x_no_data_found := TRUE;
506: -- Get current database values

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

538: x_no_data_found := okc_section_contents_pk_csr%NOTFOUND;
539: CLOSE okc_section_contents_pk_csr;
540:
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
543: okc_debug.Reset_Indentation;
544: END IF;
545:
546: RETURN(l_scc_rec);

Line 543: okc_debug.Reset_Indentation;

539: CLOSE okc_section_contents_pk_csr;
540:
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
543: okc_debug.Reset_Indentation;
544: END IF;
545:
546: RETURN(l_scc_rec);
547:

Line 610: okc_debug.Set_Indentation('OKC_SCC_PVT');

606: l_sccv_rec sccv_rec_type;
607: BEGIN
608:
609: IF (l_debug = 'Y') THEN
610: okc_debug.Set_Indentation('OKC_SCC_PVT');
611: okc_debug.log('1900: Entered get_rec', 2);
612: END IF;
613:
614: x_no_data_found := TRUE;

Line 611: okc_debug.log('1900: Entered get_rec', 2);

607: BEGIN
608:
609: IF (l_debug = 'Y') THEN
610: okc_debug.Set_Indentation('OKC_SCC_PVT');
611: okc_debug.log('1900: Entered get_rec', 2);
612: END IF;
613:
614: x_no_data_found := TRUE;
615:

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

653:
654: -- UPTO THIS - JOHN
655:
656: IF (l_debug = 'Y') THEN
657: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
658: okc_debug.Reset_Indentation;
659: END IF;
660:
661: RETURN(l_sccv_rec);

Line 658: okc_debug.Reset_Indentation;

654: -- UPTO THIS - JOHN
655:
656: IF (l_debug = 'Y') THEN
657: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
658: okc_debug.Reset_Indentation;
659: END IF;
660:
661: RETURN(l_sccv_rec);
662:

Line 685: okc_debug.Set_Indentation('OKC_SCC_PVT');

681: l_sccv_rec sccv_rec_type := p_sccv_rec;
682: BEGIN
683:
684: IF (l_debug = 'Y') THEN
685: okc_debug.Set_Indentation('OKC_SCC_PVT');
686: okc_debug.log('2100: Entered null_out_defaults', 2);
687: END IF;
688:
689: IF (l_sccv_rec.id = OKC_API.G_MISS_NUM) THEN

Line 686: okc_debug.log('2100: Entered null_out_defaults', 2);

682: BEGIN
683:
684: IF (l_debug = 'Y') THEN
685: okc_debug.Set_Indentation('OKC_SCC_PVT');
686: okc_debug.log('2100: Entered null_out_defaults', 2);
687: END IF;
688:
689: IF (l_sccv_rec.id = OKC_API.G_MISS_NUM) THEN
690: l_sccv_rec.id := NULL;

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

774: l_sccv_rec.attribute15 := NULL;
775: END IF;
776:
777: IF (l_debug = 'Y') THEN
778: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
779: okc_debug.Reset_Indentation;
780: END IF;
781:
782: RETURN(l_sccv_rec);

Line 779: okc_debug.Reset_Indentation;

775: END IF;
776:
777: IF (l_debug = 'Y') THEN
778: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
779: okc_debug.Reset_Indentation;
780: END IF;
781:
782: RETURN(l_sccv_rec);
783:

Line 799: okc_debug.Set_Indentation('OKC_SCC_PVT');

795: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
796: BEGIN
797:
798: IF (l_debug = 'Y') THEN
799: okc_debug.Set_Indentation('OKC_SCC_PVT');
800: okc_debug.log('2200: Entered Validate_Attributes', 2);
801: END IF;
802:
803: /************************ HAND-CODED *********************************/

Line 800: okc_debug.log('2200: Entered Validate_Attributes', 2);

796: BEGIN
797:
798: IF (l_debug = 'Y') THEN
799: okc_debug.Set_Indentation('OKC_SCC_PVT');
800: okc_debug.log('2200: Entered Validate_Attributes', 2);
801: END IF;
802:
803: /************************ HAND-CODED *********************************/
804: validate_scn_id

Line 860: okc_debug.log('2300: Leaving Validate_Attributes', 2);

856: End If;
857: End If;
858:
859: IF (l_debug = 'Y') THEN
860: okc_debug.log('2300: Leaving Validate_Attributes', 2);
861: okc_debug.Reset_Indentation;
862: END IF;
863:
864: RETURN(x_return_status);

Line 861: okc_debug.Reset_Indentation;

857: End If;
858:
859: IF (l_debug = 'Y') THEN
860: okc_debug.log('2300: Leaving Validate_Attributes', 2);
861: okc_debug.Reset_Indentation;
862: END IF;
863:
864: RETURN(x_return_status);
865:

Line 870: okc_debug.log('2400: Exiting Validate_Attributes:OTHERS Exception', 2);

866: exception
867: when OTHERS then
868:
869: IF (l_debug = 'Y') THEN
870: okc_debug.log('2400: Exiting Validate_Attributes:OTHERS Exception', 2);
871: okc_debug.Reset_Indentation;
872: END IF;
873:
874: -- store SQL error message on message stack

Line 871: okc_debug.Reset_Indentation;

867: when OTHERS then
868:
869: IF (l_debug = 'Y') THEN
870: okc_debug.log('2400: Exiting Validate_Attributes:OTHERS Exception', 2);
871: okc_debug.Reset_Indentation;
872: END IF;
873:
874: -- store SQL error message on message stack
875: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 917: okc_debug.Set_Indentation('OKC_SCC_PVT');

913: AND id <> p_sccv_rec.id;
914: BEGIN
915:
916: IF (l_debug = 'Y') THEN
917: okc_debug.Set_Indentation('OKC_SCC_PVT');
918: okc_debug.log('2500: Entered Validate_Record', 2);
919: END IF;
920:
921: Open l_sccv_csr;

Line 918: okc_debug.log('2500: Entered Validate_Record', 2);

914: BEGIN
915:
916: IF (l_debug = 'Y') THEN
917: okc_debug.Set_Indentation('OKC_SCC_PVT');
918: okc_debug.log('2500: Entered Validate_Record', 2);
919: END IF;
920:
921: Open l_sccv_csr;
922: Fetch l_sccv_csr Into l_counter;

Line 934: okc_debug.log('500: Leaving Validate_Record ', 2);

930: p_token1_value => 'Article');
931: End If;
932:
933: IF (l_debug = 'Y') THEN
934: okc_debug.log('500: Leaving Validate_Record ', 2);
935: okc_debug.Reset_Indentation;
936: END IF;
937:
938: RETURN (l_return_status);

Line 935: okc_debug.Reset_Indentation;

931: End If;
932:
933: IF (l_debug = 'Y') THEN
934: okc_debug.log('500: Leaving Validate_Record ', 2);
935: okc_debug.Reset_Indentation;
936: END IF;
937:
938: RETURN (l_return_status);
939:

Line 1044: okc_debug.Set_Indentation('OKC_SCC_PVT');

1040: l_scc_rec scc_rec_type;
1041: BEGIN
1042:
1043: IF (l_debug = 'Y') THEN
1044: okc_debug.Set_Indentation('OKC_SCC_PVT');
1045: okc_debug.log('2800: Entered validate_row', 2);
1046: END IF;
1047:
1048: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1045: okc_debug.log('2800: Entered validate_row', 2);

1041: BEGIN
1042:
1043: IF (l_debug = 'Y') THEN
1044: okc_debug.Set_Indentation('OKC_SCC_PVT');
1045: okc_debug.log('2800: Entered validate_row', 2);
1046: END IF;
1047:
1048: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1049: G_PKG_NAME,

Line 1077: okc_debug.log('2900: Leaving validate_row', 2);

1073: END IF;
1074: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1075:
1076: IF (l_debug = 'Y') THEN
1077: okc_debug.log('2900: Leaving validate_row', 2);
1078: okc_debug.Reset_Indentation;
1079: END IF;
1080:
1081: EXCEPTION

Line 1078: okc_debug.Reset_Indentation;

1074: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1075:
1076: IF (l_debug = 'Y') THEN
1077: okc_debug.log('2900: Leaving validate_row', 2);
1078: okc_debug.Reset_Indentation;
1079: END IF;
1080:
1081: EXCEPTION
1082: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1081: EXCEPTION
1082: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1083:
1084: IF (l_debug = 'Y') THEN
1085: okc_debug.log('3000: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1086: okc_debug.Reset_Indentation;
1087: END IF;
1088:
1089: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1086: okc_debug.Reset_Indentation;

1082: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1083:
1084: IF (l_debug = 'Y') THEN
1085: okc_debug.log('3000: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1086: okc_debug.Reset_Indentation;
1087: END IF;
1088:
1089: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1090: (

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

1097: );
1098: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099:
1100: IF (l_debug = 'Y') THEN
1101: okc_debug.log('3100: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1102: okc_debug.Reset_Indentation;
1103: END IF;
1104:
1105: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1102: okc_debug.Reset_Indentation;

1098: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099:
1100: IF (l_debug = 'Y') THEN
1101: okc_debug.log('3100: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1102: okc_debug.Reset_Indentation;
1103: END IF;
1104:
1105: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1106: (

Line 1117: okc_debug.log('3200: Exiting validate_row:OTHERS Exception', 2);

1113: );
1114: WHEN OTHERS THEN
1115:
1116: IF (l_debug = 'Y') THEN
1117: okc_debug.log('3200: Exiting validate_row:OTHERS Exception', 2);
1118: okc_debug.Reset_Indentation;
1119: END IF;
1120:
1121: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1118: okc_debug.Reset_Indentation;

1114: WHEN OTHERS THEN
1115:
1116: IF (l_debug = 'Y') THEN
1117: okc_debug.log('3200: Exiting validate_row:OTHERS Exception', 2);
1118: okc_debug.Reset_Indentation;
1119: END IF;
1120:
1121: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1122: (

Line 1150: okc_debug.Set_Indentation('OKC_SCC_PVT');

1146: i NUMBER := 0;
1147: BEGIN
1148:
1149: IF (l_debug = 'Y') THEN
1150: okc_debug.Set_Indentation('OKC_SCC_PVT');
1151: okc_debug.log('3300: Entered validate_row', 2);
1152: END IF;
1153:
1154: OKC_API.init_msg_list(p_init_msg_list);

Line 1151: okc_debug.log('3300: Entered validate_row', 2);

1147: BEGIN
1148:
1149: IF (l_debug = 'Y') THEN
1150: okc_debug.Set_Indentation('OKC_SCC_PVT');
1151: okc_debug.log('3300: Entered validate_row', 2);
1152: END IF;
1153:
1154: OKC_API.init_msg_list(p_init_msg_list);
1155: -- Make sure PL/SQL table has records in it before passing

Line 1172: okc_debug.log('3400: Leaving validate_row', 2);

1168: END LOOP;
1169: END IF;
1170:
1171: IF (l_debug = 'Y') THEN
1172: okc_debug.log('3400: Leaving validate_row', 2);
1173: okc_debug.Reset_Indentation;
1174: END IF;
1175:
1176: EXCEPTION

Line 1173: okc_debug.Reset_Indentation;

1169: END IF;
1170:
1171: IF (l_debug = 'Y') THEN
1172: okc_debug.log('3400: Leaving validate_row', 2);
1173: okc_debug.Reset_Indentation;
1174: END IF;
1175:
1176: EXCEPTION
1177: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1176: EXCEPTION
1177: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1178:
1179: IF (l_debug = 'Y') THEN
1180: okc_debug.log('3500: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1181: okc_debug.Reset_Indentation;
1182: END IF;
1183:
1184: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1181: okc_debug.Reset_Indentation;

1177: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1178:
1179: IF (l_debug = 'Y') THEN
1180: okc_debug.log('3500: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1181: okc_debug.Reset_Indentation;
1182: END IF;
1183:
1184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1185: (

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

1192: );
1193: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1194:
1195: IF (l_debug = 'Y') THEN
1196: okc_debug.log('3600: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1197: okc_debug.Reset_Indentation;
1198: END IF;
1199:
1200: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1197: okc_debug.Reset_Indentation;

1193: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1194:
1195: IF (l_debug = 'Y') THEN
1196: okc_debug.log('3600: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1197: okc_debug.Reset_Indentation;
1198: END IF;
1199:
1200: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1201: (

Line 1212: okc_debug.log('3700: Exiting validate_row:OTHERS Exception', 2);

1208: );
1209: WHEN OTHERS THEN
1210:
1211: IF (l_debug = 'Y') THEN
1212: okc_debug.log('3700: Exiting validate_row:OTHERS Exception', 2);
1213: okc_debug.Reset_Indentation;
1214: END IF;
1215:
1216: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1213: okc_debug.Reset_Indentation;

1209: WHEN OTHERS THEN
1210:
1211: IF (l_debug = 'Y') THEN
1212: okc_debug.log('3700: Exiting validate_row:OTHERS Exception', 2);
1213: okc_debug.Reset_Indentation;
1214: END IF;
1215:
1216: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1217: (

Line 1264: okc_debug.Set_Indentation('OKC_SCC_PVT');

1260: END Set_Attributes;
1261: BEGIN
1262:
1263: IF (l_debug = 'Y') THEN
1264: okc_debug.Set_Indentation('OKC_SCC_PVT');
1265: okc_debug.log('3900: Entered insert_row', 2);
1266: END IF;
1267:
1268: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1265: okc_debug.log('3900: Entered insert_row', 2);

1261: BEGIN
1262:
1263: IF (l_debug = 'Y') THEN
1264: okc_debug.Set_Indentation('OKC_SCC_PVT');
1265: okc_debug.log('3900: Entered insert_row', 2);
1266: END IF;
1267:
1268: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1269: p_init_msg_list,

Line 1352: okc_debug.log('4000: Leaving insert_row', 2);

1348: x_scc_rec := l_scc_rec;
1349: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1350:
1351: IF (l_debug = 'Y') THEN
1352: okc_debug.log('4000: Leaving insert_row', 2);
1353: okc_debug.Reset_Indentation;
1354: END IF;
1355:
1356: EXCEPTION

Line 1353: okc_debug.Reset_Indentation;

1349: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1350:
1351: IF (l_debug = 'Y') THEN
1352: okc_debug.log('4000: Leaving insert_row', 2);
1353: okc_debug.Reset_Indentation;
1354: END IF;
1355:
1356: EXCEPTION
1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1356: EXCEPTION
1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1358:
1359: IF (l_debug = 'Y') THEN
1360: okc_debug.log('4100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1361: okc_debug.Reset_Indentation;
1362: END IF;
1363:
1364: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1361: okc_debug.Reset_Indentation;

1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1358:
1359: IF (l_debug = 'Y') THEN
1360: okc_debug.log('4100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1361: okc_debug.Reset_Indentation;
1362: END IF;
1363:
1364: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1365: (

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

1372: );
1373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1374:
1375: IF (l_debug = 'Y') THEN
1376: okc_debug.log('4200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1377: okc_debug.Reset_Indentation;
1378: END IF;
1379:
1380: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1377: okc_debug.Reset_Indentation;

1373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1374:
1375: IF (l_debug = 'Y') THEN
1376: okc_debug.log('4200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1377: okc_debug.Reset_Indentation;
1378: END IF;
1379:
1380: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1381: (

Line 1392: okc_debug.log('4300: Exiting insert_row:OTHERS Exception', 2);

1388: );
1389: WHEN OTHERS THEN
1390:
1391: IF (l_debug = 'Y') THEN
1392: okc_debug.log('4300: Exiting insert_row:OTHERS Exception', 2);
1393: okc_debug.Reset_Indentation;
1394: END IF;
1395:
1396: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1393: okc_debug.Reset_Indentation;

1389: WHEN OTHERS THEN
1390:
1391: IF (l_debug = 'Y') THEN
1392: okc_debug.log('4300: Exiting insert_row:OTHERS Exception', 2);
1393: okc_debug.Reset_Indentation;
1394: END IF;
1395:
1396: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1397: (

Line 1461: okc_debug.Set_Indentation('OKC_SCC_PVT');

1457: END Set_Attributes;
1458: BEGIN
1459:
1460: IF (l_debug = 'Y') THEN
1461: okc_debug.Set_Indentation('OKC_SCC_PVT');
1462: okc_debug.log('4600: Entered insert_row', 2);
1463: END IF;
1464:
1465: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1462: okc_debug.log('4600: Entered insert_row', 2);

1458: BEGIN
1459:
1460: IF (l_debug = 'Y') THEN
1461: okc_debug.Set_Indentation('OKC_SCC_PVT');
1462: okc_debug.log('4600: Entered insert_row', 2);
1463: END IF;
1464:
1465: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1466: G_PKG_NAME,

Line 1531: okc_debug.log('4700: Leaving insert_row', 2);

1527: x_sccv_rec := l_def_sccv_rec;
1528: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1529:
1530: IF (l_debug = 'Y') THEN
1531: okc_debug.log('4700: Leaving insert_row', 2);
1532: okc_debug.Reset_Indentation;
1533: END IF;
1534:
1535: EXCEPTION

Line 1532: okc_debug.Reset_Indentation;

1528: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1529:
1530: IF (l_debug = 'Y') THEN
1531: okc_debug.log('4700: Leaving insert_row', 2);
1532: okc_debug.Reset_Indentation;
1533: END IF;
1534:
1535: EXCEPTION
1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1535: EXCEPTION
1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1537:
1538: IF (l_debug = 'Y') THEN
1539: okc_debug.log('4800: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1540: okc_debug.Reset_Indentation;
1541: END IF;
1542:
1543: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1540: okc_debug.Reset_Indentation;

1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1537:
1538: IF (l_debug = 'Y') THEN
1539: okc_debug.log('4800: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1540: okc_debug.Reset_Indentation;
1541: END IF;
1542:
1543: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1544: (

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

1551: );
1552: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1553:
1554: IF (l_debug = 'Y') THEN
1555: okc_debug.log('4900: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1556: okc_debug.Reset_Indentation;
1557: END IF;
1558:
1559: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1556: okc_debug.Reset_Indentation;

1552: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1553:
1554: IF (l_debug = 'Y') THEN
1555: okc_debug.log('4900: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1556: okc_debug.Reset_Indentation;
1557: END IF;
1558:
1559: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1560: (

Line 1571: okc_debug.log('5000: Exiting insert_row:OTHERS Exception', 2);

1567: );
1568: WHEN OTHERS THEN
1569:
1570: IF (l_debug = 'Y') THEN
1571: okc_debug.log('5000: Exiting insert_row:OTHERS Exception', 2);
1572: okc_debug.Reset_Indentation;
1573: END IF;
1574:
1575: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1572: okc_debug.Reset_Indentation;

1568: WHEN OTHERS THEN
1569:
1570: IF (l_debug = 'Y') THEN
1571: okc_debug.log('5000: Exiting insert_row:OTHERS Exception', 2);
1572: okc_debug.Reset_Indentation;
1573: END IF;
1574:
1575: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1576: (

Line 1605: okc_debug.Set_Indentation('OKC_SCC_PVT');

1601: i NUMBER := 0;
1602: BEGIN
1603:
1604: IF (l_debug = 'Y') THEN
1605: okc_debug.Set_Indentation('OKC_SCC_PVT');
1606: okc_debug.log('5100: Entered insert_row', 2);
1607: END IF;
1608:
1609: OKC_API.init_msg_list(p_init_msg_list);

Line 1606: okc_debug.log('5100: Entered insert_row', 2);

1602: BEGIN
1603:
1604: IF (l_debug = 'Y') THEN
1605: okc_debug.Set_Indentation('OKC_SCC_PVT');
1606: okc_debug.log('5100: Entered insert_row', 2);
1607: END IF;
1608:
1609: OKC_API.init_msg_list(p_init_msg_list);
1610: -- Make sure PL/SQL table has records in it before passing

Line 1628: okc_debug.log('5200: Leaving insert_row', 2);

1624: END LOOP;
1625: END IF;
1626:
1627: IF (l_debug = 'Y') THEN
1628: okc_debug.log('5200: Leaving insert_row', 2);
1629: okc_debug.Reset_Indentation;
1630: END IF;
1631:
1632: EXCEPTION

Line 1629: okc_debug.Reset_Indentation;

1625: END IF;
1626:
1627: IF (l_debug = 'Y') THEN
1628: okc_debug.log('5200: Leaving insert_row', 2);
1629: okc_debug.Reset_Indentation;
1630: END IF;
1631:
1632: EXCEPTION
1633: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1632: EXCEPTION
1633: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1634:
1635: IF (l_debug = 'Y') THEN
1636: okc_debug.log('5300: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1637: okc_debug.Reset_Indentation;
1638: END IF;
1639:
1640: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1637: okc_debug.Reset_Indentation;

1633: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1634:
1635: IF (l_debug = 'Y') THEN
1636: okc_debug.log('5300: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1637: okc_debug.Reset_Indentation;
1638: END IF;
1639:
1640: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1641: (

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

1648: );
1649: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1650:
1651: IF (l_debug = 'Y') THEN
1652: okc_debug.log('5400: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1653: okc_debug.Reset_Indentation;
1654: END IF;
1655:
1656: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1653: okc_debug.Reset_Indentation;

1649: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1650:
1651: IF (l_debug = 'Y') THEN
1652: okc_debug.log('5400: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1653: okc_debug.Reset_Indentation;
1654: END IF;
1655:
1656: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1657: (

Line 1668: okc_debug.log('5500: Exiting insert_row:OTHERS Exception', 2);

1664: );
1665: WHEN OTHERS THEN
1666:
1667: IF (l_debug = 'Y') THEN
1668: okc_debug.log('5500: Exiting insert_row:OTHERS Exception', 2);
1669: okc_debug.Reset_Indentation;
1670: END IF;
1671:
1672: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1669: okc_debug.Reset_Indentation;

1665: WHEN OTHERS THEN
1666:
1667: IF (l_debug = 'Y') THEN
1668: okc_debug.log('5500: Exiting insert_row:OTHERS Exception', 2);
1669: okc_debug.Reset_Indentation;
1670: END IF;
1671:
1672: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1673: (

Line 1720: okc_debug.Set_Indentation('OKC_SCC_PVT');

1716: lc_row_notfound BOOLEAN := FALSE;
1717: BEGIN
1718:
1719: IF (l_debug = 'Y') THEN
1720: okc_debug.Set_Indentation('OKC_SCC_PVT');
1721: okc_debug.log('5600: Entered lock_row', 2);
1722: END IF;
1723:
1724: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1721: okc_debug.log('5600: Entered lock_row', 2);

1717: BEGIN
1718:
1719: IF (l_debug = 'Y') THEN
1720: okc_debug.Set_Indentation('OKC_SCC_PVT');
1721: okc_debug.log('5600: Entered lock_row', 2);
1722: END IF;
1723:
1724: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1725: p_init_msg_list,

Line 1738: okc_debug.Set_Indentation('OKC_SCC_PVT');

1734: -->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1735: BEGIN
1736:
1737: IF (l_debug = 'Y') THEN
1738: okc_debug.Set_Indentation('OKC_SCC_PVT');
1739: okc_debug.log('5700: Entered lock_row', 2);
1740: END IF;
1741:
1742: OPEN lock_csr(p_scc_rec);

Line 1739: okc_debug.log('5700: Entered lock_row', 2);

1735: BEGIN
1736:
1737: IF (l_debug = 'Y') THEN
1738: okc_debug.Set_Indentation('OKC_SCC_PVT');
1739: okc_debug.log('5700: Entered lock_row', 2);
1740: END IF;
1741:
1742: OPEN lock_csr(p_scc_rec);
1743: FETCH lock_csr INTO l_object_version_number;

Line 1748: okc_debug.log('5800: Leaving lock_row', 2);

1744: l_row_notfound := lock_csr%NOTFOUND;
1745: CLOSE lock_csr;
1746:
1747: IF (l_debug = 'Y') THEN
1748: okc_debug.log('5800: Leaving lock_row', 2);
1749: okc_debug.Reset_Indentation;
1750: END IF;
1751:
1752: EXCEPTION

Line 1749: okc_debug.Reset_Indentation;

1745: CLOSE lock_csr;
1746:
1747: IF (l_debug = 'Y') THEN
1748: okc_debug.log('5800: Leaving lock_row', 2);
1749: okc_debug.Reset_Indentation;
1750: END IF;
1751:
1752: EXCEPTION
1753: WHEN E_Resource_Busy THEN

Line 1756: okc_debug.log('5900: Exiting lock_row:E_Resource_Busy Exception', 2);

1752: EXCEPTION
1753: WHEN E_Resource_Busy THEN
1754:
1755: IF (l_debug = 'Y') THEN
1756: okc_debug.log('5900: Exiting lock_row:E_Resource_Busy Exception', 2);
1757: okc_debug.Reset_Indentation;
1758: END IF;
1759:
1760: IF (lock_csr%ISOPEN) THEN

Line 1757: okc_debug.Reset_Indentation;

1753: WHEN E_Resource_Busy THEN
1754:
1755: IF (l_debug = 'Y') THEN
1756: okc_debug.log('5900: Exiting lock_row:E_Resource_Busy Exception', 2);
1757: okc_debug.Reset_Indentation;
1758: END IF;
1759:
1760: IF (lock_csr%ISOPEN) THEN
1761: CLOSE lock_csr;

Line 1791: okc_debug.log('6000: Leaving lock_row', 2);

1787: END IF;
1788: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1789:
1790: IF (l_debug = 'Y') THEN
1791: okc_debug.log('6000: Leaving lock_row', 2);
1792: okc_debug.Reset_Indentation;
1793: END IF;
1794:
1795: EXCEPTION

Line 1792: okc_debug.Reset_Indentation;

1788: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1789:
1790: IF (l_debug = 'Y') THEN
1791: okc_debug.log('6000: Leaving lock_row', 2);
1792: okc_debug.Reset_Indentation;
1793: END IF;
1794:
1795: EXCEPTION
1796: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1795: EXCEPTION
1796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1797:
1798: IF (l_debug = 'Y') THEN
1799: okc_debug.log('6100: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1800: okc_debug.Reset_Indentation;
1801: END IF;
1802:
1803: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1800: okc_debug.Reset_Indentation;

1796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1797:
1798: IF (l_debug = 'Y') THEN
1799: okc_debug.log('6100: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1800: okc_debug.Reset_Indentation;
1801: END IF;
1802:
1803: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1804: (

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

1811: );
1812: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1813:
1814: IF (l_debug = 'Y') THEN
1815: okc_debug.log('6200: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1816: okc_debug.Reset_Indentation;
1817: END IF;
1818:
1819: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1816: okc_debug.Reset_Indentation;

1812: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1813:
1814: IF (l_debug = 'Y') THEN
1815: okc_debug.log('6200: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1816: okc_debug.Reset_Indentation;
1817: END IF;
1818:
1819: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1820: (

Line 1831: okc_debug.log('6300: Exiting lock_row:OTHERS Exception', 2);

1827: );
1828: WHEN OTHERS THEN
1829:
1830: IF (l_debug = 'Y') THEN
1831: okc_debug.log('6300: Exiting lock_row:OTHERS Exception', 2);
1832: okc_debug.Reset_Indentation;
1833: END IF;
1834:
1835: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1832: okc_debug.Reset_Indentation;

1828: WHEN OTHERS THEN
1829:
1830: IF (l_debug = 'Y') THEN
1831: okc_debug.log('6300: Exiting lock_row:OTHERS Exception', 2);
1832: okc_debug.Reset_Indentation;
1833: END IF;
1834:
1835: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1836: (

Line 1864: okc_debug.Set_Indentation('OKC_SCC_PVT');

1860: l_scc_rec scc_rec_type;
1861: BEGIN
1862:
1863: IF (l_debug = 'Y') THEN
1864: okc_debug.Set_Indentation('OKC_SCC_PVT');
1865: okc_debug.log('6400: Entered lock_row', 2);
1866: END IF;
1867:
1868: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1865: okc_debug.log('6400: Entered lock_row', 2);

1861: BEGIN
1862:
1863: IF (l_debug = 'Y') THEN
1864: okc_debug.Set_Indentation('OKC_SCC_PVT');
1865: okc_debug.log('6400: Entered lock_row', 2);
1866: END IF;
1867:
1868: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1869: G_PKG_NAME,

Line 1902: okc_debug.log('6500: Leaving lock_row', 2);

1898: END IF;
1899: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1900:
1901: IF (l_debug = 'Y') THEN
1902: okc_debug.log('6500: Leaving lock_row', 2);
1903: okc_debug.Reset_Indentation;
1904: END IF;
1905:
1906: EXCEPTION

Line 1903: okc_debug.Reset_Indentation;

1899: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1900:
1901: IF (l_debug = 'Y') THEN
1902: okc_debug.log('6500: Leaving lock_row', 2);
1903: okc_debug.Reset_Indentation;
1904: END IF;
1905:
1906: EXCEPTION
1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1906: EXCEPTION
1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1908:
1909: IF (l_debug = 'Y') THEN
1910: okc_debug.log('6600: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1911: okc_debug.Reset_Indentation;
1912: END IF;
1913:
1914: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1911: okc_debug.Reset_Indentation;

1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1908:
1909: IF (l_debug = 'Y') THEN
1910: okc_debug.log('6600: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1911: okc_debug.Reset_Indentation;
1912: END IF;
1913:
1914: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1915: (

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

1922: );
1923: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1924:
1925: IF (l_debug = 'Y') THEN
1926: okc_debug.log('6700: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1927: okc_debug.Reset_Indentation;
1928: END IF;
1929:
1930: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1927: okc_debug.Reset_Indentation;

1923: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1924:
1925: IF (l_debug = 'Y') THEN
1926: okc_debug.log('6700: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1927: okc_debug.Reset_Indentation;
1928: END IF;
1929:
1930: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1931: (

Line 1942: okc_debug.log('6800: Exiting lock_row:OTHERS Exception', 2);

1938: );
1939: WHEN OTHERS THEN
1940:
1941: IF (l_debug = 'Y') THEN
1942: okc_debug.log('6800: Exiting lock_row:OTHERS Exception', 2);
1943: okc_debug.Reset_Indentation;
1944: END IF;
1945:
1946: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1943: okc_debug.Reset_Indentation;

1939: WHEN OTHERS THEN
1940:
1941: IF (l_debug = 'Y') THEN
1942: okc_debug.log('6800: Exiting lock_row:OTHERS Exception', 2);
1943: okc_debug.Reset_Indentation;
1944: END IF;
1945:
1946: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1947: (

Line 1975: okc_debug.Set_Indentation('OKC_SCC_PVT');

1971: i NUMBER := 0;
1972: BEGIN
1973:
1974: IF (l_debug = 'Y') THEN
1975: okc_debug.Set_Indentation('OKC_SCC_PVT');
1976: okc_debug.log('6900: Entered lock_row', 2);
1977: END IF;
1978:
1979: OKC_API.init_msg_list(p_init_msg_list);

Line 1976: okc_debug.log('6900: Entered lock_row', 2);

1972: BEGIN
1973:
1974: IF (l_debug = 'Y') THEN
1975: okc_debug.Set_Indentation('OKC_SCC_PVT');
1976: okc_debug.log('6900: Entered lock_row', 2);
1977: END IF;
1978:
1979: OKC_API.init_msg_list(p_init_msg_list);
1980: -- Make sure PL/SQL table has records in it before passing

Line 1997: okc_debug.log('7000: Leaving lock_row', 2);

1993: END LOOP;
1994: END IF;
1995:
1996: IF (l_debug = 'Y') THEN
1997: okc_debug.log('7000: Leaving lock_row', 2);
1998: okc_debug.Reset_Indentation;
1999: END IF;
2000:
2001: EXCEPTION

Line 1998: okc_debug.Reset_Indentation;

1994: END IF;
1995:
1996: IF (l_debug = 'Y') THEN
1997: okc_debug.log('7000: Leaving lock_row', 2);
1998: okc_debug.Reset_Indentation;
1999: END IF;
2000:
2001: EXCEPTION
2002: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2001: EXCEPTION
2002: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2003:
2004: IF (l_debug = 'Y') THEN
2005: okc_debug.log('7100: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2006: okc_debug.Reset_Indentation;
2007: END IF;
2008:
2009: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2006: okc_debug.Reset_Indentation;

2002: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2003:
2004: IF (l_debug = 'Y') THEN
2005: okc_debug.log('7100: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2006: okc_debug.Reset_Indentation;
2007: END IF;
2008:
2009: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2010: (

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

2017: );
2018: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2019:
2020: IF (l_debug = 'Y') THEN
2021: okc_debug.log('7200: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2022: okc_debug.Reset_Indentation;
2023: END IF;
2024:
2025: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2022: okc_debug.Reset_Indentation;

2018: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2019:
2020: IF (l_debug = 'Y') THEN
2021: okc_debug.log('7200: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2022: okc_debug.Reset_Indentation;
2023: END IF;
2024:
2025: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2026: (

Line 2037: okc_debug.log('7300: Exiting lock_row:OTHERS Exception', 2);

2033: );
2034: WHEN OTHERS THEN
2035:
2036: IF (l_debug = 'Y') THEN
2037: okc_debug.log('7300: Exiting lock_row:OTHERS Exception', 2);
2038: okc_debug.Reset_Indentation;
2039: END IF;
2040:
2041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2038: okc_debug.Reset_Indentation;

2034: WHEN OTHERS THEN
2035:
2036: IF (l_debug = 'Y') THEN
2037: okc_debug.log('7300: Exiting lock_row:OTHERS Exception', 2);
2038: okc_debug.Reset_Indentation;
2039: END IF;
2040:
2041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2042: (

Line 2086: okc_debug.Set_Indentation('OKC_SCC_PVT');

2082: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2083: BEGIN
2084:
2085: IF (l_debug = 'Y') THEN
2086: okc_debug.Set_Indentation('OKC_SCC_PVT');
2087: okc_debug.log('7400: Entered populate_new_record', 2);
2088: END IF;
2089:
2090: x_scc_rec := p_scc_rec;

Line 2087: okc_debug.log('7400: Entered populate_new_record', 2);

2083: BEGIN
2084:
2085: IF (l_debug = 'Y') THEN
2086: okc_debug.Set_Indentation('OKC_SCC_PVT');
2087: okc_debug.log('7400: Entered populate_new_record', 2);
2088: END IF;
2089:
2090: x_scc_rec := p_scc_rec;
2091: -- Get current database values

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

2210: x_scc_rec.attribute15 := l_scc_rec.attribute15;
2211: END IF;
2212:
2213: IF (l_debug = 'Y') THEN
2214: okc_debug.log('11950: Leaving populate_new_record ', 2);
2215: okc_debug.Reset_Indentation;
2216: END IF;
2217:
2218: RETURN(l_return_status);

Line 2215: okc_debug.Reset_Indentation;

2211: END IF;
2212:
2213: IF (l_debug = 'Y') THEN
2214: okc_debug.log('11950: Leaving populate_new_record ', 2);
2215: okc_debug.Reset_Indentation;
2216: END IF;
2217:
2218: RETURN(l_return_status);
2219:

Line 2238: okc_debug.Set_Indentation('OKC_SCC_PVT');

2234: END Set_Attributes;
2235: BEGIN
2236:
2237: IF (l_debug = 'Y') THEN
2238: okc_debug.Set_Indentation('OKC_SCC_PVT');
2239: okc_debug.log('7600: Entered update_row', 2);
2240: END IF;
2241:
2242: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2239: okc_debug.log('7600: Entered update_row', 2);

2235: BEGIN
2236:
2237: IF (l_debug = 'Y') THEN
2238: okc_debug.Set_Indentation('OKC_SCC_PVT');
2239: okc_debug.log('7600: Entered update_row', 2);
2240: END IF;
2241:
2242: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2243: p_init_msg_list,

Line 2302: okc_debug.log('7700: Leaving update_row', 2);

2298: x_scc_rec := l_def_scc_rec;
2299: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2300:
2301: IF (l_debug = 'Y') THEN
2302: okc_debug.log('7700: Leaving update_row', 2);
2303: okc_debug.Reset_Indentation;
2304: END IF;
2305:
2306: EXCEPTION

Line 2303: okc_debug.Reset_Indentation;

2299: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2300:
2301: IF (l_debug = 'Y') THEN
2302: okc_debug.log('7700: Leaving update_row', 2);
2303: okc_debug.Reset_Indentation;
2304: END IF;
2305:
2306: EXCEPTION
2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2306: EXCEPTION
2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2308:
2309: IF (l_debug = 'Y') THEN
2310: okc_debug.log('7800: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2311: okc_debug.Reset_Indentation;
2312: END IF;
2313:
2314: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2311: okc_debug.Reset_Indentation;

2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2308:
2309: IF (l_debug = 'Y') THEN
2310: okc_debug.log('7800: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2311: okc_debug.Reset_Indentation;
2312: END IF;
2313:
2314: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2315: (

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

2322: );
2323: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2324:
2325: IF (l_debug = 'Y') THEN
2326: okc_debug.log('7900: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2327: okc_debug.Reset_Indentation;
2328: END IF;
2329:
2330: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2327: okc_debug.Reset_Indentation;

2323: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2324:
2325: IF (l_debug = 'Y') THEN
2326: okc_debug.log('7900: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2327: okc_debug.Reset_Indentation;
2328: END IF;
2329:
2330: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2331: (

Line 2342: okc_debug.log('8000: Exiting update_row:OTHERS Exception', 2);

2338: );
2339: WHEN OTHERS THEN
2340:
2341: IF (l_debug = 'Y') THEN
2342: okc_debug.log('8000: Exiting update_row:OTHERS Exception', 2);
2343: okc_debug.Reset_Indentation;
2344: END IF;
2345:
2346: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2343: okc_debug.Reset_Indentation;

2339: WHEN OTHERS THEN
2340:
2341: IF (l_debug = 'Y') THEN
2342: okc_debug.log('8000: Exiting update_row:OTHERS Exception', 2);
2343: okc_debug.Reset_Indentation;
2344: END IF;
2345:
2346: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2347: (

Line 2404: okc_debug.Set_Indentation('OKC_SCC_PVT');

2400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2401: BEGIN
2402:
2403: IF (l_debug = 'Y') THEN
2404: okc_debug.Set_Indentation('OKC_SCC_PVT');
2405: okc_debug.log('8200: Entered populate_new_record', 2);
2406: END IF;
2407:
2408: x_sccv_rec := p_sccv_rec;

Line 2405: okc_debug.log('8200: Entered populate_new_record', 2);

2401: BEGIN
2402:
2403: IF (l_debug = 'Y') THEN
2404: okc_debug.Set_Indentation('OKC_SCC_PVT');
2405: okc_debug.log('8200: Entered populate_new_record', 2);
2406: END IF;
2407:
2408: x_sccv_rec := p_sccv_rec;
2409: -- Get current database values

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

2528: x_sccv_rec.attribute15 := l_sccv_rec.attribute15;
2529: END IF;
2530:
2531: IF (l_debug = 'Y') THEN
2532: okc_debug.log('11950: Leaving populate_new_record ', 2);
2533: okc_debug.Reset_Indentation;
2534: END IF;
2535:
2536: RETURN(l_return_status);

Line 2533: okc_debug.Reset_Indentation;

2529: END IF;
2530:
2531: IF (l_debug = 'Y') THEN
2532: okc_debug.log('11950: Leaving populate_new_record ', 2);
2533: okc_debug.Reset_Indentation;
2534: END IF;
2535:
2536: RETURN(l_return_status);
2537:

Line 2557: okc_debug.Set_Indentation('OKC_SCC_PVT');

2553: END Set_Attributes;
2554: BEGIN
2555:
2556: IF (l_debug = 'Y') THEN
2557: okc_debug.Set_Indentation('OKC_SCC_PVT');
2558: okc_debug.log('8400: Entered update_row', 2);
2559: END IF;
2560:
2561: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2558: okc_debug.log('8400: Entered update_row', 2);

2554: BEGIN
2555:
2556: IF (l_debug = 'Y') THEN
2557: okc_debug.Set_Indentation('OKC_SCC_PVT');
2558: okc_debug.log('8400: Entered update_row', 2);
2559: END IF;
2560:
2561: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2562: G_PKG_NAME,

Line 2630: okc_debug.log('8500: Leaving update_row', 2);

2626: x_sccv_rec := l_def_sccv_rec;
2627: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2628:
2629: IF (l_debug = 'Y') THEN
2630: okc_debug.log('8500: Leaving update_row', 2);
2631: okc_debug.Reset_Indentation;
2632: END IF;
2633:
2634: EXCEPTION

Line 2631: okc_debug.Reset_Indentation;

2627: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2628:
2629: IF (l_debug = 'Y') THEN
2630: okc_debug.log('8500: Leaving update_row', 2);
2631: okc_debug.Reset_Indentation;
2632: END IF;
2633:
2634: EXCEPTION
2635: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2634: EXCEPTION
2635: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2636:
2637: IF (l_debug = 'Y') THEN
2638: okc_debug.log('8600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2639: okc_debug.Reset_Indentation;
2640: END IF;
2641:
2642: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2639: okc_debug.Reset_Indentation;

2635: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2636:
2637: IF (l_debug = 'Y') THEN
2638: okc_debug.log('8600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2639: okc_debug.Reset_Indentation;
2640: END IF;
2641:
2642: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2643: (

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

2650: );
2651: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2652:
2653: IF (l_debug = 'Y') THEN
2654: okc_debug.log('8700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2655: okc_debug.Reset_Indentation;
2656: END IF;
2657:
2658: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2655: okc_debug.Reset_Indentation;

2651: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2652:
2653: IF (l_debug = 'Y') THEN
2654: okc_debug.log('8700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2655: okc_debug.Reset_Indentation;
2656: END IF;
2657:
2658: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2659: (

Line 2670: okc_debug.log('8800: Exiting update_row:OTHERS Exception', 2);

2666: );
2667: WHEN OTHERS THEN
2668:
2669: IF (l_debug = 'Y') THEN
2670: okc_debug.log('8800: Exiting update_row:OTHERS Exception', 2);
2671: okc_debug.Reset_Indentation;
2672: END IF;
2673:
2674: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2671: okc_debug.Reset_Indentation;

2667: WHEN OTHERS THEN
2668:
2669: IF (l_debug = 'Y') THEN
2670: okc_debug.log('8800: Exiting update_row:OTHERS Exception', 2);
2671: okc_debug.Reset_Indentation;
2672: END IF;
2673:
2674: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2675: (

Line 2705: okc_debug.Set_Indentation('OKC_SCC_PVT');

2701: i NUMBER := 0;
2702: BEGIN
2703:
2704: IF (l_debug = 'Y') THEN
2705: okc_debug.Set_Indentation('OKC_SCC_PVT');
2706: okc_debug.log('8900: Entered update_row', 2);
2707: END IF;
2708:
2709: OKC_API.init_msg_list(p_init_msg_list);

Line 2706: okc_debug.log('8900: Entered update_row', 2);

2702: BEGIN
2703:
2704: IF (l_debug = 'Y') THEN
2705: okc_debug.Set_Indentation('OKC_SCC_PVT');
2706: okc_debug.log('8900: Entered update_row', 2);
2707: END IF;
2708:
2709: OKC_API.init_msg_list(p_init_msg_list);
2710: -- Make sure PL/SQL table has records in it before passing

Line 2728: okc_debug.log('9000: Leaving update_row', 2);

2724: END LOOP;
2725: END IF;
2726:
2727: IF (l_debug = 'Y') THEN
2728: okc_debug.log('9000: Leaving update_row', 2);
2729: okc_debug.Reset_Indentation;
2730: END IF;
2731:
2732: EXCEPTION

Line 2729: okc_debug.Reset_Indentation;

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

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

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

Line 2737: okc_debug.Reset_Indentation;

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

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

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

Line 2753: okc_debug.Reset_Indentation;

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

Line 2768: okc_debug.log('9300: Exiting update_row:OTHERS Exception', 2);

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

Line 2769: okc_debug.Reset_Indentation;

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

Line 2805: okc_debug.Set_Indentation('OKC_SCC_PVT');

2801: l_row_notfound BOOLEAN := TRUE;
2802: BEGIN
2803:
2804: IF (l_debug = 'Y') THEN
2805: okc_debug.Set_Indentation('OKC_SCC_PVT');
2806: okc_debug.log('9400: Entered delete_row', 2);
2807: END IF;
2808:
2809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2806: okc_debug.log('9400: Entered delete_row', 2);

2802: BEGIN
2803:
2804: IF (l_debug = 'Y') THEN
2805: okc_debug.Set_Indentation('OKC_SCC_PVT');
2806: okc_debug.log('9400: Entered delete_row', 2);
2807: END IF;
2808:
2809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2810: p_init_msg_list,

Line 2824: okc_debug.log('9500: Leaving delete_row', 2);

2820:
2821: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2822:
2823: IF (l_debug = 'Y') THEN
2824: okc_debug.log('9500: Leaving delete_row', 2);
2825: okc_debug.Reset_Indentation;
2826: END IF;
2827:
2828: EXCEPTION

Line 2825: okc_debug.Reset_Indentation;

2821: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2822:
2823: IF (l_debug = 'Y') THEN
2824: okc_debug.log('9500: Leaving delete_row', 2);
2825: okc_debug.Reset_Indentation;
2826: END IF;
2827:
2828: EXCEPTION
2829: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2828: EXCEPTION
2829: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2830:
2831: IF (l_debug = 'Y') THEN
2832: okc_debug.log('9600: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2833: okc_debug.Reset_Indentation;
2834: END IF;
2835:
2836: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2833: okc_debug.Reset_Indentation;

2829: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2830:
2831: IF (l_debug = 'Y') THEN
2832: okc_debug.log('9600: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2833: okc_debug.Reset_Indentation;
2834: END IF;
2835:
2836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2837: (

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

2844: );
2845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2846:
2847: IF (l_debug = 'Y') THEN
2848: okc_debug.log('9700: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2849: okc_debug.Reset_Indentation;
2850: END IF;
2851:
2852: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2849: okc_debug.Reset_Indentation;

2845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2846:
2847: IF (l_debug = 'Y') THEN
2848: okc_debug.log('9700: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2849: okc_debug.Reset_Indentation;
2850: END IF;
2851:
2852: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2853: (

Line 2864: okc_debug.log('9800: Exiting delete_row:OTHERS Exception', 2);

2860: );
2861: WHEN OTHERS THEN
2862:
2863: IF (l_debug = 'Y') THEN
2864: okc_debug.log('9800: Exiting delete_row:OTHERS Exception', 2);
2865: okc_debug.Reset_Indentation;
2866: END IF;
2867:
2868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2865: okc_debug.Reset_Indentation;

2861: WHEN OTHERS THEN
2862:
2863: IF (l_debug = 'Y') THEN
2864: okc_debug.log('9800: Exiting delete_row:OTHERS Exception', 2);
2865: okc_debug.Reset_Indentation;
2866: END IF;
2867:
2868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2869: (

Line 2898: okc_debug.Set_Indentation('OKC_SCC_PVT');

2894: l_scc_rec scc_rec_type;
2895: BEGIN
2896:
2897: IF (l_debug = 'Y') THEN
2898: okc_debug.Set_Indentation('OKC_SCC_PVT');
2899: okc_debug.log('9900: Entered delete_row', 2);
2900: END IF;
2901:
2902: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2899: okc_debug.log('9900: Entered delete_row', 2);

2895: BEGIN
2896:
2897: IF (l_debug = 'Y') THEN
2898: okc_debug.Set_Indentation('OKC_SCC_PVT');
2899: okc_debug.log('9900: Entered delete_row', 2);
2900: END IF;
2901:
2902: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2903: G_PKG_NAME,

Line 2936: okc_debug.log('10000: Leaving delete_row', 2);

2932: END IF;
2933: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2934:
2935: IF (l_debug = 'Y') THEN
2936: okc_debug.log('10000: Leaving delete_row', 2);
2937: okc_debug.Reset_Indentation;
2938: END IF;
2939:
2940: EXCEPTION

Line 2937: okc_debug.Reset_Indentation;

2933: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2934:
2935: IF (l_debug = 'Y') THEN
2936: okc_debug.log('10000: Leaving delete_row', 2);
2937: okc_debug.Reset_Indentation;
2938: END IF;
2939:
2940: EXCEPTION
2941: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2940: EXCEPTION
2941: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2942:
2943: IF (l_debug = 'Y') THEN
2944: okc_debug.log('10100: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2945: okc_debug.Reset_Indentation;
2946: END IF;
2947:
2948: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2945: okc_debug.Reset_Indentation;

2941: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2942:
2943: IF (l_debug = 'Y') THEN
2944: okc_debug.log('10100: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2945: okc_debug.Reset_Indentation;
2946: END IF;
2947:
2948: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2949: (

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

2956: );
2957: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2958:
2959: IF (l_debug = 'Y') THEN
2960: okc_debug.log('10200: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2961: okc_debug.Reset_Indentation;
2962: END IF;
2963:
2964: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2961: okc_debug.Reset_Indentation;

2957: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2958:
2959: IF (l_debug = 'Y') THEN
2960: okc_debug.log('10200: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2961: okc_debug.Reset_Indentation;
2962: END IF;
2963:
2964: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2965: (

Line 2976: okc_debug.log('10300: Exiting delete_row:OTHERS Exception', 2);

2972: );
2973: WHEN OTHERS THEN
2974:
2975: IF (l_debug = 'Y') THEN
2976: okc_debug.log('10300: Exiting delete_row:OTHERS Exception', 2);
2977: okc_debug.Reset_Indentation;
2978: END IF;
2979:
2980: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2977: okc_debug.Reset_Indentation;

2973: WHEN OTHERS THEN
2974:
2975: IF (l_debug = 'Y') THEN
2976: okc_debug.log('10300: Exiting delete_row:OTHERS Exception', 2);
2977: okc_debug.Reset_Indentation;
2978: END IF;
2979:
2980: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2981: (

Line 3009: okc_debug.Set_Indentation('OKC_SCC_PVT');

3005: i NUMBER := 0;
3006: BEGIN
3007:
3008: IF (l_debug = 'Y') THEN
3009: okc_debug.Set_Indentation('OKC_SCC_PVT');
3010: okc_debug.log('10400: Entered delete_row', 2);
3011: END IF;
3012:
3013: OKC_API.init_msg_list(p_init_msg_list);

Line 3010: okc_debug.log('10400: Entered delete_row', 2);

3006: BEGIN
3007:
3008: IF (l_debug = 'Y') THEN
3009: okc_debug.Set_Indentation('OKC_SCC_PVT');
3010: okc_debug.log('10400: Entered delete_row', 2);
3011: END IF;
3012:
3013: OKC_API.init_msg_list(p_init_msg_list);
3014: -- Make sure PL/SQL table has records in it before passing

Line 3031: okc_debug.log('10500: Leaving delete_row', 2);

3027: END LOOP;
3028: END IF;
3029:
3030: IF (l_debug = 'Y') THEN
3031: okc_debug.log('10500: Leaving delete_row', 2);
3032: okc_debug.Reset_Indentation;
3033: END IF;
3034:
3035: EXCEPTION

Line 3032: okc_debug.Reset_Indentation;

3028: END IF;
3029:
3030: IF (l_debug = 'Y') THEN
3031: okc_debug.log('10500: Leaving delete_row', 2);
3032: okc_debug.Reset_Indentation;
3033: END IF;
3034:
3035: EXCEPTION
3036: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

3035: EXCEPTION
3036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3037:
3038: IF (l_debug = 'Y') THEN
3039: okc_debug.log('10600: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3040: okc_debug.Reset_Indentation;
3041: END IF;
3042:
3043: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3040: okc_debug.Reset_Indentation;

3036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3037:
3038: IF (l_debug = 'Y') THEN
3039: okc_debug.log('10600: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3040: okc_debug.Reset_Indentation;
3041: END IF;
3042:
3043: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3044: (

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

3051: );
3052: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3053:
3054: IF (l_debug = 'Y') THEN
3055: okc_debug.log('10700: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3056: okc_debug.Reset_Indentation;
3057: END IF;
3058:
3059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3056: okc_debug.Reset_Indentation;

3052: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3053:
3054: IF (l_debug = 'Y') THEN
3055: okc_debug.log('10700: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3056: okc_debug.Reset_Indentation;
3057: END IF;
3058:
3059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3060: (

Line 3071: okc_debug.log('10800: Exiting delete_row:OTHERS Exception', 2);

3067: );
3068: WHEN OTHERS THEN
3069:
3070: IF (l_debug = 'Y') THEN
3071: okc_debug.log('10800: Exiting delete_row:OTHERS Exception', 2);
3072: okc_debug.Reset_Indentation;
3073: END IF;
3074:
3075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3072: okc_debug.Reset_Indentation;

3068: WHEN OTHERS THEN
3069:
3070: IF (l_debug = 'Y') THEN
3071: okc_debug.log('10800: Exiting delete_row:OTHERS Exception', 2);
3072: okc_debug.Reset_Indentation;
3073: END IF;
3074:
3075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3076: (

Line 3101: okc_debug.Set_Indentation('OKC_SCC_PVT');

3097:
3098: BEGIN
3099:
3100: IF (l_debug = 'Y') THEN
3101: okc_debug.Set_Indentation('OKC_SCC_PVT');
3102: okc_debug.log('10900: Entered create_version', 2);
3103: END IF;
3104:
3105: INSERT INTO okc_section_contents_h

Line 3102: okc_debug.log('10900: Entered create_version', 2);

3098: BEGIN
3099:
3100: IF (l_debug = 'Y') THEN
3101: okc_debug.Set_Indentation('OKC_SCC_PVT');
3102: okc_debug.log('10900: Entered create_version', 2);
3103: END IF;
3104:
3105: INSERT INTO okc_section_contents_h
3106: (

Line 3175: okc_debug.log('11000: Leaving create_version', 2);

3171: FROM okc_sections_b
3172: WHERE CHR_ID=p_chr_id);
3173:
3174: IF (l_debug = 'Y') THEN
3175: okc_debug.log('11000: Leaving create_version', 2);
3176: okc_debug.Reset_Indentation;
3177: END IF;
3178: RETURN l_return_status;
3179:

Line 3176: okc_debug.Reset_Indentation;

3172: WHERE CHR_ID=p_chr_id);
3173:
3174: IF (l_debug = 'Y') THEN
3175: okc_debug.log('11000: Leaving create_version', 2);
3176: okc_debug.Reset_Indentation;
3177: END IF;
3178: RETURN l_return_status;
3179:
3180: EXCEPTION

Line 3185: okc_debug.log('11100: Exiting create_version:OTHERS Exception', 2);

3181: -- other appropriate handlers
3182: WHEN OTHERS THEN
3183:
3184: IF (l_debug = 'Y') THEN
3185: okc_debug.log('11100: Exiting create_version:OTHERS Exception', 2);
3186: okc_debug.Reset_Indentation;
3187: END IF;
3188:
3189: -- store SQL error message on message stack

Line 3186: okc_debug.Reset_Indentation;

3182: WHEN OTHERS THEN
3183:
3184: IF (l_debug = 'Y') THEN
3185: okc_debug.log('11100: Exiting create_version:OTHERS Exception', 2);
3186: okc_debug.Reset_Indentation;
3187: END IF;
3188:
3189: -- store SQL error message on message stack
3190: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

Line 3202: okc_debug.log('11000: Leaving create_version', 2);

3198: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3199: return l_return_status;
3200:
3201: IF (l_debug = 'Y') THEN
3202: okc_debug.log('11000: Leaving create_version', 2);
3203: okc_debug.Reset_Indentation;
3204: END IF;
3205: END create_version;
3206:

Line 3203: okc_debug.Reset_Indentation;

3199: return l_return_status;
3200:
3201: IF (l_debug = 'Y') THEN
3202: okc_debug.log('11000: Leaving create_version', 2);
3203: okc_debug.Reset_Indentation;
3204: END IF;
3205: END create_version;
3206:
3207: -----

Line 3227: okc_debug.Set_Indentation('OKC_SCC_PVT');

3223:
3224: BEGIN
3225:
3226: IF (l_debug = 'Y') THEN
3227: okc_debug.Set_Indentation('OKC_SCC_PVT');
3228: okc_debug.log('11200: Entered restore_version', 2);
3229: END IF;
3230:
3231: INSERT INTO okc_section_contents

Line 3228: okc_debug.log('11200: Entered restore_version', 2);

3224: BEGIN
3225:
3226: IF (l_debug = 'Y') THEN
3227: okc_debug.Set_Indentation('OKC_SCC_PVT');
3228: okc_debug.log('11200: Entered restore_version', 2);
3229: END IF;
3230:
3231: INSERT INTO okc_section_contents
3232: (

Line 3300: okc_debug.log('11300: Leaving restore_version', 2);

3296: WHERE chr_id = p_chr_id)
3297: AND major_version = p_major_version;
3298:
3299: IF (l_debug = 'Y') THEN
3300: okc_debug.log('11300: Leaving restore_version', 2);
3301: okc_debug.Reset_Indentation;
3302: END IF;
3303: RETURN l_return_status;
3304:

Line 3301: okc_debug.Reset_Indentation;

3297: AND major_version = p_major_version;
3298:
3299: IF (l_debug = 'Y') THEN
3300: okc_debug.log('11300: Leaving restore_version', 2);
3301: okc_debug.Reset_Indentation;
3302: END IF;
3303: RETURN l_return_status;
3304:
3305: EXCEPTION

Line 3310: okc_debug.log('11400: Exiting restore_version:OTHERS Exception', 2);

3306: -- other appropriate handlers
3307: WHEN OTHERS THEN
3308:
3309: IF (l_debug = 'Y') THEN
3310: okc_debug.log('11400: Exiting restore_version:OTHERS Exception', 2);
3311: okc_debug.Reset_Indentation;
3312: END IF;
3313:
3314: -- store SQL error message on message stack

Line 3311: okc_debug.Reset_Indentation;

3307: WHEN OTHERS THEN
3308:
3309: IF (l_debug = 'Y') THEN
3310: okc_debug.log('11400: Exiting restore_version:OTHERS Exception', 2);
3311: okc_debug.Reset_Indentation;
3312: END IF;
3313:
3314: -- store SQL error message on message stack
3315: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

Line 3327: okc_debug.log('11300: Leaving restore_version', 2);

3323: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3324: return l_return_status;
3325:
3326: IF (l_debug = 'Y') THEN
3327: okc_debug.log('11300: Leaving restore_version', 2);
3328: okc_debug.Reset_Indentation;
3329: END IF;
3330: END restore_version;
3331:

Line 3328: okc_debug.Reset_Indentation;

3324: return l_return_status;
3325:
3326: IF (l_debug = 'Y') THEN
3327: okc_debug.log('11300: Leaving restore_version', 2);
3328: okc_debug.Reset_Indentation;
3329: END IF;
3330: END restore_version;
3331:
3332: END OKC_SCC_PVT;