APPS.PSP_TEMPLATE_SELECTION dependencies on PSP_REPORT_ERRORS

Line 204: INSERT INTO psp_report_errors

200: fnd_message.set_name('PSP', 'PSP_EFF_NO_EMP_FOUND');
201: l_msg_str:= substr(fnd_message.get ,1,240);
202:
203: /* Removed payroll_action_id to make it independent of payroll_action_id */
204: INSERT INTO psp_report_errors
205: (error_sequence_id, request_id, message_level,
206: source_id, error_message, retry_request_id,
207: pdf_request_id, source_name, parent_source_id,
208: parent_source_name)

Line 209: VALUES (psp_report_errors_s.NEXTVAL, l_request_id, 'W',

205: (error_sequence_id, request_id, message_level,
206: source_id, error_message, retry_request_id,
207: pdf_request_id, source_name, parent_source_id,
208: parent_source_name)
209: VALUES (psp_report_errors_s.NEXTVAL, l_request_id, 'W',
210: NULL, l_msg_str, NULL,
211: NULL, NULL, NULL,
212: NULL);
213:

Line 239: INSERT INTO psp_report_errors

235: fnd_message.set_name('PSP', 'PSP_COMP_EFF_MIG');
236:
237: l_msg_str:=substr(fnd_message.get, 1,240);
238: /* Removed payroll_action_id to make it independent of payroll_action_id */
239: INSERT INTO psp_report_errors
240: (error_sequence_id, request_id, message_level,
241: source_id, error_message, retry_request_id,
242: pdf_request_id, source_name, parent_source_id,
243: parent_source_name)

Line 244: VALUES (psp_report_errors_s.NEXTVAL, l_request_id, 'E',

240: (error_sequence_id, request_id, message_level,
241: source_id, error_message, retry_request_id,
242: pdf_request_id, source_name, parent_source_id,
243: parent_source_name)
244: VALUES (psp_report_errors_s.NEXTVAL, l_request_id, 'E',
245: NULL, l_msg_str, NULL,
246: NULL, NULL, NULL,
247: NULL);
248: