DBA Data[Home] [Help]

APPS.PN_APPROVE_VARENT_PKG dependencies on PN_VARIABLE_AMOUNT_PKG

Line 25: -- 10-Apr-07 Lbala o Removed call to pn_variable_amount_pkg.get_prior_transfer_flag

21: -- 26-Oct-06 Shabda o Modified cursor csr_get_inv to accomodate true_up invoices
22: -- 27-Oct-06 Shabda o Modified cursor csr_get_inv to accomodate adjustment terms
23: -- for variance, which may not have corresponding forecasted
24: -- terms
25: -- 10-Apr-07 Lbala o Removed call to pn_variable_amount_pkg.get_prior_transfer_flag
26: -- for bug # 5965171
27: -- 31-MAy-07 Lokesh o Bug # 6079479 Changed Cursor csr_get_inv
28:
29: --------------------------------------------------------------------------------

Line 174: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.approve_payment_term (+)' );

170:
171: BEGIN
172:
173:
174: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.approve_payment_term (+)' );
175:
176: fnd_message.set_name ('PN','PN_VRAP_PRM');
177: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
178: fnd_message.set_token ('LSNO_TO',p_lease_num_to);

Line 230: pn_variable_amount_pkg.put_output

226:
227: /* If main lease is in draft status do not approve any payment term */
228: fnd_message.set_name('PN','PN_NO_APPR_TERM');
229: l_errmsg1 := fnd_message.get;
230: pn_variable_amount_pkg.put_output
231: ('+----------------------------------------------------------+');
232: pn_variable_amount_pkg.put_output(l_errmsg1);
233: pn_variable_amount_pkg.put_output
234: ('+----------------------------------------------------------+');

Line 232: pn_variable_amount_pkg.put_output(l_errmsg1);

228: fnd_message.set_name('PN','PN_NO_APPR_TERM');
229: l_errmsg1 := fnd_message.get;
230: pn_variable_amount_pkg.put_output
231: ('+----------------------------------------------------------+');
232: pn_variable_amount_pkg.put_output(l_errmsg1);
233: pn_variable_amount_pkg.put_output
234: ('+----------------------------------------------------------+');
235:
236:

Line 233: pn_variable_amount_pkg.put_output

229: l_errmsg1 := fnd_message.get;
230: pn_variable_amount_pkg.put_output
231: ('+----------------------------------------------------------+');
232: pn_variable_amount_pkg.put_output(l_errmsg1);
233: pn_variable_amount_pkg.put_output
234: ('+----------------------------------------------------------+');
235:
236:
237:

Line 258: pn_variable_amount_pkg.put_output

254: END IF;
255:
256: IF l_invoice_on = 'FORECASTED' THEN
257:
258: pn_variable_amount_pkg.put_output
259: ('+-----------------------------------------------------------+');
260: fnd_message.set_name ('PN','PN_VTERM_FORC_TRM');
261: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
262:

Line 311: pn_variable_amount_pkg.put_log

307:
308: END IF; --l_invoice_on = 'FORECASTED'
309:
310: l_counter := 0;
311: pn_variable_amount_pkg.put_log
312: ('+-----------------------------------------------------------+');
313: pn_variable_amount_pkg.put_log
314: ('Processing '||INITCAP(l_rent_type)||' terms.... ');
315:

Line 313: pn_variable_amount_pkg.put_log

309:
310: l_counter := 0;
311: pn_variable_amount_pkg.put_log
312: ('+-----------------------------------------------------------+');
313: pn_variable_amount_pkg.put_log
314: ('Processing '||INITCAP(l_rent_type)||' terms.... ');
315:
316:
317: FOR rec_get_inv in csr_get_inv(l_var_rent_id,l_rent_type, l_var_rent_type)

Line 369: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.approve_payment_term (-) : ');

365: END IF; --NVL(l_lease_status,'DRAFT') = 'DRAFT'
366:
367: END LOOP;
368:
369: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.approve_payment_term (-) : ');
370:
371: EXCEPTION
372:
373: WHEN OTHERS THEN

Line 374: pn_variable_amount_pkg.put_log

370:
371: EXCEPTION
372:
373: WHEN OTHERS THEN
374: pn_variable_amount_pkg.put_log
375: (SUBSTRB('Error in pn_approve_varent_pkg.approved_payment_term_batch : '||
376: TO_CHAR(sqlcode)||
377: ' - '||
378: sqlerrm ||

Line 551: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.set_transferred_code (+) : ');

547:
548: BEGIN
549:
550: pnp_debug_pkg.log('p_rent_type:'||p_rent_type);
551: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.set_transferred_code (+) : ');
552:
553: l_error := FALSE;
554:
555: IF p_term_status = 'Y' THEN

Line 856: pn_variable_amount_pkg.put_output

852: EXCEPTION
853: WHEN TERM_DIST_INVALID THEN
854: l_error := TRUE;
855: l_errmsg := fnd_message.get;
856: pn_variable_amount_pkg.put_output
857: ('+----------------------------------------------------------+');
858: pn_variable_amount_pkg.put_output(l_errmsg);
859: pn_variable_amount_pkg.put_output
860: ('+----------------------------------------------------------+');

Line 858: pn_variable_amount_pkg.put_output(l_errmsg);

854: l_error := TRUE;
855: l_errmsg := fnd_message.get;
856: pn_variable_amount_pkg.put_output
857: ('+----------------------------------------------------------+');
858: pn_variable_amount_pkg.put_output(l_errmsg);
859: pn_variable_amount_pkg.put_output
860: ('+----------------------------------------------------------+');
861:
862: END;

Line 859: pn_variable_amount_pkg.put_output

855: l_errmsg := fnd_message.get;
856: pn_variable_amount_pkg.put_output
857: ('+----------------------------------------------------------+');
858: pn_variable_amount_pkg.put_output(l_errmsg);
859: pn_variable_amount_pkg.put_output
860: ('+----------------------------------------------------------+');
861:
862: END;
863:

Line 1022: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.set_transferred_code (-) : ');

1018: END LOOP;
1019:
1020: END IF;
1021:
1022: pn_variable_amount_pkg.put_log('pn_approve_varent_pkg.set_transferred_code (-) : ');
1023:
1024: EXCEPTION
1025:
1026: WHEN E_NO_CUST THEN

Line 1027: pn_variable_amount_pkg.put_output

1023:
1024: EXCEPTION
1025:
1026: WHEN E_NO_CUST THEN
1027: pn_variable_amount_pkg.put_output
1028: ('+----------------------------------------------------------+');
1029: pn_variable_amount_pkg.put_output(l_errmsg1);
1030: pn_variable_amount_pkg.put_output('+----------------------------------------------------------+');
1031:

Line 1029: pn_variable_amount_pkg.put_output(l_errmsg1);

1025:
1026: WHEN E_NO_CUST THEN
1027: pn_variable_amount_pkg.put_output
1028: ('+----------------------------------------------------------+');
1029: pn_variable_amount_pkg.put_output(l_errmsg1);
1030: pn_variable_amount_pkg.put_output('+----------------------------------------------------------+');
1031:
1032: WHEN OTHERS THEN
1033: pn_variable_amount_pkg.put_log

Line 1030: pn_variable_amount_pkg.put_output('+----------------------------------------------------------+');

1026: WHEN E_NO_CUST THEN
1027: pn_variable_amount_pkg.put_output
1028: ('+----------------------------------------------------------+');
1029: pn_variable_amount_pkg.put_output(l_errmsg1);
1030: pn_variable_amount_pkg.put_output('+----------------------------------------------------------+');
1031:
1032: WHEN OTHERS THEN
1033: pn_variable_amount_pkg.put_log
1034: ('Error in pn_approve_varent_pkg.set_transferred_code - '||sqlerrm);

Line 1033: pn_variable_amount_pkg.put_log

1029: pn_variable_amount_pkg.put_output(l_errmsg1);
1030: pn_variable_amount_pkg.put_output('+----------------------------------------------------------+');
1031:
1032: WHEN OTHERS THEN
1033: pn_variable_amount_pkg.put_log
1034: ('Error in pn_approve_varent_pkg.set_transferred_code - '||sqlerrm);
1035:
1036: END set_transferred_code;
1037: