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 244: okc_debug.log('500: Leaving update prev end date successfully', 2);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

614: -- Above added for Bug 5958643
615:
616: BEGIN
617: IF (l_debug = 'Y') THEN
618: okc_debug.log('100: Entered pending approval with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
619: END IF;
620: -- Initialize API return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:

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

627:
628: IF (p_current_org_id = G_GLOBAL_ORG_ID ) OR
629: p_adopt_as_is_yn = 'N' THEN
630: IF (l_debug = 'Y') THEN
631: okc_debug.log('100: Validating article type and default section', 2);
632: END IF;
633:
634: -- Below Added for Bug 3737158
635: -- Standard clauses will be checked for valid lookup code

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

669: -- All the variables used should not have been inactivated since the article
670: -- cersion was created.
671:
672: IF (l_debug = 'Y') THEN
673: okc_debug.log('100: Validating variables and assoc. with intent', 2);
674: END IF;
675: OPEN l_check_valid_var_csr (p_article_version_id);
676: FETCH l_check_valid_var_csr BULK COLLECT INTO
677: l_variable_tbl,

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

769: -- global org. Updates the status of the version
770:
771: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
772: IF (l_debug = 'Y') THEN
773: okc_debug.log('100: Entered pending approval for global article at a global org', 2);
774: END IF;
775: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
776: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
777: x_return_status => x_return_status,

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

833: -- Also inherits all relationships between this article and other global articles adopted in this org if this
834: -- is the first version being adopted.
835:
836: IF (l_debug = 'Y') THEN
837: okc_debug.log('100: Entered pending approval for global article at a local org adopted as is', 2);
838: END IF;
839:
840: OKC_ADOPTIONS_GRP.check_adoption_details(
841: p_api_version => p_api_version,

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

958:
959: -- An Article (being created at a local org) is being send for Approval at a
960: -- local org. Updates the status of the version.
961: IF (l_debug = 'Y') THEN
962: okc_debug.log('100: Entered pending approval for local article at a local org ', 2);
963: END IF;
964:
965: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
966: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

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

1039: RAISE FND_API.G_EXC_ERROR ;
1040: END IF;
1041:
1042: IF (l_debug = 'Y') THEN
1043: okc_debug.log('200: Leaving pending approval successfully', 2);
1044: END IF;
1045:
1046: EXCEPTION
1047: WHEN FND_API.G_EXC_ERROR THEN

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

1045:
1046: EXCEPTION
1047: WHEN FND_API.G_EXC_ERROR THEN
1048: IF (l_debug = 'Y') THEN
1049: okc_debug.log('300: Leaving pending approval OKC_API.G_EXCEPTION_ERROR Exception', 2);
1050: END IF;
1051: x_return_status := G_RET_STS_ERROR ;
1052:
1053: WHEN OTHERS THEN

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

1051: x_return_status := G_RET_STS_ERROR ;
1052:
1053: WHEN OTHERS THEN
1054: IF (l_debug = 'Y') THEN
1055: okc_debug.log('500: Leaving pending approval of EXCEPTION: '||sqlerrm, 2);
1056: END IF;
1057: x_return_status := G_RET_STS_UNEXP_ERROR ;
1058:
1059: END pending_approval;

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

1097: l_new_article_status VARCHAR2(30) := NULL;
1098: BEGIN
1099:
1100: IF (l_debug = 'Y') THEN
1101: okc_debug.log('100: Entered approved with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1102: END IF;
1103: x_return_status := G_RET_STS_SUCCESS;
1104:
1105: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

1119:
1120: -- An Article (being created at a global org) is being Approved at a
1121: --global org. Updates the status of the version
1122: IF (l_debug = 'Y') THEN
1123: okc_debug.log('100: Entered approve of global article at a global org', 2);
1124: END IF;
1125:
1126: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1127: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

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

1205: -- how the org has been set up in HR Orgs for auto-adoption
1206:
1207: IF l_article_version_rec.global_YN = 'Y' THEN
1208: IF (l_debug = 'Y') THEN
1209: okc_debug.log('100: Calling Auto Adoption ', 2);
1210: END IF;
1211: OKC_ADOPTIONS_GRP.AUTO_ADOPT_ARTICLES
1212: (
1213: p_api_version => 1.0,

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

1229: -- An Article (being created at a global org) is being Approved for
1230: -- "adopted as is" at a local org. Updates the status of the adoption
1231:
1232: IF (l_debug = 'Y') THEN
1233: okc_debug.log('100: Entered approve of global article adopted as is at a local org', 2);
1234: END IF;
1235:
1236: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1237: x_return_status => x_return_status,

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

1248: -- An Article (being created at a local org) is being Approved at a local org.
1249: -- Updates the status of the version
1250:
1251: IF (l_debug = 'Y') THEN
1252: okc_debug.log('100: Entered approve of local article at a local org', 2);
1253: END IF;
1254:
1255: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1256: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

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

1351: RAISE FND_API.G_EXC_ERROR ;
1352: END IF;
1353:
1354: IF (l_debug = 'Y') THEN
1355: okc_debug.log('200: Leaving approve successfully', 2);
1356: END IF;
1357:
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN

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

1357:
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: IF (l_debug = 'Y') THEN
1361: okc_debug.log('300: Leaving approve because of OKC_API.G_EXCEPTION_ERROR Exception', 2);
1362: END IF;
1363: x_return_status := G_RET_STS_ERROR ;
1364:
1365: WHEN OTHERS THEN

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

1363: x_return_status := G_RET_STS_ERROR ;
1364:
1365: WHEN OTHERS THEN
1366: IF (l_debug = 'Y') THEN
1367: okc_debug.log('500: Leaving approve because of EXCEPTION: '||sqlerrm, 2);
1368: END IF;
1369: IF l_article_version_csr%ISOPEN THEN
1370: CLOSE l_article_version_csr;
1371: END IF;

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

1411: l_new_article_status VARCHAR2(30) := NULL;
1412: BEGIN
1413:
1414: IF (l_debug = 'Y') THEN
1415: okc_debug.log('100: Entered reject with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1416: END IF;
1417: x_return_status := G_RET_STS_SUCCESS;
1418:
1419: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

1434: --global org. Updates the status of the version
1435:
1436: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
1437: IF (l_debug = 'Y') THEN
1438: okc_debug.log('100: Entered reject of global article at a global org', 2);
1439: END IF;
1440: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1441: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1442: x_return_status => x_return_status,

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

1503: -- "Adopted As Is" at a local org. Updates the status of the adoption.
1504: -- The Article becomes Pending Adoption and all global relationships are deleted if this is the first version being adopted.
1505:
1506: IF (l_debug = 'Y') THEN
1507: okc_debug.log('100: Entered reject of global article adopted as is at a local org', 2);
1508: END IF;
1509:
1510: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1511: x_return_status => x_return_status,

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

1550:
1551: -- An Article (being created at a local org) is being Rejected at a
1552: --local org. Updates the status of the version
1553: IF (l_debug = 'Y') THEN
1554: okc_debug.log('100: Entered reject of local article at a local org', 2);
1555: END IF;
1556:
1557: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1558: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

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

1637: RAISE FND_API.G_EXC_ERROR ;
1638: END IF;
1639:
1640: IF (l_debug = 'Y') THEN
1641: okc_debug.log('200: Leaving check adoption', 2);
1642: END IF;
1643:
1644: EXCEPTION
1645: WHEN FND_API.G_EXC_ERROR THEN

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

1643:
1644: EXCEPTION
1645: WHEN FND_API.G_EXC_ERROR THEN
1646: IF (l_debug = 'Y') THEN
1647: okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1648: END IF;
1649: x_return_status := G_RET_STS_ERROR ;
1650:
1651: WHEN OTHERS THEN

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

1649: x_return_status := G_RET_STS_ERROR ;
1650:
1651: WHEN OTHERS THEN
1652: IF (l_debug = 'Y') THEN
1653: okc_debug.log('500: Leaving delete_Adoption because of EXCEPTION: '||sqlerrm, 2);
1654: END IF;
1655: IF l_article_version_csr%ISOPEN THEN
1656: CLOSE l_article_version_csr;
1657: END IF;