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.PO_TAX_INTERFACE_PVT dependencies on ZX_VALIDATION_ERRORS_GT

Line 330: FROM zx_validation_errors_gt zxvegt, po_headers_all ph

326: ,zxvegt.event_class_code
327: ,zxvegt.message_text
328: ,'VALIDATE'
329: ,ph.segment1
330: FROM zx_validation_errors_gt zxvegt, po_headers_all ph
331: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
332: AND zxvegt.trx_id = ph.po_header_id;
333:
334: d_progress := 150;

Line 354: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,

350: ,zxvegt.event_class_code
351: ,zxvegt.message_text
352: ,'VALIDATE'
353: ,ph.segment1
354: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,
355: po_releases_all pr
356: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
357: AND zxvegt.trx_id = pr.po_release_id
358: AND pr.po_header_id = ph.po_header_id;

Line 361: SELECT COUNT(1) INTO l_count FROM zx_validation_errors_gt;

357: AND zxvegt.trx_id = pr.po_release_id
358: AND pr.po_header_id = ph.po_header_id;
359:
360: BEGIN
361: SELECT COUNT(1) INTO l_count FROM zx_validation_errors_gt;
362: EXCEPTION WHEN OTHERS THEN
363: IF PO_LOG.d_stmt THEN
364: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_validation_errors_gt');
365: END IF;

Line 364: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_validation_errors_gt');

360: BEGIN
361: SELECT COUNT(1) INTO l_count FROM zx_validation_errors_gt;
362: EXCEPTION WHEN OTHERS THEN
363: IF PO_LOG.d_stmt THEN
364: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_validation_errors_gt');
365: END IF;
366: l_count := 0;
367: END;
368:

Line 370: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_validation_errors_gt '||l_count);

366: l_count := 0;
367: END;
368:
369: IF PO_LOG.d_stmt THEN
370: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_validation_errors_gt '||l_count);
371: END IF;
372:
373: END IF;
374:

Line 1227: -- Read validation errors from zx_validation_errors_gt into the global

1223: -- If there are any expected errors then set the return status
1224: -- accordingly and copy over errors into global tax errors record
1225: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1226: d_progress := 100;
1227: -- Read validation errors from zx_validation_errors_gt into the global
1228: -- error record defined in the spec
1229: SELECT
1230: 'VALIDATE' --error_level,
1231: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

Line 1242: FROM zx_validation_errors_gt zxvegt, po_requisition_headers_all prh,

1238: ,null --distribution_id,
1239: ,null --distribution_num,
1240: ,zxvegt.message_text --message_text
1241: BULK COLLECT INTO G_TAX_ERRORS_TBL
1242: FROM zx_validation_errors_gt zxvegt, po_requisition_headers_all prh,
1243: po_requisition_lines_all prl
1244: WHERE zxvegt.trx_id = prh.requisition_header_id
1245: AND zxvegt.trx_line_id = prl.requisition_line_id(+);
1246:

Line 1249: SELECT COUNT(1) INTO l_count FROM zx_validation_errors_gt;

1245: AND zxvegt.trx_line_id = prl.requisition_line_id(+);
1246:
1247: d_progress := 110;
1248: BEGIN
1249: SELECT COUNT(1) INTO l_count FROM zx_validation_errors_gt;
1250: EXCEPTION WHEN OTHERS THEN
1251: IF PO_LOG.d_stmt THEN
1252: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_validation_errors_gt');
1253: END IF;

Line 1252: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_validation_errors_gt');

1248: BEGIN
1249: SELECT COUNT(1) INTO l_count FROM zx_validation_errors_gt;
1250: EXCEPTION WHEN OTHERS THEN
1251: IF PO_LOG.d_stmt THEN
1252: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_validation_errors_gt');
1253: END IF;
1254: l_count := 0;
1255: END;
1256:

Line 1258: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_validation_errors_gt '||l_count);

1254: l_count := 0;
1255: END;
1256:
1257: IF PO_LOG.d_stmt THEN
1258: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_validation_errors_gt '||l_count);
1259: PO_LOG.stmt(d_module_base,d_progress,'Number of error records collected '||G_TAX_ERRORS_TBL.error_level.COUNT);
1260: END IF;
1261:
1262: d_progress := 120;

Line 4733: -- ZX_VALIDATION_ERRORS_GT

4729: --Modifies:
4730: -- ZX_TRX_HEADERS_GT
4731: -- ZX_TRANSACTION_LINES_GT
4732: -- ZX_ITM_DISTRIBUTIONS_GT
4733: -- ZX_VALIDATION_ERRORS_GT
4734: -- ZX_ERRORS_GT
4735: --Locks:
4736: -- ZX_TRX_HEADERS_GT
4737: -- ZX_TRANSACTION_LINES_GT

Line 4739: -- ZX_VALIDATION_ERRORS_GT

4735: --Locks:
4736: -- ZX_TRX_HEADERS_GT
4737: -- ZX_TRANSACTION_LINES_GT
4738: -- ZX_ITM_DISTRIBUTIONS_GT
4739: -- ZX_VALIDATION_ERRORS_GT
4740: -- ZX_ERRORS_GT
4741: --Function:
4742: -- Wipe out all data from ZX Global Temporary tables used in PO transaction
4743: -- except if there are lines populated that have action='DELETE'. This

Line 4813: -- ZX_VALIDATION_ERRORS_GT

4809: --Modifies:
4810: -- ZX_TRX_HEADERS_GT
4811: -- ZX_TRANSACTION_LINES_GT
4812: -- ZX_ITM_DISTRIBUTIONS_GT
4813: -- ZX_VALIDATION_ERRORS_GT
4814: -- ZX_ERRORS_GT
4815: --Locks:
4816: -- ZX_TRX_HEADERS_GT
4817: -- ZX_TRANSACTION_LINES_GT

Line 4819: -- ZX_VALIDATION_ERRORS_GT

4815: --Locks:
4816: -- ZX_TRX_HEADERS_GT
4817: -- ZX_TRANSACTION_LINES_GT
4818: -- ZX_ITM_DISTRIBUTIONS_GT
4819: -- ZX_VALIDATION_ERRORS_GT
4820: -- ZX_ERRORS_GT
4821: --Function:
4822: -- Wipe out all data from ZX Global Temporary tables
4823: --Parameters:

Line 4849: DELETE ZX_VALIDATION_ERRORS_GT;

4845: DELETE ZX_TRANSACTION_LINES_GT;
4846: d_progress := 20;
4847: DELETE ZX_ITM_DISTRIBUTIONS_GT;
4848: d_progress := 30;
4849: DELETE ZX_VALIDATION_ERRORS_GT;
4850: d_progress := 40;
4851: DELETE ZX_ERRORS_GT;
4852:
4853: d_progress := 50;