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.ICX_CAT_POPULATE_ITEM_GRP dependencies on ICX_CAT_UTIL_PVT

Line 37: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

33: ', p_api_version:' || p_api_version ||
34: ', p_commit:' || p_commit ||
35: ', p_vendor_id:' || p_vendor_id ||
36: ', p_vendor_name:' || p_vendor_name ;
37: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
38: END IF;
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 49: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

45: THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
50:
51: ICX_CAT_POPULATE_ITEM_PVT.populateVendorNameChanges(p_vendor_id, p_vendor_name);
52:
53: -- Standard check of P_COMMIT

Line 58: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

54: IF (FND_API.To_Boolean(P_COMMIT)) THEN
55: COMMIT;
56: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
57: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
58: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
59: 'Commit done.');
60: END IF;
61: ELSE
62: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 64: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

60: END IF;
61: ELSE
62: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
63: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
64: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
65: 'Commit not done.');
66: END IF;
67: END IF;
68:

Line 71: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

67: END IF;
68:
69: l_end_date := sysdate;
70: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
72: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
73: END IF;
74: EXCEPTION
75: WHEN OTHERS THEN

Line 72: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

68:
69: l_end_date := sysdate;
70: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
72: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
73: END IF;
74: EXCEPTION
75: WHEN OTHERS THEN
76: BEGIN

Line 82: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
82: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
83: 'ROLLBACK TO the savepoint caused the exception -->'
84: || SQLERRM);
85: END IF;
86: NULL;

Line 125: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

121: ', p_from_vendor_id:' || p_from_vendor_id ||
122: ', p_from_site_id:' || p_from_site_id ||
123: ', p_to_vendor_id:' || p_to_vendor_id ||
124: ', p_to_site_id:' || p_to_site_id ;
125: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
126: END IF;
127:
128: -- Standard call to check for call compatibility.
129: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 137: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

133: THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
138:
139: ICX_CAT_POPULATE_ITEM_PVT.populateVendorMerge(p_from_vendor_id, p_from_site_id, p_to_vendor_id, p_to_site_id);
140:
141: -- Standard check of P_COMMIT

Line 146: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

142: IF (FND_API.To_Boolean(P_COMMIT)) THEN
143: COMMIT;
144: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
146: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
147: 'Commit done.');
148: END IF;
149: ELSE
150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 152: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

148: END IF;
149: ELSE
150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
152: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
153: 'Commit not done.');
154: END IF;
155: END IF;
156:

Line 159: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

155: END IF;
156:
157: l_end_date := sysdate;
158: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
160: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
161: END IF;
162: EXCEPTION
163: WHEN OTHERS THEN

Line 160: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

156:
157: l_end_date := sysdate;
158: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
160: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
161: END IF;
162: EXCEPTION
163: WHEN OTHERS THEN
164: BEGIN

Line 170: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

166: EXCEPTION
167: WHEN OTHERS THEN
168: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
170: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
171: 'ROLLBACK TO the savepoint caused the exception -->'
172: || SQLERRM);
173: END IF;
174: NULL;

Line 205: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
202: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
203: ', p_api_version:' || p_api_version ||
204: ', p_commit:' || p_commit ;
205: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
206: END IF;
207:
208: l_err_loc := 300;
209: -- Standard call to check for call compatibility.

Line 222: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

218:
219: l_err_loc := 500;
220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
222: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
223: ' About to call rebuild_index');
224: END IF;
225:
226: l_err_loc := 600;

Line 232: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

228:
229: l_err_loc := 700;
230: l_end_date := sysdate;
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
233: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
234: END IF;
235:
236: EXCEPTION

Line 233: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

229: l_err_loc := 700;
230: l_end_date := sysdate;
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
233: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
234: END IF;
235:
236: EXCEPTION
237: WHEN OTHERS THEN

Line 238: ICX_CAT_UTIL_PVT.logUnexpectedException(

234: END IF;
235:
236: EXCEPTION
237: WHEN OTHERS THEN
238: ICX_CAT_UTIL_PVT.logUnexpectedException(
239: G_PKG_NAME, l_api_name,
240: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: END rebuildIPIntermediaIndex;