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

Line 160: pnp_debug_pkg.log(' l_amd_comn_date : ' || l_amd_comn_date );

156: FROM pn_lease_details_all
157: WHERE lease_id = p_lease_id;
158: END IF;
159:
160: pnp_debug_pkg.log(' l_amd_comn_date : ' || l_amd_comn_date );
161: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
162:
163: IF l_amd_comn_date > p_norm_str_dt THEN /* 6893609 */
164: l_amd_comn_date_tmp := p_norm_str_dt;

Line 161: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );

157: WHERE lease_id = p_lease_id;
158: END IF;
159:
160: pnp_debug_pkg.log(' l_amd_comn_date : ' || l_amd_comn_date );
161: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
162:
163: IF l_amd_comn_date > p_norm_str_dt THEN /* 6893609 */
164: l_amd_comn_date_tmp := p_norm_str_dt;
165: ELSE

Line 182: pnp_debug_pkg.log('l_app_amt : ' || l_app_amt);

178: AND schedule_date >= pn_schedules_items.FIRST_DAY(l_amd_comn_date_tmp); /* 8491119 */
179: --AND schedule_date <= (SELECT last_day(lease_termination_date) from /* 11742270 */
180: --pn_lease_details_all where lease_id = p_lease_id );
181:
182: pnp_debug_pkg.log('l_app_amt : ' || l_app_amt);
183:
184: --Draft schedules should not be deleted before ACD
185: --Fix for bug#14143342
186: SELECT NVL(SUM(ppi.actual_amount),0)

Line 196: pnp_debug_pkg.log('l_dft_amt : ' || l_dft_amt);

192: AND pps.payment_schedule_id = ppi.payment_schedule_id
193: AND pps.payment_status_lookup_code = 'DRAFT'
194: AND schedule_date < pn_schedules_items.FIRST_DAY(l_amd_comn_date_tmp);
195:
196: pnp_debug_pkg.log('l_dft_amt : ' || l_dft_amt);
197:
198: Select NVL(SUM(ppi.actual_amount),0)
199: into l_term_amt
200: FROM pn_payment_items_all ppi,

Line 208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');

204: AND pps.payment_schedule_id = ppi.payment_schedule_id
205: AND pps.payment_status_lookup_code <> 'DRAFT'
206: AND to_char(schedule_date,'MON-YY') = to_char(l_amd_comn_date,'MON-YY'); /* 8491119 */
207:
208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
209: pnp_debug_pkg.log(' Procedure called with Parameters... ');
210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );

Line 209: pnp_debug_pkg.log(' Procedure called with Parameters... ');

205: AND pps.payment_status_lookup_code <> 'DRAFT'
206: AND to_char(schedule_date,'MON-YY') = to_char(l_amd_comn_date,'MON-YY'); /* 8491119 */
207:
208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
209: pnp_debug_pkg.log(' Procedure called with Parameters... ');
210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );

Line 210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );

206: AND to_char(schedule_date,'MON-YY') = to_char(l_amd_comn_date,'MON-YY'); /* 8491119 */
207:
208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
209: pnp_debug_pkg.log(' Procedure called with Parameters... ');
210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );

Line 211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );

207:
208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
209: pnp_debug_pkg.log(' Procedure called with Parameters... ');
210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );

Line 212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );

208: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (+) ');
209: pnp_debug_pkg.log(' Procedure called with Parameters... ');
210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );

Line 213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );

209: pnp_debug_pkg.log(' Procedure called with Parameters... ');
210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );

Line 214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );

210: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );

Line 215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );

211: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );

Line 216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );

212: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );

Line 217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );

213: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );

Line 218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );

214: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
222: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );

Line 219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );

215: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
222: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
223: pnp_debug_pkg.log(' p_rate : ' || p_rate );

Line 220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );

216: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
222: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
223: pnp_debug_pkg.log(' p_rate : ' || p_rate );
224:

Line 221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );

217: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
222: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
223: pnp_debug_pkg.log(' p_rate : ' || p_rate );
224:
225: /* initilizations*/

Line 222: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );

218: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
222: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
223: pnp_debug_pkg.log(' p_rate : ' || p_rate );
224:
225: /* initilizations*/
226: l_partial_start_flag := FALSE;

Line 223: pnp_debug_pkg.log(' p_rate : ' || p_rate );

219: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
220: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
221: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
222: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
223: pnp_debug_pkg.log(' p_rate : ' || p_rate );
224:
225: /* initilizations*/
226: l_partial_start_flag := FALSE;
227: l_partial_end_flag := FALSE;

Line 238: pnp_debug_pkg.log('l_cash_total : '||TO_CHAR(l_cash_total));

234: FOR get_cash_rec IN get_cash_total LOOP
235: l_cash_total := get_cash_rec.total_cash_amount;
236: END LOOP;
237:
238: pnp_debug_pkg.log('l_cash_total : '||TO_CHAR(l_cash_total));
239:
240: FOR get_norm_rec IN get_norm_total LOOP
241: l_norm_apprv_total := get_norm_rec.total_norm_amount;
242: END LOOP;

Line 243: pnp_debug_pkg.log(' l_norm_apprv_total : '||TO_CHAR( l_norm_apprv_total));

239:
240: FOR get_norm_rec IN get_norm_total LOOP
241: l_norm_apprv_total := get_norm_rec.total_norm_amount;
242: END LOOP;
243: pnp_debug_pkg.log(' l_norm_apprv_total : '||TO_CHAR( l_norm_apprv_total));
244:
245: --asahoo setting Leave alone amount to Zero incase of Contraction and Expansion
246: --Fix for bug#14143342
247: --IF (p_lease_context in ('CON','EXP')) THEN

Line 253: pnp_debug_pkg.log(' leave alone amount : '||TO_CHAR( l_norm_apprv_total));

249: --ELSE
250: l_norm_apprv_total := l_norm_apprv_total - NVL(l_app_amt,0) + l_dft_amt; /* 6893609 */
251: --END IF;
252:
253: pnp_debug_pkg.log(' leave alone amount : '||TO_CHAR( l_norm_apprv_total));
254:
255: /* find which day of month the lease starts.*/
256: l_day_of_norm_start_dt := TO_CHAR(p_norm_str_dt,'DD');
257:

Line 284: pnp_debug_pkg.log('create_normalize_items - l_partial_start_fraction - 1 : '

280: l_partial_start_fraction := ((LAST_DAY(p_norm_str_dt) - p_norm_str_dt)+1)*12/g_pr_rule;
281: END IF;
282: l_norm_months := (l_norm_months - 1) + NVL(l_partial_start_fraction,0);
283:
284: pnp_debug_pkg.log('create_normalize_items - l_partial_start_fraction - 1 : '
285: ||TO_CHAR(l_partial_start_fraction)); /* 8491119 */
286:
287: END IF; /* 6893609 */
288:

Line 298: pnp_debug_pkg.log('create_normalize_items - l_partial_end_fraction - 1 : '

294: IF g_pr_rule = 999 THEN
295: l_partial_end_fraction := TO_NUMBER(TO_CHAR(p_norm_end_dt,'DD'))/
296: TO_NUMBER(TO_CHAR(LAST_DAY(p_norm_end_dt),'DD'));
297:
298: pnp_debug_pkg.log('create_normalize_items - l_partial_end_fraction - 1 : '
299: ||TO_CHAR(l_partial_end_fraction)); /* 6893609 */
300: ELSE
301: l_partial_end_fraction := TO_NUMBER(TO_CHAR(p_norm_end_dt,'DD'))*12/g_pr_rule;
302:

Line 303: pnp_debug_pkg.log('create_normalize_items - l_partial_end_fraction - 2 : '

299: ||TO_CHAR(l_partial_end_fraction)); /* 6893609 */
300: ELSE
301: l_partial_end_fraction := TO_NUMBER(TO_CHAR(p_norm_end_dt,'DD'))*12/g_pr_rule;
302:
303: pnp_debug_pkg.log('create_normalize_items - l_partial_end_fraction - 2 : '
304: ||TO_CHAR(l_partial_end_fraction)); /* 6893609 */
305: END IF;
306: l_norm_months := (l_norm_months - 1) + NVL(l_partial_end_fraction,0);
307: END IF;

Line 309: pnp_debug_pkg.log('l_norm_months : '||TO_CHAR(l_norm_months));

305: END IF;
306: l_norm_months := (l_norm_months - 1) + NVL(l_partial_end_fraction,0);
307: END IF;
308:
309: pnp_debug_pkg.log('l_norm_months : '||TO_CHAR(l_norm_months));
310:
311: /* calculate new normalized amount */
312: IF l_norm_months <= 1 THEN
313: l_new_normalized_amount := l_cash_total - l_norm_apprv_total ; /* 8491119 */

Line 320: pnp_debug_pkg.log('l_new_normalized_amount : '||TO_CHAR(l_new_normalized_amount));

316: ELSE
317: l_new_normalized_amount := (l_cash_total - l_norm_apprv_total)/l_norm_months; /* 8491119 */
318: END IF;
319:
320: pnp_debug_pkg.log('l_new_normalized_amount : '||TO_CHAR(l_new_normalized_amount));
321:
322: /*populate the pl/sql table */
323: FOR i IN 0 .. g_norm_item_tbl.COUNT - 1 LOOP
324: g_norm_item_tbl(i).normalized_amount := l_new_normalized_amount;

Line 495: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');

491: l_cash_item:=1;
492: END LOOP;
493:
494: IF l_cash_item = 0 THEN
495: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
496: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
497: pn_schedules_items.create_cash_items
498: (p_est_amt => 0,
499: p_act_amt => 0,

Line 496: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);

492: END LOOP;
493:
494: IF l_cash_item = 0 THEN
495: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
496: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
497: pn_schedules_items.create_cash_items
498: (p_est_amt => 0,
499: p_act_amt => 0,
500: p_sch_dt => g_norm_item_tbl(i).schedule_date,

Line 511: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');

507: p_cust_ship_site_id => p_cust_ship_site_id,
508: p_sob_id => p_sob_id,
509: p_curr_code => p_curr_code,
510: p_rate => p_rate);
511: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');
512: END IF;
513:
514: /*E.N. Bug 4956314 */
515:

Line 526: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (-) ');

522: norm_end_date = p_norm_end_dt
523: WHERE normalize ='Y'
524: AND payment_term_id = p_term_id;
525:
526: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (-) ');
527: EXCEPTION
528: WHEN OTHERS THEN
529: pnp_debug_pkg.log(' RENORMALIZE_ACROSS_ALL_DRAFT - OTHERS ERROR ... ' || sqlerrm);
530:

Line 529: pnp_debug_pkg.log(' RENORMALIZE_ACROSS_ALL_DRAFT - OTHERS ERROR ... ' || sqlerrm);

525:
526: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT (-) ');
527: EXCEPTION
528: WHEN OTHERS THEN
529: pnp_debug_pkg.log(' RENORMALIZE_ACROSS_ALL_DRAFT - OTHERS ERROR ... ' || sqlerrm);
530:
531: END RENORMALIZE_ACROSS_ALL_DRAFT;
532:
533:

Line 667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');

663:
664: l_org_id NUMBER;
665:
666: BEGIN
667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
668: pnp_debug_pkg.log(' Procedure called with Parameters... ');
669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );

Line 668: pnp_debug_pkg.log(' Procedure called with Parameters... ');

664: l_org_id NUMBER;
665:
666: BEGIN
667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
668: pnp_debug_pkg.log(' Procedure called with Parameters... ');
669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );

Line 669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );

665:
666: BEGIN
667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
668: pnp_debug_pkg.log(' Procedure called with Parameters... ');
669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );

Line 670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );

666: BEGIN
667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
668: pnp_debug_pkg.log(' Procedure called with Parameters... ');
669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );

Line 671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );

667: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (+) ');
668: pnp_debug_pkg.log(' Procedure called with Parameters... ');
669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );

Line 672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );

668: pnp_debug_pkg.log(' Procedure called with Parameters... ');
669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );

Line 673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );

669: pnp_debug_pkg.log(' p_lease_context : ' || p_lease_context );
670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );

Line 674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );

670: pnp_debug_pkg.log(' p_lease_id : ' || p_lease_id );
671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );

Line 675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );

671: pnp_debug_pkg.log(' p_term_id : ' || p_term_id );
672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );

Line 676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );

672: pnp_debug_pkg.log(' p_vendor_id : ' || p_vendor_id );
673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );

Line 677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );

673: pnp_debug_pkg.log(' p_cust_id : ' || p_cust_id );
674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
681: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );

Line 678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );

674: pnp_debug_pkg.log(' p_vendor_site_id : ' || p_vendor_site_id );
675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
681: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
682: pnp_debug_pkg.log(' p_rate : ' || p_rate );

Line 679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );

675: pnp_debug_pkg.log(' p_cust_site_use_id : ' || p_cust_site_use_id );
676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
681: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
682: pnp_debug_pkg.log(' p_rate : ' || p_rate );
683:

Line 680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );

676: pnp_debug_pkg.log(' p_cust_ship_site_id : ' || p_cust_ship_site_id );
677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
681: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
682: pnp_debug_pkg.log(' p_rate : ' || p_rate );
683:
684: /* initilizations*/

Line 681: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );

677: pnp_debug_pkg.log(' p_sob_id : ' || p_sob_id );
678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
681: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
682: pnp_debug_pkg.log(' p_rate : ' || p_rate );
683:
684: /* initilizations*/
685: l_partial_start_flag := FALSE;

Line 682: pnp_debug_pkg.log(' p_rate : ' || p_rate );

678: pnp_debug_pkg.log(' p_curr_code : ' || p_curr_code );
679: pnp_debug_pkg.log(' p_sch_day : ' || p_sch_day );
680: pnp_debug_pkg.log(' p_norm_str_dt : ' || p_norm_str_dt );
681: pnp_debug_pkg.log(' p_norm_end_dt : ' || p_norm_end_dt );
682: pnp_debug_pkg.log(' p_rate : ' || p_rate );
683:
684: /* initilizations*/
685: l_partial_start_flag := FALSE;
686: l_partial_end_flag := FALSE;

Line 952: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');

948: l_cash_item:=1;
949: END LOOP;
950:
951: IF l_cash_item = 0 THEN
952: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
953: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
954: pn_schedules_items.create_cash_items
955: (p_est_amt => 0,
956: p_act_amt => 0,

Line 953: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);

949: END LOOP;
950:
951: IF l_cash_item = 0 THEN
952: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
953: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
954: pn_schedules_items.create_cash_items
955: (p_est_amt => 0,
956: p_act_amt => 0,
957: p_sch_dt => g_norm_item_tbl(i).schedule_date,

Line 968: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');

964: p_cust_ship_site_id => p_cust_ship_site_id,
965: p_sob_id => p_sob_id,
966: p_curr_code => p_curr_code,
967: p_rate => p_rate);
968: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> $ 0 cash item created(-) ');
969: END IF;
970:
971: /*E.N. Bug 4956314 */
972:

Line 983: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (-) ');

979: norm_end_date = p_norm_end_dt
980: WHERE normalize ='Y'
981: AND payment_term_id = p_term_id;
982:
983: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (-) ');
984: EXCEPTION
985: WHEN OTHERS THEN
986: pnp_debug_pkg.log(' RENORMALIZE_IN_FIRST_DRAFT - OTHERS ERROR ... ' || sqlerrm);
987:

Line 986: pnp_debug_pkg.log(' RENORMALIZE_IN_FIRST_DRAFT - OTHERS ERROR ... ' || sqlerrm);

982:
983: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_IN_FIRST_DRAFT (-) ');
984: EXCEPTION
985: WHEN OTHERS THEN
986: pnp_debug_pkg.log(' RENORMALIZE_IN_FIRST_DRAFT - OTHERS ERROR ... ' || sqlerrm);
987:
988: END RENORMALIZE_IN_FIRST_DRAFT;
989:
990: /*------------------------------------------------------------------------------

Line 1075: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (+) ');

1071: lp_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE := NULL;
1072:
1073:
1074: BEGIN
1075: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (+) ');
1076:
1077: SELECT change_commencement_date
1078: INTO l_amd_comn_date
1079: FROM

Line 1133: pnp_debug_pkg.log(' N-RN COUNTER' || l_counter);

1129: g_norm_item_tbl(l_counter).schedule_date := sch_rec.schedule_date;
1130: g_norm_item_tbl(l_counter).schedule_id := sch_rec.payment_schedule_id;
1131: l_counter := l_counter + 1;
1132: END LOOP;
1133: pnp_debug_pkg.log(' N-RN COUNTER' || l_counter);
1134: /* donot renormalize if no original draft schedule is not found */
1135: IF (NVL(g_norm_item_tbl.COUNT, 0) <> 0) OR (l_system_options = 'N') THEN
1136:
1137: /* call appropriate sub procedure depending upon the system option */

Line 1149: pnp_debug_pkg.log('p_norm_end_dt ' || p_norm_end_dt);

1145: ELSE
1146: lp_norm_str_dt := p_norm_str_dt;
1147: END IF;
1148:
1149: pnp_debug_pkg.log('p_norm_end_dt ' || p_norm_end_dt);
1150:
1151: RENORMALIZE_ACROSS_ALL_DRAFT
1152: (p_lease_context => p_lease_context,
1153: p_lease_id => p_lease_id,

Line 1188: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (-) ');

1184: END IF;
1185:
1186: END IF;
1187:
1188: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (-) ');
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: pnp_debug_pkg.log(' NORMALIZE_RENORMALIZE - OTHERS ERROR ... ' || sqlerrm);
1192:

Line 1191: pnp_debug_pkg.log(' NORMALIZE_RENORMALIZE - OTHERS ERROR ... ' || sqlerrm);

1187:
1188: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (-) ');
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: pnp_debug_pkg.log(' NORMALIZE_RENORMALIZE - OTHERS ERROR ... ' || sqlerrm);
1192:
1193: END NORMALIZE_RENORMALIZE;
1194:
1195: