555: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
556: end if;
557: exception
558: when le_error then
559: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
560: fnd_message.set_token ('MSG_TEXT', lv_return_message);
561: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX', lv_return_message);
562: /*Commented by Chong for for displaying message to ZX 2012/09/02
563: app_exception.raise_exception (
556: end if;
557: exception
558: when le_error then
559: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
560: fnd_message.set_token ('MSG_TEXT', lv_return_message);
561: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX', lv_return_message);
562: /*Commented by Chong for for displaying message to ZX 2012/09/02
563: app_exception.raise_exception (
564: EXCEPTION_TYPE => 'APP' ,
568: */
569: x_return_status := FND_API.G_RET_STS_ERROR; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
570: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
571: when others then
572: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
573: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.CALCULATE_TAX' || substr(sqlerrm,1,1900));
574: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX', substr(sqlerrm,1,1900));
575: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
576: --Changed by Zhiwei for ZX comments to return same status even unexpected error begin
569: x_return_status := FND_API.G_RET_STS_ERROR; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
570: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
571: when others then
572: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
573: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.CALCULATE_TAX' || substr(sqlerrm,1,1900));
574: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX', substr(sqlerrm,1,1900));
575: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
576: --Changed by Zhiwei for ZX comments to return same status even unexpected error begin
577: ---------------------------------------------------------------------------------------------
691: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
692: end if;
693: exception
694: when le_error then
695: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
696: fnd_message.set_token ('MSG_TEXT', lv_return_message);
697: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY', lv_return_message);
698: x_return_status := FND_API.G_RET_STS_ERROR; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
699: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
692: end if;
693: exception
694: when le_error then
695: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
696: fnd_message.set_token ('MSG_TEXT', lv_return_message);
697: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY', lv_return_message);
698: x_return_status := FND_API.G_RET_STS_ERROR; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
699: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
700: /*Commented by Chong for for displaying message to ZX 2012/09/02
704: EXCEPTION_TEXT => lv_return_message
705: );
706: */
707: when others then
708: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
709: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY' || substr(sqlerrm,1,1900));
710: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY', substr(sqlerrm,1,1900));
711: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
712: --Changed by Zhiwei for ZX comments to return same status even unexpected error begin
705: );
706: */
707: when others then
708: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
709: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY' || substr(sqlerrm,1,1900));
710: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY', substr(sqlerrm,1,1900));
711: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
712: --Changed by Zhiwei for ZX comments to return same status even unexpected error begin
713: ---------------------------------------------------------------------------------------------
1072: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
1073: end if;
1074: exception
1075: when le_error then
1076: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1077: fnd_message.set_token ('MSG_TEXT', lv_return_message);
1078: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX', lv_return_message);
1079: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX ' || lv_return_message);
1080:
1073: end if;
1074: exception
1075: when le_error then
1076: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1077: fnd_message.set_token ('MSG_TEXT', lv_return_message);
1078: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX', lv_return_message);
1079: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX ' || lv_return_message);
1080:
1081: /*app_exception.raise_exception (
1086: x_return_status := FND_API.G_RET_STS_ERROR; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
1087: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
1088:
1089: when others then
1090: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1091: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX' || substr(sqlerrm,1,1900));
1092: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX', substr(sqlerrm,1,1900));
1093: /*app_exception.raise_exception (
1094: EXCEPTION_TYPE => 'APP',
1087: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
1088:
1089: when others then
1090: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1091: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX' || substr(sqlerrm,1,1900));
1092: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX', substr(sqlerrm,1,1900));
1093: /*app_exception.raise_exception (
1094: EXCEPTION_TYPE => 'APP',
1095: EXCEPTION_CODE => -20001 ,
1275:
1276:
1277: EXCEPTION
1278: when le_error then
1279: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1280: fnd_message.set_token ('MSG_TEXT', lv_return_message);
1281: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE', lv_return_message);
1282: app_exception.raise_exception (
1283: EXCEPTION_TYPE => 'APP' ,
1276:
1277: EXCEPTION
1278: when le_error then
1279: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1280: fnd_message.set_token ('MSG_TEXT', lv_return_message);
1281: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE', lv_return_message);
1282: app_exception.raise_exception (
1283: EXCEPTION_TYPE => 'APP' ,
1284: EXCEPTION_CODE => -20001 ,
1284: EXCEPTION_CODE => -20001 ,
1285: EXCEPTION_TEXT => lv_return_message
1286: );
1287: when others then
1288: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1289: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE' || substr(sqlerrm,1,1900));
1290: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE', substr(sqlerrm,1,1900));
1291: app_exception.raise_exception (
1292: EXCEPTION_TYPE => 'APP',
1285: EXCEPTION_TEXT => lv_return_message
1286: );
1287: when others then
1288: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1289: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE' || substr(sqlerrm,1,1900));
1290: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE', substr(sqlerrm,1,1900));
1291: app_exception.raise_exception (
1292: EXCEPTION_TYPE => 'APP',
1293: EXCEPTION_CODE => -20001 ,
1378: jai_ap_dtc_cancellation_pkg.process_invoice_cancellation(errbuf => lv_errbuf
1379: ,retcode => lv_retcode
1380: ,p_invoice_id => pn_invoice_id);
1381: IF lv_retcode IS NOT NULL THEN
1382: Fnd_Message.Set_Name('JA','JAI_GENERIC_MSG');
1383: Fnd_Message.Set_Token('MSG_TEXT', lv_errbuf);
1384: Fnd_Message.RAISE_ERROR();
1385: END IF;
1386:
1379: ,retcode => lv_retcode
1380: ,p_invoice_id => pn_invoice_id);
1381: IF lv_retcode IS NOT NULL THEN
1382: Fnd_Message.Set_Name('JA','JAI_GENERIC_MSG');
1383: Fnd_Message.Set_Token('MSG_TEXT', lv_errbuf);
1384: Fnd_Message.RAISE_ERROR();
1385: END IF;
1386:
1387:
1380: ,p_invoice_id => pn_invoice_id);
1381: IF lv_retcode IS NOT NULL THEN
1382: Fnd_Message.Set_Name('JA','JAI_GENERIC_MSG');
1383: Fnd_Message.Set_Token('MSG_TEXT', lv_errbuf);
1384: Fnd_Message.RAISE_ERROR();
1385: END IF;
1386:
1387:
1388: END IF;
1391:
1392: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1396: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.ap_dtc_cancel_invoice: ' || substr(sqlerrm,1,1900));
1397: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.ap_dtc_cancel_invoice', substr(sqlerrm,1,1900));
1398: app_exception.raise_exception;
1399:
1392: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1396: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.ap_dtc_cancel_invoice: ' || substr(sqlerrm,1,1900));
1397: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.ap_dtc_cancel_invoice', substr(sqlerrm,1,1900));
1398: app_exception.raise_exception;
1399:
1400: END ap_dtc_cancel_invoice;
1456: END IF;
1457: EXCEPTION
1458: WHEN le_error THEN
1459:
1460: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1461: fnd_message.set_token ('MSG_TEXT', lv_return_message);
1462: pv_return_status := FND_API.G_RET_STS_ERROR;
1463: fnd_msg_pub.add;
1464:
1457: EXCEPTION
1458: WHEN le_error THEN
1459:
1460: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1461: fnd_message.set_token ('MSG_TEXT', lv_return_message);
1462: pv_return_status := FND_API.G_RET_STS_ERROR;
1463: fnd_msg_pub.add;
1464:
1465: WHEN OTHERS THEN
1462: pv_return_status := FND_API.G_RET_STS_ERROR;
1463: fnd_msg_pub.add;
1464:
1465: WHEN OTHERS THEN
1466: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1467: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_AP_TAX_PROCESSING. CREATE_ACCOUNTING ' || substr(sqlerrm,1,1900));
1468: fnd_msg_pub.add;
1469: --Changed by Zhiwei for ZX comments to return same status even unexpected error begin
1470: ---------------------------------------------------------------------------------------------
1463: fnd_msg_pub.add;
1464:
1465: WHEN OTHERS THEN
1466: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
1467: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_AP_TAX_PROCESSING. CREATE_ACCOUNTING ' || substr(sqlerrm,1,1900));
1468: fnd_msg_pub.add;
1469: --Changed by Zhiwei for ZX comments to return same status even unexpected error begin
1470: ---------------------------------------------------------------------------------------------
1471: /*app_exception.raise_exception (
2145:
2146: EXCEPTION
2147: WHEN le_error THEN
2148:
2149: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
2150: fnd_message.set_token ('MSG_TEXT', lv_return_message);
2151: pv_return_status := FND_API.G_RET_STS_ERROR;
2152: fnd_msg_pub.add;
2153: fnd_file.put_line(fnd_file.log,lv_return_message);
2146: EXCEPTION
2147: WHEN le_error THEN
2148:
2149: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
2150: fnd_message.set_token ('MSG_TEXT', lv_return_message);
2151: pv_return_status := FND_API.G_RET_STS_ERROR;
2152: fnd_msg_pub.add;
2153: fnd_file.put_line(fnd_file.log,lv_return_message);
2154:
2152: fnd_msg_pub.add;
2153: fnd_file.put_line(fnd_file.log,lv_return_message);
2154:
2155: WHEN OTHERS THEN
2156: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
2157: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_AP_TAX_PROCESSING.OPEN_INTERFACE ' || substr(sqlerrm,1,1900));
2158: fnd_msg_pub.add;
2159: pv_return_status := FND_API.G_RET_STS_ERROR;
2160: fnd_file.put_line(fnd_file.log,'Encountered the error in JAI_AP_TAX_PROCESSING.OPEN_INTERFACE ' || substr(sqlerrm,1,1900));
2153: fnd_file.put_line(fnd_file.log,lv_return_message);
2154:
2155: WHEN OTHERS THEN
2156: fnd_message.set_name ('JA','JAI_GENERIC_MSG');
2157: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_AP_TAX_PROCESSING.OPEN_INTERFACE ' || substr(sqlerrm,1,1900));
2158: fnd_msg_pub.add;
2159: pv_return_status := FND_API.G_RET_STS_ERROR;
2160: fnd_file.put_line(fnd_file.log,'Encountered the error in JAI_AP_TAX_PROCESSING.OPEN_INTERFACE ' || substr(sqlerrm,1,1900));
2161: