APPS.IEX_STRATEGY_WF dependencies on FND_PROFILE

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

10: **/
11:
12: wf_yes varchar2(1) ;
13: wf_no varchar2(1) ;
14: -- PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15: PG_DEBUG NUMBER ;
16: procedure custom_abort_process(p_itemtype IN varchar2, p_itemkey IN varchar2) is
17: begin
18: wf_engine.abortprocess(itemtype => p_itemtype, itemkey => p_itemkey);

Line 446: l_grace_period := nvl(fnd_profile.value('IEX_STRY_GRACE_PERIOD'),0);

442: l_grace_period NUMBER ;
443:
444: BEGIN
445: -- initialize variable
446: l_grace_period := nvl(fnd_profile.value('IEX_STRY_GRACE_PERIOD'),0);
447:
448: -- IF PG_DEBUG < 10 THEN
449: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
450: iex_debug_pub.logmessage ('**** BEGIN set_escalate_wait_time ************');

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

667: l_api_version := 1.0;
668: l_init_msg_list := FND_API.G_TRUE;
669: l_commit := FND_API.G_FALSE;
670: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
671: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
672: l_count :=0;
673: l_found := TRUE;
674:
675: -- IF PG_DEBUG < 10 THEN

Line 1033: l_Default_Resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

1029: WHERE work_item_temp_id = p_work_item_temp_id;
1030:
1031: BEGIN
1032: -- initialize variable
1033: l_Default_Resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
1034: l_Resource_ID := l_Default_Resource_ID;
1035:
1036: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1037: l_return_status :=FND_API.G_RET_STS_SUCCESS;

Line 1036: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

1032: -- initialize variable
1033: l_Default_Resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
1034: l_Resource_ID := l_Default_Resource_ID;
1035:
1036: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1037: l_return_status :=FND_API.G_RET_STS_SUCCESS;
1038:
1039: -- IF PG_DEBUG < 10 THEN
1040: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1635: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

1631:
1632: IF l_id is not NULL
1633: THEN
1634: OPEN Get_Message_Num (l_message_name, l_id,
1635: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
1636: FETCH Get_Message_Num into l_message_num;
1637: CLOSE Get_Message_Num;
1638: END IF;
1639:

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

4204: l_vTest := 'Instance time';
4205: l_init_msg_list := FND_API.G_TRUE;
4206: l_commit := FND_API.G_FALSE;
4207: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
4208: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
4209:
4210: iex_debug_pub.logmessage ('get_billto_resource: Test variable is: ' || l_vTest);
4211:
4212: l_vTest := 'Runtime Changed';

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

4400: l_vTest := 'Instance time';
4401: l_init_msg_list := FND_API.G_TRUE;
4402: l_commit := FND_API.G_FALSE;
4403: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
4404: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
4405:
4406: iex_debug_pub.logmessage ('get_account_resource: Test variable is: ' || l_vTest);
4407:
4408: l_vTest := 'Runtime Changed';