DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on FND_MSG_PUB

Line 627: if (fnd_msg_pub.check_msg_level

623:
624: when others then
625: x_return_status := fnd_api.g_ret_sts_unexp_error ;
626:
627: if (fnd_msg_pub.check_msg_level
628: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
629: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
630: end if;
631: -- always return 'Y' when any error occurred

Line 628: (fnd_msg_pub.g_msg_lvl_unexp_error)) then

624: when others then
625: x_return_status := fnd_api.g_ret_sts_unexp_error ;
626:
627: if (fnd_msg_pub.check_msg_level
628: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
629: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
630: end if;
631: -- always return 'Y' when any error occurred
632: --Begin bug 4536902

Line 629: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

625: x_return_status := fnd_api.g_ret_sts_unexp_error ;
626:
627: if (fnd_msg_pub.check_msg_level
628: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
629: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
630: end if;
631: -- always return 'Y' when any error occurred
632: --Begin bug 4536902
633: g_status_id := p_status_id;

Line 719: if (fnd_msg_pub.check_msg_level

715: exception
716: when others then
717: x_return_status := fnd_api.g_ret_sts_unexp_error ;
718:
719: if (fnd_msg_pub.check_msg_level
720: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
721: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
722: end if;
723:

Line 720: (fnd_msg_pub.g_msg_lvl_unexp_error)) then

716: when others then
717: x_return_status := fnd_api.g_ret_sts_unexp_error ;
718:
719: if (fnd_msg_pub.check_msg_level
720: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
721: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
722: end if;
723:
724: -- Get message count and data

Line 721: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

717: x_return_status := fnd_api.g_ret_sts_unexp_error ;
718:
719: if (fnd_msg_pub.check_msg_level
720: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
721: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
722: end if;
723:
724: -- Get message count and data
725: FND_MSG_PUB.Count_And_Get

Line 725: FND_MSG_PUB.Count_And_Get

721: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
722: end if;
723:
724: -- Get message count and data
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count
727: , p_data => x_msg_data
728: );
729:

Line 1133: FND_MSG_PUB.ADD;

1129: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1130: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1131: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1132: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1133: FND_MSG_PUB.ADD;
1134:
1135: return 'N';
1136:
1137: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_sub_status_id = -1) then

Line 1211: FND_MSG_PUB.ADD;

1207: l_return_status = 'N') then
1208: if( l_return_status = 'N' ) then
1209: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1210: FND_MESSAGE.SET_TOKEN('TOKEN', 'Subinventory');
1211: FND_MSG_PUB.ADD;
1212: end if;
1213: return(l_return_status);
1214: end if;
1215: end if;

Line 1354: FND_MSG_PUB.ADD;

1350: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1351: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1354: FND_MSG_PUB.ADD;
1355: return 'N';
1356: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then
1357: return 'Y';
1358: end if;

Line 1429: FND_MSG_PUB.ADD;

1425: l_return_status = 'N') then
1426: if( l_return_status = 'N' ) then
1427: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1428: FND_MESSAGE.SET_TOKEN('TOKEN', 'Locator');
1429: FND_MSG_PUB.ADD;
1430: end if;
1431: return(l_return_status);
1432: end if;
1433: end if;

Line 1568: FND_MSG_PUB.ADD;

1564: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1565: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1568: FND_MSG_PUB.ADD;
1569: return 'N';
1570: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then
1571: return 'Y';
1572: end if;

Line 1600: FND_MSG_PUB.ADD;

1596: l_return_status = 'N') then
1597: if( l_return_status = 'N') then
1598: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1599: FND_MESSAGE.SET_TOKEN('TOKEN', 'Lot Number');
1600: FND_MSG_PUB.ADD;
1601: end if;
1602: return(l_return_status);
1603: end if;
1604: end if;

Line 1626: FND_MSG_PUB.ADD;

1622: l_return_status = 'N') then
1623: if( l_return_status = 'N' ) then
1624: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_NOT_APP');
1625: FND_MESSAGE.SET_TOKEN('TOKEN', 'Serial Number');
1626: FND_MSG_PUB.ADD;
1627: end if;
1628: return(l_return_status);
1629: end if;
1630: end if;

Line 1676: fnd_msg_pub.initialize;

1672: END IF;
1673: --
1674: -- Initialize message list.
1675: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1676: fnd_msg_pub.initialize;
1677: END IF;
1678:
1679: l_status_rec.organization_id := p_organization_id;
1680: l_status_rec.inventory_item_id := p_inventory_item_id;

Line 1879: FND_MSG_PUB.ADD;

1875: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1876: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
1877: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1878: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1879: FND_MSG_PUB.ADD;
1880: else
1881: return null;
1882: end if;
1883: end if;

Line 2655: fnd_msg_pub.ADD;

2651:
2652: IF l_return_status <> 'S' THEN
2653: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
2654: FND_MESSAGE.set_token('token1','XACT_QTY1');
2655: fnd_msg_pub.ADD;
2656: RAISE fnd_api.g_exc_error;
2657: END IF;
2658:
2659: IF nvl(l_qoh,0) = 0 THEN

Line 2678: fnd_msg_pub.ADD;

2674: inv_trx_util_pub.TRACE('Comingling Occurs', 'INV_MATERIAL_STATUS_GRP', 9);
2675: end if ;
2676:
2677: fnd_message.set_name('INV','INV_TXF_MOVE_DIFF_MAT_STAT');
2678: fnd_msg_pub.ADD;
2679: RAISE fnd_api.g_exc_error;
2680: END IF ;
2681: END IF ;--Second if
2682:

Line 2687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2683: END IF ; --First if
2684: EXCEPTION
2685: WHEN fnd_api.g_exc_error THEN
2686: x_return_status := fnd_api.g_ret_sts_error;
2687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2688: WHEN OTHERS THEN
2689: x_return_status := fnd_api.g_ret_sts_unexp_error;
2690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2691: END check_move_diff_status;

Line 2690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2686: x_return_status := fnd_api.g_ret_sts_error;
2687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2688: WHEN OTHERS THEN
2689: x_return_status := fnd_api.g_ret_sts_unexp_error;
2690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2691: END check_move_diff_status;
2692:
2693: --adding following procedure for lpn status project to get the lpn status
2694: PROCEDURE get_lpn_status