DBA Data[Home] [Help]

APPS.OZF_RESALE_PVT dependencies on STANDARD

Line 57: -- Standard begin of API savepoint

53:
54: l_batch_type varchar2(30);
55: l_org_id number;
56: BEGIN
57: -- Standard begin of API savepoint
58: SAVEPOINT INITIATE_PAYMENT;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call (
61: l_api_version,

Line 59: -- Standard call to check for call compatibility.

55: l_org_id number;
56: BEGIN
57: -- Standard begin of API savepoint
58: SAVEPOINT INITIATE_PAYMENT;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call (
61: l_api_version,
62: p_api_version,
63: l_api_name,

Line 168: --Standard call to get message count and if count=1, get the message

164: -- Debug Message
165: IF OZF_DEBUG_HIGH_ON THEN
166: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
167: END IF;
168: --Standard call to get message count and if count=1, get the message
169: FND_MSG_PUB.Count_And_Get (
170: p_encoded => FND_API.G_FALSE,
171: p_count => x_msg_count,
172: p_data => x_msg_data

Line 180: -- Standard call to get message count and if count=1, get the message

176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO INITIATE_PAYMENT;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data

Line 189: -- Standard call to get message count and if count=1, get the message

185: );
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO INITIATE_PAYMENT;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_MSG_PUB.Count_And_Get (
191: p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data

Line 198: -- Standard call to get message count and if count=1, get the message

194: );
195: WHEN OTHERS THEN
196: ROLLBACK TO INITIATE_PAYMENT;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: -- Standard call to get message count and if count=1, get the message
199: FND_MSG_PUB.Count_And_Get (
200: p_encoded => FND_API.G_FALSE,
201: p_count => x_msg_count,
202: p_data => x_msg_data

Line 371: -- Standard begin of API savepoint

367: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED
368: AND resale_batch_id = p_id;
369: --
370: BEGIN
371: -- Standard begin of API savepoint
372: SAVEPOINT PROCESS_IFACE;
373: -- Standard call to check for call compatibility.
374: IF NOT FND_API.Compatible_API_Call (
375: l_api_version,

Line 373: -- Standard call to check for call compatibility.

369: --
370: BEGIN
371: -- Standard begin of API savepoint
372: SAVEPOINT PROCESS_IFACE;
373: -- Standard call to check for call compatibility.
374: IF NOT FND_API.Compatible_API_Call (
375: l_api_version,
376: p_api_version,
377: l_api_name,

Line 664: --Standard call to get message count and if count=1, get the message

660: -- Debug Message
661: IF OZF_DEBUG_HIGH_ON THEN
662: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
663: END IF;
664: --Standard call to get message count and if count=1, get the message
665: FND_MSG_PUB.Count_And_Get (
666: p_encoded => FND_API.G_FALSE,
667: p_count => x_msg_count,
668: p_data => x_msg_data

Line 674: -- Standard call to get message count and if count=1, get the message

670:
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: -- Standard call to get message count and if count=1, get the message
675: FND_MSG_PUB.Count_And_Get (
676: p_encoded => FND_API.G_FALSE,
677: p_count => x_msg_count,
678: p_data => x_msg_data

Line 682: -- Standard call to get message count and if count=1, get the message

678: p_data => x_msg_data
679: );
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: -- Standard call to get message count and if count=1, get the message
683: FND_MSG_PUB.Count_And_Get (
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_msg_count,
686: p_data => x_msg_data

Line 691: -- Standard call to get message count and if count=1, get the message

687: );
688: WHEN OTHERS THEN
689: ROLLBACK TO PROCESS_IFACE;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 876: -- Standard begin of API savepoint

872: WHERE resale_batch_id = cv_batch_id;
873:
874: BEGIN
875:
876: -- Standard begin of API savepoint
877: SAVEPOINT PROCESS_RESALE;
878: -- Standard call to check for call compatibility.
879: IF NOT FND_API.Compatible_API_Call (
880: l_api_version,

Line 878: -- Standard call to check for call compatibility.

874: BEGIN
875:
876: -- Standard begin of API savepoint
877: SAVEPOINT PROCESS_RESALE;
878: -- Standard call to check for call compatibility.
879: IF NOT FND_API.Compatible_API_Call (
880: l_api_version,
881: p_api_version,
882: l_api_name,

Line 959: --Standard call to get message count and if count=1, get the message

955: -- Debug Message
956: IF OZF_DEBUG_HIGH_ON THEN
957: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
958: END IF;
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

Line 968: -- Standard call to get message count and if count=1, get the message

964: );
965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN
967: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 976: -- Standard call to get message count and if count=1, get the message

972: p_data => x_msg_data
973: );
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: -- Standard call to get message count and if count=1, get the message
977: FND_MSG_PUB.Count_And_Get (
978: p_encoded => FND_API.G_FALSE,
979: p_count => x_msg_count,
980: p_data => x_msg_data

Line 985: -- Standard call to get message count and if count=1, get the message

981: );
982: WHEN OTHERS THEN
983: ROLLBACK TO PROCESS_RESALE;
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: -- Standard call to get message count and if count=1, get the message
986: FND_MSG_PUB.Count_And_Get (
987: p_encoded => FND_API.G_FALSE,
988: p_count => x_msg_count,
989: p_data => x_msg_data

Line 1057: -- Standard begin of API savepoint

1053: l_batch_id_tbl batch_id_tbl_type;
1054:
1055: i number;
1056: BEGIN
1057: -- Standard begin of API savepoint
1058: SAVEPOINT PROCESS_RESALE_ALL;
1059: -- Standard call to check for call compatibility.
1060: IF NOT FND_API.Compatible_API_Call (
1061: l_api_version,

Line 1059: -- Standard call to check for call compatibility.

1055: i number;
1056: BEGIN
1057: -- Standard begin of API savepoint
1058: SAVEPOINT PROCESS_RESALE_ALL;
1059: -- Standard call to check for call compatibility.
1060: IF NOT FND_API.Compatible_API_Call (
1061: l_api_version,
1062: p_api_version,
1063: l_api_name,

Line 1188: --Standard call to get message count and if count=1, get the message

1184: -- Debug Message
1185: IF OZF_DEBUG_HIGH_ON THEN
1186: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1187: END IF;
1188: --Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get (
1190: p_encoded => FND_API.G_FALSE,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data

Line 1197: -- Standard call to get message count and if count=1, get the message

1193: );
1194: EXCEPTION
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: -- Standard call to get message count and if count=1, get the message
1198: FND_MSG_PUB.Count_And_Get (
1199: p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data

Line 1205: -- Standard call to get message count and if count=1, get the message

1201: p_data => x_msg_data
1202: );
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: -- Standard call to get message count and if count=1, get the message
1206: FND_MSG_PUB.Count_And_Get (
1207: p_encoded => FND_API.G_FALSE,
1208: p_count => x_msg_count,
1209: p_data => x_msg_data

Line 1214: -- Standard call to get message count and if count=1, get the message

1210: );
1211: WHEN OTHERS THEN
1212: ROLLBACK TO PROCESS_RESALE_ALL;
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: -- Standard call to get message count and if count=1, get the message
1215: FND_MSG_PUB.Count_And_Get (
1216: p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data

Line 1465: -- Standard begin of API savepoint

1461: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1462: --
1463:
1464: BEGIN
1465: -- Standard begin of API savepoint
1466: SAVEPOINT Resale_Purge;
1467: -- Standard call to check for call compatibility.
1468: IF NOT FND_API.Compatible_API_Call (
1469: l_api_version,

Line 1467: -- Standard call to check for call compatibility.

1463:
1464: BEGIN
1465: -- Standard begin of API savepoint
1466: SAVEPOINT Resale_Purge;
1467: -- Standard call to check for call compatibility.
1468: IF NOT FND_API.Compatible_API_Call (
1469: l_api_version,
1470: p_api_version,
1471: l_api_name,

Line 1582: --Standard call to get message count and if count=1, get the message

1578: -- Debug Message
1579: IF OZF_DEBUG_HIGH_ON THEN
1580: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1581: END IF;
1582: --Standard call to get message count and if count=1, get the message
1583: FND_MSG_PUB.Count_And_Get (
1584: p_encoded => FND_API.G_FALSE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data

Line 1594: -- Standard call to get message count and if count=1, get the message

1590: WHEN FND_API.G_EXC_ERROR THEN
1591: ROLLBACK TO Resale_Purge ;
1592:
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data

Line 1604: -- Standard call to get message count and if count=1, get the message

1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: ROLLBACK TO Resale_Purge;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603:
1604: -- Standard call to get message count and if count=1, get the message
1605: FND_MSG_PUB.Count_And_Get (
1606: p_encoded => FND_API.G_FALSE,
1607: p_count => x_msg_count,
1608: p_data => x_msg_data

Line 1614: -- Standard call to get message count and if count=1, get the message

1610: WHEN OTHERS THEN
1611: ROLLBACK TO Resale_Purge;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1613:
1614: -- Standard call to get message count and if count=1, get the message
1615: FND_MSG_PUB.Count_And_Get (
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data