APPS.HR_H2PI_ERROR dependencies on HR_H2PI_MESSAGE_LINES

Line 8: -- Description: Enters the error details into HR_H2PI_MESSAGE_LINES

4: --
5: -- ----------------------------------------------------------------------------
6: -- |--< Date_Error >-----------------------------------------------------------|
7: -- ----------------------------------------------------------------------------
8: -- Description: Enters the error details into HR_H2PI_MESSAGE_LINES
9: -- ----------------------------------------------------------------------------
10: PROCEDURE data_error(p_from_id number,
11: p_table_name varchar2,
12: p_message_level varchar2,

Line 63: INSERT INTO hr_h2pi_message_lines

59: ELSIF p_message_text IS NOT NULL THEN
60: l_message_name_encoded := p_message_text;
61: END IF;
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),

Line 88: -- HR_H2PI_MESSAGE_LINES for the passed parameter

84: -- ----------------------------------------------------------------------------
85: -- |--< Check_for_Errors >-----------------------------------------------------|
86: -- ----------------------------------------------------------------------------
87: -- Description: This function checks for any errors written in the table
88: -- HR_H2PI_MESSAGE_LINES for the passed parameter
89: -- P_REQUEST_ID (Concurrent Request Id) and error type Fatal
90: -- ----------------------------------------------------------------------------
91: FUNCTION check_for_errors RETURN BOOLEAN IS
92:

Line 98: FROM hr_h2pi_message_lines

94:
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

Line 129: TYPE ErrorRecTable is TABLE of hr_h2pi_message_lines%ROWTYPE

125: l_org_name hr_all_organization_units.name%type;
126: l_context hr_organization_information.org_information_context%type;
127: l_org_classification hr_organization_information.org_information1%type;
128: l_element_name pay_element_types_f.element_name%type;
129: TYPE ErrorRecTable is TABLE of hr_h2pi_message_lines%ROWTYPE
130: INDEX BY binary_integer;
131: ErrorRec ErrorRecTable;
132:
133: CURSOR csr_err_mesg IS

Line 141: FROM hr_h2pi_message_lines

137: 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,

Line 155: l_table_name hr_h2pi_message_lines.table_name%type := ' ';

151:
152: l_row_count NUMBER(15) := 0;
153: l_to_business_group_name per_business_groups.name%type;
154: l_text VARCHAR2(2000);
155: l_table_name hr_h2pi_message_lines.table_name%type := ' ';
156: --l_from_business_group_id hr_h2pi_message_lines.to_business_group_id%type;
157: l_from_client_id hr_h2pi_message_lines.to_business_group_id%type;
158:
159: BEGIN

Line 156: --l_from_business_group_id hr_h2pi_message_lines.to_business_group_id%type;

152: l_row_count NUMBER(15) := 0;
153: l_to_business_group_name per_business_groups.name%type;
154: l_text VARCHAR2(2000);
155: l_table_name hr_h2pi_message_lines.table_name%type := ' ';
156: --l_from_business_group_id hr_h2pi_message_lines.to_business_group_id%type;
157: l_from_client_id hr_h2pi_message_lines.to_business_group_id%type;
158:
159: BEGIN
160: BEGIN

Line 157: l_from_client_id hr_h2pi_message_lines.to_business_group_id%type;

153: l_to_business_group_name per_business_groups.name%type;
154: l_text VARCHAR2(2000);
155: l_table_name hr_h2pi_message_lines.table_name%type := ' ';
156: --l_from_business_group_id hr_h2pi_message_lines.to_business_group_id%type;
157: l_from_client_id hr_h2pi_message_lines.to_business_group_id%type;
158:
159: BEGIN
160: BEGIN
161: SELECT name