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_NETTING_PKG dependencies on FND_FILE

Line 61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launch Regular Exception at: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

57:
58: -- initialize the pmf setup
59: msc_pmf_pkg.process_pmf_thresholds;
60:
61: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launch Regular Exception at: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
62: start_netting(p_early_order,
63: p_changed_order,
64: p_forecast_accuracy,
65: p_forecast_mismatch,

Line 552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'forecast mismatch refnum ' || l_forecast_mismatch_refnum);

548: where plan_id = G_PLAN_ID
549: and organization_id = G_GROUP5
550: and sr_instance_id = G_SR_INSTANCE_ID;
551: --dbms_output.put_line('Max refresh_number : ' || l_forecast_mismatch_refnum);
552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'forecast mismatch refnum ' || l_forecast_mismatch_refnum);
553:
554: msc_x_netting1_pkg.compute_forecast_mismatch(l_forecast_mismatch_refnum,
555: t_company_list,
556: t_company_site_list,

Line 1054: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launch workflow process' || ':' ||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

1050:
1051: commit;
1052:
1053: IF (nvl(FND_PROFILE.VALUE('MSC_LAUNCH_EXCEPTION_NOTIFICATION'),'Y') = 'Y') THEN
1054: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launch workflow process' || ':' ||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1055:
1056: -- launch the cp exception workflow program
1057: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
1058: 'MSC', -- application

Line 1067: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch Exception Workflow request failed');

1063:
1064: COMMIT;
1065:
1066: IF l_request_id=0 THEN
1067: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch Exception Workflow request failed');
1068: begin
1069: update msc_x_exception_details
1070: set version = null, last_update_login = null
1071: where plan_id = -1

Line 1079: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch Exception Workflow request :'|| to_char(l_request_id));

1075: when others then
1076: null;
1077: end;
1078: ELSE
1079: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch Exception Workflow request :'|| to_char(l_request_id));
1080: END IF;
1081:
1082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Workflow process completed at' || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1083: ELSE

Line 1082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Workflow process completed at' || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

1078: ELSE
1079: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch Exception Workflow request :'|| to_char(l_request_id));
1080: END IF;
1081:
1082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Workflow process completed at' || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1083: ELSE
1084: --Reset the records for which the no notifications need to sent
1085: begin
1086: update msc_x_exception_details

Line 1586: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside PROCEDURE delete_wf_notification : l_notification_id = '||l_notification_id);

1582: open get_notification_c (p_type, p_key);
1583: loop
1584: fetch get_notification_c into l_notification_id;
1585: exit when (l_notification_id is null or get_notification_c%NOTFOUND or get_notification_c%NOTFOUND is null) ;
1586: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside PROCEDURE delete_wf_notification : l_notification_id = '||l_notification_id);
1587: wf_notification.cancel(l_notification_id);
1588:
1589: end loop;
1590: close get_notification_c;

Line 1595: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in delete wf nid '||sqlerrm);

1591:
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: --dbms_output.put_line('Error in delete wf nid ' || sqlerrm);
1595: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in delete wf nid '||sqlerrm);
1596: return;
1597: END delete_wf_notification;
1598:
1599: --------------------------------------------------------------------------

Line 2398: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_days '||p_days);

2394: BEGIN
2395:
2396: p_days := nvl(FND_PROFILE.VALUE('MSC_PURGE_EXCEPTION_DAYS'),0);
2397:
2398: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_days '||p_days);
2399: If (p_days > 0) then
2400:
2401: open delete_excep_c(p_days);
2402: loop

Line 2532: FND_FILE.PUT_LINE(FND_FILE.LOG,'for 1 : l_item_key'||l_item_key);

2528: to_char(p_customer_site_id) || '-' ||
2529: to_char(p_supplier_id) || '-' ||
2530: to_char(p_supplier_site_id) || '%';
2531:
2532: FND_FILE.PUT_LINE(FND_FILE.LOG,'for 1 : l_item_key'||l_item_key);
2533: delete_wf_notification(l_item_type, l_item_key);
2534:
2535: -- added for VMI Exceptions: notification deletion behaviour
2536:

Line 2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'for 2 : l_item_key = '||l_item_key);

2547: to_char(p_customer_site_id) || '-' ||
2548: to_char(p_supplier_id) || '-' ||
2549: to_char(p_supplier_site_id) || '%';
2550:
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'for 2 : l_item_key = '||l_item_key);
2552: delete_wf_notification(l_item_type, l_item_key);
2553:
2554: END IF;
2555: END IF;

Line 2945: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Count ' || a_company_id.COUNT);

2941: a_date4.EXTEND;
2942: a_date5.EXTEND;
2943: a_exception_basis.EXTEND;
2944:
2945: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Count ' || a_company_id.COUNT);
2946:
2947: a_company_id(a_company_id.COUNT) := p_company_id;
2948: a_company_name(a_company_id.COUNT) := p_company_name;
2949: a_company_site_id(a_company_id.COUNT) := p_company_site_id;

Line 3273: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Add to plsql table list');

3269: l_counter Number := 0;
3270:
3271: BEGIN
3272:
3273: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Add to plsql table list');
3274: --dbms_output.put_line('Add to plsql delete table list');
3275:
3276: t_item_list.EXTEND;
3277: t_company_list.EXTEND;

Line 3290: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Count ' || t_item_list.COUNT);

3286: t_trxid2_list.EXTEND;
3287: t_date1_list.EXTEND;
3288: t_date2_list.EXTEND;
3289:
3290: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Count ' || t_item_list.COUNT);
3291: -- dbms_output.put_line('Count ' || t_item_list.COUNT);
3292:
3293: t_item_list(t_item_list.COUNT) := p_item_id;
3294: t_company_list(t_item_list.COUNT) := p_company_id;

Line 3344: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delete in batch:' || t_item_list.COUNT);

3340: t_count3 number_arr := number_arr();
3341:
3342: BEGIN
3343:
3344: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delete in batch:' || t_item_list.COUNT);
3345: --dbms_output.put_line('Delete batch ' || t_item_list.COUNT);
3346:
3347: IF (t_item_list is not null and t_item_list.COUNT > 0) THEN
3348:

Line 3376: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete trx ' || t_trxid1_list(i) || '-' || t_count1(i));

3372: t_count1(t_count1.COUNT) := SQL%BULK_ROWCOUNT(i);
3373: --dbms_output.put_line('delete trx ' || t_trxid1_list(i) || '-' || t_count1(i) || ' Comp ' || t_company_list(i) || t_company_site_list(i) );
3374: --dbms_output.put_line('item ' || t_item_list(i) || ' Cust ' || t_customer_list(i) || t_customer_site_list(i) );
3375: --dbms_output.put_line(' supp ' || t_supplier_list(i) || t_supplier_site_list(i) );
3376: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete trx ' || t_trxid1_list(i) || '-' || t_count1(i));
3377: END LOOP;
3378:
3379: FORALL i in 1..t_item_list.COUNT
3380: update msc_item_exceptions ex

Line 3417: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete date ' || t_date1_list(i) || '-' || t_count2(i));

3413:
3414: FOR i in 1..t_item_list.COUNT LOOP
3415: t_count2.EXTEND;
3416: t_count2(t_count2.COUNT) := SQL%BULK_ROWCOUNT(i);
3417: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete date ' || t_date1_list(i) || '-' || t_count2(i));
3418: END LOOP;
3419:
3420: FORALL i in 1..t_item_list.COUNT
3421: update msc_item_exceptions ex

Line 3456: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete date ' || t_type_list(i) || '-' || t_count3(i));

3452:
3453: FOR i in 1..t_item_list.COUNT LOOP
3454: t_count3.EXTEND;
3455: t_count3(t_count3.COUNT) := SQL%BULK_ROWCOUNT(i);
3456: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete date ' || t_type_list(i) || '-' || t_count3(i));
3457: END LOOP;
3458:
3459: FORALL i in 1..t_item_list.COUNT
3460: update msc_item_exceptions ex

Line 3492: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete trx ex: ' || t_trxid1_list(i) || '-' || t_count1(i) || '-' || t_type_list(i));

3488:
3489: FOR i in 1..t_item_list.COUNT LOOP
3490: t_count1.EXTEND;
3491: t_count1(t_count1.COUNT) := SQL%BULK_ROWCOUNT(i);
3492: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete trx ex: ' || t_trxid1_list(i) || '-' || t_count1(i) || '-' || t_type_list(i));
3493: --dbms_output.put_line('delete trx ex: ' || t_trxid1_list(i) || '-' || t_count1(i) || '-' || t_type_list(i));
3494: END LOOP;
3495:
3496: FORALL i in 1..t_item_list.COUNT