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_ERRORS_GT

Line 78: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)

74: CURSOR successful_documents_csr(p_requisition_header_id IN NUMBER) IS
75: SELECT zxlgt.trx_line_id
76: FROM zx_transaction_lines_gt zxlgt
77: WHERE p_requisition_header_id=zxlgt.trx_id
78: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
79: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
80: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
81: AND zxlgt.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE;
82:

Line 483: FROM zx_errors_gt zxegt, po_headers_all ph

479: ,zxegt.event_class_code
480: ,zxegt.message_text
481: ,'CALCULATE_TAX'
482: ,ph.segment1
483: FROM zx_errors_gt zxegt, po_headers_all ph
484: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
485: AND zxegt.trx_id = ph.po_header_id;
486:
487: d_progress := 240;

Line 507: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr

503: ,zxegt.event_class_code
504: ,zxegt.message_text
505: ,'CALCULATE_TAX'
506: ,ph.segment1
507: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
508: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
509: AND zxegt.trx_id = pr.po_release_id
510: AND pr.po_header_id = ph.po_header_id;
511:

Line 513: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;

509: AND zxegt.trx_id = pr.po_release_id
510: AND pr.po_header_id = ph.po_header_id;
511:
512: BEGIN
513: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
514: EXCEPTION WHEN OTHERS THEN
515: IF PO_LOG.d_stmt THEN
516: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
517: END IF;

Line 516: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');

512: BEGIN
513: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
514: EXCEPTION WHEN OTHERS THEN
515: IF PO_LOG.d_stmt THEN
516: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
517: END IF;
518: l_count := 0;
519: END;
520:

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

518: l_count := 0;
519: END;
520:
521: IF PO_LOG.d_stmt THEN
522: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
523: END IF;
524:
525: END IF;
526:

Line 667: FROM zx_errors_gt zxegt, po_headers_all ph

663: ,zxegt.event_class_code
664: ,zxegt.message_text
665: ,'DETERMINE_RECOVERY'
666: ,ph.segment1
667: FROM zx_errors_gt zxegt, po_headers_all ph
668: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
669: AND zxegt.trx_id = ph.po_header_id;
670:
671: d_progress := 360;

Line 691: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr

687: ,zxegt.event_class_code
688: ,zxegt.message_text
689: ,'DETERMINE_RECOVERY'
690: ,ph.segment1
691: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
692: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
693: AND zxegt.trx_id = pr.po_release_id
694: AND pr.po_header_id = ph.po_header_id;
695:

Line 698: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;

694: AND pr.po_header_id = ph.po_header_id;
695:
696: d_progress := 370;
697: BEGIN
698: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
699: EXCEPTION WHEN OTHERS THEN
700: IF PO_LOG.d_stmt THEN
701: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
702: END IF;

Line 701: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');

697: BEGIN
698: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
699: EXCEPTION WHEN OTHERS THEN
700: IF PO_LOG.d_stmt THEN
701: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
702: END IF;
703: l_count := 0;
704: END;
705:

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

703: l_count := 0;
704: END;
705:
706: IF PO_LOG.d_stmt THEN
707: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
708: END IF;
709:
710: -- Bug 5169449. Removed deletions from headers and lines gt tables
711: -- because if the control has come till determine_recovery then the

Line 1338: -- Read validation errors from zx_errors_gt into the global

1334: -- and copy over errors into global tax errors record
1335: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1336: x_return_status := l_return_status;
1337: d_progress := 180;
1338: -- Read validation errors from zx_errors_gt into the global
1339: -- error record defined in the spec
1340: SELECT
1341: 'CALCULATE_TAX' --error_level,
1342: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

Line 1353: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

1349: ,null --distribution_id,
1350: ,null --distribution_num,
1351: ,zxegt.message_text --message_text
1352: BULK COLLECT INTO G_TAX_ERRORS_TBL
1353: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
1354: po_requisition_lines_all prl
1355: WHERE zxegt.trx_id = prh.requisition_header_id
1356: AND zxegt.trx_line_id = prl.requisition_line_id(+);
1357:

Line 1359: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;

1355: WHERE zxegt.trx_id = prh.requisition_header_id
1356: AND zxegt.trx_line_id = prl.requisition_line_id(+);
1357:
1358: BEGIN
1359: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
1360: EXCEPTION WHEN OTHERS THEN
1361: IF PO_LOG.d_stmt THEN
1362: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
1363: END IF;

Line 1362: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');

1358: BEGIN
1359: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
1360: EXCEPTION WHEN OTHERS THEN
1361: IF PO_LOG.d_stmt THEN
1362: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
1363: END IF;
1364: l_count := 0;
1365: END;
1366:

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

1364: l_count := 0;
1365: END;
1366:
1367: IF PO_LOG.d_stmt THEN
1368: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
1369: PO_LOG.stmt(d_module_base,d_progress,'Number of error records collected '||G_TAX_ERRORS_TBL.error_level.COUNT);
1370: END IF;
1371:
1372: d_progress := 190;

Line 1438: -- Read validation errors from zx_errors_gt into the global

1434: -- If there are any expected errors then set the return status accordingly
1435: -- and copy over errors into global tax errors record
1436: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1437: x_return_status := l_return_status;
1438: -- Read validation errors from zx_errors_gt into the global
1439: -- error record defined in the spec
1440: d_progress := 260;
1441: SELECT
1442: 'DETERMINE_RECOVERY' --error_level,

Line 1454: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

1450: ,zxegt.trx_line_dist_id --distribution_id,
1451: ,prd.distribution_id --distribution_num,
1452: ,zxegt.message_text --message_text
1453: BULK COLLECT INTO G_TAX_ERRORS_TBL
1454: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
1455: po_requisition_lines_all prl, po_req_distributions_all prd
1456: WHERE zxegt.trx_id = prh.requisition_header_id
1457: AND zxegt.trx_line_id = prl.requisition_line_id(+)
1458: AND zxegt.trx_line_dist_id = prd.distribution_id(+);

Line 1462: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;

1458: AND zxegt.trx_line_dist_id = prd.distribution_id(+);
1459:
1460: d_progress := 270;
1461: BEGIN
1462: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
1463: EXCEPTION WHEN OTHERS THEN
1464: IF PO_LOG.d_stmt THEN
1465: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
1466: END IF;

Line 1465: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');

1461: BEGIN
1462: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
1463: EXCEPTION WHEN OTHERS THEN
1464: IF PO_LOG.d_stmt THEN
1465: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
1466: END IF;
1467: l_count := 0;
1468: END;
1469:

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

1467: l_count := 0;
1468: END;
1469:
1470: IF PO_LOG.d_stmt THEN
1471: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
1472: PO_LOG.stmt(d_module_base,d_progress,'Number of error records collected '||G_TAX_ERRORS_TBL.error_level.COUNT);
1473: END IF;
1474:
1475: d_progress := 280;

Line 1759: -- Read validation errors from zx_errors_gt into the global

1755:
1756: -- If expected errors, store error details in po_session_gt temporarily
1757: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1758: x_return_status := l_return_status;
1759: -- Read validation errors from zx_errors_gt into the global
1760: -- error record defined in the spec
1761: SELECT
1762: 'DETERMINE_RECOVERY' --error_level,
1763: ,PO_CONSTANTS_SV.PO --document_type_code,

Line 1774: FROM zx_errors_gt zxegt, po_headers_all ph,

1770: ,zxegt.trx_line_dist_id --distribution_id,
1771: ,pd.distribution_num --distribution_num,
1772: ,zxegt.message_text --message_text
1773: BULK COLLECT INTO G_TAX_ERRORS_TBL
1774: FROM zx_errors_gt zxegt, po_headers_all ph,
1775: po_line_locations_all pll, po_distributions_all pd
1776: WHERE zxegt.trx_id = ph.po_header_id
1777: AND zxegt.trx_line_id = pll.line_location_id(+)
1778: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);

Line 1781: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;

1777: AND zxegt.trx_line_id = pll.line_location_id(+)
1778: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);
1779:
1780: BEGIN
1781: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
1782: EXCEPTION WHEN OTHERS THEN
1783: IF PO_LOG.d_stmt THEN
1784: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
1785: END IF;

Line 1784: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');

1780: BEGIN
1781: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
1782: EXCEPTION WHEN OTHERS THEN
1783: IF PO_LOG.d_stmt THEN
1784: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
1785: END IF;
1786: l_count := 0;
1787: END;
1788:

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

1786: l_count := 0;
1787: END;
1788:
1789: IF PO_LOG.d_stmt THEN
1790: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
1791: PO_LOG.stmt(d_module_base,d_progress,'Number of error records collected '||G_TAX_ERRORS_TBL.error_level.COUNT);
1792: END IF;
1793:
1794: RAISE FND_API.G_EXC_ERROR;

Line 1977: -- Read validation errors from zx_errors_gt into the global

1973:
1974: -- If expected errors, store error details in po_session_gt temporarily
1975: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1976: x_return_status := l_return_status;
1977: -- Read validation errors from zx_errors_gt into the global
1978: -- error record defined in the spec
1979: SELECT
1980: 'DETERMINE_RECOVERY' --error_level,
1981: ,PO_CONSTANTS_SV.PO --document_type_code,

Line 1992: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,

1988: ,zxegt.trx_line_dist_id --distribution_id,
1989: ,pd.distribution_num --distribution_num,
1990: ,zxegt.message_text --message_text
1991: BULK COLLECT INTO G_TAX_ERRORS_TBL
1992: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,
1993: po_line_locations_all pll, po_distributions_all pd
1994: WHERE zxegt.trx_id = pr.po_release_id
1995: AND pr.po_header_id = ph.po_header_id
1996: AND zxegt.trx_line_id = pll.line_location_id(+)

Line 2000: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;

1996: AND zxegt.trx_line_id = pll.line_location_id(+)
1997: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);
1998:
1999: BEGIN
2000: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
2001: EXCEPTION WHEN OTHERS THEN
2002: IF PO_LOG.d_stmt THEN
2003: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
2004: END IF;

Line 2003: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');

1999: BEGIN
2000: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
2001: EXCEPTION WHEN OTHERS THEN
2002: IF PO_LOG.d_stmt THEN
2003: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
2004: END IF;
2005: l_count := 0;
2006: END;
2007:

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

2005: l_count := 0;
2006: END;
2007:
2008: IF PO_LOG.d_stmt THEN
2009: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
2010: PO_LOG.stmt(d_module_base,d_progress,'Number of error records collected '||G_TAX_ERRORS_TBL.error_level.COUNT);
2011: END IF;
2012:
2013: RAISE FND_API.G_EXC_ERROR;

Line 2200: -- Read validation errors from zx_errors_gt into the global

2196: -- If there are any expected errors then set the return status accordingly
2197: -- and copy over errors into global tax errors record
2198: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2199: x_return_status := l_return_status;
2200: -- Read validation errors from zx_errors_gt into the global
2201: -- error record defined in the spec
2202: SELECT
2203: 'DETERMINE_RECOVERY' --error_level,
2204: ,PO_CONSTANTS_SV.REQUISITION --document_type_code,

Line 2215: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,

2211: ,zxegt.trx_line_dist_id --distribution_id,
2212: ,prd.distribution_num --distribution_num,
2213: ,zxegt.message_text --message_text
2214: BULK COLLECT INTO G_TAX_ERRORS_TBL
2215: FROM zx_errors_gt zxegt, po_requisition_headers_all prh,
2216: po_requisition_lines_all prl, po_req_distributions_all prd
2217: WHERE zxegt.trx_id = prh.requisition_header_id
2218: AND zxegt.trx_line_id = prl.requisition_line_id(+)
2219: AND zxegt.trx_line_dist_id = prd.distribution_id(+);

Line 2222: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;

2218: AND zxegt.trx_line_id = prl.requisition_line_id(+)
2219: AND zxegt.trx_line_dist_id = prd.distribution_id(+);
2220:
2221: BEGIN
2222: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
2223: EXCEPTION WHEN OTHERS THEN
2224: IF PO_LOG.d_stmt THEN
2225: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
2226: END IF;

Line 2225: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');

2221: BEGIN
2222: SELECT COUNT(1) INTO l_count FROM zx_errors_gt;
2223: EXCEPTION WHEN OTHERS THEN
2224: IF PO_LOG.d_stmt THEN
2225: PO_LOG.stmt(d_module_base,d_progress,'Exception while hitting zx_errors_gt');
2226: END IF;
2227: l_count := 0;
2228: END;
2229:

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

2227: l_count := 0;
2228: END;
2229:
2230: IF PO_LOG.d_stmt THEN
2231: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
2232: PO_LOG.stmt(d_module_base,d_progress,'Number of error records collected '||G_TAX_ERRORS_TBL.error_level.COUNT);
2233: END IF;
2234:
2235: RAISE FND_API.G_EXC_ERROR;

Line 4734: -- ZX_ERRORS_GT

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
4738: -- ZX_ITM_DISTRIBUTIONS_GT

Line 4740: -- ZX_ERRORS_GT

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
4744: -- exception is for HTML Orders case where deletions come pre-populated in

Line 4814: -- ZX_ERRORS_GT

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
4818: -- ZX_ITM_DISTRIBUTIONS_GT

Line 4820: -- ZX_ERRORS_GT

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:
4824: --IN:

Line 4851: DELETE ZX_ERRORS_GT;

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;
4854: IF (PO_LOG.d_proc) THEN
4855: PO_LOG.proc_end(d_module_base);