766: END IF;
767: END IF;
768:
769: IF (l_return_status IS NULL) THEN
770: l_return_status := FND_API.g_ret_sts_success;
771: END IF;
772:
773: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: po_message_s.sql_error('remove_req_from_po', x_progress, l_msg_data);
769: IF (l_return_status IS NULL) THEN
770: l_return_status := FND_API.g_ret_sts_success;
771: END IF;
772:
773: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: po_message_s.sql_error('remove_req_from_po', x_progress, l_msg_data);
775: END IF;
776:
777: END LOOP;
1154:
1155: END IF; -- IF ( x_req_line_id IS NOT NULL OR x_req_header_id IS NOT NULL )
1156:
1157: x_progress := '040';
1158: x_return_status := FND_API.G_RET_STS_SUCCESS;
1159:
1160: EXCEPTION
1161:
1162: WHEN OTHERS THEN
1159:
1160: EXCEPTION
1161:
1162: WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: PO_MESSAGE_S.sql_error('UPDATE_REQS_IN_POOL_FLAG',x_progress,sqlcode);
1165:
1166: END update_reqs_in_pool_flag;
1167:
1223: x_return_status => X_oe_return);
1224:
1225: X_progress := '040';
1226:
1227: If X_oe_return = fnd_api.g_ret_sts_success then
1228:
1229: /* If the table X_oe_line_tbl is empty, return TRUE */
1230: If (X_oe_line_tbl.FIRST is NULL) Then
1231: return(TRUE);
1244: x_return_status => X_wsh_return,
1245: x_msg_count => X_msg_count,
1246: x_msg_data => X_msg_data);
1247:
1248: If X_wsh_return = fnd_api.g_ret_sts_success then
1249: If X_out_rec_type.nonintf_line_qty > 0 then
1250: return FALSE;
1251:
1252: End If; /* If X_out_rec_type.nonintf_line_qty */