DBA Data[Home] [Help]

APPS.GML_PO_SYNCH dependencies on GML_VALIDATE_PO

Line 587: (GML_VALIDATE_PO.val_orgn_code(v_orgn_code) = FALSE) THEN

583:
584: /* Validate the GEMMS Organization on the Purchase Order */
585:
586: IF (v_orgn_code IS NULL) OR
587: (GML_VALIDATE_PO.val_orgn_code(v_orgn_code) = FALSE) THEN
588:
589: IF v_result = TRUE THEN /*if this is the first validation error*/
590: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
591: v_revision_count, v_last_update_date);

Line 605: (GML_VALIDATE_PO.val_vendor(v_of_payvend_site_id, v_co_code) = FALSE) THEN

601: END IF;
602:
603:
604: IF (v_of_payvend_site_id IS NULL) OR
605: (GML_VALIDATE_PO.val_vendor(v_of_payvend_site_id, v_co_code) = FALSE) THEN
606:
607: IF v_result = TRUE THEN /*if this is the first validation error*/
608: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
609: v_revision_count, v_last_update_date);

Line 624: (GML_VALIDATE_PO.val_vendor(v_of_shipvend_site_id, v_co_code) = FALSE) THEN

620: v_result := FALSE;
621: END IF;
622:
623: IF (v_of_shipvend_site_id IS NULL) OR
624: (GML_VALIDATE_PO.val_vendor(v_of_shipvend_site_id, v_co_code) = FALSE) THEN
625:
626: IF v_result = TRUE THEN /*if this is the first validation error*/
627: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
628: v_revision_count, v_last_update_date);

Line 641: (GML_VALIDATE_PO.val_warehouse(v_to_whse,v_orgn_code) = FALSE) THEN

637: v_result := FALSE;
638: END IF;
639:
640: IF (v_to_whse IS NULL) OR (v_to_whse = ' ') OR
641: (GML_VALIDATE_PO.val_warehouse(v_to_whse,v_orgn_code) = FALSE) THEN
642:
643:
644: IF v_result = TRUE THEN /*if this is the first validation error*/
645: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,

Line 659: (GML_VALIDATE_PO.val_currency (v_billing_currency)=FALSE) THEN

655: v_result := FALSE;
656: END IF;
657:
658: IF (v_billing_currency IS NULL) OR (v_billing_currency = ' ') OR
659: (GML_VALIDATE_PO.val_currency (v_billing_currency)=FALSE) THEN
660:
661: IF v_result = TRUE THEN /*if this is the first validation error*/
662: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
663: v_revision_count, v_last_update_date);

Line 677: (GML_VALIDATE_PO.val_item (v_item_no) = FALSE) THEN

673:
674: END IF;
675:
676: IF (v_item_no IS NULL) OR (v_item_no = ' ') OR
677: (GML_VALIDATE_PO.val_item (v_item_no) = FALSE) THEN
678:
679: IF v_result = TRUE THEN /*if this is the first validation error*/
680: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
681: v_revision_count, v_last_update_date);

Line 695: (GML_VALIDATE_PO.val_uom (v_order_um1) = FALSE) THEN

691:
692: END IF;
693:
694: IF (v_order_um1 IS NULL) OR (v_order_um1 = ' ') OR
695: (GML_VALIDATE_PO.val_uom (v_order_um1) = FALSE) THEN
696:
697: IF v_result = TRUE THEN /*if this is the first validation error*/
698: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
699: v_revision_count, v_last_update_date);

Line 713: (GML_VALIDATE_PO.val_uom (v_price_um)=FALSE) THEN

709:
710: END IF;
711:
712: IF (v_price_um IS NULL) OR (v_price_um = ' ') OR
713: (GML_VALIDATE_PO.val_uom (v_price_um)=FALSE) THEN
714:
715: IF v_result = TRUE THEN /*if this is the first validation error*/
716: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
717: v_revision_count, v_last_update_date);

Line 733: (GML_VALIDATE_PO.val_uom( v_order_um2) = FALSE ) THEN

729:
730: /* all the following are not mandatory*/
731:
732: IF (v_order_um2 IS NOT NULL) AND (v_order_um2 <> ' ') AND
733: (GML_VALIDATE_PO.val_uom( v_order_um2) = FALSE ) THEN
734:
735: IF v_result = TRUE THEN /*if this is the first validation error*/
736: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
737: v_revision_count, v_last_update_date);

Line 751: (GML_VALIDATE_PO.val_uom( v_item_um) = FALSE) THEN

747:
748: END IF;
749:
750: IF (v_item_um IS NOT NULL) AND (v_item_um <> ' ') AND
751: (GML_VALIDATE_PO.val_uom( v_item_um) = FALSE) THEN
752:
753: IF v_result = TRUE THEN /*if this is the first validation error*/
754: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
755: v_revision_count, v_last_update_date);

Line 769: (GML_VALIDATE_PO.val_warehouse(v_from_whse,v_orgn_code) = FALSE) THEN

765:
766: END IF;
767:
768: IF (v_from_whse IS NOT NULL) AND (v_from_whse <> ' ') AND
769: (GML_VALIDATE_PO.val_warehouse(v_from_whse,v_orgn_code) = FALSE) THEN
770:
771: IF v_result = TRUE THEN /*if this is the first validation error*/
772: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
773: v_revision_count, v_last_update_date);

Line 787: (GML_VALIDATE_PO.val_shipper_code(v_shipper_code)= FALSE ) THEN

783:
784: END IF;
785:
786: IF (v_shipper_code IS NOT NULL) AND (v_shipper_code <> ' ') AND
787: (GML_VALIDATE_PO.val_shipper_code(v_shipper_code)= FALSE ) THEN
788:
789: IF v_result = TRUE THEN /*if this is the first validation error*/
790: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
791: v_revision_count, v_last_update_date);

Line 805: (GML_VALIDATE_PO.val_frtbill_mthd( v_of_frtbill_mthd) = FALSE ) THEN

801:
802: END IF;
803:
804: IF (v_of_frtbill_mthd IS NOT NULL) AND (v_of_frtbill_mthd <> ' ') AND
805: (GML_VALIDATE_PO.val_frtbill_mthd( v_of_frtbill_mthd) = FALSE ) THEN
806:
807: IF v_result = TRUE THEN /*if this is the first validation error*/
808: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
809: v_revision_count, v_last_update_date);

Line 823: (GML_VALIDATE_PO.val_terms_code(v_of_terms_code) = FALSE ) THEN

819:
820: END IF;
821:
822: IF (v_of_terms_code IS NOT NULL) AND (v_of_terms_code <> ' ') AND
823: (GML_VALIDATE_PO.val_terms_code(v_of_terms_code) = FALSE ) THEN
824:
825: IF v_result = TRUE THEN /*if this is the first validation error*/
826: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
827: v_revision_count, v_last_update_date);

Line 843: (GML_VALIDATE_PO.val_qc_grade_wanted(v_qc_grade_wanted) = FALSE ) THEN

839:
840: /* Validate the qc_grade_wanted*/
841:
842: IF (v_qc_grade_wanted IS NOT NULL) AND (v_qc_grade_wanted <> ' ') AND
843: (GML_VALIDATE_PO.val_qc_grade_wanted(v_qc_grade_wanted) = FALSE ) THEN
844:
845: IF v_result = TRUE THEN /*if this is the first validation error*/
846: GML_PO_SYNCH.errlog_header( v_po_no, v_line_num, v_shipment_num,
847: v_revision_count, v_last_update_date);

Line 1948: GML_VALIDATE_PO.get_base_currency (v_base_currency,

1944: int_rec.po_status = 'FINALLY CLOSED') THEN
1945: v_po_status := 20;
1946: END IF;
1947:
1948: GML_VALIDATE_PO.get_base_currency (v_base_currency,
1949: int_rec.orgn_code);
1950:
1951: /* HW BUG#:1107267 don't get exchange rate, rate is already in cpg_purchasing_interface */
1952: /* IF (v_base_currency <> int_rec.billing_currency) THEN

Line 1954: GML_VALIDATE_PO.get_gl_source (v_gl_source_type);

1950:
1951: /* HW BUG#:1107267 don't get exchange rate, rate is already in cpg_purchasing_interface */
1952: /* IF (v_base_currency <> int_rec.billing_currency) THEN
1953:
1954: GML_VALIDATE_PO.get_gl_source (v_gl_source_type);
1955:
1956: GML_VALIDATE_PO.get_exchange_rate (v_exchange_rate,
1957: v_mul_div_sign,
1958: v_exchange_rate_date,

Line 1956: GML_VALIDATE_PO.get_exchange_rate (v_exchange_rate,

1952: /* IF (v_base_currency <> int_rec.billing_currency) THEN
1953:
1954: GML_VALIDATE_PO.get_gl_source (v_gl_source_type);
1955:
1956: GML_VALIDATE_PO.get_exchange_rate (v_exchange_rate,
1957: v_mul_div_sign,
1958: v_exchange_rate_date,
1959: v_base_currency,
1960: int_rec.billing_currency,