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_MTM_ROLLFORWARD_PKG dependencies on PNP_DEBUG_PKG

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 51: pnp_debug_pkg.log('Lease Number Low : '||p_lease_no_low);

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);
55:

Line 52: pnp_debug_pkg.log('Lease Number Low : '||p_lease_no_high);

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);
55:
56: l_lease_ext_end_dt := fnd_date.canonical_to_date(p_lease_ext_end_dt);

Line 53: pnp_debug_pkg.log('Lease extension end date : '||p_lease_ext_end_dt);

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);
55:
56: l_lease_ext_end_dt := fnd_date.canonical_to_date(p_lease_ext_end_dt);
57:

Line 54: pnp_debug_pkg.log('Lease Option : '||p_lease_option);

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);
55:
56: l_lease_ext_end_dt := fnd_date.canonical_to_date(p_lease_ext_end_dt);
57:
58: IF l_lease_ext_end_dt IS NULL THEN

Line 100: /pnp_debug_pkg.log(' Q_lease_details :'||Q_lease_details);/

96: WHERE lease.lease_id = det.lease_id ';
97:
98: Q_lease_details := Q_lease_details || l_where_clause;
99:
100: /*pnp_debug_pkg.log(' Q_lease_details :'||Q_lease_details);*/
101:
102: dbms_sql.parse(l_cursor, Q_lease_details, dbms_sql.native);
103:
104: IF p_lease_no_low IS NOT NULL AND p_lease_no_high IS NOT NULL THEN

Line 192: pnp_debug_pkg.log(' invalid lease record ');

188: END IF;
189:
190: EXCEPTION
191: WHEN INVALID_LEASE_RECORD THEN
192: pnp_debug_pkg.log(' invalid lease record ');
193: l_fail := l_fail + 1;
194: END;
195: END LOOP;
196:

Line 202: pnp_debug_pkg.put_log_msg(fnd_message.get);

198: l_success := l_total - l_fail;
199:
200: fnd_message.set_name('PN', 'PN_CAFM_SPACE_SUCCESS');
201: fnd_message.set_token('SUCCESS', l_success);
202: pnp_debug_pkg.put_log_msg(fnd_message.get);
203:
204: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
205: fnd_message.set_token('FAILURE', l_fail);
206: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 206: pnp_debug_pkg.put_log_msg(fnd_message.get);

202: pnp_debug_pkg.put_log_msg(fnd_message.get);
203:
204: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
205: fnd_message.set_token('FAILURE', l_fail);
206: pnp_debug_pkg.put_log_msg(fnd_message.get);
207:
208: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
209: fnd_message.set_token('TOTAL', l_total);
210: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 210: pnp_debug_pkg.put_log_msg(fnd_message.get);

206: pnp_debug_pkg.put_log_msg(fnd_message.get);
207:
208: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
209: fnd_message.set_token('TOTAL', l_total);
210: pnp_debug_pkg.put_log_msg(fnd_message.get);
211:
212: END IF;
213:
214: IF dbms_sql.is_open (l_cursor) THEN

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

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

Line 223: pnp_debug_pkg.put_log_msg (errbuf);

219: EXCEPTION
220: WHEN INCORECT_LEASE_EXCEPTION THEN
221: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
222: errbuf := fnd_message.get;
223: pnp_debug_pkg.put_log_msg (errbuf);
224: retcode := 2;
225:
226: WHEN INCORRECT_EXTENSION_END_DATE THEN
227: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');

Line 229: pnp_debug_pkg.put_log_msg (errbuf);

225:
226: WHEN INCORRECT_EXTENSION_END_DATE THEN
227: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
228: errbuf := fnd_message.get;
229: pnp_debug_pkg.put_log_msg (errbuf);
230: retcode := 2;
231:
232: WHEN INCORRECT_LEASE_OPTION THEN
233: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');

Line 235: pnp_debug_pkg.put_log_msg (errbuf);

231:
232: WHEN INCORRECT_LEASE_OPTION THEN
233: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
234: errbuf := fnd_message.get;
235: pnp_debug_pkg.put_log_msg (errbuf);
236: retcode := 2;
237:
238: WHEN INVALID_LEASE_RECORD THEN
239: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');

Line 241: pnp_debug_pkg.put_log_msg (errbuf);

237:
238: WHEN INVALID_LEASE_RECORD THEN
239: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
240: errbuf := fnd_message.get;
241: pnp_debug_pkg.put_log_msg (errbuf);
242: retcode := 2;
243:
244: WHEN OTHERS THEN
245: Errbuf := SQLERRM;

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

336: l_attribute15 VARCHAR2(250);
337:
338: BEGIN
339:
340: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.create_amendment +Start+ (+)');
341:
342: FOR rec IN get_lease_details( p_lease_id ) LOOP
343: l_lease_num := rec.lease_num;
344: l_responsibleUser := rec.responsible_user;

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

453: ,x_attribute14 => l_attribute14
454: ,x_attribute15 => l_attribute15
455: );
456:
457: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.create_amendment +End+ (-)');
458:
459: END create_amendment;
460:
461:

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

515: l_lease_class_code VARCHAR2(30);
516: l_loc_type_code VARCHAR2(30);
517:
518: BEGIN
519: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +Start+ (+)');
520:
521: IF fnd_profile.value('PN_CHG_TEN_WHEN_LEASE_CHG') = 'Y' THEN
522:
523: <>

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

567:
568: END LOOP outer_loop;
569: END IF;
570:
571: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +End+ (-)');
572:
573: END ROLLFORWARD_TENANCIES;
574:
575: -------------------------------------------------------------------------------

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

589: l_lease_ext_dt_can VARCHAR2(100) := fnd_date.date_to_canonical(p_lease_ext_end_dt);
590: l_old_ext_dt_can VARCHAR2(100) := fnd_date.date_to_canonical(p_old_ext_end_dt);
591:
592: BEGIN
593: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_var_rent +Start+ (+)');
594:
595: l_requestId := fnd_request.submit_request ( 'PN',
596: 'PNVREXCO',
597: NULL,

Line 617: pnp_debug_pkg.put_log_msg(fnd_message.get);

613: );
614:
615: IF (l_requestId = 0 ) THEN
616: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
617: pnp_debug_pkg.put_log_msg(fnd_message.get);
618: ELSE
619: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
620: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
621: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 621: pnp_debug_pkg.put_log_msg(fnd_message.get);

617: pnp_debug_pkg.put_log_msg(fnd_message.get);
618: ELSE
619: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
620: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
621: pnp_debug_pkg.put_log_msg(fnd_message.get);
622: END IF;
623:
624: g_reqId_sched := null;
625: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_var_rent +End+ (-)');

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

621: pnp_debug_pkg.put_log_msg(fnd_message.get);
622: END IF;
623:
624: g_reqId_sched := null;
625: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_var_rent +End+ (-)');
626:
627: END ROLLFORWARD_VAR_RENT;
628:
629:

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

641: IS
642: l_requestId NUMBER := NULL;
643:
644: BEGIN
645: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_terms +Start+ (+)');
646:
647: l_requestId := fnd_request.submit_request ( 'PN',
648: 'PNSCHITM',
649: NULL,

Line 668: pnp_debug_pkg.put_log_msg(fnd_message.get);

664: );
665:
666: IF (l_requestId = 0 ) THEN
667: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
668: pnp_debug_pkg.put_log_msg(fnd_message.get);
669: ELSE
670: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
671: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
672: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 672: pnp_debug_pkg.put_log_msg(fnd_message.get);

668: pnp_debug_pkg.put_log_msg(fnd_message.get);
669: ELSE
670: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
671: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
672: pnp_debug_pkg.put_log_msg(fnd_message.get);
673: END IF;
674:
675: g_reqId_sched := l_requestId;
676: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_terms +End+ (-)');

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

672: pnp_debug_pkg.put_log_msg(fnd_message.get);
673: END IF;
674:
675: g_reqId_sched := l_requestId;
676: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_terms +End+ (-)');
677:
678: END ROLLFORWARD_TERMS;
679:
680:

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

726:
727:
728: BEGIN
729:
730: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.print_output +Start+ (+)');
731:
732: fnd_message.set_name ('PN','PN_ROLFWD_PROP');
733: l_message := fnd_message.get||' ';
734: fnd_message.set_name ('PN','PN_ROLFWD_LOC');

Line 748: pnp_debug_pkg.put_log_msg(l_message);

744: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
745: l_message := l_message||fnd_message.get||' ';
746: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
747: l_message := l_message||fnd_message.get||' ';
748: pnp_debug_pkg.put_log_msg(l_message);
749:
750: pnp_debug_pkg.put_log_msg
751: ('============== '
752: ||' ============= '

Line 750: pnp_debug_pkg.put_log_msg

746: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
747: l_message := l_message||fnd_message.get||' ';
748: pnp_debug_pkg.put_log_msg(l_message);
749:
750: pnp_debug_pkg.put_log_msg
751: ('============== '
752: ||' ============= '
753: ||' ========= '
754: ||' ====================== '

Line 763: pnp_debug_pkg.put_log_msg(rec.property_name || ' '

759: );
760:
761: FOR rec IN get_lease_details (p_lease_id) LOOP
762:
763: pnp_debug_pkg.put_log_msg(rec.property_name || ' '
764: ||rec.location_name|| ' '
765: ||rec.lease_num || ' '
766: ||TO_CHAR(rec.lease_termination_date) || ' '
767: ||TO_CHAR(rec.lease_extension_end_date)|| ' '

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

771: );
772:
773: END LOOP;
774:
775: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.print_output +End+ (-)');
776:
777: END PRINT_OUTPUT;
778:
779: