196:
197: IF l_total <> 0 THEN
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');
197: IF l_total <> 0 THEN
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);
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);
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);
207:
208: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
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);
207:
208: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
209: fnd_message.set_token('TOTAL', l_total);
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);
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);
211:
212: END IF;
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);
211:
212: END IF;
213:
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
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;
223: pnp_debug_pkg.put_log_msg (errbuf);
224: retcode := 2;
225:
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;
223: pnp_debug_pkg.put_log_msg (errbuf);
224: retcode := 2;
225:
226: WHEN INCORRECT_EXTENSION_END_DATE THEN
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');
228: errbuf := fnd_message.get;
229: pnp_debug_pkg.put_log_msg (errbuf);
230: retcode := 2;
231:
224: retcode := 2;
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
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');
234: errbuf := fnd_message.get;
235: pnp_debug_pkg.put_log_msg (errbuf);
236: retcode := 2;
237:
230: retcode := 2;
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
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');
240: errbuf := fnd_message.get;
241: pnp_debug_pkg.put_log_msg (errbuf);
242: retcode := 2;
243:
236: retcode := 2;
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
612: '', '', '', '', ''
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);
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);
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);
622: END IF;
623:
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);
622: END IF;
623:
624: g_reqId_sched := null;
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+ (-)');
663: '', '', '', '', '', ''
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);
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);
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);
673: END IF;
674:
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);
673: END IF;
674:
675: g_reqId_sched := l_requestId;
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+ (-)');
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');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
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');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
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');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
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');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
732: fnd_message.set_name ('PN','PN_ROLFWD_PROP');
733: l_message := fnd_message.get||' ';
734: fnd_message.set_name ('PN','PN_ROLFWD_LOC');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
733: l_message := fnd_message.get||' ';
734: fnd_message.set_name ('PN','PN_ROLFWD_LOC');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
734: fnd_message.set_name ('PN','PN_ROLFWD_LOC');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
735: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
736: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
744: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
737: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
744: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
745: l_message := l_message||fnd_message.get||' ';
738: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
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');
739: l_message := l_message||fnd_message.get||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
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||' ';
740: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
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);
741: l_message := l_message||fnd_message.get||' ';
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
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:
742: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
743: l_message := l_message||fnd_message.get||' ';
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
743: l_message := l_message||fnd_message.get||' ';
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: ('============== '