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.

[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PUB dependencies on FND_API

Line 231: IF FND_API.to_boolean(p_init_msg_list) THEN

227: l_update_type_indicator := p_update_type_indicator;
228: /*================================
229: Initialize Message List Logic
230: ================================*/
231: IF FND_API.to_boolean(p_init_msg_list) THEN
232: FND_MSG_PUB.Initialize;
233: END IF;
234:
235: /*==================================================

Line 238: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

234:
235: /*==================================================
236: Standard call to check for call compatibility.
237: *==================================================*/
238: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
239: p_api_version ,
240: l_api_name ,
241: G_PKG_NAME ) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
239: p_api_version ,
240: l_api_name ,
241: G_PKG_NAME ) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246:

Line 244: x_return_status := FND_API.G_RET_STS_SUCCESS;

240: l_api_name ,
241: G_PKG_NAME ) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246:
247: /*===============================
248: Validate Action Type

Line 254: RAISE FND_API.G_EXC_ERROR;

250:
251: IF (p_action_type <> 'I' AND p_action_type <> 'U') THEN
252: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ACTIONTYPE_INVALID');
253: FND_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: l_update_type_indicator := p_update_type_indicator;
258: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN

Line 258: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN

254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: l_update_type_indicator := p_update_type_indicator;
258: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
259: /*===============================
260: Validate Organization
261: ==============================*/
262: l_org.organization_id := p_lot_uom_conv_rec.organization_id;

Line 267: RAISE FND_API.G_EXC_ERROR;

263: l_ret := INV_VALIDATE.organization(l_org);
264: IF (l_ret = INV_VALIDATE.F) THEN
265: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ORG_INVALID');
266: FND_MSG_PUB.Add;
267: RAISE FND_API.G_EXC_ERROR;
268: END IF;
269:
270: /*===============================
271: Validate Item

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: l_ret := INV_VALIDATE.inventory_item(l_item, l_org);
277: IF (l_ret = INV_VALIDATE.F) THEN
278: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ITEM_INVALID');
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: /*===============================
284: Validate Lot

Line 293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

289: l_ret := INV_VALIDATE.lot_number(l_lot, l_org, l_item);
290: IF (l_ret = INV_VALIDATE.F) THEN
291: FND_MESSAGE.SET_NAME('INV','INV_LOTC_LOT_INVALID');
292: FND_MSG_PUB.Add;
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295:
296:
297: /*===============================

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: l_from_unit_of_measure IS NULL AND
310: l_from_uom_class IS NULL ) THEN
311: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SOURCE_UOM_REQD');
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315:
316: IF ( l_to_uom_code IS NULL AND
317: l_to_unit_of_measure IS NULL AND

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317: l_to_unit_of_measure IS NULL AND
318: l_to_uom_class IS NULL) THEN
319: FND_MESSAGE.SET_NAME('INV','INV_LOTC_TARGET_UOM_REQD');
320: FND_MSG_PUB.Add;
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324:
325:

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: IF (get_uom_code_values%NOTFOUND) THEN
334: CLOSE get_uom_code_values;
335: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_ERR');
336: FND_MSG_PUB.Add;
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: CLOSE get_uom_code_values;
340:
341: ELSIF ( l_from_unit_of_measure IS NOT NULL) THEN

Line 348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

344: IF (get_unit_of_meas_values%NOTFOUND) THEN
345: CLOSE get_unit_of_meas_values;
346: FND_MESSAGE.SET_NAME('INV','INV_GET_UNITOFMEASURE_ERR');
347: FND_MSG_PUB.Add;
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350: CLOSE get_unit_of_meas_values;
351:
352: ELSIF ( l_from_uom_class IS NOT NULL) THEN

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: IF (get_uom_class_values%NOTFOUND) THEN
356: CLOSE get_uom_class_values;
357: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_CLASS_ERR');
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;
361: CLOSE get_uom_class_values;
362:
363: END IF; /* Which value if not NULL */

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

374: IF (get_uom_code_values%NOTFOUND) THEN
375: CLOSE get_uom_code_values;
376: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_ERR');
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380: CLOSE get_uom_code_values;
381:
382: ELSIF ( l_to_unit_of_measure IS NOT NULL) THEN

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

385: IF (get_unit_of_meas_values%NOTFOUND) THEN
386: CLOSE get_unit_of_meas_values;
387: FND_MESSAGE.SET_NAME('INV','INV_GET_UNITOFMEASURE_ERR');
388: FND_MSG_PUB.Add;
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: CLOSE get_unit_of_meas_values;
392:
393: ELSIF ( l_to_uom_class IS NOT NULL) THEN

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: IF (get_uom_class_values%NOTFOUND) THEN
397: CLOSE get_uom_class_values;
398: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_CLASS_ERR');
399: FND_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402: CLOSE get_uom_class_values;
403:
404: END IF; /* Which value if not NULL */

Line 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: FETCH get_item_uom INTO l_item_uom_code;
423: IF (get_item_uom%NOTFOUND) THEN
424: FND_MESSAGE.SET_NAME('INV','INV_ITEMUOM');
425: FND_MSG_PUB.Add;
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428: CLOSE get_item_uom;
429:
430: /*==========================================

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435: FETCH get_item_uom_class INTO l_item_uom_class;
436: IF (get_item_uom_class%NOTFOUND) THEN
437: FND_MESSAGE.SET_NAME('INV','INV_ITEMUOM_CLASS');
438: FND_MSG_PUB.Add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441: CLOSE get_item_uom_class;
442:
443: /*==========================================

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448:
449: IF (l_item_uom_class <> l_from_uom_class) THEN
450: FND_MESSAGE.SET_NAME('INV','INV_CLASSMISMATCH');
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455:
456: /*==========================================

Line 465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

461: FETCH get_base_values INTO l_from_base_unit_of_measure, l_from_base_uom_code;
462: IF (get_base_values%NOTFOUND) THEN
463: FND_MESSAGE.SET_NAME('INV','INV_FROMBASE_ERROR');
464: FND_MSG_PUB.Add;
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467: CLOSE get_base_values;
468:
469:

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490:
491: IF (l_ret = -99999) THEN
492: FND_MESSAGE.SET_NAME('INV','INV_FROMBASE_CONV_ERROR');
493: FND_MSG_PUB.Add;
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: ELSE
496: p_lot_uom_conv_rec.conversion_rate := l_from_rate;
497: l_from_uom_code := l_from_base_uom_code;
498: l_from_unit_of_measure := l_from_base_unit_of_measure;

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

508: FETCH get_base_values INTO l_to_base_unit_of_measure, l_to_base_uom_code;
509: IF (get_base_values%NOTFOUND) THEN
510: FND_MESSAGE.SET_NAME('INV','INV_TOBASE_ERROR');
511: FND_MSG_PUB.Add;
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: CLOSE get_base_values;
515:
516:

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537:
538: IF (l_ret = -99999) THEN
539: FND_MESSAGE.SET_NAME('INV','INV_TOBASE_CONV_ERROR');
540: FND_MSG_PUB.Add;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: ELSE
543: p_lot_uom_conv_rec.conversion_rate := p_lot_uom_conv_rec.conversion_rate/l_factor;
544: l_to_uom_code := l_to_base_uom_code;
545: l_to_unit_of_measure := l_to_base_unit_of_measure;

Line 575: RAISE FND_API.G_EXC_ERROR;

571: IF (p_lot_uom_conv_rec.conversion_rate <= 0 OR
572: p_lot_uom_conv_rec.conversion_rate IS NULL) THEN
573: FND_MESSAGE.SET_NAME('INV','INV_LOTC_CONVRATE_INVALID');
574: FND_MSG_PUB.Add;
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: /*===============================
579: Validate Disable Date

Line 605: RAISE FND_API.G_EXC_ERROR;

601: l_reason_id := p_reason_id;
602: l_ret := INV_VALIDATE.reason(l_reason_id);
603: IF (l_ret = INV_VALIDATE.F) THEN
604: FND_MSG_PUB.Add;
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607: END IF;
608:
609:

Line 619: RAISE FND_API.G_EXC_ERROR;

615: l_ret := mtl_lot_uom_conv_pvt.validate_update_type(
616: l_update_type_indicator);
617: IF (l_ret = G_FALSE) THEN
618: FND_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:
622: /*===============================
623: Validate WHO.

Line 653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

649:
650:
651:
652: IF (l_ret = 0) THEN
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END IF;
655:
656: /*================================================
657: Only update database if process_data flag set.

Line 705: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

701:
702: x_sequence := l_tran_seq;
703:
704: --Bug#5453231 changed x_return_status to l_return_status
705: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709:

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: x_sequence := l_tran_seq;
703:
704: --Bug#5453231 changed x_return_status to l_return_status
705: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709:
710: FND_MSG_PUB.Count_AND_GET

Line 727: p_init_msg_list => FND_API.G_TRUE,

723:
724: IF (x_sequence IS NOT NULL) THEN
725: l_ret := INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS(
726: p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_TRUE,
728: p_commit => FND_API.G_FALSE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_msg_count,

Line 728: p_commit => FND_API.G_FALSE,

724: IF (x_sequence IS NOT NULL) THEN
725: l_ret := INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS(
726: p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_TRUE,
728: p_commit => FND_API.G_FALSE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_msg_count,
732: x_msg_data => l_msg_data,

Line 729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

725: l_ret := INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS(
726: p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_TRUE,
728: p_commit => FND_API.G_FALSE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_msg_count,
732: x_msg_data => l_msg_data,
733: x_trans_count => l_trans_count,

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

737: -- old code 1 returned IF (l_ret = G_FALSE) THEN
738: -- g_false = 0 inconsistent behaviour between l_ret and l_return_status
739:
740: IF (l_ret <> 0) THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744: END IF;
745:

Line 746: IF (p_commit = FND_API.G_TRUE) THEN

742: END IF;
743:
744: END IF;
745:
746: IF (p_commit = FND_API.G_TRUE) THEN
747: COMMIT;
748: END IF;
749:
750: EXCEPTION

Line 754: x_return_status := FND_API.G_RET_STS_ERROR;

750: EXCEPTION
751:
752: WHEN DO_CHECK_ERROR THEN
753: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Count_AND_GET
756: (p_count => x_msg_count, p_data => x_msg_data);
757:
758: WHEN FND_API.G_EXC_ERROR THEN

Line 758: WHEN FND_API.G_EXC_ERROR THEN

754: x_return_status := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Count_AND_GET
756: (p_count => x_msg_count, p_data => x_msg_data);
757:
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_AND_GET
762: (p_count => x_msg_count, p_data => x_msg_data);

Line 760: x_return_status := FND_API.G_RET_STS_ERROR;

756: (p_count => x_msg_count, p_data => x_msg_data);
757:
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_AND_GET
762: (p_count => x_msg_count, p_data => x_msg_data);
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

760: x_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_AND_GET
762: (p_count => x_msg_count, p_data => x_msg_data);
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MSG_PUB.Count_AND_GET
768: (p_count => x_msg_count, p_data => x_msg_data);

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

762: (p_count => x_msg_count, p_data => x_msg_data);
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MSG_PUB.Count_AND_GET
768: (p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN OTHERS THEN

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: (p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN OTHERS THEN
771: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.Count_AND_GET
774: (p_count => x_msg_count, p_data => x_msg_data);
775:
776: END create_lot_uom_conversion;