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_MSG_PUB

Line 58: FND_MSG_PUB.Count_And_Get( p_count => l_count, p_encoded=> 'F', p_data => l_msg_data );

54: PROCEDURE get_print_msgs_stack IS
55: l_msg_data VARCHAR2(2000);
56: l_count NUMBER;
57: BEGIN
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 ));

Line 61: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

57: BEGIN
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);

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 69: FND_MSG_PUB.initialize;

65: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
66: END IF;
67:
68: --recycle it
69: FND_MSG_PUB.initialize;
70:
71: END get_print_msgs_stack;
72:
73: /*===================================================

Line 142: IF FND_MSG_PUB.Count_Msg > 0 Then

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

Line 143: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

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

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

Line 156: IF FND_MSG_PUB.Count_Msg > 0 Then

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

Line 157: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

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 161: FND_MSG_PUB.initialize;

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
163: okc_debug.Log('4000: Leaving ',2);
164: okc_debug.Reset_Indentation;
165: END IF;

Line 170: IF FND_MSG_PUB.Count_Msg > 0 Then

166: WHEN OTHERS THEN
167: retcode := 2;
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;

Line 171: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

167: retcode := 2;
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;

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 175: FND_MSG_PUB.initialize;

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
177: okc_debug.Log('5000: Leaving ',2);
178: okc_debug.Reset_Indentation;
179: END IF;

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 620: FND_MSG_PUB.initialize;

616: ------------------------------------------------------------------------
617: -- Variable Initialization
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

Line 2055: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2051: CLOSE l_unq_csr;
2052: END IF;
2053: l_return_status := G_RET_STS_UNEXP_ERROR ;
2054: x_return_status := G_RET_STS_UNEXP_ERROR ;
2055: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2057: END IF;
2058: get_print_msgs_stack;
2059: exit;

Line 2056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2052: END IF;
2053: l_return_status := G_RET_STS_UNEXP_ERROR ;
2054: x_return_status := G_RET_STS_UNEXP_ERROR ;
2055: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2057: END IF;
2058: get_print_msgs_stack;
2059: exit;
2060:

Line 2077: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2073: CLOSE l_unq_csr;
2074: END IF;
2075: l_return_status := G_RET_STS_UNEXP_ERROR ;
2076: x_return_status := G_RET_STS_UNEXP_ERROR ;
2077: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2078: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2079: END IF;
2080: get_print_msgs_stack;
2081: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );

Line 2078: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2074: END IF;
2075: l_return_status := G_RET_STS_UNEXP_ERROR ;
2076: x_return_status := G_RET_STS_UNEXP_ERROR ;
2077: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2078: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2079: END IF;
2080: get_print_msgs_stack;
2081: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );
2082: exit;

Line 2081: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );

2077: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2078: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2079: END IF;
2080: get_print_msgs_stack;
2081: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );
2082: exit;
2083: END; -- line 871 approx
2084: END LOOP; -- line 870 approx
2085:

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 2108: FND_MSG_PUB.initialize;

2104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_org_name_tbl(i));
2105: END LOOP;
2106: END IF;
2107:
2108: FND_MSG_PUB.initialize;
2109: l_org_id_tbl.DELETE;
2110: l_org_name_tbl.DELETE;
2111:
2112: IF (l_debug = 'Y') THEN

Line 2135: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2131: IF l_orig_article_csr%ISOPEN THEN
2132: CLOSE l_orig_article_csr;
2133: END IF;
2134: x_return_status := G_RET_STS_UNEXP_ERROR ;
2135: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2137: END IF;
2138: get_print_msgs_stack;
2139:

Line 2136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2132: CLOSE l_orig_article_csr;
2133: END IF;
2134: x_return_status := G_RET_STS_UNEXP_ERROR ;
2135: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2137: END IF;
2138: get_print_msgs_stack;
2139:
2140: WHEN OTHERS THEN

Line 2149: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2145: IF l_orig_article_csr%ISOPEN THEN
2146: CLOSE l_orig_article_csr;
2147: END IF;
2148: x_return_status := G_RET_STS_UNEXP_ERROR ;
2149: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2151: END IF;
2152: get_print_msgs_stack;
2153: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );

Line 2150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2146: CLOSE l_orig_article_csr;
2147: END IF;
2148: x_return_status := G_RET_STS_UNEXP_ERROR ;
2149: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2151: END IF;
2152: get_print_msgs_stack;
2153: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );
2154: END migrate_articles;

Line 2153: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );

2149: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2151: END IF;
2152: get_print_msgs_stack;
2153: -- FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => G_FALSE );
2154: END migrate_articles;
2155:
2156:
2157: END OKC_ARTICLES_MIGRATE_GRP;