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'));
47:
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
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'));
47:
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF FND_API.To_Boolean( p_init_msg_list ) THEN
200: FND_MSG_PUB.Count_And_Get(
201: p_count => x_msg_count,
202: p_data => x_msg_data);
203:
204: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Party And Accounts');
205: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
206:
207: csi_t_gen_utility_pvt.set_debug_off;
208:
201: p_count => x_msg_count,
202: p_data => x_msg_data);
203:
204: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Party And Accounts');
205: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
206:
207: csi_t_gen_utility_pvt.set_debug_off;
208:
209: EXCEPTION
203:
204: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Party And Accounts');
205: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
206:
207: csi_t_gen_utility_pvt.set_debug_off;
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211:
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'));
276:
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
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'));
276:
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.To_Boolean( p_init_msg_list ) THEN
356: FND_MSG_PUB.Count_And_Get(
357: p_count => x_msg_count,
358: p_data => x_msg_data);
359:
360: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Party Accounts');
361: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
362:
363: csi_t_gen_utility_pvt.set_debug_off;
364:
357: p_count => x_msg_count,
358: p_data => x_msg_data);
359:
360: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Party Accounts');
361: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
362:
363: csi_t_gen_utility_pvt.set_debug_off;
364:
365: EXCEPTION
359:
360: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Party Accounts');
361: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
362:
363: csi_t_gen_utility_pvt.set_debug_off;
364:
365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367:
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'));
431:
432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.
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'));
431:
432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
498: FND_MSG_PUB.Count_And_Get(
499: p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Party And Accounts');
503: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
504:
505: csi_t_gen_utility_pvt.set_debug_off;
506:
499: p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Party And Accounts');
503: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
504:
505: csi_t_gen_utility_pvt.set_debug_off;
506:
507: EXCEPTION
501:
502: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Party And Accounts');
503: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
504:
505: csi_t_gen_utility_pvt.set_debug_off;
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509:
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'));
576:
577:
578: -- Initialize message list if p_init_msg_list is set to TRUE.
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'));
576:
577:
578: -- Initialize message list if p_init_msg_list is set to TRUE.
579: IF FND_API.to_Boolean( p_init_msg_list ) THEN
642: FND_MSG_PUB.Count_And_Get(
643: p_count => x_msg_count,
644: p_data => x_msg_data);
645:
646: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Party Accounts');
647: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
648:
649: csi_t_gen_utility_pvt.set_debug_off;
650:
643: p_count => x_msg_count,
644: p_data => x_msg_data);
645:
646: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Party Accounts');
647: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
648:
649: csi_t_gen_utility_pvt.set_debug_off;
650:
651: EXCEPTION
645:
646: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Party Accounts');
647: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
648:
649: csi_t_gen_utility_pvt.set_debug_off;
650:
651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN
653:
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'));
716:
717:
718: -- Initialize message list if p_init_msg_list is set to TRUE.
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'));
716:
717:
718: -- Initialize message list if p_init_msg_list is set to TRUE.
719: IF FND_API.to_Boolean( p_init_msg_list ) THEN
783: FND_MSG_PUB.Count_And_Get(
784: p_count => x_msg_count,
785: p_data => x_msg_data);
786:
787: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Party and Accounts');
788: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
789:
790: csi_t_gen_utility_pvt.set_debug_off;
791:
784: p_count => x_msg_count,
785: p_data => x_msg_data);
786:
787: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Party and Accounts');
788: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
789:
790: csi_t_gen_utility_pvt.set_debug_off;
791:
792: EXCEPTION
786:
787: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Party and Accounts');
788: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
789:
790: csi_t_gen_utility_pvt.set_debug_off;
791:
792: EXCEPTION
793: WHEN FND_API.G_EXC_ERROR THEN
794:
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'));
857:
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
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'));
857:
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list ) THEN
923: FND_MSG_PUB.Count_And_Get(
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926:
927: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Party Accounts');
928: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
929:
930: csi_t_gen_utility_pvt.set_debug_off;
931:
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926:
927: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Party Accounts');
928: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
929:
930: csi_t_gen_utility_pvt.set_debug_off;
931:
932: EXCEPTION
926:
927: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Party Accounts');
928: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
929:
930: csi_t_gen_utility_pvt.set_debug_off;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: