APPS.HR_DU_DI_INSERT dependencies on HR_DU_RULES

Line 46: l_file_name := hr_du_rules.RETURN_UPLOAD_HEADER_FILE(

42: --
43: OPEN csr_total_desc;
44: FETCH csr_total_desc INTO l_counter_1;
45: IF csr_total_desc%NOTFOUND THEN
46: l_file_name := hr_du_rules.RETURN_UPLOAD_HEADER_FILE(
47: p_upload_header_id);
48: l_fatal_error_message := 'Error occured trying to count all of the '
49: || 'descriptors in the file ' || l_file_name;
50: RAISE e_fatal_error;

Line 57: l_file_name := hr_du_rules.RETURN_UPLOAD_HEADER_FILE(

53:
54: OPEN csr_unique_desc;
55: FETCH csr_unique_desc INTO l_counter_2;
56: IF csr_unique_desc%NOTFOUND THEN
57: l_file_name := hr_du_rules.RETURN_UPLOAD_HEADER_FILE(
58: p_upload_header_id);
59: l_fatal_error_message := 'Error occured trying to count all of the '
60: || 'distinct descriptors in the file ' || l_file_name;
61: RAISE e_fatal_error;

Line 66: l_file_name := hr_du_rules.RETURN_UPLOAD_HEADER_FILE(p_upload_header_id);

62: END IF;
63: CLOSE csr_unique_desc;
64:
65: IF l_counter_1 <> l_counter_2 THEN
66: l_file_name := hr_du_rules.RETURN_UPLOAD_HEADER_FILE(p_upload_header_id);
67: l_fatal_error_message := 'Two descriptors with the same name in ' ||
68: 'the file ' || l_file_name;
69: RAISE e_fatal_error;
70: END IF;

Line 223: HR_DU_RULES.RETURN_UPLOAD_HEADER_FILE(p_upload_header_id);

219: --loops around to check for identical column names
220: FOR j IN 1..(i - 1) LOOP
221: IF g_line_table(j) = l_section THEN
222: l_file_name :=
223: HR_DU_RULES.RETURN_UPLOAD_HEADER_FILE(p_upload_header_id);
224: l_fatal_error_message := ' Two columns have the same name ' ||
225: l_section || ' in file ' ||
226: l_file_name;
227: RAISE e_fatal_error;

Line 248: l_file_name := HR_DU_RULES.RETURN_UPLOAD_HEADER_FILE

244: IF p_line_type = 'C' THEN
245: --loops around to check for identical column names
246: FOR j IN 1..(i - 1) LOOP
247: IF g_line_table(j) = l_section THEN
248: l_file_name := HR_DU_RULES.RETURN_UPLOAD_HEADER_FILE
249: (p_upload_header_id);
250: l_fatal_error_message := ' Two columns have the same name ' ||
251: l_section || ' in file ' ||
252: l_file_name;

Line 963: l_file_name := HR_DU_RULES.RETURN_UPLOAD_HEADER_FILE

959:
960: -- statement to catch for null values in the descriptors
961: IF l_Col_two IS NULL THEN
962: IF p_upload_header_id IS NOT NULL THEN
963: l_file_name := HR_DU_RULES.RETURN_UPLOAD_HEADER_FILE
964: (p_upload_header_id);
965: l_fatal_error_message := 'A value must be supplied for the ' ||
966: l_Col_one || ' in the file ' ||
967: l_file_name;

Line 1115: -- each API file. HR_DU_RULES is then called to validate the header's

1111:
1112: -- ------------------------- EXTRACT_DESCRIPTORS -------------------------
1113: -- Description: Calls General_extract with two extra variables to handle
1114: -- the descriptor part of the input file. These are found at the top of
1115: -- each API file. HR_DU_RULES is then called to validate the header's
1116: -- set up.
1117: --
1118: -- Input Parameters
1119: -- p_filehandle - the file to be worked on

Line 1143: HR_DU_RULES.VALIDATE_USER_KEY_SETUP

1139: GENERAL_Extract(p_filehandle, p_upload_id, p_upload_header_id,
1140: l_Column_one_header, l_file_descriptor);
1141: VALIDATE_SHEET_DESCRIPTORS
1142: (p_upload_id,p_upload_header_id);
1143: HR_DU_RULES.VALIDATE_USER_KEY_SETUP
1144: (p_upload_header_id, p_upload_id);
1145: l_reference_type := HR_DU_RULES.VALIDATE_REFERENCING
1146: (p_upload_header_id, p_upload_id);
1147: HR_DU_RULES.VALIDATE_STARTING_POINT

Line 1145: l_reference_type := HR_DU_RULES.VALIDATE_REFERENCING

1141: VALIDATE_SHEET_DESCRIPTORS
1142: (p_upload_id,p_upload_header_id);
1143: HR_DU_RULES.VALIDATE_USER_KEY_SETUP
1144: (p_upload_header_id, p_upload_id);
1145: l_reference_type := HR_DU_RULES.VALIDATE_REFERENCING
1146: (p_upload_header_id, p_upload_id);
1147: HR_DU_RULES.VALIDATE_STARTING_POINT
1148: (p_upload_header_id, p_upload_id);
1149: HR_DU_RULES.PROCESS_ORDER_PRESENT

Line 1147: HR_DU_RULES.VALIDATE_STARTING_POINT

1143: HR_DU_RULES.VALIDATE_USER_KEY_SETUP
1144: (p_upload_header_id, p_upload_id);
1145: l_reference_type := HR_DU_RULES.VALIDATE_REFERENCING
1146: (p_upload_header_id, p_upload_id);
1147: HR_DU_RULES.VALIDATE_STARTING_POINT
1148: (p_upload_header_id, p_upload_id);
1149: HR_DU_RULES.PROCESS_ORDER_PRESENT
1150: (p_upload_header_id);
1151: HR_DU_RULES.API_PRESENT_AND_CORRECT

Line 1149: HR_DU_RULES.PROCESS_ORDER_PRESENT

1145: l_reference_type := HR_DU_RULES.VALIDATE_REFERENCING
1146: (p_upload_header_id, p_upload_id);
1147: HR_DU_RULES.VALIDATE_STARTING_POINT
1148: (p_upload_header_id, p_upload_id);
1149: HR_DU_RULES.PROCESS_ORDER_PRESENT
1150: (p_upload_header_id);
1151: HR_DU_RULES.API_PRESENT_AND_CORRECT
1152: (p_upload_header_id, p_upload_id);
1153: --

Line 1151: HR_DU_RULES.API_PRESENT_AND_CORRECT

1147: HR_DU_RULES.VALIDATE_STARTING_POINT
1148: (p_upload_header_id, p_upload_id);
1149: HR_DU_RULES.PROCESS_ORDER_PRESENT
1150: (p_upload_header_id);
1151: HR_DU_RULES.API_PRESENT_AND_CORRECT
1152: (p_upload_header_id, p_upload_id);
1153: --
1154: hr_du_utility.message('ROUT','exit:hr_du_di_insert.extract_descriptors',
1155: 10);

Line 1431: hr_du_rules.validate_business_group(l_business_group_profile,

1427: hr_du_utility.message('INFO','l_business_group_profile - ' ||
1428: l_business_group_profile, 15);
1429: hr_du_utility.message('INFO','l_business_group_file - ' ||
1430: l_business_group_file, 15);
1431: hr_du_rules.validate_business_group(l_business_group_profile,
1432: l_business_group_file);
1433:
1434:
1435: -- see if we are uploading global data

Line 1784: l_header_file := hr_du_rules.RETURN_UPLOAD_HEADER_FILE

1780: BEGIN
1781: l_temp_number := to_number(g_line_table(1));
1782: EXCEPTION
1783: WHEN value_error THEN
1784: l_header_file := hr_du_rules.RETURN_UPLOAD_HEADER_FILE
1785: (p_original_upload_header_id);
1786: l_fatal_error_message := g_line_table(1) || ' is not a valid '
1787: || 'column id on line ' || g_counter
1788: || ' in the file ' || l_header_file ;