eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PUMP_META_MAPPER dependencies on HR_UTILITY

Line 296: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );

292: if p_function_parameter.parameter_name = 'P_BUSINESS_GROUP_ID' then
293: if p_function_parameter.datatype <> c_dtype_number and
294: p_function_parameter.datatype <> c_dtype_binary_integer
295: then
296: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
297: hr_utility.set_message_token( 'ARGUMENT', 'P_BUSINESS_GROUP_ID' );
298: hr_utility.raise_error;
299: end if;
300: elsif p_function_parameter.parameter_name = 'P_VALIDATE' then

Line 297: hr_utility.set_message_token( 'ARGUMENT', 'P_BUSINESS_GROUP_ID' );

293: if p_function_parameter.datatype <> c_dtype_number and
294: p_function_parameter.datatype <> c_dtype_binary_integer
295: then
296: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
297: hr_utility.set_message_token( 'ARGUMENT', 'P_BUSINESS_GROUP_ID' );
298: hr_utility.raise_error;
299: end if;
300: elsif p_function_parameter.parameter_name = 'P_VALIDATE' then
301: if p_function_parameter.datatype <> c_dtype_boolean then

Line 298: hr_utility.raise_error;

294: p_function_parameter.datatype <> c_dtype_binary_integer
295: then
296: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
297: hr_utility.set_message_token( 'ARGUMENT', 'P_BUSINESS_GROUP_ID' );
298: hr_utility.raise_error;
299: end if;
300: elsif p_function_parameter.parameter_name = 'P_VALIDATE' then
301: if p_function_parameter.datatype <> c_dtype_boolean then
302: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );

Line 302: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );

298: hr_utility.raise_error;
299: end if;
300: elsif p_function_parameter.parameter_name = 'P_VALIDATE' then
301: if p_function_parameter.datatype <> c_dtype_boolean then
302: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
303: hr_utility.set_message_token( 'ARGUMENT', 'P_VALIDATE' );
304: hr_utility.raise_error;
305: end if;
306: elsif p_function_parameter.parameter_name = 'P_DATA_PUMP_ALWAYS_CALL'

Line 303: hr_utility.set_message_token( 'ARGUMENT', 'P_VALIDATE' );

299: end if;
300: elsif p_function_parameter.parameter_name = 'P_VALIDATE' then
301: if p_function_parameter.datatype <> c_dtype_boolean then
302: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
303: hr_utility.set_message_token( 'ARGUMENT', 'P_VALIDATE' );
304: hr_utility.raise_error;
305: end if;
306: elsif p_function_parameter.parameter_name = 'P_DATA_PUMP_ALWAYS_CALL'
307: then

Line 304: hr_utility.raise_error;

300: elsif p_function_parameter.parameter_name = 'P_VALIDATE' then
301: if p_function_parameter.datatype <> c_dtype_boolean then
302: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
303: hr_utility.set_message_token( 'ARGUMENT', 'P_VALIDATE' );
304: hr_utility.raise_error;
305: end if;
306: elsif p_function_parameter.parameter_name = 'P_DATA_PUMP_ALWAYS_CALL'
307: then
308: if p_function_parameter.datatype <> c_dtype_varchar2 then

Line 309: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );

305: end if;
306: elsif p_function_parameter.parameter_name = 'P_DATA_PUMP_ALWAYS_CALL'
307: then
308: if p_function_parameter.datatype <> c_dtype_varchar2 then
309: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
310: hr_utility.set_message_token( 'ARGUMENT', 'P_DATA_PUMP_ALWAYS_CALL' );
311: hr_utility.raise_error;
312: end if;
313: end if;

Line 310: hr_utility.set_message_token( 'ARGUMENT', 'P_DATA_PUMP_ALWAYS_CALL' );

306: elsif p_function_parameter.parameter_name = 'P_DATA_PUMP_ALWAYS_CALL'
307: then
308: if p_function_parameter.datatype <> c_dtype_varchar2 then
309: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
310: hr_utility.set_message_token( 'ARGUMENT', 'P_DATA_PUMP_ALWAYS_CALL' );
311: hr_utility.raise_error;
312: end if;
313: end if;
314: end check_special_parameter;

Line 311: hr_utility.raise_error;

307: then
308: if p_function_parameter.datatype <> c_dtype_varchar2 then
309: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
310: hr_utility.set_message_token( 'ARGUMENT', 'P_DATA_PUMP_ALWAYS_CALL' );
311: hr_utility.raise_error;
312: end if;
313: end if;
314: end check_special_parameter;
315:

Line 398: hr_utility.set_message( 800, 'HR_50328_DP_SEED_SPECIAL_ARG' );

394: ( ( l_mapping_type = c_mapping_type_aliased or
395: l_mapping_type = c_mapping_type_user_key ) and
396: special_parameter( l_mapping_definition ) )
397: then
398: hr_utility.set_message( 800, 'HR_50328_DP_SEED_SPECIAL_ARG' );
399: hr_utility.set_message_token( 'ARGUMENT', l_parameter_name );
400: hr_utility.raise_error;
401: end if;
402:

Line 399: hr_utility.set_message_token( 'ARGUMENT', l_parameter_name );

395: l_mapping_type = c_mapping_type_user_key ) and
396: special_parameter( l_mapping_definition ) )
397: then
398: hr_utility.set_message( 800, 'HR_50328_DP_SEED_SPECIAL_ARG' );
399: hr_utility.set_message_token( 'ARGUMENT', l_parameter_name );
400: hr_utility.raise_error;
401: end if;
402:
403: l_seqno := l_seqno + 1;

Line 400: hr_utility.raise_error;

396: special_parameter( l_mapping_definition ) )
397: then
398: hr_utility.set_message( 800, 'HR_50328_DP_SEED_SPECIAL_ARG' );
399: hr_utility.set_message_token( 'ARGUMENT', l_parameter_name );
400: hr_utility.raise_error;
401: end if;
402:
403: l_seqno := l_seqno + 1;
404: p_seed_parameter_tbl(l_seqno).parameter_name := l_parameter_name;

Line 510: hr_utility.trace('Entered get_latest_api.');

506: l_max_mandatory_args number;
507: l_distinct_overloads dbms_describe.number_table;
508: begin
509: if g_debug then
510: hr_utility.trace('Entered get_latest_api.');
511: end if;
512:
513: --
514: -- Want the latest overload for a procedure i.e. the maximum overload

Line 530: hr_utility.trace

526: l_distinct_overloads( p_overload(i) ) := -1;
527:
528: if g_debug then
529: if p_position(i) = 0 then
530: hr_utility.trace
531: ('Unsuitable overload ' || p_overload(i) || ' is a function.');
532: else
533: hr_utility.trace
534: ('Unsuitable overload ' || p_overload(i) || ' has no parameters');

Line 533: hr_utility.trace

529: if p_position(i) = 0 then
530: hr_utility.trace
531: ('Unsuitable overload ' || p_overload(i) || ' is a function.');
532: else
533: hr_utility.trace
534: ('Unsuitable overload ' || p_overload(i) || ' has no parameters');
535: end if;
536: end if;
537:

Line 546: hr_utility.trace

542: elsif not l_distinct_overloads.exists( p_overload(i) ) then
543: l_distinct_overloads( p_overload(i) ) := 0;
544:
545: if g_debug then
546: hr_utility.trace
547: ('Overload ' || p_overload(i) || ' is a candidate API.');
548: end if;
549: end if;
550:

Line 578: hr_utility.trace('No candidate API procedures found.');

574: p_parameters := false;
575: p_apis := false;
576:
577: if g_debug then
578: hr_utility.trace('No candidate API procedures found.');
579: end if;
580:
581: return;
582: else

Line 612: hr_utility.trace

608: l_max_mandatory_args := l_distinct_overloads(i);
609: loop
610:
611: if g_debug then
612: hr_utility.trace
613: ('Overload: ' || i || ' Mandatory Args: ' || l_distinct_overloads(i)
614: );
615: end if;
616:

Line 629: hr_utility.trace('Selected overload: ' || l_chosen_overload);

625:
626: end loop;
627:
628: if g_debug then
629: hr_utility.trace('Selected overload: ' || l_chosen_overload);
630: end if;
631:
632: --
633: -- Delete information that does not belong to the selected overload

Line 663: hr_utility.trace('get_latest_api: deleted unwanted overloads');

659: i := j;
660: end loop;
661:
662: if g_debug then
663: hr_utility.trace('get_latest_api: deleted unwanted overloads');
664: end if;
665: end get_latest_api;
666:
667: -- -------------------------- describe_api --------------------------------

Line 705: hr_utility.trace('Entered describe_api.');

701: l_apis boolean;
702: --
703: begin
704: if g_debug then
705: hr_utility.trace('Entered describe_api.');
706: end if;
707:
708: begin
709: hr_general.describe_procedure

Line 727: hr_utility.set_message( 800, 'HR_50305_DP_NO_SUCH_API' );

723: radix => l_radix,
724: spare => l_spare );
725: exception
726: when package_not_exists or proc_not_in_package or invalid_object_name then
727: hr_utility.set_message( 800, 'HR_50305_DP_NO_SUCH_API' );
728: hr_utility.set_message_token( 'PACKAGE', p_module_package );
729: hr_utility.set_message_token( 'MODULE', p_module_name );
730: hr_utility.raise_error;
731: when remote_object then

Line 728: hr_utility.set_message_token( 'PACKAGE', p_module_package );

724: spare => l_spare );
725: exception
726: when package_not_exists or proc_not_in_package or invalid_object_name then
727: hr_utility.set_message( 800, 'HR_50305_DP_NO_SUCH_API' );
728: hr_utility.set_message_token( 'PACKAGE', p_module_package );
729: hr_utility.set_message_token( 'MODULE', p_module_name );
730: hr_utility.raise_error;
731: when remote_object then
732: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );

Line 729: hr_utility.set_message_token( 'MODULE', p_module_name );

725: exception
726: when package_not_exists or proc_not_in_package or invalid_object_name then
727: hr_utility.set_message( 800, 'HR_50305_DP_NO_SUCH_API' );
728: hr_utility.set_message_token( 'PACKAGE', p_module_package );
729: hr_utility.set_message_token( 'MODULE', p_module_name );
730: hr_utility.raise_error;
731: when remote_object then
732: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
733: hr_utility.set_message_token

Line 730: hr_utility.raise_error;

726: when package_not_exists or proc_not_in_package or invalid_object_name then
727: hr_utility.set_message( 800, 'HR_50305_DP_NO_SUCH_API' );
728: hr_utility.set_message_token( 'PACKAGE', p_module_package );
729: hr_utility.set_message_token( 'MODULE', p_module_name );
730: hr_utility.raise_error;
731: when remote_object then
732: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
733: hr_utility.set_message_token
734: ( 'OBJECT', p_module_package || '.' || p_module_name );

Line 732: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );

728: hr_utility.set_message_token( 'PACKAGE', p_module_package );
729: hr_utility.set_message_token( 'MODULE', p_module_name );
730: hr_utility.raise_error;
731: when remote_object then
732: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
733: hr_utility.set_message_token
734: ( 'OBJECT', p_module_package || '.' || p_module_name );
735: hr_utility.raise_error;
736: when invalid_package then

Line 733: hr_utility.set_message_token

729: hr_utility.set_message_token( 'MODULE', p_module_name );
730: hr_utility.raise_error;
731: when remote_object then
732: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
733: hr_utility.set_message_token
734: ( 'OBJECT', p_module_package || '.' || p_module_name );
735: hr_utility.raise_error;
736: when invalid_package then
737: hr_utility.set_message( 800, 'HR_50306_DP_INVALID_PKG' );

Line 735: hr_utility.raise_error;

731: when remote_object then
732: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
733: hr_utility.set_message_token
734: ( 'OBJECT', p_module_package || '.' || p_module_name );
735: hr_utility.raise_error;
736: when invalid_package then
737: hr_utility.set_message( 800, 'HR_50306_DP_INVALID_PKG' );
738: hr_utility.set_message_token( 'PACKAGE', p_module_package );
739: hr_utility.raise_error;

Line 737: hr_utility.set_message( 800, 'HR_50306_DP_INVALID_PKG' );

733: hr_utility.set_message_token
734: ( 'OBJECT', p_module_package || '.' || p_module_name );
735: hr_utility.raise_error;
736: when invalid_package then
737: hr_utility.set_message( 800, 'HR_50306_DP_INVALID_PKG' );
738: hr_utility.set_message_token( 'PACKAGE', p_module_package );
739: hr_utility.raise_error;
740: end;
741:

Line 738: hr_utility.set_message_token( 'PACKAGE', p_module_package );

734: ( 'OBJECT', p_module_package || '.' || p_module_name );
735: hr_utility.raise_error;
736: when invalid_package then
737: hr_utility.set_message( 800, 'HR_50306_DP_INVALID_PKG' );
738: hr_utility.set_message_token( 'PACKAGE', p_module_package );
739: hr_utility.raise_error;
740: end;
741:
742: if g_debug then

Line 739: hr_utility.raise_error;

735: hr_utility.raise_error;
736: when invalid_package then
737: hr_utility.set_message( 800, 'HR_50306_DP_INVALID_PKG' );
738: hr_utility.set_message_token( 'PACKAGE', p_module_package );
739: hr_utility.raise_error;
740: end;
741:
742: if g_debug then
743: hr_utility.trace('Successful dbms_describe.');

Line 743: hr_utility.trace('Successful dbms_describe.');

739: hr_utility.raise_error;
740: end;
741:
742: if g_debug then
743: hr_utility.trace('Successful dbms_describe.');
744: end if;
745:
746: --
747: -- Get the latest overloaded version of the API.

Line 769: hr_utility.set_message( 800, 'HR_50308_DP_NOT_AN_API' );

765: --
766: -- Check that an API with parameters was found.
767: --
768: if not l_parameters and not l_apis then
769: hr_utility.set_message( 800, 'HR_50308_DP_NOT_AN_API' );
770: hr_utility.set_message_token
771: ( 'OBJECT', p_module_package || '.' || p_module_name );
772: hr_utility.raise_error;
773: end if;

Line 770: hr_utility.set_message_token

766: -- Check that an API with parameters was found.
767: --
768: if not l_parameters and not l_apis then
769: hr_utility.set_message( 800, 'HR_50308_DP_NOT_AN_API' );
770: hr_utility.set_message_token
771: ( 'OBJECT', p_module_package || '.' || p_module_name );
772: hr_utility.raise_error;
773: end if;
774:

Line 772: hr_utility.raise_error;

768: if not l_parameters and not l_apis then
769: hr_utility.set_message( 800, 'HR_50308_DP_NOT_AN_API' );
770: hr_utility.set_message_token
771: ( 'OBJECT', p_module_package || '.' || p_module_name );
772: hr_utility.raise_error;
773: end if;
774:
775: --
776: -- Process the parameters.

Line 789: hr_utility.trace

785: --
786: i := l_position(l_seqno);
787:
788: if g_debug then
789: hr_utility.trace
790: ('Parameter: ' || l_argument_name(l_seqno) || ' Call Position: ' || i ||
791: ' Table Position: ' || l_seqno
792: );
793: end if;

Line 799: hr_utility.set_message( 800, 'HR_50310_DP_BAD_API_ARG_NAME');

795: --
796: -- Check that parameter names start with 'p_'.
797: --
798: if substr(lower(l_argument_name(l_seqno)), 1, 2) <> 'p_' then
799: hr_utility.set_message( 800, 'HR_50310_DP_BAD_API_ARG_NAME');
800: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno));
801: hr_utility.raise_error;
802: end if;
803:

Line 800: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno));

796: -- Check that parameter names start with 'p_'.
797: --
798: if substr(lower(l_argument_name(l_seqno)), 1, 2) <> 'p_' then
799: hr_utility.set_message( 800, 'HR_50310_DP_BAD_API_ARG_NAME');
800: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno));
801: hr_utility.raise_error;
802: end if;
803:
804: --

Line 801: hr_utility.raise_error;

797: --
798: if substr(lower(l_argument_name(l_seqno)), 1, 2) <> 'p_' then
799: hr_utility.set_message( 800, 'HR_50310_DP_BAD_API_ARG_NAME');
800: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno));
801: hr_utility.raise_error;
802: end if;
803:
804: --
805: -- Check that the data type is supported.

Line 814: hr_utility.set_message( 800, 'HR_50311_DP_BAD_API_ARG_TYPE' );

810: l_datatype(l_seqno) <> c_dtype_boolean and
811: l_datatype(l_seqno) <> c_dtype_long and
812: l_datatype(l_seqno) <> c_dtype_clob -- added for bug 13362792
813: then
814: hr_utility.set_message( 800, 'HR_50311_DP_BAD_API_ARG_TYPE' );
815: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
816: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
817: hr_utility.raise_error;
818: end if;

Line 815: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );

811: l_datatype(l_seqno) <> c_dtype_long and
812: l_datatype(l_seqno) <> c_dtype_clob -- added for bug 13362792
813: then
814: hr_utility.set_message( 800, 'HR_50311_DP_BAD_API_ARG_TYPE' );
815: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
816: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
817: hr_utility.raise_error;
818: end if;
819:

Line 816: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );

812: l_datatype(l_seqno) <> c_dtype_clob -- added for bug 13362792
813: then
814: hr_utility.set_message( 800, 'HR_50311_DP_BAD_API_ARG_TYPE' );
815: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
816: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
817: hr_utility.raise_error;
818: end if;
819:
820: --

Line 817: hr_utility.raise_error;

813: then
814: hr_utility.set_message( 800, 'HR_50311_DP_BAD_API_ARG_TYPE' );
815: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
816: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
817: hr_utility.raise_error;
818: end if;
819:
820: --
821: -- Set up the long parameter count.

Line 827: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );

823: if l_datatype(l_seqno) = c_dtype_long then
824: p_parameter_counts.long_parameters :=
825: p_parameter_counts.long_parameters + 1;
826: if p_parameter_counts.long_parameters > 1 then
827: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );
828: hr_utility.set_message_token
829: ( 'API', p_module_package || '.' || p_module_name );
830: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
831: hr_utility.set_message_token( 'FUNCTION', p_module_name );

Line 828: hr_utility.set_message_token

824: p_parameter_counts.long_parameters :=
825: p_parameter_counts.long_parameters + 1;
826: if p_parameter_counts.long_parameters > 1 then
827: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );
828: hr_utility.set_message_token
829: ( 'API', p_module_package || '.' || p_module_name );
830: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
831: hr_utility.set_message_token( 'FUNCTION', p_module_name );
832: hr_utility.raise_error;

Line 830: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );

826: if p_parameter_counts.long_parameters > 1 then
827: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );
828: hr_utility.set_message_token
829: ( 'API', p_module_package || '.' || p_module_name );
830: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
831: hr_utility.set_message_token( 'FUNCTION', p_module_name );
832: hr_utility.raise_error;
833: end if;
834: end if;

Line 831: hr_utility.set_message_token( 'FUNCTION', p_module_name );

827: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );
828: hr_utility.set_message_token
829: ( 'API', p_module_package || '.' || p_module_name );
830: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
831: hr_utility.set_message_token( 'FUNCTION', p_module_name );
832: hr_utility.raise_error;
833: end if;
834: end if;
835:

Line 832: hr_utility.raise_error;

828: hr_utility.set_message_token
829: ( 'API', p_module_package || '.' || p_module_name );
830: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
831: hr_utility.set_message_token( 'FUNCTION', p_module_name );
832: hr_utility.raise_error;
833: end if;
834: end if;
835:
836: --

Line 1056: hr_utility.set_message( 800, 'HR_50312_DP_BAD_MAP_DATA' );

1052: l_seed_parameter.mapping_type <> c_mapping_type_normal and
1053: l_seed_parameter.mapping_definition is null ) or
1054: ( l_seed_parameter.mapping_type is null and
1055: l_seed_parameter.mapping_definition is not null ) then
1056: hr_utility.set_message( 800, 'HR_50312_DP_BAD_MAP_DATA' );
1057: hr_utility.set_message_token
1058: ( 'PARAMETER', l_seed_parameter.parameter_name );
1059: hr_utility.raise_error;
1060: end if;

Line 1057: hr_utility.set_message_token

1053: l_seed_parameter.mapping_definition is null ) or
1054: ( l_seed_parameter.mapping_type is null and
1055: l_seed_parameter.mapping_definition is not null ) then
1056: hr_utility.set_message( 800, 'HR_50312_DP_BAD_MAP_DATA' );
1057: hr_utility.set_message_token
1058: ( 'PARAMETER', l_seed_parameter.parameter_name );
1059: hr_utility.raise_error;
1060: end if;
1061: --

Line 1059: hr_utility.raise_error;

1055: l_seed_parameter.mapping_definition is not null ) then
1056: hr_utility.set_message( 800, 'HR_50312_DP_BAD_MAP_DATA' );
1057: hr_utility.set_message_token
1058: ( 'PARAMETER', l_seed_parameter.parameter_name );
1059: hr_utility.raise_error;
1060: end if;
1061: --
1062: -- Copy values over from the seed data.
1063: --

Line 1292: hr_utility.set_message( 800, 'HR_50313_DP_NO_MAP_PKG' );

1288: p_function.package_name := l_package;
1289: exit;
1290: exception
1291: when package_not_exists or invalid_package then
1292: hr_utility.set_message( 800, 'HR_50313_DP_NO_MAP_PKG' );
1293: hr_utility.set_message_token( 'PACKAGE', l_package );
1294: hr_utility.raise_error;
1295: when remote_object then
1296: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );

Line 1293: hr_utility.set_message_token( 'PACKAGE', l_package );

1289: exit;
1290: exception
1291: when package_not_exists or invalid_package then
1292: hr_utility.set_message( 800, 'HR_50313_DP_NO_MAP_PKG' );
1293: hr_utility.set_message_token( 'PACKAGE', l_package );
1294: hr_utility.raise_error;
1295: when remote_object then
1296: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
1297: hr_utility.set_message_token

Line 1294: hr_utility.raise_error;

1290: exception
1291: when package_not_exists or invalid_package then
1292: hr_utility.set_message( 800, 'HR_50313_DP_NO_MAP_PKG' );
1293: hr_utility.set_message_token( 'PACKAGE', l_package );
1294: hr_utility.raise_error;
1295: when remote_object then
1296: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
1297: hr_utility.set_message_token
1298: ( 'OBJECT', l_package || '.' || p_function.function_name );

Line 1296: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );

1292: hr_utility.set_message( 800, 'HR_50313_DP_NO_MAP_PKG' );
1293: hr_utility.set_message_token( 'PACKAGE', l_package );
1294: hr_utility.raise_error;
1295: when remote_object then
1296: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
1297: hr_utility.set_message_token
1298: ( 'OBJECT', l_package || '.' || p_function.function_name );
1299: hr_utility.raise_error;
1300: when invalid_object_name then

Line 1297: hr_utility.set_message_token

1293: hr_utility.set_message_token( 'PACKAGE', l_package );
1294: hr_utility.raise_error;
1295: when remote_object then
1296: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
1297: hr_utility.set_message_token
1298: ( 'OBJECT', l_package || '.' || p_function.function_name );
1299: hr_utility.raise_error;
1300: when invalid_object_name then
1301: hr_utility.set_message( 800, 'HR_50315_DP_BAD_FUNCTION_NAME' );

Line 1299: hr_utility.raise_error;

1295: when remote_object then
1296: hr_utility.set_message( 800, 'HR_50307_DP_REMOTE_OBJECT' );
1297: hr_utility.set_message_token
1298: ( 'OBJECT', l_package || '.' || p_function.function_name );
1299: hr_utility.raise_error;
1300: when invalid_object_name then
1301: hr_utility.set_message( 800, 'HR_50315_DP_BAD_FUNCTION_NAME' );
1302: hr_utility.set_message_token
1303: ( 'OBJECT', l_package || '.' || p_function.function_name );

Line 1301: hr_utility.set_message( 800, 'HR_50315_DP_BAD_FUNCTION_NAME' );

1297: hr_utility.set_message_token
1298: ( 'OBJECT', l_package || '.' || p_function.function_name );
1299: hr_utility.raise_error;
1300: when invalid_object_name then
1301: hr_utility.set_message( 800, 'HR_50315_DP_BAD_FUNCTION_NAME' );
1302: hr_utility.set_message_token
1303: ( 'OBJECT', l_package || '.' || p_function.function_name );
1304: hr_utility.raise_error;
1305: when proc_not_in_package then

Line 1302: hr_utility.set_message_token

1298: ( 'OBJECT', l_package || '.' || p_function.function_name );
1299: hr_utility.raise_error;
1300: when invalid_object_name then
1301: hr_utility.set_message( 800, 'HR_50315_DP_BAD_FUNCTION_NAME' );
1302: hr_utility.set_message_token
1303: ( 'OBJECT', l_package || '.' || p_function.function_name );
1304: hr_utility.raise_error;
1305: when proc_not_in_package then
1306: if i = p_mapping_package_tbl.count then

Line 1304: hr_utility.raise_error;

1300: when invalid_object_name then
1301: hr_utility.set_message( 800, 'HR_50315_DP_BAD_FUNCTION_NAME' );
1302: hr_utility.set_message_token
1303: ( 'OBJECT', l_package || '.' || p_function.function_name );
1304: hr_utility.raise_error;
1305: when proc_not_in_package then
1306: if i = p_mapping_package_tbl.count then
1307: hr_utility.set_message( 800, 'HR_50314_DP_NO_SUCH_FUNCTION' );
1308: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );

Line 1307: hr_utility.set_message( 800, 'HR_50314_DP_NO_SUCH_FUNCTION' );

1303: ( 'OBJECT', l_package || '.' || p_function.function_name );
1304: hr_utility.raise_error;
1305: when proc_not_in_package then
1306: if i = p_mapping_package_tbl.count then
1307: hr_utility.set_message( 800, 'HR_50314_DP_NO_SUCH_FUNCTION' );
1308: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1309: hr_utility.raise_error;
1310: end if;
1311: end;

Line 1308: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );

1304: hr_utility.raise_error;
1305: when proc_not_in_package then
1306: if i = p_mapping_package_tbl.count then
1307: hr_utility.set_message( 800, 'HR_50314_DP_NO_SUCH_FUNCTION' );
1308: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1309: hr_utility.raise_error;
1310: end if;
1311: end;
1312: end loop;

Line 1309: hr_utility.raise_error;

1305: when proc_not_in_package then
1306: if i = p_mapping_package_tbl.count then
1307: hr_utility.set_message( 800, 'HR_50314_DP_NO_SUCH_FUNCTION' );
1308: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1309: hr_utility.raise_error;
1310: end if;
1311: end;
1312: end loop;
1313:

Line 1329: hr_utility.set_message( 800, 'HR_50318_DP_OVL_FUNCTION' );

1325: --
1326: -- Check for overloaded function call as overloading is not allowed.
1327: --
1328: if l_overload(l_seqno) <> l_first_overload then
1329: hr_utility.set_message( 800, 'HR_50318_DP_OVL_FUNCTION' );
1330: hr_utility.set_message_token
1331: ( 'OBJECT', c_get_function_package || '.' || p_function.function_name );
1332: hr_utility.raise_error;
1333: end if;

Line 1330: hr_utility.set_message_token

1326: -- Check for overloaded function call as overloading is not allowed.
1327: --
1328: if l_overload(l_seqno) <> l_first_overload then
1329: hr_utility.set_message( 800, 'HR_50318_DP_OVL_FUNCTION' );
1330: hr_utility.set_message_token
1331: ( 'OBJECT', c_get_function_package || '.' || p_function.function_name );
1332: hr_utility.raise_error;
1333: end if;
1334:

Line 1332: hr_utility.raise_error;

1328: if l_overload(l_seqno) <> l_first_overload then
1329: hr_utility.set_message( 800, 'HR_50318_DP_OVL_FUNCTION' );
1330: hr_utility.set_message_token
1331: ( 'OBJECT', c_get_function_package || '.' || p_function.function_name );
1332: hr_utility.raise_error;
1333: end if;
1334:
1335: --
1336: -- Handle the function return value.

Line 1351: hr_utility.set_message( 800, 'HR_50317_DP_BAD_FUNCTION_RET' );

1347: ( ( l_datatype( l_seqno ) = c_dtype_number or
1348: l_datatype( l_seqno ) = c_dtype_binary_integer ) and
1349: p_parameter.datatype = c_dtype_varchar2 )
1350: then
1351: hr_utility.set_message( 800, 'HR_50317_DP_BAD_FUNCTION_RET' );
1352: hr_utility.set_message_token
1353: ( 'FUNCTION', c_get_function_package || '.' || p_function.function_name );
1354: hr_utility.set_message_token( 'PARAMETER', p_parameter.parameter_name );
1355: hr_utility.raise_error;

Line 1352: hr_utility.set_message_token

1348: l_datatype( l_seqno ) = c_dtype_binary_integer ) and
1349: p_parameter.datatype = c_dtype_varchar2 )
1350: then
1351: hr_utility.set_message( 800, 'HR_50317_DP_BAD_FUNCTION_RET' );
1352: hr_utility.set_message_token
1353: ( 'FUNCTION', c_get_function_package || '.' || p_function.function_name );
1354: hr_utility.set_message_token( 'PARAMETER', p_parameter.parameter_name );
1355: hr_utility.raise_error;
1356: end if;

Line 1354: hr_utility.set_message_token( 'PARAMETER', p_parameter.parameter_name );

1350: then
1351: hr_utility.set_message( 800, 'HR_50317_DP_BAD_FUNCTION_RET' );
1352: hr_utility.set_message_token
1353: ( 'FUNCTION', c_get_function_package || '.' || p_function.function_name );
1354: hr_utility.set_message_token( 'PARAMETER', p_parameter.parameter_name );
1355: hr_utility.raise_error;
1356: end if;
1357:
1358: p_function.ret_type := l_datatype( l_seqno );

Line 1355: hr_utility.raise_error;

1351: hr_utility.set_message( 800, 'HR_50317_DP_BAD_FUNCTION_RET' );
1352: hr_utility.set_message_token
1353: ( 'FUNCTION', c_get_function_package || '.' || p_function.function_name );
1354: hr_utility.set_message_token( 'PARAMETER', p_parameter.parameter_name );
1355: hr_utility.raise_error;
1356: end if;
1357:
1358: p_function.ret_type := l_datatype( l_seqno );
1359:

Line 1380: hr_utility.set_message( 800, 'HR_50319_DP_FUN_BAD_ARG_TYPE' );

1376: l_datatype(l_seqno) <> c_dtype_boolean and
1377: l_datatype(l_seqno) <> c_dtype_long and
1378: l_datatype(l_seqno) <> c_dtype_clob -- added for bug 13362792
1379: then
1380: hr_utility.set_message( 800, 'HR_50319_DP_FUN_BAD_ARG_TYPE' );
1381: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1382: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1383: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
1384: hr_utility.raise_error;

Line 1381: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );

1377: l_datatype(l_seqno) <> c_dtype_long and
1378: l_datatype(l_seqno) <> c_dtype_clob -- added for bug 13362792
1379: then
1380: hr_utility.set_message( 800, 'HR_50319_DP_FUN_BAD_ARG_TYPE' );
1381: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1382: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1383: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
1384: hr_utility.raise_error;
1385: end if;

Line 1382: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );

1378: l_datatype(l_seqno) <> c_dtype_clob -- added for bug 13362792
1379: then
1380: hr_utility.set_message( 800, 'HR_50319_DP_FUN_BAD_ARG_TYPE' );
1381: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1382: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1383: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
1384: hr_utility.raise_error;
1385: end if;
1386:

Line 1383: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );

1379: then
1380: hr_utility.set_message( 800, 'HR_50319_DP_FUN_BAD_ARG_TYPE' );
1381: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1382: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1383: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
1384: hr_utility.raise_error;
1385: end if;
1386:
1387: p_function_call_tbl(l_currpos).parameter_name :=

Line 1384: hr_utility.raise_error;

1380: hr_utility.set_message( 800, 'HR_50319_DP_FUN_BAD_ARG_TYPE' );
1381: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1382: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1383: hr_utility.set_message_token( 'TYPE', l_datatype(l_seqno) );
1384: hr_utility.raise_error;
1385: end if;
1386:
1387: p_function_call_tbl(l_currpos).parameter_name :=
1388: upper(l_argument_name(l_seqno));

Line 1407: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );

1403: --
1404: -- Got a match. Check that parameter usage types are compatible.
1405: --
1406: if p_distinct_parameter_tbl(i).datatype <> l_datatype(l_seqno) then
1407: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
1408: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1409: hr_utility.raise_error;
1410: end if;
1411: --

Line 1408: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );

1404: -- Got a match. Check that parameter usage types are compatible.
1405: --
1406: if p_distinct_parameter_tbl(i).datatype <> l_datatype(l_seqno) then
1407: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
1408: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1409: hr_utility.raise_error;
1410: end if;
1411: --
1412: -- If p_parameter is not defaultable then all parameters for its

Line 1409: hr_utility.raise_error;

1405: --
1406: if p_distinct_parameter_tbl(i).datatype <> l_datatype(l_seqno) then
1407: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
1408: hr_utility.set_message_token( 'ARGUMENT', l_argument_name(l_seqno) );
1409: hr_utility.raise_error;
1410: end if;
1411: --
1412: -- If p_parameter is not defaultable then all parameters for its
1413: -- mapping function are not defaultable either. If this mapping

Line 1465: hr_utility.set_message( 800, 'HR_50316_DP_NOT_FUNCTION' );

1461: --
1462: -- Verify that this it was actually a function.
1463: --
1464: if not l_is_a_function then
1465: hr_utility.set_message( 800, 'HR_50316_DP_NOT_FUNCTION' );
1466: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1467: hr_utility.raise_error;
1468: end if;
1469:

Line 1466: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );

1462: -- Verify that this it was actually a function.
1463: --
1464: if not l_is_a_function then
1465: hr_utility.set_message( 800, 'HR_50316_DP_NOT_FUNCTION' );
1466: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1467: hr_utility.raise_error;
1468: end if;
1469:
1470: --

Line 1467: hr_utility.raise_error;

1463: --
1464: if not l_is_a_function then
1465: hr_utility.set_message( 800, 'HR_50316_DP_NOT_FUNCTION' );
1466: hr_utility.set_message_token( 'FUNCTION', p_function.function_name );
1467: hr_utility.raise_error;
1468: end if;
1469:
1470: --
1471: -- Update indexes in the function table, and the count of function call

Line 1628: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );

1624: --
1625: -- Check that parameter types match.
1626: --
1627: if l_api_parameter.datatype <> l_function_parameter.datatype then
1628: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
1629: hr_utility.set_message_token
1630: ( 'ARGUMENT', l_api_parameter.parameter_name );
1631: hr_utility.raise_error;
1632: end if;

Line 1629: hr_utility.set_message_token

1625: -- Check that parameter types match.
1626: --
1627: if l_api_parameter.datatype <> l_function_parameter.datatype then
1628: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
1629: hr_utility.set_message_token
1630: ( 'ARGUMENT', l_api_parameter.parameter_name );
1631: hr_utility.raise_error;
1632: end if;
1633: --

Line 1631: hr_utility.raise_error;

1627: if l_api_parameter.datatype <> l_function_parameter.datatype then
1628: hr_utility.set_message( 800, 'HR_50320_DP_FUN_ARG_USAGE' );
1629: hr_utility.set_message_token
1630: ( 'ARGUMENT', l_api_parameter.parameter_name );
1631: hr_utility.raise_error;
1632: end if;
1633: --
1634: -- Get the batch lines column from the parameter list.
1635: --

Line 1670: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );

1666: if l_function_parameter.datatype = c_dtype_long then
1667: p_parameter_counts.long_parameters :=
1668: p_parameter_counts.long_parameters + 1;
1669: if p_parameter_counts.long_parameters > 1 then
1670: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );
1671: hr_utility.set_message_token
1672: ( 'API', p_module_package || '.' || p_module_name );
1673: hr_utility.set_message_token
1674: ( 'ARGUMENT', l_function_parameter.parameter_name );

Line 1671: hr_utility.set_message_token

1667: p_parameter_counts.long_parameters :=
1668: p_parameter_counts.long_parameters + 1;
1669: if p_parameter_counts.long_parameters > 1 then
1670: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );
1671: hr_utility.set_message_token
1672: ( 'API', p_module_package || '.' || p_module_name );
1673: hr_utility.set_message_token
1674: ( 'ARGUMENT', l_function_parameter.parameter_name );
1675: hr_utility.set_message_token

Line 1673: hr_utility.set_message_token

1669: if p_parameter_counts.long_parameters > 1 then
1670: hr_utility.set_message( 800, 'HR_50016_DP_TOO_MANY_LONGS' );
1671: hr_utility.set_message_token
1672: ( 'API', p_module_package || '.' || p_module_name );
1673: hr_utility.set_message_token
1674: ( 'ARGUMENT', l_function_parameter.parameter_name );
1675: hr_utility.set_message_token
1676: ( 'FUNCTION', l_function_parameter.mapping_function );
1677: hr_utility.raise_error;

Line 1675: hr_utility.set_message_token

1671: hr_utility.set_message_token
1672: ( 'API', p_module_package || '.' || p_module_name );
1673: hr_utility.set_message_token
1674: ( 'ARGUMENT', l_function_parameter.parameter_name );
1675: hr_utility.set_message_token
1676: ( 'FUNCTION', l_function_parameter.mapping_function );
1677: hr_utility.raise_error;
1678: end if;
1679: end if;

Line 1677: hr_utility.raise_error;

1673: hr_utility.set_message_token
1674: ( 'ARGUMENT', l_function_parameter.parameter_name );
1675: hr_utility.set_message_token
1676: ( 'FUNCTION', l_function_parameter.mapping_function );
1677: hr_utility.raise_error;
1678: end if;
1679: end if;
1680:
1681: l_total_parameters := p_parameter_counts.total_parameters + 1;

Line 1903: hr_utility.set_message( 800, 'HR_50321_DP_TOO_MANY_ARGS' );

1899: end if;
1900: end loop;
1901:
1902: if p_parameter_counts.batch_lines_parameters > c_max_batch_lines_cols then
1903: hr_utility.set_message( 800, 'HR_50321_DP_TOO_MANY_ARGS' );
1904: hr_utility.set_message_token
1905: ( 'TOTAL', p_parameter_counts.batch_lines_parameters );
1906: hr_utility.set_message_token( 'MAXIMUM', c_max_batch_lines_cols );
1907: hr_utility.raise_error;

Line 1904: hr_utility.set_message_token

1900: end loop;
1901:
1902: if p_parameter_counts.batch_lines_parameters > c_max_batch_lines_cols then
1903: hr_utility.set_message( 800, 'HR_50321_DP_TOO_MANY_ARGS' );
1904: hr_utility.set_message_token
1905: ( 'TOTAL', p_parameter_counts.batch_lines_parameters );
1906: hr_utility.set_message_token( 'MAXIMUM', c_max_batch_lines_cols );
1907: hr_utility.raise_error;
1908: end if;

Line 1906: hr_utility.set_message_token( 'MAXIMUM', c_max_batch_lines_cols );

1902: if p_parameter_counts.batch_lines_parameters > c_max_batch_lines_cols then
1903: hr_utility.set_message( 800, 'HR_50321_DP_TOO_MANY_ARGS' );
1904: hr_utility.set_message_token
1905: ( 'TOTAL', p_parameter_counts.batch_lines_parameters );
1906: hr_utility.set_message_token( 'MAXIMUM', c_max_batch_lines_cols );
1907: hr_utility.raise_error;
1908: end if;
1909:
1910: exception

Line 1907: hr_utility.raise_error;

1903: hr_utility.set_message( 800, 'HR_50321_DP_TOO_MANY_ARGS' );
1904: hr_utility.set_message_token
1905: ( 'TOTAL', p_parameter_counts.batch_lines_parameters );
1906: hr_utility.set_message_token( 'MAXIMUM', c_max_batch_lines_cols );
1907: hr_utility.raise_error;
1908: end if;
1909:
1910: exception
1911: when others then

Line 2036: hr_utility.set_message( 800, 'HR_50322_DP_COMPILE_FAILED' );

2032: open csr_check_compile( p_object_name, p_object_type );
2033: fetch csr_check_compile into l_status;
2034: close csr_check_compile;
2035: if upper( l_status ) <> 'VALID' then
2036: hr_utility.set_message( 800, 'HR_50322_DP_COMPILE_FAILED' );
2037: hr_utility.set_message_token( 'OBJECT', p_object_name );
2038: hr_utility.raise_error;
2039: end if;
2040: end check_compile;

Line 2037: hr_utility.set_message_token( 'OBJECT', p_object_name );

2033: fetch csr_check_compile into l_status;
2034: close csr_check_compile;
2035: if upper( l_status ) <> 'VALID' then
2036: hr_utility.set_message( 800, 'HR_50322_DP_COMPILE_FAILED' );
2037: hr_utility.set_message_token( 'OBJECT', p_object_name );
2038: hr_utility.raise_error;
2039: end if;
2040: end check_compile;
2041:

Line 2038: hr_utility.raise_error;

2034: close csr_check_compile;
2035: if upper( l_status ) <> 'VALID' then
2036: hr_utility.set_message( 800, 'HR_50322_DP_COMPILE_FAILED' );
2037: hr_utility.set_message_token( 'OBJECT', p_object_name );
2038: hr_utility.raise_error;
2039: end if;
2040: end check_compile;
2041:
2042: -- ------------------------ create_view -----------------------------------

Line 2635: 'hr_utility.set_message(800,''HR_50327_DP_TYPE_ERR'');' || c_newline ||

2631: else
2632: p_precall := p_precall || 'else' || c_newline;
2633: end if;
2634: p_precall := p_precall ||
2635: 'hr_utility.set_message(800,''HR_50327_DP_TYPE_ERR'');' || c_newline ||
2636: 'hr_utility.set_message_token(''TYPE'',''BOOLEAN'');' || c_newline ||
2637: 'hr_utility.set_message_token(''PARAMETER'',''' ||
2638: p_parameter.parameter_name || ''');' || c_newline ||
2639: 'hr_utility.set_message_token(''VALUE'',' || l_cursor_field ||

Line 2636: 'hr_utility.set_message_token(''TYPE'',''BOOLEAN'');' || c_newline ||

2632: p_precall := p_precall || 'else' || c_newline;
2633: end if;
2634: p_precall := p_precall ||
2635: 'hr_utility.set_message(800,''HR_50327_DP_TYPE_ERR'');' || c_newline ||
2636: 'hr_utility.set_message_token(''TYPE'',''BOOLEAN'');' || c_newline ||
2637: 'hr_utility.set_message_token(''PARAMETER'',''' ||
2638: p_parameter.parameter_name || ''');' || c_newline ||
2639: 'hr_utility.set_message_token(''VALUE'',' || l_cursor_field ||
2640: ');' || c_newline ||

Line 2637: 'hr_utility.set_message_token(''PARAMETER'',''' ||

2633: end if;
2634: p_precall := p_precall ||
2635: 'hr_utility.set_message(800,''HR_50327_DP_TYPE_ERR'');' || c_newline ||
2636: 'hr_utility.set_message_token(''TYPE'',''BOOLEAN'');' || c_newline ||
2637: 'hr_utility.set_message_token(''PARAMETER'',''' ||
2638: p_parameter.parameter_name || ''');' || c_newline ||
2639: 'hr_utility.set_message_token(''VALUE'',' || l_cursor_field ||
2640: ');' || c_newline ||
2641: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||

Line 2639: 'hr_utility.set_message_token(''VALUE'',' || l_cursor_field ||

2635: 'hr_utility.set_message(800,''HR_50327_DP_TYPE_ERR'');' || c_newline ||
2636: 'hr_utility.set_message_token(''TYPE'',''BOOLEAN'');' || c_newline ||
2637: 'hr_utility.set_message_token(''PARAMETER'',''' ||
2638: p_parameter.parameter_name || ''');' || c_newline ||
2639: 'hr_utility.set_message_token(''VALUE'',' || l_cursor_field ||
2640: ');' || c_newline ||
2641: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||
2642: c_newline ||
2643: 'hr_utility.raise_error;' || c_newline ||

Line 2641: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||

2637: 'hr_utility.set_message_token(''PARAMETER'',''' ||
2638: p_parameter.parameter_name || ''');' || c_newline ||
2639: 'hr_utility.set_message_token(''VALUE'',' || l_cursor_field ||
2640: ');' || c_newline ||
2641: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||
2642: c_newline ||
2643: 'hr_utility.raise_error;' || c_newline ||
2644: 'end if;';
2645: return;

Line 2643: 'hr_utility.raise_error;' || c_newline ||

2639: 'hr_utility.set_message_token(''VALUE'',' || l_cursor_field ||
2640: ');' || c_newline ||
2641: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||
2642: c_newline ||
2643: 'hr_utility.raise_error;' || c_newline ||
2644: 'end if;';
2645: return;
2646: end if;
2647: end add_to_precall;

Line 3006: hr_utility.trace

3002: p_call :=
3003: p_call || p_parameter.mapping_definition || ' => ' || p_local_variable;
3004:
3005: if g_debug then
3006: hr_utility.trace
3007: (p_parameter.parameter_name || ':' ||
3008: p_parameter.mapping_definition || ':' || p_local_variable
3009: );
3010: end if;

Line 3466: 'hr_utility.set_message(800,''HR_50326_DP_NO_ROW'');' || c_newline ||

3462: 'hr_data_pump.entry(''call'');' || c_newline ||
3463: 'open cr;' || c_newline ||
3464: 'fetch cr into c;' || c_newline ||
3465: 'if cr%notfound then' || c_newline ||
3466: 'hr_utility.set_message(800,''HR_50326_DP_NO_ROW'');' || c_newline ||
3467: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||
3468: c_newline ||
3469: 'hr_utility.set_message_token(''COLUMN'',''P_BATCH_LINE_ID'');' ||
3470: c_newline ||

Line 3467: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||

3463: 'open cr;' || c_newline ||
3464: 'fetch cr into c;' || c_newline ||
3465: 'if cr%notfound then' || c_newline ||
3466: 'hr_utility.set_message(800,''HR_50326_DP_NO_ROW'');' || c_newline ||
3467: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||
3468: c_newline ||
3469: 'hr_utility.set_message_token(''COLUMN'',''P_BATCH_LINE_ID'');' ||
3470: c_newline ||
3471: 'hr_utility.set_message_token(''VALUE'',p_batch_line_id);' ||

Line 3469: 'hr_utility.set_message_token(''COLUMN'',''P_BATCH_LINE_ID'');' ||

3465: 'if cr%notfound then' || c_newline ||
3466: 'hr_utility.set_message(800,''HR_50326_DP_NO_ROW'');' || c_newline ||
3467: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||
3468: c_newline ||
3469: 'hr_utility.set_message_token(''COLUMN'',''P_BATCH_LINE_ID'');' ||
3470: c_newline ||
3471: 'hr_utility.set_message_token(''VALUE'',p_batch_line_id);' ||
3472: c_newline ||
3473: 'hr_utility.raise_error;' || c_newline ||

Line 3471: 'hr_utility.set_message_token(''VALUE'',p_batch_line_id);' ||

3467: 'hr_utility.set_message_token(''TABLE'',''HR_PUMP_BATCH_LINES'');' ||
3468: c_newline ||
3469: 'hr_utility.set_message_token(''COLUMN'',''P_BATCH_LINE_ID'');' ||
3470: c_newline ||
3471: 'hr_utility.set_message_token(''VALUE'',p_batch_line_id);' ||
3472: c_newline ||
3473: 'hr_utility.raise_error;' || c_newline ||
3474: 'end if;';
3475: --

Line 3473: 'hr_utility.raise_error;' || c_newline ||

3469: 'hr_utility.set_message_token(''COLUMN'',''P_BATCH_LINE_ID'');' ||
3470: c_newline ||
3471: 'hr_utility.set_message_token(''VALUE'',p_batch_line_id);' ||
3472: c_newline ||
3473: 'hr_utility.raise_error;' || c_newline ||
3474: 'end if;';
3475: --
3476: split_sql_text
3477: (p_last => false

Line 3640: hr_utility.set_message( 800, 'HR_50323_DP_CODE_TOO_BIG' );

3636: ,p_text_pieces => l_body_pieces
3637: );
3638: exception
3639: when plsql_value_error then
3640: hr_utility.set_message( 800, 'HR_50323_DP_CODE_TOO_BIG' );
3641: hr_utility.raise_error;
3642: end;
3643: --
3644: -- Compile the header and body.

Line 3641: hr_utility.raise_error;

3637: );
3638: exception
3639: when plsql_value_error then
3640: hr_utility.set_message( 800, 'HR_50323_DP_CODE_TOO_BIG' );
3641: hr_utility.raise_error;
3642: end;
3643: --
3644: -- Compile the header and body.
3645: --

Line 3691: g_debug := hr_utility.debug_enabled;

3687: where upper(module_name) = upper(p_module_name)
3688: and upper(module_package) = upper(p_module_package)
3689: and upper(api_module_type) in ('AI', 'BP', 'DM');
3690: begin
3691: g_debug := hr_utility.debug_enabled;
3692:
3693: if g_debug then
3694: hr_utility.trace
3695: ('----------- Generate API: ' || p_module_package || '.' ||

Line 3694: hr_utility.trace

3690: begin
3691: g_debug := hr_utility.debug_enabled;
3692:
3693: if g_debug then
3694: hr_utility.trace
3695: ('----------- Generate API: ' || p_module_package || '.' ||
3696: p_module_name || '----------');
3697: end if;
3698:

Line 3712: hr_utility.set_message(800, 'HR_33156_DP_NOT_IN_API_MODULES');

3708: open csr_api_module_id(p_module_package, p_module_name);
3709: fetch csr_api_module_id into l_api_module_id;
3710: if csr_api_module_id%notfound then
3711: close csr_api_module_id;
3712: hr_utility.set_message(800, 'HR_33156_DP_NOT_IN_API_MODULES');
3713: hr_utility.set_message_token
3714: ( 'API', p_module_package || '.' || p_module_name );
3715: hr_utility.raise_error;
3716: end if;

Line 3713: hr_utility.set_message_token

3709: fetch csr_api_module_id into l_api_module_id;
3710: if csr_api_module_id%notfound then
3711: close csr_api_module_id;
3712: hr_utility.set_message(800, 'HR_33156_DP_NOT_IN_API_MODULES');
3713: hr_utility.set_message_token
3714: ( 'API', p_module_package || '.' || p_module_name );
3715: hr_utility.raise_error;
3716: end if;
3717: close csr_api_module_id;

Line 3715: hr_utility.raise_error;

3711: close csr_api_module_id;
3712: hr_utility.set_message(800, 'HR_33156_DP_NOT_IN_API_MODULES');
3713: hr_utility.set_message_token
3714: ( 'API', p_module_package || '.' || p_module_name );
3715: hr_utility.raise_error;
3716: end if;
3717: close csr_api_module_id;
3718:
3719: purge( p_module_package, p_module_name );

Line 3725: hr_utility.trace('Package: ' || l_package_name);

3721: hr_pump_utils.name( p_module_package, p_module_name, l_package_name,
3722: l_view_name );
3723:
3724: if g_debug then
3725: hr_utility.trace('Package: ' || l_package_name);
3726: hr_utility.trace('View: ' || l_view_name);
3727: end if;
3728:
3729: create_view( l_view_name, l_parameter_tbl, l_parameter_counts,

Line 3726: hr_utility.trace('View: ' || l_view_name);

3722: l_view_name );
3723:
3724: if g_debug then
3725: hr_utility.trace('Package: ' || l_package_name);
3726: hr_utility.trace('View: ' || l_view_name);
3727: end if;
3728:
3729: create_view( l_view_name, l_parameter_tbl, l_parameter_counts,
3730: l_api_module_id );

Line 3939: hr_utility.set_message( 800, 'HR_50324_DP_GEN_PKG' );

3935:
3936: --
3937: -- Generate and output the messages saying what has been created.
3938: --
3939: hr_utility.set_message( 800, 'HR_50324_DP_GEN_PKG' );
3940: hr_utility.set_message_token( 'PACKAGE', l_package_name );
3941: l_message := hr_utility.get_message;
3942: output_text( l_message);
3943: --

Line 3940: hr_utility.set_message_token( 'PACKAGE', l_package_name );

3936: --
3937: -- Generate and output the messages saying what has been created.
3938: --
3939: hr_utility.set_message( 800, 'HR_50324_DP_GEN_PKG' );
3940: hr_utility.set_message_token( 'PACKAGE', l_package_name );
3941: l_message := hr_utility.get_message;
3942: output_text( l_message);
3943: --
3944: hr_utility.set_message( 800, 'HR_50325_DP_GEN_VIEW' );

Line 3941: l_message := hr_utility.get_message;

3937: -- Generate and output the messages saying what has been created.
3938: --
3939: hr_utility.set_message( 800, 'HR_50324_DP_GEN_PKG' );
3940: hr_utility.set_message_token( 'PACKAGE', l_package_name );
3941: l_message := hr_utility.get_message;
3942: output_text( l_message);
3943: --
3944: hr_utility.set_message( 800, 'HR_50325_DP_GEN_VIEW' );
3945: hr_utility.set_message_token( 'VIEW', l_view_name );

Line 3944: hr_utility.set_message( 800, 'HR_50325_DP_GEN_VIEW' );

3940: hr_utility.set_message_token( 'PACKAGE', l_package_name );
3941: l_message := hr_utility.get_message;
3942: output_text( l_message);
3943: --
3944: hr_utility.set_message( 800, 'HR_50325_DP_GEN_VIEW' );
3945: hr_utility.set_message_token( 'VIEW', l_view_name );
3946: l_message := hr_utility.get_message;
3947: output_text( l_message);
3948: --

Line 3945: hr_utility.set_message_token( 'VIEW', l_view_name );

3941: l_message := hr_utility.get_message;
3942: output_text( l_message);
3943: --
3944: hr_utility.set_message( 800, 'HR_50325_DP_GEN_VIEW' );
3945: hr_utility.set_message_token( 'VIEW', l_view_name );
3946: l_message := hr_utility.get_message;
3947: output_text( l_message);
3948: --
3949: -- Generate the header.

Line 3946: l_message := hr_utility.get_message;

3942: output_text( l_message);
3943: --
3944: hr_utility.set_message( 800, 'HR_50325_DP_GEN_VIEW' );
3945: hr_utility.set_message_token( 'VIEW', l_view_name );
3946: l_message := hr_utility.get_message;
3947: output_text( l_message);
3948: --
3949: -- Generate the header.
3950: --