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_OIE_PVT dependencies on OKC_DEBUG

Line 33: okc_debug.Set_Indentation('OKC_OIE_PVT');

29: WHERE id = p_cop_id;
30: Begin
31:
32: IF (l_debug = 'Y') THEN
33: okc_debug.Set_Indentation('OKC_OIE_PVT');
34: okc_debug.log('100: Entered validate_cop_id', 2);
35: END IF;
36:
37: -- initialize return status

Line 34: okc_debug.log('100: Entered validate_cop_id', 2);

30: Begin
31:
32: IF (l_debug = 'Y') THEN
33: okc_debug.Set_Indentation('OKC_OIE_PVT');
34: okc_debug.log('100: Entered validate_cop_id', 2);
35: END IF;
36:
37: -- initialize return status
38: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 76: okc_debug.log('200: Exiting validate_cop_id', 2);

72: x_return_status := OKC_API.G_RET_STS_ERROR;
73: End If;
74:
75: IF (l_debug = 'Y') THEN
76: okc_debug.log('200: Exiting validate_cop_id', 2);
77: okc_debug.Reset_Indentation;
78: END IF;
79:
80: exception

Line 77: okc_debug.Reset_Indentation;

73: End If;
74:
75: IF (l_debug = 'Y') THEN
76: okc_debug.log('200: Exiting validate_cop_id', 2);
77: okc_debug.Reset_Indentation;
78: END IF;
79:
80: exception
81: when G_EXCEPTION_HALT_VALIDATION then

Line 84: okc_debug.log('300: Exiting validate_cop_id:G_EXCEPTION_HALT_VALIDATION Exception', 2);

80: exception
81: when G_EXCEPTION_HALT_VALIDATION then
82:
83: IF (l_debug = 'Y') THEN
84: okc_debug.log('300: Exiting validate_cop_id:G_EXCEPTION_HALT_VALIDATION Exception', 2);
85: okc_debug.Reset_Indentation;
86: END IF;
87:
88: -- no processing necessary; validation can continue with next column

Line 85: okc_debug.Reset_Indentation;

81: when G_EXCEPTION_HALT_VALIDATION then
82:
83: IF (l_debug = 'Y') THEN
84: okc_debug.log('300: Exiting validate_cop_id:G_EXCEPTION_HALT_VALIDATION Exception', 2);
85: okc_debug.Reset_Indentation;
86: END IF;
87:
88: -- no processing necessary; validation can continue with next column
89: null;

Line 94: okc_debug.log('400: Exiting validate_cop_id:OTHERS Exception', 2);

90:
91: when OTHERS then
92:
93: IF (l_debug = 'Y') THEN
94: okc_debug.log('400: Exiting validate_cop_id:OTHERS Exception', 2);
95: okc_debug.Reset_Indentation;
96: END IF;
97:
98: -- store SQL error message on message stack

Line 95: okc_debug.Reset_Indentation;

91: when OTHERS then
92:
93: IF (l_debug = 'Y') THEN
94: okc_debug.log('400: Exiting validate_cop_id:OTHERS Exception', 2);
95: okc_debug.Reset_Indentation;
96: END IF;
97:
98: -- store SQL error message on message stack
99: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 130: okc_debug.Set_Indentation('OKC_OIE_PVT');

126:
127: Begin
128:
129: IF (l_debug = 'Y') THEN
130: okc_debug.Set_Indentation('OKC_OIE_PVT');
131: okc_debug.log('500: Entered validate_target_chr_id', 2);
132: END IF;
133:
134: -- initialize return status

Line 131: okc_debug.log('500: Entered validate_target_chr_id', 2);

127: Begin
128:
129: IF (l_debug = 'Y') THEN
130: okc_debug.Set_Indentation('OKC_OIE_PVT');
131: okc_debug.log('500: Entered validate_target_chr_id', 2);
132: END IF;
133:
134: -- initialize return status
135: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 160: okc_debug.log('600: Exiting validate_target_chr_id', 2);

156: End If;
157: End If;
158:
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('600: Exiting validate_target_chr_id', 2);
161: okc_debug.Reset_Indentation;
162: END IF;
163:
164: exception

Line 161: okc_debug.Reset_Indentation;

157: End If;
158:
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('600: Exiting validate_target_chr_id', 2);
161: okc_debug.Reset_Indentation;
162: END IF;
163:
164: exception
165: when OTHERS then

Line 168: okc_debug.log('700: Exiting validate_target_chr_id:OTHERS Exception', 2);

164: exception
165: when OTHERS then
166:
167: IF (l_debug = 'Y') THEN
168: okc_debug.log('700: Exiting validate_target_chr_id:OTHERS Exception', 2);
169: okc_debug.Reset_Indentation;
170: END IF;
171:
172: -- store SQL error message on message stack

Line 169: okc_debug.Reset_Indentation;

165: when OTHERS then
166:
167: IF (l_debug = 'Y') THEN
168: okc_debug.log('700: Exiting validate_target_chr_id:OTHERS Exception', 2);
169: okc_debug.Reset_Indentation;
170: END IF;
171:
172: -- store SQL error message on message stack
173: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 193: okc_debug.Set_Indentation('OKC_OIE_PVT');

189: p_oiev_rec IN oiev_rec_type) is
190: Begin
191:
192: IF (l_debug = 'Y') THEN
193: okc_debug.Set_Indentation('OKC_OIE_PVT');
194: okc_debug.log('800: Entered validate_status_code', 2);
195: END IF;
196:
197: -- initialize return status

Line 194: okc_debug.log('800: Entered validate_status_code', 2);

190: Begin
191:
192: IF (l_debug = 'Y') THEN
193: okc_debug.Set_Indentation('OKC_OIE_PVT');
194: okc_debug.log('800: Entered validate_status_code', 2);
195: END IF;
196:
197: -- initialize return status
198: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 240: okc_debug.log('900: Exiting validate_status_code', 2);

236: End If;
237: End If;
238:
239: IF (l_debug = 'Y') THEN
240: okc_debug.log('900: Exiting validate_status_code', 2);
241: okc_debug.Reset_Indentation;
242: END IF;
243:
244: EXCEPTION

Line 241: okc_debug.Reset_Indentation;

237: End If;
238:
239: IF (l_debug = 'Y') THEN
240: okc_debug.log('900: Exiting validate_status_code', 2);
241: okc_debug.Reset_Indentation;
242: END IF;
243:
244: EXCEPTION
245: when OTHERS then

Line 248: okc_debug.log('1000: Exiting validate_status_code:OTHERS Exception', 2);

244: EXCEPTION
245: when OTHERS then
246:
247: IF (l_debug = 'Y') THEN
248: okc_debug.log('1000: Exiting validate_status_code:OTHERS Exception', 2);
249: okc_debug.Reset_Indentation;
250: END IF;
251:
252: -- store SQL error message on message stack

Line 249: okc_debug.Reset_Indentation;

245: when OTHERS then
246:
247: IF (l_debug = 'Y') THEN
248: okc_debug.log('1000: Exiting validate_status_code:OTHERS Exception', 2);
249: okc_debug.Reset_Indentation;
250: END IF;
251:
252: -- store SQL error message on message stack
253: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 287: okc_debug.Set_Indentation('OKC_OIE_PVT');

283:
284: begin
285:
286: IF (l_debug = 'Y') THEN
287: okc_debug.Set_Indentation('OKC_OIE_PVT');
288: okc_debug.log('1100: Entered validate_jtot_object1_code', 2);
289: END IF;
290:
291: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 288: okc_debug.log('1100: Entered validate_jtot_object1_code', 2);

284: begin
285:
286: IF (l_debug = 'Y') THEN
287: okc_debug.Set_Indentation('OKC_OIE_PVT');
288: okc_debug.log('1100: Entered validate_jtot_object1_code', 2);
289: END IF;
290:
291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
292: if (p_oiev_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_oiev_rec.jtot_object1_code is NULL) then

Line 305: okc_debug.log('1200: Exiting validate_jtot_object1_code', 2);

301: x_return_status := OKC_API.G_RET_STS_ERROR;
302: end if;
303:
304: IF (l_debug = 'Y') THEN
305: okc_debug.log('1200: Exiting validate_jtot_object1_code', 2);
306: okc_debug.Reset_Indentation;
307: END IF;
308:
309: exception

Line 306: okc_debug.Reset_Indentation;

302: end if;
303:
304: IF (l_debug = 'Y') THEN
305: okc_debug.log('1200: Exiting validate_jtot_object1_code', 2);
306: okc_debug.Reset_Indentation;
307: END IF;
308:
309: exception
310: when OTHERS then

Line 313: okc_debug.log('1300: Exiting validate_jtot_object1_code:OTHERS Exception', 2);

309: exception
310: when OTHERS then
311:
312: IF (l_debug = 'Y') THEN
313: okc_debug.log('1300: Exiting validate_jtot_object1_code:OTHERS Exception', 2);
314: okc_debug.Reset_Indentation;
315: END IF;
316:
317: if l_jtf_csr%ISOPEN then

Line 314: okc_debug.Reset_Indentation;

310: when OTHERS then
311:
312: IF (l_debug = 'Y') THEN
313: okc_debug.log('1300: Exiting validate_jtot_object1_code:OTHERS Exception', 2);
314: okc_debug.Reset_Indentation;
315: END IF;
316:
317: if l_jtf_csr%ISOPEN then
318: close l_jtf_csr;

Line 364: okc_debug.Set_Indentation('OKC_OIE_PVT');

360: PRAGMA EXCEPTION_INIT(e_column_not_exists,-904);
361: begin
362:
363: IF (l_debug = 'Y') THEN
364: okc_debug.Set_Indentation('OKC_OIE_PVT');
365: okc_debug.log('1400: Entered validate_object1_id1', 2);
366: END IF;
367:
368: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 365: okc_debug.log('1400: Entered validate_object1_id1', 2);

361: begin
362:
363: IF (l_debug = 'Y') THEN
364: okc_debug.Set_Indentation('OKC_OIE_PVT');
365: okc_debug.log('1400: Entered validate_object1_id1', 2);
366: END IF;
367:
368: x_return_status := OKC_API.G_RET_STS_SUCCESS;
369: if (p_oiev_rec.jtot_object1_code = OKC_API.G_MISS_CHAR or p_oiev_rec.jtot_object1_code is NULL) then

Line 387: okc_debug.log('1500: Exiting validate_object1_id1', 2);

383: into l_dummy_var
384: USING p_oiev_rec.object1_id1, p_oiev_rec.object1_id2;
385:
386: IF (l_debug = 'Y') THEN
387: okc_debug.log('1500: Exiting validate_object1_id1', 2);
388: okc_debug.Reset_Indentation;
389: END IF;
390:
391: exception

Line 388: okc_debug.Reset_Indentation;

384: USING p_oiev_rec.object1_id1, p_oiev_rec.object1_id2;
385:
386: IF (l_debug = 'Y') THEN
387: okc_debug.log('1500: Exiting validate_object1_id1', 2);
388: okc_debug.Reset_Indentation;
389: END IF;
390:
391: exception
392: when e_source_not_exists then

Line 395: okc_debug.log('1600: Exiting validate_object1_id1:e_source_not_exists Exception', 2);

391: exception
392: when e_source_not_exists then
393:
394: IF (l_debug = 'Y') THEN
395: okc_debug.log('1600: Exiting validate_object1_id1:e_source_not_exists Exception', 2);
396: okc_debug.Reset_Indentation;
397: END IF;
398:
399: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');

Line 396: okc_debug.Reset_Indentation;

392: when e_source_not_exists then
393:
394: IF (l_debug = 'Y') THEN
395: okc_debug.log('1600: Exiting validate_object1_id1:e_source_not_exists Exception', 2);
396: okc_debug.Reset_Indentation;
397: END IF;
398:
399: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'JTOT_OBJECT1_CODE');
400: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 404: okc_debug.log('1700: Exiting validate_object1_id1:e_column_not_exists Exception', 2);

400: x_return_status := OKC_API.G_RET_STS_ERROR;
401: when e_column_not_exists then
402:
403: IF (l_debug = 'Y') THEN
404: okc_debug.log('1700: Exiting validate_object1_id1:e_column_not_exists Exception', 2);
405: okc_debug.Reset_Indentation;
406: END IF;
407:
408: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');

Line 405: okc_debug.Reset_Indentation;

401: when e_column_not_exists then
402:
403: IF (l_debug = 'Y') THEN
404: okc_debug.log('1700: Exiting validate_object1_id1:e_column_not_exists Exception', 2);
405: okc_debug.Reset_Indentation;
406: END IF;
407:
408: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');
409: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 413: okc_debug.log('1800: Exiting validate_object1_id1:e_no_data_found Exception', 2);

409: x_return_status := OKC_API.G_RET_STS_ERROR;
410: when e_no_data_found then
411:
412: IF (l_debug = 'Y') THEN
413: okc_debug.log('1800: Exiting validate_object1_id1:e_no_data_found Exception', 2);
414: okc_debug.Reset_Indentation;
415: END IF;
416:
417: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OBJECT1_ID1');

Line 414: okc_debug.Reset_Indentation;

410: when e_no_data_found then
411:
412: IF (l_debug = 'Y') THEN
413: okc_debug.log('1800: Exiting validate_object1_id1:e_no_data_found Exception', 2);
414: okc_debug.Reset_Indentation;
415: END IF;
416:
417: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OBJECT1_ID1');
418: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 422: okc_debug.log('1900: Exiting validate_object1_id1:e_too_many_rows Exception', 2);

418: x_return_status := OKC_API.G_RET_STS_ERROR;
419: when e_too_many_rows then
420:
421: IF (l_debug = 'Y') THEN
422: okc_debug.log('1900: Exiting validate_object1_id1:e_too_many_rows Exception', 2);
423: okc_debug.Reset_Indentation;
424: END IF;
425:
426: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');

Line 423: okc_debug.Reset_Indentation;

419: when e_too_many_rows then
420:
421: IF (l_debug = 'Y') THEN
422: okc_debug.log('1900: Exiting validate_object1_id1:e_too_many_rows Exception', 2);
423: okc_debug.Reset_Indentation;
424: END IF;
425:
426: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_from_table||'.ID1');
427: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 431: okc_debug.log('2000: Exiting validate_object1_id1:OTHERS Exception', 2);

427: x_return_status := OKC_API.G_RET_STS_ERROR;
428: when OTHERS then
429:
430: IF (l_debug = 'Y') THEN
431: okc_debug.log('2000: Exiting validate_object1_id1:OTHERS Exception', 2);
432: okc_debug.Reset_Indentation;
433: END IF;
434:
435: if l_object1_csr%ISOPEN then

Line 432: okc_debug.Reset_Indentation;

428: when OTHERS then
429:
430: IF (l_debug = 'Y') THEN
431: okc_debug.log('2000: Exiting validate_object1_id1:OTHERS Exception', 2);
432: okc_debug.Reset_Indentation;
433: END IF;
434:
435: if l_object1_csr%ISOPEN then
436: close l_object1_csr;

Line 537: okc_debug.Set_Indentation('OKC_OIE_PVT');

533: l_oie_rec oie_rec_type;
534: BEGIN
535:
536: IF (l_debug = 'Y') THEN
537: okc_debug.Set_Indentation('OKC_OIE_PVT');
538: okc_debug.log('2500: Entered get_rec', 2);
539: END IF;
540:
541: x_no_data_found := TRUE;

Line 538: okc_debug.log('2500: Entered get_rec', 2);

534: BEGIN
535:
536: IF (l_debug = 'Y') THEN
537: okc_debug.Set_Indentation('OKC_OIE_PVT');
538: okc_debug.log('2500: Entered get_rec', 2);
539: END IF;
540:
541: x_no_data_found := TRUE;
542: -- Get current database values

Line 572: okc_debug.log('2550: Leaving Fn Get_Rec ', 2);

568: x_no_data_found := okc_operation_instances_pk_csr%NOTFOUND;
569: CLOSE okc_operation_instances_pk_csr;
570:
571: IF (l_debug = 'Y') THEN
572: okc_debug.log('2550: Leaving Fn Get_Rec ', 2);
573: okc_debug.Reset_Indentation;
574: END IF;
575:
576: RETURN(l_oie_rec);

Line 573: okc_debug.Reset_Indentation;

569: CLOSE okc_operation_instances_pk_csr;
570:
571: IF (l_debug = 'Y') THEN
572: okc_debug.log('2550: Leaving Fn Get_Rec ', 2);
573: okc_debug.Reset_Indentation;
574: END IF;
575:
576: RETURN(l_oie_rec);
577:

Line 619: okc_debug.Set_Indentation('OKC_OIE_PVT');

615: l_oiev_rec oiev_rec_type;
616: BEGIN
617:
618: IF (l_debug = 'Y') THEN
619: okc_debug.Set_Indentation('OKC_OIE_PVT');
620: okc_debug.log('2700: Entered get_rec', 2);
621: END IF;
622:
623: x_no_data_found := TRUE;

Line 620: okc_debug.log('2700: Entered get_rec', 2);

616: BEGIN
617:
618: IF (l_debug = 'Y') THEN
619: okc_debug.Set_Indentation('OKC_OIE_PVT');
620: okc_debug.log('2700: Entered get_rec', 2);
621: END IF;
622:
623: x_no_data_found := TRUE;
624: -- Get current database values

Line 645: okc_debug.log('2750: Leaving Fn Get_Rec ', 2);

641: x_no_data_found := oiev_pk_csr%NOTFOUND;
642: CLOSE oiev_pk_csr;
643:
644: IF (l_debug = 'Y') THEN
645: okc_debug.log('2750: Leaving Fn Get_Rec ', 2);
646: okc_debug.Reset_Indentation;
647: END IF;
648:
649: RETURN(l_oiev_rec);

Line 646: okc_debug.Reset_Indentation;

642: CLOSE oiev_pk_csr;
643:
644: IF (l_debug = 'Y') THEN
645: okc_debug.log('2750: Leaving Fn Get_Rec ', 2);
646: okc_debug.Reset_Indentation;
647: END IF;
648:
649: RETURN(l_oiev_rec);
650:

Line 673: okc_debug.Set_Indentation('OKC_OIE_PVT');

669: l_oiev_rec oiev_rec_type := p_oiev_rec;
670: BEGIN
671:
672: IF (l_debug = 'Y') THEN
673: okc_debug.Set_Indentation('OKC_OIE_PVT');
674: okc_debug.log('2900: Entered null_out_defaults', 2);
675: END IF;
676:
677: IF (l_oiev_rec.name = OKC_API.G_MISS_CHAR) THEN

Line 674: okc_debug.log('2900: Entered null_out_defaults', 2);

670: BEGIN
671:
672: IF (l_debug = 'Y') THEN
673: okc_debug.Set_Indentation('OKC_OIE_PVT');
674: okc_debug.log('2900: Entered null_out_defaults', 2);
675: END IF;
676:
677: IF (l_oiev_rec.name = OKC_API.G_MISS_CHAR) THEN
678: l_oiev_rec.name := NULL;

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

714: l_oiev_rec.object1_id2 := NULL;
715: END IF;
716:
717: IF (l_debug = 'Y') THEN
718: okc_debug.log('500: Leaving null_out_defaults ', 2);
719: okc_debug.Reset_Indentation;
720: END IF;
721:
722: RETURN(l_oiev_rec);

Line 719: okc_debug.Reset_Indentation;

715: END IF;
716:
717: IF (l_debug = 'Y') THEN
718: okc_debug.log('500: Leaving null_out_defaults ', 2);
719: okc_debug.Reset_Indentation;
720: END IF;
721:
722: RETURN(l_oiev_rec);
723:

Line 739: okc_debug.Set_Indentation('OKC_OIE_PVT');

735: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
736: BEGIN
737:
738: IF (l_debug = 'Y') THEN
739: okc_debug.Set_Indentation('OKC_OIE_PVT');
740: okc_debug.log('3000: Entered Validate_Attributes', 2);
741: END IF;
742:
743: /************************ HAND-CODED *********************************/

Line 740: okc_debug.log('3000: Entered Validate_Attributes', 2);

736: BEGIN
737:
738: IF (l_debug = 'Y') THEN
739: okc_debug.Set_Indentation('OKC_OIE_PVT');
740: okc_debug.log('3000: Entered Validate_Attributes', 2);
741: END IF;
742:
743: /************************ HAND-CODED *********************************/
744: validate_cop_id(x_return_status => l_return_status,

Line 795: okc_debug.log('3100: Exiting Validate_Attributes', 2);

791: End If;
792: End If;
793:
794: IF (l_debug = 'Y') THEN
795: okc_debug.log('3100: Exiting Validate_Attributes', 2);
796: okc_debug.Reset_Indentation;
797: END IF;
798:
799: RETURN(x_return_status);

Line 796: okc_debug.Reset_Indentation;

792: End If;
793:
794: IF (l_debug = 'Y') THEN
795: okc_debug.log('3100: Exiting Validate_Attributes', 2);
796: okc_debug.Reset_Indentation;
797: END IF;
798:
799: RETURN(x_return_status);
800:

Line 805: okc_debug.log('3200: Exiting Validate_Attributes:OTHERS Exception', 2);

801: EXCEPTION
802: when OTHERS then
803:
804: IF (l_debug = 'Y') THEN
805: okc_debug.log('3200: Exiting Validate_Attributes:OTHERS Exception', 2);
806: okc_debug.Reset_Indentation;
807: END IF;
808:
809: -- store SQL error message on message stack

Line 806: okc_debug.Reset_Indentation;

802: when OTHERS then
803:
804: IF (l_debug = 'Y') THEN
805: okc_debug.log('3200: Exiting Validate_Attributes:OTHERS Exception', 2);
806: okc_debug.Reset_Indentation;
807: END IF;
808:
809: -- store SQL error message on message stack
810: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 913: okc_debug.Set_Indentation('OKC_OIE_PVT');

909: l_oie_rec oie_rec_type;
910: BEGIN
911:
912: IF (l_debug = 'Y') THEN
913: okc_debug.Set_Indentation('OKC_OIE_PVT');
914: okc_debug.log('3600: Entered validate_row', 2);
915: END IF;
916:
917: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 914: okc_debug.log('3600: Entered validate_row', 2);

910: BEGIN
911:
912: IF (l_debug = 'Y') THEN
913: okc_debug.Set_Indentation('OKC_OIE_PVT');
914: okc_debug.log('3600: Entered validate_row', 2);
915: END IF;
916:
917: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
918: G_PKG_NAME,

Line 946: okc_debug.log('3700: Exiting validate_row', 2);

942: END IF;
943: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
944:
945: IF (l_debug = 'Y') THEN
946: okc_debug.log('3700: Exiting validate_row', 2);
947: okc_debug.Reset_Indentation;
948: END IF;
949:
950: EXCEPTION

Line 947: okc_debug.Reset_Indentation;

943: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
944:
945: IF (l_debug = 'Y') THEN
946: okc_debug.log('3700: Exiting validate_row', 2);
947: okc_debug.Reset_Indentation;
948: END IF;
949:
950: EXCEPTION
951: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

950: EXCEPTION
951: WHEN OKC_API.G_EXCEPTION_ERROR THEN
952:
953: IF (l_debug = 'Y') THEN
954: okc_debug.log('3800: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
955: okc_debug.Reset_Indentation;
956: END IF;
957:
958: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 955: okc_debug.Reset_Indentation;

951: WHEN OKC_API.G_EXCEPTION_ERROR THEN
952:
953: IF (l_debug = 'Y') THEN
954: okc_debug.log('3800: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
955: okc_debug.Reset_Indentation;
956: END IF;
957:
958: x_return_status := OKC_API.HANDLE_EXCEPTIONS
959: (

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

966: );
967: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968:
969: IF (l_debug = 'Y') THEN
970: okc_debug.log('3900: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
971: okc_debug.Reset_Indentation;
972: END IF;
973:
974: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 971: okc_debug.Reset_Indentation;

967: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968:
969: IF (l_debug = 'Y') THEN
970: okc_debug.log('3900: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
971: okc_debug.Reset_Indentation;
972: END IF;
973:
974: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
975: (

Line 986: okc_debug.log('4000: Exiting validate_row:OTHERS Exception', 2);

982: );
983: WHEN OTHERS THEN
984:
985: IF (l_debug = 'Y') THEN
986: okc_debug.log('4000: Exiting validate_row:OTHERS Exception', 2);
987: okc_debug.Reset_Indentation;
988: END IF;
989:
990: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 987: okc_debug.Reset_Indentation;

983: WHEN OTHERS THEN
984:
985: IF (l_debug = 'Y') THEN
986: okc_debug.log('4000: Exiting validate_row:OTHERS Exception', 2);
987: okc_debug.Reset_Indentation;
988: END IF;
989:
990: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
991: (

Line 1020: okc_debug.Set_Indentation('OKC_OIE_PVT');

1016: i NUMBER := 0;
1017: BEGIN
1018:
1019: IF (l_debug = 'Y') THEN
1020: okc_debug.Set_Indentation('OKC_OIE_PVT');
1021: okc_debug.log('4100: Entered validate_row', 2);
1022: END IF;
1023:
1024: OKC_API.init_msg_list(p_init_msg_list);

Line 1021: okc_debug.log('4100: Entered validate_row', 2);

1017: BEGIN
1018:
1019: IF (l_debug = 'Y') THEN
1020: okc_debug.Set_Indentation('OKC_OIE_PVT');
1021: okc_debug.log('4100: Entered validate_row', 2);
1022: END IF;
1023:
1024: OKC_API.init_msg_list(p_init_msg_list);
1025: -- Make sure PL/SQL table has records in it before passing

Line 1052: okc_debug.log('4200: Exiting validate_row', 2);

1048: x_return_status := l_overall_status;
1049: END IF;
1050:
1051: IF (l_debug = 'Y') THEN
1052: okc_debug.log('4200: Exiting validate_row', 2);
1053: okc_debug.Reset_Indentation;
1054: END IF;
1055:
1056: EXCEPTION

Line 1053: okc_debug.Reset_Indentation;

1049: END IF;
1050:
1051: IF (l_debug = 'Y') THEN
1052: okc_debug.log('4200: Exiting validate_row', 2);
1053: okc_debug.Reset_Indentation;
1054: END IF;
1055:
1056: EXCEPTION
1057: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1056: EXCEPTION
1057: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1058:
1059: IF (l_debug = 'Y') THEN
1060: okc_debug.log('4300: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1061: okc_debug.Reset_Indentation;
1062: END IF;
1063:
1064: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1061: okc_debug.Reset_Indentation;

1057: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1058:
1059: IF (l_debug = 'Y') THEN
1060: okc_debug.log('4300: Exiting validate_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1061: okc_debug.Reset_Indentation;
1062: END IF;
1063:
1064: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1065: (

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

1072: );
1073: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1074:
1075: IF (l_debug = 'Y') THEN
1076: okc_debug.log('4400: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1077: okc_debug.Reset_Indentation;
1078: END IF;
1079:
1080: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1077: okc_debug.Reset_Indentation;

1073: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1074:
1075: IF (l_debug = 'Y') THEN
1076: okc_debug.log('4400: Exiting validate_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1077: okc_debug.Reset_Indentation;
1078: END IF;
1079:
1080: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1081: (

Line 1092: okc_debug.log('4500: Exiting validate_row:OTHERS Exception', 2);

1088: );
1089: WHEN OTHERS THEN
1090:
1091: IF (l_debug = 'Y') THEN
1092: okc_debug.log('4500: Exiting validate_row:OTHERS Exception', 2);
1093: okc_debug.Reset_Indentation;
1094: END IF;
1095:
1096: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1093: okc_debug.Reset_Indentation;

1089: WHEN OTHERS THEN
1090:
1091: IF (l_debug = 'Y') THEN
1092: okc_debug.log('4500: Exiting validate_row:OTHERS Exception', 2);
1093: okc_debug.Reset_Indentation;
1094: END IF;
1095:
1096: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1097: (

Line 1144: okc_debug.Set_Indentation('OKC_OIE_PVT');

1140: END Set_Attributes;
1141: BEGIN
1142:
1143: IF (l_debug = 'Y') THEN
1144: okc_debug.Set_Indentation('OKC_OIE_PVT');
1145: okc_debug.log('4700: Entered insert_row', 2);
1146: END IF;
1147:
1148: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1145: okc_debug.log('4700: Entered insert_row', 2);

1141: BEGIN
1142:
1143: IF (l_debug = 'Y') THEN
1144: okc_debug.Set_Indentation('OKC_OIE_PVT');
1145: okc_debug.log('4700: Entered insert_row', 2);
1146: END IF;
1147:
1148: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1149: p_init_msg_list,

Line 1219: okc_debug.log('4800: Exiting insert_row', 2);

1215: x_oie_rec := l_oie_rec;
1216: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1217:
1218: IF (l_debug = 'Y') THEN
1219: okc_debug.log('4800: Exiting insert_row', 2);
1220: okc_debug.Reset_Indentation;
1221: END IF;
1222:
1223: EXCEPTION

Line 1220: okc_debug.Reset_Indentation;

1216: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1217:
1218: IF (l_debug = 'Y') THEN
1219: okc_debug.log('4800: Exiting insert_row', 2);
1220: okc_debug.Reset_Indentation;
1221: END IF;
1222:
1223: EXCEPTION
1224: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1223: EXCEPTION
1224: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1225:
1226: IF (l_debug = 'Y') THEN
1227: okc_debug.log('4900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1228: okc_debug.Reset_Indentation;
1229: END IF;
1230:
1231: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1228: okc_debug.Reset_Indentation;

1224: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1225:
1226: IF (l_debug = 'Y') THEN
1227: okc_debug.log('4900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1228: okc_debug.Reset_Indentation;
1229: END IF;
1230:
1231: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1232: (

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

1239: );
1240: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1241:
1242: IF (l_debug = 'Y') THEN
1243: okc_debug.log('5000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1244: okc_debug.Reset_Indentation;
1245: END IF;
1246:
1247: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1244: okc_debug.Reset_Indentation;

1240: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1241:
1242: IF (l_debug = 'Y') THEN
1243: okc_debug.log('5000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1244: okc_debug.Reset_Indentation;
1245: END IF;
1246:
1247: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1248: (

Line 1259: okc_debug.log('5100: Exiting insert_row:OTHERS Exception', 2);

1255: );
1256: WHEN OTHERS THEN
1257:
1258: IF (l_debug = 'Y') THEN
1259: okc_debug.log('5100: Exiting insert_row:OTHERS Exception', 2);
1260: okc_debug.Reset_Indentation;
1261: END IF;
1262:
1263: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1260: okc_debug.Reset_Indentation;

1256: WHEN OTHERS THEN
1257:
1258: IF (l_debug = 'Y') THEN
1259: okc_debug.log('5100: Exiting insert_row:OTHERS Exception', 2);
1260: okc_debug.Reset_Indentation;
1261: END IF;
1262:
1263: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1264: (

Line 1329: okc_debug.Set_Indentation('OKC_OIE_PVT');

1325: END Set_Attributes;
1326: BEGIN
1327:
1328: IF (l_debug = 'Y') THEN
1329: okc_debug.Set_Indentation('OKC_OIE_PVT');
1330: okc_debug.log('5400: Entered insert_row', 2);
1331: END IF;
1332:
1333: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1330: okc_debug.log('5400: Entered insert_row', 2);

1326: BEGIN
1327:
1328: IF (l_debug = 'Y') THEN
1329: okc_debug.Set_Indentation('OKC_OIE_PVT');
1330: okc_debug.log('5400: Entered insert_row', 2);
1331: END IF;
1332:
1333: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1334: G_PKG_NAME,

Line 1399: okc_debug.log('5500: Exiting insert_row', 2);

1395: x_oiev_rec := l_def_oiev_rec;
1396: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1397:
1398: IF (l_debug = 'Y') THEN
1399: okc_debug.log('5500: Exiting insert_row', 2);
1400: okc_debug.Reset_Indentation;
1401: END IF;
1402:
1403: EXCEPTION

Line 1400: okc_debug.Reset_Indentation;

1396: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1397:
1398: IF (l_debug = 'Y') THEN
1399: okc_debug.log('5500: Exiting insert_row', 2);
1400: okc_debug.Reset_Indentation;
1401: END IF;
1402:
1403: EXCEPTION
1404: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1403: EXCEPTION
1404: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1405:
1406: IF (l_debug = 'Y') THEN
1407: okc_debug.log('5600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1408: okc_debug.Reset_Indentation;
1409: END IF;
1410:
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1408: okc_debug.Reset_Indentation;

1404: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1405:
1406: IF (l_debug = 'Y') THEN
1407: okc_debug.log('5600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1408: okc_debug.Reset_Indentation;
1409: END IF;
1410:
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1412: (

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

1419: );
1420: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1421:
1422: IF (l_debug = 'Y') THEN
1423: okc_debug.log('5700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1424: okc_debug.Reset_Indentation;
1425: END IF;
1426:
1427: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1424: okc_debug.Reset_Indentation;

1420: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1421:
1422: IF (l_debug = 'Y') THEN
1423: okc_debug.log('5700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1424: okc_debug.Reset_Indentation;
1425: END IF;
1426:
1427: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1428: (

Line 1439: okc_debug.log('5800: Exiting insert_row:OTHERS Exception', 2);

1435: );
1436: WHEN OTHERS THEN
1437:
1438: IF (l_debug = 'Y') THEN
1439: okc_debug.log('5800: Exiting insert_row:OTHERS Exception', 2);
1440: okc_debug.Reset_Indentation;
1441: END IF;
1442:
1443: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1440: okc_debug.Reset_Indentation;

1436: WHEN OTHERS THEN
1437:
1438: IF (l_debug = 'Y') THEN
1439: okc_debug.log('5800: Exiting insert_row:OTHERS Exception', 2);
1440: okc_debug.Reset_Indentation;
1441: END IF;
1442:
1443: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1444: (

Line 1474: okc_debug.Set_Indentation('OKC_OIE_PVT');

1470: i NUMBER := 0;
1471: BEGIN
1472:
1473: IF (l_debug = 'Y') THEN
1474: okc_debug.Set_Indentation('OKC_OIE_PVT');
1475: okc_debug.log('5900: Entered insert_row', 2);
1476: END IF;
1477:
1478: OKC_API.init_msg_list(p_init_msg_list);

Line 1475: okc_debug.log('5900: Entered insert_row', 2);

1471: BEGIN
1472:
1473: IF (l_debug = 'Y') THEN
1474: okc_debug.Set_Indentation('OKC_OIE_PVT');
1475: okc_debug.log('5900: Entered insert_row', 2);
1476: END IF;
1477:
1478: OKC_API.init_msg_list(p_init_msg_list);
1479: -- Make sure PL/SQL table has records in it before passing

Line 1507: okc_debug.log('6000: Exiting insert_row', 2);

1503: x_return_status := l_overall_status;
1504: END IF;
1505:
1506: IF (l_debug = 'Y') THEN
1507: okc_debug.log('6000: Exiting insert_row', 2);
1508: okc_debug.Reset_Indentation;
1509: END IF;
1510:
1511: EXCEPTION

Line 1508: okc_debug.Reset_Indentation;

1504: END IF;
1505:
1506: IF (l_debug = 'Y') THEN
1507: okc_debug.log('6000: Exiting insert_row', 2);
1508: okc_debug.Reset_Indentation;
1509: END IF;
1510:
1511: EXCEPTION
1512: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1511: EXCEPTION
1512: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1513:
1514: IF (l_debug = 'Y') THEN
1515: okc_debug.log('6100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1516: okc_debug.Reset_Indentation;
1517: END IF;
1518:
1519: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1516: okc_debug.Reset_Indentation;

1512: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1513:
1514: IF (l_debug = 'Y') THEN
1515: okc_debug.log('6100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1516: okc_debug.Reset_Indentation;
1517: END IF;
1518:
1519: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1520: (

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

1527: );
1528: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1529:
1530: IF (l_debug = 'Y') THEN
1531: okc_debug.log('6200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1532: okc_debug.Reset_Indentation;
1533: END IF;
1534:
1535: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1532: okc_debug.Reset_Indentation;

1528: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1529:
1530: IF (l_debug = 'Y') THEN
1531: okc_debug.log('6200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1532: okc_debug.Reset_Indentation;
1533: END IF;
1534:
1535: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1536: (

Line 1547: okc_debug.log('6300: Exiting insert_row:OTHERS Exception', 2);

1543: );
1544: WHEN OTHERS THEN
1545:
1546: IF (l_debug = 'Y') THEN
1547: okc_debug.log('6300: Exiting insert_row:OTHERS Exception', 2);
1548: okc_debug.Reset_Indentation;
1549: END IF;
1550:
1551: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1548: okc_debug.Reset_Indentation;

1544: WHEN OTHERS THEN
1545:
1546: IF (l_debug = 'Y') THEN
1547: okc_debug.log('6300: Exiting insert_row:OTHERS Exception', 2);
1548: okc_debug.Reset_Indentation;
1549: END IF;
1550:
1551: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1552: (

Line 1599: okc_debug.Set_Indentation('OKC_OIE_PVT');

1595: lc_row_notfound BOOLEAN := FALSE;
1596: BEGIN
1597:
1598: IF (l_debug = 'Y') THEN
1599: okc_debug.Set_Indentation('OKC_OIE_PVT');
1600: okc_debug.log('6400: Entered lock_row', 2);
1601: END IF;
1602:
1603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1596: BEGIN
1597:
1598: IF (l_debug = 'Y') THEN
1599: okc_debug.Set_Indentation('OKC_OIE_PVT');
1600: okc_debug.log('6400: Entered lock_row', 2);
1601: END IF;
1602:
1603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1604: p_init_msg_list,

Line 1623: okc_debug.log('6700: Exiting lock_row:E_Resource_Busy Exception', 2);

1619: EXCEPTION
1620: WHEN E_Resource_Busy THEN
1621:
1622: IF (l_debug = 'Y') THEN
1623: okc_debug.log('6700: Exiting lock_row:E_Resource_Busy Exception', 2);
1624: okc_debug.Reset_Indentation;
1625: END IF;
1626:
1627: IF (lock_csr%ISOPEN) THEN

Line 1624: okc_debug.Reset_Indentation;

1620: WHEN E_Resource_Busy THEN
1621:
1622: IF (l_debug = 'Y') THEN
1623: okc_debug.log('6700: Exiting lock_row:E_Resource_Busy Exception', 2);
1624: okc_debug.Reset_Indentation;
1625: END IF;
1626:
1627: IF (lock_csr%ISOPEN) THEN
1628: CLOSE lock_csr;

Line 1656: okc_debug.log('6800: Exiting lock_row', 2);

1652: END IF;
1653: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1654:
1655: IF (l_debug = 'Y') THEN
1656: okc_debug.log('6800: Exiting lock_row', 2);
1657: okc_debug.Reset_Indentation;
1658: END IF;
1659:
1660: EXCEPTION

Line 1657: okc_debug.Reset_Indentation;

1653: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1654:
1655: IF (l_debug = 'Y') THEN
1656: okc_debug.log('6800: Exiting lock_row', 2);
1657: okc_debug.Reset_Indentation;
1658: END IF;
1659:
1660: EXCEPTION
1661: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1660: EXCEPTION
1661: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1662:
1663: IF (l_debug = 'Y') THEN
1664: okc_debug.log('6900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1665: okc_debug.Reset_Indentation;
1666: END IF;
1667:
1668: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1665: okc_debug.Reset_Indentation;

1661: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1662:
1663: IF (l_debug = 'Y') THEN
1664: okc_debug.log('6900: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1665: okc_debug.Reset_Indentation;
1666: END IF;
1667:
1668: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1669: (

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

1676: );
1677: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1678:
1679: IF (l_debug = 'Y') THEN
1680: okc_debug.log('7000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1681: okc_debug.Reset_Indentation;
1682: END IF;
1683:
1684: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1681: okc_debug.Reset_Indentation;

1677: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1678:
1679: IF (l_debug = 'Y') THEN
1680: okc_debug.log('7000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1681: okc_debug.Reset_Indentation;
1682: END IF;
1683:
1684: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1685: (

Line 1696: okc_debug.log('7100: Exiting lock_row:OTHERS Exception', 2);

1692: );
1693: WHEN OTHERS THEN
1694:
1695: IF (l_debug = 'Y') THEN
1696: okc_debug.log('7100: Exiting lock_row:OTHERS Exception', 2);
1697: okc_debug.Reset_Indentation;
1698: END IF;
1699:
1700: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1697: okc_debug.Reset_Indentation;

1693: WHEN OTHERS THEN
1694:
1695: IF (l_debug = 'Y') THEN
1696: okc_debug.log('7100: Exiting lock_row:OTHERS Exception', 2);
1697: okc_debug.Reset_Indentation;
1698: END IF;
1699:
1700: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1701: (

Line 1729: okc_debug.Set_Indentation('OKC_OIE_PVT');

1725: l_oie_rec oie_rec_type;
1726: BEGIN
1727:
1728: IF (l_debug = 'Y') THEN
1729: okc_debug.Set_Indentation('OKC_OIE_PVT');
1730: okc_debug.log('7200: Entered lock_row', 2);
1731: END IF;
1732:
1733: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1726: BEGIN
1727:
1728: IF (l_debug = 'Y') THEN
1729: okc_debug.Set_Indentation('OKC_OIE_PVT');
1730: okc_debug.log('7200: Entered lock_row', 2);
1731: END IF;
1732:
1733: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1734: G_PKG_NAME,

Line 1767: okc_debug.log('7300: Exiting lock_row', 2);

1763: END IF;
1764: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1765:
1766: IF (l_debug = 'Y') THEN
1767: okc_debug.log('7300: Exiting lock_row', 2);
1768: okc_debug.Reset_Indentation;
1769: END IF;
1770:
1771: EXCEPTION

Line 1768: okc_debug.Reset_Indentation;

1764: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1765:
1766: IF (l_debug = 'Y') THEN
1767: okc_debug.log('7300: Exiting lock_row', 2);
1768: okc_debug.Reset_Indentation;
1769: END IF;
1770:
1771: EXCEPTION
1772: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1771: EXCEPTION
1772: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1773:
1774: IF (l_debug = 'Y') THEN
1775: okc_debug.log('7400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1776: okc_debug.Reset_Indentation;
1777: END IF;
1778:
1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1776: okc_debug.Reset_Indentation;

1772: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1773:
1774: IF (l_debug = 'Y') THEN
1775: okc_debug.log('7400: Exiting lock_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
1776: okc_debug.Reset_Indentation;
1777: END IF;
1778:
1779: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1780: (

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

1787: );
1788: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1789:
1790: IF (l_debug = 'Y') THEN
1791: okc_debug.log('7500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1792: okc_debug.Reset_Indentation;
1793: END IF;
1794:
1795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1792: okc_debug.Reset_Indentation;

1788: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1789:
1790: IF (l_debug = 'Y') THEN
1791: okc_debug.log('7500: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1792: okc_debug.Reset_Indentation;
1793: END IF;
1794:
1795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1796: (

Line 1807: okc_debug.log('7600: Exiting lock_row:OTHERS Exception', 2);

1803: );
1804: WHEN OTHERS THEN
1805:
1806: IF (l_debug = 'Y') THEN
1807: okc_debug.log('7600: Exiting lock_row:OTHERS Exception', 2);
1808: okc_debug.Reset_Indentation;
1809: END IF;
1810:
1811: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1808: okc_debug.Reset_Indentation;

1804: WHEN OTHERS THEN
1805:
1806: IF (l_debug = 'Y') THEN
1807: okc_debug.log('7600: Exiting lock_row:OTHERS Exception', 2);
1808: okc_debug.Reset_Indentation;
1809: END IF;
1810:
1811: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1812: (

Line 1841: okc_debug.Set_Indentation('OKC_OIE_PVT');

1837: i NUMBER := 0;
1838: BEGIN
1839:
1840: IF (l_debug = 'Y') THEN
1841: okc_debug.Set_Indentation('OKC_OIE_PVT');
1842: okc_debug.log('7700: Entered lock_row', 2);
1843: END IF;
1844:
1845: OKC_API.init_msg_list(p_init_msg_list);

Line 1842: okc_debug.log('7700: Entered lock_row', 2);

1838: BEGIN
1839:
1840: IF (l_debug = 'Y') THEN
1841: okc_debug.Set_Indentation('OKC_OIE_PVT');
1842: okc_debug.log('7700: Entered lock_row', 2);
1843: END IF;
1844:
1845: OKC_API.init_msg_list(p_init_msg_list);
1846: -- Make sure PL/SQL table has records in it before passing

Line 1873: okc_debug.log('7800: Exiting lock_row', 2);

1869: x_return_status := l_overall_status;
1870: END IF;
1871:
1872: IF (l_debug = 'Y') THEN
1873: okc_debug.log('7800: Exiting lock_row', 2);
1874: okc_debug.Reset_Indentation;
1875: END IF;
1876:
1877: EXCEPTION

Line 1874: okc_debug.Reset_Indentation;

1870: END IF;
1871:
1872: IF (l_debug = 'Y') THEN
1873: okc_debug.log('7800: Exiting lock_row', 2);
1874: okc_debug.Reset_Indentation;
1875: END IF;
1876:
1877: EXCEPTION
1878: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

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

Line 1882: okc_debug.Reset_Indentation;

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

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

1893: );
1894: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1895:
1896: IF (l_debug = 'Y') THEN
1897: okc_debug.log('8000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1898: okc_debug.Reset_Indentation;
1899: END IF;
1900:
1901: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1898: okc_debug.Reset_Indentation;

1894: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1895:
1896: IF (l_debug = 'Y') THEN
1897: okc_debug.log('8000: Exiting lock_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1898: okc_debug.Reset_Indentation;
1899: END IF;
1900:
1901: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1902: (

Line 1913: okc_debug.log('8100: Exiting lock_row:OTHERS Exception', 2);

1909: );
1910: WHEN OTHERS THEN
1911:
1912: IF (l_debug = 'Y') THEN
1913: okc_debug.log('8100: Exiting lock_row:OTHERS Exception', 2);
1914: okc_debug.Reset_Indentation;
1915: END IF;
1916:
1917: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1914: okc_debug.Reset_Indentation;

1910: WHEN OTHERS THEN
1911:
1912: IF (l_debug = 'Y') THEN
1913: okc_debug.log('8100: Exiting lock_row:OTHERS Exception', 2);
1914: okc_debug.Reset_Indentation;
1915: END IF;
1916:
1917: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1918: (

Line 1962: okc_debug.Set_Indentation('OKC_OIE_PVT');

1958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1959: BEGIN
1960:
1961: IF (l_debug = 'Y') THEN
1962: okc_debug.Set_Indentation('OKC_OIE_PVT');
1963: okc_debug.log('8200: Entered populate_new_record', 2);
1964: END IF;
1965:
1966: x_oie_rec := p_oie_rec;

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

1959: BEGIN
1960:
1961: IF (l_debug = 'Y') THEN
1962: okc_debug.Set_Indentation('OKC_OIE_PVT');
1963: okc_debug.log('8200: Entered populate_new_record', 2);
1964: END IF;
1965:
1966: x_oie_rec := p_oie_rec;
1967: -- Get current database values

Line 2053: okc_debug.log('8250: Leaving populate_new_record ', 2);

2049: END IF;
2050: -- R12 Data Model Changes 4485150 Start
2051:
2052: IF (l_debug = 'Y') THEN
2053: okc_debug.log('8250: Leaving populate_new_record ', 2);
2054: okc_debug.Reset_Indentation;
2055: END IF;
2056:
2057: RETURN(l_return_status);

Line 2054: okc_debug.Reset_Indentation;

2050: -- R12 Data Model Changes 4485150 Start
2051:
2052: IF (l_debug = 'Y') THEN
2053: okc_debug.log('8250: Leaving populate_new_record ', 2);
2054: okc_debug.Reset_Indentation;
2055: END IF;
2056:
2057: RETURN(l_return_status);
2058: END populate_new_record;

Line 2076: okc_debug.Set_Indentation('OKC_OIE_PVT');

2072: END Set_Attributes;
2073: BEGIN
2074:
2075: IF (l_debug = 'Y') THEN
2076: okc_debug.Set_Indentation('OKC_OIE_PVT');
2077: okc_debug.log('8400: Entered update_row', 2);
2078: END IF;
2079:
2080: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2073: BEGIN
2074:
2075: IF (l_debug = 'Y') THEN
2076: okc_debug.Set_Indentation('OKC_OIE_PVT');
2077: okc_debug.log('8400: Entered update_row', 2);
2078: END IF;
2079:
2080: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2081: p_init_msg_list,

Line 2133: okc_debug.log('8500: Exiting update_row', 2);

2129: x_oie_rec := l_def_oie_rec;
2130: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2131:
2132: IF (l_debug = 'Y') THEN
2133: okc_debug.log('8500: Exiting update_row', 2);
2134: okc_debug.Reset_Indentation;
2135: END IF;
2136:
2137: EXCEPTION

Line 2134: okc_debug.Reset_Indentation;

2130: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2131:
2132: IF (l_debug = 'Y') THEN
2133: okc_debug.log('8500: Exiting update_row', 2);
2134: okc_debug.Reset_Indentation;
2135: END IF;
2136:
2137: EXCEPTION
2138: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2137: EXCEPTION
2138: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2139:
2140: IF (l_debug = 'Y') THEN
2141: okc_debug.log('8600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2142: okc_debug.Reset_Indentation;
2143: END IF;
2144:
2145: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2142: okc_debug.Reset_Indentation;

2138: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2139:
2140: IF (l_debug = 'Y') THEN
2141: okc_debug.log('8600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2142: okc_debug.Reset_Indentation;
2143: END IF;
2144:
2145: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2146: (

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

2153: );
2154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2155:
2156: IF (l_debug = 'Y') THEN
2157: okc_debug.log('8700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2158: okc_debug.Reset_Indentation;
2159: END IF;
2160:
2161: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2158: okc_debug.Reset_Indentation;

2154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2155:
2156: IF (l_debug = 'Y') THEN
2157: okc_debug.log('8700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2158: okc_debug.Reset_Indentation;
2159: END IF;
2160:
2161: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2162: (

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

2169: );
2170: WHEN OTHERS THEN
2171:
2172: IF (l_debug = 'Y') THEN
2173: okc_debug.log('8800: Exiting update_row:OTHERS Exception', 2);
2174: okc_debug.Reset_Indentation;
2175: END IF;
2176:
2177: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2174: okc_debug.Reset_Indentation;

2170: WHEN OTHERS THEN
2171:
2172: IF (l_debug = 'Y') THEN
2173: okc_debug.log('8800: Exiting update_row:OTHERS Exception', 2);
2174: okc_debug.Reset_Indentation;
2175: END IF;
2176:
2177: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2178: (

Line 2217: okc_debug.Set_Indentation('OKC_OIE_PVT');

2213: l_oiev_rec oiev_rec_type := p_oiev_rec;
2214: BEGIN
2215:
2216: IF (l_debug = 'Y') THEN
2217: okc_debug.Set_Indentation('OKC_OIE_PVT');
2218: okc_debug.log('8900: Entered fill_who_columns', 2);
2219: END IF;
2220:
2221: l_oiev_rec.LAST_UPDATE_DATE := SYSDATE;

Line 2218: okc_debug.log('8900: Entered fill_who_columns', 2);

2214: BEGIN
2215:
2216: IF (l_debug = 'Y') THEN
2217: okc_debug.Set_Indentation('OKC_OIE_PVT');
2218: okc_debug.log('8900: Entered fill_who_columns', 2);
2219: END IF;
2220:
2221: l_oiev_rec.LAST_UPDATE_DATE := SYSDATE;
2222: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 2240: okc_debug.Set_Indentation('OKC_OIE_PVT');

2236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2237: BEGIN
2238:
2239: IF (l_debug = 'Y') THEN
2240: okc_debug.Set_Indentation('OKC_OIE_PVT');
2241: okc_debug.log('9000: Entered populate_new_record', 2);
2242: END IF;
2243:
2244: x_oiev_rec := p_oiev_rec;

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

2237: BEGIN
2238:
2239: IF (l_debug = 'Y') THEN
2240: okc_debug.Set_Indentation('OKC_OIE_PVT');
2241: okc_debug.log('9000: Entered populate_new_record', 2);
2242: END IF;
2243:
2244: x_oiev_rec := p_oiev_rec;
2245: -- Get current database values

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

2304: x_oiev_rec.object1_id2 := l_oiev_rec.object1_id2;
2305: END IF;
2306:
2307: IF (l_debug = 'Y') THEN
2308: okc_debug.log('11950: Leaving populate_new_record ', 2);
2309: okc_debug.Reset_Indentation;
2310: END IF;
2311:
2312: RETURN(l_return_status);

Line 2309: okc_debug.Reset_Indentation;

2305: END IF;
2306:
2307: IF (l_debug = 'Y') THEN
2308: okc_debug.log('11950: Leaving populate_new_record ', 2);
2309: okc_debug.Reset_Indentation;
2310: END IF;
2311:
2312: RETURN(l_return_status);
2313:

Line 2333: okc_debug.Set_Indentation('OKC_OIE_PVT');

2329: END Set_Attributes;
2330: BEGIN
2331:
2332: IF (l_debug = 'Y') THEN
2333: okc_debug.Set_Indentation('OKC_OIE_PVT');
2334: okc_debug.log('9200: Entered update_row', 2);
2335: END IF;
2336:
2337: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2330: BEGIN
2331:
2332: IF (l_debug = 'Y') THEN
2333: okc_debug.Set_Indentation('OKC_OIE_PVT');
2334: okc_debug.log('9200: Entered update_row', 2);
2335: END IF;
2336:
2337: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2338: G_PKG_NAME,

Line 2406: okc_debug.log('9300: Exiting update_row', 2);

2402: x_oiev_rec := l_def_oiev_rec;
2403: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2404:
2405: IF (l_debug = 'Y') THEN
2406: okc_debug.log('9300: Exiting update_row', 2);
2407: okc_debug.Reset_Indentation;
2408: END IF;
2409:
2410: EXCEPTION

Line 2407: okc_debug.Reset_Indentation;

2403: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2404:
2405: IF (l_debug = 'Y') THEN
2406: okc_debug.log('9300: Exiting update_row', 2);
2407: okc_debug.Reset_Indentation;
2408: END IF;
2409:
2410: EXCEPTION
2411: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2410: EXCEPTION
2411: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2412:
2413: IF (l_debug = 'Y') THEN
2414: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2415: okc_debug.Reset_Indentation;
2416: END IF;
2417:
2418: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2415: okc_debug.Reset_Indentation;

2411: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2412:
2413: IF (l_debug = 'Y') THEN
2414: okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2415: okc_debug.Reset_Indentation;
2416: END IF;
2417:
2418: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2419: (

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

2426: );
2427: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2428:
2429: IF (l_debug = 'Y') THEN
2430: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2431: okc_debug.Reset_Indentation;
2432: END IF;
2433:
2434: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2431: okc_debug.Reset_Indentation;

2427: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2428:
2429: IF (l_debug = 'Y') THEN
2430: okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2431: okc_debug.Reset_Indentation;
2432: END IF;
2433:
2434: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2435: (

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

2442: );
2443: WHEN OTHERS THEN
2444:
2445: IF (l_debug = 'Y') THEN
2446: okc_debug.log('9600: Exiting update_row:OTHERS Exception', 2);
2447: okc_debug.Reset_Indentation;
2448: END IF;
2449:
2450: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2447: okc_debug.Reset_Indentation;

2443: WHEN OTHERS THEN
2444:
2445: IF (l_debug = 'Y') THEN
2446: okc_debug.log('9600: Exiting update_row:OTHERS Exception', 2);
2447: okc_debug.Reset_Indentation;
2448: END IF;
2449:
2450: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2451: (

Line 2481: okc_debug.Set_Indentation('OKC_OIE_PVT');

2477: i NUMBER := 0;
2478: BEGIN
2479:
2480: IF (l_debug = 'Y') THEN
2481: okc_debug.Set_Indentation('OKC_OIE_PVT');
2482: okc_debug.log('9700: Entered update_row', 2);
2483: END IF;
2484:
2485: OKC_API.init_msg_list(p_init_msg_list);

Line 2482: okc_debug.log('9700: Entered update_row', 2);

2478: BEGIN
2479:
2480: IF (l_debug = 'Y') THEN
2481: okc_debug.Set_Indentation('OKC_OIE_PVT');
2482: okc_debug.log('9700: Entered update_row', 2);
2483: END IF;
2484:
2485: OKC_API.init_msg_list(p_init_msg_list);
2486: -- Make sure PL/SQL table has records in it before passing

Line 2514: okc_debug.log('9800: Exiting update_row', 2);

2510: x_return_status := l_overall_status;
2511: END IF;
2512:
2513: IF (l_debug = 'Y') THEN
2514: okc_debug.log('9800: Exiting update_row', 2);
2515: okc_debug.Reset_Indentation;
2516: END IF;
2517:
2518: EXCEPTION

Line 2515: okc_debug.Reset_Indentation;

2511: END IF;
2512:
2513: IF (l_debug = 'Y') THEN
2514: okc_debug.log('9800: Exiting update_row', 2);
2515: okc_debug.Reset_Indentation;
2516: END IF;
2517:
2518: EXCEPTION
2519: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2518: EXCEPTION
2519: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2520:
2521: IF (l_debug = 'Y') THEN
2522: okc_debug.log('9900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2523: okc_debug.Reset_Indentation;
2524: END IF;
2525:
2526: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2523: okc_debug.Reset_Indentation;

2519: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2520:
2521: IF (l_debug = 'Y') THEN
2522: okc_debug.log('9900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2523: okc_debug.Reset_Indentation;
2524: END IF;
2525:
2526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2527: (

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

2534: );
2535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2536:
2537: IF (l_debug = 'Y') THEN
2538: okc_debug.log('10000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2539: okc_debug.Reset_Indentation;
2540: END IF;
2541:
2542: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2539: okc_debug.Reset_Indentation;

2535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2536:
2537: IF (l_debug = 'Y') THEN
2538: okc_debug.log('10000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2539: okc_debug.Reset_Indentation;
2540: END IF;
2541:
2542: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2543: (

Line 2554: okc_debug.log('10100: Exiting update_row:OTHERS Exception', 2);

2550: );
2551: WHEN OTHERS THEN
2552:
2553: IF (l_debug = 'Y') THEN
2554: okc_debug.log('10100: Exiting update_row:OTHERS Exception', 2);
2555: okc_debug.Reset_Indentation;
2556: END IF;
2557:
2558: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2555: okc_debug.Reset_Indentation;

2551: WHEN OTHERS THEN
2552:
2553: IF (l_debug = 'Y') THEN
2554: okc_debug.log('10100: Exiting update_row:OTHERS Exception', 2);
2555: okc_debug.Reset_Indentation;
2556: END IF;
2557:
2558: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2559: (

Line 2591: okc_debug.Set_Indentation('OKC_OIE_PVT');

2587: l_row_notfound BOOLEAN := TRUE;
2588: BEGIN
2589:
2590: IF (l_debug = 'Y') THEN
2591: okc_debug.Set_Indentation('OKC_OIE_PVT');
2592: okc_debug.log('10200: Entered delete_row', 2);
2593: END IF;
2594:
2595: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2592: okc_debug.log('10200: Entered delete_row', 2);

2588: BEGIN
2589:
2590: IF (l_debug = 'Y') THEN
2591: okc_debug.Set_Indentation('OKC_OIE_PVT');
2592: okc_debug.log('10200: Entered delete_row', 2);
2593: END IF;
2594:
2595: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2596: p_init_msg_list,

Line 2610: okc_debug.log('10300: Exiting delete_row', 2);

2606:
2607: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2608:
2609: IF (l_debug = 'Y') THEN
2610: okc_debug.log('10300: Exiting delete_row', 2);
2611: okc_debug.Reset_Indentation;
2612: END IF;
2613:
2614: EXCEPTION

Line 2611: okc_debug.Reset_Indentation;

2607: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2608:
2609: IF (l_debug = 'Y') THEN
2610: okc_debug.log('10300: Exiting delete_row', 2);
2611: okc_debug.Reset_Indentation;
2612: END IF;
2613:
2614: EXCEPTION
2615: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

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

Line 2619: okc_debug.Reset_Indentation;

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

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

2630: );
2631: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2632:
2633: IF (l_debug = 'Y') THEN
2634: okc_debug.log('10500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2635: okc_debug.Reset_Indentation;
2636: END IF;
2637:
2638: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2635: okc_debug.Reset_Indentation;

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

Line 2650: okc_debug.log('10600: Exiting delete_row:OTHERS Exception', 2);

2646: );
2647: WHEN OTHERS THEN
2648:
2649: IF (l_debug = 'Y') THEN
2650: okc_debug.log('10600: Exiting delete_row:OTHERS Exception', 2);
2651: okc_debug.Reset_Indentation;
2652: END IF;
2653:
2654: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2651: okc_debug.Reset_Indentation;

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

Line 2684: okc_debug.Set_Indentation('OKC_OIE_PVT');

2680: l_oie_rec oie_rec_type;
2681: BEGIN
2682:
2683: IF (l_debug = 'Y') THEN
2684: okc_debug.Set_Indentation('OKC_OIE_PVT');
2685: okc_debug.log('10700: Entered delete_row', 2);
2686: END IF;
2687:
2688: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2685: okc_debug.log('10700: Entered delete_row', 2);

2681: BEGIN
2682:
2683: IF (l_debug = 'Y') THEN
2684: okc_debug.Set_Indentation('OKC_OIE_PVT');
2685: okc_debug.log('10700: Entered delete_row', 2);
2686: END IF;
2687:
2688: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2689: G_PKG_NAME,

Line 2722: okc_debug.log('10800: Exiting delete_row', 2);

2718: END IF;
2719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2720:
2721: IF (l_debug = 'Y') THEN
2722: okc_debug.log('10800: Exiting delete_row', 2);
2723: okc_debug.Reset_Indentation;
2724: END IF;
2725:
2726: EXCEPTION

Line 2723: okc_debug.Reset_Indentation;

2719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2720:
2721: IF (l_debug = 'Y') THEN
2722: okc_debug.log('10800: Exiting delete_row', 2);
2723: okc_debug.Reset_Indentation;
2724: END IF;
2725:
2726: EXCEPTION
2727: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2726: EXCEPTION
2727: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2728:
2729: IF (l_debug = 'Y') THEN
2730: okc_debug.log('10900: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2731: okc_debug.Reset_Indentation;
2732: END IF;
2733:
2734: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2731: okc_debug.Reset_Indentation;

2727: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2728:
2729: IF (l_debug = 'Y') THEN
2730: okc_debug.log('10900: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2731: okc_debug.Reset_Indentation;
2732: END IF;
2733:
2734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2735: (

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

2742: );
2743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2744:
2745: IF (l_debug = 'Y') THEN
2746: okc_debug.log('11000: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2747: okc_debug.Reset_Indentation;
2748: END IF;
2749:
2750: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2747: okc_debug.Reset_Indentation;

2743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2744:
2745: IF (l_debug = 'Y') THEN
2746: okc_debug.log('11000: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2747: okc_debug.Reset_Indentation;
2748: END IF;
2749:
2750: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2751: (

Line 2762: okc_debug.log('11100: Exiting delete_row:OTHERS Exception', 2);

2758: );
2759: WHEN OTHERS THEN
2760:
2761: IF (l_debug = 'Y') THEN
2762: okc_debug.log('11100: Exiting delete_row:OTHERS Exception', 2);
2763: okc_debug.Reset_Indentation;
2764: END IF;
2765:
2766: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2763: okc_debug.Reset_Indentation;

2759: WHEN OTHERS THEN
2760:
2761: IF (l_debug = 'Y') THEN
2762: okc_debug.log('11100: Exiting delete_row:OTHERS Exception', 2);
2763: okc_debug.Reset_Indentation;
2764: END IF;
2765:
2766: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2767: (

Line 2796: okc_debug.Set_Indentation('OKC_OIE_PVT');

2792: i NUMBER := 0;
2793: BEGIN
2794:
2795: IF (l_debug = 'Y') THEN
2796: okc_debug.Set_Indentation('OKC_OIE_PVT');
2797: okc_debug.log('11200: Entered delete_row', 2);
2798: END IF;
2799:
2800: OKC_API.init_msg_list(p_init_msg_list);

Line 2797: okc_debug.log('11200: Entered delete_row', 2);

2793: BEGIN
2794:
2795: IF (l_debug = 'Y') THEN
2796: okc_debug.Set_Indentation('OKC_OIE_PVT');
2797: okc_debug.log('11200: Entered delete_row', 2);
2798: END IF;
2799:
2800: OKC_API.init_msg_list(p_init_msg_list);
2801: -- Make sure PL/SQL table has records in it before passing

Line 2828: okc_debug.log('11300: Exiting delete_row', 2);

2824: x_return_status := l_overall_status;
2825: END IF;
2826:
2827: IF (l_debug = 'Y') THEN
2828: okc_debug.log('11300: Exiting delete_row', 2);
2829: okc_debug.Reset_Indentation;
2830: END IF;
2831:
2832: EXCEPTION

Line 2829: okc_debug.Reset_Indentation;

2825: END IF;
2826:
2827: IF (l_debug = 'Y') THEN
2828: okc_debug.log('11300: Exiting delete_row', 2);
2829: okc_debug.Reset_Indentation;
2830: END IF;
2831:
2832: EXCEPTION
2833: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2832: EXCEPTION
2833: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2834:
2835: IF (l_debug = 'Y') THEN
2836: okc_debug.log('11400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2837: okc_debug.Reset_Indentation;
2838: END IF;
2839:
2840: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2837: okc_debug.Reset_Indentation;

2833: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2834:
2835: IF (l_debug = 'Y') THEN
2836: okc_debug.log('11400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
2837: okc_debug.Reset_Indentation;
2838: END IF;
2839:
2840: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2841: (

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

2848: );
2849: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2850:
2851: IF (l_debug = 'Y') THEN
2852: okc_debug.log('11500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2853: okc_debug.Reset_Indentation;
2854: END IF;
2855:
2856: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2853: okc_debug.Reset_Indentation;

2849: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2850:
2851: IF (l_debug = 'Y') THEN
2852: okc_debug.log('11500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2853: okc_debug.Reset_Indentation;
2854: END IF;
2855:
2856: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2857: (

Line 2868: okc_debug.log('11600: Exiting delete_row:OTHERS Exception', 2);

2864: );
2865: WHEN OTHERS THEN
2866:
2867: IF (l_debug = 'Y') THEN
2868: okc_debug.log('11600: Exiting delete_row:OTHERS Exception', 2);
2869: okc_debug.Reset_Indentation;
2870: END IF;
2871:
2872: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 2869: okc_debug.Reset_Indentation;

2865: WHEN OTHERS THEN
2866:
2867: IF (l_debug = 'Y') THEN
2868: okc_debug.log('11600: Exiting delete_row:OTHERS Exception', 2);
2869: okc_debug.Reset_Indentation;
2870: END IF;
2871:
2872: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2873: (