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