eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_RGR_PVT dependencies on OKC_DEBUG

Line 51: okc_debug.Set_Indentation('OKC_RGR_PVT');

47:
48: BEGIN
49:
50: IF (l_debug = 'Y') THEN
51: okc_debug.Set_Indentation('OKC_RGR_PVT');
52: okc_debug.log('100: Entered validate_uniqueness', 2);
53: END IF;
54:
55: -- ------------------------------------------------------

Line 52: okc_debug.log('100: Entered validate_uniqueness', 2);

48: BEGIN
49:
50: IF (l_debug = 'Y') THEN
51: okc_debug.Set_Indentation('OKC_RGR_PVT');
52: okc_debug.log('100: Entered validate_uniqueness', 2);
53: END IF;
54:
55: -- ------------------------------------------------------
56: -- Bug 1636056 related changes - Shyam

Line 84: okc_debug.log('200: Leaving validate_uniqueness', 2);

80: -- notify caller of the return status
81: x_return_status := l_return_status;
82:
83: IF (l_debug = 'Y') THEN
84: okc_debug.log('200: Leaving validate_uniqueness', 2);
85: okc_debug.Reset_Indentation;
86: END IF;
87:
88: EXCEPTION

Line 85: okc_debug.Reset_Indentation;

81: x_return_status := l_return_status;
82:
83: IF (l_debug = 'Y') THEN
84: okc_debug.log('200: Leaving validate_uniqueness', 2);
85: okc_debug.Reset_Indentation;
86: END IF;
87:
88: EXCEPTION
89: WHEN OTHERS THEN

Line 92: okc_debug.log('300: Exiting validate_uniqueness:OTHERS Exception', 2);

88: EXCEPTION
89: WHEN OTHERS THEN
90:
91: IF (l_debug = 'Y') THEN
92: okc_debug.log('300: Exiting validate_uniqueness:OTHERS Exception', 2);
93: okc_debug.Reset_Indentation;
94: END IF;
95:
96: -- store SQL error message on message stack

Line 93: okc_debug.Reset_Indentation;

89: WHEN OTHERS THEN
90:
91: IF (l_debug = 'Y') THEN
92: okc_debug.log('300: Exiting validate_uniqueness:OTHERS Exception', 2);
93: okc_debug.Reset_Indentation;
94: END IF;
95:
96: -- store SQL error message on message stack
97: OKC_API.SET_MESSAGE(

Line 133: okc_debug.Set_Indentation('OKC_RGR_PVT');

129: AND rgdv.lookup_type = 'OKC_RULE_GROUP_DEF';
130: BEGIN
131:
132: IF (l_debug = 'Y') THEN
133: okc_debug.Set_Indentation('OKC_RGR_PVT');
134: okc_debug.log('400: Entered validate_rgd_code', 2);
135: END IF;
136:
137: -- initialize return status

Line 134: okc_debug.log('400: Entered validate_rgd_code', 2);

130: BEGIN
131:
132: IF (l_debug = 'Y') THEN
133: okc_debug.Set_Indentation('OKC_RGR_PVT');
134: okc_debug.log('400: Entered validate_rgd_code', 2);
135: END IF;
136:
137: -- initialize return status
138: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 175: okc_debug.log('500: Leaving validate_rgd_code', 2);

171: x_return_status := OKC_API.G_RET_STS_ERROR;
172: END IF;
173:
174: IF (l_debug = 'Y') THEN
175: okc_debug.log('500: Leaving validate_rgd_code', 2);
176: okc_debug.Reset_Indentation;
177: END IF;
178:
179: EXCEPTION

Line 176: okc_debug.Reset_Indentation;

172: END IF;
173:
174: IF (l_debug = 'Y') THEN
175: okc_debug.log('500: Leaving validate_rgd_code', 2);
176: okc_debug.Reset_Indentation;
177: END IF;
178:
179: EXCEPTION
180: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 183: okc_debug.log('600: Exiting validate_rgd_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);

179: EXCEPTION
180: WHEN G_EXCEPTION_HALT_VALIDATION THEN
181:
182: IF (l_debug = 'Y') THEN
183: okc_debug.log('600: Exiting validate_rgd_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);
184: okc_debug.Reset_Indentation;
185: END IF;
186:
187: -- no processing necessary; validation can continue with next column

Line 184: okc_debug.Reset_Indentation;

180: WHEN G_EXCEPTION_HALT_VALIDATION THEN
181:
182: IF (l_debug = 'Y') THEN
183: okc_debug.log('600: Exiting validate_rgd_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);
184: okc_debug.Reset_Indentation;
185: END IF;
186:
187: -- no processing necessary; validation can continue with next column
188: NULL;

Line 192: okc_debug.log('700: Exiting validate_rgd_code:OTHERS Exception', 2);

188: NULL;
189: WHEN OTHERS THEN
190:
191: IF (l_debug = 'Y') THEN
192: okc_debug.log('700: Exiting validate_rgd_code:OTHERS Exception', 2);
193: okc_debug.Reset_Indentation;
194: END IF;
195:
196: -- store SQL error message on message stack

Line 193: okc_debug.Reset_Indentation;

189: WHEN OTHERS THEN
190:
191: IF (l_debug = 'Y') THEN
192: okc_debug.log('700: Exiting validate_rgd_code:OTHERS Exception', 2);
193: okc_debug.Reset_Indentation;
194: END IF;
195:
196: -- store SQL error message on message stack
197: OKC_API.SET_MESSAGE(

Line 242: okc_debug.Set_Indentation('OKC_RGR_PVT');

238: WHERE rdfv.RULE_CODE = p_rgrv_rec.rdf_code;
239: BEGIN
240:
241: IF (l_debug = 'Y') THEN
242: okc_debug.Set_Indentation('OKC_RGR_PVT');
243: okc_debug.log('800: Entered validate_rdf_code', 2);
244: END IF;
245:
246: -- initialize return status

Line 243: okc_debug.log('800: Entered validate_rdf_code', 2);

239: BEGIN
240:
241: IF (l_debug = 'Y') THEN
242: okc_debug.Set_Indentation('OKC_RGR_PVT');
243: okc_debug.log('800: Entered validate_rdf_code', 2);
244: END IF;
245:
246: -- initialize return status
247: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 284: okc_debug.log('900: Leaving validate_rdf_code', 2);

280: x_return_status := OKC_API.G_RET_STS_ERROR;
281: END IF;
282:
283: IF (l_debug = 'Y') THEN
284: okc_debug.log('900: Leaving validate_rdf_code', 2);
285: okc_debug.Reset_Indentation;
286: END IF;
287:
288: EXCEPTION

Line 285: okc_debug.Reset_Indentation;

281: END IF;
282:
283: IF (l_debug = 'Y') THEN
284: okc_debug.log('900: Leaving validate_rdf_code', 2);
285: okc_debug.Reset_Indentation;
286: END IF;
287:
288: EXCEPTION
289: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 292: okc_debug.log('1000: Exiting validate_rdf_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);

288: EXCEPTION
289: WHEN G_EXCEPTION_HALT_VALIDATION THEN
290:
291: IF (l_debug = 'Y') THEN
292: okc_debug.log('1000: Exiting validate_rdf_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);
293: okc_debug.Reset_Indentation;
294: END IF;
295:
296: -- no processing necessary; validation can continue with next column

Line 293: okc_debug.Reset_Indentation;

289: WHEN G_EXCEPTION_HALT_VALIDATION THEN
290:
291: IF (l_debug = 'Y') THEN
292: okc_debug.log('1000: Exiting validate_rdf_code:G_EXCEPTION_HALT_VALIDATION Exception', 2);
293: okc_debug.Reset_Indentation;
294: END IF;
295:
296: -- no processing necessary; validation can continue with next column
297: NULL;

Line 301: okc_debug.log('1100: Exiting validate_rdf_code:OTHERS Exception', 2);

297: NULL;
298: WHEN OTHERS THEN
299:
300: IF (l_debug = 'Y') THEN
301: okc_debug.log('1100: Exiting validate_rdf_code:OTHERS Exception', 2);
302: okc_debug.Reset_Indentation;
303: END IF;
304:
305: -- store SQL error message on message stack

Line 302: okc_debug.Reset_Indentation;

298: WHEN OTHERS THEN
299:
300: IF (l_debug = 'Y') THEN
301: okc_debug.log('1100: Exiting validate_rdf_code:OTHERS Exception', 2);
302: okc_debug.Reset_Indentation;
303: END IF;
304:
305: -- store SQL error message on message stack
306: OKC_API.SET_MESSAGE(

Line 338: okc_debug.Set_Indentation('OKC_RGR_PVT');

334: ) IS
335: BEGIN
336:
337: IF (l_debug = 'Y') THEN
338: okc_debug.Set_Indentation('OKC_RGR_PVT');
339: okc_debug.log('1200: Entered validate_optional_yn', 2);
340: END IF;
341:
342: -- initialize return status

Line 339: okc_debug.log('1200: Entered validate_optional_yn', 2);

335: BEGIN
336:
337: IF (l_debug = 'Y') THEN
338: okc_debug.Set_Indentation('OKC_RGR_PVT');
339: okc_debug.log('1200: Entered validate_optional_yn', 2);
340: END IF;
341:
342: -- initialize return status
343: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 363: okc_debug.log('1300: Leaving validate_optional_yn', 2);

359: END IF;
360: END IF;
361:
362: IF (l_debug = 'Y') THEN
363: okc_debug.log('1300: Leaving validate_optional_yn', 2);
364: okc_debug.Reset_Indentation;
365: END IF;
366:
367: EXCEPTION

Line 364: okc_debug.Reset_Indentation;

360: END IF;
361:
362: IF (l_debug = 'Y') THEN
363: okc_debug.log('1300: Leaving validate_optional_yn', 2);
364: okc_debug.Reset_Indentation;
365: END IF;
366:
367: EXCEPTION
368: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 371: okc_debug.log('1400: Exiting validate_optional_yn:G_EXCEPTION_HALT_VALIDATION Exception', 2);

367: EXCEPTION
368: WHEN G_EXCEPTION_HALT_VALIDATION THEN
369:
370: IF (l_debug = 'Y') THEN
371: okc_debug.log('1400: Exiting validate_optional_yn:G_EXCEPTION_HALT_VALIDATION Exception', 2);
372: okc_debug.Reset_Indentation;
373: END IF;
374:
375: -- no processing necessary; validation can continue with next column

Line 372: okc_debug.Reset_Indentation;

368: WHEN G_EXCEPTION_HALT_VALIDATION THEN
369:
370: IF (l_debug = 'Y') THEN
371: okc_debug.log('1400: Exiting validate_optional_yn:G_EXCEPTION_HALT_VALIDATION Exception', 2);
372: okc_debug.Reset_Indentation;
373: END IF;
374:
375: -- no processing necessary; validation can continue with next column
376: NULL;

Line 380: okc_debug.log('1500: Exiting validate_optional_yn:OTHERS Exception', 2);

376: NULL;
377: WHEN OTHERS THEN
378:
379: IF (l_debug = 'Y') THEN
380: okc_debug.log('1500: Exiting validate_optional_yn:OTHERS Exception', 2);
381: okc_debug.Reset_Indentation;
382: END IF;
383:
384: -- store SQL error message on message stack

Line 381: okc_debug.Reset_Indentation;

377: WHEN OTHERS THEN
378:
379: IF (l_debug = 'Y') THEN
380: okc_debug.log('1500: Exiting validate_optional_yn:OTHERS Exception', 2);
381: okc_debug.Reset_Indentation;
382: END IF;
383:
384: -- store SQL error message on message stack
385: OKC_API.SET_MESSAGE(

Line 412: okc_debug.Set_Indentation('OKC_RGR_PVT');

408:
409: BEGIN
410:
411: IF (l_debug = 'Y') THEN
412: okc_debug.Set_Indentation('OKC_RGR_PVT');
413: okc_debug.log('1600: Entered validate_min_cardinality', 2);
414: END IF;
415:
416: -- initialize return status

Line 413: okc_debug.log('1600: Entered validate_min_cardinality', 2);

409: BEGIN
410:
411: IF (l_debug = 'Y') THEN
412: okc_debug.Set_Indentation('OKC_RGR_PVT');
413: okc_debug.log('1600: Entered validate_min_cardinality', 2);
414: END IF;
415:
416: -- initialize return status
417: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 484: okc_debug.log('1700: Leaving validate_min_cardinality', 2);

480:
481: END IF; -- case 3
482:
483: IF (l_debug = 'Y') THEN
484: okc_debug.log('1700: Leaving validate_min_cardinality', 2);
485: okc_debug.Reset_Indentation;
486: END IF;
487:
488: EXCEPTION

Line 485: okc_debug.Reset_Indentation;

481: END IF; -- case 3
482:
483: IF (l_debug = 'Y') THEN
484: okc_debug.log('1700: Leaving validate_min_cardinality', 2);
485: okc_debug.Reset_Indentation;
486: END IF;
487:
488: EXCEPTION
489: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 492: okc_debug.log('1800: Exiting validate_min_cardinality:G_EXCEPTION_HALT_VALIDATION Exception', 2);

488: EXCEPTION
489: WHEN G_EXCEPTION_HALT_VALIDATION THEN
490:
491: IF (l_debug = 'Y') THEN
492: okc_debug.log('1800: Exiting validate_min_cardinality:G_EXCEPTION_HALT_VALIDATION Exception', 2);
493: okc_debug.Reset_Indentation;
494: END IF;
495:
496: -- no processing necessary; validation can continue with next column

Line 493: okc_debug.Reset_Indentation;

489: WHEN G_EXCEPTION_HALT_VALIDATION THEN
490:
491: IF (l_debug = 'Y') THEN
492: okc_debug.log('1800: Exiting validate_min_cardinality:G_EXCEPTION_HALT_VALIDATION Exception', 2);
493: okc_debug.Reset_Indentation;
494: END IF;
495:
496: -- no processing necessary; validation can continue with next column
497: NULL;

Line 501: okc_debug.log('1900: Exiting validate_min_cardinality:OTHERS Exception', 2);

497: NULL;
498: WHEN OTHERS THEN
499:
500: IF (l_debug = 'Y') THEN
501: okc_debug.log('1900: Exiting validate_min_cardinality:OTHERS Exception', 2);
502: okc_debug.Reset_Indentation;
503: END IF;
504:
505: -- store SQL error message on message stack

Line 502: okc_debug.Reset_Indentation;

498: WHEN OTHERS THEN
499:
500: IF (l_debug = 'Y') THEN
501: okc_debug.log('1900: Exiting validate_min_cardinality:OTHERS Exception', 2);
502: okc_debug.Reset_Indentation;
503: END IF;
504:
505: -- store SQL error message on message stack
506: OKC_API.SET_MESSAGE(

Line 535: okc_debug.Set_Indentation('OKC_RGR_PVT');

531: ) IS
532: BEGIN
533:
534: IF (l_debug = 'Y') THEN
535: okc_debug.Set_Indentation('OKC_RGR_PVT');
536: okc_debug.log('2000: Entered validate_pricing_related_yn', 2);
537: END IF;
538:
539: -- initialize return status

Line 536: okc_debug.log('2000: Entered validate_pricing_related_yn', 2);

532: BEGIN
533:
534: IF (l_debug = 'Y') THEN
535: okc_debug.Set_Indentation('OKC_RGR_PVT');
536: okc_debug.log('2000: Entered validate_pricing_related_yn', 2);
537: END IF;
538:
539: -- initialize return status
540: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 560: okc_debug.log('2100: Leaving validate_pricing_related_yn', 2);

556: END IF;
557: END IF;
558:
559: IF (l_debug = 'Y') THEN
560: okc_debug.log('2100: Leaving validate_pricing_related_yn', 2);
561: okc_debug.Reset_Indentation;
562: END IF;
563:
564: EXCEPTION

Line 561: okc_debug.Reset_Indentation;

557: END IF;
558:
559: IF (l_debug = 'Y') THEN
560: okc_debug.log('2100: Leaving validate_pricing_related_yn', 2);
561: okc_debug.Reset_Indentation;
562: END IF;
563:
564: EXCEPTION
565: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 568: okc_debug.log('2200: Exiting validate_pricing_related_yn:G_EXCEPTION_HALT_VALIDATION Exception', 2);

564: EXCEPTION
565: WHEN G_EXCEPTION_HALT_VALIDATION THEN
566:
567: IF (l_debug = 'Y') THEN
568: okc_debug.log('2200: Exiting validate_pricing_related_yn:G_EXCEPTION_HALT_VALIDATION Exception', 2);
569: okc_debug.Reset_Indentation;
570: END IF;
571:
572: -- no processing necessary; validation can continue with next column

Line 569: okc_debug.Reset_Indentation;

565: WHEN G_EXCEPTION_HALT_VALIDATION THEN
566:
567: IF (l_debug = 'Y') THEN
568: okc_debug.log('2200: Exiting validate_pricing_related_yn:G_EXCEPTION_HALT_VALIDATION Exception', 2);
569: okc_debug.Reset_Indentation;
570: END IF;
571:
572: -- no processing necessary; validation can continue with next column
573: NULL;

Line 577: okc_debug.log('2300: Exiting validate_pricing_related_yn:OTHERS Exception', 2);

573: NULL;
574: WHEN OTHERS THEN
575:
576: IF (l_debug = 'Y') THEN
577: okc_debug.log('2300: Exiting validate_pricing_related_yn:OTHERS Exception', 2);
578: okc_debug.Reset_Indentation;
579: END IF;
580:
581: -- store SQL error message on message stack

Line 578: okc_debug.Reset_Indentation;

574: WHEN OTHERS THEN
575:
576: IF (l_debug = 'Y') THEN
577: okc_debug.log('2300: Exiting validate_pricing_related_yn:OTHERS Exception', 2);
578: okc_debug.Reset_Indentation;
579: END IF;
580:
581: -- store SQL error message on message stack
582: OKC_API.SET_MESSAGE(

Line 622: okc_debug.Set_Indentation('OKC_RGR_PVT');

618:
619: BEGIN
620:
621: IF (l_debug = 'Y') THEN
622: okc_debug.Set_Indentation('OKC_RGR_PVT');
623: okc_debug.log('2400: Entered validate_access_level', 2);
624: END IF;
625:
626: -- initialize return status

Line 623: okc_debug.log('2400: Entered validate_access_level', 2);

619: BEGIN
620:
621: IF (l_debug = 'Y') THEN
622: okc_debug.Set_Indentation('OKC_RGR_PVT');
623: okc_debug.log('2400: Entered validate_access_level', 2);
624: END IF;
625:
626: -- initialize return status
627: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 654: okc_debug.log('2500: Leaving validate_access_level', 2);

650: END IF;
651: END IF;
652:
653: IF (l_debug = 'Y') THEN
654: okc_debug.log('2500: Leaving validate_access_level', 2);
655: okc_debug.Reset_Indentation;
656: END IF;
657:
658: EXCEPTION

Line 655: okc_debug.Reset_Indentation;

651: END IF;
652:
653: IF (l_debug = 'Y') THEN
654: okc_debug.log('2500: Leaving validate_access_level', 2);
655: okc_debug.Reset_Indentation;
656: END IF;
657:
658: EXCEPTION
659: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 662: okc_debug.log('2600: Exiting validate_access_level:G_EXCEPTION_HALT_VALIDATION Exception', 2);

658: EXCEPTION
659: WHEN G_EXCEPTION_HALT_VALIDATION THEN
660:
661: IF (l_debug = 'Y') THEN
662: okc_debug.log('2600: Exiting validate_access_level:G_EXCEPTION_HALT_VALIDATION Exception', 2);
663: okc_debug.Reset_Indentation;
664: END IF;
665:
666: -- no processing necessary; validation can continue with next column

Line 663: okc_debug.Reset_Indentation;

659: WHEN G_EXCEPTION_HALT_VALIDATION THEN
660:
661: IF (l_debug = 'Y') THEN
662: okc_debug.log('2600: Exiting validate_access_level:G_EXCEPTION_HALT_VALIDATION Exception', 2);
663: okc_debug.Reset_Indentation;
664: END IF;
665:
666: -- no processing necessary; validation can continue with next column
667: NULL;

Line 671: okc_debug.log('2700: Exiting validate_access_level:OTHERS Exception', 2);

667: NULL;
668: WHEN OTHERS THEN
669:
670: IF (l_debug = 'Y') THEN
671: okc_debug.log('2700: Exiting validate_access_level:OTHERS Exception', 2);
672: okc_debug.Reset_Indentation;
673: END IF;
674:
675: -- store SQL error message on message stack

Line 672: okc_debug.Reset_Indentation;

668: WHEN OTHERS THEN
669:
670: IF (l_debug = 'Y') THEN
671: okc_debug.log('2700: Exiting validate_access_level:OTHERS Exception', 2);
672: okc_debug.Reset_Indentation;
673: END IF;
674:
675: -- store SQL error message on message stack
676: OKC_API.SET_MESSAGE(

Line 708: okc_debug.Set_Indentation('OKC_RGR_PVT');

704: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
705: BEGIN
706:
707: IF (l_debug = 'Y') THEN
708: okc_debug.Set_Indentation('OKC_RGR_PVT');
709: okc_debug.log('2800: Entered Validate_Attributes', 2);
710: END IF;
711:
712: -- call each column-level validation

Line 709: okc_debug.log('2800: Entered Validate_Attributes', 2);

705: BEGIN
706:
707: IF (l_debug = 'Y') THEN
708: okc_debug.Set_Indentation('OKC_RGR_PVT');
709: okc_debug.log('2800: Entered Validate_Attributes', 2);
710: END IF;
711:
712: -- call each column-level validation
713:

Line 798: okc_debug.log('2900: Leaving Validate_Attributes', 2);

794: END IF;
795: END IF;
796: --
797: IF (l_debug = 'Y') THEN
798: okc_debug.log('2900: Leaving Validate_Attributes', 2);
799: okc_debug.Reset_Indentation;
800: END IF;
801:
802: -- return status to caller

Line 799: okc_debug.Reset_Indentation;

795: END IF;
796: --
797: IF (l_debug = 'Y') THEN
798: okc_debug.log('2900: Leaving Validate_Attributes', 2);
799: okc_debug.Reset_Indentation;
800: END IF;
801:
802: -- return status to caller
803: RETURN(x_return_status);

Line 809: okc_debug.log('3000: Exiting Validate_Attributes:OTHERS Exception', 2);

805: EXCEPTION
806: WHEN OTHERS THEN
807:
808: IF (l_debug = 'Y') THEN
809: okc_debug.log('3000: Exiting Validate_Attributes:OTHERS Exception', 2);
810: okc_debug.Reset_Indentation;
811: END IF;
812:
813: -- store SQL error message on message stack for caller

Line 810: okc_debug.Reset_Indentation;

806: WHEN OTHERS THEN
807:
808: IF (l_debug = 'Y') THEN
809: okc_debug.log('3000: Exiting Validate_Attributes:OTHERS Exception', 2);
810: okc_debug.Reset_Indentation;
811: END IF;
812:
813: -- store SQL error message on message stack for caller
814: OKC_API.SET_MESSAGE

Line 903: okc_debug.Set_Indentation('OKC_RGR_PVT');

899: l_rgr_rec rgr_rec_type;
900: BEGIN
901:
902: IF (l_debug = 'Y') THEN
903: okc_debug.Set_Indentation('OKC_RGR_PVT');
904: okc_debug.log('3500: Entered get_rec', 2);
905: END IF;
906:
907: x_no_data_found := TRUE;

Line 904: okc_debug.log('3500: Entered get_rec', 2);

900: BEGIN
901:
902: IF (l_debug = 'Y') THEN
903: okc_debug.Set_Indentation('OKC_RGR_PVT');
904: okc_debug.log('3500: Entered get_rec', 2);
905: END IF;
906:
907: x_no_data_found := TRUE;
908: -- Get current database values

Line 929: okc_debug.log('2900: Leaving Validate_Attributes', 2);

925: x_no_data_found := rgr_pk_csr%NOTFOUND;
926: CLOSE rgr_pk_csr;
927:
928: IF (l_debug = 'Y') THEN
929: okc_debug.log('2900: Leaving Validate_Attributes', 2);
930: okc_debug.Reset_Indentation;
931: END IF;
932:
933: RETURN(l_rgr_rec);

Line 930: okc_debug.Reset_Indentation;

926: CLOSE rgr_pk_csr;
927:
928: IF (l_debug = 'Y') THEN
929: okc_debug.log('2900: Leaving Validate_Attributes', 2);
930: okc_debug.Reset_Indentation;
931: END IF;
932:
933: RETURN(l_rgr_rec);
934:

Line 977: okc_debug.Set_Indentation('OKC_RGR_PVT');

973: l_rgrv_rec rgrv_rec_type;
974: BEGIN
975:
976: IF (l_debug = 'Y') THEN
977: okc_debug.Set_Indentation('OKC_RGR_PVT');
978: okc_debug.log('3700: Entered get_rec', 2);
979: END IF;
980:
981: x_no_data_found := TRUE;

Line 978: okc_debug.log('3700: Entered get_rec', 2);

974: BEGIN
975:
976: IF (l_debug = 'Y') THEN
977: okc_debug.Set_Indentation('OKC_RGR_PVT');
978: okc_debug.log('3700: Entered get_rec', 2);
979: END IF;
980:
981: x_no_data_found := TRUE;
982: -- Get current database values

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

999: x_no_data_found := okc_rgrv_pk_csr%NOTFOUND;
1000: CLOSE okc_rgrv_pk_csr;
1001:
1002: IF (l_debug = 'Y') THEN
1003: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
1004: okc_debug.Reset_Indentation;
1005: END IF;
1006:
1007: RETURN(l_rgrv_rec);

Line 1004: okc_debug.Reset_Indentation;

1000: CLOSE okc_rgrv_pk_csr;
1001:
1002: IF (l_debug = 'Y') THEN
1003: okc_debug.log('900: Leaving Fn Get_Rec ', 2);
1004: okc_debug.Reset_Indentation;
1005: END IF;
1006:
1007: RETURN(l_rgrv_rec);
1008:

Line 1031: okc_debug.Set_Indentation('OKC_RGR_PVT');

1027: l_rgrv_rec rgrv_rec_type := p_rgrv_rec;
1028: BEGIN
1029:
1030: IF (l_debug = 'Y') THEN
1031: okc_debug.Set_Indentation('OKC_RGR_PVT');
1032: okc_debug.log('3900: Entered null_out_defaults', 2);
1033: END IF;
1034:
1035: IF (l_rgrv_rec.rgd_code = OKC_API.G_MISS_CHAR) THEN

Line 1032: okc_debug.log('3900: Entered null_out_defaults', 2);

1028: BEGIN
1029:
1030: IF (l_debug = 'Y') THEN
1031: okc_debug.Set_Indentation('OKC_RGR_PVT');
1032: okc_debug.log('3900: Entered null_out_defaults', 2);
1033: END IF;
1034:
1035: IF (l_rgrv_rec.rgd_code = OKC_API.G_MISS_CHAR) THEN
1036: l_rgrv_rec.rgd_code := NULL;

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

1072: l_rgrv_rec.access_level := NULL;
1073: END IF;
1074:
1075: IF (l_debug = 'Y') THEN
1076: okc_debug.log('500: Leaving null_out_defaults ', 2);
1077: okc_debug.Reset_Indentation;
1078: END IF;
1079:
1080: RETURN(l_rgrv_rec);

Line 1077: okc_debug.Reset_Indentation;

1073: END IF;
1074:
1075: IF (l_debug = 'Y') THEN
1076: okc_debug.log('500: Leaving null_out_defaults ', 2);
1077: okc_debug.Reset_Indentation;
1078: END IF;
1079:
1080: RETURN(l_rgrv_rec);
1081:

Line 1097: okc_debug.Set_Indentation('OKC_RGR_PVT');

1093: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1094: BEGIN
1095:
1096: IF (l_debug = 'Y') THEN
1097: okc_debug.Set_Indentation('OKC_RGR_PVT');
1098: okc_debug.log('4000: Entered Validate_Attributes', 2);
1099: END IF;
1100:
1101: IF p_rgrv_rec.rgd_code = OKC_API.G_MISS_CHAR OR

Line 1098: okc_debug.log('4000: Entered Validate_Attributes', 2);

1094: BEGIN
1095:
1096: IF (l_debug = 'Y') THEN
1097: okc_debug.Set_Indentation('OKC_RGR_PVT');
1098: okc_debug.log('4000: Entered Validate_Attributes', 2);
1099: END IF;
1100:
1101: IF p_rgrv_rec.rgd_code = OKC_API.G_MISS_CHAR OR
1102: p_rgrv_rec.rgd_code IS NULL

Line 1205: okc_debug.Set_Indentation('OKC_RGR_PVT');

1201: l_rgr_rec rgr_rec_type;
1202: BEGIN
1203:
1204: IF (l_debug = 'Y') THEN
1205: okc_debug.Set_Indentation('OKC_RGR_PVT');
1206: okc_debug.log('4400: Entered validate_row', 2);
1207: END IF;
1208:
1209: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1206: okc_debug.log('4400: Entered validate_row', 2);

1202: BEGIN
1203:
1204: IF (l_debug = 'Y') THEN
1205: okc_debug.Set_Indentation('OKC_RGR_PVT');
1206: okc_debug.log('4400: Entered validate_row', 2);
1207: END IF;
1208:
1209: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1210: G_PKG_NAME,

Line 1238: okc_debug.log('4500: Leaving validate_row', 2);

1234: END IF;
1235: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1236:
1237: IF (l_debug = 'Y') THEN
1238: okc_debug.log('4500: Leaving validate_row', 2);
1239: okc_debug.Reset_Indentation;
1240: END IF;
1241:
1242: EXCEPTION

Line 1239: okc_debug.Reset_Indentation;

1235: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1236:
1237: IF (l_debug = 'Y') THEN
1238: okc_debug.log('4500: Leaving validate_row', 2);
1239: okc_debug.Reset_Indentation;
1240: END IF;
1241:
1242: EXCEPTION
1243: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

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

Line 1247: okc_debug.Reset_Indentation;

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

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

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

Line 1263: okc_debug.Reset_Indentation;

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

Line 1278: okc_debug.log('4800: Exiting validate_row:OTHERS Exception', 2);

1274: );
1275: WHEN OTHERS THEN
1276:
1277: IF (l_debug = 'Y') THEN
1278: okc_debug.log('4800: Exiting validate_row:OTHERS Exception', 2);
1279: okc_debug.Reset_Indentation;
1280: END IF;
1281:
1282: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1279: okc_debug.Reset_Indentation;

1275: WHEN OTHERS THEN
1276:
1277: IF (l_debug = 'Y') THEN
1278: okc_debug.log('4800: Exiting validate_row:OTHERS Exception', 2);
1279: okc_debug.Reset_Indentation;
1280: END IF;
1281:
1282: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1283: (

Line 1311: okc_debug.Set_Indentation('OKC_RGR_PVT');

1307: i NUMBER := 0;
1308: BEGIN
1309:
1310: IF (l_debug = 'Y') THEN
1311: okc_debug.Set_Indentation('OKC_RGR_PVT');
1312: okc_debug.log('4900: Entered validate_row', 2);
1313: END IF;
1314:
1315: OKC_API.init_msg_list(p_init_msg_list);

Line 1312: okc_debug.log('4900: Entered validate_row', 2);

1308: BEGIN
1309:
1310: IF (l_debug = 'Y') THEN
1311: okc_debug.Set_Indentation('OKC_RGR_PVT');
1312: okc_debug.log('4900: Entered validate_row', 2);
1313: END IF;
1314:
1315: OKC_API.init_msg_list(p_init_msg_list);
1316: -- Make sure PL/SQL table has records in it before passing

Line 1333: okc_debug.log('5000: Leaving validate_row', 2);

1329: END LOOP;
1330: END IF;
1331:
1332: IF (l_debug = 'Y') THEN
1333: okc_debug.log('5000: Leaving validate_row', 2);
1334: okc_debug.Reset_Indentation;
1335: END IF;
1336:
1337: EXCEPTION

Line 1334: okc_debug.Reset_Indentation;

1330: END IF;
1331:
1332: IF (l_debug = 'Y') THEN
1333: okc_debug.log('5000: Leaving validate_row', 2);
1334: okc_debug.Reset_Indentation;
1335: END IF;
1336:
1337: EXCEPTION
1338: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1337: EXCEPTION
1338: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1339:
1340: IF (l_debug = 'Y') THEN
1341: okc_debug.log('5100: Exiting validate_row:OKC_API.G_EXCEPTION_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_ERROR THEN
1339:
1340: IF (l_debug = 'Y') THEN
1341: okc_debug.log('5100: Exiting validate_row:OKC_API.G_EXCEPTION_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('5200: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1353: );
1354: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1355:
1356: IF (l_debug = 'Y') THEN
1357: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR 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 OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1355:
1356: IF (l_debug = 'Y') THEN
1357: okc_debug.log('5200: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1358: okc_debug.Reset_Indentation;
1359: END IF;
1360:
1361: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1362: (

Line 1373: okc_debug.log('5300: Exiting validate_row:OTHERS Exception', 2);

1369: );
1370: WHEN OTHERS THEN
1371:
1372: IF (l_debug = 'Y') THEN
1373: okc_debug.log('5300: Exiting validate_row:OTHERS Exception', 2);
1374: okc_debug.Reset_Indentation;
1375: END IF;
1376:
1377: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1374: okc_debug.Reset_Indentation;

1370: WHEN OTHERS THEN
1371:
1372: IF (l_debug = 'Y') THEN
1373: okc_debug.log('5300: Exiting validate_row:OTHERS Exception', 2);
1374: okc_debug.Reset_Indentation;
1375: END IF;
1376:
1377: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1378: (

Line 1425: okc_debug.Set_Indentation('OKC_RGR_PVT');

1421: END Set_Attributes;
1422: BEGIN
1423:
1424: IF (l_debug = 'Y') THEN
1425: okc_debug.Set_Indentation('OKC_RGR_PVT');
1426: okc_debug.log('5500: Entered insert_row', 2);
1427: END IF;
1428:
1429: g_insert_mode := TRUE;

Line 1426: okc_debug.log('5500: Entered insert_row', 2);

1422: BEGIN
1423:
1424: IF (l_debug = 'Y') THEN
1425: okc_debug.Set_Indentation('OKC_RGR_PVT');
1426: okc_debug.log('5500: Entered insert_row', 2);
1427: END IF;
1428:
1429: g_insert_mode := TRUE;
1430: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1484: okc_debug.log('5600: Leaving insert_row', 2);

1480: x_rgr_rec := l_rgr_rec;
1481: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1482:
1483: IF (l_debug = 'Y') THEN
1484: okc_debug.log('5600: Leaving insert_row', 2);
1485: okc_debug.Reset_Indentation;
1486: END IF;
1487:
1488: EXCEPTION

Line 1485: okc_debug.Reset_Indentation;

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

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

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

Line 1493: okc_debug.Reset_Indentation;

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

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

1504: );
1505: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1506:
1507: IF (l_debug = 'Y') THEN
1508: okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1509: okc_debug.Reset_Indentation;
1510: END IF;
1511:
1512: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1509: okc_debug.Reset_Indentation;

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

Line 1524: okc_debug.log('5900: Exiting insert_row:OTHERS Exception', 2);

1520: );
1521: WHEN OTHERS THEN
1522:
1523: IF (l_debug = 'Y') THEN
1524: okc_debug.log('5900: Exiting insert_row:OTHERS Exception', 2);
1525: okc_debug.Reset_Indentation;
1526: END IF;
1527:
1528: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1525: okc_debug.Reset_Indentation;

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

Line 1593: okc_debug.Set_Indentation('OKC_RGR_PVT');

1589: END Set_Attributes;
1590: BEGIN
1591:
1592: IF (l_debug = 'Y') THEN
1593: okc_debug.Set_Indentation('OKC_RGR_PVT');
1594: okc_debug.log('6200: Entered insert_row', 2);
1595: END IF;
1596:
1597: g_insert_mode := TRUE;

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

1590: BEGIN
1591:
1592: IF (l_debug = 'Y') THEN
1593: okc_debug.Set_Indentation('OKC_RGR_PVT');
1594: okc_debug.log('6200: Entered insert_row', 2);
1595: END IF;
1596:
1597: g_insert_mode := TRUE;
1598: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1658: x_rgrv_rec := l_def_rgrv_rec;
1659: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1660:
1661: IF (l_debug = 'Y') THEN
1662: okc_debug.log('6300: Leaving insert_row', 2);
1663: okc_debug.Reset_Indentation;
1664: END IF;
1665:
1666: EXCEPTION

Line 1663: okc_debug.Reset_Indentation;

1659: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1660:
1661: IF (l_debug = 'Y') THEN
1662: okc_debug.log('6300: Leaving insert_row', 2);
1663: okc_debug.Reset_Indentation;
1664: END IF;
1665:
1666: EXCEPTION
1667: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

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

Line 1671: okc_debug.Reset_Indentation;

1667: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1668:
1669: IF (l_debug = 'Y') THEN
1670: okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1671: okc_debug.Reset_Indentation;
1672: END IF;
1673:
1674: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1675: (

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

1682: );
1683: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1684:
1685: IF (l_debug = 'Y') THEN
1686: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1687: okc_debug.Reset_Indentation;
1688: END IF;
1689:
1690: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1687: okc_debug.Reset_Indentation;

1683: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1684:
1685: IF (l_debug = 'Y') THEN
1686: okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1687: okc_debug.Reset_Indentation;
1688: END IF;
1689:
1690: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1691: (

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

1698: );
1699: WHEN OTHERS THEN
1700:
1701: IF (l_debug = 'Y') THEN
1702: okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);
1703: okc_debug.Reset_Indentation;
1704: END IF;
1705:
1706: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1703: okc_debug.Reset_Indentation;

1699: WHEN OTHERS THEN
1700:
1701: IF (l_debug = 'Y') THEN
1702: okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);
1703: okc_debug.Reset_Indentation;
1704: END IF;
1705:
1706: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1707: (

Line 1736: okc_debug.Set_Indentation('OKC_RGR_PVT');

1732: i NUMBER := 0;
1733: BEGIN
1734:
1735: IF (l_debug = 'Y') THEN
1736: okc_debug.Set_Indentation('OKC_RGR_PVT');
1737: okc_debug.log('6700: Entered insert_row', 2);
1738: END IF;
1739:
1740: OKC_API.init_msg_list(p_init_msg_list);

Line 1737: okc_debug.log('6700: Entered insert_row', 2);

1733: BEGIN
1734:
1735: IF (l_debug = 'Y') THEN
1736: okc_debug.Set_Indentation('OKC_RGR_PVT');
1737: okc_debug.log('6700: Entered insert_row', 2);
1738: END IF;
1739:
1740: OKC_API.init_msg_list(p_init_msg_list);
1741: -- Make sure PL/SQL table has records in it before passing

Line 1759: okc_debug.log('6800: Leaving insert_row', 2);

1755: END LOOP;
1756: END IF;
1757:
1758: IF (l_debug = 'Y') THEN
1759: okc_debug.log('6800: Leaving insert_row', 2);
1760: okc_debug.Reset_Indentation;
1761: END IF;
1762:
1763: EXCEPTION

Line 1760: okc_debug.Reset_Indentation;

1756: END IF;
1757:
1758: IF (l_debug = 'Y') THEN
1759: okc_debug.log('6800: Leaving insert_row', 2);
1760: okc_debug.Reset_Indentation;
1761: END IF;
1762:
1763: EXCEPTION
1764: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1763: EXCEPTION
1764: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1765:
1766: IF (l_debug = 'Y') THEN
1767: okc_debug.log('6900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1768: okc_debug.Reset_Indentation;
1769: END IF;
1770:
1771: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1768: okc_debug.Reset_Indentation;

1764: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1765:
1766: IF (l_debug = 'Y') THEN
1767: okc_debug.log('6900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1768: okc_debug.Reset_Indentation;
1769: END IF;
1770:
1771: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1772: (

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

1779: );
1780: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1781:
1782: IF (l_debug = 'Y') THEN
1783: okc_debug.log('7000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1784: okc_debug.Reset_Indentation;
1785: END IF;
1786:
1787: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1784: okc_debug.Reset_Indentation;

1780: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1781:
1782: IF (l_debug = 'Y') THEN
1783: okc_debug.log('7000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1784: okc_debug.Reset_Indentation;
1785: END IF;
1786:
1787: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1788: (

Line 1799: okc_debug.log('7100: Exiting insert_row:OTHERS Exception', 2);

1795: );
1796: WHEN OTHERS THEN
1797:
1798: IF (l_debug = 'Y') THEN
1799: okc_debug.log('7100: Exiting insert_row:OTHERS 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 OTHERS THEN
1797:
1798: IF (l_debug = 'Y') THEN
1799: okc_debug.log('7100: Exiting insert_row:OTHERS Exception', 2);
1800: okc_debug.Reset_Indentation;
1801: END IF;
1802:
1803: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1804: (

Line 1853: okc_debug.Set_Indentation('OKC_RGR_PVT');

1849: lc_row_notfound BOOLEAN := FALSE;
1850: BEGIN
1851:
1852: IF (l_debug = 'Y') THEN
1853: okc_debug.Set_Indentation('OKC_RGR_PVT');
1854: okc_debug.log('7200: Entered lock_row', 2);
1855: END IF;
1856:
1857: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1854: okc_debug.log('7200: Entered lock_row', 2);

1850: BEGIN
1851:
1852: IF (l_debug = 'Y') THEN
1853: okc_debug.Set_Indentation('OKC_RGR_PVT');
1854: okc_debug.log('7200: Entered lock_row', 2);
1855: END IF;
1856:
1857: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1858: p_init_msg_list,

Line 1869: okc_debug.Set_Indentation('OKC_RGR_PVT');

1865: END IF;
1866: BEGIN
1867:
1868: IF (l_debug = 'Y') THEN
1869: okc_debug.Set_Indentation('OKC_RGR_PVT');
1870: okc_debug.log('7300: Entered lock_row', 2);
1871: END IF;
1872:
1873: OPEN lock_csr(p_rgr_rec);

Line 1870: okc_debug.log('7300: Entered lock_row', 2);

1866: BEGIN
1867:
1868: IF (l_debug = 'Y') THEN
1869: okc_debug.Set_Indentation('OKC_RGR_PVT');
1870: okc_debug.log('7300: Entered lock_row', 2);
1871: END IF;
1872:
1873: OPEN lock_csr(p_rgr_rec);
1874: FETCH lock_csr INTO l_object_version_number;

Line 1879: okc_debug.log('7400: Leaving lock_row', 2);

1875: l_row_notfound := lock_csr%NOTFOUND;
1876: CLOSE lock_csr;
1877:
1878: IF (l_debug = 'Y') THEN
1879: okc_debug.log('7400: Leaving lock_row', 2);
1880: okc_debug.Reset_Indentation;
1881: END IF;
1882:
1883: EXCEPTION

Line 1880: okc_debug.Reset_Indentation;

1876: CLOSE lock_csr;
1877:
1878: IF (l_debug = 'Y') THEN
1879: okc_debug.log('7400: Leaving lock_row', 2);
1880: okc_debug.Reset_Indentation;
1881: END IF;
1882:
1883: EXCEPTION
1884: WHEN E_Resource_Busy THEN

Line 1887: okc_debug.log('7500: Exiting lock_row:E_Resource_Busy Exception', 2);

1883: EXCEPTION
1884: WHEN E_Resource_Busy THEN
1885:
1886: IF (l_debug = 'Y') THEN
1887: okc_debug.log('7500: Exiting lock_row:E_Resource_Busy Exception', 2);
1888: okc_debug.Reset_Indentation;
1889: END IF;
1890:
1891: IF (lock_csr%ISOPEN) THEN

Line 1888: okc_debug.Reset_Indentation;

1884: WHEN E_Resource_Busy THEN
1885:
1886: IF (l_debug = 'Y') THEN
1887: okc_debug.log('7500: Exiting lock_row:E_Resource_Busy Exception', 2);
1888: okc_debug.Reset_Indentation;
1889: END IF;
1890:
1891: IF (lock_csr%ISOPEN) THEN
1892: CLOSE lock_csr;

Line 1920: okc_debug.log('7600: Leaving lock_row', 2);

1916: END IF;
1917: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1918:
1919: IF (l_debug = 'Y') THEN
1920: okc_debug.log('7600: Leaving lock_row', 2);
1921: okc_debug.Reset_Indentation;
1922: END IF;
1923:
1924: EXCEPTION

Line 1921: okc_debug.Reset_Indentation;

1917: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1918:
1919: IF (l_debug = 'Y') THEN
1920: okc_debug.log('7600: Leaving lock_row', 2);
1921: okc_debug.Reset_Indentation;
1922: END IF;
1923:
1924: EXCEPTION
1925: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

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

Line 1929: okc_debug.Reset_Indentation;

1925: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1926:
1927: IF (l_debug = 'Y') THEN
1928: okc_debug.log('7700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1929: okc_debug.Reset_Indentation;
1930: END IF;
1931:
1932: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1933: (

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

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

Line 1945: okc_debug.Reset_Indentation;

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

Line 1960: okc_debug.log('7900: Exiting lock_row:OTHERS Exception', 2);

1956: );
1957: WHEN OTHERS THEN
1958:
1959: IF (l_debug = 'Y') THEN
1960: okc_debug.log('7900: Exiting lock_row:OTHERS Exception', 2);
1961: okc_debug.Reset_Indentation;
1962: END IF;
1963:
1964: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1961: okc_debug.Reset_Indentation;

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

Line 1993: okc_debug.Set_Indentation('OKC_RGR_PVT');

1989: l_rgr_rec rgr_rec_type;
1990: BEGIN
1991:
1992: IF (l_debug = 'Y') THEN
1993: okc_debug.Set_Indentation('OKC_RGR_PVT');
1994: okc_debug.log('8000: Entered lock_row', 2);
1995: END IF;
1996:
1997: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1990: BEGIN
1991:
1992: IF (l_debug = 'Y') THEN
1993: okc_debug.Set_Indentation('OKC_RGR_PVT');
1994: okc_debug.log('8000: Entered lock_row', 2);
1995: END IF;
1996:
1997: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1998: G_PKG_NAME,

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

2027: END IF;
2028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2029:
2030: IF (l_debug = 'Y') THEN
2031: okc_debug.log('8100: Leaving lock_row', 2);
2032: okc_debug.Reset_Indentation;
2033: END IF;
2034:
2035: EXCEPTION

Line 2032: okc_debug.Reset_Indentation;

2028: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2029:
2030: IF (l_debug = 'Y') THEN
2031: okc_debug.log('8100: Leaving lock_row', 2);
2032: okc_debug.Reset_Indentation;
2033: END IF;
2034:
2035: EXCEPTION
2036: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

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

Line 2040: okc_debug.Reset_Indentation;

2036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2037:
2038: IF (l_debug = 'Y') THEN
2039: okc_debug.log('8200: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2040: okc_debug.Reset_Indentation;
2041: END IF;
2042:
2043: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2044: (

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

2051: );
2052: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2053:
2054: IF (l_debug = 'Y') THEN
2055: okc_debug.log('8300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2056: okc_debug.Reset_Indentation;
2057: END IF;
2058:
2059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2056: okc_debug.Reset_Indentation;

2052: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2053:
2054: IF (l_debug = 'Y') THEN
2055: okc_debug.log('8300: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2056: okc_debug.Reset_Indentation;
2057: END IF;
2058:
2059: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2060: (

Line 2071: okc_debug.log('8400: Exiting lock_row:OTHERS Exception', 2);

2067: );
2068: WHEN OTHERS THEN
2069:
2070: IF (l_debug = 'Y') THEN
2071: okc_debug.log('8400: Exiting lock_row:OTHERS Exception', 2);
2072: okc_debug.Reset_Indentation;
2073: END IF;
2074:
2075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2072: okc_debug.Reset_Indentation;

2068: WHEN OTHERS THEN
2069:
2070: IF (l_debug = 'Y') THEN
2071: okc_debug.log('8400: Exiting lock_row:OTHERS Exception', 2);
2072: okc_debug.Reset_Indentation;
2073: END IF;
2074:
2075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2076: (

Line 2104: okc_debug.Set_Indentation('OKC_RGR_PVT');

2100: i NUMBER := 0;
2101: BEGIN
2102:
2103: IF (l_debug = 'Y') THEN
2104: okc_debug.Set_Indentation('OKC_RGR_PVT');
2105: okc_debug.log('8500: Entered lock_row', 2);
2106: END IF;
2107:
2108: OKC_API.init_msg_list(p_init_msg_list);

Line 2105: okc_debug.log('8500: Entered lock_row', 2);

2101: BEGIN
2102:
2103: IF (l_debug = 'Y') THEN
2104: okc_debug.Set_Indentation('OKC_RGR_PVT');
2105: okc_debug.log('8500: Entered lock_row', 2);
2106: END IF;
2107:
2108: OKC_API.init_msg_list(p_init_msg_list);
2109: -- Make sure PL/SQL table has records in it before passing

Line 2126: okc_debug.log('8600: Leaving lock_row', 2);

2122: END LOOP;
2123: END IF;
2124:
2125: IF (l_debug = 'Y') THEN
2126: okc_debug.log('8600: Leaving lock_row', 2);
2127: okc_debug.Reset_Indentation;
2128: END IF;
2129:
2130: EXCEPTION

Line 2127: okc_debug.Reset_Indentation;

2123: END IF;
2124:
2125: IF (l_debug = 'Y') THEN
2126: okc_debug.log('8600: Leaving lock_row', 2);
2127: okc_debug.Reset_Indentation;
2128: END IF;
2129:
2130: EXCEPTION
2131: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2130: EXCEPTION
2131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2132:
2133: IF (l_debug = 'Y') THEN
2134: okc_debug.log('8700: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2135: okc_debug.Reset_Indentation;
2136: END IF;
2137:
2138: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2135: okc_debug.Reset_Indentation;

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

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

2146: );
2147: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2148:
2149: IF (l_debug = 'Y') THEN
2150: okc_debug.log('8800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2151: okc_debug.Reset_Indentation;
2152: END IF;
2153:
2154: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2151: okc_debug.Reset_Indentation;

2147: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2148:
2149: IF (l_debug = 'Y') THEN
2150: okc_debug.log('8800: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2151: okc_debug.Reset_Indentation;
2152: END IF;
2153:
2154: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2155: (

Line 2166: okc_debug.log('8900: Exiting lock_row:OTHERS Exception', 2);

2162: );
2163: WHEN OTHERS THEN
2164:
2165: IF (l_debug = 'Y') THEN
2166: okc_debug.log('8900: Exiting lock_row:OTHERS Exception', 2);
2167: okc_debug.Reset_Indentation;
2168: END IF;
2169:
2170: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2167: okc_debug.Reset_Indentation;

2163: WHEN OTHERS THEN
2164:
2165: IF (l_debug = 'Y') THEN
2166: okc_debug.log('8900: Exiting lock_row:OTHERS Exception', 2);
2167: okc_debug.Reset_Indentation;
2168: END IF;
2169:
2170: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2171: (

Line 2215: okc_debug.Set_Indentation('OKC_RGR_PVT');

2211: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2212: BEGIN
2213:
2214: IF (l_debug = 'Y') THEN
2215: okc_debug.Set_Indentation('OKC_RGR_PVT');
2216: okc_debug.log('9000: Entered populate_new_record', 2);
2217: END IF;
2218:
2219: x_rgr_rec := p_rgr_rec;

Line 2216: okc_debug.log('9000: Entered populate_new_record', 2);

2212: BEGIN
2213:
2214: IF (l_debug = 'Y') THEN
2215: okc_debug.Set_Indentation('OKC_RGR_PVT');
2216: okc_debug.log('9000: Entered populate_new_record', 2);
2217: END IF;
2218:
2219: x_rgr_rec := p_rgr_rec;
2220: -- Get current database values

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

2275: x_rgr_rec.access_level := l_rgr_rec.access_level;
2276: END IF;
2277:
2278: IF (l_debug = 'Y') THEN
2279: okc_debug.log('11950: Leaving populate_new_record ', 2);
2280: okc_debug.Reset_Indentation;
2281: END IF;
2282:
2283: RETURN(l_return_status);

Line 2280: okc_debug.Reset_Indentation;

2276: END IF;
2277:
2278: IF (l_debug = 'Y') THEN
2279: okc_debug.log('11950: Leaving populate_new_record ', 2);
2280: okc_debug.Reset_Indentation;
2281: END IF;
2282:
2283: RETURN(l_return_status);
2284:

Line 2303: okc_debug.Set_Indentation('OKC_RGR_PVT');

2299: END Set_Attributes;
2300: BEGIN
2301:
2302: IF (l_debug = 'Y') THEN
2303: okc_debug.Set_Indentation('OKC_RGR_PVT');
2304: okc_debug.log('9200: Entered update_row', 2);
2305: END IF;
2306:
2307: g_insert_mode := FALSE;

Line 2304: okc_debug.log('9200: Entered update_row', 2);

2300: BEGIN
2301:
2302: IF (l_debug = 'Y') THEN
2303: okc_debug.Set_Indentation('OKC_RGR_PVT');
2304: okc_debug.log('9200: Entered update_row', 2);
2305: END IF;
2306:
2307: g_insert_mode := FALSE;
2308: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2352: okc_debug.log('9300: Leaving update_row', 2);

2348: x_rgr_rec := l_def_rgr_rec;
2349: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2350:
2351: IF (l_debug = 'Y') THEN
2352: okc_debug.log('9300: Leaving update_row', 2);
2353: okc_debug.Reset_Indentation;
2354: END IF;
2355:
2356: EXCEPTION

Line 2353: okc_debug.Reset_Indentation;

2349: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2350:
2351: IF (l_debug = 'Y') THEN
2352: okc_debug.log('9300: Leaving update_row', 2);
2353: okc_debug.Reset_Indentation;
2354: END IF;
2355:
2356: EXCEPTION
2357: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2356: EXCEPTION
2357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2358:
2359: IF (l_debug = 'Y') THEN
2360: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2361: okc_debug.Reset_Indentation;
2362: END IF;
2363:
2364: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2361: okc_debug.Reset_Indentation;

2357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2358:
2359: IF (l_debug = 'Y') THEN
2360: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2361: okc_debug.Reset_Indentation;
2362: END IF;
2363:
2364: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2365: (

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

2372: );
2373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2374:
2375: IF (l_debug = 'Y') THEN
2376: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2377: okc_debug.Reset_Indentation;
2378: END IF;
2379:
2380: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2377: okc_debug.Reset_Indentation;

2373: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2374:
2375: IF (l_debug = 'Y') THEN
2376: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2377: okc_debug.Reset_Indentation;
2378: END IF;
2379:
2380: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2381: (

Line 2392: okc_debug.log('9600: Exiting update_row:OTHERS Exception', 2);

2388: );
2389: WHEN OTHERS THEN
2390:
2391: IF (l_debug = 'Y') THEN
2392: okc_debug.log('9600: Exiting update_row:OTHERS Exception', 2);
2393: okc_debug.Reset_Indentation;
2394: END IF;
2395:
2396: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2393: okc_debug.Reset_Indentation;

2389: WHEN OTHERS THEN
2390:
2391: IF (l_debug = 'Y') THEN
2392: okc_debug.log('9600: Exiting update_row:OTHERS Exception', 2);
2393: okc_debug.Reset_Indentation;
2394: END IF;
2395:
2396: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2397: (

Line 2454: okc_debug.Set_Indentation('OKC_RGR_PVT');

2450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2451: BEGIN
2452:
2453: IF (l_debug = 'Y') THEN
2454: okc_debug.Set_Indentation('OKC_RGR_PVT');
2455: okc_debug.log('9800: Entered populate_new_record', 2);
2456: END IF;
2457:
2458: x_rgrv_rec := p_rgrv_rec;

Line 2455: okc_debug.log('9800: Entered populate_new_record', 2);

2451: BEGIN
2452:
2453: IF (l_debug = 'Y') THEN
2454: okc_debug.Set_Indentation('OKC_RGR_PVT');
2455: okc_debug.log('9800: Entered populate_new_record', 2);
2456: END IF;
2457:
2458: x_rgrv_rec := p_rgrv_rec;
2459: -- Get current database values

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

2514: x_rgrv_rec.access_level := l_rgrv_rec.access_level;
2515: END IF;
2516:
2517: IF (l_debug = 'Y') THEN
2518: okc_debug.log('11950: Leaving populate_new_record ', 2);
2519: okc_debug.Reset_Indentation;
2520: END IF;
2521:
2522: RETURN(l_return_status);

Line 2519: okc_debug.Reset_Indentation;

2515: END IF;
2516:
2517: IF (l_debug = 'Y') THEN
2518: okc_debug.log('11950: Leaving populate_new_record ', 2);
2519: okc_debug.Reset_Indentation;
2520: END IF;
2521:
2522: RETURN(l_return_status);
2523:

Line 2612: okc_debug.log('10100: Leaving update_row', 2);

2608: x_rgrv_rec := l_def_rgrv_rec;
2609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2610:
2611: IF (l_debug = 'Y') THEN
2612: okc_debug.log('10100: Leaving update_row', 2);
2613: okc_debug.Reset_Indentation;
2614: END IF;
2615:
2616: EXCEPTION

Line 2613: okc_debug.Reset_Indentation;

2609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2610:
2611: IF (l_debug = 'Y') THEN
2612: okc_debug.log('10100: Leaving update_row', 2);
2613: okc_debug.Reset_Indentation;
2614: END IF;
2615:
2616: EXCEPTION
2617: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2616: EXCEPTION
2617: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2618:
2619: IF (l_debug = 'Y') THEN
2620: okc_debug.log('10200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2621: okc_debug.Reset_Indentation;
2622: END IF;
2623:
2624: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2621: okc_debug.Reset_Indentation;

2617: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2618:
2619: IF (l_debug = 'Y') THEN
2620: okc_debug.log('10200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2621: okc_debug.Reset_Indentation;
2622: END IF;
2623:
2624: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2625: (

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

2632: );
2633: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2634:
2635: IF (l_debug = 'Y') THEN
2636: okc_debug.log('10300: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2637: okc_debug.Reset_Indentation;
2638: END IF;
2639:
2640: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2637: okc_debug.Reset_Indentation;

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

Line 2652: okc_debug.log('10400: Exiting update_row:OTHERS Exception', 2);

2648: );
2649: WHEN OTHERS THEN
2650:
2651: IF (l_debug = 'Y') THEN
2652: okc_debug.log('10400: Exiting update_row:OTHERS Exception', 2);
2653: okc_debug.Reset_Indentation;
2654: END IF;
2655:
2656: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2653: okc_debug.Reset_Indentation;

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

Line 2686: okc_debug.Set_Indentation('OKC_RGR_PVT');

2682: i NUMBER := 0;
2683: BEGIN
2684:
2685: IF (l_debug = 'Y') THEN
2686: okc_debug.Set_Indentation('OKC_RGR_PVT');
2687: okc_debug.log('10500: Entered update_row', 2);
2688: END IF;
2689:
2690: OKC_API.init_msg_list(p_init_msg_list);

Line 2687: okc_debug.log('10500: Entered update_row', 2);

2683: BEGIN
2684:
2685: IF (l_debug = 'Y') THEN
2686: okc_debug.Set_Indentation('OKC_RGR_PVT');
2687: okc_debug.log('10500: Entered update_row', 2);
2688: END IF;
2689:
2690: OKC_API.init_msg_list(p_init_msg_list);
2691: -- Make sure PL/SQL table has records in it before passing

Line 2709: okc_debug.log('10600: Leaving update_row', 2);

2705: END LOOP;
2706: END IF;
2707:
2708: IF (l_debug = 'Y') THEN
2709: okc_debug.log('10600: Leaving update_row', 2);
2710: okc_debug.Reset_Indentation;
2711: END IF;
2712:
2713: EXCEPTION

Line 2710: okc_debug.Reset_Indentation;

2706: END IF;
2707:
2708: IF (l_debug = 'Y') THEN
2709: okc_debug.log('10600: Leaving update_row', 2);
2710: okc_debug.Reset_Indentation;
2711: END IF;
2712:
2713: EXCEPTION
2714: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2713: EXCEPTION
2714: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2715:
2716: IF (l_debug = 'Y') THEN
2717: okc_debug.log('10700: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2718: okc_debug.Reset_Indentation;
2719: END IF;
2720:
2721: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2718: okc_debug.Reset_Indentation;

2714: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2715:
2716: IF (l_debug = 'Y') THEN
2717: okc_debug.log('10700: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2718: okc_debug.Reset_Indentation;
2719: END IF;
2720:
2721: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2722: (

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

2729: );
2730: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2731:
2732: IF (l_debug = 'Y') THEN
2733: okc_debug.log('10800: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2734: okc_debug.Reset_Indentation;
2735: END IF;
2736:
2737: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2734: okc_debug.Reset_Indentation;

2730: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2731:
2732: IF (l_debug = 'Y') THEN
2733: okc_debug.log('10800: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2734: okc_debug.Reset_Indentation;
2735: END IF;
2736:
2737: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2738: (

Line 2749: okc_debug.log('10900: Exiting update_row:OTHERS Exception', 2);

2745: );
2746: WHEN OTHERS THEN
2747:
2748: IF (l_debug = 'Y') THEN
2749: okc_debug.log('10900: Exiting update_row:OTHERS Exception', 2);
2750: okc_debug.Reset_Indentation;
2751: END IF;
2752:
2753: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2750: okc_debug.Reset_Indentation;

2746: WHEN OTHERS THEN
2747:
2748: IF (l_debug = 'Y') THEN
2749: okc_debug.log('10900: Exiting update_row:OTHERS Exception', 2);
2750: okc_debug.Reset_Indentation;
2751: END IF;
2752:
2753: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2754: (

Line 2786: okc_debug.Set_Indentation('OKC_RGR_PVT');

2782: l_row_notfound BOOLEAN := TRUE;
2783: BEGIN
2784:
2785: IF (l_debug = 'Y') THEN
2786: okc_debug.Set_Indentation('OKC_RGR_PVT');
2787: okc_debug.log('11000: Entered delete_row', 2);
2788: END IF;
2789:
2790: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2787: okc_debug.log('11000: Entered delete_row', 2);

2783: BEGIN
2784:
2785: IF (l_debug = 'Y') THEN
2786: okc_debug.Set_Indentation('OKC_RGR_PVT');
2787: okc_debug.log('11000: Entered delete_row', 2);
2788: END IF;
2789:
2790: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2791: p_init_msg_list,

Line 2806: okc_debug.log('11100: Leaving delete_row', 2);

2802:
2803: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2804:
2805: IF (l_debug = 'Y') THEN
2806: okc_debug.log('11100: Leaving delete_row', 2);
2807: okc_debug.Reset_Indentation;
2808: END IF;
2809:
2810: EXCEPTION

Line 2807: okc_debug.Reset_Indentation;

2803: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2804:
2805: IF (l_debug = 'Y') THEN
2806: okc_debug.log('11100: Leaving delete_row', 2);
2807: okc_debug.Reset_Indentation;
2808: END IF;
2809:
2810: EXCEPTION
2811: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2810: EXCEPTION
2811: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2812:
2813: IF (l_debug = 'Y') THEN
2814: okc_debug.log('11200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2815: okc_debug.Reset_Indentation;
2816: END IF;
2817:
2818: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2815: okc_debug.Reset_Indentation;

2811: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2812:
2813: IF (l_debug = 'Y') THEN
2814: okc_debug.log('11200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2815: okc_debug.Reset_Indentation;
2816: END IF;
2817:
2818: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2819: (

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

2826: );
2827: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2828:
2829: IF (l_debug = 'Y') THEN
2830: okc_debug.log('11300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2831: okc_debug.Reset_Indentation;
2832: END IF;
2833:
2834: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2831: okc_debug.Reset_Indentation;

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

Line 2846: okc_debug.log('11400: Exiting delete_row:OTHERS Exception', 2);

2842: );
2843: WHEN OTHERS THEN
2844:
2845: IF (l_debug = 'Y') THEN
2846: okc_debug.log('11400: Exiting delete_row:OTHERS Exception', 2);
2847: okc_debug.Reset_Indentation;
2848: END IF;
2849:
2850: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2847: okc_debug.Reset_Indentation;

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

Line 2880: okc_debug.Set_Indentation('OKC_RGR_PVT');

2876: l_rgr_rec rgr_rec_type;
2877: BEGIN
2878:
2879: IF (l_debug = 'Y') THEN
2880: okc_debug.Set_Indentation('OKC_RGR_PVT');
2881: okc_debug.log('11500: Entered delete_row', 2);
2882: END IF;
2883:
2884: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2881: okc_debug.log('11500: Entered delete_row', 2);

2877: BEGIN
2878:
2879: IF (l_debug = 'Y') THEN
2880: okc_debug.Set_Indentation('OKC_RGR_PVT');
2881: okc_debug.log('11500: Entered delete_row', 2);
2882: END IF;
2883:
2884: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2885: G_PKG_NAME,

Line 2918: okc_debug.log('11600: Leaving delete_row', 2);

2914: END IF;
2915: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2916:
2917: IF (l_debug = 'Y') THEN
2918: okc_debug.log('11600: Leaving delete_row', 2);
2919: okc_debug.Reset_Indentation;
2920: END IF;
2921:
2922: EXCEPTION

Line 2919: okc_debug.Reset_Indentation;

2915: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2916:
2917: IF (l_debug = 'Y') THEN
2918: okc_debug.log('11600: Leaving delete_row', 2);
2919: okc_debug.Reset_Indentation;
2920: END IF;
2921:
2922: EXCEPTION
2923: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2922: EXCEPTION
2923: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2924:
2925: IF (l_debug = 'Y') THEN
2926: okc_debug.log('11700: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2927: okc_debug.Reset_Indentation;
2928: END IF;
2929:
2930: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2927: okc_debug.Reset_Indentation;

2923: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2924:
2925: IF (l_debug = 'Y') THEN
2926: okc_debug.log('11700: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2927: okc_debug.Reset_Indentation;
2928: END IF;
2929:
2930: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2931: (

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

2938: );
2939: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2940:
2941: IF (l_debug = 'Y') THEN
2942: okc_debug.log('11800: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2943: okc_debug.Reset_Indentation;
2944: END IF;
2945:
2946: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2943: okc_debug.Reset_Indentation;

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

Line 2958: okc_debug.log('11900: Exiting delete_row:OTHERS Exception', 2);

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

Line 2959: okc_debug.Reset_Indentation;

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

Line 2991: okc_debug.Set_Indentation('OKC_RGR_PVT');

2987: i NUMBER := 0;
2988: BEGIN
2989:
2990: IF (l_debug = 'Y') THEN
2991: okc_debug.Set_Indentation('OKC_RGR_PVT');
2992: okc_debug.log('12000: Entered delete_row', 2);
2993: END IF;
2994:
2995: OKC_API.init_msg_list(p_init_msg_list);

Line 2992: okc_debug.log('12000: Entered delete_row', 2);

2988: BEGIN
2989:
2990: IF (l_debug = 'Y') THEN
2991: okc_debug.Set_Indentation('OKC_RGR_PVT');
2992: okc_debug.log('12000: Entered delete_row', 2);
2993: END IF;
2994:
2995: OKC_API.init_msg_list(p_init_msg_list);
2996: -- Make sure PL/SQL table has records in it before passing

Line 3013: okc_debug.log('12100: Leaving delete_row', 2);

3009: END LOOP;
3010: END IF;
3011:
3012: IF (l_debug = 'Y') THEN
3013: okc_debug.log('12100: Leaving delete_row', 2);
3014: okc_debug.Reset_Indentation;
3015: END IF;
3016:
3017: EXCEPTION

Line 3014: okc_debug.Reset_Indentation;

3010: END IF;
3011:
3012: IF (l_debug = 'Y') THEN
3013: okc_debug.log('12100: Leaving delete_row', 2);
3014: okc_debug.Reset_Indentation;
3015: END IF;
3016:
3017: EXCEPTION
3018: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

3017: EXCEPTION
3018: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3019:
3020: IF (l_debug = 'Y') THEN
3021: okc_debug.log('12200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3022: okc_debug.Reset_Indentation;
3023: END IF;
3024:
3025: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3022: okc_debug.Reset_Indentation;

3018: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3019:
3020: IF (l_debug = 'Y') THEN
3021: okc_debug.log('12200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
3022: okc_debug.Reset_Indentation;
3023: END IF;
3024:
3025: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3026: (

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

3033: );
3034: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3035:
3036: IF (l_debug = 'Y') THEN
3037: okc_debug.log('12300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3038: okc_debug.Reset_Indentation;
3039: END IF;
3040:
3041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3038: okc_debug.Reset_Indentation;

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

Line 3053: okc_debug.log('12400: Exiting delete_row:OTHERS Exception', 2);

3049: );
3050: WHEN OTHERS THEN
3051:
3052: IF (l_debug = 'Y') THEN
3053: okc_debug.log('12400: Exiting delete_row:OTHERS Exception', 2);
3054: okc_debug.Reset_Indentation;
3055: END IF;
3056:
3057: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 3054: okc_debug.Reset_Indentation;

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