DBA Data[Home] [Help]

APPS.INV_DECIMALS_PUB dependencies on FND_MESSAGE

Line 309: fnd_message.set_name('INV', 'MAX_DECIMAL_LENGTH');

305: x_return_status := fnd_api.g_ret_sts_success;
306:
307: -- now make sure that # of decimal digits does not exceed g_max_decimal_digits
308: if ( p_input_quantity <> ROUND(p_input_quantity, g_max_decimal_digits)) then
309: fnd_message.set_name('INV', 'MAX_DECIMAL_LENGTH');
310: x_output_quantity := ROUND(p_input_quantity, g_max_decimal_digits);
311: l_raise_warning := 1 ;
312: else
313: if (x_output_quantity IS NULL) then

Line 321: fnd_message.set_name('INV', 'MAX_REAL_LENGTH');

317:
318: -- Now make sure that the length of real part of number doesn't exceed
319: -- g_max_real_digits
320: if ( trunc(abs(p_input_quantity)) > (POWER(10,g_max_real_digits) - 1) ) then
321: fnd_message.set_name('INV', 'MAX_REAL_LENGTH');
322: raise fnd_api.g_exc_error;
323: end if;
324:
325: -- now that in the given UOM the item quantity obeys the decimal precision rules

Line 382: fnd_message.set_name('INV', 'PRI_MAX_DECIMAL_LENGTH');

378:
379: if ( l_decimal_profile = '1' ) then -- '1'= yes, '2' = no
380:
381: if ( x_primary_quantity <> ROUND(x_primary_quantity,g_max_decimal_digits) ) then
382: fnd_message.set_name('INV', 'PRI_MAX_DECIMAL_LENGTH');
383: raise fnd_api.g_exc_error;
384: end if;
385:
386: -- Now make sure that the length of real part of number doesn't exceed

Line 389: fnd_message.set_name('INV', 'PRI_MAX_REAL_LENGTH');

385:
386: -- Now make sure that the length of real part of number doesn't exceed
387: -- g_max_real_digits
388: if ( trunc(abs(x_primary_quantity)) > ( POWER(10,g_max_real_digits) - 1) ) then
389: fnd_message.set_name('INV', 'PRI_MAX_REAL_LENGTH');
390: raise fnd_api.g_exc_error;
391: end if;
392:
393: -- now check if the quantity in primary UOM is zero

Line 395: fnd_message.set_name('INV', 'PRI_QTY_IS_ZERO');

391: end if;
392:
393: -- now check if the quantity in primary UOM is zero
394: if ( (x_primary_quantity = 0) AND (p_input_quantity <> 0) ) then
395: fnd_message.set_name('INV', 'PRI_QTY_IS_ZERO');
396: raise fnd_api.g_exc_error ;
397: end if;
398:
399: end if;

Line 407: fnd_message.set_name('INV', 'DIVISIBILITY_VIOLATION');

403: -- if item has indivisible flag set, then make sure that quantity is integer in
404: -- primary UOM
405:
406: if (( l_indivisible_flag = 'Y' ) AND ( Round(x_primary_quantity,(g_max_decimal_digits-1)) <> TRUNC(x_primary_quantity)) ) then
407: fnd_message.set_name('INV', 'DIVISIBILITY_VIOLATION');
408: raise fnd_api.g_exc_error ;
409: end if;
410:
411: -- if item is serial number controlled, make the qty in primary UOM is integer

Line 417: fnd_message.set_name('INV', 'SERIAL_QTY_VIOLATION');

413: -- integer in primary uom. Even if specific serial may not be required at the time, the
414: -- qty of a serial number should be integer in primary uom.
415:
416: if ( (l_serial_control > 1 ) AND ( x_primary_quantity <> TRUNC(x_primary_quantity)) ) then
417: fnd_message.set_name('INV', 'SERIAL_QTY_VIOLATION');
418: raise fnd_api.g_exc_error ;
419: end if;
420:
421: if ( l_raise_warning = 1 ) then

Line 508: fnd_message.set_name('INV', 'MAX_DECIMAL_LENGTH');

504: end if;
505:
506: -- now make sure that # of decimal digits does not exceed l_max_decimal_digits
507: if ( p_input_quantity <> ROUND(p_input_quantity, l_max_decimal_digits)) then
508: fnd_message.set_name('INV', 'MAX_DECIMAL_LENGTH');
509: x_output_quantity := ROUND(p_input_quantity, l_max_decimal_digits);
510: l_raise_warning := 1 ;
511: else
512: if (x_output_quantity IS NULL) then

Line 520: fnd_message.set_name('INV', 'MAX_REAL_LENGTH');

516:
517: -- Now make sure that the length of real part of number doesn't exceed
518: -- g_max_real_digits
519: if ( trunc(abs(p_input_quantity)) > (POWER(10,g_max_real_digits) - 1) ) then
520: fnd_message.set_name('INV', 'MAX_REAL_LENGTH');
521: raise fnd_api.g_exc_error;
522: end if;
523:
524: -- now that in the given UOM the item quantity obeys the decimal precision rules

Line 566: fnd_message.set_name('INV', 'PRI_MAX_DECIMAL_LENGTH');

562:
563: if ( l_decimal_profile = '1' ) then -- '1'= yes, '2' = no
564:
565: if ( x_primary_quantity <> ROUND(x_primary_quantity,l_max_decimal_digits) ) then
566: fnd_message.set_name('INV', 'PRI_MAX_DECIMAL_LENGTH');
567: raise fnd_api.g_exc_error;
568: end if;
569:
570: -- Now make sure that the length of real part of number doesn't exceed

Line 573: fnd_message.set_name('INV', 'PRI_MAX_REAL_LENGTH');

569:
570: -- Now make sure that the length of real part of number doesn't exceed
571: -- g_max_real_digits
572: if ( trunc(abs(x_primary_quantity)) > ( POWER(10,g_max_real_digits) - 1) ) then
573: fnd_message.set_name('INV', 'PRI_MAX_REAL_LENGTH');
574: raise fnd_api.g_exc_error;
575: end if;
576:
577: -- now check if the quantity in primary UOM is zero

Line 579: fnd_message.set_name('INV', 'PRI_QTY_IS_ZERO');

575: end if;
576:
577: -- now check if the quantity in primary UOM is zero
578: if ( (x_primary_quantity = 0) AND (p_input_quantity <> 0) ) then
579: fnd_message.set_name('INV', 'PRI_QTY_IS_ZERO');
580: raise fnd_api.g_exc_error ;
581: end if;
582:
583: end if;

Line 591: fnd_message.set_name('INV', 'DIVISIBILITY_VIOLATION');

587: -- if item has indivisible flag set, then make sure that quantity is integer in
588: -- primary UOM
589:
590: if (( l_indivisible_flag = 'Y' ) AND ( Round(x_primary_quantity,(l_max_decimal_digits-1)) <> TRUNC(x_primary_quantity)) ) then
591: fnd_message.set_name('INV', 'DIVISIBILITY_VIOLATION');
592: raise fnd_api.g_exc_error ;
593: end if;
594:
595: -- if item is serial number controlled, make the qty in primary UOM is integer

Line 601: fnd_message.set_name('INV', 'SERIAL_QTY_VIOLATION');

597: -- integer in primary uom. Even if specific serial may not be required at the time, the
598: -- qty of a serial number should be integer in primary uom.
599:
600: if ( (l_serial_control > 1 ) AND ( x_primary_quantity <> TRUNC(x_primary_quantity)) ) then
601: fnd_message.set_name('INV', 'SERIAL_QTY_VIOLATION');
602: raise fnd_api.g_exc_error ;
603: end if;
604:
605: if ( l_raise_warning = 1 ) then