DBA Data[Home] [Help]

APPS.INV_CONSIGNED_VALIDATIONS dependencies on FND_MSG_PUB

Line 935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

931:
932: EXCEPTION
933: WHEN OTHERS THEN
934: x_return_status := fnd_api.g_ret_sts_unexp_error ;
935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
936: THEN
937: fnd_msg_pub.add_exc_msg
938: ( g_pkg_name
939: , 'Build_Cursor'

Line 937: fnd_msg_pub.add_exc_msg

933: WHEN OTHERS THEN
934: x_return_status := fnd_api.g_ret_sts_unexp_error ;
935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
936: THEN
937: fnd_msg_pub.add_exc_msg
938: ( g_pkg_name
939: , 'Build_Cursor'
940: );
941: END IF;

Line 1334: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1330: inv_log_util.trace('in check_is_reservable, OTHERS Error='||SQLERRM, 'CONSIGNED_VALIDATIONS',9);
1331: END IF;
1332: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1333:
1334: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1335: THEN
1336: fnd_msg_pub.add_exc_msg
1337: ( g_pkg_name
1338: , 'Check_Is_Reservable'

Line 1336: fnd_msg_pub.add_exc_msg

1332: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1333:
1334: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1335: THEN
1336: fnd_msg_pub.add_exc_msg
1337: ( g_pkg_name
1338: , 'Check_Is_Reservable'
1339: );
1340: END IF;

Line 1515: fnd_msg_pub.ADD;

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;
1519:

Line 1523: fnd_msg_pub.ADD;

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;
1527: END IF;

Line 1532: fnd_msg_pub.ADD;

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;
1536: END IF;

Line 1553: fnd_msg_pub.ADD;

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 ;
1557:

Line 1561: fnd_msg_pub.ADD;

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 ;
1565: ELSIF (p_query_mode = G_REG_MODE) THEN

Line 1568: fnd_msg_pub.ADD;

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 ;
1572: END IF;

Line 1829: fnd_msg_pub.ADD;

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;
1833: END IF ;

Line 1836: fnd_msg_pub.ADD;

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;
1840: END IF ;

Line 1849: fnd_msg_pub.ADD;

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;
1853: END IF ;

Line 3892: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

3888: IF (l_debug = 1) THEN
3889: inv_log_util.trace('When Others Ex. in build_lpn_cursor','CONSIGNED_VALIDATIONS',9);
3890: END IF;
3891:
3892: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3893: THEN
3894: fnd_msg_pub.add_exc_msg
3895: ( g_pkg_name
3896: , 'Build_Cursor'

Line 3894: fnd_msg_pub.add_exc_msg

3890: END IF;
3891:
3892: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3893: THEN
3894: fnd_msg_pub.add_exc_msg
3895: ( g_pkg_name
3896: , 'Build_Cursor'
3897: );
3898: END IF;

Line 4147: fnd_msg_pub.ADD;

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;
4151:

Line 4155: fnd_msg_pub.ADD;

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;
4159: END IF;

Line 4164: fnd_msg_pub.ADD;

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;
4168: END IF;

Line 4185: fnd_msg_pub.ADD;

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 ;
4189:

Line 4193: fnd_msg_pub.ADD;

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 ;
4197: ELSIF (p_query_mode = G_REG_MODE) THEN

Line 4200: fnd_msg_pub.ADD;

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 ;
4204: END IF;