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_UTILITY_PVT dependencies on AMS_UTILITY_PVT

Line 1: PACKAGE BODY AMS_Utility_PVT AS

1: PACKAGE BODY AMS_Utility_PVT AS
2: /* $Header: amsvutlb.pls 120.5 2006/06/14 17:52:16 dbiswas noship $ */
3:
4: -- HISTORY
5: --

Line 740: AMS_Utility_PVT.error_message ('AMS_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_sys_qual);

736: ELSIF p_sys_qual = 'ALIST' THEN
737: x_table_name := 'AMS_ACT_LISTS';
738: x_pk_name := 'ACT_LIST_HEADER_ID';
739: ELSE
740: AMS_Utility_PVT.error_message ('AMS_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_sys_qual);
741: x_return_status := FND_API.g_ret_sts_unexp_error;
742: x_table_name := NULL;
743: x_pk_name := NULL;
744: END IF;

Line 1296: -- SELECT AMS_Utility_PVT.get_lookup_meaning ('AMS_CAMPAIGN_STATUS', status_code)

1292: -- FUNCTION
1293: -- get_lookup_meaning
1294: -- USAGE
1295: -- Example:
1296: -- SELECT AMS_Utility_PVT.get_lookup_meaning ('AMS_CAMPAIGN_STATUS', status_code)
1297: -- FROM ams_campaigns_vl;
1298: -- HISTORY
1299: -- 28-Apr-2000 choang Created.
1300: ---------------------------------------------------------------------

Line 1328: -- SELECT AMS_Utility_PVT.get_resource_name (owner_user_id)

1324: -- FUNCTION
1325: -- get_resource_name
1326: -- USAGE
1327: -- Example:
1328: -- SELECT AMS_Utility_PVT.get_resource_name (owner_user_id)
1329: -- FROM ams_campaigns_vl
1330: -- HISTORY
1331: -- 28-Apr-2000 choang Created.
1332: ---------------------------------------------------------------------

Line 1770: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_STATUS_CHANGE');

1766: OPEN c_approval_flag;
1767: FETCH c_approval_flag INTO l_theme_flag, l_budget_flag;
1768: IF c_approval_flag%NOTFOUND THEN
1769: x_return_status := FND_API.g_ret_sts_error;
1770: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_STATUS_CHANGE');
1771: END IF;
1772: CLOSE c_approval_flag;
1773:
1774: IF l_budget_flag = 'Y' THEN

Line 1877: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_STATUS_CHANGE');

1873: OPEN c_approval_flag;
1874: FETCH c_approval_flag INTO l_theme_flag, l_budget_flag;
1875: IF c_approval_flag%NOTFOUND THEN
1876: x_return_status := FND_API.g_ret_sts_error;
1877: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_STATUS_CHANGE');
1878: END IF;
1879: CLOSE c_approval_flag;
1880:
1881: IF l_budget_flag = 'Y' THEN

Line 2169: IF ams_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',

2165:
2166: x_return_status := fnd_api.g_ret_sts_error;
2167: RETURN;
2168: ELSE
2169: IF ams_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',
2170: 'CONVERSION_TYPE'
2171: ,l_conversion_type) = fnd_api.g_false
2172: THEN
2173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 2204: ams_utility_pvt.debug_message('debug: start ' || l_org_id);

2200: CLOSE c_org_cur;
2201: END IF;
2202:
2203: IF (AMS_DEBUG_HIGH_ON) THEN
2204: ams_utility_pvt.debug_message('debug: start ' || l_org_id);
2205: END IF;
2206:
2207: x_mrc_sob_type_code := 'P';
2208: OPEN c_get_gl_info(l_org_id);

Line 2404: AMS_Utility_PVT.error_message ('AMS_APPR_INVALID_RESOURCE_ID');

2400: FETCH c_resource INTO l_person_id , l_user_id, l_category;
2401: IF c_resource%NOTFOUND THEN
2402: CLOSE c_resource ;
2403: x_return_status := FND_API.G_RET_STS_ERROR;
2404: AMS_Utility_PVT.error_message ('AMS_APPR_INVALID_RESOURCE_ID');
2405: return;
2406: END IF;
2407: CLOSE c_resource ;
2408: -- Pass the Employee ID to get the Role

Line 2418: AMS_Utility_PVT.error_message ('AMS_APPR_INVALID_ROLE');

2414: p_display_name => x_role_display_name
2415: );
2416: IF x_role_name is null then
2417: x_return_status := FND_API.G_RET_STS_ERROR;
2418: AMS_Utility_PVT.error_message ('AMS_APPR_INVALID_ROLE');
2419: return;
2420: END IF;
2421: ELSE
2422: WF_DIRECTORY.getrolename

Line 2430: AMS_Utility_PVT.error_message ('AMS_APPR_INVALID_ROLE');

2426: p_display_name => x_role_display_name
2427: );
2428: IF x_role_name is null then
2429: x_return_status := FND_API.G_RET_STS_ERROR;
2430: AMS_Utility_PVT.error_message ('AMS_APPR_INVALID_ROLE');
2431: return;
2432: END IF;
2433: END IF;
2434: EXCEPTION

Line 2494: AMS_UTILITY_PVT.get_resource_role

2490:
2491: BEGIN
2492: x_return_status := FND_API.G_RET_STS_SUCCESS;
2493: IF p_send_to_role_name IS NULL THEN
2494: AMS_UTILITY_PVT.get_resource_role
2495: ( p_resource_id => p_send_to_res_id,
2496: x_role_name => l_role_name,
2497: x_role_display_name => l_display_role_name,
2498: x_return_status => x_return_status

Line 2661: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_UTILITY_PVT';

2657: FROM ams_campaign_schedules_vl
2658: WHERE schedule_id = p_csch_id;
2659:
2660: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_NAME';
2661: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_UTILITY_PVT';
2662:
2663: BEGIN
2664:
2665: If p_association_type_code = 'AMS_DELV' then

Line 2816: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

2812: l_attribute_token := null;
2813: l_region_code := 'AMS_' || p_obj_type || '_METADATA_0';
2814: l_comma_char := ',';
2815: l_found_error := false;
2816: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2817:
2818: x_return_status := FND_API.G_RET_STS_SUCCESS;
2819: IF p_obj_type IS NULL or p_obj_attribute IS NULL or p_obj_status IS NULL or p_fileld_ak_name_array IS NULL or p_change_indicator_array IS NULL THEN
2820: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2888: END AMS_Utility_PVT;

2884: return;
2885: END validate_locking_rules;
2886:
2887:
2888: END AMS_Utility_PVT;