APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_MTM_ROLLFORWARD_PKG

Line 1: PACKAGE BODY PN_MTM_ROLLFORWARD_PKG AS

1: PACKAGE BODY PN_MTM_ROLLFORWARD_PKG AS
2: /* $Header: PNRLFWDB.pls 120.0 2007/10/03 14:25:07 rthumma noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCEDURE : ROLLFORWARD_LEASES

Line 50: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_leases +Start+ (+)');

46: l_lease_change_id NUMBER;
47:
48: BEGIN
49:
50: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_leases +Start+ (+)');
51: pnp_debug_pkg.log('Lease Number Low : '||p_lease_no_low);
52: pnp_debug_pkg.log('Lease Number Low : '||p_lease_no_high);
53: pnp_debug_pkg.log('Lease extension end date : '||p_lease_ext_end_dt);
54: pnp_debug_pkg.log('Lease Option : '||p_lease_option);

Line 217: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_leases +End+ (-)');

213: IF dbms_sql.is_open (l_cursor) THEN
214: dbms_sql.close_cursor (l_cursor);
215: END IF;
216:
217: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_leases +End+ (-)');
218: EXCEPTION
219: WHEN INCORECT_LEASE_EXCEPTION THEN
220: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
221: errbuf := fnd_message.get;

Line 307: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.create_amendment +Start+ (+)');

303: l_leaseExecutionDate DATE;
304:
305: BEGIN
306:
307: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.create_amendment +Start+ (+)');
308:
309: FOR rec IN get_lease_details( p_lease_id ) LOOP
310: l_lease_num := rec.lease_num;
311: l_responsibleUser := rec.responsible_user;

Line 408: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.create_amendment +End+ (-)');

404: ,x_attribute14 => NULL
405: ,x_attribute15 => NULL
406: );
407:
408: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.create_amendment +End+ (-)');
409:
410: END create_amendment;
411:
412:

Line 468: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +Start+ (+)');

464: l_lease_class_code VARCHAR2(30);
465: l_loc_type_code VARCHAR2(30);
466:
467: BEGIN
468: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +Start+ (+)');
469:
470: IF fnd_profile.value('PN_CHG_TEN_WHEN_LEASE_CHG') = 'Y' THEN
471:
472: <>

Line 520: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +End+ (-)');

516:
517: END LOOP outer_loop;
518: END IF;
519:
520: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +End+ (-)');
521:
522: END ROLLFORWARD_TENANCIES;
523:
524: -------------------------------------------------------------------------------

Line 542: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_var_rent +Start+ (+)');

538: l_lease_ext_dt_can VARCHAR2(100) := fnd_date.date_to_canonical(p_lease_ext_end_dt);
539: l_old_ext_dt_can VARCHAR2(100) := fnd_date.date_to_canonical(p_old_ext_end_dt);
540:
541: BEGIN
542: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_var_rent +Start+ (+)');
543:
544: l_requestId := fnd_request.submit_request ( 'PN',
545: 'PNVREXCO',
546: NULL,

Line 573: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_var_rent +End+ (-)');

569: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
570: pnp_debug_pkg.put_log_msg(fnd_message.get);
571: END IF;
572:
573: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_var_rent +End+ (-)');
574:
575: END ROLLFORWARD_VAR_RENT;
576:
577:

Line 593: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_terms +Start+ (+)');

589: IS
590: l_requestId NUMBER := NULL;
591:
592: BEGIN
593: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_terms +Start+ (+)');
594:
595: l_requestId := fnd_request.submit_request ( 'PN',
596: 'PNSCHITM',
597: NULL,

Line 623: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_terms +End+ (-)');

619: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
620: pnp_debug_pkg.put_log_msg(fnd_message.get);
621: END IF;
622:
623: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_terms +End+ (-)');
624:
625: END ROLLFORWARD_TERMS;
626:
627:

Line 677: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.print_output +Start+ (+)');

673:
674:
675: BEGIN
676:
677: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.print_output +Start+ (+)');
678:
679: fnd_message.set_name ('PN','PN_ROLFWD_PROP');
680: l_message := fnd_message.get||' ';
681: fnd_message.set_name ('PN','PN_ROLFWD_LOC');

Line 722: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.print_output +End+ (-)');

718: );
719:
720: END LOOP;
721:
722: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.print_output +End+ (-)');
723:
724: END PRINT_OUTPUT;
725:
726:

Line 727: END PN_MTM_ROLLFORWARD_PKG;

723:
724: END PRINT_OUTPUT;
725:
726:
727: END PN_MTM_ROLLFORWARD_PKG;