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

216: INTO arr_rec.trx_line_amt
217: FROM DUAL;
218: */
219:
220: 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;
221:
222: -- dbms_output.put_line ('inserting ');
223: INSERT INTO JG_ZZ_VAT_TRX_GT
224: ( jg_info_v1 -- tipo

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

1011: lc_misc VARCHAR2(1000);
1012: --
1013: BEGIN
1014: -- dbms_output.put_line ('Executing before_report');
1015: fnd_file.put_line(FND_FILE.LOG,'Executing before_report');
1016: -- dbms_output.put_line ('Calling funct_curr_legal');
1017:
1018: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.funct_curr_legal'); END IF;
1019:

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

1014: -- dbms_output.put_line ('Executing before_report');
1015: fnd_file.put_line(FND_FILE.LOG,'Executing before_report');
1016: -- dbms_output.put_line ('Calling funct_curr_legal');
1017:
1018: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.funct_curr_legal'); END IF;
1019:
1020: jg_zz_common_pkg.funct_curr_legal( lc_func_curr_code
1021: , lc_rep_legal_entity
1022: , ln_rep_legal_entity_id

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

1025: , p_tax_period
1026: , p_tax_year
1027: );
1028: -- dbms_output.put_line ('jg_zz_common_pkg.tax_registration');
1029: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.tax_registration'); END IF;
1030:
1031: BEGIN
1032: jg_zz_common_pkg.tax_registration( x_tax_registration => lc_trx_num
1033: , x_period_start_date => ld_period_start_date

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

1042: WHEN OTHERS THEN
1043: NULL;
1044: END;
1045: -- dbms_output.put_line ('jg_zz_common_pkg.tax_registration');
1046: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'jg_zz_common_pkg.company_detail'); END IF;
1047:
1048: jg_zz_common_pkg.company_detail(x_company_name => lc_company_name
1049: ,x_registration_number => lc_registration_number
1050: ,x_country => lc_country

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

1063: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
1064:
1065:
1066:
1067: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'JG_ZZ_VAT_REP_UTILITY.get_period_status'); END IF;
1068:
1069: -- Fetch the reporting mode only if the report name is not null
1070: IF P_REPORT_NAME IS NOT NULL THEN
1071: lc_reporting_mode := JG_ZZ_VAT_REP_UTILITY.get_period_status(pn_vat_reporting_entity_id => p_vat_rep_entity_id

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

1089: G_LE_NAME := lc_rep_legal_entity;
1090: G_FROM_DATE := ld_period_start_date;
1091: G_TO_DATE := ld_period_end_date;
1092: -- dbms_output.put_line ('SELECT precision INTO G_CUR_PRECISION');
1093: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'SELECT precision INTO G_CUR_PRECISION'); END IF;
1094:
1095: BEGIN
1096: SELECT precision
1097: INTO G_CUR_PRECISION

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

1101: WHEN NO_DATA_FOUND THEN
1102: NULL;
1103: END;
1104: -- dbms_output.put_line ('P_REPORT_NAME:'||P_REPORT_NAME);
1105: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'P_REPORT_NAME:'||P_REPORT_NAME); END IF;
1106:
1107: IF P_REPORT_NAME = 'JEESAMOR' AND P_MODELO = '347' THEN
1108: lc_address1 := SUBSTR( lc_address1, 1,2);
1109: lc_address2 := SUBSTR( lc_address2, 1,20);

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

1124: lc_company_name := SUBSTR(lc_company_name,1,40);
1125: lc_city := SUBSTR(lc_city,1,24);
1126: END IF;
1127: -- dbms_output.put_line ('BEFORE INSERT HEADER');
1128: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'BEFORE INSERT HEADER'); END IF;
1129:
1130: INSERT INTO JG_ZZ_VAT_TRX_GT
1131: (jg_info_v1 -- curr_code
1132: ,jg_info_v2 -- entity_name

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

1206: ,ld_period_start_date
1207: ,ld_period_end_date
1208: ,'H');
1209: -- dbms_output.put_line ('AFTER INSERT HEADER');
1210: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'AFTER INSERT HEADER'); END IF;
1211:
1212: /**
1213: author: brathod
1214: date : 23/05/2006

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

1355: , '$PROPERTY_FLAG_GRP_COL$'
1356: , lc_misc );
1357:
1358: IF G_DEBUG THEN
1359: fnd_file.put_line(FND_FILE.LOG,'1.3. bEFORE Merge subquery to inclue expense reports');
1360: END IF;
1361:
1362: --
1363: -- Remove semi colon to merge union select

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

1485: lv_filter_key := 'JZVTD.trx_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date
1486: AND JZVRS.TAX_CALENDAR_YEAR'; --Bug 5525421
1487: lv_filter_value := p_tax_year;
1488: end if;
1489: fnd_file.put_line(FND_FILE.LOG,'lv_filter_key :='||lv_filter_key);
1490: lc_jgzz_modelo_query1 :=
1491: REPLACE( lc_jgzz_modelo_query1
1492: , '$FILTER_KEY$'
1493: , lv_filter_key );

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

1509: , P_ORG_ID);
1510:
1511: lc_jgzz_modelo_query := lc_jgzz_modelo_query || lc_jgzz_modelo_query1;
1512:
1513: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.4. After Merge subquery to inclue expense reports'); END IF;
1514:
1515:
1516: ELSIF p_modelo = '415' THEN
1517:

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

1644: --
1645:
1646: -- INSERT INTO JG_TEMP_TABLE values (Lc_jgzz_modelo_query); -- debug
1647:
1648: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.5. Open the Dynamic Query: '||lc_jgzz_modelo_query ); END IF;
1649:
1650: OPEN c_modelo_ext FOR lc_jgzz_modelo_query ; -- opencur
1651: LOOP
1652:

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

1649:
1650: OPEN c_modelo_ext FOR lc_jgzz_modelo_query ; -- opencur
1651: LOOP
1652:
1653: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'1.6. Fetch from the Dynamic Query'); END IF;
1654: G_LINENO := '1.6.1';
1655: FETCH c_modelo_ext
1656: INTO lc_tax_registration_number
1657: ,lc_customer_name

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

1692:
1693: G_LINENO := '1.6.2.1';
1694:
1695: IF G_DEBUG THEN
1696: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
1697: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
1698: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
1699: END IF;
1700:

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

1693: G_LINENO := '1.6.2.1';
1694:
1695: IF G_DEBUG THEN
1696: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
1697: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
1698: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
1699: END IF;
1700:
1701: G_LINENO := '1.6.2.2';

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

1694:
1695: IF G_DEBUG THEN
1696: fnd_file.put_line(FND_FILE.LOG,'lc_address_detail='||lc_address_detail);
1697: fnd_file.put_line(FND_FILE.LOG,'lc_postal_code='||lc_postal_code);
1698: fnd_file.put_line(FND_FILE.LOG,'lc_city='||lc_city);
1699: END IF;
1700:
1701: G_LINENO := '1.6.2.2';
1702:

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

2222:
2223: END IF;
2224: G_LINENO := '2.4';
2225: -- Insert AR Transations into Global Temp Table
2226: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Modelo SQL Statement: '||lc_jgzz_modelo_query); END IF;
2227:
2228: OPEN c_modelo_ext FOR lc_jgzz_modelo_query ;
2229: LOOP
2230: FETCH c_modelo_ext

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

2242: ,lc_trx_period -- Bug 5525421
2243: ,lc_property_retail_flag
2244: ;
2245: IF G_DEBUG THEN
2246: fnd_file.put_line(FND_FILE.LOG,'lc_customer_name='||lc_customer_name||',lc_customer_address_id='||lc_customer_address_id);
2247: END IF;
2248:
2249: EXIT WHEN c_modelo_ext%NOTFOUND;
2250:

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

2282: G_LINENO := '2.4.6';
2283: ln_arrenda_amount := AR347_GROSS_AMOUNTFormula
2284: ( p_customer_id => lc_billing_trading_partner_id
2285: );
2286: fnd_file.put_line(FND_FILE.LOG,'2.4.6 ln_arrenda_amount :='||ln_arrenda_amount);
2287:
2288: G_LINENO := '2.4.7';
2289: -- dbms_output.put_line ('ln_sum_trx_line_amt='||ln_sum_trx_line_amt||', ln_arrenda_amount =' || ln_arrenda_amount );
2290: IF nvl(ln_arrenda_amount,0) <> 0 THEN

Line 2559: 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;

2555:
2556: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';
2557:
2558: G_LINENO := '2.7';
2559: 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;
2560: IF P_REPORT_NAME = 'JEESAMOR' THEN
2561: G_LINENO := '2.7.1';
2562:
2563: IF P_MODELO = '347' THEN

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

2626: G_LINENO := '2.8';
2627: RETURN (TRUE);
2628: EXCEPTION
2629: WHEN OTHERS THEN
2630: fnd_file.put_line(FND_FILE.LOG,'Error while processing Before Report Trigger. Statement No = ' || G_LINENO||' Err:'|| SQLCODE || SUBSTR(SQLERRM,1,200));
2631: RETURN (FALSE);
2632: END BEFORE_REPORT;
2633:
2634: FUNCTION after_Report RETURN BOOLEAN