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_TRL_MANAGE_TAX_PKG dependencies on ZX_API_PUB

Line 135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

131: | PROCEDURE Create_Detail_Lines : Insert tax lines into ZX_LINES table. |
132: * ===========================================================================*/
133:
134: PROCEDURE Create_Detail_Lines (
135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
136: x_return_status OUT NOCOPY VARCHAR2
137: ) IS
138:
139: l_row_count NUMBER;

Line 141: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE;

137: ) IS
138:
139: l_row_count NUMBER;
140: l_error_buffer VARCHAR2(100);
141: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE;
142:
143: -- Variables added for Preventive checks --
144: l_trx_id NUMBER;
145: l_trx_line_exist VARCHAR2(1);

Line 230: ZX_API_PUB.Add_Msg(l_msg_context_info_rec);

226: 'Cannot create tax line without transaction line');
227: END IF;
228: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
229: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Cannot create tax line without transaction line');
230: ZX_API_PUB.Add_Msg(l_msg_context_info_rec);
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: ELSE
233: IF (g_level_statement >= g_current_runtime_level ) THEN
234: FND_LOG.STRING(g_level_statement,

Line 892: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);

888: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines',
889: 'Return Status = '||x_return_status);
890: END IF;
891: -- FND_MESSAGE.SET_NAME('ZX','ZX_TRL_RECORD_ALREADY_EXISTS');
892: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);
893:
894: WHEN OTHERS THEN
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
896: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 913: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

909: | Update_Freeze_Flag event |
910: * ===========================================================================*/
911:
912: PROCEDURE Summarization_For_Freeze_Event
913: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
914: x_return_status OUT NOCOPY VARCHAR2) IS
915:
916: l_error_buffer VARCHAR2(100);
917: l_use_null_summary_id_flag VARCHAR2(1);

Line 1027: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1023: *============================================================================*/
1024:
1025: PROCEDURE Delete_Detail_Lines
1026: (x_return_status OUT NOCOPY VARCHAR2,
1027: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1028:
1029: l_row_count NUMBER;
1030: l_error_buffer VARCHAR2(100);
1031:

Line 1197: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1193: | ZX_LINES_SUMMARY for a given transaction details |
1194: * ===========================================================================*/
1195: PROCEDURE Delete_Summary_Lines
1196: (x_return_status OUT NOCOPY VARCHAR2,
1197: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1198:
1199: l_row_count NUMBER;
1200: l_error_buffer VARCHAR2(100);
1201: l_trx_id NUMBER;

Line 1281: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1277: * ===========================================================================*/
1278:
1279: PROCEDURE Delete_Loose_Tax_Distributions
1280: (x_return_status OUT NOCOPY VARCHAR2,
1281: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1282:
1283: l_row_count NUMBER;
1284: l_error_buffer VARCHAR2(200);
1285: l_prev_trx_id NUMBER;

Line 1286: l_context_info_rec ZX_API_PUB.context_info_rec_type;

1282:
1283: l_row_count NUMBER;
1284: l_error_buffer VARCHAR2(200);
1285: l_prev_trx_id NUMBER;
1286: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1287:
1288: -- Cursors added for Frozen Tax Deleted Check --
1289: -- bug 14198788 driving queries from zx_trx_headers_gt
1290: CURSOR get_deleted_frzn_dist IS

Line 1460: ZX_API_PUB.Add_Msg(l_context_info_rec);

1456: l_context_info_rec.trx_id := l_trx_id_tbl(i);
1457:
1458: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
1459: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_error_buffer);
1460: ZX_API_PUB.Add_Msg(l_context_info_rec);
1461: END IF;
1462: l_prev_trx_id := l_trx_id_tbl(i);
1463:
1464: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1508: ZX_API_PUB.Add_Msg(l_context_info_rec);

1504: l_context_info_rec.trx_id := l_trx_id_tbl(i);
1505:
1506: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
1507: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_error_buffer);
1508: ZX_API_PUB.Add_Msg(l_context_info_rec);
1509: END IF;
1510: l_prev_trx_id := l_trx_id_tbl(i);
1511:
1512: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1575: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1571: * ===========================================================================*/
1572:
1573: PROCEDURE Delete_Tax_Distributions(
1574: x_return_status OUT NOCOPY VARCHAR2,
1575: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1576:
1577: l_row_count NUMBER;
1578: l_error_buffer VARCHAR2(100);
1579:

Line 1655: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1651: | PROCEDURE Delete_Transaction: Deletes the tax lines in the repository |
1652: * ===========================================================================*/
1653: PROCEDURE Delete_Transaction
1654: (x_return_status OUT NOCOPY VARCHAR2,
1655: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1656:
1657: l_api_version CONSTANT NUMBER := 1.0;
1658: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction';
1659: l_row_count NUMBER;

Line 1662: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE;

1658: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction';
1659: l_row_count NUMBER;
1660: l_error_buffer VARCHAR2(100);
1661:
1662: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE;
1663:
1664: -- This cursor will check if any tax lines has frozen distributions
1665: CURSOR check_frozen_child IS
1666: SELECT TAX_LINE_ID

Line 1726: ZX_API_PUB.add_msg(l_msg_context_info_rec);

1722: x_return_status := FND_API.G_RET_STS_ERROR;
1723:
1724:
1725: FND_MESSAGE.SET_NAME('ZX','ZX_CHILD_FROZEN');
1726: ZX_API_PUB.add_msg(l_msg_context_info_rec);
1727: RETURN;
1728: END IF;
1729: CLOSE check_frozen_child;
1730: END IF;

Line 1832: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1828: * ===========================================================================*/
1829:
1830: PROCEDURE Cancel_Transaction
1831: (x_return_status OUT NOCOPY VARCHAR2,
1832: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1833:
1834: l_row_count NUMBER;
1835: l_error_buffer VARCHAR2(100);
1836:

Line 2375: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

2371: * ===============================================================================*/
2372:
2373: PROCEDURE Purge_Transaction
2374: (x_return_status OUT NOCOPY VARCHAR2,
2375: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
2376:
2377: l_return_status VARCHAR2(1);
2378: l_error_buffer VARCHAR2(100);
2379:

Line 2458: p_transaction_line_rec IN ZX_API_PUB.TRANSACTION_LINE_REC_TYPE) IS

2454: * ===========================================================================*/
2455:
2456: PROCEDURE Mark_Detail_Tax_Lines_Delete
2457: (x_return_status OUT NOCOPY VARCHAR2,
2458: p_transaction_line_rec IN ZX_API_PUB.TRANSACTION_LINE_REC_TYPE) IS
2459:
2460: l_row_count NUMBER;
2461: l_freeze_dists_num NUMBER;
2462: l_error_buffer VARCHAR2(100);

Line 2994: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);

2990: -- bug#4893261- move to wrapper since do not
2991: -- have event_class_rec here to set message index
2992: --
2993: -- FND_MESSAGE.SET_NAME('ZX','ZX_TRL_RECORD_ALREADY_EXISTS');
2994: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);
2995:
2996:
2997: WHEN OTHERS THEN
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3019: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3015: *============================================================================*/
3016:
3017: PROCEDURE Delete_Dist_Marked_For_Delete
3018: (x_return_status OUT NOCOPY VARCHAR2,
3019: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3020:
3021: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dist_Marked_For_Delete';
3022: l_error_buffer VARCHAR2(200);
3023: l_row_count NUMBER;

Line 3024: l_msg_context_info_rec ZX_API_PUB.context_info_rec_type;

3020:
3021: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dist_Marked_For_Delete';
3022: l_error_buffer VARCHAR2(200);
3023: l_row_count NUMBER;
3024: l_msg_context_info_rec ZX_API_PUB.context_info_rec_type;
3025:
3026: BEGIN
3027:
3028: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3069: --ZX_API_PUB.add_msg(l_msg_context_info_rec);

3065: 'Return Status = '||x_return_status);
3066: END IF;
3067:
3068: --FND_MESSAGE.SET_NAME('ZX','ZX_TRL_NULL_VALUES');
3069: --ZX_API_PUB.add_msg(l_msg_context_info_rec);
3070:
3071: ELSE
3072: IF (g_level_procedure >= g_current_runtime_level ) THEN
3073: FND_LOG.STRING(g_level_procedure,

Line 3269: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3265: *================================================================================*/
3266:
3267: PROCEDURE Update_TaxLine_Rec_Nrec_Amt
3268: (x_return_status OUT NOCOPY VARCHAR2,
3269: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3270:
3271: l_error_buffer VARCHAR2(100);
3272:
3273: BEGIN

Line 3407: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3403: *============================================================================*/
3404:
3405: PROCEDURE Update_Freeze_Flag
3406: (x_return_status OUT NOCOPY VARCHAR2,
3407: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3408:
3409: l_return_status VARCHAR2(1);
3410: l_error_buffer VARCHAR2(100);
3411: l_use_null_summary_id_flag VARCHAR2(1);

Line 3602: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3598: *============================================================================*/
3599:
3600: PROCEDURE Update_Item_Dist_Changed_Flag
3601: (x_return_status OUT NOCOPY VARCHAR2,
3602: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3603:
3604: l_error_buffer VARCHAR2(100);
3605:
3606: BEGIN

Line 3665: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3661: *============================================================================*/
3662:
3663: PROCEDURE discard_tax_only_lines
3664: (x_return_status OUT NOCOPY VARCHAR2,
3665: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3666:
3667: l_row_count NUMBER;
3668: l_error_buffer VARCHAR2(100);
3669:

Line 4306: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4302: | |
4303: *============================================================================*/
4304:
4305: PROCEDURE Update_Exchange_Rate
4306: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4307: x_return_status OUT NOCOPY VARCHAR2) IS
4308:
4309: l_error_buffer VARCHAR2(100);
4310:

Line 4406: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4402: | UPDATE case, if the same summarization criteria exists in |
4403: | zx_lines_summary |
4404: * ===========================================================================*/
4405: PROCEDURE update_exist_summary_line_id(
4406: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4407: x_return_status OUT NOCOPY VARCHAR2) IS
4408:
4409: l_row_count NUMBER;
4410: l_error_buffer VARCHAR2(100);

Line 4541: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4537: * ===========================================================================*/
4538:
4539: PROCEDURE release_document_tax_hold(
4540: x_return_status OUT NOCOPY VARCHAR2,
4541: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4542: p_tax_hold_released_code IN ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE
4543: ) IS
4544: l_error_buffer VARCHAR2(100);
4545:

Line 4542: p_tax_hold_released_code IN ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE

4538:
4539: PROCEDURE release_document_tax_hold(
4540: x_return_status OUT NOCOPY VARCHAR2,
4541: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4542: p_tax_hold_released_code IN ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE
4543: ) IS
4544: l_error_buffer VARCHAR2(100);
4545:
4546: l_tax_hold_release_value NUMBER;

Line 4664: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4660: ------------------------------------------------------------------------------
4661: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines
4662:
4663: PROCEDURE create_summary_lines_crt_evnt(
4664: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4665: x_return_status OUT NOCOPY VARCHAR2
4666: ) IS
4667:
4668: l_error_buffer VARCHAR2(100);

Line 5434: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

5430: -- retain_summ_tax_line_id_flag on event_class_rec of 'Y'
5431: ------------------------------------------------------------------------------
5432: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines
5433: PROCEDURE create_summary_lines_upd_evnt(
5434: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5435: x_return_status OUT NOCOPY VARCHAR2
5436: ) IS
5437:
5438: l_error_buffer VARCHAR2(100);

Line 5453: l_context_info_rec ZX_API_PUB.context_info_rec_type;

5449: l_err_count NUMBER;
5450: l_err_code NUMBER;
5451: l_ora_error VARCHAR2(10);
5452: l_err_trx_id NUMBER;
5453: l_context_info_rec ZX_API_PUB.context_info_rec_type;
5454:
5455: summary_error EXCEPTION;
5456: PRAGMA exception_init(summary_error, -24381);
5457:

Line 6684: ZX_API_PUB.Add_Msg(l_context_info_rec);

6680: l_ora_error := 'ORA-'||SUBSTR(LPAD(TO_CHAR(l_err_code),5,'0'),1,5);
6681:
6682: FND_MESSAGE.SET_NAME('ZX','ZX_SUMMARY_CONSTRAINT_VIOLATED');
6683: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_ora_error);
6684: ZX_API_PUB.Add_Msg(l_context_info_rec);
6685:
6686: l_err_trx_id := pg_trx_id_tbl(l_err_idx);
6687:
6688: print_summary_columns(p_application_id => pg_application_id_tbl(l_err_idx),