DBA Data[Home] [Help]

APPS.CSI_T_TXN_DETAILS_GRP dependencies on STANDARD

Line 135: -- Standard Start of API savepoint

131: ---Added (End) for m-to-m enhancements
132:
133: BEGIN
134:
135: -- Standard Start of API savepoint
136: SAVEPOINT get_transaction_dtls;
137:
138: csi_t_gen_utility_pvt.add('API Being Executed : Get Transaction Details');
139: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

145:
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: -- Standard call to check for call compatibility.
150: IF NOT
151:
152: FND_API.Compatible_API_Call (
153: p_current_version_number => l_api_version,

Line 368: -- Standard check of p_commit.

364: END IF ; ---x_tmp_systems_tbl.COUNT > 0
365:
366: END LOOP ; ---txn_line_cur
367:
368: -- Standard check of p_commit.
369: IF FND_API.To_Boolean( p_commit ) THEN
370: COMMIT WORK;
371: END IF;
372:

Line 381: -- Standard call to get message count and if count is get message info.

377: dbms_session.set_sql_trace(false);
378: END IF;
379: ****/
380:
381: -- Standard call to get message count and if count is get message info.
382: FND_MSG_PUB.Count_And_Get(
383: p_count => x_msg_count,
384: p_data => x_msg_data);
385:

Line 422: -- Standard check of p_commit.

418: IF l_return_status <> fnd_api.g_ret_sts_success THEN
419: RAISE fnd_api.g_exc_error;
420: END IF;
421:
422: -- Standard check of p_commit.
423: IF FND_API.To_Boolean( p_commit ) THEN
424: COMMIT WORK;
425: END IF;
426:

Line 434: -- Standard call to get message count and if count is get message info.

430: dbms_session.set_sql_trace(false);
431: END IF;
432: ****/
433:
434: -- Standard call to get message count and if count is get message info.
435: FND_MSG_PUB.Count_And_Get(
436: p_count => x_msg_count,
437: p_data => x_msg_data);
438: END IF ; --p_txn_line_query_rec.source_txn_header_id is NOT NULL

Line 521: -- Standard Start of API savepoint

517: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
518:
519: BEGIN
520:
521: -- Standard Start of API savepoint
522: SAVEPOINT create_transaction_dtls;
523:
524: csi_t_gen_utility_pvt.add('API Being Executed : Create Transaction Details');
525: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

531:
532: -- Initialize API return status to success
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:
535: -- Standard call to check for call compatibility.
536: IF NOT
537:
538: FND_API.Compatible_API_Call (
539: p_current_version_number => l_api_version,

Line 627: -- Standard check of p_commit.

623: IF l_return_status <> fnd_api.g_ret_sts_success THEN
624: RAISE fnd_api.g_exc_error;
625: END IF;
626:
627: -- Standard check of p_commit.
628: IF FND_API.To_Boolean( p_commit ) THEN
629: COMMIT WORK;
630: END IF;
631:

Line 639: -- Standard call to get message count and if count is get message info.

635: dbms_session.set_sql_trace(false);
636: END IF;
637: ****/
638:
639: -- Standard call to get message count and if count is get message info.
640: FND_MSG_PUB.Count_And_Get(
641: p_count => x_msg_count,
642: p_data => x_msg_data);
643:

Line 728: -- Standard Start of API savepoint

724: l_msg_data VARCHAR2(512);
725:
726: BEGIN
727:
728: -- Standard Start of API savepoint
729: SAVEPOINT update_txn_line_dtls;
730:
731: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
732: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

738:
739: -- Initialize API return status to success
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742: -- Standard call to check for call compatibility.
743: IF NOT
744:
745: FND_API.Compatible_API_Call (
746: p_current_version_number => l_api_version,

Line 803: -- Standard check of p_commit.

799: IF l_return_status <> fnd_api.g_ret_sts_success THEN
800: RAISE fnd_api.g_exc_error;
801: END IF;
802:
803: -- Standard check of p_commit.
804: IF FND_API.To_Boolean( p_commit ) THEN
805: COMMIT WORK;
806: END IF;
807:

Line 815: -- Standard call to get message count and if count is get message info.

811: dbms_session.set_sql_trace(false);
812: END IF;
813: ****/
814:
815: -- Standard call to get message count and if count is get message info.
816: FND_MSG_PUB.Count_And_Get(
817: p_count => x_msg_count,
818: p_data => x_msg_data);
819:

Line 908: -- Standard Start of API savepoint

904: WHERE transaction_line_id = p_transaction_line_id ;
905:
906: BEGIN
907:
908: -- Standard Start of API savepoint
909: SAVEPOINT Delete_Transaction_Dtls;
910:
911:
912: csi_t_gen_utility_pvt.add('API Being Executed : Delete Transaction Details');

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

919:
920: -- Initialize API return status to success
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922:
923: -- Standard call to check for call compatibility.
924: IF NOT
925:
926: FND_API.Compatible_API_Call (
927: p_current_version_number => l_api_version,

Line 987: -- Standard check of p_commit.

983: IF l_return_status <> fnd_api.g_ret_sts_success THEN
984: RAISE fnd_api.g_exc_error;
985: END IF;
986:
987: -- Standard check of p_commit.
988: IF FND_API.To_Boolean( p_commit ) THEN
989: COMMIT WORK;
990: END IF;
991:

Line 1000: -- Standard call to get message count and if count is get message info.

996: END IF;
997: ****/
998:
999:
1000: -- Standard call to get message count and if count is get message info.
1001: FND_MSG_PUB.Count_And_Get(
1002: p_count => x_msg_count,
1003: p_data => x_msg_data);
1004:

Line 1084: -- Standard Start of API savepoint

1080: l_msg_data VARCHAR2(2000);
1081:
1082: BEGIN
1083:
1084: -- Standard Start of API savepoint
1085: SAVEPOINT copy_transaction_dtls;
1086:
1087: csi_t_gen_utility_pvt.add('API Being Executed : Copy Transaction Details');
1088: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

1094:
1095: -- Initialize API return status to success
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: -- Standard call to check for call compatibility.
1099: IF NOT
1100:
1101: FND_API.Compatible_API_Call (
1102: p_current_version_number => l_api_version,

Line 1148: -- Standard check of p_commit.

1144: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: -- Standard check of p_commit.
1149: IF FND_API.To_Boolean( p_commit ) THEN
1150: COMMIT WORK;
1151: END IF;
1152:

Line 1160: -- Standard call to get message count and if count is get message info.

1156: dbms_session.set_sql_trace(false);
1157: END IF;
1158: ****/
1159:
1160: -- Standard call to get message count and if count is get message info.
1161: FND_MSG_PUB.Count_And_Get(
1162: p_count => x_msg_count,
1163: p_data => x_msg_data);
1164:

Line 1247: -- Standard Start of API savepoint

1243: l_msg_data VARCHAR2(512);
1244:
1245: BEGIN
1246:
1247: -- Standard Start of API savepoint
1248: SAVEPOINT update_transaction_dtls;
1249:
1250: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
1251: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

1257:
1258: -- Initialize API return status to success
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;
1260:
1261: -- Standard call to check for call compatibility.
1262: IF NOT
1263:
1264: FND_API.Compatible_API_Call (
1265: p_current_version_number => l_api_version,

Line 1321: -- Standard check of p_commit.

1317: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1318: RAISE fnd_api.g_exc_error;
1319: END IF;
1320:
1321: -- Standard check of p_commit.
1322: IF FND_API.To_Boolean( p_commit ) THEN
1323: COMMIT WORK;
1324: END IF;
1325:

Line 1326: -- Standard call to get message count and if count is get message info.

1322: IF FND_API.To_Boolean( p_commit ) THEN
1323: COMMIT WORK;
1324: END IF;
1325:
1326: -- Standard call to get message count and if count is get message info.
1327: FND_MSG_PUB.Count_And_Get(
1328: p_count => x_msg_count,
1329: p_data => x_msg_data);
1330:

Line 1406: -- Standard Start of API savepoint

1402: l_api_name CONSTANT VARCHAR2(30) := 'split_transaction_details';
1403: l_api_version CONSTANT NUMBER := 1.0;
1404:
1405: BEGIN
1406: -- Standard Start of API savepoint
1407: SAVEPOINT split_transaction_details;
1408:
1409: csi_t_gen_utility_pvt.add('API Being Executed : Split Transaction Details');
1410: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

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

1416:
1417: -- Initialize API return status to success
1418: x_return_status := FND_API.G_RET_STS_SUCCESS;
1419:
1420: -- Standard call to check for call compatibility.
1421: IF NOT
1422: FND_API.Compatible_API_Call (
1423: p_current_version_number => l_api_version,
1424: p_caller_version_number => p_api_version,

Line 1477: -- Standard call to get message count and if count is get message info.

1473: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1474: dbms_session.set_sql_trace(false);
1475: END IF;
1476:
1477: -- Standard call to get message count and if count is get message info.
1478: FND_MSG_PUB.Count_And_Get(
1479: p_count => x_msg_count,
1480: p_data => x_msg_data);
1481: