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.
PACKAGE BODY: APPS.ITG_MSG

Source


1 PACKAGE BODY itg_msg AS
2 /* ARCS: $Header: itgmsgb.pls 120.9 2006/09/15 13:36:01 pvaddana noship $
3  * CVS:  itgmsgb.pls,v 1.21 2002/12/27 18:35:04 ecoe Exp
4  */
5 
6    l_buff VARCHAR2(4000);
7 
8   FUNCTION chknul(p_text VARCHAR2) RETURN VARCHAR2 IS
9   BEGIN
10     RETURN nvl(p_text,   'NULL');
11   END chknul;
12 
13   PROCEDURE text(p_text VARCHAR2) IS
14   BEGIN
15     fnd_message.set_name('FND',   'FND_GENERIC_MESSAGE');
16     fnd_message.set_token('MESSAGE',   chknul(p_text));
17   END text;
18 
19   PROCEDURE debug(p_pkg_name VARCHAR2,   p_proc_name VARCHAR2,   p_text VARCHAR2) IS
20   BEGIN
21     fnd_message.set_name('ITG',   'ITG_DEBUG');
22     fnd_message.set_token('PKG_NAME',   chknul(p_pkg_name));
23     fnd_message.set_token('PROCEDURE_NAME',   chknul(p_proc_name));
24     fnd_message.set_token('ERROR_TEXT',   chknul(p_text));
25     fnd_msg_pub.ADD;
26   END;
27 
28   PROCEDURE debug_more(p_text VARCHAR2) IS
29   BEGIN
30     fnd_message.set_name('ITG',   'ITG_DEBUG_MORE');
31     fnd_message.set_token('ERROR_TEXT',   chknul(p_text));
32     fnd_msg_pub.ADD;
33   END;
34 
35   PROCEDURE missing_element_value(p_name VARCHAR2,   p_value VARCHAR2) IS
36   BEGIN
37     fnd_message.set_name('ITG',   'ITG_MISSING_ELEMENT_VALUE');
38     fnd_message.set_token('ELEMENT_NAME',   chknul(p_name));
39     fnd_message.set_token('ELEMENT_VALUE',   chknul(p_value));
40     fnd_msg_pub.ADD;
41 
42     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_MISSING_ELEMENT_VALUE',   p_msg_app => 'ITG',   p_token_vals => 'ELEMENT_NAME::' || chknul(p_name) || '^^ELEMENT_VALUE::' || chknul(p_value),   p_translatable => TRUE,   p_reset => FALSE);
43 
44   END;
45 
46   PROCEDURE data_value_error(p_value VARCHAR2,   p_min NUMBER,   p_max NUMBER) IS
47   BEGIN
48     fnd_message.set_name('ITG',   'ITG_DATA_VALUE_ERROR');
49     fnd_message.set_token('DATA_VALUE',   chknul(p_value));
50     fnd_message.set_token('MIN_LENGTH',   chknul(to_char(p_min)));
51     fnd_message.set_token('MAX_LENGTH',   chknul(to_char(p_max)));
52     fnd_msg_pub.ADD;
53 
54     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DATA_VALUE_ERROR',   p_msg_app => 'ITG',   p_token_vals => 'DATA_VALUE::' || chknul(p_value) || '^^MIN_LENGTH::' || chknul(p_min) || '^^MAX_LENGTH::' || chknul(p_max),
55     p_translatable => TRUE,   p_reset => FALSE);
56 
57   END;
58 
59   PROCEDURE update_failed IS
60   BEGIN
61     fnd_message.set_name('ITG',   'ITG_UPDATE_FAILED');
62     fnd_msg_pub.ADD;
63 
64     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_UPDATE_FAILED',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
65 
66   END;
67 
68   PROCEDURE existing_flex_value(p_flex_value VARCHAR2,   p_vset_id NUMBER) IS
69   BEGIN
70     fnd_message.set_name('ITG',   'ITG_EXISTING_FLEX_VALUE');
71     fnd_message.set_token('FLEX_VALUE',   chknul(p_flex_value));
72     fnd_message.set_token('VALUE_SET_ID',   chknul(to_char(p_vset_id)));
73     fnd_msg_pub.ADD;
74 
75     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_EXISTING_FLEX_VALUE',   p_msg_app => 'ITG',   p_token_vals => 'FLEX_VALUE::' || chknul(p_flex_value) || '^^VALUE_SET_ID::' || chknul(p_vset_id),   p_translatable => TRUE,   p_reset => FALSE);
76 
77   END;
78 
79   PROCEDURE invalid_account_type(p_acct_type VARCHAR2) IS
80   BEGIN
81     fnd_message.set_name('ITG',   'ITG_INVALID_ACCOUNT_TYPE');
82     fnd_message.set_token('ACCOUNT_TYPE',   chknul(p_acct_type));
83     fnd_msg_pub.ADD;
84 
85     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVALID_ACCOUNT_TYPE',   p_msg_app => 'ITG',   p_token_vals => 'ACCOUNT_TYPE::' || chknul(p_acct_type),   p_translatable => TRUE,   p_reset => FALSE);
86   END;
87 
88   PROCEDURE flex_insert_fail(p_flex_value VARCHAR2) IS
89   BEGIN
90     fnd_message.set_name('ITG',   'ITG_FLEX_INSERT_FAIL');
91     fnd_message.set_token('FLEX_VALUE',   chknul(p_flex_value));
92     fnd_msg_pub.ADD;
93 
94     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_FLEX_INSERT_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'FLEX_VALUE::' || chknul(p_flex_value),   p_translatable => TRUE,   p_reset => FALSE);
95 
96   END;
97 
98   PROCEDURE flex_update_fail_novalue(p_flex_value VARCHAR2) IS
99   BEGIN
100     fnd_message.set_name('ITG',   'ITG_FLEX_UPDATE_FAIL_NOVALUE');
101     fnd_message.set_token('FLEX_VALUE',   chknul(p_flex_value));
102     fnd_msg_pub.ADD;
103 
104     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_FLEX_UPDATE_FAIL_NOVALUE',   p_msg_app => 'ITG',   p_token_vals => 'FLEX_VALUE::' || chknul(p_flex_value),   p_translatable => TRUE,   p_reset => FALSE);
105   END;
106 
107   PROCEDURE flex_update_fail_notl(p_flex_value VARCHAR2) IS
108   BEGIN
109     fnd_message.set_name('ITG',   'ITG_FLEX_UPDATE_FAIL_NOTL');
110     fnd_message.set_token('FLEX_VALUE',   chknul(p_flex_value));
111     fnd_msg_pub.ADD;
112 
113     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_FLEX_UPDATE_FAIL_NOTL',   p_msg_app => 'ITG',   p_token_vals => 'FLEX_VALUE::' || chknul(p_flex_value),   p_translatable => TRUE,   p_reset => FALSE);
114   END;
115 
116   PROCEDURE invalid_currency_code IS
117   BEGIN
118     fnd_message.set_name('SQLGL',   'GL INVALID CURRENCY CODE');
119     fnd_msg_pub.ADD;
120 
121     itg_x_utils.addcboddescmsg(p_msg_code => 'GL INVALID CURRENCY CODE',   p_msg_app => 'SQLGL',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
122   END;
123 
124   PROCEDURE same_currency_code IS
125   BEGIN
126     fnd_message.set_name('SQLGL',   'GL_GLXRTDLY_SAMECURR');
127     fnd_msg_pub.ADD;
128 
129     itg_x_utils.addcboddescmsg(p_msg_code => 'GL_GLXRTDLY_SAMECURR',   p_msg_app => 'SQLGL',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
130 
131   END;
132 
133   PROCEDURE duplicate_exchange_rate IS
134   BEGIN
135     fnd_message.set_name('SQLGL',   'GL_DUPLICATE_EXCHANGE_RATE');
136     fnd_msg_pub.ADD;
137 
138     itg_x_utils.addcboddescmsg(p_msg_code => 'GL_DUPLICATE_EXCHANGE_RATE',   p_msg_app => 'SQLGL',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
139   END;
140 
141   PROCEDURE no_po_found(p_po_code VARCHAR2,   p_org_id NUMBER) IS
142   BEGIN
143     fnd_message.set_name('ITG',   'ITG_NO_PO_FOUND');
144     fnd_message.set_token('PO_CODE',   chknul(p_po_code));
145     fnd_message.set_token('ORG_ID',   chknul(to_char(p_org_id)));
146     fnd_msg_pub.ADD;
147 
148     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_PO_FOUND',   p_msg_app => 'ITG',   p_token_vals => 'PO_CODE::' || chknul(p_po_code) || '^^ORG_ID::' || chknul(p_org_id),   p_translatable => TRUE,   p_reset => FALSE);
149 
150   END;
151 
152   PROCEDURE no_line_locs_found IS
153   BEGIN
154     fnd_message.set_name('ITG',   'ITG_NO_LINE_LOCS_FOUND');
155     fnd_msg_pub.ADD;
156 
157     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_LINE_LOCS_FOUND',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
158   END;
159 
160   PROCEDURE allocship_toomany_rtn IS
161   BEGIN
162     fnd_message.set_name('ITG',   'ITG_ALLOCSHIP_TOOMANY_RTN');
163     fnd_msg_pub.ADD;
164 
165     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_ALLOCSHIP_TOOMANY_RTN',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
166 
167   END;
168 
169   PROCEDURE allocdist_toomany_rtn IS
170   BEGIN
171     fnd_message.set_name('ITG',   'ITG_ALLOCDIST_TOOMANY_RTN');
172     fnd_msg_pub.ADD;
173 
174     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_ALLOCDIST_TOOMANY_RTN',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
175 
176   END;
177 
178   PROCEDURE allocreqn_toomany_rtn IS
179   BEGIN
180     fnd_message.set_name('ITG',   'ITG_ALLOCREQN_TOOMANY_RTN');
181     fnd_msg_pub.ADD;
182 
183     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_ALLOCREQN_TOOMANY_RTN',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
184 
185   END;
186 
187   PROCEDURE poline_closed_rcv IS
188   BEGIN
189     fnd_message.set_name('ITG',   'ITG_POLINE_CLOSED_RCV');
190     fnd_msg_pub.ADD;
191 
192     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_CLOSED_RCV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
193 
194   END;
195 
196   PROCEDURE poline_zeroqty_rcv IS
197   BEGIN
198     fnd_message.set_name('ITG',   'ITG_POLINE_ZEROQTY_RCV');
199     fnd_msg_pub.ADD;
200 
201     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_ZEROQTY_RCV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
202 
203   END;
204   /* Added to fix bug  5438268 to error out the neg qty RECEIPT */
205   PROCEDURE poline_negqty_rcv IS
206   BEGIN
207   fnd_message.set_name('ITG',   'ITG_POLINE_NEGQTY_RCV');
208     fnd_msg_pub.ADD;
209     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_NEGQTY_RCV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
210   END;
211 
212   PROCEDURE receipt_tol_exceeded IS
213   BEGIN
214     fnd_message.set_name('ITG',   'ITG_RECEIPT_TOL_EXCEEDED');
215     fnd_msg_pub.ADD;
216 
217     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_RECEIPT_TOL_EXCEEDED',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
218 
219   END;
220 
221   PROCEDURE receipt_closepo_fail(p_return_code VARCHAR2) IS
222   BEGIN
223     fnd_message.set_name('ITG',   'ITG_RECEIPT_CLOSEPO_FAIL');
224     fnd_message.set_token('RETURN_CODE',   chknul(p_return_code));
225     fnd_msg_pub.ADD;
226 
227     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_RECEIPT_CLOSEPO_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'RETURN_CODE::' || chknul(p_return_code),   p_translatable => TRUE,   p_reset => FALSE);
228 
229   END;
230  /*Added following procedure to fix bug : 5258514*/
231   PROCEDURE receipt_closerelease_fail( p_return_code VARCHAR2 ) IS
232   BEGIN
233     fnd_message.set_name('ITG',   'ITG_RECEIPT_CLOSERELEASE_FAIL');
234     fnd_message.set_token('RETURN_CODE',   chknul(p_return_code));
235     fnd_msg_pub.ADD;
236 
237     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_RECEIPT_CLOSERELEASE_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'RETURN_CODE::' || chknul(p_return_code),   p_translatable => TRUE,   p_reset => FALSE);
238   END;
239 
240   PROCEDURE inspect_tol_exceeded IS
241   BEGIN
242     fnd_message.set_name('ITG',   'ITG_INSPECT_TOL_EXCEEDED');
243     fnd_msg_pub.ADD;
244 
245     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INSPECT_TOL_EXCEEDED',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
246 
247   END;
248 
249   PROCEDURE poline_negqty_ins IS
250   BEGIN
251     fnd_message.set_name('ITG',   'ITG_POLINE_NEGQTY_INS');
252     fnd_msg_pub.ADD;
253 
254     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_NEGQTY_INS',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
255 
256   END;
257 
258   PROCEDURE poline_zeroqty_ins IS
259   BEGIN
260     fnd_message.set_name('ITG',   'ITG_POLINE_ZEROQTY_INS');
261     fnd_msg_pub.ADD;
262 
263     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_ZEROQTY_INS',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
264 
265   END;
266 
267   PROCEDURE poline_zeroamt_inv IS
268   BEGIN
269     fnd_message.set_name('ITG',   'ITG_POLINE_ZEROAMT_INV');
270     fnd_msg_pub.ADD;
271 
272     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_ZEROAMT_INV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
273 
274   END;
275 
276   PROCEDURE poline_badsign_inv IS
277   BEGIN
278     fnd_message.set_name('ITG',   'ITG_POLINE_BADSIGN_INV');
279     fnd_msg_pub.ADD;
280 
284 
281     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_BADSIGN_INV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
282 
283   END;
285   PROCEDURE poline_closed_inv IS
286   BEGIN
287     fnd_message.set_name('ITG',   'ITG_POLINE_CLOSED_INV');
288     fnd_msg_pub.ADD;
289 
290     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_CLOSED_INV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
291 
292   END;
293 
294   PROCEDURE invoice_tol_exceeded IS
295   BEGIN
296     fnd_message.set_name('ITG',   'ITG_INVOICE_TOL_EXCEEDED');
297     fnd_msg_pub.ADD;
298 
299     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVOICE_TOL_EXCEEDED',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
300 
301   END;
302 
303   PROCEDURE invoice_closepo_fail(p_return_code VARCHAR2) IS
304   BEGIN
305     fnd_message.set_name('ITG',   'ITG_INVOICE_CLOSEPO_FAIL');
306     fnd_message.set_token('RETURN_CODE',   chknul(p_return_code));
307     fnd_msg_pub.ADD;
308 
309     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVOICE_CLOSEPO_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'RETURN_CODE::' || chknul(p_return_code),   p_translatable => TRUE,   p_reset => FALSE);
310 
311   END;
312  /*Added following procedure to fix bug : 5258514*/
313 
314   PROCEDURE invoice_closerelease_fail(p_return_code VARCHAR2) IS
315   BEGIN
316     fnd_message.set_name('ITG',   'ITG_INVOICE_CLOSERELEASE_FAIL');
317     fnd_message.set_token('RETURN_CODE',   chknul(p_return_code));
318     fnd_msg_pub.ADD;
319 
320     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVOICE_CLOSERELEASE_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'RETURN_CODE::' || chknul(p_return_code),   p_translatable => TRUE,   p_reset => FALSE);
321 
322   END;
323 
324   PROCEDURE poline_closed_final IS
325   BEGIN
326     fnd_message.set_name('ITG',   'ITG_POLINE_CLOSED_FINAL');
327     fnd_msg_pub.ADD;
328 
329     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_CLOSED_FINAL',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
330   END;
331 
332   PROCEDURE poline_invalid_doctype IS
333   BEGIN
334     fnd_message.set_name('ITG',   'ITG_POLINE_INVALID_DOCTYPE');
335     fnd_msg_pub.ADD;
336 
337     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_POLINE_INVALID_DOCTYPE',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
338 
339   END;
340 
341   PROCEDURE toomany_base_uom_flag IS
342   BEGIN
343     fnd_message.set_name('ITG',   'ITG_TOOMANY_BASE_UOM_FLAG');
344     fnd_msg_pub.ADD;
345 
346     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_TOOMANY_BASE_UOM_FLAG',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
347 
348   END;
349 
350   PROCEDURE null_disable_date IS
351   BEGIN
352     fnd_message.set_name('ITG',   'ITG_NULL_DISABLE_DATE');
353     fnd_msg_pub.ADD;
354 
355     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NULL_DISABLE_DATE',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
356 
357   END;
358 
359   PROCEDURE delete_failed IS
360   BEGIN
361     fnd_message.set_name('ITG',   'ITG_DELETE_FAILED');
362     fnd_msg_pub.ADD;
363 
364     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DELETE_FAILED',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
365   END;
366 
367   PROCEDURE bad_uom_crossval IS
368   BEGIN
369     fnd_message.set_name('ITG',   'ITG_BAD_UOM_CROSSVAL');
370     fnd_msg_pub.ADD;
371 
372     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_BAD_UOM_CROSSVAL',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
373   END;
374 
375   PROCEDURE toomany_default_conv_flag IS
376   BEGIN
377     fnd_message.set_name('ITG',   'ITG_TOOMANY_DEFAULT_CONV_FLAG');
378     fnd_msg_pub.ADD;
379 
380     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_TOOMANY_DEFAULT_CONV_FLAG',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
381   END;
382 
383   PROCEDURE neg_conv IS
384   BEGIN
385     fnd_message.set_name('INV',   'INV_NEG_CONV');
386     fnd_msg_pub.ADD;
387 
388     itg_x_utils.addcboddescmsg(p_msg_code => 'INV_NEG_CONV',   p_msg_app => 'INV',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
389 
390   END;
391 
392   PROCEDURE conv_not_found(p_uom_code VARCHAR2) IS
393   BEGIN
394     fnd_message.set_name('ITG',   'ITG_CONV_NOT_FOUND');
395     fnd_message.set_token('UOM_CODE',   chknul(p_uom_code));
396     fnd_msg_pub.ADD;
397 
398     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_CONV_NOT_FOUND',   p_msg_app => 'ITG',   p_token_vals => 'UOM_CODE::' || chknul(p_uom_code),   p_translatable => TRUE,   p_reset => FALSE);
399 
400   END;
401 
402   PROCEDURE base_uom_not_found(p_uom_code VARCHAR2) IS
403   BEGIN
404     fnd_message.set_name('ITG',   'ITG_BASE_UOM_NOT_FOUND');
405     fnd_message.set_token('UOM_CODE',   chknul(p_uom_code));
406     fnd_msg_pub.ADD;
407 
408     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_BASE_UOM_NOT_FOUND',   p_msg_app => 'ITG',   p_token_vals => 'UOM_CODE::' || chknul(p_uom_code),   p_translatable => TRUE,   p_reset => FALSE);
409 
410   END;
411 
412   PROCEDURE uom_not_found(p_uom_code VARCHAR2) IS
413   BEGIN
414     fnd_message.set_name('ITG',   'ITG_UOM_NOT_FOUND');
415     fnd_message.set_token('UOM_CODE',   chknul(p_uom_code));
416     fnd_msg_pub.ADD;
417 
421 
418     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_UOM_NOT_FOUND',   p_msg_app => 'ITG',   p_token_vals => 'UOM_CODE::' || chknul(p_uom_code),   p_translatable => TRUE,   p_reset => FALSE);
419 
420   END;
422   PROCEDURE unknown_document_error IS
423   BEGIN
424     fnd_message.set_name('ITG',   'ITG_UNKNOWN_DOCUMENT_ERROR');
425     fnd_msg_pub.ADD;
426 
427     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_UNKNOWN_DOCUMENT_ERROR',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
428   END;
429 
430   PROCEDURE document_success IS
431   BEGIN
432     fnd_message.set_name('ITG',   'ITG_DOCUMENT_SUCCESS');
433     fnd_msg_pub.ADD;
434 
435     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DOCUMENT_SUCCESS',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
436 
437   END;
438 
439   PROCEDURE orgeff_check_failed IS
440   BEGIN
441     fnd_message.set_name('ITG',   'ITG_ORGEFF_CHECK_FAILED');
442     fnd_msg_pub.ADD;
443 
444     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_ORGEFF_CHECK_FAILED',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
445   END;
446 
447   PROCEDURE invalid_argument(p_name VARCHAR2,   p_value VARCHAR2) IS
448   BEGIN
449     fnd_message.set_name('ITG',   'ITG_INVALID_ARGUMENT');
450     fnd_message.set_token('NAME',   chknul(p_name));
451     fnd_message.set_token('VALUE',   chknul(p_value));
452     fnd_msg_pub.ADD;
453 
454     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVALID_ARGUMENT',   p_msg_app => 'ITG',   p_token_vals => 'NAME::' || chknul(p_name) || '^^VALUE::' || chknul(p_value),   p_translatable => TRUE,   p_reset => FALSE);
455   END;
456 
457   PROCEDURE invalid_doc_direction(p_doc_dir VARCHAR2) IS
458   BEGIN
459     fnd_message.set_name('ITG',   'ITG_INVALID_DOC_DIRECTION');
460     fnd_message.set_token('DIRECTION',   chknul(p_doc_dir));
461     fnd_msg_pub.ADD;
462 
463     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVALID_DOC_DIRECTION',   p_msg_app => 'ITG',   p_token_vals => 'DIRECTION::' || chknul(p_doc_dir),   p_translatable => TRUE,   p_reset => FALSE);
464 
465   END;
466 
467   PROCEDURE missing_orgind(p_doc_typ VARCHAR2,   p_doc_dir VARCHAR2) IS
468   BEGIN
469     fnd_message.set_name('ITG',   'ITG_MISSING_ORGIND');
470     fnd_message.set_token('DOC_TYPE',   chknul(p_doc_typ));
471     fnd_message.set_token('DIRECTION',   chknul(p_doc_dir));
472     fnd_msg_pub.ADD;
473 
474     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_MISSING_ORGIND',   p_msg_app => 'ITG',   p_token_vals => 'DOC_TYPE::' || chknul(p_doc_typ) || '^^DIRECTION::' || p_doc_dir,   p_translatable => TRUE,   p_reset => FALSE);
475 
476   END;
477 
478   --- THERE IS NO ADD MESSAGE HERE BY PURPOSE
479   PROCEDURE effectivity_update_fail(p_org_id NUMBER,   p_doc_typ VARCHAR2,   p_doc_dir VARCHAR2,   p_eff_id NUMBER) IS
480   BEGIN
481     fnd_message.set_name('ITG',   'ITG_EFFECTIVITY_UPDATE_FAIL');
482     fnd_message.set_token('ORG_ID',   chknul(to_char(p_org_id)));
483     fnd_message.set_token('DOC_TYPE',   chknul(p_doc_typ));
484     fnd_message.set_token('DIRECTION',   chknul(p_doc_dir));
485     fnd_message.set_token('EFF_ID',   chknul(to_char(p_eff_id)));
486   END;
487 
488   --- THERE IS NO ADD MESSAGE HERE BY PURPOSE
489   PROCEDURE effectivity_insert_fail(p_org_id NUMBER,   p_doc_typ VARCHAR2,   p_doc_dir VARCHAR2) IS
490   BEGIN
491     fnd_message.set_name('ITG',   'ITG_EFFECTIVITY_INSERT_FAIL');
492     fnd_message.set_token('ORG_ID',   chknul(to_char(p_org_id)));
493     fnd_message.set_token('DOC_TYPE',   chknul(p_doc_typ));
494     fnd_message.set_token('DIRECTION',   chknul(p_doc_dir));
495   END;
496 
497   PROCEDURE daily_exchange_rate_error(p_currency_from VARCHAR2,   p_currency_to VARCHAR2,   p_error_code VARCHAR2) IS
498   BEGIN
499 
500     /* p_error_code can be one of:
501 
502         DATE_RANGE_TOO_LARGE
503         DISABLED_FROM_CURRENCY
504         DISABLED_TO_CURRENCY
505         EMU_FROM_CURRENCY
506         EMU_TO_CURRENCY
507         NEGATIVE_CONVERSION_RATE
508         NEGATIVE_INVERSE_RATE
509         NONEXISTANT_CONVERSION_TYPE
510         NONEXISTANT_FROM_CURRENCY
511         NONEXISTANT_TO_CURRENCY
512         OUT_OF_DATE_FROM_CURRENCY
513         OUT_OF_DATE_TO_CURRENCY
514         STATISTICAL_FROM_CURRENCY
515         STATISTICAL_TO_CURRENCY
516 
517         No translated messages for these errors codes seem to be
518         available, so I am passing them through as-is.
519 
520      */ fnd_message.set_name('ITG',   'ITG_DAILY_EXCHANGE_RATE_ERROR');
521     fnd_message.set_token('FROM_CURR',   chknul(p_currency_from));
522     fnd_message.set_token('TO_CURR',   chknul(p_currency_to));
523     fnd_message.set_token('ERROR_CODE',   chknul(p_error_code));
524     fnd_msg_pub.ADD;
525 
526     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DAILY_EXCHANGE_RATE_ERROR',   p_msg_app => 'ITG',   p_token_vals => 'FROM_CURR::' || p_currency_from || '^^TO_CURR::' || p_currency_to || '^^ERROR_CODE::' || p_error_code,
527     p_translatable => TRUE,   p_reset => FALSE);
528   END;
529 
530   PROCEDURE checked_error(p_action VARCHAR2) IS
531   BEGIN
532     fnd_message.set_name('ITG',   'ITG_CHECKED_ERROR');
533     fnd_message.set_token('ACTION',   p_action);
534     fnd_msg_pub.ADD;
535     --ITG_Debug.add_error;
536 
537     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_CHECKED_ERROR',   p_msg_app => 'ITG',   p_token_vals => 'ACTION::' || p_action,   p_translatable => TRUE,   p_reset => FALSE);
538 
539   END;
540 
541   PROCEDURE unexpected_error(p_action VARCHAR2) IS
542   BEGIN
543 
544     fnd_message.set_name('ITG',   'ITG_UNEXPECTED_ERROR');
545     fnd_message.set_token('ACTION',   p_action);
546     fnd_msg_pub.ADD;
547 
551   PROCEDURE invalid_org(p_org_id VARCHAR2) IS
548     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_UNEXPECTED_ERROR',   p_msg_app => 'ITG',   p_token_vals => 'ACTION::' || p_action,   p_translatable => TRUE,   p_reset => FALSE);
549   END;
550 
552   BEGIN
553     fnd_message.set_name('ITG',   'ITG_INVALID_ORG');
554     fnd_message.set_token('ORG_ID',   p_org_id);
555     fnd_msg_pub.ADD;
556 
557     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVALID_ORG',   p_msg_app => 'ITG',   p_token_vals => 'ORG_ID::' || p_org_id,   p_translatable => TRUE,   p_reset => FALSE);
558 
559   END;
560 
561   PROCEDURE vendor_not_found(p_name VARCHAR2) IS
562   BEGIN
563     fnd_message.set_name('ITG',   'ITG_NO_VENDOR');
564     fnd_message.set_token('NAME',   p_name);
565     fnd_msg_pub.ADD;
566 
567     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_VENDOR',   p_msg_app => 'ITG',   p_token_vals => 'NAME::' || p_name,   p_translatable => TRUE,   p_reset => FALSE);
568   END;
569 
570   PROCEDURE no_vendor_site(p_site_code VARCHAR2) IS
571   BEGIN
572     fnd_message.set_name('ITG',   'ITG_NO_VENDORSITE');
573     fnd_message.set_token('NAME',   p_site_code);
574     fnd_msg_pub.ADD;
575 
576     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_VENDORSITE',   p_msg_app => 'ITG',   p_token_vals => 'NAME::' || p_site_code,   p_translatable => TRUE,   p_reset => FALSE);
577   END;
578 
579   PROCEDURE gl_req_fail(p_sob_id VARCHAR2) IS
580   BEGIN
581     fnd_message.set_name('ITG',   'ITG_GLREQ_FAIL');
582     fnd_message.set_token('SOB',   p_sob_id);
583     fnd_msg_pub.ADD;
584 
585     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_GLREQ_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'SOB::' || p_sob_id,   p_translatable => TRUE,   p_reset => FALSE);
586   END;
587 
588   PROCEDURE no_gl_currency(p_sob_id VARCHAR2) IS
589   BEGIN
590     fnd_message.set_name('ITG',   'ITG_NO_GLCURR');
591     fnd_message.set_token('SOB',   p_sob_id);
592     fnd_msg_pub.ADD;
593 
594     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_GLCURR',   p_msg_app => 'ITG',   p_token_vals => 'SOB::' || p_sob_id,   p_translatable => TRUE,   p_reset => FALSE);
595   END;
596 
597   PROCEDURE no_set_of_books(p_sob VARCHAR2) IS
598   BEGIN
599     fnd_message.set_name('ITG',   'ITG_NO_SOB');
600     fnd_message.set_token('SOB',   p_sob);
601     fnd_msg_pub.ADD;
602 
603     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_SOB',   p_msg_app => 'ITG',   p_token_vals => 'SOB::' || p_sob,   p_translatable => TRUE,   p_reset => FALSE);
604   END;
605 
606   PROCEDURE no_gl_period(p_sob VARCHAR2,   p_effective_date VARCHAR2) IS
607   BEGIN
608     fnd_message.set_name('ITG',   'ITG_NO_GLPERIOD');
609     fnd_message.set_token('SOB',   p_sob);
610     fnd_message.set_token('DATE',   p_effective_date);
611     --ITG_Debug.add_error;
612     fnd_msg_pub.ADD;
613 
614     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_GLPERIOD',   p_msg_app => 'ITG',   p_token_vals => 'SOB::' || p_sob || '^^DATE::' || p_effective_date,   p_translatable => TRUE,   p_reset => FALSE);
615   END;
616 
617   PROCEDURE no_uom(p_uom VARCHAR2) IS
618   BEGIN
619     fnd_message.set_name('ITG',   'ITG_NO_UOM');
620     fnd_message.set_token('UOM',   p_uom);
621     fnd_msg_pub.ADD;
622 
623     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_UOM',   p_msg_app => 'ITG',   p_token_vals => 'UOM::' || p_uom,   p_translatable => TRUE,   p_reset => FALSE);
624   END;
625 
626   PROCEDURE no_uom_class(p_uom_class VARCHAR2) IS
627   BEGIN
628     fnd_message.set_name('ITG',   'ITG_NO_UOMCLASS');
629     fnd_message.set_token('UOMCLASS',   p_uom_class);
630     fnd_msg_pub.ADD;
631 
632     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_UOMCLASS',   p_msg_app => 'ITG',   p_token_vals => 'UOMCLASS::' || p_uom_class,   p_translatable => TRUE,   p_reset => FALSE);
633   END;
634 
635   PROCEDURE no_uomclass_conv IS
636   BEGIN
637     fnd_message.set_name('ITG',   'ITG_NO_UOMCLASSCONV');
638     fnd_msg_pub.ADD;
639 
640     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_UOMCLASSCONV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
641   END;
642 
643   PROCEDURE dup_uomclass_conv IS
644   BEGIN
645     fnd_message.set_name('ITG',   'ITG_DUP_UOMCLASSCONV');
646     fnd_msg_pub.ADD;
647 
648     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DUP_UOMCLASSCONV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
649   END;
650 
651   PROCEDURE no_uom_conv IS
652   BEGIN
653     fnd_message.set_name('ITG',   'ITG_NO_UOMCONV');
654     fnd_msg_pub.ADD;
655 
656     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_UOMCONV',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
657   END;
658 
659   PROCEDURE no_req_hdr(p_reqid VARCHAR2,   p_org VARCHAR2) IS
660   BEGIN
661     fnd_message.set_name('ITG',   'ITG_NO_REQHEADER');
662     fnd_message.set_token('REQHDR',   p_org || ':' || p_reqid);
663     fnd_msg_pub.ADD;
664 
665     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_REQHEADER',   p_msg_app => 'ITG',   p_token_vals => 'REQHDR::' || p_org || ':' || p_reqid,   p_translatable => TRUE,   p_reset => FALSE);
666   END;
667 
668   PROCEDURE no_req_line(p_req_id VARCHAR2,   p_req_line VARCHAR2,   p_org VARCHAR2) IS
669   BEGIN
670     fnd_message.set_name('ITG',   'ITG_NO_REQLINE');
671     fnd_message.set_token('REQLINE',   p_org || ':' || p_req_id || ':' || p_req_line);
672     fnd_msg_pub.ADD;
673 
674     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_REQLINE',   p_msg_app => 'ITG',   p_token_vals => 'REQLINE::' || p_org || ':' || p_req_id || ':' || p_req_line,   p_translatable => TRUE,   p_reset => FALSE);
675   END;
676 
680     fnd_message.set_token('POLINE',   p_org_id || ':' || p_po_code || ':' || p_line_num);
677   PROCEDURE no_po_line(p_org_id VARCHAR2,   p_po_code VARCHAR2,   p_line_num VARCHAR2) IS
678   BEGIN
679     fnd_message.set_name('ITG',   'ITG_NO_POLINE');
681     fnd_msg_pub.ADD;
682 
683     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_POLINE',   p_msg_app => 'ITG',   p_token_vals => 'POLINE::' || p_org_id || ':' || p_po_code || ':' || p_line_num,   p_translatable => TRUE,   p_reset => FALSE);
684   END;
685 
686   PROCEDURE incorrect_setup IS
687   BEGIN
688     fnd_message.set_name('ITG',   'ITG_INCORRECT_SETUP');
689     fnd_msg_pub.ADD;
690 
691     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INCORRRECT_SETUP',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
692   END;
693 
694   PROCEDURE mici_only_failed IS
695   BEGIN
696     fnd_message.set_name('ITG',   'ITG_MICI_FAILED');
697     fnd_msg_pub.ADD;
698 
699     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_MICI_FAILED',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
700   END;
701 
702   PROCEDURE no_hazard_class(p_hazrdmatl VARCHAR2) IS
703   BEGIN
704     fnd_message.set_name('ITG',   'ITG_NO_HAZMAT');
705     fnd_message.set_token('HAZMAT',   p_hazrdmatl);
706     fnd_msg_pub.ADD;
707 
708     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_HAZMAT',   p_msg_app => 'ITG',   p_token_vals => 'HAZMAT::' || p_hazrdmatl,   p_translatable => TRUE,   p_reset => FALSE);
709   END;
710 
711   PROCEDURE cln_failure(p_clnmsg VARCHAR2) IS
712   BEGIN
713     fnd_message.set_name('ITG',   'ITG_CLN_FAIL');
714     fnd_message.set_token('MSG',   p_clnmsg);
715     fnd_msg_pub.ADD;
716 
717     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_CLN_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'MSG::' || p_clnmsg,   p_translatable => TRUE,   p_reset => FALSE);
718   END;
719 
720   PROCEDURE no_vset(p_set_id VARCHAR2) IS
721   BEGIN
722     fnd_message.set_name('ITG',   'ITG_NO_VSET');
723     fnd_message.set_token('VSET',   p_set_id);
724     fnd_msg_pub.ADD;
725 
726     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_VSET',   p_msg_app => 'ITG',   p_token_vals => 'VSET::' || p_set_id,   p_translatable => TRUE,   p_reset => FALSE);
727 
728   END;
729 
730   PROCEDURE no_currtype_match(p_curr_from VARCHAR2,   p_curr_to VARCHAR2) IS
731   BEGIN
732     fnd_message.set_name('ITG',   'ITG_CURRTYPE_NOMATCH');
733     fnd_message.set_token('FROM',   p_curr_from);
734     fnd_message.set_token('TO',   p_curr_to);
735     fnd_msg_pub.ADD;
736 
737     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_CURRTYPE_NOMATCH',   p_msg_app => 'ITG',   p_token_vals => 'FROM::' || p_curr_from || '^^TO::' || p_curr_to,   p_translatable => TRUE,   p_reset => FALSE);
738   END;
739 
740   PROCEDURE gl_no_currec(p_sob VARCHAR2,   p_currency_to VARCHAR2) IS
741   BEGIN
742     fnd_message.set_name('ITG',   'ITG_NO_CURR');
743     fnd_message.set_token('SOB',   p_sob);
744     fnd_message.set_token('CURRTO',   p_currency_to);
745     fnd_msg_pub.ADD;
746 
747     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_NO_CURR',   p_msg_app => 'ITG',   p_token_vals => 'SOB::' || p_sob || '^^CURRTO::' || p_currency_to,   p_translatable => TRUE,   p_reset => FALSE);
748   END;
749 
750   PROCEDURE ratetype_noupd IS
751   BEGIN
752     fnd_message.set_name('ITG',   'ITG_RATE_NOUPD');
753     fnd_msg_pub.ADD;
754 
755     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_RATE_NOUPD',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
756   END;
757 
758   PROCEDURE gl_fromcur_wrong(p_sob VARCHAR2,   p_currency_from VARCHAR2) IS
759   BEGIN
760     fnd_message.set_name('ITG',   'ITG_FROMCURR_WRONG');
761     fnd_message.set_token('SOB',   p_sob);
762     fnd_message.set_token('CURRFROM',   p_currency_from);
763     fnd_msg_pub.ADD;
764 
765     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_FROMCURR_WRONG',   p_msg_app => 'ITG',   p_token_vals => 'SOB::' || p_sob || '^^CURRFROM::' || p_currency_from,   p_translatable => TRUE,   p_reset => FALSE);
766   END;
767 
768   PROCEDURE item_commodity_ign IS
769   BEGIN
770     fnd_message.set_name('ITG',   'ITG_CMMDTY_IGN');
771     fnd_msg_pub.ADD;
772 
773     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_CMMDTY_IGN',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
774   END;
775 
776   PROCEDURE item_import_pending(p_ccmid VARCHAR2,   p_status VARCHAR2,   p_phase VARCHAR2) IS
777   BEGIN
778     fnd_message.set_name('ITG',   'ITG_ITEMIMPORT_PENDING');
779     fnd_message.set_token('CCMID',   p_ccmid);
780     fnd_message.set_token('STATUS',   p_status);
781     fnd_message.set_token('PHASE',   p_phase);
782     fnd_msg_pub.ADD;
783 
784     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_ITEMIMPORT_PENDING',   p_msg_app => 'ITG',   p_token_vals => 'CCMID::' || p_ccmid || '^^STATUS::' || p_status || '^^PHASE::' || p_phase,   p_translatable => TRUE,   p_reset => FALSE);
785   END;
786 
787   /* Additional error messages exist, for the effectivities screen.
788      These are not wrapped in functions, because they are not called from
789      the PL/SQL code:
790 
791      ITG_EFF_INVALID_ORG_ID_EX
792      ITG_EFF_OBJ_NOT_FOUND_EX: OBJECT_NAME
793      ITG_EFF_ORG_EX
794      ITG_EFF_ORG_ID_EX
795      ITG_EFF_ORG_NAME_EX
796      ITG_EFF_SQL_EX
797    */
798 
799   PROCEDURE itemcat_import_pending(p_ccmid VARCHAR2) IS
800   BEGIN
801     fnd_message.set_name('ITG',   'ITG_ITEMCATIMPORT_PENDING');
802     fnd_message.set_token('CCMID',   p_ccmid);
803     fnd_msg_pub.ADD;
804 
808   PROCEDURE inv_cp_fail(p_status VARCHAR2,   p_phase VARCHAR2) IS
805     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_ITEMCATIMPORT_PENDING',   p_msg_app => 'ITG',   p_token_vals => 'CCMID::' || p_ccmid,   p_translatable => TRUE,   p_reset => FALSE);
806   END;
807 
809   BEGIN
810     fnd_message.set_name('ITG',   'ITG_INVCP_FAIL');
811     fnd_message.set_token('PHASE',   p_phase);
812     fnd_message.set_token('STATUS',   p_status);
813     fnd_msg_pub.ADD;
814 
815     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INVCP_FAIL',   p_msg_app => 'ITG',   p_token_vals => 'STATUS::' || p_status || '^^PHASE::' || p_phase,   p_translatable => TRUE,   p_reset => FALSE);
816   END;
817 
818   PROCEDURE item_import_errors IS
819   BEGIN
820     fnd_message.set_name('ITG',   'ITG_ITEMIMPORT_ERRORS');
821     fnd_msg_pub.ADD;
822 
823     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_ITEMIMPORT_ERRORS',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
824   END;
825 
826   PROCEDURE dup_vendor IS
827   BEGIN
828     fnd_message.set_name('ITG',   'ITG_DUP_VENDOR');
829     fnd_msg_pub.ADD;
830 
831     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DUP_VENDOR',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
832   END;
833 
834   PROCEDURE vendor_contact_only IS
835   BEGIN
836     fnd_message.set_name('ITG',   'ITG_VENDOR_CONTACT');
837     fnd_msg_pub.ADD;
838 
839     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_VENDOR_CONTACT',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
840   END;
841 
842   PROCEDURE vendor_site_only IS
843   BEGIN
844     fnd_message.set_name('ITG',   'ITG_VENDOR_SITE');
845     fnd_msg_pub.ADD;
846 
847     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_VENDOR_SITE',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
848   END;
849 
850   PROCEDURE sup_number_exists(p_sup_no VARCHAR2) IS
851   BEGIN
852     fnd_message.set_name('ITG',   'ITG_DUP_SUPNO');
853     fnd_message.set_token('SUPNO',   p_sup_no);
854     fnd_msg_pub.ADD;
855 
856     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DUP_SUPNO',   p_msg_app => 'ITG',   p_token_vals => 'SUPNO::' || chknul(p_sup_no),   p_translatable => TRUE,   p_reset => FALSE);
857   END;
858 
859   PROCEDURE dup_uom(p_uom_code VARCHAR2,   p_unit_of_measure VARCHAR2) IS
860   BEGIN
861     fnd_message.set_name('ITG',   'ITG_DUP_UOM');
862     fnd_message.set_token('UOM_CODE',   p_uom_code);
863     fnd_message.set_token('UNIT_OF_MEASURE',   p_unit_of_measure);
864     fnd_msg_pub.ADD;
865 
866     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DUP_UOM',   p_msg_app => 'ITG',   p_token_vals => 'UOM_CODE::' || p_uom_code || '^^UNIT_OF_MEASURE::' || p_unit_of_measure,   p_translatable => TRUE,   p_reset => FALSE);
867   END;
868 
869   PROCEDURE dup_uom_conv(p_item VARCHAR2,   p_uom VARCHAR2) IS
870   BEGIN
871     fnd_message.set_name('ITG',   'ITG_DUP_UOMCONV');
872     fnd_message.set_token('ITEM',   p_item);
873     fnd_message.set_token('UOM',   p_uom);
874     fnd_msg_pub.ADD;
875 
876     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_DUP_UOMCONV',   p_msg_app => 'ITG',   p_token_vals => 'ITEM::' || chknul(p_item) || '^^UOM::' || chknul(p_uom),   p_translatable => TRUE,   p_reset => FALSE);
877   END;
878 
879   PROCEDURE apicallret(p_api VARCHAR2,   p_retcode VARCHAR2,   p_retmsg VARCHAR2) IS
880   BEGIN
881     fnd_message.set_name('ITG',   'ITG_APICALL_RET');
882     fnd_message.set_token('API',   p_api);
883     fnd_message.set_token('RETSTS',   p_retcode);
884     fnd_message.set_token('RETMSG',   p_retmsg);
885     fnd_msg_pub.ADD;
886 
887     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_APICALL_RET',   p_msg_app => 'ITG',   p_token_vals => 'API::' || chknul(p_api) || '^^RETSTS::' || chknul(p_retcode) || '^^RETMSG::' || chknul(p_retmsg),   p_translatable => TRUE,   p_reset => FALSE);
888   END;
889 
890   PROCEDURE uomconvrate_err IS
891   BEGIN
892     fnd_message.set_name('ITG',   'ITG_UOMCONVRATE_ERR');
893     fnd_msg_pub.ADD;
894 
895     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_UOMCONVRATE_ERR',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
896   END;
897 
898 /* Adding following two procs to fix  the  bug 4882347 */
899   PROCEDURE inv_qty_larg_than_exp IS
900   BEGIN
901     fnd_message.set_name('ITG',   'ITG_INV_QTY_LARGER_ERR');
902     fnd_msg_pub.ADD;
903     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INV_QTY_LARGER_ERR',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
904    END;
905 
906   PROCEDURE insp_qty_larg_than_exp IS
907   BEGIN
908     fnd_message.set_name('ITG',   'ITG_INSP_QTY_LARGER_ERR');
909     fnd_msg_pub.ADD;
910     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_INSP_QTY_LARGER_ERR',   p_msg_app => 'ITG',   p_token_vals => NULL,   p_translatable => TRUE,   p_reset => FALSE);
911    END;
912   /*Added to validate flex_value max size in COA inbound transaction  to fix bug : 5533589 */
913   PROCEDURE INVALID_FLEXVAL_LENGTH(p_vset_id  NUMBER,p_flex_value  VARCHAR2) IS
914   BEGIN
915     fnd_message.set_name('ITG',   'ITG_FLEX_VALUE_MAXSIZE_ERR');
916     fnd_message.set_token('VSET',   p_vset_id);
917     fnd_message.set_token('FLEXVAL',   p_flex_value);
918     fnd_msg_pub.ADD;
919 
920     itg_x_utils.addcboddescmsg(p_msg_code => 'ITG_FLEX_VALUE_MAXSIZE_ERR',   p_msg_app => 'ITG',   p_token_vals => 'FLEXVAL::' || chknul(p_flex_value) || '^^VSET::' || chknul(p_vset_id),   p_translatable => TRUE,   p_reset => FALSE);
921 
922   END;
923 
924 
925 
926   END itg_msg;