APPS.AHL_FMP_PVT dependencies on FND_PROFILE

Line 5: G_APPLN_USAGE VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');

1: PACKAGE BODY AHL_FMP_PVT AS
2: /* $Header: AHLVFMPB.pls 120.9.12010000.2 2008/12/27 01:04:51 sracha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AHL_FMP_PVT';
5: G_APPLN_USAGE VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
6: --Define Global Cursor: get item instance attributes from ahl_unit_installed_details_v.
7: --The last two attributes: manufacturer_id and counctry_code are not in the view definition.
8: CURSOR get_inst_attri(c_item_instance_id NUMBER) IS
9: SELECT serial_number, item_number, inventory_item_id,

Line 2971: l_appln_code VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');

2967: l_return_status VARCHAR2(1);
2968: l_item_instance_id NUMBER;
2969: l_inventory_item_id NUMBER;
2970: l_pm_install VARCHAR2(1);
2971: l_appln_code VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
2972: l_inp_rec OKS_PM_ENTITLEMENTS_PUB.get_pmcontin_rec;
2973: l_ent_contracts OKS_ENTITLEMENTS_PUB.get_contop_tbl;
2974: l_pm_activities OKS_PM_ENTITLEMENTS_PUB.get_activityop_tbl;
2975: l_prior_mr_header_id NUMBER;

Line 3026: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');

3022: THEN
3023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3024: END IF;
3025:
3026: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3027: IF l_appln_code <> 'PM' THEN
3028: FND_MESSAGE.set_name('AHL', 'AHL_FMP_PM_NOT_INSTALLED');
3029: FND_MSG_PUB.add;
3030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;