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

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

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

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

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

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

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

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

162: WHERE t.REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
163: BEGIN
164:
165: IF (l_debug = 'Y') THEN
166: Okc_Debug.Log('400: Entered get_rec', 2);
167: END IF;
168:
169: -- Get current database values
170: OPEN OKC_REVIEW_TERMS_PK_CSR (p_REVIEW_UPLD_TERMS_id);

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

197: END IF;
198: CLOSE OKC_REVIEW_TERMS_PK_CSR;
199:
200: IF (l_debug = 'Y') THEN
201: Okc_Debug.Log('500: Leaving get_rec ', 2);
202: END IF;
203:
204: RETURN G_RET_STS_SUCCESS ;
205:

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

206: EXCEPTION
207: WHEN OTHERS THEN
208:
209: IF (l_debug = 'Y') THEN
210: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
211: END IF;
212:
213: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
214: p_msg_name => G_UNEXPECTED_ERROR,

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

275: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
277: BEGIN
278: IF (l_debug = 'Y') THEN
279: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
280: END IF;
281:
282: IF( p_REVIEW_UPLD_TERMS_id IS NOT NULL ) THEN
283: -- Get current database values

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

422:
423: END IF;
424:
425: IF (l_debug = 'Y') THEN
426: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
427: END IF;
428:
429: RETURN G_RET_STS_SUCCESS ;
430: EXCEPTION

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

429: RETURN G_RET_STS_SUCCESS ;
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: IF (l_debug = 'Y') THEN
433: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
434: END IF;
435: RETURN G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

435: RETURN G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: IF (l_debug = 'Y') THEN
439: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
440: END IF;
441: RETURN G_RET_STS_UNEXP_ERROR;
442:
443: WHEN OTHERS THEN

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

441: RETURN G_RET_STS_UNEXP_ERROR;
442:
443: WHEN OTHERS THEN
444: IF (l_debug = 'Y') THEN
445: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
446: END IF;
447: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
448: p_msg_name => G_UNEXPECTED_ERROR,
449: p_token1 => G_SQLCODE_TOKEN,

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

517: */
518: BEGIN
519:
520: IF (l_debug = 'Y') THEN
521: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
522: END IF;
523:
524: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
525: IF (l_debug = 'Y') THEN

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

522: END IF;
523:
524: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
525: IF (l_debug = 'Y') THEN
526: Okc_Debug.Log('1300: required values validation', 2);
527: END IF;
528:
529: END IF;
530:

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

529: END IF;
530:
531: IF p_validation_level > G_VALID_VALUE_VALID_LEVEL THEN
532: IF (l_debug = 'Y') THEN
533: Okc_Debug.Log('1600: static values and range validation', 2);
534: END IF;
535:
536: END IF;
537:

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

536: END IF;
537:
538: IF p_validation_level > G_LOOKUP_CODE_VALID_LEVEL THEN
539: IF (l_debug = 'Y') THEN
540: Okc_Debug.Log('1900: lookup codes validation', 2);
541: END IF;
542: /* ?? uncomment next part after you check and change this lokkup codes validation
543:
544: */

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

545: END IF;
546:
547: IF p_validation_level > G_FOREIGN_KEY_VALID_LEVEL THEN
548: IF (l_debug = 'Y') THEN
549: Okc_Debug.Log('2100: foreigh keys validation ', 2);
550: END IF;
551: /* ?? uncomment next part after you check and change this foreign key validation
552:
553: IF (l_debug = 'Y') THEN

Line 554: Okc_Debug.Log('2200: - attribute REVIEW_UPLD_TERMS_ID ', 2);

550: END IF;
551: /* ?? uncomment next part after you check and change this foreign key validation
552:
553: IF (l_debug = 'Y') THEN
554: Okc_Debug.Log('2200: - attribute REVIEW_UPLD_TERMS_ID ', 2);
555: END IF;
556: IF p_REVIEW_UPLD_TERMS_id IS NOT NULL THEN
557: l_dummy_var := '?';
558: OPEN l_REVIEW_UPLD_TERMS_id_csr;

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

559: FETCH l_REVIEW_UPLD_TERMS_id_csr INTO l_dummy_var;
560: CLOSE l_REVIEW_UPLD_TERMS_id_csr;
561: IF (l_dummy_var = '?') THEN
562: IF (l_debug = 'Y') THEN
563: Okc_Debug.Log('2300: - attribute REVIEW_UPLD_TERMS_ID is invalid', 2);
564: END IF;
565: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'REVIEW_UPLD_TERMS_ID');
566: l_return_status := G_RET_STS_ERROR;
567: END IF;

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

567: END IF;
568: END IF;
569:
570: IF (l_debug = 'Y') THEN
571: Okc_Debug.Log('2200: - attribute DOCUMENT_ID ', 2);
572: END IF;
573: IF p_document_id IS NOT NULL THEN
574: l_dummy_var := '?';
575: OPEN l_document_id_csr;

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

576: FETCH l_document_id_csr INTO l_dummy_var;
577: CLOSE l_document_id_csr;
578: IF (l_dummy_var = '?') THEN
579: IF (l_debug = 'Y') THEN
580: Okc_Debug.Log('2300: - attribute DOCUMENT_ID is invalid', 2);
581: END IF;
582: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DOCUMENT_ID');
583: l_return_status := G_RET_STS_ERROR;
584: END IF;

Line 588: Okc_Debug.Log('2200: - attribute OBJECT_ID ', 2);

584: END IF;
585: END IF;
586:
587: IF (l_debug = 'Y') THEN
588: Okc_Debug.Log('2200: - attribute OBJECT_ID ', 2);
589: END IF;
590: IF p_object_id IS NOT NULL THEN
591: l_dummy_var := '?';
592: OPEN l_object_id_csr;

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

593: FETCH l_object_id_csr INTO l_dummy_var;
594: CLOSE l_object_id_csr;
595: IF (l_dummy_var = '?') THEN
596: IF (l_debug = 'Y') THEN
597: Okc_Debug.Log('2300: - attribute OBJECT_ID is invalid', 2);
598: END IF;
599: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OBJECT_ID');
600: l_return_status := G_RET_STS_ERROR;
601: END IF;

Line 605: Okc_Debug.Log('2200: - attribute PARENT_ID ', 2);

601: END IF;
602: END IF;
603:
604: IF (l_debug = 'Y') THEN
605: Okc_Debug.Log('2200: - attribute PARENT_ID ', 2);
606: END IF;
607: IF p_parent_id IS NOT NULL THEN
608: l_dummy_var := '?';
609: OPEN l_parent_id_csr;

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

610: FETCH l_parent_id_csr INTO l_dummy_var;
611: CLOSE l_parent_id_csr;
612: IF (l_dummy_var = '?') THEN
613: IF (l_debug = 'Y') THEN
614: Okc_Debug.Log('2300: - attribute PARENT_ID is invalid', 2);
615: END IF;
616: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARENT_ID');
617: l_return_status := G_RET_STS_ERROR;
618: END IF;

Line 622: Okc_Debug.Log('2200: - attribute ARTICLE_ID ', 2);

618: END IF;
619: END IF;
620:
621: IF (l_debug = 'Y') THEN
622: Okc_Debug.Log('2200: - attribute ARTICLE_ID ', 2);
623: END IF;
624: IF p_article_id IS NOT NULL THEN
625: l_dummy_var := '?';
626: OPEN l_article_id_csr;

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

627: FETCH l_article_id_csr INTO l_dummy_var;
628: CLOSE l_article_id_csr;
629: IF (l_dummy_var = '?') THEN
630: IF (l_debug = 'Y') THEN
631: Okc_Debug.Log('2300: - attribute ARTICLE_ID is invalid', 2);
632: END IF;
633: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_ID');
634: l_return_status := G_RET_STS_ERROR;
635: END IF;

Line 639: Okc_Debug.Log('2200: - attribute ARTICLE_VERSION_ID ', 2);

635: END IF;
636: END IF;
637:
638: IF (l_debug = 'Y') THEN
639: Okc_Debug.Log('2200: - attribute ARTICLE_VERSION_ID ', 2);
640: END IF;
641: IF p_article_version_id IS NOT NULL THEN
642: l_dummy_var := '?';
643: OPEN l_article_version_id_csr;

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

644: FETCH l_article_version_id_csr INTO l_dummy_var;
645: CLOSE l_article_version_id_csr;
646: IF (l_dummy_var = '?') THEN
647: IF (l_debug = 'Y') THEN
648: Okc_Debug.Log('2300: - attribute ARTICLE_VERSION_ID is invalid', 2);
649: END IF;
650: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ARTICLE_VERSION_ID');
651: l_return_status := G_RET_STS_ERROR;
652: END IF;

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

656: END IF;
657:
658:
659: IF (l_debug = 'Y') THEN
660: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
661: END IF;
662:
663: RETURN l_return_status;
664:

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

663: RETURN l_return_status;
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
668: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
669: p_msg_name => G_UNEXPECTED_ERROR,
670: p_token1 => G_SQLCODE_TOKEN,
671: p_token1_value => sqlcode,

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

736: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
737: BEGIN
738:
739: IF (l_debug = 'Y') THEN
740: Okc_Debug.Log('2600: Entered Validate_Record', 2);
741: END IF;
742:
743: --- Validate all non-missing attributes (Item Level Validation)
744: l_return_status := Validate_Attributes(

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

765:
766: );
767: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
768: IF (l_debug = 'Y') THEN
769: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
770: END IF;
771: RETURN G_RET_STS_UNEXP_ERROR;
772: END IF;
773:

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

773:
774: --- Record Level Validation
775: IF p_validation_level > G_RECORD_VALID_LEVEL THEN
776: IF (l_debug = 'Y') THEN
777: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
778: END IF;
779: /*+++++++++++++start of hand code +++++++++++++++++++*/
780: -- ?? manual coding for Record Level Validations if required ??
781: /*+++++++++++++End of hand code +++++++++++++++++++*/

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

781: /*+++++++++++++End of hand code +++++++++++++++++++*/
782: END IF;
783:
784: IF (l_debug = 'Y') THEN
785: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
786: END IF;
787: RETURN l_return_status ;
788:
789: EXCEPTION

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

789: EXCEPTION
790: WHEN OTHERS THEN
791:
792: IF (l_debug = 'Y') THEN
793: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
794: END IF;
795:
796: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
797: p_msg_name => G_UNEXPECTED_ERROR,

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

861: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
862: BEGIN
863:
864: IF (l_debug = 'Y') THEN
865: Okc_Debug.Log('3100: Entered validate_row', 2);
866: END IF;
867:
868: -- Setting attributes
869: x_return_status := Set_Attributes(

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

934: p_upload_level => l_upload_level
935: );
936:
937: IF (l_debug = 'Y') THEN
938: Okc_Debug.Log('3200: Leaving validate_row', 2);
939: END IF;
940:
941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN

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

940:
941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN
943: IF (l_debug = 'Y') THEN
944: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
945: END IF;
946: x_return_status := G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

946: x_return_status := G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: IF (l_debug = 'Y') THEN
950: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
951: END IF;
952: x_return_status := G_RET_STS_UNEXP_ERROR;
953:
954: WHEN OTHERS THEN

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

952: x_return_status := G_RET_STS_UNEXP_ERROR;
953:
954: WHEN OTHERS THEN
955: IF (l_debug = 'Y') THEN
956: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
957: END IF;
958: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
959: p_msg_name => G_UNEXPECTED_ERROR,
960: p_token1 => G_SQLCODE_TOKEN,

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

1001:
1002: BEGIN
1003:
1004: IF (l_debug = 'Y') THEN
1005: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
1006: END IF;
1007:
1008: INSERT INTO OKC_REVIEW_UPLD_TERMS(
1009: REVIEW_UPLD_TERMS_ID,

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

1056: p_last_update_login,
1057: p_last_update_date);
1058:
1059: IF (l_debug = 'Y') THEN
1060: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
1061: END IF;
1062:
1063: RETURN( G_RET_STS_SUCCESS );
1064:

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

1065: EXCEPTION
1066: WHEN OTHERS THEN
1067:
1068: IF (l_debug = 'Y') THEN
1069: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
1070: END IF;
1071:
1072: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1073: p_msg_name => G_UNEXPECTED_ERROR,

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

1121:
1122: x_return_status := G_RET_STS_SUCCESS;
1123:
1124: IF (l_debug = 'Y') THEN
1125: Okc_Debug.Log('4200: Entered Insert_Row', 2);
1126: END IF;
1127:
1128: --- Setting item attributes
1129: -- Set primary key value

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

1182: --------------------------------------------
1183: -- Call the internal Insert_Row for each child record
1184: --------------------------------------------
1185: IF (l_debug = 'Y') THEN
1186: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
1187: END IF;
1188:
1189: x_return_status := Insert_Row(
1190: p_REVIEW_UPLD_TERMS_id => x_REVIEW_UPLD_TERMS_id,

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

1220:
1221:
1222:
1223: IF (l_debug = 'Y') THEN
1224: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
1225: END IF;
1226:
1227: EXCEPTION
1228: WHEN FND_API.G_EXC_ERROR THEN

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

1226:
1227: EXCEPTION
1228: WHEN FND_API.G_EXC_ERROR THEN
1229: IF (l_debug = 'Y') THEN
1230: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1231: END IF;
1232: x_return_status := G_RET_STS_ERROR;
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1232: x_return_status := G_RET_STS_ERROR;
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: IF (l_debug = 'Y') THEN
1236: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1237: END IF;
1238: x_return_status := G_RET_STS_UNEXP_ERROR;
1239:
1240: WHEN OTHERS THEN

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

1238: x_return_status := G_RET_STS_UNEXP_ERROR;
1239:
1240: WHEN OTHERS THEN
1241: IF (l_debug = 'Y') THEN
1242: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
1243: END IF;
1244: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1245: p_msg_name => G_UNEXPECTED_ERROR,
1246: p_token1 => G_SQLCODE_TOKEN,

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

1278: WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
1279: BEGIN
1280:
1281: IF (l_debug = 'Y') THEN
1282: Okc_Debug.Log('4900: Entered Lock_Row', 2);
1283: END IF;
1284:
1285:
1286: BEGIN

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

1293: EXCEPTION
1294: WHEN E_Resource_Busy THEN
1295:
1296: IF (l_debug = 'Y') THEN
1297: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1298: END IF;
1299:
1300: IF (lock_csr%ISOPEN) THEN
1301: CLOSE lock_csr;

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

1325: l_return_status := G_RET_STS_SUCCESS;
1326: END IF;
1327:
1328: IF (l_debug = 'Y') THEN
1329: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1330: END IF;
1331:
1332: RETURN( l_return_status );
1333:

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

1341: CLOSE lchk_csr;
1342: END IF;
1343:
1344: IF (l_debug = 'Y') THEN
1345: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1346: END IF;
1347:
1348: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1349: p_msg_name => G_UNEXPECTED_ERROR,

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

1366: ) IS
1367: BEGIN
1368:
1369: IF (l_debug = 'Y') THEN
1370: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1371: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1372: END IF;
1373:
1374: --------------------------------------------

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

1367: BEGIN
1368:
1369: IF (l_debug = 'Y') THEN
1370: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1371: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1372: END IF;
1373:
1374: --------------------------------------------
1375: -- Call the LOCK_ROW for each _B child record

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

1386:
1387:
1388:
1389: IF (l_debug = 'Y') THEN
1390: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1391: END IF;
1392:
1393: EXCEPTION
1394: WHEN FND_API.G_EXC_ERROR THEN

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

1392:
1393: EXCEPTION
1394: WHEN FND_API.G_EXC_ERROR THEN
1395: IF (l_debug = 'Y') THEN
1396: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1397: END IF;
1398: x_return_status := G_RET_STS_ERROR;
1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1398: x_return_status := G_RET_STS_ERROR;
1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1401: IF (l_debug = 'Y') THEN
1402: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1403: END IF;
1404: x_return_status := G_RET_STS_UNEXP_ERROR;
1405:
1406: WHEN OTHERS THEN

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

1404: x_return_status := G_RET_STS_UNEXP_ERROR;
1405:
1406: WHEN OTHERS THEN
1407: IF (l_debug = 'Y') THEN
1408: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1409: END IF;
1410: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1411: p_msg_name => G_UNEXPECTED_ERROR,
1412: p_token1 => G_SQLCODE_TOKEN,

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

1449:
1450: BEGIN
1451:
1452: IF (l_debug = 'Y') THEN
1453: Okc_Debug.Log('6400: Entered Update_Row', 2);
1454: END IF;
1455:
1456: UPDATE OKC_REVIEW_UPLD_TERMS
1457: SET DOCUMENT_ID = p_document_id,

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

1477: LAST_UPDATE_DATE = p_last_update_date
1478: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_id;
1479:
1480: IF (l_debug = 'Y') THEN
1481: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1482: END IF;
1483:
1484: RETURN G_RET_STS_SUCCESS ;
1485:

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

1486: EXCEPTION
1487: WHEN OTHERS THEN
1488:
1489: IF (l_debug = 'Y') THEN
1490: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1491: END IF;
1492:
1493: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1494: p_msg_name => G_UNEXPECTED_ERROR,

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

1556:
1557: BEGIN
1558:
1559: IF (l_debug = 'Y') THEN
1560: Okc_Debug.Log('7000: Entered Update_Row', 2);
1561: Okc_Debug.Log('7100: Locking _B row', 2);
1562: END IF;
1563:
1564: x_return_status := Lock_row(

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

1557: BEGIN
1558:
1559: IF (l_debug = 'Y') THEN
1560: Okc_Debug.Log('7000: Entered Update_Row', 2);
1561: Okc_Debug.Log('7100: Locking _B row', 2);
1562: END IF;
1563:
1564: x_return_status := Lock_row(
1565: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,

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

1572: END IF;
1573:
1574:
1575: IF (l_debug = 'Y') THEN
1576: Okc_Debug.Log('7300: Setting attributes', 2);
1577: END IF;
1578:
1579: l_object_version_number := p_object_version_number;
1580: x_return_status := Set_Attributes(

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

1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: IF (l_debug = 'Y') THEN
1625: Okc_Debug.Log('7400: Record Validation', 2);
1626: END IF;
1627:
1628: --- Validate all non-missing attributes
1629: x_return_status := Validate_Record(

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

1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656:
1657: IF (l_debug = 'Y') THEN
1658: Okc_Debug.Log('7500: Filling WHO columns', 2);
1659: END IF;
1660:
1661: -- Filling who columns
1662: l_last_update_date := SYSDATE;

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

1672: --------------------------------------------
1673: -- Call the Update_Row for each child record
1674: --------------------------------------------
1675: IF (l_debug = 'Y') THEN
1676: Okc_Debug.Log('7600: Updating Row', 2);
1677: END IF;
1678:
1679: x_return_status := Update_Row(
1680: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,

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

1707: END IF;
1708:
1709:
1710: IF (l_debug = 'Y') THEN
1711: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1712: END IF;
1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN

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

1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN
1716: IF (l_debug = 'Y') THEN
1717: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1718: END IF;
1719: x_return_status := G_RET_STS_ERROR;
1720:
1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1719: x_return_status := G_RET_STS_ERROR;
1720:
1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1722: IF (l_debug = 'Y') THEN
1723: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1724: END IF;
1725: x_return_status := G_RET_STS_UNEXP_ERROR;
1726:
1727: WHEN OTHERS THEN

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

1725: x_return_status := G_RET_STS_UNEXP_ERROR;
1726:
1727: WHEN OTHERS THEN
1728: IF (l_debug = 'Y') THEN
1729: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1730: END IF;
1731: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1732: p_msg_name => G_UNEXPECTED_ERROR,
1733: p_token1 => G_SQLCODE_TOKEN,

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

1750:
1751: BEGIN
1752:
1753: IF (l_debug = 'Y') THEN
1754: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1755: END IF;
1756:
1757: DELETE FROM OKC_REVIEW_UPLD_TERMS
1758: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_ID;

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

1757: DELETE FROM OKC_REVIEW_UPLD_TERMS
1758: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_ID;
1759:
1760: IF (l_debug = 'Y') THEN
1761: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1762: END IF;
1763:
1764: RETURN( G_RET_STS_SUCCESS );
1765:

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

1766: EXCEPTION
1767: WHEN OTHERS THEN
1768:
1769: IF (l_debug = 'Y') THEN
1770: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1771: END IF;
1772:
1773: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1774: p_msg_name => G_UNEXPECTED_ERROR,

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

1792: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
1793: BEGIN
1794:
1795: IF (l_debug = 'Y') THEN
1796: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1797: Okc_Debug.Log('8900: Locking _B row', 2);
1798: END IF;
1799:
1800: x_return_status := Lock_row(

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

1793: BEGIN
1794:
1795: IF (l_debug = 'Y') THEN
1796: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1797: Okc_Debug.Log('8900: Locking _B row', 2);
1798: END IF;
1799:
1800: x_return_status := Lock_row(
1801: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,

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

1808: END IF;
1809:
1810:
1811: IF (l_debug = 'Y') THEN
1812: Okc_Debug.Log('9100: Removing _B row', 2);
1813: END IF;
1814: x_return_status := Delete_Row( p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id );
1815: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1819: END IF;
1820:
1821:
1822: IF (l_debug = 'Y') THEN
1823: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1824: END IF;
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN

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

1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: IF (l_debug = 'Y') THEN
1829: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1830: END IF;
1831: x_return_status := G_RET_STS_ERROR;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1831: x_return_status := G_RET_STS_ERROR;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF (l_debug = 'Y') THEN
1835: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1836: END IF;
1837: x_return_status := G_RET_STS_UNEXP_ERROR;
1838:
1839: WHEN OTHERS THEN

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

1837: x_return_status := G_RET_STS_UNEXP_ERROR;
1838:
1839: WHEN OTHERS THEN
1840: IF (l_debug = 'Y') THEN
1841: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1842: END IF;
1843: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1844: p_msg_name => G_UNEXPECTED_ERROR,
1845: p_token1 => G_SQLCODE_TOKEN,