112: TEMPLATE_OUTSIDE_BLANKET)
113: THEN
114: IF pStatus = INACTIVE_TEMPLATE THEN
115: xErrLoc := 310;
116: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_TEMPLATE');
117: ELSIF pStatus = TEMPLATE_INACTIVE_BLANKET THEN
118: xErrLoc := 320;
119: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INACTIVE_BLANK');
120: ELSIF pStatus = TEMPLATE_INEFFECTIVE_BLANKET THEN
115: xErrLoc := 310;
116: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_TEMPLATE');
117: ELSIF pStatus = TEMPLATE_INACTIVE_BLANKET THEN
118: xErrLoc := 320;
119: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INACTIVE_BLANK');
120: ELSIF pStatus = TEMPLATE_INEFFECTIVE_BLANKET THEN
121: xErrLoc := 330;
122: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INEFFECTIVE_BLANK');
123: ELSIF pStatus = TEMPLATE_INACTIVE_BLANKET_LINE THEN
118: xErrLoc := 320;
119: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INACTIVE_BLANK');
120: ELSIF pStatus = TEMPLATE_INEFFECTIVE_BLANKET THEN
121: xErrLoc := 330;
122: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INEFFECTIVE_BLANK');
123: ELSIF pStatus = TEMPLATE_INACTIVE_BLANKET_LINE THEN
124: xErrLoc := 340;
125: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INACTIVE_BLANK_LN');
126: ELSIF pStatus = TEMPLATE_OUTSIDE_BLANKET THEN
121: xErrLoc := 330;
122: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INEFFECTIVE_BLANK');
123: ELSIF pStatus = TEMPLATE_INACTIVE_BLANKET_LINE THEN
124: xErrLoc := 340;
125: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INACTIVE_BLANK_LN');
126: ELSIF pStatus = TEMPLATE_OUTSIDE_BLANKET THEN
127: xErrLoc := 350;
128: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_OUTSIDE_BLANK_LN');
129: END IF;
124: xErrLoc := 340;
125: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_INACTIVE_BLANK_LN');
126: ELSIF pStatus = TEMPLATE_OUTSIDE_BLANKET THEN
127: xErrLoc := 350;
128: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_OUTSIDE_BLANK_LN');
129: END IF;
130:
131: xErrLoc := 360;
132: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
128: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMP_OUTSIDE_BLANK_LN');
129: END IF;
130:
131: xErrLoc := 360;
132: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
133: xErrLoc := 370;
134: fnd_message.set_token('TEMPLATE_NAME', pDocName);
135: xErrLoc := 380;
136: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
130:
131: xErrLoc := 360;
132: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
133: xErrLoc := 370;
134: fnd_message.set_token('TEMPLATE_NAME', pDocName);
135: xErrLoc := 380;
136: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
137: xErrLoc := 390;
138: xMessage := fnd_message.get;
132: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
133: xErrLoc := 370;
134: fnd_message.set_token('TEMPLATE_NAME', pDocName);
135: xErrLoc := 380;
136: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
137: xErrLoc := 390;
138: xMessage := fnd_message.get;
139:
140: xErrLoc := 395;
134: fnd_message.set_token('TEMPLATE_NAME', pDocName);
135: xErrLoc := 380;
136: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
137: xErrLoc := 390;
138: xMessage := fnd_message.get;
139:
140: xErrLoc := 395;
141: RETURN xMessage;
142: END IF;
149: GLOBAL_AGREEMENT_INVALID_UOM)
150: THEN
151: IF pStatus = INACTIVE_BLANKET THEN
152: xErrLoc := 410;
153: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_BLANKET');
154: ELSIF pStatus = INEFFECTIVE_BLANKET THEN
155: xErrLoc := 420;
156: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INEFFECTIVE_BLANKET');
157: ELSIF pStatus = INACTIVE_BLANKET_LINE THEN
152: xErrLoc := 410;
153: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_BLANKET');
154: ELSIF pStatus = INEFFECTIVE_BLANKET THEN
155: xErrLoc := 420;
156: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INEFFECTIVE_BLANKET');
157: ELSIF pStatus = INACTIVE_BLANKET_LINE THEN
158: xErrLoc := 430;
159: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_BLANKET_LINE');
160: ELSIF pStatus = OUTSIDE_BLANKET THEN
155: xErrLoc := 420;
156: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INEFFECTIVE_BLANKET');
157: ELSIF pStatus = INACTIVE_BLANKET_LINE THEN
158: xErrLoc := 430;
159: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_BLANKET_LINE');
160: ELSIF pStatus = OUTSIDE_BLANKET THEN
161: xErrLoc := 440;
162: fnd_message.set_name(xIcxSchema, 'ICX_CAT_OUTSIDE_BLANKET');
163: ELSIF pStatus = GLOBAL_AGREEMENT_DISABLED THEN
158: xErrLoc := 430;
159: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_BLANKET_LINE');
160: ELSIF pStatus = OUTSIDE_BLANKET THEN
161: xErrLoc := 440;
162: fnd_message.set_name(xIcxSchema, 'ICX_CAT_OUTSIDE_BLANKET');
163: ELSIF pStatus = GLOBAL_AGREEMENT_DISABLED THEN
164: xErrLoc := 442;
165: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_DISABLED');
166: ELSIF pStatus = GLOBAL_AGREEMENT_INVALID_ITEM THEN
161: xErrLoc := 440;
162: fnd_message.set_name(xIcxSchema, 'ICX_CAT_OUTSIDE_BLANKET');
163: ELSIF pStatus = GLOBAL_AGREEMENT_DISABLED THEN
164: xErrLoc := 442;
165: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_DISABLED');
166: ELSIF pStatus = GLOBAL_AGREEMENT_INVALID_ITEM THEN
167: xErrLoc := 444;
168: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_ITEM');
169: ELSIF pStatus = GLOBAL_AGREEMENT_INVALID_UOM THEN
164: xErrLoc := 442;
165: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_DISABLED');
166: ELSIF pStatus = GLOBAL_AGREEMENT_INVALID_ITEM THEN
167: xErrLoc := 444;
168: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_ITEM');
169: ELSIF pStatus = GLOBAL_AGREEMENT_INVALID_UOM THEN
170: xErrLoc := 446;
171: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_UOM');
172: END IF;
167: xErrLoc := 444;
168: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_ITEM');
169: ELSIF pStatus = GLOBAL_AGREEMENT_INVALID_UOM THEN
170: xErrLoc := 446;
171: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_UOM');
172: END IF;
173:
174: xErrLoc := 450;
175: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
171: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_UOM');
172: END IF;
173:
174: xErrLoc := 450;
175: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
176: xErrLoc := 460;
177: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
178: xErrLoc := 470;
179: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
173:
174: xErrLoc := 450;
175: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
176: xErrLoc := 460;
177: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
178: xErrLoc := 470;
179: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
180: xErrLoc := 480;
181: xMessage := fnd_message.get;
175: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
176: xErrLoc := 460;
177: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
178: xErrLoc := 470;
179: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
180: xErrLoc := 480;
181: xMessage := fnd_message.get;
182:
183: xErrLoc := 490;
177: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
178: xErrLoc := 470;
179: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
180: xErrLoc := 480;
181: xMessage := fnd_message.get;
182:
183: xErrLoc := 490;
184: RETURN xMessage;
185: END IF;
185: END IF;
186:
187: xErrLoc := 492;
188: IF pStatus = GLOBAL_AGREEMENT_INVALID_SITE THEN
189: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_SITE');
190: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
191: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
192: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
193: fnd_message.set_token('SUPPLIER_SITE_CODE', pExtraValue2);
186:
187: xErrLoc := 492;
188: IF pStatus = GLOBAL_AGREEMENT_INVALID_SITE THEN
189: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_SITE');
190: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
191: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
192: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
193: fnd_message.set_token('SUPPLIER_SITE_CODE', pExtraValue2);
194: xMessage := fnd_message.get;
187: xErrLoc := 492;
188: IF pStatus = GLOBAL_AGREEMENT_INVALID_SITE THEN
189: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_SITE');
190: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
191: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
192: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
193: fnd_message.set_token('SUPPLIER_SITE_CODE', pExtraValue2);
194: xMessage := fnd_message.get;
195:
188: IF pStatus = GLOBAL_AGREEMENT_INVALID_SITE THEN
189: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_SITE');
190: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
191: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
192: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
193: fnd_message.set_token('SUPPLIER_SITE_CODE', pExtraValue2);
194: xMessage := fnd_message.get;
195:
196: RETURN xMessage;
189: fnd_message.set_name(xIcxSchema, 'ICX_CAT_GA_INVALID_SITE');
190: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
191: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
192: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
193: fnd_message.set_token('SUPPLIER_SITE_CODE', pExtraValue2);
194: xMessage := fnd_message.get;
195:
196: RETURN xMessage;
197: END IF;
190: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
191: fnd_message.set_token('AGREEMENT_NUMBER', pDocName);
192: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
193: fnd_message.set_token('SUPPLIER_SITE_CODE', pExtraValue2);
194: xMessage := fnd_message.get;
195:
196: RETURN xMessage;
197: END IF;
198:
201: QUOTATION_NO_EFFECTIVE_PRICE)
202: THEN
203: IF pStatus = INACTIVE_QUOTATION THEN
204: xErrLoc := 510;
205: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_QUOTATION');
206: ELSIF pStatus = INEFFECTIVE_QUOTATION THEN
207: xErrLoc := 520;
208: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INEFFECTIVE_QUOTATION');
209: ELSIF pStatus = QUOTATION_NO_EFFECTIVE_PRICE THEN
204: xErrLoc := 510;
205: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INACTIVE_QUOTATION');
206: ELSIF pStatus = INEFFECTIVE_QUOTATION THEN
207: xErrLoc := 520;
208: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INEFFECTIVE_QUOTATION');
209: ELSIF pStatus = QUOTATION_NO_EFFECTIVE_PRICE THEN
210: xErrLoc := 530;
211: fnd_message.set_name(xIcxSchema, 'ICX_CAT_QUOTE_NO_EFFECT_PRICE');
212: END IF;
207: xErrLoc := 520;
208: fnd_message.set_name(xIcxSchema, 'ICX_CAT_INEFFECTIVE_QUOTATION');
209: ELSIF pStatus = QUOTATION_NO_EFFECTIVE_PRICE THEN
210: xErrLoc := 530;
211: fnd_message.set_name(xIcxSchema, 'ICX_CAT_QUOTE_NO_EFFECT_PRICE');
212: END IF;
213:
214: xErrLoc := 550;
215: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
211: fnd_message.set_name(xIcxSchema, 'ICX_CAT_QUOTE_NO_EFFECT_PRICE');
212: END IF;
213:
214: xErrLoc := 550;
215: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
216: xErrLoc := 560;
217: fnd_message.set_token('QUOTATION_NUMBER', pDocName);
218: xErrLoc := 570;
219: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
213:
214: xErrLoc := 550;
215: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
216: xErrLoc := 560;
217: fnd_message.set_token('QUOTATION_NUMBER', pDocName);
218: xErrLoc := 570;
219: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
220: xErrLoc := 580;
221: xMessage := fnd_message.get;
215: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
216: xErrLoc := 560;
217: fnd_message.set_token('QUOTATION_NUMBER', pDocName);
218: xErrLoc := 570;
219: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
220: xErrLoc := 580;
221: xMessage := fnd_message.get;
222:
223: xErrLoc := 590;
217: fnd_message.set_token('QUOTATION_NUMBER', pDocName);
218: xErrLoc := 570;
219: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
220: xErrLoc := 580;
221: xMessage := fnd_message.get;
222:
223: xErrLoc := 590;
224: RETURN xMessage;
225: END IF;
229: ASL_NO_PRICE)
230: THEN
231: IF pStatus = DISABLED_ASL THEN
232: xErrLoc := 610;
233: fnd_message.set_name(xIcxSchema, 'ICX_CAT_DISABLED_ASL');
234: ELSIF pStatus = UNALLOWED_ASL THEN
235: xErrLoc := 620;
236: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNALLOWED_ASL');
237: ELSIF pStatus = ASL_NO_PRICE THEN
232: xErrLoc := 610;
233: fnd_message.set_name(xIcxSchema, 'ICX_CAT_DISABLED_ASL');
234: ELSIF pStatus = UNALLOWED_ASL THEN
235: xErrLoc := 620;
236: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNALLOWED_ASL');
237: ELSIF pStatus = ASL_NO_PRICE THEN
238: xErrLoc := 630;
239: fnd_message.set_name(xIcxSchema, 'ICX_CAT_ASL_NO_PRICE');
240: END IF;
235: xErrLoc := 620;
236: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNALLOWED_ASL');
237: ELSIF pStatus = ASL_NO_PRICE THEN
238: xErrLoc := 630;
239: fnd_message.set_name(xIcxSchema, 'ICX_CAT_ASL_NO_PRICE');
240: END IF;
241:
242: xErrLoc := 650;
243: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
239: fnd_message.set_name(xIcxSchema, 'ICX_CAT_ASL_NO_PRICE');
240: END IF;
241:
242: xErrLoc := 650;
243: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
244: xErrLoc := 660;
245: fnd_message.set_token('SUPPLIER_NAME', pDocName);
246: xErrLoc := 670;
247: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
241:
242: xErrLoc := 650;
243: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
244: xErrLoc := 660;
245: fnd_message.set_token('SUPPLIER_NAME', pDocName);
246: xErrLoc := 670;
247: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
248: xErrLoc := 680;
249: xMessage := fnd_message.get;
243: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
244: xErrLoc := 660;
245: fnd_message.set_token('SUPPLIER_NAME', pDocName);
246: xErrLoc := 670;
247: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
248: xErrLoc := 680;
249: xMessage := fnd_message.get;
250:
251: xErrLoc := 690;
245: fnd_message.set_token('SUPPLIER_NAME', pDocName);
246: xErrLoc := 670;
247: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
248: xErrLoc := 680;
249: xMessage := fnd_message.get;
250:
251: xErrLoc := 690;
252: RETURN xMessage;
253: END IF;
257: UNPURCHASABLE_NOTINTERNAL, ITEM_NO_PRICE)
258: THEN
259: IF pStatus = UNPURCHASABLE_OUTSIDE THEN
260: xErrLoc := 710;
261: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNPURCHAE_OUTSIDE');
262: ELSIF pStatus = NOTINTERNAL THEN
263: xErrLoc := 720;
264: fnd_message.set_name(xIcxSchema, 'ICX_CAT_NOINTERNAL');
265: ELSIF pStatus = UNPURCHASABLE_NOTINTERNAL THEN
260: xErrLoc := 710;
261: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNPURCHAE_OUTSIDE');
262: ELSIF pStatus = NOTINTERNAL THEN
263: xErrLoc := 720;
264: fnd_message.set_name(xIcxSchema, 'ICX_CAT_NOINTERNAL');
265: ELSIF pStatus = UNPURCHASABLE_NOTINTERNAL THEN
266: xErrLoc := 730;
267: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNPURCHASE_NOINTERNAL');
268: ELSIF pStatus = ITEM_NO_PRICE THEN
263: xErrLoc := 720;
264: fnd_message.set_name(xIcxSchema, 'ICX_CAT_NOINTERNAL');
265: ELSIF pStatus = UNPURCHASABLE_NOTINTERNAL THEN
266: xErrLoc := 730;
267: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNPURCHASE_NOINTERNAL');
268: ELSIF pStatus = ITEM_NO_PRICE THEN
269: xErrLoc := 740;
270: fnd_message.set_name(xIcxSchema, 'ICX_CAT_ITEM_NO_PRICE');
271: END IF;
266: xErrLoc := 730;
267: fnd_message.set_name(xIcxSchema, 'ICX_CAT_UNPURCHASE_NOINTERNAL');
268: ELSIF pStatus = ITEM_NO_PRICE THEN
269: xErrLoc := 740;
270: fnd_message.set_name(xIcxSchema, 'ICX_CAT_ITEM_NO_PRICE');
271: END IF;
272:
273: xErrLoc := 750;
274: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
270: fnd_message.set_name(xIcxSchema, 'ICX_CAT_ITEM_NO_PRICE');
271: END IF;
272:
273: xErrLoc := 750;
274: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
275: xErrLoc := 770;
276: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
277: xErrLoc := 780;
278: xMessage := fnd_message.get;
272:
273: xErrLoc := 750;
274: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
275: xErrLoc := 770;
276: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
277: xErrLoc := 780;
278: xMessage := fnd_message.get;
279:
280: xErrLoc := 790;
274: fnd_message.set_token('INVENTORY_ORGANIZATION', pOrgName);
275: xErrLoc := 770;
276: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
277: xErrLoc := 780;
278: xMessage := fnd_message.get;
279:
280: xErrLoc := 790;
281: RETURN xMessage;
282: END IF;
283:
284: xErrLoc := 800;
285: IF pStatus = CATEGORY_NOT_EXTRACTED THEN
286: xErrLoc := 810;
287: fnd_message.set_name(xIcxSchema, 'ICX_CAT_CATEGORY_NOT_EXTRACTED');
288: xErrLoc := 850;
289: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
290: xErrLoc := 860;
291: fnd_message.set_token('ITEM_CATEGORY', pDocName);
285: IF pStatus = CATEGORY_NOT_EXTRACTED THEN
286: xErrLoc := 810;
287: fnd_message.set_name(xIcxSchema, 'ICX_CAT_CATEGORY_NOT_EXTRACTED');
288: xErrLoc := 850;
289: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
290: xErrLoc := 860;
291: fnd_message.set_token('ITEM_CATEGORY', pDocName);
292: xErrLoc := 870;
293: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
287: fnd_message.set_name(xIcxSchema, 'ICX_CAT_CATEGORY_NOT_EXTRACTED');
288: xErrLoc := 850;
289: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
290: xErrLoc := 860;
291: fnd_message.set_token('ITEM_CATEGORY', pDocName);
292: xErrLoc := 870;
293: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
294: xErrLoc := 880;
295: xMessage := fnd_message.get;
289: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
290: xErrLoc := 860;
291: fnd_message.set_token('ITEM_CATEGORY', pDocName);
292: xErrLoc := 870;
293: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
294: xErrLoc := 880;
295: xMessage := fnd_message.get;
296:
297: xErrLoc := 890;
291: fnd_message.set_token('ITEM_CATEGORY', pDocName);
292: xErrLoc := 870;
293: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
294: xErrLoc := 880;
295: xMessage := fnd_message.get;
296:
297: xErrLoc := 890;
298: RETURN xMessage;
299: END IF;
300:
301: xErrLoc := 900;
302: IF pStatus = TEMPLATE_HEADER_NOT_EXTRACTED THEN
303: xErrLoc := 910;
304: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMPHEAD_NOT_EXTRACTED');
305: xErrLoc := 950;
306: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
307: xErrLoc := 960;
308: fnd_message.set_token('TEMPLATE_NAME', pDocName);
302: IF pStatus = TEMPLATE_HEADER_NOT_EXTRACTED THEN
303: xErrLoc := 910;
304: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMPHEAD_NOT_EXTRACTED');
305: xErrLoc := 950;
306: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
307: xErrLoc := 960;
308: fnd_message.set_token('TEMPLATE_NAME', pDocName);
309: xErrLoc := 970;
310: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
304: fnd_message.set_name(xIcxSchema, 'ICX_CAT_TEMPHEAD_NOT_EXTRACTED');
305: xErrLoc := 950;
306: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
307: xErrLoc := 960;
308: fnd_message.set_token('TEMPLATE_NAME', pDocName);
309: xErrLoc := 970;
310: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
311: xErrLoc := 980;
312: xMessage := fnd_message.get;
306: fnd_message.set_token('OPERATING_UNIT_NAME', pOrgName);
307: xErrLoc := 960;
308: fnd_message.set_token('TEMPLATE_NAME', pDocName);
309: xErrLoc := 970;
310: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
311: xErrLoc := 980;
312: xMessage := fnd_message.get;
313:
314: xErrLoc := 990;
308: fnd_message.set_token('TEMPLATE_NAME', pDocName);
309: xErrLoc := 970;
310: fnd_message.set_token('ITEM_NUMBER', pExtraValue);
311: xErrLoc := 980;
312: xMessage := fnd_message.get;
313:
314: xErrLoc := 990;
315: RETURN xMessage;
316: END IF;