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

Line 20: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

16: --
17: -- Input Paramters
18: -- P_UOM_CLASS uom_class data.
19: -- Output Parameters
20: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
21: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
22: -- = fnd_api.g_ret_sts_unexp_error, if
23: -- an unexpected error occurred
24: --

Line 21: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred

17: -- Input Paramters
18: -- P_UOM_CLASS uom_class data.
19: -- Output Parameters
20: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
21: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
22: -- = fnd_api.g_ret_sts_unexp_error, if
23: -- an unexpected error occurred
24: --
25: ---------------------------------------------

Line 22: -- = fnd_api.g_ret_sts_unexp_error, if

18: -- P_UOM_CLASS uom_class data.
19: -- Output Parameters
20: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
21: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
22: -- = fnd_api.g_ret_sts_unexp_error, if
23: -- an unexpected error occurred
24: --
25: ---------------------------------------------
26:

Line 69: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

65: -- P_ATTRIBUTES_CNT
66: -- P_DESC_FLEX_NAME
67:
68: -- Output Parameters
69: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
70: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
71: -- = fnd_api.g_ret_sts_unexp_error, if
72: -- an unexpected error occurred
73: -- x_msg_count

Line 70: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred

66: -- P_DESC_FLEX_NAME
67:
68: -- Output Parameters
69: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
70: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
71: -- = fnd_api.g_ret_sts_unexp_error, if
72: -- an unexpected error occurred
73: -- x_msg_count
74: -- X_MSG_DATA

Line 71: -- = fnd_api.g_ret_sts_unexp_error, if

67:
68: -- Output Parameters
69: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
70: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
71: -- = fnd_api.g_ret_sts_unexp_error, if
72: -- an unexpected error occurred
73: -- x_msg_count
74: -- X_MSG_DATA
75: ---------------------------------------------

Line 122: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

118: l_global_nsegments NUMBER := 0;
119: col NUMBER;
120: BEGIN
121:
122: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
123:
124: SAVEPOINT get_lot_attr_information;
125:
126: /* Populate the flex field record */

Line 182: RAISE fnd_api.g_exc_error;

178: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
179: fnd_message.set_token('CONTEXT', 'NULL');
180: fnd_message.set_token('ROUTINE', 'inv_uom_api_pub');
181: fnd_msg_pub.ADD;
182: RAISE fnd_api.g_exc_error;
183: END IF;
184:
185:
186: IF (L_DEBUG = 1) THEN

Line 197: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) = fnd_api.g_miss_char) OR

193: IF l_segments_dr.is_required(i) THEN
194: col := SUBSTR(l_segments_dr.application_column_name(i)
195: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9);
196: --DBMS_output.put_line('col is ' || col);
197: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) = fnd_api.g_miss_char) OR
198: NOT p_attributes_tbl.EXISTS(col))
199: THEN
200: --DBMS_output.put_line('y r we here');
201: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');

Line 204: RAISE fnd_api.g_exc_error;

200: --DBMS_output.put_line('y r we here');
201: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
202: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
203: fnd_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: END IF;
206: ELSE
207: --DBMS_output.put_line('This segment is not required');
208: NULL;

Line 285: RAISE fnd_api.g_exc_error;

281: THEN
282: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
283: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
284: fnd_msg_pub.ADD;
285: RAISE fnd_api.g_exc_error;
286: --DBMS_output.put_line('Req segment is not populated');
287: END IF;
288: END IF;
289:

Line 350: x_return_status := fnd_api.g_ret_sts_error;

346: END IF;
347:
348: EXCEPTION
349: WHEN ERRORS_RECEIVED THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: error_msg := fnd_flex_descval.error_message;
352: s := 1;
353: e := 200;
354:

Line 367: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

363: e := e + 200;
364: END LOOP;
365:
366: ROLLBACK TO get_lot_attr_information;
367: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
368: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
369:
370: IF (L_DEBUG = 1) THEN
371: INV_LOG_UTIL.TRACE('errors_received exception:'||X_MSG_DATA, 'inv_uom_api_pub', '9');

Line 374: WHEN fnd_api.g_exc_error THEN

370: IF (L_DEBUG = 1) THEN
371: INV_LOG_UTIL.TRACE('errors_received exception:'||X_MSG_DATA, 'inv_uom_api_pub', '9');
372: END IF;
373:
374: WHEN fnd_api.g_exc_error THEN
375: x_return_status := fnd_api.g_ret_sts_error;
376: ROLLBACK TO get_lot_attr_information;
377: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
378:

Line 375: x_return_status := fnd_api.g_ret_sts_error;

371: INV_LOG_UTIL.TRACE('errors_received exception:'||X_MSG_DATA, 'inv_uom_api_pub', '9');
372: END IF;
373:
374: WHEN fnd_api.g_exc_error THEN
375: x_return_status := fnd_api.g_ret_sts_error;
376: ROLLBACK TO get_lot_attr_information;
377: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN

Line 377: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

373:
374: WHEN fnd_api.g_exc_error THEN
375: x_return_status := fnd_api.g_ret_sts_error;
376: ROLLBACK TO get_lot_attr_information;
377: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: ROLLBACK TO get_lot_attr_information;

Line 379: WHEN fnd_api.g_exc_unexpected_error THEN

375: x_return_status := fnd_api.g_ret_sts_error;
376: ROLLBACK TO get_lot_attr_information;
377: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: ROLLBACK TO get_lot_attr_information;
382: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
383:

Line 380: x_return_status := fnd_api.g_ret_sts_unexp_error;

376: ROLLBACK TO get_lot_attr_information;
377: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: ROLLBACK TO get_lot_attr_information;
382: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
383:
384: WHEN OTHERS THEN

Line 382: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: ROLLBACK TO get_lot_attr_information;
382: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: ROLLBACK TO get_lot_attr_information;

Line 385: x_return_status := fnd_api.g_ret_sts_unexp_error;

381: ROLLBACK TO get_lot_attr_information;
382: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: ROLLBACK TO get_lot_attr_information;
387: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
388:
389: END validate_attr_info;

Line 387: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: ROLLBACK TO get_lot_attr_information;
387: FND_MSG_PUB.COUNT_AND_GET(P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
388:
389: END validate_attr_info;
390:
391: -----------------------------------------------

Line 412: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

408: -- P_UOM_ATTRIBUTE 1 - 15 DFF of Define Unit of Measures
409: -- p_action_type Object type of UOM class that whether uom class need to insert or update
410: -- i.e 'I' or 'U'
411: -- Output Parameters
412: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
413: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
414: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
415: --
416: -- x_msg_count = Message count

Line 413: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred

409: -- p_action_type Object type of UOM class that whether uom class need to insert or update
410: -- i.e 'I' or 'U'
411: -- Output Parameters
412: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
413: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
414: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
415: --
416: -- x_msg_count = Message count
417: -- x_msg_data = Message text

Line 414: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred

410: -- i.e 'I' or 'U'
411: -- Output Parameters
412: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
413: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
414: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
415: --
416: -- x_msg_count = Message count
417: -- x_msg_data = Message text
418: --

Line 466: L_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

462: X_MSG_DATA OUT NOCOPY VARCHAR2,
463: X_RETURN_STATUS OUT NOCOPY VARCHAR2 )
464: IS
465: L_FOUND BOOLEAN;
466: L_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
467: -- L_UNIT_OF_MEASURE VARCHAR2(25);
468: L_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
469:
470: -- L_UOM_CODE VARCHAR2(3);

Line 541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

537:
538: FND_MESSAGE.SET_NAME('INV', 'INV_DUP');
539: FND_MESSAGE.SET_TOKEN('VALUE1', P_UOM_CLASS);
540: FND_MSG_PUB.ADD;
541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
542:
543: RAISE FND_API.G_EXC_ERROR;
544: END IF; -- UOM class already exists.
545:

Line 543: RAISE FND_API.G_EXC_ERROR;

539: FND_MESSAGE.SET_TOKEN('VALUE1', P_UOM_CLASS);
540: FND_MSG_PUB.ADD;
541: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
542:
543: RAISE FND_API.G_EXC_ERROR;
544: END IF; -- UOM class already exists.
545:
546: END;
547: -- End of Validating P_UOM_CLASS

Line 558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

554: IF P_DISABLE_DATE IS NOT NULL AND TRUNC(P_DISABLE_DATE) < TRUNC(SYSDATE) THEN
555:
556: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
557: FND_MSG_PUB.ADD;
558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
559: RAISE FND_API.G_EXC_ERROR;
560:
561: END IF;
562:

Line 559: RAISE FND_API.G_EXC_ERROR;

555:
556: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
557: FND_MSG_PUB.ADD;
558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
559: RAISE FND_API.G_EXC_ERROR;
560:
561: END IF;
562:
563: -- Validating p_base_unit_of_measure and p_base_uom_code

Line 571: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

567: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
568: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UNIT_OF_MEASURE OR P_BASE_UOM_CODE');
569: FND_MSG_PUB.ADD;
570:
571: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
572: RAISE FND_API.G_EXC_ERROR;
573: -- The unit of measure and base uom code for this uom class need to be passed.
574: END IF;
575:

Line 572: RAISE FND_API.G_EXC_ERROR;

568: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UNIT_OF_MEASURE OR P_BASE_UOM_CODE');
569: FND_MSG_PUB.ADD;
570:
571: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
572: RAISE FND_API.G_EXC_ERROR;
573: -- The unit of measure and base uom code for this uom class need to be passed.
574: END IF;
575:
576:

Line 589: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

585: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
586: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UOM_CODE');
587: FND_MSG_PUB.ADD;
588:
589: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
590: RAISE FND_API.G_EXC_ERROR;
591:
592: END IF;
593:

Line 590: RAISE FND_API.G_EXC_ERROR;

586: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UOM_CODE');
587: FND_MSG_PUB.ADD;
588:
589: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
590: RAISE FND_API.G_EXC_ERROR;
591:
592: END IF;
593:
594: END;

Line 619: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

615: IF ( L_UNIT_OF_MEASURE IS NOT NULL) THEN
616: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
617: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
618: FND_MSG_PUB.ADD;
619: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
620: RAISE FND_API.G_EXC_ERROR;
621: -- Already unit of measure and uom code exists with some other class exists.
622: END IF;
623:

Line 620: RAISE FND_API.G_EXC_ERROR;

616: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
617: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
618: FND_MSG_PUB.ADD;
619: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
620: RAISE FND_API.G_EXC_ERROR;
621: -- Already unit of measure and uom code exists with some other class exists.
622: END IF;
623:
624:

Line 644: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

640:
641: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
642: FND_MESSAGE.SET_TOKEN('VALUE1', L_UOM_CODE);
643: FND_MSG_PUB.ADD;
644: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
645: RAISE FND_API.G_EXC_ERROR;
646: -- Already unit of measure and uom code exists with some other class exists.
647: END IF;
648:

Line 645: RAISE FND_API.G_EXC_ERROR;

641: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
642: FND_MESSAGE.SET_TOKEN('VALUE1', L_UOM_CODE);
643: FND_MSG_PUB.ADD;
644: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
645: RAISE FND_API.G_EXC_ERROR;
646: -- Already unit of measure and uom code exists with some other class exists.
647: END IF;
648:
649:

Line 674: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

670: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
671: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
672: FND_MSG_PUB.ADD;
673:
674: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
675: RAISE fnd_api.g_exc_error;
676:
677: END IF;
678:

Line 675: RAISE fnd_api.g_exc_error;

671: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
672: FND_MSG_PUB.ADD;
673:
674: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
675: RAISE fnd_api.g_exc_error;
676:
677: END IF;
678:
679: END;

Line 698: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

694: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
695: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UOM_CODE');
696: FND_MSG_PUB.ADD;
697:
698: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
699: RAISE FND_API.G_EXC_ERROR;
700:
701: END IF;
702:

Line 699: RAISE FND_API.G_EXC_ERROR;

695: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UOM_CODE');
696: FND_MSG_PUB.ADD;
697:
698: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
699: RAISE FND_API.G_EXC_ERROR;
700:
701: END IF;
702:
703: END;

Line 715: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

711: END IF;
712:
713: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
714: FND_MSG_PUB.ADD;
715: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
716: RAISE FND_API.G_EXC_ERROR;
717:
718: END IF;
719:

Line 716: RAISE FND_API.G_EXC_ERROR;

712:
713: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
714: FND_MSG_PUB.ADD;
715: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
716: RAISE FND_API.G_EXC_ERROR;
717:
718: END IF;
719:
720: -- Validating p_base_unit_of_measure and p_base_uom_code

Line 728: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

724: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
725: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UNIT_OF_MEASURE OR P_BASE_UOM_CODE');
726: FND_MSG_PUB.ADD;
727:
728: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
729: RAISE FND_API.G_EXC_ERROR;
730: -- The unit of measure and base uom code for this uom class need to be passed.
731: END IF;
732:

Line 729: RAISE FND_API.G_EXC_ERROR;

725: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_BASE_UNIT_OF_MEASURE OR P_BASE_UOM_CODE');
726: FND_MSG_PUB.ADD;
727:
728: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
729: RAISE FND_API.G_EXC_ERROR;
730: -- The unit of measure and base uom code for this uom class need to be passed.
731: END IF;
732:
733: BEGIN

Line 749: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

745: WHEN NO_DATA_FOUND THEN
746: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_COMB_MSG');
747: -- FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
748: FND_MSG_PUB.ADD;
749: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
750: RAISE FND_API.G_EXC_ERROR;
751: END ;
752:
753: IF (L_DEBUG = 1) THEN

Line 750: RAISE FND_API.G_EXC_ERROR;

746: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_COMB_MSG');
747: -- FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
748: FND_MSG_PUB.ADD;
749: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
750: RAISE FND_API.G_EXC_ERROR;
751: END ;
752:
753: IF (L_DEBUG = 1) THEN
754: INV_LOG_UTIL.TRACE('l_unit_of_measure:' || L_UNIT_OF_MEASURE, 'inv_uom_api_pub', '9');

Line 763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

759: -- DBMS_OUTPUT.PUT_LINE('unit of measure already exists');
760: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
761: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
762: FND_MSG_PUB.ADD;
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: RAISE FND_API.G_EXC_ERROR;
765: -- Already unit of measure and uom code exists with some other class exists.
766: END IF;
767:

Line 764: RAISE FND_API.G_EXC_ERROR;

760: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
761: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
762: FND_MSG_PUB.ADD;
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: RAISE FND_API.G_EXC_ERROR;
765: -- Already unit of measure and uom code exists with some other class exists.
766: END IF;
767:
768: END IF; -- end of p_action_type = 'U'

Line 863: RAISE fnd_api.g_exc_error;

859: INV_LOG_UTIL.TRACE('L_MSG_DATA:' || L_MSG_DATA, 'inv_uom_api_pub', '9');
860: END IF;
861:
862: IF L_RETURN_STATUS = 'E' THEN
863: RAISE fnd_api.g_exc_error;
864: ELSIF l_return_status = 'U' THEN
865: RAISE fnd_api.g_exc_unexpected_error;
866: END IF;
867:

Line 865: RAISE fnd_api.g_exc_unexpected_error;

861:
862: IF L_RETURN_STATUS = 'E' THEN
863: RAISE fnd_api.g_exc_error;
864: ELSIF l_return_status = 'U' THEN
865: RAISE fnd_api.g_exc_unexpected_error;
866: END IF;
867:
868:
869: -- Defaulting the DFF attribute parameters to null if the corresponding attributes are not enabled

Line 931: RAISE FND_API.G_EXC_ERROR;

927: );
928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: RAISE FND_API.G_EXC_ERROR;
932: END;
933:
934: IF (L_DEBUG = 1) THEN
935: INV_LOG_UTIL.TRACE('After inserting uom class, X_RETURN_STATUS:'|| X_RETURN_STATUS, 'inv_uom_api_pub', '9');

Line 1034: RAISE fnd_api.g_exc_error;

1030: END IF;
1031:
1032: IF l_return_status = 'E' THEN
1033: --DBMS_output.put_line('Error from validate_loc_attr_info');
1034: RAISE fnd_api.g_exc_error;
1035: ELSIF l_return_status = 'U' THEN
1036: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: --DBMS_output.put_line('Error from validate_loc_attr_info');
1034: RAISE fnd_api.g_exc_error;
1035: ELSIF l_return_status = 'U' THEN
1036: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039:
1040: -- Defaulting the DFF attribute parameters to null if the corresponding attributes are not enabled
1041:

Line 1200: RAISE FND_API.G_EXC_ERROR;

1196: X_LAST_UPDATE_LOGIN => L_LOGINID
1197: );
1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: RAISE FND_API.G_EXC_ERROR;
1201: END;
1202:
1203: IF (L_DEBUG = 1) THEN
1204: INV_LOG_UTIL.TRACE('After update uom class , X_RETURN_STATUS:'|| X_RETURN_STATUS, 'inv_uom_api_pub', '9');

Line 1208: RAISE FND_API.G_EXC_ERROR;

1204: INV_LOG_UTIL.TRACE('After update uom class , X_RETURN_STATUS:'|| X_RETURN_STATUS, 'inv_uom_api_pub', '9');
1205: END IF;
1206:
1207: IF X_RETURN_STATUS <> 'S' THEN
1208: RAISE FND_API.G_EXC_ERROR;
1209: END IF;
1210:
1211: END IF;
1212:

Line 1214: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;

1210:
1211: END IF;
1212:
1213: -- End of Code logic to insert MTL_UOM_CLASS_CONVERSIONS table.
1214: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;
1215:
1216: COMMIT;
1217:
1218: EXCEPTION

Line 1221: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1217:
1218: EXCEPTION
1219: WHEN L_INVALID_OBJECT_TYPE THEN
1220:
1221: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1222: FND_MSG_PUB.COUNT_AND_GET
1223: ( P_COUNT => X_MSG_COUNT
1224: , P_DATA => X_MSG_DATA
1225: );

Line 1229: WHEN FND_API.G_EXC_ERROR THEN

1225: );
1226:
1227: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1228:
1229: WHEN FND_API.G_EXC_ERROR THEN
1230: ROLLBACK;
1231: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1232:
1233: -- Get message count and data

Line 1231: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1227: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1228:
1229: WHEN FND_API.G_EXC_ERROR THEN
1230: ROLLBACK;
1231: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1232:
1233: -- Get message count and data
1234: fnd_msg_pub.count_and_get
1235: ( p_count => x_msg_count

Line 1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1234: fnd_msg_pub.count_and_get
1235: ( p_count => x_msg_count
1236: , p_data => x_msg_data
1237: );
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1239: ROLLBACK;
1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1241:
1242: -- Get message count and data

Line 1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1236: , p_data => x_msg_data
1237: );
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1239: ROLLBACK;
1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1241:
1242: -- Get message count and data
1243: fnd_msg_pub.count_and_get
1244: ( p_count => x_msg_count

Line 1249: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1245: , p_data => x_msg_data
1246: );
1247: WHEN OTHERS THEN
1248: ROLLBACK;
1249: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1250:
1251: -- Get message count and data
1252: fnd_msg_pub.count_and_get
1253: ( p_count => x_msg_count

Line 1276: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

1272: -- P_ATTRIBUTE_CATEGORY Context of Unit of Measure
1273: -- p_attribute 1-15 DFF of Define Unit of measure.
1274: -- p_action_type Object type whether 'I' or 'U'
1275: -- Output Parameters
1276: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
1277: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
1278: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
1279: --
1280: -- x_msg_count = Message count

Line 1277: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred

1273: -- p_attribute 1-15 DFF of Define Unit of measure.
1274: -- p_action_type Object type whether 'I' or 'U'
1275: -- Output Parameters
1276: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
1277: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
1278: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
1279: --
1280: -- x_msg_count = Message count
1281: -- x_msg_data = Message text

Line 1278: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred

1274: -- p_action_type Object type whether 'I' or 'U'
1275: -- Output Parameters
1276: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
1277: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
1278: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
1279: --
1280: -- x_msg_count = Message count
1281: -- x_msg_data = Message text
1282: --

Line 1377: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1373: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
1374: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
1375: FND_MSG_PUB.ADD;
1376: L_BASE_UOM_FLAG := 'Y';
1377: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1378: RAISE FND_API.G_EXC_ERROR;
1379:
1380: END IF;
1381: -- End of Validating P_UOM_CLASS

Line 1378: RAISE FND_API.G_EXC_ERROR;

1374: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CLASS');
1375: FND_MSG_PUB.ADD;
1376: L_BASE_UOM_FLAG := 'Y';
1377: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1378: RAISE FND_API.G_EXC_ERROR;
1379:
1380: END IF;
1381: -- End of Validating P_UOM_CLASS
1382:

Line 1396: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1392: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
1393: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CODE');
1394: FND_MSG_PUB.ADD;
1395:
1396: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1397: RAISE FND_API.G_EXC_ERROR;
1398:
1399: END IF;
1400:

Line 1397: RAISE FND_API.G_EXC_ERROR;

1393: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_UOM_CODE');
1394: FND_MSG_PUB.ADD;
1395:
1396: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1397: RAISE FND_API.G_EXC_ERROR;
1398:
1399: END IF;
1400:
1401: END;

Line 1411: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1407:
1408: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1409: FND_MESSAGE.SET_TOKEN('UOM', 'P_UNIT_OF_MEASURE'); -- added now
1410: FND_MSG_PUB.ADD;
1411: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1412: RAISE FND_API.G_EXC_ERROR;
1413: -- The unit of measure and base uom code for this uom class need to be passed.
1414:
1415: END IF;

Line 1412: RAISE FND_API.G_EXC_ERROR;

1408: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1409: FND_MESSAGE.SET_TOKEN('UOM', 'P_UNIT_OF_MEASURE'); -- added now
1410: FND_MSG_PUB.ADD;
1411: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1412: RAISE FND_API.G_EXC_ERROR;
1413: -- The unit of measure and base uom code for this uom class need to be passed.
1414:
1415: END IF;
1416:

Line 1422: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1418:
1419: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1420: FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1421: FND_MSG_PUB.ADD;
1422: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1423: RAISE FND_API.G_EXC_ERROR;
1424: -- The unit of measure and base uom code for this uom class need to be passed.
1425:
1426: END IF;

Line 1423: RAISE FND_API.G_EXC_ERROR;

1419: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1420: FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1421: FND_MSG_PUB.ADD;
1422: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1423: RAISE FND_API.G_EXC_ERROR;
1424: -- The unit of measure and base uom code for this uom class need to be passed.
1425:
1426: END IF;
1427:

Line 1433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1429: IF P_DISABLE_DATE IS NOT NULL AND TRUNC(P_DISABLE_DATE) < TRUNC(SYSDATE) THEN
1430:
1431: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
1432: FND_MSG_PUB.ADD;
1433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1434: RAISE FND_API.G_EXC_ERROR;
1435:
1436: END IF;
1437:

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430:
1431: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
1432: FND_MSG_PUB.ADD;
1433: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1434: RAISE FND_API.G_EXC_ERROR;
1435:
1436: END IF;
1437:
1438: BEGIN

Line 1453: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1449: WHEN NO_DATA_FOUND THEN
1450: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1451: -- FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1452: FND_MSG_PUB.ADD;
1453: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END ;
1456:
1457: END IF;

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1451: -- FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1452: FND_MSG_PUB.ADD;
1453: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END ;
1456:
1457: END IF;
1458:

Line 1473: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1469: EXCEPTION
1470: WHEN NO_DATA_FOUND THEN
1471: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1472: FND_MSG_PUB.ADD;
1473: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1474: RAISE fnd_api.g_exc_error;
1475:
1476: end;
1477:

Line 1474: RAISE fnd_api.g_exc_error;

1470: WHEN NO_DATA_FOUND THEN
1471: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1472: FND_MSG_PUB.ADD;
1473: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1474: RAISE fnd_api.g_exc_error;
1475:
1476: end;
1477:
1478:

Line 1485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1481:
1482: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1483: FND_MESSAGE.SET_TOKEN('UOM', 'P_UNIT_OF_MEASURE'); -- added now
1484: FND_MSG_PUB.ADD;
1485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1486: RAISE FND_API.G_EXC_ERROR;
1487: -- The unit of measure and base uom code for this uom class need to be passed.
1488:
1489: END IF;

Line 1486: RAISE FND_API.G_EXC_ERROR;

1482: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1483: FND_MESSAGE.SET_TOKEN('UOM', 'P_UNIT_OF_MEASURE'); -- added now
1484: FND_MSG_PUB.ADD;
1485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1486: RAISE FND_API.G_EXC_ERROR;
1487: -- The unit of measure and base uom code for this uom class need to be passed.
1488:
1489: END IF;
1490:

Line 1496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1492:
1493: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1494: FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1495: FND_MSG_PUB.ADD;
1496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1497: RAISE FND_API.G_EXC_ERROR;
1498: -- The unit of measure and base uom code for this uom class need to be passed.
1499:
1500: END IF;

Line 1497: RAISE FND_API.G_EXC_ERROR;

1493: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
1494: FND_MESSAGE.SET_TOKEN('UOM', 'P_UOM_CODE'); -- added now
1495: FND_MSG_PUB.ADD;
1496: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1497: RAISE FND_API.G_EXC_ERROR;
1498: -- The unit of measure and base uom code for this uom class need to be passed.
1499:
1500: END IF;
1501:

Line 1507: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1503: IF P_DISABLE_DATE IS NOT NULL AND TRUNC(P_DISABLE_DATE) < TRUNC(SYSDATE) THEN
1504:
1505: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
1506: FND_MSG_PUB.ADD;
1507: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1508: RAISE FND_API.G_EXC_ERROR;
1509:
1510: END IF;
1511:

Line 1508: RAISE FND_API.G_EXC_ERROR;

1504:
1505: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
1506: FND_MSG_PUB.ADD;
1507: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1508: RAISE FND_API.G_EXC_ERROR;
1509:
1510: END IF;
1511:
1512: BEGIN

Line 1539: RAISE FND_API.G_EXC_ERROR;

1535:
1536: FND_MESSAGE.SET_NAME('INV', 'INV_UNIT_EXISTS');
1537: FND_MESSAGE.SET_TOKEN('VALUE1', L_UNIT_OF_MEASURE);
1538: FND_MSG_PUB.ADD;
1539: RAISE FND_API.G_EXC_ERROR;
1540:
1541: --fnd_message.raise_error;
1542: -- Already unit of measure and uom code exists with some other class exists.
1543:

Line 1625: RAISE FND_API.G_EXC_ERROR;

1621: , P_DESC_FLEX_NAME => L_DESC_FLEX_NAME
1622: );
1623:
1624: IF L_RETURN_STATUS = 'E' THEN
1625: RAISE FND_API.G_EXC_ERROR;
1626: ELSIF L_RETURN_STATUS = 'U' THEN
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END IF;
1629:

Line 1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1623:
1624: IF L_RETURN_STATUS = 'E' THEN
1625: RAISE FND_API.G_EXC_ERROR;
1626: ELSIF L_RETURN_STATUS = 'U' THEN
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END IF;
1629:
1630: -- Defaulting the DFF attribute parameters to null if the corresponding attributes are not enabled
1631:

Line 1723: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1719:
1720: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
1721: fnd_message.set_token('VALUE1', 'p_action_type');
1722: FND_MSG_PUB.ADD;
1723: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1724:
1725: RAISE L_INVALID_OBJECT_TYPE;
1726:
1727: END IF;

Line 1731: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;

1727: END IF;
1728:
1729: -- End of Code logic to insert MTL_UNITS_OF_MEASURE table.
1730: -- print_debug(' successfully returned from the package create_unit_of_measure ' || g_pkg_version, 1);
1731: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;
1732:
1733: COMMIT;
1734:
1735: EXCEPTION

Line 1737: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1733: COMMIT;
1734:
1735: EXCEPTION
1736: WHEN L_INVALID_OBJECT_TYPE THEN
1737: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1738: FND_MSG_PUB.COUNT_AND_GET
1739: ( P_COUNT => X_MSG_COUNT
1740: , P_DATA => X_MSG_DATA
1741: );

Line 1744: WHEN FND_API.G_EXC_ERROR THEN

1740: , P_DATA => X_MSG_DATA
1741: );
1742:
1743: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1744: WHEN FND_API.G_EXC_ERROR THEN
1745:
1746: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1747:
1748: -- Get message count and data

Line 1746: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1742:
1743: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1744: WHEN FND_API.G_EXC_ERROR THEN
1745:
1746: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1747:
1748: -- Get message count and data
1749: FND_MSG_PUB.COUNT_AND_GET
1750: ( P_COUNT => X_MSG_COUNT

Line 1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1751: , P_DATA => X_MSG_DATA
1752: );
1753: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1754:
1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1756:
1757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: -- Get message count and data

Line 1757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1753: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
1754:
1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1756:
1757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: -- Get message count and data
1760: FND_MSG_PUB.COUNT_AND_GET
1761: ( P_COUNT => X_MSG_COUNT

Line 1765: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1761: ( P_COUNT => X_MSG_COUNT
1762: , P_DATA => X_MSG_DATA
1763: );
1764: WHEN OTHERS THEN
1765: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1766: FND_MSG_PUB.COUNT_AND_GET
1767: ( P_COUNT => X_MSG_COUNT
1768: , P_DATA => X_MSG_DATA
1769: );

Line 1798: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

1794: --
1795: -- p_disable_date In active date.
1796: -- p_action_type Object type whether 'I' or 'U'
1797: -- Output Parameters
1798: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
1799: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
1800: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
1801: --
1802: -- x_msg_count = Message count

Line 1799: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred

1795: -- p_disable_date In active date.
1796: -- p_action_type Object type whether 'I' or 'U'
1797: -- Output Parameters
1798: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
1799: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
1800: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
1801: --
1802: -- x_msg_count = Message count
1803: -- x_msg_data = Message text

Line 1800: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred

1796: -- p_action_type Object type whether 'I' or 'U'
1797: -- Output Parameters
1798: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
1799: -- = fnd_api.g_ret_sts_exc_error, if an expected error occurred
1800: -- = fnd_api.g_ret_sts_unexp_error, if an unexpected error occurred
1801: --
1802: -- x_msg_count = Message count
1803: -- x_msg_data = Message text
1804: --

Line 2025: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2021: IF (P_UOM_RATE IS NULL) THEN
2022:
2023: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_CONVRATE_REQUIRED');
2024: FND_MSG_PUB.ADD;
2025: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2026: RAISE L_INVALID_UOM_RATE;
2027:
2028: END IF;
2029:

Line 2034: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2030: IF (P_UOM_RATE <= 0) THEN
2031:
2032: FND_MESSAGE.SET_NAME('INV', 'INV_NEG_CONV');
2033: FND_MSG_PUB.ADD;
2034: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2035: RAISE L_INVALID_UOM_RATE;
2036:
2037: END IF;
2038:

Line 2047: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2043: END IF;
2044:
2045: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
2046: FND_MSG_PUB.ADD;
2047: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2048: RAISE FND_API.G_EXC_ERROR;
2049:
2050: END IF;
2051:

Line 2048: RAISE FND_API.G_EXC_ERROR;

2044:
2045: FND_MESSAGE.SET_NAME('INV', 'INV_DISABLE_DATE');
2046: FND_MSG_PUB.ADD;
2047: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2048: RAISE FND_API.G_EXC_ERROR;
2049:
2050: END IF;
2051:
2052:

Line 2077: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2073: if l_qr > 0 then
2074:
2075: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_RSV_EXIST');
2076: FND_MSG_PUB.ADD;
2077: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2078: RAISE FND_API.G_EXC_ERROR;
2079: end if;
2080:
2081:

Line 2078: RAISE FND_API.G_EXC_ERROR;

2074:
2075: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_RSV_EXIST');
2076: FND_MSG_PUB.ADD;
2077: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2078: RAISE FND_API.G_EXC_ERROR;
2079: end if;
2080:
2081:
2082: BEGIN

Line 2155: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

2151: IF (L_DEBUG = 1) THEN
2152: INV_LOG_UTIL.TRACE('After standard uom conversion creations,X_RETURN_STATUS:'|| X_RETURN_STATUS, 'inv_uom_api_pub', '9');
2153: END IF;
2154:
2155: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
2156:
2157: IF L_FROM_CLASS = L_TO_CLASS THEN -- standard intra class conversion.
2158:
2159: UPDATE MTL_UOM_CONVERSIONS

Line 2189: RAISE FND_API.G_EXC_ERROR;

2185: FND_MSG_PUB.ADD;
2186:
2187: RAISE L_CONVERSION_EXISTS_EXC;
2188: ELSIF X_RETURN_STATUS <> 'S' THEN
2189: RAISE FND_API.G_EXC_ERROR;
2190: END IF;
2191:
2192: END;
2193:

Line 2270: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2266:
2267: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
2268: FND_MESSAGE.SET_TOKEN('VALUE1', 'p_action_type');
2269: FND_MSG_PUB.ADD;
2270: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2271:
2272: RAISE L_INVALID_OBJECT;
2273:
2274: END IF; -- end if of p_action_type = U

Line 2287: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2283: EXCEPTION
2284: WHEN OTHERS THEN
2285: FND_MESSAGE.SET_NAME('INV', 'INV_INT_ORGCODE');
2286: FND_MSG_PUB.ADD;
2287: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2288: RAISE FND_API.G_EXC_ERROR;
2289: END;
2290:
2291: IF (L_DEBUG = 1) THEN

Line 2288: RAISE FND_API.G_EXC_ERROR;

2284: WHEN OTHERS THEN
2285: FND_MESSAGE.SET_NAME('INV', 'INV_INT_ORGCODE');
2286: FND_MSG_PUB.ADD;
2287: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2288: RAISE FND_API.G_EXC_ERROR;
2289: END;
2290:
2291: IF (L_DEBUG = 1) THEN
2292: INV_LOG_UTIL.TRACE('l_ORG_EXISTS:' || l_ORG_EXISTS, 'inv_uom_api_pub', '9');

Line 2305: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: FND_MESSAGE.SET_NAME('INV', 'INV_INT_ITMCODE');
2304: FND_MSG_PUB.ADD;
2305: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2306: RAISE FND_API.G_EXC_ERROR;
2307:
2308: END;
2309:

Line 2306: RAISE FND_API.G_EXC_ERROR;

2302: WHEN OTHERS THEN
2303: FND_MESSAGE.SET_NAME('INV', 'INV_INT_ITMCODE');
2304: FND_MSG_PUB.ADD;
2305: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2306: RAISE FND_API.G_EXC_ERROR;
2307:
2308: END;
2309:
2310: IF (L_DEBUG = 1) THEN

Line 2428: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2424:
2425: IF( v_lot_control_code = 1 ) THEN
2426: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_CTL_ERROR');
2427: FND_MSG_PUB.ADD;
2428: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2429: FND_MESSAGE.RAISE_ERROR;
2430: END IF;
2431:
2432: END;

Line 2449: RAISE FND_API.G_EXC_ERROR;

2445: EXCEPTION
2446: WHEN NO_DATA_FOUND THEN
2447: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_INVALID');
2448: FND_MSG_PUB.ADD;
2449: RAISE FND_API.G_EXC_ERROR;
2450: END ;
2451:
2452: -- End of Validating the passed lot valid with the same item.
2453:

Line 2472: RAISE FND_API.G_EXC_ERROR;

2468: INV_LOG_UTIL.TRACE('Lot expired' , 'inv_uom_api_pub', '9');
2469: END IF;
2470: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_EXPIRED');
2471: FND_MSG_PUB.ADD;
2472: RAISE FND_API.G_EXC_ERROR;
2473: END;
2474:
2475: END IF;
2476:

Line 2507: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2503:
2504: IF (l_count > 0) THEN
2505: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UOM_INUSE');
2506: FND_MSG_PUB.ADD;
2507: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2508: FND_MESSAGE.RAISE_ERROR;
2509: END IF;
2510: -- End of Check if the lot uom conversion already present.
2511: -- From and to UOM cannot be the same.

Line 2516: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2512:
2513: IF (p_from_uom_code = p_to_uom_code) THEN
2514: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UOM_FROMTO_ERROR');
2515: FND_MSG_PUB.ADD;
2516: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2517: fnd_message.raise_error;
2518: END IF;
2519: -- End of From and to UOM cannot be the same.
2520: -- Check if item is lot controlled.

Line 2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2548:
2549: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
2550: fnd_message.set_token('VALUE1', 'p_action_type');
2551: FND_MSG_PUB.ADD;
2552: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2553:
2554: RAISE L_INVALID_OBJECT;
2555:
2556: END IF;

Line 2595: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2591:
2592: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UPDATETYPE_INVALID');
2593: FND_MSG_PUB.ADD;
2594:
2595: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2596: -- fnd_message.raise_error;
2597: RAISE FND_API.G_EXC_ERROR;
2598:
2599: END IF;

Line 2597: RAISE FND_API.G_EXC_ERROR;

2593: FND_MSG_PUB.ADD;
2594:
2595: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2596: -- fnd_message.raise_error;
2597: RAISE FND_API.G_EXC_ERROR;
2598:
2599: END IF;
2600: -- check for object_type 1,2-----
2601:

Line 2609: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2605:
2606: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_TYPE0_ERROR');
2607: FND_MSG_PUB.ADD;
2608:
2609: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2610: FND_MESSAGE.RAISE_ERROR;
2611: -- Error if the item is not Dual Fixed or dual default.
2612: ELSIF (L_SECONDARY_DEF_IND NOT IN ('F', 'D')) THEN
2613:

Line 2617: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2613:
2614: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_TYPE3_ERROR');
2615: FND_MSG_PUB.ADD;
2616:
2617: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2618: FND_MESSAGE.RAISE_ERROR;
2619:
2620: END IF;
2621: -- END IF;

Line 2642: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2638: CLOSE GET_NON_BATCH_TXNS;
2639: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_NON_BATCH');
2640: FND_MSG_PUB.ADD;
2641:
2642: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2643: RAISE FND_API.G_EXC_ERROR;
2644:
2645: END IF;
2646:

Line 2643: RAISE FND_API.G_EXC_ERROR;

2639: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_NON_BATCH');
2640: FND_MSG_PUB.ADD;
2641:
2642: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2643: RAISE FND_API.G_EXC_ERROR;
2644:
2645: END IF;
2646:
2647: CLOSE GET_NON_BATCH_TXNS;

Line 2692: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2688: CLOSE GET_BATCH_INFO;
2689: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_MULT_BATCHES');
2690: FND_MSG_PUB.ADD;
2691:
2692: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2693: FND_MESSAGE.RAISE_ERROR;
2694:
2695: END IF;
2696:

Line 2705: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2701: CLOSE GET_BATCH_INFO;
2702: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_INGREDIENT');
2703: FND_MSG_PUB.ADD;
2704:
2705: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2706: FND_MESSAGE.RAISE_ERROR;
2707:
2708: END IF;
2709:

Line 2718: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2714: IF (X_OPM_COSTED_FLAG IS NULL) THEN
2715:
2716: FND_MESSAGE.SET_NAME('INV','INV_LOTCONV_INDITEM_COSTED');
2717: FND_MSG_PUB.ADD;
2718: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2719: FND_MESSAGE.RAISE_ERROR;
2720:
2721: END IF ;
2722:

Line 2736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2732:
2733: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_NO_BATCHES');
2734: FND_MSG_PUB.ADD;
2735:
2736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2737: FND_MESSAGE.RAISE_ERROR;
2738:
2739: END IF;
2740: -- Conversion can be updated only if batch status is WIP or Completed.

Line 2749: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2745: ELSE
2746: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_INVALID_BATCH_STS');
2747: FND_MSG_PUB.ADD;
2748:
2749: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2750: FND_MESSAGE.RAISE_ERROR;
2751:
2752: END IF;
2753:

Line 2787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2783: IF x_uom_class <> x_sec_uom_class THEN
2784: CLOSE GET_MATL_LINES;
2785: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_UPD_WRNG_DTLUM_CLS');
2786: FND_MSG_PUB.ADD;
2787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2788: RAISE FND_API.G_EXC_ERROR;
2789:
2790: END IF;
2791: END IF;

Line 2788: RAISE FND_API.G_EXC_ERROR;

2784: CLOSE GET_MATL_LINES;
2785: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_UPD_WRNG_DTLUM_CLS');
2786: FND_MSG_PUB.ADD;
2787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2788: RAISE FND_API.G_EXC_ERROR;
2789:
2790: END IF;
2791: END IF;
2792:

Line 2805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2801:
2802: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_TYPE_NOT_ALLOWED');
2803: FND_MSG_PUB.ADD;
2804:
2805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2806: FND_MESSAGE.RAISE_ERROR;
2807:
2808: END IF;
2809:

Line 2856: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2852:
2853: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_CONV_FUNC');
2854: FND_MSG_PUB.ADD;
2855:
2856: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2857: FND_MESSAGE.RAISE_ERROR;
2858:
2859: ELSE
2860: NEW_SECONDARY_QTY := X_CALC_QTY;

Line 2879: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2875:
2876: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_CONV_FUNC');
2877: FND_MSG_PUB.ADD;
2878:
2879: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2880: FND_MESSAGE.RAISE_ERROR;
2881:
2882: ELSE
2883: NEW_PRIMARY_QTY := X_CALC_QTY;

Line 3004: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3000: FND_MSG_PUB.ADD;
3001: FND_MESSAGE.RAISE_ERROR;
3002: END LOOP;
3003:
3004: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3005:
3006: END IF;
3007:
3008: IF (L_QR > 0) THEN

Line 3012: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3008: IF (L_QR > 0) THEN
3009:
3010: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_RSV_EXIST');
3011: FND_MSG_PUB.ADD;
3012: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3013: RAISE FND_API.G_EXC_ERROR;
3014:
3015: END IF;
3016:

Line 3013: RAISE FND_API.G_EXC_ERROR;

3009:
3010: FND_MESSAGE.SET_NAME('INV', 'INV_LOTCONV_RSV_EXIST');
3011: FND_MSG_PUB.ADD;
3012: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3013: RAISE FND_API.G_EXC_ERROR;
3014:
3015: END IF;
3016:
3017: -- End of reservation validationg for the item.

Line 3063: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3059: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_PARAMETER_TYPE');
3060: FND_MESSAGE.SET_TOKEN('VALUE1', 'P_ONHAND_UPDATE');
3061: FND_MSG_PUB.ADD;
3062:
3063: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3064:
3065: RAISE FND_API.G_EXC_ERROR;
3066:
3067: END IF;

Line 3065: RAISE FND_API.G_EXC_ERROR;

3061: FND_MSG_PUB.ADD;
3062:
3063: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3064:
3065: RAISE FND_API.G_EXC_ERROR;
3066:
3067: END IF;
3068:
3069: BEGIN

Line 3148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3144: FND_MSG_PUB.ADD;
3145: fnd_message.raise_error;
3146: END LOOP;
3147:
3148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3149:
3150: END IF;
3151:
3152: END IF; -- Lot specific conversion.

Line 3154: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;

3150: END IF;
3151:
3152: END IF; -- Lot specific conversion.
3153:
3154: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;
3155:
3156: COMMIT;
3157:
3158: EXCEPTION

Line 3160: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3156: COMMIT;
3157:
3158: EXCEPTION
3159: WHEN L_INVALID_BASE_UOM THEN
3160: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3161: FND_MSG_PUB.COUNT_AND_GET
3162: ( P_COUNT => X_MSG_COUNT
3163: , P_DATA => X_MSG_DATA
3164: );

Line 3168: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3164: );
3165: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3166:
3167: WHEN L_INVALID_REASON THEN
3168: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3169: FND_MSG_PUB.COUNT_AND_GET
3170: ( P_COUNT => X_MSG_COUNT
3171: , P_DATA => X_MSG_DATA
3172: );

Line 3176: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3172: );
3173: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3174: WHEN L_INVALID_OBJECT THEN
3175:
3176: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3177: FND_MSG_PUB.COUNT_AND_GET
3178: ( P_COUNT => X_MSG_COUNT
3179: , P_DATA => X_MSG_DATA
3180: );

Line 3188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3184: /* WHEN L_INVALID_LOT THEN
3185:
3186: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_LOT_INVALID');
3187: FND_MSG_PUB.ADD;
3188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3189: FND_MSG_PUB.COUNT_AND_GET
3190: ( P_COUNT => X_MSG_COUNT
3191: , P_DATA => X_MSG_DATA
3192: );

Line 3200: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3196: WHEN L_LOT_CONV_NOT_EXISTS THEN
3197:
3198: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3199: FND_MSG_PUB.ADD;
3200: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3201:
3202: FND_MSG_PUB.COUNT_AND_GET
3203: ( P_COUNT => X_MSG_COUNT
3204: , P_DATA => X_MSG_DATA

Line 3214: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3210: WHEN L_PENDING_TRAN_EXISTS THEN
3211:
3212: FND_MESSAGE.SET_NAME('GMI', 'GMI_LOTCONV_PENDING_EXIST');
3213: FND_MSG_PUB.ADD;
3214: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3215: FND_MSG_PUB.COUNT_AND_GET
3216: ( P_COUNT => X_MSG_COUNT
3217: , P_DATA => X_MSG_DATA
3218: );

Line 3225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3221:
3222: WHEN L_INVALID_UOM_RATE THEN
3223:
3224: ROLLBACK;
3225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3226: FND_MESSAGE.SET_NAME('INV', 'INV_NEG_CONV');
3227: FND_MSG_PUB.ADD;
3228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3229: FND_MSG_PUB.COUNT_AND_GET

Line 3228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3224: ROLLBACK;
3225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3226: FND_MESSAGE.SET_NAME('INV', 'INV_NEG_CONV');
3227: FND_MSG_PUB.ADD;
3228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3229: FND_MSG_PUB.COUNT_AND_GET
3230: ( P_COUNT => X_MSG_COUNT
3231: , P_DATA => X_MSG_DATA
3232: );

Line 3236: WHEN FND_API.G_EXC_ERROR THEN

3232: );
3233:
3234: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3235:
3236: WHEN FND_API.G_EXC_ERROR THEN
3237:
3238: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3239:
3240: -- Get message count and data

Line 3238: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3234: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3235:
3236: WHEN FND_API.G_EXC_ERROR THEN
3237:
3238: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3239:
3240: -- Get message count and data
3241: FND_MSG_PUB.COUNT_AND_GET
3242: ( P_COUNT => X_MSG_COUNT

Line 3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3244: );
3245:
3246: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3247:
3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3249:
3250: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;
3251:
3252: -- Get message count and data

Line 3250: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;

3246: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3247:
3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3249:
3250: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;
3251:
3252: -- Get message count and data
3253: FND_MSG_PUB.COUNT_AND_GET
3254: ( P_COUNT => X_MSG_COUNT

Line 3262: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3258: WHEN L_INVALID_UOM_EXC THEN
3259:
3260: FND_MESSAGE.SET_NAME('INV', 'INV_UOM_NOTFOUND');
3261: FND_MSG_PUB.ADD;
3262: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3263: FND_MSG_PUB.COUNT_AND_GET
3264: ( P_COUNT => X_MSG_COUNT
3265: , P_DATA => X_MSG_DATA
3266: );

Line 3283: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3279: WHEN L_INVALID_ITEM_EXC THEN
3280:
3281: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');
3282: FND_MSG_PUB.ADD;
3283: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3284: FND_MSG_PUB.COUNT_AND_GET
3285: ( P_COUNT => X_MSG_COUNT
3286: , P_DATA => X_MSG_DATA
3287: );

Line 3293: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3289: WHEN L_UOM_FROMTO_EXC THEN
3290:
3291: FND_MESSAGE.SET_NAME('INV', 'INV_LOTC_UOM_FROMTO_ERROR');
3292: FND_MSG_PUB.ADD;
3293: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3294: FND_MSG_PUB.COUNT_AND_GET
3295: ( P_COUNT => X_MSG_COUNT
3296: , P_DATA => X_MSG_DATA
3297: );

Line 3304: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3300: WHEN L_CONV_NOT_EXISTS THEN
3301:
3302: FND_MESSAGE.SET_NAME('INV', 'INV_NO_CONVERSIONS');
3303: FND_MSG_PUB.ADD;
3304: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3305:
3306: FND_MSG_PUB.COUNT_AND_GET
3307: ( P_COUNT => X_MSG_COUNT
3308: , P_DATA => X_MSG_DATA

Line 3315: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3311: X_MSG_DATA := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
3312:
3313: WHEN OTHERS THEN
3314:
3315: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3316: FND_MSG_PUB.COUNT_AND_GET
3317: ( P_COUNT => X_MSG_COUNT
3318: , P_DATA => X_MSG_DATA
3319: );