DBA Data[Home] [Help]

APPS.AR_GTA_REPORTS_PKG dependencies on FND_FILE

Line 1560: /*fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_customer_name:'||l_ar_customer_name);

1556: --Add trim() function to avoid the discrepancy caused by space character
1557: l_ar_customer_name:=trim(l_ar_customer_name);
1558: l_gta_customer_name:=trim(l_gta_customer_name);
1559: l_gt_customer_name:=trim(l_gt_customer_name);
1560: /*fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_customer_name:'||l_ar_customer_name);
1561: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gta_customer_name:'||l_gta_customer_name);
1562: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gt_customer_name'||l_gt_customer_name);*/
1563: IF (nvl(l_ar_customer_name,' ')<>nvl(l_gta_customer_name,' ')) OR
1564: --Yao Zhang Modified for bug#8765631

Line 1561: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gta_customer_name:'||l_gta_customer_name);

1557: l_ar_customer_name:=trim(l_ar_customer_name);
1558: l_gta_customer_name:=trim(l_gta_customer_name);
1559: l_gt_customer_name:=trim(l_gt_customer_name);
1560: /*fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_customer_name:'||l_ar_customer_name);
1561: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gta_customer_name:'||l_gta_customer_name);
1562: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gt_customer_name'||l_gt_customer_name);*/
1563: IF (nvl(l_ar_customer_name,' ')<>nvl(l_gta_customer_name,' ')) OR
1564: --Yao Zhang Modified for bug#8765631
1565: ((nvl(l_ar_customer_name,' ')<>nvl(l_gt_customer_name,' '))AND l_gta_status='COMPLETED')

Line 1562: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gt_customer_name'||l_gt_customer_name);*/

1558: l_gta_customer_name:=trim(l_gta_customer_name);
1559: l_gt_customer_name:=trim(l_gt_customer_name);
1560: /*fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_customer_name:'||l_ar_customer_name);
1561: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gta_customer_name:'||l_gta_customer_name);
1562: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_gt_customer_name'||l_gt_customer_name);*/
1563: IF (nvl(l_ar_customer_name,' ')<>nvl(l_gta_customer_name,' ')) OR
1564: --Yao Zhang Modified for bug#8765631
1565: ((nvl(l_ar_customer_name,' ')<>nvl(l_gt_customer_name,' '))AND l_gta_status='COMPLETED')
1566: THEN

Line 2493: --fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_line_context'||l_ar_line_context);

2489: ,l_om_line_id
2490: ,l_price_adjustment_id;
2491: EXIT WHEN c_ar_lines%NOTFOUND;
2492: --c_ar_lines%FOUND
2493: --fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_line_context'||l_ar_line_context);
2494: --fnd_file.PUT_LINE(fnd_file.LOG,'l_price_adjustment_id'||l_price_adjustment_id);
2495:
2496: --The following code is added by Yao to fix bug#8765631
2497: l_adjustment_type:=null;

Line 2494: --fnd_file.PUT_LINE(fnd_file.LOG,'l_price_adjustment_id'||l_price_adjustment_id);

2490: ,l_price_adjustment_id;
2491: EXIT WHEN c_ar_lines%NOTFOUND;
2492: --c_ar_lines%FOUND
2493: --fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_line_context'||l_ar_line_context);
2494: --fnd_file.PUT_LINE(fnd_file.LOG,'l_price_adjustment_id'||l_price_adjustment_id);
2495:
2496: --The following code is added by Yao to fix bug#8765631
2497: l_adjustment_type:=null;
2498: l_discount_amount:=NULL;

Line 2523: --fnd_file.PUT_LINE(fnd_file.LOG,'NormalLine with discount'||l_om_line_id);

2519:
2520: --The following code is added by Yao Zhang for bug#8605196 to support discount line
2521: IF(l_ar_line_context='ORDER ENTRY' and l_price_adjustment_id=0)
2522: THEN--the original transction line
2523: --fnd_file.PUT_LINE(fnd_file.LOG,'NormalLine with discount'||l_om_line_id);
2524: OPEN c_discount_lines(l_om_line_id);
2525: LOOP
2526: FETCH c_discount_lines INTO l_discount_adjustment_id;
2527: EXIT WHEN c_discount_lines%NOTFOUND;

Line 2537: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_discount_amount IN CURSOR:'||l_discount_amount);

2533: WHERE rctl.customer_trx_id = l_ar_header_id
2534: AND rctl.line_type = 'LINE'
2535: AND rctl.interface_line_attribute11 =
2536: l_discount_adjustment_id;
2537: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_discount_amount IN CURSOR:'||l_discount_amount);
2538: --Calculate the discount tax amount
2539: SELECT tax.tax_amt_tax_curr + nvl(l_discount_tax_amount, 0)
2540: INTO l_discount_tax_amount
2541: FROM zx_lines tax

Line 2549: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_discount_tax_amount IN CURSOR:'||l_discount_tax_amount);

2545: AND tax.trx_level_type = 'LINE'
2546: AND tax.tax_currency_code = l_gt_currency_code
2547: AND tax.tax_type_code = l_tax_type_code
2548: AND tax.trx_id = l_ar_header_id;
2549: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_discount_tax_amount IN CURSOR:'||l_discount_tax_amount);
2550: END LOOP;/*c_discount_lines*/
2551: CLOSE c_discount_lines;
2552: END IF;/*(l_interface_line_context='ORDER ENTRY' and l_price_adjustment_id=0)*/
2553: IF l_adjustment_type IS NULL OR l_adjustment_type <>'DIS'

Line 3214: --fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_line_amount'||nvl(l_ar_line_amount,0));

3210: END IF; --(l_ar_quantity<>l_gta_line_quantity_sum)
3211:
3212: --compare Line Amount
3213: --Yao modified for bug#8765631
3214: --fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_line_amount'||nvl(l_ar_line_amount,0));
3215: --fnd_file.PUT_LINE(fnd_file.LOG,'l_gta_line_amount_sum'||nvl(l_gta_line_amount_sum,0));
3216: l_ar_line_amount:=round(l_ar_line_amount,2);--Qiong add for bug 10638369
3217: l_gta_line_amount_sum:=round(l_gta_line_amount_sum,2);--Qiong add for bug 10638369
3218: IF (nvl(l_ar_line_amount,0)<>nvl(l_gta_line_amount_sum,0)) AND

Line 3215: --fnd_file.PUT_LINE(fnd_file.LOG,'l_gta_line_amount_sum'||nvl(l_gta_line_amount_sum,0));

3211:
3212: --compare Line Amount
3213: --Yao modified for bug#8765631
3214: --fnd_file.PUT_LINE(fnd_file.LOG,'l_ar_line_amount'||nvl(l_ar_line_amount,0));
3215: --fnd_file.PUT_LINE(fnd_file.LOG,'l_gta_line_amount_sum'||nvl(l_gta_line_amount_sum,0));
3216: l_ar_line_amount:=round(l_ar_line_amount,2);--Qiong add for bug 10638369
3217: l_gta_line_amount_sum:=round(l_gta_line_amount_sum,2);--Qiong add for bug 10638369
3218: IF (nvl(l_ar_line_amount,0)<>nvl(l_gta_line_amount_sum,0)) AND
3219: (l_gta_trx_number_con IS NOT NULL) --To validate that current

Line 5200: FND_FILE.Put_Line(FND_FILE.Output,'');

5196:
5197:
5198: --Output xml script
5199:
5200: FND_FILE.Put_Line(FND_FILE.Output,'');
5201: AR_GTA_TRX_UTIL.Output_Conc(l_xml_output.Getclobval);
5202:
5203: --Logging for debug
5204: