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.JAI_TAX_PROCESSING_PKG dependencies on JAI_TAX_PROCESSING_PKG

Line 1: package body JAI_TAX_PROCESSING_PKG as

1: package body JAI_TAX_PROCESSING_PKG as
2: /* $Header: jai_tax_prc.plb 120.41.12020000.3 2013/05/07 09:56:09 cholei noship $ */
3:
4: /*---------------------------------------------------------------------------------------------------------------------------------+
5: | Created By : zhiwei.xin |

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_TAX_PROCESSING_PKG';

19: /* ======================================================================*
20: | Global Data Types |
21: * ======================================================================*/
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_TAX_PROCESSING_PKG';
24: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
25: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
26: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
27: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 38: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_TAX_PROCESSING_PKG.';

34: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
36: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
37: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
38: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_TAX_PROCESSING_PKG.';
39:
40: GN_SET_BOOK_ID number;
41: GV_JAI_EXISTS boolean := false;
42:

Line 286: jai_tax_processing_pkg.open_interface

282: p_event_class_rec.event_type_code IN ('STANDARD UPDATED')
283: )
284: ) THEN
285:
286: jai_tax_processing_pkg.open_interface
287: ( p_event_class_rec => p_event_class_rec,
288: pv_return_status => x_return_status
289: );
290:

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 573: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.CALCULATE_TAX' || substr(sqlerrm,1,1900));

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

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

577: ---------------------------------------------------------------------------------------------
578: /*app_exception.raise_exception (
579: EXCEPTION_TYPE => 'APP',
580: EXCEPTION_CODE => -20001 ,
581: EXCEPTION_TEXT => 'Encountered the error in procedure JAI_TAX_PROCESSING_PKG.CALCULATE_TAX' || substr(sqlerrm,1,1900)
582: );*/
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: ----------------------------------------------------------------------------------------------
585: --Changed by Zhiwei for ZX comments to return same status even unexpected error end

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 709: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY' || substr(sqlerrm,1,1900));

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

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

713: ---------------------------------------------------------------------------------------------
714: /*app_exception.raise_exception (
715: EXCEPTION_TYPE => 'APP',
716: EXCEPTION_CODE => -20001 ,
717: EXCEPTION_TEXT => 'Encountered the error in procedure JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY' || substr(sqlerrm,1,1900)
718: );*/
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: ----------------------------------------------------------------------------------------------
721: --Changed by Zhiwei for ZX comments to return same status even unexpected error end

Line 962: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX for transaction ' || t_ra_customer_trx_rec.customer_trx_id);

958: OPEN c_ra_customer_trx(p_event_class_rec.trx_id);
959: FETCH c_ra_customer_trx INTO t_ra_customer_trx_rec;
960: CLOSE c_ra_customer_trx;
961:
962: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX for transaction ' || t_ra_customer_trx_rec.customer_trx_id);
963:
964: --FOR rec_trx_lines in c_ra_cust_trx_lines(ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id)
965: FOR rec_trx_lines in c_ra_cust_trx_lines(p_event_class_rec.trx_id)
966: LOOP

Line 971: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into loop for transaction ' || t_ra_customer_trx_rec.customer_trx_id);

967:
968: /*FOR i IN 1 .. ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.application_id.count
969: LOOP*/
970:
971: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into loop for transaction ' || t_ra_customer_trx_rec.customer_trx_id);
972:
973:
974: ln_trx_line_id := rec_trx_lines.customer_trx_line_id;
975:

Line 985: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX get trx line id ' || ln_trx_line_id);

981: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_class_code(i) = 'INVOICE'
982: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_type_code(i) = 'INV_CREATE'
983: ;*/
984:
985: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX get trx line id ' || ln_trx_line_id);
986:
987:
988: open c_ra_customer_trx_lines(ln_trx_line_id);
989: fetch c_ra_customer_trx_lines into t_rec_lines;

Line 999: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into import_projects_taxes() ');

995: if t_rec_lines.line_type = 'LINE'
996: and JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context(t_rec_lines.interface_line_context)
997: then
998:
999: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into import_projects_taxes() ');
1000:
1001: JAI_AR_IMPORT_POPU_PKG.import_projects_taxes
1002: (
1003: r_new => t_rec_lines

Line 1010: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out import_projects_taxes() ');

1006: , pv_err_msg => lv_return_message
1007: , pv_err_flg => lv_return_code
1008: );
1009:
1010: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out import_projects_taxes() ');
1011: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);
1012: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);
1013:
1014: IF lv_return_code <> jai_constants.successful then

Line 1024: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into pop_jai_inv_and_suppl() ');

1020:
1021:
1022: if t_rec_lines.line_type = 'LINE' then
1023:
1024: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into pop_jai_inv_and_suppl() ');
1025:
1026: JAI_AR_IMPORT_POPU_PKG.pop_jai_inv_and_suppl(
1027: --JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2(
1028: pr_old => NULL

Line 1034: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out pop_jai_inv_and_suppl() ');

1030: ,pv_action => lv_action
1031: ,pv_return_code => lv_return_code
1032: ,pv_return_message => lv_return_message
1033: );
1034: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out pop_jai_inv_and_suppl() ');
1035: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);
1036: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);
1037:
1038:

Line 1045: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into pop_jai_rmacm() ');

1041: END IF;
1042: end if;
1043: if t_rec_lines.line_type = 'LINE' then
1044:
1045: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into pop_jai_rmacm() ');
1046:
1047: JAI_AR_IMPORT_POPU_PKG.pop_jai_rmacm(
1048: --JAI_AR_RCTLA_IM_PKG.ARI_T3(
1049: pr_old => NULL

Line 1055: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out pop_jai_rmacm() ');

1051: ,pv_action => lv_action
1052: ,pv_return_code => lv_return_code
1053: ,pv_return_message => lv_return_message
1054: );
1055: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out pop_jai_rmacm() ');
1056: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);
1057: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);
1058:
1059: IF lv_return_code <> jai_constants.successful then

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 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);

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

Line 1091: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX' || substr(sqlerrm,1,1900));

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 ,

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 1096: EXCEPTION_TEXT => 'Encountered the error in procedure 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)
1097: );*/
1098: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX ' || substr(sqlerrm,1,1900));
1099: x_return_status := FND_API.G_RET_STS_ERROR; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
1100: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02

Line 1098: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX ' || substr(sqlerrm,1,1900));

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)
1097: );*/
1098: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX ' || substr(sqlerrm,1,1900));
1099: x_return_status := FND_API.G_RET_STS_ERROR; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
1100: fnd_msg_pub.add; --Added x_return_status by Chong for displaying message to ZX 2012/09/02
1101:
1102: end IMPORT_DOCUMENT_WITH_TAX;

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 1289: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.PROCESS_COMPLETE' || substr(sqlerrm,1,1900));

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 ,

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 1294: EXCEPTION_TEXT => 'Encountered the error in procedure 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)
1295: );
1296:
1297:
1298: END PROCESS_COMPLETE;

Line 1396: fnd_message.set_token ('MSG_TEXT', 'Encountered the error in JAI_TAX_PROCESSING_PKG.ap_dtc_cancel_invoice: ' || substr(sqlerrm,1,1900));

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;

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 1444: JAI_TAX_PROCESSING_PKG.create_accounting(

1440:
1441: lv_action := JAI_CONSTANTS.updating;
1442:
1443: FOR ap_inv_dist_rec in c_get_inv_dists(zx_global_structures_pkg.g_event_class_rec.trx_id)LOOP
1444: JAI_TAX_PROCESSING_PKG.create_accounting(
1445: pr_rec => ap_inv_dist_rec ,
1446: pv_action => lv_action ,
1447: pv_return_code => lv_return_code ,
1448: pv_return_message => lv_return_message

Line 1474: EXCEPTION_TEXT => 'Encountered the error in procedure JAI_TAX_PROCESSING_PKG.CREATE_ACCOUNTING' || substr(sqlerrm,1,1900)

1470: ---------------------------------------------------------------------------------------------
1471: /*app_exception.raise_exception (
1472: EXCEPTION_TYPE => 'APP',
1473: EXCEPTION_CODE => -20001 ,
1474: EXCEPTION_TEXT => 'Encountered the error in procedure JAI_TAX_PROCESSING_PKG.CREATE_ACCOUNTING' || substr(sqlerrm,1,1900)
1475: );*/
1476: pv_return_status := FND_API.G_RET_STS_ERROR;
1477: ----------------------------------------------------------------------------------------------
1478: --Changed by Zhiwei for ZX comments to return same status even unexpected error end

Line 1490: | Called From : JAI_TAX_PROCESSING_PKG.create_accounting |

1486: | Type : PROCEDURE |
1487: | Purpose : Insert jai journal entry to gl interface table |
1488: | TDD Reference : Section 8.5 |
1489: | Assumptions : |
1490: | Called From : JAI_TAX_PROCESSING_PKG.create_accounting |
1491: |--------------------------------------------------------------------------------------------------------------------------------|
1492: | parameters IN/OUT Type Required Description and Purpose |
1493: | ------------ -------- ------ ---------- ------------------------- |
1494: | pr_rec IN RECORD yes ap distribution record |

Line 2165: end JAI_TAX_PROCESSING_PKG;

2161:
2162: END OPEN_INTERFACE;
2163:
2164:
2165: end JAI_TAX_PROCESSING_PKG;