38: l_contact_party_id number;
39: l_contact_party_index varchar2(1);
40: BEGIN
41:
42: -- Standard Start of API savepoint
43: SAVEPOINT create_txn_party_dtls;
44:
45: csi_t_gen_utility_pvt.add('API Being Executed : Create Txn Party AND Accounts');
46: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
53:
54: -- Initialize API return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: -- Standard call to check for call compatibility.
58: IF NOT
59:
60: FND_API.Compatible_API_Call (
61: p_current_version_number => l_api_version,
183: END IF;
184: END LOOP;
185: END IF;
186:
187: -- Standard check of p_commit.
188: IF FND_API.To_Boolean( p_commit ) THEN
189: COMMIT WORK;
190: END IF;
191:
195: dbms_session.set_sql_trace(false);
196: END IF;
197: ****/
198:
199: -- Standard call to get message count and if count is get message info.
200: FND_MSG_PUB.Count_And_Get(
201: p_count => x_msg_count,
202: p_data => x_msg_data);
203:
267: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;
268:
269: BEGIN
270:
271: -- Standard Start of API savepoint
272: SAVEPOINT create_txn_pty_acct_dtls;
273:
274: csi_t_gen_utility_pvt.add('API Being Executed : Create Txn Party Accounts');
275: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
282:
283: -- Initialize API return status to success
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: -- Standard call to check for call compatibility.
287: IF NOT
288:
289: FND_API.Compatible_API_Call (
290: p_current_version_number => l_api_version,
339:
340: END LOOP;
341:
342: END IF;
343: -- Standard check of p_commit.
344: IF FND_API.To_Boolean( p_commit ) THEN
345: COMMIT WORK;
346: END IF;
347:
351: dbms_session.set_sql_trace(false);
352: END IF;
353: ****/
354:
355: -- Standard call to get message count and if count is get message info.
356: FND_MSG_PUB.Count_And_Get(
357: p_count => x_msg_count,
358: p_data => x_msg_data);
359:
422: l_msg_data VARCHAR2(512);
423:
424: BEGIN
425:
426: -- Standard Start of API savepoint
427: SAVEPOINT Update_Txn_Party_Dtls;
428:
429: csi_t_gen_utility_pvt.add('API Being Executed : Update Txn Party And Accounts');
430: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
437:
438: -- Initialize API return status to success
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: -- Standard call to check for call compatibility.
442: IF NOT
443:
444: FND_API.Compatible_API_Call (
445: p_current_version_number => l_api_version,
481: IF l_return_status <> fnd_api.g_ret_sts_success THEN
482: raise fnd_api.g_exc_error;
483: END IF;
484:
485: -- Standard check of p_commit.
486: IF FND_API.To_Boolean( p_commit ) THEN
487: COMMIT WORK;
488: END IF;
489:
493: dbms_session.set_sql_trace(false);
494: END IF;
495: ****/
496:
497: -- Standard call to get message count and if count is get message info.
498: FND_MSG_PUB.Count_And_Get(
499: p_count => x_msg_count,
500: p_data => x_msg_data);
501:
567: l_msg_data VARCHAR2(512);
568:
569: BEGIN
570:
571: -- Standard Start of API savepoint
572: SAVEPOINT Update_Txn_Party_acct_Dtls;
573:
574: csi_t_gen_utility_pvt.add('API Being Executed : Update Txn Party Accounts');
575: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
582:
583: -- Initialize API return status to success
584: x_return_status := FND_API.G_RET_STS_SUCCESS;
585:
586: -- Standard call to check for call compatibility.
587: IF NOT
588:
589: FND_API.Compatible_API_Call (
590: p_current_version_number => l_api_version,
625: IF l_return_status <> fnd_api.g_ret_sts_success THEN
626: RAISE fnd_api.g_exc_error;
627: END IF;
628:
629: -- Standard check of p_commit.
630: IF FND_API.To_Boolean( p_commit ) THEN
631: COMMIT WORK;
632: END IF;
633:
637: dbms_session.set_sql_trace(false);
638: END IF;
639: ****/
640:
641: -- Standard call to get message count and if count is get message info.
642: FND_MSG_PUB.Count_And_Get(
643: p_count => x_msg_count,
644: p_data => x_msg_data);
645:
707: l_msg_data VARCHAR2(2000);
708:
709: BEGIN
710:
711: -- Standard Start of API savepoint
712: SAVEPOINT delete_txn_party_dtls;
713:
714: csi_t_gen_utility_pvt.add('API Being Executed : Delete Txn Party and acounts');
715: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
722:
723: -- Initialize API return status to success
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: -- Standard call to check for call compatibility.
727: IF NOT
728:
729: FND_API.Compatible_API_Call (
730: p_current_version_number => l_api_version,
766: IF l_return_status <> fnd_api.g_ret_sts_success THEN
767: RAISE fnd_api.g_exc_error;
768: END IF;
769:
770: -- Standard check of p_commit.
771: IF FND_API.To_Boolean( p_commit ) THEN
772: COMMIT WORK;
773: END IF;
774:
778: dbms_session.set_sql_trace(false);
779: END IF;
780: ****/
781:
782: -- Standard call to get message count and if count is get message info.
783: FND_MSG_PUB.Count_And_Get(
784: p_count => x_msg_count,
785: p_data => x_msg_data);
786:
848: l_msg_data VARCHAR2(2000);
849:
850: BEGIN
851:
852: -- Standard Start of API savepoint
853: SAVEPOINT delete_txn_party_acct_dtls;
854:
855: csi_t_gen_utility_pvt.add('API Being Executed : delete Txn Party Accounts');
856: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
863:
864: -- Initialize API return status to success
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: -- Standard call to check for call compatibility.
868: IF NOT
869:
870: FND_API.Compatible_API_Call (
871: p_current_version_number => l_api_version,
906: IF l_return_status <> fnd_api.g_ret_sts_success THEN
907: RAISE fnd_api.g_exc_error;
908: END IF;
909:
910: -- Standard check of p_commit.
911: IF FND_API.To_Boolean( p_commit ) THEN
912: COMMIT WORK;
913: END IF;
914:
918: dbms_session.set_sql_trace(false);
919: END IF;
920: ****/
921:
922: -- Standard call to get message count and if count is get message info.
923: FND_MSG_PUB.Count_And_Get(
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926: