DBA Data[Home] [Help]

APPS.QP_COPY_DEBUG_PVT dependencies on QP_DEBUG_TEXT

Line 670: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'This line cannot be written into QP_DEBUG_TEXT');

666:
667: BEGIN
668: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
669: IF (G_DEBUG_TEXT_LINE_NO is null) or (G_DEBUG_REQUEST_ID is null) then
670: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'This line cannot be written into QP_DEBUG_TEXT');
671: return;
672: else
673: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'Written one line into QP_DEBUG_TEXT');
674: G_DEBUG_TEXT_LINE_NO := G_DEBUG_TEXT_LINE_NO + 1;

Line 673: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'Written one line into QP_DEBUG_TEXT');

669: IF (G_DEBUG_TEXT_LINE_NO is null) or (G_DEBUG_REQUEST_ID is null) then
670: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'This line cannot be written into QP_DEBUG_TEXT');
671: return;
672: else
673: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'Written one line into QP_DEBUG_TEXT');
674: G_DEBUG_TEXT_LINE_NO := G_DEBUG_TEXT_LINE_NO + 1;
675:
676: INSERT INTO qp_debug_text(REQUEST_ID,MESSAGE_LINE_NO,MESSAGE_TEXT)
677: VALUES (G_DEBUG_REQUEST_ID, G_DEBUG_TEXT_LINE_NO, p_text);

Line 676: INSERT INTO qp_debug_text(REQUEST_ID,MESSAGE_LINE_NO,MESSAGE_TEXT)

672: else
673: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'Written one line into QP_DEBUG_TEXT');
674: G_DEBUG_TEXT_LINE_NO := G_DEBUG_TEXT_LINE_NO + 1;
675:
676: INSERT INTO qp_debug_text(REQUEST_ID,MESSAGE_LINE_NO,MESSAGE_TEXT)
677: VALUES (G_DEBUG_REQUEST_ID, G_DEBUG_TEXT_LINE_NO, p_text);
678: COMMIT;
679: end if;
680: EXCEPTION