DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on FND_FILE

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 1011: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);

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
1015: raise le_error ;

Line 1012: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);

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
1015: raise le_error ;
1016: end if;

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 1035: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);

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:
1039: IF lv_return_code <> jai_constants.successful then

Line 1036: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);

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:
1039: IF lv_return_code <> jai_constants.successful then
1040: RAISE le_error;

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 1056: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);

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
1060: RAISE le_error;

Line 1057: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);

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
1060: RAISE le_error;
1061: END IF;

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

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

Line 2094: fnd_file.put_line(fnd_file.log,'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_pss invoice_id=' ||p_event_class_rec.trx_id);

2090:
2091:
2092: FOR inv_ps_rec IN c_get_inv_pss(p_event_class_rec.trx_id)
2093: LOOP
2094: fnd_file.put_line(fnd_file.log,'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_pss invoice_id=' ||p_event_class_rec.trx_id);
2095: IF inv_rec.invoice_type_lookup_code = 'CREDIT' and inv_rec.source = 'INDIA TDS' then
2096:
2097: open c_jai_ap_tds_thhold_trxs(p_event_class_rec.trx_id);
2098: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;

Line 2112: fnd_file.put_line(fnd_file.log,'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_lines LINE_NUMBER=' || inv_lines_rec.LINE_NUMBER);

2108: End IF;
2109: END LOOP;
2110:
2111: For inv_lines_rec in c_get_inv_lines(p_event_class_rec.trx_id) loop
2112: fnd_file.put_line(fnd_file.log,'In JAI_AP_TAX_PROCESSING.OPEN_INTERFACEIN at LOOP c_get_inv_lines LINE_NUMBER=' || inv_lines_rec.LINE_NUMBER);
2113: jai_ap_match_tax_proc_pkg.tax_check_at_inv_validate(inv_lines_rec.INVOICE_ID,
2114: inv_lines_rec.LINE_NUMBER,
2115: lv_process_flag,
2116: lv_process_message,

Line 2153: fnd_file.put_line(fnd_file.log,lv_return_message);

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

Line 2160: fnd_file.put_line(fnd_file.log,'Encountered the error in JAI_AP_TAX_PROCESSING.OPEN_INTERFACE ' || substr(sqlerrm,1,1900));

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:
2162: END OPEN_INTERFACE;
2163:
2164: