1251: l_pricing_attribute15:=NULL;
1252: END IF;
1253:
1254: -- Standard call to check for call compatibility
1255: --oe_debug_pub.initialize;
1256: oe_debug_pub.debug_on;
1257: fname := oe_debug_pub.set_debug_mode('FILE');
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1252: END IF;
1253:
1254: -- Standard call to check for call compatibility
1255: --oe_debug_pub.initialize;
1256: oe_debug_pub.debug_on;
1257: fname := oe_debug_pub.set_debug_mode('FILE');
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1253:
1254: -- Standard call to check for call compatibility
1255: --oe_debug_pub.initialize;
1256: oe_debug_pub.debug_on;
1257: fname := oe_debug_pub.set_debug_mode('FILE');
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1254: -- Standard call to check for call compatibility
1255: --oe_debug_pub.initialize;
1256: oe_debug_pub.debug_on;
1257: fname := oe_debug_pub.set_debug_mode('FILE');
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1255: --oe_debug_pub.initialize;
1256: oe_debug_pub.debug_on;
1257: fname := oe_debug_pub.set_debug_mode('FILE');
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1256: oe_debug_pub.debug_on;
1257: fname := oe_debug_pub.set_debug_mode('FILE');
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1257: fname := oe_debug_pub.set_debug_mode('FILE');
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1258: oe_debug_pub.add('Debugging is on in Procedure Fetch List Price ');
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1259: oe_debug_pub.add('Begin Kanan Fetch_List_Price');
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1260: oe_debug_pub.add('============================');
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1261: oe_debug_pub.add(' p_validation_level: '|| p_validation_level);
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1262: oe_debug_pub.add('price_list_id: '||p_price_list_id);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1263: oe_debug_pub.add('inventory_item_id: '|| p_inventory_item_id);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1264: oe_debug_pub.add('Unit code :'||p_unit_code);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1272: oe_debug_pub.add(' p_pricing_attribute2: '|| p_pricing_attribute2);
1265: oe_debug_pub.add('p_service_duration :'|| p_service_duration);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1272: oe_debug_pub.add(' p_pricing_attribute2: '|| p_pricing_attribute2);
1273: oe_debug_pub.add(' p_pricing_attribute3: '|| p_pricing_attribute3);
1266: oe_debug_pub.add(' p_item_type_code :'|| p_item_type_code);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1272: oe_debug_pub.add(' p_pricing_attribute2: '|| p_pricing_attribute2);
1273: oe_debug_pub.add(' p_pricing_attribute3: '|| p_pricing_attribute3);
1274: oe_debug_pub.add(' p_pricing_attribute4: '|| p_pricing_attribute4);
1267: oe_debug_pub.add('Base Price : '|| p_base_price);
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1272: oe_debug_pub.add(' p_pricing_attribute2: '|| p_pricing_attribute2);
1273: oe_debug_pub.add(' p_pricing_attribute3: '|| p_pricing_attribute3);
1274: oe_debug_pub.add(' p_pricing_attribute4: '|| p_pricing_attribute4);
1275:
1268: oe_debug_pub.add(' p_pricing_date: '|| p_pricing_date);
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1272: oe_debug_pub.add(' p_pricing_attribute2: '|| p_pricing_attribute2);
1273: oe_debug_pub.add(' p_pricing_attribute3: '|| p_pricing_attribute3);
1274: oe_debug_pub.add(' p_pricing_attribute4: '|| p_pricing_attribute4);
1275:
1276:
1269: oe_debug_pub.add('p_fetch_attempts: '||p_fetch_attempts );
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1272: oe_debug_pub.add(' p_pricing_attribute2: '|| p_pricing_attribute2);
1273: oe_debug_pub.add(' p_pricing_attribute3: '|| p_pricing_attribute3);
1274: oe_debug_pub.add(' p_pricing_attribute4: '|| p_pricing_attribute4);
1275:
1276:
1277: --DBMS_output.Put_line('Begin Kanan Fetch_List_Price');
1270: oe_debug_pub.add('p_prc_method_code: '||p_prc_method_code);
1271: oe_debug_pub.add(' p_pricing_attribute1: '|| p_pricing_attribute1);
1272: oe_debug_pub.add(' p_pricing_attribute2: '|| p_pricing_attribute2);
1273: oe_debug_pub.add(' p_pricing_attribute3: '|| p_pricing_attribute3);
1274: oe_debug_pub.add(' p_pricing_attribute4: '|| p_pricing_attribute4);
1275:
1276:
1277: --DBMS_output.Put_line('Begin Kanan Fetch_List_Price');
1278: --DBMS_output.Put_line('============================');