DBA Data[Home] [Help]

APPS.WMS_ASN_LOT_ATT dependencies on FND_FLEX_DESCVAL

Line 740: fnd_flex_descval.set_context_value(x_context_value);

736:
737: if x_context_value is not null
738: then
739:
740: fnd_flex_descval.set_context_value(x_context_value);
741: fnd_flex_descval.clear_column_values;
742: fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
743: g_lot_attributes_tbl(9).column_value);
744:

Line 741: fnd_flex_descval.clear_column_values;

737: if x_context_value is not null
738: then
739:
740: fnd_flex_descval.set_context_value(x_context_value);
741: fnd_flex_descval.clear_column_values;
742: fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
743: g_lot_attributes_tbl(9).column_value);
744:
745: IF (l_debug = 1) THEN

Line 742: fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',

738: then
739:
740: fnd_flex_descval.set_context_value(x_context_value);
741: fnd_flex_descval.clear_column_values;
742: fnd_flex_descval.set_column_value('LOT_ATTRIBUTE_CATEGORY',
743: g_lot_attributes_tbl(9).column_value);
744:
745: IF (l_debug = 1) THEN
746: print_debug('After Setting the context Code for validation '||' Progress ='|| l_progress , 4);

Line 782: fnd_flex_descval.set_column_value(g_lot_attributes_tbl(k).column_name,

778: if g_lot_attributes_tbl(k).column_type = 'DATE' then
779: IF (l_debug = 1) THEN
780: print_debug('Setting the columns for validation -- Date' , 4);
781: END IF;
782: fnd_flex_descval.set_column_value(g_lot_attributes_tbl(k).column_name,
783: fnd_date.canonical_to_date(g_lot_attributes_tbl(k).column_value));
784: end if;
785:
786: if g_lot_attributes_tbl(k).column_type = 'NUMBER' then

Line 790: fnd_flex_descval.set_column_value(g_lot_attributes_tbl(k).column_name,

786: if g_lot_attributes_tbl(k).column_type = 'NUMBER' then
787: IF (l_debug = 1) THEN
788: print_debug('Setting the columns for validation -- Number' , 4);
789: END IF;
790: fnd_flex_descval.set_column_value(g_lot_attributes_tbl(k).column_name,
791: to_number(g_lot_attributes_tbl(k).column_value));
792: end if;
793:
794: if g_lot_attributes_tbl(k).column_type = 'VARCHAR2' then

Line 798: fnd_flex_descval.set_column_value(g_lot_attributes_tbl(k).column_name,

794: if g_lot_attributes_tbl(k).column_type = 'VARCHAR2' then
795: IF (l_debug = 1) THEN
796: print_debug('Setting the columns for validation -- Varchar2' , 4);
797: END IF;
798: fnd_flex_descval.set_column_value(g_lot_attributes_tbl(k).column_name,
799: g_lot_attributes_tbl(k).column_value);
800: end if;
801:
802: IF (l_debug = 1) THEN

Line 827: l_status := fnd_flex_descval.validate_desccols(

823: IF (l_debug = 1) THEN
824: print_debug('Before Calling The API for validation ' , 4);
825: END IF;
826:
827: l_status := fnd_flex_descval.validate_desccols(
828: appl_short_name => 'INV',
829: desc_flex_name => l_attributes_name);
830:
831: if l_status = TRUE then

Line 839: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);

835: null;
836: else
837: IF (l_debug = 1) THEN
838: print_debug('API for validation is failure' , 4);
839: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
840: END IF;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: x_msg_data := fnd_flex_descval.error_message;
843: raise FND_API.G_EXC_ERROR;

Line 842: x_msg_data := fnd_flex_descval.error_message;

838: print_debug('API for validation is failure' , 4);
839: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
840: END IF;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: x_msg_data := fnd_flex_descval.error_message;
843: raise FND_API.G_EXC_ERROR;
844: end if;
845:
846: l_progress := '100';

Line 1717: fnd_flex_descval.set_context_value(x_context_value);

1713:
1714: if x_context_value is not null
1715: then
1716:
1717: fnd_flex_descval.set_context_value(x_context_value);
1718: fnd_flex_descval.clear_column_values;
1719: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY',
1720: g_serial_attributes_tbl(1).column_value);
1721:

Line 1718: fnd_flex_descval.clear_column_values;

1714: if x_context_value is not null
1715: then
1716:
1717: fnd_flex_descval.set_context_value(x_context_value);
1718: fnd_flex_descval.clear_column_values;
1719: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY',
1720: g_serial_attributes_tbl(1).column_value);
1721:
1722: IF (l_debug = 1) THEN

Line 1719: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY',

1715: then
1716:
1717: fnd_flex_descval.set_context_value(x_context_value);
1718: fnd_flex_descval.clear_column_values;
1719: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY',
1720: g_serial_attributes_tbl(1).column_value);
1721:
1722: IF (l_debug = 1) THEN
1723: print_debug('After Setting the context Code for validation '||' Progress ='|| l_progress , 4);

Line 1759: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,

1755: if g_serial_attributes_tbl(k).column_type = 'DATE' then
1756: IF (l_debug = 1) THEN
1757: print_debug('Setting the columns for validation -- Date' , 4);
1758: END IF;
1759: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
1760: fnd_date.canonical_to_date(g_serial_attributes_tbl(k).column_value));
1761: end if;
1762:
1763: if g_serial_attributes_tbl(k).column_type = 'NUMBER' then

Line 1767: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,

1763: if g_serial_attributes_tbl(k).column_type = 'NUMBER' then
1764: IF (l_debug = 1) THEN
1765: print_debug('Setting the columns for validation -- Number' , 4);
1766: END IF;
1767: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
1768: to_number(g_serial_attributes_tbl(k).column_value));
1769: end if;
1770:
1771: if g_serial_attributes_tbl(k).column_type = 'VARCHAR2' then

Line 1775: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,

1771: if g_serial_attributes_tbl(k).column_type = 'VARCHAR2' then
1772: IF (l_debug = 1) THEN
1773: print_debug('Setting the columns for validation -- Varchar2' , 4);
1774: END IF;
1775: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
1776: g_serial_attributes_tbl(k).column_value);
1777: end if;
1778:
1779: IF (l_debug = 1) THEN

Line 1804: l_status := fnd_flex_descval.validate_desccols(

1800: IF (l_debug = 1) THEN
1801: print_debug('Before Calling The API for validation ' , 4);
1802: END IF;
1803:
1804: l_status := fnd_flex_descval.validate_desccols(
1805: appl_short_name => 'INV',
1806: desc_flex_name => l_attributes_name);
1807:
1808: if l_status = TRUE then

Line 1816: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);

1812: null;
1813: else
1814: IF (l_debug = 1) THEN
1815: print_debug('API for validation is failure' , 4);
1816: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
1817: END IF;
1818: x_return_status := FND_API.G_RET_STS_ERROR ;
1819: x_msg_data := fnd_flex_descval.error_message;
1820: raise FND_API.G_EXC_ERROR;

Line 1819: x_msg_data := fnd_flex_descval.error_message;

1815: print_debug('API for validation is failure' , 4);
1816: print_debug('Error Messages '|| fnd_flex_descval.error_message , 4);
1817: END IF;
1818: x_return_status := FND_API.G_RET_STS_ERROR ;
1819: x_msg_data := fnd_flex_descval.error_message;
1820: raise FND_API.G_EXC_ERROR;
1821: end if;
1822:
1823: end if;