APPS.CSD_REPAIRS_UTIL dependencies on FND_PROFILE

Line 1594: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');

1590: 'p_severity_id',
1591: lc_api_name);
1592:
1593: -- profile option for server_timezone_id must be set
1594: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1595: IF (NVL(l_server_timezone_id,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
1596: Fnd_Message.SET_NAME('CSD','CSD_CANNOT_GET_PROFILE_VALUE');
1597: Fnd_Message.SET_TOKEN('PROFILE',get_user_profile_option_name('SERVER_TIMEZONE_ID'));
1598: Fnd_Msg_Pub.ADD;

Line 1689: FROM fnd_profile_options_tl

1685:
1686: -- define cursors
1687: CURSOR c_user_prof_name(p_profile_name VARCHAR2) IS
1688: SELECT user_profile_option_name
1689: FROM fnd_profile_options_tl
1690: WHERE profile_option_name = p_profile_name
1691: AND language = userenv('lang');
1692:
1693: BEGIN

Line 1771: if nvl(fnd_profile.value('CSD_ENABLE_AUTO_UPD_RO_STAT'),'N') = 'N'

1767: if p_event = 'RECEIVE' then
1768: -- check if all the RMA -- CUST_PROD and RMA-EXCHANGE combination is received.
1769: -- only update the RO status if all RMA -- CUST_PROD combination is received
1770: --
1771: if nvl(fnd_profile.value('CSD_ENABLE_AUTO_UPD_RO_STAT'),'N') = 'N'
1772: then
1773: if lc_log_level >= lc_procedure_level then
1774: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Enable Auto Update of Repair
1775: Order Status upon Receiving is not set to yes.');

Line 1804: l_to_flow_status_id := fnd_profile.value('CSD_DEF_RO_STAT_FR_RCV');

1800: end;
1801:
1802: if l_un_rcvd_lines_exists is null then
1803:
1804: l_to_flow_status_id := fnd_profile.value('CSD_DEF_RO_STAT_FR_RCV');
1805: if l_to_flow_status_id is null then
1806: if lc_log_level >= lc_procedure_level then
1807: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Default Repair Order Status After
1808: Receving is not set');

Line 2035: l_inv_org := to_number(fnd_profile.value('CSD_DEF_REP_INV_ORG'));

2031: if (x_return_status = fnd_api.g_ret_sts_success) then
2032: if (l_default_val_num is not null) then
2033: l_inv_org := l_default_val_num;
2034: else
2035: l_inv_org := to_number(fnd_profile.value('CSD_DEF_REP_INV_ORG'));
2036: end if;
2037: else
2038: RAISE FND_API.G_EXC_ERROR;
2039: end if;

Line 2069: l_repair_org := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_ORG'));

2065: if (x_return_status = fnd_api.g_ret_sts_success) then
2066: if (l_default_val_num is not null) then
2067: l_repair_org := l_default_val_num;
2068: else
2069: l_repair_org := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_ORG'));
2070: end if;
2071: else
2072: RAISE FND_API.G_EXC_ERROR;
2073: end if;

Line 2160: l_repair_type_id := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_TYPE'));

2156: if (x_return_status = fnd_api.g_ret_sts_success) then
2157: if (l_default_val_num is not null) then
2158: l_repair_type_id := l_default_val_num;
2159: else
2160: l_repair_type_id := to_number(fnd_profile.value('CSD_DEFAULT_REPAIR_TYPE'));
2161: end if;
2162:
2163: if l_repair_type_id is not null then
2164: open c_def_wip (l_repair_type_id);