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_ARTICLES_MIGRATE_GRP dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

24: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
25:
26: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
29:
30: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
31: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
32: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

58: FND_MSG_PUB.Count_And_Get( p_count => l_count, p_encoded=> 'F', p_data => l_msg_data );
59:
60: IF l_count > 1 Then
61: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
62: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
63: END LOOP;
64: ELSE
65: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
66: END IF;

Line 115: RAISE FND_API.G_EXC_ERROR ;

111: l_return_status := G_RET_STS_ERROR;
112:
113: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
114: p_msg_name => 'OKC_ART_IMP_LIM_FETCHSIZE');
115: RAISE FND_API.G_EXC_ERROR ;
116: END IF;
117:
118: -- Call the Article Migration API
119: OKC_ARTICLES_MIGRATE_GRP.migrate_articles(

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

140: retcode := 2;
141: errbuf := substr(sqlerrm,1,200);
142: IF FND_MSG_PUB.Count_Msg > 0 Then
143: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
144: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
145: END LOOP;
146: END IF;
147: FND_MSG_PUB.initialize;
148:

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

154: retcode := 2;
155: errbuf := substr(sqlerrm,1,200);
156: IF FND_MSG_PUB.Count_Msg > 0 Then
157: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
158: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
159: END LOOP;
160: END IF;
161: FND_MSG_PUB.initialize;
162: IF (l_debug = 'Y') THEN

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

168: errbuf := substr(sqlerrm,1,200);
169:
170: IF FND_MSG_PUB.Count_Msg > 0 Then
171: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
172: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
173: END LOOP;
174: END IF;
175: FND_MSG_PUB.initialize;
176: IF (l_debug = 'Y') THEN

Line 286: RAISE FND_API.G_EXC_ERROR ;

282:
283: IF l_row_notfound THEN
284: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
285: p_msg_name => 'OKC_ART_INCMPLT_CUR_ORG_DEF');
286: RAISE FND_API.G_EXC_ERROR ;
287: END IF;
288:
289:
290: INSERT INTO OKC_ARTICLE_ADOPTIONS

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

364: REL1.org_id = G_CURRENT_ORG_ID);
365:
366: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
367: p_msg_name => 'OKC_ART_MIG_OUTPUT');
368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
369: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_org_name);
370:
371: x_return_status := G_RET_STS_SUCCESS;
372:

Line 374: WHEN FND_API.G_EXC_ERROR THEN

370:
371: x_return_status := G_RET_STS_SUCCESS;
372:
373: EXCEPTION
374: WHEN FND_API.G_EXC_ERROR THEN
375: IF (l_debug = 'Y') THEN
376: okc_debug.Log('300: Error occurred in process_current_org: OKC_API.G_EXCEPTION_ERROR Exception', 2);
377: END IF;
378: get_print_msgs_stack;

Line 622: x_return_status := FND_API.G_RET_STS_SUCCESS;

618: -------------------------------------------------------------------------
619: -- Standard Start of API savepoint
620: FND_MSG_PUB.initialize;
621: -- Initialize API return status to success
622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623: l_return_status := G_RET_STS_SUCCESS;
624: -- Cache user_id and login_id
625: G_user_id := Fnd_Global.user_id;
626: G_login_id := Fnd_Global.login_id;

Line 633: RAISE FND_API.G_EXC_ERROR;

629: -- if global org is not defined then error out
630: IF G_GLOBAL_ORG_ID = '-99' Then
631: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
632: p_msg_name => 'OKC_ART_NO_GLOBAL_ORG');
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635:
636: -- Derive and cache the base language
637: OPEN get_languages;

Line 643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

639: l_row_notfound := get_languages%NOTFOUND;
640: CLOSE get_languages;
641: IF l_row_notfound THEN
642: Okc_Api.Set_Message(p_app_name => G_APP_NAME,p_msg_name => 'OKC_ART_NO_BASE_LANG');
643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
644: END IF;
645:
646: -- Check for orgs in contracts that are not defined for Articles in HR_ORG
647:

Line 660: RAISE FND_API.G_EXC_ERROR ;

656: FND_FILE.PUT_LINE(FND_FILE.LOG,l_org_name_tbl(i));
657: -- dbms_output.put_line(l_org_name_tbl(i)||'ORG');
658: END LOOP;
659: l_org_name_tbl.DELETE;
660: RAISE FND_API.G_EXC_ERROR ;
661: END IF;
662:
663: l_org_name_tbl.DELETE;
664:

Line 674: RAISE FND_API.G_EXC_ERROR ;

670: IF l_org_id_tbl.COUNT <= 0 THEN
671: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
672: p_msg_name => 'OKC_ART_INCMPLT_ORG_DEF');
673: get_print_msgs_stack;
674: RAISE FND_API.G_EXC_ERROR ;
675: END IF;
676:
677: -- Update Article Text with ' ' to be migrated to OKC_ARTICLE_VERSIONS
678: UPDATE OKC_STD_ART_VERSIONS_TL

Line 781: RAISE FND_API.G_EXC_ERROR ;

777: p_token2_value => sqlerrm);
778:
779: l_return_status := G_RET_STS_ERROR;
780: x_return_status := G_RET_STS_ERROR ;
781: RAISE FND_API.G_EXC_ERROR ;
782: END;
783:
784: BEGIN
785: INSERT INTO OKC_FOLDERS_ALL_TL (

Line 828: RAISE FND_API.G_EXC_ERROR;

824: p_token2 => G_SQLERRM_TOKEN,
825: p_token2_value => sqlerrm);
826: l_return_status := G_RET_STS_ERROR;
827: x_return_status := G_RET_STS_ERROR;
828: RAISE FND_API.G_EXC_ERROR;
829: END;
830: ------------------------------------------------------------------------
831: -- Bulk fetch all articles rows based on the fetchsize passed by the user
832: -- the outermost loop of this procedure

Line 885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

881: ELSIF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
882: article_number_tbl(i) := NULL;
883: l_return_status := x_return_status;
884: art_process_status_tbl(i) := 'U';
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: ELSE
887: article_number_tbl(i) := NULL;
888: art_process_status_tbl(i) := 'U';
889: l_return_status := x_return_status;

Line 890: RAISE FND_API.G_EXC_ERROR;

886: ELSE
887: article_number_tbl(i) := NULL;
888: art_process_status_tbl(i) := 'U';
889: l_return_status := x_return_status;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892:
893: -- Check if the article title of this article already exists in 11.5.10
894: l_row_notfound := FALSE;

Line 931: RAISE FND_API.G_EXC_ERROR ;

927: p_msg_name => 'OKC_MIG_ERR_NO_VER',
928: p_token1 => 'ARTICLE_TITLE',
929: p_token1_value => article_title_tbl(i)
930: );
931: RAISE FND_API.G_EXC_ERROR ;
932: ELSE
933: ver_language_tbl(i) := l_language;
934: article_id_tbl(i) := -99; -- new article ..ids will be generated later
935: END IF;

Line 950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

946: x_object_id => article_id_tbl(i));
947:
948: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
949: art_process_status_tbl(i) := 'U';
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
951: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
952: l_return_status := x_return_status;
953: art_process_status_tbl(i) := 'E';
954: RAISE FND_API.G_EXC_ERROR ;

Line 954: RAISE FND_API.G_EXC_ERROR ;

950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
951: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
952: l_return_status := x_return_status;
953: art_process_status_tbl(i) := 'E';
954: RAISE FND_API.G_EXC_ERROR ;
955: END IF;
956: -- Message article versions data
957:
958: FOR j in start_date_tbl.FIRST .. start_date_tbl.LAST LOOP

Line 976: RAISE FND_API.G_EXC_ERROR ;

972: p_token1_value => article_title_tbl(i),
973: p_token2 => 'ARTICLE_VERSION',
974: p_token2_value => artv_sav_release_tbl(j)
975: );
976: RAISE FND_API.G_EXC_ERROR ;
977: END IF;
978: **/
979:
980: -- Generate article version id only for all article versions

Line 987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

983: x_object_id => article_version_id_tbl(j));
984: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
985: ver_process_status_tbl(j) := 'U';
986: art_process_status_tbl(i) := 'U';
987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
988: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
989: l_return_status := x_return_status;
990: ver_process_status_tbl(j) := 'E';
991: art_process_status_tbl(i) := 'E';

Line 992: RAISE FND_API.G_EXC_ERROR ;

988: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
989: l_return_status := x_return_status;
990: ver_process_status_tbl(j) := 'E';
991: art_process_status_tbl(i) := 'E';
992: RAISE FND_API.G_EXC_ERROR ;
993: END IF;
994:
995:
996: EXCEPTION

Line 997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

993: END IF;
994:
995:
996: EXCEPTION
997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
998: IF (l_debug = 'Y') THEN
999: okc_debug.Log('400: Leaving version processing loop due to OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1000: END IF;
1001: --

Line 1022: WHEN FND_API.G_EXC_ERROR THEN

1018: l_return_status := G_RET_STS_UNEXP_ERROR ;
1019: x_return_status := G_RET_STS_UNEXP_ERROR ;
1020: exit; -- exit this loop
1021:
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: IF (l_debug = 'Y') THEN
1024: okc_debug.Log('400: Error in this version: OKC_API.G_EXC_ERROR Exception', 2);
1025: END IF;
1026: --

Line 1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1059: -------------------------------------------------------------------------
1060: -- initialize l_return_status to track status of DML execution
1061: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1062: art_process_status_tbl(i) := 'U';
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1064: exit;
1065: END IF;
1066:
1067: -- For successful rows push to a larger collection for eventual bulk insert of versions

Line 1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1107: x_return_status := G_RET_STS_ERROR ;
1108: RAISE G_EXC_PREREQ_SETUP_ERROR;
1109: exit;-- exit this loop
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: IF (l_debug = 'Y') THEN
1113: okc_debug.Log('400: Leaving loop for individual article processing loop due to OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1114: END IF;
1115: --

Line 1135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1131: CLOSE l_unq_csr;
1132: END IF;
1133: l_return_status := G_RET_STS_UNEXP_ERROR ;
1134: x_return_status := G_RET_STS_UNEXP_ERROR ;
1135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1136: exit; -- exit this loop
1137:
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: IF (l_debug = 'Y') THEN

Line 1138: WHEN FND_API.G_EXC_ERROR THEN

1134: x_return_status := G_RET_STS_UNEXP_ERROR ;
1135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1136: exit; -- exit this loop
1137:
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: IF (l_debug = 'Y') THEN
1140: okc_debug.Log('400: Leaving Articles_Migration: OKC_API.G_EXC_ERROR Exception', 2);
1141: END IF;
1142: --

Line 1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1167: END IF;
1168:
1169: l_return_status := G_RET_STS_UNEXP_ERROR ;
1170: x_return_status := G_RET_STS_UNEXP_ERROR ;
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1172: exit; -- exit this loop
1173: END;
1174: END LOOP; -- end of FOR i in article_id_tbl.FIRST ..line 880 approx
1175:

Line 1287: RAISE FND_API.G_EXC_ERROR;

1283: p_token1_value => g_context);
1284: l_return_status := G_RET_STS_ERROR;
1285: x_return_status := G_RET_STS_ERROR;
1286: ROLLBACK TO SAVEPOINT bulkdml;
1287: RAISE FND_API.G_EXC_ERROR;
1288: END;
1289:
1290: --
1291: -- End of Insert into OKC_ARTICLES_ALL

Line 1442: RAISE FND_API.G_EXC_ERROR;

1438: p_token1_value => g_context);
1439: l_return_status := G_RET_STS_ERROR;
1440: x_return_status := G_RET_STS_ERROR;
1441: ROLLBACK TO SAVEPOINT bulkdml;
1442: RAISE FND_API.G_EXC_ERROR;
1443: END;
1444:
1445: --
1446: -- End of Insert into OKC_ARTICLE_VERSIONS

Line 1509: RAISE FND_API.G_EXC_ERROR;

1505: p_token1_value => g_context);
1506: l_return_status := G_RET_STS_ERROR;
1507: x_return_status := G_RET_STS_ERROR;
1508: ROLLBACK TO SAVEPOINT bulkdml;
1509: RAISE FND_API.G_EXC_ERROR;
1510: END;
1511:
1512: BEGIN
1513: G_context := 'ARL2';

Line 1571: RAISE FND_API.G_EXC_ERROR;

1567: p_token1_value => g_context);
1568: l_return_status := G_RET_STS_ERROR;
1569: x_return_status := G_RET_STS_ERROR;
1570: ROLLBACK TO SAVEPOINT bulkdml;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END;
1573:
1574: BEGIN
1575: G_context := 'ARL3';

Line 1633: RAISE FND_API.G_EXC_ERROR;

1629: p_token1_value => g_context);
1630: l_return_status := G_RET_STS_ERROR;
1631: x_return_status := G_RET_STS_ERROR;
1632: ROLLBACK TO SAVEPOINT bulkdml;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END;
1635:
1636: BEGIN
1637: G_context := 'ARL4';

Line 1695: RAISE FND_API.G_EXC_ERROR;

1691: p_token1_value => g_context);
1692: l_return_status := G_RET_STS_ERROR;
1693: x_return_status := G_RET_STS_ERROR;
1694: ROLLBACK TO SAVEPOINT bulkdml;
1695: RAISE FND_API.G_EXC_ERROR;
1696: END;
1697:
1698: BEGIN
1699: G_context := 'ADP';

Line 1755: RAISE FND_API.G_EXC_ERROR;

1751: p_token1_value => g_context);
1752: l_return_status := G_RET_STS_ERROR;
1753: x_return_status := G_RET_STS_ERROR;
1754: ROLLBACK TO SAVEPOINT bulkdml;
1755: RAISE FND_API.G_EXC_ERROR;
1756: END;
1757:
1758: -- Update contract articles with newly generated ids.
1759: -- Newly Generated Ids has been moved to column Old_id of OKC_K_ARTICLES_B

Line 1793: RAISE FND_API.G_EXC_ERROR;

1789:
1790: l_return_status := G_RET_STS_ERROR;
1791: x_return_status := G_RET_STS_ERROR;
1792: ROLLBACK TO SAVEPOINT bulkdml;
1793: RAISE FND_API.G_EXC_ERROR;
1794: END;
1795:
1796: -- Update contract articles history with newly generated ids.
1797: -- Newly Generated Ids has been moved to column Old_id of OKC_K_ARTICLES_BH

Line 1835: RAISE FND_API.G_EXC_ERROR;

1831:
1832: l_return_status := G_RET_STS_ERROR;
1833: x_return_status := G_RET_STS_ERROR;
1834: ROLLBACK TO SAVEPOINT bulkdml;
1835: RAISE FND_API.G_EXC_ERROR;
1836: END;
1837:
1838: BEGIN
1839: FORALL i in article_id_tbl.FIRST ..article_id_tbl.LAST

Line 1889: RAISE FND_API.G_EXC_ERROR;

1885:
1886: l_return_status := G_RET_STS_ERROR;
1887: x_return_status := G_RET_STS_ERROR;
1888: ROLLBACK TO SAVEPOINT bulkdml;
1889: RAISE FND_API.G_EXC_ERROR;
1890: END;
1891:
1892: ---------------------------------------------------------------------
1893: /* Migrate Attachments, Attachments exist at the version level

Line 1942: RAISE FND_API.G_EXC_ERROR;

1938: p_token1_value => g_context);
1939: l_return_status := G_RET_STS_ERROR;
1940: x_return_status := G_RET_STS_ERROR;
1941: ROLLBACK TO SAVEPOINT bulkdml;
1942: RAISE FND_API.G_EXC_ERROR;
1943: END;
1944:
1945:
1946: /*

Line 1993: WHEN FND_API.G_EXC_ERROR THEN

1989:
1990: EXIT WHEN l_orig_article_csr%NOTFOUND;
1991: EXCEPTION -- from line 871 approx
1992:
1993: WHEN FND_API.G_EXC_ERROR THEN
1994: IF (l_debug = 'Y') THEN
1995: okc_debug.Log('300: Error occurred in this fetch... Moving on to next fetch: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1996: END IF;
1997: l_return_status := G_RET_STS_ERROR ;

Line 2039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2035: get_print_msgs_stack;
2036: exit;-- exit this loop
2037:
2038:
2039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2040: IF (l_debug = 'Y') THEN
2041: okc_debug.Log('400: Leaving Fetch Loop: No more processing: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2042: END IF;
2043:

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

2094:
2095: IF not l_migrated THEN
2096: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2097: p_msg_name => 'OKC_ART_MIG_OUTPUT_NO_ART');
2098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
2099: ELSE
2100: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2101: p_msg_name => 'OKC_ART_MIG_OUTPUT');
2102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));

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

2098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
2099: ELSE
2100: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2101: p_msg_name => 'OKC_ART_MIG_OUTPUT');
2102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
2103: FOR i in l_org_name_tbl.FIRST..l_org_name_tbl.LAST LOOP
2104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_org_name_tbl(i));
2105: END LOOP;
2106: END IF;

Line 2119: WHEN FND_API.G_EXC_ERROR THEN

2115: x_return_status := l_return_status;
2116:
2117: EXCEPTION
2118:
2119: WHEN FND_API.G_EXC_ERROR THEN
2120: IF (l_debug = 'Y') THEN
2121: okc_debug.Log('300: Leaving Articles_Migrate: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2122: END IF;
2123: get_print_msgs_stack;

Line 2126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2122: END IF;
2123: get_print_msgs_stack;
2124: x_return_status := G_RET_STS_ERROR ;
2125:
2126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2127: IF (l_debug = 'Y') THEN
2128: okc_debug.Log('400: Leaving Articles_Migrate: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2129: END IF;
2130: