APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_POR_EXT_UTL

Line 2382: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,

2378: --In some cases if system_action is null then replace it with action
2379: --this system_action is only used to insert into icx_por_failed_lines table
2380: IF ( v_rec.system_action IS NULL ) THEN
2381: xErrLoc := 110;
2382: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,
2383: 'system_action is null in save_failed_item;' ||
2384: ' v_rec.action:' ||v_rec.action||
2385: ', v_rec.system_action:' ||v_rec.system_action||
2386: ', v_rec.error_flag:' ||v_rec.error_flag||

Line 4022: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,

4018: --Before each batch instantiate the vChangedCatItemIndex to 0
4019: vChangedCatItemIndex := 0;
4020: vCurrentBatch := vCurrentBatch+1;
4021: --Add the Debug info for the current batch
4022: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,
4023: 'Currently processing batch number:'||to_char(vCurrentBatch) );
4024:
4025: FETCH it_table_csr BULK COLLECT INTO
4026: --Bug#2729328

Line 4130: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,

4126: --Index of all gChanged.. plssql_tables should start with 1
4127: --instead of i
4128: vChangedCatItemIndex := vChangedCatItemIndex +1;
4129: --Debugging
4130: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,
4131: 'Category Change seen; vChangedCatItemIndex:' ||to_char(vChangedCatItemIndex)
4132: ||', variables at position i:'||to_char(i)
4133: ||': vOldCategoryIds:'||to_char(vOldCategoryIds(i))
4134: ||', vCategoryIds:' ||to_char(vCategoryIds(i))

Line 4255: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,

4251: BATCH_SIZE := 1000;
4252: END IF;
4253:
4254: --Add the Debug info for the current batch
4255: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL,
4256: 'BATCH_SIZE set to:'||to_char(BATCH_SIZE) );
4257:
4258: CACHE_SIZE := 2*BATCH_SIZE;
4259:

Line 4994: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL, 'handle_category_change called with action:'||p_action

4990: -- Fetch all the distinct category ids that have changed for the items
4991: -- in this batch.
4992:
4993: if ( gChangedCatItemIds.COUNT > 0 ) then
4994: icx_por_ext_utl.debug(icx_por_ext_utl.MUST_LEVEL, 'handle_category_change called with action:'||p_action
4995: ||', gChangedCatItemIds.COUNT:'||to_char(gChangedCatItemIds.COUNT)
4996: ||', gChangedOldCatIds.COUNT:'||to_char(gChangedOldCatIds.COUNT)
4997: ||', gChangedNewCatIds.COUNT:'||to_char(gChangedNewCatIds.COUNT)
4998: ||', gChangedCatActions.COUNT:'||to_char(gChangedCatActions.COUNT));