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.JE_ES_MODELO_EXT_PKG dependencies on FND_FILE

Line 730: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'inserting with tipo 3: p_cust_tax_reg_num=' ||p_cust_tax_reg_num); END IF;

726: INTO arrenda_rec.trx_line_amt
727: FROM DUAL;
728: */
729:
730: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'inserting with tipo 3: p_cust_tax_reg_num=' ||p_cust_tax_reg_num); END IF;
731:
732: -- dbms_output.put_line ('inserting ');
733: INSERT INTO JG_ZZ_VAT_TRX_GT
734: ( jg_info_v1 -- tipo

Line 1524: fnd_file.put_line(FND_FILE.LOG,'G_MIN_VALUE1 :'||G_MIN_VALUE);

1520: that should also be deleted */
1521: PROCEDURE MOD347_MIN_AMOUNT ( p_tipo IN VARCHAR2 ) IS
1522:
1523: BEGIN
1524: fnd_file.put_line(FND_FILE.LOG,'G_MIN_VALUE1 :'||G_MIN_VALUE);
1525: UPDATE JG_ZZ_VAT_TRX_GT JZVTG
1526: SET JZVTG.jg_info_n4 = 1
1527: WHERE JZVTG.jg_info_v11 IN (
1528: SELECT JZVTG1.jg_info_v11

Line 2068: fnd_file.put_line(FND_FILE.LOG,'Executing before_report');

2064:
2065: BEGIN
2066:
2067: -- dbms_output.put_line ('Executing before_report');
2068: fnd_file.put_line(FND_FILE.LOG,'Executing before_report');
2069: g_min_value := fnd_number.canonical_to_number(P_MIN_VALUE);
2070: -- dbms_output.put_line ('Calling funct_curr_legal');
2071:
2072: -- Start: BUG 9765740 Spanish Modelo 349 ESL EPL Changes

Line 2131: fnd_file.put_line(FND_FILE.LOG,'Fetching periods in a string');

2127:
2128:
2129: If p_tax_Period is not null Then
2130: If G_DEBUG Then
2131: fnd_file.put_line(FND_FILE.LOG,'Fetching periods in a string');
2132: End If;
2133: For C_Tax_Periods_Rec in C_Tax_Periods Loop
2134: If l_period_count = 0 Then
2135: l_period_string := '(''' || C_Tax_Periods_Rec.tax_calendar_period ||'''';

Line 2145: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'l_period_string: '|| l_period_string); END IF;

2141: End Loop;
2142: l_period_string := l_period_string || ')';
2143: End If;
2144:
2145: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'l_period_string: '|| l_period_string); END IF;
2146:
2147:
2148: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.funct_curr_legal'); END IF;
2149:

Line 2148: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.funct_curr_legal'); END IF;

2144:
2145: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'l_period_string: '|| l_period_string); END IF;
2146:
2147:
2148: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.funct_curr_legal'); END IF;
2149:
2150: jg_zz_common_pkg.funct_curr_legal( lc_func_curr_code
2151: , lc_rep_legal_entity
2152: , ln_rep_legal_entity_id

Line 2159: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.tax_registration'); END IF;

2155: , p_tax_period
2156: , p_tax_year
2157: );
2158: -- dbms_output.put_line ('jg_zz_common_pkg.tax_registration');
2159: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.tax_registration'); END IF;
2160:
2161: BEGIN
2162: jg_zz_common_pkg.tax_registration( x_tax_registration => lc_trx_num
2163: , x_period_start_date => ld_period_start_date

Line 2173: fnd_file.put_line(FND_FILE.LOG,'Getting the Period End ');

2169: , pv_source => P_SOURCE
2170: );
2171: If p_tax_period_to is not null Then
2172: If G_DEBUG THEN
2173: fnd_file.put_line(FND_FILE.LOG,'Getting the Period End ');
2174: End If;
2175: If C_End_Date%IsOpen Then
2176: Close C_End_Date;
2177: End IF;

Line 2189: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.company_detail'); END IF;

2185: WHEN OTHERS THEN
2186: NULL;
2187: END;
2188: -- dbms_output.put_line ('jg_zz_common_pkg.tax_registration');
2189: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.company_detail'); END IF;
2190:
2191: jg_zz_common_pkg.company_detail(x_company_name => lc_company_name
2192: ,x_registration_number => lc_registration_number
2193: ,x_country => lc_country

Line 2210: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'JG_ZZ_VAT_REP_UTILITY.get_period_status'); END IF;

2206: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
2207:
2208:
2209:
2210: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'JG_ZZ_VAT_REP_UTILITY.get_period_status'); END IF;
2211:
2212: -- Fetch the reporting mode only if the report name is not null
2213: IF P_REPORT_NAME IS NOT NULL and p_tax_year is not null
2214: AND p_modelo <> '340' THEN

Line 2223: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'lc_reporting_mode: '||lc_reporting_mode); END IF;

2219: ,pv_report_name => P_REPORT_NAME||':'||P_MODELO);
2220: ELSE
2221: lc_reporting_mode := NULL;
2222: END IF;
2223: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'lc_reporting_mode: '||lc_reporting_mode); END IF;
2224:
2225: G_CURRENCY_CODE := lc_func_curr_code;
2226: /* bug 5729082 start */
2227: /* Bug 10354561 commented below line and added a new condition for 349 template*/

Line 2240: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'SELECT precision INTO G_CUR_PRECISION'); END IF;

2236: G_LE_NAME := lc_rep_legal_entity;
2237: G_FROM_DATE := ld_period_start_date;
2238: G_TO_DATE := ld_period_end_date;
2239: -- dbms_output.put_line ('SELECT precision INTO G_CUR_PRECISION');
2240: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'SELECT precision INTO G_CUR_PRECISION'); END IF;
2241:
2242: BEGIN
2243: SELECT precision
2244: INTO G_CUR_PRECISION

Line 2252: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'G_CUR_PRECISION: '||G_CUR_PRECISION); END IF;

2248: WHEN NO_DATA_FOUND THEN
2249: NULL;
2250: END;
2251:
2252: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'G_CUR_PRECISION: '||G_CUR_PRECISION); END IF;
2253:
2254: -- dbms_output.put_line ('P_REPORT_NAME:'||P_REPORT_NAME);
2255: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'P_REPORT_NAME:'||P_REPORT_NAME); END IF;
2256:

Line 2255: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'P_REPORT_NAME:'||P_REPORT_NAME); END IF;

2251:
2252: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'G_CUR_PRECISION: '||G_CUR_PRECISION); END IF;
2253:
2254: -- dbms_output.put_line ('P_REPORT_NAME:'||P_REPORT_NAME);
2255: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'P_REPORT_NAME:'||P_REPORT_NAME); END IF;
2256:
2257: IF P_REPORT_NAME = 'JEESAMOR' AND P_MODELO = '347' THEN
2258: /* Header record information */
2259: lc_address1 := SUBSTR( lc_address1, 1,2);

Line 2279: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'BEFORE INSERT HEADER'); END IF;

2275: lc_company_name := SUBSTR(lc_company_name,1,40);
2276: lc_city := SUBSTR(lc_city,1,24);
2277: END IF;
2278: -- dbms_output.put_line ('BEFORE INSERT HEADER');
2279: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'BEFORE INSERT HEADER'); END IF;
2280:
2281: INSERT INTO JG_ZZ_VAT_TRX_GT
2282: (jg_info_v1 -- curr_code
2283: ,jg_info_v2 -- entity_name

Line 2370: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'AFTER INSERT HEADER'); END IF;

2366: ,P_SUBSTITUTION
2367: ,P_MIN_CASH_AMOUNT_VALUE);
2368:
2369: -- dbms_output.put_line ('AFTER INSERT HEADER');
2370: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'AFTER INSERT HEADER'); END IF;
2371:
2372: /**
2373: author: brathod
2374: date : 23/05/2006

Line 2440: fnd_file.put_line(FND_FILE.LOG,'Updating the C_CORRECTION_TRX_SEL_COLS:3 ');

2436: REPLACE( lv_filter_key
2437: ,'trx_date'
2438: ,'gl_date'
2439: );
2440: fnd_file.put_line(FND_FILE.LOG,'***Updating the C_CORRECTION_TRX_SEL_COLS***:3 ');
2441: C_CORRECTION_TRX_SEL_COLS := REPLACE( C_CORRECTION_TRX_SEL_COLS
2442: ,'TRX_DATE'
2443: ,'GL_DATE'
2444: );

Line 2467: fnd_file.put_line(FND_FILE.LOG,'Updating the C_CORRECTION_TRX_SEL_COLS:2 ');

2463: REPLACE( lv_filter_key
2464: ,'trx_date'
2465: ,'gl_date'
2466: );
2467: fnd_file.put_line(FND_FILE.LOG,'***Updating the C_CORRECTION_TRX_SEL_COLS***:2 ');
2468: C_CORRECTION_TRX_SEL_COLS := REPLACE( C_CORRECTION_TRX_SEL_COLS
2469: ,'TRX_DATE'
2470: ,'GL_DATE'
2471: );

Line 2613: fnd_file.put_line(FND_FILE.LOG,'1.3. bEFORE Merge subquery to include expense reports');

2609:
2610:
2611:
2612: IF G_DEBUG THEN
2613: fnd_file.put_line(FND_FILE.LOG,'1.3. bEFORE Merge subquery to include expense reports');
2614: END IF;
2615:
2616: --
2617: -- Remove semi colon to merge union select

Line 2768: fnd_file.put_line(FND_FILE.LOG,'lv_filter_key :='||lv_filter_key);

2764:
2765: lv_filter_value := p_tax_year;
2766: lv_filter_oper := '=';
2767: end if;
2768: fnd_file.put_line(FND_FILE.LOG,'lv_filter_key :='||lv_filter_key);
2769: lc_jgzz_modelo_query1 :=
2770: REPLACE( lc_jgzz_modelo_query1
2771: , '$FILTER_KEY$'
2772: , lv_filter_key );

Line 2798: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.4. After Merge subquery to inclue expense reports'); END IF;

2794:
2795:
2796: lc_jgzz_modelo_query := lc_jgzz_modelo_query || lc_jgzz_modelo_query1;
2797:
2798: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.4. After Merge subquery to inclue expense reports'); END IF;
2799:
2800:
2801: ELSIF p_modelo = '415' THEN
2802:

Line 2992: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.5. Open the Dynamic Query: '||lc_jgzz_modelo_query ); END IF;

2988: --
2989:
2990: -- INSERT INTO JG_TEMP_TABLE values (Lc_jgzz_modelo_query); -- debug
2991:
2992: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.5. Open the Dynamic Query: '||lc_jgzz_modelo_query ); END IF;
2993:
2994: OPEN c_modelo_ext FOR lc_jgzz_modelo_query ; -- opencur
2995: LOOP
2996:

Line 2997: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.6. Fetch from the Dynamic Query'); END IF;

2993:
2994: OPEN c_modelo_ext FOR lc_jgzz_modelo_query ; -- opencur
2995: LOOP
2996:
2997: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.6. Fetch from the Dynamic Query'); END IF;
2998: G_LINENO := '1.6.1';
2999: FETCH c_modelo_ext
3000: INTO lc_tax_registration_number
3001: ,lc_customer_name

Line 3020: fnd_file.put_line(FND_FILE.LOG,G_LINENO);

3016:
3017:
3018: EXIT WHEN c_modelo_ext%NOTFOUND;
3019: IF G_DEBUG THEN
3020: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3021: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3022: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3023: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3024: END IF;

Line 3021: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);

3017:
3018: EXIT WHEN c_modelo_ext%NOTFOUND;
3019: IF G_DEBUG THEN
3020: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3021: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3022: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3023: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3024: END IF;
3025:

Line 3022: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);

3018: EXIT WHEN c_modelo_ext%NOTFOUND;
3019: IF G_DEBUG THEN
3020: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3021: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3022: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3023: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3024: END IF;
3025:
3026: G_LINENO := '1.6.2';

Line 3023: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);

3019: IF G_DEBUG THEN
3020: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3021: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3022: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3023: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3024: END IF;
3025:
3026: G_LINENO := '1.6.2';
3027: IF P_MODELO = '415' THEN

Line 3050: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);

3046:
3047: G_LINENO := '1.6.2.1';
3048:
3049: IF G_DEBUG THEN
3050: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
3051: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
3052: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
3053: END IF;
3054:

Line 3051: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);

3047: G_LINENO := '1.6.2.1';
3048:
3049: IF G_DEBUG THEN
3050: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
3051: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
3052: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
3053: END IF;
3054:
3055: G_LINENO := '1.6.2.2';

Line 3052: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);

3048:
3049: IF G_DEBUG THEN
3050: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
3051: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
3052: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
3053: END IF;
3054:
3055: G_LINENO := '1.6.2.2';
3056:

Line 3079: fnd_file.put_line(FND_FILE.LOG,G_LINENO);

3075: , x_address_detail => lc_address_detail
3076: , x_country => lc_country
3077: );
3078: IF G_DEBUG THEN
3079: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3080: fnd_file.put_line(FND_FILE.LOG,'lc_customer_address_id='||lc_customer_address_id);
3081: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
3082: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
3083: END IF;

Line 3080: fnd_file.put_line(FND_FILE.LOG,'lc_customer_address_id='||lc_customer_address_id);

3076: , x_country => lc_country
3077: );
3078: IF G_DEBUG THEN
3079: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3080: fnd_file.put_line(FND_FILE.LOG,'lc_customer_address_id='||lc_customer_address_id);
3081: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
3082: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
3083: END IF;
3084:

Line 3081: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);

3077: );
3078: IF G_DEBUG THEN
3079: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3080: fnd_file.put_line(FND_FILE.LOG,'lc_customer_address_id='||lc_customer_address_id);
3081: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
3082: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
3083: END IF;
3084:
3085: G_LINENO := '1.6.2.5';

Line 3082: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);

3078: IF G_DEBUG THEN
3079: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3080: fnd_file.put_line(FND_FILE.LOG,'lc_customer_address_id='||lc_customer_address_id);
3081: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
3082: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
3083: END IF;
3084:
3085: G_LINENO := '1.6.2.5';
3086:

Line 3121: fnd_file.put_line(FND_FILE.LOG,G_LINENO);

3117: END IF;
3118:
3119:
3120: IF G_DEBUG THEN
3121: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3122: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt='||ln_sum_taxable_amt);
3123: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr1='||ln_sum_taxable_amt_qtr1);
3124: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr2='||ln_sum_taxable_amt_qtr2);
3125: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr3='||ln_sum_taxable_amt_qtr3);

Line 3122: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt='||ln_sum_taxable_amt);

3118:
3119:
3120: IF G_DEBUG THEN
3121: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3122: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt='||ln_sum_taxable_amt);
3123: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr1='||ln_sum_taxable_amt_qtr1);
3124: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr2='||ln_sum_taxable_amt_qtr2);
3125: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr3='||ln_sum_taxable_amt_qtr3);
3126: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr4='||ln_sum_taxable_amt_qtr4);

Line 3123: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr1='||ln_sum_taxable_amt_qtr1);

3119:
3120: IF G_DEBUG THEN
3121: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3122: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt='||ln_sum_taxable_amt);
3123: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr1='||ln_sum_taxable_amt_qtr1);
3124: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr2='||ln_sum_taxable_amt_qtr2);
3125: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr3='||ln_sum_taxable_amt_qtr3);
3126: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr4='||ln_sum_taxable_amt_qtr4);
3127:

Line 3124: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr2='||ln_sum_taxable_amt_qtr2);

3120: IF G_DEBUG THEN
3121: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3122: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt='||ln_sum_taxable_amt);
3123: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr1='||ln_sum_taxable_amt_qtr1);
3124: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr2='||ln_sum_taxable_amt_qtr2);
3125: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr3='||ln_sum_taxable_amt_qtr3);
3126: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr4='||ln_sum_taxable_amt_qtr4);
3127:
3128: END IF;

Line 3125: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr3='||ln_sum_taxable_amt_qtr3);

3121: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3122: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt='||ln_sum_taxable_amt);
3123: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr1='||ln_sum_taxable_amt_qtr1);
3124: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr2='||ln_sum_taxable_amt_qtr2);
3125: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr3='||ln_sum_taxable_amt_qtr3);
3126: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr4='||ln_sum_taxable_amt_qtr4);
3127:
3128: END IF;
3129:

Line 3126: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr4='||ln_sum_taxable_amt_qtr4);

3122: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt='||ln_sum_taxable_amt);
3123: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr1='||ln_sum_taxable_amt_qtr1);
3124: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr2='||ln_sum_taxable_amt_qtr2);
3125: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr3='||ln_sum_taxable_amt_qtr3);
3126: fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt_qtr4='||ln_sum_taxable_amt_qtr4);
3127:
3128: END IF;
3129:
3130: G_LINENO := '1.6.2.6';

Line 3155: fnd_file.put_line(FND_FILE.LOG,'IF :

3151: lc_clave_operation := lc_triangulation; -- BUG 9765740
3152: ln_base_imponiable := ln_ncorrection_amount;
3153: ln_running_total := ln_ncorrection_amount;
3154: IF G_DEBUG THEN
3155: fnd_file.put_line(FND_FILE.LOG,'IF :
3156: lc_clave_operation='||lc_clave_operation||',
3157: lc_tax_registration_number='||lc_tax_registration_number||',
3158: lc_customer_name='||lc_customer_name||',
3159: lc_correction_year='||lc_correction_year||',

Line 3176: fnd_file.put_line(FND_FILE.LOG,'ELSE :

3172: ln_formerly_decl_amt := 0;
3173: G_LINENO := '1.6.2.7.2.3';
3174:
3175: IF G_DEBUG THEN
3176: fnd_file.put_line(FND_FILE.LOG,'ELSE :
3177: lc_clave_operation='||lc_clave_operation||',
3178: lc_tax_registration_number='||lc_tax_registration_number||',
3179: lc_customer_name='||lc_customer_name||',
3180: lc_correction_year='||lc_correction_year||',

Line 3321: fnd_file.put_line(FND_FILE.LOG,G_LINENO);

3317: , lc_print_period --Bug 5525421
3318: );
3319:
3320: IF G_DEBUG THEN
3321: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3322: END IF;
3323:
3324: ----Bug 5525421 Updation should haapend only after insertintg the correction reocrd.
3325:

Line 3406: fnd_file.put_line(FND_FILE.LOG,'Updating the C_CORRECTION_TRX_SEL_COLS:1 ');

3402: REPLACE( lv_filter_key
3403: ,'trx_date'
3404: ,'gl_date'
3405: );
3406: fnd_file.put_line(FND_FILE.LOG,'***Updating the C_CORRECTION_TRX_SEL_COLS***:1 ');
3407: C_CORRECTION_TRX_SEL_COLS := REPLACE( C_CORRECTION_TRX_SEL_COLS
3408: ,'TRX_DATE'
3409: ,'GL_DATE'
3410: );

Line 3432: fnd_file.put_line(FND_FILE.LOG,'Updating the C_CORRECTION_TRX_SEL_COLS: ');

3428: REPLACE( lv_filter_key
3429: ,'trx_date'
3430: ,'gl_date'
3431: );
3432: fnd_file.put_line(FND_FILE.LOG,'***Updating the C_CORRECTION_TRX_SEL_COLS***: ');
3433: C_CORRECTION_TRX_SEL_COLS := REPLACE( C_CORRECTION_TRX_SEL_COLS
3434: ,'TRX_DATE'
3435: ,'GL_DATE'
3436: );

Line 3828: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Modelo SQL Statement: '||lc_jgzz_modelo_query); END IF;

3824:
3825: END IF;
3826: G_LINENO := '2.4';
3827: -- Insert AR Transations into Global Temp Table
3828: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Modelo SQL Statement: '||lc_jgzz_modelo_query); END IF;
3829:
3830: OPEN c_modelo_ext FOR lc_jgzz_modelo_query ;
3831: LOOP
3832: FETCH c_modelo_ext

Line 3851: fnd_file.put_line(FND_FILE.LOG,'lc_customer_name='||lc_customer_name||',lc_customer_address_id='||lc_customer_address_id);

3847: ,ln_transmission_property_amt
3848: ,ln_year_of_amts_received_cash
3849: ;
3850: IF G_DEBUG THEN
3851: fnd_file.put_line(FND_FILE.LOG,'lc_customer_name='||lc_customer_name||',lc_customer_address_id='||lc_customer_address_id);
3852: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3853: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3854: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3855: fnd_file.put_line(FND_FILE.LOG,'ln_year_of_amts_received_cash'||ln_year_of_amts_received_cash);

Line 3852: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);

3848: ,ln_year_of_amts_received_cash
3849: ;
3850: IF G_DEBUG THEN
3851: fnd_file.put_line(FND_FILE.LOG,'lc_customer_name='||lc_customer_name||',lc_customer_address_id='||lc_customer_address_id);
3852: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3853: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3854: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3855: fnd_file.put_line(FND_FILE.LOG,'ln_year_of_amts_received_cash'||ln_year_of_amts_received_cash);
3856: END IF;

Line 3853: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);

3849: ;
3850: IF G_DEBUG THEN
3851: fnd_file.put_line(FND_FILE.LOG,'lc_customer_name='||lc_customer_name||',lc_customer_address_id='||lc_customer_address_id);
3852: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3853: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3854: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3855: fnd_file.put_line(FND_FILE.LOG,'ln_year_of_amts_received_cash'||ln_year_of_amts_received_cash);
3856: END IF;
3857:

Line 3854: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);

3850: IF G_DEBUG THEN
3851: fnd_file.put_line(FND_FILE.LOG,'lc_customer_name='||lc_customer_name||',lc_customer_address_id='||lc_customer_address_id);
3852: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3853: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3854: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3855: fnd_file.put_line(FND_FILE.LOG,'ln_year_of_amts_received_cash'||ln_year_of_amts_received_cash);
3856: END IF;
3857:
3858: EXIT WHEN c_modelo_ext%NOTFOUND;

Line 3855: fnd_file.put_line(FND_FILE.LOG,'ln_year_of_amts_received_cash'||ln_year_of_amts_received_cash);

3851: fnd_file.put_line(FND_FILE.LOG,'lc_customer_name='||lc_customer_name||',lc_customer_address_id='||lc_customer_address_id);
3852: fnd_file.put_line(FND_FILE.LOG,'lc_tax_registration_number='||lc_tax_registration_number);
3853: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation='||lc_clave_operation);
3854: fnd_file.put_line(FND_FILE.LOG,'lc_triangulation'||lc_triangulation);
3855: fnd_file.put_line(FND_FILE.LOG,'ln_year_of_amts_received_cash'||ln_year_of_amts_received_cash);
3856: END IF;
3857:
3858: EXIT WHEN c_modelo_ext%NOTFOUND;
3859:

Line 3884: fnd_file.put_line(FND_FILE.LOG,G_LINENO);

3880:
3881: -- Bug 8485057 this value is now selected from the record
3882: -- lc_clave_operation := 'B' ;
3883: IF G_DEBUG THEN
3884: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3885: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation);
3886: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);
3887: -- fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt :='||ln_sum_taxable_amt);
3888: -- fnd_file.put_line(FND_FILE.LOG,'ln_transmission_property_amt='||ln_transmission_property_amt);

Line 3885: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation);

3881: -- Bug 8485057 this value is now selected from the record
3882: -- lc_clave_operation := 'B' ;
3883: IF G_DEBUG THEN
3884: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3885: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation);
3886: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);
3887: -- fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt :='||ln_sum_taxable_amt);
3888: -- fnd_file.put_line(FND_FILE.LOG,'ln_transmission_property_amt='||ln_transmission_property_amt);
3889: END IF;

Line 3886: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);

3882: -- lc_clave_operation := 'B' ;
3883: IF G_DEBUG THEN
3884: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3885: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation);
3886: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);
3887: -- fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt :='||ln_sum_taxable_amt);
3888: -- fnd_file.put_line(FND_FILE.LOG,'ln_transmission_property_amt='||ln_transmission_property_amt);
3889: END IF;
3890:

Line 3887: -- fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt :='||ln_sum_taxable_amt);

3883: IF G_DEBUG THEN
3884: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3885: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation);
3886: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);
3887: -- fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt :='||ln_sum_taxable_amt);
3888: -- fnd_file.put_line(FND_FILE.LOG,'ln_transmission_property_amt='||ln_transmission_property_amt);
3889: END IF;
3890:
3891: G_LINENO := '2.4.5';

Line 3888: -- fnd_file.put_line(FND_FILE.LOG,'ln_transmission_property_amt='||ln_transmission_property_amt);

3884: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3885: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation);
3886: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);
3887: -- fnd_file.put_line(FND_FILE.LOG,'ln_sum_taxable_amt :='||ln_sum_taxable_amt);
3888: -- fnd_file.put_line(FND_FILE.LOG,'ln_transmission_property_amt='||ln_transmission_property_amt);
3889: END IF;
3890:
3891: G_LINENO := '2.4.5';
3892: get_customer_address2

Line 3915: fnd_file.put_line(FND_FILE.LOG,G_LINENO||'After AR347_GROSS_AMOUNT');

3911: , p_tipo => lc_clave_operation
3912: , p_year_of_amts_rec_cash => ln_year_of_amts_received_cash);
3913:
3914: IF G_DEBUG THEN
3915: fnd_file.put_line(FND_FILE.LOG,G_LINENO||'After AR347_GROSS_AMOUNT');
3916: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amount :='||ln_arrenda_amount);
3917: END IF;
3918:
3919: -- initilise amts to zero

Line 3916: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amount :='||ln_arrenda_amount);

3912: , p_year_of_amts_rec_cash => ln_year_of_amts_received_cash);
3913:
3914: IF G_DEBUG THEN
3915: fnd_file.put_line(FND_FILE.LOG,G_LINENO||'After AR347_GROSS_AMOUNT');
3916: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amount :='||ln_arrenda_amount);
3917: END IF;
3918:
3919: -- initilise amts to zero
3920:

Line 3963: -- fnd_file.put_line(FND_FILE.LOG,G_LINENO);

3959:
3960: G_LINENO := '2.4.7.1';
3961: ln_sum_trx_line_amt := ln_sum_trx_line_amt - ln_arrenda_amount ;
3962:
3963: -- fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3964: -- fnd_file.put_line(FND_FILE.LOG,'new ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);
3965:
3966: /* Bug 8485057: check any cash received for this customer, tipo and property rental */
3967: ln_cash_received_amount := AR347_CASH_RECEIVEDFormula ( p_customer_id => lc_billing_trading_partner_id

Line 3964: -- fnd_file.put_line(FND_FILE.LOG,'new ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);

3960: G_LINENO := '2.4.7.1';
3961: ln_sum_trx_line_amt := ln_sum_trx_line_amt - ln_arrenda_amount ;
3962:
3963: -- fnd_file.put_line(FND_FILE.LOG,G_LINENO);
3964: -- fnd_file.put_line(FND_FILE.LOG,'new ln_sum_trx_line_amt :='||ln_sum_trx_line_amt);
3965:
3966: /* Bug 8485057: check any cash received for this customer, tipo and property rental */
3967: ln_cash_received_amount := AR347_CASH_RECEIVEDFormula ( p_customer_id => lc_billing_trading_partner_id
3968: , p_tipo => lc_clave_operation

Line 3973: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);

3969: , p_property_rental_flag => 'Y'
3970: , p_year_of_amts_rec_cash => ln_year_of_amts_received_cash);
3971:
3972: IF G_DEBUG THEN
3973: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
3974: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q1 :='||ln_sum_trx_line_amt_q1);
3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);
3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);

Line 3974: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q1 :='||ln_sum_trx_line_amt_q1);

3970: , p_year_of_amts_rec_cash => ln_year_of_amts_received_cash);
3971:
3972: IF G_DEBUG THEN
3973: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
3974: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q1 :='||ln_sum_trx_line_amt_q1);
3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);
3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);

Line 3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);

3971:
3972: IF G_DEBUG THEN
3973: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
3974: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q1 :='||ln_sum_trx_line_amt_q1);
3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);
3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);

Line 3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);

3972: IF G_DEBUG THEN
3973: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
3974: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q1 :='||ln_sum_trx_line_amt_q1);
3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);
3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);

Line 3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);

3973: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
3974: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q1 :='||ln_sum_trx_line_amt_q1);
3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);
3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);

Line 3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);

3974: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q1 :='||ln_sum_trx_line_amt_q1);
3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);
3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);

Line 3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);

3975: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q2 :='||ln_sum_trx_line_amt_q2);
3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);

Line 3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);

3976: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q3 :='||ln_sum_trx_line_amt_q3);
3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);

Line 3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);

3977: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt_q4 :='||ln_sum_trx_line_amt_q4);
3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);
3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);

Line 3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);

3978: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q1 :='||ln_arrenda_amt_q1);
3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);
3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);
3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));

Line 3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);

3979: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q2 :='||ln_arrenda_amt_q2);
3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);
3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);
3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
3987: END IF;

Line 3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);

3980: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q3 :='||ln_arrenda_amt_q3);
3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);
3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);
3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
3987: END IF;
3988:

Line 3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);

3981: fnd_file.put_line(FND_FILE.LOG,'ln_arrenda_amt_q4 :='||ln_arrenda_amt_q4);
3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);
3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);
3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
3987: END IF;
3988:
3989: /* Bug 8485057 Transmission of property transactions are always different than property rental transactions */

Line 3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));

3982: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q1 :='||ln_transmission_prop_amt_q1);
3983: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q2 :='||ln_transmission_prop_amt_q2);
3984: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q3 :='||ln_transmission_prop_amt_q3);
3985: fnd_file.put_line(FND_FILE.LOG,'ln_transmission_prop_amt_q4 :='||ln_transmission_prop_amt_q4);
3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
3987: END IF;
3988:
3989: /* Bug 8485057 Transmission of property transactions are always different than property rental transactions */
3990: INSERT INTO JG_ZZ_VAT_TRX_GT

Line 4057: fnd_file.put_line(FND_FILE.LOG,G_LINENO);

4053: THEN
4054: G_LINENO := '2.4.8.1';
4055:
4056: IF G_DEBUG THEN
4057: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
4058: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt: '||ln_sum_trx_line_amt );
4059: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation );
4060: END IF;
4061:

Line 4058: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt: '||ln_sum_trx_line_amt );

4054: G_LINENO := '2.4.8.1';
4055:
4056: IF G_DEBUG THEN
4057: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
4058: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt: '||ln_sum_trx_line_amt );
4059: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation );
4060: END IF;
4061:
4062: /* Bug 8485057: check any cash received for this customer, tipo and no property rental */

Line 4059: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation );

4055:
4056: IF G_DEBUG THEN
4057: fnd_file.put_line(FND_FILE.LOG,G_LINENO);
4058: fnd_file.put_line(FND_FILE.LOG,'ln_sum_trx_line_amt: '||ln_sum_trx_line_amt );
4059: fnd_file.put_line(FND_FILE.LOG,'lc_clave_operation: '||lc_clave_operation );
4060: END IF;
4061:
4062: /* Bug 8485057: check any cash received for this customer, tipo and no property rental */
4063: ln_cash_received_amount := AR347_CASH_RECEIVEDFormula

Line 4070: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);

4066: , p_property_rental_flag => 'N'
4067: , p_year_of_amts_rec_cash => ln_year_of_amts_received_cash);
4068:
4069: IF G_DEBUG THEN
4070: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
4071: -- fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
4072: END IF;
4073:
4074: INSERT INTO JG_ZZ_VAT_TRX_GT

Line 4071: -- fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));

4067: , p_year_of_amts_rec_cash => ln_year_of_amts_received_cash);
4068:
4069: IF G_DEBUG THEN
4070: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
4071: -- fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
4072: END IF;
4073:
4074: INSERT INTO JG_ZZ_VAT_TRX_GT
4075: ( jg_info_v1 -- lc_clave_operation

Line 4136: -- fnd_file.put_line(FND_FILE.LOG,G_LINENO||'Inseted into JG_ZZ_VAT_TRX_GT');

4132: , lc_postal_code1
4133: ) ;
4134: G_LINENO := '2.4.8.2';
4135:
4136: -- fnd_file.put_line(FND_FILE.LOG,G_LINENO||'Inseted into JG_ZZ_VAT_TRX_GT');
4137:
4138: end if;
4139: G_LINENO := '2.4.9';
4140: ELSIF P_MODELO = '349' THEN

Line 4166: fnd_file.put_line(FND_FILE.LOG,'IF :

4162: lc_clave_operation := lc_triangulation;
4163:
4164: G_LINENO := '2.4.10.2.2';
4165: IF G_DEBUG THEN
4166: fnd_file.put_line(FND_FILE.LOG,'IF :
4167: lc_clave_operation='||lc_clave_operation||',
4168: lc_tax_registration_number='||lc_tax_registration_number||',
4169: lc_customer_name='||lc_customer_name||',
4170: lc_correction_year='||lc_correction_year||',

Line 4186: fnd_file.put_line(FND_FILE.LOG,'ELSE :

4182: ln_base_imponiable := ln_correction_amount;
4183: G_LINENO := '2.4.10.2.4';
4184:
4185: IF G_DEBUG THEN
4186: fnd_file.put_line(FND_FILE.LOG,'ELSE :
4187: lc_clave_operation='||lc_clave_operation||',
4188: lc_tax_registration_number='||lc_tax_registration_number||',
4189: lc_customer_name='||lc_customer_name||',
4190: lc_correction_year='||lc_correction_year||',

Line 4359: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AP Processing ...');

4355:
4356: ELSE
4357:
4358: IF G_DEBUG THEN
4359: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AP Processing ...');
4360: fnd_file.put_line(FND_FILE.LOG,'Driving Date ...'||p_driving_date);
4361: END IF;
4362:
4363: G_LINENO := '2.5.5';

Line 4360: fnd_file.put_line(FND_FILE.LOG,'Driving Date ...'||p_driving_date);

4356: ELSE
4357:
4358: IF G_DEBUG THEN
4359: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AP Processing ...');
4360: fnd_file.put_line(FND_FILE.LOG,'Driving Date ...'||p_driving_date);
4361: END IF;
4362:
4363: G_LINENO := '2.5.5';
4364:

Line 4645: fnd_file.put_line(FND_FILE.LOG,'**** start '||p_340_start_date||' end '||p_340_end_date);

4641:
4642: -- Set start and end dates, specific to 340
4643: set_dates;
4644:
4645: fnd_file.put_line(FND_FILE.LOG,'**** start '||p_340_start_date||' end '||p_340_end_date);
4646:
4647: if p_driving_date = 'GL' then
4648: lc_jgzz_mod_query_340 :=
4649: REPLACE( lc_jgzz_mod_query_340

Line 4709: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.6.1 Open the AP Dynamic Query for 340 : '||lc_jgzz_mod_query_340 ); END IF;

4705: REPLACE( lc_jgzz_mod_query_340
4706: , '$P_ORG_ID$'
4707: , P_ORG_ID );
4708:
4709: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.6.1 Open the AP Dynamic Query for 340 : '||lc_jgzz_mod_query_340 ); END IF;
4710:
4711:
4712: OPEN c_modelo_340 FOR lc_jgzz_mod_query_340 ;
4713: LOOP

Line 4762: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);

4758:
4759: G_LINENO := '2.5.5.3';
4760:
4761: IF G_DEBUG THEN
4762: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
4763: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
4764: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
4765: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
4766: END IF;

Line 4763: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);

4759: G_LINENO := '2.5.5.3';
4760:
4761: IF G_DEBUG THEN
4762: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
4763: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
4764: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
4765: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
4766: END IF;
4767:

Line 4764: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);

4760:
4761: IF G_DEBUG THEN
4762: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
4763: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
4764: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
4765: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
4766: END IF;
4767:
4768: G_LINENO := '2.5.5.4';

Line 4765: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);

4761: IF G_DEBUG THEN
4762: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
4763: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
4764: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
4765: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
4766: END IF;
4767:
4768: G_LINENO := '2.5.5.4';
4769:

Line 4841: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AP Processing Complete');

4837: CLOSE c_modelo_340;
4838: END IF;
4839:
4840: IF G_DEBUG THEN
4841: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AP Processing Complete');
4842: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AR Processing ...');
4843: END IF;
4844:
4845: lc_jgzz_mod_query_340 :=

Line 4842: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AR Processing ...');

4838: END IF;
4839:
4840: IF G_DEBUG THEN
4841: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AP Processing Complete');
4842: fnd_file.put_line(FND_FILE.LOG,'Modelo 340 AR Processing ...');
4843: END IF;
4844:
4845: lc_jgzz_mod_query_340 :=
4846: 'SELECT decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',

Line 5120: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.6.1 Open the AR Dynamic Query for 340: '||lc_jgzz_mod_query_340 ); END IF;

5116: , P_ORG_ID );
5117:
5118:
5119: G_LINENO := '2.5.6.1';
5120: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.6.1 Open the AR Dynamic Query for 340: '||lc_jgzz_mod_query_340 ); END IF;
5121: OPEN c_modelo_340 FOR lc_jgzz_mod_query_340 ; -- opencur
5122: LOOP
5123:
5124: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.5. Fetch from 340 AR Query'); END IF;

Line 5124: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.5. Fetch from 340 AR Query'); END IF;

5120: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.6.1 Open the AR Dynamic Query for 340: '||lc_jgzz_mod_query_340 ); END IF;
5121: OPEN c_modelo_340 FOR lc_jgzz_mod_query_340 ; -- opencur
5122: LOOP
5123:
5124: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'2.5.5. Fetch from 340 AR Query'); END IF;
5125:
5126: G_LINENO := '2.5.6.2';
5127:
5128: FETCH c_modelo_340

Line 5189: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);

5185:
5186: G_LINENO := '2.5.6.4';
5187:
5188: IF G_DEBUG THEN
5189: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
5190: fnd_file.put_line(FND_FILE.LOG,'ln_trx_id='||ln_trx_id);
5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);

Line 5190: fnd_file.put_line(FND_FILE.LOG,'ln_trx_id='||ln_trx_id);

5186: G_LINENO := '2.5.6.4';
5187:
5188: IF G_DEBUG THEN
5189: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
5190: fnd_file.put_line(FND_FILE.LOG,'ln_trx_id='||ln_trx_id);
5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);

Line 5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);

5187:
5188: IF G_DEBUG THEN
5189: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
5190: fnd_file.put_line(FND_FILE.LOG,'ln_trx_id='||ln_trx_id);
5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);

Line 5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);

5188: IF G_DEBUG THEN
5189: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
5190: fnd_file.put_line(FND_FILE.LOG,'ln_trx_id='||ln_trx_id);
5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
5196: fnd_file.put_line(FND_FILE.LOG,'ln_property_location_code='||ln_property_location_code);

Line 5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);

5189: fnd_file.put_line(FND_FILE.LOG,'lc_trx_num='||lc_trx_num);
5190: fnd_file.put_line(FND_FILE.LOG,'ln_trx_id='||ln_trx_id);
5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
5196: fnd_file.put_line(FND_FILE.LOG,'ln_property_location_code='||ln_property_location_code);
5197: fnd_file.put_line(FND_FILE.LOG,'lc_ref_catastral='||lc_ref_catastral);

Line 5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);

5190: fnd_file.put_line(FND_FILE.LOG,'ln_trx_id='||ln_trx_id);
5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
5196: fnd_file.put_line(FND_FILE.LOG,'ln_property_location_code='||ln_property_location_code);
5197: fnd_file.put_line(FND_FILE.LOG,'lc_ref_catastral='||lc_ref_catastral);
5198: END IF;

Line 5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);

5191: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
5196: fnd_file.put_line(FND_FILE.LOG,'ln_property_location_code='||ln_property_location_code);
5197: fnd_file.put_line(FND_FILE.LOG,'lc_ref_catastral='||lc_ref_catastral);
5198: END IF;
5199:

Line 5196: fnd_file.put_line(FND_FILE.LOG,'ln_property_location_code='||ln_property_location_code);

5192: fnd_file.put_line(FND_FILE.LOG,'lc_street_type='||lc_street_type);
5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
5196: fnd_file.put_line(FND_FILE.LOG,'ln_property_location_code='||ln_property_location_code);
5197: fnd_file.put_line(FND_FILE.LOG,'lc_ref_catastral='||lc_ref_catastral);
5198: END IF;
5199:
5200:

Line 5197: fnd_file.put_line(FND_FILE.LOG,'lc_ref_catastral='||lc_ref_catastral);

5193: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
5194: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
5195: fnd_file.put_line(FND_FILE.LOG,'lc_country='||lc_country);
5196: fnd_file.put_line(FND_FILE.LOG,'ln_property_location_code='||ln_property_location_code);
5197: fnd_file.put_line(FND_FILE.LOG,'lc_ref_catastral='||lc_ref_catastral);
5198: END IF;
5199:
5200:
5201: ln_cash_received_amount := 0;

Line 5247: fnd_file.put_line(FND_FILE.LOG, 'Processed transaction: '||lc_trx_num);

5243:
5244: G_LINENO := '2.5.6.6';
5245:
5246: IF G_DEBUG THEN
5247: fnd_file.put_line(FND_FILE.LOG, 'Processed transaction: '||lc_trx_num);
5248: fnd_file.put_line(FND_FILE.LOG, 'Tax Amount: '||ln_tax_amt);
5249: fnd_file.put_line(FND_FILE.LOG, 'Tax rate: '||ln_tax_rate);
5250: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Amount: '||ln_surcharge_amount);
5251: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Rate: '||ln_surcharge_rate);

Line 5248: fnd_file.put_line(FND_FILE.LOG, 'Tax Amount: '||ln_tax_amt);

5244: G_LINENO := '2.5.6.6';
5245:
5246: IF G_DEBUG THEN
5247: fnd_file.put_line(FND_FILE.LOG, 'Processed transaction: '||lc_trx_num);
5248: fnd_file.put_line(FND_FILE.LOG, 'Tax Amount: '||ln_tax_amt);
5249: fnd_file.put_line(FND_FILE.LOG, 'Tax rate: '||ln_tax_rate);
5250: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Amount: '||ln_surcharge_amount);
5251: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Rate: '||ln_surcharge_rate);
5252: fnd_file.put_line(FND_FILE.LOG, 'Inv Amount: '||ln_inv_total_amt);

Line 5249: fnd_file.put_line(FND_FILE.LOG, 'Tax rate: '||ln_tax_rate);

5245:
5246: IF G_DEBUG THEN
5247: fnd_file.put_line(FND_FILE.LOG, 'Processed transaction: '||lc_trx_num);
5248: fnd_file.put_line(FND_FILE.LOG, 'Tax Amount: '||ln_tax_amt);
5249: fnd_file.put_line(FND_FILE.LOG, 'Tax rate: '||ln_tax_rate);
5250: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Amount: '||ln_surcharge_amount);
5251: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Rate: '||ln_surcharge_rate);
5252: fnd_file.put_line(FND_FILE.LOG, 'Inv Amount: '||ln_inv_total_amt);
5253: END IF;

Line 5250: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Amount: '||ln_surcharge_amount);

5246: IF G_DEBUG THEN
5247: fnd_file.put_line(FND_FILE.LOG, 'Processed transaction: '||lc_trx_num);
5248: fnd_file.put_line(FND_FILE.LOG, 'Tax Amount: '||ln_tax_amt);
5249: fnd_file.put_line(FND_FILE.LOG, 'Tax rate: '||ln_tax_rate);
5250: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Amount: '||ln_surcharge_amount);
5251: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Rate: '||ln_surcharge_rate);
5252: fnd_file.put_line(FND_FILE.LOG, 'Inv Amount: '||ln_inv_total_amt);
5253: END IF;
5254:

Line 5251: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Rate: '||ln_surcharge_rate);

5247: fnd_file.put_line(FND_FILE.LOG, 'Processed transaction: '||lc_trx_num);
5248: fnd_file.put_line(FND_FILE.LOG, 'Tax Amount: '||ln_tax_amt);
5249: fnd_file.put_line(FND_FILE.LOG, 'Tax rate: '||ln_tax_rate);
5250: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Amount: '||ln_surcharge_amount);
5251: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Rate: '||ln_surcharge_rate);
5252: fnd_file.put_line(FND_FILE.LOG, 'Inv Amount: '||ln_inv_total_amt);
5253: END IF;
5254:
5255: -- Insert AR record

Line 5252: fnd_file.put_line(FND_FILE.LOG, 'Inv Amount: '||ln_inv_total_amt);

5248: fnd_file.put_line(FND_FILE.LOG, 'Tax Amount: '||ln_tax_amt);
5249: fnd_file.put_line(FND_FILE.LOG, 'Tax rate: '||ln_tax_rate);
5250: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Amount: '||ln_surcharge_amount);
5251: fnd_file.put_line(FND_FILE.LOG, 'Surcharge Rate: '||ln_surcharge_rate);
5252: fnd_file.put_line(FND_FILE.LOG, 'Inv Amount: '||ln_inv_total_amt);
5253: END IF;
5254:
5255: -- Insert AR record
5256: INSERT INTO JG_ZZ_VAT_TRX_GT

Line 5409: fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT, before applying minimum amount='||P_REC_COUNT);

5405: /* Bug 8485057 apply minimum amounts to the selected transactions */
5406: IF P_MODELO = '347'
5407: THEN
5408: IF G_DEBUG THEN
5409: fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT, before applying minimum amount='||P_REC_COUNT);
5410: END IF;
5411:
5412: -- Apply minimum amount parameter to the selected transactions
5413: -- Note: Only transactions tipo 'A' and 'B' are subject to this minimum

Line 5436: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;

5432:
5433: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';
5434:
5435: G_LINENO := '2.7';
5436: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;
5437: IF P_REPORT_NAME = 'JEESAMOR' THEN
5438: G_LINENO := '2.7.1';
5439:
5440: IF P_MODELO = '347' THEN

Line 5555: fnd_file.put_line(FND_FILE.LOG,'Error while processing Before Report Trigger. Statement No = ' || G_LINENO||' Err:'|| SQLCODE || SUBSTR(SQLERRM,1,200));

5551: G_LINENO := '2.8';
5552: RETURN (TRUE);
5553: EXCEPTION
5554: WHEN OTHERS THEN
5555: fnd_file.put_line(FND_FILE.LOG,'Error while processing Before Report Trigger. Statement No = ' || G_LINENO||' Err:'|| SQLCODE || SUBSTR(SQLERRM,1,200));
5556: RETURN (FALSE);
5557: END BEFORE_REPORT;
5558:
5559: FUNCTION after_Report RETURN BOOLEAN