DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TERMS_PKG dependencies on JAI_CONSTANTS

Line 231: p_process_flag := jai_constants.expected_error;

227: */
228:
229: IF NVL(p_term_id,0) = 0 THEN
230:
231: p_process_flag := jai_constants.expected_error;
232: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Term Id cannot be NULL' ;
233: return;
234:
235: END IF;

Line 239: p_process_flag := jai_constants.expected_error;

235: END IF;
236:
237: IF NVL(p_amount,-1) <= 0 THEN
238:
239: p_process_flag := jai_constants.expected_error;
240: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Amount should not be NULL or Zero or Negative' ;
241: return;
242:
243: END IF ;

Line 569: p_process_flag := jai_constants.successful ;

565: -----------------------------------------------------------------------------
566: --added by eric ma for VAT FLEX RECOVERY (Bug9494633) on Mar-09-2010,End
567:
568:
569: p_process_flag := jai_constants.successful ;
570: return ;
571:
572: EXCEPTION
573: WHEN OTHERS THEN

Line 574: p_process_flag := jai_constants.unexpected_error ;

570: return ;
571:
572: EXCEPTION
573: WHEN OTHERS THEN
574: p_process_flag := jai_constants.unexpected_error ;
575: p_process_msg := 'Error Occured in jai_rgm_claims_pkg.prepare_term_schedules - ' || substr(sqlerrm,1,900) ;
576:
577: END generate_term_schedules ;
578:

Line 662: p_process_flag := jai_constants.expected_error;

658: */
659:
660: IF p_regime_id IS NULL THEN
661:
662: p_process_flag := jai_constants.expected_error;
663: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Regime ID cannot be NULL' ;
664: return;
665:
666: END IF;

Line 670: p_process_flag := jai_constants.expected_error;

666: END IF;
667:
668: IF p_item_id IS NULL THEN
669:
670: p_process_flag := jai_constants.expected_error;
671: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Item ID cannot be NULL' ;
672: return;
673:
674: END IF ;

Line 678: p_process_flag := jai_constants.expected_error;

674: END IF ;
675:
676: IF p_organization_id IS NULL THEN
677:
678: p_process_flag := jai_constants.expected_error;
679: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Organization ID cannot be NULL' ;
680: return;
681:
682: END IF ;

Line 686: p_process_flag := jai_constants.expected_error;

682: END IF ;
683:
684: IF p_party_type IS NULL THEN
685:
686: p_process_flag := jai_constants.expected_error;
687: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Party Type cannot be NULL' ;
688: return;
689:
690: END IF ;

Line 695: p_process_flag := jai_constants.expected_error;

691:
692:
693: IF p_location_id IS NULL THEN
694:
695: p_process_flag := jai_constants.expected_error;
696: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Location ID cannot be NULL' ;
697: return;
698:
699: END IF ;

Line 728: IF ( lv_reg_item_class IS NULL ) OR ( lv_process_flag <> jai_constants.successful ) THEN

724: p_process_flag => lv_process_flag ,
725: p_process_msg => lv_process_msg
726: );
727:
728: IF ( lv_reg_item_class IS NULL ) OR ( lv_process_flag <> jai_constants.successful ) THEN
729:
730: p_process_flag := jai_constants.expected_error;
731: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => jai_inv_items_pkg.jai_get_attrib => p_process_flag :: lv_process_msg' ;
732: return;

Line 730: p_process_flag := jai_constants.expected_error;

726: );
727:
728: IF ( lv_reg_item_class IS NULL ) OR ( lv_process_flag <> jai_constants.successful ) THEN
729:
730: p_process_flag := jai_constants.expected_error;
731: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => jai_inv_items_pkg.jai_get_attrib => p_process_flag :: lv_process_msg' ;
732: return;
733:
734: END IF ;

Line 749: p_process_flag := jai_constants.expected_error ;

745: CLOSE cur_term_id ;
746:
747: IF p_term_id IS NULL THEN
748:
749: p_process_flag := jai_constants.expected_error ;
750: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => No term defined' ;
751: RETURN ;
752:
753: END IF ;

Line 755: p_process_flag := jai_constants.successful ;

751: RETURN ;
752:
753: END IF ;
754:
755: p_process_flag := jai_constants.successful ;
756: p_process_msg := NULL;
757:
758: EXCEPTION
759: WHEN others THEN

Line 761: p_process_flag := jai_constants.unexpected_error;

757:
758: EXCEPTION
759: WHEN others THEN
760:
761: p_process_flag := jai_constants.unexpected_error;
762: p_process_msg := 'JAI_CMN_RG_OTHERS.get_term_id => Error Occured : ' || substr(sqlerrm,1,1000) ;
763:
764: END get_term_id ;
765:

Line 791: p_process_flag := jai_constants.expected_error;

787: */
788:
789: IF p_term_id IS NULL THEN
790:
791: p_process_flag := jai_constants.expected_error;
792: p_process_msg := 'jai_rgm_claims_pkg.set_term_in_use_flag => Term ID cannot be NULL' ;
793: return;
794:
795: END IF;

Line 801: p_process_flag := jai_constants.expected_error;

797: OPEN cur_term_flag ( cp_term_id => p_term_id );
798: FETCH cur_term_flag INTO lv_term_in_use_flag ;
799: IF NOT ( cur_term_flag%FOUND ) THEN
800:
801: p_process_flag := jai_constants.expected_error;
802: p_process_msg := 'jai_rgm_claims_pkg.set_term_in_use_flag => Term ID does not exist in database' ;
803: CLOSE cur_term_flag ;
804: return;
805:

Line 820: p_process_flag := jai_constants.successful ;

816: WHERE term_id = p_term_id ;
817:
818: END IF ;
819:
820: p_process_flag := jai_constants.successful ;
821: p_process_msg := NULL;
822:
823: EXCEPTION
824: WHEN others THEN

Line 826: p_process_flag := jai_constants.unexpected_error;

822:
823: EXCEPTION
824: WHEN others THEN
825:
826: p_process_flag := jai_constants.unexpected_error;
827: p_process_msg := 'JAI_CMN_RG_OTHERS.set_term_in_use_flag => Error Occured : ' || substr(sqlerrm,1,1000) ;
828:
829: END set_term_in_use ;
830: