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_REPLENISH dependencies on MSC_PO_REQUISITIONS_INTERFACE

Line 2314: -- insert a row into msc_po_requisitions_interface with status = 'approved'

2310: end;
2311:
2312: print_debug_info(' employee id = ' || l_employee_id);
2313:
2314: -- insert a row into msc_po_requisitions_interface with status = 'approved'
2315: INSERT INTO msc_po_requisitions_interface
2316: (
2317: -- line_type_id -- Amount or Quantity based (Bug #4589288)
2318: last_updated_by

Line 2315: INSERT INTO msc_po_requisitions_interface

2311:
2312: print_debug_info(' employee id = ' || l_employee_id);
2313:
2314: -- insert a row into msc_po_requisitions_interface with status = 'approved'
2315: INSERT INTO msc_po_requisitions_interface
2316: (
2317: -- line_type_id -- Amount or Quantity based (Bug #4589288)
2318: last_updated_by
2319: , last_update_date

Line 2429: print_debug_info(' ' || l_loaded_reqs || ' rows inserted into msc_po_requisitions_interface');

2425: ;
2426:
2427: IF SQL%ROWCOUNT > 0 THEN
2428: l_loaded_reqs := SQL%ROWCOUNT;
2429: print_debug_info(' ' || l_loaded_reqs || ' rows inserted into msc_po_requisitions_interface');
2430: ELSE
2431: l_loaded_reqs := 0;
2432: print_debug_info(' no rows inserted into msc_po_requisitions_interface');
2433: END IF;

Line 2432: print_debug_info(' no rows inserted into msc_po_requisitions_interface');

2428: l_loaded_reqs := SQL%ROWCOUNT;
2429: print_debug_info(' ' || l_loaded_reqs || ' rows inserted into msc_po_requisitions_interface');
2430: ELSE
2431: l_loaded_reqs := 0;
2432: print_debug_info(' no rows inserted into msc_po_requisitions_interface');
2433: END IF;
2434:
2435: if (l_loaded_reqs > 0) then
2436:

Line 2516: DELETE MSC_PO_REQUISITIONS_INTERFACE

2512: );
2513: END;
2514:
2515: BEGIN
2516: DELETE MSC_PO_REQUISITIONS_INTERFACE
2517: WHERE sr_instance_id= l_sr_instance_id;
2518:
2519: print_debug_info(' deleted related data in MSC_PO_REQUISITIONS_INTERFACE');
2520: EXCEPTION

Line 2519: print_debug_info(' deleted related data in MSC_PO_REQUISITIONS_INTERFACE');

2515: BEGIN
2516: DELETE MSC_PO_REQUISITIONS_INTERFACE
2517: WHERE sr_instance_id= l_sr_instance_id;
2518:
2519: print_debug_info(' deleted related data in MSC_PO_REQUISITIONS_INTERFACE');
2520: EXCEPTION
2521: WHEN OTHERS THEN
2522: print_debug_info(' Error when deleting data in MSC_PO_REQUISITIONS_INTERFACE' || sqlerrm);
2523: END;

Line 2522: print_debug_info(' Error when deleting data in MSC_PO_REQUISITIONS_INTERFACE' || sqlerrm);

2518:
2519: print_debug_info(' deleted related data in MSC_PO_REQUISITIONS_INTERFACE');
2520: EXCEPTION
2521: WHEN OTHERS THEN
2522: print_debug_info(' Error when deleting data in MSC_PO_REQUISITIONS_INTERFACE' || sqlerrm);
2523: END;
2524:
2525: end if; /* (l_loaded_reqs > 0) */
2526:

Line 3306: -- insert a row into msc_po_requisitions_interface with status = 'approved'

3302:
3303:
3304: print_debug_info('l_aps_customer_site_id : ' ||l_aps_customer_site_id );
3305: print_debug_info('p_item_id : ' ||p_item_id );
3306: -- insert a row into msc_po_requisitions_interface with status = 'approved'
3307: INSERT INTO msc_po_requisitions_interface(
3308: -- line_type_id -- Amount or Quantity based
3309: last_updated_by
3310: , last_update_date

Line 3307: INSERT INTO msc_po_requisitions_interface(

3303:
3304: print_debug_info('l_aps_customer_site_id : ' ||l_aps_customer_site_id );
3305: print_debug_info('p_item_id : ' ||p_item_id );
3306: -- insert a row into msc_po_requisitions_interface with status = 'approved'
3307: INSERT INTO msc_po_requisitions_interface(
3308: -- line_type_id -- Amount or Quantity based
3309: last_updated_by
3310: , last_update_date
3311: , last_update_login

Line 3465: print_debug_info(' inserted into msc_po_requisitions_interface, number of inserted rows = '

3461: AND rownum = 1;
3462:
3463: IF SQL%ROWCOUNT > 0 THEN
3464: l_loaded_reqs := SQL%ROWCOUNT;
3465: print_debug_info(' inserted into msc_po_requisitions_interface, number of inserted rows = '
3466: || l_loaded_reqs);
3467: ELSE
3468: l_loaded_reqs := 0;
3469: print_debug_info(' no record inserted into msc_po_requisitions_interface');

Line 3469: print_debug_info(' no record inserted into msc_po_requisitions_interface');

3465: print_debug_info(' inserted into msc_po_requisitions_interface, number of inserted rows = '
3466: || l_loaded_reqs);
3467: ELSE
3468: l_loaded_reqs := 0;
3469: print_debug_info(' no record inserted into msc_po_requisitions_interface');
3470: END IF;
3471:
3472: if (l_loaded_reqs > 0) then
3473:

Line 3533: print_debug_info(' delete records in MSC_PO_REQUISITIONS_INTERFACE' || l_fnd_request_id);

3529: print_debug_info(' Error in manual creation of requisition = ' || sqlerrm);
3530: END;
3531:
3532: BEGIN
3533: print_debug_info(' delete records in MSC_PO_REQUISITIONS_INTERFACE' || l_fnd_request_id);
3534: DELETE MSC_PO_REQUISITIONS_INTERFACE --ut
3535: WHERE sr_instance_id= l_sr_instance_id; --ut
3536: EXCEPTION
3537: WHEN OTHERS THEN

Line 3534: DELETE MSC_PO_REQUISITIONS_INTERFACE --ut

3530: END;
3531:
3532: BEGIN
3533: print_debug_info(' delete records in MSC_PO_REQUISITIONS_INTERFACE' || l_fnd_request_id);
3534: DELETE MSC_PO_REQUISITIONS_INTERFACE --ut
3535: WHERE sr_instance_id= l_sr_instance_id; --ut
3536: EXCEPTION
3537: WHEN OTHERS THEN
3538: print_debug_info(' Error when deleting records in MSC_PO_REQUISITIONS_INTERFACE');

Line 3538: print_debug_info(' Error when deleting records in MSC_PO_REQUISITIONS_INTERFACE');

3534: DELETE MSC_PO_REQUISITIONS_INTERFACE --ut
3535: WHERE sr_instance_id= l_sr_instance_id; --ut
3536: EXCEPTION
3537: WHEN OTHERS THEN
3538: print_debug_info(' Error when deleting records in MSC_PO_REQUISITIONS_INTERFACE');
3539: END;
3540: END IF;
3541:
3542: END IF; -- is_vmi_item_moe