DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_CMN_UTILS_PKG

Line 183: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code);

179: end if;
180:
181: if nvl(p_event_class_rec.application_id, p_transaction_rec.application_id) = 200 then -- called from AP
182:
183: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code);
184: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.EVENT_TYPE_CODE );
185: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code);
186:
187: /**Prepayment unapplication*/

Line 184: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.EVENT_TYPE_CODE );

180:
181: if nvl(p_event_class_rec.application_id, p_transaction_rec.application_id) = 200 then -- called from AP
182:
183: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code);
184: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.EVENT_TYPE_CODE );
185: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code);
186:
187: /**Prepayment unapplication*/
188: if p_line_level_action in ('UNAPPLY_FROM') and p_trx_line_id is not NULL then -- Prepayment Unapply Action

Line 185: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code);

181: if nvl(p_event_class_rec.application_id, p_transaction_rec.application_id) = 200 then -- called from AP
182:
183: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code);
184: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.EVENT_TYPE_CODE );
185: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code);
186:
187: /**Prepayment unapplication*/
188: if p_line_level_action in ('UNAPPLY_FROM') and p_trx_line_id is not NULL then -- Prepayment Unapply Action
189: lv_action := JAI_CONSTANTS.inserting;

Line 561: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX', lv_return_message);

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' ,
565: EXCEPTION_CODE => -20001 ,

Line 574: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX', substr(sqlerrm,1,1900));

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: ---------------------------------------------------------------------------------------------
578: /*app_exception.raise_exception (

Line 697: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY', lv_return_message);

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
701: app_exception.raise_exception (

Line 710: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY', substr(sqlerrm,1,1900));

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: ---------------------------------------------------------------------------------------------
714: /*app_exception.raise_exception (

Line 843: lb_jai_exists := JAI_CMN_UTILS_PKG.CHECK_JAI_EXISTS(p_calling_object => 'CALCULATE_TAX'

839:
840: if (nvl(GN_SET_BOOK_ID,-999) = nvl(l_ledger_id,-998))then
841: return GV_JAI_EXISTS;
842: else
843: lb_jai_exists := JAI_CMN_UTILS_PKG.CHECK_JAI_EXISTS(p_calling_object => 'CALCULATE_TAX'
844: ,p_set_of_books_id => l_ledger_id
845: );
846:
847: GV_JAI_EXISTS := lb_jai_exists;

Line 1078: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX', lv_return_message);

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 (
1082: EXCEPTION_TYPE => 'APP' ,

Line 1092: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX', substr(sqlerrm,1,1900));

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 ,
1096: EXCEPTION_TEXT => 'Encountered the error in procedure JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX' || substr(sqlerrm,1,1900)

Line 1281: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE', lv_return_message);

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 ,
1285: EXCEPTION_TEXT => lv_return_message

Line 1290: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE', substr(sqlerrm,1,1900));

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 ,
1294: EXCEPTION_TEXT => 'Encountered the error in procedure JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE' || substr(sqlerrm,1,1900)

Line 1358: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');

1354: lv_retcode VARCHAR2(1);
1355:
1356: BEGIN
1357: --log for debug
1358: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
1359: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name || '.parameters', 'pn_invoice_id: ' || pn_invoice_id );
1360:
1361:
1362: OPEN c_get_invoice_info(pn_invoice_id);

Line 1359: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name || '.parameters', 'pn_invoice_id: ' || pn_invoice_id );

1355:
1356: BEGIN
1357: --log for debug
1358: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
1359: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name || '.parameters', 'pn_invoice_id: ' || pn_invoice_id );
1360:
1361:
1362: OPEN c_get_invoice_info(pn_invoice_id);
1363: FETCH c_get_invoice_info INTO r_invoice_info;

Line 1392: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');

1388: END IF;
1389:
1390: 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));

Line 1397: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_TAX_PROCESSING_PKG.ap_dtc_cancel_invoice', substr(sqlerrm,1,1900));

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;
1401:

Line 2061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.trx_id );

2057: BEGIN
2058:
2059: IF (p_event_class_rec.application_id = 200) THEN --Indicates AP Module
2060:
2061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.trx_id );
2062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code );
2063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code );
2064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_type_code );
2065: IF p_event_class_rec.event_class_code IN ('STANDARD INVOICES') AND

Line 2062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code );

2058:
2059: IF (p_event_class_rec.application_id = 200) THEN --Indicates AP Module
2060:
2061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.trx_id );
2062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code );
2063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code );
2064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_type_code );
2065: IF p_event_class_rec.event_class_code IN ('STANDARD INVOICES') AND
2066: ((p_event_class_rec.tax_event_type_code IN ('CREATE') AND

Line 2063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code );

2059: IF (p_event_class_rec.application_id = 200) THEN --Indicates AP Module
2060:
2061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.trx_id );
2062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code );
2063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code );
2064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_type_code );
2065: IF p_event_class_rec.event_class_code IN ('STANDARD INVOICES') AND
2066: ((p_event_class_rec.tax_event_type_code IN ('CREATE') AND
2067: p_event_class_rec.event_type_code IN ('STANDARD CREATED')

Line 2064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_type_code );

2060:
2061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.trx_id );
2062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_class_code );
2063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code );
2064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, p_event_class_rec.event_type_code );
2065: IF p_event_class_rec.event_class_code IN ('STANDARD INVOICES') AND
2066: ((p_event_class_rec.tax_event_type_code IN ('CREATE') AND
2067: p_event_class_rec.event_type_code IN ('STANDARD CREATED')
2068: ) OR

Line 2080: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN before call JAI_AP_OI_PROCESSING_PKG.PROCESS_INVOICE invoice_id=' ||p_event_class_rec.trx_id );

2076: OPEN c_get_invs(p_event_class_rec.trx_id);
2077: FETCH c_get_invs into inv_rec;
2078: CLOSE c_get_invs;
2079: fnd_file.put_line(fnd_file.log,'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN before call JAI_AP_OI_PROCESSING_PKG.PROCESS_INVOICE invoice_id=' ||p_event_class_rec.trx_id);
2080: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN before call JAI_AP_OI_PROCESSING_PKG.PROCESS_INVOICE invoice_id=' ||p_event_class_rec.trx_id );
2081: JAI_AP_OI_PROCESSING_PKG.PROCESS_INVOICE(
2082: pr_rec => inv_rec,
2083: pv_action => lv_action,
2084: pv_return_code => lv_return_code,