APPS.IEX_CASE_UTL_PUB dependencies on FND_PROFILE

Line 18: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

14: /**Name AddInvalidArgMsg
15: **Appends to a message the api name, parameter name and parameter Value
16: */
17:
18: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
19: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20:
21: PROCEDURE AddInvalidArgMsg
22: ( p_api_name IN VARCHAR2,

Line 927: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

923: l_case_definition_tbl CASE_DEFINITION_TBL_TYPE
924: DEFAULT G_MISS_CASE_DEF_TBL;
925:
926: l_resource_tab iex_utilities.resource_tab_type; -- added by ehuh Aug 1 2003
927: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
928:
929: Cursor get_case_objects_obj_ver_num (p_cas_id in number) is
930: select object_version_number,
931: case_object_id

Line 1340: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

1336: l_case_object_rec iex_case_objects_pvt.case_object_rec_type
1337: := iex_case_objects_pvt.g_miss_case_object_rec;
1338:
1339: l_resource_tab iex_utilities.resource_tab_type; -- added by ehuh Aug 1 2003
1340: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
1341:
1342: --Begin Bug#6962575 barathsr 29-Jul-2008
1343: --While creating cases in bulk skip finding the resource and assign default resource
1344: l_orig_system_source OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%type;

Line 1414: --l_org_id := fnd_profile.value('ORG_ID');

1410: IF (p_org_id IS NULL) OR
1411: (p_org_id = FND_API.G_MISS_NUM) THEN
1412: --Bug#4679639 schekuri 20-OCT-2005
1413: --Used mo_global.get_current_org_id to get ORG_ID
1414: --l_org_id := fnd_profile.value('ORG_ID');
1415: l_org_id := mo_global.get_current_org_id;
1416: END IF;
1417: -- IF PG_DEBUG < 10 THEN
1418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1957: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

1953: l_case_agent VARCHAR2(120);
1954: l_contract_number VARCHAR2(120);
1955:
1956: l_resource_tab iex_utilities.resource_tab_type; -- added by ehuh Aug 1 2003
1957: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
1958:
1959:
1960: cursor c_getname(p_old_case_id IN NUMBER) is
1961: Select user_name

Line 1966: fnd_profile.value('IEX_DEFAULT_CASE_AGENT'));

1962: from jtf_rs_resource_extns a,
1963: iex_Cases_all_b b
1964: where b.cas_id =p_old_case_id
1965: and a.resource_id = nvl(b.access_resource_id,
1966: fnd_profile.value('IEX_DEFAULT_CASE_AGENT'));
1967:
1968:
1969: cursor c_contract (p_contract_id IN NUMBER) is
1970: Select contract_number

Line 2040: --l_org_id := fnd_profile.value('ORG_ID');

2036: (p_org_id = FND_API.G_MISS_NUM) THEN
2037:
2038: --Bug#4679639 schekuri 20-OCT-2005
2039: --Used mo_global.get_current_org_id to get ORG_ID
2040: --l_org_id := fnd_profile.value('ORG_ID');
2041: l_org_id := mo_global.get_current_org_id;
2042: END IF;
2043: -- IF PG_DEBUG < 10 THEN
2044: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN