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 80: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

76: FROM
77: (
78: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
79: mi.inventory_item_id inventory_item_id,
80: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
81: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
82: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
83: NVL(fsp.org_id, -2) org_id,
84: mitl.language,

Line 81: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

77: (
78: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
79: mi.inventory_item_id inventory_item_id,
80: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
81: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
82: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
83: NVL(fsp.org_id, -2) org_id,
84: mitl.language,
85: 'MASTER_ITEM' source_type,

Line 82: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

78: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
79: mi.inventory_item_id inventory_item_id,
80: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
81: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
82: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
83: NVL(fsp.org_id, -2) org_id,
84: mitl.language,
85: 'MASTER_ITEM' source_type,
86: NVL(fsp.org_id, -2) purchasing_org_id,

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

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

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

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

Line 146: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

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

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

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

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

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

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

Line 211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

207: FROM
208: (
209: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
210: mi.inventory_item_id inventory_item_id,
211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
212: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
213: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
214: NVL(fsp.org_id, -2) org_id,
215: mitl.language,

Line 212: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

208: (
209: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
210: mi.inventory_item_id inventory_item_id,
211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
212: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
213: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
214: NVL(fsp.org_id, -2) org_id,
215: mitl.language,
216: 'MASTER_ITEM' source_type,

Line 213: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

209: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
210: mi.inventory_item_id inventory_item_id,
211: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
212: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
213: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
214: NVL(fsp.org_id, -2) org_id,
215: mitl.language,
216: 'MASTER_ITEM' source_type,
217: NVL(fsp.org_id, -2) purchasing_org_id,

Line 246: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

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

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

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

Line 277: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

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

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

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

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

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

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

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

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

Line 345: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

341: FROM
342: (
343: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
344: mi.inventory_item_id inventory_item_id,
345: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
346: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
347: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
348: NVL(fsp.org_id, -2) org_id,
349: mitl.language,

Line 346: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

342: (
343: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
344: mi.inventory_item_id inventory_item_id,
345: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
346: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
347: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
348: NVL(fsp.org_id, -2) org_id,
349: mitl.language,
350: 'MASTER_ITEM' source_type,

Line 347: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

343: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
344: mi.inventory_item_id inventory_item_id,
345: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
346: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
347: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
348: NVL(fsp.org_id, -2) org_id,
349: mitl.language,
350: 'MASTER_ITEM' source_type,
351: NVL(fsp.org_id, -2) purchasing_org_id,

Line 383: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

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

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

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

Line 444: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

440: FROM
441: (
442: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
443: mi.inventory_item_id inventory_item_id,
444: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
445: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
446: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
447: NVL(fsp.org_id, -2) org_id,
448: mitl.language,

Line 445: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

441: (
442: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
443: mi.inventory_item_id inventory_item_id,
444: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
445: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
446: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
447: NVL(fsp.org_id, -2) org_id,
448: mitl.language,
449: 'MASTER_ITEM' source_type,

Line 446: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

442: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
443: mi.inventory_item_id inventory_item_id,
444: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
445: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
446: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
447: NVL(fsp.org_id, -2) org_id,
448: mitl.language,
449: 'MASTER_ITEM' source_type,
450: NVL(fsp.org_id, -2) purchasing_org_id,

Line 485: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

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

Line 527: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

523: FROM
524: (
525: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
526: mi.inventory_item_id inventory_item_id,
527: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
528: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
529: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
530: NVL(fsp.org_id, -2) org_id,
531: mitl.language,

Line 528: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

524: (
525: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
526: mi.inventory_item_id inventory_item_id,
527: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
528: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
529: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
530: NVL(fsp.org_id, -2) org_id,
531: mitl.language,
532: 'MASTER_ITEM' source_type,

Line 529: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

525: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
526: mi.inventory_item_id inventory_item_id,
527: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
528: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
529: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
530: NVL(fsp.org_id, -2) org_id,
531: mitl.language,
532: 'MASTER_ITEM' source_type,
533: NVL(fsp.org_id, -2) purchasing_org_id,

Line 568: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

564: AND mi.organization_id = mitl.organization_id
565: AND mitl.language = mitl.source_lang
566: AND mic.inventory_item_id = mi.inventory_item_id
567: AND mic.organization_id = mi.organization_id
568: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
569: AND muom.uom_code = mi.primary_uom_code
570: AND NOT (mi.replenish_to_order_flag = 'Y'
571: AND mi.base_item_id IS NOT NULL
572: AND mi.auto_created_config_flag = 'Y')

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

588: AND doc.source_type = ctx.source_type (+)
589: ) doc1 ORDER by doc1.inventory_item_id;
590: END IF;
591: l_err_loc := 500;
592: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);
593:
594: l_err_loc := 600;
595: CLOSE l_masterItem_csr;
596:

Line 600: ICX_CAT_UTIL_PVT.logUnexpectedException(

596:
597: l_err_loc := 700;
598: EXCEPTION
599: WHEN OTHERS THEN
600: ICX_CAT_UTIL_PVT.logUnexpectedException(
601: G_PKG_NAME, l_api_name,
602: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
603: RAISE;
604: END openBulkItemChangeCursor;

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

614: BEGIN
615: l_err_loc := 100;
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Processing cursor:' || l_api_name ||
620: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
621: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
622: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||

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

616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Processing cursor:' || l_api_name ||
620: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
621: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
622: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
623: ', p_mtl_category_id:' || p_mtl_category_id );
624: END IF;

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

617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Processing cursor:' || l_api_name ||
620: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
621: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
622: ', P_INVENTORY_ITEM_ID:' || P_INVENTORY_ITEM_ID ||
623: ', p_mtl_category_id:' || p_mtl_category_id );
624: END IF;
625:

Line 655: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

651: FROM
652: (
653: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
654: mi.inventory_item_id inventory_item_id,
655: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
656: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
657: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
658: NVL(fsp.org_id, -2) org_id,
659: mitl.language,

Line 656: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

652: (
653: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
654: mi.inventory_item_id inventory_item_id,
655: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
656: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
657: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
658: NVL(fsp.org_id, -2) org_id,
659: mitl.language,
660: 'MASTER_ITEM' source_type,

Line 657: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

653: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
654: mi.inventory_item_id inventory_item_id,
655: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
656: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
657: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
658: NVL(fsp.org_id, -2) org_id,
659: mitl.language,
660: 'MASTER_ITEM' source_type,
661: NVL(fsp.org_id, -2) purchasing_org_id,

Line 687: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

683: AND mi.organization_id = mitl.organization_id
684: AND mitl.language = mitl.source_lang
685: AND mic.inventory_item_id = mi.inventory_item_id
686: AND mic.organization_id = mi.organization_id
687: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
688: AND mic.category_id = p_mtl_category_id
689: AND mi.inventory_item_id >= p_inventory_item_id
690: AND muom.uom_code = mi.primary_uom_code
691: AND NOT (mi.replenish_to_order_flag = 'Y'

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

709: AND doc.source_type = ctx.source_type (+)
710: ORDER by doc.inventory_item_id;
711:
712: l_err_loc := 500;
713: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_online_const);
714:
715: l_err_loc := 600;
716: CLOSE l_masterItem_csr;
717:

Line 721: ICX_CAT_UTIL_PVT.logUnexpectedException(

717:
718: l_err_loc := 700;
719: EXCEPTION
720: WHEN OTHERS THEN
721: ICX_CAT_UTIL_PVT.logUnexpectedException(
722: G_PKG_NAME, l_api_name,
723: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
724: RAISE;
725: END openCategoryItemsCursor;

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

732: BEGIN
733: l_err_loc := 100;
734: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
735: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
736: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
737: 'Processing cursor:' || l_api_name ||
738: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
739: ', g_start_rowid:' || g_start_rowid ||
740: ', g_end_rowid:' || g_end_rowid ||

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

737: 'Processing cursor:' || l_api_name ||
738: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
739: ', g_start_rowid:' || g_start_rowid ||
740: ', g_end_rowid:' || g_end_rowid ||
741: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
742: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER );
743: END IF;
744:
745: l_err_loc := 150;

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

738: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
739: ', g_start_rowid:' || g_start_rowid ||
740: ', g_end_rowid:' || g_end_rowid ||
741: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
742: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER );
743: END IF;
744:
745: l_err_loc := 150;
746: --First close the cursor

Line 776: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

772: FROM
773: (
774: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
775: mi.inventory_item_id inventory_item_id,
776: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
777: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
778: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
779: NVL(fsp.org_id, -2) org_id,
780: mitl.language,

Line 777: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

773: (
774: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
775: mi.inventory_item_id inventory_item_id,
776: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
777: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
778: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
779: NVL(fsp.org_id, -2) org_id,
780: mitl.language,
781: 'MASTER_ITEM' source_type,

Line 778: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

774: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
775: mi.inventory_item_id inventory_item_id,
776: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
777: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
778: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
779: NVL(fsp.org_id, -2) org_id,
780: mitl.language,
781: 'MASTER_ITEM' source_type,
782: NVL(fsp.org_id, -2) purchasing_org_id,

Line 808: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

804: AND mi.organization_id = mitl.organization_id
805: AND mitl.language = mitl.source_lang
806: AND mic.inventory_item_id = mi.inventory_item_id
807: AND mic.organization_id = mi.organization_id
808: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
809: AND muom.uom_code = mi.primary_uom_code
810: AND NOT (mi.replenish_to_order_flag = 'Y'
811: AND mi.base_item_id IS NOT NULL
812: AND mi.auto_created_config_flag = 'Y')

Line 853: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,

849: FROM
850: (
851: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
852: mi.inventory_item_id inventory_item_id,
853: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
854: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
855: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
856: NVL(fsp.org_id, -2) org_id,
857: mitl.language,

Line 854: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,

850: (
851: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
852: mi.inventory_item_id inventory_item_id,
853: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
854: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
855: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
856: NVL(fsp.org_id, -2) org_id,
857: mitl.language,
858: 'MASTER_ITEM' source_type,

Line 855: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,

851: SELECT /*+ ROWID(mi) NO_EXPAND use_nl(mitl,mic,catMap) */
852: mi.inventory_item_id inventory_item_id,
853: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) po_line_id,
854: TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_name,
855: TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER) req_template_line_num,
856: NVL(fsp.org_id, -2) org_id,
857: mitl.language,
858: 'MASTER_ITEM' source_type,
859: NVL(fsp.org_id, -2) purchasing_org_id,

Line 885: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id

881: AND mi.organization_id = mitl.organization_id
882: AND mitl.language = mitl.source_lang
883: AND mic.inventory_item_id = mi.inventory_item_id
884: AND mic.organization_id = mi.organization_id
885: AND mic.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id
886: AND muom.uom_code = mi.primary_uom_code
887: AND NOT (mi.replenish_to_order_flag = 'Y'
888: AND mi.base_item_id IS NOT NULL
889: AND mi.auto_created_config_flag = 'Y')

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

909: AND doc.source_type = ctx.source_type (+);
910: END IF;
911:
912: l_err_loc := 700;
913: populateMIs(l_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);
914:
915: l_err_loc := 800;
916: CLOSE l_masterItem_csr;
917:

Line 922: ICX_CAT_UTIL_PVT.logUnexpectedException(

918: l_err_loc := 900;
919:
920: EXCEPTION
921: WHEN OTHERS THEN
922: ICX_CAT_UTIL_PVT.logUnexpectedException(
923: G_PKG_NAME, l_api_name,
924: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
925: RAISE;
926: END openR12UpgradeMICursor;

Line 928: -- p_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

924: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
925: RAISE;
926: END openR12UpgradeMICursor;
927:
928: -- p_masterItem_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
929: PROCEDURE populateMIs
930: ( p_masterItem_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
931: p_current_mode IN VARCHAR2
932: )

Line 1063: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1059: l_ctx_ip_category_id_tbl,
1060: l_ctx_po_category_id_tbl,
1061: l_ctx_ip_category_name_tbl,
1062: l_ctx_rowid_tbl
1063: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1064: l_err_loc := 400;
1065: EXIT WHEN l_inv_item_id_tbl.COUNT = 0;
1066:
1067: l_err_loc := 500;

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

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

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

1087: (l_intrnl_order_enbld_flag_tbl(i), l_outside_operation_flag_tbl(i), l_unit_price_tbl(i),
1088: l_inv_item_status, l_item_type);
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: 'l_inv_item_status: ' || l_inv_item_status ||
1093: 'l_item_type :' || l_item_type);
1094: END IF;
1095: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1093: 'l_item_type :' || l_item_type);
1094: END IF;
1095: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1096: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1097: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1098: 'Values for Variables in populateMIs ' ||
1099: 'l_inv_item_id: ' || l_inv_item_id_tbl(i) ||
1100: ',l_po_line_id: ' || l_po_line_id_tbl(i) ||
1101: ',l_req_template_name: ' || l_req_template_name_tbl(i) ||

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

1138: IF (l_po_category_id_tbl(i) IS NULL) THEN
1139: l_err_loc := 900;
1140: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1142: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1143: 'null l_po_category_id:' || l_po_category_id_tbl(i) ||
1144: 'for l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1145: ', l_org_id_tbl:' || l_org_id_tbl(i));
1146: END IF;

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

1162: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
1163: l_current_ctx_item_rec.item_type := l_item_type;
1164: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
1165: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
1166: l_current_ctx_item_rec.supplier_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1167: l_current_ctx_item_rec.supplier_part_num := '##NULL##';
1168: l_current_ctx_item_rec.supplier_part_auxid := '##NULL##';
1169: l_current_ctx_item_rec.supplier_site_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1170: l_current_ctx_item_rec.status := l_inv_item_status;

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

1165: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
1166: l_current_ctx_item_rec.supplier_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1167: l_current_ctx_item_rec.supplier_part_num := '##NULL##';
1168: l_current_ctx_item_rec.supplier_part_auxid := '##NULL##';
1169: l_current_ctx_item_rec.supplier_site_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1170: l_current_ctx_item_rec.status := l_inv_item_status;
1171: -- Ignore category changes due to mapping if this was online item update
1172: -- Honor category changes due to mapping during upgrade, online item category change
1173: -- and online item create.

Line 1175: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const

1171: -- Ignore category changes due to mapping if this was online item update
1172: -- Honor category changes due to mapping during upgrade, online item category change
1173: -- and online item create.
1174: IF (l_ctx_rowid_tbl(i) IS NOT NULL
1175: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1176: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1177: THEN
1178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

Line 1176: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)

1172: -- Honor category changes due to mapping during upgrade, online item category change
1173: -- and online item create.
1174: IF (l_ctx_rowid_tbl(i) IS NOT NULL
1175: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1176: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1177: THEN
1178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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

1176: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1177: THEN
1178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1181: 'Not changing the po category and ip category for' ||
1182: ', l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1183: ', l_org_id_tbl:' || l_org_id_tbl(i) ||
1184: ', l_ctx_rowid_tbl:' || l_ctx_rowid_tbl(i) ||

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

1235: l_err_loc := 1200;
1236: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
1237:
1238: l_err_loc := 1300;
1239: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1240: ELSE
1241: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1242: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

1237:
1238: l_err_loc := 1300;
1239: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1240: ELSE
1241: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1242: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1244: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1245: 'Row #:' || i ||

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

1240: ELSE
1241: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1242: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1244: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1245: 'Row #:' || i ||
1246: ', item:( ' || l_inv_item_id_tbl(i) ||
1247: ', ' || l_org_id_tbl(i) || '), Not processed' ||
1248: ', internal_order_enabled_flag:' || l_intrnl_order_enbld_flag_tbl(i) ||

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

1254: END IF;
1255: ELSE
1256: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1257: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1258: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1259: 'Row #:' || i ||
1260: ', item:( ' || l_inv_item_id_tbl(i) ||
1261: ', ' || l_organization_id_tbl(i) || '), Item is inactive and invalid for purchase, delete from iP tables' ||
1262: ', internal_order_enabled_flag:' || l_intrnl_order_enbld_flag_tbl(i) ||

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

1271: END IF;
1272: END LOOP; --FOR LOOP of l_inv_item_id_tbl
1273:
1274: l_err_loc := 1400;
1275: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1276: EXCEPTION
1277: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1278: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1279: ||', Total processeded batches:' ||l_batch_count

Line 1277: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1273:
1274: l_err_loc := 1400;
1275: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1276: EXCEPTION
1277: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1278: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1279: ||', Total processeded batches:' ||l_batch_count
1280: ||', Cursor will be reopened with inventory_item_id:' ||l_start_inv_item_id;
1281: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

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

1277: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1278: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1279: ||', Total processeded batches:' ||l_batch_count
1280: ||', Cursor will be reopened with inventory_item_id:' ||l_start_inv_item_id;
1281: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1282: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1283: --Closing and reopen of cursor will be done by called procedures
1284: l_err_loc := 1500;
1285: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

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

1278: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateMIs' ||l_err_loc
1279: ||', Total processeded batches:' ||l_batch_count
1280: ||', Cursor will be reopened with inventory_item_id:' ||l_start_inv_item_id;
1281: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1282: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1283: --Closing and reopen of cursor will be done by called procedures
1284: l_err_loc := 1500;
1285: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1286: l_err_loc := 1600;

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

1281: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1282: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1283: --Closing and reopen of cursor will be done by called procedures
1284: l_err_loc := 1500;
1285: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1286: l_err_loc := 1600;
1287: openR12UpgradeMICursor;
1288: ELSE
1289: l_err_loc := 1700;

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

1297: l_err_loc := 1900;
1298: -- Online case should not throw snapshot too old error.
1299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1301: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1302: 'Online case throwing snap shot too old error');
1303: END IF;
1304: END IF;
1305: END IF;

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

1309: END;
1310: END LOOP; --Cursor loop
1311:
1312: l_err_loc := 2000;
1313: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1314:
1315: l_err_loc := 2100;
1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

1314:
1315: l_err_loc := 2100;
1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1318: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1319: 'populateMIs in mode:'|| p_current_mode ||' done; '||
1320: 'Total num. of batches processed:' ||l_batch_count ||
1321: ', Total num. of rows processed:' ||l_row_count);
1322: END IF;

Line 1325: ICX_CAT_UTIL_PVT.logUnexpectedException(

1321: ', Total num. of rows processed:' ||l_row_count);
1322: END IF;
1323: EXCEPTION
1324: WHEN OTHERS THEN
1325: ICX_CAT_UTIL_PVT.logUnexpectedException(
1326: G_PKG_NAME, l_api_name,
1327: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1328: RAISE;
1329: END populateMIs;

Line 1353: ICX_CAT_UTIL_PVT.logUnexpectedException(

1349:
1350: l_err_loc := 400;
1351: EXCEPTION
1352: WHEN OTHERS THEN
1353: ICX_CAT_UTIL_PVT.logUnexpectedException(
1354: G_PKG_NAME, l_api_name,
1355: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1356: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1357: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

Line 1356: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;

1352: WHEN OTHERS THEN
1353: ICX_CAT_UTIL_PVT.logUnexpectedException(
1354: G_PKG_NAME, l_api_name,
1355: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1356: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1357: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
1358: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
1359: RAISE;
1360: END upgradeR12MIs;

Line 1357: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

1353: ICX_CAT_UTIL_PVT.logUnexpectedException(
1354: G_PKG_NAME, l_api_name,
1355: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1356: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1357: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
1358: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
1359: RAISE;
1360: END upgradeR12MIs;
1361:

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

1354: G_PKG_NAME, l_api_name,
1355: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1356: ICX_CAT_UTIL_PVT.g_job_mi_complete_date := NULL;
1357: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
1358: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
1359: RAISE;
1360: END upgradeR12MIs;
1361:
1362: PROCEDURE populateItemChange

Line 1380: ICX_CAT_UTIL_PVT.setBatchSize;

1376: g_entity_type := P_ENTITY_TYPE;
1377:
1378: l_err_loc := 300;
1379: -- Set the batch_size for the online case
1380: ICX_CAT_UTIL_PVT.setBatchSize;
1381:
1382: l_err_loc := 400;
1383: ICX_CAT_UTIL_PVT.setWhoColumns(p_request_id);
1384:

Line 1383: ICX_CAT_UTIL_PVT.setWhoColumns(p_request_id);

1379: -- Set the batch_size for the online case
1380: ICX_CAT_UTIL_PVT.setBatchSize;
1381:
1382: l_err_loc := 400;
1383: ICX_CAT_UTIL_PVT.setWhoColumns(p_request_id);
1384:
1385: l_err_loc := 500;
1386: -- Initialize the purchasing category set info.
1387: -- If coming from populateItemCatgChange,

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

1385: l_err_loc := 500;
1386: -- Initialize the purchasing category set info.
1387: -- If coming from populateItemCatgChange,
1388: -- this will already be set in ICX_CAT_POPULATE_MI_GRP.populateItemCategoryChange.
1389: IF (ICX_CAT_UTIL_PVT.g_category_set_id IS NULL) THEN
1390: l_err_loc := 600;
1391: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1392: ELSE
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1391: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

1387: -- If coming from populateItemCatgChange,
1388: -- this will already be set in ICX_CAT_POPULATE_MI_GRP.populateItemCategoryChange.
1389: IF (ICX_CAT_UTIL_PVT.g_category_set_id IS NULL) THEN
1390: l_err_loc := 600;
1391: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1392: ELSE
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1395: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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

1391: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1392: ELSE
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1395: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1396: 'Purchasing category set info:' ||
1397: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1398: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1399: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);

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

1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1395: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1396: 'Purchasing category set info:' ||
1397: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1398: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1399: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1400: END IF;
1401: END IF;

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

1394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1395: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1396: 'Purchasing category set info:' ||
1397: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1398: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1399: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1400: END IF;
1401: END IF;
1402:

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

1395: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1396: 'Purchasing category set info:' ||
1397: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1398: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||
1399: ', g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id);
1400: END IF;
1401: END IF;
1402:
1403: l_err_loc := 700;

Line 1418: ICX_CAT_UTIL_PVT.logUnexpectedException(

1414:
1415: l_err_loc := 1100;
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: ICX_CAT_UTIL_PVT.logUnexpectedException(
1419: G_PKG_NAME, l_api_name,
1420: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1421: RAISE;
1422: END populateItemChange;

Line 1462: ICX_CAT_UTIL_PVT.setBatchSize;

1458: l_batch_count := 0;
1459:
1460: l_err_loc := 200;
1461: -- Set the batch_size for the online case
1462: ICX_CAT_UTIL_PVT.setBatchSize;
1463:
1464: l_err_loc := 300;
1465: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1466:

Line 1465: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1461: -- Set the batch_size for the online case
1462: ICX_CAT_UTIL_PVT.setBatchSize;
1463:
1464: l_err_loc := 300;
1465: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1466:
1467: l_err_loc := 400;
1468: OPEN masterItemsToBeDeletedCsr(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);
1469:

Line 1480: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1476: BEGIN
1477: l_err_loc := 600;
1478: FETCH masterItemsToBeDeletedCsr BULK COLLECT INTO
1479: l_inv_item_id_tbl, l_org_id_tbl, l_language_tbl
1480: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1481: l_err_loc := 700;
1482: EXIT WHEN l_inv_item_id_tbl.COUNT = 0;
1483:
1484: l_err_loc := 800;

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

1486:
1487: FOR i in 1..l_inv_item_id_tbl.COUNT LOOP
1488: l_err_loc := 900;
1489: l_current_ctx_item_rec.ctx_inventory_item_id := l_inv_item_id_tbl(i);
1490: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1491: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1492: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1493: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1494: l_current_ctx_item_rec.language := l_language_tbl(i);

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

1487: FOR i in 1..l_inv_item_id_tbl.COUNT LOOP
1488: l_err_loc := 900;
1489: l_current_ctx_item_rec.ctx_inventory_item_id := l_inv_item_id_tbl(i);
1490: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1491: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1492: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1493: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1494: l_current_ctx_item_rec.language := l_language_tbl(i);
1495:

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

1488: l_err_loc := 900;
1489: l_current_ctx_item_rec.ctx_inventory_item_id := l_inv_item_id_tbl(i);
1490: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1491: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1492: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1493: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1494: l_current_ctx_item_rec.language := l_language_tbl(i);
1495:
1496: l_err_loc := 1000;

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

1499: l_err_loc := 1100;
1500: ICX_CAT_POPULATE_ITEM_PVT.deleteItemCtxDtlsTLP(l_current_ctx_item_rec);
1501:
1502: l_err_loc := 1200;
1503: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1504: END LOOP; --FOR LOOP of l_inv_item_id_tbl
1505:
1506: l_err_loc := 1300;
1507: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

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

1503: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1504: END LOOP; --FOR LOOP of l_inv_item_id_tbl
1505:
1506: l_err_loc := 1300;
1507: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1508: EXCEPTION
1509: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1510: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc
1511: ||', Total processeded batches:' ||l_batch_count

Line 1509: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1505:
1506: l_err_loc := 1300;
1507: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1508: EXCEPTION
1509: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1510: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc
1511: ||', Total processeded batches:' ||l_batch_count
1512: ||', Cursor will be reopened;';
1513: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

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

1509: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1510: l_err_string := 'ICX_CAT_POPULATE_MI_PVT.populateItemDelete' ||l_err_loc
1511: ||', Total processeded batches:' ||l_batch_count
1512: ||', Cursor will be reopened;';
1513: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1514: l_err_loc := 1400;
1515: IF (masterItemsToBeDeletedCsr%ISOPEN) THEN
1516: l_err_loc := 1500;
1517: CLOSE masterItemsToBeDeletedCsr;

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

1521: END;
1522: END LOOP; --Cursor loop
1523:
1524: l_err_loc := 1700;
1525: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1526:
1527: l_err_loc := 1800;
1528: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

1526:
1527: l_err_loc := 1800;
1528: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1530: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1531: 'populateItemDelete done; Total num. of batches processed:' || l_batch_count);
1532: END IF;
1533:
1534: l_err_loc := 1900;

Line 1543: ICX_CAT_UTIL_PVT.logUnexpectedException(

1539:
1540: l_err_loc := 2100;
1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: ICX_CAT_UTIL_PVT.logUnexpectedException(
1544: G_PKG_NAME, l_api_name,
1545: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1546: RAISE;
1547: END populateItemDelete;

Line 1565: ICX_CAT_UTIL_PVT.logUnexpectedException(

1561: -- Call populateItemChange because it internally checks for category change.
1562: populateItemChange(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID, P_REQUEST_ID, P_ENTITY_TYPE);
1563: EXCEPTION
1564: WHEN OTHERS THEN
1565: ICX_CAT_UTIL_PVT.logUnexpectedException(
1566: G_PKG_NAME, l_api_name,
1567: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1568: RAISE;
1569: END populateItemCatgChange;

Line 1586: ICX_CAT_UTIL_PVT.setBatchSize;

1582: g_online_mode := g_onlineUpdate_mode;
1583:
1584: l_err_loc := 200;
1585: -- Set the batch_size for the online case
1586: ICX_CAT_UTIL_PVT.setBatchSize;
1587:
1588: l_err_loc := 300;
1589: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1590:

Line 1589: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1585: -- Set the batch_size for the online case
1586: ICX_CAT_UTIL_PVT.setBatchSize;
1587:
1588: l_err_loc := 300;
1589: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1590:
1591: l_err_loc := 400;
1592: openOnlineItemCatgDeleteCursor(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);
1593:

Line 1597: ICX_CAT_UTIL_PVT.logUnexpectedException(

1593:
1594: l_err_loc := 500;
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: ICX_CAT_UTIL_PVT.logUnexpectedException(
1598: G_PKG_NAME, l_api_name,
1599: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1600: RAISE;
1601: END populateItemCatgDelete;

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

1615:
1616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1617: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
1618: ', P_MTL_CATEGORY_ID_TBL.COUNT:' || P_MTL_CATEGORY_ID_TBL.COUNT;
1619: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1620: END IF;
1621:
1622: g_online_mode := g_catgItemUpdate_mode;
1623: FOR i IN 1..P_MTL_CATEGORY_ID_TBL.COUNT LOOP

Line 1632: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

1628:
1629: l_err_loc := 900;
1630: l_end_date := sysdate;
1631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1633: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1634: END IF;
1635: EXCEPTION
1636: WHEN OTHERS THEN

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

1629: l_err_loc := 900;
1630: l_end_date := sysdate;
1631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1633: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1634: END IF;
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: ICX_CAT_UTIL_PVT.logUnexpectedException(

Line 1637: ICX_CAT_UTIL_PVT.logUnexpectedException(

1633: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1634: END IF;
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: ICX_CAT_UTIL_PVT.logUnexpectedException(
1638: G_PKG_NAME, l_api_name,
1639: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1640: RAISE;
1641: END populateCategoryItems;

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

1651: l_err_loc := 100;
1652: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN
1653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1655: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1656: 'about to call buildmetadatinfo');
1657: END IF;
1658:
1659: l_err_loc := 200;

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

1666: l_err_loc := 400;
1667: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN
1668: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1669: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1671: 'about to call buildctxsql');
1672: END IF;
1673: l_err_loc := 500;
1674: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

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

1671: 'about to call buildctxsql');
1672: END IF;
1673: l_err_loc := 500;
1674: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1675: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'NOTROWID', g_special_metadata_tbl,
1676: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
1677: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
1678: l_err_loc := 600;
1679: ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed := TRUE;

Line 1689: ICX_CAT_UTIL_PVT.logUnexpectedException(

1685:
1686: l_err_loc := 800;
1687: EXCEPTION
1688: WHEN OTHERS THEN
1689: ICX_CAT_UTIL_PVT.logUnexpectedException(
1690: G_PKG_NAME, l_api_name,
1691: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1692: RAISE;
1693: END buildCtxSqlForMIs;