DBA Data[Home] [Help]

APPS.INV_CONSIGNED_VALIDATIONS dependencies on FND_MESSAGE

Line 1514: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');

1510:
1511: -- validate demand source info
1512: IF p_tree_mode IN (g_transaction_mode, g_loose_only_mode) THEN
1513: IF p_source_type_id IS NULL THEN
1514: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
1515: fnd_msg_pub.ADD;
1516: x_return_msg := fnd_message.get;
1517: RAISE fnd_api.g_exc_error;
1518: END IF;

Line 1516: x_return_msg := fnd_message.get;

1512: IF p_tree_mode IN (g_transaction_mode, g_loose_only_mode) THEN
1513: IF p_source_type_id IS NULL THEN
1514: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
1515: fnd_msg_pub.ADD;
1516: x_return_msg := fnd_message.get;
1517: RAISE fnd_api.g_exc_error;
1518: END IF;
1519:
1520: IF p_demand_source_header_id IS NULL THEN

Line 1522: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');

1518: END IF;
1519:
1520: IF p_demand_source_header_id IS NULL THEN
1521: IF p_demand_source_name IS NULL THEN
1522: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
1523: fnd_msg_pub.ADD;
1524: x_return_msg := fnd_message.get;
1525: RAISE fnd_api.g_exc_error;
1526: END IF;

Line 1524: x_return_msg := fnd_message.get;

1520: IF p_demand_source_header_id IS NULL THEN
1521: IF p_demand_source_name IS NULL THEN
1522: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
1523: fnd_msg_pub.ADD;
1524: x_return_msg := fnd_message.get;
1525: RAISE fnd_api.g_exc_error;
1526: END IF;
1527: END IF;
1528:

Line 1531: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');

1527: END IF;
1528:
1529: IF p_demand_source_header_id IS NULL
1530: AND p_demand_source_line_id IS NOT NULL THEN
1531: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
1532: fnd_msg_pub.ADD;
1533: x_return_msg := fnd_message.get;
1534: RAISE fnd_api.g_exc_error;
1535: END IF;

Line 1533: x_return_msg := fnd_message.get;

1529: IF p_demand_source_header_id IS NULL
1530: AND p_demand_source_line_id IS NOT NULL THEN
1531: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
1532: fnd_msg_pub.ADD;
1533: x_return_msg := fnd_message.get;
1534: RAISE fnd_api.g_exc_error;
1535: END IF;
1536: END IF;
1537:

Line 1552: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

1548: END IF;
1549:
1550: /* Validate input parameters */
1551: IF (p_inventory_item_id IS NULL) THEN
1552: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
1553: fnd_msg_pub.ADD;
1554: x_return_msg := fnd_message.get;
1555: RAISE fnd_api.g_exc_unexpected_error;
1556: END IF ;

Line 1554: x_return_msg := fnd_message.get;

1550: /* Validate input parameters */
1551: IF (p_inventory_item_id IS NULL) THEN
1552: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
1553: fnd_msg_pub.ADD;
1554: x_return_msg := fnd_message.get;
1555: RAISE fnd_api.g_exc_unexpected_error;
1556: END IF ;
1557:
1558: IF (p_query_mode = G_TXN_MODE) THEN

Line 1560: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');

1556: END IF ;
1557:
1558: IF (p_query_mode = G_TXN_MODE) THEN
1559: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN
1560: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');
1561: fnd_msg_pub.ADD;
1562: x_return_msg := fnd_message.get;
1563: RAISE fnd_api.g_exc_unexpected_error;
1564: END IF ;

Line 1562: x_return_msg := fnd_message.get;

1558: IF (p_query_mode = G_TXN_MODE) THEN
1559: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN
1560: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');
1561: fnd_msg_pub.ADD;
1562: x_return_msg := fnd_message.get;
1563: RAISE fnd_api.g_exc_unexpected_error;
1564: END IF ;
1565: ELSIF (p_query_mode = G_REG_MODE) THEN
1566: IF (p_owning_org_id IS NULL) THEN

Line 1567: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');

1563: RAISE fnd_api.g_exc_unexpected_error;
1564: END IF ;
1565: ELSIF (p_query_mode = G_REG_MODE) THEN
1566: IF (p_owning_org_id IS NULL) THEN
1567: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');
1568: fnd_msg_pub.ADD;
1569: x_return_msg := fnd_message.get;
1570: RAISE fnd_api.g_exc_unexpected_error;
1571: END IF ;

Line 1569: x_return_msg := fnd_message.get;

1565: ELSIF (p_query_mode = G_REG_MODE) THEN
1566: IF (p_owning_org_id IS NULL) THEN
1567: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');
1568: fnd_msg_pub.ADD;
1569: x_return_msg := fnd_message.get;
1570: RAISE fnd_api.g_exc_unexpected_error;
1571: END IF ;
1572: END IF;
1573:

Line 1828: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

1824: x_return_status := fnd_api.g_ret_sts_success;
1825:
1826:
1827: IF (p_inventory_item_id IS NULL) THEN
1828: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
1829: fnd_msg_pub.ADD;
1830: x_msg_data := fnd_message.get;
1831: x_return_status :='E';
1832: RAISE fnd_api.g_exc_unexpected_error;

Line 1830: x_msg_data := fnd_message.get;

1826:
1827: IF (p_inventory_item_id IS NULL) THEN
1828: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
1829: fnd_msg_pub.ADD;
1830: x_msg_data := fnd_message.get;
1831: x_return_status :='E';
1832: RAISE fnd_api.g_exc_unexpected_error;
1833: END IF ;
1834: IF (p_organization_id IS NULL) THEN

Line 1835: fnd_message.set_name('INV', 'INV-NO ORG INFORMATION');

1831: x_return_status :='E';
1832: RAISE fnd_api.g_exc_unexpected_error;
1833: END IF ;
1834: IF (p_organization_id IS NULL) THEN
1835: fnd_message.set_name('INV', 'INV-NO ORG INFORMATION');
1836: fnd_msg_pub.ADD;
1837: x_msg_data := fnd_message.get;
1838: x_return_status :='E';
1839: RAISE fnd_api.g_exc_unexpected_error;

Line 1837: x_msg_data := fnd_message.get;

1833: END IF ;
1834: IF (p_organization_id IS NULL) THEN
1835: fnd_message.set_name('INV', 'INV-NO ORG INFORMATION');
1836: fnd_msg_pub.ADD;
1837: x_msg_data := fnd_message.get;
1838: x_return_status :='E';
1839: RAISE fnd_api.g_exc_unexpected_error;
1840: END IF ;
1841:

Line 1848: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');

1844: -- The update quantity API should have minimum level of Subinventory
1845: --level.
1846:
1847: IF (p_subinventory_code IS NULL) THEN
1848: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');
1849: fnd_msg_pub.ADD;
1850: x_msg_data := fnd_message.get;
1851: x_return_status :='E';
1852: RAISE fnd_api.g_exc_unexpected_error;

Line 1850: x_msg_data := fnd_message.get;

1846:
1847: IF (p_subinventory_code IS NULL) THEN
1848: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');
1849: fnd_msg_pub.ADD;
1850: x_msg_data := fnd_message.get;
1851: x_return_status :='E';
1852: RAISE fnd_api.g_exc_unexpected_error;
1853: END IF ;
1854:

Line 4146: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');

4142:
4143: -- validate demand source info
4144: IF p_tree_mode IN (g_transaction_mode, g_loose_only_mode) THEN
4145: IF p_source_type_id IS NULL THEN
4146: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
4147: fnd_msg_pub.ADD;
4148: x_return_msg := fnd_message.get;
4149: RAISE fnd_api.g_exc_error;
4150: END IF;

Line 4148: x_return_msg := fnd_message.get;

4144: IF p_tree_mode IN (g_transaction_mode, g_loose_only_mode) THEN
4145: IF p_source_type_id IS NULL THEN
4146: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
4147: fnd_msg_pub.ADD;
4148: x_return_msg := fnd_message.get;
4149: RAISE fnd_api.g_exc_error;
4150: END IF;
4151:
4152: IF p_demand_source_header_id IS NULL THEN

Line 4154: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');

4150: END IF;
4151:
4152: IF p_demand_source_header_id IS NULL THEN
4153: IF p_demand_source_name IS NULL THEN
4154: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
4155: fnd_msg_pub.ADD;
4156: x_return_msg := fnd_message.get;
4157: RAISE fnd_api.g_exc_error;
4158: END IF;

Line 4156: x_return_msg := fnd_message.get;

4152: IF p_demand_source_header_id IS NULL THEN
4153: IF p_demand_source_name IS NULL THEN
4154: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
4155: fnd_msg_pub.ADD;
4156: x_return_msg := fnd_message.get;
4157: RAISE fnd_api.g_exc_error;
4158: END IF;
4159: END IF;
4160:

Line 4163: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');

4159: END IF;
4160:
4161: IF p_demand_source_header_id IS NULL
4162: AND p_demand_source_line_id IS NOT NULL THEN
4163: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
4164: fnd_msg_pub.ADD;
4165: x_return_msg := fnd_message.get;
4166: RAISE fnd_api.g_exc_error;
4167: END IF;

Line 4165: x_return_msg := fnd_message.get;

4161: IF p_demand_source_header_id IS NULL
4162: AND p_demand_source_line_id IS NOT NULL THEN
4163: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
4164: fnd_msg_pub.ADD;
4165: x_return_msg := fnd_message.get;
4166: RAISE fnd_api.g_exc_error;
4167: END IF;
4168: END IF;
4169:

Line 4184: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

4180: END IF;
4181:
4182: /* Validate input parameters */
4183: IF (p_inventory_item_id IS NULL) THEN
4184: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
4185: fnd_msg_pub.ADD;
4186: x_return_msg := fnd_message.get;
4187: RAISE fnd_api.g_exc_unexpected_error;
4188: END IF ;

Line 4186: x_return_msg := fnd_message.get;

4182: /* Validate input parameters */
4183: IF (p_inventory_item_id IS NULL) THEN
4184: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
4185: fnd_msg_pub.ADD;
4186: x_return_msg := fnd_message.get;
4187: RAISE fnd_api.g_exc_unexpected_error;
4188: END IF ;
4189:
4190: IF (p_query_mode = G_TXN_MODE) THEN

Line 4192: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');

4188: END IF ;
4189:
4190: IF (p_query_mode = G_TXN_MODE) THEN
4191: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN
4192: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');
4193: fnd_msg_pub.ADD;
4194: x_return_msg := fnd_message.get;
4195: RAISE fnd_api.g_exc_unexpected_error;
4196: END IF ;

Line 4194: x_return_msg := fnd_message.get;

4190: IF (p_query_mode = G_TXN_MODE) THEN
4191: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN
4192: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');
4193: fnd_msg_pub.ADD;
4194: x_return_msg := fnd_message.get;
4195: RAISE fnd_api.g_exc_unexpected_error;
4196: END IF ;
4197: ELSIF (p_query_mode = G_REG_MODE) THEN
4198: IF (p_owning_org_id IS NULL) THEN

Line 4199: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');

4195: RAISE fnd_api.g_exc_unexpected_error;
4196: END IF ;
4197: ELSIF (p_query_mode = G_REG_MODE) THEN
4198: IF (p_owning_org_id IS NULL) THEN
4199: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');
4200: fnd_msg_pub.ADD;
4201: x_return_msg := fnd_message.get;
4202: RAISE fnd_api.g_exc_unexpected_error;
4203: END IF ;

Line 4201: x_return_msg := fnd_message.get;

4197: ELSIF (p_query_mode = G_REG_MODE) THEN
4198: IF (p_owning_org_id IS NULL) THEN
4199: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');
4200: fnd_msg_pub.ADD;
4201: x_return_msg := fnd_message.get;
4202: RAISE fnd_api.g_exc_unexpected_error;
4203: END IF ;
4204: END IF;
4205: