DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WF dependencies on IEX_UTILITIES

Line 644: l_resource_tab iex_utilities.resource_tab_type;

640: x_resource_id OUT NOCOPY NUMBER) IS
641:
642: l_api_version NUMBER ;
643: l_init_msg_list VARCHAR2(1) ;
644: l_resource_tab iex_utilities.resource_tab_type;
645:
646: l_commit VARCHAR2(1) ;
647: l_return_status VARCHAR2(1);
648: l_msg_count NUMBER;

Line 685: /*iex_utilities.get_assign_resources(p_api_version => l_api_version,

681: -- get resource id table of reords for the given party id
682: -- the record has resource id and person id along with the user name
683: --Begin bug#5373412 schekuri 10-Jul-2006
684: --Call new consolidated procedure get_assigned_collector
685: /*iex_utilities.get_assign_resources(p_api_version => l_api_version,
686: p_init_msg_list => FND_API.G_TRUE,
687: p_commit => FND_API.G_FALSE,
688: p_validation_level => l_validation_level,
689: x_msg_count => l_msg_count,

Line 695: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

691: x_return_status => l_return_status,
692: p_party_id => p_party_id,
693: x_resource_tab => l_resource_tab);*/
694:
695: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
696: p_init_msg_list => FND_API.G_TRUE,
697: p_commit => FND_API.G_FALSE,
698: p_validation_level => l_validation_level,
699: p_level => 'PARTY',

Line 711: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_access_resources = '||l_return_status);

707:
708: --IF PG_DEBUG < 10 THEN
709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
710: iex_debug_pub.logmessage('populate_schedule_times: ' || 'in get resource and l_return_status = '||l_return_status);
711: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_access_resources = '||l_return_status);
712: iex_debug_pub.logmessage('resource count from iex_utilities.get_access_resources = '||l_resource_tab.count);
713: END IF;
714:
715: -- if COMPETENCE id exists for the given work template Id,

Line 712: iex_debug_pub.logmessage('resource count from iex_utilities.get_access_resources = '||l_resource_tab.count);

708: --IF PG_DEBUG < 10 THEN
709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
710: iex_debug_pub.logmessage('populate_schedule_times: ' || 'in get resource and l_return_status = '||l_return_status);
711: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_access_resources = '||l_return_status);
712: iex_debug_pub.logmessage('resource count from iex_utilities.get_access_resources = '||l_resource_tab.count);
713: END IF;
714:
715: -- if COMPETENCE id exists for the given work template Id,
716: -- see if the person id from the

Line 1050: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

1046: Begin
1047: SELECT count(*) into l_str_level_count
1048: FROM IEX_LOOKUPS_V
1049: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
1050: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1051: Exception
1052: when others then
1053: iex_debug_pub.logmessage (' Exception in str_level_count ');
1054: End;

Line 4181: l_resource_tab iex_utilities.resource_tab_type;

4177: l_vTest varchar2(20) ;
4178:
4179: l_api_version NUMBER := 1.0;
4180: l_init_msg_list VARCHAR2(1) ;
4181: l_resource_tab iex_utilities.resource_tab_type;
4182:
4183: l_commit VARCHAR2(1) ;
4184: l_return_status VARCHAR2(1);
4185: l_msg_count NUMBER;

Line 4224: /*iex_utilities.get_billto_resources(p_api_version => l_api_version,

4220: -- get resource id table of reords for the given site use id
4221: -- the record has resource id and person id along with the user name
4222: --Begin bug#5373412 schekuri 10-Jul-2006
4223: --Call new consolidated procedure get_assigned_collector
4224: /*iex_utilities.get_billto_resources(p_api_version => l_api_version,
4225: p_init_msg_list => FND_API.G_TRUE,
4226: p_commit => FND_API.G_FALSE,
4227: p_validation_level => l_validation_level,
4228: x_msg_count => l_msg_count,

Line 4234: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

4230: x_return_status => l_return_status,
4231: p_site_use_id => p_siteuse_id,
4232: x_resource_tab => l_resource_tab);*/
4233:
4234: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
4235: p_init_msg_list => FND_API.G_TRUE,
4236: p_commit => FND_API.G_FALSE,
4237: p_validation_level => l_validation_level,
4238: p_level => 'BILLTO',

Line 4249: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_billto_resources = '||l_return_status);

4245: --End bug#5373412 schekuri 10-Jul-2006
4246: --IF PG_DEBUG < 10 THEN
4247: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4248: iex_debug_pub.logmessage('get_billto_resource: ' || 'in get resource and l_return_status = '||l_return_status);
4249: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_billto_resources = '||l_return_status);
4250: iex_debug_pub.logmessage('resource count from iex_utilities.get_billto_resources = '||l_resource_tab.count);
4251: END IF;
4252:
4253: if l_resource_tab.count > 0 then

Line 4250: iex_debug_pub.logmessage('resource count from iex_utilities.get_billto_resources = '||l_resource_tab.count);

4246: --IF PG_DEBUG < 10 THEN
4247: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4248: iex_debug_pub.logmessage('get_billto_resource: ' || 'in get resource and l_return_status = '||l_return_status);
4249: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_billto_resources = '||l_return_status);
4250: iex_debug_pub.logmessage('resource count from iex_utilities.get_billto_resources = '||l_resource_tab.count);
4251: END IF;
4252:
4253: if l_resource_tab.count > 0 then
4254: l_bReturn := true;

Line 4376: l_resource_tab iex_utilities.resource_tab_type;

4372: l_vTest varchar2(20) ;
4373:
4374: l_api_version NUMBER := 1.0;
4375: l_init_msg_list VARCHAR2(1) ;
4376: l_resource_tab iex_utilities.resource_tab_type;
4377:
4378: l_commit VARCHAR2(1) ;
4379: l_return_status VARCHAR2(1);
4380: l_msg_count NUMBER;

Line 4420: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

4416: -- get resource id table of reords for the given site use id
4417: -- the record has resource id and person id along with the user name
4418: --Begin bug#5373412 schekuri 10-Jul-2006
4419: --Call new consolidated procedure get_assigned_collector
4420: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
4421: p_init_msg_list => FND_API.G_TRUE,
4422: p_commit => FND_API.G_FALSE,
4423: p_validation_level => l_validation_level,
4424: p_level => 'ACCOUNT',

Line 4430: /*iex_utilities.get_assign_account_resources(p_api_version => l_api_version,

4426: x_msg_count => l_msg_count,
4427: x_msg_data => l_msg_data,
4428: x_return_status => l_return_status,
4429: x_resource_tab => l_resource_tab);
4430: /*iex_utilities.get_assign_account_resources(p_api_version => l_api_version,
4431: p_init_msg_list => FND_API.G_TRUE,
4432: p_commit => FND_API.G_FALSE,
4433: p_validation_level => l_validation_level,
4434: x_msg_count => l_msg_count,

Line 4442: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_assign_account_resources = '||l_return_status);

4438: x_resource_tab => l_resource_tab);*/
4439: --End bug#5373412 schekuri 10-Jul-2006
4440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4441: iex_debug_pub.logmessage('get_billto_resource: ' || 'in get resource and l_return_status = '||l_return_status);
4442: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_assign_account_resources = '||l_return_status);
4443: iex_debug_pub.logmessage('resource count from iex_utilities.get_assign_account_resources = '||l_resource_tab.count);
4444: END IF;
4445:
4446: if l_resource_tab.count > 0 then

Line 4443: iex_debug_pub.logmessage('resource count from iex_utilities.get_assign_account_resources = '||l_resource_tab.count);

4439: --End bug#5373412 schekuri 10-Jul-2006
4440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4441: iex_debug_pub.logmessage('get_billto_resource: ' || 'in get resource and l_return_status = '||l_return_status);
4442: iex_debug_pub.logmessage('in get resource and l_return_status from iex_utilities.get_assign_account_resources = '||l_return_status);
4443: iex_debug_pub.logmessage('resource count from iex_utilities.get_assign_account_resources = '||l_resource_tab.count);
4444: END IF;
4445:
4446: if l_resource_tab.count > 0 then
4447: l_bReturn := true;