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_API

Line 9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ADOPTIONS_GRP';

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ADOPTIONS_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

Line 225: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_NO_ADP_GLBL_ORG');

221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: IF (p_local_org_id = G_GLOBAL_ORG_ID OR
223: p_local_org_id = -99 OR
224: l_global_org_id = -99) THEN
225: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_NO_ADP_GLBL_ORG');
226: RAISE FND_API.G_EXC_ERROR ;
227: ELSE
228: IF p_global_article_version_id IS NULL Then
229: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');

Line 229: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');

225: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_NO_ADP_GLBL_ORG');
226: RAISE FND_API.G_EXC_ERROR ;
227: ELSE
228: IF p_global_article_version_id IS NULL Then
229: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');
230: RAISE FND_API.G_EXC_ERROR ;
231: END IF;
232: OPEN l_adoption_csr (p_global_article_version_id, p_local_org_id);
233: FETCH l_adoption_csr INTO l_adoption_rec;

Line 244: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');

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;
247:
248: IF (nvl(p_adoption_type, 'INVALID') NOT IN ('ADOPTED', 'LOCALIZED')) THEN

Line 252: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');

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;
255:
256: IF (l_adoption_rec.article_status = 'ON_HOLD') THEN

Line 260: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_STATUS_TO_ADOPT');

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;
263:
264:

Line 289: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_DIFF_ADP_TYPE');

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
292: -- localization flow
293: l_lcz_row_notfound := FALSE;

Line 304: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_INV_GLOB_ADP');

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;
307:
308: IF nvl(l_latest_ver_lcz_rec.adoption_status, 'DRAFT')

Line 313: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_EXIST_DRAFT_LOCALIZED');

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;
316:
317: ELSIF ( NOT l_adp_row_notfound) THEN

Line 323: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_LATER_GLOB_ADP_EXIST');

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;
326:
327: IF nvl(l_latest_ver_adp_rec.adoption_status, 'REJECTED')

Line 332: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_EXIST_PENDING_ADOPTED');

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;
335: END IF; -- IF (l_adp_row_notfound AND l_lcz_row_notfound)
336:

Line 351: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_DUP_TITLE_ADP_ORG');

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;
354:
355: END IF;

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 517: p_adoption_status => OKC_API.G_MISS_CHAR,

513: p_adoption_type => 'AVAILABLE',
514: p_local_org_id => p_local_org_id,
515: p_orig_local_version_id => p_local_article_version_id,
516: p_new_local_version_id => NULL,
517: p_adoption_status => OKC_API.G_MISS_CHAR,
518: p_object_version_number => NULL
519: );
520: ELSIF l_delete_adoption = 'T' Then
521: OKC_ARTICLE_ADOPTIONS_PVT.delete_row(

Line 529: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_ADP_NOT_FOUND');

525: p_local_article_version_id => p_local_article_version_id,
526: p_object_version_number => NULL
527: );
528: ELSE
529: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_ADP_NOT_FOUND');
530: RAISE FND_API.G_EXC_ERROR ;
531: END IF;
532: END IF;
533:

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 628: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_EARLIER_NOT_ADPT');

624: -- Earlier version of the local article exists but has not been adopted ...
625: -- ERROR
626:
627: IF (l_row_notfound) THEN
628: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_EARLIER_NOT_ADPT');
629: RAISE FND_API.G_EXC_ERROR ;
630: END IF;
631: /*
632: -- For LOCALIZE option the same global article version for a local article

Line 642: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_MULTI_GLOB_ADPT');

638: -- article version_id from the previous adoption.
639:
640: IF p_global_article_version_id IS NOT NULL AND
641: p_global_article_version_id = l_adoption_rec.global_article_version_id THEN
642: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_MULTI_GLOB_ADPT');
643: RAISE FND_API.G_EXC_ERROR ;
644: END IF;
645: */
646: -- For LOCALIZE option the earlier local article version id has a different

Line 650: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_DIFF_ADP_TYPE');

646: -- For LOCALIZE option the earlier local article version id has a different
647: -- adoption type i.e. ADOPTED (as is) ... ERROR
648:
649: IF l_adoption_rec.adoption_type <> 'LOCALIZED' THEN
650: OKC_API.SET_MESSAGE(G_APP_NAME, 'OKC_ART_DIFF_ADP_TYPE');
651: RAISE FND_API.G_EXC_ERROR ;
652: END IF;
653: l_global_article_version_id := l_adoption_rec.global_article_version_id;
654: ELSE -- earlier local version id IS NULL

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 935: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

931: CLOSE l_adoptions_csr;
932:
933: if (l_rowfound) THEN
934: l_adp_record_status_tbl(i) := 'E';
935: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
936: p_msg_name => 'OKC_ART_ADP_ALREADY_EXIST',
937: p_token1 => 'ORG_ID',
938: p_token1_value => l_org_id_tbl(i));
939: l_return_status := G_RET_STS_ERROR;

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 1585: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1581: FETCH l_adoption_type_meaning_csr into l_adoption_type_meaning;
1582: CLOSE l_adoption_type_meaning_csr;
1583:
1584: -- Write report into OUTPUT
1585: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1586: p_msg_name => 'OKC_ART_ADP_NEWORG_OUTPUT',
1587: p_token1 => 'ADOPTION_TYPE',
1588: p_token1_value => l_adoption_type_meaning,
1589: p_token2 => 'TOTAL_VER_ADOPTED',