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 STANDARD

Line 487: -- Standard start of API savepoint

483: BEGIN
484: ----------------------dbms_output.put_line('In VALIDATE_TENANCIES_TBL procedure of PVT package');--Rupak
485: pvt_debug(g_pkg_name||'-VALIDATE_TENANCIES_TBL:Procedure Begin',3);
486:
487: -- Standard start of API savepoint
488: SAVEPOINT validate_tenancies_tbl;
489: -- Initialize the return status.
490: x_return_status := fnd_api.g_ret_sts_success;
491: l_tenancy_record_cnt := p_lease_tenancies_tbl.COUNT;

Line 1516: -- Standard start of API savepoint

1512: q NUMBER:=NULL;
1513: BEGIN
1514: pvt_debug(g_pkg_name||'-UPDATE_TENANCIES_TBL:Procedure Begin',3);
1515:
1516: -- Standard start of API savepoint
1517: -- Initialize the return status.
1518: x_return_status := fnd_api.g_ret_sts_success;
1519:
1520: l_lease_rec.lease_id := p_lease_id;

Line 2372: -- Standard start of API savepoint

2368: l_lastupdatedate DATE := NULL;
2369: l_leaseextensionenddate DATE := NULL;
2370: l_leasechangeid pn_lease_details.lease_change_id%TYPE;
2371: BEGIN
2372: -- Standard start of API savepoint
2373: SAVEPOINT update_lease_pvt;
2374:
2375: -- Initialize message list if p_init_msg_list is set to TRUE
2376: IF fnd_api.to_boolean (p_init_msg_list)

Line 2382: pvt_debug(g_pkg_name||'-DIRECT_UPDATE_LEASE:Updating the Lease Record by calling the standard Package',3);

2378: fnd_msg_pub.initialize;
2379: END IF;
2380:
2381:
2382: pvt_debug(g_pkg_name||'-DIRECT_UPDATE_LEASE:Updating the Lease Record by calling the standard Package',3);
2383: -- Initialize the return status.
2384: x_return_status := fnd_api.g_ret_sts_success;
2385: l_lastupdatedate := p_last_update_date;
2386: l_leasecommencementdate := p_lease_commencement_date;

Line 2502: -- Standard start of API savepoint

2498: l_changecommencementdate DATE := NULL;
2499: l_changeterminationdate DATE := NULL;
2500: l_changeexecutiondate DATE := NULL;
2501: BEGIN
2502: -- Standard start of API savepoint
2503: SAVEPOINT amend_lease_pvt;
2504:
2505: -- Initialize message list if p_init_msg_list is set to TRUE
2506: IF fnd_api.to_boolean (p_init_msg_list)

Line 2592: -- Standard start of API savepoint

2588: l_creationdate DATE := p_creation_date;
2589: l_leasechangenumber NUMBER := NULL;
2590: l_org_id NUMBER;
2591: BEGIN
2592: -- Standard start of API savepoint
2593: SAVEPOINT edit_lease_pvt;
2594:
2595: -- Initialize message list if p_init_msg_list is set to TRUE
2596: IF fnd_api.to_boolean (p_init_msg_list)

Line 3043: pvt_debug(g_pkg_name||'-INSERT_TENANCIES_ROW:Before Calling Standard tenancies package:insert_row',3);

3039: END IF;
3040: p_lease_tenancies_rec.allocated_area := l_loc_area;
3041: END IF;
3042:
3043: pvt_debug(g_pkg_name||'-INSERT_TENANCIES_ROW:Before Calling Standard tenancies package:insert_row',3);
3044:
3045: /*********************************************************************************************************************************************/
3046: INIT_TENANCIES_REC( p_lease_tenancies_rec => p_lease_tenancies_rec
3047: , p_lease_context => p_lease_context

Line 3376: -- Standard start of API savepoint

3372: l_error_flag VARCHAR2 (1);
3373: l_err_contact_count NUMBER := 0;
3374: BEGIN
3375:
3376: -- Standard start of API savepoint
3377: SAVEPOINT validate_contacts_tbl;
3378:
3379: -- Initialize message list if p_init_msg_list is set to TRUE
3380: -- IF fnd_api.to_boolean (p_init_msg_list)

Line 3884: -- Standard start of API savepoint

3880: l_pro_rule VARCHAR2(100);
3881: BEGIN
3882: ----------------------dbms_output.put_line ('In VALIDATE_LEASE_REC procedure of PVT package');--Rupak
3883: pvt_debug(g_pkg_name||'-Inside VALIDATE_LEASE_REC:'||x_return_status,3);
3884: -- Standard start of API savepoint
3885: SAVEPOINT validate_lease_rec;
3886: -- Initialize message list if p_init_msg_list is set to TRUE
3887: -- IF fnd_api.to_boolean (p_init_msg_list)
3888: -- THEN

Line 11975: -- Standard start of API savepoint

11971: l_lease_status_new pn_leases_all.lease_status%TYPE := NULL;
11972: BEGIN
11973: l_lease_context := NVL(p_lease_context,'UPD');
11974: g_lease_context := l_lease_context;
11975: -- Standard start of API savepoint
11976: SAVEPOINT update_lease_pvt;
11977:
11978: -- Initialize message list if p_init_msg_list is set to TRUE
11979: IF fnd_api.to_boolean (p_init_msg_list)

Line 13355: -- Standard check of p_commit

13351: fnd_msg_pub.ADD;
13352: RAISE fnd_api.g_exc_error;
13353: END IF;
13354:
13355: -- Standard check of p_commit
13356: ----------------------dbms_output.put_line('In Update Private 11');--Rupak
13357:
13358: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
13359: , p_count => x_msg_count

Line 14304: -- Standard start of API savepoint

14300:
14301:
14302: BEGIN
14303: --.put_line('In validate_payment_terms_tbl:1');--Rupak
14304: -- Standard start of API savepoint
14305: SAVEPOINT validate_payment_terms_tbl;
14306: -- Initialize the return status.
14307: x_return_status := FND_API.G_RET_STS_SUCCESS;--OOPS(RHIA)
14308:

Line 16765: -- Standard start of API savepoint

16761: BEGIN
16762: ----------------------dbms_output.put_line (' IN Private :In Procedure:update_lease FIRST');--Rupak
16763: x_return_status := fnd_api.g_ret_sts_success;
16764: pvt_debug(g_pkg_name||'-Inside UPDATE_TERMS:',3);
16765: -- Standard start of API savepoint
16766: SAVEPOINT update_payment_pvt;
16767:
16768: -- Initialize message list if p_init_msg_list is set to TRUE
16769: IF fnd_api.to_boolean (p_init_msg_list)

Line 16774: -- Standard call to check for call compatibility

16770: THEN
16771: fnd_msg_pub.initialize;
16772: END IF;
16773:
16774: -- Standard call to check for call compatibility
16775: IF NOT fnd_api.compatible_api_call (l_api_version
16776: , p_api_version
16777: , l_api_name
16778: , g_pkg_name

Line 17785: -- Standard start of API savepoint

17781: x_request_id NUMBER:=NULL;
17782:
17783: l_locations_count NUMBER := 0;
17784: BEGIN
17785: -- Standard start of API savepoint
17786: SAVEPOINT insert_payment_pvt;
17787:
17788: -- Initialize message list if p_init_msg_list is set to TRUE
17789: IF fnd_api.to_boolean (p_init_msg_list)

Line 17794: -- Standard call to check for call compatibility

17790: THEN
17791: fnd_msg_pub.initialize;
17792: END IF;
17793:
17794: -- Standard call to check for call compatibility
17795: IF NOT fnd_api.compatible_api_call (l_api_version
17796: , p_api_version
17797: , l_api_name
17798: , g_pkg_name

Line 18876: --Initiate Approval Workflow if profile option value for 'PN: Use Lease Approval Workflow' is set to 'Y' else submit the standard concurrent request

18872: IF p_new_approval_status_code='F' AND l_approval_status_old='D' -- Location Exists
18873: AND l_location_exists='Y'
18874: THEN
18875:
18876: --Initiate Approval Workflow if profile option value for 'PN: Use Lease Approval Workflow' is set to 'Y' else submit the standard concurrent request
18877: IF NVL(fnd_profile.VALUE ('PN_LEASE_APPROVAL_WORKFLOW'),'N') ='Y'
18878: THEN
18879:
18880: --dbms_output.put_line('Updating status to Submitted');

Line 18931: -- Submit the standard concurrent request to Schedule items

18927: , 5);
18928: x_return_status := fnd_api.g_ret_sts_unexp_error;
18929: END;
18930:
18931: -- Submit the standard concurrent request to Schedule items
18932:
18933: l_request_id := fnd_request.submit_request ('PN',
18934: 'PNSCHITM',
18935: NULL,