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_POR_EXT_ITEM dependencies on ICX_POR_EXT_ITEM

Line 1: PACKAGE BODY ICX_POR_EXT_ITEM AS

1: PACKAGE BODY ICX_POR_EXT_ITEM AS
2: /* $Header: ICXEXTIB.pls 120.5 2009/07/27 14:34:59 rojain ship $*/
3:
4: --------------------------------------------------------------
5: -- Global Constants --

Line 1729: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.setActivePriceItemAttributes -'||

1725: ICX_POR_EXT_UTL.extRollback;
1726: IF (cActivePriceItemAttributes%ISOPEN) THEN
1727: CLOSE cActivePriceItemAttributes;
1728: END IF;
1729: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.setActivePriceItemAttributes -'||
1730: xErrLoc||' '||SQLERRM);
1731:
1732: raise ICX_POR_EXT_UTL.gException;
1733:

Line 2030: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.findItemCache-'||

2026:
2027: RETURN FALSE;
2028: EXCEPTION
2029: when others then
2030: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.findItemCache-'||
2031: xErrLoc||' '||SQLERRM);
2032: raise ICX_POR_EXT_UTL.gException;
2033: END findItemCache;
2034:

Line 2057: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.putItemCache-'||

2053: xErrLoc := 200;
2054: gItemCache(pItem.hash_value) := pItem;
2055: EXCEPTION
2056: when others then
2057: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.putItemCache-'||
2058: xErrLoc||' '||SQLERRM);
2059: raise ICX_POR_EXT_UTL.gException;
2060: END putItemCache;
2061:

Line 2137: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

2133: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2134: last_update_date = gUPLastUpdateDates(i),
2135: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2136: -- Bug#3352834
2137: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2138: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2139: program_id = ICX_POR_EXTRACTOR.gProgramId,
2140: program_update_date = SYSDATE
2141: WHERE rowid = gUPPriceRowIds(i);

Line 2177: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

2173: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2174: last_update_date = SYSDATE,
2175: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2176: -- Bug#3352834
2177: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2178: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2179: program_id = ICX_POR_EXTRACTOR.gProgramId,
2180: program_update_date = SYSDATE
2181: WHERE contract_id = gUPGContractIds(i)

Line 2247: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

2243: NULL, ICX_POR_EXTRACTOR.gLoginId,
2244: ICX_POR_EXTRACTOR.gUserId, gIPLastUpdateDates(i),
2245: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2246: -- Bug#3352834
2247: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2248: ICX_POR_EXTRACTOR.gProgramApplicationId,
2249: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2250:
2251: clearTables(xActionMode);

Line 2613: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

2609: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2610: last_update_date = SYSDATE,
2611: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
2612: -- Bug#3352834
2613: request_id = ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2614: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
2615: program_id = ICX_POR_EXTRACTOR.gProgramId,
2616: program_update_date = SYSDATE
2617: WHERE contract_id = gUPGAContractIds(i)

Line 2686: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,

2682: NULL, ICX_POR_EXTRACTOR.gLoginId,
2683: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2684: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
2685: -- Bug#3352834
2686: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID,
2687: ICX_POR_EXTRACTOR.gProgramApplicationId,
2688: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2689:
2690: FORALL i IN 1..gIPGARtItemIds.COUNT

Line 2944: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.processBatchData-'||

2940: when ICX_POR_EXT_UTL.gException then
2941: -- rollback;
2942: ICX_POR_EXT_UTL.extRollback;
2943:
2944: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.processBatchData-'||
2945: xErrLoc);
2946: raise ICX_POR_EXT_UTL.gException;
2947: when others then
2948: -- rollback;

Line 2951: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.processBatchData-'||

2947: when others then
2948: -- rollback;
2949: ICX_POR_EXT_UTL.extRollback;
2950:
2951: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.processBatchData-'||
2952: xErrLoc||' '||SQLERRM);
2953: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xActionMode));
2954: raise ICX_POR_EXT_UTL.gException;
2955: END processBatchData;

Line 2981: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,

2977: xErrLoc := 200;
2978: OPEN xFoundItemCur FOR
2979: SELECT i.rt_item_id,
2980: t.primary_category_id,
2981: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
2982: i.rt_item_id,
2983: gCurrentPrice.template_id) match_template_flag
2984: FROM icx_cat_items_b i,
2985: icx_cat_items_tlp t

Line 3024: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,

3020: xErrLoc := 300;
3021: OPEN xFoundItemCur FOR
3022: SELECT p.rt_item_id,
3023: t.primary_category_id,
3024: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
3025: p.rt_item_id,
3026: gCurrentPrice.template_id) match_template_flag
3027: FROM icx_cat_item_prices p,
3028: icx_cat_items_tlp t

Line 3049: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,

3045: xErrLoc := 400;
3046: OPEN xFoundItemCur FOR
3047: SELECT i.rt_item_id,
3048: t.primary_category_id,
3049: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
3050: i.rt_item_id,
3051: gCurrentPrice.template_id) match_template_flag
3052: FROM icx_cat_items_b i,
3053: icx_cat_items_tlp t

Line 3088: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,

3084: xErrLoc := 500;
3085: OPEN xFoundItemCur FOR
3086: SELECT p.rt_item_id,
3087: t.primary_category_id,
3088: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
3089: p.rt_item_id,
3090: gCurrentPrice.template_id) match_template_flag
3091: FROM icx_cat_item_prices p,
3092: icx_cat_items_tlp t

Line 3205: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-openItemCursor-'||

3201: RETURN xFoundItemCur;
3202:
3203: EXCEPTION
3204: when others then
3205: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-openItemCursor-'||
3206: xErrLoc||' '||SQLERRM);
3207: raise ICX_POR_EXT_UTL.gException;
3208: END openItemCursor;
3209:

Line 3486: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-findItemRecord-'||

3482: when ICX_POR_EXT_UTL.gException then
3483: -- rollback;
3484: ICX_POR_EXT_UTL.extRollback;
3485:
3486: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-findItemRecord-'||
3487: xErrLoc);
3488: raise ICX_POR_EXT_UTL.gException;
3489: when others then
3490: -- rollback;

Line 3493: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-findItemRecord-'||

3489: when others then
3490: -- rollback;
3491: ICX_POR_EXT_UTL.extRollback;
3492:
3493: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-findItemRecord-'||
3494: xErrLoc||' '||SQLERRM);
3495: ICX_POR_EXT_UTL.pushError(snapShotPriceRow);
3496: raise ICX_POR_EXT_UTL.gException;
3497: END findItemRecord;

Line 3577: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemPrices-'||

3573: xErrLoc := 400;
3574: EXCEPTION
3575: when others then
3576: ICX_POR_EXT_UTL.extRollback;
3577: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemPrices-'||
3578: xErrLoc||' '||SQLERRM);
3579: raise ICX_POR_EXT_UTL.gException;
3580: END updateItemPrices;
3581:

Line 3632: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemPrices-'||

3628: xErrLoc := 400;
3629: EXCEPTION
3630: when others then
3631: ICX_POR_EXT_UTL.extRollback;
3632: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemPrices-'||
3633: xErrLoc||' '||SQLERRM);
3634: raise ICX_POR_EXT_UTL.gException;
3635: END insertItemPrices;
3636:

Line 3664: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemsB-'||

3660: xErrLoc := 400;
3661: EXCEPTION
3662: when others then
3663: ICX_POR_EXT_UTL.extRollback;
3664: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemsB-'||
3665: xErrLoc||' '||SQLERRM);
3666: raise ICX_POR_EXT_UTL.gException;
3667: END insertItemsB;
3668:

Line 3686: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemsB-'||

3682: xErrLoc := 400;
3683: EXCEPTION
3684: when others then
3685: ICX_POR_EXT_UTL.extRollback;
3686: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemsB-'||
3687: xErrLoc||' '||SQLERRM);
3688: raise ICX_POR_EXT_UTL.gException;
3689: END updateItemsB;
3690:

Line 3847: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemsTLP-'||

3843: IF (cTranslations%ISOPEN) THEN
3844: CLOSE cTranslations;
3845: END IF;
3846:
3847: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemsTLP-'||
3848: xErrLoc||' '||SQLERRM);
3849: raise ICX_POR_EXT_UTL.gException;
3850: END insertItemsTLP;
3851:

Line 4063: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemsTLP-'||

4059: ICX_POR_EXT_UTL.extRollback;
4060: IF (cTranslations%ISOPEN) THEN
4061: CLOSE cTranslations;
4062: END IF;
4063: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemsTLP-'||
4064: xErrLoc||' '||SQLERRM);
4065: raise ICX_POR_EXT_UTL.gException;
4066: END updateItemsTLP;
4067:

Line 4170: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertExtItemsTLP-'||

4166: IF (cTranslations%ISOPEN) THEN
4167: CLOSE cTranslations;
4168: END IF;
4169:
4170: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertExtItemsTLP-'||
4171: xErrLoc||' '||SQLERRM);
4172: raise ICX_POR_EXT_UTL.gException;
4173: END insertExtItemsTLP;
4174:

Line 4328: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateExtItemsTLP-'||

4324: IF (cTranslations%ISOPEN) THEN
4325: CLOSE cTranslations;
4326: END IF;
4327:
4328: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateExtItemsTLP-'||
4329: xErrLoc||' '||SQLERRM);
4330: raise ICX_POR_EXT_UTL.gException;
4331: END updateExtItemsTLP;
4332:

Line 4356: 'ICX_POR_EXT_ITEM.insertPrimaryCategoryItems-'||

4352: */
4353: EXCEPTION
4354: when others then
4355: ICX_POR_EXT_UTL.pushError(
4356: 'ICX_POR_EXT_ITEM.insertPrimaryCategoryItems-'||
4357: xErrLoc||' '||SQLERRM);
4358: raise ICX_POR_EXT_UTL.gException;
4359: END insertPrimaryCategoryItems;
4360:

Line 4385: 'ICX_POR_EXT_ITEM.updatePrimaryCategoryItems-'||

4381: */
4382: EXCEPTION
4383: when others then
4384: ICX_POR_EXT_UTL.pushError(
4385: 'ICX_POR_EXT_ITEM.updatePrimaryCategoryItems-'||
4386: xErrLoc||' '||SQLERRM);
4387: raise ICX_POR_EXT_UTL.gException;
4388: END updatePrimaryCategoryItems;
4389:

Line 4404: 'ICX_POR_EXT_ITEM.insertTemplateCategoryItems-'||

4400: xErrLoc := 400;
4401: EXCEPTION
4402: when others then
4403: ICX_POR_EXT_UTL.pushError(
4404: 'ICX_POR_EXT_ITEM.insertTemplateCategoryItems-'||
4405: xErrLoc||' '||SQLERRM);
4406: raise ICX_POR_EXT_UTL.gException;
4407: END insertTemplateCategoryItems;
4408:

Line 4419: 'ICX_POR_EXT_ITEM.touchCleanupItem-'||

4415: gCIRtItemIds(xIndex) := pRtItemId;
4416: EXCEPTION
4417: when others then
4418: ICX_POR_EXT_UTL.pushError(
4419: 'ICX_POR_EXT_ITEM.touchCleanupItem-'||
4420: xErrLoc||' '||SQLERRM);
4421: raise ICX_POR_EXT_UTL.gException;
4422: END touchCleanupItem;
4423:

Line 4437: 'ICX_POR_EXT_ITEM.touchUpdatedGA-'||

4433: gUGAContractLineIds(xIndex) := pContractLineId;
4434: EXCEPTION
4435: when others then
4436: ICX_POR_EXT_UTL.pushError(
4437: 'ICX_POR_EXT_ITEM.touchUpdatedGA-'||
4438: xErrLoc||' '||SQLERRM);
4439: raise ICX_POR_EXT_UTL.gException;
4440: END touchUpdatedGA;
4441:

Line 4452: 'ICX_POR_EXT_ITEM.touchRtItemActiveFlag-'||

4448: gTARtItemIds(xIndex) := pRtItemId;
4449: EXCEPTION
4450: when others then
4451: ICX_POR_EXT_UTL.pushError(
4452: 'ICX_POR_EXT_ITEM.touchRtItemActiveFlag-'||
4453: xErrLoc||' '||SQLERRM);
4454: raise ICX_POR_EXT_UTL.gException;
4455: END touchRtItemActiveFlag;
4456:

Line 4472: 'ICX_POR_EXT_ITEM.touchInvItemActiveFlag-'||

4468: END IF;
4469: EXCEPTION
4470: when others then
4471: ICX_POR_EXT_UTL.pushError(
4472: 'ICX_POR_EXT_ITEM.touchInvItemActiveFlag-'||
4473: xErrLoc||' '||SQLERRM);
4474: raise ICX_POR_EXT_UTL.gException;
4475: END touchInvItemActiveFlag;
4476:

Line 4514: 'ICX_POR_EXT_ITEM.deleteItemPrices-'||

4510: EXCEPTION
4511: when others then
4512: ICX_POR_EXT_UTL.extRollback;
4513: ICX_POR_EXT_UTL.pushError(
4514: 'ICX_POR_EXT_ITEM.deleteItemPrices-'||
4515: xErrLoc||' '||SQLERRM);
4516: raise ICX_POR_EXT_UTL.gException;
4517: END deleteItemPrices;
4518:

Line 4555: 'ICX_POR_EXT_ITEM.deleteItem-'||

4551: EXCEPTION
4552: when others then
4553: ICX_POR_EXT_UTL.extRollback;
4554: ICX_POR_EXT_UTL.pushError(
4555: 'ICX_POR_EXT_ITEM.deleteItem-'||
4556: xErrLoc||' '||SQLERRM);
4557: raise ICX_POR_EXT_UTL.gException;
4558: END deleteItem;
4559:

Line 4590: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemPricesGA-'||

4586: xErrLoc := 400;
4587: EXCEPTION
4588: when others then
4589: ICX_POR_EXT_UTL.extRollback;
4590: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updateItemPricesGA-'||
4591: xErrLoc||' '||SQLERRM);
4592: raise ICX_POR_EXT_UTL.gException;
4593: END updateItemPricesGA;
4594:

Line 4640: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemPricesGA-'||

4636: xErrLoc := 400;
4637: EXCEPTION
4638: when others then
4639: ICX_POR_EXT_UTL.extRollback;
4640: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.insertItemPricesGA-'||
4641: xErrLoc||' '||SQLERRM);
4642: raise ICX_POR_EXT_UTL.gException;
4643: END insertItemPricesGA;
4644:

Line 4665: 'ICX_POR_EXT_ITEM.setLocalRtItemId-'||

4661: EXCEPTION
4662: when others then
4663: ICX_POR_EXT_UTL.extRollback;
4664: ICX_POR_EXT_UTL.pushError(
4665: 'ICX_POR_EXT_ITEM.setLocalRtItemId-'||
4666: xErrLoc||' '||SQLERRM);
4667: raise ICX_POR_EXT_UTL.gException;
4668: END setLocalRtItemId;
4669:

Line 4993: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-processPriceRow-'||

4989: when ICX_POR_EXT_UTL.gException then
4990: -- rollback;
4991: ICX_POR_EXT_UTL.extRollback;
4992:
4993: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-processPriceRow-'||
4994: xErrLoc);
4995: raise ICX_POR_EXT_UTL.gException;
4996: when others then
4997: -- rollback;

Line 5000: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-processPriceRow-'||

4996: when others then
4997: -- rollback;
4998: ICX_POR_EXT_UTL.extRollback;
4999:
5000: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM-processPriceRow-'||
5001: xErrLoc||' '||SQLERRM);
5002: ICX_POR_EXT_UTL.pushError(snapShotPriceRow);
5003: raise ICX_POR_EXT_UTL.gException;
5004: END processPriceRow;

Line 5385: 'ICX_POR_EXT_ITEM.extractPriceRows-'||xErrLoc ||

5381: EXCEPTION
5382: when snap_shot_too_old then
5383: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
5384: 'ORA-01555: snapshot too old: caught at '||
5385: 'ICX_POR_EXT_ITEM.extractPriceRows-'||xErrLoc ||
5386: ', Total processed price rows: ' || gPriceRowCount ||
5387: ', SQLERRM:' ||SQLERRM ||
5388: '; so close the cursor and reopen the cursor-');
5389: xErrLoc := 283;

Line 5424: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractPriceRows-'||

5420: IF (cUpdatedPriceRows%ISOPEN) THEN
5421: CLOSE cUpdatedPriceRows;
5422: END IF;
5423:
5424: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractPriceRows-'||
5425: xErrLoc);
5426: raise ICX_POR_EXT_UTL.gException;
5427: when others then
5428: ICX_POR_EXT_UTL.extRollback;

Line 5432: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractPriceRows-'||

5428: ICX_POR_EXT_UTL.extRollback;
5429: IF (cUpdatedPriceRows%ISOPEN) THEN
5430: CLOSE cUpdatedPriceRows;
5431: END IF;
5432: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractPriceRows-'||
5433: xErrLoc||
5434: ', Total processed price rows: ' || gPriceRowCount ||' '||SQLERRM);
5435:
5436: raise ICX_POR_EXT_UTL.gException;

Line 5525: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.getRate-' || xErrLoc);

5521: ', and the Daily Rate is not defined between ' || x_from_currency ||
5522: ' and ' || l_to_currency || ' for ' || l_user_conv_type || '. Please ' ||
5523: 'specify the daily rate value and re-run the Extraction Process.');
5524:
5525: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.getRate-' || xErrLoc);
5526: raise ICX_POR_EXT_UTL.gException;
5527:
5528: when others then
5529: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.getRate-' || xErrLoc);

Line 5529: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.getRate-' || xErrLoc);

5525: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.getRate-' || xErrLoc);
5526: raise ICX_POR_EXT_UTL.gException;
5527:
5528: when others then
5529: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.getRate-' || xErrLoc);
5530: raise ICX_POR_EXT_UTL.gException;
5531: END getRate;
5532:
5533: -- Open item prices cursor

Line 5559: xTmpReqId := ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;

5555: xErrLoc := 100;
5556:
5557: -- Bug#3352834
5558: IF (pType = 'TEMPLATE') THEN
5559: xTmpReqId := ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;
5560: ELSIF (pType = 'CONTRACT') THEN
5561: xTmpReqId := ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
5562: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
5563: xTmpReqId := ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;

Line 5561: xTmpReqId := ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;

5557: -- Bug#3352834
5558: IF (pType = 'TEMPLATE') THEN
5559: xTmpReqId := ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;
5560: ELSIF (pType = 'CONTRACT') THEN
5561: xTmpReqId := ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
5562: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
5563: xTmpReqId := ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
5564: ELSIF (pType = 'ASL') THEN
5565: xTmpReqId := ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;

Line 5563: xTmpReqId := ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;

5559: xTmpReqId := ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;
5560: ELSIF (pType = 'CONTRACT') THEN
5561: xTmpReqId := ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
5562: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
5563: xTmpReqId := ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
5564: ELSIF (pType = 'ASL') THEN
5565: xTmpReqId := ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
5566: ELSIF (pType = 'ITEM') THEN
5567: xTmpReqId := ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;

Line 5565: xTmpReqId := ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;

5561: xTmpReqId := ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
5562: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
5563: xTmpReqId := ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
5564: ELSIF (pType = 'ASL') THEN
5565: xTmpReqId := ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
5566: ELSIF (pType = 'ITEM') THEN
5567: xTmpReqId := ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;
5568: END IF;
5569:

Line 5567: xTmpReqId := ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;

5563: xTmpReqId := ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
5564: ELSIF (pType = 'ASL') THEN
5565: xTmpReqId := ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
5566: ELSIF (pType = 'ITEM') THEN
5567: xTmpReqId := ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;
5568: END IF;
5569:
5570:
5571: xErrLoc := 125;

Line 5614: ', ICX_POR_EXT_ITEM.getItemActiveFlag(doc.internal_item_id, doc.org_id), ' ||

5610: -- inventory_item_id + org_id, not rt_item_id
5611: IF pType = 'ITEM' THEN
5612: xSelectStr := xSelectStr ||
5613: 'DECODE(doc.status, ' || ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT ||
5614: ', ICX_POR_EXT_ITEM.getItemActiveFlag(doc.internal_item_id, doc.org_id), ' ||
5615: 'NULL) active_flag, ';
5616: ELSE
5617: xSelectStr := xSelectStr ||
5618: 'p.active_flag active_flag, ';

Line 5642: 'ICX_POR_EXT_ITEM.getItemSourceType(DECODE(prl.source_type_code, ''VENDOR'', '||

5638: 'TO_CHAR('||NULL_NUMBER||')) supplier_part_num, '||
5639: 'NVL(prl.item_id, '||NULL_NUMBER||') internal_item_id, '||
5640: 'mi.concatenated_segments internal_item_num, '||
5641: 'mi.organization_id inventory_organization_id, '||
5642: 'ICX_POR_EXT_ITEM.getItemSourceType(DECODE(prl.source_type_code, ''VENDOR'', '||
5643: '''TEMPLATE'', ''INTERNAL_TEMPLATE''), prl.item_id, ' ||
5644: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
5645: 'mi.list_price_per_unit, l.load_item_master, ' ||
5646: 'mi.internal_order_enabled_flag, l.load_internal_item) item_source_type, ' ||

Line 5647: 'ICX_POR_EXT_ITEM.getSearchType(DECODE(prl.source_type_code, ''VENDOR'', '||

5643: '''TEMPLATE'', ''INTERNAL_TEMPLATE''), prl.item_id, ' ||
5644: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
5645: 'mi.list_price_per_unit, l.load_item_master, ' ||
5646: 'mi.internal_order_enabled_flag, l.load_internal_item) item_source_type, ' ||
5647: 'ICX_POR_EXT_ITEM.getSearchType(DECODE(prl.source_type_code, ''VENDOR'', '||
5648: '''TEMPLATE'', ''INTERNAL_TEMPLATE''), prl.item_id, ' ||
5649: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
5650: 'mi.list_price_per_unit, l.load_item_master, ' ||
5651: 'mi.internal_order_enabled_flag, l.load_internal_item) item_search_type, ' ||

Line 5831: 'ICX_POR_EXT_ITEM.getItemSourceType(''CONTRACT'', pl.item_id, ' ||

5827: ')) supplier_part_num, '||
5828: 'NVL(pl.item_id, '||NULL_NUMBER||') internal_item_id, '||
5829: 'mi.concatenated_segments internal_item_num, '||
5830: 'mi.organization_id inventory_organization_id, '||
5831: 'ICX_POR_EXT_ITEM.getItemSourceType(''CONTRACT'', pl.item_id, ' ||
5832: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
5833: 'mi.list_price_per_unit, l.load_item_master, ' ||
5834: 'mi.internal_order_enabled_flag, l.load_internal_item) item_source_type, ' ||
5835: '''SUPPLIER'' item_search_type, '||

Line 5941: '''Y'', ICX_POR_EXT_ITEM.getRate(fsp.set_of_books_id, '||

5937: xViewStr := xViewStr ||
5938: -- 'ph.rate, '||
5939: 'DECODE(NVL(ph.global_agreement_flag, ''N''), '||
5940: '''N'', ph.rate, ' ||
5941: '''Y'', ICX_POR_EXT_ITEM.getRate(fsp.set_of_books_id, '||
5942: 'ph.currency_code, '||
5943: 'sysdate, '||
5944: 'icx_psp.default_rate_type, '||
5945: 't.purchasing_org_id, '||

Line 6115: 'ICX_POR_EXT_ITEM.getItemSourceType(''ASL'', pasl.item_id, ' ||

6111: ')) supplier_part_num, '||
6112: 'pasl.item_id internal_item_id, '||
6113: 'mi.concatenated_segments internal_item_num, '||
6114: 'mi.organization_id inventory_organization_id, '||
6115: 'ICX_POR_EXT_ITEM.getItemSourceType(''ASL'', pasl.item_id, ' ||
6116: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
6117: 'mi.list_price_per_unit, l.load_item_master, ' ||
6118: 'mi.internal_order_enabled_flag, l.load_internal_item) item_source_type, ' ||
6119: '''SUPPLIER'' item_search_type, '||

Line 6220: 'ICX_POR_EXT_ITEM.getItemSourceType(type.price_type, mi.inventory_item_id, ' ||

6216: 'TO_CHAR('||NULL_NUMBER||') supplier_part_num, '||
6217: 'mi.inventory_item_id internal_item_id, '||
6218: 'mi.concatenated_segments internal_item_num, '||
6219: 'mi.organization_id inventory_organization_id, '||
6220: 'ICX_POR_EXT_ITEM.getItemSourceType(type.price_type, mi.inventory_item_id, ' ||
6221: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
6222: 'mi.list_price_per_unit, l.load_item_master, ' ||
6223: 'mi.internal_order_enabled_flag, l.load_internal_item) item_source_type, ' ||
6224: 'ICX_POR_EXT_ITEM.getSearchType(type.price_type, mi.inventory_item_id, ' ||

Line 6224: 'ICX_POR_EXT_ITEM.getSearchType(type.price_type, mi.inventory_item_id, ' ||

6220: 'ICX_POR_EXT_ITEM.getItemSourceType(type.price_type, mi.inventory_item_id, ' ||
6221: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
6222: 'mi.list_price_per_unit, l.load_item_master, ' ||
6223: 'mi.internal_order_enabled_flag, l.load_internal_item) item_source_type, ' ||
6224: 'ICX_POR_EXT_ITEM.getSearchType(type.price_type, mi.inventory_item_id, ' ||
6225: 'mi.purchasing_enabled_flag, mi.outside_operation_flag, ' ||
6226: 'mi.list_price_per_unit, l.load_item_master, ' ||
6227: 'mi.internal_order_enabled_flag, l.load_internal_item) item_search_type, ' ||
6228: 'mic.category_id mtl_category_id, '||

Line 6413: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||

6409:
6410: -- Bug#3352834
6411: xErrLoc := 500;
6412: xWhereStr := xWhereStr ||
6413: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||
6414: ') <> ' || xTmpReqId;
6415:
6416: xErrLoc := 510;
6417: --Bug#3277977

Line 6537: 'ICX_POR_EXT_ITEM.getRate(fsp.set_of_books_id, '||

6533: * Enabled Org for calculation of Rate and Functional Price.
6534: */
6535: 'icx_psp.default_rate_type rate_type, '||
6536: 'sysdate rate_date, '||
6537: 'ICX_POR_EXT_ITEM.getRate(fsp.set_of_books_id, '||
6538: 'ip.currency, '||
6539: 'sysdate, '||
6540: 'icx_psp.default_rate_type, ' ||
6541: 't.purchasing_org_id, '||

Line 6719: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||

6715:
6716: -- Bug#3352834
6717: xErrLoc := 700;
6718: xWhereStr := xWhereStr ||
6719: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||
6720: ') <> ' || xTmpReqId;
6721: xString := xString ||
6722: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||
6723: ') <> ' || xTmpReqId;

Line 6722: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||

6718: xWhereStr := xWhereStr ||
6719: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||
6720: ') <> ' || xTmpReqId;
6721: xString := xString ||
6722: ' AND nvl(p.request_id, ' || ICX_POR_EXT_ITEM.NEW_PRICE_TEMP_REQUEST_ID ||
6723: ') <> ' || xTmpReqId;
6724:
6725: xErrLoc := 725;
6726: --Bug#3277977

Line 6748: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.openPriceCursor-'||

6744: when ICX_POR_EXT_UTL.gException then
6745: -- rollback;
6746: ICX_POR_EXT_UTL.extRollback;
6747:
6748: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.openPriceCursor-'||
6749: xErrLoc);
6750: raise ICX_POR_EXT_UTL.gException;
6751: when others then
6752: -- rollback;

Line 6754: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.openPriceCursor-'||

6750: raise ICX_POR_EXT_UTL.gException;
6751: when others then
6752: -- rollback;
6753: ICX_POR_EXT_UTL.extRollback;
6754: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.openPriceCursor-'||
6755: xErrLoc||' '||SQLERRM);
6756: raise ICX_POR_EXT_UTL.gException;
6757: END openPriceCursor;
6758:

Line 7044: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractVendorNames-'||

7040:
7041: IF (cUpdatedVendorNames%ISOPEN) THEN
7042: CLOSE cUpdatedVendorNames;
7043: END IF;
7044: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractVendorNames-'||
7045: xErrLoc);
7046: raise ICX_POR_EXT_UTL.gException;
7047: when others then
7048: ICX_POR_EXT_UTL.extRollback;

Line 7050: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractVendorNames-'||

7046: raise ICX_POR_EXT_UTL.gException;
7047: when others then
7048: ICX_POR_EXT_UTL.extRollback;
7049:
7050: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractVendorNames-'||
7051: xErrLoc||' '||SQLERRM);
7052:
7053: raise ICX_POR_EXT_UTL.gException;
7054: END extractVendorNames;

Line 7078: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.truncateTempTable-'||

7074: xErrLoc := 300;
7075: EXCEPTION
7076: when others then
7077: ICX_POR_EXT_UTL.extRollback;
7078: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.truncateTempTable-'||
7079: xErrLoc||' '||SQLERRM);
7080: raise ICX_POR_EXT_UTL.gException;
7081: END truncateTempTable;
7082:

Line 7157: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupItems-'||

7153:
7154: IF (cItemNoPrices%ISOPEN) THEN
7155: CLOSE cItemNoPrices;
7156: END IF;
7157: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupItems-'||
7158: xErrLoc);
7159: raise ICX_POR_EXT_UTL.gException;
7160: when others then
7161: ICX_POR_EXT_UTL.extRollback;

Line 7165: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupItems-'||

7161: ICX_POR_EXT_UTL.extRollback;
7162: IF (cItemNoPrices%ISOPEN) THEN
7163: CLOSE cItemNoPrices;
7164: END IF;
7165: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupItems-'||
7166: xErrLoc||' '||SQLERRM);
7167:
7168: raise ICX_POR_EXT_UTL.gException;
7169: END cleanupItems;

Line 7187: ICX_POR_EXT_ITEM.getActiveFlag(p.price_type, p.rowid) active_flag

7183: CURSOR cActiveFlagPrices IS
7184: SELECT p.price_type,
7185: p.rt_item_id,
7186: p.rowid price_rowid,
7187: ICX_POR_EXT_ITEM.getActiveFlag(p.price_type, p.rowid) active_flag
7188: FROM icx_cat_item_prices p,
7189: icx_cat_extract_gt i
7190: WHERE i.type = 'ACTIVE_FLAG'
7191: AND p.rt_item_id = i.rt_item_id

Line 7193: AND nvl(p.request_id, ICX_POR_EXT_ITEM.AF_NEW_PRICE_TEMP_REQUEST_ID) <>

7189: icx_cat_extract_gt i
7190: WHERE i.type = 'ACTIVE_FLAG'
7191: AND p.rt_item_id = i.rt_item_id
7192: AND p.price_type <> 'GLOBAL_AGREEMENT'
7193: AND nvl(p.request_id, ICX_POR_EXT_ITEM.AF_NEW_PRICE_TEMP_REQUEST_ID) <>
7194: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID; -- Bug # 3542291
7195: BEGIN
7196: xErrLoc := 100;
7197: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

Line 7194: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID; -- Bug # 3542291

7190: WHERE i.type = 'ACTIVE_FLAG'
7191: AND p.rt_item_id = i.rt_item_id
7192: AND p.price_type <> 'GLOBAL_AGREEMENT'
7193: AND nvl(p.request_id, ICX_POR_EXT_ITEM.AF_NEW_PRICE_TEMP_REQUEST_ID) <>
7194: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID; -- Bug # 3542291
7195: BEGIN
7196: xErrLoc := 100;
7197: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
7198: 'Set active flags.');

Line 7240: request_id = ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID,

7236: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
7237: last_update_date = SYSDATE,
7238: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
7239: -- Bug # 3542291
7240: request_id = ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID,
7241: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
7242: program_id = ICX_POR_EXTRACTOR.gProgramId,
7243: program_update_date = SYSDATE
7244: WHERE rowid = gSARowIds(i);

Line 7252: 'ICX_POR_EXT_ITEM.setActiveFlags-'||xErrLoc ||

7248: EXCEPTION
7249: when snap_shot_too_old then
7250: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
7251: 'ORA-01555: snapshot too old: caught at '||
7252: 'ICX_POR_EXT_ITEM.setActiveFlags-'||xErrLoc ||
7253: ', Total processed rows to set active flag: ' || xRowCount ||
7254: ', SQLERRM:' ||SQLERRM ||
7255: '; so close the cursor and reopen the cursor-');
7256: xErrLoc := 440;

Line 7283: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.setActiveFlags-'||

7279:
7280: IF (cActiveFlagPrices%ISOPEN) THEN
7281: CLOSE cActiveFlagPrices;
7282: END IF;
7283: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.setActiveFlags-'||
7284: xErrLoc);
7285: raise ICX_POR_EXT_UTL.gException;
7286: when others then
7287: ICX_POR_EXT_UTL.extRollback;

Line 7291: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.setActiveFlags-'||

7287: ICX_POR_EXT_UTL.extRollback;
7288: IF (cActiveFlagPrices%ISOPEN) THEN
7289: CLOSE cActiveFlagPrices;
7290: END IF;
7291: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.setActiveFlags-'||
7292: xErrLoc||' '||SQLERRM);
7293:
7294: raise ICX_POR_EXT_UTL.gException;
7295: END setActiveFlags;

Line 7316: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

7312:
7313: -- Bug#3352834
7314: xErrLoc := 120;
7315: IF (pType = 'TEMPLATE') THEN
7316: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7317: ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;
7318: -- Bug # 3542291
7319: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;

Line 7317: ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;

7313: -- Bug#3352834
7314: xErrLoc := 120;
7315: IF (pType = 'TEMPLATE') THEN
7316: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7317: ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;
7318: -- Bug # 3542291
7319: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;
7321: ELSIF (pType = 'CONTRACT') THEN

Line 7319: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

7315: IF (pType = 'TEMPLATE') THEN
7316: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7317: ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;
7318: -- Bug # 3542291
7319: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;
7321: ELSIF (pType = 'CONTRACT') THEN
7322: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;

Line 7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;

7316: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7317: ICX_POR_EXT_ITEM.TEMPLATE_TEMP_REQUEST_ID;
7318: -- Bug # 3542291
7319: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;
7321: ELSIF (pType = 'CONTRACT') THEN
7322: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

Line 7322: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

7318: -- Bug # 3542291
7319: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;
7321: ELSIF (pType = 'CONTRACT') THEN
7322: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;
7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN

Line 7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;

7319: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;
7321: ELSIF (pType = 'CONTRACT') THEN
7322: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;
7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

Line 7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

7320: ICX_POR_EXT_ITEM.AF_TEMPLATE_TEMP_REQUEST_ID;
7321: ELSIF (pType = 'CONTRACT') THEN
7322: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;
7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;

Line 7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;

7321: ELSIF (pType = 'CONTRACT') THEN
7322: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;
7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

Line 7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

7323: ICX_POR_EXT_ITEM.CONTRACT_TEMP_REQUEST_ID;
7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;
7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;
7331: ELSIF (pType = 'ASL') THEN

Line 7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;

7324: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;
7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;
7331: ELSIF (pType = 'ASL') THEN
7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

Line 7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

7325: ICX_POR_EXT_ITEM.AF_CONTRACT_TEMP_REQUEST_ID;
7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;
7331: ELSIF (pType = 'ASL') THEN
7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;

Line 7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;

7326: ELSIF (pType = 'GLOBAL_AGREEMENT') THEN
7327: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;
7331: ELSIF (pType = 'ASL') THEN
7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

Line 7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

7328: ICX_POR_EXT_ITEM.GA_TEMP_REQUEST_ID;
7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;
7331: ELSIF (pType = 'ASL') THEN
7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;
7336: ELSIF (pType = 'ITEM') THEN

Line 7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;

7329: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;
7331: ELSIF (pType = 'ASL') THEN
7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;
7336: ELSIF (pType = 'ITEM') THEN
7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

Line 7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

7330: ICX_POR_EXT_ITEM.AF_GA_TEMP_REQUEST_ID;
7331: ELSIF (pType = 'ASL') THEN
7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;
7336: ELSIF (pType = 'ITEM') THEN
7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7338: ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;

Line 7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;

7331: ELSIF (pType = 'ASL') THEN
7332: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;
7336: ELSIF (pType = 'ITEM') THEN
7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7338: ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;
7339: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

Line 7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=

7333: ICX_POR_EXT_ITEM.ASL_TEMP_REQUEST_ID;
7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;
7336: ELSIF (pType = 'ITEM') THEN
7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7338: ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;
7339: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7340: ICX_POR_EXT_ITEM.AF_ITEM_TEMP_REQUEST_ID;
7341: END IF;

Line 7338: ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;

7334: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;
7336: ELSIF (pType = 'ITEM') THEN
7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7338: ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;
7339: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7340: ICX_POR_EXT_ITEM.AF_ITEM_TEMP_REQUEST_ID;
7341: END IF;
7342:

Line 7339: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

7335: ICX_POR_EXT_ITEM.AF_ASL_TEMP_REQUEST_ID;
7336: ELSIF (pType = 'ITEM') THEN
7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7338: ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;
7339: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7340: ICX_POR_EXT_ITEM.AF_ITEM_TEMP_REQUEST_ID;
7341: END IF;
7342:
7343:

Line 7340: ICX_POR_EXT_ITEM.AF_ITEM_TEMP_REQUEST_ID;

7336: ELSIF (pType = 'ITEM') THEN
7337: ICX_POR_EXT_ITEM.CURRENT_REQUEST_ID :=
7338: ICX_POR_EXT_ITEM.ITEM_TEMP_REQUEST_ID;
7339: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7340: ICX_POR_EXT_ITEM.AF_ITEM_TEMP_REQUEST_ID;
7341: END IF;
7342:
7343:
7344: xErrLoc := 130;

Line 7364: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.processItemData-'||

7360: ICX_POR_EXT_UTL.extRollback;
7361: IF (cPriceRows%ISOPEN) THEN
7362: CLOSE cPriceRows;
7363: END IF;
7364: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.processItemData-'||
7365: xErrLoc||' '||SQLERRM);
7366: raise ICX_POR_EXT_UTL.gException;
7367: END processItemData;
7368:

Line 7515: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=

7511: xErrLoc := 420;
7512: cleanupItems;
7513: xErrLoc := 440;
7514: -- Bug # 3542291
7515: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7516: ICX_POR_EXT_ITEM.AF_CLEANUP_TEMP_REQUEST_ID;
7517: setActiveFlags;
7518: xErrLoc := 460;
7519: truncateTempTable('NOGA');

Line 7516: ICX_POR_EXT_ITEM.AF_CLEANUP_TEMP_REQUEST_ID;

7512: cleanupItems;
7513: xErrLoc := 440;
7514: -- Bug # 3542291
7515: ICX_POR_EXT_ITEM.AF_CURRENT_REQUEST_ID :=
7516: ICX_POR_EXT_ITEM.AF_CLEANUP_TEMP_REQUEST_ID;
7517: setActiveFlags;
7518: xErrLoc := 460;
7519: truncateTempTable('NOGA');
7520: xErrLoc := 500;

Line 7528: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupPrices-'||

7524:
7525: IF (cInvalidPrices%ISOPEN) THEN
7526: CLOSE cInvalidPrices;
7527: END IF;
7528: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupPrices-'||
7529: xErrLoc);
7530: raise ICX_POR_EXT_UTL.gException;
7531: when others then
7532: ICX_POR_EXT_UTL.extRollback;

Line 7536: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupPrices-'||

7532: ICX_POR_EXT_UTL.extRollback;
7533: IF (cInvalidPrices%ISOPEN) THEN
7534: CLOSE cInvalidPrices;
7535: END IF;
7536: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.cleanupPrices-'||
7537: xErrLoc||' '||SQLERRM);
7538:
7539: raise ICX_POR_EXT_UTL.gException;
7540: END cleanupPrices;

Line 7625: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractItemData-'||

7621: when others then
7622: ICX_POR_EXT_UTL.extRollback;
7623: updatePriceRequestIds;
7624: truncateTempTable('ALL');
7625: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.extractItemData-'||
7626: xErrLoc||' '||SQLERRM);
7627: raise ICX_POR_EXT_UTL.gException;
7628: END extractItemData;
7629:

Line 7659: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updatePriceRequestIds -'||

7655: EXCEPTION
7656: when others then
7657: ICX_POR_EXT_UTL.extRollback;
7658:
7659: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.updatePriceRequestIds -'||
7660: xErrLoc||' '||SQLERRM);
7661:
7662: raise ICX_POR_EXT_UTL.gException;
7663: END updatePriceRequestIds;

Line 7665: END ICX_POR_EXT_ITEM;

7661:
7662: raise ICX_POR_EXT_UTL.gException;
7663: END updatePriceRequestIds;
7664:
7665: END ICX_POR_EXT_ITEM;