DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on FND_MSG_PUB

Line 641: if (fnd_msg_pub.check_msg_level

637:
638: when others then
639: x_return_status := fnd_api.g_ret_sts_unexp_error ;
640:
641: if (fnd_msg_pub.check_msg_level
642: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
643: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
644: end if;
645: -- always return 'Y' when any error occurred

Line 642: (fnd_msg_pub.g_msg_lvl_unexp_error)) then

638: when others then
639: x_return_status := fnd_api.g_ret_sts_unexp_error ;
640:
641: if (fnd_msg_pub.check_msg_level
642: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
643: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
644: end if;
645: -- always return 'Y' when any error occurred
646: --Begin bug 4536902

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

639: x_return_status := fnd_api.g_ret_sts_unexp_error ;
640:
641: if (fnd_msg_pub.check_msg_level
642: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
643: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
644: end if;
645: -- always return 'Y' when any error occurred
646: --Begin bug 4536902
647: g_status_id := p_status_id;

Line 733: if (fnd_msg_pub.check_msg_level

729: exception
730: when others then
731: x_return_status := fnd_api.g_ret_sts_unexp_error ;
732:
733: if (fnd_msg_pub.check_msg_level
734: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
735: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
736: end if;
737:

Line 734: (fnd_msg_pub.g_msg_lvl_unexp_error)) then

730: when others then
731: x_return_status := fnd_api.g_ret_sts_unexp_error ;
732:
733: if (fnd_msg_pub.check_msg_level
734: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
735: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
736: end if;
737:
738: -- Get message count and data

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

731: x_return_status := fnd_api.g_ret_sts_unexp_error ;
732:
733: if (fnd_msg_pub.check_msg_level
734: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
735: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
736: end if;
737:
738: -- Get message count and data
739: FND_MSG_PUB.Count_And_Get

Line 739: FND_MSG_PUB.Count_And_Get

735: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
736: end if;
737:
738: -- Get message count and data
739: FND_MSG_PUB.Count_And_Get
740: ( p_count => x_msg_count
741: , p_data => x_msg_data
742: );
743:

Line 1200: FND_MSG_PUB.ADD;

1196: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1197: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1198: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1199: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1200: FND_MSG_PUB.ADD;
1201:
1202: return 'N';
1203:
1204: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_sub_status_id = -1) then

Line 1325: FND_MSG_PUB.ADD;

1321: TRANSLATE => TRUE);
1322: FND_MESSAGE.SET_TOKEN('OBJECT','');
1323: END IF;
1324: /* End Changes done while fixing bug 6974630 */
1325: FND_MSG_PUB.ADD;
1326: l_return_status := 'N';
1327: end if;
1328: return(l_return_status);
1329: end if;

Line 1530: FND_MSG_PUB.ADD;

1526: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1527: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1528: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1529: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1530: FND_MSG_PUB.ADD;
1531: return 'N';
1532: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then
1533: return 'Y';
1534: end if;

Line 1649: FND_MSG_PUB.ADD;

1645: TRANSLATE => TRUE);
1646: END IF;
1647: /* End Changes done while fixing bug 6974630 */
1648: FND_MESSAGE.SET_TOKEN('OBJECT','');
1649: FND_MSG_PUB.ADD;
1650: l_return_status := 'N';
1651: end if;
1652: return(l_return_status);
1653: end if;

Line 1841: FND_MSG_PUB.ADD;

1837: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
1838: FND_MESSAGE.SET_TOKEN('LOC_ID', p_locator_id );
1839: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1840: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1841: FND_MSG_PUB.ADD;
1842: return 'N';
1843: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then
1844: return 'Y';
1845: end if;

Line 1919: FND_MSG_PUB.ADD;

1915: TRANSLATE => TRUE);
1916: FND_MESSAGE.SET_TOKEN('OBJECT','');
1917: END IF;
1918: /* END Changes done while fixing bug 6974630 */
1919: FND_MSG_PUB.ADD;
1920: l_return_status := 'N';
1921: end if;
1922: return(l_return_status);
1923: end if;

Line 2012: FND_MSG_PUB.ADD;

2008: VALUE => 'SER',
2009: TRANSLATE => TRUE);
2010: /* End Changes done while fixing bug 6974630 */
2011: FND_MESSAGE.SET_TOKEN('OBJECT',p_serial_number);
2012: FND_MSG_PUB.ADD;
2013: l_return_status := 'N';
2014: end if;
2015: return(l_return_status);
2016: end if;

Line 2064: fnd_msg_pub.initialize;

2060: END IF;
2061: --
2062: -- Initialize message list.
2063: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2064: fnd_msg_pub.initialize;
2065: END IF;
2066:
2067: l_status_rec.organization_id := p_organization_id;
2068: l_status_rec.inventory_item_id := p_inventory_item_id;

Line 2275: FND_MSG_PUB.ADD;

2271: FND_MESSAGE.SET_TOKEN('SUB', p_sub_code);
2272: FND_MESSAGE.SET_TOKEN('LOC_ID', p_loc_id );
2273: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
2274: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
2275: FND_MSG_PUB.ADD;
2276: else
2277: return null;
2278: end if;
2279: end if;

Line 3176: fnd_msg_pub.ADD;

3172:
3173: IF l_return_status <> 'S' THEN
3174: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3175: FND_MESSAGE.set_token('token1','XACT_QTY1');
3176: fnd_msg_pub.ADD;
3177: RAISE fnd_api.g_exc_error;
3178: END IF;
3179:
3180: IF (g_debug = 1) then

Line 3209: fnd_msg_pub.ADD;

3205: inv_trx_util_pub.TRACE('Comingling Occurs', 'INV_MATERIAL_STATUS_GRP', 9);
3206: end if ;
3207:
3208: fnd_message.set_name('INV','INV_TXF_MOVE_DIFF_MAT_STAT');
3209: fnd_msg_pub.ADD;
3210: RAISE fnd_api.g_exc_error;
3211: END IF ;
3212: END IF ;--Second if
3213:

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

3214: END IF ; --First if
3215: EXCEPTION
3216: WHEN fnd_api.g_exc_error THEN
3217: x_return_status := fnd_api.g_ret_sts_error;
3218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3219: WHEN OTHERS THEN
3220: x_return_status := fnd_api.g_ret_sts_unexp_error;
3221: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3222: END check_move_diff_status;

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

3217: x_return_status := fnd_api.g_ret_sts_error;
3218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3219: WHEN OTHERS THEN
3220: x_return_status := fnd_api.g_ret_sts_unexp_error;
3221: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3222: END check_move_diff_status;
3223:
3224: --adding following procedure for lpn status project to get the lpn status
3225: PROCEDURE get_lpn_status