[Home] [Help]
2595: IF (l_header_rec.order_header_id IS NOT NULL) THEN
2596: BEGIN
2597: SELECT order_number
2598: INTO l_order_number
2599: FROM OE_ORDER_HEADERS_ALL
2600: WHERE header_id = l_header_Rec.order_header_id;
2601:
2602: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2603: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2609: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2611: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2612: 'No Data Found for l_header_rec.order_header_id = '
2613: || l_header_rec.order_header_id || ' in OE_ORDER_HEADERS_ALL');
2614: end if;
2615: null;
2616: END;
2617: END IF;
3274: FROM csp_requirement_headers h,
3275: csp_requirement_lines l,
3276: csp_req_line_details dio,
3277: oe_order_lines_all oola,
3278: oe_order_headers_all ooha
3279: WHERE h.task_id = l_task_id
3280: AND h.task_assignment_id = l_Task_Assignment_id
3281: AND h.address_type IN ('R', 'S')
3282: AND h.requirement_header_id = l.requirement_header_id
3540: FROM csp_requirement_headers h,
3541: csp_requirement_lines l,
3542: csp_req_line_details d,
3543: oe_order_lines_all oola,
3544: oe_order_headers_all ooha
3545: WHERE h.task_assignment_id = l_Task_Assignment_id
3546: AND h.task_id = l_task_id
3547: AND h.requirement_header_id = l.requirement_header_id
3548: AND l.requirement_line_id = d.requirement_line_id
4026: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4027: rollback to csp_book_order;
4028:
4029: select order_number into l_oe_order_num
4030: from oe_order_headers_all where header_id = l_oe_header_id;
4031:
4032: FND_MESSAGE.SET_NAME('CSP', 'CSP_IO_BOOK_ERROR');
4033: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_oe_order_num, TRUE);
4034: FND_MSG_PUB.ADD;