DBA Data[Home] [Help]

APPS.PN_MASS_APPR_PKG dependencies on FND_MESSAGE

Line 481: fnd_message.set_name('PN', 'PN_FUNC_CURR_NOT_FOUND');

477: END LOOP;
478:
479: IF l_func_curr IS NULL THEN
480: /* need to tell the user functional currency is not defined */
481: fnd_message.set_name('PN', 'PN_FUNC_CURR_NOT_FOUND');
482: pnp_debug_pkg.put_log_msg
483: ('+------------------------------------------------------------------------------+');
484: pnp_debug_pkg.put_log_msg(fnd_message.get);
485: pnp_debug_pkg.put_log_msg

Line 484: pnp_debug_pkg.put_log_msg(fnd_message.get);

480: /* need to tell the user functional currency is not defined */
481: fnd_message.set_name('PN', 'PN_FUNC_CURR_NOT_FOUND');
482: pnp_debug_pkg.put_log_msg
483: ('+------------------------------------------------------------------------------+');
484: pnp_debug_pkg.put_log_msg(fnd_message.get);
485: pnp_debug_pkg.put_log_msg
486: ('+------------------------------------------------------------------------------+');
487:
488: RAISE NO_DATA_FOUND;

Line 563: fnd_message.set_name('PN','PN_SCHED_REJECT_MSG');

559: END LOOP;
560:
561: IF l_exist_item_null_amt THEN
562:
563: fnd_message.set_name('PN','PN_SCHED_REJECT_MSG');
564: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
565: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
566:
567: pnp_debug_pkg.put_log_msg

Line 564: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);

560:
561: IF l_exist_item_null_amt THEN
562:
563: fnd_message.set_name('PN','PN_SCHED_REJECT_MSG');
564: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
565: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
566:
567: pnp_debug_pkg.put_log_msg
568: ('+------------------------------------------------------------------------------+');

Line 565: fnd_message.set_token('L_LEASE_NAME',l_lease_name);

561: IF l_exist_item_null_amt THEN
562:
563: fnd_message.set_name('PN','PN_SCHED_REJECT_MSG');
564: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
565: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
566:
567: pnp_debug_pkg.put_log_msg
568: ('+------------------------------------------------------------------------------+');
569: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 569: pnp_debug_pkg.put_log_msg(fnd_message.get);

565: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
566:
567: pnp_debug_pkg.put_log_msg
568: ('+------------------------------------------------------------------------------+');
569: pnp_debug_pkg.put_log_msg(fnd_message.get);
570: pnp_debug_pkg.put_log_msg
571: ('+------------------------------------------------------------------------------+');
572:
573: l_sched_failed := TRUE;

Line 611: fnd_message.set_name('PN','PN_SCHED_BILL_REJ_MSG');

607:
608: /* Set the schedule failed flag */
609: l_sched_failed := TRUE;
610:
611: fnd_message.set_name('PN','PN_SCHED_BILL_REJ_MSG');
612: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
613: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
614:
615: pnp_debug_pkg.put_log_msg

Line 612: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);

608: /* Set the schedule failed flag */
609: l_sched_failed := TRUE;
610:
611: fnd_message.set_name('PN','PN_SCHED_BILL_REJ_MSG');
612: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
613: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
614:
615: pnp_debug_pkg.put_log_msg
616: ('+------------------------------------------------------------------------------+');

Line 613: fnd_message.set_token('L_LEASE_NAME',l_lease_name);

609: l_sched_failed := TRUE;
610:
611: fnd_message.set_name('PN','PN_SCHED_BILL_REJ_MSG');
612: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
613: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
614:
615: pnp_debug_pkg.put_log_msg
616: ('+------------------------------------------------------------------------------+');
617: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 617: pnp_debug_pkg.put_log_msg(fnd_message.get);

613: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
614:
615: pnp_debug_pkg.put_log_msg
616: ('+------------------------------------------------------------------------------+');
617: pnp_debug_pkg.put_log_msg(fnd_message.get);
618: pnp_debug_pkg.put_log_msg
619: ('+------------------------------------------------------------------------------+');
620:
621: ELSIF l_exist_bad_pay_term THEN

Line 626: fnd_message.set_name('PN','PN_SCHED_PAY_REJ_MSG');

622:
623: /* Set the schedule failed flag */
624: l_sched_failed := TRUE;
625:
626: fnd_message.set_name('PN','PN_SCHED_PAY_REJ_MSG');
627: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
628: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
629:
630: pnp_debug_pkg.put_log_msg

Line 627: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);

623: /* Set the schedule failed flag */
624: l_sched_failed := TRUE;
625:
626: fnd_message.set_name('PN','PN_SCHED_PAY_REJ_MSG');
627: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
628: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
629:
630: pnp_debug_pkg.put_log_msg
631: ('+------------------------------------------------------------------------------+');

Line 628: fnd_message.set_token('L_LEASE_NAME',l_lease_name);

624: l_sched_failed := TRUE;
625:
626: fnd_message.set_name('PN','PN_SCHED_PAY_REJ_MSG');
627: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
628: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
629:
630: pnp_debug_pkg.put_log_msg
631: ('+------------------------------------------------------------------------------+');
632: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 632: pnp_debug_pkg.put_log_msg(fnd_message.get);

628: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
629:
630: pnp_debug_pkg.put_log_msg
631: ('+------------------------------------------------------------------------------+');
632: pnp_debug_pkg.put_log_msg(fnd_message.get);
633: pnp_debug_pkg.put_log_msg
634: ('+------------------------------------------------------------------------------+');
635:
636: ELSE

Line 654: fnd_message.set_name('PN','PN_GL_PRD_MSG');

650:
651: /* Set the schedule failed flag */
652: l_sched_failed := TRUE;
653:
654: fnd_message.set_name('PN','PN_GL_PRD_MSG');
655: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
656: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
657:
658: pnp_debug_pkg.put_log_msg

Line 655: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);

651: /* Set the schedule failed flag */
652: l_sched_failed := TRUE;
653:
654: fnd_message.set_name('PN','PN_GL_PRD_MSG');
655: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
656: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
657:
658: pnp_debug_pkg.put_log_msg
659: ('+------------------------------------------------------------------------------+');

Line 656: fnd_message.set_token('L_LEASE_NAME',l_lease_name);

652: l_sched_failed := TRUE;
653:
654: fnd_message.set_name('PN','PN_GL_PRD_MSG');
655: fnd_message.set_token('L_LEASE_NUMBER',l_lease_number);
656: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
657:
658: pnp_debug_pkg.put_log_msg
659: ('+------------------------------------------------------------------------------+');
660: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 660: pnp_debug_pkg.put_log_msg(fnd_message.get);

656: fnd_message.set_token('L_LEASE_NAME',l_lease_name);
657:
658: pnp_debug_pkg.put_log_msg
659: ('+------------------------------------------------------------------------------+');
660: pnp_debug_pkg.put_log_msg(fnd_message.get);
661: pnp_debug_pkg.put_log_msg
662: ('+------------------------------------------------------------------------------+');
663:
664: ELSE

Line 682: fnd_message.set_name('PN','PN_RATE_NOT_FOUND');

678:
679: EXCEPTION
680:
681: WHEN RATE_NOT_DEFINED THEN
682: fnd_message.set_name('PN','PN_RATE_NOT_FOUND');
683: fnd_message.set_token('CURRENCY', l_func_curr);
684: pnp_debug_pkg.put_log_msg
685: ('+------------------------------------------------------------------------------+');
686: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 683: fnd_message.set_token('CURRENCY', l_func_curr);

679: EXCEPTION
680:
681: WHEN RATE_NOT_DEFINED THEN
682: fnd_message.set_name('PN','PN_RATE_NOT_FOUND');
683: fnd_message.set_token('CURRENCY', l_func_curr);
684: pnp_debug_pkg.put_log_msg
685: ('+------------------------------------------------------------------------------+');
686: pnp_debug_pkg.put_log_msg(fnd_message.get);
687: pnp_debug_pkg.put_log_msg

Line 686: pnp_debug_pkg.put_log_msg(fnd_message.get);

682: fnd_message.set_name('PN','PN_RATE_NOT_FOUND');
683: fnd_message.set_token('CURRENCY', l_func_curr);
684: pnp_debug_pkg.put_log_msg
685: ('+------------------------------------------------------------------------------+');
686: pnp_debug_pkg.put_log_msg(fnd_message.get);
687: pnp_debug_pkg.put_log_msg
688: ('+------------------------------------------------------------------------------+');
689:
690: l_rate_err := TRUE;

Line 694: fnd_message.set_name('PN','PN_CONV_TYPE_NOT_FOUND');

690: l_rate_err := TRUE;
691: ROLLBACK TO beforeupdate;
692:
693: WHEN CURR_CONV_FAILED THEN
694: fnd_message.set_name('PN','PN_CONV_TYPE_NOT_FOUND');
695: pnp_debug_pkg.put_log_msg
696: ('+------------------------------------------------------------------------------+');
697: pnp_debug_pkg.put_log_msg(fnd_message.get);
698: pnp_debug_pkg.put_log_msg

Line 697: pnp_debug_pkg.put_log_msg(fnd_message.get);

693: WHEN CURR_CONV_FAILED THEN
694: fnd_message.set_name('PN','PN_CONV_TYPE_NOT_FOUND');
695: pnp_debug_pkg.put_log_msg
696: ('+------------------------------------------------------------------------------+');
697: pnp_debug_pkg.put_log_msg(fnd_message.get);
698: pnp_debug_pkg.put_log_msg
699: ('+------------------------------------------------------------------------------+');
700:
701: l_rate_err := TRUE;

Line 767: fnd_message.set_name('PN', 'PN_APPR_SCHED_FAILED');

763:
764: /* print if approved or unapproved */
765: IF l_sched_failed THEN
766:
767: fnd_message.set_name('PN', 'PN_APPR_SCHED_FAILED');
768: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
769: pnp_debug_pkg.put_log_msg(fnd_message.get);
770: pnp_debug_pkg.put_log_msg(' ');
771:

Line 768: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);

764: /* print if approved or unapproved */
765: IF l_sched_failed THEN
766:
767: fnd_message.set_name('PN', 'PN_APPR_SCHED_FAILED');
768: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
769: pnp_debug_pkg.put_log_msg(fnd_message.get);
770: pnp_debug_pkg.put_log_msg(' ');
771:
772: /* increment the rejected counter */

Line 769: pnp_debug_pkg.put_log_msg(fnd_message.get);

765: IF l_sched_failed THEN
766:
767: fnd_message.set_name('PN', 'PN_APPR_SCHED_FAILED');
768: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
769: pnp_debug_pkg.put_log_msg(fnd_message.get);
770: pnp_debug_pkg.put_log_msg(' ');
771:
772: /* increment the rejected counter */
773: l_sch_rej := l_sch_rej + 1;

Line 778: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUCCESS');

774:
775:
776: ELSE
777:
778: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUCCESS');
779: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
780: pnp_debug_pkg.put_log_msg(fnd_message.get);
781: pnp_debug_pkg.put_log_msg(' ');
782:

Line 779: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);

775:
776: ELSE
777:
778: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUCCESS');
779: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
780: pnp_debug_pkg.put_log_msg(fnd_message.get);
781: pnp_debug_pkg.put_log_msg(' ');
782:
783: END IF;

Line 780: pnp_debug_pkg.put_log_msg(fnd_message.get);

776: ELSE
777:
778: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUCCESS');
779: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
780: pnp_debug_pkg.put_log_msg(fnd_message.get);
781: pnp_debug_pkg.put_log_msg(' ');
782:
783: END IF;
784:

Line 798: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUMMARY');

794:
795: /* summary */
796: l_sch_app := l_sch_tot - l_sch_rej;
797:
798: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUMMARY');
799: fnd_message.set_token('APPROVED', l_sch_app);
800: fnd_message.set_token('FAILED', l_sch_rej);
801: fnd_message.set_token('TOTAL', l_sch_tot);
802:

Line 799: fnd_message.set_token('APPROVED', l_sch_app);

795: /* summary */
796: l_sch_app := l_sch_tot - l_sch_rej;
797:
798: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUMMARY');
799: fnd_message.set_token('APPROVED', l_sch_app);
800: fnd_message.set_token('FAILED', l_sch_rej);
801: fnd_message.set_token('TOTAL', l_sch_tot);
802:
803: pnp_debug_pkg.put_log_msg(' ');

Line 800: fnd_message.set_token('FAILED', l_sch_rej);

796: l_sch_app := l_sch_tot - l_sch_rej;
797:
798: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUMMARY');
799: fnd_message.set_token('APPROVED', l_sch_app);
800: fnd_message.set_token('FAILED', l_sch_rej);
801: fnd_message.set_token('TOTAL', l_sch_tot);
802:
803: pnp_debug_pkg.put_log_msg(' ');
804: pnp_debug_pkg.put_log_msg

Line 801: fnd_message.set_token('TOTAL', l_sch_tot);

797:
798: fnd_message.set_name('PN', 'PN_APPR_SCHED_SUMMARY');
799: fnd_message.set_token('APPROVED', l_sch_app);
800: fnd_message.set_token('FAILED', l_sch_rej);
801: fnd_message.set_token('TOTAL', l_sch_tot);
802:
803: pnp_debug_pkg.put_log_msg(' ');
804: pnp_debug_pkg.put_log_msg
805: ('+==============================================================================+');

Line 806: pnp_debug_pkg.put_log_msg(fnd_message.get);

802:
803: pnp_debug_pkg.put_log_msg(' ');
804: pnp_debug_pkg.put_log_msg
805: ('+==============================================================================+');
806: pnp_debug_pkg.put_log_msg(fnd_message.get);
807: pnp_debug_pkg.put_log_msg
808: ('+==============================================================================+');
809:
810: IF bad_currency_table.COUNT > 0 THEN

Line 815: fnd_message.set_name('PN','PN_CURRENCY_CONV_FAIL');

811:
812: pnp_debug_pkg.put_log_msg
813: ('+==============================================================================+');
814: FOR i IN 0 .. (bad_currency_table.COUNT - 1) LOOP
815: fnd_message.set_name('PN','PN_CURRENCY_CONV_FAIL');
816: fnd_message.set_token('FROM_CURRENCY', bad_currency_table(i));
817: fnd_message.set_token('TO_CURRENCY', l_func_curr);
818: pnp_debug_pkg.put_log_msg(fnd_message.get);
819: END LOOP;

Line 816: fnd_message.set_token('FROM_CURRENCY', bad_currency_table(i));

812: pnp_debug_pkg.put_log_msg
813: ('+==============================================================================+');
814: FOR i IN 0 .. (bad_currency_table.COUNT - 1) LOOP
815: fnd_message.set_name('PN','PN_CURRENCY_CONV_FAIL');
816: fnd_message.set_token('FROM_CURRENCY', bad_currency_table(i));
817: fnd_message.set_token('TO_CURRENCY', l_func_curr);
818: pnp_debug_pkg.put_log_msg(fnd_message.get);
819: END LOOP;
820: pnp_debug_pkg.put_log_msg

Line 817: fnd_message.set_token('TO_CURRENCY', l_func_curr);

813: ('+==============================================================================+');
814: FOR i IN 0 .. (bad_currency_table.COUNT - 1) LOOP
815: fnd_message.set_name('PN','PN_CURRENCY_CONV_FAIL');
816: fnd_message.set_token('FROM_CURRENCY', bad_currency_table(i));
817: fnd_message.set_token('TO_CURRENCY', l_func_curr);
818: pnp_debug_pkg.put_log_msg(fnd_message.get);
819: END LOOP;
820: pnp_debug_pkg.put_log_msg
821: ('+==============================================================================+');

Line 818: pnp_debug_pkg.put_log_msg(fnd_message.get);

814: FOR i IN 0 .. (bad_currency_table.COUNT - 1) LOOP
815: fnd_message.set_name('PN','PN_CURRENCY_CONV_FAIL');
816: fnd_message.set_token('FROM_CURRENCY', bad_currency_table(i));
817: fnd_message.set_token('TO_CURRENCY', l_func_curr);
818: pnp_debug_pkg.put_log_msg(fnd_message.get);
819: END LOOP;
820: pnp_debug_pkg.put_log_msg
821: ('+==============================================================================+');
822:

Line 1008: fnd_message.set_name('PN', 'PN_UNAPPR_SCHED_SUCCESS');

1004: approval_date = NULL,
1005: period_name = NULL
1006: WHERE payment_schedule_id = l_payment_schedule_id;
1007:
1008: fnd_message.set_name('PN', 'PN_UNAPPR_SCHED_SUCCESS');
1009: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
1010: pnp_debug_pkg.put_log_msg(fnd_message.get);
1011: pnp_debug_pkg.put_log_msg(' ');
1012:

Line 1009: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);

1005: period_name = NULL
1006: WHERE payment_schedule_id = l_payment_schedule_id;
1007:
1008: fnd_message.set_name('PN', 'PN_UNAPPR_SCHED_SUCCESS');
1009: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
1010: pnp_debug_pkg.put_log_msg(fnd_message.get);
1011: pnp_debug_pkg.put_log_msg(' ');
1012:
1013: END LOOP;

Line 1010: pnp_debug_pkg.put_log_msg(fnd_message.get);

1006: WHERE payment_schedule_id = l_payment_schedule_id;
1007:
1008: fnd_message.set_name('PN', 'PN_UNAPPR_SCHED_SUCCESS');
1009: fnd_message.set_token('SCHEDULE_DATE', l_payment_schedule_date);
1010: pnp_debug_pkg.put_log_msg(fnd_message.get);
1011: pnp_debug_pkg.put_log_msg(' ');
1012:
1013: END LOOP;
1014:

Line 1015: fnd_message.set_name('PN', 'PN_UNAPPR_SCHED_SUMMARY');

1011: pnp_debug_pkg.put_log_msg(' ');
1012:
1013: END LOOP;
1014:
1015: fnd_message.set_name('PN', 'PN_UNAPPR_SCHED_SUMMARY');
1016: fnd_message.set_token('UNAPPROVED', l_sch_unapp);
1017:
1018: pnp_debug_pkg.put_log_msg(' ');
1019: pnp_debug_pkg.put_log_msg

Line 1016: fnd_message.set_token('UNAPPROVED', l_sch_unapp);

1012:
1013: END LOOP;
1014:
1015: fnd_message.set_name('PN', 'PN_UNAPPR_SCHED_SUMMARY');
1016: fnd_message.set_token('UNAPPROVED', l_sch_unapp);
1017:
1018: pnp_debug_pkg.put_log_msg(' ');
1019: pnp_debug_pkg.put_log_msg
1020: ('+==============================================================================+');

Line 1021: pnp_debug_pkg.put_log_msg(fnd_message.get);

1017:
1018: pnp_debug_pkg.put_log_msg(' ');
1019: pnp_debug_pkg.put_log_msg
1020: ('+==============================================================================+');
1021: pnp_debug_pkg.put_log_msg(fnd_message.get);
1022: pnp_debug_pkg.put_log_msg
1023: ('+==============================================================================+');
1024:
1025: PNP_DEBUG_PKG.debug ('PN_MASS_APPR_PKG.unapprove (-)');

Line 1080: fnd_message.set_name('PN','PN_MASAPB_PARAMS');

1076: PNP_DEBUG_PKG.debug('pn_mass_appr_pkg.pn_mass_app (+)');
1077:
1078: /* --- MESSAGE NEEDED --- */
1079: /* need to print the i/p params */
1080: fnd_message.set_name('PN','PN_MASAPB_PARAMS');
1081: fnd_message.set_token('P_ACTION_TYPE', p_action_type);
1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);
1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);

Line 1081: fnd_message.set_token('P_ACTION_TYPE', p_action_type);

1077:
1078: /* --- MESSAGE NEEDED --- */
1079: /* need to print the i/p params */
1080: fnd_message.set_name('PN','PN_MASAPB_PARAMS');
1081: fnd_message.set_token('P_ACTION_TYPE', p_action_type);
1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);
1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);

Line 1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);

1078: /* --- MESSAGE NEEDED --- */
1079: /* need to print the i/p params */
1080: fnd_message.set_name('PN','PN_MASAPB_PARAMS');
1081: fnd_message.set_token('P_ACTION_TYPE', p_action_type);
1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);
1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);

Line 1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);

1079: /* need to print the i/p params */
1080: fnd_message.set_name('PN','PN_MASAPB_PARAMS');
1081: fnd_message.set_token('P_ACTION_TYPE', p_action_type);
1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);
1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);

Line 1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);

1080: fnd_message.set_name('PN','PN_MASAPB_PARAMS');
1081: fnd_message.set_token('P_ACTION_TYPE', p_action_type);
1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);
1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);

Line 1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);

1081: fnd_message.set_token('P_ACTION_TYPE', p_action_type);
1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);
1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);

Line 1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);

1082: fnd_message.set_token('P_SCHEDULE_FROM_DATE', p_schedule_from_date);
1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);

Line 1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);

1083: fnd_message.set_token('P_SCHEDULE_TO_DATE', p_schedule_to_date);
1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);

Line 1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);

1084: fnd_message.set_token('P_TRX_FROM_DATE', p_trx_from_date);
1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);
1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);

Line 1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);

1085: fnd_message.set_token('P_TRX_TO_DATE', p_trx_to_date);
1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);
1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);
1093: fnd_message.set_token('P_LOCATION_TO_CODE', p_location_to_code);

Line 1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);

1086: fnd_message.set_token('P_LEASE_CLASS_CODE', p_lease_class_code);
1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);
1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);
1093: fnd_message.set_token('P_LOCATION_TO_CODE', p_location_to_code);
1094: fnd_message.set_token('P_RESPONSIBLE_USER', p_responsible_user);

Line 1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);

1087: fnd_message.set_token('P_SET_OF_BOOKS', p_set_of_books);
1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);
1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);
1093: fnd_message.set_token('P_LOCATION_TO_CODE', p_location_to_code);
1094: fnd_message.set_token('P_RESPONSIBLE_USER', p_responsible_user);
1095:

Line 1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);

1088: fnd_message.set_token('P_PAYMENT_PERIOD', p_payment_period);
1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);
1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);
1093: fnd_message.set_token('P_LOCATION_TO_CODE', p_location_to_code);
1094: fnd_message.set_token('P_RESPONSIBLE_USER', p_responsible_user);
1095:
1096: pnp_debug_pkg.put_log_msg

Line 1093: fnd_message.set_token('P_LOCATION_TO_CODE', p_location_to_code);

1089: fnd_message.set_token('P_BILLING_PERIOD', p_billing_period);
1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);
1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);
1093: fnd_message.set_token('P_LOCATION_TO_CODE', p_location_to_code);
1094: fnd_message.set_token('P_RESPONSIBLE_USER', p_responsible_user);
1095:
1096: pnp_debug_pkg.put_log_msg
1097: ('+------------------------------------------------------------------------------+');

Line 1094: fnd_message.set_token('P_RESPONSIBLE_USER', p_responsible_user);

1090: fnd_message.set_token('P_LEASE_FROM_NUMBER', p_lease_from_number);
1091: fnd_message.set_token('P_LEASE_TO_NUMBER', p_lease_to_number);
1092: fnd_message.set_token('P_LOCATION_FROM_CODE', p_location_from_code);
1093: fnd_message.set_token('P_LOCATION_TO_CODE', p_location_to_code);
1094: fnd_message.set_token('P_RESPONSIBLE_USER', p_responsible_user);
1095:
1096: pnp_debug_pkg.put_log_msg
1097: ('+------------------------------------------------------------------------------+');
1098: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1098: pnp_debug_pkg.put_log_msg(fnd_message.get);

1094: fnd_message.set_token('P_RESPONSIBLE_USER', p_responsible_user);
1095:
1096: pnp_debug_pkg.put_log_msg
1097: ('+------------------------------------------------------------------------------+');
1098: pnp_debug_pkg.put_log_msg(fnd_message.get);
1099: pnp_debug_pkg.put_log_msg
1100: ('+------------------------------------------------------------------------------+');
1101:
1102:

Line 1178: fnd_message.set_name('PN','PN_MASAPB_NO_DATE');

1174: PNP_DEBUG_PKG.debug('pn_mass_appr_pkg.pn_mass_app (-)');
1175:
1176: EXCEPTION
1177: WHEN INPUT_DATE_MISSING THEN
1178: fnd_message.set_name('PN','PN_MASAPB_NO_DATE');
1179: pnp_debug_pkg.put_log_msg
1180: ('+------------------------------------------------------------------------------+');
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182: pnp_debug_pkg.put_log_msg

Line 1181: pnp_debug_pkg.put_log_msg(fnd_message.get);

1177: WHEN INPUT_DATE_MISSING THEN
1178: fnd_message.set_name('PN','PN_MASAPB_NO_DATE');
1179: pnp_debug_pkg.put_log_msg
1180: ('+------------------------------------------------------------------------------+');
1181: pnp_debug_pkg.put_log_msg(fnd_message.get);
1182: pnp_debug_pkg.put_log_msg
1183: ('+------------------------------------------------------------------------------+');
1184: retcode := '2';
1185: