APPS.HR_H2PI_ERROR dependencies on HR_H2PI_UPLOAD

Line 66: VALUES ( hr_h2pi_upload.g_to_business_group_id, hr_h2pi_upload.g_request_id,

62: --
63: INSERT INTO hr_h2pi_message_lines
64: ( to_business_group_id, request_id, from_id, table_name,
65: message_level, message_name_encoded, api_module_id)
66: VALUES ( hr_h2pi_upload.g_to_business_group_id, hr_h2pi_upload.g_request_id,
67: NVL(p_from_id, 0), p_table_name, UPPER(p_message_level),
68: nvl(l_message_name_encoded,p_message_text), p_api_module_id );
69: ELSE
70: l_mesg := 'Invalid Message Level ' || p_message_level;

Line 99: WHERE request_id = hr_h2pi_upload.g_request_id

95: BEGIN
96: SELECT count(*)
97: INTO l_count
98: FROM hr_h2pi_message_lines
99: WHERE request_id = hr_h2pi_upload.g_request_id
100: AND message_level = 'FATAL';
101:
102: IF l_count > 0 THEN
103: RETURN TRUE;

Line 142: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id

138: request_id,
139: from_id,
140: table_name
141: FROM hr_h2pi_message_lines
142: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
143: AND request_id = hr_h2pi_upload.g_request_id
144: GROUP BY to_business_group_id,
145: request_id,
146: table_name,

Line 143: AND request_id = hr_h2pi_upload.g_request_id

139: from_id,
140: table_name
141: FROM hr_h2pi_message_lines
142: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
143: AND request_id = hr_h2pi_upload.g_request_id
144: GROUP BY to_business_group_id,
145: request_id,
146: table_name,
147: message_level,

Line 164: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;

160: BEGIN
161: SELECT name
162: INTO l_to_business_group_name
163: FROM per_business_groups
164: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: fnd_file.put_line(FND_FILE.LOG,
168: 'FATAL - HR_H2PI_ERROR.GENERATE_ERROR_REPORT: ' ||

Line 176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);

172:
173: fnd_file.new_line(FND_FILE.LOG);
174: fnd_file.put_line(FND_FILE.LOG, 'Business Group: ' || l_to_business_group_name);
175: fnd_file.new_line(FND_FILE.LOG);
176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);
177: --
178: l_from_client_id := hr_h2pi_upload.get_from_client_id;
179: FOR csr_rec IN csr_err_mesg LOOP
180: IF csr_rec.table_name <> l_table_name then

Line 178: l_from_client_id := hr_h2pi_upload.get_from_client_id;

174: fnd_file.put_line(FND_FILE.LOG, 'Business Group: ' || l_to_business_group_name);
175: fnd_file.new_line(FND_FILE.LOG);
176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);
177: --
178: l_from_client_id := hr_h2pi_upload.get_from_client_id;
179: FOR csr_rec IN csr_err_mesg LOOP
180: IF csr_rec.table_name <> l_table_name then
181: l_table_name := csr_rec.table_name;
182: fnd_file.new_line(FND_FILE.LOG);