11: PROCEDURE debug(
12: p_message IN varchar2)
13: IS
14: BEGIN
15: csi_t_gen_utility_pvt.add(p_message);
16: END debug;
17:
18: PROCEDURE api_log(
19: p_api_name IN varchar2)
18: PROCEDURE api_log(
19: p_api_name IN varchar2)
20: IS
21: BEGIN
22: csi_t_gen_utility_pvt.dump_api_info(
23: p_pkg_name => 'csi_t_txn_attribs_pvt',
24: p_api_name => p_api_name);
25: END api_log;
26:
72: END IF;
73:
74: -- Check the profile option debug_level for debug message reporting
75:
76: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
77:
78: csi_t_gen_utility_pvt.dump_api_info(
79: p_pkg_name => g_pkg_name,
80: p_api_name => l_api_name);
74: -- Check the profile option debug_level for debug message reporting
75:
76: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
77:
78: csi_t_gen_utility_pvt.dump_api_info(
79: p_pkg_name => g_pkg_name,
80: p_api_name => l_api_name);
81:
82: IF l_debug_level > 1 THEN
80: p_api_name => l_api_name);
81:
82: IF l_debug_level > 1 THEN
83:
84: csi_t_gen_utility_pvt.add(
85: p_api_version||'-'||p_commit||'-'||p_init_msg_list||'-'||p_validation_level);
86:
87: csi_t_gen_utility_pvt.dump_txn_eav_rec(
88: p_txn_eav_rec => p_txn_ext_attrib_vals_rec);
83:
84: csi_t_gen_utility_pvt.add(
85: p_api_version||'-'||p_commit||'-'||p_init_msg_list||'-'||p_validation_level);
86:
87: csi_t_gen_utility_pvt.dump_txn_eav_rec(
88: p_txn_eav_rec => p_txn_ext_attrib_vals_rec);
89:
90: END IF;
91:
242:
243: --debug info
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(
295: IF fnd_api.To_Boolean( p_commit ) THEN
296: COMMIT WORK;
297: END IF;
298:
299: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
300: csi_t_gen_utility_pvt.set_debug_off;
301: END IF;
302:
303: -- Standard call to get message count and if count is get message info.
296: COMMIT WORK;
297: END IF;
298:
299: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
300: csi_t_gen_utility_pvt.set_debug_off;
301: END IF;
302:
303: -- Standard call to get message count and if count is get message info.
304: fnd_msg_pub.count_and_get(
408:
409: END IF;
410:
411: -- Check the profile option debug_level for debug message reporting
412: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
413:
414: csi_t_gen_utility_pvt.dump_api_info(
415: p_pkg_name => g_pkg_name,
416: p_api_name => l_api_name);
410:
411: -- Check the profile option debug_level for debug message reporting
412: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
413:
414: csi_t_gen_utility_pvt.dump_api_info(
415: p_pkg_name => g_pkg_name,
416: p_api_name => l_api_name);
417:
418: csi_t_gen_utility_pvt.add(
414: csi_t_gen_utility_pvt.dump_api_info(
415: p_pkg_name => g_pkg_name,
416: p_api_name => l_api_name);
417:
418: csi_t_gen_utility_pvt.add(
419: p_api_version||'-'||p_commit||'-'||p_init_msg_list||'-'||p_validation_level);
420: ---FOR CZ
421: l_txn_ext_attrib_vals_tbl := p_txn_ext_attrib_vals_tbl ;
422: ---FOR CZ end
426: IF l_txn_ext_attrib_vals_tbl.COUNT > 0 THEN
427: FOR l_ind in l_txn_ext_attrib_vals_tbl.FIRST..l_txn_ext_attrib_vals_tbl.LAST
428: LOOP
429: IF l_debug_level > 1 THEN
430: csi_t_gen_utility_pvt.dump_txn_eav_rec(
431: p_txn_eav_rec => l_txn_ext_attrib_vals_tbl(l_ind));
432: END IF;
433:
434: -- Added for CZ Integration (Begin)
671: l_txn_ext_attrib_vals_tbl(l_ind).context ;
672:
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(
822:
823: END IF;
824:
825: -- Check the profile option debug_level for debug message reporting
826: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
827:
828: csi_t_gen_utility_pvt.dump_api_info(
829: p_pkg_name => g_pkg_name,
830: p_api_name => l_api_name);
824:
825: -- Check the profile option debug_level for debug message reporting
826: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
827:
828: csi_t_gen_utility_pvt.dump_api_info(
829: p_pkg_name => g_pkg_name,
830: p_api_name => l_api_name);
831:
832: csi_t_gen_utility_pvt.add(
828: csi_t_gen_utility_pvt.dump_api_info(
829: p_pkg_name => g_pkg_name,
830: p_api_name => l_api_name);
831:
832: csi_t_gen_utility_pvt.add(
833: p_api_version||'-'||p_commit||'-'||p_init_msg_list||'-'||p_validation_level);
834:
835: -- Main API code
836: IF p_txn_ext_attrib_ids_tbl.count > 0 THEN
858: RAISE fnd_api.g_exc_error;
859:
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(
891:
892: FOR ea_rec in ea_cur (l_line_dtl_id)
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(