APPS.PV_PARTNER_PROGRAM_PVT dependencies on FND_PROFILE

Line 74: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');

70: l_msg_count NUMBER;
71: l_msg VARCHAR2(2000);
72: l_msg_data VARCHAR2(2000);
73: l_ptr_prgm_update_rec ptr_prgm_rec_type;
74: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
75: l_uom_code VARCHAR2(10) := fnd_profile.value('PV_DEFAULT_UOM_CODE');
76: l_flx_fld VARCHAR2(244);
77: l_temp_flx_fld VARCHAR2(244);
78: l_rplc_str VARCHAR2(40);

Line 75: l_uom_code VARCHAR2(10) := fnd_profile.value('PV_DEFAULT_UOM_CODE');

71: l_msg VARCHAR2(2000);
72: l_msg_data VARCHAR2(2000);
73: l_ptr_prgm_update_rec ptr_prgm_rec_type;
74: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
75: l_uom_code VARCHAR2(10) := fnd_profile.value('PV_DEFAULT_UOM_CODE');
76: l_flx_fld VARCHAR2(244);
77: l_temp_flx_fld VARCHAR2(244);
78: l_rplc_str VARCHAR2(40);
79:

Line 290: l_flx_fld := FND_PROFILE.Value_Specific('PV_PROGRAM_INV_FLEX_SEGMENTS',null,null,691);

286: END IF;
287:
288: -- /*** need to find the Item Number from profile value and than replce the val ***/
289:
290: l_flx_fld := FND_PROFILE.Value_Specific('PV_PROGRAM_INV_FLEX_SEGMENTS',null,null,691);
291: IF (l_flx_fld IS NULL)
292: THEN
293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
294: THEN

Line 1100: l_currency:=FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');

1096: FETCH c_resource_id into l_rules_rec.owner_resource_id;
1097: CLOSE c_resource_id;
1098:
1099: --get the currency of the logged in user
1100: l_currency:=FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
1101: IF l_currency IS NULL THEN
1102: FND_MESSAGE.set_name('PV', 'PV_PRGM_CURRENCY_UNDEFINED');
1103: FND_MSG_PUB.add;
1104: RAISE FND_API.G_EXC_ERROR;

Line 1529: IF (((FND_PROFILE.VALUE('PV_ENABLE_AUTO_CREATION_OF_INVENTORY_ITEM') is null) or (FND_PROFILE.VALUE('PV_ENABLE_AUTO_CREATION_OF_INVENTORY_ITEM') = 'Y')) and

1525: l_return_status := FND_API.G_RET_STS_SUCCESS;
1526:
1527: /* Modified for R12 */
1528: -- If the profile is not set or set to 'Y'
1529: IF (((FND_PROFILE.VALUE('PV_ENABLE_AUTO_CREATION_OF_INVENTORY_ITEM') is null) or (FND_PROFILE.VALUE('PV_ENABLE_AUTO_CREATION_OF_INVENTORY_ITEM') = 'Y')) and
1530: l_ptr_prgm_rec.no_fee_flag = 'N') THEN
1531: IF (PV_DEBUG_HIGH_ON) THEN
1532: PVX_UTILITY_PVT.debug_message('PV_AUTO_CREATION_OF_INVENTORY is not N');
1533: END IF;

Line 1989: l_default_appr:=FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR');

1985:
1986: END IF;
1987:
1988:
1989: l_default_appr:=FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR');
1990: IF ( l_tar_ptr_prgm_rec.program_status_code='ACTIVE' and
1991: l_tar_ptr_prgm_rec.program_level_code='MEMBERSHIP' and
1992: l_default_appr is NULL ) THEN
1993:

Line 5627: l_currency:=FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');

5623: FETCH c_resource_id into l_rules_rec.owner_resource_id;
5624: CLOSE c_resource_id;
5625:
5626: --get the currency of the logged in user
5627: l_currency:=FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
5628:
5629: IF l_currency IS NULL THEN
5630: FND_MESSAGE.set_name('PV', 'PV_PRGM_CURRENCY_UNDEFINED');
5631: FND_MSG_PUB.add;