DBA Data[Home] [Help]

APPS.OZF_RESALE_PVT dependencies on STANDARD

Line 56: -- Standard begin of API savepoint

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

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

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

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

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

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

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

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

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

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

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

Line 370: -- Standard begin of API savepoint

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

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

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

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

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

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

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

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

677: p_data => x_msg_data
678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_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

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

686: );
687: WHEN OTHERS THEN
688: ROLLBACK TO PROCESS_IFACE;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data

Line 832: -- Standard begin of API savepoint

828: WHERE resale_batch_id = cv_batch_id;
829:
830: BEGIN
831:
832: -- Standard begin of API savepoint
833: SAVEPOINT PROCESS_RESALE;
834: -- Standard call to check for call compatibility.
835: IF NOT FND_API.Compatible_API_Call (
836: l_api_version,

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

830: BEGIN
831:
832: -- Standard begin of API savepoint
833: SAVEPOINT PROCESS_RESALE;
834: -- Standard call to check for call compatibility.
835: IF NOT FND_API.Compatible_API_Call (
836: l_api_version,
837: p_api_version,
838: l_api_name,

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

911: -- Debug Message
912: IF OZF_DEBUG_HIGH_ON THEN
913: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
914: END IF;
915: --Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data

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

920: );
921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data

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

928: p_data => x_msg_data
929: );
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get (
934: p_encoded => FND_API.G_FALSE,
935: p_count => x_msg_count,
936: p_data => x_msg_data

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

937: );
938: WHEN OTHERS THEN
939: ROLLBACK TO PROCESS_RESALE;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: -- Standard call to get message count and if count=1, get the message
942: FND_MSG_PUB.Count_And_Get (
943: p_encoded => FND_API.G_FALSE,
944: p_count => x_msg_count,
945: p_data => x_msg_data

Line 1012: -- Standard begin of API savepoint

1008: l_batch_id_tbl batch_id_tbl_type;
1009:
1010: i number;
1011: BEGIN
1012: -- Standard begin of API savepoint
1013: SAVEPOINT PROCESS_RESALE_ALL;
1014: -- Standard call to check for call compatibility.
1015: IF NOT FND_API.Compatible_API_Call (
1016: l_api_version,

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

1010: i number;
1011: BEGIN
1012: -- Standard begin of API savepoint
1013: SAVEPOINT PROCESS_RESALE_ALL;
1014: -- Standard call to check for call compatibility.
1015: IF NOT FND_API.Compatible_API_Call (
1016: l_api_version,
1017: p_api_version,
1018: l_api_name,

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

1125: -- Debug Message
1126: IF OZF_DEBUG_HIGH_ON THEN
1127: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1128: END IF;
1129: --Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data

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

1134: );
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data

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

1142: p_data => x_msg_data
1143: );
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: -- Standard call to get message count and if count=1, get the message
1147: FND_MSG_PUB.Count_And_Get (
1148: p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data

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

1151: );
1152: WHEN OTHERS THEN
1153: ROLLBACK TO PROCESS_RESALE_ALL;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data

Line 1313: -- Standard begin of API savepoint

1309: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1310: --
1311:
1312: BEGIN
1313: -- Standard begin of API savepoint
1314: SAVEPOINT Resale_Purge;
1315: -- Standard call to check for call compatibility.
1316: IF NOT FND_API.Compatible_API_Call (
1317: l_api_version,

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

1311:
1312: BEGIN
1313: -- Standard begin of API savepoint
1314: SAVEPOINT Resale_Purge;
1315: -- Standard call to check for call compatibility.
1316: IF NOT FND_API.Compatible_API_Call (
1317: l_api_version,
1318: p_api_version,
1319: l_api_name,

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

1426: -- Debug Message
1427: IF OZF_DEBUG_HIGH_ON THEN
1428: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1429: END IF;
1430: --Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data

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

1438: WHEN FND_API.G_EXC_ERROR THEN
1439: ROLLBACK TO Resale_Purge ;
1440:
1441: x_return_status := FND_API.G_RET_STS_ERROR;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data

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

1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: ROLLBACK TO Resale_Purge;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1455: p_count => x_msg_count,
1456: p_data => x_msg_data

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

1458: WHEN OTHERS THEN
1459: ROLLBACK TO Resale_Purge;
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1461:
1462: -- Standard call to get message count and if count=1, get the message
1463: FND_MSG_PUB.Count_And_Get (
1464: p_encoded => FND_API.G_FALSE,
1465: p_count => x_msg_count,
1466: p_data => x_msg_data