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.ITG_SYNCUOMINBOUND_PVT dependencies on ITG_MSG

Line 19: ITG_MSG.data_value_error(p_value, p_min, p_max);

15: ) RETURN VARCHAR2 IS
16: BEGIN
17: IF LENGTHB(p_value) NOT BETWEEN p_min AND p_max THEN /* bug 4002567*/
18: ITG_Debug.msg('cs', 'Length check failed for field '||p_desc);
19: ITG_MSG.data_value_error(p_value, p_min, p_max);
20: RAISE FND_API.G_EXC_ERROR;
21: END IF;
22: RETURN p_value;
23: END check_size;

Line 32: ITG_MSG.missing_element_value('BASEUOMFL', p_uom_rec.base_uom_flag);

28: l_count NUMBER := 0;
29: BEGIN
30: g_action := 'UOM parameters validation';
31: IF NVL(p_uom_rec.base_uom_flag, 'z') NOT IN ('Y', 'N') THEN
32: ITG_MSG.missing_element_value('BASEUOMFL', p_uom_rec.base_uom_flag);
33: RAISE FND_API.G_EXC_ERROR;
34: END IF;
35:
36:

Line 45: itg_msg.dup_uom(p_uom_rec.uom_code,p_uom_rec.unit_of_measure);

41: where (uom_code = p_uom_rec.uom_code and unit_of_measure <> p_uom_rec.unit_of_measure)
42: or (uom_code <> p_uom_rec.uom_code and unit_of_measure = p_uom_rec.unit_of_measure);
43:
44: if l_count > 0 then
45: itg_msg.dup_uom(p_uom_rec.uom_code,p_uom_rec.unit_of_measure);
46: raise FND_API.G_EXC_ERROR;
47: end if;
48:
49: IF p_uom_rec.base_uom_flag = 'Y' THEN

Line 56: ITG_MSG.toomany_base_uom_flag;

52: FROM mtl_units_of_measure
53: WHERE base_uom_flag = 'Y'
54: AND uom_class = p_uom_rec.uom_class;
55: IF l_count > 0 THEN
56: ITG_MSG.toomany_base_uom_flag;
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59: END IF;
60:

Line 105: ITG_MSG.null_disable_date;

101: ) IS
102: BEGIN
103: g_action := 'UOM disable';
104: IF p_uom_rec.disable_date IS NULL THEN
105: ITG_MSG.null_disable_date;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: UPDATE mtl_units_of_measure_tl

Line 121: ITG_MSG.no_uom(p_uom_rec.unit_of_measure||'-'||p_uom_rec.uom_code||'-'||p_uom_rec.uom_class);

117: AND uom_class = p_uom_rec.uom_class
118: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
119:
120: IF SQL%ROWCOUNT = 0 THEN
121: ITG_MSG.no_uom(p_uom_rec.unit_of_measure||'-'||p_uom_rec.uom_code||'-'||p_uom_rec.uom_class);
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: END delete_uom;
125:

Line 144: ITG_MSG.no_uom(p_uom_rec.unit_of_measure||'-'||p_uom_rec.uom_code||'-'||p_uom_rec.uom_class);

140: AND uom_class = p_uom_rec.uom_class
141: AND USERENV('LANG') IN (language, source_lang);
142:
143: IF SQL%ROWCOUNT = 0 THEN
144: ITG_MSG.no_uom(p_uom_rec.unit_of_measure||'-'||p_uom_rec.uom_code||'-'||p_uom_rec.uom_class);
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: END update_uom;
148:

Line 172: ITG_MSG.missing_element_value('UOMCLASS', p_uom_class);

168: RETURN;
169: END IF;
170: END IF;
171:
172: ITG_MSG.missing_element_value('UOMCLASS', p_uom_class);
173: RAISE FND_API.G_EXC_ERROR;
174: END valid_uom_class;
175:
176: FUNCTION valid_number(

Line 184: ITG_MSG.missing_element_value(p_name, p_value);

180: BEGIN
181: RETURN TO_NUMBER(p_value);
182: EXCEPTION
183: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
184: ITG_MSG.missing_element_value(p_name, p_value);
185: RAISE FND_API.G_EXC_ERROR;
186: END valid_number;
187:
188: FUNCTION reduce_conv_rate (

Line 206: itg_msg.uomconvrate_err;

202: /* Reduce the fraction to a decimal value */
203: RETURN SUBSTRB(TO_CHAR(l_result), 1, 40);/* bug 4002567*/
204: EXCEPTION
205: WHEN OTHERS THEN
206: itg_msg.uomconvrate_err;
207: RAISE FND_API.G_EXC_ERROR;
208: END reduce_conv_rate;
209:
210: FUNCTION cross_validate(

Line 228: ITG_MSG.bad_uom_crossval;

224: RETURN l_base;
225:
226: EXCEPTION
227: WHEN NO_DATA_FOUND THEN
228: ITG_MSG.bad_uom_crossval;
229: RAISE FND_API.G_EXC_ERROR;
230: END cross_validate;
231:
232: FUNCTION get_default_conv_flag(

Line 267: ITG_MSG.conv_not_found(p_uom_code);

263: RETURN l_conv_rate;
264:
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: ITG_MSG.conv_not_found(p_uom_code);
268: RAISE FND_API.G_EXC_ERROR;
269: END get_in_base;
270:
271: FUNCTION get_base_uom(

Line 287: ITG_MSG.base_uom_not_found(p_uom_code);

283: RETURN l_base_uom_code;
284:
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287: ITG_MSG.base_uom_not_found(p_uom_code);
288: RAISE FND_API.G_EXC_ERROR;
289: END get_base_uom;
290:
291: PROCEDURE delete_uom_class(

Line 297: ITG_MSG.null_disable_date;

293: ) IS
294: BEGIN
295: g_action := 'UOMClass parameter validation';
296: IF p_cls_rec.disable_date IS NULL THEN
297: ITG_MSG.null_disable_date;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300: g_action := 'UOMClass disable';
301: UPDATE mtl_uom_classes_tl

Line 311: ITG_MSG.no_uom_class(p_cls_rec.uom_class);

307: WHERE uom_class = p_cls_rec.uom_class
308: AND USERENV('LANG') IN (language, source_lang);
309:
310: IF SQL%ROWCOUNT = 0 THEN
311: ITG_MSG.no_uom_class(p_cls_rec.uom_class);
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314: END delete_uom_class;
315:

Line 332: ITG_MSG.no_uom_class(p_cls_rec.uom_class);

328: WHERE uom_class = p_cls_rec.uom_class
329: AND USERENV('LANG') IN (language, source_lang);
330:
331: IF SQL%ROWCOUNT = 0 THEN
332: ITG_MSG.no_uom_class(p_cls_rec.uom_class);
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335: END update_uom_class;
336:

Line 378: ITG_MSG.null_disable_date;

374: ) IS
375: BEGIN
376: g_action := 'UOMClass-conversion parameter validation';
377: IF p_ccv_rec.disable_date IS NULL THEN
378: ITG_MSG.null_disable_date;
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381:
382: g_action := 'UOMClassConversion delete';

Line 395: ITG_MSG.no_uomclass_conv;

391: AND to_uom_code = p_ccv_rec.to_uom_code
392: AND to_uom_class = p_ccv_rec.to_uom_class;
393:
394: IF SQL%ROWCOUNT = 0 THEN
395: ITG_MSG.no_uomclass_conv;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398: END delete_uom_class_conv;
399:

Line 418: ITG_MSG.no_uomclass_conv;

414: AND to_uom_code = p_ccv_rec.to_uom_code
415: AND to_uom_class = p_ccv_rec.to_uom_class;
416:
417: IF SQL%ROWCOUNT = 0 THEN
418: ITG_MSG.no_uomclass_conv;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: END update_uom_class_conv;
422:

Line 441: itg_msg.dup_uomclass_conv;

437: to_uom_class = p_ccv_rec.to_uom_class OR
438: to_unit_of_measure = p_ccv_rec.to_unit_of_measure );
439:
440: IF l_count > 0 THEN
441: itg_msg.dup_uomclass_conv;
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: INSERT INTO mtl_uom_class_conversions (

Line 482: ITG_MSG.null_disable_date;

478: ) IS
479: BEGIN
480: g_action := 'UOM-conversion parameter validation';
481: IF p_con_rec.disable_date IS NULL THEN
482: ITG_MSG.null_disable_date;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485: g_action := 'UOM-conversion update';
486: UPDATE mtl_uom_conversions

Line 495: ITG_MSG.no_uom_conv;

491: AND uom_code = p_con_rec.uom_code
492: AND uom_class = p_con_rec.uom_class;
493:
494: IF SQL%ROWCOUNT = 0 THEN
495: ITG_MSG.no_uom_conv;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: END delete_uom_conv;
499:

Line 515: ITG_MSG.no_uom_conv;

511: AND uom_code = p_con_rec.uom_code
512: AND uom_class = p_con_rec.uom_class;
513:
514: IF SQL%ROWCOUNT = 0 THEN
515: ITG_MSG.no_uom_conv;
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
518: END update_uom_conv;
519:

Line 528: ITG_MSG.missing_element_value(

524: l_count NUMBER;
525: BEGIN
526: g_action := 'UOM-conversion parameter validation';
527: IF NVL(p_con_rec.default_conversion_flag, 'z') NOT IN ('Y', 'N') THEN
528: ITG_MSG.missing_element_value(
529: 'CONVFLAG', p_con_rec.default_conversion_flag);
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:

Line 542: itg_msg.dup_uom_conv(p_con_rec.inventory_item_id,

538: and ( unit_of_measure = p_con_rec.unit_of_measure
539: OR uom_code = p_con_rec.uom_code );
540:
541: IF l_count > 0 then
542: itg_msg.dup_uom_conv(p_con_rec.inventory_item_id,
543: p_con_rec.uom_code||'-'||p_con_rec.unit_of_measure);
544: RAISE FND_API.G_EXC_ERROR;
545: end if;
546:

Line 556: ITG_MSG.toomany_default_conv_flag;

552: FROM mtl_uom_conversions
553: WHERE default_conversion_flag = 'Y'
554: AND uom_class = p_con_rec.uom_class;
555: IF l_flag_count > 1 THEN
556: ITG_MSG.toomany_default_conv_flag;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559: END IF;
560:

Line 635: itg_msg.missing_element_value(l_param,nvl(l_value,'NULL'));

631: l_value := p_syncind;
632: END IF;
633:
634: IF l_param IS NOT NULL THEN
635: itg_msg.missing_element_value(l_param,nvl(l_value,'NULL'));
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638:
639: g_action := 'UOMClass sync';

Line 643: itg_msg.missing_element_value('SYNCIND',p_syncind);

639: g_action := 'UOMClass sync';
640:
641: /* Get the records together */
642: IF p_syncind NOT IN ('A','C','D') THEN
643: itg_msg.missing_element_value('SYNCIND',p_syncind);
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646: l_cls_rec.last_update_date := NVL(p_dt_creation, SYSDATE);
647: l_cls_rec.last_updated_by := FND_GLOBAL.user_id;

Line 757: itg_msg.missing_element_value(l_param,nvl(l_value,'NULL'));

753: l_value := p_syncind;
754: END IF;
755:
756: IF l_param IS NOT NULL THEN
757: itg_msg.missing_element_value(l_param,nvl(l_value,'NULL'));
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760:
761: /* Get the record together */

Line 841: itg_msg.missing_element_value('SYNCIND',p_syncind);

837: BEGIN
838: g_action := 'UOM conversion parameter validation';
839:
840: IF p_syncind NOT IN ('A','C','D') THEN
841: itg_msg.missing_element_value('SYNCIND',p_syncind);
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844:
845: /* Get the record together */

Line 872: ITG_MSG.missing_element_value('CONVRATE', p_conv_rate);

868: valid_uom_class(l_ccv_rec.to_uom_class, l_ccv_rec.creation_date);
869:
870: l_ccv_rec.conversion_rate := valid_number(p_conv_rate, 'CONVRATE');
871: IF NVL(l_ccv_rec.conversion_rate, 0) <= 0 THEN
872: ITG_MSG.missing_element_value('CONVRATE', p_conv_rate);
873: RAISE FND_API.G_EXC_ERROR;
874: ELSIF p_itemid IS NULL THEN
875: ITG_MSG.missing_element_value('ITEMID', p_itemid);
876: RAISE FND_API.G_EXC_ERROR;

Line 875: ITG_MSG.missing_element_value('ITEMID', p_itemid);

871: IF NVL(l_ccv_rec.conversion_rate, 0) <= 0 THEN
872: ITG_MSG.missing_element_value('CONVRATE', p_conv_rate);
873: RAISE FND_API.G_EXC_ERROR;
874: ELSIF p_itemid IS NULL THEN
875: ITG_MSG.missing_element_value('ITEMID', p_itemid);
876: RAISE FND_API.G_EXC_ERROR;
877: ELSE
878: /* l_ccv_rec.inventory_item_id :=
879: po_ip_oagxml_pkg.getItemId(p_itemid, NULL); */

Line 931: itg_msg.missing_element_value('SYNCIND',p_syncind);

927:
928: g_action := 'UOM-conversion parameter validation';
929:
930: IF p_syncind NOT IN ('A','C','D') THEN
931: itg_msg.missing_element_value('SYNCIND',p_syncind);
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935:

Line 970: ITG_MSG.neg_conv;

966: * (needs the uom, code, class and l_base_flag)
967: */
968: l_con_rec.conversion_rate := valid_number(p_conv_rate, 'CONVRATE');
969: IF NVL(l_con_rec.conversion_rate, 0) <= 0 THEN
970: ITG_MSG.neg_conv;
971: RAISE FND_API.G_EXC_ERROR;
972: ELSIF p_itemid IS NULL THEN
973: l_con_rec.inventory_item_id := 0;
974: IF l_base_flag = 'Y' THEN

Line 976: ITG_MSG.missing_element_value('CONVRATE', p_conv_rate);

972: ELSIF p_itemid IS NULL THEN
973: l_con_rec.inventory_item_id := 0;
974: IF l_base_flag = 'Y' THEN
975: IF NVL(l_con_rec.conversion_rate, 0) <> 1 THEN
976: ITG_MSG.missing_element_value('CONVRATE', p_conv_rate);
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: END IF;
980: ELSE

Line 1048: ITG_MSG.missing_element_value('UOMGRPDTL/UOM', p_touomcode);

1044: FETCH l_uom_csr INTO l_to_uom_csr_rec;
1045: CLOSE l_uom_csr;
1046:
1047: IF l_to_uom_csr_rec.uom_code IS NULL THEN
1048: ITG_MSG.missing_element_value('UOMGRPDTL/UOM', p_touomcode);
1049: RAISE FND_API.G_EXC_ERROR;
1050: END IF;
1051:
1052: /* Build an outField using the "in" field (the field parameter coming in,

Line 1077: ITG_MSG.missing_element_value(l_param,l_value);

1073: END IF;
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: ITG_MSG.missing_element_value(l_param,l_value);
1078: RAISE FND_API.G_EXC_ERROR;
1079: END;
1080: l_conv_rate := reduce_conv_rate(p_fromfactor, p_tofactor);
1081:

Line 1133: ITG_MSG.missing_element_value('UOMGRPHDR/UOM', p_fromcode);

1129: FETCH l_uom_csr INTO l_fr_uom_csr_rec;
1130: CLOSE l_uom_csr;
1131:
1132: IF l_fr_uom_csr_rec.uom_code IS NULL THEN
1133: ITG_MSG.missing_element_value('UOMGRPHDR/UOM', p_fromcode);
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:
1137: /* Build an Inter-Class conversion field table

Line 1270: ITG_MSG.missing_element_value('P_TASK', p_task);

1266: p_dt_creation => l_dt_creation,
1267: p_dt_expiration => l_dt_expiration
1268: );
1269: ELSE
1270: ITG_MSG.missing_element_value('P_TASK', p_task);
1271: END IF;
1272:
1273: COMMIT WORK;
1274:

Line 1281: ITG_msg.checked_error(g_action);

1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO Sync_UOM_ALL;
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: ITG_msg.checked_error(g_action);
1282:
1283: WHEN OTHERS THEN
1284: ROLLBACK TO Sync_UOM_ALL;
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1286: ITG_msg.unexpected_error(g_action);

1282:
1283: WHEN OTHERS THEN
1284: ROLLBACK TO Sync_UOM_ALL;
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: ITG_msg.unexpected_error(g_action);
1287: itg_debug.msg('Unexpected error (UOMSync) - ' || substr(SQLERRM,1,255),true);
1288:
1289: -- Removed FND_MSG_PUB.Count_And_Get
1290: