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.PN_LEASE_PVT dependencies on PN_MO_CACHE_UTILS

Line 230: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'

226:
227: pvt_debug(g_pkg_name||'-Create_Space_Assign Begin',3);
228: x_return_status := fnd_api.g_ret_sts_success;
229:
230: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'
231: , p_lease_tenancies_rec.org_id)
232: ,'N');
233:
234: pvt_debug('-l_automatic_distrubution '|| l_automatic_distrubution,3);

Line 1301: IF p_lease_tenancies_rec.org_id IS NULL OR NVL(pn_mo_cache_utils.check_valid_org(p_lease_tenancies_rec.org_id), 'N') <> 'Y' THEN

1297: pvt_debug(g_pkg_name||'-UPDATE_TENANCIES_ROW:Tenancy ID'||p_lease_tenancies_rec.tenancy_id,3);
1298: -- Initialize the return status.
1299: x_return_status := fnd_api.g_ret_sts_success;
1300:
1301: IF p_lease_tenancies_rec.org_id IS NULL OR NVL(pn_mo_cache_utils.check_valid_org(p_lease_tenancies_rec.org_id), 'N') <> 'Y' THEN
1302: fnd_message.set_name('MO', 'MO_ORG_INVALID');
1303: fnd_msg_pub.ADD;
1304: RAISE fnd_api.g_exc_error;
1305: END IF;

Line 1307: l_mutiple_lease := NVL(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION'

1303: fnd_msg_pub.ADD;
1304: RAISE fnd_api.g_exc_error;
1305: END IF;
1306:
1307: l_mutiple_lease := NVL(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION'
1308: , p_lease_tenancies_rec.org_id)
1309: ,'N');
1310: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'
1311: , p_lease_tenancies_rec.org_id)

Line 1310: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'

1306:
1307: l_mutiple_lease := NVL(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION'
1308: , p_lease_tenancies_rec.org_id)
1309: ,'N');
1310: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'
1311: , p_lease_tenancies_rec.org_id)
1312: ,'N');
1313: l_overlap_tenancy := nvl(pn_mo_cache_utils.get_profile_value('PN_MULT_TNC_SAME_LEASE'
1314: , p_lease_tenancies_rec.org_id)

Line 1313: l_overlap_tenancy := nvl(pn_mo_cache_utils.get_profile_value('PN_MULT_TNC_SAME_LEASE'

1309: ,'N');
1310: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'
1311: , p_lease_tenancies_rec.org_id)
1312: ,'N');
1313: l_overlap_tenancy := nvl(pn_mo_cache_utils.get_profile_value('PN_MULT_TNC_SAME_LEASE'
1314: , p_lease_tenancies_rec.org_id)
1315: ,'N');
1316:
1317: IF l_automatic_distrubution = 'N' AND (l_mutiple_lease <> 'N' OR l_overlap_tenancy <>'N') THEN

Line 2969: NVL(pn_mo_cache_utils.check_valid_org(p_lease_tenancies_rec.org_id), 'N') <> 'Y'

2965: -- Initialize the return status.
2966: x_return_status := fnd_api.g_ret_sts_success;
2967: /*********************************************************************************************************************************************/
2968: IF p_lease_tenancies_rec.org_id IS NULL OR
2969: NVL(pn_mo_cache_utils.check_valid_org(p_lease_tenancies_rec.org_id), 'N') <> 'Y'
2970: THEN
2971: fnd_message.set_name('MO', 'MO_ORG_INVALID');
2972: fnd_msg_pub.ADD;
2973: RAISE fnd_api.g_exc_error;

Line 2977: l_mutiple_lease := NVL(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION'

2973: RAISE fnd_api.g_exc_error;
2974: END IF;
2975:
2976: pvt_debug(g_pkg_name||'-Inside INSERT_TENANCIES_ROW',3);
2977: l_mutiple_lease := NVL(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION'
2978: , p_lease_tenancies_rec.org_id)
2979: ,'N');
2980: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'
2981: , p_lease_tenancies_rec.org_id)

Line 2980: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'

2976: pvt_debug(g_pkg_name||'-Inside INSERT_TENANCIES_ROW',3);
2977: l_mutiple_lease := NVL(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION'
2978: , p_lease_tenancies_rec.org_id)
2979: ,'N');
2980: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'
2981: , p_lease_tenancies_rec.org_id)
2982: ,'N');
2983: l_overlap_tenancy := nvl(pn_mo_cache_utils.get_profile_value('PN_MULT_TNC_SAME_LEASE'
2984:

Line 2983: l_overlap_tenancy := nvl(pn_mo_cache_utils.get_profile_value('PN_MULT_TNC_SAME_LEASE'

2979: ,'N');
2980: l_automatic_distrubution := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION'
2981: , p_lease_tenancies_rec.org_id)
2982: ,'N');
2983: l_overlap_tenancy := nvl(pn_mo_cache_utils.get_profile_value('PN_MULT_TNC_SAME_LEASE'
2984:
2985: , p_lease_tenancies_rec.org_id)
2986: ,'N');
2987:

Line 3874: l_org_id NUMBER := g_org_id;--pn_mo_cache_utils.get_profile_value('org_id');--pn_mo_cache_utils.get_current_org_id;

3870: , x_return_status OUT NOCOPY VARCHAR2)
3871: IS
3872: l_lease_rec lease_rec;
3873: l_return_status VARCHAR2 (30) := NULL;
3874: l_org_id NUMBER := g_org_id;--pn_mo_cache_utils.get_profile_value('org_id');--pn_mo_cache_utils.get_current_org_id;
3875: l_term_template_type pn_term_templates_all.term_template_type%TYPE;
3876: l_api_name CONSTANT VARCHAR2 (30) := p_operation;
3877: l_api_name_full CONSTANT VARCHAR2 (61) := g_pkg_name || '.'|| l_api_name;
3878: l_error_flag VARCHAR2(1);

Line 11714: pn_mo_cache_utils.fnd_req_set_org_id (p_org_id);

11710: RETURN NUMBER
11711: AS
11712: l_requestid NUMBER;
11713: BEGIN
11714: pn_mo_cache_utils.fnd_req_set_org_id (p_org_id);
11715: l_requestid :=
11716: fnd_request.submit_request ('PN'
11717: , 'PNSCHITM'
11718: , NULL

Line 13804: pn_mo_cache_utils.fnd_req_set_org_id(p_org_id);

13800: END IF;
13801: END IF;
13802: ----------dbms_output.put_line('In FINALIZE_RECORD:1');
13803: commit; --Bug# 12692579 Added commit so that all changes are saved before invoking the concurrent program.
13804: pn_mo_cache_utils.fnd_req_set_org_id(p_org_id);
13805: ----------dbms_output.put_line('In FINALIZE_RECORD:2');
13806: x_request_id := fnd_request.submit_request ( 'PN',
13807: 'PNSCHITM',
13808: NULL,

Line 13971: , x_set_of_books_id => pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',g_org_id)--p_lease_terms_rec.set_of_books_id

13967: , x_customer_site_use_id => p_lease_terms_rec.customer_site_use_id
13968: , x_target_date => trunc(p_lease_terms_rec.target_date)
13969: , x_actual_amount => p_lease_terms_rec.actual_amount
13970: , x_estimated_amount => p_lease_terms_rec.estimated_amount
13971: , x_set_of_books_id => pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',g_org_id)--p_lease_terms_rec.set_of_books_id
13972: , x_currency_code => p_lease_terms_rec.currency_code
13973: , x_rate => p_lease_terms_rec.rate
13974: , x_normalize => p_lease_terms_rec.normalize
13975: , x_location_id => p_lease_terms_rec.location_id