DBA Data[Home] [Help]

APPS.HR_API_USER_HOOKS dependencies on HR_GENERAL

Line 340: -- returned from hr_general.describe_procedure is for a function

336: hr_utility.set_location(l_proc, 20);
337: l_para_valid := false;
338: --
339: -- Check the argument name has been set. If it is not set the entry
340: -- returned from hr_general.describe_procedure is for a function
341: -- return value. Package functions should not be called.
342: --
343: elsif p_call_parameter_name is null then
344: -- Error: A package function cannot be called. Only package procedures

Line 678: -- hr_general.describe_procedure

674: ,p_hook_parameter_datatypes in tbl_parameter_datatype
675: ) is
676: --
677: -- Local variables to catch the values returned from
678: -- hr_general.describe_procedure
679: --
680: l_overload dbms_describe.number_table;
681: l_position dbms_describe.number_table;
682: l_level dbms_describe.number_table;

Line 700: l_describe_error boolean := false; -- Indicates if the hr_general.

696: l_pre_overload number; -- Overload number for the previous
697: -- parameter.
698: l_param_valid boolean := true; -- Indicates if the current
699: -- parameter is valid for this hook.
700: l_describe_error boolean := false; -- Indicates if the hr_general.
701: -- describe_procedure raised an
702: -- error for the call package
703: -- procedure.
704: l_encoded_err_text varchar2(2000); -- Set to the encoded error text

Line 714: -- that errors raised by hr_general.describe_procedure can be trapped and

710: hr_utility.set_location('Entering:'|| l_proc, 10);
711: --
712: -- Call an RDMS procedure to obtain the list of parameters to the call
713: -- package procedure. A separate begin ... end block has been specified so
714: -- that errors raised by hr_general.describe_procedure can be trapped and
715: -- handled locally.
716: --
717: begin
718: hr_general.describe_procedure

Line 718: hr_general.describe_procedure

714: -- that errors raised by hr_general.describe_procedure can be trapped and
715: -- handled locally.
716: --
717: begin
718: hr_general.describe_procedure
719: (object_name => p_call_package || '.' || p_call_procedure
720: ,reserved1 => null
721: ,reserved2 => null
722: ,overload => l_overload

Line 771: -- hr_general.describe_procedure did not raise an error.

767: end;
768: hr_utility.set_location(l_proc, 70);
769: --
770: -- Only carry out the parameter validation if
771: -- hr_general.describe_procedure did not raise an error.
772: --
773: if not l_describe_error then
774: --
775: -- If the first parameter in the list has a data type of 'UNDEFINED'

Line 882: -- If hr_general.describe_procedure raised an error or the last parameter

878: and object_version_number = p_object_version_number;
879: end if;
880: end if;
881: --
882: -- If hr_general.describe_procedure raised an error or the last parameter
883: -- processed was invalid then the calling code which has been built-up is
884: -- not complete and it should not be added to the rest of the source code.
885: -- Either this procedure (for a hr_general.describe_procedure error) or
886: -- the chk_param_in_hook_proc_call function (for a parameter error) has set

Line 885: -- Either this procedure (for a hr_general.describe_procedure error) or

881: --
882: -- If hr_general.describe_procedure raised an error or the last parameter
883: -- processed was invalid then the calling code which has been built-up is
884: -- not complete and it should not be added to the rest of the source code.
885: -- Either this procedure (for a hr_general.describe_procedure error) or
886: -- the chk_param_in_hook_proc_call function (for a parameter error) has set
887: -- the AOL message stack will details of the error. The error details should
888: -- be written to the HR_API_HOOK_CALLS using the encoded format. Some comment
889: -- text and a 'null' statement should be added to the hook package body

Line 999: -- hr_general.describe_procedure

995: ,p_hook_parameter_datatypes in tbl_parameter_datatype
996: ) return boolean is
997: --
998: -- Local variables to catch the values returned from
999: -- hr_general.describe_procedure
1000: --
1001: l_overload dbms_describe.number_table;
1002: l_position dbms_describe.number_table;
1003: l_level dbms_describe.number_table;

Line 1039: -- specified so that errors raised by hr_general.describe_procedure can

1035: --
1036: -- Build the code to call the specified legislation package function.
1037: -- Call an RDMS procedure to obtain the list of parameters to the
1038: -- legislation package function. A separate begin ... end block has been
1039: -- specified so that errors raised by hr_general.describe_procedure can
1040: -- be trapped and handled locally.
1041: --
1042: begin
1043: hr_general.describe_procedure

Line 1043: hr_general.describe_procedure

1039: -- specified so that errors raised by hr_general.describe_procedure can
1040: -- be trapped and handled locally.
1041: --
1042: begin
1043: hr_general.describe_procedure
1044: (object_name => p_legislation_package || '.' ||
1045: p_legislation_function
1046: ,reserved1 => null
1047: ,reserved2 => null

Line 1100: -- hr_general.describe_procedure did not raise an error.

1096: end;
1097: hr_utility.set_location(l_proc, 70);
1098: --
1099: -- Only carry out the parameter validation if
1100: -- hr_general.describe_procedure did not raise an error.
1101: --
1102: if not l_err_found then
1103: --
1104: -- Ensure the legislation package function is really a function, and not

Line 1106: -- hr_general.describe_procedure is blank.

1102: if not l_err_found then
1103: --
1104: -- Ensure the legislation package function is really a function, and not
1105: -- a procedure, by checking the first parameter name returned by
1106: -- hr_general.describe_procedure is blank.
1107: --
1108: if l_argument_name(1) is not null then
1109: -- Error: The legislation function can only be a function. It cannot be
1110: -- a procedure. This API module will not execute until this problem has

Line 1131: -- hr_general.describe_procedure are not passed to the

1127: --
1128: -- Build the function call and parameter list. Checking that the
1129: -- required parameters are available in the hook package procedure.
1130: -- (Details of the first parameter returned by
1131: -- hr_general.describe_procedure are not passed to the
1132: -- chk_param_in_hook_leg_func procedure. If it was passed
1133: -- across an error would be raised.
1134: --
1135: l_call_code := 'l_legislation_code := ' || p_legislation_package || '.';

Line 2475: -- hr_general.describe_procedure

2471: ,p_param_list_error out nocopy boolean
2472: ) is
2473: --
2474: -- Local variables to catch the values returned from
2475: -- hr_general.describe_procedure
2476: --
2477: l_overload dbms_describe.number_table;
2478: l_position dbms_describe.number_table;
2479: l_level dbms_describe.number_table;

Line 2494: -- hr_general.

2490: -- Other local variables
2491: --
2492: l_loop binary_integer; -- Loop counter
2493: l_error boolean := false; -- Indicates if the
2494: -- hr_general.
2495: -- describe_procedure raised an
2496: -- error for the hook package
2497: -- procedure. Or shows there is
2498: -- a problem with a parameter

Line 2515: -- that errors raised by hr_general.describe_procedure can be trapped and

2511: hr_utility.set_location('Entering:'|| l_proc, 10);
2512: --
2513: -- Call an RDMS procedure to obtain the list of parameters to the hook
2514: -- package procedure. A separate begin ... end block has been specified so
2515: -- that errors raised by hr_general.describe_procedure can be trapped and
2516: -- handled locally.
2517: --
2518: begin
2519: hr_general.describe_procedure

Line 2519: hr_general.describe_procedure

2515: -- that errors raised by hr_general.describe_procedure can be trapped and
2516: -- handled locally.
2517: --
2518: begin
2519: hr_general.describe_procedure
2520: (object_name => p_hook_package || '.' || p_hook_procedure
2521: ,reserved1 => null
2522: ,reserved2 => null
2523: ,overload => l_overload

Line 2579: -- hr_general.describe_procedure did not raise an error.

2575: end;
2576: hr_utility.set_location(l_proc, 70);
2577: --
2578: -- Only continue with the individual parameter validation if
2579: -- hr_general.describe_procedure did not raise an error.
2580: --
2581: if not l_error then
2582: --
2583: -- If the first parameter in the list has a data type of 'UNDEFINED'

Line 2667: -- returned from hr_general.describe_procedure is for a function

2663: l_error := true;
2664: hr_utility.set_location(l_proc, 110);
2665: --
2666: -- Check the argument name has been set. If it is not set entry
2667: -- returned from hr_general.describe_procedure is for a function
2668: -- return value. Hook package functions should not be called.
2669: --
2670: elsif l_argument_name(l_loop) is null then
2671: -- Error: The hook package procedure can only be a procedure. It