DBA Data[Home] [Help]

APPS.PO_SHIPMENTS_SV4 dependencies on PO_CORE_S

Line 72: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT

68: '', '', '', '', 'Y');
69: --
70: --Delete the Price differentials entity type for the given Shipment
71: PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff(
72: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT
73: ,p_doc_level_id => x_line_location_id);
74: --
75:
76: END LOOP;

Line 144: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT

140: '', '', '', '', 'Y');
141: --
142: --Delete the Price differentials entity type for the given Shipment
143: PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff(
144: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT
145: ,p_doc_level_id => x_line_location_id);
146: --
147: END LOOP;
148:

Line 369: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT

365:
366: --
367: --Delete the Price differentials entity type for the given Line
368: PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff(
369: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT
370: ,p_doc_level_id => x_line_location_id);
371: --
372:
373: --dbms_output.put_line('after call to delete children');

Line 950: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_PB_ON_APRVD_PO');

946: IF (l_approved_flag IN ('Y', 'R'))
947: THEN
948: IF (l_shipment_type = 'PRICE BREAK')
949: THEN
950: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_PB_ON_APRVD_PO');
951: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
952: ELSE
953: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
954: ,'DOCUMENT_TYPE'

Line 951: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

947: THEN
948: IF (l_shipment_type = 'PRICE BREAK')
949: THEN
950: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_PB_ON_APRVD_PO');
951: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
952: ELSE
953: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
954: ,'DOCUMENT_TYPE'
955: , p_style_disp_name);

Line 953: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'

949: THEN
950: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_PB_ON_APRVD_PO');
951: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
952: ELSE
953: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
954: ,'DOCUMENT_TYPE'
955: , p_style_disp_name);
956: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
957: END IF;

Line 956: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

952: ELSE
953: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
954: ,'DOCUMENT_TYPE'
955: , p_style_disp_name);
956: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
957: END IF;
958: END IF;
959:
960: d_pos := 20;

Line 962: PO_CORE_S.are_any_dists_reserved(

958: END IF;
959:
960: d_pos := 20;
961: -- Disallow a delete if any distributions are reserved.
962: PO_CORE_S.are_any_dists_reserved(
963: p_doc_type => p_doc_type,
964: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT,
965: p_doc_level_id => p_line_loc_id,
966: x_some_dists_reserved_flag => l_some_dists_reserved_flag);

Line 964: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT,

960: d_pos := 20;
961: -- Disallow a delete if any distributions are reserved.
962: PO_CORE_S.are_any_dists_reserved(
963: p_doc_type => p_doc_type,
964: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT,
965: p_doc_level_id => p_line_loc_id,
966: x_some_dists_reserved_flag => l_some_dists_reserved_flag);
967:
968: IF l_some_dists_reserved_flag = 'Y'

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

966: x_some_dists_reserved_flag => l_some_dists_reserved_flag);
967:
968: IF l_some_dists_reserved_flag = 'Y'
969: THEN
970: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
971: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
972: END IF;
973: d_pos := 30;
974:

Line 971: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

967:
968: IF l_some_dists_reserved_flag = 'Y'
969: THEN
970: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
971: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
972: END IF;
973: d_pos := 30;
974:
975: --

Line 987: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_SCHEDULE');

983: AND nvl(closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN) <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
984: AND nvl(cancel_flag, 'N') <> 'Y';
985:
986: --If we reach here then we have only one valid shipment and shopuld not allow its deletion
987: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_SCHEDULE');
988: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
989: --
990: EXCEPTION
991: WHEN TOO_MANY_ROWS THEN

Line 988: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

984: AND nvl(cancel_flag, 'N') <> 'Y';
985:
986: --If we reach here then we have only one valid shipment and shopuld not allow its deletion
987: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_SCHEDULE');
988: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
989: --
990: EXCEPTION
991: WHEN TOO_MANY_ROWS THEN
992: --If there are multiple viable shipments then we can allow the deletion of this shipment

Line 1001: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

997: PO_LOG.proc_end(d_module);
998: END IF;
999:
1000: EXCEPTION
1001: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
1002: IF (PO_LOG.d_stmt) THEN
1003: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1004: END IF;
1005: WHEN OTHERS THEN

Line 1212: PO_LOG.stmt(d_module, 'boolean coverted to char: l_is_source_info_changed', PO_CORE_S.boolean_to_flag(l_is_source_info_changed));

1208: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1209: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1210: IF (PO_LOG.d_stmt) THEN
1211: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1212: PO_LOG.stmt(d_module, 'boolean coverted to char: l_is_source_info_changed', PO_CORE_S.boolean_to_flag(l_is_source_info_changed));
1213: END IF;
1214:
1215: d_pos := 120;
1216: -- Update the line price and from_line_location_id in PO_LINES_ALL