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