[Home] [Help]
3028: INTO l_resource_type_name
3029: FROM JTF_OBJECTS_VL
3030: WHERE OBJECT_CODE = l_resource_type_code;
3031:
3032: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3033:
3034: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3035: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_resource_type_name, TRUE);
3036: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name, TRUE);
3219: AND h.requirement_header_id = l.requirement_header_id
3220: AND l.requirement_line_id = d.requirement_line_id
3221: and d.source_type = 'IO'
3222: AND d.source_id = oola.line_id
3223: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'PARTIALLY RECEIVED';
3224:
3225: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3226: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3227: 'l_partial_line = ' || l_partial_line);
3255: AND h.requirement_header_id = l.requirement_header_id
3256: AND l.requirement_line_id = dio.requirement_line_id
3257: AND dio.source_type = 'IO'
3258: and dio.source_id = oola.line_id
3259: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
3260: AND dio.requirement_line_id = dres.requirement_line_id
3261: AND oola.inventory_item_id = mr.inventory_item_id
3262: AND oola.ordered_quantity = mr.reservation_quantity
3263: AND dres.source_type = 'RES'
3312: AND h.requirement_header_id = l.requirement_header_id
3313: AND l.requirement_line_id = dio.requirement_line_id
3314: AND dio.source_type = 'IO'
3315: AND dio.source_id = oola.line_id
3316: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
3317: AND dio.requirement_line_id = dres.requirement_line_id
3318: AND oola.inventory_item_id = mr.inventory_item_id
3319: AND oola.ordered_quantity = mr.reservation_quantity
3320: AND dres.source_type = 'RES'
3344: AND h.requirement_header_id = l.requirement_header_id
3345: AND l.requirement_line_id = dio.requirement_line_id
3346: AND dio.source_type = 'IO'
3347: AND dio.source_id = oola.line_id
3348: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
3349: AND dio.requirement_line_id = dres.requirement_line_id
3350: AND oola.inventory_item_id = mr.inventory_item_id
3351: AND oola.ordered_quantity = mr.reservation_quantity
3352: AND dres.source_type = 'RES'
3398: AND h.requirement_header_id = l.requirement_header_id
3399: AND l.requirement_line_id = dio.requirement_line_id
3400: AND dio.source_type = 'IO'
3401: AND dio.source_id = oola.line_id
3402: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
3403: AND dio.requirement_line_id = dres.requirement_line_id
3404: AND oola.inventory_item_id = mr.inventory_item_id
3405: AND oola.ordered_quantity = mr.reservation_quantity
3406: AND dres.source_type = 'RES'
3451: AND h.requirement_header_id = l.requirement_header_id
3452: AND l.requirement_line_id = dio.requirement_line_id
3453: AND dio.source_type = 'IO'
3454: AND dio.source_id = oola.line_id
3455: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'FULLY RECEIVED'
3456: AND dio.requirement_line_id = dres.requirement_line_id
3457: AND oola.inventory_item_id = mr.inventory_item_id
3458: AND oola.ordered_quantity = mr.reservation_quantity
3459: AND dres.source_type = 'RES'
3512: AND h.requirement_header_id = l.requirement_header_id
3513: AND l.requirement_line_id = d.requirement_line_id
3514: AND d.source_type = 'IO'
3515: AND d.source_id = oola.line_id
3516: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
3517:
3518: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3520: 'l_shpd_lines = ' || l_shpd_lines);
3547: AND h.requirement_header_id = l.requirement_header_id
3548: AND l.requirement_line_id = d.requirement_line_id
3549: AND d.source_type = 'IO'
3550: AND d.source_id = oola.line_id
3551: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) IN ('SHIPPED', 'EXPECTED')
3552: AND oola.header_id = ooha.header_id
3553: AND rownum = 1;
3554:
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3576: AND l.requirement_line_id = d.requirement_line_id
3577: AND h.address_type IN ('T', 'C', 'P')
3578: AND d.source_type = 'IO'
3579: AND d.source_id = oola.line_id
3580: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3581: AND dother.requirement_line_id = l.requirement_line_id
3582: AND dother.source_id <> d.source_id;
3583:
3584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3620: AND h.requirement_header_id = l.requirement_header_id
3621: AND l.requirement_line_id = d.requirement_line_id
3622: AND d.source_type = 'IO'
3623: AND d.source_id = oola.line_id
3624: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3625: );
3626:
3627: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3628: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3664: AND h.requirement_header_id = l.requirement_header_id
3665: AND l.requirement_line_id = d.requirement_line_id
3666: AND d.source_type = 'IO'
3667: AND d.source_id = oola.line_id
3668: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3669: );
3670:
3671: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3672: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3813: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3814: end if;
3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3816: FND_MSG_PUB.initialize;
3817: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');
3819: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3820: FND_MSG_PUB.ADD;
3821: fnd_msg_pub.count_and_get