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.AMS_WFTRIG_PVT dependencies on FND_API

Line 214: p_encoded => FND_API.G_FALSE,

210:
211: WHILE l_cnt < p_msg_count
212: LOOP
213: FND_MSG_PUB.Get(p_msg_index => l_cnt + 1,
214: p_encoded => FND_API.G_FALSE,
215: p_data => l_msg_data,
216: p_msg_index_out => l_msg_index ) ;
217: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10);
218: l_cnt := l_cnt + 1 ;

Line 673: p_init_msg_list => FND_API.G_FALSE,

669: -- Start :anchaudh: 15 Oct'03 : uncommented the call to "Schedule_Next_Trigger_Run" and calling "Schedule_Repeat" instead.
670:
671: /* AMS_ContCampaign_PVT.Schedule_Next_Trigger_Run
672: (p_api_version => 1.0,
673: p_init_msg_list => FND_API.G_FALSE,
674: p_commit => FND_API.G_FALSE,
675: p_trigger_id => l_trigger_id,
676: x_msg_count => l_msg_count,
677: x_msg_data => l_msg_data,

Line 674: p_commit => FND_API.G_FALSE,

670:
671: /* AMS_ContCampaign_PVT.Schedule_Next_Trigger_Run
672: (p_api_version => 1.0,
673: p_init_msg_list => FND_API.G_FALSE,
674: p_commit => FND_API.G_FALSE,
675: p_trigger_id => l_trigger_id,
676: x_msg_count => l_msg_count,
677: x_msg_data => l_msg_data,
678: x_return_status => l_return_status,

Line 709: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

705: x_return_status => l_return_status,
706: x_msg_count => l_msg_count,
707: x_msg_data => l_msg_data);
708:
709: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
710: Handle_Err
711: (p_itemtype => itemtype ,
712: p_itemkey => itemkey ,
713: p_msg_count => l_msg_count, -- Number of error Messages

Line 725: p_init_msg_list => FND_API.G_FALSE,

721:
722: -- The calls added to calculate the time in User's timezone
723:
724: AMS_Utility_PVT.Convert_Timezone(
725: p_init_msg_list => FND_API.G_FALSE,
726: x_return_status => l_return_status,
727: x_msg_count => l_msg_count,
728: x_msg_data => l_msg_data,
729:

Line 737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

733:
734: x_out_time => l_user_last_run_date_time
735: ) ;
736:
737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
738: Handle_Err
739: (p_itemtype => itemtype ,
740: p_itemkey => itemkey ,
741: p_msg_count => l_msg_count, -- Number of error Messages

Line 751: p_init_msg_list => FND_API.G_FALSE,

747: RETURN;
748: END IF;
749:
750: AMS_Utility_PVT.Convert_Timezone(
751: p_init_msg_list => FND_API.G_FALSE,
752: x_return_status => l_return_status,
753: x_msg_count => l_msg_count,
754: x_msg_data => l_msg_data,
755:

Line 763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

759:
760: x_out_time => l_user_next_run_date_time
761: );
762:
763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: Handle_Err
765: (p_itemtype => itemtype ,
766: p_itemkey => itemkey ,
767: p_msg_count => l_msg_count, -- Number of error Messages

Line 788: --IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

784: -- End :anchaudh: 15 Oct'03 : uncommented the call to "Schedule_Next_Trigger_Run" and calling "Schedule_Repeat" instead.
785:
786: -- dbms_OUTPUT.PUT_LINE('Next Scheduled Date is : '||to_char(l_sch_date,'DD-MON-RRRR:HH-MI-SS AM'));
787:
788: --IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
789: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
790: itemkey => itemkey ,
791: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
792: avalue => to_char(l_sch_date,'DD-MON-RRRR HH:MI:SS AM'));

Line 1045: p_commit => Fnd_Api.G_FALSE);

1041: p_act_metric_used_by_id => l_chk1_source_id,
1042: x_return_status => l_return_status,
1043: x_msg_count => l_msg_count,
1044: x_msg_data => l_msg_data,
1045: p_commit => Fnd_Api.G_FALSE);
1046:
1047: IF l_return_status <> FND_API.g_ret_sts_success THEN
1048: result := 'COMPLETE:FAILURE';
1049: return;

Line 1047: IF l_return_status <> FND_API.g_ret_sts_success THEN

1043: x_msg_count => l_msg_count,
1044: x_msg_data => l_msg_data,
1045: p_commit => Fnd_Api.G_FALSE);
1046:
1047: IF l_return_status <> FND_API.g_ret_sts_success THEN
1048: result := 'COMPLETE:FAILURE';
1049: return;
1050: END IF;
1051: END IF;

Line 1070: p_commit => Fnd_Api.G_FALSE);

1066: p_act_metric_used_by_id => l_chk2_source_id,
1067: x_return_status => l_return_status,
1068: x_msg_count => l_msg_count,
1069: x_msg_data => l_msg_data,
1070: p_commit => Fnd_Api.G_FALSE);
1071:
1072: IF l_return_status <> FND_API.g_ret_sts_success THEN
1073: result := 'COMPLETE:FAILURE';
1074: return;

Line 1072: IF l_return_status <> FND_API.g_ret_sts_success THEN

1068: x_msg_count => l_msg_count,
1069: x_msg_data => l_msg_data,
1070: p_commit => Fnd_Api.G_FALSE);
1071:
1072: IF l_return_status <> FND_API.g_ret_sts_success THEN
1073: result := 'COMPLETE:FAILURE';
1074: return;
1075: END IF;
1076: END IF;

Line 1081: p_init_msg_list => FND_API.G_FALSE,

1077: END IF;
1078: */
1079: AMS_ContCampaign_PVT.Perform_Checks
1080: (p_api_version => 1.0 ,
1081: p_init_msg_list => FND_API.G_FALSE,
1082: x_return_status => l_return_status,
1083: x_msg_count => l_msg_count,
1084: x_msg_data => l_msg_data,
1085: p_trigger_id => l_trigger_id,

Line 1092: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1088: x_check_high_val => l_high_value,
1089: x_result_id => l_result_id
1090: ) ;
1091:
1092: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1093: IF l_chk_success = '0' THEN
1094: result := 'COMPLETE:FAILURE' ;
1095: ELSIF l_chk_success = '1' THEN
1096: l_camp_name := WF_ENGINE.GetItemAttrText(

Line 1537: p_init_msg_list => FND_API.G_FALSE,

1533: Ams_Utility_pvt.debug_message('Schedule id: '||l_sch_id);
1534:
1535: AMS_Act_List_PVT.generate_target_group_list_old
1536: ( p_api_version => 1.0,
1537: p_init_msg_list => FND_API.G_FALSE,
1538: p_commit => FND_API.G_FALSE,
1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1540: p_list_used_by => 'CSCH',
1541: p_list_used_by_id => l_sch_id,

Line 1538: p_commit => FND_API.G_FALSE,

1534:
1535: AMS_Act_List_PVT.generate_target_group_list_old
1536: ( p_api_version => 1.0,
1537: p_init_msg_list => FND_API.G_FALSE,
1538: p_commit => FND_API.G_FALSE,
1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1540: p_list_used_by => 'CSCH',
1541: p_list_used_by_id => l_sch_id,
1542: x_return_status => l_return_status,

Line 1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1535: AMS_Act_List_PVT.generate_target_group_list_old
1536: ( p_api_version => 1.0,
1537: p_init_msg_list => FND_API.G_FALSE,
1538: p_commit => FND_API.G_FALSE,
1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1540: p_list_used_by => 'CSCH',
1541: p_list_used_by_id => l_sch_id,
1542: x_return_status => l_return_status,
1543: x_msg_count => l_msg_count,

Line 1556: IF l_return_status = FND_API.g_ret_sts_success THEN

1552: p_msg_data => 'return status from generate target group: ' || l_return_status ,
1553: p_msg_type => 'DEBUG'
1554: );
1555:
1556: IF l_return_status = FND_API.g_ret_sts_success THEN
1557: result := 'COMPLETE:SUCCESS';
1558: ELSE
1559: result := 'COMPLETE:ERROR';
1560: /* WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 1590: ,p_init_msg_list => FND_API.G_FALSE

1586: p_msg_type => 'DEBUG'
1587: );
1588:
1589: AMS_ScheduleRules_PVT.Activate_Schedule(p_api_version => 1.0
1590: ,p_init_msg_list => FND_API.G_FALSE
1591: ,p_commit => FND_API.G_False
1592: ,x_return_status => l_return_status
1593: ,x_msg_count => l_msg_count
1594: ,x_msg_data => l_msg_data

Line 1591: ,p_commit => FND_API.G_False

1587: );
1588:
1589: AMS_ScheduleRules_PVT.Activate_Schedule(p_api_version => 1.0
1590: ,p_init_msg_list => FND_API.G_FALSE
1591: ,p_commit => FND_API.G_False
1592: ,x_return_status => l_return_status
1593: ,x_msg_count => l_msg_count
1594: ,x_msg_data => l_msg_data
1595: ,p_schedule_id => l_sch_id

Line 1607: IF l_return_status = FND_API.g_ret_sts_success THEN

1603: p_log_used_by_id => l_sch_id,
1604: p_msg_data => 'return status from activate schedule: ' || l_return_status ,
1605: p_msg_type => 'DEBUG'
1606: );
1607: IF l_return_status = FND_API.g_ret_sts_success THEN
1608: result := 'COMPLETE:SUCCESS';
1609: ELSE
1610: result := 'COMPLETE:ERROR';
1611: --WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 1636: p_init_msg_list => FND_API.G_TRUE,

1632: FETCH c_sch_det INTO l_start_time, l_timezone;
1633: CLOSE c_sch_det;
1634:
1635: AMS_UTILITY_PVT.Convert_Timezone(
1636: p_init_msg_list => FND_API.G_TRUE,
1637: x_return_status => l_return_status,
1638: x_msg_count => l_msg_count,
1639: x_msg_data => l_msg_data,
1640:

Line 1649: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1645: x_out_time => l_sys_start_time
1646: );
1647:
1648: -- If any errors happen let start time be sysdate
1649: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1650: l_sys_start_time := SYSDATE;
1651: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1652: l_sys_start_time := SYSDATE;
1653: END IF;

Line 1651: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1647:
1648: -- If any errors happen let start time be sysdate
1649: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1650: l_sys_start_time := SYSDATE;
1651: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1652: l_sys_start_time := SYSDATE;
1653: END IF;
1654:
1655: --AMS_Utility_PVT.debug_message('Raise Business event for schedule execution');

Line 1770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1766: Get_User_Role(p_user_id => l_sch_det_rec.owner_user_id,
1767: x_role_name => l_owner,
1768: x_role_display_name => l_display_name,
1769: x_return_status => l_return_status);
1770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1771: RAISE FND_API.G_EXC_ERROR;
1772: END IF;
1773:
1774: WF_ENGINE.SetItemAttrText(itemtype => itemtype

Line 1771: RAISE FND_API.G_EXC_ERROR;

1767: x_role_name => l_owner,
1768: x_role_display_name => l_display_name,
1769: x_return_status => l_return_status);
1770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1771: RAISE FND_API.G_EXC_ERROR;
1772: END IF;
1773:
1774: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1775: ,itemkey => l_item_key

Line 1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1799: Get_User_Role(p_user_id => l_sch_det_rec.notify_user_id,
1800: x_role_name => l_notify,
1801: x_role_display_name => l_display_name,
1802: x_return_status => l_return_status);
1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1804: THEN
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807: WF_ENGINE.SetItemAttrText(itemtype => itemtype

Line 1805: RAISE FND_API.G_EXC_ERROR;

1801: x_role_display_name => l_display_name,
1802: x_return_status => l_return_status);
1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1804: THEN
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1808: ,itemkey => l_item_key
1809: ,aname => 'AMS_NOTIF_TO_USER_NAME'

Line 1825: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1821: Get_User_Role(p_user_id => l_sch_det_rec.approver_user_id,
1822: x_role_name => l_approver,
1823: x_role_display_name => l_display_name,
1824: x_return_status => l_return_status);
1825: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1826: RAISE FND_API.G_EXC_ERROR;
1827: END IF;
1828: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1829: ,itemkey => l_item_key

Line 1826: RAISE FND_API.G_EXC_ERROR;

1822: x_role_name => l_approver,
1823: x_role_display_name => l_display_name,
1824: x_return_status => l_return_status);
1825: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1826: RAISE FND_API.G_EXC_ERROR;
1827: END IF;
1828: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1829: ,itemkey => l_item_key
1830: ,aname => 'AMS_APPROVER_NAME'

Line 2032: x_return_status := FND_API.G_RET_STS_SUCCESS;

2028: FROM ams_jtf_rs_emp_v
2029: WHERE resource_id = p_user_id ;
2030: l_person_id number;
2031: BEGIN
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033: OPEN c_resource ;
2034: FETCH c_resource INTO l_person_id ;
2035: IF c_resource%NOTFOUND THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2036: x_return_status := FND_API.G_RET_STS_ERROR;

2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033: OPEN c_resource ;
2034: FETCH c_resource INTO l_person_id ;
2035: IF c_resource%NOTFOUND THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
2038: FND_MSG_PUB.Add;
2039: END IF;
2040: CLOSE c_resource ;

Line 2048: x_return_status := FND_API.G_RET_STS_ERROR;

2044: p_orig_system_id => l_person_id ,
2045: p_name => x_role_name,
2046: p_display_name => x_role_display_name );
2047: IF x_role_name is null then
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
2050: FND_MSG_PUB.Add;
2051: END IF;
2052: END Get_User_Role;

Line 2319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2315: Get_User_Role(p_user_id => l_notify_action_det.action_for_id,
2316: x_role_name => l_notify,
2317: x_role_display_name => l_display_name,
2318: x_return_status => l_return_status);
2319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2320: THEN
2321: RAISE FND_API.G_EXC_ERROR;
2322: END IF;
2323:

Line 2321: RAISE FND_API.G_EXC_ERROR;

2317: x_role_display_name => l_display_name,
2318: x_return_status => l_return_status);
2319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2320: THEN
2321: RAISE FND_API.G_EXC_ERROR;
2322: END IF;
2323:
2324: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2325: ,itemkey => itemkey

Line 2685: IF l_return_status <> FND_API.g_ret_sts_success THEN

2681: x_return_status => l_return_status,
2682: x_msg_count => l_msg_count,
2683: x_msg_data => l_msg_data);
2684:
2685: IF l_return_status <> FND_API.g_ret_sts_success THEN
2686: l_failed := l_failed + 1;
2687: result := 'COMPLETE:ERROR';
2688: END IF;
2689:

Line 2764: IF l_return_status <> FND_API.g_ret_sts_success THEN

2760: Get_User_Role(p_user_id => l_sch_det_rec.owner_user_id,
2761: x_role_name => l_owner,
2762: x_role_display_name => l_display_name,
2763: x_return_status => l_return_status);
2764: IF l_return_status <> FND_API.g_ret_sts_success THEN
2765: result := 'COMPLETE:ERROR';
2766: RETURN;
2767: END IF;
2768:

Line 2806: IF l_return_status <> FND_API.g_ret_sts_success THEN

2802: Get_User_Role(p_user_id => l_sch_det_rec.notify_user_id,
2803: x_role_name => l_notify,
2804: x_role_display_name => l_display_name,
2805: x_return_status => l_return_status);
2806: IF l_return_status <> FND_API.g_ret_sts_success THEN
2807: result := 'COMPLETE:ERROR';
2808: RETURN;
2809: END IF;
2810:

Line 2829: IF l_return_status <> FND_API.g_ret_sts_success THEN

2825: Get_User_Role(p_user_id => l_sch_det_rec.approver_user_id,
2826: x_role_name => l_approver,
2827: x_role_display_name => l_display_name,
2828: x_return_status => l_return_status);
2829: IF l_return_status <> FND_API.g_ret_sts_success THEN
2830: result := 'COMPLETE:ERROR';
2831: RETURN;
2832: END IF;
2833:

Line 2956: /* l_schedule_rec.schedule_id := FND_API.G_MISS_NUM;

2952: open c_sched_rec(l_sch_det_rec.schedule_id);
2953: FETCH c_sched_rec INTO l_csch_rec;
2954: CLOSE c_sched_rec;
2955:
2956: /* l_schedule_rec.schedule_id := FND_API.G_MISS_NUM;
2957: l_schedule_rec.campaign_id := l_csch_rec.campaign_id;
2958:
2959: l_schedule_rec.use_parent_code_flag := l_csch_rec.use_parent_code_flag;
2960: l_schedule_rec.source_code := null; */

Line 2986: IF l_return_status <> FND_API.g_ret_sts_success THEN

2982: x_return_status => l_return_status,
2983: x_msg_count => l_msg_count,
2984: x_msg_data => l_msg_data);
2985:
2986: IF l_return_status <> FND_API.g_ret_sts_success THEN
2987: l_failed := l_failed + 1;
2988: result := 'COMPLETE:ERROR';
2989: END IF;
2990:

Line 3068: IF l_return_status <> FND_API.g_ret_sts_success THEN

3064: x_msg_data => l_msg_data,
3065: x_return_status => l_return_status
3066: );
3067:
3068: IF l_return_status <> FND_API.g_ret_sts_success THEN
3069: l_failed := l_failed + 1;
3070: result := 'COMPLETE:ERROR';
3071: AMS_Utility_PVT.Create_Log (
3072: x_return_status => l_return_log_status,

Line 3547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3543: Get_User_Role(p_user_id => l_notify_action_det.action_for_id,
3544: x_role_name => l_notify,
3545: x_role_display_name => l_display_name,
3546: x_return_status => l_return_status);
3547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3548: THEN
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 3549: RAISE FND_API.G_EXC_ERROR;

3545: x_role_display_name => l_display_name,
3546: x_return_status => l_return_status);
3547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3548: THEN
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3552: itemkey => itemkey,
3553: aname => 'AMS_TRIG_NOTIFTIER',

Line 3762: l_msg := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);

3758: IS
3759: l_msg varchar2(4000);
3760: BEGIN
3761: LOOP
3762: l_msg := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);
3763: EXIT WHEN l_msg IS NULL;
3764: write_msg(p_procedure, 'ERROR: '||l_msg);
3765: END LOOP;
3766: END;