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_RELATIONSHIPS_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_source_article_id IS NULL AND p_target_article_id IS NULL AND p_org_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 136: Okc_Debug.Log('400: Entered get_rec', 2);

132: t.ORG_ID = cp_org_id;
133: BEGIN
134:
135: IF (l_debug = 'Y') THEN
136: Okc_Debug.Log('400: Entered get_rec', 2);
137: END IF;
138:
139: -- Get current database values
140: OPEN OKC_ART_REL_pk_csr (p_source_article_id, p_target_article_id, p_org_id);

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

151: END IF;
152: CLOSE OKC_ART_REL_pk_csr;
153:
154: IF (l_debug = 'Y') THEN
155: Okc_Debug.Log('500: Leaving get_rec ', 2);
156: END IF;
157:
158: RETURN G_RET_STS_SUCCESS ;
159:

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

160: EXCEPTION
161: WHEN OTHERS THEN
162:
163: IF (l_debug = 'Y') THEN
164: Okc_Debug.Log('600: Leaving get_rec because of EXCEPTION: '||sqlerrm, 2);
165: END IF;
166:
167: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
168: p_msg_name => G_UNEXPECTED_ERROR,

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

199: l_last_update_login OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_LOGIN%TYPE;
200: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
201: BEGIN
202: IF (l_debug = 'Y') THEN
203: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
204: END IF;
205:
206: IF( p_source_article_id IS NOT NULL AND p_target_article_id IS NOT NULL AND p_org_id IS NOT NULL ) THEN
207: -- Get current database values

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

235:
236: END IF;
237:
238: IF (l_debug = 'Y') THEN
239: Okc_Debug.Log('800: Leaving Set_Attributes ', 2);
240: END IF;
241:
242: RETURN G_RET_STS_SUCCESS ;
243: EXCEPTION

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

242: RETURN G_RET_STS_SUCCESS ;
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN
245: IF (l_debug = 'Y') THEN
246: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
247: END IF;
248: RETURN G_RET_STS_ERROR;
249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

248: RETURN G_RET_STS_ERROR;
249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: IF (l_debug = 'Y') THEN
252: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
253: END IF;
254: RETURN G_RET_STS_UNEXP_ERROR;
255:
256: WHEN OTHERS THEN

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

254: RETURN G_RET_STS_UNEXP_ERROR;
255:
256: WHEN OTHERS THEN
257: IF (l_debug = 'Y') THEN
258: Okc_Debug.Log('1100: Leaving Set_Attributes because of EXCEPTION: '||sqlerrm, 2);
259: END IF;
260: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
261: p_msg_name => G_UNEXPECTED_ERROR,
262: p_token1 => G_SQLCODE_TOKEN,

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

299:
300: BEGIN
301:
302: IF (l_debug = 'Y') THEN
303: Okc_Debug.Log('1200: Entered Validate_Attributes', 2);
304: END IF;
305:
306: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
307: IF (l_debug = 'Y') THEN

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

304: END IF;
305:
306: IF p_validation_level > G_REQUIRED_VALUE_VALID_LEVEL THEN
307: IF (l_debug = 'Y') THEN
308: Okc_Debug.Log('1300: required values validation', 2);
309: END IF;
310:
311: IF (l_debug = 'Y') THEN
312: Okc_Debug.Log('1400: - attribute SOURCE_ARTICLE_ID ', 2);

Line 312: Okc_Debug.Log('1400: - attribute SOURCE_ARTICLE_ID ', 2);

308: Okc_Debug.Log('1300: required values validation', 2);
309: END IF;
310:
311: IF (l_debug = 'Y') THEN
312: Okc_Debug.Log('1400: - attribute SOURCE_ARTICLE_ID ', 2);
313: END IF;
314: IF ( p_source_article_id IS NULL) THEN
315: IF (l_debug = 'Y') THEN
316: Okc_Debug.Log('1500: - attribute SOURCE_ARTICLE_ID is invalid', 2);

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

312: Okc_Debug.Log('1400: - attribute SOURCE_ARTICLE_ID ', 2);
313: END IF;
314: IF ( p_source_article_id IS NULL) THEN
315: IF (l_debug = 'Y') THEN
316: Okc_Debug.Log('1500: - attribute SOURCE_ARTICLE_ID is invalid', 2);
317: END IF;
318: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'SOURCE_ARTICLE_ID');
319: l_return_status := G_RET_STS_ERROR;
320: END IF;

Line 323: Okc_Debug.Log('1400: - attribute TARGET_ARTICLE_ID ', 2);

319: l_return_status := G_RET_STS_ERROR;
320: END IF;
321:
322: IF (l_debug = 'Y') THEN
323: Okc_Debug.Log('1400: - attribute TARGET_ARTICLE_ID ', 2);
324: END IF;
325: IF ( p_target_article_id IS NULL) THEN
326: IF (l_debug = 'Y') THEN
327: Okc_Debug.Log('1500: - attribute TARGET_ARTICLE_ID is invalid', 2);

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

323: Okc_Debug.Log('1400: - attribute TARGET_ARTICLE_ID ', 2);
324: END IF;
325: IF ( p_target_article_id IS NULL) THEN
326: IF (l_debug = 'Y') THEN
327: Okc_Debug.Log('1500: - attribute TARGET_ARTICLE_ID is invalid', 2);
328: END IF;
329: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'TARGET_ARTICLE_ID');
330: l_return_status := G_RET_STS_ERROR;
331: END IF;

Line 334: Okc_Debug.Log('1400: - attribute ORG_ID ', 2);

330: l_return_status := G_RET_STS_ERROR;
331: END IF;
332:
333: IF (l_debug = 'Y') THEN
334: Okc_Debug.Log('1400: - attribute ORG_ID ', 2);
335: END IF;
336: IF ( p_org_id IS NULL) THEN
337: IF (l_debug = 'Y') THEN
338: Okc_Debug.Log('1500: - attribute ORG_ID is invalid', 2);

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

334: Okc_Debug.Log('1400: - attribute ORG_ID ', 2);
335: END IF;
336: IF ( p_org_id IS NULL) THEN
337: IF (l_debug = 'Y') THEN
338: Okc_Debug.Log('1500: - attribute ORG_ID is invalid', 2);
339: END IF;
340: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ORG_ID');
341: l_return_status := G_RET_STS_ERROR;
342: END IF;

Line 345: Okc_Debug.Log('1400: - attribute RELATIONSHIP_TYPE ', 2);

341: l_return_status := G_RET_STS_ERROR;
342: END IF;
343:
344: IF (l_debug = 'Y') THEN
345: Okc_Debug.Log('1400: - attribute RELATIONSHIP_TYPE ', 2);
346: END IF;
347: IF ( p_relationship_type IS NULL) THEN
348: IF (l_debug = 'Y') THEN
349: Okc_Debug.Log('1500: - attribute RELATIONSHIP_TYPE is invalid', 2);

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

345: Okc_Debug.Log('1400: - attribute RELATIONSHIP_TYPE ', 2);
346: END IF;
347: IF ( p_relationship_type IS NULL) THEN
348: IF (l_debug = 'Y') THEN
349: Okc_Debug.Log('1500: - attribute RELATIONSHIP_TYPE is invalid', 2);
350: END IF;
351: Okc_Api.Set_Message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'RELATIONSHIP_TYPE');
352: l_return_status := G_RET_STS_ERROR;
353: END IF;

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

355: END IF;
356:
357: IF p_validation_level > G_VALID_VALUE_VALID_LEVEL THEN
358: IF (l_debug = 'Y') THEN
359: Okc_Debug.Log('1600: static values and range validation', 2);
360: END IF;
361:
362: END IF;
363:

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

362: END IF;
363:
364: IF p_validation_level > G_LOOKUP_CODE_VALID_LEVEL THEN
365: IF (l_debug = 'Y') THEN
366: Okc_Debug.Log('1900: lookup codes validation', 2);
367: END IF;
368:
369: --Modified
370: IF (l_debug = 'Y') THEN

Line 371: Okc_Debug.Log('2000: - attribute RELATIONSHIP_TYPE ', 2);

367: END IF;
368:
369: --Modified
370: IF (l_debug = 'Y') THEN
371: Okc_Debug.Log('2000: - attribute RELATIONSHIP_TYPE ', 2);
372: END IF;
373: IF p_relationship_type IS NOT NULL THEN
374: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_RELATIONSHIP_TYPE',p_relationship_type);
375: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN

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

384: END IF;
385:
386: IF p_validation_level > G_FOREIGN_KEY_VALID_LEVEL THEN
387: IF (l_debug = 'Y') THEN
388: Okc_Debug.Log('2100: foreigh keys validation ', 2);
389: END IF;
390:
391: IF (l_debug = 'Y') THEN
392: Okc_Debug.Log('2200: - attribute SOURCE_ARTICLE_ID ', 2);

Line 392: Okc_Debug.Log('2200: - attribute SOURCE_ARTICLE_ID ', 2);

388: Okc_Debug.Log('2100: foreigh keys validation ', 2);
389: END IF;
390:
391: IF (l_debug = 'Y') THEN
392: Okc_Debug.Log('2200: - attribute SOURCE_ARTICLE_ID ', 2);
393: END IF;
394: IF p_source_article_id IS NOT NULL THEN
395: l_dummy_var := '?';
396: OPEN l_source_article_id_csr;

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

397: FETCH l_source_article_id_csr INTO l_dummy_var;
398: CLOSE l_source_article_id_csr;
399: IF (l_dummy_var = '?') THEN
400: IF (l_debug = 'Y') THEN
401: Okc_Debug.Log('2300: - attribute SOURCE_ARTICLE_ID is invalid', 2);
402: END IF;
403: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SOURCE_ARTICLE_ID');
404: l_return_status := G_RET_STS_ERROR;
405: END IF;

Line 409: Okc_Debug.Log('2200: - attribute TARGET_ARTICLE_ID ', 2);

405: END IF;
406: END IF;
407:
408: IF (l_debug = 'Y') THEN
409: Okc_Debug.Log('2200: - attribute TARGET_ARTICLE_ID ', 2);
410: END IF;
411: IF p_target_article_id IS NOT NULL THEN
412: l_dummy_var := '?';
413: OPEN l_target_article_id_csr;

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

414: FETCH l_target_article_id_csr INTO l_dummy_var;
415: CLOSE l_target_article_id_csr;
416: IF (l_dummy_var = '?') THEN
417: IF (l_debug = 'Y') THEN
418: Okc_Debug.Log('2300: - attribute TARGET_ARTICLE_ID is invalid', 2);
419: END IF;
420: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TARGET_ARTICLE_ID');
421: l_return_status := G_RET_STS_ERROR;
422: END IF;

Line 426: Okc_Debug.Log('2200: - attribute ORG_ID ', 2);

422: END IF;
423: END IF;
424:
425: IF (l_debug = 'Y') THEN
426: Okc_Debug.Log('2200: - attribute ORG_ID ', 2);
427: END IF;
428: IF p_org_id IS NOT NULL THEN
429: l_dummy_var := '?';
430: OPEN l_org_id_csr;

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

431: FETCH l_org_id_csr INTO l_dummy_var;
432: CLOSE l_org_id_csr;
433: IF (l_dummy_var = '?') THEN
434: IF (l_debug = 'Y') THEN
435: Okc_Debug.Log('2300: - attribute ORG_ID is invalid', 2);
436: END IF;
437: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'ORG_ID');
438: l_return_status := G_RET_STS_ERROR;
439: END IF;

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

442: END IF;
443:
444:
445: IF (l_debug = 'Y') THEN
446: Okc_Debug.Log('2400: Leaving Validate_Attributes ', 2);
447: END IF;
448:
449: RETURN l_return_status;
450:

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

449: RETURN l_return_status;
450:
451: EXCEPTION
452: WHEN OTHERS THEN
453: Okc_Debug.Log('2500: Leaving Validate_Attributes because of EXCEPTION: '||sqlerrm, 2);
454: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
455: p_msg_name => G_UNEXPECTED_ERROR,
456: p_token1 => G_SQLCODE_TOKEN,
457: p_token1_value => sqlcode,

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

548: -- Modified
549: BEGIN
550:
551: IF (l_debug = 'Y') THEN
552: Okc_Debug.Log('2600: Entered Validate_Record', 2);
553: END IF;
554:
555: --- Validate all non-missing attributes (Item Level Validation)
556: l_return_status := Validate_Attributes(

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

562: p_relationship_type => p_relationship_type
563: );
564: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
565: IF (l_debug = 'Y') THEN
566: Okc_Debug.Log('2700: Leaving Validate_Record because of UNEXP_ERROR in Validate_Attributes: '||sqlerrm, 2);
567: END IF;
568: RETURN G_RET_STS_UNEXP_ERROR;
569: END IF;
570:

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

570:
571: --- Record Level Validation
572: IF p_validation_level > G_RECORD_VALID_LEVEL THEN
573: IF (l_debug = 'Y') THEN
574: Okc_Debug.Log('2800: Entered Record Level Validations', 2);
575: END IF;
576: /*+++++++++++++start of hand code +++++++++++++++++++*/
577: -- manual coding for Record Level Validations if required
578: IF p_source_article_id = p_target_article_id THEN

Line 580: OKC_Debug.Log('2800: - attribute SOURCE_ARTICLE_ID , TARGET_ARTICLE_ID can not be same',2);

576: /*+++++++++++++start of hand code +++++++++++++++++++*/
577: -- manual coding for Record Level Validations if required
578: IF p_source_article_id = p_target_article_id THEN
579: IF (l_debug='Y') THEN
580: OKC_Debug.Log('2800: - attribute SOURCE_ARTICLE_ID , TARGET_ARTICLE_ID can not be same',2);
581: END IF;
582: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_SAME_ART_RELTNSHP');
583: l_return_status := G_RET_STS_ERROR;
584: -- fix for bug#4006749 start

Line 603: OKC_Debug.Log('2800: - attribute SOURCE_ARTICLE_ID , TARGET_ARTICLE_ID are not unique for Org',2);

599: l_rowfound := l_unq_csr%FOUND;
600: CLOSE l_unq_csr;
601: IF l_rowfound THEN
602: IF (l_debug='Y') THEN
603: OKC_Debug.Log('2800: - attribute SOURCE_ARTICLE_ID , TARGET_ARTICLE_ID are not unique for Org',2);
604: END IF;
605: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DUP_RELTNSHP');
606: l_return_status := G_RET_STS_ERROR;
607: END IF;

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

609: /*+++++++++++++End of hand code +++++++++++++++++++*/
610: END IF;
611:
612: IF (l_debug = 'Y') THEN
613: Okc_Debug.Log('2900: Leaving Validate_Record : '||sqlerrm, 2);
614: END IF;
615: RETURN l_return_status ;
616:
617: EXCEPTION

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

617: EXCEPTION
618: WHEN OTHERS THEN
619:
620: IF (l_debug = 'Y') THEN
621: Okc_Debug.Log('3000: Leaving Validate_Record because of EXCEPTION: '||sqlerrm, 2);
622: END IF;
623:
624: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
625: p_msg_name => G_UNEXPECTED_ERROR,

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

663: l_last_update_date OKC_ARTICLE_RELATNS_ALL.LAST_UPDATE_DATE%TYPE;
664: BEGIN
665:
666: IF (l_debug = 'Y') THEN
667: Okc_Debug.Log('3100: Entered validate_row', 2);
668: END IF;
669:
670: -- Setting attributes
671: x_return_status := Set_Attributes(

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

691: p_relationship_type => l_relationship_type
692: );
693:
694: IF (l_debug = 'Y') THEN
695: Okc_Debug.Log('3200: Leaving validate_row', 2);
696: END IF;
697:
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN

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

697:
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: IF (l_debug = 'Y') THEN
701: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
702: END IF;
703: x_return_status := G_RET_STS_ERROR;
704:
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

703: x_return_status := G_RET_STS_ERROR;
704:
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
706: IF (l_debug = 'Y') THEN
707: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
708: END IF;
709: x_return_status := G_RET_STS_UNEXP_ERROR;
710:
711: WHEN OTHERS THEN

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

709: x_return_status := G_RET_STS_UNEXP_ERROR;
710:
711: WHEN OTHERS THEN
712: IF (l_debug = 'Y') THEN
713: Okc_Debug.Log('3500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);
714: END IF;
715: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
716: p_msg_name => G_UNEXPECTED_ERROR,
717: p_token1 => G_SQLCODE_TOKEN,

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

744:
745: BEGIN
746:
747: IF (l_debug = 'Y') THEN
748: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
749: END IF;
750: -- Create opposite rows (mutually related by flipping the source and target ids)
751: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
752: SOURCE_ARTICLE_ID,

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

771: p_last_update_login,
772: p_last_update_date);
773:
774: IF (l_debug = 'Y') THEN
775: Okc_Debug.Log('3700: Leaving Insert_Row', 2);
776: END IF;
777:
778: RETURN( G_RET_STS_SUCCESS );
779:

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

780: EXCEPTION
781: WHEN OTHERS THEN
782:
783: IF (l_debug = 'Y') THEN
784: Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
785: END IF;
786:
787: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
788: p_msg_name => G_UNEXPECTED_ERROR,

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

826:
827: x_return_status := G_RET_STS_SUCCESS;
828:
829: IF (l_debug = 'Y') THEN
830: Okc_Debug.Log('4200: Entered Insert_Row', 2);
831: END IF;
832:
833: --- Setting item attributes
834: -- Set primary key value

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

868: --------------------------------------------
869: -- Call the internal Insert_Row for each child record
870: --------------------------------------------
871: IF (l_debug = 'Y') THEN
872: Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
873: END IF;
874:
875: x_return_status := Insert_Row(
876: p_source_article_id => x_source_article_id,

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

892:
893:
894:
895: IF (l_debug = 'Y') THEN
896: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
897: END IF;
898:
899: EXCEPTION
900: WHEN FND_API.G_EXC_ERROR THEN

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

898:
899: EXCEPTION
900: WHEN FND_API.G_EXC_ERROR THEN
901: IF (l_debug = 'Y') THEN
902: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
903: END IF;
904: x_return_status := G_RET_STS_ERROR;
905:
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

904: x_return_status := G_RET_STS_ERROR;
905:
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: IF (l_debug = 'Y') THEN
908: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
909: END IF;
910: x_return_status := G_RET_STS_UNEXP_ERROR;
911:
912: WHEN OTHERS THEN

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

910: x_return_status := G_RET_STS_UNEXP_ERROR;
911:
912: WHEN OTHERS THEN
913: IF (l_debug = 'Y') THEN
914: Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
915: END IF;
916: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
917: p_msg_name => G_UNEXPECTED_ERROR,
918: p_token1 => G_SQLCODE_TOKEN,

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

957: l_row_notfound BOOLEAN := FALSE;
958: BEGIN
959:
960: IF (l_debug = 'Y') THEN
961: Okc_Debug.Log('4900: Entered Lock_Row', 2);
962: END IF;
963:
964:
965: BEGIN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1120:
1121: BEGIN
1122:
1123: IF (l_debug = 'Y') THEN
1124: Okc_Debug.Log('6400: Entered Update_Row', 2);
1125: END IF;
1126:
1127: UPDATE OKC_ARTICLE_RELATNS_ALL
1128: SET RELATIONSHIP_TYPE = p_relationship_type,

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

1134: LAST_UPDATE_DATE = p_last_update_date
1135: WHERE SOURCE_ARTICLE_ID = p_source_article_id AND TARGET_ARTICLE_ID = p_target_article_id AND ORG_ID = p_org_id;
1136:
1137: IF (l_debug = 'Y') THEN
1138: Okc_Debug.Log('6500: Leaving Update_Row', 2);
1139: END IF;
1140:
1141: RETURN G_RET_STS_SUCCESS ;
1142:

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

1143: EXCEPTION
1144: WHEN OTHERS THEN
1145:
1146: IF (l_debug = 'Y') THEN
1147: Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1148: END IF;
1149:
1150: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1151: p_msg_name => G_UNEXPECTED_ERROR,

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

1187:
1188: BEGIN
1189:
1190: IF (l_debug = 'Y') THEN
1191: Okc_Debug.Log('7000: Entered Update_Row', 2);
1192: Okc_Debug.Log('7100: Locking _B row', 2);
1193: END IF;
1194:
1195: x_return_status := Lock_row(

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

1188: BEGIN
1189:
1190: IF (l_debug = 'Y') THEN
1191: Okc_Debug.Log('7000: Entered Update_Row', 2);
1192: Okc_Debug.Log('7100: Locking _B row', 2);
1193: END IF;
1194:
1195: x_return_status := Lock_row(
1196: p_source_article_id => p_source_article_id,

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

1205: END IF;
1206:
1207:
1208: IF (l_debug = 'Y') THEN
1209: Okc_Debug.Log('7300: Setting attributes', 2);
1210: END IF;
1211:
1212: x_return_status := Set_Attributes(
1213: p_source_article_id => p_source_article_id,

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

1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225:
1226: IF (l_debug = 'Y') THEN
1227: Okc_Debug.Log('7400: Record Validation', 2);
1228: END IF;
1229:
1230: --- Validate all non-missing attributes
1231: x_return_status := Validate_Record(

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

1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;
1244:
1245: IF (l_debug = 'Y') THEN
1246: Okc_Debug.Log('7500: Filling WHO columns', 2);
1247: END IF;
1248:
1249: -- Filling who columns
1250: l_last_update_date := SYSDATE;

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

1259: --------------------------------------------
1260: -- Call the Update_Row for each child record
1261: --------------------------------------------
1262: IF (l_debug = 'Y') THEN
1263: Okc_Debug.Log('7600: Updating Row', 2);
1264: END IF;
1265:
1266: x_return_status := Update_Row(
1267: p_source_article_id => p_source_article_id,

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

1282: END IF;
1283:
1284:
1285: IF (l_debug = 'Y') THEN
1286: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1287: END IF;
1288:
1289: EXCEPTION
1290: WHEN FND_API.G_EXC_ERROR THEN

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

1288:
1289: EXCEPTION
1290: WHEN FND_API.G_EXC_ERROR THEN
1291: IF (l_debug = 'Y') THEN
1292: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1293: END IF;
1294: x_return_status := G_RET_STS_ERROR;
1295:
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1294: x_return_status := G_RET_STS_ERROR;
1295:
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: IF (l_debug = 'Y') THEN
1298: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1299: END IF;
1300: x_return_status := G_RET_STS_UNEXP_ERROR;
1301:
1302: WHEN OTHERS THEN

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

1300: x_return_status := G_RET_STS_UNEXP_ERROR;
1301:
1302: WHEN OTHERS THEN
1303: IF (l_debug = 'Y') THEN
1304: Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
1305: END IF;
1306: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1307: p_msg_name => G_UNEXPECTED_ERROR,
1308: p_token1 => G_SQLCODE_TOKEN,

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

1327:
1328: BEGIN
1329:
1330: IF (l_debug = 'Y') THEN
1331: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1332: END IF;
1333: -- Delete opposite rows (mutually related by flipping the source and target ids)
1334:
1335: DELETE FROM OKC_ARTICLE_RELATNS_ALL

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

1337: TARGET_ARTICLE_ID = p_TARGET_ARTICLE_ID AND
1338: ORG_ID = p_ORG_ID;
1339:
1340: IF (l_debug = 'Y') THEN
1341: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1342: END IF;
1343:
1344: RETURN( G_RET_STS_SUCCESS );
1345:

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

1346: EXCEPTION
1347: WHEN OTHERS THEN
1348:
1349: IF (l_debug = 'Y') THEN
1350: Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
1351: END IF;
1352:
1353: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1354: p_msg_name => G_UNEXPECTED_ERROR,

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

1374: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
1375: BEGIN
1376:
1377: IF (l_debug = 'Y') THEN
1378: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1379: Okc_Debug.Log('8900: Locking _B row', 2);
1380: END IF;
1381:
1382: x_return_status := Lock_row(

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

1375: BEGIN
1376:
1377: IF (l_debug = 'Y') THEN
1378: Okc_Debug.Log('8800: Entered Delete_Row', 2);
1379: Okc_Debug.Log('8900: Locking _B row', 2);
1380: END IF;
1381:
1382: x_return_status := Lock_row(
1383: p_source_article_id => p_source_article_id,

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

1392: END IF;
1393:
1394:
1395: IF (l_debug = 'Y') THEN
1396: Okc_Debug.Log('9100: Removing _B row', 2);
1397: END IF;
1398: x_return_status := Delete_Row( p_source_article_id => p_source_article_id,p_target_article_id => p_target_article_id,p_org_id => p_org_id );
1399: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1403: END IF;
1404:
1405:
1406: IF (l_debug = 'Y') THEN
1407: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1408: END IF;
1409:
1410: EXCEPTION
1411: WHEN FND_API.G_EXC_ERROR THEN

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

1409:
1410: EXCEPTION
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: IF (l_debug = 'Y') THEN
1413: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1414: END IF;
1415: x_return_status := G_RET_STS_ERROR;
1416:
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1415: x_return_status := G_RET_STS_ERROR;
1416:
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1418: IF (l_debug = 'Y') THEN
1419: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1420: END IF;
1421: x_return_status := G_RET_STS_UNEXP_ERROR;
1422:
1423: WHEN OTHERS THEN

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

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