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

Line 1277: FND_FILE.PUT_LINE(FND_FILE.LOG, '5:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||

1273: --dbms_output.put_line('5 only one line' || b_bkt_start_date(j));
1274: END IF;
1275:
1276:
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, '5:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||
1278: l_start_date || 'cutoff ' || l_cutoff_ref_num );
1279:
1280: --dbms_output.put_line( '5:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||
1281: -- l_start_date || 'cutoff ' || l_cutoff_ref_num || ' pair ' || l_pair);

Line 1459: FND_FILE.PUT_LINE(FND_FILE.LOG, '5:insert' || 'demand ' || l_tp_total_demand || 'sup ' || l_total_supply);

1455: IF ((l_tp_total_demand - l_total_supply) > (l_tp_total_demand * l_threshold1/100))
1456: and (b_refresh_number(j) > p_refresh_number)
1457: THEN --- Bug#4629582
1458:
1459: FND_FILE.PUT_LINE(FND_FILE.LOG, '5:insert' || 'demand ' || l_tp_total_demand || 'sup ' || l_total_supply);
1460:
1461:
1462: l_exception_type := msc_x_netting_pkg.G_EXCEP5;
1463: l_exception_group := msc_x_netting_pkg.G_MATERIAL_SHORTAGE;

Line 1569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(5) ||

1565: --- END IF; --sum
1566: END LOOP;
1567: END IF;
1568:
1569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(5) ||
1570: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1571:
1572: --=======================================================================================
1573: --for Supplier supply planning (exception 2.2 and 7.2)

Line 1875: FND_FILE.PUT_LINE(FND_FILE.LOG, '6:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||

1871: l_supplier_site_name := b_supplier_site_name(j);
1872: END IF;
1873:
1874:
1875: FND_FILE.PUT_LINE(FND_FILE.LOG, '6:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||
1876: l_start_date || 'cutoff ' || l_cutoff_ref_num || 'bkt ' || b_bucket_index(j));
1877:
1878: IF ( ((j > 1 and l_insert = 1 ) OR (b_bucket_index.COUNT = 1)) and
1879: ((l_total_demand - l_tp_total_supply ) > (l_total_demand * l_threshold1/100)))

Line 2163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(6) ||

2159: --end if;
2160: END LOOP;
2161: END IF;
2162:
2163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(6) ||
2164: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2165:
2166:
2167: /* reset the trxid */

Line 2752: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(7) ||

2748: END IF; -- if j=1
2749: end if; -- if total qty
2750: END LOOP;
2751: END IF;
2752: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(7) ||
2753: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2754:
2755: /* reset the trxid */
2756: l_generate_complement := null;

Line 3348: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(8) ||

3344: end if;
3345: END LOOP;
3346: END IF;
3347:
3348: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(8) ||
3349: ':' ||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3350:
3351: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
3352: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_MATERIAL_SHORTAGE) || ':' || l_inserted_record);

Line 3351: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||

3347:
3348: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(8) ||
3349: ':' ||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3350:
3351: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
3352: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_MATERIAL_SHORTAGE) || ':' || l_inserted_record);
3353:
3354:
3355: -- added exception handler

Line 3839: FND_FILE.PUT_LINE(FND_FILE.LOG, '25:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||

3835:
3836: --dbms_output.put_line('5 only one line' || b_bkt_start_date(j));
3837: END IF;
3838:
3839: FND_FILE.PUT_LINE(FND_FILE.LOG, '25:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||
3840: l_start_date || 'cutoff ' || l_cutoff_ref_num );
3841:
3842: --dbms_output.put_line( '25:supply ' || l_total_supply || ' demand ' || l_total_demand || ' date ' ||
3843: -- l_start_date || 'cutoff ' || l_cutoff_ref_num || ' pair ' || l_pair);

Line 4130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(25) ||

4126: -- END IF; --sum
4127: end loop;
4128: END IF;
4129:
4130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(25) ||
4131: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4132:
4133: --=======================================================================================
4134: --for Supplier supply planning (exception 7.2)

Line 4434: FND_FILE.PUT_LINE(FND_FILE.LOG, '26:supply ' || l_total_supply || ' demand ' || l_total_demand ||

4430:
4431: END IF;
4432:
4433:
4434: FND_FILE.PUT_LINE(FND_FILE.LOG, '26:supply ' || l_total_supply || ' demand ' || l_total_demand ||
4435: ' date ' || l_start_date || 'cutoff ' || l_cutoff_ref_num);
4436:
4437:
4438: IF (((j > 1 and l_insert = 1 ) OR (b_bucket_index.COUNT = 1)) and

Line 4723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(26) ||

4719: --END IF;
4720: --END IF; --sum
4721: END LOOP;
4722: END IF;
4723: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(26) ||
4724: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4725:
4726:
4727: --=================================================================================

Line 5325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(27) ||

5321: END IF; -- if j=1
5322: end if;
5323: END LOOP;
5324: END IF;
5325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(27) ||
5326: ':' ||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
5327:
5328: /* reset the trxid */
5329:

Line 5928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(28) ||

5924: END IF; --if j = 1
5925: end if;
5926: END LOOP;
5927: END IF;
5928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(28) ||
5929: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
5930:
5931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
5932: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_MATERIAL_EXCESS) || ':' || l_inserted_record);

Line 5931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||

5927: END IF;
5928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' || msc_x_netting_pkg.get_message_type(28) ||
5929: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
5930:
5931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
5932: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_MATERIAL_EXCESS) || ':' || l_inserted_record);
5933:
5934: EXCEPTION
5935: WHEN OTHERS THEN