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 FND_LOG

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

27: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
28: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
29: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
30:
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
34: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

28: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
29: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
30:
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
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;

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

29: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
30:
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
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;

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

30:
31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
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.';

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

31: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
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:

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

32: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
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;

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

33: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
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;

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

174: --Added by Junjian for ZX integration of Invoice lines discard end
175:
176: begin
177: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
179: end if;
180:
181: if nvl(p_event_class_rec.application_id, p_transaction_rec.application_id) = 200 then -- called from AP
182:

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 214: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call unpply for invoice: ' || p_transaction_rec.TRX_ID );

210: been unapplied, so they should not be fetched out for processing.
211: */
212:
213: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
214: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call unpply for invoice: ' || p_transaction_rec.TRX_ID );
215: end if;
216:
217: FOR ap_inv_dist_rec in c_get_inv_dist_line(p_transaction_rec.TRX_ID)
218: LOOP

Line 242: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call validation for invoice: ' || NVL(p_event_class_rec.TRX_ID , p_transaction_rec.TRX_ID));

238:
239: lv_action := JAI_CONSTANTS.updating;
240:
241: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
242: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call validation for invoice: ' || NVL(p_event_class_rec.TRX_ID , p_transaction_rec.TRX_ID));
243: end if;
244:
245: for ap_inv_dist_rec in c_get_inv_dists(NVL(p_event_class_rec.TRX_ID , p_transaction_rec.TRX_ID))
246: loop

Line 321: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_po with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);

317: ELSIF p_event_class_rec.event_type_code = 'PO_PA_ADJUSTED' THEN
318: lv_action := JAI_CONSTANTS.updating;
319: END IF;
320: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
321: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_po with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
322: end if;
323: jai_po_proc_pkg.process_po(p_event_class_rec.trx_id, lv_action);
324:
325: ELSIF p_event_class_rec.entity_code = 'RELEASE'

Line 335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_release with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);

331: ELSIF p_event_class_rec.event_type_code = 'RELEASE_ADJUSTED' THEN
332: lv_action := JAI_CONSTANTS.updating;
333: END IF;
334: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_release with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
336: end if;
337: jai_po_proc_pkg.process_release(p_event_class_rec.trx_id, lv_action);
338: ELSIF p_event_class_rec.entity_code = 'REQUISITION'
339: AND p_event_class_rec.event_class_code = 'REQUISITION'

Line 342: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_requisition with trx_id ' || p_event_class_rec.trx_id );

338: ELSIF p_event_class_rec.entity_code = 'REQUISITION'
339: AND p_event_class_rec.event_class_code = 'REQUISITION'
340: AND p_event_class_rec.event_type_code IN ('REQ_CREATED') THEN
341: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
342: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_requisition with trx_id ' || p_event_class_rec.trx_id );
343: end if;
344:
345: jai_po_proc_pkg.process_requisition(p_event_class_rec.trx_id);
346: END IF;

Line 351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.delete_po_taxes and delete_jai_po_lines with p_trx_line_id ' || p_trx_line_id );

347: ELSIF p_transaction_rec.application_id = 201 THEN--Indicates PO Module
348: IF p_transaction_rec.entity_code = 'PURCHASE_ORDER'AND p_transaction_rec.event_class_code = 'PO_PA' THEN
349: IF p_transaction_rec.event_type_code IN( 'PO_PA_ADJUSTED') THEN
350: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.delete_po_taxes and delete_jai_po_lines with p_trx_line_id ' || p_trx_line_id );
352: end if;
353: jai_po_proc_pkg.delete_po_taxes(pn_line_loc_id => p_trx_line_id );
354: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => p_trx_line_id);
355: ELSIF p_transaction_rec.event_type_code IN( 'PO_PA_CANCELLED') THEN

Line 357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.cancel_po with TRX_ID' || p_transaction_rec.TRX_ID );

353: jai_po_proc_pkg.delete_po_taxes(pn_line_loc_id => p_trx_line_id );
354: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => p_trx_line_id);
355: ELSIF p_transaction_rec.event_type_code IN( 'PO_PA_CANCELLED') THEN
356: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.cancel_po with TRX_ID' || p_transaction_rec.TRX_ID );
358: end if;
359: jai_po_proc_pkg.cancel_po(p_transaction_rec.TRX_ID);
360: END IF;
361:

Line 545: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', 'after jai_ar_tax_processing_pkg.calculate_tax. lv_return_code = '||lv_return_code||

541: --Added by qinglei for ZX Integration of Manual AR end
542:
543: --Added by Qinglei for bug#14627780 begin
544: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
545: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', 'after jai_ar_tax_processing_pkg.calculate_tax. lv_return_code = '||lv_return_code||
546: ', lv_return_message = '||lv_return_message);
547: END IF;
548: IF lv_return_code <> JAI_CONSTANTS.successful THEN
549: RAISE le_error;

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

551: --Added by Qinglei for bug#14627780 end
552: END IF;
553:
554: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
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');

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 637: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');

633: and invoice_distribution_id_prepay = aida.invoice_distribution_id);
634:
635: begin
636: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
637: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
638: end if;
639:
640: if p_event_class_rec.application_id = 200 then -- called from AP
641:

Line 662: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call application for invoice: ' || p_event_class_rec.TRX_ID );

658: );
659: END LOOP;
660:
661: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
662: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call application for invoice: ' || p_event_class_rec.TRX_ID );
663: end if;
664: /*
665: Fetch prepay distribution lines for prepay application (amount < 0).
666: Datas in JAI_AP_TDS_PREPAYMENT indicate the prepay distributions had already been applied,

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

687:
688: end if;
689:
690: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
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');

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 790: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');

786: ln_org_id NUMBER;--Added by Wenqiong for PO integration
787: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_JAI_EXISTS_IN_ZX()';
788: begin
789: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
790: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
791: end if;
792:
793: l_ledger_id := pn_set_of_books_id;
794:

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

849:
850: end if;
851:
852: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
853: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
854: end if;
855:
856: return GV_JAI_EXISTS;
857: end check_jai_exists_in_zx;

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

920:
921: begin
922:
923: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
924: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
925: end if;
926:
927: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
928: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' p_event_class_rec.application_id: '||p_event_class_rec.application_id||';'

Line 928: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' p_event_class_rec.application_id: '||p_event_class_rec.application_id||';'

924: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
925: end if;
926:
927: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
928: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' p_event_class_rec.application_id: '||p_event_class_rec.application_id||';'
929: || 'p_event_class_rec.entity_code :' ||p_event_class_rec.entity_code||';'
930: || 'p_event_class_rec.TAX_EVENT_CLASS_CODE :' ||p_event_class_rec.TAX_EVENT_CLASS_CODE||';'
931: || 'p_event_class_rec.trx_id :' ||p_event_class_rec.trx_id||';'
932:

Line 934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' global_struction_pkg.application_id: '||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id||';'

930: || 'p_event_class_rec.TAX_EVENT_CLASS_CODE :' ||p_event_class_rec.TAX_EVENT_CLASS_CODE||';'
931: || 'p_event_class_rec.trx_id :' ||p_event_class_rec.trx_id||';'
932:
933: );
934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' global_struction_pkg.application_id: '||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id||';'
935: || 'global_struction_pkg.entity_code :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code||';'
936: || 'global_struction_pkg.TAX_EVENT_CLASS_CODE :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE||';'
937: || 'global_struction_pkg.trx_id :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id||';'
938:

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

1068:
1069: END IF;
1070:
1071: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
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');

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 1714: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');

1710: BEGIN
1711: pv_return_code := jai_constants.successful ;
1712:
1713: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1714: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1715: end if;
1716:
1717:
1718: If pv_action = jai_constants.updating Then

Line 1944: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()+');

1940: END IF; /*pr_rec.line_type_lookup_code = 'MISCELLANEOUS' AND ln_dist_line_amount > 0 */
1941: End if; /* updating */
1942:
1943: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1944: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()+');
1945: end if;
1946:
1947: EXCEPTION
1948: WHEN OTHERS THEN

Line 1952: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.EXCEPTION', G_PKG_NAME || ': '||l_api_name||'()+'||' EXCEPTION Message:'||pv_return_message);

1948: WHEN OTHERS THEN
1949: pv_return_code := jai_constants.unexpected_error;
1950: pv_return_message := substr(sqlerrm,1,1900);
1951: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1952: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.EXCEPTION', G_PKG_NAME || ': '||l_api_name||'()+'||' EXCEPTION Message:'||pv_return_message);
1953: end if;
1954: app_exception.raise_exception (
1955: EXCEPTION_TYPE => 'APP',
1956: EXCEPTION_CODE => -20001 ,

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,