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.MTL_LOT_UOM_CONV_PUB dependencies on FND_API

Line 229: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 236: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 252: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 265: RAISE FND_API.G_EXC_ERROR;

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

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 573: RAISE FND_API.G_EXC_ERROR;

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

Line 603: RAISE FND_API.G_EXC_ERROR;

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

Line 617: RAISE FND_API.G_EXC_ERROR;

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

Line 651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

679:
680: x_sequence := l_tran_seq;
681:
682: --Bug#5453231 changed x_return_status to l_return_status
683: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687:

Line 684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

680: x_sequence := l_tran_seq;
681:
682: --Bug#5453231 changed x_return_status to l_return_status
683: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687:
688: FND_MSG_PUB.Count_AND_GET

Line 705: p_init_msg_list => FND_API.G_TRUE,

701:
702: IF (x_sequence IS NOT NULL) THEN
703: l_ret := INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS(
704: p_api_version => 1.0,
705: p_init_msg_list => FND_API.G_TRUE,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: x_return_status => l_return_status,
709: x_msg_count => l_msg_count,

Line 706: p_commit => FND_API.G_FALSE,

702: IF (x_sequence IS NOT NULL) THEN
703: l_ret := INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS(
704: p_api_version => 1.0,
705: p_init_msg_list => FND_API.G_TRUE,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: x_return_status => l_return_status,
709: x_msg_count => l_msg_count,
710: x_msg_data => l_msg_data,

Line 707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

703: l_ret := INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS(
704: p_api_version => 1.0,
705: p_init_msg_list => FND_API.G_TRUE,
706: p_commit => FND_API.G_FALSE,
707: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
708: x_return_status => l_return_status,
709: x_msg_count => l_msg_count,
710: x_msg_data => l_msg_data,
711: x_trans_count => l_trans_count,

Line 719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

715: -- old code 1 returned IF (l_ret = G_FALSE) THEN
716: -- g_false = 0 inconsistent behaviour between l_ret and l_return_status
717:
718: IF (l_ret <> 0) THEN
719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721:
722: END IF;
723:

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

720: END IF;
721:
722: END IF;
723:
724: IF (p_commit = FND_API.G_TRUE) THEN
725: COMMIT;
726: END IF;
727:
728: EXCEPTION

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

728: EXCEPTION
729:
730: WHEN DO_CHECK_ERROR THEN
731: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_AND_GET
734: (p_count => x_msg_count, p_data => x_msg_data);
735:
736: WHEN FND_API.G_EXC_ERROR THEN

Line 736: WHEN FND_API.G_EXC_ERROR THEN

732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_AND_GET
734: (p_count => x_msg_count, p_data => x_msg_data);
735:
736: WHEN FND_API.G_EXC_ERROR THEN
737: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: FND_MSG_PUB.Count_AND_GET
740: (p_count => x_msg_count, p_data => x_msg_data);

Line 738: x_return_status := FND_API.G_RET_STS_ERROR;

734: (p_count => x_msg_count, p_data => x_msg_data);
735:
736: WHEN FND_API.G_EXC_ERROR THEN
737: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: FND_MSG_PUB.Count_AND_GET
740: (p_count => x_msg_count, p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

738: x_return_status := FND_API.G_RET_STS_ERROR;
739: FND_MSG_PUB.Count_AND_GET
740: (p_count => x_msg_count, p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_AND_GET
746: (p_count => x_msg_count, p_data => x_msg_data);

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

740: (p_count => x_msg_count, p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_AND_GET
746: (p_count => x_msg_count, p_data => x_msg_data);
747:
748: WHEN OTHERS THEN

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

746: (p_count => x_msg_count, p_data => x_msg_data);
747:
748: WHEN OTHERS THEN
749: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_AND_GET
752: (p_count => x_msg_count, p_data => x_msg_data);
753:
754: END create_lot_uom_conversion;