DBA Data[Home] [Help]

APPS.MSC_X_NETTING4_PKG dependencies on FND_FILE

Line 1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(33) ||

1069: l_inserted_record := l_inserted_record + 1;
1070: END LOOP;
1071: END IF;
1072:
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(33) ||
1074: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1075:
1076: ---------------------------------------------------------------------
1077: -- This is required purge all the zero qty entries for order execution entities

Line 1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(34) ||

1332:
1333: END LOOP;
1334: END IF;
1335:
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(34) ||
1337: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1338:
1339:
1340: ---------------------------------------------------------------------------

Line 1614: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(49) ||

1610: a_exception_basis);
1611: l_inserted_record := l_inserted_record + 1;
1612: END LOOP;
1613: END IF;
1614: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(49) ||
1615: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1616:
1617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
1618: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_CHANGED_ORDER) || ':' || l_inserted_record);

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

1613: END IF;
1614: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(49) ||
1615: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1616:
1617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
1618: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_CHANGED_ORDER) || ':' || l_inserted_record);
1619:
1620:
1621: -- added exception handler

Line 1989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(35) || ':' || sysdate);

1985: a_exception_basis);
1986: l_inserted_record := l_inserted_record + 1;
1987:
1988: END IF;
1989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(35) || ':' || sysdate);
1990: IF (l_total_forecast > 0) and (l_total_historical_sales > 0 ) and
1991: (1- l_total_historical_sales/l_total_forecast) > l_threshold2/100 THEN
1992: l_exception_type := msc_x_netting_pkg.G_EXCEP36;
1993: l_exception_group := msc_x_netting_pkg.G_FORECAST_ACCURACY;

Line 2090: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(36) ||

2086: END IF;
2087: END LOOP;
2088: END IF;
2089:
2090: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(36) ||
2091: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2092:
2093: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
2094: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_FORECAST_ACCURACY) || ':' || l_inserted_record);

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

2089:
2090: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(36) ||
2091: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2092:
2093: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
2094: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_FORECAST_ACCURACY) || ':' || l_inserted_record);
2095:
2096: -- added exception handler
2097: EXCEPTION

Line 2662: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(39) ||

2658: END IF;
2659: END LOOP;
2660: END IF;
2661:
2662: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(39) ||
2663: ',' || msc_x_netting_pkg.get_message_type(40) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2664:
2665:
2666: ----------------------------------------------------------------------

Line 3025: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(43) || ','

3021: END IF;
3022: END LOOP;
3023: END IF;
3024:
3025: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(43) || ','
3026: || msc_x_netting_pkg.get_message_type(44) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3027: --------------------------------------------------
3028: --dbms_output.put_line('Exception 45 and 46');
3029: open exception_45_46;

Line 3317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(45) ||

3313: l_inserted_record := l_inserted_record + 1;
3314: END IF;
3315: END LOOP;
3316: END IF;
3317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(45) ||
3318: ',' || msc_x_netting_pkg.get_message_type(46) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3319: --------------------------------------------------
3320: --dbms_output.put_line('Exception 47 and 48');
3321:

Line 3489: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(47) ||

3485: a_exception_basis);
3486: l_inserted_record := l_inserted_record + 1;
3487: END IF;
3488:
3489: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(47) ||
3490: ':' ||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3491:
3492: IF (l_stock_out > l_threshold2) then
3493: l_exception_type := msc_x_netting_pkg.G_EXCEP48; --stock out at your customer site

Line 3591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(47) ||

3587: END IF;
3588: END LOOP;
3589: END IF;
3590:
3591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(47) ||
3592: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3593:
3594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
3595: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_PERFORMANCE) || ':' || l_inserted_record);

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

3590:
3591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(47) ||
3592: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3593:
3594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
3595: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_PERFORMANCE) || ':' || l_inserted_record);
3596:
3597: -- added exception handler
3598: EXCEPTION

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

3609: PROCEDURE COMPUTE_CUSTOM_EXCEPTION IS
3610:
3611: BEGIN
3612:
3613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launch Customer Exception at: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3614: /* launch custom exceptions whar supposed to be run with netting engine */
3615:
3616: MSC_X_USER_EXCEP_GEN.RunCustomExcepWithNetting;
3617: