eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IEX_STRATEGY_WF dependencies on FND_API

Line 298: p_init_msg_list => FND_API.G_TRUE,

294: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
295: iex_debug_pub.logmessage ('**** BEGIN update_workitem_Status ************');
296: END IF;
297: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
298: p_init_msg_list => FND_API.G_TRUE,
299: p_commit => FND_API.G_FALSE,
300: x_msg_count => l_msg_count,
301: x_msg_data => l_msg_data,
302: x_return_status => l_return_status,

Line 299: p_commit => FND_API.G_FALSE,

295: iex_debug_pub.logmessage ('**** BEGIN update_workitem_Status ************');
296: END IF;
297: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
298: p_init_msg_list => FND_API.G_TRUE,
299: p_commit => FND_API.G_FALSE,
300: x_msg_count => l_msg_count,
301: x_msg_data => l_msg_data,
302: x_return_status => l_return_status,
303: p_work_item_id => p_work_item_id,

Line 668: l_init_msg_list := FND_API.G_TRUE;

664:
665: BEGIN
666: -- initialize variable
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;

Line 669: l_commit := FND_API.G_FALSE;

665: BEGIN
666: -- initialize variable
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;

Line 670: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

666: -- initialize variable
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:

Line 686: p_init_msg_list => FND_API.G_TRUE,

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,
690: x_msg_data => l_msg_data,

Line 687: p_commit => FND_API.G_FALSE,

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,
690: x_msg_data => l_msg_data,
691: x_return_status => l_return_status,

Line 696: p_init_msg_list => FND_API.G_TRUE,

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',
700: p_level_id => p_party_id,

Line 697: p_commit => FND_API.G_FALSE,

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',
700: p_level_id => p_party_id,
701: x_msg_count => l_msg_count,

Line 1037: l_return_status :=FND_API.G_RET_STS_SUCCESS;

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
1041: iex_debug_pub.logmessage ('populate_schedule_times: ' || '**** BEGIN create_work_item ************');

Line 1207: x_return_Status :=FND_API.G_RET_STS_ERROR;

1203:
1204:
1205: if l_resource_id is null then
1206:
1207: x_return_Status :=FND_API.G_RET_STS_ERROR;
1208: x_error_msg := 'resource_id is Null';
1209: -- IF PG_DEBUG < 10 THEN
1210: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1211: iex_debug_pub.logmessage ('populate_schedule_times: ' || 'resource id is null ');

Line 1316: P_Init_Msg_List =>FND_API.G_TRUE,

1312: END IF;
1313:
1314: iex_strategy_work_items_pvt.create_strategy_work_items
1315: (P_Api_Version_Number =>2.0,
1316: P_Init_Msg_List =>FND_API.G_TRUE,
1317: P_Commit =>FND_API.G_FALSE,
1318: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,
1319: p_strategy_work_item_rec =>l_strategy_work_item_rec,
1320: x_work_item_id =>x_work_item_id,

Line 1317: P_Commit =>FND_API.G_FALSE,

1313:
1314: iex_strategy_work_items_pvt.create_strategy_work_items
1315: (P_Api_Version_Number =>2.0,
1316: P_Init_Msg_List =>FND_API.G_TRUE,
1317: P_Commit =>FND_API.G_FALSE,
1318: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,
1319: p_strategy_work_item_rec =>l_strategy_work_item_rec,
1320: x_work_item_id =>x_work_item_id,
1321: x_return_status =>l_return_status,

Line 1318: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,

1314: iex_strategy_work_items_pvt.create_strategy_work_items
1315: (P_Api_Version_Number =>2.0,
1316: P_Init_Msg_List =>FND_API.G_TRUE,
1317: P_Commit =>FND_API.G_FALSE,
1318: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,
1319: p_strategy_work_item_rec =>l_strategy_work_item_rec,
1320: x_work_item_id =>x_work_item_id,
1321: x_return_status =>l_return_status,
1322: x_msg_count =>l_msg_count,

Line 1329: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1325: iex_debug_pub.logmessage ('after calling create_work_pvt.create');
1326: iex_debug_pub.logmessage ('and l_return_status from the pvt ='||l_return_status);
1327: END IF;
1328: x_return_status :=l_return_Status;
1329: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1330: --update nextwork item i nthe strategy table
1331: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1332: (p_api_version => l_api_version,
1333: p_init_msg_list => FND_API.G_TRUE,

Line 1333: p_init_msg_list => FND_API.G_TRUE,

1329: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1330: --update nextwork item i nthe strategy table
1331: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1332: (p_api_version => l_api_version,
1333: p_init_msg_list => FND_API.G_TRUE,
1334: p_commit => FND_API.G_FALSE,
1335: x_msg_count => l_msg_count,
1336: x_msg_data => l_msg_data,
1337: x_return_status => l_return_status,

Line 1334: p_commit => FND_API.G_FALSE,

1330: --update nextwork item i nthe strategy table
1331: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1332: (p_api_version => l_api_version,
1333: p_init_msg_list => FND_API.G_TRUE,
1334: p_commit => FND_API.G_FALSE,
1335: x_msg_count => l_msg_count,
1336: x_msg_data => l_msg_data,
1337: x_return_status => l_return_status,
1338: p_strategy_id => p_strategy_id,

Line 1378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1374:
1375: -- if next work_item updation fails then also get the error message
1376: -- get error message and passit pass it
1377: --add new message
1378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1379: fnd_message.set_name('IEX', 'IEX_UPD_NEXT_WORK_ITEM_FAILED');
1380: fnd_msg_pub.add;
1381: FND_MSG_PUB.Count_And_Get
1382: ( p_count => l_msg_count,

Line 1625: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

1621: iex_debug_pub.logmessage ('**** BEGIN Get_Messages ************');
1622: END IF;
1623: FOR l_count in 1..p_message_count LOOP
1624:
1625: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
1626: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
1627: OPEN Get_Appl_Id (l_appl_short_name);
1628: FETCH Get_Appl_Id into l_id;
1629: CLOSE Get_Appl_Id;

Line 1640: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

1636: FETCH Get_Message_Num into l_message_num;
1637: CLOSE Get_Message_Num;
1638: END IF;
1639:
1640: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
1641:
1642: IF NVL(l_message_num, 0) <> 0
1643: THEN
1644: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

Line 1652: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

1648:
1649: IF l_count = 1
1650: THEN
1651: l_msg_list := l_msg_list || l_temp_msg ||
1652: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
1653: ELSE
1654: l_msg_list := l_msg_list || l_temp_msg ||
1655: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
1656: END IF;

Line 1655: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

1651: l_msg_list := l_msg_list || l_temp_msg ||
1652: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
1653: ELSE
1654: l_msg_list := l_msg_list || l_temp_msg ||
1655: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
1656: END IF;
1657:
1658: l_msg_list := l_msg_list || '';
1659:

Line 2016: p_init_msg_list => FND_API.G_TRUE,

2012: l_strategy_status := 'CLOSED';
2013: END IF;
2014:
2015: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
2016: p_init_msg_list => FND_API.G_TRUE,
2017: p_commit => FND_API.G_FALSE,
2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data,
2020: x_return_status => l_return_status,

Line 2017: p_commit => FND_API.G_FALSE,

2013: END IF;
2014:
2015: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
2016: p_init_msg_list => FND_API.G_TRUE,
2017: p_commit => FND_API.G_FALSE,
2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data,
2020: x_return_status => l_return_status,
2021: p_strategy_id => l_strategy_id,

Line 2032: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

2028: END IF;
2029:
2030: -- if the result is 'N' then go back to
2031: -- sleep or wait mode
2032: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2033: result := wf_engine.eng_completed ||':'||wf_yes;
2034: else
2035: result := wf_engine.eng_completed ||':'||wf_no;
2036: --set the strategy_status back to 'OPEN'

Line 2113: l_init_msg_list := FND_API.G_TRUE;

2109: where strategy_id =p_strategy_id;
2110: l_value VARCHAR2(300);
2111: Begin
2112: -- initialize variable
2113: l_init_msg_list := FND_API.G_TRUE;
2114: l_commit := FND_API.G_TRUE;
2115:
2116: -- IF PG_DEBUG < 10 THEN
2117: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2114: l_commit := FND_API.G_TRUE;

2110: l_value VARCHAR2(300);
2111: Begin
2112: -- initialize variable
2113: l_init_msg_list := FND_API.G_TRUE;
2114: l_commit := FND_API.G_TRUE;
2115:
2116: -- IF PG_DEBUG < 10 THEN
2117: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2118: iex_debug_pub.logmessage ('**** BEGIN create_next_work_item ************');

Line 2176: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN

2172: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2173: iex_debug_pub.logmessage ('create_next_work_item: ' || ' creation of work items and status => '||l_return_status);
2174: END IF;
2175:
2176: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
2177: result := wf_engine.eng_completed ||':'||wf_no;
2178: --pass the error message
2179: wf_engine.SetItemAttrText(itemtype => itemtype,
2180: itemkey => itemkey,

Line 2632: l_return_status :=FND_API.G_RET_STS_SUCCESS;

2628: l_user_item_workflow VARCHAR2(240);
2629:
2630: BEGIN
2631: -- initialize variable
2632: l_return_status :=FND_API.G_RET_STS_SUCCESS;
2633:
2634: -- IF PG_DEBUG < 10 THEN
2635: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2636: iex_debug_pub.logmessage ('**** START CUSTOM_CHECK ************');

Line 2717: p_init_msg_list => FND_API.G_TRUE,

2713:
2714: IEX_STRY_cuwf_pub.Start_CustomWF
2715: (
2716: p_api_version =>1.0,
2717: p_init_msg_list => FND_API.G_TRUE,
2718: p_commit => FND_API.G_FALSE,
2719: p_custom_wf_rec =>l_custom_wf_rec,
2720: x_msg_count => l_msg_count,
2721: x_msg_data => l_msg_data,

Line 2718: p_commit => FND_API.G_FALSE,

2714: IEX_STRY_cuwf_pub.Start_CustomWF
2715: (
2716: p_api_version =>1.0,
2717: p_init_msg_list => FND_API.G_TRUE,
2718: p_commit => FND_API.G_FALSE,
2719: p_custom_wf_rec =>l_custom_wf_rec,
2720: x_msg_count => l_msg_count,
2721: x_msg_data => l_msg_data,
2722: x_return_status => l_return_status);

Line 2736: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2732:
2733: -- don't check for result, what ever is the outcome
2734: -- go and wait, the UI will relaunch the custom workflow
2735:
2736: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2737: result := wf_engine.eng_completed ||':'||wf_yes;
2738: else
2739: result := wf_engine.eng_completed ||':'||wf_no;
2740: end if;

Line 2789: l_return_status :=FND_API.G_RET_STS_SUCCESS;

2785: WHERE work_item_id = p_work_item_id;
2786:
2787: BEGIN
2788: -- initialize variable
2789: l_return_status :=FND_API.G_RET_STS_SUCCESS;
2790:
2791: -- IF PG_DEBUG < 10 THEN
2792: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2793: iex_debug_pub.logmessage ('**** START FULFIL_CHECK ************');

Line 2863: p_init_msg_list => FND_API.G_FALSE,

2859: iex_debug_pub.logmessage('FULFIL_CHECK: ' || 'fulful template id' ||l_fulfil_temp_id);
2860: END IF;
2861: iex_strategy_work_pub.strategy_mailer(
2862: p_api_version =>1.0,
2863: p_init_msg_list => FND_API.G_FALSE,
2864: p_commit => FND_API.G_TRUE,
2865: p_strategy_mailer_rec => l_strategy_mailer_rec,
2866: x_msg_count => l_msg_count,
2867: x_msg_data => l_msg_data,

Line 2864: p_commit => FND_API.G_TRUE,

2860: END IF;
2861: iex_strategy_work_pub.strategy_mailer(
2862: p_api_version =>1.0,
2863: p_init_msg_list => FND_API.G_FALSE,
2864: p_commit => FND_API.G_TRUE,
2865: p_strategy_mailer_rec => l_strategy_mailer_rec,
2866: x_msg_count => l_msg_count,
2867: x_msg_data => l_msg_data,
2868: x_return_status => l_return_status);

Line 2877: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2873:
2874: -- don't check for result, what ever is the outcome
2875: -- go and wait, the UI will relaunch the fulilment workflow
2876:
2877: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2878: result := wf_engine.eng_completed ||':'||wf_yes;
2879: else
2880: result := wf_engine.eng_completed ||':'||wf_no;
2881: end if;

Line 2935: l_return_status :=FND_API.G_RET_STS_SUCCESS;

2931: WHERE work_item_id = p_work_item_id;
2932:
2933: BEGIN
2934: -- initialize variable
2935: l_return_status :=FND_API.G_RET_STS_SUCCESS;
2936:
2937: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2938: iex_debug_pub.logmessage ('**** START cal_post_wait ************');
2939: END IF;

Line 3754: p_init_msg_list => FND_API.G_TRUE,

3750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3751: iex_debug_pub.logmessage('UPDATE_WORK_ITEM: ' || 'value of workitem id '||l_work_item_id);
3752: END IF;
3753: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
3754: p_init_msg_list => FND_API.G_TRUE,
3755: p_commit => FND_API.G_FALSE,
3756: x_msg_count => l_msg_count,
3757: x_msg_data => l_msg_data,
3758: x_return_status => l_return_status,

Line 3755: p_commit => FND_API.G_FALSE,

3751: iex_debug_pub.logmessage('UPDATE_WORK_ITEM: ' || 'value of workitem id '||l_work_item_id);
3752: END IF;
3753: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
3754: p_init_msg_list => FND_API.G_TRUE,
3755: p_commit => FND_API.G_FALSE,
3756: x_msg_count => l_msg_count,
3757: x_msg_data => l_msg_data,
3758: x_return_status => l_return_status,
3759: p_work_item_id => l_work_item_id,

Line 3761: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

3757: x_msg_data => l_msg_data,
3758: x_return_status => l_return_status,
3759: p_work_item_id => l_work_item_id,
3760: p_status => 'TIMEOUT');
3761: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
3762: result := wf_engine.eng_completed ||':'||wf_yes;
3763: else
3764: RAISE EXC;
3765: END IF;

Line 4044: p_init_msg_list => FND_API.G_TRUE,

4040:
4041: abort_processes(l_strategy_id);
4042:
4043: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
4044: p_init_msg_list => FND_API.G_TRUE,
4045: p_commit => FND_API.G_FALSE,
4046: x_msg_count => l_msg_count,
4047: x_msg_data => l_msg_data,
4048: x_return_status => l_return_status,

Line 4045: p_commit => FND_API.G_FALSE,

4041: abort_processes(l_strategy_id);
4042:
4043: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
4044: p_init_msg_list => FND_API.G_TRUE,
4045: p_commit => FND_API.G_FALSE,
4046: x_msg_count => l_msg_count,
4047: x_msg_data => l_msg_data,
4048: x_return_status => l_return_status,
4049: p_strategy_id => l_strategy_id,

Line 4205: l_init_msg_list := FND_API.G_TRUE;

4201: -- End for the bug#7656223
4202: BEGIN
4203: -- initialize variable
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:

Line 4206: l_commit := FND_API.G_FALSE;

4202: BEGIN
4203: -- initialize variable
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);

Line 4207: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

4203: -- initialize variable
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:

Line 4225: p_init_msg_list => FND_API.G_TRUE,

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,
4229: x_msg_data => l_msg_data,

Line 4226: p_commit => FND_API.G_FALSE,

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,
4229: x_msg_data => l_msg_data,
4230: x_return_status => l_return_status,

Line 4235: p_init_msg_list => FND_API.G_TRUE,

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',
4239: p_level_id => p_siteuse_id,

Line 4236: p_commit => FND_API.G_FALSE,

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',
4239: p_level_id => p_siteuse_id,
4240: x_msg_count => l_msg_count,

Line 4401: l_init_msg_list := FND_API.G_TRUE;

4397:
4398: BEGIN
4399: -- initialize variable
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:

Line 4402: l_commit := FND_API.G_FALSE;

4398: BEGIN
4399: -- initialize variable
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);

Line 4403: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

4399: -- initialize variable
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:

Line 4421: p_init_msg_list => FND_API.G_TRUE,

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',
4425: p_level_id => p_account_id,

Line 4422: p_commit => FND_API.G_FALSE,

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',
4425: p_level_id => p_account_id,
4426: x_msg_count => l_msg_count,

Line 4431: p_init_msg_list => FND_API.G_TRUE,

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,
4435: x_msg_data => l_msg_data,

Line 4432: p_commit => FND_API.G_FALSE,

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,
4435: x_msg_data => l_msg_data,
4436: x_return_status => l_return_status,

Line 4739: P_Init_Msg_List =>FND_API.G_TRUE,

4735: l_strategy_work_item_Rec.escalated_yn := 'Y';
4736: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
4737: P_Api_Version_Number =>l_api_version_number,
4738: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4739: P_Init_Msg_List =>FND_API.G_TRUE,
4740: p_commit =>FND_API.G_TRUE,
4741: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4742: x_msg_count => l_msg_count,
4743: x_msg_data => l_msg_data,

Line 4740: p_commit =>FND_API.G_TRUE,

4736: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
4737: P_Api_Version_Number =>l_api_version_number,
4738: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4739: P_Init_Msg_List =>FND_API.G_TRUE,
4740: p_commit =>FND_API.G_TRUE,
4741: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4742: x_msg_count => l_msg_count,
4743: x_msg_data => l_msg_data,
4744: x_return_status => l_return_status,

Line 4741: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4737: P_Api_Version_Number =>l_api_version_number,
4738: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4739: P_Init_Msg_List =>FND_API.G_TRUE,
4740: p_commit =>FND_API.G_TRUE,
4741: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4742: x_msg_count => l_msg_count,
4743: x_msg_data => l_msg_data,
4744: x_return_status => l_return_status,
4745: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );

Line 4749: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

4745: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
4746: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4747: iex_debug_pub.logmessage ('UPDATE_ESC_FLAG: Return status = ' || l_return_status);
4748: END IF;
4749: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
4750: begin
4751: iex_debug_pub.logmessage('UPDATE_ESC_FLAG: Refreshing UWQ Summary..');
4752: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
4753: exception