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_MI_GRP dependencies on ICX_CAT_UTIL_PVT

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

52: ', p_organization_id:' || p_organization_id ||
53: ', p_organization_code:' || p_organization_code ||
54: ', p_master_org_flag:' || p_master_org_flag ||
55: ', p_item_description:' || p_item_description ;
56: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
57: END IF;
58:
59: l_err_loc := 400;
60: -- Standard call to check for call compatibility.

Line 71: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: l_err_loc := 600;
71: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
72:
73: /* START OF TO BE REMOVED */
74: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
75: l_err_loc := 650;

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

80: AND mi.organization_id = p_organization_id;
81:
82: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
83: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
84: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
85: 'Num. of rows from mi for the given inventory_item_id and organization_id:' ||
86: l_tmp_count);
87: END IF;
88:

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

94: AND mtl.language = mtl.source_lang;
95:
96: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
98: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
99: 'Num. of rows from mtl for the given inventory_item_id and organization_id:' ||
100: l_tmp_count);
101: END IF;
102:

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

108: AND mic.category_set_id = 2;
109:
110: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
112: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
113: 'Num. of rows from mic for the given inventory_item_id and organization_id:' ||
114: l_tmp_count);
115: END IF;
116: END IF;

Line 120: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const

116: END IF;
117: /* END OF TO BE REMOVED */
118:
119: l_err_loc := 700;
120: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
121: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;
122:
123: --populateItemChange will always join with mtl_parameters to figure out
124: --the child orgs, If we do it otherwise, then we have to open the

Line 121: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;

117: /* END OF TO BE REMOVED */
118:
119: l_err_loc := 700;
120: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
121: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;
122:
123: --populateItemChange will always join with mtl_parameters to figure out
124: --the child orgs, If we do it otherwise, then we have to open the
125: --populateItemChange cursor many times for each child org

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

142: -- Call the rebuild index
143: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
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: 'Rebuild indexes called.');
148: END IF;
149: ELSE
150: l_err_loc := 1300;

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

149: ELSE
150: l_err_loc := 1300;
151: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
153: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
154: 'p_commit is false, so Rebuild indexes is not called in.');
155: END IF;
156: END IF;
157: l_err_loc := 1400;

Line 161: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

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

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

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

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

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

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

216: ', p_api_version:' || p_api_version ||
217: ', p_commit:' || p_commit ||
218: ', p_request_id:' || p_request_id ||
219: ', p_entity_type:' || p_entity_type;
220: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
221: END IF;
222:
223: l_err_loc := 400;
224: -- Standard call to check for call compatibility.

Line 235: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: l_err_loc := 600;
235: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
236:
237: l_err_loc := 650;
238: -- Log the values from mtl_bulkload_item_recs:
239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 240: ICX_CAT_UTIL_PVT.logMtlItemBulkloadRecsData(p_request_id);

236:
237: l_err_loc := 650;
238: -- Log the values from mtl_bulkload_item_recs:
239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: ICX_CAT_UTIL_PVT.logMtlItemBulkloadRecsData(p_request_id);
241: END IF;
242:
243: l_err_loc := 700;
244: IF (P_ENTITY_TYPE = 'ITEM') THEN

Line 246: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const

242:
243: l_err_loc := 700;
244: IF (P_ENTITY_TYPE = 'ITEM') THEN
245: l_err_loc := 800;
246: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
247: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;
248:
249: l_err_loc := 850;
250: ICX_CAT_POPULATE_MI_PVT.populateItemChange(NULL, NULL, P_REQUEST_ID, P_ENTITY_TYPE);

Line 247: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;

243: l_err_loc := 700;
244: IF (P_ENTITY_TYPE = 'ITEM') THEN
245: l_err_loc := 800;
246: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
247: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;
248:
249: l_err_loc := 850;
250: ICX_CAT_POPULATE_MI_PVT.populateItemChange(NULL, NULL, P_REQUEST_ID, P_ENTITY_TYPE);
251: ELSIF (P_ENTITY_TYPE = 'ITEM_CATEGORY') THEN

Line 253: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const

249: l_err_loc := 850;
250: ICX_CAT_POPULATE_MI_PVT.populateItemChange(NULL, NULL, P_REQUEST_ID, P_ENTITY_TYPE);
251: ELSIF (P_ENTITY_TYPE = 'ITEM_CATEGORY') THEN
252: l_err_loc := 900;
253: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
254: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
255:
256: l_err_loc := 950;
257: ICX_CAT_POPULATE_MI_PVT.populateItemCatgChange(NULL, NULL, NULL, P_REQUEST_ID, P_ENTITY_TYPE);

Line 254: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;

250: ICX_CAT_POPULATE_MI_PVT.populateItemChange(NULL, NULL, P_REQUEST_ID, P_ENTITY_TYPE);
251: ELSIF (P_ENTITY_TYPE = 'ITEM_CATEGORY') THEN
252: l_err_loc := 900;
253: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
254: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
255:
256: l_err_loc := 950;
257: ICX_CAT_POPULATE_MI_PVT.populateItemCatgChange(NULL, NULL, NULL, P_REQUEST_ID, P_ENTITY_TYPE);
258: ELSE

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

258: ELSE
259: l_err_loc := 1000;
260: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
262: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
263: 'Invalid entity_type:' || P_ENTITY_TYPE);
264: END IF;
265: END IF;
266:

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

273: -- Call the rebuild index
274: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
275: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
277: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
278: 'Rebuild indexes called.');
279: END IF;
280: ELSE
281: l_err_loc := 1400;

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

280: ELSE
281: l_err_loc := 1400;
282: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
283: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
284: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
285: 'p_commit is false, so Rebuild indexes is not called.');
286: END IF;
287: END IF;
288:

Line 292: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

288:
289: l_err_loc := 1500;
290: l_end_date := sysdate;
291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
293: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
294: END IF;
295: EXCEPTION
296: WHEN OTHERS THEN

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

289: l_err_loc := 1500;
290: l_end_date := sysdate;
291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
293: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
294: END IF;
295: EXCEPTION
296: WHEN OTHERS THEN
297: BEGIN

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

299: EXCEPTION
300: WHEN OTHERS THEN
301: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
303: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
304: 'ROLLBACK TO the savepoint caused the exception -->'
305: || SQLERRM);
306: END IF;
307: NULL;

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

355: ', p_organization_id:' || p_organization_id ||
356: ', p_master_org_flag:' || p_master_org_flag ||
357: ', p_category_set_id:' || p_category_set_id ||
358: ', p_category_id:' || p_category_id;
359: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
360: END IF;
361:
362: l_err_loc := 400;
363: -- Standard call to check for call compatibility.

Line 375: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

371: END IF;
372:
373: l_err_loc := 600;
374: --Initialize the purchasing category set info.
375: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
376:
377: l_err_loc := 700;
378: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID) THEN
379: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 378: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID) THEN

374: --Initialize the purchasing category set info.
375: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
376:
377: l_err_loc := 700;
378: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID) THEN
379: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.string(FND_LOG.LEVEL_EVENT,
381: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
382: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id );

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

377: l_err_loc := 700;
378: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID) THEN
379: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.string(FND_LOG.LEVEL_EVENT,
381: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
382: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id );
383: END IF;
384: RETURN;
385: END IF;

Line 382: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id );

378: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID) THEN
379: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.string(FND_LOG.LEVEL_EVENT,
381: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
382: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id );
383: END IF;
384: RETURN;
385: END IF;
386:

Line 388: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

384: RETURN;
385: END IF;
386:
387: l_err_loc := 800;
388: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
389:
390: l_err_loc := 900;
391: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
392: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;

Line 391: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const

387: l_err_loc := 800;
388: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
389:
390: l_err_loc := 900;
391: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
392: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
393:
394: IF (P_DML_TYPE = 'DELETE') THEN
395: l_err_loc := 1000;

Line 392: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;

388: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
389:
390: l_err_loc := 900;
391: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
392: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
393:
394: IF (P_DML_TYPE = 'DELETE') THEN
395: l_err_loc := 1000;
396: ICX_CAT_POPULATE_MI_PVT.populateItemCatgDelete(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);

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

408: -- Call the rebuild index
409: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
410: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
411: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
412: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
413: 'Rebuild indexes called.');
414: END IF;
415: ELSE
416: l_err_loc := 1500;

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

415: ELSE
416: l_err_loc := 1500;
417: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
419: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
420: 'p_commit is false, so Rebuild indexes is not called.');
421: END IF;
422: END IF;
423:

Line 427: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

423:
424: l_err_loc := 1600;
425: l_end_date := sysdate;
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
428: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
429: END IF;
430: EXCEPTION
431: WHEN OTHERS THEN

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

424: l_err_loc := 1600;
425: l_end_date := sysdate;
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
428: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
429: END IF;
430: EXCEPTION
431: WHEN OTHERS THEN
432: BEGIN

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

434: EXCEPTION
435: WHEN OTHERS THEN
436: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
437: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
438: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
439: 'ROLLBACK TO the savepoint caused the exception -->'
440: || SQLERRM);
441: END IF;
442: NULL;