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

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

33: BEGIN
34: l_err_loc := 100;
35: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
36: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
37: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
38: 'Processing cursor:' || l_api_name ||
39: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
40: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
41: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||

Line 39: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

35: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
36: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
37: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
38: 'Processing cursor:' || l_api_name ||
39: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
40: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
41: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
42: ', P_ORGANIZATION_ID:' || P_ORGANIZATION_ID );
43: END IF;

Line 40: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

36: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
37: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
38: 'Processing cursor:' || l_api_name ||
39: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
40: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
41: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
42: ', P_ORGANIZATION_ID:' || P_ORGANIZATION_ID );
43: END IF;
44:

Line 79: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

75: ROWIDTOCHAR(ctx.rowid) ctx_rowid
76: FROM
77: (
78: SELECT mi.inventory_item_id inventory_item_id,
79: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
80: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
81: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
82: NVL(fsp.org_id, -2) org_id,
83: mitl.language,

Line 80: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

76: FROM
77: (
78: SELECT mi.inventory_item_id inventory_item_id,
79: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
80: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
81: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
82: NVL(fsp.org_id, -2) org_id,
83: mitl.language,
84: 'MASTER_ITEM' source_type,

Line 81: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

77: (
78: SELECT mi.inventory_item_id inventory_item_id,
79: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
80: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
81: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
82: NVL(fsp.org_id, -2) org_id,
83: mitl.language,
84: 'MASTER_ITEM' source_type,
85: NVL(fsp.org_id, -2) purchasing_org_id,

Line 114: AND mic.category_set_id (+) = ICX_CAT_UTIL_PVT.g_category_set_id

110: AND mi.organization_id = mitl.organization_id
111: AND mitl.language = mitl.source_lang
112: AND mic.inventory_item_id (+) = mi.inventory_item_id
113: AND mic.organization_id (+) = mi.organization_id
114: AND mic.category_set_id (+) = ICX_CAT_UTIL_PVT.g_category_set_id
115: AND muom.uom_code = mi.primary_uom_code
116: AND NOT (mi.replenish_to_order_flag = 'Y'
117: AND mi.base_item_id IS NOT NULL
118: AND mi.auto_created_config_flag = 'Y')

Line 137: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);

133: AND doc.language = ctx.language (+)
134: AND doc.source_type = ctx.source_type (+) ;
135:
136: l_err_loc := 500;
137: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);
138:
139: l_err_loc := 600;
140: CLOSE l_masterItem_csr;
141:

Line 145: ICX_CAT_UTIL_PVT.logUnexpectedException(

141:
142: l_err_loc := 700;
143: EXCEPTION
144: WHEN OTHERS THEN
145: ICX_CAT_UTIL_PVT.logUnexpectedException(
146: G_PKG_NAME, l_api_name,
147: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
148: RAISE;
149: END openOnlineItemCatgDeleteCursor;

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

159: BEGIN
160: l_err_loc := 100;
161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
164: 'Processing cursor:' || l_api_name ||
165: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
166: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
167: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||

Line 165: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
164: 'Processing cursor:' || l_api_name ||
165: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
166: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
167: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
168: ', P_ORGANIZATION_ID:' || P_ORGANIZATION_ID );
169: END IF;

Line 166: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
164: 'Processing cursor:' || l_api_name ||
165: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
166: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
167: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
168: ', P_ORGANIZATION_ID:' || P_ORGANIZATION_ID );
169: END IF;
170:

Line 209: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

205: ROWIDTOCHAR(ctx.rowid) ctx_rowid
206: FROM
207: (
208: SELECT mi.inventory_item_id inventory_item_id,
209: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
210: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
212: NVL(fsp.org_id, -2) org_id,
213: mitl.language,

Line 210: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

206: FROM
207: (
208: SELECT mi.inventory_item_id inventory_item_id,
209: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
210: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
212: NVL(fsp.org_id, -2) org_id,
213: mitl.language,
214: 'MASTER_ITEM' source_type,

Line 211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

207: (
208: SELECT mi.inventory_item_id inventory_item_id,
209: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
210: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
212: NVL(fsp.org_id, -2) org_id,
213: mitl.language,
214: 'MASTER_ITEM' source_type,
215: NVL(fsp.org_id, -2) purchasing_org_id,

Line 244: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

240: AND mi.organization_id = mitl.organization_id
241: AND mitl.language = mitl.source_lang
242: AND mic.inventory_item_id = mi.inventory_item_id
243: AND mic.organization_id = mi.organization_id
244: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
245: AND muom.uom_code = mi.primary_uom_code
246: AND NOT (mi.replenish_to_order_flag = 'Y'
247: AND mi.base_item_id IS NOT NULL
248: AND mi.auto_created_config_flag = 'Y')

Line 267: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);

263: AND doc.language = ctx.language (+)
264: AND doc.source_type = ctx.source_type (+) ;
265:
266: l_err_loc := 500;
267: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);
268:
269: l_err_loc := 600;
270: CLOSE l_masterItem_csr;
271:

Line 275: ICX_CAT_UTIL_PVT.logUnexpectedException(

271:
272: l_err_loc := 700;
273: EXCEPTION
274: WHEN OTHERS THEN
275: ICX_CAT_UTIL_PVT.logUnexpectedException(
276: G_PKG_NAME, l_api_name,
277: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
278: RAISE;
279: END openOnlineItemChangeCursor;

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

289: BEGIN
290: l_err_loc := 100;
291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
293: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
294: 'Processing cursor:' || l_api_name ||
295: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
296: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
297: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||

Line 295: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
293: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
294: 'Processing cursor:' || l_api_name ||
295: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
296: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
297: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
298: ', P_REQUEST_ID:' || P_REQUEST_ID ||
299: ', P_ENTITY_TYPE:' || P_ENTITY_TYPE );

Line 296: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
293: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
294: 'Processing cursor:' || l_api_name ||
295: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
296: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
297: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
298: ', P_REQUEST_ID:' || P_REQUEST_ID ||
299: ', P_ENTITY_TYPE:' || P_ENTITY_TYPE );
300: END IF;

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

314: l_err_loc := 300;
315: IF (P_ENTITY_TYPE = 'ITEM') THEN
316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
318: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
319: 'Inside if of P_ENTITY_TYPE = ITEM');
320: END IF;
321:
322: OPEN l_masterItem_csr FOR

Line 342: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

338: ROWIDTOCHAR(ctx.rowid) ctx_rowid
339: FROM
340: (
341: SELECT mi.inventory_item_id inventory_item_id,
342: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
343: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
344: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
345: NVL(fsp.org_id, -2) org_id,
346: mitl.language,

Line 343: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

339: FROM
340: (
341: SELECT mi.inventory_item_id inventory_item_id,
342: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
343: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
344: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
345: NVL(fsp.org_id, -2) org_id,
346: mitl.language,
347: 'MASTER_ITEM' source_type,

Line 344: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

340: (
341: SELECT mi.inventory_item_id inventory_item_id,
342: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
343: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
344: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
345: NVL(fsp.org_id, -2) org_id,
346: mitl.language,
347: 'MASTER_ITEM' source_type,
348: NVL(fsp.org_id, -2) purchasing_org_id,

Line 380: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

376: AND mi.organization_id = mitl.organization_id
377: AND mitl.language = mitl.source_lang
378: AND mic.inventory_item_id = mi.inventory_item_id
379: AND mic.organization_id = mi.organization_id
380: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
381: AND muom.uom_code = mi.primary_uom_code
382: AND NOT (mi.replenish_to_order_flag = 'Y'
383: AND mi.base_item_id IS NOT NULL
384: AND mi.auto_created_config_flag = 'Y')

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

412: */
413: ELSIF (P_ENTITY_TYPE = 'ITEM_CATEGORY') THEN
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
416: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
417: 'Inside else of P_ENTITY_TYPE = ITEM_CATEGORY');
418: END IF;
419: OPEN l_masterItem_csr FOR
420: SELECT * FROM (

Line 440: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

436: ROWIDTOCHAR(ctx.rowid) ctx_rowid
437: FROM
438: (
439: SELECT mi.inventory_item_id inventory_item_id,
440: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
441: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
442: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
443: NVL(fsp.org_id, -2) org_id,
444: mitl.language,

Line 441: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

437: FROM
438: (
439: SELECT mi.inventory_item_id inventory_item_id,
440: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
441: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
442: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
443: NVL(fsp.org_id, -2) org_id,
444: mitl.language,
445: 'MASTER_ITEM' source_type,

Line 442: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

438: (
439: SELECT mi.inventory_item_id inventory_item_id,
440: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
441: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
442: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
443: NVL(fsp.org_id, -2) org_id,
444: mitl.language,
445: 'MASTER_ITEM' source_type,
446: NVL(fsp.org_id, -2) purchasing_org_id,

Line 481: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

477: AND mi.organization_id = mitl.organization_id
478: AND mitl.language = mitl.source_lang
479: AND mic.inventory_item_id = mi.inventory_item_id
480: AND mic.organization_id = mi.organization_id
481: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
482: AND muom.uom_code = mi.primary_uom_code
483: AND NOT (mi.replenish_to_order_flag = 'Y'
484: AND mi.base_item_id IS NOT NULL
485: AND mi.auto_created_config_flag = 'Y')

Line 522: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

518: ROWIDTOCHAR(ctx.rowid) ctx_rowid
519: FROM
520: (
521: SELECT mi.inventory_item_id inventory_item_id,
522: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
523: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
524: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
525: NVL(fsp.org_id, -2) org_id,
526: mitl.language,

Line 523: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

519: FROM
520: (
521: SELECT mi.inventory_item_id inventory_item_id,
522: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
523: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
524: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
525: NVL(fsp.org_id, -2) org_id,
526: mitl.language,
527: 'MASTER_ITEM' source_type,

Line 524: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

520: (
521: SELECT mi.inventory_item_id inventory_item_id,
522: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
523: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
524: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
525: NVL(fsp.org_id, -2) org_id,
526: mitl.language,
527: 'MASTER_ITEM' source_type,
528: NVL(fsp.org_id, -2) purchasing_org_id,

Line 563: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

559: AND mi.organization_id = mitl.organization_id
560: AND mitl.language = mitl.source_lang
561: AND mic.inventory_item_id = mi.inventory_item_id
562: AND mic.organization_id = mi.organization_id
563: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
564: AND muom.uom_code = mi.primary_uom_code
565: AND NOT (mi.replenish_to_order_flag = 'Y'
566: AND mi.base_item_id IS NOT NULL
567: AND mi.auto_created_config_flag = 'Y')

Line 587: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);

583: AND doc.source_type = ctx.source_type (+)
584: ) doc1 ORDER by doc1.inventory_item_id;
585: END IF;
586: l_err_loc := 500;
587: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);
588:
589: l_err_loc := 600;
590: CLOSE l_masterItem_csr;
591:

Line 595: ICX_CAT_UTIL_PVT.logUnexpectedException(

591:
592: l_err_loc := 700;
593: EXCEPTION
594: WHEN OTHERS THEN
595: ICX_CAT_UTIL_PVT.logUnexpectedException(
596: G_PKG_NAME, l_api_name,
597: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
598: RAISE;
599: END openBulkItemChangeCursor;

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

609: BEGIN
610: l_err_loc := 100;
611: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
613: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
614: 'Processing cursor:' || l_api_name ||
615: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
616: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
617: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||

Line 615: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

611: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
613: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
614: 'Processing cursor:' || l_api_name ||
615: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
616: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
617: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
618: ', p_mtl_category_id:' || p_mtl_category_id );
619: END IF;

Line 616: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
613: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
614: 'Processing cursor:' || l_api_name ||
615: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
616: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
617: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
618: ', p_mtl_category_id:' || p_mtl_category_id );
619: END IF;
620:

Line 649: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

645: ROWIDTOCHAR(ctx.rowid) ctx_rowid
646: FROM
647: (
648: SELECT mi.inventory_item_id inventory_item_id,
649: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
650: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
651: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
652: NVL(fsp.org_id, -2) org_id,
653: mitl.language,

Line 650: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

646: FROM
647: (
648: SELECT mi.inventory_item_id inventory_item_id,
649: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
650: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
651: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
652: NVL(fsp.org_id, -2) org_id,
653: mitl.language,
654: 'MASTER_ITEM' source_type,

Line 651: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

647: (
648: SELECT mi.inventory_item_id inventory_item_id,
649: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
650: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
651: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
652: NVL(fsp.org_id, -2) org_id,
653: mitl.language,
654: 'MASTER_ITEM' source_type,
655: NVL(fsp.org_id, -2) purchasing_org_id,

Line 681: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

677: AND mi.organization_id = mitl.organization_id
678: AND mitl.language = mitl.source_lang
679: AND mic.inventory_item_id = mi.inventory_item_id
680: AND mic.organization_id = mi.organization_id
681: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
682: AND mic.category_id = p_mtl_category_id
683: AND mi.inventory_item_id >= p_inventory_item_id
684: AND muom.uom_code = mi.primary_uom_code
685: AND NOT (mi.replenish_to_order_flag = 'Y'

Line 707: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);

703: AND doc.source_type = ctx.source_type (+)
704: ORDER by doc.inventory_item_id;
705:
706: l_err_loc := 500;
707: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);
708:
709: l_err_loc := 600;
710: CLOSE l_masterItem_csr;
711:

Line 715: ICX_CAT_UTIL_PVT.logUnexpectedException(

711:
712: l_err_loc := 700;
713: EXCEPTION
714: WHEN OTHERS THEN
715: ICX_CAT_UTIL_PVT.logUnexpectedException(
716: G_PKG_NAME, l_api_name,
717: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
718: RAISE;
719: END openCategoryItemsCursor;

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

726: BEGIN
727: l_err_loc := 100;
728: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
731: 'Processing cursor:' || l_api_name ||
732: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
733: ', g_start_rowid:' || g_start_rowid ||
734: ', g_end_rowid:' || g_end_rowid ||

Line 735: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

731: 'Processing cursor:' || l_api_name ||
732: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
733: ', g_start_rowid:' || g_start_rowid ||
734: ', g_end_rowid:' || g_end_rowid ||
735: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
736: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER );
737: END IF;
738:
739: l_err_loc := 150;

Line 736: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER );

732: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
733: ', g_start_rowid:' || g_start_rowid ||
734: ', g_end_rowid:' || g_end_rowid ||
735: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
736: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER );
737: END IF;
738:
739: l_err_loc := 150;
740: --First close the cursor

Line 770: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

766: FROM
767: (
768: SELECT /*+ ROWID(mi) use_nl(mitl,mic,catMap) */
769: mi.inventory_item_id inventory_item_id,
770: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
771: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
772: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
773: NVL(fsp.org_id, -2) org_id,
774: mitl.language,

Line 771: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

767: (
768: SELECT /*+ ROWID(mi) use_nl(mitl,mic,catMap) */
769: mi.inventory_item_id inventory_item_id,
770: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
771: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
772: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
773: NVL(fsp.org_id, -2) org_id,
774: mitl.language,
775: 'MASTER_ITEM' source_type,

Line 772: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

768: SELECT /*+ ROWID(mi) use_nl(mitl,mic,catMap) */
769: mi.inventory_item_id inventory_item_id,
770: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
771: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
772: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
773: NVL(fsp.org_id, -2) org_id,
774: mitl.language,
775: 'MASTER_ITEM' source_type,
776: NVL(fsp.org_id, -2) purchasing_org_id,

Line 802: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

798: AND mi.organization_id = mitl.organization_id
799: AND mitl.language = mitl.source_lang
800: AND mic.inventory_item_id = mi.inventory_item_id
801: AND mic.organization_id = mi.organization_id
802: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
803: AND muom.uom_code = mi.primary_uom_code
804: AND NOT (mi.replenish_to_order_flag = 'Y'
805: AND mi.base_item_id IS NOT NULL
806: AND mi.auto_created_config_flag = 'Y')

Line 847: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

843: FROM
844: (
845: SELECT /*+ ROWID(mi) use_nl(mitl,mic,catMap) */
846: mi.inventory_item_id inventory_item_id,
847: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
848: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
849: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
850: NVL(fsp.org_id, -2) org_id,
851: mitl.language,

Line 848: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

844: (
845: SELECT /*+ ROWID(mi) use_nl(mitl,mic,catMap) */
846: mi.inventory_item_id inventory_item_id,
847: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
848: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
849: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
850: NVL(fsp.org_id, -2) org_id,
851: mitl.language,
852: 'MASTER_ITEM' source_type,

Line 849: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

845: SELECT /*+ ROWID(mi) use_nl(mitl,mic,catMap) */
846: mi.inventory_item_id inventory_item_id,
847: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
848: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
849: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
850: NVL(fsp.org_id, -2) org_id,
851: mitl.language,
852: 'MASTER_ITEM' source_type,
853: NVL(fsp.org_id, -2) purchasing_org_id,

Line 879: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

875: AND mi.organization_id = mitl.organization_id
876: AND mitl.language = mitl.source_lang
877: AND mic.inventory_item_id = mi.inventory_item_id
878: AND mic.organization_id = mi.organization_id
879: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
880: AND muom.uom_code = mi.primary_uom_code
881: AND NOT (mi.replenish_to_order_flag = 'Y'
882: AND mi.base_item_id IS NOT NULL
883: AND mi.auto_created_config_flag = 'Y')

Line 907: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);

903: AND doc.source_type = ctx.source_type (+);
904: END IF;
905:
906: l_err_loc := 700;
907: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);
908:
909: l_err_loc := 800;
910: CLOSE l_masterItem_csr;
911:

Line 916: ICX_CAT_UTIL_PVT.logUnexpectedException(

912: l_err_loc := 900;
913:
914: EXCEPTION
915: WHEN OTHERS THEN
916: ICX_CAT_UTIL_PVT.logUnexpectedException(
917: G_PKG_NAME, l_api_name,
918: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
919: RAISE;
920: END openR12UpgradeMICursor;

Line 922: -- p_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

918: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
919: RAISE;
920: END openR12UpgradeMICursor;
921:
922: -- p_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
923: PROCEDURE populateMIs
924: ( p_masterItem_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
925: p_current_mode IN VARCHAR2
926: )

Line 1057: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1053: l_ctx_ip_category_id_tbl,
1054: l_ctx_po_category_id_tbl,
1055: l_ctx_ip_category_name_tbl,
1056: l_ctx_rowid_tbl
1057: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1058: l_err_loc := 400;
1059: EXIT WHEN l_inv_item_id_tbl.COUNT = 0;
1060:
1061: l_err_loc := 500;

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

1064: l_err_loc := 600;
1065: l_count := l_inv_item_id_tbl.COUNT;
1066: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1068: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1069: 'Num. of rows returned from the cursor:' || l_count);
1070: END IF;
1071:
1072: --Save the last inventory_item_id processed, so that re-open of cursor will start from the saved id.

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

1081: (l_intrnl_order_enbld_flag_tbl(i), l_outside_operation_flag_tbl(i), l_unit_price_tbl(i),
1082: l_inv_item_status, l_item_type);
1083: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1084: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1085: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1086: 'l_inv_item_status: ' || l_inv_item_status ||
1087: 'l_item_type :' || l_item_type);
1088: END IF;
1089: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1087: 'l_item_type :' || l_item_type);
1088: END IF;
1089: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1091: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1092: 'Values for Variables in populateMIs ' ||
1093: 'l_inv_item_id: ' || l_inv_item_id_tbl(i) ||
1094: ',l_po_line_id: ' || l_po_line_id_tbl(i) ||
1095: ',l_req_template_name: ' || l_req_template_name_tbl(i) ||

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

1132: IF (l_po_category_id_tbl(i) IS NULL) THEN
1133: l_err_loc := 900;
1134: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1136: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1137: 'null l_po_category_id:' || l_po_category_id_tbl(i) ||
1138: 'for l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1139: ', l_org_id_tbl:' || l_org_id_tbl(i));
1140: END IF;

Line 1160: l_current_ctx_item_rec.supplier_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

1156: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
1157: l_current_ctx_item_rec.item_type := l_item_type;
1158: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
1159: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
1160: l_current_ctx_item_rec.supplier_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1161: l_current_ctx_item_rec.supplier_part_num := '##NULL##';
1162: l_current_ctx_item_rec.supplier_part_auxid := '##NULL##';
1163: l_current_ctx_item_rec.supplier_site_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1164: l_current_ctx_item_rec.status := l_inv_item_status;

Line 1163: l_current_ctx_item_rec.supplier_site_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

1159: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
1160: l_current_ctx_item_rec.supplier_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1161: l_current_ctx_item_rec.supplier_part_num := '##NULL##';
1162: l_current_ctx_item_rec.supplier_part_auxid := '##NULL##';
1163: l_current_ctx_item_rec.supplier_site_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1164: l_current_ctx_item_rec.status := l_inv_item_status;
1165: -- Ignore category changes due to mapping if this was online item update
1166: -- Honor category changes due to mapping during upgrade, online item category change
1167: -- and online item create.

Line 1169: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const

1165: -- Ignore category changes due to mapping if this was online item update
1166: -- Honor category changes due to mapping during upgrade, online item category change
1167: -- and online item create.
1168: IF (l_ctx_rowid_tbl(i) IS NOT NULL
1169: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1170: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1171: THEN
1172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 1170: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)

1166: -- Honor category changes due to mapping during upgrade, online item category change
1167: -- and online item create.
1168: IF (l_ctx_rowid_tbl(i) IS NOT NULL
1169: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1170: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1171: THEN
1172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1174: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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

1170: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1171: THEN
1172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1174: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1175: 'Not changing the po category and ip category for' ||
1176: ', l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1177: ', l_org_id_tbl:' || l_org_id_tbl(i) ||
1178: ', l_ctx_rowid_tbl:' || l_ctx_rowid_tbl(i) ||

Line 1233: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1229: l_err_loc := 1200;
1230: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
1231:
1232: l_err_loc := 1300;
1233: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1234: ELSE
1235: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1235: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

1231:
1232: l_err_loc := 1300;
1233: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1234: ELSE
1235: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1238: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1239: 'Row #:' || i ||

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

1234: ELSE
1235: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1238: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1239: 'Row #:' || i ||
1240: ', item:( ' || l_inv_item_id_tbl(i) ||
1241: ', ' || l_org_id_tbl(i) || '), Not processed' ||
1242: ', internal_order_enabled_flag:' || l_intrnl_order_enbld_flag_tbl(i) ||

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

1248: END IF;
1249: ELSE
1250: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1251: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1252: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1253: 'Row #:' || i ||
1254: ', item:( ' || l_inv_item_id_tbl(i) ||
1255: ', ' || l_org_id_tbl(i) || '), Not processed' ||
1256: ', internal_order_enabled_flag:' || l_intrnl_order_enbld_flag_tbl(i) ||

Line 1268: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

1264: END IF;
1265: END LOOP; --FOR LOOP of l_inv_item_id_tbl
1266:
1267: l_err_loc := 1400;
1268: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1269: EXCEPTION
1270: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1271: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1272: ||', Total processeded batches:' ||l_batch_count

Line 1270: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1266:
1267: l_err_loc := 1400;
1268: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1269: EXCEPTION
1270: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1271: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1272: ||', Total processeded batches:' ||l_batch_count
1273: ||', Cursor will be reopened with inventory_item_id:' ||l_start_inv_item_id;
1274: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 1274: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

1270: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1271: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1272: ||', Total processeded batches:' ||l_batch_count
1273: ||', Cursor will be reopened with inventory_item_id:' ||l_start_inv_item_id;
1274: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1275: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1276: --Closing and reopen of cursor will be done by called procedures
1277: l_err_loc := 1500;
1278: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

Line 1275: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

1271: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1272: ||', Total processeded batches:' ||l_batch_count
1273: ||', Cursor will be reopened with inventory_item_id:' ||l_start_inv_item_id;
1274: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1275: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1276: --Closing and reopen of cursor will be done by called procedures
1277: l_err_loc := 1500;
1278: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1279: l_err_loc := 1600;

Line 1278: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

1274: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1275: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1276: --Closing and reopen of cursor will be done by called procedures
1277: l_err_loc := 1500;
1278: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1279: l_err_loc := 1600;
1280: openR12UpgradeMICursor;
1281: ELSE
1282: l_err_loc := 1700;

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

1290: l_err_loc := 1900;
1291: -- Online case should not throw snapshot too old error.
1292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1293: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1294: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1295: 'Online case throwing snap shot too old error');
1296: END IF;
1297: END IF;
1298: END IF;

Line 1306: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1302: END;
1303: END LOOP; --Cursor loop
1304:
1305: l_err_loc := 2000;
1306: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1307:
1308: l_err_loc := 2100;
1309: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1310: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

1307:
1308: l_err_loc := 2100;
1309: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1310: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1311: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1312: 'populateMIs in mode:'|| p_current_mode ||' done; '||
1313: 'Total num. of batches processed:' ||l_batch_count ||
1314: ', Total num. of rows processed:' ||l_row_count);
1315: END IF;

Line 1318: ICX_CAT_UTIL_PVT.logUnexpectedException(

1314: ', Total num. of rows processed:' ||l_row_count);
1315: END IF;
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: ICX_CAT_UTIL_PVT.logUnexpectedException(
1319: G_PKG_NAME, l_api_name,
1320: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1321: RAISE;
1322: END populateMIs;

Line 1346: ICX_CAT_UTIL_PVT.logUnexpectedException(

1342:
1343: l_err_loc := 400;
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: ICX_CAT_UTIL_PVT.logUnexpectedException(
1347: G_PKG_NAME, l_api_name,
1348: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1349: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1350: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

Line 1349: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;

1345: WHEN OTHERS THEN
1346: ICX_CAT_UTIL_PVT.logUnexpectedException(
1347: G_PKG_NAME, l_api_name,
1348: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1349: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1350: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
1351: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
1352: RAISE;
1353: END upgradeR12MIs;

Line 1350: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

1346: ICX_CAT_UTIL_PVT.logUnexpectedException(
1347: G_PKG_NAME, l_api_name,
1348: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1349: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1350: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
1351: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
1352: RAISE;
1353: END upgradeR12MIs;
1354:

Line 1351: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;

1347: G_PKG_NAME, l_api_name,
1348: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1349: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1350: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
1351: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
1352: RAISE;
1353: END upgradeR12MIs;
1354:
1355: PROCEDURE populateItemChange

Line 1373: ICX_CAT_UTIL_PVT.setBatchSize;

1369: g_entity_type := P_ENTITY_TYPE;
1370:
1371: l_err_loc := 300;
1372: -- Set the batch_size for the online case
1373: ICX_CAT_UTIL_PVT.setBatchSize;
1374:
1375: l_err_loc := 400;
1376: ICX_CAT_UTIL_PVT.setWhoColumns(p_request_id);
1377:

Line 1376: ICX_CAT_UTIL_PVT.setWhoColumns(p_request_id);

1372: -- Set the batch_size for the online case
1373: ICX_CAT_UTIL_PVT.setBatchSize;
1374:
1375: l_err_loc := 400;
1376: ICX_CAT_UTIL_PVT.setWhoColumns(p_request_id);
1377:
1378: l_err_loc := 500;
1379: -- Initialize the purchasing category set info.
1380: -- If coming from populateItemCatgChange,

Line 1382: IF (ICX_CAT_UTIL_PVT.g_category_set_id IS NULL) THEN

1378: l_err_loc := 500;
1379: -- Initialize the purchasing category set info.
1380: -- If coming from populateItemCatgChange,
1381: -- this will already be set in ICX_CAT_POPULATE_MI_GRP.populateItemCategoryChange.
1382: IF (ICX_CAT_UTIL_PVT.g_category_set_id IS NULL) THEN
1383: l_err_loc := 600;
1384: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1385: ELSE
1386: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1384: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

1380: -- If coming from populateItemCatgChange,
1381: -- this will already be set in ICX_CAT_POPULATE_MI_GRP.populateItemCategoryChange.
1382: IF (ICX_CAT_UTIL_PVT.g_category_set_id IS NULL) THEN
1383: l_err_loc := 600;
1384: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1385: ELSE
1386: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1387: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1388: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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

1384: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1385: ELSE
1386: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1387: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1388: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1389: 'Purchasing category set info:' ||
1390: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1391: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1392: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);

Line 1390: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

1386: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1387: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1388: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1389: 'Purchasing category set info:' ||
1390: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1391: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1392: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1393: END IF;
1394: END IF;

Line 1391: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||

1387: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1388: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1389: 'Purchasing category set info:' ||
1390: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1391: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1392: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1393: END IF;
1394: END IF;
1395:

Line 1392: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);

1388: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1389: 'Purchasing category set info:' ||
1390: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1391: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1392: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1393: END IF;
1394: END IF;
1395:
1396: l_err_loc := 700;

Line 1411: ICX_CAT_UTIL_PVT.logUnexpectedException(

1407:
1408: l_err_loc := 1100;
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: ICX_CAT_UTIL_PVT.logUnexpectedException(
1412: G_PKG_NAME, l_api_name,
1413: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1414: RAISE;
1415: END populateItemChange;

Line 1455: ICX_CAT_UTIL_PVT.setBatchSize;

1451: l_batch_count := 0;
1452:
1453: l_err_loc := 200;
1454: -- Set the batch_size for the online case
1455: ICX_CAT_UTIL_PVT.setBatchSize;
1456:
1457: l_err_loc := 300;
1458: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1459:

Line 1458: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1454: -- Set the batch_size for the online case
1455: ICX_CAT_UTIL_PVT.setBatchSize;
1456:
1457: l_err_loc := 300;
1458: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1459:
1460: l_err_loc := 400;
1461: OPEN masterItemsToBeDeletedCsr(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);
1462:

Line 1473: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1469: BEGIN
1470: l_err_loc := 600;
1471: FETCH masterItemsToBeDeletedCsr BULK COLLECT INTO
1472: l_inv_item_id_tbl, l_org_id_tbl, l_language_tbl
1473: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1474: l_err_loc := 700;
1475: EXIT WHEN l_inv_item_id_tbl.COUNT = 0;
1476:
1477: l_err_loc := 800;

Line 1483: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

1479:
1480: FOR i in 1..l_inv_item_id_tbl.COUNT LOOP
1481: l_err_loc := 900;
1482: l_current_ctx_item_rec.ctx_inventory_item_id := l_inv_item_id_tbl(i);
1483: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1484: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1485: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1486: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1487: l_current_ctx_item_rec.language := l_language_tbl(i);

Line 1484: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

1480: FOR i in 1..l_inv_item_id_tbl.COUNT LOOP
1481: l_err_loc := 900;
1482: l_current_ctx_item_rec.ctx_inventory_item_id := l_inv_item_id_tbl(i);
1483: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1484: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1485: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1486: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1487: l_current_ctx_item_rec.language := l_language_tbl(i);
1488:

Line 1485: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

1481: l_err_loc := 900;
1482: l_current_ctx_item_rec.ctx_inventory_item_id := l_inv_item_id_tbl(i);
1483: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1484: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1485: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1486: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1487: l_current_ctx_item_rec.language := l_language_tbl(i);
1488:
1489: l_err_loc := 1000;

Line 1496: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1492: l_err_loc := 1100;
1493: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxDtlsTLP(l_current_ctx_item_rec);
1494:
1495: l_err_loc := 1200;
1496: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1497: END LOOP; --FOR LOOP of l_inv_item_id_tbl
1498:
1499: l_err_loc := 1300;
1500: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

Line 1500: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

1496: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1497: END LOOP; --FOR LOOP of l_inv_item_id_tbl
1498:
1499: l_err_loc := 1300;
1500: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1501: EXCEPTION
1502: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1503: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc
1504: ||', Total processeded batches:' ||l_batch_count

Line 1502: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1498:
1499: l_err_loc := 1300;
1500: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1501: EXCEPTION
1502: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1503: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc
1504: ||', Total processeded batches:' ||l_batch_count
1505: ||', Cursor will be reopened;';
1506: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 1506: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

1502: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1503: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc
1504: ||', Total processeded batches:' ||l_batch_count
1505: ||', Cursor will be reopened;';
1506: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1507: l_err_loc := 1400;
1508: IF (masterItemsToBeDeletedCsr%ISOPEN) THEN
1509: l_err_loc := 1500;
1510: CLOSE masterItemsToBeDeletedCsr;

Line 1518: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);

1514: END;
1515: END LOOP; --Cursor loop
1516:
1517: l_err_loc := 1700;
1518: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1519:
1520: l_err_loc := 1800;
1521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

1519:
1520: l_err_loc := 1800;
1521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1523: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1524: 'populateItemDelete done; Total num. of batches processed:' || l_batch_count);
1525: END IF;
1526:
1527: l_err_loc := 1900;

Line 1536: ICX_CAT_UTIL_PVT.logUnexpectedException(

1532:
1533: l_err_loc := 2100;
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: ICX_CAT_UTIL_PVT.logUnexpectedException(
1537: G_PKG_NAME, l_api_name,
1538: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1539: RAISE;
1540: END populateItemDelete;

Line 1558: ICX_CAT_UTIL_PVT.logUnexpectedException(

1554: -- Call populateItemChange because it internally checks for category change.
1555: populateItemChange(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID, P_REQUEST_ID, P_ENTITY_TYPE);
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: ICX_CAT_UTIL_PVT.logUnexpectedException(
1559: G_PKG_NAME, l_api_name,
1560: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1561: RAISE;
1562: END populateItemCatgChange;

Line 1579: ICX_CAT_UTIL_PVT.setBatchSize;

1575: g_online_mode := g_onlineUpdate_mode;
1576:
1577: l_err_loc := 200;
1578: -- Set the batch_size for the online case
1579: ICX_CAT_UTIL_PVT.setBatchSize;
1580:
1581: l_err_loc := 300;
1582: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1583:

Line 1582: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1578: -- Set the batch_size for the online case
1579: ICX_CAT_UTIL_PVT.setBatchSize;
1580:
1581: l_err_loc := 300;
1582: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1583:
1584: l_err_loc := 400;
1585: openOnlineItemCatgDeleteCursor(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);
1586:

Line 1590: ICX_CAT_UTIL_PVT.logUnexpectedException(

1586:
1587: l_err_loc := 500;
1588: EXCEPTION
1589: WHEN OTHERS THEN
1590: ICX_CAT_UTIL_PVT.logUnexpectedException(
1591: G_PKG_NAME, l_api_name,
1592: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1593: RAISE;
1594: END populateItemCatgDelete;

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

1608:
1609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1610: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
1611: ', P_MTL_CATEGORY_ID_TBL.COUNT:' || P_MTL_CATEGORY_ID_TBL.COUNT;
1612: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1613: END IF;
1614:
1615: g_online_mode := g_catgItemUpdate_mode;
1616: FOR i IN 1..P_MTL_CATEGORY_ID_TBL.COUNT LOOP

Line 1625: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

1621:
1622: l_err_loc := 900;
1623: l_end_date := sysdate;
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1626: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1627: END IF;
1628: EXCEPTION
1629: WHEN OTHERS THEN

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

1622: l_err_loc := 900;
1623: l_end_date := sysdate;
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1626: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1627: END IF;
1628: EXCEPTION
1629: WHEN OTHERS THEN
1630: ICX_CAT_UTIL_PVT.logUnexpectedException(

Line 1630: ICX_CAT_UTIL_PVT.logUnexpectedException(

1626: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1627: END IF;
1628: EXCEPTION
1629: WHEN OTHERS THEN
1630: ICX_CAT_UTIL_PVT.logUnexpectedException(
1631: G_PKG_NAME, l_api_name,
1632: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1633: RAISE;
1634: END populateCategoryItems;

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

1644: l_err_loc := 100;
1645: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN
1646: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1648: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1649: 'about to call buildmetadatinfo');
1650: END IF;
1651:
1652: l_err_loc := 200;

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

1659: l_err_loc := 400;
1660: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN
1661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1663: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1664: 'about to call buildctxsql');
1665: END IF;
1666: l_err_loc := 500;
1667: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

Line 1668: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'NOTROWID', g_special_metadata_tbl,

1664: 'about to call buildctxsql');
1665: END IF;
1666: l_err_loc := 500;
1667: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1668: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'NOTROWID', g_special_metadata_tbl,
1669: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
1670: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
1671: l_err_loc := 600;
1672: ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed := TRUE;

Line 1682: ICX_CAT_UTIL_PVT.logUnexpectedException(

1678:
1679: l_err_loc := 800;
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: ICX_CAT_UTIL_PVT.logUnexpectedException(
1683: G_PKG_NAME, l_api_name,
1684: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1685: RAISE;
1686: END buildCtxSqlForMIs;