[Home] [Help]
227: WHERE instance_id = l_u_instance_rec.instance_id;
228:
229:
230:
231: l_split_flag := nvl(fnd_profile.value('CSI_AUTO_SPLIT_INSTANCE' ),'N');
232: debug(' profile_auto_split : '||l_split_flag);
233:
234: l_order_line_rec := p_order_line_rec;
235: l_cp_ind := 0;
8915: l_ratio_split_qty := 1;
8916:
8917: IF l_order_line_rec.fulfilled_quantity > 1 THEN
8918:
8919: l_split_flag := nvl(fnd_profile.value('CSI_AUTO_SPLIT_INSTANCE'), 'N');
8920:
8921: debug(' auto split profile :'||l_split_flag);
8922:
8923: l_ratio_split_flag := 'N';
10718: ASO_HANDLE_EXCEPTION EXCEPTION;
10719: BEGIN
10720: SAVEPOINT PROCESS_OLD_ORDER_LINES;
10721: --
10722: l_process_profile := fnd_profile.value('CSI_PROCESS_FULFILL_LINES');
10723: --
10724: if l_process_profile is null then
10725: fnd_file.put_line(fnd_file.log,'Profile CSI_PROCESS_FULFILL_LINES is not set');
10726: retcode := 2;
11257: -- Get the Profile Option ID
11258: Begin
11259: select profile_option_id
11260: into l_profile_option_id
11261: from FND_PROFILE_OPTIONS
11262: where upper(profile_option_name) = 'CSI_PROCESS_FULFILL_LINES';
11263: Exception
11264: when no_data_found then
11265: fnd_file.put_line(fnd_file.log,'Unable to find the Profile Option CSI_PROCESS_FULFILL_LINES');
11352: End Loop;
11353: if v_ret_counter = 0 then
11354: fnd_file.put_line(fnd_file.log,'All Old Fulfillable lines have been Processed. Updating the Profile');
11355: -- update the profile
11356: UPDATE fnd_profile_option_values
11357: SET profile_option_value = 'N'
11358: WHERE profile_option_id = l_profile_option_id
11359: AND application_id=542 --fix for the bug 4907945
11360: AND level_id = 10001;