DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on PSP_REPORT_ERRORS

Line 2570: INSERT INTO psp_report_errors

2566: p_information9 IN VARCHAR2 DEFAULT NULL,
2567: p_information10 IN VARCHAR2 DEFAULT NULL) IS
2568: PRAGMA AUTONOMOUS_TRANSACTION;
2569: BEGIN
2570: INSERT INTO psp_report_errors
2571: (error_sequence_id, request_id, message_level,
2572: source_id, error_message, payroll_action_id,
2573: source_name, parent_source_id, parent_source_name,
2574: value1, value2, value3, value4, value5,

Line 2579: (psp_report_errors_s.NEXTVAL, p_request_id, p_message_level,

2575: value6, value7, value8, value9, value10,
2576: information1, information2, information3, information4, information5,
2577: information6, information7, information8, information9, information10)
2578: VALUES
2579: (psp_report_errors_s.NEXTVAL, p_request_id, p_message_level,
2580: p_source_id, p_error_message, p_payroll_action_id,
2581: p_source_name, p_parent_source_id, p_parent_source_name,
2582: p_value1, p_value2, p_value3, p_value4, p_value5,
2583: p_value6, p_value7, p_value8, p_value9, p_value10,

Line 2604: INSERT INTO psp_report_errors

2600: p_error_message IN VARCHAR2,
2601: p_return_status OUT NOCOPY VARCHAR2) IS
2602: PRAGMA AUTONOMOUS_TRANSACTION;
2603: BEGIN
2604: INSERT INTO psp_report_errors
2605: (error_sequence_id, request_id, message_level, source_id,
2606: retry_request_id, pdf_request_id, error_message)
2607: VALUES
2608: (psp_report_errors_s.NEXTVAL, p_request_id, p_message_level, p_source_id,

Line 2608: (psp_report_errors_s.NEXTVAL, p_request_id, p_message_level, p_source_id,

2604: INSERT INTO psp_report_errors
2605: (error_sequence_id, request_id, message_level, source_id,
2606: retry_request_id, pdf_request_id, error_message)
2607: VALUES
2608: (psp_report_errors_s.NEXTVAL, p_request_id, p_message_level, p_source_id,
2609: p_retry_request_id, p_pdf_request_id, p_error_message);
2610:
2611: COMMIT;
2612: