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_ARTICLE_ADOPTIONS_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_ARTICLES_ALL_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_global_article_version_id IS NULL AND p_local_org_id IS NULL AND p_local_article_version_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 154: Okc_Debug.Log('400: Entered get_rec', 2);

150:
151: BEGIN
152:
153: IF (l_debug = 'Y') THEN
154: Okc_Debug.Log('400: Entered get_rec', 2);
155: END IF;
156:
157: -- Get current database values
158: IF p_local_article_version_id IS NOT NULL THEN

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

188: CLOSE OKC_ADOPTIONS_wo_lv_csr;
189: END IF;
190:
191: IF (l_debug = 'Y') THEN
192: Okc_Debug.Log('500: Leaving get_rec ', 2);
193: END IF;
194:
195: RETURN G_RET_STS_SUCCESS ;
196:

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

197: EXCEPTION
198: WHEN OTHERS THEN
199:
200: IF (l_debug = 'Y') THEN
201: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
202: END IF;
203:
204: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
205: p_msg_name => G_UNEXPECTED_ERROR,

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

241: l_last_update_login OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;
242: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
243: BEGIN
244: IF (l_debug = 'Y') THEN
245: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
246: END IF;
247:
248: -- p_global_article_version_id should NEVER be NULL. However for update
249: -- of an adoption row from LOCALIZED to AVAILABLE, the calling program need not

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

295: x_adoption_status := p_adoption_status;
296: END IF;
297:
298: IF (l_debug = 'Y') THEN
299: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
300: END IF;
301:
302: RETURN G_RET_STS_SUCCESS ;
303: EXCEPTION

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

302: RETURN G_RET_STS_SUCCESS ;
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: IF (l_debug = 'Y') THEN
306: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
307: END IF;
308: RETURN G_RET_STS_ERROR;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

308: RETURN G_RET_STS_ERROR;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: IF (l_debug = 'Y') THEN
312: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
313: END IF;
314: RETURN G_RET_STS_UNEXP_ERROR;
315:
316: WHEN OTHERS THEN

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

314: RETURN G_RET_STS_UNEXP_ERROR;
315:
316: WHEN OTHERS THEN
317: IF (l_debug = 'Y') THEN
318: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
319: END IF;
320: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
321: p_msg_name => G_UNEXPECTED_ERROR,
322: p_token1 => G_SQLCODE_TOKEN,

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

362:
363: BEGIN
364:
365: IF (l_debug = 'Y') THEN
366: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
367: END IF;
368:
369: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
370: IF (l_debug = 'Y') THEN

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

367: END IF;
368:
369: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
370: IF (l_debug = 'Y') THEN
371: Okc_Debug.Log('1300: required values validation', 2);
372: END IF;
373:
374: IF (l_debug = 'Y') THEN
375: Okc_Debug.Log('1400: - attribute GLOBAL_ARTICLE_VERSION_ID ', 2);

Line 375: Okc_Debug.Log('1400: - attribute GLOBAL_ARTICLE_VERSION_ID ', 2);

371: Okc_Debug.Log('1300: required values validation', 2);
372: END IF;
373:
374: IF (l_debug = 'Y') THEN
375: Okc_Debug.Log('1400: - attribute GLOBAL_ARTICLE_VERSION_ID ', 2);
376: END IF;
377: IF ( p_global_article_version_id IS NULL) THEN
378: IF (l_debug = 'Y') THEN
379: Okc_Debug.Log('1500: - attribute GLOBAL_ARTICLE_VERSION_ID is invalid', 2);

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

375: Okc_Debug.Log('1400: - attribute GLOBAL_ARTICLE_VERSION_ID ', 2);
376: END IF;
377: IF ( p_global_article_version_id IS NULL) THEN
378: IF (l_debug = 'Y') THEN
379: Okc_Debug.Log('1500: - attribute GLOBAL_ARTICLE_VERSION_ID is invalid', 2);
380: END IF;
381: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'GLOBAL_ARTICLE_VERSION_ID');
382: l_return_status := G_RET_STS_ERROR;
383: END IF;

Line 386: Okc_Debug.Log('1400: - attribute ADOPTION_TYPE ', 2);

382: l_return_status := G_RET_STS_ERROR;
383: END IF;
384:
385: IF (l_debug = 'Y') THEN
386: Okc_Debug.Log('1400: - attribute ADOPTION_TYPE ', 2);
387: END IF;
388: IF ( p_adoption_type IS NULL) THEN
389: IF (l_debug = 'Y') THEN
390: Okc_Debug.Log('1500: - attribute ADOPTION_TYPE is invalid', 2);

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

386: Okc_Debug.Log('1400: - attribute ADOPTION_TYPE ', 2);
387: END IF;
388: IF ( p_adoption_type IS NULL) THEN
389: IF (l_debug = 'Y') THEN
390: Okc_Debug.Log('1500: - attribute ADOPTION_TYPE is invalid', 2);
391: END IF;
392: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ADOPTION_TYPE');
393: l_return_status := G_RET_STS_ERROR;
394: END IF;

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

393: l_return_status := G_RET_STS_ERROR;
394: END IF;
395:
396: IF (l_debug = 'Y') THEN
397: Okc_Debug.Log('1400: - attribute LOCAL_ORG_ID ', 2);
398: END IF;
399: IF ( p_local_org_id IS NULL) THEN
400: IF (l_debug = 'Y') THEN
401: Okc_Debug.Log('1500: - attribute LOCAL_ORG_ID is invalid', 2);

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

397: Okc_Debug.Log('1400: - attribute LOCAL_ORG_ID ', 2);
398: END IF;
399: IF ( p_local_org_id IS NULL) THEN
400: IF (l_debug = 'Y') THEN
401: Okc_Debug.Log('1500: - attribute LOCAL_ORG_ID is invalid', 2);
402: END IF;
403: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'LOCAL_ORG_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:
421: --Modified
422: IF (l_debug = 'Y') THEN

Line 423: Okc_Debug.Log('2000: - attribute ADOPTION_TYPE ', 2);

419: END IF;
420:
421: --Modified
422: IF (l_debug = 'Y') THEN
423: Okc_Debug.Log('2000: - attribute ADOPTION_TYPE ', 2);
424: END IF;
425: IF p_adoption_type IS NOT NULL THEN
426: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_ADOPTION_TYPE',p_adoption_type);
427: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN

Line 434: Okc_Debug.Log('2000: - attribute ADOPTION_STATUS ', 2);

430: END IF;
431: END IF;
432:
433: IF (l_debug = 'Y') THEN
434: Okc_Debug.Log('2000: - attribute ADOPTION_STATUS ', 2);
435: END IF;
436: IF p_adoption_status IS NOT NULL THEN
437: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_STATUS',p_adoption_status);
438: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN

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

447: END IF;
448:
449: IF p_validation_level > G_FOREIGN_KEY_VALID_LEVEL THEN
450: IF (l_debug = 'Y') THEN
451: Okc_Debug.Log('2100: foreigh keys validation ', 2);
452: END IF;
453:
454: IF (l_debug = 'Y') THEN
455: Okc_Debug.Log('2200: - attribute GLOBAL_ARTICLE_VERSION_ID ', 2);

Line 455: Okc_Debug.Log('2200: - attribute GLOBAL_ARTICLE_VERSION_ID ', 2);

451: Okc_Debug.Log('2100: foreigh keys validation ', 2);
452: END IF;
453:
454: IF (l_debug = 'Y') THEN
455: Okc_Debug.Log('2200: - attribute GLOBAL_ARTICLE_VERSION_ID ', 2);
456: END IF;
457: IF p_global_article_version_id IS NOT NULL THEN
458: l_dummy_var := '?';
459: OPEN l_global_art_ver_csr;

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

460: FETCH l_global_art_ver_csr INTO l_dummy_var;
461: CLOSE l_global_art_ver_csr;
462: IF (l_dummy_var = '?') THEN
463: IF (l_debug = 'Y') THEN
464: Okc_Debug.Log('2300: - attribute GLOBAL_ARTICLE_VERSION_ID is invalid', 2);
465: END IF;
466: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'GLOBAL_ARTICLE_VERSION_ID');
467: l_return_status := G_RET_STS_ERROR;
468: END IF;

Line 472: Okc_Debug.Log('2200: - attribute LOCAL_ORG_ID ', 2);

468: END IF;
469: END IF;
470:
471: IF (l_debug = 'Y') THEN
472: Okc_Debug.Log('2200: - attribute LOCAL_ORG_ID ', 2);
473: END IF;
474: IF p_local_org_id IS NOT NULL THEN
475: l_dummy_var := '?';
476: OPEN l_local_org_id_csr;

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

477: FETCH l_local_org_id_csr INTO l_dummy_var;
478: CLOSE l_local_org_id_csr;
479: IF (l_dummy_var = '?') THEN
480: IF (l_debug = 'Y') THEN
481: Okc_Debug.Log('2300: - attribute LOCAL_ORG_ID is invalid', 2);
482: END IF;
483: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LOCAL_ORG_ID');
484: l_return_status := G_RET_STS_ERROR;
485: END IF;

Line 489: Okc_Debug.Log('2200: - attribute LOCAL_ARTICLE_VERSION_ID ', 2);

485: END IF;
486: END IF;
487:
488: IF (l_debug = 'Y') THEN
489: Okc_Debug.Log('2200: - attribute LOCAL_ARTICLE_VERSION_ID ', 2);
490: END IF;
491: IF p_local_article_version_id IS NOT NULL THEN
492: l_dummy_var := '?';
493: OPEN l_local_art_ver_csr;

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

494: FETCH l_local_art_ver_csr INTO l_dummy_var;
495: CLOSE l_local_art_ver_csr;
496: IF (l_dummy_var = '?') THEN
497: IF (l_debug = 'Y') THEN
498: Okc_Debug.Log('2300: - attribute LOCAL_ARTICLE_VERSION_ID is invalid', 2);
499: END IF;
500: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LOCAL_ARTICLE_VERSION_ID');
501: l_return_status := G_RET_STS_ERROR;
502: END IF;

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

505: END IF;
506:
507:
508: IF (l_debug = 'Y') THEN
509: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
510: END IF;
511:
512: RETURN l_return_status;
513:

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

512: RETURN l_return_status;
513:
514: EXCEPTION
515: WHEN OTHERS THEN
516: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
517: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
518: p_msg_name => G_UNEXPECTED_ERROR,
519: p_token1 => G_SQLCODE_TOKEN,
520: p_token1_value => sqlcode,

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

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

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

572: p_adoption_status => p_adoption_status
573: );
574: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
575: IF (l_debug = 'Y') THEN
576: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
577: END IF;
578: RETURN G_RET_STS_UNEXP_ERROR;
579: END IF;
580:

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

580:
581: --- Record Level Validation
582: IF p_validation_level > G_RECORD_VALID_LEVEL THEN
583: IF (l_debug = 'Y') THEN
584: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
585: END IF;
586: /*+++++++++++++start of hand code +++++++++++++++++++*/
587: -- ?? manual coding for Record Level Validations if required ??
588: /*+++++++++++++End of hand code +++++++++++++++++++*/

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

588: /*+++++++++++++End of hand code +++++++++++++++++++*/
589: END IF;
590:
591: IF (l_debug = 'Y') THEN
592: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
593: END IF;
594: RETURN l_return_status ;
595:
596: EXCEPTION

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

596: EXCEPTION
597: WHEN OTHERS THEN
598:
599: IF (l_debug = 'Y') THEN
600: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
601: END IF;
602:
603: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
604: p_msg_name => G_UNEXPECTED_ERROR,

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

642: l_last_update_date OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;
643: BEGIN
644:
645: IF (l_debug = 'Y') THEN
646: Okc_Debug.Log('3100: Entered validate_row', 2);
647: END IF;
648:
649: l_global_article_version_id := p_global_article_version_id;
650: -- Setting attributes

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

674: p_adoption_status => l_adoption_status
675: );
676:
677: IF (l_debug = 'Y') THEN
678: Okc_Debug.Log('3200: Leaving validate_row', 2);
679: END IF;
680:
681: EXCEPTION
682: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

686: x_return_status := G_RET_STS_ERROR;
687:
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: IF (l_debug = 'Y') THEN
690: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
691: END IF;
692: x_return_status := G_RET_STS_UNEXP_ERROR;
693:
694: WHEN OTHERS THEN

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

692: x_return_status := G_RET_STS_UNEXP_ERROR;
693:
694: WHEN OTHERS THEN
695: IF (l_debug = 'Y') THEN
696: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
697: END IF;
698: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
699: p_msg_name => G_UNEXPECTED_ERROR,
700: p_token1 => G_SQLCODE_TOKEN,

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

728:
729: BEGIN
730:
731: IF (l_debug = 'Y') THEN
732: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
733: END IF;
734:
735: INSERT INTO OKC_ARTICLE_ADOPTIONS(
736: GLOBAL_ARTICLE_VERSION_ID,

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

757: p_last_update_login,
758: p_last_update_date);
759:
760: IF (l_debug = 'Y') THEN
761: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
762: END IF;
763:
764: RETURN( G_RET_STS_SUCCESS );
765:

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

766: EXCEPTION
767: WHEN OTHERS THEN
768:
769: IF (l_debug = 'Y') THEN
770: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
771: END IF;
772:
773: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
774: p_msg_name => G_UNEXPECTED_ERROR,

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

813:
814: x_return_status := G_RET_STS_SUCCESS;
815:
816: IF (l_debug = 'Y') THEN
817: Okc_Debug.Log('4200: Entered Insert_Row', 2);
818: END IF;
819:
820: --- Setting item attributes
821: -- Set primary key value

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

855: --------------------------------------------
856: -- Call the internal Insert_Row for each child record
857: --------------------------------------------
858: IF (l_debug = 'Y') THEN
859: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
860: END IF;
861:
862: x_return_status := Insert_Row(
863: p_global_article_version_id => x_global_article_version_id,

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

880:
881:
882:
883: IF (l_debug = 'Y') THEN
884: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
885: END IF;
886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_ERROR THEN

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

886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_ERROR THEN
889: IF (l_debug = 'Y') THEN
890: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
891: END IF;
892: x_return_status := G_RET_STS_ERROR;
893:
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

892: x_return_status := G_RET_STS_ERROR;
893:
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF (l_debug = 'Y') THEN
896: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
897: END IF;
898: x_return_status := G_RET_STS_UNEXP_ERROR;
899:
900: WHEN OTHERS THEN

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

898: x_return_status := G_RET_STS_UNEXP_ERROR;
899:
900: WHEN OTHERS THEN
901: IF (l_debug = 'Y') THEN
902: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
903: END IF;
904: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
905: p_msg_name => G_UNEXPECTED_ERROR,
906: p_token1 => G_SQLCODE_TOKEN,

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

961: l_row_notfound BOOLEAN := FALSE;
962: BEGIN
963:
964: IF (l_debug = 'Y') THEN
965: Okc_Debug.Log('4900: Entered Lock_Row', 2);
966: END IF;
967:
968:
969: IF p_local_article_version_id IS NOT NULL Then

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

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

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

1016: EXCEPTION
1017: WHEN E_Resource_Busy THEN
1018:
1019: IF (l_debug = 'Y') THEN
1020: Okc_Debug.Log('5000: Leaving Lock_Row:E_Resource_Busy Exception', 2);
1021: END IF;
1022:
1023: IF (lock_wo_lv_csr%ISOPEN) THEN
1024: CLOSE lock_wo_lv_csr;

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

1048:
1049: END IF;
1050:
1051: IF (l_debug = 'Y') THEN
1052: Okc_Debug.Log('5100: Leaving Lock_Row', 2);
1053: END IF;
1054:
1055: RETURN( l_return_status );
1056:

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

1070: CLOSE lchk_wo_lv_csr;
1071: END IF;
1072:
1073: IF (l_debug = 'Y') THEN
1074: Okc_Debug.Log('5200: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1075: END IF;
1076:
1077: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1078: p_msg_name => G_UNEXPECTED_ERROR,

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

1097: ) IS
1098: BEGIN
1099:
1100: IF (l_debug = 'Y') THEN
1101: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1102: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1103: END IF;
1104:
1105: --------------------------------------------

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

1098: BEGIN
1099:
1100: IF (l_debug = 'Y') THEN
1101: Okc_Debug.Log('5700: Entered Lock_Row', 2);
1102: Okc_Debug.Log('5800: Locking Row for Base Table', 2);
1103: END IF;
1104:
1105: --------------------------------------------
1106: -- Call the LOCK_ROW for each _B child record

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

1119:
1120:
1121:
1122: IF (l_debug = 'Y') THEN
1123: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1124: END IF;
1125:
1126: EXCEPTION
1127: WHEN FND_API.G_EXC_ERROR THEN

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

1125:
1126: EXCEPTION
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: IF (l_debug = 'Y') THEN
1129: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1130: END IF;
1131: x_return_status := G_RET_STS_ERROR;
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1131: x_return_status := G_RET_STS_ERROR;
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134: IF (l_debug = 'Y') THEN
1135: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1136: END IF;
1137: x_return_status := G_RET_STS_UNEXP_ERROR;
1138:
1139: WHEN OTHERS THEN

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

1137: x_return_status := G_RET_STS_UNEXP_ERROR;
1138:
1139: WHEN OTHERS THEN
1140: IF (l_debug = 'Y') THEN
1141: Okc_Debug.Log('6300: Leaving Lock_Row because of EXCEPTION: '||sqlerrm, 2);
1142: END IF;
1143: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1144: p_msg_name => G_UNEXPECTED_ERROR,
1145: p_token1 => G_SQLCODE_TOKEN,

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

1172:
1173: BEGIN
1174:
1175: IF (l_debug = 'Y') THEN
1176: Okc_Debug.Log('6400: Entered Update_Row', 2);
1177: END IF;
1178: IF p_orig_local_version_id IS NOT NULL THEN
1179: UPDATE OKC_ARTICLE_ADOPTIONS
1180: SET ADOPTION_TYPE = p_adoption_type,

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

1202: LOCAL_ARTICLE_VERSION_ID IS NULL;
1203: END IF;
1204:
1205: IF (l_debug = 'Y') THEN
1206: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1207: END IF;
1208:
1209: RETURN G_RET_STS_SUCCESS ;
1210:

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

1211: EXCEPTION
1212: WHEN OTHERS THEN
1213:
1214: IF (l_debug = 'Y') THEN
1215: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1216: END IF;
1217:
1218: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1219: p_msg_name => G_UNEXPECTED_ERROR,

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

1259:
1260: BEGIN
1261:
1262: IF (l_debug = 'Y') THEN
1263: Okc_Debug.Log('7000: Entered Update_Row', 2);
1264: Okc_Debug.Log('7300: Locking row', 2);
1265: END IF;
1266:
1267: x_return_status := Lock_row(

Line 1264: Okc_Debug.Log('7300: Locking row', 2);

1260: BEGIN
1261:
1262: IF (l_debug = 'Y') THEN
1263: Okc_Debug.Log('7000: Entered Update_Row', 2);
1264: Okc_Debug.Log('7300: Locking row', 2);
1265: END IF;
1266:
1267: x_return_status := Lock_row(
1268: p_global_article_version_id => p_global_article_version_id,

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

1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278:
1279: IF (l_debug = 'Y') THEN
1280: Okc_Debug.Log('7300: Setting attributes', 2);
1281: END IF;
1282: l_global_article_version_id := p_global_article_version_id;
1283: x_return_status := Set_Attributes(
1284: p_global_article_version_id => l_global_article_version_id,

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

1297: END IF;
1298:
1299:
1300: IF (l_debug = 'Y') THEN
1301: Okc_Debug.Log('7400: Record Validation', 2);
1302: END IF;
1303:
1304: --- Validate all non-missing attributes
1305: x_return_status := Validate_Record(

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

1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1320: IF (l_debug = 'Y') THEN
1321: Okc_Debug.Log('7500: Filling WHO columns', 2);
1322: END IF;
1323:
1324: -- Filling who columns
1325: l_last_update_date := SYSDATE;

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

1334: --------------------------------------------
1335: -- Call the Update_Row for each child record
1336: --------------------------------------------
1337: IF (l_debug = 'Y') THEN
1338: Okc_Debug.Log('7600: Updating Row', 2);
1339: END IF;
1340:
1341: x_return_status := Update_Row(
1342: p_global_article_version_id => l_global_article_version_id,

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

1359: END IF;
1360:
1361:
1362: IF (l_debug = 'Y') THEN
1363: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1364: END IF;
1365:
1366: EXCEPTION
1367: WHEN FND_API.G_EXC_ERROR THEN

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

1365:
1366: EXCEPTION
1367: WHEN FND_API.G_EXC_ERROR THEN
1368: IF (l_debug = 'Y') THEN
1369: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1370: END IF;
1371: x_return_status := G_RET_STS_ERROR;
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1371: x_return_status := G_RET_STS_ERROR;
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: IF (l_debug = 'Y') THEN
1375: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1376: END IF;
1377: x_return_status := G_RET_STS_UNEXP_ERROR;
1378:
1379: WHEN OTHERS THEN

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

1377: x_return_status := G_RET_STS_UNEXP_ERROR;
1378:
1379: WHEN OTHERS THEN
1380: IF (l_debug = 'Y') THEN
1381: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1382: END IF;
1383: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1384: p_msg_name => G_UNEXPECTED_ERROR,
1385: p_token1 => G_SQLCODE_TOKEN,

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

1404:
1405: BEGIN
1406:
1407: IF (l_debug = 'Y') THEN
1408: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1409: END IF;
1410:
1411: DELETE FROM OKC_ARTICLE_ADOPTIONS
1412: WHERE GLOBAL_ARTICLE_VERSION_ID = p_GLOBAL_ARTICLE_VERSION_ID AND LOCAL_ORG_ID = p_LOCAL_ORG_ID AND LOCAL_ARTICLE_VERSION_ID = p_LOCAL_ARTICLE_VERSION_ID;

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

1411: DELETE FROM OKC_ARTICLE_ADOPTIONS
1412: WHERE GLOBAL_ARTICLE_VERSION_ID = p_GLOBAL_ARTICLE_VERSION_ID AND LOCAL_ORG_ID = p_LOCAL_ORG_ID AND LOCAL_ARTICLE_VERSION_ID = p_LOCAL_ARTICLE_VERSION_ID;
1413:
1414: IF (l_debug = 'Y') THEN
1415: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1416: END IF;
1417:
1418: RETURN( G_RET_STS_SUCCESS );
1419:

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

1420: EXCEPTION
1421: WHEN OTHERS THEN
1422:
1423: IF (l_debug = 'Y') THEN
1424: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1425: END IF;
1426:
1427: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1428: p_msg_name => G_UNEXPECTED_ERROR,

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

1448: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
1449: BEGIN
1450:
1451: IF (l_debug = 'Y') THEN
1452: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1453: Okc_Debug.Log('8900: Locking _B row', 2);
1454: END IF;
1455:
1456: x_return_status := Lock_row(

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

1449: BEGIN
1450:
1451: IF (l_debug = 'Y') THEN
1452: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1453: Okc_Debug.Log('8900: Locking _B row', 2);
1454: END IF;
1455:
1456: x_return_status := Lock_row(
1457: p_global_article_version_id => p_global_article_version_id,

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

1466: END IF;
1467:
1468:
1469: IF (l_debug = 'Y') THEN
1470: Okc_Debug.Log('9100: Removing _B row', 2);
1471: END IF;
1472: x_return_status := Delete_Row( p_global_article_version_id => p_global_article_version_id,p_local_org_id => p_local_org_id,p_local_article_version_id => p_local_article_version_id );
1473: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1477: END IF;
1478:
1479:
1480: IF (l_debug = 'Y') THEN
1481: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1482: END IF;
1483:
1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN

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

1483:
1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN
1486: IF (l_debug = 'Y') THEN
1487: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1488: END IF;
1489: x_return_status := G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1489: x_return_status := G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492: IF (l_debug = 'Y') THEN
1493: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1494: END IF;
1495: x_return_status := G_RET_STS_UNEXP_ERROR;
1496:
1497: WHEN OTHERS THEN

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

1495: x_return_status := G_RET_STS_UNEXP_ERROR;
1496:
1497: WHEN OTHERS THEN
1498: IF (l_debug = 'Y') THEN
1499: Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1500: END IF;
1501: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1502: p_msg_name => G_UNEXPECTED_ERROR,
1503: p_token1 => G_SQLCODE_TOKEN,