195:
196: IF l_total <> 0 THEN
197: l_success := l_total - l_fail;
198:
199: fnd_message.set_name('PN', 'PN_CAFM_SPACE_SUCCESS');
200: fnd_message.set_token('SUCCESS', l_success);
201: pnp_debug_pkg.put_log_msg(fnd_message.get);
202:
203: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
196: IF l_total <> 0 THEN
197: l_success := l_total - l_fail;
198:
199: fnd_message.set_name('PN', 'PN_CAFM_SPACE_SUCCESS');
200: fnd_message.set_token('SUCCESS', l_success);
201: pnp_debug_pkg.put_log_msg(fnd_message.get);
202:
203: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
204: fnd_message.set_token('FAILURE', l_fail);
197: l_success := l_total - l_fail;
198:
199: fnd_message.set_name('PN', 'PN_CAFM_SPACE_SUCCESS');
200: fnd_message.set_token('SUCCESS', l_success);
201: pnp_debug_pkg.put_log_msg(fnd_message.get);
202:
203: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
204: fnd_message.set_token('FAILURE', l_fail);
205: pnp_debug_pkg.put_log_msg(fnd_message.get);
199: fnd_message.set_name('PN', 'PN_CAFM_SPACE_SUCCESS');
200: fnd_message.set_token('SUCCESS', l_success);
201: pnp_debug_pkg.put_log_msg(fnd_message.get);
202:
203: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
204: fnd_message.set_token('FAILURE', l_fail);
205: pnp_debug_pkg.put_log_msg(fnd_message.get);
206:
207: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
200: fnd_message.set_token('SUCCESS', l_success);
201: pnp_debug_pkg.put_log_msg(fnd_message.get);
202:
203: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
204: fnd_message.set_token('FAILURE', l_fail);
205: pnp_debug_pkg.put_log_msg(fnd_message.get);
206:
207: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
208: fnd_message.set_token('TOTAL', l_total);
201: pnp_debug_pkg.put_log_msg(fnd_message.get);
202:
203: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
204: fnd_message.set_token('FAILURE', l_fail);
205: pnp_debug_pkg.put_log_msg(fnd_message.get);
206:
207: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
208: fnd_message.set_token('TOTAL', l_total);
209: pnp_debug_pkg.put_log_msg(fnd_message.get);
203: fnd_message.set_name('PN', 'PN_CAFM_SPACE_FAILURE');
204: fnd_message.set_token('FAILURE', l_fail);
205: pnp_debug_pkg.put_log_msg(fnd_message.get);
206:
207: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
208: fnd_message.set_token('TOTAL', l_total);
209: pnp_debug_pkg.put_log_msg(fnd_message.get);
210:
211: END IF;
204: fnd_message.set_token('FAILURE', l_fail);
205: pnp_debug_pkg.put_log_msg(fnd_message.get);
206:
207: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
208: fnd_message.set_token('TOTAL', l_total);
209: pnp_debug_pkg.put_log_msg(fnd_message.get);
210:
211: END IF;
212:
205: pnp_debug_pkg.put_log_msg(fnd_message.get);
206:
207: fnd_message.set_name('PN', 'PN_CAFM_SPACE_TOTAL');
208: fnd_message.set_token('TOTAL', l_total);
209: pnp_debug_pkg.put_log_msg(fnd_message.get);
210:
211: END IF;
212:
213: IF dbms_sql.is_open (l_cursor) THEN
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;
222: pnp_debug_pkg.put_log_msg (errbuf);
223: retcode := 2;
224:
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;
222: pnp_debug_pkg.put_log_msg (errbuf);
223: retcode := 2;
224:
225: WHEN INCORRECT_EXTENSION_END_DATE THEN
222: pnp_debug_pkg.put_log_msg (errbuf);
223: retcode := 2;
224:
225: WHEN INCORRECT_EXTENSION_END_DATE THEN
226: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
227: errbuf := fnd_message.get;
228: pnp_debug_pkg.put_log_msg (errbuf);
229: retcode := 2;
230:
223: retcode := 2;
224:
225: WHEN INCORRECT_EXTENSION_END_DATE THEN
226: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
227: errbuf := fnd_message.get;
228: pnp_debug_pkg.put_log_msg (errbuf);
229: retcode := 2;
230:
231: WHEN INCORRECT_LEASE_OPTION THEN
228: pnp_debug_pkg.put_log_msg (errbuf);
229: retcode := 2;
230:
231: WHEN INCORRECT_LEASE_OPTION THEN
232: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
233: errbuf := fnd_message.get;
234: pnp_debug_pkg.put_log_msg (errbuf);
235: retcode := 2;
236:
229: retcode := 2;
230:
231: WHEN INCORRECT_LEASE_OPTION THEN
232: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
233: errbuf := fnd_message.get;
234: pnp_debug_pkg.put_log_msg (errbuf);
235: retcode := 2;
236:
237: WHEN INVALID_LEASE_RECORD THEN
234: pnp_debug_pkg.put_log_msg (errbuf);
235: retcode := 2;
236:
237: WHEN INVALID_LEASE_RECORD THEN
238: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
239: errbuf := fnd_message.get;
240: pnp_debug_pkg.put_log_msg (errbuf);
241: retcode := 2;
242:
235: retcode := 2;
236:
237: WHEN INVALID_LEASE_RECORD THEN
238: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
239: errbuf := fnd_message.get;
240: pnp_debug_pkg.put_log_msg (errbuf);
241: retcode := 2;
242:
243: WHEN OTHERS THEN
561: '', '', '', '', '', ''
562: );
563:
564: IF (l_requestId = 0 ) THEN
565: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
566: pnp_debug_pkg.put_log_msg(fnd_message.get);
567: ELSE
568: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
569: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
562: );
563:
564: IF (l_requestId = 0 ) THEN
565: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
566: pnp_debug_pkg.put_log_msg(fnd_message.get);
567: ELSE
568: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
569: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
570: pnp_debug_pkg.put_log_msg(fnd_message.get);
564: IF (l_requestId = 0 ) THEN
565: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
566: pnp_debug_pkg.put_log_msg(fnd_message.get);
567: ELSE
568: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
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:
565: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
566: pnp_debug_pkg.put_log_msg(fnd_message.get);
567: ELSE
568: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
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+ (-)');
566: pnp_debug_pkg.put_log_msg(fnd_message.get);
567: ELSE
568: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
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:
611: '', '', '', '', '', ''
612: );
613:
614: IF (l_requestId = 0 ) THEN
615: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
616: pnp_debug_pkg.put_log_msg(fnd_message.get);
617: ELSE
618: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
619: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
612: );
613:
614: IF (l_requestId = 0 ) THEN
615: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
616: pnp_debug_pkg.put_log_msg(fnd_message.get);
617: ELSE
618: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
619: fnd_message.set_token ( 'REQUEST_ID', TO_CHAR(l_requestId), FALSE);
620: pnp_debug_pkg.put_log_msg(fnd_message.get);
614: IF (l_requestId = 0 ) THEN
615: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
616: pnp_debug_pkg.put_log_msg(fnd_message.get);
617: ELSE
618: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
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:
615: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
616: pnp_debug_pkg.put_log_msg(fnd_message.get);
617: ELSE
618: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
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+ (-)');
616: pnp_debug_pkg.put_log_msg(fnd_message.get);
617: ELSE
618: fnd_message.set_name ( 'PN', 'PN_REQUEST_SUBMITTED' );
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:
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');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
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');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
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');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
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');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
679: fnd_message.set_name ('PN','PN_ROLFWD_PROP');
680: l_message := fnd_message.get||' ';
681: fnd_message.set_name ('PN','PN_ROLFWD_LOC');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
680: l_message := fnd_message.get||' ';
681: fnd_message.set_name ('PN','PN_ROLFWD_LOC');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
681: fnd_message.set_name ('PN','PN_ROLFWD_LOC');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
682: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
683: fnd_message.set_name ('PN','PN_ROLFWD_LEASE_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
684: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
692: l_message := l_message||fnd_message.get||' ';
685: fnd_message.set_name ('PN','PN_ROLFWD_TRM_DATE');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
692: l_message := l_message||fnd_message.get||' ';
693: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
686: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
692: l_message := l_message||fnd_message.get||' ';
693: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
694: l_message := l_message||fnd_message.get||' ';
687: fnd_message.set_name ('PN','PN_ROLFWD_EXT_DATE');
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
692: l_message := l_message||fnd_message.get||' ';
693: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
694: l_message := l_message||fnd_message.get||' ';
695: pnp_debug_pkg.put_log_msg(l_message);
688: l_message := l_message||fnd_message.get||' ';
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
692: l_message := l_message||fnd_message.get||' ';
693: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
694: l_message := l_message||fnd_message.get||' ';
695: pnp_debug_pkg.put_log_msg(l_message);
696:
689: fnd_message.set_name ('PN','PN_ROLFWD_CHARGE');
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
692: l_message := l_message||fnd_message.get||' ';
693: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
694: l_message := l_message||fnd_message.get||' ';
695: pnp_debug_pkg.put_log_msg(l_message);
696:
697: pnp_debug_pkg.put_log_msg
690: l_message := l_message||fnd_message.get||' ';
691: fnd_message.set_name ('PN','PN_ROLFWD_INDEX_NUM');
692: l_message := l_message||fnd_message.get||' ';
693: fnd_message.set_name ('PN','PN_ROLFWD_VAR_NUM');
694: l_message := l_message||fnd_message.get||' ';
695: pnp_debug_pkg.put_log_msg(l_message);
696:
697: pnp_debug_pkg.put_log_msg
698: ('============== '