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

Line 207: okc_debug.log('100: Entered check_adoption with parameters: ' || p_global_article_version_id ||''|| p_adoption_type ||''|| p_local_org_id, 2);

203:
204: BEGIN
205:
206: IF (l_debug = 'Y') THEN
207: okc_debug.log('100: Entered check_adoption with parameters: ' || p_global_article_version_id ||'*'|| p_adoption_type ||'*'|| p_local_org_id, 2);
208: END IF;
209: x_earlier_local_version_id := NULL;
210:
211: -- Standard Start of API savepoint

Line 242: okc_debug.log('200: Adoption cursor row not found', 2);

238: -- to the local org.
239:
240: IF (l_row_notfound) THEN
241: IF (l_debug = 'Y') THEN
242: okc_debug.log('200: Adoption cursor row not found', 2);
243: END IF;
244: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');
245: RAISE FND_API.G_EXC_ERROR ;
246: END IF;

Line 250: okc_debug.log('300: Adoption type is wrong', 2);

246: END IF;
247:
248: IF (nvl(p_adoption_type, 'INVALID') NOT IN ('ADOPTED', 'LOCALIZED')) THEN
249: IF (l_debug = 'Y') THEN
250: okc_debug.log('300: Adoption type is wrong', 2);
251: END IF;
252: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');
253: RAISE FND_API.G_EXC_ERROR ;
254: END IF;

Line 258: okc_debug.log('350: Invalid status to be adopted', 2);

254: END IF;
255:
256: IF (l_adoption_rec.article_status = 'ON_HOLD') THEN
257: IF (l_debug = 'Y') THEN
258: okc_debug.log('350: Invalid status to be adopted', 2);
259: END IF;
260: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_STATUS_TO_ADOPT');
261: RAISE FND_API.G_EXC_ERROR ;
262: END IF;

Line 281: okc_debug.log('200: Other version row not found', 2);

277: -- Check that the global article version does not have any other later version already localized.
278: -- Check if the adoption type is not same as previous adoptions for the same global article
279: IF (l_adp_row_notfound AND l_lcz_row_notfound) THEN
280: IF (l_debug = 'Y') THEN
281: okc_debug.log('200: Other version row not found', 2);
282: END IF;
283: l_never_adopted := TRUE;
284: ELSIF ( ( NOT l_adp_row_notfound AND p_adoption_type <> 'ADOPTED')
285: OR ( NOT l_lcz_row_notfound AND p_adoption_type <> 'LOCALIZED')) THEN

Line 287: okc_debug.log('400: Other version row different adoption', 2);

283: l_never_adopted := TRUE;
284: ELSIF ( ( NOT l_adp_row_notfound AND p_adoption_type <> 'ADOPTED')
285: OR ( NOT l_lcz_row_notfound AND p_adoption_type <> 'LOCALIZED')) THEN
286: IF (l_debug = 'Y') THEN
287: okc_debug.log('400: Other version row different adoption', 2);
288: END IF;
289: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_DIFF_ADP_TYPE');
290: RAISE FND_API.G_EXC_ERROR ;
291: ELSIF ( NOT l_lcz_row_notfound ) THEN

Line 302: okc_debug.log('500: Localization Latest version not found', 2);

298:
299: x_earlier_local_version_id := l_latest_ver_lcz_rec.article_version_id;
300: IF (l_lcz_row_notfound) THEN
301: IF (l_debug = 'Y') THEN
302: okc_debug.log('500: Localization Latest version not found', 2);
303: END IF;
304: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;

Line 311: okc_debug.log('600: Other version has adoption in Rejected/Draft/Pending Approval', 2);

307:
308: IF nvl(l_latest_ver_lcz_rec.adoption_status, 'DRAFT')
309: IN ('DRAFT','REJECTED','PENDING_APPROVAL') THEN
310: IF (l_debug = 'Y') THEN
311: okc_debug.log('600: Other version has adoption in Rejected/Draft/Pending Approval', 2);
312: END IF;
313: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_EXIST_DRAFT_LOCALIZED');
314: RAISE FND_API.G_EXC_ERROR ;
315: END IF;

Line 321: okc_debug.log('700: Other version has a later adoption', 2);

317: ELSIF ( NOT l_adp_row_notfound) THEN
318: -- Adoption flow
319: IF (l_latest_ver_adp_rec.start_date > l_adoption_rec.start_date) THEN
320: IF (l_debug = 'Y') THEN
321: okc_debug.log('700: Other version has a later adoption', 2);
322: END IF;
323: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_LATER_GLOB_ADP_EXIST');
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;

Line 330: okc_debug.log('800: Other version has adoption in Pending Approval', 2);

326:
327: IF nvl(l_latest_ver_adp_rec.adoption_status, 'REJECTED')
328: IN ('PENDING_APPROVAL') THEN
329: IF (l_debug = 'Y') THEN
330: okc_debug.log('800: Other version has adoption in Pending Approval', 2);
331: END IF;
332: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_EXIST_PENDING_ADOPTED');
333: RAISE FND_API.G_EXC_ERROR ;
334: END IF;

Line 349: okc_debug.log('1000: Duplicate title found in local org', 2);

345: CLOSE l_unq_local_title_csr;
346:
347: IF (l_row_found) THEN
348: IF (l_debug = 'Y') THEN
349: okc_debug.log('1000: Duplicate title found in local org', 2);
350: END IF;
351: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_DUP_TITLE_ADP_ORG');
352: RAISE FND_API.G_EXC_ERROR ;
353: END IF;

Line 360: okc_debug.log('2000: Leaving check adoption', 2);

356:
357: END IF; -- IF( p_local_org_id = G_GLOBAL_ORG_ID OR p_local_org_id = -99 OR l_global_org_id = -99 )
358:
359: IF (l_debug = 'Y') THEN
360: okc_debug.log('2000: Leaving check adoption', 2);
361: END IF;
362: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
363:
364: EXCEPTION

Line 367: okc_debug.log('3000: Leaving Check_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);

363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: IF (l_debug = 'Y') THEN
367: okc_debug.log('3000: Leaving Check_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
368: END IF;
369: x_return_status := G_RET_STS_ERROR ;
370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
371:

Line 374: okc_debug.log('4000: Leaving Check_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: IF (l_debug = 'Y') THEN
374: okc_debug.log('4000: Leaving Check_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
375: END IF;
376: IF l_latest_ver_adp_csr%ISOPEN THEN
377: CLOSE l_latest_ver_adp_csr;
378: END IF;

Line 396: okc_debug.log('5000: Leaving Check_Adoption because of EXCEPTION: '||sqlerrm, 2);

392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
393:
394: WHEN OTHERS THEN
395: IF (l_debug = 'Y') THEN
396: okc_debug.log('5000: Leaving Check_Adoption because of EXCEPTION: '||sqlerrm, 2);
397: END IF;
398: IF l_latest_ver_adp_csr%ISOPEN THEN
399: CLOSE l_latest_ver_adp_csr;
400: END IF;

Line 461: okc_debug.log('100: Entered delete_adoption', 2);

457:
458: BEGIN
459:
460: IF (l_debug = 'Y') THEN
461: okc_debug.log('100: Entered delete_adoption', 2);
462: END IF;
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard Start of API savepoint

Line 535: okc_debug.log('200: Leaving check adoption', 2);

531: END IF;
532: END IF;
533:
534: IF (l_debug = 'Y') THEN
535: okc_debug.log('200: Leaving check adoption', 2);
536: END IF;
537:
538: EXCEPTION
539: WHEN FND_API.G_EXC_ERROR THEN

Line 541: okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);

537:
538: EXCEPTION
539: WHEN FND_API.G_EXC_ERROR THEN
540: IF (l_debug = 'Y') THEN
541: okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
542: END IF;
543: x_return_status := G_RET_STS_ERROR ;
544:
545: WHEN OTHERS THEN

Line 547: okc_debug.log('500: Leaving delete_Adoption because of EXCEPTION: '||sqlerrm, 2);

543: x_return_status := G_RET_STS_ERROR ;
544:
545: WHEN OTHERS THEN
546: IF (l_debug = 'Y') THEN
547: okc_debug.log('500: Leaving delete_Adoption because of EXCEPTION: '||sqlerrm, 2);
548: END IF;
549: IF l_other_version_csr%ISOPEN THEN
550: CLOSE l_other_version_csr;
551: END IF;

Line 596: okc_debug.log('100: Entered create_adoption', 2);

592:
593: BEGIN
594:
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('100: Entered create_adoption', 2);
597: END IF;
598:
599: -- Standard Start of API savepoint
600: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 739: okc_debug.log('200: Leaving check adoption', 2);

735: END IF;
736: --------------------------------------------
737:
738: IF (l_debug = 'Y') THEN
739: okc_debug.log('200: Leaving check adoption', 2);
740: END IF;
741:
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN

Line 745: okc_debug.log('300: Leaving create_local_adoption_details: OKC_API.G_EXCEPTION_ERROR Exception', 2);

741:
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: IF (l_debug = 'Y') THEN
745: okc_debug.log('300: Leaving create_local_adoption_details: OKC_API.G_EXCEPTION_ERROR Exception', 2);
746: END IF;
747: x_return_status := G_RET_STS_ERROR ;
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 751: okc_debug.log('400: Leaving create_local_adoption_details: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

747: x_return_status := G_RET_STS_ERROR ;
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: IF (l_debug = 'Y') THEN
751: okc_debug.log('400: Leaving create_local_adoption_details: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
752: END IF;
753: IF l_adoption_csr%ISOPEN THEN
754: CLOSE l_adoption_csr;
755: END IF;

Line 760: okc_debug.log('500: Leaving create_local_adoption_details because of EXCEPTION: '||sqlerrm, 2);

756: x_return_status := G_RET_STS_UNEXP_ERROR ;
757:
758: WHEN OTHERS THEN
759: IF (l_debug = 'Y') THEN
760: okc_debug.log('500: Leaving create_local_adoption_details because of EXCEPTION: '||sqlerrm, 2);
761: END IF;
762: IF l_adoption_csr%ISOPEN THEN
763: CLOSE l_adoption_csr;
764: END IF;

Line 892: okc_debug.log('100: Entered create_adoption', 2);

888: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
889:
890: BEGIN
891: IF (l_debug = 'Y') THEN
892: okc_debug.log('100: Entered create_adoption', 2);
893: END IF;
894:
895: -- Standard Start of API savepoint
896: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 956: okc_debug.log('200: AUTO ADOPTION cannot be done because duplicate article found in the org '|| l_org_id_tbl(i), 2);

952: CLOSE l_unq_local_title_csr;
953:
954: IF (l_rowfound) THEN
955: IF (l_debug = 'Y') THEN
956: okc_debug.log('200: AUTO ADOPTION cannot be done because duplicate article found in the org '|| l_org_id_tbl(i), 2);
957: END IF;
958: l_adoption_type_tbl(i) := 'AVAILABLE';
959: l_adoption_status_tbl(i) := NULL;
960: ELSE

Line 1051: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);

1047: end if; -- relationship_yn = Y
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: IF (l_debug = 'Y') THEN
1051: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
1052: END IF;
1053: IF l_org_info_csr%ISOPEN THEN
1054: CLOSE l_org_info_csr;
1055: END IF;

Line 1127: okc_debug.log('200: Leaving check adoption', 2);

1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
1125:
1126: IF (l_debug = 'Y') THEN
1127: okc_debug.log('200: Leaving check adoption', 2);
1128: END IF;
1129:
1130: EXCEPTION
1131: WHEN FND_API.G_EXC_ERROR THEN

Line 1133: okc_debug.log('300: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1129:
1130: EXCEPTION
1131: WHEN FND_API.G_EXC_ERROR THEN
1132: IF (l_debug = 'Y') THEN
1133: okc_debug.log('300: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1134: END IF;
1135: x_return_status := G_RET_STS_ERROR ;
1136:
1137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1139: okc_debug.log('400: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1135: x_return_status := G_RET_STS_ERROR ;
1136:
1137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1138: IF (l_debug = 'Y') THEN
1139: okc_debug.log('400: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1140: END IF;
1141: IF l_org_info_csr%ISOPEN THEN
1142: CLOSE l_org_info_csr;
1143: END IF;

Line 1154: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);

1150: x_return_status := G_RET_STS_UNEXP_ERROR ;
1151:
1152: WHEN OTHERS THEN
1153: IF (l_debug = 'Y') THEN
1154: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
1155: END IF;
1156: IF l_org_info_csr%ISOPEN THEN
1157: CLOSE l_org_info_csr;
1158: END IF;

Line 1284: okc_debug.log('100: Entered auto_adoption for new org.', 2);

1280: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1281:
1282: BEGIN
1283: IF (l_debug = 'Y') THEN
1284: okc_debug.log('100: Entered auto_adoption for new org.', 2);
1285: END IF;
1286:
1287: FND_MSG_PUB.initialize;
1288: retcode := 0;

Line 1313: okc_debug.log('200: Org row not found', 2);

1309: CLOSE l_org_info_csr ;
1310:
1311: IF (l_row_notfound) THEN
1312: IF (l_debug = 'Y') THEN
1313: okc_debug.log('200: Org row not found', 2);
1314: END IF;
1315: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_ADOPT_INVALID_ORG');
1316: FND_MSG_PUB.add;
1317: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

Line 1394: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);

1390: sysdate );
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: IF (l_debug = 'Y') THEN
1394: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
1395: END IF;
1396: l_adp_record_status_tbl(i) := 'U';
1397: l_return_status := G_RET_STS_UNEXP_ERROR ;
1398: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

Line 1446: okc_debug.log('500: Auto_Adoption New Org EXCEPTION: ' ||sqlerrm, 2);

1442:
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: IF (l_debug = 'Y') THEN
1446: okc_debug.log('500: Auto_Adoption New Org EXCEPTION: ' ||sqlerrm, 2);
1447: END IF;
1448: IF l_dup_title_csr%ISOPEN THEN
1449: CLOSE l_dup_title_csr;
1450: END IF;

Line 1559: okc_debug.log('500: Auto_Adoption New Org EXCEPTION: ' ||sqlerrm, 2);

1555:
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: IF (l_debug = 'Y') THEN
1559: okc_debug.log('500: Auto_Adoption New Org EXCEPTION: ' ||sqlerrm, 2);
1560: END IF;
1561: l_adp_record_status_tbl(i) := 'U';
1562: l_return_status := G_RET_STS_UNEXP_ERROR ;
1563: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

Line 1598: okc_debug.log('500: Leaving Auto_Adoption New Org' );

1594: p_token4_value => l_organization_name);
1595:
1596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));
1597:
1598: okc_debug.log('500: Leaving Auto_Adoption New Org' );
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: IF (l_debug = 'Y') THEN
1602: okc_debug.log('500: Leaving Auto_Adoption New Org because of EXCEPTION: '||sqlerrm, 2);

Line 1602: okc_debug.log('500: Leaving Auto_Adoption New Org because of EXCEPTION: '||sqlerrm, 2);

1598: okc_debug.log('500: Leaving Auto_Adoption New Org' );
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: IF (l_debug = 'Y') THEN
1602: okc_debug.log('500: Leaving Auto_Adoption New Org because of EXCEPTION: '||sqlerrm, 2);
1603: END IF;
1604: l_return_status := G_RET_STS_UNEXP_ERROR ;
1605: IF l_adoptions_csr%ISOPEN Then
1606: close l_adoptions_csr;