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_DISTRIBUTIONS_SV dependencies on PO_CORE_S

Line 700: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');

696: IF l_req_distribution_id IS NOT NULL
697: THEN
698: IF(l_is_complex_work_po = FALSE) --BUG 5553581
699: THEN
700: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');
701: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
702: ELSE
703: BEGIN --5553581
704: select po_distribution_id

Line 701: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

697: THEN
698: IF(l_is_complex_work_po = FALSE) --BUG 5553581
699: THEN
700: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');
701: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
702: ELSE
703: BEGIN --5553581
704: select po_distribution_id
705: into l_dummy

Line 710: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');

706: FROM po_distributions_all pod
707: WHERE pod.line_location_id = p_line_loc_id
708: AND pod.req_distribution_id = l_req_distribution_id;
709:
710: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');
711: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
712: EXCEPTION
713: WHEN TOO_MANY_ROWS THEN
714: --If there are multiple rows then we can go ahead and delete

Line 711: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

707: WHERE pod.line_location_id = p_line_loc_id
708: AND pod.req_distribution_id = l_req_distribution_id;
709:
710: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');
711: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
712: EXCEPTION
713: WHEN TOO_MANY_ROWS THEN
714: --If there are multiple rows then we can go ahead and delete
715: NULL;

Line 725: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DELETE_DEL_DIST_NA');

721: -- Has been Delivered
722: IF l_quantity_delivered > 0
723: OR l_amount_delivered > 0
724: THEN
725: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DELETE_DEL_DIST_NA');
726: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
727: END IF;
728:
729: d_pos := 30;

Line 726: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

722: IF l_quantity_delivered > 0
723: OR l_amount_delivered > 0
724: THEN
725: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DELETE_DEL_DIST_NA');
726: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
727: END IF;
728:
729: d_pos := 30;
730: --Has been Billed

Line 734: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DELETE_DIST_BILLED_NA');

730: --Has been Billed
731: IF l_quantity_billed > 0
732: OR l_amount_billed > 0
733: THEN
734: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DELETE_DIST_BILLED_NA');
735: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
736: END IF;
737:
738: d_pos := 40;

Line 735: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

731: IF l_quantity_billed > 0
732: OR l_amount_billed > 0
733: THEN
734: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DELETE_DIST_BILLED_NA');
735: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
736: END IF;
737:
738: d_pos := 40;
739: -- is Encumbered

Line 742: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');

738: d_pos := 40;
739: -- is Encumbered
740: IF l_encumbered_flag = 'Y'
741: THEN
742: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
743: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
744: END IF;
745:
746: d_pos := 50;

Line 743: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

739: -- is Encumbered
740: IF l_encumbered_flag = 'Y'
741: THEN
742: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
743: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
744: END IF;
745:
746: d_pos := 50;
747: -- Approved atleast once

Line 750: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3');

746: d_pos := 50;
747: -- Approved atleast once
748: IF (l_creation_date <= p_approved_date)
749: THEN
750: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3');
751: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
752: END IF;
753:
754: d_pos := 60;

Line 751: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

747: -- Approved atleast once
748: IF (l_creation_date <= p_approved_date)
749: THEN
750: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3');
751: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
752: END IF;
753:
754: d_pos := 60;
755: -- If there is only one single viable distribution then we should not allow to

Line 763: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_DIST');

759: into l_dummy
760: FROM po_distributions_all pod
761: WHERE pod.line_location_id = p_line_loc_id;
762:
763: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_DIST');
764: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
765: EXCEPTION
766: WHEN TOO_MANY_ROWS THEN
767: --If there are multiple rows then we can go ahead and delete

Line 764: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

760: FROM po_distributions_all pod
761: WHERE pod.line_location_id = p_line_loc_id;
762:
763: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_DIST');
764: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
765: EXCEPTION
766: WHEN TOO_MANY_ROWS THEN
767: --If there are multiple rows then we can go ahead and delete
768: NULL;

Line 771: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

767: --If there are multiple rows then we can go ahead and delete
768: NULL;
769: END;
770: EXCEPTION
771: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
772: NULL;
773: IF (PO_LOG.d_stmt) THEN
774: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
775: END IF;