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_FPI_UPGRADE dependencies on ICX_POR_EXT_UTL

Line 35: gLogLevel PLS_INTEGER := ICX_POR_EXT_UTL.DEBUG_LEVEL;

31: -- Dynamic SQL to update ICX_CAT_ITEMS_TLP, ICX_CAT_EXT_ITEMS_TLP
32: gDynSqlBaseAttributes VARCHAR2(4000);
33: gDynSqlCatAttributes VARCHAR2(4000);
34: gReturnErr VARCHAR2(4000) := NULL;
35: gLogLevel PLS_INTEGER := ICX_POR_EXT_UTL.DEBUG_LEVEL;
36: gLogFile VARCHAR2(200) := 'icxupgfi.log';
37: gCommitSize PLS_INTEGER := 2000;
38: gContinueExtItemTlp BOOLEAN := FALSE;
39:

Line 149: ICX_POR_EXT_UTL.getTableElement(gIRtItemIds, pIndex) || ', ';

145: xShot VARCHAR2(2000) := 'Snap Shot('||pMode||')['||pIndex||']--';
146: BEGIN
147: IF pMode = 'ITEM' THEN
148: xShot := xShot || ' gIRtItemIds: ' ||
149: ICX_POR_EXT_UTL.getTableElement(gIRtItemIds, pIndex) || ', ';
150: xShot := xShot || ' gIOldRtItemIds: ' ||
151: ICX_POR_EXT_UTL.getTableElement(gIOldRtItemIds, pIndex) || ', ';
152: xShot := xShot || ' gIOrgIds: ' ||
153: ICX_POR_EXT_UTL.getTableElement(gIOrgIds, pIndex) || ', ';

Line 151: ICX_POR_EXT_UTL.getTableElement(gIOldRtItemIds, pIndex) || ', ';

147: IF pMode = 'ITEM' THEN
148: xShot := xShot || ' gIRtItemIds: ' ||
149: ICX_POR_EXT_UTL.getTableElement(gIRtItemIds, pIndex) || ', ';
150: xShot := xShot || ' gIOldRtItemIds: ' ||
151: ICX_POR_EXT_UTL.getTableElement(gIOldRtItemIds, pIndex) || ', ';
152: xShot := xShot || ' gIOrgIds: ' ||
153: ICX_POR_EXT_UTL.getTableElement(gIOrgIds, pIndex) || ', ';
154: xShot := xShot || ' gISupplierPartNums: ' ||
155: ICX_POR_EXT_UTL.getTableElement(gISupplierPartNums, pIndex) || ', ';

Line 153: ICX_POR_EXT_UTL.getTableElement(gIOrgIds, pIndex) || ', ';

149: ICX_POR_EXT_UTL.getTableElement(gIRtItemIds, pIndex) || ', ';
150: xShot := xShot || ' gIOldRtItemIds: ' ||
151: ICX_POR_EXT_UTL.getTableElement(gIOldRtItemIds, pIndex) || ', ';
152: xShot := xShot || ' gIOrgIds: ' ||
153: ICX_POR_EXT_UTL.getTableElement(gIOrgIds, pIndex) || ', ';
154: xShot := xShot || ' gISupplierPartNums: ' ||
155: ICX_POR_EXT_UTL.getTableElement(gISupplierPartNums, pIndex) || ', ';
156: xShot := xShot || ' gIRtCategoryIds: ' ||
157: ICX_POR_EXT_UTL.getTableElement(gIRtCategoryIds, pIndex) || ', ';

Line 155: ICX_POR_EXT_UTL.getTableElement(gISupplierPartNums, pIndex) || ', ';

151: ICX_POR_EXT_UTL.getTableElement(gIOldRtItemIds, pIndex) || ', ';
152: xShot := xShot || ' gIOrgIds: ' ||
153: ICX_POR_EXT_UTL.getTableElement(gIOrgIds, pIndex) || ', ';
154: xShot := xShot || ' gISupplierPartNums: ' ||
155: ICX_POR_EXT_UTL.getTableElement(gISupplierPartNums, pIndex) || ', ';
156: xShot := xShot || ' gIRtCategoryIds: ' ||
157: ICX_POR_EXT_UTL.getTableElement(gIRtCategoryIds, pIndex) || ', ';
158: xShot := xShot || ' gIExtractorUpdatedFlags: ' ||
159: ICX_POR_EXT_UTL.getTableElement(gIExtractorUpdatedFlags, pIndex);

Line 157: ICX_POR_EXT_UTL.getTableElement(gIRtCategoryIds, pIndex) || ', ';

153: ICX_POR_EXT_UTL.getTableElement(gIOrgIds, pIndex) || ', ';
154: xShot := xShot || ' gISupplierPartNums: ' ||
155: ICX_POR_EXT_UTL.getTableElement(gISupplierPartNums, pIndex) || ', ';
156: xShot := xShot || ' gIRtCategoryIds: ' ||
157: ICX_POR_EXT_UTL.getTableElement(gIRtCategoryIds, pIndex) || ', ';
158: xShot := xShot || ' gIExtractorUpdatedFlags: ' ||
159: ICX_POR_EXT_UTL.getTableElement(gIExtractorUpdatedFlags, pIndex);
160: ELSIF pMode = 'TLP' THEN
161: xShot := xShot || ' gITRtItemIds: ' ||

Line 159: ICX_POR_EXT_UTL.getTableElement(gIExtractorUpdatedFlags, pIndex);

155: ICX_POR_EXT_UTL.getTableElement(gISupplierPartNums, pIndex) || ', ';
156: xShot := xShot || ' gIRtCategoryIds: ' ||
157: ICX_POR_EXT_UTL.getTableElement(gIRtCategoryIds, pIndex) || ', ';
158: xShot := xShot || ' gIExtractorUpdatedFlags: ' ||
159: ICX_POR_EXT_UTL.getTableElement(gIExtractorUpdatedFlags, pIndex);
160: ELSIF pMode = 'TLP' THEN
161: xShot := xShot || ' gITRtItemIds: ' ||
162: ICX_POR_EXT_UTL.getTableElement(gITRtItemIds, pIndex) || ', ';
163: xShot := xShot || ' gITItemDescriptions: ' ||

Line 162: ICX_POR_EXT_UTL.getTableElement(gITRtItemIds, pIndex) || ', ';

158: xShot := xShot || ' gIExtractorUpdatedFlags: ' ||
159: ICX_POR_EXT_UTL.getTableElement(gIExtractorUpdatedFlags, pIndex);
160: ELSIF pMode = 'TLP' THEN
161: xShot := xShot || ' gITRtItemIds: ' ||
162: ICX_POR_EXT_UTL.getTableElement(gITRtItemIds, pIndex) || ', ';
163: xShot := xShot || ' gITItemDescriptions: ' ||
164: ICX_POR_EXT_UTL.getTableElement(gITItemDescriptions, pIndex);
165: ELSIF pMode = 'CAT_ITEM' THEN
166: xShot := xShot || ' gCIRtItemIds: ' ||

Line 164: ICX_POR_EXT_UTL.getTableElement(gITItemDescriptions, pIndex);

160: ELSIF pMode = 'TLP' THEN
161: xShot := xShot || ' gITRtItemIds: ' ||
162: ICX_POR_EXT_UTL.getTableElement(gITRtItemIds, pIndex) || ', ';
163: xShot := xShot || ' gITItemDescriptions: ' ||
164: ICX_POR_EXT_UTL.getTableElement(gITItemDescriptions, pIndex);
165: ELSIF pMode = 'CAT_ITEM' THEN
166: xShot := xShot || ' gCIRtItemIds: ' ||
167: ICX_POR_EXT_UTL.getTableElement(gCIRtItemIds, pIndex) || ', ';
168: xShot := xShot || ' gCITemplateIds: ' ||

Line 167: ICX_POR_EXT_UTL.getTableElement(gCIRtItemIds, pIndex) || ', ';

163: xShot := xShot || ' gITItemDescriptions: ' ||
164: ICX_POR_EXT_UTL.getTableElement(gITItemDescriptions, pIndex);
165: ELSIF pMode = 'CAT_ITEM' THEN
166: xShot := xShot || ' gCIRtItemIds: ' ||
167: ICX_POR_EXT_UTL.getTableElement(gCIRtItemIds, pIndex) || ', ';
168: xShot := xShot || ' gCITemplateIds: ' ||
169: ICX_POR_EXT_UTL.getTableElement(gCITemplateIds, pIndex);
170: ELSIF pMode = 'EXTRACTED_PRICE' THEN
171: xShot := xShot || ' gEPRtItemIds: ' ||

Line 169: ICX_POR_EXT_UTL.getTableElement(gCITemplateIds, pIndex);

165: ELSIF pMode = 'CAT_ITEM' THEN
166: xShot := xShot || ' gCIRtItemIds: ' ||
167: ICX_POR_EXT_UTL.getTableElement(gCIRtItemIds, pIndex) || ', ';
168: xShot := xShot || ' gCITemplateIds: ' ||
169: ICX_POR_EXT_UTL.getTableElement(gCITemplateIds, pIndex);
170: ELSIF pMode = 'EXTRACTED_PRICE' THEN
171: xShot := xShot || ' gEPRtItemIds: ' ||
172: ICX_POR_EXT_UTL.getTableElement(gEPRtItemIds, pIndex) || ', ';
173: xShot := xShot || ' gEPActiveFlags: ' ||

Line 172: ICX_POR_EXT_UTL.getTableElement(gEPRtItemIds, pIndex) || ', ';

168: xShot := xShot || ' gCITemplateIds: ' ||
169: ICX_POR_EXT_UTL.getTableElement(gCITemplateIds, pIndex);
170: ELSIF pMode = 'EXTRACTED_PRICE' THEN
171: xShot := xShot || ' gEPRtItemIds: ' ||
172: ICX_POR_EXT_UTL.getTableElement(gEPRtItemIds, pIndex) || ', ';
173: xShot := xShot || ' gEPActiveFlags: ' ||
174: ICX_POR_EXT_UTL.getTableElement(gEPActiveFlags, pIndex) || ', ';
175: xShot := xShot || ' gEPOrgIds: ' ||
176: ICX_POR_EXT_UTL.getTableElement(gEPOrgIds, pIndex) || ', ';

Line 174: ICX_POR_EXT_UTL.getTableElement(gEPActiveFlags, pIndex) || ', ';

170: ELSIF pMode = 'EXTRACTED_PRICE' THEN
171: xShot := xShot || ' gEPRtItemIds: ' ||
172: ICX_POR_EXT_UTL.getTableElement(gEPRtItemIds, pIndex) || ', ';
173: xShot := xShot || ' gEPActiveFlags: ' ||
174: ICX_POR_EXT_UTL.getTableElement(gEPActiveFlags, pIndex) || ', ';
175: xShot := xShot || ' gEPOrgIds: ' ||
176: ICX_POR_EXT_UTL.getTableElement(gEPOrgIds, pIndex) || ', ';
177: xShot := xShot || ' gEPPriceTypes: ' ||
178: ICX_POR_EXT_UTL.getTableElement(gEPPriceTypes, pIndex) || ', ';

Line 176: ICX_POR_EXT_UTL.getTableElement(gEPOrgIds, pIndex) || ', ';

172: ICX_POR_EXT_UTL.getTableElement(gEPRtItemIds, pIndex) || ', ';
173: xShot := xShot || ' gEPActiveFlags: ' ||
174: ICX_POR_EXT_UTL.getTableElement(gEPActiveFlags, pIndex) || ', ';
175: xShot := xShot || ' gEPOrgIds: ' ||
176: ICX_POR_EXT_UTL.getTableElement(gEPOrgIds, pIndex) || ', ';
177: xShot := xShot || ' gEPPriceTypes: ' ||
178: ICX_POR_EXT_UTL.getTableElement(gEPPriceTypes, pIndex) || ', ';
179: xShot := xShot || ' gEPRateTypes: ' ||
180: ICX_POR_EXT_UTL.getTableElement(gEPRateTypes, pIndex) || ', ';

Line 178: ICX_POR_EXT_UTL.getTableElement(gEPPriceTypes, pIndex) || ', ';

174: ICX_POR_EXT_UTL.getTableElement(gEPActiveFlags, pIndex) || ', ';
175: xShot := xShot || ' gEPOrgIds: ' ||
176: ICX_POR_EXT_UTL.getTableElement(gEPOrgIds, pIndex) || ', ';
177: xShot := xShot || ' gEPPriceTypes: ' ||
178: ICX_POR_EXT_UTL.getTableElement(gEPPriceTypes, pIndex) || ', ';
179: xShot := xShot || ' gEPRateTypes: ' ||
180: ICX_POR_EXT_UTL.getTableElement(gEPRateTypes, pIndex) || ', ';
181: xShot := xShot || ' gEPRateDates: ' ||
182: ICX_POR_EXT_UTL.getTableElement(gEPRateDates, pIndex) || ', ';

Line 180: ICX_POR_EXT_UTL.getTableElement(gEPRateTypes, pIndex) || ', ';

176: ICX_POR_EXT_UTL.getTableElement(gEPOrgIds, pIndex) || ', ';
177: xShot := xShot || ' gEPPriceTypes: ' ||
178: ICX_POR_EXT_UTL.getTableElement(gEPPriceTypes, pIndex) || ', ';
179: xShot := xShot || ' gEPRateTypes: ' ||
180: ICX_POR_EXT_UTL.getTableElement(gEPRateTypes, pIndex) || ', ';
181: xShot := xShot || ' gEPRateDates: ' ||
182: ICX_POR_EXT_UTL.getTableElement(gEPRateDates, pIndex) || ', ';
183: xShot := xShot || ' gEPRates: ' ||
184: ICX_POR_EXT_UTL.getTableElement(gEPRates, pIndex) || ', ';

Line 182: ICX_POR_EXT_UTL.getTableElement(gEPRateDates, pIndex) || ', ';

178: ICX_POR_EXT_UTL.getTableElement(gEPPriceTypes, pIndex) || ', ';
179: xShot := xShot || ' gEPRateTypes: ' ||
180: ICX_POR_EXT_UTL.getTableElement(gEPRateTypes, pIndex) || ', ';
181: xShot := xShot || ' gEPRateDates: ' ||
182: ICX_POR_EXT_UTL.getTableElement(gEPRateDates, pIndex) || ', ';
183: xShot := xShot || ' gEPRates: ' ||
184: ICX_POR_EXT_UTL.getTableElement(gEPRates, pIndex) || ', ';
185: xShot := xShot || ' gEPSupplierNumbers: ' ||
186: ICX_POR_EXT_UTL.getTableElement(gEPSupplierNumbers, pIndex) || ', ';

Line 184: ICX_POR_EXT_UTL.getTableElement(gEPRates, pIndex) || ', ';

180: ICX_POR_EXT_UTL.getTableElement(gEPRateTypes, pIndex) || ', ';
181: xShot := xShot || ' gEPRateDates: ' ||
182: ICX_POR_EXT_UTL.getTableElement(gEPRateDates, pIndex) || ', ';
183: xShot := xShot || ' gEPRates: ' ||
184: ICX_POR_EXT_UTL.getTableElement(gEPRates, pIndex) || ', ';
185: xShot := xShot || ' gEPSupplierNumbers: ' ||
186: ICX_POR_EXT_UTL.getTableElement(gEPSupplierNumbers, pIndex) || ', ';
187: xShot := xShot || ' gEPSupplierContactIds: ' ||
188: ICX_POR_EXT_UTL.getTableElement(gEPSupplierContactIds, pIndex) || ', ';

Line 186: ICX_POR_EXT_UTL.getTableElement(gEPSupplierNumbers, pIndex) || ', ';

182: ICX_POR_EXT_UTL.getTableElement(gEPRateDates, pIndex) || ', ';
183: xShot := xShot || ' gEPRates: ' ||
184: ICX_POR_EXT_UTL.getTableElement(gEPRates, pIndex) || ', ';
185: xShot := xShot || ' gEPSupplierNumbers: ' ||
186: ICX_POR_EXT_UTL.getTableElement(gEPSupplierNumbers, pIndex) || ', ';
187: xShot := xShot || ' gEPSupplierContactIds: ' ||
188: ICX_POR_EXT_UTL.getTableElement(gEPSupplierContactIds, pIndex) || ', ';
189: xShot := xShot || ' gEPItemRevisions: ' ||
190: ICX_POR_EXT_UTL.getTableElement(gEPItemRevisions, pIndex) || ', ';

Line 188: ICX_POR_EXT_UTL.getTableElement(gEPSupplierContactIds, pIndex) || ', ';

184: ICX_POR_EXT_UTL.getTableElement(gEPRates, pIndex) || ', ';
185: xShot := xShot || ' gEPSupplierNumbers: ' ||
186: ICX_POR_EXT_UTL.getTableElement(gEPSupplierNumbers, pIndex) || ', ';
187: xShot := xShot || ' gEPSupplierContactIds: ' ||
188: ICX_POR_EXT_UTL.getTableElement(gEPSupplierContactIds, pIndex) || ', ';
189: xShot := xShot || ' gEPItemRevisions: ' ||
190: ICX_POR_EXT_UTL.getTableElement(gEPItemRevisions, pIndex) || ', ';
191: xShot := xShot || ' gEPLineTypeIds: ' ||
192: ICX_POR_EXT_UTL.getTableElement(gEPLineTypeIds, pIndex) || ', ';

Line 190: ICX_POR_EXT_UTL.getTableElement(gEPItemRevisions, pIndex) || ', ';

186: ICX_POR_EXT_UTL.getTableElement(gEPSupplierNumbers, pIndex) || ', ';
187: xShot := xShot || ' gEPSupplierContactIds: ' ||
188: ICX_POR_EXT_UTL.getTableElement(gEPSupplierContactIds, pIndex) || ', ';
189: xShot := xShot || ' gEPItemRevisions: ' ||
190: ICX_POR_EXT_UTL.getTableElement(gEPItemRevisions, pIndex) || ', ';
191: xShot := xShot || ' gEPLineTypeIds: ' ||
192: ICX_POR_EXT_UTL.getTableElement(gEPLineTypeIds, pIndex) || ', ';
193: xShot := xShot || ' gEPBuyerIds: ' ||
194: ICX_POR_EXT_UTL.getTableElement(gEPBuyerIds, pIndex) || ', ';

Line 192: ICX_POR_EXT_UTL.getTableElement(gEPLineTypeIds, pIndex) || ', ';

188: ICX_POR_EXT_UTL.getTableElement(gEPSupplierContactIds, pIndex) || ', ';
189: xShot := xShot || ' gEPItemRevisions: ' ||
190: ICX_POR_EXT_UTL.getTableElement(gEPItemRevisions, pIndex) || ', ';
191: xShot := xShot || ' gEPLineTypeIds: ' ||
192: ICX_POR_EXT_UTL.getTableElement(gEPLineTypeIds, pIndex) || ', ';
193: xShot := xShot || ' gEPBuyerIds: ' ||
194: ICX_POR_EXT_UTL.getTableElement(gEPBuyerIds, pIndex) || ', ';
195: xShot := xShot || ' gEPRowIds: ' ||
196: ICX_POR_EXT_UTL.getTableElement(gEPRowIds, pIndex);

Line 194: ICX_POR_EXT_UTL.getTableElement(gEPBuyerIds, pIndex) || ', ';

190: ICX_POR_EXT_UTL.getTableElement(gEPItemRevisions, pIndex) || ', ';
191: xShot := xShot || ' gEPLineTypeIds: ' ||
192: ICX_POR_EXT_UTL.getTableElement(gEPLineTypeIds, pIndex) || ', ';
193: xShot := xShot || ' gEPBuyerIds: ' ||
194: ICX_POR_EXT_UTL.getTableElement(gEPBuyerIds, pIndex) || ', ';
195: xShot := xShot || ' gEPRowIds: ' ||
196: ICX_POR_EXT_UTL.getTableElement(gEPRowIds, pIndex);
197: ELSIF pMode = 'BULKLOADED_PRICE' THEN
198: xShot := xShot || ' gBPRtItemIds: ' ||

Line 196: ICX_POR_EXT_UTL.getTableElement(gEPRowIds, pIndex);

192: ICX_POR_EXT_UTL.getTableElement(gEPLineTypeIds, pIndex) || ', ';
193: xShot := xShot || ' gEPBuyerIds: ' ||
194: ICX_POR_EXT_UTL.getTableElement(gEPBuyerIds, pIndex) || ', ';
195: xShot := xShot || ' gEPRowIds: ' ||
196: ICX_POR_EXT_UTL.getTableElement(gEPRowIds, pIndex);
197: ELSIF pMode = 'BULKLOADED_PRICE' THEN
198: xShot := xShot || ' gBPRtItemIds: ' ||
199: ICX_POR_EXT_UTL.getTableElement(gBPRtItemIds, pIndex) || ', ';
200: xShot := xShot || ' gBRActiveFlgs: ' ||

Line 199: ICX_POR_EXT_UTL.getTableElement(gBPRtItemIds, pIndex) || ', ';

195: xShot := xShot || ' gEPRowIds: ' ||
196: ICX_POR_EXT_UTL.getTableElement(gEPRowIds, pIndex);
197: ELSIF pMode = 'BULKLOADED_PRICE' THEN
198: xShot := xShot || ' gBPRtItemIds: ' ||
199: ICX_POR_EXT_UTL.getTableElement(gBPRtItemIds, pIndex) || ', ';
200: xShot := xShot || ' gBRActiveFlgs: ' ||
201: ICX_POR_EXT_UTL.getTableElement(gBRActiveFlgs, pIndex) || ', ';
202: xShot := xShot || ' gBPOrgIds: ' ||
203: ICX_POR_EXT_UTL.getTableElement(gBPOrgIds, pIndex) || ', ';

Line 201: ICX_POR_EXT_UTL.getTableElement(gBRActiveFlgs, pIndex) || ', ';

197: ELSIF pMode = 'BULKLOADED_PRICE' THEN
198: xShot := xShot || ' gBPRtItemIds: ' ||
199: ICX_POR_EXT_UTL.getTableElement(gBPRtItemIds, pIndex) || ', ';
200: xShot := xShot || ' gBRActiveFlgs: ' ||
201: ICX_POR_EXT_UTL.getTableElement(gBRActiveFlgs, pIndex) || ', ';
202: xShot := xShot || ' gBPOrgIds: ' ||
203: ICX_POR_EXT_UTL.getTableElement(gBPOrgIds, pIndex) || ', ';
204: xShot := xShot || ' gBPSupplierSiteIds: ' ||
205: ICX_POR_EXT_UTL.getTableElement(gBPSupplierSiteIds, pIndex) || ', ';

Line 203: ICX_POR_EXT_UTL.getTableElement(gBPOrgIds, pIndex) || ', ';

199: ICX_POR_EXT_UTL.getTableElement(gBPRtItemIds, pIndex) || ', ';
200: xShot := xShot || ' gBRActiveFlgs: ' ||
201: ICX_POR_EXT_UTL.getTableElement(gBRActiveFlgs, pIndex) || ', ';
202: xShot := xShot || ' gBPOrgIds: ' ||
203: ICX_POR_EXT_UTL.getTableElement(gBPOrgIds, pIndex) || ', ';
204: xShot := xShot || ' gBPSupplierSiteIds: ' ||
205: ICX_POR_EXT_UTL.getTableElement(gBPSupplierSiteIds, pIndex) || ', ';
206: xShot := xShot || ' gBPPriceTypes: ' ||
207: ICX_POR_EXT_UTL.getTableElement(gBPPriceTypes, pIndex) || ', ';

Line 205: ICX_POR_EXT_UTL.getTableElement(gBPSupplierSiteIds, pIndex) || ', ';

201: ICX_POR_EXT_UTL.getTableElement(gBRActiveFlgs, pIndex) || ', ';
202: xShot := xShot || ' gBPOrgIds: ' ||
203: ICX_POR_EXT_UTL.getTableElement(gBPOrgIds, pIndex) || ', ';
204: xShot := xShot || ' gBPSupplierSiteIds: ' ||
205: ICX_POR_EXT_UTL.getTableElement(gBPSupplierSiteIds, pIndex) || ', ';
206: xShot := xShot || ' gBPPriceTypes: ' ||
207: ICX_POR_EXT_UTL.getTableElement(gBPPriceTypes, pIndex) || ', ';
208: xShot := xShot || ' gBPRowIds: ' ||
209: ICX_POR_EXT_UTL.getTableElement(gBPRowIds, pIndex);

Line 207: ICX_POR_EXT_UTL.getTableElement(gBPPriceTypes, pIndex) || ', ';

203: ICX_POR_EXT_UTL.getTableElement(gBPOrgIds, pIndex) || ', ';
204: xShot := xShot || ' gBPSupplierSiteIds: ' ||
205: ICX_POR_EXT_UTL.getTableElement(gBPSupplierSiteIds, pIndex) || ', ';
206: xShot := xShot || ' gBPPriceTypes: ' ||
207: ICX_POR_EXT_UTL.getTableElement(gBPPriceTypes, pIndex) || ', ';
208: xShot := xShot || ' gBPRowIds: ' ||
209: ICX_POR_EXT_UTL.getTableElement(gBPRowIds, pIndex);
210: END IF;
211:

Line 209: ICX_POR_EXT_UTL.getTableElement(gBPRowIds, pIndex);

205: ICX_POR_EXT_UTL.getTableElement(gBPSupplierSiteIds, pIndex) || ', ';
206: xShot := xShot || ' gBPPriceTypes: ' ||
207: ICX_POR_EXT_UTL.getTableElement(gBPPriceTypes, pIndex) || ', ';
208: xShot := xShot || ' gBPRowIds: ' ||
209: ICX_POR_EXT_UTL.getTableElement(gBPRowIds, pIndex);
210: END IF;
211:
212: RETURN xShot;
213: END snapShot;

Line 243: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

239: -- A power of 2 for the hash_size parameter is best
240: xHashSize := GREATEST(POWER(2,ROUND(LOG(2,gCommitSize*10))),
241: POWER(2, 10));
242: xErrLoc := 200;
243: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
244: 'Cache hash size is ' || xHashSize);
245: setHashRange(1, xHashSize);
246: END initCaches;
247:

Line 307: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.findTemplateItemCache-'||

303:
304: RETURN FALSE;
305: EXCEPTION
306: when others then
307: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.findTemplateItemCache-'||
308: xErrLoc||' '||SQLERRM);
309: raise ICX_POR_EXT_UTL.gException;
310: END findTemplateItemCache;
311:

Line 309: raise ICX_POR_EXT_UTL.gException;

305: EXCEPTION
306: when others then
307: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.findTemplateItemCache-'||
308: xErrLoc||' '||SQLERRM);
309: raise ICX_POR_EXT_UTL.gException;
310: END findTemplateItemCache;
311:
312: PROCEDURE putTemplateItemCache(pTemplateItem IN tTemplateItemRecord) IS
313: xErrLoc PLS_INTEGER := 100;

Line 325: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.putTemplateItemCache-'||

321: xErrLoc := 200;
322: gTemplateItemCache(pTemplateItem.hash_value) := pTemplateItem;
323: EXCEPTION
324: when others then
325: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.putTemplateItemCache-'||
326: xErrLoc||' '||SQLERRM);
327: raise ICX_POR_EXT_UTL.gException;
328: END putTemplateItemCache;
329:

Line 327: raise ICX_POR_EXT_UTL.gException;

323: EXCEPTION
324: when others then
325: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_ITEM.putTemplateItemCache-'||
326: xErrLoc||' '||SQLERRM);
327: raise ICX_POR_EXT_UTL.gException;
328: END putTemplateItemCache;
329:
330:
331: FUNCTION getOldPrimaryCategoryId(pRtItemId IN NUMBER)

Line 392: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

388: xReturnErr VARCHAR2(2000);
389:
390: BEGIN
391: xErrLoc := 50;
392: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
393: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
394: 'Fetch attributes for category ' || pRtCategoryId);
395: END IF;
396:

Line 393: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

389:
390: BEGIN
391: xErrLoc := 50;
392: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
393: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
394: 'Fetch attributes for category ' || pRtCategoryId);
395: END IF;
396:
397: OPEN cCatAttributes(pRtCategoryId);

Line 404: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

400: xStoredInTables, xStoredInColumns;
401:
402: xErrLoc := 100;
403:
404: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
405: FOR i in 1..xRtDescriptorIds.COUNT LOOP
406: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
407: 'rt_descriptor_id: ' || xRtDescriptorIds(i) ||
408: ', key: ' || xKeys(i) || ', type: ' || xTypes(i) ||

Line 406: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

402: xErrLoc := 100;
403:
404: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
405: FOR i in 1..xRtDescriptorIds.COUNT LOOP
406: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
407: 'rt_descriptor_id: ' || xRtDescriptorIds(i) ||
408: ', key: ' || xKeys(i) || ', type: ' || xTypes(i) ||
409: ', stored_in_table: ' || xStoredInTables(i) ||
410: ', stored_in_column: ' || xStoredInColumns(i));

Line 435: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,

431: IF (pRtCategoryId > 0 OR
432: xRtDescriptorIds(i) > 100)
433: THEN
434: IF (xStoredInColumns(i) IS NULL) THEN
435: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
436: 'Empty stored_in_column for attribute: ' || xKeys(i));
437: ELSE
438: xErrLoc := 240;
439: IF (xUpdateColumns IS NOT NULL) THEN

Line 510: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

506:
507: xErrLoc := 400;
508: IF (pRtCategoryId = 0) THEN
509: IF (gDynSqlBaseAttributes IS NOT NULL) THEN
510: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
511: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
512: gDynSqlBaseAttributes);
513: END IF;
514: END IF;

Line 511: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

507: xErrLoc := 400;
508: IF (pRtCategoryId = 0) THEN
509: IF (gDynSqlBaseAttributes IS NOT NULL) THEN
510: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
511: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
512: gDynSqlBaseAttributes);
513: END IF;
514: END IF;
515: ELSE

Line 517: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

513: END IF;
514: END IF;
515: ELSE
516: IF (gDynSqlCatAttributes IS NOT NULL) THEN
517: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
518: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
519: gDynSqlCatAttributes);
520: END IF;
521: END IF;

Line 518: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

514: END IF;
515: ELSE
516: IF (gDynSqlCatAttributes IS NOT NULL) THEN
517: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
518: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
519: gDynSqlCatAttributes);
520: END IF;
521: END IF;
522: END IF;

Line 530: ICX_POR_EXT_UTL.pushError(xReturnErr);

526: ROLLBACK;
527: xReturnErr :=
528: 'fetchAttributes(' ||xErrLoc||'): '||sqlerrm;
529: gReturnErr := gReturnErr || '-->' || xReturnErr;
530: ICX_POR_EXT_UTL.pushError(xReturnErr);
531: raise ICX_POR_EXT_UTL.gException;
532: END fetchAttributes;
533:
534: -- Process item records based on gCurrentItem

Line 531: raise ICX_POR_EXT_UTL.gException;

527: xReturnErr :=
528: 'fetchAttributes(' ||xErrLoc||'): '||sqlerrm;
529: gReturnErr := gReturnErr || '-->' || xReturnErr;
530: ICX_POR_EXT_UTL.pushError(xReturnErr);
531: raise ICX_POR_EXT_UTL.gException;
532: END fetchAttributes;
533:
534: -- Process item records based on gCurrentItem
535: PROCEDURE processItems IS

Line 844: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN

840: xTemplateItem tTemplateItemRecord;
841:
842: BEGIN
843: xErrLoc := 50;
844: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
845: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
846: 'Process item records for item: ' || gCurrentItem.rt_item_id);
847: END IF;
848: clearCache;

Line 845: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

841:
842: BEGIN
843: xErrLoc := 50;
844: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
845: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
846: 'Process item records for item: ' || gCurrentItem.rt_item_id);
847: END IF;
848: clearCache;
849:

Line 870: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

866: RETURN;
867: END IF;
868:
869: xErrLoc := 100;
870: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
871: FOR i in 1..xOrgIds.COUNT LOOP
872: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
873: 'org_id: ' || xOrgIds(i) ||
874: ', supplier_id: ' || xSupplierIds(i) ||

Line 872: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

868:
869: xErrLoc := 100;
870: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
871: FOR i in 1..xOrgIds.COUNT LOOP
872: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
873: 'org_id: ' || xOrgIds(i) ||
874: ', supplier_id: ' || xSupplierIds(i) ||
875: ', supplier_part_num: ' || xSupplierPartNums(i) ||
876: ', supplier_site_id: ' || xSupplierSiteIds(i) ||

Line 1013: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1009: INTO xRtItemId
1010: FROM sys.dual;
1011:
1012: xErrLoc := 300;
1013: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1014: 'Create a new item: ' || xRtItemId ||
1015: ' for item[old_rt_item_id: ' ||
1016: gCurrentItem.rt_item_id || ', org_id: ' ||
1017: xOrgIds(i) || ', supplier_id: ' ||

Line 1114: ICX_POR_EXT_UTL.pushError(xReturnErr);

1110: ROLLBACK;
1111: xReturnErr :=
1112: 'processItems(' ||xErrLoc||'): '||sqlerrm;
1113: gReturnErr := gReturnErr || '-->' || xReturnErr;
1114: ICX_POR_EXT_UTL.pushError(xReturnErr);
1115: raise ICX_POR_EXT_UTL.gException;
1116: END processItems;
1117:
1118: -- Move data into ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS

Line 1115: raise ICX_POR_EXT_UTL.gException;

1111: xReturnErr :=
1112: 'processItems(' ||xErrLoc||'): '||sqlerrm;
1113: gReturnErr := gReturnErr || '-->' || xReturnErr;
1114: ICX_POR_EXT_UTL.pushError(xReturnErr);
1115: raise ICX_POR_EXT_UTL.gException;
1116: END processItems;
1117:
1118: -- Move data into ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS
1119: PROCEDURE moveItems IS

Line 1130: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1126: xMode VARCHAR2(20) := 'ITEM';
1127:
1128: BEGIN
1129: xErrLoc := 50;
1130: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1131: 'moveItem[Count: ' || gIRtItemIds.COUNT || ']');
1132:
1133: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1134: FOR i in 1..gIRtItemIds.COUNT LOOP

Line 1133: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

1129: xErrLoc := 50;
1130: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1131: 'moveItem[Count: ' || gIRtItemIds.COUNT || ']');
1132:
1133: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1134: FOR i in 1..gIRtItemIds.COUNT LOOP
1135: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1136: snapShot(i, xMode));
1137: END LOOP;

Line 1135: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

1131: 'moveItem[Count: ' || gIRtItemIds.COUNT || ']');
1132:
1133: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1134: FOR i in 1..gIRtItemIds.COUNT LOOP
1135: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1136: snapShot(i, xMode));
1137: END LOOP;
1138: END IF;
1139:

Line 1141: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'ICX_CAT_ITEMS_B');

1137: END LOOP;
1138: END IF;
1139:
1140: xErrLoc := 100;
1141: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'ICX_CAT_ITEMS_B');
1142:
1143: -- Let's use object_version_number to store old_rt_item_id for now
1144: FORALL i IN 1..gIRtItemIds.COUNT
1145: INSERT INTO ICX_CAT_ITEMS_B

Line 1167: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'ICX_CAT_ITEMS_TLP');

1163:
1164: COMMIT;
1165:
1166: xErrLoc := 150;
1167: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'ICX_CAT_ITEMS_TLP');
1168:
1169: FORALL i IN 1..gIRtItemIds.COUNT
1170: INSERT INTO ICX_CAT_ITEMS_TLP
1171: (rt_item_id, language, org_id,

Line 1212: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1208:
1209: COMMIT;
1210:
1211: xErrLoc := 200;
1212: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1213: 'Dynamic SQL to update base attributes of ICX_CAT_ITEMS_TLP');
1214:
1215: IF (gDynSqlBaseAttributes IS NOT NULL) THEN
1216: xErrLoc := 210;

Line 1234: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1230: COMMIT;
1231: END IF;
1232:
1233: xErrLoc := 300;
1234: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1235: 'Primary category into ICX_CAT_CATEGORY_ITEMS');
1236:
1237: FORALL i IN 1..gIRtItemIds.COUNT
1238: INSERT INTO ICX_CAT_CATEGORY_ITEMS

Line 1251: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1247:
1248: COMMIT;
1249:
1250: xErrLoc := 400;
1251: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1252: 'ICX_CAT_EXT_ITEMS_TLP');
1253:
1254: FORALL i IN 1..gIRtItemIds.COUNT
1255: INSERT INTO ICX_CAT_EXT_ITEMS_TLP

Line 1281: ICX_POR_EXT_UTL.pushError(xReturnErr);

1277: ROLLBACK;
1278: xReturnErr :=
1279: 'moveItems(' ||xErrLoc||'): '||sqlerrm;
1280: gReturnErr := gReturnErr || '-->' || xReturnErr;
1281: ICX_POR_EXT_UTL.pushError(xReturnErr);
1282: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1283: raise ICX_POR_EXT_UTL.gException;
1284: END moveItems;
1285:

Line 1282: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));

1278: xReturnErr :=
1279: 'moveItems(' ||xErrLoc||'): '||sqlerrm;
1280: gReturnErr := gReturnErr || '-->' || xReturnErr;
1281: ICX_POR_EXT_UTL.pushError(xReturnErr);
1282: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1283: raise ICX_POR_EXT_UTL.gException;
1284: END moveItems;
1285:
1286: -- Update item_description of ICX_CAT_ITEMS_TLP

Line 1283: raise ICX_POR_EXT_UTL.gException;

1279: 'moveItems(' ||xErrLoc||'): '||sqlerrm;
1280: gReturnErr := gReturnErr || '-->' || xReturnErr;
1281: ICX_POR_EXT_UTL.pushError(xReturnErr);
1282: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1283: raise ICX_POR_EXT_UTL.gException;
1284: END moveItems;
1285:
1286: -- Update item_description of ICX_CAT_ITEMS_TLP
1287: PROCEDURE updateItemsTLP IS

Line 1294: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1290: xMode VARCHAR2(20) := 'TLP';
1291:
1292: BEGIN
1293: xErrLoc := 50;
1294: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1295: 'updateItemsTLP[Count: ' || gITRtItemIds.COUNT || ']');
1296:
1297: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1298: FOR i in 1..gITRtItemIds.COUNT LOOP

Line 1297: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

1293: xErrLoc := 50;
1294: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1295: 'updateItemsTLP[Count: ' || gITRtItemIds.COUNT || ']');
1296:
1297: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1298: FOR i in 1..gITRtItemIds.COUNT LOOP
1299: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1300: snapShot(i, xMode));
1301: END LOOP;

Line 1299: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

1295: 'updateItemsTLP[Count: ' || gITRtItemIds.COUNT || ']');
1296:
1297: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1298: FOR i in 1..gITRtItemIds.COUNT LOOP
1299: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1300: snapShot(i, xMode));
1301: END LOOP;
1302: END IF;
1303:

Line 1305: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1301: END LOOP;
1302: END IF;
1303:
1304: xErrLoc := 100;
1305: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1306: 'Update item_description of ICX_CAT_ITEMS_TLP');
1307:
1308: FORALL i IN 1..gITRtItemIds.COUNT
1309: UPDATE ICX_CAT_ITEMS_TLP

Line 1328: ICX_POR_EXT_UTL.pushError(xReturnErr);

1324: ROLLBACK;
1325: xReturnErr :=
1326: 'updateItemsTLP(' ||xErrLoc||'): '||sqlerrm;
1327: gReturnErr := gReturnErr || '-->' || xReturnErr;
1328: ICX_POR_EXT_UTL.pushError(xReturnErr);
1329: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1330: raise ICX_POR_EXT_UTL.gException;
1331: END updateItemsTLP;
1332:

Line 1329: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));

1325: xReturnErr :=
1326: 'updateItemsTLP(' ||xErrLoc||'): '||sqlerrm;
1327: gReturnErr := gReturnErr || '-->' || xReturnErr;
1328: ICX_POR_EXT_UTL.pushError(xReturnErr);
1329: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1330: raise ICX_POR_EXT_UTL.gException;
1331: END updateItemsTLP;
1332:
1333: -- Create template headers into ICX_CAT_CATEGORY_ITEMS

Line 1330: raise ICX_POR_EXT_UTL.gException;

1326: 'updateItemsTLP(' ||xErrLoc||'): '||sqlerrm;
1327: gReturnErr := gReturnErr || '-->' || xReturnErr;
1328: ICX_POR_EXT_UTL.pushError(xReturnErr);
1329: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1330: raise ICX_POR_EXT_UTL.gException;
1331: END updateItemsTLP;
1332:
1333: -- Create template headers into ICX_CAT_CATEGORY_ITEMS
1334: PROCEDURE createTempCategoryItems IS

Line 1341: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1337: xMode VARCHAR2(20) := 'CAT_ITEM';
1338:
1339: BEGIN
1340: xErrLoc := 50;
1341: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1342: 'createTempCategoryItems[Count: ' || gCIRtItemIds.COUNT || ']');
1343:
1344: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1345: 'Template headers into ICX_CAT_CATEGORY_ITEMS');

Line 1344: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1340: xErrLoc := 50;
1341: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1342: 'createTempCategoryItems[Count: ' || gCIRtItemIds.COUNT || ']');
1343:
1344: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1345: 'Template headers into ICX_CAT_CATEGORY_ITEMS');
1346:
1347: xErrLoc := 100;
1348: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

Line 1348: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

1344: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1345: 'Template headers into ICX_CAT_CATEGORY_ITEMS');
1346:
1347: xErrLoc := 100;
1348: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1349: FOR i in 1..gCIRtItemIds.COUNT LOOP
1350: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1351: snapShot(i, xMode));
1352: END LOOP;

Line 1350: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

1346:
1347: xErrLoc := 100;
1348: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1349: FOR i in 1..gCIRtItemIds.COUNT LOOP
1350: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1351: snapShot(i, xMode));
1352: END LOOP;
1353: END IF;
1354:

Line 1384: ICX_POR_EXT_UTL.pushError(xReturnErr);

1380: ROLLBACK;
1381: xReturnErr :=
1382: 'createTempCategoryItems(' ||xErrLoc||'): '||sqlerrm;
1383: gReturnErr := gReturnErr || '-->' || xReturnErr;
1384: ICX_POR_EXT_UTL.pushError(xReturnErr);
1385: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1386: raise ICX_POR_EXT_UTL.gException;
1387: END createTempCategoryItems;
1388:

Line 1385: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));

1381: xReturnErr :=
1382: 'createTempCategoryItems(' ||xErrLoc||'): '||sqlerrm;
1383: gReturnErr := gReturnErr || '-->' || xReturnErr;
1384: ICX_POR_EXT_UTL.pushError(xReturnErr);
1385: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1386: raise ICX_POR_EXT_UTL.gException;
1387: END createTempCategoryItems;
1388:
1389: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_ORACLE_ITEM_SUBTABLE

Line 1386: raise ICX_POR_EXT_UTL.gException;

1382: 'createTempCategoryItems(' ||xErrLoc||'): '||sqlerrm;
1383: gReturnErr := gReturnErr || '-->' || xReturnErr;
1384: ICX_POR_EXT_UTL.pushError(xReturnErr);
1385: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1386: raise ICX_POR_EXT_UTL.gException;
1387: END createTempCategoryItems;
1388:
1389: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_ORACLE_ITEM_SUBTABLE
1390: PROCEDURE moveExtractedPrices IS

Line 1397: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1393: xMode VARCHAR2(20) := 'EXTRACTED_PRICE';
1394:
1395: BEGIN
1396: xErrLoc := 50;
1397: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1398: 'moveExtractedPrices[Count: ' || gEPRtItemIds.COUNT || ']');
1399:
1400: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1401: FOR i in 1..gEPRtItemIds.COUNT LOOP

Line 1400: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

1396: xErrLoc := 50;
1397: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1398: 'moveExtractedPrices[Count: ' || gEPRtItemIds.COUNT || ']');
1399:
1400: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1401: FOR i in 1..gEPRtItemIds.COUNT LOOP
1402: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1403: snapShot(i, xMode));
1404: END LOOP;

Line 1402: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

1398: 'moveExtractedPrices[Count: ' || gEPRtItemIds.COUNT || ']');
1399:
1400: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1401: FOR i in 1..gEPRtItemIds.COUNT LOOP
1402: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1403: snapShot(i, xMode));
1404: END LOOP;
1405: END IF;
1406:

Line 1408: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1404: END LOOP;
1405: END IF;
1406:
1407: xErrLoc := 100;
1408: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1409: 'ICX_CAT_ITEM_PRICES from ICX_POR_ORACLE_ITEM_SUBTABLE');
1410:
1411: FORALL i IN 1..gEPRtItemIds.COUNT
1412: INSERT INTO ICX_CAT_ITEM_PRICES

Line 1471: ICX_POR_EXT_UTL.pushError(xReturnErr);

1467: ROLLBACK;
1468: xReturnErr :=
1469: 'moveExtractedPrices(' ||xErrLoc||'): '||sqlerrm;
1470: gReturnErr := gReturnErr || '-->' || xReturnErr;
1471: ICX_POR_EXT_UTL.pushError(xReturnErr);
1472: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1473: raise ICX_POR_EXT_UTL.gException;
1474: END moveExtractedPrices;
1475:

Line 1472: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));

1468: xReturnErr :=
1469: 'moveExtractedPrices(' ||xErrLoc||'): '||sqlerrm;
1470: gReturnErr := gReturnErr || '-->' || xReturnErr;
1471: ICX_POR_EXT_UTL.pushError(xReturnErr);
1472: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1473: raise ICX_POR_EXT_UTL.gException;
1474: END moveExtractedPrices;
1475:
1476: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_PRICE_LIST_LINES

Line 1473: raise ICX_POR_EXT_UTL.gException;

1469: 'moveExtractedPrices(' ||xErrLoc||'): '||sqlerrm;
1470: gReturnErr := gReturnErr || '-->' || xReturnErr;
1471: ICX_POR_EXT_UTL.pushError(xReturnErr);
1472: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1473: raise ICX_POR_EXT_UTL.gException;
1474: END moveExtractedPrices;
1475:
1476: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_PRICE_LIST_LINES
1477: PROCEDURE moveBulkloadedPrices IS

Line 1484: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1480: xMode VARCHAR2(20) := 'BULKLOADED_PRICE';
1481:
1482: BEGIN
1483: xErrLoc := 50;
1484: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1485: 'moveBulkloadedPrices[Count: ' || gBPRtItemIds.COUNT || ']');
1486:
1487: xErrLoc := 100;
1488: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

Line 1488: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

1484: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1485: 'moveBulkloadedPrices[Count: ' || gBPRtItemIds.COUNT || ']');
1486:
1487: xErrLoc := 100;
1488: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1489: FOR i in 1..gBPRtItemIds.COUNT LOOP
1490: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1491: snapShot(i, xMode));
1492: END LOOP;

Line 1490: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

1486:
1487: xErrLoc := 100;
1488: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1489: FOR i in 1..gBPRtItemIds.COUNT LOOP
1490: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1491: snapShot(i, xMode));
1492: END LOOP;
1493: END IF;
1494:

Line 1495: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1491: snapShot(i, xMode));
1492: END LOOP;
1493: END IF;
1494:
1495: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1496: 'ICX_CAT_ITEM_PRICES from ICX_POR_PRICE_LIST_LINES');
1497:
1498: xErrLoc := 200;
1499: FORALL i IN 1..gBPRtItemIds.COUNT

Line 1551: ICX_POR_EXT_UTL.pushError(xReturnErr);

1547: ROLLBACK;
1548: xReturnErr :=
1549: 'moveBulkloadedPrices(' ||xErrLoc||'): '||sqlerrm;
1550: gReturnErr := gReturnErr || '-->' || xReturnErr;
1551: ICX_POR_EXT_UTL.pushError(xReturnErr);
1552: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1553: raise ICX_POR_EXT_UTL.gException;
1554: END moveBulkloadedPrices;
1555:

Line 1552: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));

1548: xReturnErr :=
1549: 'moveBulkloadedPrices(' ||xErrLoc||'): '||sqlerrm;
1550: gReturnErr := gReturnErr || '-->' || xReturnErr;
1551: ICX_POR_EXT_UTL.pushError(xReturnErr);
1552: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1553: raise ICX_POR_EXT_UTL.gException;
1554: END moveBulkloadedPrices;
1555:
1556: -- Move data

Line 1553: raise ICX_POR_EXT_UTL.gException;

1549: 'moveBulkloadedPrices(' ||xErrLoc||'): '||sqlerrm;
1550: gReturnErr := gReturnErr || '-->' || xReturnErr;
1551: ICX_POR_EXT_UTL.pushError(xReturnErr);
1552: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1553: raise ICX_POR_EXT_UTL.gException;
1554: END moveBulkloadedPrices;
1555:
1556: -- Move data
1557: PROCEDURE moveData (pMode VARCHAR2) IS

Line 1602: ICX_POR_EXT_UTL.pushError(xReturnErr);

1598: ROLLBACK;
1599: xReturnErr :=
1600: 'moveData(' ||xErrLoc||'): '||sqlerrm;
1601: gReturnErr := gReturnErr || '-->' || xReturnErr;
1602: ICX_POR_EXT_UTL.pushError(xReturnErr);
1603: raise ICX_POR_EXT_UTL.gException;
1604: END moveData;
1605:
1606: -- Update category attributes of ICX_CAT_EXT_ITEMS_TLP

Line 1603: raise ICX_POR_EXT_UTL.gException;

1599: xReturnErr :=
1600: 'moveData(' ||xErrLoc||'): '||sqlerrm;
1601: gReturnErr := gReturnErr || '-->' || xReturnErr;
1602: ICX_POR_EXT_UTL.pushError(xReturnErr);
1603: raise ICX_POR_EXT_UTL.gException;
1604: END moveData;
1605:
1606: -- Update category attributes of ICX_CAT_EXT_ITEMS_TLP
1607: -- Note: We use icx_cat_items_b.object_version_number to

Line 1649: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1645: xResultCount NUMBER;
1646:
1647: BEGIN
1648: xErrLoc := 50;
1649: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1650: 'Update category attributes of ICX_CAT_EXT_ITEMS_TLP');
1651:
1652: FOR all_category IN cAllCategories LOOP
1653: xErrLoc := 100;

Line 1673: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

1669: LIMIT gCommitSize;
1670: EXIT WHEN xRtItemIds.COUNT = 0;
1671:
1672: xErrLoc := 210;
1673: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1674: FOR i in 1..xRtItemIds.COUNT LOOP
1675: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1676: 'xRtItemIds('||i||'): '||xRtItemIds(i)||', '||
1677: 'xOldRtItemIds('||i||'): '||xOldRtItemIds(i));

Line 1675: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

1671:
1672: xErrLoc := 210;
1673: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1674: FOR i in 1..xRtItemIds.COUNT LOOP
1675: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1676: 'xRtItemIds('||i||'): '||xRtItemIds(i)||', '||
1677: 'xOldRtItemIds('||i||'): '||xOldRtItemIds(i));
1678: END LOOP;
1679: END IF;

Line 1697: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN

1693: xErrLoc := 280;
1694: DBMS_SQL.close_cursor(xCursorId);
1695:
1696: xErrLoc := 300;
1697: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
1698: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1699: 'Restore ICX_CAT_ITEMS_B.object_version_number to 1');
1700: END IF;
1701:

Line 1698: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

1694: DBMS_SQL.close_cursor(xCursorId);
1695:
1696: xErrLoc := 300;
1697: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
1698: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1699: 'Restore ICX_CAT_ITEMS_B.object_version_number to 1');
1700: END IF;
1701:
1702: xErrLoc := 320;

Line 1733: ICX_POR_EXT_UTL.pushError(xReturnErr);

1729: ROLLBACK;
1730: xReturnErr :=
1731: 'updateExtItemsTLP(' ||xErrLoc||'): '||sqlerrm;
1732: gReturnErr := gReturnErr || '-->' || xReturnErr;
1733: ICX_POR_EXT_UTL.pushError(xReturnErr);
1734: raise ICX_POR_EXT_UTL.gException;
1735: END updateExtItemsTLP;
1736:
1737: -- Create unextracted internal item price record

Line 1734: raise ICX_POR_EXT_UTL.gException;

1730: xReturnErr :=
1731: 'updateExtItemsTLP(' ||xErrLoc||'): '||sqlerrm;
1732: gReturnErr := gReturnErr || '-->' || xReturnErr;
1733: ICX_POR_EXT_UTL.pushError(xReturnErr);
1734: raise ICX_POR_EXT_UTL.gException;
1735: END updateExtItemsTLP;
1736:
1737: -- Create unextracted internal item price record
1738: -- Only need to create row in icx_cat_item_prices

Line 1753: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1749: xReturnErr VARCHAR2(2000);
1750: xRowIds DBMS_SQL.UROWID_TABLE;
1751: BEGIN
1752: xErrLoc := 50;
1753: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1754: 'create missing internal item prices');
1755:
1756: OPEN cInternalItemPrices;
1757: xErrLoc := 100;

Line 1830: ICX_POR_EXT_UTL.pushError(xReturnErr);

1826: END IF;
1827: xReturnErr :=
1828: 'createInternalItemPrices(' ||xErrLoc||'): '||sqlerrm;
1829: gReturnErr := gReturnErr || '-->' || xReturnErr;
1830: ICX_POR_EXT_UTL.pushError(xReturnErr);
1831: raise ICX_POR_EXT_UTL.gException;
1832: END createInternalItemPrices;
1833:
1834: -- Create unextracted purchasing item price record

Line 1831: raise ICX_POR_EXT_UTL.gException;

1827: xReturnErr :=
1828: 'createInternalItemPrices(' ||xErrLoc||'): '||sqlerrm;
1829: gReturnErr := gReturnErr || '-->' || xReturnErr;
1830: ICX_POR_EXT_UTL.pushError(xReturnErr);
1831: raise ICX_POR_EXT_UTL.gException;
1832: END createInternalItemPrices;
1833:
1834: -- Create unextracted purchasing item price record
1835: -- If this item has internal part, will reuse the internal rt_item_id

Line 1883: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1879: xLanguage VARCHAR2(4);
1880:
1881: BEGIN
1882: xErrLoc := 100;
1883: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1884: 'create missing purchasing item prices');
1885:
1886: xErrLoc := 101;
1887: SELECT language_code INTO xLanguage

Line 1891: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1887: SELECT language_code INTO xLanguage
1888: FROM fnd_languages
1889: WHERE installed_flag = 'B';
1890:
1891: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1892: 'base language:' ||xLanguage);
1893:
1894: xErrLoc := 102;
1895: OPEN cPurchasingItemPrices;

Line 1996: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

1992:
1993: xErrLoc := 280;
1994: EXCEPTION
1995: WHEN snap_shot_too_old THEN
1996: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1997: 'ORA-01555: snapshot too old: caught at ' ||
1998: 'ICX_CAT_FPI_UPGRADE.upgrade-' ||xErrLoc ||
1999: ', SQLERRM:' ||SQLERRM ||
2000: '; so close the cursor and repoen the cursor');

Line 2002: ICX_POR_EXT_UTL.extAFCommit;

1998: 'ICX_CAT_FPI_UPGRADE.upgrade-' ||xErrLoc ||
1999: ', SQLERRM:' ||SQLERRM ||
2000: '; so close the cursor and repoen the cursor');
2001: xErrLoc := 282;
2002: ICX_POR_EXT_UTL.extAFCommit;
2003: IF (cPurchasingItemPrices%ISOPEN) THEN
2004: xErrLoc := 284;
2005: CLOSE cPurchasingItemPrices;
2006: xErrLoc := 286;

Line 2032: ICX_POR_EXT_UTL.pushError(xReturnErr);

2028: END IF;
2029: xReturnErr :=
2030: 'createPurchasingItemPrices(' ||xErrLoc||'): '||sqlerrm;
2031: gReturnErr := gReturnErr || '-->' || xReturnErr;
2032: ICX_POR_EXT_UTL.pushError(xReturnErr);
2033: raise ICX_POR_EXT_UTL.gException;
2034: END createPurchasingItemPrices;
2035:
2036:

Line 2033: raise ICX_POR_EXT_UTL.gException;

2029: xReturnErr :=
2030: 'createPurchasingItemPrices(' ||xErrLoc||'): '||sqlerrm;
2031: gReturnErr := gReturnErr || '-->' || xReturnErr;
2032: ICX_POR_EXT_UTL.pushError(xReturnErr);
2033: raise ICX_POR_EXT_UTL.gException;
2034: END createPurchasingItemPrices;
2035:
2036:
2037: --update the request_id of icx_cat_item_prices from -20 to -9

Line 2053: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

2049: WHERE p.request_id = CREATE_PURCHASING_PHASE;
2050:
2051: BEGIN
2052: xErrLoc := 710;
2053: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
2054: 'update request_id of item prices table');
2055:
2056: OPEN cRequestId;
2057: LOOP

Line 2087: ICX_POR_EXT_UTL.pushError(xReturnErr);

2083: END IF;
2084: xReturnErr :=
2085: 'updateRequestId(' ||xErrLoc||'): '||sqlerrm;
2086: gReturnErr := gReturnErr || '-->' || xReturnErr;
2087: ICX_POR_EXT_UTL.pushError(xReturnErr);
2088: raise ICX_POR_EXT_UTL.gException;
2089: END updateRequestId;
2090:
2091: -- Move records from icx_por_price_lists to icx_cat_price_lists

Line 2088: raise ICX_POR_EXT_UTL.gException;

2084: xReturnErr :=
2085: 'updateRequestId(' ||xErrLoc||'): '||sqlerrm;
2086: gReturnErr := gReturnErr || '-->' || xReturnErr;
2087: ICX_POR_EXT_UTL.pushError(xReturnErr);
2088: raise ICX_POR_EXT_UTL.gException;
2089: END updateRequestId;
2090:
2091: -- Move records from icx_por_price_lists to icx_cat_price_lists
2092: PROCEDURE movePriceLists IS

Line 2097: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

2093: xErrLoc PLS_INTEGER;
2094: xReturnErr VARCHAR2(2000);
2095: BEGIN
2096: xErrLoc := 50;
2097: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
2098: 'Move records from icx_por_price_lists to icx_cat_price_lists');
2099:
2100: xErrLoc := 100;
2101: LOOP

Line 2136: ICX_POR_EXT_UTL.pushError(xReturnErr);

2132: ROLLBACK;
2133: xReturnErr :=
2134: 'movePriceLists(' ||xErrLoc||'): '||sqlerrm;
2135: gReturnErr := gReturnErr || '-->' || xReturnErr;
2136: ICX_POR_EXT_UTL.pushError(xReturnErr);
2137: raise ICX_POR_EXT_UTL.gException;
2138: END movePriceLists;
2139:
2140: -- Update POR_FAVORITE_LIST_LINES

Line 2137: raise ICX_POR_EXT_UTL.gException;

2133: xReturnErr :=
2134: 'movePriceLists(' ||xErrLoc||'): '||sqlerrm;
2135: gReturnErr := gReturnErr || '-->' || xReturnErr;
2136: ICX_POR_EXT_UTL.pushError(xReturnErr);
2137: raise ICX_POR_EXT_UTL.gException;
2138: END movePriceLists;
2139:
2140: -- Update POR_FAVORITE_LIST_LINES
2141: PROCEDURE updateFavoriteList IS

Line 2146: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

2142: xErrLoc PLS_INTEGER;
2143: xReturnErr VARCHAR2(2000);
2144: BEGIN
2145: xErrLoc := 100;
2146: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2147: FOR i in 1..gUpFavRowIds.COUNT LOOP
2148: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2149: 'rt_item_id: ' || gUpFavRtItemIds(i) ||
2150: ', rowid: ' || gUpFavRowIds(i));

Line 2148: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

2144: BEGIN
2145: xErrLoc := 100;
2146: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2147: FOR i in 1..gUpFavRowIds.COUNT LOOP
2148: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2149: 'rt_item_id: ' || gUpFavRtItemIds(i) ||
2150: ', rowid: ' || gUpFavRowIds(i));
2151: END LOOP;
2152: END IF;

Line 2170: ICX_POR_EXT_UTL.pushError(xReturnErr);

2166: ROLLBACK;
2167: xReturnErr :=
2168: 'updateFavoriteList(' ||xErrLoc||'): '||sqlerrm;
2169: gReturnErr := gReturnErr || '-->' || xReturnErr;
2170: ICX_POR_EXT_UTL.pushError(xReturnErr);
2171: raise ICX_POR_EXT_UTL.gException;
2172: END updateFavoriteList;
2173:
2174: -- Insert POR_FAVORITE_LIST_LINES

Line 2171: raise ICX_POR_EXT_UTL.gException;

2167: xReturnErr :=
2168: 'updateFavoriteList(' ||xErrLoc||'): '||sqlerrm;
2169: gReturnErr := gReturnErr || '-->' || xReturnErr;
2170: ICX_POR_EXT_UTL.pushError(xReturnErr);
2171: raise ICX_POR_EXT_UTL.gException;
2172: END updateFavoriteList;
2173:
2174: -- Insert POR_FAVORITE_LIST_LINES
2175: PROCEDURE insertFavoriteList IS

Line 2180: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

2176: xErrLoc PLS_INTEGER;
2177: xReturnErr VARCHAR2(2000);
2178: BEGIN
2179: xErrLoc := 100;
2180: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2181: FOR i in 1..gInFavRowIds.COUNT LOOP
2182: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2183: 'rt_item_id: ' || gInFavRtItemIds(i) ||
2184: ', rowid: ' || gInFavRowIds(i));

Line 2182: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

2178: BEGIN
2179: xErrLoc := 100;
2180: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2181: FOR i in 1..gInFavRowIds.COUNT LOOP
2182: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2183: 'rt_item_id: ' || gInFavRtItemIds(i) ||
2184: ', rowid: ' || gInFavRowIds(i));
2185: END LOOP;
2186: END IF;

Line 2321: ICX_POR_EXT_UTL.pushError(xReturnErr);

2317: ROLLBACK;
2318: xReturnErr :=
2319: 'insertFavoriteList(' ||xErrLoc||'): '||sqlerrm;
2320: gReturnErr := gReturnErr || '-->' || xReturnErr;
2321: ICX_POR_EXT_UTL.pushError(xReturnErr);
2322: raise ICX_POR_EXT_UTL.gException;
2323: END insertFavoriteList;
2324:
2325: -- Upgrade POR_FAVORITE_LIST_LINES

Line 2322: raise ICX_POR_EXT_UTL.gException;

2318: xReturnErr :=
2319: 'insertFavoriteList(' ||xErrLoc||'): '||sqlerrm;
2320: gReturnErr := gReturnErr || '-->' || xReturnErr;
2321: ICX_POR_EXT_UTL.pushError(xReturnErr);
2322: raise ICX_POR_EXT_UTL.gException;
2323: END insertFavoriteList;
2324:
2325: -- Upgrade POR_FAVORITE_LIST_LINES
2326: PROCEDURE upgradeFavoriteList IS

Line 2350: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

2346: xCount PLS_INTEGER;
2347:
2348: BEGIN
2349: xErrLoc := 50;
2350: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
2351: 'upgrade POR_FAVORITE_LIST_LINES');
2352:
2353: xErrLoc := 100;
2354: FOR favorite IN cFavoriteListLines LOOP

Line 2432: ICX_POR_EXT_UTL.pushError(xReturnErr);

2428: END IF;
2429: xReturnErr :=
2430: 'upgradeFavoriteList(' ||xErrLoc||'): '||sqlerrm;
2431: gReturnErr := gReturnErr || '-->' || xReturnErr;
2432: ICX_POR_EXT_UTL.pushError(xReturnErr);
2433: raise ICX_POR_EXT_UTL.gException;
2434: END upgradeFavoriteList;
2435:
2436: PROCEDURE setLog (pLogLevel IN NUMBER,

Line 2433: raise ICX_POR_EXT_UTL.gException;

2429: xReturnErr :=
2430: 'upgradeFavoriteList(' ||xErrLoc||'): '||sqlerrm;
2431: gReturnErr := gReturnErr || '-->' || xReturnErr;
2432: ICX_POR_EXT_UTL.pushError(xReturnErr);
2433: raise ICX_POR_EXT_UTL.gException;
2434: END upgradeFavoriteList;
2435:
2436: PROCEDURE setLog (pLogLevel IN NUMBER,
2437: pLogFile IN VARCHAR2)

Line 2446: ICX_POR_EXT_UTL.setDebugLevel(gLogLevel);

2442: END setLog;
2443:
2444: PROCEDURE startLog IS
2445: BEGIN
2446: ICX_POR_EXT_UTL.setDebugLevel(gLogLevel);
2447: ICX_POR_EXT_UTL.setUseFile(1);
2448: ICX_POR_EXT_UTL.setFilePath(ICX_POR_EXT_UTL.UTL_FILE_DIR);
2449: ICX_POR_EXT_UTL.openLog(gLogFile);
2450: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start...');

Line 2447: ICX_POR_EXT_UTL.setUseFile(1);

2443:
2444: PROCEDURE startLog IS
2445: BEGIN
2446: ICX_POR_EXT_UTL.setDebugLevel(gLogLevel);
2447: ICX_POR_EXT_UTL.setUseFile(1);
2448: ICX_POR_EXT_UTL.setFilePath(ICX_POR_EXT_UTL.UTL_FILE_DIR);
2449: ICX_POR_EXT_UTL.openLog(gLogFile);
2450: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start...');
2451: END startLog;

Line 2448: ICX_POR_EXT_UTL.setFilePath(ICX_POR_EXT_UTL.UTL_FILE_DIR);

2444: PROCEDURE startLog IS
2445: BEGIN
2446: ICX_POR_EXT_UTL.setDebugLevel(gLogLevel);
2447: ICX_POR_EXT_UTL.setUseFile(1);
2448: ICX_POR_EXT_UTL.setFilePath(ICX_POR_EXT_UTL.UTL_FILE_DIR);
2449: ICX_POR_EXT_UTL.openLog(gLogFile);
2450: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start...');
2451: END startLog;
2452:

Line 2449: ICX_POR_EXT_UTL.openLog(gLogFile);

2445: BEGIN
2446: ICX_POR_EXT_UTL.setDebugLevel(gLogLevel);
2447: ICX_POR_EXT_UTL.setUseFile(1);
2448: ICX_POR_EXT_UTL.setFilePath(ICX_POR_EXT_UTL.UTL_FILE_DIR);
2449: ICX_POR_EXT_UTL.openLog(gLogFile);
2450: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start...');
2451: END startLog;
2452:
2453: PROCEDURE endLog IS

Line 2450: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start...');

2446: ICX_POR_EXT_UTL.setDebugLevel(gLogLevel);
2447: ICX_POR_EXT_UTL.setUseFile(1);
2448: ICX_POR_EXT_UTL.setFilePath(ICX_POR_EXT_UTL.UTL_FILE_DIR);
2449: ICX_POR_EXT_UTL.openLog(gLogFile);
2450: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start...');
2451: END startLog;
2452:
2453: PROCEDURE endLog IS
2454: BEGIN

Line 2455: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End...');

2451: END startLog;
2452:
2453: PROCEDURE endLog IS
2454: BEGIN
2455: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End...');
2456: ICX_POR_EXT_UTL.closeLog;
2457: END endLog;
2458:
2459: PROCEDURE setCommitSize (pCommitSize IN NUMBER)

Line 2456: ICX_POR_EXT_UTL.closeLog;

2452:
2453: PROCEDURE endLog IS
2454: BEGIN
2455: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End...');
2456: ICX_POR_EXT_UTL.closeLog;
2457: END endLog;
2458:
2459: PROCEDURE setCommitSize (pCommitSize IN NUMBER)
2460: IS

Line 2472: xIcxSchema := ICX_POR_EXT_UTL.getIcxSchema;

2468: xIcxSchema VARCHAR2(20);
2469:
2470: BEGIN
2471: xErrLoc := 50;
2472: xIcxSchema := ICX_POR_EXT_UTL.getIcxSchema;
2473:
2474: xErrLoc := 100;
2475: -- ICX_POR_BATCH_JOBS
2476: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||

Line 2529: xIcxSchema := ICX_POR_EXT_UTL.getIcxSchema;

2525: xIcxSchema VARCHAR2(20);
2526:
2527: BEGIN
2528: xErrLoc := 50;
2529: xIcxSchema := ICX_POR_EXT_UTL.getIcxSchema;
2530:
2531: xErrLoc := 100;
2532: -- ICX_CAT_ITEMS_B
2533: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||

Line 2589: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start Data Upgrade...');

2585: FROM icx_por_price_list_lines pll
2586: WHERE pll.item_id = item.rt_item_id));
2587: BEGIN
2588: xErrLoc := 50;
2589: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start Data Upgrade...');
2590:
2591: xErrLoc := 60;
2592: -- Bug 2813141, job tables should be cleaned before odf applied
2593: -- move this procedure into a pre-upgrade script: icxprupi.sql

Line 2607: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN

2603: xErrLoc := 100;
2604: FOR all_item IN cAllItems LOOP
2605: xErrLoc := 140;
2606: gCurrentItem := all_item;
2607: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
2608: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2609: 'gCurrentItem[rt_item_id: ' || gCurrentItem.rt_item_id ||
2610: ', rt_category_id: ' || gCurrentItem.rt_category_id || ']');
2611: END IF;

Line 2608: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,

2604: FOR all_item IN cAllItems LOOP
2605: xErrLoc := 140;
2606: gCurrentItem := all_item;
2607: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
2608: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2609: 'gCurrentItem[rt_item_id: ' || gCurrentItem.rt_item_id ||
2610: ', rt_category_id: ' || gCurrentItem.rt_category_id || ']');
2611: END IF;
2612:

Line 2645: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End Data Upgrade...');

2641: xErrLoc := 900;
2642: upgradeFavoriteList;
2643:
2644: xErrLoc := 1000;
2645: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End Data Upgrade...');
2646: EXCEPTION
2647: WHEN OTHERS THEN
2648: IF (cAllItems%ISOPEN) THEN
2649: CLOSE cAllItems;

Line 2656: ICX_POR_EXT_UTL.pushError(xReturnErr);

2652: rollback;
2653: xReturnErr :=
2654: 'upgrade(' || xErrLoc || '): ' || sqlerrm;
2655: gReturnErr := gReturnErr || '-->' || xReturnErr;
2656: ICX_POR_EXT_UTL.pushError(xReturnErr);
2657: ICX_POR_EXT_UTL.printStackTrace;
2658: raise_application_error(-20000, gReturnErr);
2659: END upgrade;
2660:

Line 2657: ICX_POR_EXT_UTL.printStackTrace;

2653: xReturnErr :=
2654: 'upgrade(' || xErrLoc || '): ' || sqlerrm;
2655: gReturnErr := gReturnErr || '-->' || xReturnErr;
2656: ICX_POR_EXT_UTL.pushError(xReturnErr);
2657: ICX_POR_EXT_UTL.printStackTrace;
2658: raise_application_error(-20000, gReturnErr);
2659: END upgrade;
2660:
2661: END ICX_CAT_FPI_UPGRADE;