177: l_skip_tl_create varchar2(1) := 'N';
178:
179: BEGIN
180:
181: -- Standard Start of API savepoint
182: SAVEPOINT create_transaction_dtls;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE.
185: IF FND_API.To_Boolean( p_init_msg_list ) THEN
188:
189: -- Initialize API return status to success
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: -- Standard call to check for call compatibility.
193: IF NOT
194:
195: FND_API.Compatible_API_Call (
196: p_current_version_number => l_api_version,
725:
726: END IF; -- main if for td tbl count > 0
727:
728:
729: -- Standard check of p_commit.
730: IF FND_API.To_Boolean( p_commit ) THEN
731: COMMIT WORK;
732: END IF;
733:
734: csi_t_gen_utility_pvt.add('transaction_line_id : '||l_txn_line_id);
735: csi_t_gen_utility_pvt.add('Transaction details created successfully.');
736: csi_t_gen_utility_pvt.set_debug_off;
737:
738: -- Standard call to get message count and if count is get message info.
739: FND_MSG_PUB.Count_And_Get(
740: p_count => x_msg_count,
741: p_data => x_msg_data);
742:
859: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
860: l_exists VARCHAR2(1);
861:
862: BEGIN
863: -- Standard Start of API savepoint
864: SAVEPOINT update_transaction_dtls;
865:
866: -- Initialize message list if p_init_msg_list is set to TRUE.
867: IF FND_API.To_Boolean( p_init_msg_list ) THEN
870:
871: -- Initialize API return status to success
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: -- Standard call to check for call compatibility.
875: IF NOT
876: FND_API.Compatible_API_Call (
877: p_current_version_number => l_api_version,
878: p_caller_version_number => p_api_version,
1572: END LOOP ; ---l_d_tld_tbl
1573: END IF ; ---px_txn_line_detail_tbl.COUNT > 0
1574: END IF;
1575:
1576: -- Standard check of p_commit.
1577: IF FND_API.To_Boolean( p_commit ) THEN
1578: COMMIT WORK;
1579: END IF;
1580:
1580:
1581: csi_t_gen_utility_pvt.add('Transaction details updated successfully.');
1582: csi_t_gen_utility_pvt.set_debug_off;
1583:
1584: -- Standard call to get message count and if count is get message info.
1585: FND_MSG_PUB.Count_And_Get(
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588:
1730: WHERE transaction_line_id = p_transaction_line_id;
1731:
1732: BEGIN
1733:
1734: -- Standard Start of API savepoint
1735: SAVEPOINT delete_transaction_dtls;
1736:
1737: -- Initialize message list if p_init_msg_list is set to TRUE.
1738: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1741:
1742: -- Initialize API return status to success
1743: x_return_status := FND_API.G_RET_STS_SUCCESS;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT
1747:
1748: FND_API.Compatible_API_Call (
1749: p_current_version_number => l_api_version,
2074: csi_t_transaction_lines_pkg.delete_row(
2075: p_transaction_line_id => p_transaction_line_id);
2076: END IF;
2077:
2078: -- Standard check of p_commit.
2079: IF FND_API.To_Boolean( p_commit ) THEN
2080: COMMIT WORK;
2081: END IF;
2082:
2083: csi_t_gen_utility_pvt.add('Transaction Details Deleted Successfully
2084: for Transaction Line ID:'||to_char(p_transaction_line_id)||
2085: ' Txn line detail ID:'||to_char(p_txn_line_detail_id));
2086:
2087: -- Standard call to get message count and if count is get message info.
2088: FND_MSG_PUB.Count_And_Get(
2089: p_count => x_msg_count,
2090: p_data => x_msg_data);
2091:
2436: l_swap_loc_id NUMBER;
2437:
2438: BEGIN
2439:
2440: -- Standard Start of API savepoint
2441: SAVEPOINT Get_Transaction_Dtls;
2442:
2443: -- Initialize message list if p_init_msg_list is set to TRUE.
2444: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2447:
2448: -- Initialize API return status to success
2449: x_return_status := FND_API.G_RET_STS_SUCCESS;
2450:
2451: -- Standard call to check for call compatibility.
2452: IF NOT
2453:
2454: FND_API.Compatible_API_Call (
2455: p_current_version_number => l_api_version,
2764: END IF;
2765:
2766: END IF;
2767:
2768: -- Standard check of p_commit.
2769: IF FND_API.To_Boolean( p_commit ) THEN
2770: COMMIT WORK;
2771: END IF;
2772:
2771: END IF;
2772:
2773: csi_t_gen_utility_pvt.add('Get Transaction Details Successful');
2774:
2775: -- Standard call to get message count and if count is get message info.
2776: FND_MSG_PUB.Count_And_Get(
2777: p_count => x_msg_count,
2778: p_data => x_msg_data);
2779:
2895:
2896: BEGIN
2897:
2898:
2899: -- Standard Start of API savepoint
2900: SAVEPOINT split_transaction_dtls;
2901:
2902: -- Initialize message list if p_init_msg_list is set to TRUE.
2903: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2906:
2907: -- Initialize API return status to success
2908: x_return_status := FND_API.G_RET_STS_SUCCESS;
2909:
2910: -- Standard call to check for call compatibility.
2911: IF NOT
2912:
2913: FND_API.Compatible_API_Call (
2914: p_current_version_number => l_api_version,
3138: END LOOP;
3139:
3140: END IF;
3141:
3142: -- Standard check of p_commit.
3143: IF FND_API.To_Boolean( p_commit ) THEN
3144: COMMIT WORK;
3145: END IF;
3146:
3143: IF FND_API.To_Boolean( p_commit ) THEN
3144: COMMIT WORK;
3145: END IF;
3146:
3147: -- Standard call to get message count and if count is get message info.
3148: FND_MSG_PUB.Count_And_Get(
3149: p_count => x_msg_count,
3150: p_data => x_msg_data);
3151:
3228: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3229:
3230: BEGIN
3231:
3232: -- Standard Start of API savepoint
3233: SAVEPOINT copy_transaction_dtls;
3234:
3235: -- Initialize message list if p_init_msg_list is set to TRUE.
3236: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3239:
3240: -- Initialize API return status to success
3241: x_return_status := FND_API.G_RET_STS_SUCCESS;
3242:
3243: -- Standard call to check for call compatibility.
3244: IF NOT
3245:
3246: FND_API.Compatible_API_Call (
3247: p_current_version_number => l_api_version,
3381:
3382: csi_t_gen_utility_pvt.add('Transaction details copied successfully.');
3383: csi_t_gen_utility_pvt.add('II rltns count after copying : '||l_ii_rltns_tbl.count);
3384:
3385: -- Standard check of p_commit.
3386: IF FND_API.To_Boolean( p_commit ) THEN
3387: COMMIT WORK;
3388: END IF;
3389:
3386: IF FND_API.To_Boolean( p_commit ) THEN
3387: COMMIT WORK;
3388: END IF;
3389:
3390: -- Standard call to get message count and if count is get message info.
3391: FND_MSG_PUB.Count_And_Get(
3392: p_count => x_msg_count,
3393: p_data => x_msg_data);
3394:
3472: l_match_txn_dtl_qty number := 0;
3473: l_tab_ind number;
3474: BEGIN
3475:
3476: -- Standard Start of API savepoint
3477: SAVEPOINT split_transaction_details;
3478:
3479: -- Initialize message list if p_init_msg_list is set to TRUE.
3480: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3483:
3484: -- Initialize API return status to success
3485: x_return_status := FND_API.G_RET_STS_SUCCESS;
3486:
3487: -- Standard call to check for call compatibility.
3488: IF NOT
3489:
3490: FND_API.Compatible_API_Call (
3491: p_current_version_number => l_api_version,
3749: END IF;
3750:
3751: END IF;
3752:
3753: -- Standard check of p_commit.
3754: IF FND_API.To_Boolean( p_commit ) THEN
3755: COMMIT WORK;
3756: END IF;
3757:
3754: IF FND_API.To_Boolean( p_commit ) THEN
3755: COMMIT WORK;
3756: END IF;
3757:
3758: -- Standard call to get message count and if count is get message info.
3759: FND_MSG_PUB.Count_And_Get(
3760: p_count => x_msg_count,
3761: p_data => x_msg_data);
3762: