[Home] [Help]
2236: l_column_name1 varchar2(30) :=null;
2237: l_error_text pay_message_lines.line_text%TYPE := null;
2238: l_user_status pay_batch_control_totals.control_status%TYPE :=null;
2239: l_user_message pay_message_lines.line_text%TYPE :=null;
2240: -- Additions for standard totalling functionality
2241: l_std_status pay_batch_control_totals.control_status%TYPE :=null;
2242: l_std_message pay_message_lines.line_text%TYPE :=null;
2243: --
2244: column_is_null exception;
2315: raise invalid_value;
2316: end;
2317: -- The core batch control checks were validated successfully, therefore
2318: -- carry out the control checks for the particular control.
2319: -- See if its a standard control check first. If not, pass on to be dealt
2320: -- with by user check routine
2321:
2322:
2323: -- next block carries out standard totalling checks. l_std_status is returned as
2319: -- See if its a standard control check first. If not, pass on to be dealt
2320: -- with by user check routine
2321:
2322:
2323: -- next block carries out standard totalling checks. l_std_status is returned as
2324: -- Warning, Error or Custom (W,E,C). A status of custom is returned when
2325: -- control_type is not a standard control total and is therefore assumed
2326: -- to have been added as a part of customization
2327:
2321:
2322:
2323: -- next block carries out standard totalling checks. l_std_status is returned as
2324: -- Warning, Error or Custom (W,E,C). A status of custom is returned when
2325: -- control_type is not a standard control total and is therefore assumed
2326: -- to have been added as a part of customization
2327:
2328: begin
2329:
2326: -- to have been added as a part of customization
2327:
2328: begin
2329:
2330: pay_standard_check.check_control(p_batch_id,
2331: g_control_record.control_type,
2332: g_control_record.control_total,
2333: l_std_status,l_std_message);
2334:
2371: raise user_control_error;
2372: end;
2373:
2374:
2375: if(l_std_status <> 'C') then --control was a standard one and has been
2376: -- processed by the above routine
2377:
2378: -- update control status. Both V and W -> V in pay_batch_control_totals
2379:
2631: end if;
2632: --
2633: hr_utility.set_location('payplnk.validate_controls',30);
2634:
2635: -- end section dealing with user defined controls as opposed to standard controls
2636: end if;
2637: --
2638: exception
2639: when column_is_null then