13:
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SALES_TRANSACTIONS_PVT';
15: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvstnb.pls';
16:
17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
19:
20: G_COMMON_UOM_CODE VARCHAR2(30) := FND_PROFILE.value('OZF_TP_COMMON_UOM');
21: G_COMMON_CURRENCY_CODE VARCHAR2(15) := FND_PROFILE.value('OZF_TP_COMMON_CURRENCY');
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SALES_TRANSACTIONS_PVT';
15: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvstnb.pls';
16:
17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
19:
20: G_COMMON_UOM_CODE VARCHAR2(30) := FND_PROFILE.value('OZF_TP_COMMON_UOM');
21: G_COMMON_CURRENCY_CODE VARCHAR2(15) := FND_PROFILE.value('OZF_TP_COMMON_CURRENCY');
22: ---------------------------------------------------------------------
71: END IF;
72:
73: --Initialize message list if p_init_msg_list is TRUE.
74: IF FND_API.To_Boolean (p_init_msg_list) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message
79: IF OZF_DEBUG_LOW_ON THEN
159: IF OZF_DEBUG_LOW_ON THEN
160: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
161: END IF;
162: --Standard call to get message count and if count=1, get the message
163: FND_MSG_PUB.Count_And_Get (
164: p_encoded => FND_API.G_FALSE,
165: p_count => x_msg_count,
166: p_data => x_msg_data
167: );
169: WHEN FND_API.G_EXC_ERROR THEN
170: ROLLBACK TO Validate_trans_PVT;
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: -- Standard call to get message count and if count=1, get the message
173: FND_MSG_PUB.Count_And_Get (
174: p_encoded => FND_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: ROLLBACK TO Validate_trans_PVT;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: -- Standard call to get message count and if count=1, get the message
182: FND_MSG_PUB.Count_And_Get (
183: p_encoded => FND_API.G_FALSE,
184: p_count => x_msg_count,
185: p_data => x_msg_data
186: );
186: );
187: WHEN OTHERS THEN
188: ROLLBACK TO Validate_trans_PVT;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
193: END IF;
194: -- Standard call to get message count and if count=1, get the message
188: ROLLBACK TO Validate_trans_PVT;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
193: END IF;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
193: END IF;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );
277: END IF;
278:
279: --Initialize message list if p_init_msg_list is TRUE.
280: IF FND_API.To_Boolean (p_init_msg_list) THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284: -- Debug Message
285: IF OZF_DEBUG_LOW_ON THEN
604: IF OZF_DEBUG_LOW_ON THEN
605: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
606: END IF;
607: --Standard call to get message count and if count=1, get the message
608: FND_MSG_PUB.Count_And_Get (
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data
612: );
615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO CREATE_TRANSACTION;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: -- Standard call to get message count and if count=1, get the message
619: FND_MSG_PUB.Count_And_Get (
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data
623: );
625: ROLLBACK TO CREATE_TRANSACTION;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627:
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
635: ROLLBACK TO CREATE_TRANSACTION;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637:
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data
643: );
697: END IF;
698:
699: --Initialize message list if p_init_msg_list is TRUE.
700: IF FND_API.To_Boolean (p_init_msg_list) THEN
701: FND_MSG_PUB.initialize;
702: END IF;
703:
704: -- Debug Message
705: IF OZF_DEBUG_LOW_ON THEN
936: IF OZF_DEBUG_LOW_ON THEN
937: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
938: END IF;
939: --Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count,
943: p_data => x_msg_data
944: );
947: WHEN FND_API.G_EXC_ERROR THEN
948: ROLLBACK TO INIT_INVEN_TMP;
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: -- Standard call to get message count and if count=1, get the message
951: FND_MSG_PUB.Count_And_Get (
952: p_encoded => FND_API.G_FALSE,
953: p_count => x_msg_count,
954: p_data => x_msg_data
955: );
957: ROLLBACK TO INIT_INVEN_TMP;
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: -- Standard call to get message count and if count=1, get the message
961: FND_MSG_PUB.Count_And_Get (
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data
965: );
967: ROLLBACK TO INIT_INVEN_TMP;
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969:
970: -- Standard call to get message count and if count=1, get the message
971: FND_MSG_PUB.Count_And_Get (
972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,
974: p_data => x_msg_data
975: );
1027: END IF;
1028:
1029: --Initialize message list if p_init_msg_list is TRUE.
1030: IF FND_API.To_Boolean (p_init_msg_list) THEN
1031: FND_MSG_PUB.initialize;
1032: END IF;
1033:
1034: -- Debug Message
1035: IF OZF_DEBUG_LOW_ON THEN
1058: IF OZF_DEBUG_LOW_ON THEN
1059: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1060: END IF;
1061: --Standard call to get message count and if count=1, get the message
1062: FND_MSG_PUB.Count_And_Get (
1063: p_encoded => FND_API.G_FALSE,
1064: p_count => x_msg_count,
1065: p_data => x_msg_data
1066: );
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: ROLLBACK TO UPD_INVEN_TMP;
1071: x_return_status := FND_API.G_RET_STS_ERROR;
1072: -- Standard call to get message count and if count=1, get the message
1073: FND_MSG_PUB.Count_And_Get (
1074: p_encoded => FND_API.G_FALSE,
1075: p_count => x_msg_count,
1076: p_data => x_msg_data
1077: );
1079: ROLLBACK TO UPD_INVEN_TMP;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081:
1082: -- Standard call to get message count and if count=1, get the message
1083: FND_MSG_PUB.Count_And_Get (
1084: p_encoded => FND_API.G_FALSE,
1085: p_count => x_msg_count,
1086: p_data => x_msg_data
1087: );
1089: ROLLBACK TO UPD_INVEN_TMP;
1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1091:
1092: -- Standard call to get message count and if count=1, get the message
1093: FND_MSG_PUB.Count_And_Get (
1094: p_encoded => FND_API.G_FALSE,
1095: p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );
1191: END IF;
1192:
1193: --Initialize message list if p_init_msg_list is TRUE.
1194: IF FND_API.To_Boolean (p_init_msg_list) THEN
1195: FND_MSG_PUB.initialize;
1196: END IF;
1197:
1198: -- Debug Message
1199: IF OZF_DEBUG_LOW_ON THEN
1343: IF OZF_DEBUG_LOW_ON THEN
1344: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1345: END IF;
1346: --Standard call to get message count and if count=1, get the message
1347: FND_MSG_PUB.Count_And_Get (
1348: p_encoded => FND_API.G_FALSE,
1349: p_count => x_msg_count,
1350: p_data => x_msg_data
1351: );
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: ROLLBACK TO VALID_INV_LVL;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: -- Standard call to get message count and if count=1, get the message
1359: FND_MSG_PUB.Count_And_Get (
1360: p_encoded => FND_API.G_FALSE,
1361: p_count => x_msg_count,
1362: p_data => x_msg_data
1363: );
1365: ROLLBACK TO VALID_INV_LVL;
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367:
1368: -- Standard call to get message count and if count=1, get the message
1369: FND_MSG_PUB.Count_And_Get (
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,
1372: p_data => x_msg_data
1373: );
1375: ROLLBACK TO VALID_INV_LVL;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377:
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,
1381: p_count => x_msg_count,
1382: p_data => x_msg_data
1383: );
1475: END IF;
1476:
1477: --Initialize message list if p_init_msg_list is TRUE.
1478: IF FND_API.To_Boolean (p_init_msg_list) THEN
1479: FND_MSG_PUB.initialize;
1480: END IF;
1481:
1482: -- Debug Message
1483: IF OZF_DEBUG_LOW_ON THEN
1602: IF OZF_DEBUG_LOW_ON THEN
1603: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1604: END IF;
1605: --Standard call to get message count and if count=1, get the message
1606: FND_MSG_PUB.Count_And_Get (
1607: p_encoded => FND_API.G_FALSE,
1608: p_count => x_msg_count,
1609: p_data => x_msg_data
1610: );
1614: WHEN FND_API.G_EXC_ERROR THEN
1615: ROLLBACK TO GET_WAC;
1616: x_return_status := FND_API.G_RET_STS_ERROR;
1617: -- Standard call to get message count and if count=1, get the message
1618: FND_MSG_PUB.Count_And_Get (
1619: p_encoded => FND_API.G_FALSE,
1620: p_count => x_msg_count,
1621: p_data => x_msg_data
1622: );
1624: ROLLBACK TO GET_WAC;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626:
1627: -- Standard call to get message count and if count=1, get the message
1628: FND_MSG_PUB.Count_And_Get (
1629: p_encoded => FND_API.G_FALSE,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data
1632: );
1634: ROLLBACK TO GET_WAC;
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636:
1637: -- Standard call to get message count and if count=1, get the message
1638: FND_MSG_PUB.Count_And_Get (
1639: p_encoded => FND_API.G_FALSE,
1640: p_count => x_msg_count,
1641: p_data => x_msg_data
1642: );