eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TEST_API dependencies on ZX_ERRORS_GT

Line 4533: l_zx_errors_gt VARCHAR2(4000);

4529: l_ending_row NUMBER;
4530: l_first BOOLEAN;
4531: l_sync_trx_rec zx_api_pub.sync_trx_rec_type;
4532: l_sync_trx_lines_tbl zx_api_pub.sync_trx_lines_tbl_type%type;
4533: l_zx_errors_gt VARCHAR2(4000);
4534:
4535:
4536: -------------------------------------
4537: --7 Standard Parameters for all APIs

Line 7779: -- If there are messages in ZX_ERRORS_GT extract them

7775: END LOOP;
7776: END IF;
7777:
7778: -----------------------------------------------------
7779: -- If there are messages in ZX_ERRORS_GT extract them
7780: -----------------------------------------------------
7781: get_zx_errors_gt(l_zx_errors_gt);
7782: IF ltrim(rtrim(l_zx_errors_gt)) IS NOT NULL THEN
7783: l_msg_data := l_msg_data ||' Errors from ZX_ERRORS_GT:'||l_zx_errors_gt;

Line 7781: get_zx_errors_gt(l_zx_errors_gt);

7777:
7778: -----------------------------------------------------
7779: -- If there are messages in ZX_ERRORS_GT extract them
7780: -----------------------------------------------------
7781: get_zx_errors_gt(l_zx_errors_gt);
7782: IF ltrim(rtrim(l_zx_errors_gt)) IS NOT NULL THEN
7783: l_msg_data := l_msg_data ||' Errors from ZX_ERRORS_GT:'||l_zx_errors_gt;
7784: write_message(l_msg_data);
7785: END IF;

Line 7782: IF ltrim(rtrim(l_zx_errors_gt)) IS NOT NULL THEN

7778: -----------------------------------------------------
7779: -- If there are messages in ZX_ERRORS_GT extract them
7780: -----------------------------------------------------
7781: get_zx_errors_gt(l_zx_errors_gt);
7782: IF ltrim(rtrim(l_zx_errors_gt)) IS NOT NULL THEN
7783: l_msg_data := l_msg_data ||' Errors from ZX_ERRORS_GT:'||l_zx_errors_gt;
7784: write_message(l_msg_data);
7785: END IF;
7786:

Line 7783: l_msg_data := l_msg_data ||' Errors from ZX_ERRORS_GT:'||l_zx_errors_gt;

7779: -- If there are messages in ZX_ERRORS_GT extract them
7780: -----------------------------------------------------
7781: get_zx_errors_gt(l_zx_errors_gt);
7782: IF ltrim(rtrim(l_zx_errors_gt)) IS NOT NULL THEN
7783: l_msg_data := l_msg_data ||' Errors from ZX_ERRORS_GT:'||l_zx_errors_gt;
7784: write_message(l_msg_data);
7785: END IF;
7786:
7787: ---------------------------------------------------------

Line 9659: | PROCEDURE get_zx_errors_gt: Retrieves the errors stored in ZX_ERRORS_GT |

9655: END get_start_end_rows_structure;
9656:
9657:
9658: /*============================================================================*
9659: | PROCEDURE get_zx_errors_gt: Retrieves the errors stored in ZX_ERRORS_GT |
9660: *============================================================================*/
9661: PROCEDURE get_zx_errors_gt
9662: (x_message OUT NOCOPY VARCHAR2)
9663: IS

Line 9661: PROCEDURE get_zx_errors_gt

9657:
9658: /*============================================================================*
9659: | PROCEDURE get_zx_errors_gt: Retrieves the errors stored in ZX_ERRORS_GT |
9660: *============================================================================*/
9661: PROCEDURE get_zx_errors_gt
9662: (x_message OUT NOCOPY VARCHAR2)
9663: IS
9664: l_zx_errors_gt_count NUMBER;
9665: l_message VARCHAR2(4000);

Line 9664: l_zx_errors_gt_count NUMBER;

9660: *============================================================================*/
9661: PROCEDURE get_zx_errors_gt
9662: (x_message OUT NOCOPY VARCHAR2)
9663: IS
9664: l_zx_errors_gt_count NUMBER;
9665: l_message VARCHAR2(4000);
9666:
9667: CURSOR c_errors IS
9668: SELECT message_text

Line 9669: FROM zx_errors_gt;

9665: l_message VARCHAR2(4000);
9666:
9667: CURSOR c_errors IS
9668: SELECT message_text
9669: FROM zx_errors_gt;
9670: BEGIN
9671:
9672: ----------------------------------------------------------------
9673: -- Detects if there are messages in the table ZX_ERRORS_GT

Line 9673: -- Detects if there are messages in the table ZX_ERRORS_GT

9669: FROM zx_errors_gt;
9670: BEGIN
9671:
9672: ----------------------------------------------------------------
9673: -- Detects if there are messages in the table ZX_ERRORS_GT
9674: -- if so, extract them and print them.
9675: ----------------------------------------------------------------
9676: BEGIN
9677: Select count(*) into l_zx_errors_gt_count from ZX_ERRORS_GT;

Line 9677: Select count(*) into l_zx_errors_gt_count from ZX_ERRORS_GT;

9673: -- Detects if there are messages in the table ZX_ERRORS_GT
9674: -- if so, extract them and print them.
9675: ----------------------------------------------------------------
9676: BEGIN
9677: Select count(*) into l_zx_errors_gt_count from ZX_ERRORS_GT;
9678: EXCEPTION
9679: WHEN OTHERS THEN NULL;
9680: END;
9681:

Line 9682: IF l_zx_errors_gt_count = 0 then

9678: EXCEPTION
9679: WHEN OTHERS THEN NULL;
9680: END;
9681:
9682: IF l_zx_errors_gt_count = 0 then
9683: l_message := NULL;
9684: ELSE
9685: FOR c in c_errors LOOP
9686: l_message := l_message || c.message_text ||' ';

Line 9691: END get_zx_errors_gt;

9687: END LOOP;
9688: END IF;
9689: x_message := l_message;
9690:
9691: END get_zx_errors_gt;
9692:
9693:
9694: /*============================================================================*
9695: | PROCEDURE TEST_API: This is the main procedure of Testing APIs |