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.

[Home] [Help]

APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on FND_LOG

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

7: --| Modifed cursor c_get_quantity for fetching shipped line quantity. |
8: --+============================================================================================================*/
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_TAX_PROCESSING_PKG';
11: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
14: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
15: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

8: --+============================================================================================================*/
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_TAX_PROCESSING_PKG';
11: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
14: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
15: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_TAX_PROCESSING_PKG';
11: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
14: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
15: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
17: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_OM_TAX_PROCESSING_PKG';
11: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
14: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
15: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
17: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
18: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_TAX_PROCESSING_PKG.';

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

11: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
14: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
15: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
17: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
18: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_TAX_PROCESSING_PKG.';
19:

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

12: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
13: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
14: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
15: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
17: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
18: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_TAX_PROCESSING_PKG.';
19:
20: /*

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

13: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
14: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
15: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
16: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
17: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
18: G_MODULE_NAME CONSTANT VARCHAR2(60) := 'JA.PLSQL.JAI_OM_TAX_PROCESSING_PKG.';
19:
20: /*
21: REM +======================================================================+

Line 251: FND_LOG.STRING(G_LEVEL_STATEMENT,

247:
248: --Skip 'RETURN' type, just process 'RETURN' cycle.
249: IF NVL(p_rec_new.line_category_code, 'RETURN') <> 'ORDER' THEN
250: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
251: FND_LOG.STRING(G_LEVEL_STATEMENT,
252: G_MODULE_NAME || v_api_name,
253: ' This procedure just process type is ORDER, skip it for line_id' || p_rec_new.line_id);
254: END IF;
255: px_return_code := jai_constants.successful ;

Line 277: FND_LOG.STRING(G_LEVEL_STATEMENT,

273: CLOSE c_ja_in_so_tax_lines_tax_amt;
274:
275: IF NVL(v_line_tax_amount,0) <> NVL(v_sum_tax_amount,0) THEN
276: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
277: FND_LOG.STRING(G_LEVEL_STATEMENT,
278: G_MODULE_NAME || v_api_name,
279: ' Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || p_rec_new.line_id);
280: END IF;
281: px_return_code := jai_constants.expected_error ;

Line 332: FND_LOG.STRING(G_LEVEL_STATEMENT,

328: CLOSE cur_chk_excise_exists ;
329:
330: IF nvl (ln_exc_cnt,0) > 0 AND nvl(v_exe_flag,'N') = 'N' THEN
331: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.STRING(G_LEVEL_STATEMENT,
333: G_MODULE_NAME || v_api_name,
334: 'An item which is not Excisable has Excise Taxes attached.' ||
335: 'Please correct the item attribute or remove the Excise type of taxes');
336: END IF;

Line 367: FND_LOG.STRING(G_LEVEL_STATEMENT,

363: CLOSE c_orgn_null_site_info;
364:
365: IF NVL(lv_allow_shipment_wo_excise,'N') = 'Y' THEN
366: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
367: FND_LOG.STRING(G_LEVEL_STATEMENT,
368: G_MODULE_NAME || v_api_name,
369: ' Delivery can not be ship confirmed as Excisable Item in the shipment does not have Excise taxes');
370: END IF;
371: raise_application_error(-20412, 'Delivery can not be ship confirmed as Excisable Item in the shipment does not have Excise taxes' );

Line 377: FND_LOG.STRING(G_LEVEL_STATEMENT,

373: END IF;
374:
375: IF v_location_id IS NULL and v_container_item_flag ='N' and lv_inventory_item_flag = 'Y' then
376: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
377: FND_LOG.STRING(G_LEVEL_STATEMENT,
378: G_MODULE_NAME || v_api_name,
379: ' Mandatory India Localization Sub-inventory Setup not done for this Location from where shipment is made');
380: END IF;
381: px_return_code := jai_constants.expected_error ;

Line 412: FND_LOG.STRING(G_LEVEL_STATEMENT,

408: || For vat regime organization-location specific setup does not exist in
409: || jai_rgm_parties (Regime Organization Registration)
410: */
411: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(G_LEVEL_STATEMENT,
413: G_MODULE_NAME || v_api_name,
414: ' Organization-Location setup does not exist at regime level');
415: END IF;
416: app_exception.raise_exception( EXCEPTION_TYPE => 'APP'

Line 458: FND_LOG.STRING(G_LEVEL_STATEMENT,

454: /*
455: ||item is not vatable
456: */
457: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
458: FND_LOG.STRING(G_LEVEL_STATEMENT,
459: G_MODULE_NAME || v_api_name,
460: ' An item which is not Vatable has VAT Taxes attached.Please correct the item attribute or remove the VAT type of taxes');
461: END IF;
462: app_exception.raise_exception( EXCEPTION_TYPE => 'APP'

Line 468: FND_LOG.STRING(G_LEVEL_STATEMENT,

464: ,EXCEPTION_TEXT => 'An item which is not Vatable has VAT Taxes attached.Please correct the item attribute or remove the VAT type of taxes'
465: );
466: ELSIF lv_process_flag <> jai_constants.successful THEN
467: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(G_LEVEL_STATEMENT,
469: G_MODULE_NAME || v_api_name,
470: lv_process_message);
471: END IF;
472: app_exception.raise_exception( EXCEPTION_TYPE => 'APP'

Line 492: FND_LOG.STRING(G_LEVEL_STATEMENT,

488: IF lv_process_flag = jai_constants.expected_error OR
489: lv_process_flag = jai_constants.unexpected_error
490: THEN
491: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.STRING(G_LEVEL_STATEMENT,
493: G_MODULE_NAME || v_api_name,
494: lv_process_message);
495: END IF;
496: raise le_error;

Line 757: FND_LOG.STRING(G_LEVEL_STATEMENT,

753: pr_header_info.conv_type_code,
754: pr_header_info.conv_rate);
755:
756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.STRING(G_LEVEL_STATEMENT,
758: G_MODULE_NAME || v_api_name,
759: ' jai_om_tax_pkg.calculate_ato_taxes :' ||
760: TO_CHAR(pr_order_line.header_id) || ' ~ ' ||
761: TO_CHAR(pr_order_line.line_id));

Line 2639: FND_LOG.STRING(G_LEVEL_STATEMENT,

2635: INTO v_source_order_category_code;
2636: CLOSE source_order_doc_cur;
2637:
2638: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2639: FND_LOG.STRING(G_LEVEL_STATEMENT,
2640: G_MODULE_NAME || v_api_name,
2641: ' Order header category code ~ Line category code :' ||
2642: v_source_order_category_code || ' ~ ' ||
2643: v_line_category_code);

Line 2807: FND_LOG.STRING(G_LEVEL_STATEMENT,

2803: END IF;
2804: END IF;
2805:
2806: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2807: FND_LOG.STRING(G_LEVEL_STATEMENT,
2808: G_MODULE_NAME || v_api_name,
2809: ' v_transaction_name ' || v_transaction_name);
2810: END IF;
2811: -- Else if the line is a fresh line , Unsplitted

Line 2849: FND_LOG.STRING(G_LEVEL_STATEMENT,

2845:
2846: ln_vat_assessable_value := nvl(ln_vat_assessable_value, 0) * NVL(pr_order_line.ordered_quantity, 0);
2847:
2848: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2849: FND_LOG.STRING(G_LEVEL_STATEMENT,
2850: G_MODULE_NAME || v_api_name,
2851: ' v_assessable_value' || v_assessable_value);
2852: END IF;
2853:

Line 2863: FND_LOG.STRING(G_LEVEL_STATEMENT,

2859: IF ((v_line_category_code = 'ORDER') OR
2860: (v_transaction_name = 'RMA_LEGACY_INSERT')) THEN
2861:
2862: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2863: FND_LOG.STRING(G_LEVEL_STATEMENT,
2864: G_MODULE_NAME || v_api_name,
2865: ' inside IF OF v_line_category_code IN (ORDER) OR v_transaction_name = RMA_LEGACY_INSERT');
2866: END IF;
2867:

Line 2870: FND_LOG.STRING(G_LEVEL_STATEMENT,

2866: END IF;
2867:
2868: IF NVL(pr_order_line.ship_to_ORG_id, 0) <> NVL(pr_old_line.ship_to_ORG_id, 0) THEN
2869: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2870: FND_LOG.STRING(G_LEVEL_STATEMENT,
2871: G_MODULE_NAME || v_api_name,
2872: ' BEFORE DELETING WHEN ship TO org has changed');
2873: END IF;
2874:

Line 2886: FND_LOG.STRING(G_LEVEL_STATEMENT,

2882: END IF;
2883: END IF;
2884:
2885: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2886: FND_LOG.STRING(G_LEVEL_STATEMENT,
2887: G_MODULE_NAME || v_api_name,
2888: ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes ');
2889: END IF;
2890:

Line 2892: FND_LOG.STRING(G_LEVEL_STATEMENT,

2888: ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes ');
2889: END IF;
2890:
2891: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2892: FND_LOG.STRING(G_LEVEL_STATEMENT,
2893: G_MODULE_NAME || v_api_name,
2894: ' Before calling jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes:' ||
2895: ' pr_order_line.SHIP_FROM_ORG_ID:' || pr_order_line.SHIP_FROM_ORG_ID ||
2896: ' customer_id: ' || pr_header_info.customer_id ||

Line 2913: FND_LOG.STRING(G_LEVEL_STATEMENT,

2909: v_tax_category_id);
2910: IF v_tax_category_id IS NULL THEN
2911:
2912: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2913: FND_LOG.STRING(G_LEVEL_STATEMENT,
2914: G_MODULE_NAME || v_api_name,
2915: ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes ');
2916: END IF;
2917:

Line 2919: FND_LOG.STRING(G_LEVEL_STATEMENT,

2915: ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes ');
2916: END IF;
2917:
2918: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2919: FND_LOG.STRING(G_LEVEL_STATEMENT,
2920: G_MODULE_NAME || v_api_name,
2921: ' Tax category id is null, then call jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes:' ||
2922: ' pr_order_line.SHIP_FROM_ORG_ID:' || pr_order_line.SHIP_FROM_ORG_ID ||
2923: ' pr_order_line.inventory_item_id: ' ||

Line 2933: FND_LOG.STRING(G_LEVEL_STATEMENT,

2929:
2930: ELSE
2931: /* elsif of v_tax_category_id IS NULL */
2932: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2933: FND_LOG.STRING(G_LEVEL_STATEMENT,
2934: G_MODULE_NAME || v_api_name,
2935: ' BEFORE setting v_line_tax_amount := p_line_amount ');
2936: END IF;
2937: v_line_tax_amount := v_line_amount;

Line 2943: FND_LOG.STRING(G_LEVEL_STATEMENT,

2939:
2940: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2941:
2942: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2943: FND_LOG.STRING(G_LEVEL_STATEMENT,
2944: G_MODULE_NAME || v_api_name,
2945: ' inside IF OF RMA_LEGACY_INSERT ');
2946: END IF;
2947:

Line 2956: FND_LOG.STRING(G_LEVEL_STATEMENT,

2952:
2953: ELSE
2954: --14
2955: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2956: FND_LOG.STRING(G_LEVEL_STATEMENT,
2957: G_MODULE_NAME || v_api_name,
2958: ' inside ELSE OF RMA_LEGACY_INSERT ');
2959: END IF;
2960:

Line 2970: FND_LOG.STRING(G_LEVEL_STATEMENT,

2966:
2967: IF v_so_tax_lines_count = 0 THEN
2968:
2969: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2970: FND_LOG.STRING(G_LEVEL_STATEMENT,
2971: G_MODULE_NAME || v_api_name,
2972: ' inside IF OF v_so_tax_lines_count = 0 ');
2973: END IF;
2974:

Line 2976: FND_LOG.STRING(G_LEVEL_STATEMENT,

2972: ' inside IF OF v_so_tax_lines_count = 0 ');
2973: END IF;
2974:
2975: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2976: FND_LOG.STRING(G_LEVEL_STATEMENT,
2977: G_MODULE_NAME || v_api_name,
2978: ' If v_so_tax_lines_count = 0, then call jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes:' ||
2979: ' p_transaction_name:' || v_transaction_name ||
2980: ' p_tax_category_id:' || v_tax_category_id ||

Line 3016: FND_LOG.STRING(G_LEVEL_STATEMENT,

3012:
3013: IF V_SHIPMENT_SCHEDULE_LINE_ID IS NULL THEN
3014:
3015: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3016: FND_LOG.STRING(G_LEVEL_STATEMENT,
3017: G_MODULE_NAME || v_api_name,
3018: ' inside IF OF V_SHIPMENT_SCHEDULE_LINE_ID IS NULL ');
3019: END IF;
3020:

Line 3036: FND_LOG.STRING(G_LEVEL_STATEMENT,

3032:
3033: IF v_so_lines_count = 0 THEN
3034:
3035: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3036: FND_LOG.STRING(G_LEVEL_STATEMENT,
3037: G_MODULE_NAME || v_api_name,
3038: ' inside IF OF v_so_lines_count = 0 ');
3039: END IF;
3040: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN

Line 3043: FND_LOG.STRING(G_LEVEL_STATEMENT,

3039: END IF;
3040: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3041:
3042: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3043: FND_LOG.STRING(G_LEVEL_STATEMENT,
3044: G_MODULE_NAME || v_api_name,
3045: 'BEFORE opening return_tax_amount_Cur ');
3046: END IF;
3047: OPEN return_tax_amount_Cur(pr_order_line.header_id, pr_order_line.LINE_ID);

Line 3059: FND_LOG.STRING(G_LEVEL_STATEMENT,

3055: CLOSE order_tax_amount_Cur;
3056: END IF;
3057:
3058: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3059: FND_LOG.STRING(G_LEVEL_STATEMENT,
3060: G_MODULE_NAME || v_api_name,
3061: ' Total tax : ' || v_line_tax_amount);
3062: END IF;
3063:

Line 3067: FND_LOG.STRING(G_LEVEL_STATEMENT,

3063:
3064: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3065:
3066: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3067: FND_LOG.STRING(G_LEVEL_STATEMENT,
3068: G_MODULE_NAME || v_api_name,
3069: ' BEFORE INSERTING RECORD INTO JAI_OM_OE_RMA_LINES ');
3070: END IF;
3071: INSERT INTO JAI_OM_OE_RMA_LINES

Line 3110: FND_LOG.STRING(G_LEVEL_STATEMENT,

3106: pr_order_line.ship_to_org_id);
3107: ELSE
3108: /* else if of v_transaction_name = 'RMA_LEGACY_INSERT' */
3109: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3110: FND_LOG.STRING(G_LEVEL_STATEMENT,
3111: G_MODULE_NAME || v_api_name,
3112: ' BEFORE INSERTING RECORD INTO JAI_OM_OE_SO_LINES ');
3113: END IF;
3114:

Line 3279: FND_LOG.STRING(G_LEVEL_STATEMENT,

3275:
3276: For model_rec in c_model_taxes Loop
3277:
3278: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3279: FND_LOG.STRING(G_LEVEL_STATEMENT,
3280: G_MODULE_NAME || v_api_name,
3281: 'In the Loop Header ID ~ Line ID :' ||
3282: TO_CHAR(pr_order_line.header_id) || ' ~ ' ||
3283: TO_CHAR(pr_order_line.line_id));

Line 3684: FND_LOG.STRING(G_LEVEL_STATEMENT,

3680: END IF;
3681: END LOOP; --FOR Rec IN So_Tax_Lines_Cur( pr_order_line.header_id, pr_order_line.SPLIT_FROM_LINE_ID)
3682:
3683: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3684: FND_LOG.STRING(G_LEVEL_STATEMENT,
3685: G_MODULE_NAME || v_api_name,
3686: '** START OForder_tax_amount_Cur ' ||
3687: pr_order_line.header_id || ' line id ' || pr_order_line.line_id);
3688: END IF;

Line 3695: FND_LOG.STRING(G_LEVEL_STATEMENT,

3691: INTO v_header_tax_amount;
3692: CLOSE order_tax_amount_Cur;
3693:
3694: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3695: FND_LOG.STRING(G_LEVEL_STATEMENT,
3696: G_MODULE_NAME || v_api_name,
3697: '** v_header_tax_amount ' || v_header_tax_amount);
3698: END IF;
3699: update JAI_OM_OE_SO_LINES

Line 3787: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3783: v_hook VARCHAR2(6);
3784:
3785: BEGIN
3786:
3787: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3788: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3789: G_MODULE_NAME || v_api_name || '.BEGIN',
3790: G_PKG_NAME || ': ' || v_api_name || '()+');
3791: END IF;

Line 3788: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3784:
3785: BEGIN
3786:
3787: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3788: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3789: G_MODULE_NAME || v_api_name || '.BEGIN',
3790: G_PKG_NAME || ': ' || v_api_name || '()+');
3791: END IF;
3792:

Line 3836: FND_LOG.STRING(G_LEVEL_STATEMENT,

3832: RETURN;
3833: END IF;
3834:
3835: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3836: FND_LOG.STRING(G_LEVEL_STATEMENT,
3837: G_MODULE_NAME || v_api_name,
3838: '** START OF POPULATE_TAX ~ ' ||
3839: TO_CHAR(SYSDATE, 'dd/mm/rrrr hh24:mi:ss'));
3840: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 3840: FND_LOG.STRING(G_LEVEL_STATEMENT,

3836: FND_LOG.STRING(G_LEVEL_STATEMENT,
3837: G_MODULE_NAME || v_api_name,
3838: '** START OF POPULATE_TAX ~ ' ||
3839: TO_CHAR(SYSDATE, 'dd/mm/rrrr hh24:mi:ss'));
3840: FND_LOG.STRING(G_LEVEL_STATEMENT,
3841: G_MODULE_NAME || v_api_name,
3842: ' Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) ||
3843: ' ~ ' || TO_CHAR(pr_new.line_id));
3844: END IF;

Line 3871: FND_LOG.STRING(G_LEVEL_STATEMENT,

3867: pr_new.return_context IS NOT NULL) AND
3868: NVL(pr_new.SOURCE_DOCUMENT_TYPE_ID, 0) <> 2 THEN
3869:
3870: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3871: FND_LOG.STRING(G_LEVEL_STATEMENT,
3872: G_MODULE_NAME || v_api_name,
3873: ' Returning at STANDARD , RETURN, pr_new.SOURCE_DOCUMENT_TYPE_ID');
3874: FND_LOG.STRING(G_LEVEL_STATEMENT,
3875: G_MODULE_NAME || v_api_name,

Line 3874: FND_LOG.STRING(G_LEVEL_STATEMENT,

3870: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3871: FND_LOG.STRING(G_LEVEL_STATEMENT,
3872: G_MODULE_NAME || v_api_name,
3873: ' Returning at STANDARD , RETURN, pr_new.SOURCE_DOCUMENT_TYPE_ID');
3874: FND_LOG.STRING(G_LEVEL_STATEMENT,
3875: G_MODULE_NAME || v_api_name,
3876: '** END OF POPULATE_TAX ~ ' ||
3877: TO_CHAR(SYSDATE, 'dd/mm/rrrr hh24:mi:ss'));
3878: END IF;

Line 3938: FND_LOG.STRING(G_LEVEL_STATEMENT,

3934: px_return_message => pv_return_message);*/
3935: -- commented out by zhiwei.xin for Trigger Replacement bug #15968958 on 20-Dec-2012 end.
3936:
3937: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3938: FND_LOG.STRING(G_LEVEL_STATEMENT,
3939: G_MODULE_NAME || v_api_name,
3940: '** SUCCESSFUL END OF POPULATE_TAX ~ ' ||
3941: TO_CHAR(SYSDATE, 'DD/mm/rrrr hh24:mi:ss'));
3942: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 3942: FND_LOG.STRING(G_LEVEL_STATEMENT,

3938: FND_LOG.STRING(G_LEVEL_STATEMENT,
3939: G_MODULE_NAME || v_api_name,
3940: '** SUCCESSFUL END OF POPULATE_TAX ~ ' ||
3941: TO_CHAR(SYSDATE, 'DD/mm/rrrr hh24:mi:ss'));
3942: FND_LOG.STRING(G_LEVEL_STATEMENT,
3943: G_MODULE_NAME || v_api_name,
3944: 'Header ID ~ Line ID :' ||
3945: TO_CHAR(pr_new.header_id) || ' ~ ' ||
3946: TO_CHAR(pr_new.line_id));

Line 3949: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3945: TO_CHAR(pr_new.header_id) || ' ~ ' ||
3946: TO_CHAR(pr_new.line_id));
3947: END IF;
3948:
3949: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3950: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3951: G_MODULE_NAME || v_api_name || '.END',
3952: G_PKG_NAME || ': ' || v_api_name || '()-' ||
3953: ' RETURN_CODE = ' || pv_return_code);

Line 3950: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3946: TO_CHAR(pr_new.line_id));
3947: END IF;
3948:
3949: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3950: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3951: G_MODULE_NAME || v_api_name || '.END',
3952: G_PKG_NAME || ': ' || v_api_name || '()-' ||
3953: ' RETURN_CODE = ' || pv_return_code);
3954: END IF;

Line 3960: FND_LOG.STRING(G_LEVEL_ERROR,

3956: EXCEPTION
3957: WHEN OTHERS THEN
3958:
3959: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3960: FND_LOG.STRING(G_LEVEL_ERROR,
3961: G_MODULE_NAME || v_api_name,
3962: 'Header ID ~ Line ID :' ||
3963: TO_CHAR(pr_new.header_id) || ' ~ ' ||
3964: TO_CHAR(pr_new.line_id));

Line 3965: FND_LOG.STRING(G_LEVEL_ERROR,

3961: G_MODULE_NAME || v_api_name,
3962: 'Header ID ~ Line ID :' ||
3963: TO_CHAR(pr_new.header_id) || ' ~ ' ||
3964: TO_CHAR(pr_new.line_id));
3965: FND_LOG.STRING(G_LEVEL_ERROR,
3966: G_MODULE_NAME || v_api_name,
3967: 'Error :' || SQLERRM);
3968: FND_LOG.STRING(G_LEVEL_ERROR,
3969: G_MODULE_NAME || v_api_name,

Line 3968: FND_LOG.STRING(G_LEVEL_ERROR,

3964: TO_CHAR(pr_new.line_id));
3965: FND_LOG.STRING(G_LEVEL_ERROR,
3966: G_MODULE_NAME || v_api_name,
3967: 'Error :' || SQLERRM);
3968: FND_LOG.STRING(G_LEVEL_ERROR,
3969: G_MODULE_NAME || v_api_name,
3970: '** Error END OF POPULATE_TAX ~ ' ||
3971: TO_CHAR(SYSDATE, 'DD/mm/rrrr hh24:mi:ss'));
3972: END IF;

Line 3978: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

3974: Pv_return_code := jai_constants.unexpected_error;
3975: Pv_return_message := 'Encountered an error in JAI_OM_TAX_PROCESSING_PKG.POPULATE_TAX ' ||
3976: substr(sqlerrm, 1, 1900);
3977: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3978: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
3979: G_MODULE_NAME || v_api_name,
3980: SQLERRM);
3981: END IF;
3982:

Line 4154: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4150:
4151: END get_config_item;
4152:
4153: BEGIN
4154: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4155: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4156: G_MODULE_NAME || v_api_name || '.BEGIN',
4157: G_PKG_NAME || ': ' || v_api_name || '()+');
4158: END IF;

Line 4155: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4151: END get_config_item;
4152:
4153: BEGIN
4154: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4155: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4156: G_MODULE_NAME || v_api_name || '.BEGIN',
4157: G_PKG_NAME || ': ' || v_api_name || '()+');
4158: END IF;
4159: pv_return_code := jai_constants.successful;

Line 4449: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4445: WHERE rma_line_id = v_line_id;
4446:
4447: END IF;
4448:
4449: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4450: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4451: G_MODULE_NAME || v_api_name || '.END',
4452: G_PKG_NAME || ': ' || v_api_name || '()-' ||
4453: ' RETURN_CODE = ' || pv_return_code);

Line 4450: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4446:
4447: END IF;
4448:
4449: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4450: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4451: G_MODULE_NAME || v_api_name || '.END',
4452: G_PKG_NAME || ': ' || v_api_name || '()-' ||
4453: ' RETURN_CODE = ' || pv_return_code);
4454: END IF;

Line 4461: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

4457: Pv_return_code := jai_constants.unexpected_error;
4458: Pv_return_message := 'Encountered an error in JAI_OM_TAX_PROCESSING_PKG.UPDATE_TAX ' ||
4459: substr(sqlerrm, 1, 1900);
4460: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4461: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
4462: G_MODULE_NAME || v_api_name,
4463: SQLERRM);
4464: END IF;
4465:

Line 4565: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4561: lv_allow_sales_flag varchar2(1);
4562: ln_excise_duty_per_unit number;
4563: ln_excise_duty_rate number;
4564: BEGIN
4565: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4566: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4567: G_MODULE_NAME || v_api_name || '.BEGIN',
4568: G_PKG_NAME || ': ' || v_api_name || '()+');
4569: END IF;

Line 4566: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4562: ln_excise_duty_per_unit number;
4563: ln_excise_duty_rate number;
4564: BEGIN
4565: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4566: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4567: G_MODULE_NAME || v_api_name || '.BEGIN',
4568: G_PKG_NAME || ': ' || v_api_name || '()+');
4569: END IF;
4570:

Line 4735: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4731: pr_new.line_category_code
4732: );
4733:
4734:
4735: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4736: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4737: G_MODULE_NAME || v_api_name || '.END',
4738: G_PKG_NAME || ': ' || v_api_name || '()-' ||
4739: ' RETURN_CODE = ' || pv_return_code);

Line 4736: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4732: );
4733:
4734:
4735: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4736: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4737: G_MODULE_NAME || v_api_name || '.END',
4738: G_PKG_NAME || ': ' || v_api_name || '()-' ||
4739: ' RETURN_CODE = ' || pv_return_code);
4740: END IF;

Line 4747: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

4743: Pv_return_code := jai_constants.unexpected_error;
4744: Pv_return_message := 'Encountered an error in JAI_OM_TAX_PROCESSING_PKG.DEFAULT_TAX ' ||
4745: substr(sqlerrm, 1, 1900);
4746: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4747: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
4748: G_MODULE_NAME || v_api_name,
4749: SQLERRM);
4750: END IF;
4751: