DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on ZX_ERRORS_GT

Line 989: --Call API to dump into zx_errors_gt

985: EXCEPTION
986: WHEN FND_API.G_EXC_ERROR THEN
987: -- ROLLBACK TO Calculate_Tax_Doc_Norel_PVT;
988: x_return_status := FND_API.G_RET_STS_ERROR ;
989: --Call API to dump into zx_errors_gt
990: IF ( errors_tbl.application_id.LAST is NOT NULL) THEN
991: DUMP_MSG;
992: END IF;
993: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1350: -- call DUMP_MSG to insert them into ZX_ERRORS_GT

1346: END;
1347:
1348:
1349: -- If there exists error messages in Error Table
1350: -- call DUMP_MSG to insert them into ZX_ERRORS_GT
1351: IF ZX_API_PUB.errors_tbl.trx_id.COUNT > 0 THEN
1352: DUMP_MSG;
1353: END IF;
1354:

Line 2206: -- call DUMP_MSG to insert them into ZX_ERRORS_GT

2202: ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.GEOGRAPHY_ID.DELETE;
2203: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_HASH_TBL.DELETE;
2204:
2205: -- If there exists error messages in Error Table
2206: -- call DUMP_MSG to insert them into ZX_ERRORS_GT
2207: IF ZX_API_PUB.errors_tbl.trx_id.COUNT > 0 THEN
2208: DUMP_MSG;
2209: END IF;
2210:

Line 2614: --Call API to dump into zx_errors_gt

2610: EXCEPTION
2611: WHEN FND_API.G_EXC_ERROR THEN
2612: --ROLLBACK TO Import_Doc_Rel_PVT;
2613:
2614: --Call API to dump into zx_errors_gt
2615: IF ( errors_tbl.application_id.LAST is NOT NULL) THEN
2616: DUMP_MSG;
2617: END IF;
2618: BEGIN

Line 2619: SELECT 1 INTO l_dummy_number FROM ZX_ERRORS_GT WHERE ROWNUM = 1;

2615: IF ( errors_tbl.application_id.LAST is NOT NULL) THEN
2616: DUMP_MSG;
2617: END IF;
2618: BEGIN
2619: SELECT 1 INTO l_dummy_number FROM ZX_ERRORS_GT WHERE ROWNUM = 1;
2620: EXCEPTION WHEN OTHERS THEN
2621: l_dummy_number := null;
2622: END;
2623:

Line 2748: -- call DUMP_MSG to insert them into ZX_ERRORS_GT

2744: -- bug fix 5417887 end 17-Aug-2006
2745: END LOOP;--event_classes cursor
2746:
2747: -- If there exists error messages in Error Table
2748: -- call DUMP_MSG to insert them into ZX_ERRORS_GT
2749: IF ZX_API_PUB.errors_tbl.trx_id.COUNT > 0 THEN
2750: DUMP_MSG;
2751: END IF;
2752:

Line 4641: --Call API to dump into zx_errors_gt if not already inserted.

4637: EXCEPTION
4638: WHEN FND_API.G_EXC_ERROR THEN
4639: ROLLBACK TO reverse_document_PVT;
4640: x_return_status := FND_API.G_RET_STS_ERROR ;
4641: --Call API to dump into zx_errors_gt if not already inserted.
4642: DUMP_MSG;
4643: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
4644: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
4645: END IF;

Line 4800: --Call API to dump into zx_errors_gt

4796: EXCEPTION
4797: WHEN FND_API.G_EXC_ERROR THEN
4798: ROLLBACK TO reverse_distributions_PVT;
4799: x_return_status := FND_API.G_RET_STS_ERROR ;
4800: --Call API to dump into zx_errors_gt
4801: DUMP_MSG;
4802: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
4803: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
4804: END IF;

Line 4999: --Call API to dump into zx_errors_gt if not already inserted.

4995: EXCEPTION
4996: WHEN FND_API.G_EXC_ERROR THEN
4997: ROLLBACK TO reverse_doc_distribution_PVT;
4998: x_return_status := FND_API.G_RET_STS_ERROR ;
4999: --Call API to dump into zx_errors_gt if not already inserted.
5000: DUMP_MSG;
5001: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
5002: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
5003: END IF;

Line 9473: INSERT INTO ZX_ERRORS_GT (application_id,

9469: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
9470: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_API_PUB: '||l_api_name||'()+');
9471: END IF;
9472: FORALL i IN 1 .. nvl(errors_tbl.application_id.LAST,-99)
9473: INSERT INTO ZX_ERRORS_GT (application_id,
9474: entity_code,
9475: event_class_code,
9476: trx_id,
9477: trx_line_id,

Line 9496: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,SQL%ROWCOUNT||' Error Message(s) dumped into Zx_Errors_GT.');

9492: NVL(errors_tbl.message_text(i),'UNEXPECTED_ERROR_DUMP_MSG')
9493: );
9494:
9495: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
9496: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,SQL%ROWCOUNT||' Error Message(s) dumped into Zx_Errors_GT.');
9497: END IF;
9498:
9499: errors_tbl.application_id.delete;
9500: errors_tbl.entity_code.delete;

Line 13574: --Call API to dump into zx_errors_gt

13570: EXCEPTION
13571: WHEN FND_API.G_EXC_ERROR THEN
13572: ROLLBACK TO Get_Def_Tax_Det_Attrs_Doc_PVT;
13573: x_return_status := FND_API.G_RET_STS_ERROR ;
13574: --Call API to dump into zx_errors_gt
13575: DUMP_MSG;
13576: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
13577: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
13578: END IF;

Line 14722: --Call API to dump into zx_errors_gt

14718: EXCEPTION
14719: WHEN FND_API.G_EXC_ERROR THEN
14720: ROLLBACK TO Purge_Tax_Repository_PVT;
14721: x_return_status := FND_API.G_RET_STS_ERROR ;
14722: --Call API to dump into zx_errors_gt
14723: DUMP_MSG;
14724: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
14725: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
14726: END IF;