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 FND_API

Line 19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

Line 20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:

Line 21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

Line 23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
30: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
30: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
31: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

39: -- 'Submit for Approve' - OKC_ARTICLE_STATUS_CHANGE_PVT.pending_approval
40: PROCEDURE check_adoption_details(
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44:
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,

Line 212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

208: END IF;
209: x_earlier_local_version_id := NULL;
210:
211: -- Standard Start of API savepoint
212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209: x_earlier_local_version_id := NULL;
210:
211: -- Standard Start of API savepoint
212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
217: FND_MSG_PUB.initialize;

Line 216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
217: FND_MSG_PUB.initialize;
218: END IF;
219:
220: -- Initialize API return status to success

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: FND_MSG_PUB.initialize;
218: END IF;
219:
220: -- Initialize API return status to success
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');

Line 226: RAISE FND_API.G_EXC_ERROR ;

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');
230: RAISE FND_API.G_EXC_ERROR ;

Line 230: RAISE FND_API.G_EXC_ERROR ;

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;
234: l_row_notfound := l_adoption_csr%NOTFOUND;

Line 245: RAISE FND_API.G_EXC_ERROR ;

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
249: IF (l_debug = 'Y') THEN

Line 253: RAISE FND_API.G_EXC_ERROR ;

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
257: IF (l_debug = 'Y') THEN

Line 261: RAISE FND_API.G_EXC_ERROR ;

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:
265: OPEN l_latest_ver_adp_csr(l_adoption_rec.article_id, p_global_article_version_id, p_local_org_id);

Line 290: RAISE FND_API.G_EXC_ERROR ;

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;
294: OPEN l_latest_ver_lcz_csr(l_lcz_article_id);

Line 305: RAISE FND_API.G_EXC_ERROR;

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')
309: IN ('DRAFT','REJECTED','PENDING_APPROVAL') THEN

Line 314: RAISE FND_API.G_EXC_ERROR ;

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
318: -- Adoption flow

Line 324: RAISE FND_API.G_EXC_ERROR;

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')
328: IN ('PENDING_APPROVAL') THEN

Line 333: RAISE FND_API.G_EXC_ERROR ;

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:
337: --Check whether adopted article title exists in local org

Line 352: RAISE FND_API.G_EXC_ERROR ;

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;
356:

Line 365: WHEN FND_API.G_EXC_ERROR THEN

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
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 ;

Line 372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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:
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

Line 463: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
466: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 466: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

462: END IF;
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard Start of API savepoint
466: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: -- Initialize message list if p_init_msg_list is set to TRUE.
470: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard Start of API savepoint
466: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: -- Initialize message list if p_init_msg_list is set to TRUE.
470: IF FND_API.to_Boolean( p_init_msg_list ) THEN
471: FND_MSG_PUB.initialize;

Line 470: IF FND_API.to_Boolean( p_init_msg_list ) THEN

466: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: -- Initialize message list if p_init_msg_list is set to TRUE.
470: IF FND_API.to_Boolean( p_init_msg_list ) THEN
471: FND_MSG_PUB.initialize;
472: END IF;
473: -- Initialize API return status to success
474: -- If a local article version is deleted the attached global article version

Line 530: RAISE FND_API.G_EXC_ERROR ;

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:
534: IF (l_debug = 'Y') THEN

Line 539: WHEN FND_API.G_EXC_ERROR THEN

535: okc_debug.log('200: Leaving check adoption', 2);
536: END IF;
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 ;

Line 559: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

555:
556: PROCEDURE create_local_adoption_details(
557: p_api_version IN NUMBER,
558: p_init_msg_list IN VARCHAR2 ,
559: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
560:
561: x_return_status OUT NOCOPY VARCHAR2,
562: x_msg_count OUT NOCOPY NUMBER,
563: x_msg_data OUT NOCOPY VARCHAR2,

Line 600: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) 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
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list ) THEN
605: FND_MSG_PUB.initialize;

Line 604: IF FND_API.to_Boolean( p_init_msg_list ) THEN

600: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list ) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607: -- Initialize API return status to success
608: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 608: x_return_status := FND_API.G_RET_STS_SUCCESS;

604: IF FND_API.to_Boolean( p_init_msg_list ) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607: -- Initialize API return status to success
608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609: x_adoption_type := NULL;
610: -- dbms_output.put_line(p_earlier_local_version_id||'*'||p_global_article_version_id);
611: IF (p_local_org_id = G_GLOBAL_ORG_ID OR
612: p_local_org_id = -99 OR

Line 629: RAISE FND_API.G_EXC_ERROR ;

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
633: -- version should not be the same for the earlier version of the same local

Line 643: RAISE FND_API.G_EXC_ERROR ;

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
647: -- adoption type i.e. ADOPTED (as is) ... ERROR

Line 651: RAISE FND_API.G_EXC_ERROR ;

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
655: l_global_article_version_id := p_global_article_version_id;

Line 677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

673: -- dbms_output.put_line('RETURN:'||x_return_status);
674:
675: --------------------------------------------
676: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
678: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
679: RAISE FND_API.G_EXC_ERROR ;
680: END IF;
681: --------------------------------------------

Line 679: RAISE FND_API.G_EXC_ERROR ;

675: --------------------------------------------
676: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
678: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
679: RAISE FND_API.G_EXC_ERROR ;
680: END IF;
681: --------------------------------------------
682: x_adoption_type := 'LOCALIZED';
683: return;

Line 732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

728: END IF; -- l_global_article_version_id is NULL
729: END IF; -- local org id = global org id
730: --------------------------------------------
731: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
733: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
734: RAISE FND_API.G_EXC_ERROR ;
735: END IF;
736: --------------------------------------------

Line 734: RAISE FND_API.G_EXC_ERROR ;

730: --------------------------------------------
731: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
733: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
734: RAISE FND_API.G_EXC_ERROR ;
735: END IF;
736: --------------------------------------------
737:
738: IF (l_debug = 'Y') THEN

Line 743: WHEN FND_API.G_EXC_ERROR THEN

739: okc_debug.log('200: Leaving check adoption', 2);
740: END IF;
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 ;

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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
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

Line 774: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

770: PROCEDURE AUTO_ADOPT_ARTICLES
771: (
772: p_api_version IN NUMBER,
773: p_init_msg_list IN VARCHAR2 ,
774: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
775: p_commit IN VARCHAR2 := FND_API.G_FALSE,
776:
777: x_return_status OUT NOCOPY VARCHAR2,
778: x_msg_count OUT NOCOPY NUMBER,

Line 775: p_commit IN VARCHAR2 := FND_API.G_FALSE,

771: (
772: p_api_version IN NUMBER,
773: p_init_msg_list IN VARCHAR2 ,
774: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
775: p_commit IN VARCHAR2 := FND_API.G_FALSE,
776:
777: x_return_status OUT NOCOPY VARCHAR2,
778: x_msg_count OUT NOCOPY NUMBER,
779: x_msg_data OUT NOCOPY VARCHAR2,

Line 896: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) 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
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list ) THEN
901: FND_MSG_PUB.initialize;

Line 900: IF FND_API.to_Boolean( p_init_msg_list ) THEN

896: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list ) THEN
901: FND_MSG_PUB.initialize;
902: END IF;
903: -- Initialize API return status to success
904: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 904: x_return_status := FND_API.G_RET_STS_SUCCESS;

900: IF FND_API.to_Boolean( p_init_msg_list ) THEN
901: FND_MSG_PUB.initialize;
902: END IF;
903: -- Initialize API return status to success
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905: l_return_status := FND_API.G_RET_STS_SUCCESS;
906: --dbms_output.put_line('Global org is: '|| l_global_org_id);
907: if p_adoption_yn = 'N' and p_relationship_yn = 'N' Then
908: return;

Line 905: l_return_status := FND_API.G_RET_STS_SUCCESS;

901: FND_MSG_PUB.initialize;
902: END IF;
903: -- Initialize API return status to success
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905: l_return_status := FND_API.G_RET_STS_SUCCESS;
906: --dbms_output.put_line('Global org is: '|| l_global_org_id);
907: if p_adoption_yn = 'N' and p_relationship_yn = 'N' Then
908: return;
909: end if;

Line 1069: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then

1065: exit;
1066: END;
1067: END LOOP; -- for i in l_org_id_tbl..
1068: i := 0;
1069: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then
1070: IF p_adoption_yn = 'Y' AND l_org_id_tbl.COUNT > 0 Then
1071: FORALL i in l_org_id_tbl.FIRST .. l_org_id_tbl.LAST
1072: INSERT INTO OKC_ARTICLE_ADOPTIONS
1073: (

Line 1120: IF FND_API.To_Boolean( p_commit ) THEN

1116: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1117: return;
1118: END IF;
1119: -- Standard check of p_commit
1120: IF FND_API.To_Boolean( p_commit ) THEN
1121: COMMIT WORK;
1122: END IF;
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 );

Line 1131: WHEN FND_API.G_EXC_ERROR THEN

1127: okc_debug.log('200: Leaving check adoption', 2);
1128: END IF;
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 ;

Line 1137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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
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

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

1293: l_GLOBAL_ORG_ID := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1294: if p_org_id = l_GLOBAL_ORG_ID or p_org_id = -99 Then
1295: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_ADOPT_INVALID_ORG');
1296: FND_MSG_PUB.add;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
1298: retcode := 2;
1299: return;
1300: end if;
1301:

Line 1302: l_return_status := FND_API.G_RET_STS_SUCCESS;

1298: retcode := 2;
1299: return;
1300: end if;
1301:
1302: l_return_status := FND_API.G_RET_STS_SUCCESS;
1303:
1304: -- First determine whether the orgid passed is a valid org defined in HR Org definitions.
1305:
1306: OPEN l_org_info_csr (p_org_id,l_global_org_id);

Line 1317: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

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 ));
1318: retcode := 2;
1319: return;
1320: END IF;
1321:

Line 1596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MSG_PUB.Get(1,p_encoded=>FND_API.G_FALSE));

1592: p_token3_value => l_count_ver_available,
1593: p_token4 => 'ORG_NAME',
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