17: G_SPECIAL_PRICING_OBJ CONSTANT VARCHAR2(30) :='SPECIAL_PRICE';
18:
19: G_SPP_UTIL_TYPE CONSTANT VARCHAR2(30) :='UTILIZED';
20:
21: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:
18:
19: G_SPP_UTIL_TYPE CONSTANT VARCHAR2(30) :='UTILIZED';
20:
21: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:
26: G_OFF_INVOICE_OFFER CONSTANT VARCHAR2(30) :='OFF_INVOICE';
19: G_SPP_UTIL_TYPE CONSTANT VARCHAR2(30) :='UTILIZED';
20:
21: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:
26: G_OFF_INVOICE_OFFER CONSTANT VARCHAR2(30) :='OFF_INVOICE';
27:
20:
21: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:
26: G_OFF_INVOICE_OFFER CONSTANT VARCHAR2(30) :='OFF_INVOICE';
27:
28: g_inventory_tracking VARCHAR2(1);
240: END IF;
241:
242: --Initialize message list if p_init_msg_list is TRUE.
243: IF FND_API.To_Boolean (p_init_msg_list) THEN
244: FND_MSG_PUB.initialize;
245: END IF;
246:
247: -- Debug Message
248: IF OZF_DEBUG_HIGH_ON THEN
723: IF OZF_DEBUG_HIGH_ON THEN
724: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
725: END IF;
726: --Standard call to get message count and if count=1, get the message
727: FND_MSG_PUB.Count_And_Get (
728: p_encoded => FND_API.G_FALSE,
729: p_count => x_msg_count,
730: p_data => x_msg_data
731: );
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO INIT_PAYMENT_SPP;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: -- Standard call to get message count and if count=1, get the message
738: FND_MSG_PUB.Count_And_Get (
739: p_encoded => FND_API.G_FALSE,
740: p_count => x_msg_count,
741: p_data => x_msg_data
742: );
744: ROLLBACK TO INIT_PAYMENT_SPP;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746:
747: -- Standard call to get message count and if count=1, get the message
748: FND_MSG_PUB.Count_And_Get (
749: p_encoded => FND_API.G_FALSE,
750: p_count => x_msg_count,
751: p_data => x_msg_data
752: );
754: ROLLBACK TO INIT_PAYMENT_SPP;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756:
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
803: END IF;
804:
805: --Initialize message list if p_init_msg_list is TRUE.
806: IF FND_API.To_Boolean (p_init_msg_list) THEN
807: FND_MSG_PUB.initialize;
808: END IF;
809:
810: -- Debug Message
811: IF OZF_DEBUG_HIGH_ON THEN
939: IF OZF_DEBUG_HIGH_ON THEN
940: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
941: END IF;
942: --Standard call to get message count and if count=1, get the message
943: FND_MSG_PUB.Count_And_Get (
944: p_encoded => FND_API.G_FALSE,
945: p_count => x_msg_count,
946: p_data => x_msg_data
947: );
948: EXCEPTION
949: WHEN FND_API.G_EXC_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: -- Standard call to get message count and if count=1, get the message
952: FND_MSG_PUB.Count_And_Get (
953: p_encoded => FND_API.G_FALSE,
954: p_count => x_msg_count,
955: p_data => x_msg_data
956: );
956: );
957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959: -- Standard call to get message count and if count=1, get the message
960: FND_MSG_PUB.Count_And_Get (
961: p_encoded => FND_API.G_FALSE,
962: p_count => x_msg_count,
963: p_data => x_msg_data
964: );
965: WHEN OTHERS THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967:
968: -- Standard call to get message count and if count=1, get the message
969: FND_MSG_PUB.Count_And_Get (
970: p_encoded => FND_API.G_FALSE,
971: p_count => x_msg_count,
972: p_data => x_msg_data
973: );
1459: END;
1460: GOTO END_LOOP;
1461: END IF;
1462:
1463: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1464: OZF_UTILITY_PVT.debug_message('line currency '||l_order_set_tbl(J).currency_code );
1465: END IF;
1466: IF l_order_set_tbl(J).currency_code <> l_header_currency_code THEN
1467: BEGIN
2032: END IF;
2033:
2034: --Initialize message list if p_init_msg_list is TRUE.
2035: IF FND_API.To_Boolean (p_init_msg_list) THEN
2036: FND_MSG_PUB.initialize;
2037: END IF;
2038:
2039: -- Debug Message
2040: IF OZF_DEBUG_HIGH_ON THEN
2165: IF OZF_DEBUG_HIGH_ON THEN
2166: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2167: END IF;
2168: --Standard call to get message count and if count=1, get the message
2169: FND_MSG_PUB.Count_And_Get (
2170: p_encoded => FND_API.G_FALSE,
2171: p_count => x_msg_count,
2172: p_data => x_msg_data
2173: );
2176: WHEN FND_API.G_EXC_ERROR THEN
2177: ROLLBACK TO Process_SPP_Order;
2178: x_return_status := FND_API.G_RET_STS_ERROR;
2179: -- Standard call to get message count and if count=1, get the message
2180: FND_MSG_PUB.Count_And_Get (
2181: p_encoded => FND_API.G_FALSE,
2182: p_count => x_msg_count,
2183: p_data => x_msg_data
2184: );
2186: ROLLBACK TO Process_SPP_Order;
2187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2188:
2189: -- Standard call to get message count and if count=1, get the message
2190: FND_MSG_PUB.Count_And_Get (
2191: p_encoded => FND_API.G_FALSE,
2192: p_count => x_msg_count,
2193: p_data => x_msg_data
2194: );
2196: ROLLBACK TO Process_SPP_Order;
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198:
2199: -- Standard call to get message count and if count=1, get the message
2200: FND_MSG_PUB.Count_And_Get (
2201: p_encoded => FND_API.G_FALSE,
2202: p_count => x_msg_count,
2203: p_data => x_msg_data
2204: );