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 378: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT

374:
375: --
376: --Delete the Price differentials entity type for the given Line
377: PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff(
378: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT
379: ,p_doc_level_id => x_line_location_id);
380: --
381:
382: --dbms_output.put_line('after call to delete children');

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

966: IF (l_approved_flag IN ('Y', 'R'))
967: THEN
968: IF (l_shipment_type = 'PRICE BREAK')
969: THEN
970: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_PB_ON_APRVD_PO');
971: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
972: ELSE
973: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
974: ,'DOCUMENT_TYPE'

Line 971: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

967: THEN
968: IF (l_shipment_type = 'PRICE BREAK')
969: THEN
970: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_PB_ON_APRVD_PO');
971: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
972: ELSE
973: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
974: ,'DOCUMENT_TYPE'
975: , p_style_disp_name);

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

969: THEN
970: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_PB_ON_APRVD_PO');
971: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
972: ELSE
973: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
974: ,'DOCUMENT_TYPE'
975: , p_style_disp_name);
976: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
977: END IF;

Line 976: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

972: ELSE
973: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'
974: ,'DOCUMENT_TYPE'
975: , p_style_disp_name);
976: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
977: END IF;
978: END IF;
979:
980: d_pos := 20;

Line 982: PO_CORE_S.are_any_dists_reserved(

978: END IF;
979:
980: d_pos := 20;
981: -- Disallow a delete if any distributions are reserved.
982: PO_CORE_S.are_any_dists_reserved(
983: p_doc_type => p_doc_type,
984: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT,
985: p_doc_level_id => p_line_loc_id,
986: x_some_dists_reserved_flag => l_some_dists_reserved_flag);

Line 984: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT,

980: d_pos := 20;
981: -- Disallow a delete if any distributions are reserved.
982: PO_CORE_S.are_any_dists_reserved(
983: p_doc_type => p_doc_type,
984: p_doc_level => PO_CORE_S.g_doc_level_SHIPMENT,
985: p_doc_level_id => p_line_loc_id,
986: x_some_dists_reserved_flag => l_some_dists_reserved_flag);
987:
988: IF l_some_dists_reserved_flag = 'Y'

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

986: x_some_dists_reserved_flag => l_some_dists_reserved_flag);
987:
988: IF l_some_dists_reserved_flag = 'Y'
989: THEN
990: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
991: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
992: END IF;
993: d_pos := 30;
994:

Line 991: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

987:
988: IF l_some_dists_reserved_flag = 'Y'
989: THEN
990: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
991: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
992: END IF;
993: d_pos := 30;
994:
995: --

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

1003: AND nvl(closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN) <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
1004: AND nvl(cancel_flag, 'N') <> 'Y';
1005:
1006: --If we reach here then we have only one valid shipment and shopuld not allow its deletion
1007: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_SCHEDULE');
1008: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
1009: --
1010: EXCEPTION
1011: WHEN TOO_MANY_ROWS THEN

Line 1008: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

1004: AND nvl(cancel_flag, 'N') <> 'Y';
1005:
1006: --If we reach here then we have only one valid shipment and shopuld not allow its deletion
1007: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_SCHEDULE');
1008: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
1009: --
1010: EXCEPTION
1011: WHEN TOO_MANY_ROWS THEN
1012: --If there are multiple viable shipments then we can allow the deletion of this shipment

Line 1021: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

1017: PO_LOG.proc_end(d_module);
1018: END IF;
1019:
1020: EXCEPTION
1021: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
1022: IF (PO_LOG.d_stmt) THEN
1023: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
1024: END IF;
1025: WHEN OTHERS THEN

Line 1232: 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));

1228: l_price := nvl(l_price, l_po_lines_rec.unit_price);
1229: l_base_unit_price := nvl(l_price, l_po_lines_rec.base_unit_price);
1230: IF (PO_LOG.d_stmt) THEN
1231: PO_LOG.stmt(d_module, 'l_base_unit_price', l_base_unit_price); PO_LOG.stmt(d_module, 'l_price', l_price);
1232: 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));
1233: END IF;
1234:
1235: d_pos := 120;
1236: -- Update the line price and from_line_location_id in PO_LINES_ALL