194: INDEX BY BINARY_INTEGER;
195: l_orig_end_cust_tbl orig_end_cust_tbl_type;
196:
197: BEGIN
198: -- Standard begin of API savepoint
199: SAVEPOINT TRAC_INITIATE_PAYMENT;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.Compatible_API_Call (
202: l_api_version,
196:
197: BEGIN
198: -- Standard begin of API savepoint
199: SAVEPOINT TRAC_INITIATE_PAYMENT;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.Compatible_API_Call (
202: l_api_version,
203: p_api_version,
204: l_api_name,
691: -- Debug Message
692: IF OZF_DEBUG_HIGH_ON THEN
693: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
694: END IF;
695: --Standard call to get message count and if count=1, get the message
696: FND_MSG_PUB.Count_And_Get (
697: p_encoded => FND_API.G_FALSE,
698: p_count => x_msg_count,
699: p_data => x_msg_data
701: x_return_status := l_return_status;
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: -- Standard call to get message count and if count=1, get the message
706: FND_MSG_PUB.Count_And_Get (
707: p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count,
709: p_data => x_msg_data
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: ROLLBACK TO TRAC_INITIATE_PAYMENT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714:
715: -- Standard call to get message count and if count=1, get the message
716: FND_MSG_PUB.Count_And_Get (
717: p_encoded => FND_API.G_FALSE,
718: p_count => x_msg_count,
719: p_data => x_msg_data
721: WHEN OTHERS THEN
722: ROLLBACK TO TRAC_INITIATE_PAYMENT;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724:
725: -- Standard call to get message count and if count=1, get the message
726: FND_MSG_PUB.Count_And_Get (
727: p_encoded => FND_API.G_FALSE,
728: p_count => x_msg_count,
729: p_data => x_msg_data
769:
770: l_non_tracing_count NUMBER;
771:
772: BEGIN
773: -- Standard begin of API savepoint
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call (
776: l_api_version,
777: p_api_version,
770: l_non_tracing_count NUMBER;
771:
772: BEGIN
773: -- Standard begin of API savepoint
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call (
776: l_api_version,
777: p_api_version,
778: l_api_name,
850: -- Debug Message
851: IF OZF_DEBUG_HIGH_ON THEN
852: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
853: END IF;
854: --Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: -- Standard call to get message count and if count=1, get the message
864: FND_MSG_PUB.Count_And_Get (
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,
867: p_data => x_msg_data
867: p_data => x_msg_data
868: );
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: -- Standard call to get message count and if count=1, get the message
872: FND_MSG_PUB.Count_And_Get (
873: p_encoded => FND_API.G_FALSE,
874: p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877: WHEN OTHERS THEN
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879:
880: -- Standard call to get message count and if count=1, get the message
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,
883: p_count => x_msg_count,
884: p_data => x_msg_data
979: l_report_start_date date;
980: l_report_end_date date;
981:
982: BEGIN
983: -- Standard begin of API savepoint
984: SAVEPOINT PROCESS_TRAC_ORDER;
985: -- Standard call to check for call compatibility.
986: IF NOT FND_API.Compatible_API_Call (
987: l_api_version,
981:
982: BEGIN
983: -- Standard begin of API savepoint
984: SAVEPOINT PROCESS_TRAC_ORDER;
985: -- Standard call to check for call compatibility.
986: IF NOT FND_API.Compatible_API_Call (
987: l_api_version,
988: p_api_version,
989: l_api_name,
1219: -- Debug Message
1220: IF OZF_DEBUG_HIGH_ON THEN
1221: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
1222: END IF;
1223: --Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1230: EXCEPTION
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: ROLLBACK TO PROCESS_TRAC_ORDER;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: -- Standard call to get message count and if count=1, get the message
1235: FND_MSG_PUB.Count_And_Get (
1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
1238: p_data => x_msg_data
1240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1241: ROLLBACK TO PROCESS_TRAC_ORDER;
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243:
1244: -- Standard call to get message count and if count=1, get the message
1245: FND_MSG_PUB.Count_And_Get (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => x_msg_count,
1248: p_data => x_msg_data
1250: WHEN OTHERS THEN
1251: ROLLBACK TO PROCESS_TRAC_ORDER;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253:
1254: -- Standard call to get message count and if count=1, get the message
1255: FND_MSG_PUB.Count_And_Get (
1256: p_encoded => FND_API.G_FALSE,
1257: p_count => x_msg_count,
1258: p_data => x_msg_data