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

Line 66: Okc_Debug.Log('100: Entered get_seq_id', 2);

62: CURSOR l_seq_csr IS
63: SELECT OKC_review_upld_header_S1.NEXTVAL FROM DUAL;
64: BEGIN
65: IF (l_debug = 'Y') THEN
66: Okc_Debug.Log('100: Entered get_seq_id', 2);
67: END IF;
68:
69: IF( p_review_upld_header_id IS NULL ) THEN
70: OPEN l_seq_csr;

Line 79: Okc_Debug.Log('200: Leaving get_seq_id', 2);

75: CLOSE l_seq_csr;
76: END IF;
77:
78: IF (l_debug = 'Y') THEN
79: Okc_Debug.Log('200: Leaving get_seq_id', 2);
80: END IF;
81: RETURN G_RET_STS_SUCCESS;
82: EXCEPTION
83: WHEN OTHERS THEN

Line 86: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);

82: EXCEPTION
83: WHEN OTHERS THEN
84:
85: IF (l_debug = 'Y') THEN
86: Okc_Debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm, 2);
87: END IF;
88:
89: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
90: p_msg_name => G_UNEXPECTED_ERROR,

Line 147: Okc_Debug.Log('400: Entered get_rec', 2);

143: WHERE t.review_upld_header_ID = cp_review_upld_header_id;
144: BEGIN
145:
146: IF (l_debug = 'Y') THEN
147: Okc_Debug.Log('400: Entered get_rec', 2);
148: END IF;
149:
150: -- Get current database values
151: OPEN OKC_review_upld_header_pk_csr (p_review_upld_header_id);

Line 173: Okc_Debug.Log('500: Leaving get_rec ', 2);

169: END IF;
170: CLOSE OKC_review_upld_header_pk_csr;
171:
172: IF (l_debug = 'Y') THEN
173: Okc_Debug.Log('500: Leaving get_rec ', 2);
174: END IF;
175:
176: RETURN G_RET_STS_SUCCESS ;
177:

Line 182: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);

178: EXCEPTION
179: WHEN OTHERS THEN
180:
181: IF (l_debug = 'Y') THEN
182: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
183: END IF;
184:
185: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
186: p_msg_name => G_UNEXPECTED_ERROR,

Line 232: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

228: l_last_update_login OKC_review_upld_header.LAST_UPDATE_LOGIN%TYPE;
229: l_last_update_date OKC_review_upld_header.LAST_UPDATE_DATE%TYPE;
230: BEGIN
231: IF (l_debug = 'Y') THEN
232: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
233: END IF;
234:
235: IF( p_review_upld_header_id IS NOT NULL ) THEN
236: -- Get current database values

Line 323: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);

319:
320: END IF;
321:
322: IF (l_debug = 'Y') THEN
323: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
324: END IF;
325:
326: RETURN G_RET_STS_SUCCESS ;
327: EXCEPTION

Line 330: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);

326: RETURN G_RET_STS_SUCCESS ;
327: EXCEPTION
328: WHEN FND_API.G_EXC_ERROR THEN
329: IF (l_debug = 'Y') THEN
330: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
331: END IF;
332: RETURN G_RET_STS_ERROR;
333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 336: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

332: RETURN G_RET_STS_ERROR;
333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: IF (l_debug = 'Y') THEN
336: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
337: END IF;
338: RETURN G_RET_STS_UNEXP_ERROR;
339:
340: WHEN OTHERS THEN

Line 342: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);

338: RETURN G_RET_STS_UNEXP_ERROR;
339:
340: WHEN OTHERS THEN
341: IF (l_debug = 'Y') THEN
342: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
343: END IF;
344: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
345: p_msg_name => G_UNEXPECTED_ERROR,
346: p_token1 => G_SQLCODE_TOKEN,

Line 388: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);

384: */
385: BEGIN
386:
387: IF (l_debug = 'Y') THEN
388: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
389: END IF;
390:
391: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
392: IF (l_debug = 'Y') THEN

Line 393: Okc_Debug.Log('1300: required values validation', 2);

389: END IF;
390:
391: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
392: IF (l_debug = 'Y') THEN
393: Okc_Debug.Log('1300: required values validation', 2);
394: END IF;
395:
396: IF (l_debug = 'Y') THEN
397: Okc_Debug.Log('1400: - attribute review_upld_header_ID ', 2);

Line 397: Okc_Debug.Log('1400: - attribute review_upld_header_ID ', 2);

393: Okc_Debug.Log('1300: required values validation', 2);
394: END IF;
395:
396: IF (l_debug = 'Y') THEN
397: Okc_Debug.Log('1400: - attribute review_upld_header_ID ', 2);
398: END IF;
399: IF ( p_review_upld_header_id IS NULL) THEN
400: IF (l_debug = 'Y') THEN
401: Okc_Debug.Log('1500: - attribute review_upld_header_ID is invalid', 2);

Line 401: Okc_Debug.Log('1500: - attribute review_upld_header_ID is invalid', 2);

397: Okc_Debug.Log('1400: - attribute review_upld_header_ID ', 2);
398: END IF;
399: IF ( p_review_upld_header_id IS NULL) THEN
400: IF (l_debug = 'Y') THEN
401: Okc_Debug.Log('1500: - attribute review_upld_header_ID is invalid', 2);
402: END IF;
403: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'review_upld_header_ID');
404: l_return_status := G_RET_STS_ERROR;
405: END IF;

Line 411: Okc_Debug.Log('1600: static values and range validation', 2);

407: END IF;
408:
409: IF p_validation_level > G_VALID_VALUE_VALID_LEVEL THEN
410: IF (l_debug = 'Y') THEN
411: Okc_Debug.Log('1600: static values and range validation', 2);
412: END IF;
413:
414: END IF;
415:

Line 418: Okc_Debug.Log('1900: lookup codes validation', 2);

414: END IF;
415:
416: IF p_validation_level > G_LOOKUP_CODE_VALID_LEVEL THEN
417: IF (l_debug = 'Y') THEN
418: Okc_Debug.Log('1900: lookup codes validation', 2);
419: END IF;
420: /* ?? uncomment next part after you check and change this lokkup codes validation
421:
422: */

Line 427: Okc_Debug.Log('2100: foreigh keys validation ', 2);

423: END IF;
424:
425: IF p_validation_level > G_FOREIGN_KEY_VALID_LEVEL THEN
426: IF (l_debug = 'Y') THEN
427: Okc_Debug.Log('2100: foreigh keys validation ', 2);
428: END IF;
429: /* ?? uncomment next part after you check and change this foreign key validation
430:
431: IF (l_debug = 'Y') THEN

Line 432: Okc_Debug.Log('2200: - attribute review_upld_header_ID ', 2);

428: END IF;
429: /* ?? uncomment next part after you check and change this foreign key validation
430:
431: IF (l_debug = 'Y') THEN
432: Okc_Debug.Log('2200: - attribute review_upld_header_ID ', 2);
433: END IF;
434: IF p_review_upld_header_id IS NOT NULL THEN
435: l_dummy_var := '?';
436: OPEN l_review_upld_header_id_csr;

Line 441: Okc_Debug.Log('2300: - attribute review_upld_header_ID is invalid', 2);

437: FETCH l_review_upld_header_id_csr INTO l_dummy_var;
438: CLOSE l_review_upld_header_id_csr;
439: IF (l_dummy_var = '?') THEN
440: IF (l_debug = 'Y') THEN
441: Okc_Debug.Log('2300: - attribute review_upld_header_ID is invalid', 2);
442: END IF;
443: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'review_upld_header_ID');
444: l_return_status := G_RET_STS_ERROR;
445: END IF;

Line 449: Okc_Debug.Log('2200: - attribute DOCUMENT_ID ', 2);

445: END IF;
446: END IF;
447:
448: IF (l_debug = 'Y') THEN
449: Okc_Debug.Log('2200: - attribute DOCUMENT_ID ', 2);
450: END IF;
451: IF p_document_id IS NOT NULL THEN
452: l_dummy_var := '?';
453: OPEN l_document_id_csr;

Line 458: Okc_Debug.Log('2300: - attribute DOCUMENT_ID is invalid', 2);

454: FETCH l_document_id_csr INTO l_dummy_var;
455: CLOSE l_document_id_csr;
456: IF (l_dummy_var = '?') THEN
457: IF (l_debug = 'Y') THEN
458: Okc_Debug.Log('2300: - attribute DOCUMENT_ID is invalid', 2);
459: END IF;
460: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_ID');
461: l_return_status := G_RET_STS_ERROR;
462: END IF;

Line 470: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);

466: END IF;
467:
468:
469: IF (l_debug = 'Y') THEN
470: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
471: END IF;
472:
473: RETURN l_return_status;
474:

Line 477: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);

473: RETURN l_return_status;
474:
475: EXCEPTION
476: WHEN OTHERS THEN
477: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
478: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
479: p_msg_name => G_UNEXPECTED_ERROR,
480: p_token1 => G_SQLCODE_TOKEN,
481: p_token1_value => sqlcode,

Line 526: Okc_Debug.Log('2600: Entered Validate_Record', 2);

522: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
523: BEGIN
524:
525: IF (l_debug = 'Y') THEN
526: Okc_Debug.Log('2600: Entered Validate_Record', 2);
527: END IF;
528:
529: --- Validate all non-missing attributes (Item Level Validation)
530: l_return_status := Validate_Attributes(

Line 545: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);

541: p_file_description => p_file_description
542: );
543: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
544: IF (l_debug = 'Y') THEN
545: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
546: END IF;
547: RETURN G_RET_STS_UNEXP_ERROR;
548: END IF;
549:

Line 553: Okc_Debug.Log('2800: Entered Record Level Validations', 2);

549:
550: --- Record Level Validation
551: IF p_validation_level > G_RECORD_VALID_LEVEL THEN
552: IF (l_debug = 'Y') THEN
553: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
554: END IF;
555: /*+++++++++++++start of hand code +++++++++++++++++++*/
556: -- ?? manual coding for Record Level Validations if required ??
557: /*+++++++++++++End of hand code +++++++++++++++++++*/

Line 561: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);

557: /*+++++++++++++End of hand code +++++++++++++++++++*/
558: END IF;
559:
560: IF (l_debug = 'Y') THEN
561: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
562: END IF;
563: RETURN l_return_status ;
564:
565: EXCEPTION

Line 569: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);

565: EXCEPTION
566: WHEN OTHERS THEN
567:
568: IF (l_debug = 'Y') THEN
569: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
570: END IF;
571:
572: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
573: p_msg_name => G_UNEXPECTED_ERROR,

Line 623: Okc_Debug.Log('3100: Entered validate_row', 2);

619:
620: BEGIN
621:
622: IF (l_debug = 'Y') THEN
623: Okc_Debug.Log('3100: Entered validate_row', 2);
624: END IF;
625:
626: -- Setting attributes
627: x_return_status := Set_Attributes(

Line 672: Okc_Debug.Log('3200: Leaving validate_row', 2);

668:
669: );
670:
671: IF (l_debug = 'Y') THEN
672: Okc_Debug.Log('3200: Leaving validate_row', 2);
673: END IF;
674:
675: EXCEPTION
676: WHEN FND_API.G_EXC_ERROR THEN

Line 678: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);

674:
675: EXCEPTION
676: WHEN FND_API.G_EXC_ERROR THEN
677: IF (l_debug = 'Y') THEN
678: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
679: END IF;
680: x_return_status := G_RET_STS_ERROR;
681:
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 684: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

680: x_return_status := G_RET_STS_ERROR;
681:
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683: IF (l_debug = 'Y') THEN
684: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
685: END IF;
686: x_return_status := G_RET_STS_UNEXP_ERROR;
687:
688: WHEN OTHERS THEN

Line 690: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);

686: x_return_status := G_RET_STS_UNEXP_ERROR;
687:
688: WHEN OTHERS THEN
689: IF (l_debug = 'Y') THEN
690: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
691: END IF;
692: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
693: p_msg_name => G_UNEXPECTED_ERROR,
694: p_token1 => G_SQLCODE_TOKEN,

Line 730: Okc_Debug.Log('3600: Entered Insert_Row function', 2);

726:
727: BEGIN
728:
729: IF (l_debug = 'Y') THEN
730: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
731: END IF;
732:
733: INSERT INTO OKC_review_upld_header(
734: review_upld_header_ID,

Line 767: Okc_Debug.Log('3700: Leaving Insert_Row', 2);

763: p_enable_reporting_flag,
764: p_file_description);
765:
766: IF (l_debug = 'Y') THEN
767: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
768: END IF;
769:
770: RETURN( G_RET_STS_SUCCESS );
771:

Line 776: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);

772: EXCEPTION
773: WHEN OTHERS THEN
774:
775: IF (l_debug = 'Y') THEN
776: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
777: END IF;
778:
779: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
780: p_msg_name => G_UNEXPECTED_ERROR,

Line 823: Okc_Debug.Log('4200: Entered Insert_Row', 2);

819:
820: x_return_status := G_RET_STS_SUCCESS;
821:
822: IF (l_debug = 'Y') THEN
823: Okc_Debug.Log('4200: Entered Insert_Row', 2);
824: END IF;
825:
826: --- Setting item attributes
827: -- Set primary key value

Line 875: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);

871: --------------------------------------------
872: -- Call the internal Insert_Row for each child record
873: --------------------------------------------
874: IF (l_debug = 'Y') THEN
875: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
876: END IF;
877:
878: x_return_status := Insert_Row(
879: p_review_upld_header_id => x_review_upld_header_id,

Line 904: Okc_Debug.Log('4500: Leaving Insert_Row', 2);

900:
901:
902:
903: IF (l_debug = 'Y') THEN
904: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
905: END IF;
906:
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN

Line 910: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);

906:
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN
909: IF (l_debug = 'Y') THEN
910: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
911: END IF;
912: x_return_status := G_RET_STS_ERROR;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 916: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

912: x_return_status := G_RET_STS_ERROR;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: IF (l_debug = 'Y') THEN
916: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
917: END IF;
918: x_return_status := G_RET_STS_UNEXP_ERROR;
919:
920: WHEN OTHERS THEN

Line 922: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);

918: x_return_status := G_RET_STS_UNEXP_ERROR;
919:
920: WHEN OTHERS THEN
921: IF (l_debug = 'Y') THEN
922: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
923: END IF;
924: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
925: p_msg_name => G_UNEXPECTED_ERROR,
926: p_token1 => G_SQLCODE_TOKEN,

Line 962: Okc_Debug.Log('4900: Entered Lock_Row', 2);

958: WHERE review_upld_header_ID = cp_review_upld_header_id;
959: BEGIN
960:
961: IF (l_debug = 'Y') THEN
962: Okc_Debug.Log('4900: Entered Lock_Row', 2);
963: END IF;
964:
965:
966: BEGIN

Line 977: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);

973: EXCEPTION
974: WHEN E_Resource_Busy THEN
975:
976: IF (l_debug = 'Y') THEN
977: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
978: END IF;
979:
980: IF (lock_csr%ISOPEN) THEN
981: CLOSE lock_csr;

Line 1009: Okc_Debug.Log('5100: Leaving Lock_Row', 2);

1005: l_return_status := G_RET_STS_SUCCESS;
1006: END IF;
1007:
1008: IF (l_debug = 'Y') THEN
1009: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1010: END IF;
1011:
1012: RETURN( l_return_status );
1013:

Line 1025: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);

1021: CLOSE lchk_csr;
1022: END IF;
1023:
1024: IF (l_debug = 'Y') THEN
1025: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1026: END IF;
1027:
1028: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1029: p_msg_name => G_UNEXPECTED_ERROR,

Line 1050: Okc_Debug.Log('5700: Entered Lock_Row', 2);

1046: ) IS
1047: BEGIN
1048:
1049: IF (l_debug = 'Y') THEN
1050: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1051: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1052: END IF;
1053:
1054: --------------------------------------------

Line 1051: Okc_Debug.Log('5800: Locking Row for Base Table', 2);

1047: BEGIN
1048:
1049: IF (l_debug = 'Y') THEN
1050: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1051: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1052: END IF;
1053:
1054: --------------------------------------------
1055: -- Call the LOCK_ROW for each _B child record

Line 1070: Okc_Debug.Log('6000: Leaving Lock_Row', 2);

1066:
1067:
1068:
1069: IF (l_debug = 'Y') THEN
1070: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1071: END IF;
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN

Line 1076: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);

1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: IF (l_debug = 'Y') THEN
1076: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1077: END IF;
1078: x_return_status := G_RET_STS_ERROR;
1079:
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1082: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1078: x_return_status := G_RET_STS_ERROR;
1079:
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: IF (l_debug = 'Y') THEN
1082: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1083: END IF;
1084: x_return_status := G_RET_STS_UNEXP_ERROR;
1085:
1086: WHEN OTHERS THEN

Line 1088: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);

1084: x_return_status := G_RET_STS_UNEXP_ERROR;
1085:
1086: WHEN OTHERS THEN
1087: IF (l_debug = 'Y') THEN
1088: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1089: END IF;
1090: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1091: p_msg_name => G_UNEXPECTED_ERROR,
1092: p_token1 => G_SQLCODE_TOKEN,

Line 1125: Okc_Debug.Log('6400: Entered Update_Row', 2);

1121:
1122: BEGIN
1123:
1124: IF (l_debug = 'Y') THEN
1125: Okc_Debug.Log('6400: Entered Update_Row', 2);
1126: END IF;
1127:
1128: UPDATE OKC_review_upld_header
1129: SET FILE_NAME = p_file_name,

Line 1144: Okc_Debug.Log('6500: Leaving Update_Row', 2);

1140: file_description = p_file_description
1141: WHERE review_upld_header_ID = p_review_upld_header_id;
1142:
1143: IF (l_debug = 'Y') THEN
1144: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1145: END IF;
1146:
1147: RETURN G_RET_STS_SUCCESS ;
1148:

Line 1153: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);

1149: EXCEPTION
1150: WHEN OTHERS THEN
1151:
1152: IF (l_debug = 'Y') THEN
1153: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1154: END IF;
1155:
1156: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1157: p_msg_name => G_UNEXPECTED_ERROR,

Line 1205: Okc_Debug.Log('7000: Entered Update_Row', 2);

1201: l_file_description OKC_review_upld_header.file_description%TYPE;
1202: BEGIN
1203:
1204: IF (l_debug = 'Y') THEN
1205: Okc_Debug.Log('7000: Entered Update_Row', 2);
1206: Okc_Debug.Log('7100: Locking _B row', 2);
1207: END IF;
1208:
1209: x_return_status := Lock_row(

Line 1206: Okc_Debug.Log('7100: Locking _B row', 2);

1202: BEGIN
1203:
1204: IF (l_debug = 'Y') THEN
1205: Okc_Debug.Log('7000: Entered Update_Row', 2);
1206: Okc_Debug.Log('7100: Locking _B row', 2);
1207: END IF;
1208:
1209: x_return_status := Lock_row(
1210: p_review_upld_header_id => p_review_upld_header_id,

Line 1221: Okc_Debug.Log('7300: Setting attributes', 2);

1217: END IF;
1218:
1219:
1220: IF (l_debug = 'Y') THEN
1221: Okc_Debug.Log('7300: Setting attributes', 2);
1222: END IF;
1223:
1224: l_object_version_number := p_object_version_number;
1225: x_return_status := Set_Attributes(

Line 1252: Okc_Debug.Log('7400: Record Validation', 2);

1248: RAISE FND_API.G_EXC_ERROR;
1249: END IF;
1250:
1251: IF (l_debug = 'Y') THEN
1252: Okc_Debug.Log('7400: Record Validation', 2);
1253: END IF;
1254:
1255: --- Validate all non-missing attributes
1256: x_return_status := Validate_Record(

Line 1276: Okc_Debug.Log('7500: Filling WHO columns', 2);

1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274:
1275: IF (l_debug = 'Y') THEN
1276: Okc_Debug.Log('7500: Filling WHO columns', 2);
1277: END IF;
1278:
1279: -- Filling who columns
1280: l_last_update_date := SYSDATE;

Line 1294: Okc_Debug.Log('7600: Updating Row', 2);

1290: --------------------------------------------
1291: -- Call the Update_Row for each child record
1292: --------------------------------------------
1293: IF (l_debug = 'Y') THEN
1294: Okc_Debug.Log('7600: Updating Row', 2);
1295: END IF;
1296:
1297: x_return_status := Update_Row(
1298: p_review_upld_header_id => p_review_upld_header_id,

Line 1320: Okc_Debug.Log('7800: Leaving Update_Row', 2);

1316: END IF;
1317:
1318:
1319: IF (l_debug = 'Y') THEN
1320: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1321: END IF;
1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN

Line 1326: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);

1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: IF (l_debug = 'Y') THEN
1326: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1327: END IF;
1328: x_return_status := G_RET_STS_ERROR;
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1332: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1328: x_return_status := G_RET_STS_ERROR;
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331: IF (l_debug = 'Y') THEN
1332: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1333: END IF;
1334: x_return_status := G_RET_STS_UNEXP_ERROR;
1335:
1336: WHEN OTHERS THEN

Line 1338: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);

1334: x_return_status := G_RET_STS_UNEXP_ERROR;
1335:
1336: WHEN OTHERS THEN
1337: IF (l_debug = 'Y') THEN
1338: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1339: END IF;
1340: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1341: p_msg_name => G_UNEXPECTED_ERROR,
1342: p_token1 => G_SQLCODE_TOKEN,

Line 1363: Okc_Debug.Log('8200: Entered Delete_Row', 2);

1359:
1360: BEGIN
1361:
1362: IF (l_debug = 'Y') THEN
1363: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1364: END IF;
1365:
1366: DELETE FROM OKC_review_upld_header
1367: WHERE review_upld_header_ID = p_review_upld_header_ID;

Line 1370: Okc_Debug.Log('8300: Leaving Delete_Row', 2);

1366: DELETE FROM OKC_review_upld_header
1367: WHERE review_upld_header_ID = p_review_upld_header_ID;
1368:
1369: IF (l_debug = 'Y') THEN
1370: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1371: END IF;
1372:
1373: RETURN( G_RET_STS_SUCCESS );
1374:

Line 1379: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);

1375: EXCEPTION
1376: WHEN OTHERS THEN
1377:
1378: IF (l_debug = 'Y') THEN
1379: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1380: END IF;
1381:
1382: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1383: p_msg_name => G_UNEXPECTED_ERROR,

Line 1405: Okc_Debug.Log('8800: Entered Delete_Row', 2);

1401: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
1402: BEGIN
1403:
1404: IF (l_debug = 'Y') THEN
1405: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1406: Okc_Debug.Log('8900: Locking _B row', 2);
1407: END IF;
1408:
1409: x_return_status := Lock_row(

Line 1406: Okc_Debug.Log('8900: Locking _B row', 2);

1402: BEGIN
1403:
1404: IF (l_debug = 'Y') THEN
1405: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1406: Okc_Debug.Log('8900: Locking _B row', 2);
1407: END IF;
1408:
1409: x_return_status := Lock_row(
1410: p_review_upld_header_id => p_review_upld_header_id,

Line 1421: Okc_Debug.Log('9100: Removing _B row', 2);

1417: END IF;
1418:
1419:
1420: IF (l_debug = 'Y') THEN
1421: Okc_Debug.Log('9100: Removing _B row', 2);
1422: END IF;
1423: x_return_status := Delete_Row( p_review_upld_header_id => p_review_upld_header_id );
1424: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1432: Okc_Debug.Log('9300: Leaving Delete_Row', 2);

1428: END IF;
1429:
1430:
1431: IF (l_debug = 'Y') THEN
1432: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1433: END IF;
1434:
1435: EXCEPTION
1436: WHEN FND_API.G_EXC_ERROR THEN

Line 1438: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);

1434:
1435: EXCEPTION
1436: WHEN FND_API.G_EXC_ERROR THEN
1437: IF (l_debug = 'Y') THEN
1438: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1439: END IF;
1440: x_return_status := G_RET_STS_ERROR;
1441:
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1444: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1440: x_return_status := G_RET_STS_ERROR;
1441:
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1443: IF (l_debug = 'Y') THEN
1444: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1445: END IF;
1446: x_return_status := G_RET_STS_UNEXP_ERROR;
1447:
1448: WHEN OTHERS THEN

Line 1450: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);

1446: x_return_status := G_RET_STS_UNEXP_ERROR;
1447:
1448: WHEN OTHERS THEN
1449: IF (l_debug = 'Y') THEN
1450: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1451: END IF;
1452: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1453: p_msg_name => G_UNEXPECTED_ERROR,
1454: p_token1 => G_SQLCODE_TOKEN,