DBA Data[Home] [Help]

APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on CSI_T_EXTEND_ATTRIBS

Line 188: 'Either no Attribute code is passed OR csi_t_extend_attribs_pkg.get_attrib_id failed');

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 ;

Line 248: p_pkg_name => 'csi_t_extend_attribs_pkg');

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,

Line 250: csi_t_extend_attribs_pkg.insert_row(

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,

Line 287: 'csi_t_extend_attribs_pkg.insert_row Failed. '||substr(sqlerrm,1,200));

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:

Line 372: FROM csi_t_extend_attribs

368: l_error_msg VARCHAR2(2000);
369:
370: CURSOR l_ea_cur(p_attrib_dtl_id in number) IS
371: SELECT *
372: FROM csi_t_extend_attribs
373: where txn_attrib_detail_id = p_attrib_dtl_id;
374:
375: CURSOR ext_attribs_cur (c_txn_line_detail_id IN NUMBER,
376: c_attrib_source_id IN NUMBER,

Line 380: FROM csi_t_extend_attribs

376: c_attrib_source_id IN NUMBER,
377: c_attrib_source_table IN VARCHAR2)
378: IS
379: SELECT txn_attrib_detail_id
380: FROM csi_t_extend_attribs
381: WHERE txn_line_detail_id = c_txn_line_detail_id
382: AND attrib_source_id = c_attrib_source_id
383: AND attrib_source_table = c_attrib_source_table ;
384:

Line 528: 'csi_t_extend_attribs_pkg.get_attrib_id failed');

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 ;

Line 677: p_pkg_name => 'csi_t_extend_attribs_pkg');

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,

Line 679: csi_t_extend_attribs_pkg.update_row(

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,

Line 716: 'csi_t_extend_attribs_pkg.update_row Failed. '||substr(sqlerrm,1,200));

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:

Line 796: FROM csi_t_extend_attribs

792: l_line_dtl_id NUMBER;
793:
794: CURSOR ea_cur (p_line_dtl_id IN NUMBER) IS
795: SELECT txn_attrib_detail_id
796: FROM csi_t_extend_attribs
797: WHERE txn_line_detail_id = p_line_dtl_id;
798:
799: BEGIN
800:

Line 864: p_pkg_name => 'csi_t_extend_attribs_pkg');

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:

Line 866: csi_t_extend_attribs_pkg.delete_row(

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:

Line 897: p_pkg_name => 'csi_t_extend_attribs_pkg');

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:

Line 899: csi_t_extend_attribs_pkg.delete_row(

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:

Line 1227: from csi_t_extend_attribs

1223: context, attribute1, attribute2, attribute3, attribute4,
1224: attribute5, attribute6, attribute7, attribute8, attribute9,
1225: attribute10, attribute11, attribute12, attribute13, attribute14,
1226: attribute15, object_version_number
1227: from csi_t_extend_attribs
1228: where txn_line_detail_id = :line_dtl_id';
1229:
1230: l_ea_cur_id := dbms_sql.open_cursor;
1231: