eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HEADERS_SV9 dependencies on STANDARD

Line 469: if x_document_type_code = 'STANDARD' then

465: */
466:
467: if (X_vendor_doc_num is not null) and (X_document_num is not null) then
468:
469: if x_document_type_code = 'STANDARD' then
470:
471: select count(1)
472: into x_temp
473: from po_headers

Line 515: ELSIF(x_document_type_code = 'STANDARD') THEN

511: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
512: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
513: AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');
514: --
515: ELSIF(x_document_type_code = 'STANDARD') THEN
516: SELECT count(*)
517: INTO x_temp
518: FROM po_headers
519: WHERE vendor_id = x_vendor_id

Line 526: -- Added the below 'if/else' statement for standard PO.

522: END IF;
523:
524: elsif(x_document_num is not null) then
525: --
526: -- Added the below 'if/else' statement for standard PO.
527:
528: if (x_document_type_code <> 'STANDARD') then
529: /* Since we are using segment1 it is same for both
530: * Blanket and Quotation.

Line 528: if (x_document_type_code <> 'STANDARD') then

524: elsif(x_document_num is not null) then
525: --
526: -- Added the below 'if/else' statement for standard PO.
527:
528: if (x_document_type_code <> 'STANDARD') then
529: /* Since we are using segment1 it is same for both
530: * Blanket and Quotation.
531: */
532: -- Bug 2449186. Truncate dates when comparing them.

Line 589: -- Added the following 'if/else' statement for standard purchase orders.

585: end if;
586:
587: X_progress := '030';
588: --
589: -- Added the following 'if/else' statement for standard purchase orders.
590:
591: IF (x_document_type_code <> 'STANDARD') THEN
592: po_interface_errors_sv1.handle_interface_errors(
593: 'PO_DOCS_OPEN_INTERFACE',

Line 591: IF (x_document_type_code <> 'STANDARD') THEN

587: X_progress := '030';
588: --
589: -- Added the following 'if/else' statement for standard purchase orders.
590:
591: IF (x_document_type_code <> 'STANDARD') THEN
592: po_interface_errors_sv1.handle_interface_errors(
593: 'PO_DOCS_OPEN_INTERFACE',
594: 'FATAL',
595: null,

Line 609: -- of standard PO.

605: X_header_processable_flag);
606: else
607: --
608: -- Added the below procedure to populate the error message incase
609: -- of standard PO.
610: po_interface_errors_sv1.handle_interface_errors(
611: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
612: x_error_type => 'FATAL',
613: x_batch_id => null,

Line 642: -- Added the following 'if/else' for standard purchase orders.

638: PO_DEBUG.put_line ('X_vendor_doc_num:' || X_vendor_doc_num);
639: PO_DEBUG.put_line ('x_document_num:' || X_vendor_doc_num);
640: END IF;
641: --
642: -- Added the following 'if/else' for standard purchase orders.
643:
644: IF (x_document_type_code <> 'STANDARD') THEN
645: po_interface_errors_sv1.handle_interface_errors(
646: 'PO_DOCS_OPEN_INTERFACE',

Line 644: IF (x_document_type_code <> 'STANDARD') THEN

640: END IF;
641: --
642: -- Added the following 'if/else' for standard purchase orders.
643:
644: IF (x_document_type_code <> 'STANDARD') THEN
645: po_interface_errors_sv1.handle_interface_errors(
646: 'PO_DOCS_OPEN_INTERFACE',
647: 'FATAL',
648: null,

Line 661: -- Added the below procedure to populate error message is case of standard

657: null,null,null,null,null,
658: X_header_processable_flag);
659: ELSE
660: --
661: -- Added the below procedure to populate error message is case of standard
662: -- purchase orders.
663: po_interface_errors_sv1.handle_interface_errors(
664: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
665: x_error_type => 'FATAL',

Line 699: -- Added the following 'if/else' for standard purchase orders.

695: END IF;
696:
697: -- Bug 2449186. Truncate dates when comparing them. Also refactored update.
698: --
699: -- Added the following 'if/else' for standard purchase orders.
700:
701: IF (x_document_type_code <> 'STANDARD') THEN
702: SELECT po_header_id
703: INTO X_po_header_id

Line 701: IF (x_document_type_code <> 'STANDARD') THEN

697: -- Bug 2449186. Truncate dates when comparing them. Also refactored update.
698: --
699: -- Added the following 'if/else' for standard purchase orders.
700:
701: IF (x_document_type_code <> 'STANDARD') THEN
702: SELECT po_header_id
703: INTO X_po_header_id
704: FROM po_headers
705: WHERE vendor_id = X_vendor_id

Line 719: PO_DEBUG.put_line ('Calling status check api for standard POs');

715: --
716: -- Added the following api to check whether the document is in valid
717: -- status and updateable.
718: IF (g_po_pdoi_write_to_file = 'Y') THEN
719: PO_DEBUG.put_line ('Calling status check api for standard POs');
720: END IF;
721:
722: PO_DOCUMENT_CHECKS_GRP.po_status_check(
723: p_api_version => 1.0,

Line 727: p_document_subtype => 'STANDARD',

723: p_api_version => 1.0,
724: p_header_id => null,
725: p_release_id => null,
726: p_document_type => 'PO',
727: p_document_subtype => 'STANDARD',
728: p_document_num => x_document_num,
729: p_vendor_order_num => x_vendor_doc_num,
730: p_line_id => null,
731: p_line_location_id => null,

Line 763: PO_DEBUG.put_line ('Standard PO is not updatable');

759: if x_po_status_rec.updatable_flag(1) = 'N' or
760: x_consigned_consumption_flag='Y' then
761:
762: if (g_po_pdoi_write_to_file = 'Y') THEN
763: PO_DEBUG.put_line ('Standard PO is not updatable');
764: PO_DEBUG.put_line('x_po_status_rec.updatable_flag is ' || x_po_status_rec.updatable_flag(1));
765: PO_DEBUG.put_line ('x_consigned_consumption_flag is
766: '|| x_consigned_consumption_flag);
767: end if;

Line 870: elsif (x_document_type_code= 'STANDARD') then

866: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
867: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
868: AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');
869: --frkhan was not catching this case before so request was failing
870: elsif (x_document_type_code= 'STANDARD') then
871: x_temp := 0;
872: end if;
873:
874: IF (g_po_pdoi_write_to_file = 'Y') THEN