DBA Data[Home] [Help]

APPS.HR_API_USER_HOOKS dependencies on HR_GENERAL

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

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

Line 685: -- hr_general.describe_procedure

681: ,p_hook_parameter_datatypes in tbl_parameter_datatype
682: ) is
683: --
684: -- Local variables to catch the values returned from
685: -- hr_general.describe_procedure
686: --
687: l_overload dbms_describe.number_table;
688: l_position dbms_describe.number_table;
689: l_level dbms_describe.number_table;

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

703: l_pre_overload number; -- Overload number for the previous
704: -- parameter.
705: l_param_valid boolean := true; -- Indicates if the current
706: -- parameter is valid for this hook.
707: l_describe_error boolean := false; -- Indicates if the hr_general.
708: -- describe_procedure raised an
709: -- error for the call package
710: -- procedure.
711: l_encoded_err_text varchar2(2000); -- Set to the encoded error text

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

717: hr_utility.set_location('Entering:'|| l_proc, 10);
718: --
719: -- Call an RDMS procedure to obtain the list of parameters to the call
720: -- package procedure. A separate begin ... end block has been specified so
721: -- that errors raised by hr_general.describe_procedure can be trapped and
722: -- handled locally.
723: --
724: begin
725: hr_general.describe_procedure

Line 725: hr_general.describe_procedure

721: -- that errors raised by hr_general.describe_procedure can be trapped and
722: -- handled locally.
723: --
724: begin
725: hr_general.describe_procedure
726: (object_name => p_call_package || '.' || p_call_procedure
727: ,reserved1 => null
728: ,reserved2 => null
729: ,overload => l_overload

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

774: end;
775: hr_utility.set_location(l_proc, 70);
776: --
777: -- Only carry out the parameter validation if
778: -- hr_general.describe_procedure did not raise an error.
779: --
780: if not l_describe_error then
781: --
782: -- If the first parameter in the list has a data type of 'UNDEFINED'

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

885: and object_version_number = p_object_version_number;
886: end if;
887: end if;
888: --
889: -- If hr_general.describe_procedure raised an error or the last parameter
890: -- processed was invalid then the calling code which has been built-up is
891: -- not complete and it should not be added to the rest of the source code.
892: -- Either this procedure (for a hr_general.describe_procedure error) or
893: -- the chk_param_in_hook_proc_call function (for a parameter error) has set

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

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

Line 1006: -- hr_general.describe_procedure

1002: ,p_hook_parameter_datatypes in tbl_parameter_datatype
1003: ) return boolean is
1004: --
1005: -- Local variables to catch the values returned from
1006: -- hr_general.describe_procedure
1007: --
1008: l_overload dbms_describe.number_table;
1009: l_position dbms_describe.number_table;
1010: l_level dbms_describe.number_table;

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

1042: --
1043: -- Build the code to call the specified legislation package function.
1044: -- Call an RDMS procedure to obtain the list of parameters to the
1045: -- legislation package function. A separate begin ... end block has been
1046: -- specified so that errors raised by hr_general.describe_procedure can
1047: -- be trapped and handled locally.
1048: --
1049: begin
1050: hr_general.describe_procedure

Line 1050: hr_general.describe_procedure

1046: -- specified so that errors raised by hr_general.describe_procedure can
1047: -- be trapped and handled locally.
1048: --
1049: begin
1050: hr_general.describe_procedure
1051: (object_name => p_legislation_package || '.' ||
1052: p_legislation_function
1053: ,reserved1 => null
1054: ,reserved2 => null

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

1103: end;
1104: hr_utility.set_location(l_proc, 70);
1105: --
1106: -- Only carry out the parameter validation if
1107: -- hr_general.describe_procedure did not raise an error.
1108: --
1109: if not l_err_found then
1110: --
1111: -- Ensure the legislation package function is really a function, and not

Line 1113: -- hr_general.describe_procedure is blank.

1109: if not l_err_found then
1110: --
1111: -- Ensure the legislation package function is really a function, and not
1112: -- a procedure, by checking the first parameter name returned by
1113: -- hr_general.describe_procedure is blank.
1114: --
1115: if l_argument_name(1) is not null then
1116: -- Error: The legislation function can only be a function. It cannot be
1117: -- a procedure. This API module will not execute until this problem has

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

1134: --
1135: -- Build the function call and parameter list. Checking that the
1136: -- required parameters are available in the hook package procedure.
1137: -- (Details of the first parameter returned by
1138: -- hr_general.describe_procedure are not passed to the
1139: -- chk_param_in_hook_leg_func procedure. If it was passed
1140: -- across an error would be raised.
1141: --
1142: l_call_code := 'l_legislation_code := ' || p_legislation_package || '.';

Line 2482: -- hr_general.describe_procedure

2478: ,p_param_list_error out nocopy boolean
2479: ) is
2480: --
2481: -- Local variables to catch the values returned from
2482: -- hr_general.describe_procedure
2483: --
2484: l_overload dbms_describe.number_table;
2485: l_position dbms_describe.number_table;
2486: l_level dbms_describe.number_table;

Line 2501: -- hr_general.

2497: -- Other local variables
2498: --
2499: l_loop binary_integer; -- Loop counter
2500: l_error boolean := false; -- Indicates if the
2501: -- hr_general.
2502: -- describe_procedure raised an
2503: -- error for the hook package
2504: -- procedure. Or shows there is
2505: -- a problem with a parameter

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

2518: hr_utility.set_location('Entering:'|| l_proc, 10);
2519: --
2520: -- Call an RDMS procedure to obtain the list of parameters to the hook
2521: -- package procedure. A separate begin ... end block has been specified so
2522: -- that errors raised by hr_general.describe_procedure can be trapped and
2523: -- handled locally.
2524: --
2525: begin
2526: hr_general.describe_procedure

Line 2526: hr_general.describe_procedure

2522: -- that errors raised by hr_general.describe_procedure can be trapped and
2523: -- handled locally.
2524: --
2525: begin
2526: hr_general.describe_procedure
2527: (object_name => p_hook_package || '.' || p_hook_procedure
2528: ,reserved1 => null
2529: ,reserved2 => null
2530: ,overload => l_overload

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

2582: end;
2583: hr_utility.set_location(l_proc, 70);
2584: --
2585: -- Only continue with the individual parameter validation if
2586: -- hr_general.describe_procedure did not raise an error.
2587: --
2588: if not l_error then
2589: --
2590: -- If the first parameter in the list has a data type of 'UNDEFINED'

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

2673: l_error := true;
2674: hr_utility.set_location(l_proc, 110);
2675: --
2676: -- Check the argument name has been set. If it is not set entry
2677: -- returned from hr_general.describe_procedure is for a function
2678: -- return value. Hook package functions should not be called.
2679: --
2680: elsif l_argument_name(l_loop) is null then
2681: -- Error: The hook package procedure can only be a procedure. It