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
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;
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
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: ('+------------------------------------------------------------------------------+');
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);
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;
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
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: ('+------------------------------------------------------------------------------+');
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);
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
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
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: ('+------------------------------------------------------------------------------+');
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);
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
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
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: ('+------------------------------------------------------------------------------+');
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);
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
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);
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
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;
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
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;
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:
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 */
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;
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:
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;
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:
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:
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(' ');
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
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: ('+==============================================================================+');
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
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;
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
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: ('+==============================================================================+');
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:
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:
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;
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:
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
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: ('+==============================================================================+');
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 (-)');
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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: ('+------------------------------------------------------------------------------+');
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);
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:
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
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: