530: FROM mtl_system_items_b
531: WHERE inventory_item_id = p_component_id
532: AND organization_id = l_tp_organization_id ;
533:
534: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
535: fnd_message.set_token('SUB_ORDER', l_order_number );
536: fnd_message.set_token('SUB_COMP', l_sub_comp);
537: l_message := fnd_message.GET();
538: fnd_file.put_line(fnd_file.LOG, l_message);
531: WHERE inventory_item_id = p_component_id
532: AND organization_id = l_tp_organization_id ;
533:
534: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
535: fnd_message.set_token('SUB_ORDER', l_order_number );
536: fnd_message.set_token('SUB_COMP', l_sub_comp);
537: l_message := fnd_message.GET();
538: fnd_file.put_line(fnd_file.LOG, l_message);
539: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
532: AND organization_id = l_tp_organization_id ;
533:
534: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
535: fnd_message.set_token('SUB_ORDER', l_order_number );
536: fnd_message.set_token('SUB_COMP', l_sub_comp);
537: l_message := fnd_message.GET();
538: fnd_file.put_line(fnd_file.LOG, l_message);
539: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
540: EXCEPTION
533:
534: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
535: fnd_message.set_token('SUB_ORDER', l_order_number );
536: fnd_message.set_token('SUB_COMP', l_sub_comp);
537: l_message := fnd_message.GET();
538: fnd_file.put_line(fnd_file.LOG, l_message);
539: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
540: EXCEPTION
541: WHEN OTHERS THEN
1030: (SELECT 1 FROM jmf_subcontract_orders jso
1031: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1032: AND jso.tp_organization_id = mip.organization_id);
1033:
1034: fnd_message.set_name('JMF','JMF_SHK_NO_SHIP_METHOD');
1035: fnd_message.set_token('OEM', l_oem_organization);
1036: fnd_message.set_token('MP', l_tp_organization);
1037: l_message := fnd_message.GET();
1038: fnd_file.put_line(fnd_file.LOG, l_message);
1031: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1032: AND jso.tp_organization_id = mip.organization_id);
1033:
1034: fnd_message.set_name('JMF','JMF_SHK_NO_SHIP_METHOD');
1035: fnd_message.set_token('OEM', l_oem_organization);
1036: fnd_message.set_token('MP', l_tp_organization);
1037: l_message := fnd_message.GET();
1038: fnd_file.put_line(fnd_file.LOG, l_message);
1039: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
1032: AND jso.tp_organization_id = mip.organization_id);
1033:
1034: fnd_message.set_name('JMF','JMF_SHK_NO_SHIP_METHOD');
1035: fnd_message.set_token('OEM', l_oem_organization);
1036: fnd_message.set_token('MP', l_tp_organization);
1037: l_message := fnd_message.GET();
1038: fnd_file.put_line(fnd_file.LOG, l_message);
1039: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
1040: EXCEPTION
1033:
1034: fnd_message.set_name('JMF','JMF_SHK_NO_SHIP_METHOD');
1035: fnd_message.set_token('OEM', l_oem_organization);
1036: fnd_message.set_token('MP', l_tp_organization);
1037: l_message := fnd_message.GET();
1038: fnd_file.put_line(fnd_file.LOG, l_message);
1039: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
1040: EXCEPTION
1041: WHEN OTHERS THEN
2380: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
2381: AND jso.tp_organization_id = msi.organization_id );
2382:
2383:
2384: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
2385: fnd_message.set_token('SUB_ORDER', l_order_number );
2386: fnd_message.set_token('SUB_COMP', l_sub_comp);
2387: l_message := fnd_message.GET();
2388: fnd_file.put_line(fnd_file.LOG, l_message);
2381: AND jso.tp_organization_id = msi.organization_id );
2382:
2383:
2384: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
2385: fnd_message.set_token('SUB_ORDER', l_order_number );
2386: fnd_message.set_token('SUB_COMP', l_sub_comp);
2387: l_message := fnd_message.GET();
2388: fnd_file.put_line(fnd_file.LOG, l_message);
2389: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
2382:
2383:
2384: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
2385: fnd_message.set_token('SUB_ORDER', l_order_number );
2386: fnd_message.set_token('SUB_COMP', l_sub_comp);
2387: l_message := fnd_message.GET();
2388: fnd_file.put_line(fnd_file.LOG, l_message);
2389: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
2390: EXCEPTION
2383:
2384: fnd_message.set_name('JMF','JMF_SHK_ALLOCATION_ERROR');
2385: fnd_message.set_token('SUB_ORDER', l_order_number );
2386: fnd_message.set_token('SUB_COMP', l_sub_comp);
2387: l_message := fnd_message.GET();
2388: fnd_file.put_line(fnd_file.LOG, l_message);
2389: l_status_flag := FND_CONCURRENT.set_completion_status('WARNING',NULL);
2390: EXCEPTION
2391: WHEN OTHERS THEN