DBA Data[Home] [Help]

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 412: l_grace_period := nvl(fnd_profile.value('IEX_STRY_GRACE_PERIOD'),0);

408: l_grace_period NUMBER ;
409:
410: BEGIN
411: -- initialize variable
412: l_grace_period := nvl(fnd_profile.value('IEX_STRY_GRACE_PERIOD'),0);
413:
414: -- IF PG_DEBUG < 10 THEN
415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
416: iex_debug_pub.logmessage ('**** BEGIN set_escalate_wait_time ************');

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

605: l_api_version := 1.0;
606: l_init_msg_list := FND_API.G_TRUE;
607: l_commit := FND_API.G_FALSE;
608: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
609: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
610: l_count :=0;
611: l_found := TRUE;
612:
613: -- IF PG_DEBUG < 10 THEN

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

915: bReturn Boolean;
916: l_wkitem_status varchar2(30); --bug#5874874 gnramasa
917: BEGIN
918: -- initialize variable
919: l_Default_Resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
920: l_Resource_ID := l_Default_Resource_ID;
921:
922: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
923: l_return_status :=FND_API.G_RET_STS_SUCCESS;

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

918: -- initialize variable
919: l_Default_Resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
920: l_Resource_ID := l_Default_Resource_ID;
921:
922: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
923: l_return_status :=FND_API.G_RET_STS_SUCCESS;
924:
925: -- IF PG_DEBUG < 10 THEN
926: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1467:
1468: IF l_id is not NULL
1469: THEN
1470: OPEN Get_Message_Num (l_message_name, l_id,
1471: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
1472: FETCH Get_Message_Num into l_message_num;
1473: CLOSE Get_Message_Num;
1474: END IF;
1475:

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

3896: l_vTest := 'Instance time';
3897: l_init_msg_list := FND_API.G_TRUE;
3898: l_commit := FND_API.G_FALSE;
3899: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
3900: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
3901:
3902: iex_debug_pub.logmessage ('get_billto_resource: Test variable is: ' || l_vTest);
3903:
3904: l_vTest := 'Runtime Changed';

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

4092: l_vTest := 'Instance time';
4093: l_init_msg_list := FND_API.G_TRUE;
4094: l_commit := FND_API.G_FALSE;
4095: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
4096: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
4097:
4098: iex_debug_pub.logmessage ('get_account_resource: Test variable is: ' || l_vTest);
4099:
4100: l_vTest := 'Runtime Changed';