293: ------------------------------------------------------------------------
294: -- PROCEDURE : display_error_messages
295: -- DESCRIPTION: This procedure will parse a string of error message codes
296: -- delimited of with a comma. It will lookup each code using
297: -- fnd_messages routine.
298: ------------------------------------------------------------------------
299:
300: PROCEDURE display_error_messages (
301: ip_message_string IN VARCHAR2
318: ELSE
319: comma_loc := 0;
320: END IF;
321:
322: fnd_message.clear;
323:
324: --
325: -- loop will cycle thru each occurrence of delimted text
326: -- and display message with its code..
347:
348: --
349: -- Convert error message code to its 'user-friendly' message;
350: --
351: fnd_message.set_name ('PN', ind_message);
352: --
353: -- Display message to the output log
354: --
355: put_output ( '-->'
352: --
353: -- Display message to the output log
354: --
355: put_output ( '-->'
356: || fnd_message.get
357: || ' ('
358: || ind_message
359: || ')');
360: --
432: -- Printing the index periods of the report report
433: --
434: v_line_count := v_line_count
435: + 1;
436: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
437: l_message := ' '||fnd_message.get;
438: fnd_message.set_name ('PN','PN_RICAL_START');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
433: --
434: v_line_count := v_line_count
435: + 1;
436: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
437: l_message := ' '||fnd_message.get;
438: fnd_message.set_name ('PN','PN_RICAL_START');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
434: v_line_count := v_line_count
435: + 1;
436: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
437: l_message := ' '||fnd_message.get;
438: fnd_message.set_name ('PN','PN_RICAL_START');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
435: + 1;
436: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
437: l_message := ' '||fnd_message.get;
438: fnd_message.set_name ('PN','PN_RICAL_START');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
436: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
437: l_message := ' '||fnd_message.get;
438: fnd_message.set_name ('PN','PN_RICAL_START');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
437: l_message := ' '||fnd_message.get;
438: fnd_message.set_name ('PN','PN_RICAL_START');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
445: l_message := l_message||' '||fnd_message.get;
438: fnd_message.set_name ('PN','PN_RICAL_START');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
445: l_message := l_message||' '||fnd_message.get;
446: fnd_message.set_name ('PN','PN_RICAL_NORZ');
439: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
445: l_message := l_message||' '||fnd_message.get;
446: fnd_message.set_name ('PN','PN_RICAL_NORZ');
447: l_message := l_message||' '||fnd_message.get;
440: fnd_message.set_name ('PN','PN_RICAL_END');
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
445: l_message := l_message||' '||fnd_message.get;
446: fnd_message.set_name ('PN','PN_RICAL_NORZ');
447: l_message := l_message||' '||fnd_message.get;
448: put_output(l_message);
441: l_message := l_message||' '||fnd_message.get;
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
445: l_message := l_message||' '||fnd_message.get;
446: fnd_message.set_name ('PN','PN_RICAL_NORZ');
447: l_message := l_message||' '||fnd_message.get;
448: put_output(l_message);
449:
442: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
445: l_message := l_message||' '||fnd_message.get;
446: fnd_message.set_name ('PN','PN_RICAL_NORZ');
447: l_message := l_message||' '||fnd_message.get;
448: put_output(l_message);
449:
450: l_message := NULL;
443: l_message := l_message||' '||fnd_message.get;
444: fnd_message.set_name ('PN','PN_RICAL_INDEX');
445: l_message := l_message||' '||fnd_message.get;
446: fnd_message.set_name ('PN','PN_RICAL_NORZ');
447: l_message := l_message||' '||fnd_message.get;
448: put_output(l_message);
449:
450: l_message := NULL;
451:
448: put_output(l_message);
449:
450: l_message := NULL;
451:
452: fnd_message.set_name ('PN','PN_RICAL_FREQ');
453: l_message := ' '||fnd_message.get;
454: fnd_message.set_name ('PN','PN_RICAL_DATE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
449:
450: l_message := NULL;
451:
452: fnd_message.set_name ('PN','PN_RICAL_FREQ');
453: l_message := ' '||fnd_message.get;
454: fnd_message.set_name ('PN','PN_RICAL_DATE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
450: l_message := NULL;
451:
452: fnd_message.set_name ('PN','PN_RICAL_FREQ');
453: l_message := ' '||fnd_message.get;
454: fnd_message.set_name ('PN','PN_RICAL_DATE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
451:
452: fnd_message.set_name ('PN','PN_RICAL_FREQ');
453: l_message := ' '||fnd_message.get;
454: fnd_message.set_name ('PN','PN_RICAL_DATE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
452: fnd_message.set_name ('PN','PN_RICAL_FREQ');
453: l_message := ' '||fnd_message.get;
454: fnd_message.set_name ('PN','PN_RICAL_DATE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
453: l_message := ' '||fnd_message.get;
454: fnd_message.set_name ('PN','PN_RICAL_DATE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
454: fnd_message.set_name ('PN','PN_RICAL_DATE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
455: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
463: l_message := l_message||' '||fnd_message.get;
456: fnd_message.set_name ('PN','PN_RICAL_DATE');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
463: l_message := l_message||' '||fnd_message.get;
464: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
457: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
463: l_message := l_message||' '||fnd_message.get;
464: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
465: l_message := l_message||' '||fnd_message.get;
458: fnd_message.set_name ('PN','PN_RICAL_AMT');
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
463: l_message := l_message||' '||fnd_message.get;
464: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
465: l_message := l_message||' '||fnd_message.get;
466: put_output(l_message);
459: l_message := l_message||' '||fnd_message.get;
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
463: l_message := l_message||' '||fnd_message.get;
464: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
465: l_message := l_message||' '||fnd_message.get;
466: put_output(l_message);
467:
460: fnd_message.set_name ('PN','PN_RICAL_STATUS');
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
463: l_message := l_message||' '||fnd_message.get;
464: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
465: l_message := l_message||' '||fnd_message.get;
466: put_output(l_message);
467:
468: put_output (
461: l_message := l_message||' '||fnd_message.get;
462: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
463: l_message := l_message||' '||fnd_message.get;
464: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
465: l_message := l_message||' '||fnd_message.get;
466: put_output(l_message);
467:
468: put_output (
469: ' --------- ----------- ----------- ---------- ----------- ------------------ ---------'
507: -- Print Message if no payment terms found for this period
508: --
509: IF v_line_count = 0 THEN
510: put_output ('*********************************************');
511: fnd_message.set_name ('PN','PN_RICAL_NO_PAY');
512: put_output(fnd_message.get);
513: put_output ('*********************************************');
514: END IF;
515: END print_payment_terms;
508: --
509: IF v_line_count = 0 THEN
510: put_output ('*********************************************');
511: fnd_message.set_name ('PN','PN_RICAL_NO_PAY');
512: put_output(fnd_message.get);
513: put_output ('*********************************************');
514: END IF;
515: END print_payment_terms;
516:
565: LOOP
566: --
567: -- Printing the Headers of the report
568: --
569: fnd_message.set_name ('PN','PN_RICAL_CUR');
570: l_message := ' '||fnd_message.get;
571: fnd_message.set_name ('PN','PN_RICAL_ASS');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
566: --
567: -- Printing the Headers of the report
568: --
569: fnd_message.set_name ('PN','PN_RICAL_CUR');
570: l_message := ' '||fnd_message.get;
571: fnd_message.set_name ('PN','PN_RICAL_ASS');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
567: -- Printing the Headers of the report
568: --
569: fnd_message.set_name ('PN','PN_RICAL_CUR');
570: l_message := ' '||fnd_message.get;
571: fnd_message.set_name ('PN','PN_RICAL_ASS');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
568: --
569: fnd_message.set_name ('PN','PN_RICAL_CUR');
570: l_message := ' '||fnd_message.get;
571: fnd_message.set_name ('PN','PN_RICAL_ASS');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
569: fnd_message.set_name ('PN','PN_RICAL_CUR');
570: l_message := ' '||fnd_message.get;
571: fnd_message.set_name ('PN','PN_RICAL_ASS');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
570: l_message := ' '||fnd_message.get;
571: fnd_message.set_name ('PN','PN_RICAL_ASS');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
578: l_message := l_message||' '||fnd_message.get;
571: fnd_message.set_name ('PN','PN_RICAL_ASS');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
578: l_message := l_message||' '||fnd_message.get;
579: fnd_message.set_name ('PN','PN_RICAL_CON');
572: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
578: l_message := l_message||' '||fnd_message.get;
579: fnd_message.set_name ('PN','PN_RICAL_CON');
580: l_message := l_message||' '||fnd_message.get;
573: fnd_message.set_name ('PN','PN_RICAL_INDX');
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
578: l_message := l_message||' '||fnd_message.get;
579: fnd_message.set_name ('PN','PN_RICAL_CON');
580: l_message := l_message||' '||fnd_message.get;
581: put_output(l_message);
574: l_message := l_message||' '||fnd_message.get;
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
578: l_message := l_message||' '||fnd_message.get;
579: fnd_message.set_name ('PN','PN_RICAL_CON');
580: l_message := l_message||' '||fnd_message.get;
581: put_output(l_message);
582:
575: fnd_message.set_name ('PN','PN_RICAL_BAS');
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
578: l_message := l_message||' '||fnd_message.get;
579: fnd_message.set_name ('PN','PN_RICAL_CON');
580: l_message := l_message||' '||fnd_message.get;
581: put_output(l_message);
582:
583: l_message := NULL;
576: l_message := l_message||' '||fnd_message.get;
577: fnd_message.set_name ('PN','PN_RICAL_UCON');
578: l_message := l_message||' '||fnd_message.get;
579: fnd_message.set_name ('PN','PN_RICAL_CON');
580: l_message := l_message||' '||fnd_message.get;
581: put_output(l_message);
582:
583: l_message := NULL;
584:
581: put_output(l_message);
582:
583: l_message := NULL;
584:
585: fnd_message.set_name ('PN','PN_RICAL_BAS');
586: l_message := ' '||fnd_message.get;
587: fnd_message.set_name ('PN','PN_RICAL_DATE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
582:
583: l_message := NULL;
584:
585: fnd_message.set_name ('PN','PN_RICAL_BAS');
586: l_message := ' '||fnd_message.get;
587: fnd_message.set_name ('PN','PN_RICAL_DATE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
583: l_message := NULL;
584:
585: fnd_message.set_name ('PN','PN_RICAL_BAS');
586: l_message := ' '||fnd_message.get;
587: fnd_message.set_name ('PN','PN_RICAL_DATE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
584:
585: fnd_message.set_name ('PN','PN_RICAL_BAS');
586: l_message := ' '||fnd_message.get;
587: fnd_message.set_name ('PN','PN_RICAL_DATE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
585: fnd_message.set_name ('PN','PN_RICAL_BAS');
586: l_message := ' '||fnd_message.get;
587: fnd_message.set_name ('PN','PN_RICAL_DATE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
586: l_message := ' '||fnd_message.get;
587: fnd_message.set_name ('PN','PN_RICAL_DATE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
587: fnd_message.set_name ('PN','PN_RICAL_DATE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
588: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
596: l_message := l_message||' '||fnd_message.get;
589: fnd_message.set_name ('PN','PN_RICAL_REL');
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
596: l_message := l_message||' '||fnd_message.get;
597: l_message := l_message||' '||fnd_message.get;
590: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
596: l_message := l_message||' '||fnd_message.get;
597: l_message := l_message||' '||fnd_message.get;
598: l_message := l_message||' '||fnd_message.get;
591: fnd_message.set_name ('PN','PN_RICAL_CHG');
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
596: l_message := l_message||' '||fnd_message.get;
597: l_message := l_message||' '||fnd_message.get;
598: l_message := l_message||' '||fnd_message.get;
599: put_output(l_message);
592: l_message := l_message||' '||fnd_message.get;
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
596: l_message := l_message||' '||fnd_message.get;
597: l_message := l_message||' '||fnd_message.get;
598: l_message := l_message||' '||fnd_message.get;
599: put_output(l_message);
600:
593: fnd_message.set_name ('PN','PN_RICAL_CHG');
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
596: l_message := l_message||' '||fnd_message.get;
597: l_message := l_message||' '||fnd_message.get;
598: l_message := l_message||' '||fnd_message.get;
599: put_output(l_message);
600:
601: put_output (
594: l_message := l_message||' '||fnd_message.get;
595: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
596: l_message := l_message||' '||fnd_message.get;
597: l_message := l_message||' '||fnd_message.get;
598: l_message := l_message||' '||fnd_message.get;
599: put_output(l_message);
600:
601: put_output (
602: ' --------- ------------ ----------- ---------- ---------- ---------- ----------'
621: -- Print Message if no basis periods found
622: --
623: IF v_line_count = 0 THEN
624: put_output ('**************************************');
625: fnd_message.set_name ('PN','PN_RICAL_NO_PRDS');
626: put_output(fnd_message.get);
627: put_output ('**************************************');
628: END IF;
629: END print_basis_periods;
622: --
623: IF v_line_count = 0 THEN
624: put_output ('**************************************');
625: fnd_message.set_name ('PN','PN_RICAL_NO_PRDS');
626: put_output(fnd_message.get);
627: put_output ('**************************************');
628: END IF;
629: END print_basis_periods;
630:
6066: ,p_period_str_date => c_rec.basis_start_date
6067: ,p_org_id => c_rec.org_id
6068: );
6069: put_output ('****************************************');
6070: fnd_message.set_name ('PN','PN_RICAL_PROC');
6071: put_output(fnd_message.get||'...');
6072: fnd_message.set_name ('PN','PN_RICAL_LSNO');
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6067: ,p_org_id => c_rec.org_id
6068: );
6069: put_output ('****************************************');
6070: fnd_message.set_name ('PN','PN_RICAL_PROC');
6071: put_output(fnd_message.get||'...');
6072: fnd_message.set_name ('PN','PN_RICAL_LSNO');
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6068: );
6069: put_output ('****************************************');
6070: fnd_message.set_name ('PN','PN_RICAL_PROC');
6071: put_output(fnd_message.get||'...');
6072: fnd_message.set_name ('PN','PN_RICAL_LSNO');
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6069: put_output ('****************************************');
6070: fnd_message.set_name ('PN','PN_RICAL_PROC');
6071: put_output(fnd_message.get||'...');
6072: fnd_message.set_name ('PN','PN_RICAL_LSNO');
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6070: fnd_message.set_name ('PN','PN_RICAL_PROC');
6071: put_output(fnd_message.get||'...');
6072: fnd_message.set_name ('PN','PN_RICAL_LSNO');
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6071: put_output(fnd_message.get||'...');
6072: fnd_message.set_name ('PN','PN_RICAL_LSNO');
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6079: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
6072: fnd_message.set_name ('PN','PN_RICAL_LSNO');
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6079: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
6080: fnd_message.set_token ('DATE', c_rec.assessment_date);
6073: fnd_message.set_token ('NUM', c_rec.index_lease_number);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6079: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
6080: fnd_message.set_token ('DATE', c_rec.assessment_date);
6081: put_output(fnd_message.get);
6074: put_output(fnd_message.get);
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6079: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
6080: fnd_message.set_token ('DATE', c_rec.assessment_date);
6081: put_output(fnd_message.get);
6082: put_output ('****************************************');
6075: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6079: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
6080: fnd_message.set_token ('DATE', c_rec.assessment_date);
6081: put_output(fnd_message.get);
6082: put_output ('****************************************');
6083:
6076: fnd_message.set_token ('NUM', c_rec.line_number);
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6079: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
6080: fnd_message.set_token ('DATE', c_rec.assessment_date);
6081: put_output(fnd_message.get);
6082: put_output ('****************************************');
6083:
6084: /* Initialize global variable g_currency_code */
6077: fnd_message.set_token ('ID', c_rec.index_period_id);
6078: put_output(fnd_message.get);
6079: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
6080: fnd_message.set_token ('DATE', c_rec.assessment_date);
6081: put_output(fnd_message.get);
6082: put_output ('****************************************');
6083:
6084: /* Initialize global variable g_currency_code */
6085:
6248:
6249: --
6250: -- Printing the Headers of the report
6251: --
6252: fnd_message.set_name ('PN','PN_RICAL_CUR');
6253: l_message := ' '||fnd_message.get;
6254: fnd_message.set_name ('PN','PN_RICAL_ASS');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6249: --
6250: -- Printing the Headers of the report
6251: --
6252: fnd_message.set_name ('PN','PN_RICAL_CUR');
6253: l_message := ' '||fnd_message.get;
6254: fnd_message.set_name ('PN','PN_RICAL_ASS');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6250: -- Printing the Headers of the report
6251: --
6252: fnd_message.set_name ('PN','PN_RICAL_CUR');
6253: l_message := ' '||fnd_message.get;
6254: fnd_message.set_name ('PN','PN_RICAL_ASS');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6251: --
6252: fnd_message.set_name ('PN','PN_RICAL_CUR');
6253: l_message := ' '||fnd_message.get;
6254: fnd_message.set_name ('PN','PN_RICAL_ASS');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6252: fnd_message.set_name ('PN','PN_RICAL_CUR');
6253: l_message := ' '||fnd_message.get;
6254: fnd_message.set_name ('PN','PN_RICAL_ASS');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6253: l_message := ' '||fnd_message.get;
6254: fnd_message.set_name ('PN','PN_RICAL_ASS');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6261: l_message := l_message||' '||fnd_message.get;
6254: fnd_message.set_name ('PN','PN_RICAL_ASS');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6261: l_message := l_message||' '||fnd_message.get;
6262: fnd_message.set_name ('PN','PN_RICAL_CON');
6255: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6261: l_message := l_message||' '||fnd_message.get;
6262: fnd_message.set_name ('PN','PN_RICAL_CON');
6263: l_message := l_message||' '||fnd_message.get;
6256: fnd_message.set_name ('PN','PN_RICAL_INDX');
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6261: l_message := l_message||' '||fnd_message.get;
6262: fnd_message.set_name ('PN','PN_RICAL_CON');
6263: l_message := l_message||' '||fnd_message.get;
6264: put_output(l_message);
6257: l_message := l_message||' '||fnd_message.get;
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6261: l_message := l_message||' '||fnd_message.get;
6262: fnd_message.set_name ('PN','PN_RICAL_CON');
6263: l_message := l_message||' '||fnd_message.get;
6264: put_output(l_message);
6265:
6258: fnd_message.set_name ('PN','PN_RICAL_BAS');
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6261: l_message := l_message||' '||fnd_message.get;
6262: fnd_message.set_name ('PN','PN_RICAL_CON');
6263: l_message := l_message||' '||fnd_message.get;
6264: put_output(l_message);
6265:
6266: l_message := NULL;
6259: l_message := l_message||' '||fnd_message.get;
6260: fnd_message.set_name ('PN','PN_RICAL_UCON');
6261: l_message := l_message||' '||fnd_message.get;
6262: fnd_message.set_name ('PN','PN_RICAL_CON');
6263: l_message := l_message||' '||fnd_message.get;
6264: put_output(l_message);
6265:
6266: l_message := NULL;
6267:
6264: put_output(l_message);
6265:
6266: l_message := NULL;
6267:
6268: fnd_message.set_name ('PN','PN_RICAL_BAS');
6269: l_message := ' '||fnd_message.get;
6270: fnd_message.set_name ('PN','PN_RICAL_DATE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6265:
6266: l_message := NULL;
6267:
6268: fnd_message.set_name ('PN','PN_RICAL_BAS');
6269: l_message := ' '||fnd_message.get;
6270: fnd_message.set_name ('PN','PN_RICAL_DATE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6266: l_message := NULL;
6267:
6268: fnd_message.set_name ('PN','PN_RICAL_BAS');
6269: l_message := ' '||fnd_message.get;
6270: fnd_message.set_name ('PN','PN_RICAL_DATE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6267:
6268: fnd_message.set_name ('PN','PN_RICAL_BAS');
6269: l_message := ' '||fnd_message.get;
6270: fnd_message.set_name ('PN','PN_RICAL_DATE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6268: fnd_message.set_name ('PN','PN_RICAL_BAS');
6269: l_message := ' '||fnd_message.get;
6270: fnd_message.set_name ('PN','PN_RICAL_DATE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6269: l_message := ' '||fnd_message.get;
6270: fnd_message.set_name ('PN','PN_RICAL_DATE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6270: fnd_message.set_name ('PN','PN_RICAL_DATE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6271: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6272: fnd_message.set_name ('PN','PN_RICAL_REL');
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6280: l_message := l_message||' '||fnd_message.get;
6273: l_message := l_message||' '||fnd_message.get;
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6280: l_message := l_message||' '||fnd_message.get;
6281: fnd_message.set_name ('PN','PN_RICAL_DUE');
6274: fnd_message.set_name ('PN','PN_RICAL_CHG');
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6280: l_message := l_message||' '||fnd_message.get;
6281: fnd_message.set_name ('PN','PN_RICAL_DUE');
6282: l_message := l_message||' '||fnd_message.get;
6275: l_message := l_message||' '||fnd_message.get;
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6280: l_message := l_message||' '||fnd_message.get;
6281: fnd_message.set_name ('PN','PN_RICAL_DUE');
6282: l_message := l_message||' '||fnd_message.get;
6283: put_output(l_message);
6276: fnd_message.set_name ('PN','PN_RICAL_CHG');
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6280: l_message := l_message||' '||fnd_message.get;
6281: fnd_message.set_name ('PN','PN_RICAL_DUE');
6282: l_message := l_message||' '||fnd_message.get;
6283: put_output(l_message);
6284:
6277: l_message := l_message||' '||fnd_message.get;
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6280: l_message := l_message||' '||fnd_message.get;
6281: fnd_message.set_name ('PN','PN_RICAL_DUE');
6282: l_message := l_message||' '||fnd_message.get;
6283: put_output(l_message);
6284:
6285: put_output (
6278: fnd_message.set_name ('PN','PN_RICAL_RENT_DUE');
6279: l_message := l_message||' '||fnd_message.get;
6280: l_message := l_message||' '||fnd_message.get;
6281: fnd_message.set_name ('PN','PN_RICAL_DUE');
6282: l_message := l_message||' '||fnd_message.get;
6283: put_output(l_message);
6284:
6285: put_output (
6286: ' --------- ------------ ----------- ---------- ---------- ---------- ----------'
6300: );
6301:
6302: put_output ('. ');
6303:
6304: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6305: l_message := ' '||fnd_message.get;
6306: fnd_message.set_name ('PN','PN_RICAL_START');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6301:
6302: put_output ('. ');
6303:
6304: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6305: l_message := ' '||fnd_message.get;
6306: fnd_message.set_name ('PN','PN_RICAL_START');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6302: put_output ('. ');
6303:
6304: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6305: l_message := ' '||fnd_message.get;
6306: fnd_message.set_name ('PN','PN_RICAL_START');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6303:
6304: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6305: l_message := ' '||fnd_message.get;
6306: fnd_message.set_name ('PN','PN_RICAL_START');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6304: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6305: l_message := ' '||fnd_message.get;
6306: fnd_message.set_name ('PN','PN_RICAL_START');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6305: l_message := ' '||fnd_message.get;
6306: fnd_message.set_name ('PN','PN_RICAL_START');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6313: l_message := l_message||' '||fnd_message.get;
6306: fnd_message.set_name ('PN','PN_RICAL_START');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6313: l_message := l_message||' '||fnd_message.get;
6314: fnd_message.set_name ('PN','PN_RICAL_NORZ');
6307: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6313: l_message := l_message||' '||fnd_message.get;
6314: fnd_message.set_name ('PN','PN_RICAL_NORZ');
6315: l_message := l_message||' '||fnd_message.get;
6308: fnd_message.set_name ('PN','PN_RICAL_END');
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6313: l_message := l_message||' '||fnd_message.get;
6314: fnd_message.set_name ('PN','PN_RICAL_NORZ');
6315: l_message := l_message||' '||fnd_message.get;
6316: put_output(l_message);
6309: l_message := l_message||' '||fnd_message.get;
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6313: l_message := l_message||' '||fnd_message.get;
6314: fnd_message.set_name ('PN','PN_RICAL_NORZ');
6315: l_message := l_message||' '||fnd_message.get;
6316: put_output(l_message);
6317:
6310: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6313: l_message := l_message||' '||fnd_message.get;
6314: fnd_message.set_name ('PN','PN_RICAL_NORZ');
6315: l_message := l_message||' '||fnd_message.get;
6316: put_output(l_message);
6317:
6318: l_message := NULL;
6311: l_message := l_message||' '||fnd_message.get;
6312: fnd_message.set_name ('PN','PN_RICAL_INDEX');
6313: l_message := l_message||' '||fnd_message.get;
6314: fnd_message.set_name ('PN','PN_RICAL_NORZ');
6315: l_message := l_message||' '||fnd_message.get;
6316: put_output(l_message);
6317:
6318: l_message := NULL;
6319:
6316: put_output(l_message);
6317:
6318: l_message := NULL;
6319:
6320: fnd_message.set_name ('PN','PN_RICAL_FREQ');
6321: l_message := ' '||fnd_message.get;
6322: fnd_message.set_name ('PN','PN_RICAL_DATE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6317:
6318: l_message := NULL;
6319:
6320: fnd_message.set_name ('PN','PN_RICAL_FREQ');
6321: l_message := ' '||fnd_message.get;
6322: fnd_message.set_name ('PN','PN_RICAL_DATE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6318: l_message := NULL;
6319:
6320: fnd_message.set_name ('PN','PN_RICAL_FREQ');
6321: l_message := ' '||fnd_message.get;
6322: fnd_message.set_name ('PN','PN_RICAL_DATE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6319:
6320: fnd_message.set_name ('PN','PN_RICAL_FREQ');
6321: l_message := ' '||fnd_message.get;
6322: fnd_message.set_name ('PN','PN_RICAL_DATE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6320: fnd_message.set_name ('PN','PN_RICAL_FREQ');
6321: l_message := ' '||fnd_message.get;
6322: fnd_message.set_name ('PN','PN_RICAL_DATE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6321: l_message := ' '||fnd_message.get;
6322: fnd_message.set_name ('PN','PN_RICAL_DATE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6322: fnd_message.set_name ('PN','PN_RICAL_DATE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6323: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6331: l_message := l_message||' '||fnd_message.get;
6324: fnd_message.set_name ('PN','PN_RICAL_DATE');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6331: l_message := l_message||' '||fnd_message.get;
6332: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
6325: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6331: l_message := l_message||' '||fnd_message.get;
6332: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
6333: l_message := l_message||' '||fnd_message.get;
6326: fnd_message.set_name ('PN','PN_RICAL_AMT');
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6331: l_message := l_message||' '||fnd_message.get;
6332: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
6333: l_message := l_message||' '||fnd_message.get;
6334: put_output(l_message);
6327: l_message := l_message||' '||fnd_message.get;
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6331: l_message := l_message||' '||fnd_message.get;
6332: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
6333: l_message := l_message||' '||fnd_message.get;
6334: put_output(l_message);
6335:
6328: fnd_message.set_name ('PN','PN_RICAL_STATUS');
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6331: l_message := l_message||' '||fnd_message.get;
6332: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
6333: l_message := l_message||' '||fnd_message.get;
6334: put_output(l_message);
6335:
6336: put_output (
6329: l_message := l_message||' '||fnd_message.get;
6330: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
6331: l_message := l_message||' '||fnd_message.get;
6332: fnd_message.set_name ('PN','PN_RICAL_YES_NO');
6333: l_message := l_message||' '||fnd_message.get;
6334: put_output(l_message);
6335:
6336: put_output (
6337: ' --------- ----------- ----------- ---------- ----------- ------------------ ---------'
6504:
6505:
6506: END LOOP index_lease_period;
6507:
6508: fnd_message.set_name ('PN','PN_RICAL_MSG');
6509: put_output (fnd_message.get||' :');
6510:
6511: display_error_messages (ip_message_string => v_all_msg);
6512: op_msg := SUBSTR (v_all_msg, 1, INSTR ( v_all_msg
6505:
6506: END LOOP index_lease_period;
6507:
6508: fnd_message.set_name ('PN','PN_RICAL_MSG');
6509: put_output (fnd_message.get||' :');
6510:
6511: display_error_messages (ip_message_string => v_all_msg);
6512: op_msg := SUBSTR (v_all_msg, 1, INSTR ( v_all_msg
6513: || ',', ',')
6817: NOT pnp_util_func.validate_term_template(p_term_temp_id => il_rec.term_template_id,
6818: p_lease_cls_code => il_rec.lease_class_code) THEN
6819:
6820: l_err_flag := 'Y';
6821: fnd_message.set_name ('PN', 'PN_MISS_TERM_TEMP_DATA');
6822: put_output(fnd_message.get);
6823: END IF;
6824: END IF;
6825:
6818: p_lease_cls_code => il_rec.lease_class_code) THEN
6819:
6820: l_err_flag := 'Y';
6821: fnd_message.set_name ('PN', 'PN_MISS_TERM_TEMP_DATA');
6822: put_output(fnd_message.get);
6823: END IF;
6824: END IF;
6825:
6826: IF nvl(pn_mo_cache_utils.get_profile_value('RECALC_IR_ON_ACC_CHG_FLAG',il_rec.org_id),'Y') = 'N' THEN
7356: LOOP
7357: v_counter := v_counter + 1;
7358:
7359: put_output ('****************************************');
7360: fnd_message.set_name ('PN','PN_RICAL_PROC');
7361: put_output(fnd_message.get||'...');
7362: fnd_message.set_name ('PN','PN_RICAL_LSNO');
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7357: v_counter := v_counter + 1;
7358:
7359: put_output ('****************************************');
7360: fnd_message.set_name ('PN','PN_RICAL_PROC');
7361: put_output(fnd_message.get||'...');
7362: fnd_message.set_name ('PN','PN_RICAL_LSNO');
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7358:
7359: put_output ('****************************************');
7360: fnd_message.set_name ('PN','PN_RICAL_PROC');
7361: put_output(fnd_message.get||'...');
7362: fnd_message.set_name ('PN','PN_RICAL_LSNO');
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7359: put_output ('****************************************');
7360: fnd_message.set_name ('PN','PN_RICAL_PROC');
7361: put_output(fnd_message.get||'...');
7362: fnd_message.set_name ('PN','PN_RICAL_LSNO');
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7360: fnd_message.set_name ('PN','PN_RICAL_PROC');
7361: put_output(fnd_message.get||'...');
7362: fnd_message.set_name ('PN','PN_RICAL_LSNO');
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7361: put_output(fnd_message.get||'...');
7362: fnd_message.set_name ('PN','PN_RICAL_LSNO');
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7369: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
7362: fnd_message.set_name ('PN','PN_RICAL_LSNO');
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7369: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
7370: fnd_message.set_token ('DATE', il_rec.assessment_date);
7363: fnd_message.set_token ('NUM', il_rec.index_lease_number);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7369: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
7370: fnd_message.set_token ('DATE', il_rec.assessment_date);
7371: put_output(fnd_message.get);
7364: put_output(fnd_message.get);
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7369: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
7370: fnd_message.set_token ('DATE', il_rec.assessment_date);
7371: put_output(fnd_message.get);
7372: put_output ('****************************************');
7365: fnd_message.set_name ('PN','PN_RICAL_LS_PRD');
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7369: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
7370: fnd_message.set_token ('DATE', il_rec.assessment_date);
7371: put_output(fnd_message.get);
7372: put_output ('****************************************');
7373:
7366: fnd_message.set_token ('NUM', il_rec.line_number);
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7369: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
7370: fnd_message.set_token ('DATE', il_rec.assessment_date);
7371: put_output(fnd_message.get);
7372: put_output ('****************************************');
7373:
7374: /* if main lease is in draft status disallow approval */
7367: fnd_message.set_token ('ID', il_rec.index_period_id);
7368: put_output(fnd_message.get);
7369: fnd_message.set_name ('PN','PN_RICAL_ASS_DATE');
7370: fnd_message.set_token ('DATE', il_rec.assessment_date);
7371: put_output(fnd_message.get);
7372: put_output ('****************************************');
7373:
7374: /* if main lease is in draft status disallow approval */
7375:
7373:
7374: /* if main lease is in draft status disallow approval */
7375:
7376: IF nvl(il_rec.lease_status,'D') = 'D' THEN
7377: fnd_message.set_name('PN','PN_NO_APPR_TERM');
7378: l_errmsg := fnd_message.get;
7379: put_output('+----------------------------------------------------------+');
7380: put_output(l_errmsg);
7381: put_output('+----------------------------------------------------------+');
7374: /* if main lease is in draft status disallow approval */
7375:
7376: IF nvl(il_rec.lease_status,'D') = 'D' THEN
7377: fnd_message.set_name('PN','PN_NO_APPR_TERM');
7378: l_errmsg := fnd_message.get;
7379: put_output('+----------------------------------------------------------+');
7380: put_output(l_errmsg);
7381: put_output('+----------------------------------------------------------+');
7382: ELSE
7435:
7436: END IF; --nvl(il_rec.lease_status,'D') = 'D'
7437:
7438: l_message := NULL;
7439: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7440: l_message := ' '||fnd_message.get;
7441: fnd_message.set_name ('PN','PN_RICAL_START');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7436: END IF; --nvl(il_rec.lease_status,'D') = 'D'
7437:
7438: l_message := NULL;
7439: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7440: l_message := ' '||fnd_message.get;
7441: fnd_message.set_name ('PN','PN_RICAL_START');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7437:
7438: l_message := NULL;
7439: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7440: l_message := ' '||fnd_message.get;
7441: fnd_message.set_name ('PN','PN_RICAL_START');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7438: l_message := NULL;
7439: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7440: l_message := ' '||fnd_message.get;
7441: fnd_message.set_name ('PN','PN_RICAL_START');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7439: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7440: l_message := ' '||fnd_message.get;
7441: fnd_message.set_name ('PN','PN_RICAL_START');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7440: l_message := ' '||fnd_message.get;
7441: fnd_message.set_name ('PN','PN_RICAL_START');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7448: l_message := l_message||' '||fnd_message.get; */
7441: fnd_message.set_name ('PN','PN_RICAL_START');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7448: l_message := l_message||' '||fnd_message.get; */
7449: fnd_message.set_name ('PN','PN_RICAL_NORZ');
7442: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7448: l_message := l_message||' '||fnd_message.get; */
7449: fnd_message.set_name ('PN','PN_RICAL_NORZ');
7450: l_message := l_message||' '||fnd_message.get;
7443: fnd_message.set_name ('PN','PN_RICAL_END');
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7448: l_message := l_message||' '||fnd_message.get; */
7449: fnd_message.set_name ('PN','PN_RICAL_NORZ');
7450: l_message := l_message||' '||fnd_message.get;
7451: put_output(l_message);
7444: l_message := l_message||' '||fnd_message.get;
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7448: l_message := l_message||' '||fnd_message.get; */
7449: fnd_message.set_name ('PN','PN_RICAL_NORZ');
7450: l_message := l_message||' '||fnd_message.get;
7451: put_output(l_message);
7452:
7445: fnd_message.set_name ('PN','PN_RICAL_PAYMENT');
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7448: l_message := l_message||' '||fnd_message.get; */
7449: fnd_message.set_name ('PN','PN_RICAL_NORZ');
7450: l_message := l_message||' '||fnd_message.get;
7451: put_output(l_message);
7452:
7453: l_message := NULL;
7446: l_message := l_message||' '||fnd_message.get;
7447: /*fnd_message.set_name ('PN','PN_RICAL_INDEX');
7448: l_message := l_message||' '||fnd_message.get; */
7449: fnd_message.set_name ('PN','PN_RICAL_NORZ');
7450: l_message := l_message||' '||fnd_message.get;
7451: put_output(l_message);
7452:
7453: l_message := NULL;
7454:
7451: put_output(l_message);
7452:
7453: l_message := NULL;
7454:
7455: fnd_message.set_name ('PN','PN_RICAL_FREQ');
7456: l_message := ' '||fnd_message.get;
7457: fnd_message.set_name ('PN','PN_RICAL_DATE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7452:
7453: l_message := NULL;
7454:
7455: fnd_message.set_name ('PN','PN_RICAL_FREQ');
7456: l_message := ' '||fnd_message.get;
7457: fnd_message.set_name ('PN','PN_RICAL_DATE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7453: l_message := NULL;
7454:
7455: fnd_message.set_name ('PN','PN_RICAL_FREQ');
7456: l_message := ' '||fnd_message.get;
7457: fnd_message.set_name ('PN','PN_RICAL_DATE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7454:
7455: fnd_message.set_name ('PN','PN_RICAL_FREQ');
7456: l_message := ' '||fnd_message.get;
7457: fnd_message.set_name ('PN','PN_RICAL_DATE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7455: fnd_message.set_name ('PN','PN_RICAL_FREQ');
7456: l_message := ' '||fnd_message.get;
7457: fnd_message.set_name ('PN','PN_RICAL_DATE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7456: l_message := ' '||fnd_message.get;
7457: fnd_message.set_name ('PN','PN_RICAL_DATE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7457: fnd_message.set_name ('PN','PN_RICAL_DATE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7458: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7466: l_message := l_message||' '||fnd_message.get;
7459: fnd_message.set_name ('PN','PN_RICAL_DATE');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7466: l_message := l_message||' '||fnd_message.get;
7467: /* fnd_message.set_name ('PN','PN_RICAL_YES_NO');
7460: l_message := l_message||' '||fnd_message.get;
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7466: l_message := l_message||' '||fnd_message.get;
7467: /* fnd_message.set_name ('PN','PN_RICAL_YES_NO');
7468: l_message := l_message||' '||fnd_message.get;*/
7461: fnd_message.set_name ('PN','PN_RICAL_AMT');
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7466: l_message := l_message||' '||fnd_message.get;
7467: /* fnd_message.set_name ('PN','PN_RICAL_YES_NO');
7468: l_message := l_message||' '||fnd_message.get;*/
7469: put_output(l_message);
7462: l_message := l_message||' '||fnd_message.get;
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7466: l_message := l_message||' '||fnd_message.get;
7467: /* fnd_message.set_name ('PN','PN_RICAL_YES_NO');
7468: l_message := l_message||' '||fnd_message.get;*/
7469: put_output(l_message);
7470:
7463: fnd_message.set_name ('PN','PN_RICAL_STATUS');
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7466: l_message := l_message||' '||fnd_message.get;
7467: /* fnd_message.set_name ('PN','PN_RICAL_YES_NO');
7468: l_message := l_message||' '||fnd_message.get;*/
7469: put_output(l_message);
7470:
7471: put_output (
7464: l_message := l_message||' '||fnd_message.get;
7465: fnd_message.set_name ('PN','PN_RICAL_PAYMENT_TYPE');
7466: l_message := l_message||' '||fnd_message.get;
7467: /* fnd_message.set_name ('PN','PN_RICAL_YES_NO');
7468: l_message := l_message||' '||fnd_message.get;*/
7469: put_output(l_message);
7470:
7471: put_output (
7472: ' --------- ----------- ----------- ---------- ----------- ------------------ ------------'
7485:
7486: END LOOP;
7487:
7488: IF v_counter = 0 THEN
7489: fnd_message.set_name ('PN','PN_RICAL_MSG');
7490: put_output (fnd_message.get||' :');
7491: display_error_messages (ip_message_string => 'PN_INDEX_NO_PAYT_TO_APPROVE');
7492: END IF;
7493:
7486: END LOOP;
7487:
7488: IF v_counter = 0 THEN
7489: fnd_message.set_name ('PN','PN_RICAL_MSG');
7490: put_output (fnd_message.get||' :');
7491: display_error_messages (ip_message_string => 'PN_INDEX_NO_PAYT_TO_APPROVE');
7492: END IF;
7493:
7494: