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

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

47: ', p_dml_type:' || p_dml_type ||
48: ', p_structure_id:' || p_structure_id ||
49: ', p_category_name:' || p_category_name ||
50: ', p_category_id:' || p_category_id;
51: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
52: END IF;
53:
54: l_err_loc := 400;
55: -- Standard call to check for call compatibility.

Line 67: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

63: END IF;
64:
65: l_err_loc := 600;
66: --Initialize the purchasing category set info.
67: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
68:
69: l_err_loc := 700;
70: IF (ICX_CAT_UTIL_PVT.g_structure_id <> P_STRUCTURE_ID OR
71: (P_DML_TYPE = 'CREATE' AND ICX_CAT_UTIL_PVT.g_validate_flag = 'Y')) THEN

Line 70: IF (ICX_CAT_UTIL_PVT.g_structure_id <> P_STRUCTURE_ID OR

66: --Initialize the purchasing category set info.
67: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
68:
69: l_err_loc := 700;
70: IF (ICX_CAT_UTIL_PVT.g_structure_id <> P_STRUCTURE_ID OR
71: (P_DML_TYPE = 'CREATE' AND ICX_CAT_UTIL_PVT.g_validate_flag = 'Y')) THEN
72: -- If ICX_CAT_UTIL_PVT.g_validate_flag is 'Y'
73: -- Then ip does not have to process the category added to mtl_categories_b
74: -- This category will be processed when it is added to the valid cats

Line 71: (P_DML_TYPE = 'CREATE' AND ICX_CAT_UTIL_PVT.g_validate_flag = 'Y')) THEN

67: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
68:
69: l_err_loc := 700;
70: IF (ICX_CAT_UTIL_PVT.g_structure_id <> P_STRUCTURE_ID OR
71: (P_DML_TYPE = 'CREATE' AND ICX_CAT_UTIL_PVT.g_validate_flag = 'Y')) THEN
72: -- If ICX_CAT_UTIL_PVT.g_validate_flag is 'Y'
73: -- Then ip does not have to process the category added to mtl_categories_b
74: -- This category will be processed when it is added to the valid cats
75: -- in the call to populateValidCategorySetInsert

Line 72: -- If ICX_CAT_UTIL_PVT.g_validate_flag is 'Y'

68:
69: l_err_loc := 700;
70: IF (ICX_CAT_UTIL_PVT.g_structure_id <> P_STRUCTURE_ID OR
71: (P_DML_TYPE = 'CREATE' AND ICX_CAT_UTIL_PVT.g_validate_flag = 'Y')) THEN
72: -- If ICX_CAT_UTIL_PVT.g_validate_flag is 'Y'
73: -- Then ip does not have to process the category added to mtl_categories_b
74: -- This category will be processed when it is added to the valid cats
75: -- in the call to populateValidCategorySetInsert
76: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

74: -- This category will be processed when it is added to the valid cats
75: -- in the call to populateValidCategorySetInsert
76: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.string(FND_LOG.LEVEL_EVENT,
78: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
79: 'returning; g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
80: ', P_DML_TYPE:' || P_DML_TYPE ||
81: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
82: END IF;

Line 79: 'returning; g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||

75: -- in the call to populateValidCategorySetInsert
76: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.string(FND_LOG.LEVEL_EVENT,
78: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
79: 'returning; g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
80: ', P_DML_TYPE:' || P_DML_TYPE ||
81: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
82: END IF;
83: RETURN;

Line 81: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

77: FND_LOG.string(FND_LOG.LEVEL_EVENT,
78: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
79: 'returning; g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
80: ', P_DML_TYPE:' || P_DML_TYPE ||
81: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
82: END IF;
83: RETURN;
84: END IF;
85:

Line 88: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

84: END IF;
85:
86:
87: l_err_loc := 800;
88: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
89: l_err_loc := 900;
90: ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := P_DML_TYPE;
91:
92: l_err_loc := 1000;

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

101: -- Call the rebuild index
102: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
103: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
105: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
106: 'Rebuild indexes called.');
107: END IF;
108: ELSE
109: l_err_loc := 1400;

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

108: ELSE
109: l_err_loc := 1400;
110: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
112: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
113: 'p_commit is false, so Rebuild indexes is not called.');
114: END IF;
115: END IF;
116:

Line 120: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

116:
117: l_err_loc := 1500;
118: l_end_date := sysdate;
119: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
120: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
121: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
122: END IF;
123: EXCEPTION
124: WHEN OTHERS THEN

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

117: l_err_loc := 1500;
118: l_end_date := sysdate;
119: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
120: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
121: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
122: END IF;
123: EXCEPTION
124: WHEN OTHERS THEN
125: BEGIN

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

127: EXCEPTION
128: WHEN OTHERS THEN
129: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
130: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
131: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
132: 'ROLLBACK TO the savepoint caused the exception -->'
133: || SQLERRM);
134: END IF;
135: NULL;

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

173: ', p_api_version:' || p_api_version ||
174: ', p_commit:' || p_commit ||
175: ', p_category_set_id:' || p_category_set_id ||
176: ', p_category_id:' || p_category_id;
177: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
178: END IF;
179:
180: l_err_loc := 400;
181: -- Standard call to check for call compatibility.

Line 193: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

189: END IF;
190:
191: l_err_loc := 600;
192: --Initialize the purchasing category set info.
193: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
194:
195: l_err_loc := 700;
196: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN

Line 196: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR

192: --Initialize the purchasing category set info.
193: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
194:
195: l_err_loc := 700;
196: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
198: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_EVENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN

193: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
194:
195: l_err_loc := 700;
196: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
198: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_EVENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

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

196: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
198: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_EVENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
202: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
203: END IF;
204: RETURN;

Line 201: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
198: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_EVENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
202: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
203: END IF;
204: RETURN;
205: END IF;

Line 202: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

198: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_EVENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
202: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
203: END IF;
204: RETURN;
205: END IF;
206:

Line 208: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

204: RETURN;
205: END IF;
206:
207: l_err_loc := 800;
208: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
209: l_err_loc := 900;
210: ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_INSERT_TYPE;
211:
212: l_err_loc := 1000;

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

221: -- Call the rebuild index
222: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
223: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
225: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
226: 'Rebuild indexes called.');
227: END IF;
228: ELSE
229: l_err_loc := 1400;

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

228: ELSE
229: l_err_loc := 1400;
230: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
232: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
233: 'p_commit is false, so Rebuild indexes is not called.');
234: END IF;
235: END IF;
236:

Line 240: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

236:
237: l_err_loc := 1500;
238: l_end_date := sysdate;
239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
241: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
242: END IF;
243: EXCEPTION
244: WHEN OTHERS THEN

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

237: l_err_loc := 1500;
238: l_end_date := sysdate;
239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
241: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
242: END IF;
243: EXCEPTION
244: WHEN OTHERS THEN
245: BEGIN

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

247: EXCEPTION
248: WHEN OTHERS THEN
249: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
251: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
252: 'ROLLBACK TO the savepoint caused the exception -->'
253: || SQLERRM);
254: END IF;
255: NULL;

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

295: ', p_commit:' || p_commit ||
296: ', p_category_set_id:' || p_category_set_id ||
297: ', p_old_category_id:' || p_old_category_id ||
298: ', p_new_category_id:' || p_new_category_id ;
299: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
300: END IF;
301:
302: l_err_loc := 400;
303: -- Standard call to check for call compatibility.

Line 315: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

311: END IF;
312:
313: l_err_loc := 600;
314: --Initialize the purchasing category set info.
315: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
316:
317: l_err_loc := 700;
318: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN

Line 318: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR

314: --Initialize the purchasing category set info.
315: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
316:
317: l_err_loc := 700;
318: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
320: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_EVENT,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN

315: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
316:
317: l_err_loc := 700;
318: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
320: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_EVENT,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
323: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

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

318: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
320: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_EVENT,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
323: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
324: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
325: END IF;
326: RETURN;

Line 323: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
320: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_EVENT,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
323: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
324: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
325: END IF;
326: RETURN;
327: END IF;

Line 324: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

320: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_EVENT,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
323: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
324: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
325: END IF;
326: RETURN;
327: END IF;
328:

Line 330: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

326: RETURN;
327: END IF;
328:
329: l_err_loc := 800;
330: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
331: l_err_loc := 900;
332: ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_UPDATE_TYPE;
333:
334: l_err_loc := 1000;

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

343: -- Call the rebuild index
344: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
348: 'Rebuild indexes called.');
349: END IF;
350: ELSE
351: l_err_loc := 1400;

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

350: ELSE
351: l_err_loc := 1400;
352: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
354: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
355: 'p_commit is false, so Rebuild indexes is not called.');
356: END IF;
357: END IF;
358:

Line 362: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

358:
359: l_err_loc := 1500;
360: l_end_date := sysdate;
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
363: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
364: END IF;
365: EXCEPTION
366: WHEN OTHERS THEN

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

359: l_err_loc := 1500;
360: l_end_date := sysdate;
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
363: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
364: END IF;
365: EXCEPTION
366: WHEN OTHERS THEN
367: BEGIN

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

369: EXCEPTION
370: WHEN OTHERS THEN
371: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
373: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
374: 'ROLLBACK TO the savepoint caused the exception -->'
375: || SQLERRM);
376: END IF;
377: NULL;

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

415: ', p_api_version:' || p_api_version ||
416: ', p_commit:' || p_commit ||
417: ', p_category_set_id:' || p_category_set_id ||
418: ', p_category_id:' || p_category_id;
419: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
420: END IF;
421:
422: l_err_loc := 400;
423: -- Standard call to check for call compatibility.

Line 435: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

431: END IF;
432:
433: l_err_loc := 600;
434: --Initialize the purchasing category set info.
435: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
436:
437: l_err_loc := 700;
438: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN

Line 438: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR

434: --Initialize the purchasing category set info.
435: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
436:
437: l_err_loc := 700;
438: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
440: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.string(FND_LOG.LEVEL_EVENT,
442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN

435: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
436:
437: l_err_loc := 700;
438: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
440: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.string(FND_LOG.LEVEL_EVENT,
442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
443: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

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

438: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
440: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.string(FND_LOG.LEVEL_EVENT,
442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
443: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
444: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
445: END IF;
446: RETURN;

Line 443: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
440: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.string(FND_LOG.LEVEL_EVENT,
442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
443: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
444: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
445: END IF;
446: RETURN;
447: END IF;

Line 444: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

440: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.string(FND_LOG.LEVEL_EVENT,
442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
443: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
444: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
445: END IF;
446: RETURN;
447: END IF;
448:

Line 450: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);

446: RETURN;
447: END IF;
448:
449: l_err_loc := 800;
450: ICX_CAT_UTIL_PVT.setCommitParameter(P_COMMIT);
451:
452: l_err_loc := 900;
453: ICX_CAT_POPULATE_CATG_PVT.g_DML_TYPE := ICX_CAT_POPULATE_CATG_PVT.g_DML_DELETE_TYPE;
454:

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

464: -- Call the rebuild index
465: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
466: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
468: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
469: 'Rebuild indexes called.');
470: END IF;
471: ELSE
472: l_err_loc := 1400;

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

471: ELSE
472: l_err_loc := 1400;
473: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
475: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
476: 'p_commit is false, so Rebuild indexes is not called.');
477: END IF;
478: END IF;
479:

Line 483: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

479:
480: l_err_loc := 1500;
481: l_end_date := sysdate;
482: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
484: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
485: END IF;
486: EXCEPTION
487: WHEN OTHERS THEN

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

480: l_err_loc := 1500;
481: l_end_date := sysdate;
482: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
484: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
485: END IF;
486: EXCEPTION
487: WHEN OTHERS THEN
488: BEGIN

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

490: EXCEPTION
491: WHEN OTHERS THEN
492: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
493: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
494: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
495: 'ROLLBACK TO the savepoint caused the exception -->'
496: || SQLERRM);
497: END IF;
498: NULL;