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 OKC_API

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

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

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

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

Line 31: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;
33: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
34: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
35: G_EXC_PREREQ_SETUP_ERROR EXCEPTION;

Line 32: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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;
33: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
34: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
35: G_EXC_PREREQ_SETUP_ERROR EXCEPTION;
36: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);

Line 86: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

82: p_fetchsize IN NUMBER
83: ) IS
84: l_api_name CONSTANT VARCHAR2(30) := 'conc_migrate_articles';
85: l_api_version CONSTANT VARCHAR2(30) := 1.0;
86: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
87: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
88: l_msg_count NUMBER;
89: l_msg_data VARCHAR2(2000);
90: l_fetchsize NUMBER := p_fetchsize;

Line 87: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

83: ) IS
84: l_api_name CONSTANT VARCHAR2(30) := 'conc_migrate_articles';
85: l_api_version CONSTANT VARCHAR2(30) := 1.0;
86: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
87: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
88: l_msg_count NUMBER;
89: l_msg_data VARCHAR2(2000);
90: l_fetchsize NUMBER := p_fetchsize;
91: --

Line 113: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

109: ELSIF p_fetchsize > G_FETCHSIZE_LIMIT THEN
110: x_return_status := G_RET_STS_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:

Line 126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

122: x_msg_data => l_msg_data,
123: p_fetchsize => l_fetchsize );
124:
125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;

Line 127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

123: p_fetchsize => l_fetchsize );
124:
125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131:

Line 128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

124:
125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131:
132: IF (l_debug = 'Y') THEN

Line 129: RAISE OKC_API.G_EXCEPTION_ERROR;

125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131:
132: IF (l_debug = 'Y') THEN
133: okc_debug.Log('1000: Leaving ',2);

Line 139: WHEN OKC_API.G_EXCEPTION_ERROR THEN

135: END IF;
136: COMMIT;
137:
138: EXCEPTION
139: WHEN OKC_API.G_EXCEPTION_ERROR THEN
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

Line 153: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

149: IF (l_debug = 'Y') THEN
150: okc_debug.Log('3000: Leaving ',2);
151: okc_debug.Reset_Indentation;
152: END IF;
153: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
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

Line 227: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

223: IF (l_debug = 'Y') THEN
224: okc_debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm,2);
225: END IF;
226:
227: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
228: p_msg_name => G_UNEXPECTED_ERROR,
229: p_token1 => G_SQLCODE_TOKEN,
230: p_token1_value => sqlcode,
231: p_token2 => G_SQLERRM_TOKEN,

Line 284: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

280: l_row_notfound := l_current_org_info_csr%NOTFOUND;
281: CLOSE l_current_org_info_csr;
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:

Line 366: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

362: WHERE REL1.source_article_id = REL.source_article_id AND
363: REL1.target_article_id = REL.target_article_id AND
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:

Line 376: okc_debug.Log('300: Error occurred in process_current_org: OKC_API.G_EXCEPTION_ERROR Exception', 2);

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;
379: x_return_status := G_RET_STS_ERROR ;
380:

Line 385: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

381: WHEN OTHERS THEN
382: IF (l_debug = 'Y') THEN
383: okc_debug.Log('500: Leaving current org processing because of EXCEPTION: '||sqlerrm, 2);
384: END IF;
385: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
386: p_msg_name => G_UNEXPECTED_ERROR,
387: p_token1 => G_SQLCODE_TOKEN,
388: p_token1_value => sqlcode,
389: p_token2 => G_SQLERRM_TOKEN,

Line 631: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

627: l_userenv_lang := USERENV('LANG');
628:
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:

Line 642: Okc_Api.Set_Message(p_app_name => G_APP_NAME,p_msg_name => 'OKC_ART_NO_BASE_LANG');

638: FETCH get_languages INTO l_language;
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

Line 652: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

648: OPEN l_missing_org_csr;
649: FETCH l_missing_org_csr BULK COLLECT INTO l_org_name_tbl;
650: CLOSE l_missing_org_csr;
651: IF l_org_name_tbl.COUNT > 0 THEN
652: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
653: p_msg_name => 'OKC_ART_INCMPLT_ORG_DEF');
654: get_print_msgs_stack;
655: FOR i in l_org_name_tbl.FIRST..l_org_name_tbl.LAST LOOP
656: FND_FILE.PUT_LINE(FND_FILE.LOG,l_org_name_tbl(i));

Line 671: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

667: FETCH l_org_info_csr BULK COLLECT INTO l_org_id_tbl, l_org_name_tbl;
668: CLOSE l_org_info_csr;
669:
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;

Line 772: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

768: WHEN OTHERS THEN
769: IF (l_debug = 'Y') THEN
770: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);
771: END IF;
772: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
773: p_msg_name => G_UNEXPECTED_ERROR,
774: p_token1 => G_SQLCODE_TOKEN,
775: p_token1_value => sqlcode,
776: p_token2 => G_SQLERRM_TOKEN,

Line 820: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

816: WHEN OTHERS THEN
817: IF (l_debug = 'Y') THEN
818: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);
819: END IF;
820: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
821: p_msg_name => G_UNEXPECTED_ERROR,
822: p_token1 => G_SQLCODE_TOKEN,
823: p_token1_value => sqlcode,
824: p_token2 => G_SQLERRM_TOKEN,

Line 875: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

871:
872: IF x_return_status = G_RET_STS_SUCCESS Then
873: IF l_article_number is NULL Then
874: art_process_status_tbl(i) :='U';
875: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
876: p_msg_name => 'OKC_ART_MIG_NO_AUTO_NUMBER');
877: RAISE G_EXC_PREREQ_SETUP_ERROR;
878: ELSE
879: article_number_tbl(i) := l_article_number;

Line 926: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

922: article_text_tbl;
923: CLOSE l_orig_ver_csr;
924: IF start_date_tbl.COUNT <= 0 THEN
925: art_process_status_tbl(i) := 'E';
926: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
927: p_msg_name => 'OKC_MIG_ERR_NO_VER',
928: p_token1 => 'ARTICLE_TITLE',
929: p_token1_value => article_title_tbl(i)
930: );

Line 969: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

965: -- Basic validation: article text being NULL
966: IF article_text_tbl(j) IS NULL Then
967: art_process_status_tbl(i) := 'E';
968: ver_process_status_tbl(j) := 'E';
969: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
970: p_msg_name => 'OKC_MIG_ERR_NO_TEXT',
971: p_token1 => 'ARTICLE_NAME',
972: p_token1_value => article_title_tbl(i),
973: p_token2 => 'ARTICLE_VERSION',

Line 999: okc_debug.Log('400: Leaving version processing loop due to OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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: --
1002: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1003: p_msg_name => G_UNEXPECTED_ERROR,

Line 1002: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

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: --
1002: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1003: p_msg_name => G_UNEXPECTED_ERROR,
1004: p_token1 => G_SQLCODE_TOKEN,
1005: p_token1_value => sqlcode,
1006: p_token2 => G_SQLERRM_TOKEN,

Line 1024: okc_debug.Log('400: Error in this version: OKC_API.G_EXC_ERROR Exception', 2);

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: --
1027:
1028: l_return_status := G_RET_STS_ERROR ;

Line 1035: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1031: WHEN OTHERS THEN
1032: IF (l_debug = 'Y') THEN
1033: okc_debug.Log('500: Leaving version processing loop due to EXCEPTION: '||sqlerrm, 2);
1034: END IF;
1035: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1036: p_msg_name => G_UNEXPECTED_ERROR,
1037: p_token1 => G_SQLCODE_TOKEN,
1038: p_token1_value => sqlcode,
1039: p_token2 => G_SQLERRM_TOKEN,

Line 1113: okc_debug.Log('400: Leaving loop for individual article processing loop due to OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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: --
1116: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1117: p_msg_name => G_UNEXPECTED_ERROR,

Line 1116: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

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: --
1116: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1117: p_msg_name => G_UNEXPECTED_ERROR,
1118: p_token1 => G_SQLCODE_TOKEN,
1119: p_token1_value => sqlcode,
1120: p_token2 => G_SQLERRM_TOKEN,

Line 1140: okc_debug.Log('400: Leaving Articles_Migration: OKC_API.G_EXC_ERROR Exception', 2);

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: --
1143: l_return_status := G_RET_STS_ERROR ;
1144: x_return_status := G_RET_STS_ERROR ;

Line 1151: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1147: WHEN OTHERS THEN
1148: IF (l_debug = 'Y') THEN
1149: okc_debug.Log('500: Leaving loop for individual article processing loop due to EXCEPTION: '||sqlerrm, 2);
1150: END IF;
1151: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1152: p_msg_name => G_UNEXPECTED_ERROR,
1153: p_token1 => G_SQLCODE_TOKEN,
1154: p_token1_value => sqlcode,
1155: p_token2 => G_SQLERRM_TOKEN,

Line 1274: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1270: WHEN OTHERS THEN
1271: IF (l_debug = 'Y') THEN
1272: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);
1273: END IF;
1274: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1275: p_msg_name => G_UNEXPECTED_ERROR,
1276: p_token1 => G_SQLCODE_TOKEN,
1277: p_token1_value => sqlcode,
1278: p_token2 => G_SQLERRM_TOKEN,

Line 1280: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1276: p_token1 => G_SQLCODE_TOKEN,
1277: p_token1_value => sqlcode,
1278: p_token2 => G_SQLERRM_TOKEN,
1279: p_token2_value => sqlerrm);
1280: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1281: p_msg_name => 'OKC_ART_FETCH_FAILED',
1282: p_token1 => 'CONTEXT',
1283: p_token1_value => g_context);
1284: l_return_status := G_RET_STS_ERROR;

Line 1429: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1425: WHEN OTHERS THEN
1426: IF (l_debug = 'Y') THEN
1427: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);
1428: END IF;
1429: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1430: p_msg_name => G_UNEXPECTED_ERROR,
1431: p_token1 => G_SQLCODE_TOKEN,
1432: p_token1_value => sqlcode,
1433: p_token2 => G_SQLERRM_TOKEN,

Line 1435: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1431: p_token1 => G_SQLCODE_TOKEN,
1432: p_token1_value => sqlcode,
1433: p_token2 => G_SQLERRM_TOKEN,
1434: p_token2_value => sqlerrm);
1435: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1436: p_msg_name => 'OKC_ART_FETCH_FAILED',
1437: p_token1 => 'CONTEXT',
1438: p_token1_value => g_context);
1439: l_return_status := G_RET_STS_ERROR;

Line 1496: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1492: WHEN OTHERS THEN
1493: IF (l_debug = 'Y') THEN
1494: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);
1495: END IF;
1496: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1497: p_msg_name => G_UNEXPECTED_ERROR,
1498: p_token1 => G_SQLCODE_TOKEN,
1499: p_token1_value => sqlcode,
1500: p_token2 => G_SQLERRM_TOKEN,

Line 1502: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1498: p_token1 => G_SQLCODE_TOKEN,
1499: p_token1_value => sqlcode,
1500: p_token2 => G_SQLERRM_TOKEN,
1501: p_token2_value => sqlerrm);
1502: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1503: p_msg_name => 'OKC_ART_FETCH_FAILED',
1504: p_token1 => 'CONTEXT',
1505: p_token1_value => g_context);
1506: l_return_status := G_RET_STS_ERROR;

Line 1558: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1554: WHEN OTHERS THEN
1555: IF (l_debug = 'Y') THEN
1556: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);
1557: END IF;
1558: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1559: p_msg_name => G_UNEXPECTED_ERROR,
1560: p_token1 => G_SQLCODE_TOKEN,
1561: p_token1_value => sqlcode,
1562: p_token2 => G_SQLERRM_TOKEN,

Line 1564: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1560: p_token1 => G_SQLCODE_TOKEN,
1561: p_token1_value => sqlcode,
1562: p_token2 => G_SQLERRM_TOKEN,
1563: p_token2_value => sqlerrm);
1564: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1565: p_msg_name => 'OKC_ART_FETCH_FAILED',
1566: p_token1 => 'CONTEXT',
1567: p_token1_value => g_context);
1568: l_return_status := G_RET_STS_ERROR;

Line 1620: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1616: WHEN OTHERS THEN
1617: IF (l_debug = 'Y') THEN
1618: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);
1619: END IF;
1620: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1621: p_msg_name => G_UNEXPECTED_ERROR,
1622: p_token1 => G_SQLCODE_TOKEN,
1623: p_token1_value => sqlcode,
1624: p_token2 => G_SQLERRM_TOKEN,

Line 1626: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1622: p_token1 => G_SQLCODE_TOKEN,
1623: p_token1_value => sqlcode,
1624: p_token2 => G_SQLERRM_TOKEN,
1625: p_token2_value => sqlerrm);
1626: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1627: p_msg_name => 'OKC_ART_FETCH_FAILED',
1628: p_token1 => 'CONTEXT',
1629: p_token1_value => g_context);
1630: l_return_status := G_RET_STS_ERROR;

Line 1682: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1678: WHEN OTHERS THEN
1679: IF (l_debug = 'Y') THEN
1680: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);
1681: END IF;
1682: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1683: p_msg_name => G_UNEXPECTED_ERROR,
1684: p_token1 => G_SQLCODE_TOKEN,
1685: p_token1_value => sqlcode,
1686: p_token2 => G_SQLERRM_TOKEN,

Line 1688: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1684: p_token1 => G_SQLCODE_TOKEN,
1685: p_token1_value => sqlcode,
1686: p_token2 => G_SQLERRM_TOKEN,
1687: p_token2_value => sqlerrm);
1688: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1689: p_msg_name => 'OKC_ART_FETCH_FAILED',
1690: p_token1 => 'CONTEXT',
1691: p_token1_value => g_context);
1692: l_return_status := G_RET_STS_ERROR;

Line 1742: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1738: WHEN OTHERS THEN
1739: IF (l_debug = 'Y') THEN
1740: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);
1741: END IF;
1742: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1743: p_msg_name => G_UNEXPECTED_ERROR,
1744: p_token1 => G_SQLCODE_TOKEN,
1745: p_token1_value => sqlcode,
1746: p_token2 => G_SQLERRM_TOKEN,

Line 1748: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1744: p_token1 => G_SQLCODE_TOKEN,
1745: p_token1_value => sqlcode,
1746: p_token2 => G_SQLERRM_TOKEN,
1747: p_token2_value => sqlerrm);
1748: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1749: p_msg_name => 'OKC_ART_FETCH_FAILED',
1750: p_token1 => 'CONTEXT',
1751: p_token1_value => g_context);
1752: l_return_status := G_RET_STS_ERROR;

Line 1781: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1777: WHEN OTHERS THEN
1778: IF (l_debug = 'Y') THEN
1779: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);
1780: END IF;
1781: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1782: p_msg_name => G_UNEXPECTED_ERROR,
1783: p_token1 => G_SQLCODE_TOKEN,
1784: p_token1_value => sqlcode,
1785: p_token2 => G_SQLERRM_TOKEN,

Line 1787: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1783: p_token1 => G_SQLCODE_TOKEN,
1784: p_token1_value => sqlcode,
1785: p_token2 => G_SQLERRM_TOKEN,
1786: p_token2_value => sqlerrm);
1787: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1788: p_msg_name => 'OKC_ART_FETCH_FAILED');
1789:
1790: l_return_status := G_RET_STS_ERROR;
1791: x_return_status := G_RET_STS_ERROR;

Line 1821: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1817: WHEN OTHERS THEN
1818: IF (l_debug = 'Y') THEN
1819: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);
1820: END IF;
1821: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1822: p_msg_name => G_UNEXPECTED_ERROR,
1823: p_token1 => G_SQLCODE_TOKEN,
1824: p_token1_value => sqlcode,
1825: p_token2 => G_SQLERRM_TOKEN,

Line 1827: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1823: p_token1 => G_SQLCODE_TOKEN,
1824: p_token1_value => sqlcode,
1825: p_token2 => G_SQLERRM_TOKEN,
1826: p_token2_value => sqlerrm);
1827: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1828: p_msg_name => 'OKC_ART_FETCH_FAILED',
1829: p_token1 => 'CONTEXT',
1830: p_token1_value => g_context);
1831:

Line 1875: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1871: WHEN OTHERS THEN
1872: IF (l_debug = 'Y') THEN
1873: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);
1874: END IF;
1875: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1876: p_msg_name => G_UNEXPECTED_ERROR,
1877: p_token1 => G_SQLCODE_TOKEN,
1878: p_token1_value => sqlcode,
1879: p_token2 => G_SQLERRM_TOKEN,

Line 1881: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1877: p_token1 => G_SQLCODE_TOKEN,
1878: p_token1_value => sqlcode,
1879: p_token2 => G_SQLERRM_TOKEN,
1880: p_token2_value => sqlerrm);
1881: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1882: p_msg_name => 'OKC_ART_FETCH_FAILED',
1883: p_token1 => 'CONTEXT',
1884: p_token1_value => g_context);
1885:

Line 1929: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1925: WHEN OTHERS THEN
1926: IF (l_debug = 'Y') THEN
1927: okc_debug.Log('500: Leaving Article Version Attachments because of EXCEPTION: '||sqlerrm, 2);
1928: END IF;
1929: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1930: p_msg_name => G_UNEXPECTED_ERROR,
1931: p_token1 => G_SQLCODE_TOKEN,
1932: p_token1_value => sqlcode,
1933: p_token2 => G_SQLERRM_TOKEN,

Line 1935: Okc_API.Set_Message(p_app_name => G_APP_NAME,

1931: p_token1 => G_SQLCODE_TOKEN,
1932: p_token1_value => sqlcode,
1933: p_token2 => G_SQLERRM_TOKEN,
1934: p_token2_value => sqlerrm);
1935: Okc_API.Set_Message(p_app_name => G_APP_NAME,
1936: p_msg_name => 'OKC_ART_FETCH_FAILED',
1937: p_token1 => 'CONTEXT',
1938: p_token1_value => g_context);
1939: l_return_status := G_RET_STS_ERROR;

Line 1995: okc_debug.Log('300: Error occurred in this fetch... Moving on to next fetch: OKC_API.G_EXCEPTION_ERROR Exception', 2);

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 ;
1998: x_return_status := G_RET_STS_ERROR ;
1999:

Line 2041: okc_debug.Log('400: Leaving Fetch Loop: No more processing: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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:
2044: IF l_orig_article_csr%ISOPEN THEN
2045: CLOSE l_orig_article_csr;

Line 2096: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2092: CLOSE l_orig_article_csr;
2093: END IF;
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,

Line 2100: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

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

Line 2121: okc_debug.Log('300: Leaving Articles_Migrate: OKC_API.G_EXCEPTION_ERROR Exception', 2);

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;
2124: x_return_status := G_RET_STS_ERROR ;
2125:

Line 2128: okc_debug.Log('400: Leaving Articles_Migrate: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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:
2131: IF l_orig_article_csr%ISOPEN THEN
2132: CLOSE l_orig_article_csr;