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);
215: END IF;
216:
217: --Initialize message list if p_init_msg_list is TRUE.
218: IF FND_API.To_Boolean (p_init_msg_list) THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message
223: IF OZF_DEBUG_HIGH_ON THEN
667: IF OZF_DEBUG_HIGH_ON THEN
668: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
669: END IF;
670: --Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
675: );
678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO INIT_PAYMENT_SPP;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );
688: ROLLBACK TO INIT_PAYMENT_SPP;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690:
691: -- Standard call to get message count and if count=1, get the message
692: FND_MSG_PUB.Count_And_Get (
693: p_encoded => FND_API.G_FALSE,
694: p_count => x_msg_count,
695: p_data => x_msg_data
696: );
698: ROLLBACK TO INIT_PAYMENT_SPP;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700:
701: -- Standard call to get message count and if count=1, get the message
702: FND_MSG_PUB.Count_And_Get (
703: p_encoded => FND_API.G_FALSE,
704: p_count => x_msg_count,
705: p_data => x_msg_data
706: );
747: END IF;
748:
749: --Initialize message list if p_init_msg_list is TRUE.
750: IF FND_API.To_Boolean (p_init_msg_list) THEN
751: FND_MSG_PUB.initialize;
752: END IF;
753:
754: -- Debug Message
755: IF OZF_DEBUG_HIGH_ON THEN
883: IF OZF_DEBUG_HIGH_ON THEN
884: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
885: END IF;
886: --Standard call to get message count and if count=1, get the message
887: FND_MSG_PUB.Count_And_Get (
888: p_encoded => FND_API.G_FALSE,
889: p_count => x_msg_count,
890: p_data => x_msg_data
891: );
892: EXCEPTION
893: WHEN FND_API.G_EXC_ERROR THEN
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: -- Standard call to get message count and if count=1, get the message
896: FND_MSG_PUB.Count_And_Get (
897: p_encoded => FND_API.G_FALSE,
898: p_count => x_msg_count,
899: p_data => x_msg_data
900: );
900: );
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: -- Standard call to get message count and if count=1, get the message
904: FND_MSG_PUB.Count_And_Get (
905: p_encoded => FND_API.G_FALSE,
906: p_count => x_msg_count,
907: p_data => x_msg_data
908: );
909: WHEN OTHERS THEN
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911:
912: -- Standard call to get message count and if count=1, get the message
913: FND_MSG_PUB.Count_And_Get (
914: p_encoded => FND_API.G_FALSE,
915: p_count => x_msg_count,
916: p_data => x_msg_data
917: );
1378: END;
1379: GOTO END_LOOP;
1380: END IF;
1381:
1382: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1383: OZF_UTILITY_PVT.debug_message('line currency '||l_order_set_tbl(J).currency_code );
1384: END IF;
1385: IF l_order_set_tbl(J).currency_code <> l_header_currency_code THEN
1386: BEGIN
1928: END IF;
1929:
1930: --Initialize message list if p_init_msg_list is TRUE.
1931: IF FND_API.To_Boolean (p_init_msg_list) THEN
1932: FND_MSG_PUB.initialize;
1933: END IF;
1934:
1935: -- Debug Message
1936: IF OZF_DEBUG_HIGH_ON THEN
2061: IF OZF_DEBUG_HIGH_ON THEN
2062: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2063: END IF;
2064: --Standard call to get message count and if count=1, get the message
2065: FND_MSG_PUB.Count_And_Get (
2066: p_encoded => FND_API.G_FALSE,
2067: p_count => x_msg_count,
2068: p_data => x_msg_data
2069: );
2072: WHEN FND_API.G_EXC_ERROR THEN
2073: ROLLBACK TO Process_SPP_Order;
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: -- Standard call to get message count and if count=1, get the message
2076: FND_MSG_PUB.Count_And_Get (
2077: p_encoded => FND_API.G_FALSE,
2078: p_count => x_msg_count,
2079: p_data => x_msg_data
2080: );
2082: ROLLBACK TO Process_SPP_Order;
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084:
2085: -- Standard call to get message count and if count=1, get the message
2086: FND_MSG_PUB.Count_And_Get (
2087: p_encoded => FND_API.G_FALSE,
2088: p_count => x_msg_count,
2089: p_data => x_msg_data
2090: );
2092: ROLLBACK TO Process_SPP_Order;
2093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2094:
2095: -- Standard call to get message count and if count=1, get the message
2096: FND_MSG_PUB.Count_And_Get (
2097: p_encoded => FND_API.G_FALSE,
2098: p_count => x_msg_count,
2099: p_data => x_msg_data
2100: );