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 FND_API

Line 20: RAISE FND_API.G_EXC_ERROR;

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;
24:

Line 33: RAISE FND_API.G_EXC_ERROR;

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:
37: -- this condition is not accounted in the NOT EXISTS clause of the insert

Line 46: raise FND_API.G_EXC_ERROR;

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
50: SELECT COUNT(*)

Line 57: RAISE FND_API.G_EXC_ERROR;

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:
61: g_action := 'UOM insert';

Line 106: RAISE FND_API.G_EXC_ERROR;

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
110: SET disable_date = p_uom_rec.disable_date,

Line 122: RAISE FND_API.G_EXC_ERROR;

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:
126: PROCEDURE update_uom(

Line 145: RAISE FND_API.G_EXC_ERROR;

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:
149: PROCEDURE valid_uom_class(

Line 173: RAISE FND_API.G_EXC_ERROR;

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(
177: p_value IN VARCHAR2,

Line 185: RAISE FND_API.G_EXC_ERROR;

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 (
189: p_numerator IN VARCHAR2,

Line 207: RAISE FND_API.G_EXC_ERROR;

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(
211: p_uom IN VARCHAR2,

Line 229: RAISE FND_API.G_EXC_ERROR;

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(
233: p_uom_code IN VARCHAR2,

Line 268: RAISE FND_API.G_EXC_ERROR;

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(
272: p_uom_code IN VARCHAR2

Line 288: RAISE FND_API.G_EXC_ERROR;

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(
292: p_cls_rec IN mtl_uom_classes%ROWTYPE

Line 298: RAISE FND_API.G_EXC_ERROR;

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
302: SET disable_date = p_cls_rec.disable_date,

Line 312: RAISE FND_API.G_EXC_ERROR;

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:
316: PROCEDURE update_uom_class(

Line 333: RAISE FND_API.G_EXC_ERROR;

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:
337: PROCEDURE insert_uom_class(

Line 379: RAISE FND_API.G_EXC_ERROR;

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';
383: UPDATE mtl_uom_class_conversions

Line 396: RAISE FND_API.G_EXC_ERROR;

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:
400: PROCEDURE update_uom_class_conv(

Line 419: RAISE FND_API.G_EXC_ERROR;

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:
423:

Line 442: RAISE FND_API.G_EXC_ERROR;

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 (
446: from_unit_of_measure,

Line 483: RAISE FND_API.G_EXC_ERROR;

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
487: SET disable_date = p_con_rec.disable_date,

Line 496: RAISE FND_API.G_EXC_ERROR;

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:
500: PROCEDURE update_uom_conv(

Line 516: RAISE FND_API.G_EXC_ERROR;

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:
520: PROCEDURE insert_uom_conv(

Line 530: RAISE FND_API.G_EXC_ERROR;

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:
533:
534: select count(*)

Line 544: RAISE FND_API.G_EXC_ERROR;

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:
547:
548: /* Check for multiple flags */

Line 557: RAISE FND_API.G_EXC_ERROR;

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:
561: g_action := 'UOM-conversion insert';

Line 636: RAISE FND_API.G_EXC_ERROR;

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';
640:

Line 644: RAISE FND_API.G_EXC_ERROR;

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;
648: l_cls_rec.creation_date := l_cls_rec.last_update_date;

Line 758: RAISE FND_API.G_EXC_ERROR;

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 */
762: l_uom_rec.last_update_date := NVL(p_dt_creation, SYSDATE);

Line 842: RAISE FND_API.G_EXC_ERROR;

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 */
846: l_ccv_rec.last_update_date := NVL(p_dt_creation, SYSDATE);

Line 873: RAISE FND_API.G_EXC_ERROR;

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;
877: ELSE

Line 876: RAISE FND_API.G_EXC_ERROR;

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); */
880: NULL;

Line 932: RAISE FND_API.G_EXC_ERROR;

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:
936: /* Get the record together */

Line 971: RAISE FND_API.G_EXC_ERROR;

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
975: IF NVL(l_con_rec.conversion_rate, 0) <> 1 THEN

Line 977: RAISE FND_API.G_EXC_ERROR;

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
981: --TODO!. Need to enhance the XGM to allow item_seg + org

Line 1049: RAISE FND_API.G_EXC_ERROR;

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,
1053: * that is) which we will pass along to the appropriate procedure,

Line 1072: RAISE FND_API.G_EXC_ERROR;

1068: l_value := p_tofactor;
1069: l_tmp := to_number(p_tofactor);
1070:
1071: IF l_tmp = 0 THEN
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN

Line 1078: RAISE FND_API.G_EXC_ERROR;

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:
1082:

Line 1134: RAISE FND_API.G_EXC_ERROR;

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
1138: * need to find the conversion rate based on the base UOM's.

Line 1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

1193:
1194: l_dt_creation DATE;
1195: l_dt_expiration DATE;
1196: BEGIN
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: g_action := 'UOM sync';
1200:
1201: SAVEPOINT Sync_UOM_ALL;

Line 1278: WHEN FND_API.G_EXC_ERROR THEN

1274:
1275: ITG_Debug.msg('SUA', 'Done.');
1276:
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:

Line 1280: x_return_status := FND_API.G_RET_STS_ERROR;

1276:
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;

Line 1285: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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