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 2039: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);

2035: iv) Validate instance references
2036: v) validate the relationship for bus rules if instance is involved
2037: */
2038: BEGIN
2039: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2040: l_line_dtl_rec1 := p_txn_line_detail_rec1;
2041: l_line_dtl_rec2 := p_txn_line_detail_rec2;
2042: l_ii_rltns_rec := p_iir_rec;
2043: l_object_type := l_ii_rltns_rec.object_type;

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

2156: l_found VARCHAR2(1) := 'N';
2157: l_loc_type VARCHAR2(30);
2158:
2159: BEGIN
2160: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2161: l_line_dtl_rec := p_txn_dtl_rec;
2162: l_txn_rltns_rec := p_iir_rec;
2163: l_object_type := l_txn_rltns_rec.object_type;
2164: l_object_id := l_txn_rltns_rec.object_id;

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

2287: l_txn_line_rec csi_t_transaction_lines%rowtype;
2288:
2289: BEGIN
2290:
2291: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2292: x_return_status := fnd_api.g_ret_sts_success ;
2293: l_query := 'Select source_txn_header_id, source_transaction_type_id '||
2294: 'from csi_t_transaction_lines where transaction_line_id = :line_id';
2295: EXECUTE IMMEDIATE l_query

Line 2303: 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);

2299: EXECUTE IMMEDIATE l_query
2300: INTO l_txn_hdr_id2 , l_txn_type_id2
2301: USING p_txn_line_id2;
2302:
2303: 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);
2304:
2305: IF l_txn_hdr_id1 is NULL THEN
2306: l_txn_hdr_id1 := fnd_api.g_miss_num;
2307: END IF;

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

2411: AND config_inst_rev_num = p_config_inst_rev_num
2412: AND config_inst_item_id = p_config_inst_item_id ;
2413:
2414: BEGIN
2415: csi_t_gen_utility_pvt.add('Begin : in get_cz_inst_or_tld_id ');
2416: csi_t_gen_utility_pvt.add('p_config_inst_hdr_id :'||p_config_inst_hdr_id
2417: ||' p_config_inst_rev_num :'|| p_config_inst_rev_num ||
2418: ' p_config_inst_item_id :'|| p_config_inst_item_id);
2419:

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

2412: AND config_inst_item_id = p_config_inst_item_id ;
2413:
2414: BEGIN
2415: csi_t_gen_utility_pvt.add('Begin : in get_cz_inst_or_tld_id ');
2416: csi_t_gen_utility_pvt.add('p_config_inst_hdr_id :'||p_config_inst_hdr_id
2417: ||' p_config_inst_rev_num :'|| p_config_inst_rev_num ||
2418: ' p_config_inst_item_id :'|| p_config_inst_item_id);
2419:
2420: x_return_status := fnd_api.g_ret_sts_success ;

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

2470: AND a.config_session_item_id = p_config_session_item_id
2471: AND a.source_transaction_table = 'CONFIGURATOR'; --fix for bug 5632296
2472:
2473: BEGIN
2474: csi_t_gen_utility_pvt.add('Begin : in get_cz_txn_line_id ');
2475: x_txn_line_id := NULL ;
2476: x_return_status := fnd_api.g_ret_sts_success ;
2477:
2478: OPEN cz_txn_line_cur ;

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

2477:
2478: OPEN cz_txn_line_cur ;
2479: FETCH cz_txn_line_cur INTO x_txn_line_id ;
2480: CLOSE cz_txn_line_cur ;
2481: csi_t_gen_utility_pvt.add('x_txn_line_id :'|| x_txn_line_id);
2482:
2483: EXCEPTION
2484: WHEN OTHERS
2485: THEN