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

Line 73: okc_debug.log('500: Entering update adoption if exists ', 2);

69: l_rowid ROWID;
70:
71: BEGIN
72: IF (l_debug = 'Y') THEN
73: okc_debug.log('500: Entering update adoption if exists ', 2);
74: END IF;
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: OPEN l_article_adoption_csr(p_article_version_id,

Line 91: okc_debug.log('500: Leaving update adoption if exists successfully', 2);

87: WHERE CURRENT OF l_article_adoption_csr;
88: END IF;
89: CLOSE l_article_adoption_csr;
90: IF (l_debug = 'Y') THEN
91: okc_debug.log('500: Leaving update adoption if exists successfully', 2);
92: END IF;
93: EXCEPTION
94: WHEN OTHERS THEN
95: IF (l_debug = 'Y') THEN

Line 96: okc_debug.log('500: Leaving update adoption if exists because of EXCEPTION: '||sqlerrm, 2);

92: END IF;
93: EXCEPTION
94: WHEN OTHERS THEN
95: IF (l_debug = 'Y') THEN
96: okc_debug.log('500: Leaving update adoption if exists because of EXCEPTION: '||sqlerrm, 2);
97: END IF;
98: IF l_article_adoption_csr%ISOPEN THEN
99: CLOSE l_article_adoption_csr;
100: END IF;

Line 182: okc_debug.log('500: Entering update prev vers end date ', 2);

178:
179:
180: BEGIN
181: IF (l_debug = 'Y') THEN
182: okc_debug.log('500: Entering update prev vers end date ', 2);
183: END IF;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: OPEN l_earlier_version_csr(p_article_id, p_article_version_id);
186: FETCH l_earlier_version_csr INTO l_earlier_version_rec ;

Line 242: okc_debug.log('500: Leaving update prev end date successfully', 2);

238: );
239: END IF;
240: CLOSE l_earlier_version_csr;
241: IF (l_debug = 'Y') THEN
242: okc_debug.log('500: Leaving update prev end date successfully', 2);
243: END IF;
244:
245:
246: EXCEPTION

Line 249: okc_debug.log('500: Leaving update prev vers end date because of EXCEPTION: '||sqlerrm, 2);

245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF (l_debug = 'Y') THEN
249: okc_debug.log('500: Leaving update prev vers end date because of EXCEPTION: '||sqlerrm, 2);
250: END IF;
251: IF l_earlier_version_csr%ISOPEN THEN
252: CLOSE l_earlier_version_csr;
253: END IF;

Line 303: okc_debug.log('100: Entered hold_unhold with '||p_hold_yn||'*'||p_article_version_id, 2);

299: l_article_version_rec l_article_version_csr%ROWTYPE;
300: BEGIN
301:
302: IF (l_debug = 'Y') THEN
303: okc_debug.log('100: Entered hold_unhold with '||p_hold_yn||'*'||p_article_version_id, 2);
304: END IF;
305:
306: IF FND_API.to_Boolean( p_init_msg_list ) THEN
307: FND_MSG_PUB.initialize;

Line 321: Okc_Debug.Log('130: - attribute G_CURRENT_ORG_ID is invalid', 2);

317: x_return_status := G_RET_STS_SUCCESS;
318: -- MOAC
319: if G_CURRENT_ORG_ID IS NULL Then
320: IF (l_debug = 'Y') THEN
321: Okc_Debug.Log('130: - attribute G_CURRENT_ORG_ID is invalid', 2);
322: END IF;
323: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
324: x_return_status := G_RET_STS_ERROR;
325: RAISE FND_API.G_EXC_ERROR ;

Line 361: okc_debug.log('120: Starting Update Adoption Statuses if Global Article ', 2);

357:
358: -- start update adoption table if work with global article (muteshev)
359: /* commented out because of bug#3251484
360: IF (l_debug = 'Y') THEN
361: okc_debug.log('120: Starting Update Adoption Statuses if Global Article ', 2);
362: END IF;
363: begin
364: if l_article_version_rec.global_yn = 'Y' then
365: update okc_article_adoptions

Line 399: okc_debug.log('140: Finishing Update Adoption Statuses if Global Article ', 2);

395: x_return_status := G_RET_STS_UNEXP_ERROR;
396: end;
397:
398: IF (l_debug = 'Y') THEN
399: okc_debug.log('140: Finishing Update Adoption Statuses if Global Article ', 2);
400: END IF;
401: */
402: -- end update adoption table if work with global article (muteshev)
403:

Line 407: okc_debug.log('160: Starting Update Article Status ', 2);

403:
404: IF x_return_status = G_RET_STS_SUCCESS THEN
405:
406: IF (l_debug = 'Y') THEN
407: okc_debug.log('160: Starting Update Article Status ', 2);
408: END IF;
409:
410: UPDATE OKC_ARTICLE_VERSIONS
411: SET ARTICLE_STATUS = l_new_article_status,

Line 420: okc_debug.log('180: Finishing Update Article Status ', 2);

416: WHERE current of l_article_version_csr;
417: end if;
418:
419: IF (l_debug = 'Y') THEN
420: okc_debug.log('180: Finishing Update Article Status ', 2);
421: END IF;
422:
423: END IF;
424: CLOSE l_article_version_csr;

Line 434: okc_debug.log('200: Leaving Hold Unhold successfully ', 2);

430: END IF;
431: --------------------------------------------
432: COMMIT;
433: IF (l_debug = 'Y') THEN
434: okc_debug.log('200: Leaving Hold Unhold successfully ', 2);
435: END IF;
436: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
437:
438: EXCEPTION

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

437:
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: IF (l_debug = 'Y') THEN
441: okc_debug.log('300: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_ERROR Exception', 2);
442: END IF;
443: x_return_status := G_RET_STS_ERROR ;
444: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
445:

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

444: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: IF (l_debug = 'Y') THEN
448: okc_debug.log('400: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
449: END IF;
450: x_return_status := G_RET_STS_UNEXP_ERROR ;
451: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
452:

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

451: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
452:
453: WHEN OTHERS THEN
454: IF (l_debug = 'Y') THEN
455: okc_debug.log('500: Leaving Hold_Unhold because of EXCEPTION: '||sqlerrm, 2);
456: END IF;
457:
458: x_return_status := G_RET_STS_UNEXP_ERROR ;
459: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );

Line 606: okc_debug.log('100: Entered pending approval with '||p_current_org_id ||''||p_adopt_as_is_yn||''||p_article_version_id, 2);

602: -- Above added for Bug 5958643
603:
604: BEGIN
605: IF (l_debug = 'Y') THEN
606: okc_debug.log('100: Entered pending approval with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
607: END IF;
608: -- Initialize API return status to success
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610:

Line 619: okc_debug.log('100: Validating article type and default section', 2);

615:
616: IF (p_current_org_id = G_GLOBAL_ORG_ID ) OR
617: p_adopt_as_is_yn = 'N' THEN
618: IF (l_debug = 'Y') THEN
619: okc_debug.log('100: Validating article type and default section', 2);
620: END IF;
621:
622: -- Below Added for Bug 3737158
623: -- Standard clauses will be checked for valid lookup code

Line 661: okc_debug.log('100: Validating variables and assoc. with intent', 2);

657: -- All the variables used should not have been inactivated since the article
658: -- cersion was created.
659:
660: IF (l_debug = 'Y') THEN
661: okc_debug.log('100: Validating variables and assoc. with intent', 2);
662: END IF;
663: OPEN l_check_valid_var_csr (p_article_version_id);
664: FETCH l_check_valid_var_csr BULK COLLECT INTO
665: l_variable_tbl,

Line 759: okc_debug.log('100: Entered pending approval for global article at a global org', 2);

755: -- global org. Updates the status of the version
756:
757: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
758: IF (l_debug = 'Y') THEN
759: okc_debug.log('100: Entered pending approval for global article at a global org', 2);
760: END IF;
761: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
762: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
763: x_return_status => x_return_status,

Line 821: okc_debug.log('100: Entered pending approval for global article at a local org adopted as is', 2);

817: -- Also inherits all relationships between this article and other global articles adopted in this org if this
818: -- is the first version being adopted.
819:
820: IF (l_debug = 'Y') THEN
821: okc_debug.log('100: Entered pending approval for global article at a local org adopted as is', 2);
822: END IF;
823:
824: OKC_ADOPTIONS_GRP.check_adoption_details(
825: p_api_version => p_api_version,

Line 946: okc_debug.log('100: Entered pending approval for local article at a local org ', 2);

942:
943: -- An Article (being created at a local org) is being send for Approval at a
944: -- local org. Updates the status of the version.
945: IF (l_debug = 'Y') THEN
946: okc_debug.log('100: Entered pending approval for local article at a local org ', 2);
947: END IF;
948:
949: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
950: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 1025: okc_debug.log('200: Leaving pending approval successfully', 2);

1021: RAISE FND_API.G_EXC_ERROR ;
1022: END IF;
1023:
1024: IF (l_debug = 'Y') THEN
1025: okc_debug.log('200: Leaving pending approval successfully', 2);
1026: END IF;
1027:
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN

Line 1031: okc_debug.log('300: Leaving pending approval OKC_API.G_EXCEPTION_ERROR Exception', 2);

1027:
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: IF (l_debug = 'Y') THEN
1031: okc_debug.log('300: Leaving pending approval OKC_API.G_EXCEPTION_ERROR Exception', 2);
1032: END IF;
1033: x_return_status := G_RET_STS_ERROR ;
1034:
1035: WHEN OTHERS THEN

Line 1037: okc_debug.log('500: Leaving pending approval of EXCEPTION: '||sqlerrm, 2);

1033: x_return_status := G_RET_STS_ERROR ;
1034:
1035: WHEN OTHERS THEN
1036: IF (l_debug = 'Y') THEN
1037: okc_debug.log('500: Leaving pending approval of EXCEPTION: '||sqlerrm, 2);
1038: END IF;
1039: x_return_status := G_RET_STS_UNEXP_ERROR ;
1040:
1041: END pending_approval;

Line 1083: okc_debug.log('100: Entered approved with '||p_current_org_id ||''||p_adopt_as_is_yn||''||p_article_version_id, 2);

1079: l_new_article_status VARCHAR2(30) := NULL;
1080: BEGIN
1081:
1082: IF (l_debug = 'Y') THEN
1083: okc_debug.log('100: Entered approved with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1084: END IF;
1085: x_return_status := G_RET_STS_SUCCESS;
1086:
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1105: okc_debug.log('100: Entered approve of global article at a global org', 2);

1101:
1102: -- An Article (being created at a global org) is being Approved at a
1103: --global org. Updates the status of the version
1104: IF (l_debug = 'Y') THEN
1105: okc_debug.log('100: Entered approve of global article at a global org', 2);
1106: END IF;
1107:
1108: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1109: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 1189: okc_debug.log('100: Calling Auto Adoption ', 2);

1185: -- how the org has been set up in HR Orgs for auto-adoption
1186:
1187: IF l_article_version_rec.global_YN = 'Y' THEN
1188: IF (l_debug = 'Y') THEN
1189: okc_debug.log('100: Calling Auto Adoption ', 2);
1190: END IF;
1191: OKC_ADOPTIONS_GRP.AUTO_ADOPT_ARTICLES
1192: (
1193: p_api_version => 1.0,

Line 1213: okc_debug.log('100: Entered approve of global article adopted as is at a local org', 2);

1209: -- An Article (being created at a global org) is being Approved for
1210: -- "adopted as is" at a local org. Updates the status of the adoption
1211:
1212: IF (l_debug = 'Y') THEN
1213: okc_debug.log('100: Entered approve of global article adopted as is at a local org', 2);
1214: END IF;
1215:
1216: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1217: x_return_status => x_return_status,

Line 1232: okc_debug.log('100: Entered approve of local article at a local org', 2);

1228: -- An Article (being created at a local org) is being Approved at a local org.
1229: -- Updates the status of the version
1230:
1231: IF (l_debug = 'Y') THEN
1232: okc_debug.log('100: Entered approve of local article at a local org', 2);
1233: END IF;
1234:
1235: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1236: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 1333: okc_debug.log('200: Leaving approve successfully', 2);

1329: RAISE FND_API.G_EXC_ERROR ;
1330: END IF;
1331:
1332: IF (l_debug = 'Y') THEN
1333: okc_debug.log('200: Leaving approve successfully', 2);
1334: END IF;
1335:
1336: EXCEPTION
1337: WHEN FND_API.G_EXC_ERROR THEN

Line 1339: okc_debug.log('300: Leaving approve because of OKC_API.G_EXCEPTION_ERROR Exception', 2);

1335:
1336: EXCEPTION
1337: WHEN FND_API.G_EXC_ERROR THEN
1338: IF (l_debug = 'Y') THEN
1339: okc_debug.log('300: Leaving approve because of OKC_API.G_EXCEPTION_ERROR Exception', 2);
1340: END IF;
1341: x_return_status := G_RET_STS_ERROR ;
1342:
1343: WHEN OTHERS THEN

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

1341: x_return_status := G_RET_STS_ERROR ;
1342:
1343: WHEN OTHERS THEN
1344: IF (l_debug = 'Y') THEN
1345: okc_debug.log('500: Leaving approve because of EXCEPTION: '||sqlerrm, 2);
1346: END IF;
1347: IF l_article_version_csr%ISOPEN THEN
1348: CLOSE l_article_version_csr;
1349: END IF;

Line 1393: okc_debug.log('100: Entered reject with '||p_current_org_id ||''||p_adopt_as_is_yn||''||p_article_version_id, 2);

1389: l_new_article_status VARCHAR2(30) := NULL;
1390: BEGIN
1391:
1392: IF (l_debug = 'Y') THEN
1393: okc_debug.log('100: Entered reject with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1394: END IF;
1395: x_return_status := G_RET_STS_SUCCESS;
1396:
1397: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1416: okc_debug.log('100: Entered reject of global article at a global org', 2);

1412: --global org. Updates the status of the version
1413:
1414: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
1415: IF (l_debug = 'Y') THEN
1416: okc_debug.log('100: Entered reject of global article at a global org', 2);
1417: END IF;
1418: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1419: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1420: x_return_status => x_return_status,

Line 1483: okc_debug.log('100: Entered reject of global article adopted as is at a local org', 2);

1479: -- "Adopted As Is" at a local org. Updates the status of the adoption.
1480: -- The Article becomes Pending Adoption and all global relationships are deleted if this is the first version being adopted.
1481:
1482: IF (l_debug = 'Y') THEN
1483: okc_debug.log('100: Entered reject of global article adopted as is at a local org', 2);
1484: END IF;
1485:
1486: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1487: x_return_status => x_return_status,

Line 1530: okc_debug.log('100: Entered reject of local article at a local org', 2);

1526:
1527: -- An Article (being created at a local org) is being Rejected at a
1528: --local org. Updates the status of the version
1529: IF (l_debug = 'Y') THEN
1530: okc_debug.log('100: Entered reject of local article at a local org', 2);
1531: END IF;
1532:
1533: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1534: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

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

1611: RAISE FND_API.G_EXC_ERROR ;
1612: END IF;
1613:
1614: IF (l_debug = 'Y') THEN
1615: okc_debug.log('200: Leaving check adoption', 2);
1616: END IF;
1617:
1618: EXCEPTION
1619: WHEN FND_API.G_EXC_ERROR THEN

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

1617:
1618: EXCEPTION
1619: WHEN FND_API.G_EXC_ERROR THEN
1620: IF (l_debug = 'Y') THEN
1621: okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1622: END IF;
1623: x_return_status := G_RET_STS_ERROR ;
1624:
1625: WHEN OTHERS THEN

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

1623: x_return_status := G_RET_STS_ERROR ;
1624:
1625: WHEN OTHERS THEN
1626: IF (l_debug = 'Y') THEN
1627: okc_debug.log('500: Leaving delete_Adoption because of EXCEPTION: '||sqlerrm, 2);
1628: END IF;
1629: IF l_article_version_csr%ISOPEN THEN
1630: CLOSE l_article_version_csr;
1631: END IF;