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.

APPS.IEX_STRATEGY_WF dependencies on FND_API

Line 264: p_init_msg_list => FND_API.G_TRUE,

260: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
261: iex_debug_pub.logmessage ('**** BEGIN update_workitem_Status ************');
262: END IF;
263: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
264: p_init_msg_list => FND_API.G_TRUE,
265: p_commit => FND_API.G_FALSE,
266: x_msg_count => l_msg_count,
267: x_msg_data => l_msg_data,
268: x_return_status => l_return_status,

Line 265: p_commit => FND_API.G_FALSE,

261: iex_debug_pub.logmessage ('**** BEGIN update_workitem_Status ************');
262: END IF;
263: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
264: p_init_msg_list => FND_API.G_TRUE,
265: p_commit => FND_API.G_FALSE,
266: x_msg_count => l_msg_count,
267: x_msg_data => l_msg_data,
268: x_return_status => l_return_status,
269: p_work_item_id => p_work_item_id,

Line 606: l_init_msg_list := FND_API.G_TRUE;

602:
603: BEGIN
604: -- initialize variable
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;

Line 607: l_commit := FND_API.G_FALSE;

603: BEGIN
604: -- initialize variable
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;

Line 608: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

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

Line 624: p_init_msg_list => FND_API.G_TRUE,

620: -- the record has resource id and person id along with the user name
621: --Begin bug#5373412 schekuri 10-Jul-2006
622: --Call new consolidated procedure get_assigned_collector
623: /*iex_utilities.get_assign_resources(p_api_version => l_api_version,
624: p_init_msg_list => FND_API.G_TRUE,
625: p_commit => FND_API.G_FALSE,
626: p_validation_level => l_validation_level,
627: x_msg_count => l_msg_count,
628: x_msg_data => l_msg_data,

Line 625: p_commit => FND_API.G_FALSE,

621: --Begin bug#5373412 schekuri 10-Jul-2006
622: --Call new consolidated procedure get_assigned_collector
623: /*iex_utilities.get_assign_resources(p_api_version => l_api_version,
624: p_init_msg_list => FND_API.G_TRUE,
625: p_commit => FND_API.G_FALSE,
626: p_validation_level => l_validation_level,
627: x_msg_count => l_msg_count,
628: x_msg_data => l_msg_data,
629: x_return_status => l_return_status,

Line 634: p_init_msg_list => FND_API.G_TRUE,

630: p_party_id => p_party_id,
631: x_resource_tab => l_resource_tab);*/
632:
633: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
634: p_init_msg_list => FND_API.G_TRUE,
635: p_commit => FND_API.G_FALSE,
636: p_validation_level => l_validation_level,
637: p_level => 'PARTY',
638: p_level_id => p_party_id,

Line 635: p_commit => FND_API.G_FALSE,

631: x_resource_tab => l_resource_tab);*/
632:
633: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
634: p_init_msg_list => FND_API.G_TRUE,
635: p_commit => FND_API.G_FALSE,
636: p_validation_level => l_validation_level,
637: p_level => 'PARTY',
638: p_level_id => p_party_id,
639: x_msg_count => l_msg_count,

Line 923: l_return_status :=FND_API.G_RET_STS_SUCCESS;

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

Line 1064: x_return_Status :=FND_API.G_RET_STS_ERROR;

1060:
1061:
1062: if l_resource_id is null then
1063:
1064: x_return_Status :=FND_API.G_RET_STS_ERROR;
1065: x_error_msg := 'resource_id is Null';
1066: -- IF PG_DEBUG < 10 THEN
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: iex_debug_pub.logmessage ('populate_schedule_times: ' || 'resource id is null ');

Line 1152: P_Init_Msg_List =>FND_API.G_TRUE,

1148: END IF;
1149:
1150: iex_strategy_work_items_pvt.create_strategy_work_items
1151: (P_Api_Version_Number =>2.0,
1152: P_Init_Msg_List =>FND_API.G_TRUE,
1153: P_Commit =>FND_API.G_FALSE,
1154: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,
1155: p_strategy_work_item_rec =>l_strategy_work_item_rec,
1156: x_work_item_id =>x_work_item_id,

Line 1153: P_Commit =>FND_API.G_FALSE,

1149:
1150: iex_strategy_work_items_pvt.create_strategy_work_items
1151: (P_Api_Version_Number =>2.0,
1152: P_Init_Msg_List =>FND_API.G_TRUE,
1153: P_Commit =>FND_API.G_FALSE,
1154: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,
1155: p_strategy_work_item_rec =>l_strategy_work_item_rec,
1156: x_work_item_id =>x_work_item_id,
1157: x_return_status =>l_return_status,

Line 1154: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,

1150: iex_strategy_work_items_pvt.create_strategy_work_items
1151: (P_Api_Version_Number =>2.0,
1152: P_Init_Msg_List =>FND_API.G_TRUE,
1153: P_Commit =>FND_API.G_FALSE,
1154: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,
1155: p_strategy_work_item_rec =>l_strategy_work_item_rec,
1156: x_work_item_id =>x_work_item_id,
1157: x_return_status =>l_return_status,
1158: x_msg_count =>l_msg_count,

Line 1165: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1161: iex_debug_pub.logmessage ('after calling create_work_pvt.create');
1162: iex_debug_pub.logmessage ('and l_return_status from the pvt ='||l_return_status);
1163: END IF;
1164: x_return_status :=l_return_Status;
1165: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1166: --update nextwork item i nthe strategy table
1167: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1168: (p_api_version => l_api_version,
1169: p_init_msg_list => FND_API.G_TRUE,

Line 1169: p_init_msg_list => FND_API.G_TRUE,

1165: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1166: --update nextwork item i nthe strategy table
1167: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1168: (p_api_version => l_api_version,
1169: p_init_msg_list => FND_API.G_TRUE,
1170: p_commit => FND_API.G_FALSE,
1171: x_msg_count => l_msg_count,
1172: x_msg_data => l_msg_data,
1173: x_return_status => l_return_status,

Line 1170: p_commit => FND_API.G_FALSE,

1166: --update nextwork item i nthe strategy table
1167: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1168: (p_api_version => l_api_version,
1169: p_init_msg_list => FND_API.G_TRUE,
1170: p_commit => FND_API.G_FALSE,
1171: x_msg_count => l_msg_count,
1172: x_msg_data => l_msg_data,
1173: x_return_status => l_return_status,
1174: p_strategy_id => p_strategy_id,

Line 1214: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1210:
1211: -- if next work_item updation fails then also get the error message
1212: -- get error message and passit pass it
1213: --add new message
1214: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1215: fnd_message.set_name('IEX', 'IEX_UPD_NEXT_WORK_ITEM_FAILED');
1216: fnd_msg_pub.add;
1217: FND_MSG_PUB.Count_And_Get
1218: ( p_count => l_msg_count,

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

1457: iex_debug_pub.logmessage ('**** BEGIN Get_Messages ************');
1458: END IF;
1459: FOR l_count in 1..p_message_count LOOP
1460:
1461: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
1462: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
1463: OPEN Get_Appl_Id (l_appl_short_name);
1464: FETCH Get_Appl_Id into l_id;
1465: CLOSE Get_Appl_Id;

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

1472: FETCH Get_Message_Num into l_message_num;
1473: CLOSE Get_Message_Num;
1474: END IF;
1475:
1476: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
1477:
1478: IF NVL(l_message_num, 0) <> 0
1479: THEN
1480: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

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

1484:
1485: IF l_count = 1
1486: THEN
1487: l_msg_list := l_msg_list || l_temp_msg ||
1488: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
1489: ELSE
1490: l_msg_list := l_msg_list || l_temp_msg ||
1491: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
1492: END IF;

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

1487: l_msg_list := l_msg_list || l_temp_msg ||
1488: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
1489: ELSE
1490: l_msg_list := l_msg_list || l_temp_msg ||
1491: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
1492: END IF;
1493:
1494: l_msg_list := l_msg_list || '';
1495:

Line 1851: p_init_msg_list => FND_API.G_TRUE,

1847:
1848: END IF;
1849:
1850: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
1851: p_init_msg_list => FND_API.G_TRUE,
1852: p_commit => FND_API.G_FALSE,
1853: x_msg_count => l_msg_count,
1854: x_msg_data => l_msg_data,
1855: x_return_status => l_return_status,

Line 1852: p_commit => FND_API.G_FALSE,

1848: END IF;
1849:
1850: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
1851: p_init_msg_list => FND_API.G_TRUE,
1852: p_commit => FND_API.G_FALSE,
1853: x_msg_count => l_msg_count,
1854: x_msg_data => l_msg_data,
1855: x_return_status => l_return_status,
1856: p_strategy_id => l_strategy_id,

Line 1867: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1863: END IF;
1864:
1865: -- if the result is 'N' then go back to
1866: -- sleep or wait mode
1867: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1868: result := wf_engine.eng_completed ||':'||wf_yes;
1869: else
1870: result := wf_engine.eng_completed ||':'||wf_no;
1871: --set the strategy_status back to 'OPEN'

Line 1948: l_init_msg_list := FND_API.G_TRUE;

1944: where strategy_id =p_strategy_id;
1945: l_value VARCHAR2(300);
1946: Begin
1947: -- initialize variable
1948: l_init_msg_list := FND_API.G_TRUE;
1949: l_commit := FND_API.G_TRUE;
1950:
1951: -- IF PG_DEBUG < 10 THEN
1952: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1949: l_commit := FND_API.G_TRUE;

1945: l_value VARCHAR2(300);
1946: Begin
1947: -- initialize variable
1948: l_init_msg_list := FND_API.G_TRUE;
1949: l_commit := FND_API.G_TRUE;
1950:
1951: -- IF PG_DEBUG < 10 THEN
1952: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1953: iex_debug_pub.logmessage ('**** BEGIN create_next_work_item ************');

Line 2011: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN

2007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2008: iex_debug_pub.logmessage ('create_next_work_item: ' || ' creation of work items and status => '||l_return_status);
2009: END IF;
2010:
2011: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
2012: result := wf_engine.eng_completed ||':'||wf_no;
2013: --pass the error message
2014: wf_engine.SetItemAttrText(itemtype => itemtype,
2015: itemkey => itemkey,

Line 2456: l_return_status :=FND_API.G_RET_STS_SUCCESS;

2452: L_STATUS_CODE VARCHAR2(25);
2453: l_work_item_id NUMBER(25);
2454: BEGIN
2455: -- initialize variable
2456: l_return_status :=FND_API.G_RET_STS_SUCCESS;
2457:
2458: -- IF PG_DEBUG < 10 THEN
2459: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2460: iex_debug_pub.logmessage ('**** START CUSTOM_CHECK ************');

Line 2525: p_init_msg_list => FND_API.G_TRUE,

2521:
2522: IEX_STRY_cuwf_pub.Start_CustomWF
2523: (
2524: p_api_version =>1.0,
2525: p_init_msg_list => FND_API.G_TRUE,
2526: p_commit => FND_API.G_FALSE,
2527: p_custom_wf_rec =>l_custom_wf_rec,
2528: x_msg_count => l_msg_count,
2529: x_msg_data => l_msg_data,

Line 2526: p_commit => FND_API.G_FALSE,

2522: IEX_STRY_cuwf_pub.Start_CustomWF
2523: (
2524: p_api_version =>1.0,
2525: p_init_msg_list => FND_API.G_TRUE,
2526: p_commit => FND_API.G_FALSE,
2527: p_custom_wf_rec =>l_custom_wf_rec,
2528: x_msg_count => l_msg_count,
2529: x_msg_data => l_msg_data,
2530: x_return_status => l_return_status);

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

2540:
2541: -- don't check for result, what ever is the outcome
2542: -- go and wait, the UI will relaunch the custom workflow
2543:
2544: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2545: result := wf_engine.eng_completed ||':'||wf_yes;
2546: else
2547: result := wf_engine.eng_completed ||':'||wf_no;
2548: end if;

Line 2589: l_return_status :=FND_API.G_RET_STS_SUCCESS;

2585: l_curr_dmethod varchar2(10);
2586:
2587: BEGIN
2588: -- initialize variable
2589: l_return_status :=FND_API.G_RET_STS_SUCCESS;
2590:
2591: -- IF PG_DEBUG < 10 THEN
2592: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2593: iex_debug_pub.logmessage ('**** START FULFIL_CHECK ************');

Line 2645: p_init_msg_list => FND_API.G_FALSE,

2641: iex_debug_pub.logmessage('FULFIL_CHECK: ' || 'fulful template id' ||l_fulfil_temp_id);
2642: END IF;
2643: iex_strategy_work_pub.strategy_mailer(
2644: p_api_version =>1.0,
2645: p_init_msg_list => FND_API.G_FALSE,
2646: p_commit => FND_API.G_TRUE,
2647: p_strategy_mailer_rec => l_strategy_mailer_rec,
2648: x_msg_count => l_msg_count,
2649: x_msg_data => l_msg_data,

Line 2646: p_commit => FND_API.G_TRUE,

2642: END IF;
2643: iex_strategy_work_pub.strategy_mailer(
2644: p_api_version =>1.0,
2645: p_init_msg_list => FND_API.G_FALSE,
2646: p_commit => FND_API.G_TRUE,
2647: p_strategy_mailer_rec => l_strategy_mailer_rec,
2648: x_msg_count => l_msg_count,
2649: x_msg_data => l_msg_data,
2650: x_return_status => l_return_status);

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

2655:
2656: -- don't check for result, what ever is the outcome
2657: -- go and wait, the UI will relaunch the fulilment workflow
2658:
2659: /* if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2660: result := wf_engine.eng_completed ||':'||wf_yes;
2661: else
2662: result := wf_engine.eng_completed ||':'||wf_no;
2663: end if;

Line 2712: l_return_status :=FND_API.G_RET_STS_SUCCESS;

2708: l_curr_dmethod varchar2(10);
2709:
2710: BEGIN
2711: -- initialize variable
2712: l_return_status :=FND_API.G_RET_STS_SUCCESS;
2713:
2714: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2715: iex_debug_pub.logmessage ('**** START cal_post_wait ************');
2716: END IF;

Line 3446: p_init_msg_list => FND_API.G_TRUE,

3442: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3443: iex_debug_pub.logmessage('UPDATE_WORK_ITEM: ' || 'value of workitem id '||l_work_item_id);
3444: END IF;
3445: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
3446: p_init_msg_list => FND_API.G_TRUE,
3447: p_commit => FND_API.G_FALSE,
3448: x_msg_count => l_msg_count,
3449: x_msg_data => l_msg_data,
3450: x_return_status => l_return_status,

Line 3447: p_commit => FND_API.G_FALSE,

3443: iex_debug_pub.logmessage('UPDATE_WORK_ITEM: ' || 'value of workitem id '||l_work_item_id);
3444: END IF;
3445: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
3446: p_init_msg_list => FND_API.G_TRUE,
3447: p_commit => FND_API.G_FALSE,
3448: x_msg_count => l_msg_count,
3449: x_msg_data => l_msg_data,
3450: x_return_status => l_return_status,
3451: p_work_item_id => l_work_item_id,

Line 3453: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

3449: x_msg_data => l_msg_data,
3450: x_return_status => l_return_status,
3451: p_work_item_id => l_work_item_id,
3452: p_status => 'TIMEOUT');
3453: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
3454: result := wf_engine.eng_completed ||':'||wf_yes;
3455: else
3456: RAISE EXC;
3457: END IF;

Line 3736: p_init_msg_list => FND_API.G_TRUE,

3732:
3733: abort_processes(l_strategy_id);
3734:
3735: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
3736: p_init_msg_list => FND_API.G_TRUE,
3737: p_commit => FND_API.G_FALSE,
3738: x_msg_count => l_msg_count,
3739: x_msg_data => l_msg_data,
3740: x_return_status => l_return_status,

Line 3737: p_commit => FND_API.G_FALSE,

3733: abort_processes(l_strategy_id);
3734:
3735: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
3736: p_init_msg_list => FND_API.G_TRUE,
3737: p_commit => FND_API.G_FALSE,
3738: x_msg_count => l_msg_count,
3739: x_msg_data => l_msg_data,
3740: x_return_status => l_return_status,
3741: p_strategy_id => l_strategy_id,

Line 3897: l_init_msg_list := FND_API.G_TRUE;

3893: -- End for the bug#7656223
3894: BEGIN
3895: -- initialize variable
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:

Line 3898: l_commit := FND_API.G_FALSE;

3894: BEGIN
3895: -- initialize variable
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);

Line 3899: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

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

Line 3917: p_init_msg_list => FND_API.G_TRUE,

3913: -- the record has resource id and person id along with the user name
3914: --Begin bug#5373412 schekuri 10-Jul-2006
3915: --Call new consolidated procedure get_assigned_collector
3916: /*iex_utilities.get_billto_resources(p_api_version => l_api_version,
3917: p_init_msg_list => FND_API.G_TRUE,
3918: p_commit => FND_API.G_FALSE,
3919: p_validation_level => l_validation_level,
3920: x_msg_count => l_msg_count,
3921: x_msg_data => l_msg_data,

Line 3918: p_commit => FND_API.G_FALSE,

3914: --Begin bug#5373412 schekuri 10-Jul-2006
3915: --Call new consolidated procedure get_assigned_collector
3916: /*iex_utilities.get_billto_resources(p_api_version => l_api_version,
3917: p_init_msg_list => FND_API.G_TRUE,
3918: p_commit => FND_API.G_FALSE,
3919: p_validation_level => l_validation_level,
3920: x_msg_count => l_msg_count,
3921: x_msg_data => l_msg_data,
3922: x_return_status => l_return_status,

Line 3927: p_init_msg_list => FND_API.G_TRUE,

3923: p_site_use_id => p_siteuse_id,
3924: x_resource_tab => l_resource_tab);*/
3925:
3926: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
3927: p_init_msg_list => FND_API.G_TRUE,
3928: p_commit => FND_API.G_FALSE,
3929: p_validation_level => l_validation_level,
3930: p_level => 'BILLTO',
3931: p_level_id => p_siteuse_id,

Line 3928: p_commit => FND_API.G_FALSE,

3924: x_resource_tab => l_resource_tab);*/
3925:
3926: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
3927: p_init_msg_list => FND_API.G_TRUE,
3928: p_commit => FND_API.G_FALSE,
3929: p_validation_level => l_validation_level,
3930: p_level => 'BILLTO',
3931: p_level_id => p_siteuse_id,
3932: x_msg_count => l_msg_count,

Line 4093: l_init_msg_list := FND_API.G_TRUE;

4089:
4090: BEGIN
4091: -- initialize variable
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:

Line 4094: l_commit := FND_API.G_FALSE;

4090: BEGIN
4091: -- initialize variable
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);

Line 4095: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

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

Line 4113: p_init_msg_list => FND_API.G_TRUE,

4109: -- the record has resource id and person id along with the user name
4110: --Begin bug#5373412 schekuri 10-Jul-2006
4111: --Call new consolidated procedure get_assigned_collector
4112: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
4113: p_init_msg_list => FND_API.G_TRUE,
4114: p_commit => FND_API.G_FALSE,
4115: p_validation_level => l_validation_level,
4116: p_level => 'ACCOUNT',
4117: p_level_id => p_account_id,

Line 4114: p_commit => FND_API.G_FALSE,

4110: --Begin bug#5373412 schekuri 10-Jul-2006
4111: --Call new consolidated procedure get_assigned_collector
4112: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
4113: p_init_msg_list => FND_API.G_TRUE,
4114: p_commit => FND_API.G_FALSE,
4115: p_validation_level => l_validation_level,
4116: p_level => 'ACCOUNT',
4117: p_level_id => p_account_id,
4118: x_msg_count => l_msg_count,

Line 4123: p_init_msg_list => FND_API.G_TRUE,

4119: x_msg_data => l_msg_data,
4120: x_return_status => l_return_status,
4121: x_resource_tab => l_resource_tab);
4122: /*iex_utilities.get_assign_account_resources(p_api_version => l_api_version,
4123: p_init_msg_list => FND_API.G_TRUE,
4124: p_commit => FND_API.G_FALSE,
4125: p_validation_level => l_validation_level,
4126: x_msg_count => l_msg_count,
4127: x_msg_data => l_msg_data,

Line 4124: p_commit => FND_API.G_FALSE,

4120: x_return_status => l_return_status,
4121: x_resource_tab => l_resource_tab);
4122: /*iex_utilities.get_assign_account_resources(p_api_version => l_api_version,
4123: p_init_msg_list => FND_API.G_TRUE,
4124: p_commit => FND_API.G_FALSE,
4125: p_validation_level => l_validation_level,
4126: x_msg_count => l_msg_count,
4127: x_msg_data => l_msg_data,
4128: x_return_status => l_return_status,

Line 4430: P_Init_Msg_List =>FND_API.G_TRUE,

4426: l_strategy_work_item_Rec.escalated_yn := 'Y';
4427: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
4428: P_Api_Version_Number =>l_api_version_number,
4429: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4430: P_Init_Msg_List =>FND_API.G_TRUE,
4431: p_commit =>FND_API.G_TRUE,
4432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4433: x_msg_count => l_msg_count,
4434: x_msg_data => l_msg_data,

Line 4431: p_commit =>FND_API.G_TRUE,

4427: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
4428: P_Api_Version_Number =>l_api_version_number,
4429: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4430: P_Init_Msg_List =>FND_API.G_TRUE,
4431: p_commit =>FND_API.G_TRUE,
4432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4433: x_msg_count => l_msg_count,
4434: x_msg_data => l_msg_data,
4435: x_return_status => l_return_status,

Line 4432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4428: P_Api_Version_Number =>l_api_version_number,
4429: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4430: P_Init_Msg_List =>FND_API.G_TRUE,
4431: p_commit =>FND_API.G_TRUE,
4432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4433: x_msg_count => l_msg_count,
4434: x_msg_data => l_msg_data,
4435: x_return_status => l_return_status,
4436: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );

Line 4440: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN

4436: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
4437: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
4438: iex_debug_pub.logmessage ('UPDATE_ESC_FLAG: Return status = ' || l_return_status);
4439: END IF;
4440: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
4441: begin
4442: iex_debug_pub.logmessage('UPDATE_ESC_FLAG: Refreshing UWQ Summary..');
4443: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
4444: exception