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

Line 1210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(11) ||

1206:
1207: END LOOP;
1208: END IF;
1209:
1210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(11) ||
1211: msc_x_netting_pkg.get_message_type(31) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1212:
1213:
1214: l_exception_detail_id1 := null;

Line 1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(12) ||

1530: END IF;
1531: END LOOP;
1532: END IF;
1533:
1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(12) ||
1535: msc_x_netting_pkg.get_message_type(32) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1536:
1537:
1538: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||

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

1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(12) ||
1535: msc_x_netting_pkg.get_message_type(32) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1536:
1537:
1538: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
1539: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_RESPONSE_REQUIRED) || ':' || l_inserted_record);
1540: --===========================================================================================
1541: --Archive all the exception notifications sent out in previous engine runs
1542: --and are not re-occurr in this run

Line 2170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(13) ||

2166: END IF;
2167: END LOOP;
2168: END IF;
2169:
2170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(13) ||
2171: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2172:
2173: --dbms_output.put_line('end of exception 13');
2174: --------------------------------------------------------------------

Line 2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan order at risk ' || l_plan_order_at_risk);

2183:
2184:
2185:
2186: l_plan_order_at_risk := FND_PROFILE.VALUE('MSC_PLAN_FOR_ORDER_AT_RISK');
2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan order at risk ' || l_plan_order_at_risk);
2188: --dbms_output.put_line('Plan order at risk ' || l_plan_order_at_risk);
2189: BEGIN
2190: select plan_id
2191: into l_plan_order_at_risk_id

Line 2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The plan for order at risk has not defined as a profile option ');

2192: from msc_plans
2193: where compile_designator = l_plan_order_at_risk;
2194: EXCEPTION
2195: when others then
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The plan for order at risk has not defined as a profile option ');
2197: END;
2198:
2199:
2200: OPEN exception_50_51 (p_refresh_number);

Line 2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TRX ID = ' || b_trx_id1(j));

2360:
2361: -- limit the loop (at this point don't know it is for exception50 or 51
2362: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) ) THEN
2363:
2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TRX ID = ' || b_trx_id1(j));
2365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END ORDER= ' || b_end_order_number(j));
2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));
2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));

Line 2365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END ORDER= ' || b_end_order_number(j));

2361: -- limit the loop (at this point don't know it is for exception50 or 51
2362: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) ) THEN
2363:
2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TRX ID = ' || b_trx_id1(j));
2365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END ORDER= ' || b_end_order_number(j));
2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));
2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));
2369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST SITE = ' || b_customer_site_id(j));

Line 2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));

2362: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) ) THEN
2363:
2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TRX ID = ' || b_trx_id1(j));
2365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END ORDER= ' || b_end_order_number(j));
2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));
2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));
2369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST SITE = ' || b_customer_site_id(j));
2370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ITEM = ' || b_item_id(j));

Line 2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));

2363:
2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TRX ID = ' || b_trx_id1(j));
2365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END ORDER= ' || b_end_order_number(j));
2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));
2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));
2369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST SITE = ' || b_customer_site_id(j));
2370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ITEM = ' || b_item_id(j));
2371: /*---------------------------------------------------------------------------------

Line 2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));

2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TRX ID = ' || b_trx_id1(j));
2365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END ORDER= ' || b_end_order_number(j));
2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));
2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));
2369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST SITE = ' || b_customer_site_id(j));
2370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ITEM = ' || b_item_id(j));
2371: /*---------------------------------------------------------------------------------
2372: -- Get the SO2 from CP (eg: cust: OEM, supp: CM - at this point not cust will pass in

Line 2369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST SITE = ' || b_customer_site_id(j));

2365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END ORDER= ' || b_end_order_number(j));
2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));
2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));
2369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST SITE = ' || b_customer_site_id(j));
2370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ITEM = ' || b_item_id(j));
2371: /*---------------------------------------------------------------------------------
2372: -- Get the SO2 from CP (eg: cust: OEM, supp: CM - at this point not cust will pass in
2373: -----------------------------------------------------------------------------------*/

Line 2370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ITEM = ' || b_item_id(j));

2366: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END REL = ' || b_end_order_rel_number(j));
2367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'END LINE = ' || b_end_order_line_number(j));
2368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST = ' || b_customer_id(j));
2369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUST SITE = ' || b_customer_site_id(j));
2370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ITEM = ' || b_item_id(j));
2371: /*---------------------------------------------------------------------------------
2372: -- Get the SO2 from CP (eg: cust: OEM, supp: CM - at this point not cust will pass in
2373: -----------------------------------------------------------------------------------*/
2374: OPEN level_2_so_cp (b_end_order_number(j),b_end_order_rel_number(j), b_end_order_line_number(j),

Line 2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));

2420: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2421: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2422: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2423: --dbms_output.put_line('SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate Sales order at risk');
2426: --Generate the exception: Sales Order at risk due to upstream lateness
2427: --======================================================
2428: -- Clean up the old exceptions

Line 2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate Sales order at risk');

2421: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2422: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2423: --dbms_output.put_line('SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate Sales order at risk');
2426: --Generate the exception: Sales Order at risk due to upstream lateness
2427: --======================================================
2428: -- Clean up the old exceptions
2429: --======================================================

Line 2579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLAN EXISTS ' || l_plan_order_at_risk);

2575: --dbms_output.put_line('Supplier = ' || b_supplier_id(j));
2576: --dbms_output.put_line('Supplier Site = ' || b_supplier_site_id(j));
2577:
2578:
2579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLAN EXISTS ' || l_plan_order_at_risk);
2580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order number = ' || b_order_number(j));
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));
2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));

Line 2580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order number = ' || b_order_number(j));

2576: --dbms_output.put_line('Supplier Site = ' || b_supplier_site_id(j));
2577:
2578:
2579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLAN EXISTS ' || l_plan_order_at_risk);
2580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order number = ' || b_order_number(j));
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));
2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));

Line 2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));

2577:
2578:
2579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLAN EXISTS ' || l_plan_order_at_risk);
2580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order number = ' || b_order_number(j));
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));
2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));
2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));

Line 2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));

2578:
2579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLAN EXISTS ' || l_plan_order_at_risk);
2580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order number = ' || b_order_number(j));
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));
2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));
2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));
2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier = ' || b_supplier_id(j));

Line 2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));

2579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLAN EXISTS ' || l_plan_order_at_risk);
2580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order number = ' || b_order_number(j));
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));
2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));
2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));
2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier = ' || b_supplier_id(j));
2587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier Site = ' || b_supplier_site_id(j));

Line 2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));

2580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order number = ' || b_order_number(j));
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));
2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));
2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));
2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier = ' || b_supplier_id(j));
2587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier Site = ' || b_supplier_site_id(j));
2588:

Line 2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));

2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Release number = ' || b_release_number(j));
2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));
2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));
2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier = ' || b_supplier_id(j));
2587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier Site = ' || b_supplier_site_id(j));
2588:
2589: OPEN map_po_in_ascp (l_plan_order_at_risk_id,

Line 2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier = ' || b_supplier_id(j));

2582: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line number = ' || b_line_number(j));
2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));
2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));
2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier = ' || b_supplier_id(j));
2587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier Site = ' || b_supplier_site_id(j));
2588:
2589: OPEN map_po_in_ascp (l_plan_order_at_risk_id,
2590: b_order_number(j),

Line 2587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier Site = ' || b_supplier_site_id(j));

2583: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item = ' || b_item_id(j));
2584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer = ' || b_customer_id(j));
2585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer Site = ' || b_customer_site_id(j));
2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier = ' || b_supplier_id(j));
2587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier Site = ' || b_supplier_site_id(j));
2588:
2589: OPEN map_po_in_ascp (l_plan_order_at_risk_id,
2590: b_order_number(j),
2591: b_release_number(j),

Line 2605: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Num of POs found = ' ||

2601:
2602:
2603: --dbms_output.put_line('Num of POs found = ' || n_ascp_first_po_trx_id.COUNT);
2604:
2605: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Num of POs found = ' ||
2606: n_ascp_first_po_trx_id.COUNT);
2607:
2608: IF ((n_ascp_first_po_trx_id is not null)
2609: AND (n_ascp_first_po_trx_id.COUNT > 0)) THEN --sbala

Line 2621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IN PEG LOOP');

2617: --dbms_output.put_line('IN PEG LOOP');
2618: --dbms_output.put_line(' PO TRX ID = ' || n_ascp_first_po_trx_id(n));
2619:
2620:
2621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IN PEG LOOP');
2622: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PO TRX ID = ' || n_ascp_first_po_trx_id(n));
2623:
2624: OPEN get_all_pegging (n_ascp_first_po_trx_id(n),
2625: l_plan_order_at_risk_id);

Line 2622: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PO TRX ID = ' || n_ascp_first_po_trx_id(n));

2618: --dbms_output.put_line(' PO TRX ID = ' || n_ascp_first_po_trx_id(n));
2619:
2620:
2621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IN PEG LOOP');
2622: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PO TRX ID = ' || n_ascp_first_po_trx_id(n));
2623:
2624: OPEN get_all_pegging (n_ascp_first_po_trx_id(n),
2625: l_plan_order_at_risk_id);
2626:

Line 2642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Peg trx_id ' || l_peg_trx_id || ' Peg type ' || l_peg_supply_type);

2638:
2639:
2640: EXIT when get_all_pegging%NOTFOUND;
2641: --dbms_output.put_line('Peg trx_id ' || l_peg_trx_id || ' Peg type ' || l_peg_supply_type);
2642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Peg trx_id ' || l_peg_trx_id || ' Peg type ' || l_peg_supply_type);
2643: /*---------------------------------------------------------------
2644: Get the PO at risk
2645: -----------------------------------------------------------------*/
2646:

Line 2770: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NO PO FOUND IN CP');

2766: EXCEPTION
2767:
2768: when no_data_found then
2769: --dbms_output.put_line('NO PO FOUND IN CP');
2770: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NO PO FOUND IN CP');
2771: l_po_trx_id := null;
2772:
2773: when too_many_rows then
2774:

Line 2775: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOO MANY POs');

2771: l_po_trx_id := null;
2772:
2773: when too_many_rows then
2774:
2775: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOO MANY POs');
2776:
2777: when others then
2778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error to find PO in cp ' || sqlerrm);
2779: l_ascp_po_order_number := null;

Line 2778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error to find PO in cp ' || sqlerrm);

2774:
2775: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOO MANY POs');
2776:
2777: when others then
2778: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error to find PO in cp ' || sqlerrm);
2779: l_ascp_po_order_number := null;
2780: l_ascp_po_line := null;
2781: l_cp_company_id := null;
2782: l_cp_company_site_id := null;

Line 2837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 51');

2833:
2834:
2835: --dbms_output.put_line('Generate excep 51');
2836:
2837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 51');
2838: msc_x_netting_pkg.add_to_exception_tbl(l_customer_id,
2839: l_customer_name,
2840: l_customer_site_id,
2841: l_customer_site_name,

Line 2935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Demand id = ' || l_demand_id);

2931:
2932: /* sbala: Need code to check for existence of records */
2933:
2934: --dbms_output.put_line('Demand id = ' || l_demand_id);
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Demand id = ' || l_demand_id);
2936:
2937: /* sbala LOOP */
2938: /*--------------------------------------------------------------
2939: Look for the SO existing in CP

Line 3069: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NO SO FOUND IN CP');

3065:
3066: when no_data_found then
3067:
3068: --dbms_output.put_line('NO SO FOUND IN CP');
3069: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NO SO FOUND IN CP');
3070: l_so_trx_id := null;
3071:
3072: when too_many_rows then
3073: null;

Line 3097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 50');

3093: --Generate the exceptions for this SO
3094: --the sales order at risk due to upstream lateness
3095:
3096: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) + l_threshold50) THEN
3097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 50');
3098: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
3099: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3100: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3101: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

Line 3241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(50 ) || '-' ||

3237: END LOOP;
3238: END IF;
3239:
3240:
3241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(50 ) || '-' ||
3242: msc_x_netting_pkg.get_message_type(51) ||
3243: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3244: --------------------------------------------------------------
3245: --Need to clean up the existing exceptions before regenerate

Line 3612: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(14) || '-' ||

3608: END LOOP;
3609: END IF;
3610:
3611:
3612: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(14) || '-' ||
3613: msc_x_netting_pkg.get_message_type(15) ||
3614: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3615:
3616:

Line 3832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(16) ||

3828: END IF;
3829: end loop;
3830: END IF;
3831:
3832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(16) ||
3833: '.' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3834:
3835:
3836:

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

3833: '.' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3834:
3835:
3836:
3837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
3838: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER) || ':' || l_inserted_record);
3839:
3840: EXCEPTION
3841: when others then