184: p_txn_ext_attrib_vals_rec.attribute_source_id := x_attribute_id ;
185: ELSE
186: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
187: fnd_message.set_token('MESSAGE',
188: 'Either no Attribute code is passed OR csi_t_extend_attribs_pkg.get_attrib_id failed');
189: fnd_msg_pub.add;
190: debug ( 'Attribute id is null so raise the error :');
191: RAISE fnd_api.g_exc_error;
192: END IF ;
244: BEGIN
245:
246: csi_t_gen_utility_pvt.dump_api_info(
247: p_api_name => 'insert_row',
248: p_pkg_name => 'csi_t_extend_attribs_pkg');
249:
250: csi_t_extend_attribs_pkg.insert_row(
251: px_txn_attrib_detail_id => l_txn_attrib_detail_id,
252: p_txn_line_detail_id => p_txn_ext_attrib_vals_rec.txn_line_detail_id,
246: csi_t_gen_utility_pvt.dump_api_info(
247: p_api_name => 'insert_row',
248: p_pkg_name => 'csi_t_extend_attribs_pkg');
249:
250: csi_t_extend_attribs_pkg.insert_row(
251: px_txn_attrib_detail_id => l_txn_attrib_detail_id,
252: p_txn_line_detail_id => p_txn_ext_attrib_vals_rec.txn_line_detail_id,
253: p_attrib_source_id => p_txn_ext_attrib_vals_rec.attribute_source_id,
254: p_attrib_source_table => p_txn_ext_attrib_vals_rec.attrib_source_table,
283: EXCEPTION
284: WHEN others THEN
285: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
286: fnd_message.set_token('MESSAGE',
287: 'csi_t_extend_attribs_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
288: fnd_msg_pub.add;
289: RAISE fnd_api.g_exc_error;
290: END;
291:
524: l_txn_ext_attrib_vals_tbl(l_ind).attribute_source_id := l_attribute_id ;
525: ELSE
526: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
527: fnd_message.set_token('MESSAGE',
528: 'csi_t_extend_attribs_pkg.get_attrib_id failed');
529: fnd_msg_pub.add;
530: debug ( 'Attribute id is null so raise the error :');
531: RAISE fnd_api.g_exc_error;
532: END IF ;
673: begin
674:
675: csi_t_gen_utility_pvt.dump_api_info(
676: p_api_name => 'update_row',
677: p_pkg_name => 'csi_t_extend_attribs_pkg');
678:
679: csi_t_extend_attribs_pkg.update_row(
680: p_txn_attrib_detail_id => l_ea_rec.txn_attrib_detail_id,
681: p_txn_line_detail_id => l_ea_rec.txn_line_detail_id,
675: csi_t_gen_utility_pvt.dump_api_info(
676: p_api_name => 'update_row',
677: p_pkg_name => 'csi_t_extend_attribs_pkg');
678:
679: csi_t_extend_attribs_pkg.update_row(
680: p_txn_attrib_detail_id => l_ea_rec.txn_attrib_detail_id,
681: p_txn_line_detail_id => l_ea_rec.txn_line_detail_id,
682: p_attrib_source_id => l_ea_rec.attribute_source_id,
683: p_attrib_source_table => l_ea_rec.attrib_source_table,
712: exception
713: when others then
714: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
715: fnd_message.set_token('MESSAGE',
716: 'csi_t_extend_attribs_pkg.update_row Failed. '||substr(sqlerrm,1,200));
717: fnd_msg_pub.add;
718: raise fnd_api.g_exc_error;
719: end;
720:
860: END IF;
861:
862: csi_t_gen_utility_pvt.dump_api_info(
863: p_api_name => 'delete_row',
864: p_pkg_name => 'csi_t_extend_attribs_pkg');
865:
866: csi_t_extend_attribs_pkg.delete_row(
867: p_txn_attrib_detail_id => l_ext_att_id);
868:
862: csi_t_gen_utility_pvt.dump_api_info(
863: p_api_name => 'delete_row',
864: p_pkg_name => 'csi_t_extend_attribs_pkg');
865:
866: csi_t_extend_attribs_pkg.delete_row(
867: p_txn_attrib_detail_id => l_ext_att_id);
868:
869: ELSE
870:
893: LOOP
894:
895: csi_t_gen_utility_pvt.dump_api_info(
896: p_api_name => 'delete_row',
897: p_pkg_name => 'csi_t_extend_attribs_pkg');
898:
899: csi_t_extend_attribs_pkg.delete_row(
900: p_txn_attrib_detail_id => ea_rec.txn_attrib_detail_id);
901:
895: csi_t_gen_utility_pvt.dump_api_info(
896: p_api_name => 'delete_row',
897: p_pkg_name => 'csi_t_extend_attribs_pkg');
898:
899: csi_t_extend_attribs_pkg.delete_row(
900: p_txn_attrib_detail_id => ea_rec.txn_attrib_detail_id);
901:
902: END LOOP;
903: