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

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

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

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

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

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

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

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

142: WHERE t.REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
143: BEGIN
144:
145: IF (l_debug = 'Y') THEN
146: Okc_Debug.Log('400: Entered get_rec', 2);
147: END IF;
148:
149: -- Get current database values
150: OPEN OKC_REVIEW_VAR_VALUES_pk_csr (p_REVIEW_UPLD_TERMS_id);

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

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

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

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

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

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

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

309:
310: END IF;
311:
312: IF (l_debug = 'Y') THEN
313: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
314: END IF;
315:
316: RETURN G_RET_STS_SUCCESS ;
317: EXCEPTION

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

316: RETURN G_RET_STS_SUCCESS ;
317: EXCEPTION
318: WHEN FND_API.G_EXC_ERROR THEN
319: IF (l_debug = 'Y') THEN
320: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
321: END IF;
322: RETURN G_RET_STS_ERROR;
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

322: RETURN G_RET_STS_ERROR;
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: IF (l_debug = 'Y') THEN
326: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
327: END IF;
328: RETURN G_RET_STS_UNEXP_ERROR;
329:
330: WHEN OTHERS THEN

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

328: RETURN G_RET_STS_UNEXP_ERROR;
329:
330: WHEN OTHERS THEN
331: IF (l_debug = 'Y') THEN
332: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
333: END IF;
334: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
335: p_msg_name => G_UNEXPECTED_ERROR,
336: p_token1 => G_SQLCODE_TOKEN,

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

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

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

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

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

395: END IF;
396:
397: IF p_validation_level > G_VALID_VALUE_VALID_LEVEL THEN
398: IF (l_debug = 'Y') THEN
399: Okc_Debug.Log('1600: static values and range validation', 2);
400: END IF;
401:
402: END IF;
403:

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

402: END IF;
403:
404: IF p_validation_level > G_LOOKUP_CODE_VALID_LEVEL THEN
405: IF (l_debug = 'Y') THEN
406: Okc_Debug.Log('1900: lookup codes validation', 2);
407: END IF;
408: /* ?? uncomment next part after you check and change this lokkup codes validation
409:
410: IF (l_debug = 'Y') THEN

Line 411: Okc_Debug.Log('2000: - attribute VARIABLE_CODE ', 2);

407: END IF;
408: /* ?? uncomment next part after you check and change this lokkup codes validation
409:
410: IF (l_debug = 'Y') THEN
411: Okc_Debug.Log('2000: - attribute VARIABLE_CODE ', 2);
412: END IF;
413: IF p_variable_code IS NOT NULL THEN
414: l_return_status := Okc_Util.Check_Lookup_Code(??'lookup_code_type'??,p_variable_code);
415: IF (l_return_status <> G_RET_STS_SUCCESS) THEN

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

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

Line 431: Okc_Debug.Log('2200: - attribute REVIEW_VAR_VALUES_ID ', 2);

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

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

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

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

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

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

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

Line 465: Okc_Debug.Log('2200: - attribute VARIABLE_VALUE_ID ', 2);

461: END IF;
462: END IF;
463:
464: IF (l_debug = 'Y') THEN
465: Okc_Debug.Log('2200: - attribute VARIABLE_VALUE_ID ', 2);
466: END IF;
467: IF p_variable_value_id IS NOT NULL THEN
468: l_dummy_var := '?';
469: OPEN l_variable_value_id_csr;

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

470: FETCH l_variable_value_id_csr INTO l_dummy_var;
471: CLOSE l_variable_value_id_csr;
472: IF (l_dummy_var = '?') THEN
473: IF (l_debug = 'Y') THEN
474: Okc_Debug.Log('2300: - attribute VARIABLE_VALUE_ID is invalid', 2);
475: END IF;
476: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VARIABLE_VALUE_ID');
477: l_return_status := G_RET_STS_ERROR;
478: END IF;

Line 482: Okc_Debug.Log('2200: - attribute ATTRIBUTE_VALUE_SET_ID ', 2);

478: END IF;
479: END IF;
480:
481: IF (l_debug = 'Y') THEN
482: Okc_Debug.Log('2200: - attribute ATTRIBUTE_VALUE_SET_ID ', 2);
483: END IF;
484: IF p_attribute_value_set_id IS NOT NULL THEN
485: l_dummy_var := '?';
486: OPEN l_attribute_value_set_id_csr;

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

487: FETCH l_attribute_value_set_id_csr INTO l_dummy_var;
488: CLOSE l_attribute_value_set_id_csr;
489: IF (l_dummy_var = '?') THEN
490: IF (l_debug = 'Y') THEN
491: Okc_Debug.Log('2300: - attribute ATTRIBUTE_VALUE_SET_ID is invalid', 2);
492: END IF;
493: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ATTRIBUTE_VALUE_SET_ID');
494: l_return_status := G_RET_STS_ERROR;
495: END IF;

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

499: END IF;
500:
501:
502: IF (l_debug = 'Y') THEN
503: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
504: END IF;
505:
506: RETURN l_return_status;
507:

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

506: RETURN l_return_status;
507:
508: EXCEPTION
509: WHEN OTHERS THEN
510: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
511: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
512: p_msg_name => G_UNEXPECTED_ERROR,
513: p_token1 => G_SQLCODE_TOKEN,
514: p_token1_value => sqlcode,

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

561: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
562: BEGIN
563:
564: IF (l_debug = 'Y') THEN
565: Okc_Debug.Log('2600: Entered Validate_Record', 2);
566: END IF;
567:
568: --- Validate all non-missing attributes (Item Level Validation)
569: l_return_status := Validate_Attributes(

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

579: p_attribute_value_set_id => p_attribute_value_set_id
580: );
581: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
582: IF (l_debug = 'Y') THEN
583: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
584: END IF;
585: RETURN G_RET_STS_UNEXP_ERROR;
586: END IF;
587:

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

587:
588: --- Record Level Validation
589: IF p_validation_level > G_RECORD_VALID_LEVEL THEN
590: IF (l_debug = 'Y') THEN
591: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
592: END IF;
593: /*+++++++++++++start of hand code +++++++++++++++++++*/
594: -- ?? manual coding for Record Level Validations if required ??
595: /*+++++++++++++End of hand code +++++++++++++++++++*/

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

595: /*+++++++++++++End of hand code +++++++++++++++++++*/
596: END IF;
597:
598: IF (l_debug = 'Y') THEN
599: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
600: END IF;
601: RETURN l_return_status ;
602:
603: EXCEPTION

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

603: EXCEPTION
604: WHEN OTHERS THEN
605:
606: IF (l_debug = 'Y') THEN
607: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
608: END IF;
609:
610: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
611: p_msg_name => G_UNEXPECTED_ERROR,

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

656: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
657: BEGIN
658:
659: IF (l_debug = 'Y') THEN
660: Okc_Debug.Log('3100: Entered validate_row', 2);
661: END IF;
662:
663: -- Setting attributes
664: x_return_status := Set_Attributes(

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

699: p_attribute_value_set_id => l_attribute_value_set_id
700: );
701:
702: IF (l_debug = 'Y') THEN
703: Okc_Debug.Log('3200: Leaving validate_row', 2);
704: END IF;
705:
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN

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

705:
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: IF (l_debug = 'Y') THEN
709: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
710: END IF;
711: x_return_status := G_RET_STS_ERROR;
712:
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

711: x_return_status := G_RET_STS_ERROR;
712:
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714: IF (l_debug = 'Y') THEN
715: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
716: END IF;
717: x_return_status := G_RET_STS_UNEXP_ERROR;
718:
719: WHEN OTHERS THEN

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

717: x_return_status := G_RET_STS_UNEXP_ERROR;
718:
719: WHEN OTHERS THEN
720: IF (l_debug = 'Y') THEN
721: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
722: END IF;
723: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
724: p_msg_name => G_UNEXPECTED_ERROR,
725: p_token1 => G_SQLCODE_TOKEN,

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

756:
757: BEGIN
758:
759: IF (l_debug = 'Y') THEN
760: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
761: END IF;
762:
763: INSERT INTO OKC_REVIEW_VAR_VALUES(
764: REVIEW_VAR_VALUES_ID,

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

792: p_last_update_login,
793: p_last_update_date);
794:
795: IF (l_debug = 'Y') THEN
796: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
797: END IF;
798:
799: RETURN( G_RET_STS_SUCCESS );
800:

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

801: EXCEPTION
802: WHEN OTHERS THEN
803:
804: IF (l_debug = 'Y') THEN
805: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
806: END IF;
807:
808: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
809: p_msg_name => G_UNEXPECTED_ERROR,

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

848:
849: x_return_status := G_RET_STS_SUCCESS;
850:
851: IF (l_debug = 'Y') THEN
852: Okc_Debug.Log('4200: Entered Insert_Row', 2);
853: END IF;
854:
855: --- Setting item attributes
856: -- Set primary key value

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

899: --------------------------------------------
900: -- Call the internal Insert_Row for each child record
901: --------------------------------------------
902: IF (l_debug = 'Y') THEN
903: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
904: END IF;
905:
906: x_return_status := Insert_Row(
907: p_REVIEW_UPLD_TERMS_id => x_REVIEW_UPLD_TERMS_id,

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

930:
931:
932:
933: IF (l_debug = 'Y') THEN
934: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
935: END IF;
936:
937: EXCEPTION
938: WHEN FND_API.G_EXC_ERROR THEN

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

936:
937: EXCEPTION
938: WHEN FND_API.G_EXC_ERROR THEN
939: IF (l_debug = 'Y') THEN
940: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
941: END IF;
942: x_return_status := G_RET_STS_ERROR;
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

942: x_return_status := G_RET_STS_ERROR;
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: IF (l_debug = 'Y') THEN
946: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
947: END IF;
948: x_return_status := G_RET_STS_UNEXP_ERROR;
949:
950: WHEN OTHERS THEN

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

948: x_return_status := G_RET_STS_UNEXP_ERROR;
949:
950: WHEN OTHERS THEN
951: IF (l_debug = 'Y') THEN
952: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
953: END IF;
954: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
955: p_msg_name => G_UNEXPECTED_ERROR,
956: p_token1 => G_SQLCODE_TOKEN,

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

988: WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
989: BEGIN
990:
991: IF (l_debug = 'Y') THEN
992: Okc_Debug.Log('4900: Entered Lock_Row', 2);
993: END IF;
994:
995:
996: BEGIN

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

1003: EXCEPTION
1004: WHEN E_Resource_Busy THEN
1005:
1006: IF (l_debug = 'Y') THEN
1007: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1008: END IF;
1009:
1010: IF (lock_csr%ISOPEN) THEN
1011: CLOSE lock_csr;

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

1035: l_return_status := G_RET_STS_SUCCESS;
1036: END IF;
1037:
1038: IF (l_debug = 'Y') THEN
1039: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1040: END IF;
1041:
1042: RETURN( l_return_status );
1043:

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

1051: CLOSE lchk_csr;
1052: END IF;
1053:
1054: IF (l_debug = 'Y') THEN
1055: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1056: END IF;
1057:
1058: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1059: p_msg_name => G_UNEXPECTED_ERROR,

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

1076: ) IS
1077: BEGIN
1078:
1079: IF (l_debug = 'Y') THEN
1080: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1081: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1082: END IF;
1083:
1084: --------------------------------------------

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

1077: BEGIN
1078:
1079: IF (l_debug = 'Y') THEN
1080: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1081: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1082: END IF;
1083:
1084: --------------------------------------------
1085: -- Call the LOCK_ROW for each _B child record

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

1096:
1097:
1098:
1099: IF (l_debug = 'Y') THEN
1100: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1101: END IF;
1102:
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN

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

1102:
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN
1105: IF (l_debug = 'Y') THEN
1106: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1107: END IF;
1108: x_return_status := G_RET_STS_ERROR;
1109:
1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1108: x_return_status := G_RET_STS_ERROR;
1109:
1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1111: IF (l_debug = 'Y') THEN
1112: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1113: END IF;
1114: x_return_status := G_RET_STS_UNEXP_ERROR;
1115:
1116: WHEN OTHERS THEN

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

1114: x_return_status := G_RET_STS_UNEXP_ERROR;
1115:
1116: WHEN OTHERS THEN
1117: IF (l_debug = 'Y') THEN
1118: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1119: END IF;
1120: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1121: p_msg_name => G_UNEXPECTED_ERROR,
1122: p_token1 => G_SQLCODE_TOKEN,

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

1149:
1150: BEGIN
1151:
1152: IF (l_debug = 'Y') THEN
1153: Okc_Debug.Log('6400: Entered Update_Row', 2);
1154: END IF;
1155:
1156: UPDATE OKC_REVIEW_VAR_VALUES
1157: SET REVIEW_VAR_VALUES_ID = p_REVIEW_VAR_VALUES_id,

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

1167: LAST_UPDATE_DATE = p_last_update_date
1168: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_id;
1169:
1170: IF (l_debug = 'Y') THEN
1171: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1172: END IF;
1173:
1174: RETURN G_RET_STS_SUCCESS ;
1175:

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

1176: EXCEPTION
1177: WHEN OTHERS THEN
1178:
1179: IF (l_debug = 'Y') THEN
1180: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1181: END IF;
1182:
1183: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1184: p_msg_name => G_UNEXPECTED_ERROR,

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

1227:
1228: BEGIN
1229:
1230: IF (l_debug = 'Y') THEN
1231: Okc_Debug.Log('7000: Entered Update_Row', 2);
1232: Okc_Debug.Log('7100: Locking _B row', 2);
1233: END IF;
1234:
1235: x_return_status := Lock_row(

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

1228: BEGIN
1229:
1230: IF (l_debug = 'Y') THEN
1231: Okc_Debug.Log('7000: Entered Update_Row', 2);
1232: Okc_Debug.Log('7100: Locking _B row', 2);
1233: END IF;
1234:
1235: x_return_status := Lock_row(
1236: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,

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

1243: END IF;
1244:
1245:
1246: IF (l_debug = 'Y') THEN
1247: Okc_Debug.Log('7300: Setting attributes', 2);
1248: END IF;
1249:
1250: l_object_version_number := p_object_version_number;
1251: x_return_status := Set_Attributes(

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

1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274:
1275: IF (l_debug = 'Y') THEN
1276: Okc_Debug.Log('7400: Record Validation', 2);
1277: END IF;
1278:
1279: --- Validate all non-missing attributes
1280: x_return_status := Validate_Record(

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

1295: RAISE FND_API.G_EXC_ERROR;
1296: END IF;
1297:
1298: IF (l_debug = 'Y') THEN
1299: Okc_Debug.Log('7500: Filling WHO columns', 2);
1300: END IF;
1301:
1302: -- Filling who columns
1303: l_last_update_date := SYSDATE;

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

1313: --------------------------------------------
1314: -- Call the Update_Row for each child record
1315: --------------------------------------------
1316: IF (l_debug = 'Y') THEN
1317: Okc_Debug.Log('7600: Updating Row', 2);
1318: END IF;
1319:
1320: x_return_status := Update_Row(
1321: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,

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

1338: END IF;
1339:
1340:
1341: IF (l_debug = 'Y') THEN
1342: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1343: END IF;
1344:
1345: EXCEPTION
1346: WHEN FND_API.G_EXC_ERROR THEN

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

1344:
1345: EXCEPTION
1346: WHEN FND_API.G_EXC_ERROR THEN
1347: IF (l_debug = 'Y') THEN
1348: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1349: END IF;
1350: x_return_status := G_RET_STS_ERROR;
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1350: x_return_status := G_RET_STS_ERROR;
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353: IF (l_debug = 'Y') THEN
1354: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1355: END IF;
1356: x_return_status := G_RET_STS_UNEXP_ERROR;
1357:
1358: WHEN OTHERS THEN

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

1356: x_return_status := G_RET_STS_UNEXP_ERROR;
1357:
1358: WHEN OTHERS THEN
1359: IF (l_debug = 'Y') THEN
1360: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1361: END IF;
1362: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1363: p_msg_name => G_UNEXPECTED_ERROR,
1364: p_token1 => G_SQLCODE_TOKEN,

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

1381:
1382: BEGIN
1383:
1384: IF (l_debug = 'Y') THEN
1385: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1386: END IF;
1387:
1388: DELETE FROM OKC_REVIEW_VAR_VALUES
1389: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_ID;

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

1389: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_ID;
1390: COMMIT;
1391:
1392: IF (l_debug = 'Y') THEN
1393: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1394: END IF;
1395:
1396: RETURN( G_RET_STS_SUCCESS );
1397:

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

1398: EXCEPTION
1399: WHEN OTHERS THEN
1400:
1401: IF (l_debug = 'Y') THEN
1402: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1403: END IF;
1404:
1405: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1406: p_msg_name => G_UNEXPECTED_ERROR,

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

1424: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
1425: BEGIN
1426:
1427: IF (l_debug = 'Y') THEN
1428: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1429: Okc_Debug.Log('8900: Locking _B row', 2);
1430: END IF;
1431:
1432: x_return_status := Lock_row(

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

1425: BEGIN
1426:
1427: IF (l_debug = 'Y') THEN
1428: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1429: Okc_Debug.Log('8900: Locking _B row', 2);
1430: END IF;
1431:
1432: x_return_status := Lock_row(
1433: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,

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

1440: END IF;
1441:
1442:
1443: IF (l_debug = 'Y') THEN
1444: Okc_Debug.Log('9100: Removing _B row', 2);
1445: END IF;
1446: x_return_status := Delete_Row( p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id );
1447: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1451: END IF;
1452:
1453:
1454: IF (l_debug = 'Y') THEN
1455: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1456: END IF;
1457:
1458: EXCEPTION
1459: WHEN FND_API.G_EXC_ERROR THEN

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

1457:
1458: EXCEPTION
1459: WHEN FND_API.G_EXC_ERROR THEN
1460: IF (l_debug = 'Y') THEN
1461: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1462: END IF;
1463: x_return_status := G_RET_STS_ERROR;
1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1463: x_return_status := G_RET_STS_ERROR;
1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: IF (l_debug = 'Y') THEN
1467: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1468: END IF;
1469: x_return_status := G_RET_STS_UNEXP_ERROR;
1470:
1471: WHEN OTHERS THEN

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

1469: x_return_status := G_RET_STS_UNEXP_ERROR;
1470:
1471: WHEN OTHERS THEN
1472: IF (l_debug = 'Y') THEN
1473: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1474: END IF;
1475: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1476: p_msg_name => G_UNEXPECTED_ERROR,
1477: p_token1 => G_SQLCODE_TOKEN,