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_DEBUG

Line 98: okc_debug.Set_Indentation(l_proc);

94:
95: BEGIN
96:
97: IF (l_debug = 'Y') THEN
98: okc_debug.Set_Indentation(l_proc);
99: okc_debug.Log('10: Entering ',2);
100: END IF;
101:
102: --Initialize the return code

Line 99: okc_debug.Log('10: Entering ',2);

95: BEGIN
96:
97: IF (l_debug = 'Y') THEN
98: okc_debug.Set_Indentation(l_proc);
99: okc_debug.Log('10: Entering ',2);
100: END IF;
101:
102: --Initialize the return code
103: retcode := 0;

Line 133: okc_debug.Log('1000: Leaving ',2);

129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131:
132: IF (l_debug = 'Y') THEN
133: okc_debug.Log('1000: Leaving ',2);
134: okc_debug.Reset_Indentation;
135: END IF;
136: COMMIT;
137:

Line 134: okc_debug.Reset_Indentation;

130: END IF;
131:
132: IF (l_debug = 'Y') THEN
133: okc_debug.Log('1000: Leaving ',2);
134: okc_debug.Reset_Indentation;
135: END IF;
136: COMMIT;
137:
138: EXCEPTION

Line 150: okc_debug.Log('3000: Leaving ',2);

146: END IF;
147: FND_MSG_PUB.initialize;
148:
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;

Line 151: okc_debug.Reset_Indentation;

147: FND_MSG_PUB.initialize;
148:
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);

Line 163: okc_debug.Log('4000: Leaving ',2);

159: END LOOP;
160: END IF;
161: FND_MSG_PUB.initialize;
162: IF (l_debug = 'Y') THEN
163: okc_debug.Log('4000: Leaving ',2);
164: okc_debug.Reset_Indentation;
165: END IF;
166: WHEN OTHERS THEN
167: retcode := 2;

Line 164: okc_debug.Reset_Indentation;

160: END IF;
161: FND_MSG_PUB.initialize;
162: IF (l_debug = 'Y') THEN
163: okc_debug.Log('4000: Leaving ',2);
164: okc_debug.Reset_Indentation;
165: END IF;
166: WHEN OTHERS THEN
167: retcode := 2;
168: errbuf := substr(sqlerrm,1,200);

Line 177: okc_debug.Log('5000: Leaving ',2);

173: END LOOP;
174: END IF;
175: FND_MSG_PUB.initialize;
176: IF (l_debug = 'Y') THEN
177: okc_debug.Log('5000: Leaving ',2);
178: okc_debug.Reset_Indentation;
179: END IF;
180: END conc_migrate_articles;
181:

Line 178: okc_debug.Reset_Indentation;

174: END IF;
175: FND_MSG_PUB.initialize;
176: IF (l_debug = 'Y') THEN
177: okc_debug.Log('5000: Leaving ',2);
178: okc_debug.Reset_Indentation;
179: END IF;
180: END conc_migrate_articles;
181:
182: /*===================================================

Line 197: okc_debug.Log('100: Entered get_seq_id', 2);

193: CURSOR l_ver_csr IS
194: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
195: BEGIN
196: IF (l_debug = 'Y') THEN
197: okc_debug.Log('100: Entered get_seq_id', 2);
198: END IF;
199:
200: IF p_object_type = 'ART' THEN
201: OPEN l_art_csr;

Line 217: okc_debug.Log('200: Leaving get_seq_id', 2);

213: CLOSE l_ver_csr;
214: END IF;
215:
216: IF (l_debug = 'Y') THEN
217: okc_debug.Log('200: Leaving get_seq_id', 2);
218: END IF;
219: RETURN G_RET_STS_SUCCESS;
220: EXCEPTION
221: WHEN OTHERS THEN

Line 224: okc_debug.Log('300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm,2);

220: EXCEPTION
221: WHEN OTHERS THEN
222:
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,

Line 275: okc_debug.Log('100: Entered process current org only', 2);

271:
272: SAVEPOINT bulkdml;
273: -- Create Auto Adoption rows.
274: IF (l_debug = 'Y') THEN
275: okc_debug.Log('100: Entered process current org only', 2);
276: END IF;
277:
278: OPEN l_current_org_info_csr;
279: FETCH l_current_org_info_csr INTO l_org_id, l_org_name;

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 383: okc_debug.Log('500: Leaving current org processing because of EXCEPTION: '||sqlerrm, 2);

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

Line 612: okc_debug.Log('100: Entered article_migrate', 2);

608: BEGIN
609: l_debug := 'Y';
610:
611: IF (l_debug = 'Y') THEN
612: okc_debug.Log('100: Entered article_migrate', 2);
613: END IF;
614:
615:
616: ------------------------------------------------------------------------

Line 770: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);

766: AND ORG_ID = l_org_id_tbl(i));
767: EXCEPTION
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,

Line 818: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);

814: AND FLDT.LANGUAGE = LKU.LANGUAGE) ;
815: EXCEPTION
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,

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 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 1033: okc_debug.Log('500: Leaving version processing loop due to EXCEPTION: '||sqlerrm, 2);

1029: x_return_status := G_RET_STS_ERROR ;
1030:
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,

Line 1099: okc_debug.Log('400: Leaving loop for individual article processing loop : Prereq is not properly set', 2);

1095: artv_sav_release_tbl.DELETE;
1096: EXCEPTION
1097: WHEN G_EXC_PREREQ_SETUP_ERROR THEN
1098: IF (l_debug = 'Y') THEN
1099: okc_debug.Log('400: Leaving loop for individual article processing loop : Prereq is not properly set', 2);
1100: END IF;
1101: --
1102:
1103: IF l_orig_article_csr%ISOPEN THEN

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 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 1149: okc_debug.Log('500: Leaving loop for individual article processing loop due to EXCEPTION: '||sqlerrm, 2);

1145: -- exit; -- exit this loop
1146:
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,

Line 1272: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);

1268: AND id = art_system_reference_id1_tbl(i);
1269: EXCEPTION
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,

Line 1427: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);

1423:
1424: EXCEPTION
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,

Line 1494: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);

1490:
1491: EXCEPTION
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,

Line 1556: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);

1552:
1553: EXCEPTION
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,

Line 1618: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);

1614:
1615: EXCEPTION
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,

Line 1680: okc_debug.Log('500: Leaving Article Relations because of EXCEPTION: '||sqlerrm, 2);

1676:
1677: EXCEPTION
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,

Line 1740: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);

1736: AND LOCAL_ORG_ID = ORGANIZATION_ID);
1737: EXCEPTION
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,

Line 1779: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);

1775: AND ARTICLE_VERSION_ID IS NULL;
1776: EXCEPTION
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,

Line 1819: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);

1815: AND ARTICLE_VERSION_ID IS NULL;
1816: EXCEPTION
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,

Line 1873: okc_debug.Log('500: Leaving Article Versions because of EXCEPTION: '||sqlerrm, 2);

1869: AND MEMBER_ID = article_id_tbl(i));
1870: EXCEPTION
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,

Line 1927: okc_debug.Log('500: Leaving Article Version Attachments because of EXCEPTION: '||sqlerrm, 2);

1923: ART.ORIG_SYSTEM_REFERENCE_ID1 = t_ver_system_reference_id1_tbl(i));
1924: EXCEPTION
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,

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 2030: okc_debug.Log('400: Leaving Fetch Loop: No more processing: Prereq is not properly set(AUTONUMBER)', 2);

2026: display_name_tbl.DELETE;
2027:
2028: WHEN G_EXC_PREREQ_SETUP_ERROR THEN
2029: IF (l_debug = 'Y') THEN
2030: okc_debug.Log('400: Leaving Fetch Loop: No more processing: Prereq is not properly set(AUTONUMBER)', 2);
2031: END IF;
2032: --
2033: l_return_status := G_RET_STS_ERROR ;
2034: x_return_status := G_RET_STS_ERROR ;

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 2063: okc_debug.Log('500: Leaving Fetch Loop: No more processing: because of EXCEPTION: '||sqlerrm, 2);

2059: exit;
2060:
2061: WHEN OTHERS THEN
2062: IF (l_debug = 'Y') THEN
2063: okc_debug.Log('500: Leaving Fetch Loop: No more processing: because of EXCEPTION: '||sqlerrm, 2);
2064: END IF;
2065:
2066: IF l_orig_article_csr%ISOPEN THEN
2067: CLOSE l_orig_article_csr;

Line 2113: okc_debug.Log('200: Leaving articles migrate', 2);

2109: l_org_id_tbl.DELETE;
2110: l_org_name_tbl.DELETE;
2111:
2112: IF (l_debug = 'Y') THEN
2113: okc_debug.Log('200: Leaving articles migrate', 2);
2114: END IF;
2115: x_return_status := l_return_status;
2116:
2117: EXCEPTION

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;

Line 2142: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);

2138: get_print_msgs_stack;
2139:
2140: WHEN OTHERS THEN
2141: IF (l_debug = 'Y') THEN
2142: okc_debug.Log('500: Leaving Articles_Migrate because of EXCEPTION: '||sqlerrm, 2);
2143: END IF;
2144:
2145: IF l_orig_article_csr%ISOPEN THEN
2146: CLOSE l_orig_article_csr;