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_NEW_SERVICES_PKG dependencies on FND_LOG

Line 17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

13: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
14: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
15: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
16:
17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

14: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
15: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
16:
17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

15: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
16:
17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

16:
17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
24: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_NEW_APIS_PUB.';

Line 21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

17: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
24: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_NEW_APIS_PUB.';
25:

Line 22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

18: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
24: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_NEW_APIS_PUB.';
25:
26: TYPE VARCHAR2_tbl_type is TABLE OF VARCHAR2(1)

Line 23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

19: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
24: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_NEW_APIS_PUB.';
25:
26: TYPE VARCHAR2_tbl_type is TABLE OF VARCHAR2(1)
27: INDEX BY BINARY_INTEGER;

Line 453: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',

449: l_trx_level_type VARCHAR(30);
450:
451: BEGIN
452: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
453: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',
454: 'ZX_SRVC_TYP_PKG: Pop_Index_Attrbs_To_Null()+');
455: END IF;
456: -- Copy the key attributes in the local variables
457: l_application_id := ZX_Global_Structures_Pkg.trx_line_dist_tbl.Application_id(p_index);

Line 478: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',

474: ZX_Global_Structures_Pkg.trx_line_dist_tbl.Trx_line_Id(p_index) := l_trx_line_id;
475: ZX_Global_Structures_Pkg.trx_line_dist_tbl.Trx_level_type(p_index) := l_trx_level_type;
476:
477: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
478: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.END',
479: 'ZX_NEW_SERVICES_PKG: Pop_Index_Attrbs_To_Null()-');
480: END IF;
481:
482: EXCEPTION

Line 486: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,

482: EXCEPTION
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
487: 'Error occurred in ' || l_api_name || ' : ' ||SQLERRM);
488: END IF;
489:
490: END Pop_Index_Attrbs_To_Null;

Line 505: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||':'||l_api_name||'()+');

501: l_return_status VARCHAR2(1);
502:
503: BEGIN
504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||':'||l_api_name||'()+');
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: FORALL i IN NVL(p_trx_line_dist_tbl.application_id.FIRST,0) .. NVL(p_trx_line_dist_tbl.application_id.LAST,-99)

Line 803: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.END',

799: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
800: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i));
801:
802: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
803: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.END',
804: G_PKG_NAME ||':'||l_api_name||'(). Records Updated = ' || SQL%ROWCOUNT);
805: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.END',
806: G_PKG_NAME ||':'||l_api_name||'()-'||', RETURN_STATUS = ' || x_return_status);
807: END IF;

Line 805: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.END',

801:
802: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
803: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.END',
804: G_PKG_NAME ||':'||l_api_name||'(). Records Updated = ' || SQL%ROWCOUNT);
805: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.END',
806: G_PKG_NAME ||':'||l_api_name||'()-'||', RETURN_STATUS = ' || x_return_status);
807: END IF;
808:
809: EXCEPTION

Line 813: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

809: EXCEPTION
810: WHEN OTHERS THEN
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
812: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
813: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
814: END IF;
815: END db_update_line_det_factors;
816:
817: /* =======================================================================*

Line 863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||

859:
860: BEGIN
861:
862: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||
864: '.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
865: END IF;
866:
867: /*--------------------------------------------------+

Line 924: FND_LOG.STRING(G_LEVEL_STATEMENT,

920: l_event_class_rec.retain_summ_tax_line_id_flag;
921:
922: IF get_event_class_info%notfound THEN
923: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
924: FND_LOG.STRING(G_LEVEL_STATEMENT,
925: G_MODULE_NAME || l_api_name, G_PKG_NAME||':'||
926: l_api_name ||': Event Class Info not retreived');
927: END IF;
928: END IF;

Line 1035: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1031: AND tax_only_line_flag = 'Y'
1032: );
1033:
1034: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1035: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1036: G_MODULE_NAME||l_api_name||'.END',
1037: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
1038: END IF;
1039:

Line 1055: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

1051: p_data => x_msg_data
1052: );
1053:
1054: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1055: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1056: END IF;
1057:
1058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1059: ROLLBACK TO freeze_tax_dists_for_itms_PVT;

Line 1073: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

1069: p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );
1072: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1073: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1074: END IF;
1075:
1076: WHEN OTHERS THEN
1077: ROLLBACK TO freeze_tax_dists_for_itms_PVT;

Line 1091: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

1087: p_count => x_msg_count,
1088: p_data => x_msg_data
1089: );
1090: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1091: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1092: END IF;
1093: END freeze_tax_dists_for_items;
1094:
1095: PROCEDURE UPDATE_DET_FACTORS_FOR_CANCEL(

Line 1155: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

1151:
1152: BEGIN
1153:
1154: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1155: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
1156: END IF;
1157:
1158: SAVEPOINT update_det_factors_PVT;
1159: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1184: FND_LOG.STRING(g_level_unexpected,

1180:
1181: IF l_evnt_cls.internal_organization_id.COUNT > 1 THEN
1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1184: FND_LOG.STRING(g_level_unexpected,
1185: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1186: 'This API cannot handle Bulk calls');
1187: FND_LOG.STRING(g_level_unexpected,
1188: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

Line 1187: FND_LOG.STRING(g_level_unexpected,

1183: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1184: FND_LOG.STRING(g_level_unexpected,
1185: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1186: 'This API cannot handle Bulk calls');
1187: FND_LOG.STRING(g_level_unexpected,
1188: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1189: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1190: END IF;
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1192: END IF;
1193:
1194: IF l_evnt_cls.event_class_code.LAST is null THEN
1195: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1197: 'Event class information does not exist - indicates SALES_TRANSACTION_TAX_QUOTE/PURCHASE_TRANSACTION_TAX_QUOTE');
1198: END IF;
1199:
1200: select event_class_code,

Line 1245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1241:
1242: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1243: x_return_status := l_return_status ;
1244: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1246: G_PKG_NAME||': '||l_api_name||':ZX_VALID_INIT_PARAMS_PKG.calculate_tax returned errors');
1247: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1248: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1249: END IF;

Line 1247: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1243: x_return_status := l_return_status ;
1244: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1246: G_PKG_NAME||': '||l_api_name||':ZX_VALID_INIT_PARAMS_PKG.calculate_tax returned errors');
1247: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1248: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1249: END IF;
1250: RETURN;
1251: END IF;

Line 1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1263: l_context_info_rec.TRX_ID := l_event_class_rec.TRX_ID;
1264: ZX_API_PUB.add_msg(p_context_info_rec => l_context_info_rec);
1265: END IF;
1266: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1268: ' RETURN_STATUS = ' || x_return_status);
1269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1270: G_PKG_NAME||': '||l_api_name||':ZX_TCM_PTP_PKG.get_location_id returned errors');
1271: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

Line 1269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1265: END IF;
1266: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1268: ' RETURN_STATUS = ' || x_return_status);
1269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1270: G_PKG_NAME||': '||l_api_name||':ZX_TCM_PTP_PKG.get_location_id returned errors');
1271: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1272: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1273: END IF;

Line 1271: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1268: ' RETURN_STATUS = ' || x_return_status);
1269: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1270: G_PKG_NAME||': '||l_api_name||':ZX_TCM_PTP_PKG.get_location_id returned errors');
1271: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1272: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1273: END IF;
1274: RETURN;
1275: END IF;

Line 1278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1274: RETURN;
1275: END IF;
1276:
1277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1279: 'p_trx_line_id:' || p_trx_line_id);
1280: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1281: 'p_trx_level_type: ' || p_trx_level_type);
1282: END IF;

Line 1280: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',

1276:
1277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1279: 'p_trx_line_id:' || p_trx_line_id);
1280: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel',
1281: 'p_trx_level_type: ' || p_trx_level_type);
1282: END IF;
1283:
1284: OPEN c_lines(l_event_class_rec,

Line 1671: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1667:
1668: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1669: x_return_status := l_return_status;
1670: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1672: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1673: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1674: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1675: END IF;

Line 1673: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1669: x_return_status := l_return_status;
1670: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1672: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1673: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1674: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1675: END IF;
1676: IF c_lines%ISOPEN THEN
1677: CLOSE c_lines;

Line 1691: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1687:
1688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1689: x_return_status := l_return_status;
1690: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1692: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1693: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1694: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1695: END IF;

Line 1693: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1689: x_return_status := l_return_status;
1690: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1692: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.determine_effective_date returned errors');
1693: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1694: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1695: END IF;
1696: IF c_lines%ISOPEN THEN
1697: CLOSE c_lines;

Line 1720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1716:
1717: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1718: x_return_status := l_return_status;
1719: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1721: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.get_tax_event_type returned errors');
1722: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1723: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1724: END IF;

Line 1722: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1718: x_return_status := l_return_status;
1719: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1721: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.get_tax_event_type returned errors');
1722: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1723: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1724: END IF;
1725: IF c_lines%ISOPEN THEN
1726: CLOSE c_lines;

Line 1745: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1741:
1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743: x_return_status := l_return_status;
1744: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1745: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1746: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.populate_event_class_options returned errors');
1747: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1748: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1749: END IF;

Line 1747: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1743: x_return_status := l_return_status;
1744: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1745: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1746: G_PKG_NAME||': '||l_api_name||':zx_valid_init_params_pkg.populate_event_class_options returned errors');
1747: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1748: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1749: END IF;
1750: IF c_lines%ISOPEN THEN
1751: CLOSE c_lines;

Line 1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1763:
1764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1765: x_return_status := l_return_status;
1766: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1768: G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
1769: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1770: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1771: END IF;

Line 1769: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1765: x_return_status := l_return_status;
1766: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1768: G_PKG_NAME||': '||l_api_name||':ZX_TDS_CALC_SERVICES_PUB_PKG.initialize returned errors');
1769: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1770: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1771: END IF;
1772: IF c_lines%ISOPEN THEN
1773: CLOSE c_lines;

Line 1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1785: x_return_status => l_return_status);
1786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: x_return_status := l_return_status;
1788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1790: ' RETURN_STATUS = ' || x_return_status);
1791: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1792: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.Pop_Index_Attrbs_To_Null returned errors');
1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

Line 1791: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1787: x_return_status := l_return_status;
1788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1790: ' RETURN_STATUS = ' || x_return_status);
1791: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1792: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.Pop_Index_Attrbs_To_Null returned errors');
1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1794: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1795: END IF;

Line 1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1790: ' RETURN_STATUS = ' || x_return_status);
1791: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1792: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.Pop_Index_Attrbs_To_Null returned errors');
1793: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1794: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1795: END IF;
1796: IF c_lines%ISOPEN THEN
1797: CLOSE c_lines;

Line 1823: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1819: );
1820: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1821: x_return_status := l_return_status;
1822: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1823: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1824: ' RETURN_STATUS = ' || x_return_status);
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1826: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.db_update_line_det_factors returned errors');
1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

Line 1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1821: x_return_status := l_return_status;
1822: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1823: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1824: ' RETURN_STATUS = ' || x_return_status);
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1826: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.db_update_line_det_factors returned errors');
1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1828: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1829: END IF;

Line 1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',

1823: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1824: ' RETURN_STATUS = ' || x_return_status);
1825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1826: G_PKG_NAME||': '||l_api_name||':ZX_NEW_SERVICES_PKG.db_update_line_det_factors returned errors');
1827: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel.END',
1828: 'ZX_NEW_SERVICES_PKG.update_det_factors_for_cancel(-)');
1829: END IF;
1830: RETURN;
1831: END IF;

Line 1845: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

1841: p_count => x_msg_count,
1842: p_data => x_msg_data
1843: );
1844: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1845: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1846: END IF;
1847:
1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1849: ROLLBACK TO update_det_factors_PVT;

Line 1861: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

1857: p_count => x_msg_count,
1858: p_data => x_msg_data
1859: );
1860: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1861: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1862: END IF;
1863: WHEN OTHERS THEN
1864: ROLLBACK TO update_det_factors_PVT;
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1876: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

1872: p_count => x_msg_count,
1873: p_data => x_msg_data
1874: );
1875: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1877: END IF;
1878: END update_det_factors_for_cancel;
1879:
1880: /* =============================================================================*

Line 2071: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

2067: HAVING zl.tax_amt <> SUM(zd.rec_nrec_tax_amt);
2068:
2069: BEGIN
2070: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2071: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
2072: END IF;
2073:
2074: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 2075: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2071: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
2072: END IF;
2073:
2074: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2076: 'APPLICATION ID: ' || p_transaction_rec.application_id ||
2077: ', ENTITY_CODE: ' || p_transaction_rec.entity_code ||
2078: ', EVENT_CLASS_CODE: ' || p_transaction_rec.event_class_code ||
2079: ', TRX_ID: ' || p_transaction_rec.trx_id ||

Line 2126: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':JAI processing start +');

2122: );
2123:
2124: IF lb_jai_exists = TRUE THEN
2125: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2126: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':JAI processing start +');
2127: END IF;
2128:
2129: --Call JAI procedure for AP TDS prepayment unapplication
2130: JAI_TAX_PROCESSING_PKG.CALCULATE_TAX(p_transaction_rec => p_transaction_rec

Line 2139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2135:
2136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2137: x_return_status := l_return_status;
2138: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2140: 'JAI_TAX_PROCESSING_PKG.CALCULATE_TAX RETURN_STATUS = ' || x_return_status);
2141: END IF;
2142: RAISE FND_API.G_EXC_ERROR;
2143: END IF;

Line 2146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':JAI processing end -');

2142: RAISE FND_API.G_EXC_ERROR;
2143: END IF;
2144:
2145: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':JAI processing end -');
2147: END IF;
2148: END IF;
2149: -- End : Added JAI Trigger Elimination
2150:

Line 2156: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2152: | Check for valid line_level_action |
2153: +--------------------------------------------------*/
2154: IF p_line_level_action NOT IN ('CANCEL','DISCARD','UNAPPLY_FROM') THEN
2155: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2156: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2157: 'Invalid Line_Level_Action passed by the calling product : '||p_line_level_action);
2158: END IF;
2159: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
2160: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Line_Level_Action passed by the calling product.');

Line 2191: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2187: ZX_API_PUB.G_DATA_TRANSFER_MODE := 'TAB';
2188: ZX_API_PUB.G_EXTERNAL_API_CALL := 'N';
2189:
2190: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2191: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2192: 'Data Transfer Mode: '||ZX_API_PUB.G_DATA_TRANSFER_MODE);
2193: END IF;
2194:
2195: /*-----------------------------------------+

Line 2212: FND_LOG.STRING(G_LEVEL_STATEMENT,

2208: IF get_event_class_info%ISOPEN THEN
2209: CLOSE get_event_class_info;
2210: END IF;
2211: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2212: FND_LOG.STRING(G_LEVEL_STATEMENT,
2213: G_MODULE_NAME || l_api_name,
2214: G_PKG_NAME||':'||l_api_name||': Event Class Info not retreived');
2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

Line 2215: FND_LOG.STRING(g_level_statement,

2211: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2212: FND_LOG.STRING(G_LEVEL_STATEMENT,
2213: G_MODULE_NAME || l_api_name,
2214: G_PKG_NAME||':'||l_api_name||': Event Class Info not retreived');
2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2217: 'RETURN_STATUS = ' || x_return_status);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

Line 2218: FND_LOG.STRING(g_level_statement,

2214: G_PKG_NAME||':'||l_api_name||': Event Class Info not retreived');
2215: FND_LOG.STRING(g_level_statement,
2216: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2217: 'RETURN_STATUS = ' || x_return_status);
2218: FND_LOG.STRING(g_level_statement,
2219: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2220: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2221: END IF;
2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2249: FND_LOG.STRING(g_level_statement,

2245:
2246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2247: x_return_status := l_return_status;
2248: IF (g_level_statement >= g_current_runtime_level ) THEN
2249: FND_LOG.STRING(g_level_statement,
2250: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2251: 'Incorrect return_status after calling ' ||
2252: ' ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly');
2253: FND_LOG.STRING(g_level_statement,

Line 2253: FND_LOG.STRING(g_level_statement,

2249: FND_LOG.STRING(g_level_statement,
2250: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2251: 'Incorrect return_status after calling ' ||
2252: ' ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly');
2253: FND_LOG.STRING(g_level_statement,
2254: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2255: 'RETURN_STATUS = ' || x_return_status);
2256: FND_LOG.STRING(g_level_statement,
2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

Line 2256: FND_LOG.STRING(g_level_statement,

2252: ' ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly');
2253: FND_LOG.STRING(g_level_statement,
2254: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2255: 'RETURN_STATUS = ' || x_return_status);
2256: FND_LOG.STRING(g_level_statement,
2257: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2258: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2259: END IF;
2260: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2278: FND_LOG.STRING(g_level_statement,

2274: x_return_status => l_return_status );
2275:
2276: IF NOT l_trx_migrated_b THEN
2277: IF (g_level_statement >= g_current_runtime_level ) THEN
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2280: 'New Item Line with no tax impacts in Payables, no action required');
2281: FND_LOG.STRING(g_level_statement,
2282: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

Line 2281: FND_LOG.STRING(g_level_statement,

2277: IF (g_level_statement >= g_current_runtime_level ) THEN
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2280: 'New Item Line with no tax impacts in Payables, no action required');
2281: FND_LOG.STRING(g_level_statement,
2282: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2283: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2284: END IF;
2285: RETURN;

Line 2293: FND_LOG.STRING(g_level_statement,

2289: INTO l_count
2290: FROM ZX_REVERSE_DIST_GT;
2291:
2292: IF (g_level_statement >= g_current_runtime_level ) THEN
2293: FND_LOG.STRING(g_level_statement,
2294: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2295: 'Count in ZX_REVERSE_DIST_GT : '||TO_CHAR(l_count));
2296: END IF;
2297:

Line 2310: FND_LOG.STRING(g_level_unexpected,

2306:
2307: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2308: x_return_status := l_return_status;
2309: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2310: FND_LOG.STRING(g_level_unexpected,
2311: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2312: 'Incorrect return_status after calling ' ||
2313: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2314: FND_LOG.STRING(g_level_unexpected,

Line 2314: FND_LOG.STRING(g_level_unexpected,

2310: FND_LOG.STRING(g_level_unexpected,
2311: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2312: 'Incorrect return_status after calling ' ||
2313: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2314: FND_LOG.STRING(g_level_unexpected,
2315: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2316: 'RETURN_STATUS = ' || x_return_status);
2317: FND_LOG.STRING(g_level_unexpected,
2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

Line 2317: FND_LOG.STRING(g_level_unexpected,

2313: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2314: FND_LOG.STRING(g_level_unexpected,
2315: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2316: 'RETURN_STATUS = ' || x_return_status);
2317: FND_LOG.STRING(g_level_unexpected,
2318: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2319: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2320: END IF;
2321: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2329: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2325: END IF;
2326: END IF;
2327:
2328: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2329: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2330: 'Updating the Freeze_Flag for the distributions');
2331: END IF;
2332:
2333: -- Update the freeze flag on the distributions

Line 2344: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2340: AND TRX_LINE_ID = p_trx_line_id
2341: AND TRX_LEVEL_TYPE = p_trx_level_type;
2342:
2343: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2344: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2345: 'No Of Rows Updated: ' || sql%rowcount);
2346: END IF;
2347:
2348: -- Set the tax amounts accordingly

Line 2350: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2346: END IF;
2347:
2348: -- Set the tax amounts accordingly
2349: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2350: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2351: 'Opening Cursor TOT_DIST_AMT_TRX_LINE');
2352: END IF;
2353:
2354: OPEN tot_dist_amt_trx_line;

Line 2417: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2413: CLOSE tot_dist_amt_trx_line;
2414:
2415: IF l_summarization_flag = 'Y' THEN
2416: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2417: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2418: 'Opening Cursor TOT_TAX_AMT_TRX_LINE');
2419: END IF;
2420: OPEN tot_tax_amt_trx_line;
2421: LOOP

Line 2438: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2434: LIMIT G_LINES_PER_FETCH;
2435:
2436: FOR i IN NVL(l_summary_tax_line_id_tbl.FIRST,0) .. NVL(l_summary_tax_line_id_tbl.LAST,-99) LOOP
2437: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2438: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2439: TO_CHAR(i)||': Tax_Amt = ' || l_tax_amt_tbl(i) ||
2440: ', Summary_Tax_Line_Id = ' || l_summary_tax_line_id_tbl(i));
2441: END IF;
2442:

Line 2469: FND_LOG.STRING(g_level_statement,

2465: END IF; --l_summarization_flag = 'Y'
2466: -- Cancel flow for the entire Invoice
2467: ELSE
2468: IF (g_level_statement >= g_current_runtime_level ) THEN
2469: FND_LOG.STRING(g_level_statement,
2470: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2471: 'Canceling Complete Invoice');
2472: END IF;
2473: -- Reverse the tax distributions, Payables needs to populate

Line 2480: FND_LOG.STRING(g_level_unexpected,

2476:
2477: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2478: x_return_status := l_return_status;
2479: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2480: FND_LOG.STRING(g_level_unexpected,
2481: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2482: 'Incorrect return_status after calling ' ||
2483: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2484: FND_LOG.STRING(g_level_unexpected,

Line 2484: FND_LOG.STRING(g_level_unexpected,

2480: FND_LOG.STRING(g_level_unexpected,
2481: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2482: 'Incorrect return_status after calling ' ||
2483: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2484: FND_LOG.STRING(g_level_unexpected,
2485: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2486: 'RETURN_STATUS = ' || x_return_status);
2487: FND_LOG.STRING(g_level_unexpected,
2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

Line 2487: FND_LOG.STRING(g_level_unexpected,

2483: 'ZX_TRD_SERVICES_PUB_PKG.REVERSE_DISTRIBUTIONS');
2484: FND_LOG.STRING(g_level_unexpected,
2485: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2486: 'RETURN_STATUS = ' || x_return_status);
2487: FND_LOG.STRING(g_level_unexpected,
2488: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2489: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2490: END IF;
2491: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2500: FND_LOG.STRING(g_level_statement,

2496: END IF;
2497:
2498: -- Update the freeze flag for the entire invoice
2499: IF (g_level_statement >= g_current_runtime_level ) THEN
2500: FND_LOG.STRING(g_level_statement,
2501: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2502: 'Updating the Freeze_Flag');
2503: END IF;
2504:

Line 2513: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2509: AND EVENT_CLASS_CODE = p_transaction_rec.event_class_code
2510: AND TRX_ID = p_transaction_rec.trx_id;
2511:
2512: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2513: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2514: 'No Of Rows Updated: ' || sql%rowcount);
2515: END IF;
2516:
2517: -- set the tax amounts accordingly

Line 2519: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2515: END IF;
2516:
2517: -- set the tax amounts accordingly
2518: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2519: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2520: 'Opening Cursor TOT_DIST_AMT_TRX');
2521: END IF;
2522: OPEN tot_dist_amt_trx;
2523: LOOP

Line 2582: FND_LOG.STRING(g_level_statement,

2578: CLOSE tot_dist_amt_trx;
2579:
2580: -- Check if there exist tax lines that do not have any distributions
2581: IF (g_level_statement >= g_current_runtime_level ) THEN
2582: FND_LOG.STRING(g_level_statement,
2583: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2584: 'Checking for Tax Lines without distributions');
2585: END IF;
2586:

Line 2607: FND_LOG.STRING(g_level_unexpected,

2603: AND zd.tax_line_id = zl.tax_line_id
2604: AND ROWNUM = 1);
2605: EXCEPTION WHEN OTHERS THEN
2606: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2607: FND_LOG.STRING(g_level_unexpected,
2608: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2609: 'Query to check for Tax Lines without dists failed with error '||SQLERRM);
2610: END IF;
2611: l_tax_line_count := 0;

Line 2615: FND_LOG.STRING(g_level_statement,

2611: l_tax_line_count := 0;
2612: END;
2613:
2614: IF (g_level_statement >= g_current_runtime_level ) THEN
2615: FND_LOG.STRING(g_level_statement,
2616: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2617: 'Count of Tax Lines without distributions = '||l_tax_line_count);
2618: END IF;
2619:

Line 2672: FND_LOG.STRING(g_level_statement,

2668: AND ZD.TAX_LINE_ID = ZL.TAX_LINE_ID
2669: AND ROWNUM = 1);
2670:
2671: IF (g_level_statement >= g_current_runtime_level ) THEN
2672: FND_LOG.STRING(g_level_statement,
2673: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2674: 'No. of Rows Updated : '||SQL%ROWCOUNT);
2675: END IF;
2676: END IF;

Line 2680: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2676: END IF;
2677:
2678: IF l_summarization_flag = 'Y' THEN
2679: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2680: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2681: 'Opening Cursor TOT_TAX_AMT_TRX');
2682: END IF;
2683: OPEN tot_tax_amt_trx;
2684: LOOP

Line 2727: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2723: -- If no distributions exists
2724: ELSE
2725: -- Discard flow for Single item line.
2726: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2727: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2728: 'If no distributions exists, Discard flow for Single item line : '|| p_trx_line_id);
2729: END IF;
2730: IF p_trx_line_id IS NOT NULL THEN
2731: UPDATE ZX_LINES

Line 2776: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

2772: AND NVL(TAX_ONLY_LINE_FLAG,'N') <> 'Y';
2773:
2774: IF l_summarization_flag = 'Y' THEN
2775: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2776: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
2777: 'Opening Cursor TOT_TAX_AMT_TRX_LINE');
2778: END IF;
2779: OPEN tot_tax_amt_trx_line;
2780: LOOP

Line 2899: FND_LOG.STRING(g_level_unexpected,

2895: );
2896: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2897: x_return_status := l_return_status;
2898: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2899: FND_LOG.STRING(g_level_unexpected,
2900: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2901: 'Incorrect return_status after calling ' ||
2902: 'ZX_API_PUB.discard_tax_only_lines');
2903: FND_LOG.STRING(g_level_unexpected,

Line 2903: FND_LOG.STRING(g_level_unexpected,

2899: FND_LOG.STRING(g_level_unexpected,
2900: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2901: 'Incorrect return_status after calling ' ||
2902: 'ZX_API_PUB.discard_tax_only_lines');
2903: FND_LOG.STRING(g_level_unexpected,
2904: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2905: 'RETURN_STATUS = ' || x_return_status);
2906: FND_LOG.STRING(g_level_unexpected,
2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

Line 2906: FND_LOG.STRING(g_level_unexpected,

2902: 'ZX_API_PUB.discard_tax_only_lines');
2903: FND_LOG.STRING(g_level_unexpected,
2904: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2905: 'RETURN_STATUS = ' || x_return_status);
2906: FND_LOG.STRING(g_level_unexpected,
2907: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2908: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2909: END IF;
2910: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2944: FND_LOG.STRING(g_level_unexpected,

2940: );
2941: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2942: x_return_status := l_return_status;
2943: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2944: FND_LOG.STRING(g_level_unexpected,
2945: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2946: 'Incorrect return_status after calling ' ||
2947: 'ZX_API_PUB.Global_document_update');
2948: FND_LOG.STRING(g_level_unexpected,

Line 2948: FND_LOG.STRING(g_level_unexpected,

2944: FND_LOG.STRING(g_level_unexpected,
2945: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.CANCEL_TAX_LINES',
2946: 'Incorrect return_status after calling ' ||
2947: 'ZX_API_PUB.Global_document_update');
2948: FND_LOG.STRING(g_level_unexpected,
2949: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2950: 'RETURN_STATUS = ' || x_return_status);
2951: FND_LOG.STRING(g_level_unexpected,
2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',

Line 2951: FND_LOG.STRING(g_level_unexpected,

2947: 'ZX_API_PUB.Global_document_update');
2948: FND_LOG.STRING(g_level_unexpected,
2949: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2950: 'RETURN_STATUS = ' || x_return_status);
2951: FND_LOG.STRING(g_level_unexpected,
2952: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines.END',
2953: 'ZX_NEW_SERVICES_PKG.cancel_tax_lines(-)');
2954: END IF;
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2964: FND_LOG.STRING(G_LEVEL_STATEMENT,

2960: END IF;
2961:
2962: --Preventice checks
2963: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2964: FND_LOG.STRING(G_LEVEL_STATEMENT,
2965: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2966: 'Opening Preventive Check Cursor Check_Canceled_Tax_Lines');
2967: END IF;
2968:

Line 2985: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2981:
2982: IF check_canceled_tax_lines%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
2983: l_return_status := FND_API.G_RET_STS_ERROR;
2984: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2986: 'Following tax lines are not canceled properly:');
2987: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
2988: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2989: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||

Line 2988: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2984: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2986: 'Following tax lines are not canceled properly:');
2987: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
2988: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2989: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||
2990: ', CANCEL_FLAG: '||l_chk_cancel_flg_tbl(i)||
2991: ', TAX_AMT: '||TO_CHAR(l_chk_tax_amt_tbl(i)));
2992: END LOOP;

Line 2996: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

2992: END LOOP;
2993: END IF;
2994: ELSE
2995: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2996: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
2997: 'No problematic records found. Tax canceled successfully.');
2998: END IF;
2999: END IF;
3000: EXIT WHEN check_canceled_tax_lines%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;

Line 3005: FND_LOG.STRING(G_LEVEL_STATEMENT,

3001: END LOOP;
3002: CLOSE check_canceled_tax_lines;
3003:
3004: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3005: FND_LOG.STRING(G_LEVEL_STATEMENT,
3006: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3007: 'Opening Preventive Check Cursor Check_Tax_Lines_Dists_Amt');
3008: END IF;
3009:

Line 3027: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3023: IF check_tax_lines_dists_amt%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
3024: l_return_status := FND_API.G_RET_STS_ERROR;
3025:
3026: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3028: 'Following tax lines and its distributions are out of sync:');
3029: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3030: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3031: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||

Line 3030: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3026: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3028: 'Following tax lines and its distributions are out of sync:');
3029: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3030: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3031: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||
3032: ', TAX_AMT: '||TO_CHAR(l_chk_tax_amt_tbl(i))||
3033: ', TOTAL_DIST_AMT: '||TO_CHAR(l_chk_tot_dist_amt_tbl(i)));
3034: END LOOP;

Line 3038: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3034: END LOOP;
3035: END IF;
3036: ELSE
3037: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3038: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3039: 'No problematic records found. Tax lines and distributions are in sync.');
3040: END IF;
3041: END IF;
3042: EXIT WHEN check_tax_lines_dists_amt%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;

Line 3056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');

3052: RAISE FND_API.G_EXC_ERROR;
3053: END IF;
3054:
3055: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3057: END IF;
3058:
3059: EXCEPTION
3060: WHEN FND_API.G_EXC_ERROR THEN

Line 3074: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

3070: p_count => x_msg_count,
3071: p_data => x_msg_data
3072: );
3073: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3074: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3075: END IF;
3076:
3077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3078: ROLLBACK TO cancel_tax_lines_PVT;

Line 3093: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

3089: p_count => x_msg_count,
3090: p_data => x_msg_data
3091: );
3092: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3093: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3094: END IF;
3095: WHEN OTHERS THEN
3096: ROLLBACK TO cancel_tax_lines_PVT;
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3111: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

3107: p_count => x_msg_count,
3108: p_data => x_msg_data
3109: );
3110: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3111: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
3112: END IF;
3113: END cancel_tax_lines;
3114:
3115: /* ======================================================================*

Line 3171: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');

3167: HAVING zl.tax_amt <> SUM(zd.rec_nrec_tax_amt);
3168:
3169: BEGIN
3170: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3171: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
3172: END IF;
3173:
3174: /*--------------------------------------------------+
3175: | Standard start of API savepoint |

Line 3278: FND_LOG.STRING(G_LEVEL_STATEMENT,

3274: l_chk_tax_amt_tbl.DELETE;
3275: l_chk_tot_dist_amt_tbl.DELETE;
3276:
3277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.STRING(G_LEVEL_STATEMENT,
3279: 'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3280: 'Opening Preventive Check Cursor Check_Tax_Lines_Dists_Amt');
3281: END IF;
3282:

Line 3296: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3292: IF check_tax_lines_dists_amt%FOUND AND l_chk_tax_line_id_tbl.COUNT > 0 THEN
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294:
3295: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3296: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3297: 'Following tax lines and its distributions are out of sync:');
3298: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3299: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3300: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||

Line 3299: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3295: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3296: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3297: 'Following tax lines and its distributions are out of sync:');
3298: FOR i IN NVL(l_chk_tax_line_id_tbl.FIRST,0)..NVL(l_chk_tax_line_id_tbl.LAST,-99) LOOP
3299: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3300: 'TAX_LINE_ID: '||TO_CHAR(l_chk_tax_line_id_tbl(i))||
3301: ', TAX_AMT: '||TO_CHAR(l_chk_tax_amt_tbl(i))||
3302: ', TOTAL_DIST_AMT: '||TO_CHAR(l_chk_tot_dist_amt_tbl(i)));
3303: END LOOP;

Line 3307: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',

3303: END LOOP;
3304: END IF;
3305: ELSE
3306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3307: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_NEW_SERVICES_PKG.cancel_tax_lines',
3308: 'No problematic records found. Tax lines and distributions are in sync.');
3309: END IF;
3310: END IF;
3311: EXIT WHEN check_tax_lines_dists_amt%NOTFOUND OR l_chk_tax_line_id_tbl.COUNT = 0;

Line 3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');

3350: END IF;
3351: -- End : Preventive check code --
3352:
3353: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3355: END IF;
3356:
3357: EXCEPTION
3358: WHEN FND_API.G_EXC_ERROR THEN

Line 3373: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

3369: p_data => x_msg_data
3370: );
3371:
3372: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3373: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3374: END IF;
3375:
3376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3377: ROLLBACK TO Del_Cand_Tax_Distributions_PVT;

Line 3392: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

3388: p_data => x_msg_data
3389: );
3390:
3391: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3392: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3393: END IF;
3394:
3395: WHEN OTHERS THEN
3396: ROLLBACK TO Del_Cand_Tax_Distributions_PVT;

Line 3410: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

3406: p_count => x_msg_count,
3407: p_data => x_msg_data
3408: );
3409: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3410: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
3411: END IF;
3412:
3413: END delete_tax_dists;
3414:

Line 3438: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||

3434:
3435: BEGIN
3436:
3437: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3438: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||
3439: '.BEGIN','ZX_NEW_SERVICES_PKG: '||l_api_name||'()+');
3440: END IF;
3441:
3442: /*--------------------------------------------------+

Line 3509: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3505: WHERE rec_nrec_tax_dist_id = p_tax_dist_dff_tbl.rec_nrec_tax_dist_id(i);
3506:
3507:
3508: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3509: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3510: G_MODULE_NAME||l_api_name||'.END',
3511: 'ZX_NEW_SERVICES_PKG: '||l_api_name||'()-');
3512: END IF;
3513:

Line 3529: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

3525: p_data => x_msg_data
3526: );
3527:
3528: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3529: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3530: END IF;
3531:
3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3533: ROLLBACK TO sync_tax_dist_dff_pvt;

Line 3548: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');

3544: p_data => x_msg_data
3545: );
3546:
3547: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3548: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
3549: END IF;
3550:
3551: WHEN OTHERS THEN
3552: ROLLBACK TO sync_tax_dist_dff_pvt;

Line 3566: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

3562: p_count => x_msg_count,
3563: p_data => x_msg_data
3564: );
3565: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3566: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
3567: END IF;
3568:
3569: END SYNC_TAX_DIST_DFF;
3570: --End Bug 7117340 --DFF ER