DBA Data[Home] [Help]

APPS.JAI_AR_TAX_LINES_PKG dependencies on FND_LOG

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

1: PACKAGE BODY JAI_AR_TAX_LINES_PKG AS
2: /* $Header: jai_ar_tax_lines.plb 120.0.12020000.2 2013/03/19 00:23:55 vkaranam noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

1: PACKAGE BODY JAI_AR_TAX_LINES_PKG AS
2: /* $Header: jai_ar_tax_lines.plb 120.0.12020000.2 2013/03/19 00:23:55 vkaranam noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

2: /* $Header: jai_ar_tax_lines.plb 120.0.12020000.2 2013/03/19 00:23:55 vkaranam noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TAX_LINES_PKG.';

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

4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TAX_LINES_PKG.';
12:

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

5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TAX_LINES_PKG.';
12:
13: /********************************************************************************************************

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

6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TAX_LINES_PKG.';
12:
13: /********************************************************************************************************
14: FILENAME : jai_ar_tax_lines.plb

Line 326: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);

322: BEGIN
323:
324: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
325: lv_debug_info := 'JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_TEMP.BEGIN';
326: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);
327: END IF;
328: pv_return_code := jai_constants.successful;
329: /*------------------------------------------------------------------------------------------
330: FILENAME: jai_ar_tax_lines.plb

Line 565: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'v_customer_trx_id = ');

561: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
562: lv_debug_info := 'v_customer_trx_id = '|| v_customer_trx_id||
563: ', v_customer_trx_line_id = '|| v_customer_trx_line_id||
564: ', lv_trx_type = '|| lv_trx_type;
565: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'v_customer_trx_id = ');
566: END IF;
567: -------------------------------------------
568: --Added by Wenqiong for Bug 14253668 end
569: lb_is_accrual_basis := JAI_CMN_UTILS_PKG.IS_ACCRUAL_BASIS(ln_regime_id,

Line 577: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'v_customer_trx_id = ');

573: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
574: lv_debug_info := 'v_customer_trx_id = '|| v_customer_trx_id||
575: ', v_customer_trx_line_id = '|| v_customer_trx_line_id||
576: ', ld';
577: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'v_customer_trx_id = ');
578: END IF;
579:
580: IF lb_is_accrual_basis THEN
581: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668

Line 589: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get accrual basis account for service tax, liability account ccid is '|| v_ccid);

585: p_location_id => v_location_id,
586: p_tax_type => tax_type_rec.t_type,
587: p_account_name => jai_constants.liability);
588: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get accrual basis account for service tax, liability account ccid is '|| v_ccid);
590: END IF;
591: --Added by Wenqiong for Bug 14253668 begin
592: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
593: v_ccid := jai_cmn_rgm_recording_pkg.get_account (

Line 612: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get cash basis account for service tax, liability interim account ccid is '|| v_ccid);

608: p_location_id => v_location_id,
609: p_tax_type => tax_type_rec.t_type,
610: p_account_name => jai_constants.liability_interim);
611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get cash basis account for service tax, liability interim account ccid is '|| v_ccid);
613: END IF;
614: --Added by Wenqiong for Bug 14253668 begin
615: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
616: v_ccid := jai_cmn_rgm_recording_pkg.get_account (

Line 949: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);

945: END IF;
946: END IF;
947: lv_debug_info := 'JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_TEMP.END';
948: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);
950: END IF;
951: EXCEPTION
952: WHEN OTHERS THEN
953: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN

Line 955: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME || lv_api_name,lv_debug_info);

951: EXCEPTION
952: WHEN OTHERS THEN
953: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
954: lv_debug_info := substr('Error occurred in JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_TEMP. '||sqlerrm,1,4000);
955: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME || lv_api_name,lv_debug_info);
956: END IF;
957: RAISE le;
958: END POPULATE_TAX_LINES_TEMP;
959:

Line 987: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);

983: le EXCEPTION;
984: BEGIN
985: lv_debug_info := 'JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER.BEGIN';
986: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);
988: END IF;
989: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_TEMP(pr_old,
990: pr_new,
991: pv_action,

Line 1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);

1004:
1005: lv_debug_info := substr('End calling POPULATE_TAX_LINES_TEMP. lv_return_code = '||
1006: lv_return_code||', lv_return_message = '|| lv_return_message,1,4000);
1007: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);
1009: END IF;
1010:
1011: IF lv_return_code = JAI_CONSTANTS.SUCCESSFUL AND
1012: lv_created_from = 'ARXTWMAI' AND ln_tax_exists = 1 THEN

Line 1021: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);

1017: END IF;
1018:
1019: lv_debug_info := 'JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER.END';
1020: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1021: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);
1022: END IF;
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN

Line 1027: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME || lv_api_name,lv_debug_info);

1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
1026: lv_debug_info := substr('Error calling POPULATE_TAX_LINES_WRAPPER. '|| sqlerrm,1,4000);
1027: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME || lv_api_name,lv_debug_info);
1028: END IF;
1029: RAISE le;
1030: END POPULATE_TAX_LINES_WRAPPER;
1031:

Line 1086: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'JAI_AR_TAX_LINES_PKG.INSERT_TAX_LINES_TEMP.BEGIN');

1082: 1,
1083: 4000);
1084:
1085: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'JAI_AR_TAX_LINES_PKG.INSERT_TAX_LINES_TEMP.BEGIN');
1087: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1088: G_MODULE_NAME || lv_api_name,
1089: lv_debug_info);
1090:

Line 1087: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1083: 4000);
1084:
1085: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'JAI_AR_TAX_LINES_PKG.INSERT_TAX_LINES_TEMP.BEGIN');
1087: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1088: G_MODULE_NAME || lv_api_name,
1089: lv_debug_info);
1090:
1091: END IF;

Line 1142: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'1 record inserted into table JAI_AR_TRX_INS_LINES_T.');

1138: pv_source,
1139: pn_org_id,
1140: pn_line_number);
1141: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1142: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'1 record inserted into table JAI_AR_TRX_INS_LINES_T.');
1143: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'JAI_AR_TAX_LINES_PKG.INSERT_TAX_LINES_TEMP.END');
1144: END IF;
1145: EXCEPTION
1146: WHEN OTHERS THEN

Line 1143: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'JAI_AR_TAX_LINES_PKG.INSERT_TAX_LINES_TEMP.END');

1139: pn_org_id,
1140: pn_line_number);
1141: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1142: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'1 record inserted into table JAI_AR_TRX_INS_LINES_T.');
1143: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'JAI_AR_TAX_LINES_PKG.INSERT_TAX_LINES_TEMP.END');
1144: END IF;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN

Line 1148: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

1144: END IF;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
1148: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
1149: G_MODULE_NAME || lv_api_name,
1150: substr('Error inserting table JAI_AR_TRX_INS_LINES_T. ' ||
1151: sqlerrm,1,4000));
1152: END IF;