APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_T_GEN_UTILITY_PVT

Line 617: csi_t_gen_utility_pvt.add('Converting to Primary UOM.');

613: -- if the source uom is not the primary uom then convert it to primary
614:
615: IF l_src_uom_code <> l_primary_uom_code THEN
616:
617: csi_t_gen_utility_pvt.add('Converting to Primary UOM.');
618:
619: l_src_primary_qty :=
620: inv_convert.inv_um_convert(
621: item_id => l_src_item_id,

Line 2012: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);

2008: iv) Validate instance references
2009: v) validate the relationship for bus rules if instance is involved
2010: */
2011: BEGIN
2012: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2013: l_line_dtl_rec1 := p_txn_line_detail_rec1;
2014: l_line_dtl_rec2 := p_txn_line_detail_rec2;
2015: l_ii_rltns_rec := p_iir_rec;
2016: l_object_type := l_ii_rltns_rec.object_type;

Line 2133: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);

2129: l_found VARCHAR2(1) := 'N';
2130: l_loc_type VARCHAR2(30);
2131:
2132: BEGIN
2133: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2134: l_line_dtl_rec := p_txn_dtl_rec;
2135: l_txn_rltns_rec := p_iir_rec;
2136: l_object_type := l_txn_rltns_rec.object_type;
2137: l_object_id := l_txn_rltns_rec.object_id;

Line 2264: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);

2260: l_txn_line_rec csi_t_transaction_lines%rowtype;
2261:
2262: BEGIN
2263:
2264: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2265: x_return_status := fnd_api.g_ret_sts_success ;
2266: l_query := 'Select source_txn_header_id, source_transaction_type_id '||
2267: 'from csi_t_transaction_lines where transaction_line_id = :line_id';
2268: EXECUTE IMMEDIATE l_query

Line 2276: csi_t_gen_utility_pvt.add('In Validate_src_header :'||'header id1'||l_txn_hdr_id1||'header id2'||l_txn_hdr_id2||'relationship type'||p_rel_type_code);

2272: EXECUTE IMMEDIATE l_query
2273: INTO l_txn_hdr_id2 , l_txn_type_id2
2274: USING p_txn_line_id2;
2275:
2276: csi_t_gen_utility_pvt.add('In Validate_src_header :'||'header id1'||l_txn_hdr_id1||'header id2'||l_txn_hdr_id2||'relationship type'||p_rel_type_code);
2277:
2278: IF l_txn_hdr_id1 is NULL THEN
2279: l_txn_hdr_id1 := fnd_api.g_miss_num;
2280: END IF;

Line 2388: csi_t_gen_utility_pvt.add('Begin : in get_cz_inst_or_tld_id ');

2384: AND config_inst_rev_num = p_config_inst_rev_num
2385: AND config_inst_item_id = p_config_inst_item_id ;
2386:
2387: BEGIN
2388: csi_t_gen_utility_pvt.add('Begin : in get_cz_inst_or_tld_id ');
2389: csi_t_gen_utility_pvt.add('p_config_inst_hdr_id :'||p_config_inst_hdr_id
2390: ||' p_config_inst_rev_num :'|| p_config_inst_rev_num ||
2391: ' p_config_inst_item_id :'|| p_config_inst_item_id);
2392:

Line 2389: csi_t_gen_utility_pvt.add('p_config_inst_hdr_id :'||p_config_inst_hdr_id

2385: AND config_inst_item_id = p_config_inst_item_id ;
2386:
2387: BEGIN
2388: csi_t_gen_utility_pvt.add('Begin : in get_cz_inst_or_tld_id ');
2389: csi_t_gen_utility_pvt.add('p_config_inst_hdr_id :'||p_config_inst_hdr_id
2390: ||' p_config_inst_rev_num :'|| p_config_inst_rev_num ||
2391: ' p_config_inst_item_id :'|| p_config_inst_item_id);
2392:
2393: x_return_status := fnd_api.g_ret_sts_success ;

Line 2447: csi_t_gen_utility_pvt.add('Begin : in get_cz_txn_line_id ');

2443: AND a.config_session_item_id = p_config_session_item_id
2444: AND a.source_transaction_table = 'CONFIGURATOR'; --fix for bug 5632296
2445:
2446: BEGIN
2447: csi_t_gen_utility_pvt.add('Begin : in get_cz_txn_line_id ');
2448: x_txn_line_id := NULL ;
2449: x_return_status := fnd_api.g_ret_sts_success ;
2450:
2451: OPEN cz_txn_line_cur ;

Line 2454: csi_t_gen_utility_pvt.add('x_txn_line_id :'|| x_txn_line_id);

2450:
2451: OPEN cz_txn_line_cur ;
2452: FETCH cz_txn_line_cur INTO x_txn_line_id ;
2453: CLOSE cz_txn_line_cur ;
2454: csi_t_gen_utility_pvt.add('x_txn_line_id :'|| x_txn_line_id);
2455:
2456: EXCEPTION
2457: WHEN OTHERS
2458: THEN