35:
36: -- Standard Start of API savepoint
37: SAVEPOINT create_txn_ext_attrib_dtls;
38:
39: csi_t_gen_utility_pvt.add('API Being Executed : Create Txn Extended Attributes');
40: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
41:
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.To_Boolean( p_init_msg_list ) THEN
36: -- Standard Start of API savepoint
37: SAVEPOINT create_txn_ext_attrib_dtls;
38:
39: csi_t_gen_utility_pvt.add('API Being Executed : Create Txn Extended Attributes');
40: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
41:
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.To_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.Initialize;
119: FND_MSG_PUB.Count_And_Get(
120: p_count => x_msg_count,
121: p_data => x_msg_data);
122:
123: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Extended Attributes');
124: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
125:
126: csi_t_gen_utility_pvt.set_debug_off;
127:
120: p_count => x_msg_count,
121: p_data => x_msg_data);
122:
123: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Extended Attributes');
124: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
125:
126: csi_t_gen_utility_pvt.set_debug_off;
127:
128: EXCEPTION
122:
123: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Extended Attributes');
124: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
125:
126: csi_t_gen_utility_pvt.set_debug_off;
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130:
189:
190: -- Standard Start of API savepoint
191: SAVEPOINT Update_Txn_Ext_Attrib_Dtls;
192:
193: csi_t_gen_utility_pvt.add('API Being Executed : Update Txn Extended Attributes');
194: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
195:
196:
197: -- Initialize message list if p_init_msg_list is set to TRUE.
190: -- Standard Start of API savepoint
191: SAVEPOINT Update_Txn_Ext_Attrib_Dtls;
192:
193: csi_t_gen_utility_pvt.add('API Being Executed : Update Txn Extended Attributes');
194: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
195:
196:
197: -- Initialize message list if p_init_msg_list is set to TRUE.
198: IF FND_API.to_Boolean( p_init_msg_list ) THEN
261: FND_MSG_PUB.Count_And_Get(
262: p_count => x_msg_count,
263: p_data => x_msg_data);
264:
265: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Extended Attributes');
266: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
267:
268: csi_t_gen_utility_pvt.set_debug_off;
269:
262: p_count => x_msg_count,
263: p_data => x_msg_data);
264:
265: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Extended Attributes');
266: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
267:
268: csi_t_gen_utility_pvt.set_debug_off;
269:
270: EXCEPTION
264:
265: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Extended Attributes');
266: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
267:
268: csi_t_gen_utility_pvt.set_debug_off;
269:
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272:
331:
332: -- Standard Start of API savepoint
333: SAVEPOINT delete_txn_ext_attrib_dtls;
334:
335: csi_t_gen_utility_pvt.add('API Being Executed : Delete Txn Extended Attributes');
336: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
337:
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
332: -- Standard Start of API savepoint
333: SAVEPOINT delete_txn_ext_attrib_dtls;
334:
335: csi_t_gen_utility_pvt.add('API Being Executed : Delete Txn Extended Attributes');
336: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
337:
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: IF FND_API.to_Boolean( p_init_msg_list ) THEN
403: FND_MSG_PUB.Count_And_Get(
404: p_count => x_msg_count,
405: p_data => x_msg_data);
406:
407: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Extended Attributes');
408: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
409:
410: csi_t_gen_utility_pvt.set_debug_off;
411:
404: p_count => x_msg_count,
405: p_data => x_msg_data);
406:
407: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Extended Attributes');
408: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
409:
410: csi_t_gen_utility_pvt.set_debug_off;
411:
412: EXCEPTION
406:
407: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Extended Attributes');
408: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
409:
410: csi_t_gen_utility_pvt.set_debug_off;
411:
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: